TypeRoor reading json

[buran]

Your json is array of 6864 jsonobjects, that is deserialised to list of dicts, like this (one elment):

Output:
{
	"COD": "PC97987",
	"Nombre": "Todas las edades. Total. Total. Málaga. Dato base. ",
	"T3_Unidad": "Personas",
	"T3_Escala": " ",
	"MetaData": [{
		"Id": 15668,
		"Variable": {
			"Id": 356,
			"Nombre": "Totales de edad",
			"Codigo": ""
		},
		"Nombre": "Todas las edades",
		"Codigo": ""
	}, {
		"Id": 16420,
		"Variable": {
			"Id": 141,
			"Nombre": "Nacionalidad",
			"Codigo": ""
		},
		"Nombre": "Total",
		"Codigo": ""
	}, {
		"Id": 451,
		"Variable": {
			"Id": 18,
			"Nombre": "Sexo",
			"Codigo": ""
		},
		"Nombre": "Total",
		"Codigo": ""
	}, {
		"Id": 30,
		"Variable": {
			"Id": 115,
			"Nombre": "Provincias",
			"Codigo": "PROV"
		},
		"Nombre": "Málaga",
		"Codigo": "29"
	}, {
		"Id": 72,
		"Variable": {
			"Id": 3,
			"Nombre": "Tipo de dato",
			"Codigo": ""
		},
		"Nombre": "Dato base",
		"Codigo": ""
	}],
	"Data": [{
		"Fecha": "2022-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2022,
		"Valor": 1717504.0
	}, {
		"Fecha": "2021-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2021,
		"Valor": 1695651.0
	}, {
		"Fecha": "2020-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2020,
		"Valor": 1685920.0
	}, {
		"Fecha": "2019-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2019,
		"Valor": 1661785.0
	}, {
		"Fecha": "2018-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2018,
		"Valor": 1641121.0
	}, {
		"Fecha": "2017-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2017,
		"Valor": 1630615.0
	}, {
		"Fecha": "2016-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2016,
		"Valor": 1629298.0
	}, {
		"Fecha": "2015-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2015,
		"Valor": 1628973.0
	}, {
		"Fecha": "2014-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2014,
		"Valor": 1621968.0
	}, {
		"Fecha": "2013-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2013,
		"Valor": 1652999.0
	}, {
		"Fecha": "2012-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2012,
		"Valor": 1641098.0
	}, {
		"Fecha": "2011-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2011,
		"Valor": 1625827.0
	}, {
		"Fecha": "2010-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2010,
		"Valor": 1609557.0
	}, {
		"Fecha": "2009-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2009,
		"Valor": 1593068.0
	}, {
		"Fecha": "2008-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2008,
		"Valor": 1563261.0
	}, {
		"Fecha": "2007-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2007,
		"Valor": 1517523.0
	}, {
		"Fecha": "2006-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2006,
		"Valor": 1491287.0
	}, {
		"Fecha": "2005-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2005,
		"Valor": 1453409.0
	}, {
		"Fecha": "2004-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2004,
		"Valor": 1397925.0
	}, {
		"Fecha": "2003-01-01T00:00:00.000+01:00",
		"T3_TipoDato": "Definitivo",
		"T3_Periodo": "1 de enero de",
		"Anyo": 2003,
		"Valor": 1374890.0
	}]
}

I don't see which part of this goes into which column