{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["1","2","3","4","5","6","7","8","9","10","11","12","13","14"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":38,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1","index":0,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 1. PREVISIONES DE ESTABILIDAD PRESUPUESTARIA EN 2023 DE LAS 24 GRANDES CORPORACIONES LOCALES (ACTUALES Y DE INFORME DE PRESUPUESTO) Y ESTIMACIONES AIREF"]
["(*) La capacidad/necesidad de financiación de 2022 y/o 2023 comunicada por la entidad local ha sido corregida de los ajustes de Contabilidad Nacional derivados de la liquidación de 2020 del Sistema de Financiación y/o de los del PRTR para hacerlos neutrales."]
["Corporaciones Locales","CNF / Ingresos Cierre 2022","CNF / ingresos Corporaciones Locales Presupuesto 2023","CNF / ingresos Corporaciones Locales Cierre 2023","CNF / ingresos AIReF Cierre 2023"]
["Ayuntamiento Madrid",-4.490055535181034E-2,9.9470654450787305E-3,2.0816345937583736E-2,1.2936838537826413E-2]
["Ayuntamiento Barcelona*",-5.9873978563335213E-2,7.9467889469535874E-6,-3.3834941908251003E-2,-2.632978447659548E-2]
["Ayuntamiento Valencia",2.7840550238175842E-2,3.4538414620014876E-2,4.0066842653272573E-2,9.9447136891491345E-2]
["Ayuntamiento Sevilla",3.9216894711044288E-2,0.15654031663846202,0.12231265001715851,0.13058474097906167]
["Ayuntamiento Zaragoza",4.933277082222496E-2,4.7768309968034481E-2,8.500268596967421E-2,9.4500615541912483E-2]
["Ayuntamiento Málaga",1.2939347683472411E-2,0.20332710080258751,9.9931839196569117E-2,0.11006013043983306]
["Ayuntamiento Murcia*",-4.2595053782050904E-2,0.10252016522858343,-1.7620646505733233E-2,3.1398567013102598E-2]
["Ayuntamiento Palma",3.5964105817672898E-2,-2.0923034921751333E-3,1.9213435377781467E-2,9.6689670153884855E-2]
["Ayuntamiento Las Palmas Gran Canaria",-2.9230779607815196E-2,-2.2730397792263015E-2,-5.7896080340081528E-2,2.616072269474138E-2]
["Ayuntamiento Bilbao",5.8609005697849957E-2,-7.7173427266541653E-2,-8.6900044932933324E-2,-1.3722387522570934E-2]
["Ayuntamiento Alicante*",3.8652467558801647E-2,2.7587466787058808E-2,2.7587466787058808E-2,8.574393668684932E-2]
["Ayuntamiento Córdoba*",1.8359740980280915E-2,0.10242978995899252,5.0013966542412453E-3,5.6136719037901281E-2]
["Ayuntamiento Valladolid",-0.10410892776989741,2.8045857980873701E-3,-0.10327599601477262,-7.6833930571362882E-2]
["Ayuntamiento Vigo",1.5187705223421673E-2,0,-7.3141053724571289E-2,6.5806963857724691E-3]
["Ayuntamiento Gijón/Xixón*",-4.8060980392856556E-2,0.17179806062352385,5.7665493742825868E-2,4.4169140140730818E-2]
["Ayuntamiento L'Hospitalet*",1.9917360417691949E-2,8.0905811871693128E-2,6.0007879684098611E-2,8.9309063677931455E-2]
["Diputación Barcelona",7.8971100576211026E-2,5.4928704044364618E-2,2.7868698599205335E-2,4.8913910212120416E-2]
["Diputación Valencia*",-1.1593639525998404E-2,6.2129765997280116E-2,5.4433774446661788E-2,5.2866343125875813E-2]
["Diputación Sevilla",-9.1924472907498084E-2,-1.4876520567759368E-2,0.13089596636004444,8.2606376350437674E-2]
["Cabildo Insular Tenerife*",-1.357952839863231E-2,6.9723172174761303E-2,2.7278845345327405E-2,3.3003180172504899E-2]
["Consell Insular Mallorca*",1.9482060753121401E-2,7.2498846944510059E-2,8.6756689005739102E-2,8.6756689005739102E-2]
["Diputación Foral de Araba",-6.7022354823148928E-3,-6.1236089593565218E-2,-6.1236089593565218E-2,2.4309964719624747E-3]
["Diputación Foral de Gipuzkoa",6.4717624064296611E-2,-6.8627090040144171E-3,-5.3918898561832518E-2,-4.6994619009888905E-3]
["Diputación Foral de Bizkaia",1.0582516241608426E-2,-3.8832763604982341E-2,-5.1716840813064997E-2,-9.1377503134859196E-3]
["Media del grupo",-5.4817648698138564E-3,2.1548172257146416E-2,4.8677965749176965E-3,2.6251392427681826E-2]

{"sheet":"2","index":1,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 2. PREVISIONES ESTABILIDAD PRESUPUESTARIA 2023 DE LAS 24 GRANDES CORPORACIONES LOCALES SIN EFECTO LIQUIDACIÓN 2020 SISTEMA FINANCIACIÓN ESTADO"]
["Corporaciones Locales","CNF / INF 2023 Corporaciones Locales sin liquidación Sistema de Financiación","CNF / INF 2023 AIReF sin liquidación Sistema de Financiación"]
["Ayuntamiento Madrid",-5.2281639250361944E-3,-1.322154454099294E-2]
["Ayuntamiento Barcelona",-6.5470041626634418E-2,-5.8084839143798493E-2]
["Ayuntamiento Valencia",9.3338263974912412E-3,6.854038094480791E-2]
["Ayuntamiento Sevilla",9.1550231013166519E-2,9.9492767292500339E-2]
["Ayuntamiento Zaragoza",5.6584251829425586E-2,6.6303691324739886E-2]
["Ayuntamiento Málaga",6.7344101078121485E-2,7.9191693697869797E-2]
["Ayuntamiento Murcia",-3.7979389694812585E-2,1.1293758342683279E-2]
["Ayuntamiento Palma",3.1423832631447745E-3,8.0802118013763857E-2]
["Ayuntamiento Las Palmas GC",-7.949573673514479E-2,3.2675380375679665E-3]
["Ayuntamiento Bilbao",-8.6900044932933337E-2,-1.3722387522570934E-2]
["Ayuntamiento Alicante",2.7587457674091747E-2,6.2884936034376171E-2]
["Ayuntamiento Córdoba",-1.6854680704580297E-2,3.3966521496940634E-2]
["Ayuntamiento Valladolid",-0.12639267518721869,-9.9840129215657519E-2]
["Ayuntamiento Vigo",-9.5476284972363365E-2,-1.5649317505062817E-2]
["Ayuntamiento Gijón/Xixón",3.5206200543971597E-2,2.0974509169683648E-2]
["Ayuntamiento L'Hospitalet",3.2330000110363522E-2,6.3456221563094217E-2]
["Diputación Barcelona",-2.3970100321230613E-2,-2.1541379365673276E-3]
["Diputación Valencia",-1.0100912185544805E-2,-1.0232161601472734E-2]
["Diputación Sevilla",8.1713065706745885E-2,3.5667509088220681E-2]
["Cabildo Insular Tenerife",1.4484616604090395E-2,2.0797740485102644E-2]
["Consell Insular Mallorca",7.4072836456114247E-2,7.4072836456114247E-2]
["Diputación Foral de Araba",-6.1236089593565218E-2,2.4309964719624747E-3]
["Diputación Foral de Gipuzkoa",-5.3918898561832525E-2,-4.6994619009888905E-3]
["Diputación Foral de Bizkaia",-5.1716840813064997E-2,-9.1377503134859196E-3]
["Total",-1.7093476880887741E-2,4.3120602116588662E-3]

{"sheet":"3","index":2,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 3. EVOLUCIÓN DE LA REPRESENTATIVIDAD EN LA CAPACIDAD/NECESIDAD DE FINANCIACIÓN DE LOS DOS GRANDES "]
["Corporaciones Locales",2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,"2023\nPresupuesto","2023\nCierre"]
["Ayuntamiento Madrid",965.80200000000002,1293.9659999999999,1385.086,1022.31284667,1057.0083958099999,1072.2034079100001,549.48449025000002,86.720941490000001,70.73208837,-236.30039300000001,56.136660880000001,117.660860189999]
["Ayuntamiento Barcelona",139.81700000000001,31.637,93.864000000000004,120.45433603000001,30.327480850000001,4.3862983700000004,47.065619469999994,-62.813579140000002,-80.537899999999993,-190.77912703999999,2.6190069999999999E-2,-113.64931147]
["Diputaciones Forales",73.855511129999655,77.597395229996593,102.88858959000014,125.23852816000149,231.8913728600003,283.95844979000003,246.95937717999999,-229.02566367,229.03857553,135.44997296,-172.31578306,-289.01767787839901]
["Resto Corporaciones Locales grandes",934.02362478000043,762.32408791000364,333.1614104099998,856.9942891399985,598.77275047999979,965.55671655000037,886.63133080000034,474.35221791999993,530.86981371000002,156.39814712041712,658.10659510924779,415.27251451041201]

{"sheet":"4","index":3,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 4. VARIACIONES DEL GASTO COMPUTABLE 24 GRANDES CORPORACIONES LOCALES AL CIERRE DE 2020, 2021 Y 2022 Y PREVISIONES 2023"]
["Corporaciones Locales","Variación anual 2020","Variación anual 2021","Variación anual 2022","Variación anual 2023"]
["Ayuntamiento Madrid",7.8627994712893834E-2,0.10571198165548523,0.10541803337354484,7.4018317135370104E-2]
["Ayuntamiento Barcelona",1.5098743745262988E-2,8.9906431469761738E-2,0.15979784569998134,5.296260661594121E-2]
["Ayuntamiento Valencia",2.7622062664482083E-2,2.5833892966244276E-2,0.10434242574585252,0.10573582502534551]
["Ayuntamiento Sevilla",-9.7811957522841997E-4,-1.6239930819548221E-3,9.9582602092189484E-2,1.6234198240403952E-2]
["Ayuntamiento Zaragoza",0.13843827078636384,-5.6671666917718744E-2,0.11057335988815753,1.6891826381014274E-2]
["Ayuntamiento Málaga",1.6075540049484971E-3,8.0243085308592269E-2,0.11178128499240959,7.8943758708505118E-3]
["Ayuntamiento Murcia",8.0563235623789531E-3,3.3117928133168606E-2,8.3037037189130705E-2,5.1405198120471729E-2]
["Ayuntamiento Palma",8.0331017498459723E-2,3.9262411055570379E-2,0.10491918027412339,1.4020641752448437E-2]
["Ayuntamiento Las Palmas Gran Canaria",0.12758736260909886,-1.3774810069447474E-2,1.2918447194234517E-2,0.27430988445441118]
["Ayuntamiento Bilbao",-6.3998103947217611E-2,6.0779581467870658E-2,7.0458597703645376E-2,0.11796811477311377]
["Ayuntamiento Alicante",8.5962578433415468E-2,3.4114884903512888E-2,0.13853302157784553]
["Ayuntamiento Córdoba",6.4126213040441415E-2,0.16949473495803002,9.0010097950166124E-3,0.26191947748366617]
["Ayuntamiento Valladolid",1.3258796321374389E-2,6.420685390895664E-2,0.14771975321096864,0.10879583542509375]
["Ayuntamiento Vigo",-5.1622305364232075E-2,8.1816236130885844E-2,0.13138459733831809,0.22213019137894421]
["Ayuntamiento Gijón/Xixón",2.3533319486420012E-2,6.0901892728260298E-2,7.5912617879531519E-2,5.2709248838774148E-2]
["Ayuntamiento L'Hospitalet",5.8632269299104811E-2,-5.0141662684470178E-2,8.7508749817073225E-2,-7.056099787183423E-2]
["Diputación Barcelona",-4.5809001439676041E-2,3.8706596171863561E-2,1.1394762475893216E-2,0.25523862270273945]
["Diputación Valencia",0.15911471408505862,7.571515764140746E-2,5.1800165327785752E-2,0.11551309444793943]
["Diputación Sevilla",3.0201830212217118E-2,1.3448449162495151,1.5690476567836509E-2,-0.27395797991432858]
["Cabildo Insular Tenerife",6.1922014026117633E-2,0.12717680540433096,0.46089650681072714,5.7089115060812823E-2]
["Consell Insular Mallorca",3.4203084772900239E-2,0.19972079096110495,0.115985417821582,0.13947015739824842]
["Diputación Foral de Araba",6.0245794729731905E-3,3.7301787980686285E-2,7.1775862422453374E-2]
["Diputación Foral de Gipuzkoa",0.13206526375401606,-3.8770284220801865E-2,0.11033628335636569,0.35838736727956499]
["Diputación Foral de Bizkaia",3.3385017073332746E-2,2.8365976842574803E-3,0.10905617964399106,0.12389001788424302]
["Total",4.3556307039189335E-2,7.0388658069006294E-2,0.11153189402598705,9.134364107027014E-2]

{"sheet":"5","index":4,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 5. COMPARACIÓN ENTRE LA VARIACIÓN ANUAL MEDIA DEL GASTO COMPUTABLE DE 2019 A 2022 Y DE 2019 A 2023"]
["Nombre","Media anual 2019/2022 en PR2023","Media anual 2019/2022 en CI2023","Media anual 2019/2023 en CI2023"]
["Ayuntamiento Madrid",11.061877748044067,10.578025139835946,9.3120281052170348]
["Ayuntamiento Barcelona",6.5944941027884498,9.4385672439819484,8.7779089413558324]
["Ayuntamiento Valencia",6.4570270499411926,7.1466139679972578,8.0094322585905537]
["Ayuntamiento Sevilla",2.7215748979124115,3.1717960089956567,2.8053835588565281]
["Ayuntamiento Zaragoza",5.7199212272702971,6.4222712652982992,5.3203620268879757]
["Ayuntamiento Málaga",4.5579798304263024,6.7233715634566957,5.2554245428989397]
["Ayuntamiento Murcia",3.5085211328630557,3.9470732735001461,3.7576897074970028]
["Ayuntamiento Palma",7.6849043629484788,8.0548968785013155,6.6155651748948774]
["Ayuntamiento Las Palmas Gran Canaria",4.2140362187682507,4.2140361811050964,10.885238080633336]
["Ayuntamiento Bilbao",2.0313533377186812,2.0949818789915087,4.7057950756328237]
["Ayuntamiento Alicante",9.2861348207731176,9.2861348207731176]
["Ayuntamiento Córdoba",6.8914163058137063,7.7836538935832786,13.449743971410195]
["Ayuntamiento Valladolid",7.907827260462537,8.5175465580697249,9.8030609993476343]
["Ayuntamiento Vigo",5.4318153729480869,5.4453346097544708,10.544435656029815]
["Ayuntamiento Gijón/Xixón",5.2758318973243234,5.6099850518844887,5.7469935834439045]
["Ayuntamiento L'Hospitalet",3.1181723216277955,3.1181723551591065,0.40958830488617703]
["Diputación Barcelona",8.0603712382017648E-2,8.0603743135609918E-2,6.4568482662071602]
["Diputación Valencia",10.293306843935538,10.382190532685387,11.573929477396467]
["Diputación Sevilla",48.452214540253976,48.452214540253976,19.534808293964538]
["Cabildo Insular Tenerife",24.4606614686579,25.169321337697909,21.381727834386687]
["Consell Insular Mallorca",12.822147444735828,12.822147444735828,14.444594710233721]
["Diputación Foral de Araba",3.9484291622737593,3.9484291622737593]
["Diputación Foral de Gipuzkoa",6.8417684291775869,4.7812730368560041,16.0404591567554]
["Diputación Foral de Bizkaia",4.9777670931625027,4.9777670931625027,6.1708166672887756]
["Total",7.5437980501775224,8.0010564059091056,8.5849655866425465]

{"sheet":"6","index":5,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 6. VARIACIONES DE LOS GASTOS PRIMARIOS AJUSTADOS POR EL PRTR DE LAS 24 GRANDES CORPORACIONES LOCALES AL CIERRE DE 2019 A 2022 Y PREVISIONES 2023"]
["Corporaciones Locales",2019,2020,2021,2022,2023]
["Ayuntamiento Madrid",8.6682845202202277E-2,4.3271472169138327E-2,7.4584495862449821E-2,9.6472994250764818E-2,-5.97526602162195E-2]
["Ayuntamiento Barcelona",-1.5847116234539452E-2,2.9034639302805143E-2,8.0470443214356591E-2,6.0333677199824853E-2,0.10275884607888028]
["Ayuntamiento Valencia",5.9482690329494471E-2,4.406896168973793E-2,6.9735590924476246E-2,6.2582492570110004E-2,9.1471407315644362E-2]
["Ayuntamiento Sevilla",1.5949624831748502E-2,7.5658536227795642E-2,-2.8164897666895821E-2,0.10253358198420254,1.7344975054230872E-2]
["Ayuntamiento Zaragoza",-1.366748512714428E-2,0.15251891418310393,-2.0625618195562904E-2,5.3847948630372448E-2,1.4842456760714726E-2]
["Ayuntamiento Málaga",5.4133376834750106E-2,8.8553955269840921E-3,6.4974155193209135E-2,7.4471717964588943E-2,-4.0137813388064492E-2]
["Ayuntamiento Murcia",6.9341368270779927E-2,-1.4238465016159553E-2,1.2658108431165879E-2,6.8827877475561877E-2,4.6703292351911743E-2]
["Ayuntamiento Palma",3.0048280990637319E-2,5.5605615853383757E-2,0.11613952298972739,2.4359883946635578E-2,6.467927425732202E-2]
["Ayuntamiento Las Palmas Gran Canaria",7.6416988931626656E-2,2.1405463306921956E-2,-1.9625856046409575E-2,1.4495562169928927E-2,0.36900377790431638]
["Ayuntamiento Bilbao",7.2536999193424628E-2,-2.8913429916267337E-2,5.0253333470961996E-2,7.6192836375863021E-2,8.3220131596116048E-2]
["Ayuntamiento Alicante",-4.8949842371854482E-3,6.708490453250017E-2,9.5495260681933009E-2,5.1163456787745393E-2,-6.2978122077949747E-3]
["Ayuntamiento Córdoba",-9.3038079485021144E-3,1.7097724357988019E-2,0.1723363298720676,-6.9144518963744919E-2,0.25294646319346503]
["Ayuntamiento Valladolid",5.6552302375009487E-2,-7.738207306841269E-3,0.12436692969998207,7.8963887490937773E-2,3.3471996170605096E-2]
["Ayuntamiento Vigo",-7.3306662676536238E-2,-9.6889009549510671E-2,0.11313988300738557,6.5095996610042006E-2,0.24065395374214169]
["Ayuntamiento Gijón/Xixón",-1.2866693932040209E-2,5.958746597547681E-2,2.7988067112481078E-2,9.5942081265443832E-2,5.4385658085799017E-2]
["Ayuntamiento L'Hospitalet",-1.4740727752802821E-4,1.4237562456437832E-2,-4.8683311896444224E-2,6.3600992995425099E-2,-2.2992281625009305E-2]
["Diputación Barcelona",0.11478076824171703,-5.571285420078731E-2,3.6499032584887993E-2,2.3865344270941016E-2,0.24102589446815903]
["Diputación Valencia",-1.3382735458173849E-2,9.4151943456881201E-2,4.4130118516832705E-2,9.4334784388076243E-2,9.475191893661894E-2]
["Diputación Sevilla",1.0207943900608666E-2,-1.5202480283343303E-2,0.66340624359517697,-8.7012907536212977E-2,-7.0667034294679729E-2]
["Cabildo Insular Tenerife",8.8636385312615088E-3,-8.1548252210879593E-2,1.1859651428801583E-2,0.11567097353388739,2.634581510714807E-2]
["Consell Insular Mallorca",-1.4083400894556038E-2,5.1488933034651262E-2,0.1114701785091157,2.7685660092116808E-2,0.10697106511721999]
["Diputación Foral de Araba",8.444749833721682E-2,-6.0259357492206123E-2,4.7041516561505653E-2,5.9744487175637039E-2,0.16520924490959152]
["Diputación Foral de Gipuzkoa",7.2286802714528697E-2,3.3486387323995434E-2,8.8291549240204104E-2,6.1094884022709288E-2,0.20566030533540466]
["Diputación Foral de Bizkaia",7.1531212571244507E-2,1.8105271224754143E-3,9.0092846598831128E-2,0.21852585303088704,-7.6545364700165722E-2]
["Total",4.1863008755877701E-2,2.2977954267822166E-2,7.1111320464932168E-2,7.7640047440210386E-2,4.1202493955610514E-2]

{"sheet":"7","index":6,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 7. VARIACIÓN INTERANUAL 2018-2023 DE INGRESOS FISCALES 16 GRANDES AYUNTAMIENTOS"]
["Corporaciones Locales",2018,2019,2020,2021,2022,2023]
["Ayuntamiento Madrid",2.891633642037927E-2,-2.461791089497585E-2,-9.0226690921785854E-2,7.9427232399406619E-2,-0.1066737486255811,0.14794431057956625]
["Ayuntamiento Barcelona",7.03553067034753E-3,2.1340370251903763E-2,-7.7425656043898172E-2,0.15197504893930289,-1.0029655574574227E-2,3.2734123242093884E-2]
["Ayuntamiento Valencia",6.3016277300039725E-2,-5.0752997218364848E-2,-1.6778659504750749E-2,7.8253703690327858E-2,4.3123170295548147E-3,8.1625532554020462E-3]
["Ayuntamiento Sevilla",3.4461961079168595E-2,1.3299618033247267E-2,-0.16516362687627528,7.8373582152820531E-2,8.3739542401701186E-2,-8.6460229838731927E-3]
["Ayuntamiento Zaragoza",-2.9706435850912614E-2,4.8151731988437963E-3,-9.8883516487047476E-2,8.9940680243564053E-2,-5.1155643172087525E-2,2.6281325151989686E-2]
["Ayuntamiento Málaga",1.9723456950691023E-2,6.952842396209126E-2,-0.12349389653227315,4.8458935329449948E-2,-4.5901323094010016E-2,5.2944409243013447E-3]
["Ayuntamiento Murcia",-1.7219602920345602E-2,3.7934316087068688E-2,-3.3134069466174233E-2,6.1372386541825245E-2,-1.1200414825971616E-2,-7.0122034471020262E-3]
["Ayuntamiento Palma",4.0768530044850364E-2,-3.1019749065609326E-2,-6.9748565534030846E-2,7.1616706395599736E-2,9.6305908401990048E-2,-1.9000485791139183E-2]
["Ayuntamiento Las Palmas Gran Canaria",5.4580883836023261E-2,-1.7311793925387745E-2,-0.18998338128907907,9.0304333760238942E-2,-8.843420919002391E-3,0.22128996767139292]
["Ayuntamiento Bilbao",6.2982916574995398E-2,4.3492523210907436E-2,-5.8593399112894483E-2,9.7569890437981643E-2,6.6177029639386646E-3,-3.983673330784937E-2]
["Ayuntamiento Alicante",-8.0228336718332453E-3,-1.2566960224706367E-2,-6.6351304576377695E-2,8.1441401351213485E-2,-2.4134119493353416E-2,4.4588885548326032E-2]
["Ayuntamiento Córdoba",-4.217730129135569E-2,-0.11283531311995067,-0.1179830453190482,4.4423961873286968E-2,-2.2511813346228492E-2,0.21836752958721276]
["Ayuntamiento Valladolid",1.3210113110796329E-2,-1.25367296320423E-2,-5.8764742741802448E-2,0.106421704950486,9.6022816796425218E-3,-4.2501710948722581E-3]
["Ayuntamiento Vigo",3.1043267923190739E-2,5.5984956491788848E-2,-6.7268757174038768E-2,6.904579960130941E-2,9.5377277305064929E-4,-4.9679587116202913E-2]
["Ayuntamiento Gijón/Xixón",4.1936377588376456E-2,-2.2074367362888196E-2,-7.7354428218579185E-2,-5.5209132494523196E-3,8.6560184926493991E-2,8.5116485536034139E-2]
["Ayuntamiento L'Hospitalet",-2.5386652547805932E-2,-2.724578876747951E-2,-5.9303938135837855E-2,5.237440553989943E-2,3.5332218972185955E-2,-7.0803560563496182E-2]
["Media",2.0689685121185564E-2,-7.4634821280118143E-3,-8.7415124359023239E-2,8.9118550267003313E-2,-3.8173952788848158E-2,6.7634991251657575E-2]

{"sheet":"8","index":7,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 8. EVOLUCIÓN DEL ENDEUDAMIENTO DE LAS 24 GRANDES CORPORACIONES LOCALES 2012 – 2022 Y ESTIMACIÓN 2023 (PORCENTAJE DE DEUDA SOBRE INGRESOS CORRIENTES)"]
["Entidad local","Ratio Deuda 2012","Ratio Deuda 2022","Ratio Deuda 2023"]
["Ayuntamiento Madrid",1.7746,0.32250450999999997,0.36019400000000001]
["Ayuntamiento Barcelona",0.50919999999999999,0.29114605999999998,0.41859400000000002]
["Ayuntamiento Valencia",1.37,0.22902028999999999,0.23271500000000001]
["Ayuntamiento Sevilla",0.66,0.19334921000000002,0.25561800000000001]
["Ayuntamiento Zaragoza",1.4421999999999999,0.76200219999999996,0.71357999999999999]
["Ayuntamiento Málaga",1.3419000000000001,0.29985761999999999,0.34640799999999999]
["Ayuntamiento Murcia",0.59899999999999998,0.58040217999999999,0.60782199999999997]
["Ayuntamiento Palma",0.96909999999999996,0.39436221999999999,0.39413300000000001]
["Ayuntamiento Las Palmas Gran Canaria",0.4254,0,1.1158E-2]
["Ayuntamiento Bilbao",4.3E-3,1.0449E-2,3.2356999999999997E-2]
["Ayuntamiento Alicante",0.74750000000000005,0,6.8079000000000001E-2]
["Ayuntamiento Córdoba",0.95350000000000001,0.50801940999999995,0.58128599999999997]
["Ayuntamiento Valladolid",0.76370000000000005,0.48247712999999998,0.59199400000000002]
["Ayuntamiento Vigo",0.25480000000000003,0,0]
["Ayuntamiento Gijón/Xixón",0.69989999999999997,0.32226899000000003,0.36082900000000001]
["Ayuntamiento L'Hospitalet",0.69850000000000001,0.31514769999999998,0.28635100000000002]
["Diputación Barcelona",0.33,0,0]
["Diputación Valencia",0.94699999999999995,3.6788040000000001E-2,7.8253000000000003E-2]
["Diputación Sevilla",0.51280000000000003,1.690152E-2,1.3723000000000001E-2]
["Cabildo Insular Tenerife",0.84279999999999999,0.15802839999999999,0.171787]
["Consell Insular Mallorca",0.82440000000000002,0.20015329999999998,0.200317]
["Diputación Foral de Araba",0.46800000000000003,0.70828697630688364,0.74409199999999998]
["Diputación Foral de Gipuzkoa",0.41870000000000002,0.29336973463022537,0.26955699999999999]
["Diputación Foral de Bizkaia",0.52929999999999999,0.75961532661998166,0.74306399999999995]
["Media grupo",0.996,0.34143609548593806,0.37399449900996617]

{"sheet":"9","index":8,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[" GRÁFICO 9. PREVISIONES DE ESTABILIDAD PRESUPUESTARIA EN 2023 DE LAS CORPORACIONES LOCALES CON PROBLEMAS ESTRUCTURALES Y ESTIMACIONES AIREF "]
["(*) La capacidad/necesidad de financiación de 2022 y/o 2023 comunicada por la entidad local ha sido corregida de los ajustes de Contabilidad Nacional derivados de la liquidación de 2020 del Sistema de Financiación y/o de los del PRTR para hacerlos neutrales."]
["Corporaciones Locales","CNF / Ingresos Cierre 2022","CNF / ingresos Corporaciones Locales Cierre 2023","CNF / ingresos AIReF Cierre 2023"]
["Ayuntamiento Jerez de la Frontera*",6.8170308901327512E-2,9.3194737575045469E-2,6.9271459514619674E-2]
["Ayuntamiento Alcorcón",0.1136946192189482,0.2058220398941833,0.22676068936385746]
["Ayuntamiento Parla",-0.31764099062768864,-0.12906757462424218,-9.0485910759099328E-2]
["Ayuntamiento Algeciras*",-3.0987383152197009E-2,0.11024339095485425,4.4198820679564536E-2]
["Ayuntamiento Jaén*",-0.22920498718072657,-0.5315635749055635,-8.8024345587261674E-2]
["Ayuntamiento Gandía*",2.5818502643736713E-2,8.6426757447277888E-2,6.8709930036076672E-2]
["Ayuntamiento Línea de la Concepción*",4.6649823868755269E-2,9.5883700719713458E-2,8.3660780013094793E-2]
["Ayuntamiento Aranjuez*",9.4470891817796721E-2,9.0160529155061966E-2,9.4913592496431859E-2]
["Ayuntamiento Arganda del Rey*",7.0418122116630136E-2,5.8361163598735485E-2,0.11397459162176711]
["Ayuntamiento Puerto Real",0.19378874263756246,0.14341000963828995,0.17066418473847855]
["Ayuntamiento San Fernando de Henares",0.12418508184381204,0.1505758367428004,0.16533645654419069]
["Ayuntamiento Palacios y Villafranca (Los)*",6.4003720603697852E-3,5.5434413452684961E-2,5.5434413452684961E-2]
["Ayuntamiento Totana",-7.067269560708006E-2,3.2288465596238589E-2,-2.4662364764990292E-2]
["Ayuntamiento Arcos de la Frontera",-6.4680207564941403E-2,-2.9220915728954706E-2,-1.8440612256455317E-2]
["Ayuntamiento San Andrés del Rabanedo",0.22325567281755324,0.16106080110005441,0.21198858544464896]
["Ayuntamiento Navalcarnero","Sin datos","Sin datos","Sin datos"]
["Ayuntamiento Caravaca de la Cruz*",1.6646613323489292E-2,-0.10154970025555633,1.3921797076721847E-2]
["Ayuntamiento Alboraia/Alboraya*",8.076155756563462E-2,-9.3391750622289155E-4,2.6876406355135864E-2]
["Ayuntamiento Almonte",0.21031658404179351,0.16554800067858894,0.14963032895443731]
["Ayuntamiento Barrios (Los)",0.24560003298947344,0.22179082783316903,1.4698845993009755E-2]
["Ayuntamiento Barbate","Sin datos","Sin datos","Sin datos"]
["Ayuntamiento Ayamonte",0.10153199574520486,9.8078380894675424E-2,5.7108199630017661E-2]
["Media del grupo",2.249492954097326E-2,5.0118839725727414E-2,7.0842782955956113E-2]

{"sheet":"10","index":9,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 10. PREVISIONES ESTABILIDAD PRESUPUESTARIA 2023 DE LAS CORPORACIONES LOCALES CON PROBLEMAS ESTRUCTURALES SIN EFECTO LIQUIDACIÓN 2020 SISTEMA FINANCIACIÓN"]
["Corporaciones Locales","CNF / INF 2023 Corporaciones Locales sin liquidación Sistema de Financiación","CNF / INF 2023 AIReF sin liquidación Sistema de Financiación"]
["Ayuntamiento Jerez de la Frontera",7.3579783838656321E-2,4.9814403309316198E-2]
["Ayuntamiento Alcorcón",0.18350721825398961,0.20519850571072057]
["Ayuntamiento Parla",-0.15331930818530434,-0.11224753627755857]
["Ayuntamiento Algeciras",8.9436407880027352E-2,2.374263603123504E-2]
["Ayuntamiento Jaén",-0.55912965163968154,-0.10812648785298778]
["Ayuntamiento Gandía",6.7090392764498047E-2,4.9960680454601211E-2]
["Ayuntamiento Línea de la Concepción",9.5883700719713458E-2,8.3660780013094793E-2]
["Ayuntamiento Aranjuez",6.5587587328545943E-2,7.0438911505711022E-2]
["Ayuntamiento Arganda del Rey",4.0695544380138664E-2,9.5758087431035796E-2]
["Ayuntamiento Puerto Real",0.12327949905539129,0.15117416781819068]
["Ayuntamiento San Fernando de Henares",0.13262164854352862,0.14738226834491894]
["Ayuntamiento Palacios y Villafranca (Los)",3.3221488407311747E-2,3.3221488407311747E-2]
["Ayuntamiento Totana",8.7949453356900627E-3,-4.8155885025538817E-2]
["Ayuntamiento Arcos de la Frontera",-4.8075507728446931E-2,-3.7751540858660934E-2]
["Ayuntamiento San Andrés del Rabanedo",0.13437536250810814,0.18580299006605741]
["Ayuntamiento Navalcarnero","Sin datos","Sin datos"]
["Ayuntamiento Caravaca de la Cruz",-0.12162062389811265,-6.0495889122093886E-3]
["Ayuntamiento Alboraia/Alboraya",-2.0043209501757666E-2,7.8017312239638164E-3]
["Ayuntamiento Almonte",0.15348200024705311,0.138056127744942]
["Ayuntamiento Barrios (Los)",0.2040527186153569,-2.572637717149421E-3]
["Ayuntamiento Barbate","Sin datos","Sin datos"]
["Ayuntamiento Ayamonte",8.1761725622663192E-2,4.1469816177013799E-2]
["Total",3.0346040517244828E-2,5.1891954639573384E-2]

{"sheet":"11","index":10,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 11. VARIACIONES DEL GASTO COMPUTABLE DE LAS CORPORACIONES LOCALES CON PROBLEMAS ESTRUCTURALES AL CIERRE DE 2020, 2021 Y 2022 Y PREVISIONES 2023"]
["Corporaciones Locales","Variación anual 2020","Variación anual 2021","Variación anual 2022","Variación anual 2023"]
["Jerez de la Frontera",-2.3316875315604335E-3,-5.3878590458562685E-2,-8.3010548407054893E-2,0.15017886436979055]
["Alcorcón",-0.10316375438174387,0.20070265720965974,5.9376427723795144E-2,7.4319791653409517E-2]
["Parla",5.9725235978914437E-2,-0.18580953658977528,0.25007254410454771,1.8599242074559985E-2]
["Algeciras",2.0764685169971875E-2,0.2002143703381849,0.36829164286833449,-0.26460404568586116]
["Jaén",9.6742935121120657E-2,-1.6473089384397399E-2,-3.3721934231049189E-2,0.13166828016393883]
["Gandía",2.5965009176466491E-2,6.4200972612195484E-2,0.11026009883899279,-5.3322660806428779E-2]
["Línea de la Concepción",-4.1528272265916828E-2,4.0627241971420425E-2,0.18934278277320193,-3.4468376302210446E-2]
["Aranjuez",4.4291692545602501E-2,-0.11163964518301439,0.15169915304743742,0.13872247013004135]
["Arganda del Rey",6.7392585822056983E-3,5.740188225542564E-4,2.0412892726636045E-2,-2.9949379417005706E-2]
["Puerto Real",-8.4361444320656384E-2,0.19960963729606296,-3.0244536000877176E-2,4.6538816306848529E-2]
["San Fernando de Henares",-0.13329916583315038,0.33859495177722176,-3.4652740715693797E-2,2.5436332062011902E-2]
["Palacios y Villafranca (Los)",-1.5504756622609972E-2,0.3966117289698276,-0.22720862933667629,4.4451098964159552E-2]
["Totana",5.6115247156834913E-2,9.80643561594048E-2,0.29014913257248143,-9.9668650295679506E-2]
["Arcos de la Frontera",-9.7886716511724092E-2,0.14128450746799848,0.29478881630880283,-6.2981357928730941E-2]
["San Andrés del Rabanedo",-2.7164286836207752E-2,0.11769354758670891,-4.3753730084973415E-2,0.14722515308073802]
["Navalcarnero","Sin datos","Sin datos","Sin datos","Sin datos"]
["Caravaca de la Cruz",-4.2132599116542317E-2,1.7551847284174027E-3,0.29294763106198252,-9.0126834102995712E-2]
["Alboraia/Alboraya",1.5229398042802336,-0.45787215140241971,-3.8316073076345103E-2,6.6309686164678139E-2]
["Almonte",-0.16965212337392799,5.8570012394751902E-2,0.12678863529724649,-2.8577737516588431E-2]
["Barrios (Los)",-6.0883528872671677E-2,-7.331060743822837E-3,0.11093008579457209,4.2076471510027691E-2]
["Barbate","Sin datos","Sin datos","Sin datos","Sin datos"]
["Ayamonte",2.8970250583033375E-2,4.7372082404579352E-2,8.9271280536620701E-2,4.0787068036340912E-3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["EELL","EELL","EELL","EELL"]
["Liquidación","Liquidación","Liquidación","Liquidación"]
["Corporación","Corporación","Corporación","Corporación"]
[2021,2022,2022,2022]
["CI2023","CI2023","CI2023","CI2023"]
["GC_RdG_Aj","GC_RdG_Aj","IFS","Homogeneizacion"]
[184105.54313000001,160978.32136,0,0,160978.32136]
[120926.90062,128107.107994526,0,0,128107.107994526]
[68956.18922,86200.238890000008,0,0,86200.238890000008]
[100795.005,137916.96298437199,0,0,137916.96298437199]
[125304.54068999999,121079.02920999999,0,0,121079.02920999999]
[72582.498149999999,80585.45156999999,0,0,80585.45156999999]
[37492.987703699997,44592.014329999998,0,0,44592.014329999998]
[36862.206200000001,42454.17166,0,0,42454.17166]
[60834.3,66576.104040000006,0,0,66576.104040000006]
[29463.31,28572.205859999998,0,0,28572.205859999998]
[38281.56136,36955.000340000006,0,0,36955.000340000006]
[29253.047999999999,25742.804489999999,0,0,25742.804489999999]
[20982.591179999999,27070.67181,0,0,27070.67181]
[26558.189309999998,34387.246500000001,0,0,34387.246500000001]
[15811.302,15119.49856,0,0,15119.49856]
[0,0,0,0,0]
[17695.802800000001,22879.746309999999,0,0,22879.746309999999]
[28858.203000000001,27752.469985,0,0,27752.469985]
[33845.027040000001,38136.191829999996,0,0,38136.191829999996]
[18008.715,20006.423300000002,0,0,20006.423300000002]
[0,0,0,0,0]
[18429.426239999997,20074.64472,0,0,20074.64472]

{"sheet":"12","index":11,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 12. VARIACIONES DE LOS GASTOS PRIMARIOS AJUSTADOS POR EL PRTR DE LAS CORPORACIONES LOCALES CON PROBLEMAS ESTRUCTURALES AL CIERRE DE 2019 A 2022 Y PREVISIONES 2023"]
["Corporaciones Locales",2019,2020,2021,2022,2023]
["Ayuntamiento Jerez de la Frontera",-7.7459548470847725E-2,6.8669227781613773E-2,0.18228622985729881,-9.0776478339551853E-2,8.469178511709901E-3]
["Ayuntamiento Alcorcón",-4.561250013372907E-2,0.21233414249495949,-4.6222955225128669E-2,2.1380583452487441E-2,4.9827912362429574E-2]
["Ayuntamiento Parla",1.3193556513086128E-2,8.3421446842704111E-2,-2.8882795579283773E-2,0.44691883984701358,-0.27524460037816817]
["Ayuntamiento Algeciras",7.4628590246825735E-2,-6.7302033182057531E-3,9.1085400613162684E-2,0.12198643151967735,-0.12862429662125593]
["Ayuntamiento Jaén",-3.1405964913056431E-2,-6.8787645122882476E-2,6.6088070946745639E-2,0.10303710885403113,0.12329104191211379]
["Ayuntamiento Gandía",-6.5406950019041954E-2,5.0678046135504091E-2,0.11776084511485055,0.18482454947248372,-0.10485053015525868]
["Ayuntamiento Línea de la Concepción",0.10626854496201625,1.078272388989828E-4,8.3116562737522826E-2,0.30353080924773401,-0.10100585065124697]
["Ayuntamiento Aranjuez",-0.26884395711941339,0.17264042666585194,-6.338747519729386E-2,0.1755555069597439,1.8970208310010388E-2]
["Ayuntamiento Arganda del Rey",5.7303912833944218E-2,-4.4709847550039018E-2,7.6004209493796215E-2,0.18273538299900072,0.13157681326837753]
["Ayuntamiento Puerto Real",0.16913608577963932,-0.1234922479238071,null,null,0.20644937033677732]
["Ayuntamiento San Fernando de Henares",null,null,null,0.10495150552388754,-0.15791352524314189]
["Ayuntamiento Palacios y Villafranca (Los)",0.20326883753919031,-0.15595615455018308,null,null,3.5510054727611456E-2]
["Ayuntamiento Totana",4.0652910596541976E-2,0.1033738770013186,-1.3163292827480183E-2,7.1965121868639487E-2,-7.7484086846929048E-2]
["Ayuntamiento Arcos de la Frontera",null,null,0.47420365974945533,6.3403729043280066E-2,-2.6409604441970734E-2]
["Ayuntamiento San Andrés del Rabanedo",0.11782500415193428,-5.3420542340383625E-2,0.14869286350808356,-8.5150984962395926E-2,0.16643689617949639]
["Ayuntamiento Navalcarnero",0.15500422956793286,-0.15633588798531894,0.14365011643614875]
["Ayuntamiento Caravaca de la Cruz",-1.3556211437954439E-2,-7.608545468274544E-2,0.14668663034522431,0.12443378619013186,0.15293427622644784]
["Ayuntamiento Alboraia/Alboraya",0.15971042930986656,-5.4189219307371583E-2,0.12873698126971228,0.31927490575795525,-6.6567376090692909E-3]
["Ayuntamiento Almonte",4.5318195726485884E-2,-0.12162524729570881,8.6116891378697717E-3,-5.1360943873960931E-2,4.2143522595361714E-2]
["Ayuntamiento Barrios (Los)",-0.26902837410344704,0.23941319067013545,-5.8709314968353195E-2,0.6645204034631238,-0.41432871898864015]
["Ayuntamiento Barbate"]
["Ayuntamiento Ayamonte",0.33139109904808445,-0.23564040512841083,0.15618243930779199,9.0439665198945612E-2,-1.1336784426800408E-2]
["Total",1.6333502219713549E-2,1.4392104963753441E-2,4.8629762008201911E-2,0.14354625259358242,-3.8700204729765014E-2]

{"sheet":"13","index":12,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 13. VARIACIÓN INTERANUAL 2018-2023 DE INGRESOS FISCALES DE LAS CORPORACIONES LOCALES CON PROBLEMAS ESTRUCTURALES"]
["Corporaciones Locales",2018,2019,2020,2021,2022,2023]
["Ayuntamiento Jerez de la Frontera",5.1537926671881409E-2,-3.0468920238931128E-2,-1.9499576380614959E-4,9.1327307089911547E-2,-8.0553923951704895E-2,-3.5485775399430139E-2]
["Ayuntamiento Alcorcón",null,-3.8229484096587843E-2,-5.8960540937184058E-2,9.4239784951092049E-3,-7.4182737069086929E-2,3.682628360609972E-2]
["Ayuntamiento Parla",2.2832130671834911E-3,5.2229751145414761E-4,-0.11825040243071816,0.10152788112635359,-1.5824202482551314E-2,9.8591652355989757E-3]
["Ayuntamiento Algeciras",0.1460458113646276,3.8090280215928973E-2,-9.9598979035913776E-2,8.1346816135466682E-2,-8.5354212347834024E-3,1.2285422355852098E-2]
["Ayuntamiento Jaén",0.11024666102969313,-0.25743175784574507,0.4499870908153511,3.5780620380489812E-2,-0.14426334811341845,-5.5421652041534555E-2]
["Ayuntamiento Gandía",-1.2078931029705581E-2,8.7582645364970707E-2,-0.17862630954582132,0.27621035028809543,-2.087577693525124E-2,-6.1909577378372174E-2]
["Ayuntamiento Línea de la Concepción",6.1825662604380716E-2,5.3759907534995217E-2,-8.8091444081674644E-2,5.9595447411022982E-2,8.2135199486366064E-2,1.8246814073496315E-3]
["Ayuntamiento Aranjuez",7.4665110705306167E-2,5.1208893177703045E-2,-0.12229137700264342,4.8330601232528178E-2,-3.9763303060986022E-2,-1.2452753849201087E-2]
["Ayuntamiento Arganda del Rey",0.19180861320023046,2.3694369548726776E-2,-0.2140863489767702,4.8880934577731827E-3,0.21554215056831502,0.13383362721018974]
["Ayuntamiento Puerto Real",2.0246179738022153E-2,-1.1075624044358759E-3,-4.5289847068416501E-3,2.0801809023899925E-2,6.361583112786999E-2,-0.119250106564166]
["Ayuntamiento San Fernando de Henares",null,null,null,null,0.21837121746039975,1.9719569101068622E-2]
["Ayuntamiento Palacios y Villafranca (Los)",3.7311054072099871E-2,4.7475886219419195E-3,-2.2940810899827777E-2,6.0559283264354842E-2,4.1970950538436101E-2,1.7052411600266791E-2]
["Ayuntamiento Totana",0.19257661772752072,3.9656979529708529E-2,2.7327490355467244E-3,6.4156634496102177E-2,-2.6663768667160831E-2,1.7205834281420741E-2]
["Ayuntamiento Arcos de la Frontera",null,null,null,3.1302290786406839E-2,-5.8066175072234931E-4,9.1790129815026975E-2]
["Ayuntamiento San Andrés del Rabanedo",8.8757236756573862E-2,-6.1150972811461903E-2,0.13510006507732186,-5.4466983488023618E-2,9.8351607478680478E-3,-4.5013497756980568E-2]
["Ayuntamiento Navalcarnero",8.7872566159987855E-2,3.0067306685760176E-2,-5.9636220136813953E-2,0.12373703104185857]
["Ayuntamiento Caravaca de la Cruz",-1.6225960830923813E-2,-5.6949823269483281E-3,-3.5837573126464677E-2,0.16758662412969491,-5.8988408707611378E-2,0.12121064438140394]
["Ayuntamiento Alboraia/Alboraya",9.7515042107929648E-2,-2.414169334508115E-2,-2.2503882931641694E-2,1.0160178955268802E-2,3.7446235126940429E-3,2.8134068112862169E-2]
["Ayuntamiento Almonte",9.1588304334417628E-2,-7.0192913868856247E-2,-6.6554827733631777E-2,8.3167636488331712E-2,0.15872533910190087,-2.7056302026832971E-2]
["Ayuntamiento Barrios (Los)",-7.3839310764915914E-2,-3.4433416468488708E-2,-3.7316619959498913E-2,0.17109669969215921,0.12470589468518706,-8.6590529510420247E-2]
["Ayuntamiento Barbate"]
["Ayuntamiento Ayamonte",9.6560737110765234E-3,0.25266699757111027,-0.17610986604534332,0.12137366149108327,0.13069836106780494,-0.10795928126840589]
["Total",0.16481048561412701,3.9111130427418204E-3,-3.9135727440727526E-2,0.11496196802996203,-4.2930786830339282E-2,-5.7179631054856215E-3]

{"sheet":"14","index":13,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["GRÁFICO 14. EVOLUCIÓN DEL ENDEUDAMIENTO DE LAS CORPORACIONES LOCALES CON PROBLEMAS ESTRUCTURALES EN 2012-2021 Y ESTIMACIÓN 2023 (PORCENTAJE DE DEUDA SOBRE INGRESOS CORRIENTES)"]
["Entidad local","Ratio deuda 2012","Ratio deuda 2021","Ratio deuda 2023"]
["Jerez de la Frontera",1.7746,4.3904171741534395,4.4776040000000004]
["Alcorcón",0.50919999999999999,1.1906289385956708,0.80664499999999995]
["Parla",1.37,4.9474976440355345,5.5490000000000004]
["Algeciras",0.66,1.9987580054244813,1.9809939999999999]
["Jaén",1.4421999999999999,4.3209733943435387,4.5595689999999998]
["Gandía",0.59899999999999998,3.0827454613915721,2.8957419999999998]
["Línea de la Concepción",0.96909999999999996,2.2611979736760595,1.8496950000000001]
["Aranjuez",0.4254,2.2833936726624477,2.3008000000000002]
["Arganda del Rey",4.3E-3,1.5110103293532384,1.3767389999999999]
["Puerto Real",0.74750000000000005,2.6836388999691367,2.345926]
["San Fernando de Henares",0.95350000000000001,1.8589771471733443,1.645985]
["Palacios y Villafranca (Los)",0.76370000000000005,1.6399065946799121,1.651842]
["Totana",0.25480000000000003,3.7060295831387089,3.8958029999999999]
["Arcos de la Frontera",0.69989999999999997,2.373832385482276,2.2918249999999998]
["San Andrés del Rabanedo",0.69850000000000001,2.2792339844021616,1.841888]
["Navalcarnero",0.33,3.8077635839629114,0]
["Caravaca de la Cruz",0.94699999999999995,1.215832143614562,1.138272]
["Alboraia/Alboraya",0.51280000000000003,0.85558588952843173,0.56425999999999998]
["Almonte",0.84279999999999999,1.0319472779019065,0.69921199999999994]
["Barrios (Los)",0.82440000000000002,6.6788416241946118,6.924963]
["Barbate",0.46800000000000003,3.2243266220981792,0]
["Ayamonte",0.41870000000000002,1.7395686930072236,1.359451]