{"project":"backend-unificado","generated_at":"2026-04-25T11:37:51.672220Z","data":{"ciiu":"41","format":"json","path":"/app/data/exports/sector_41.json","inline_content":"{\n  \"summary\": {\n    \"ciiu\": \"41\",\n    \"title\": \"Construcción de edificios residenciales\",\n    \"available_company_rows\": 20904,\n    \"available_years\": [\n      2017,\n      2018,\n      2019,\n      2020,\n      2021,\n      2022,\n      2023,\n      2024\n    ],\n    \"latest_year\": 2024,\n    \"metrics_by_year\": [\n      {\n        \"anio\": 2017,\n        \"companies\": 1147,\n        \"ingresos_mean\": 16346862.338273758,\n        \"utilidad_neta_mean\": 1565259.482999128,\n        \"activo_total_mean\": 49633269.09590235,\n        \"pasivo_total_mean\": 33883682.991281606,\n        \"liquidez_corriente_mean\": null,\n        \"endeudamiento_mean\": 3.4838974055219536,\n        \"roa_mean\": -22.148331756389677\n      },\n      {\n        \"anio\": 2018,\n        \"companies\": 1504,\n        \"ingresos_mean\": 20132410.996675532,\n        \"utilidad_neta_mean\": 2227771.361037234,\n        \"activo_total_mean\": 109781993.74933511,\n        \"pasivo_total_mean\": 70766257.58510639,\n        \"liquidez_corriente_mean\": null,\n        \"endeudamiento_mean\": 1.195150307741913,\n        \"roa_mean\": -0.10644712585774867\n      },\n      {\n        \"anio\": 2019,\n        \"companies\": 1755,\n        \"ingresos_mean\": 11814238.417094016,\n        \"utilidad_neta_mean\": 763617.8,\n        \"activo_total_mean\": 41439012.39544159,\n        \"pasivo_total_mean\": 27683241.944159545,\n        \"liquidez_corriente_mean\": null,\n        \"endeudamiento_mean\": 1287.3385535854356,\n        \"roa_mean\": -0.7046956695854018\n      },\n      {\n        \"anio\": 2020,\n        \"companies\": 3730,\n        \"ingresos_mean\": 9779785.514745308,\n        \"utilidad_neta_mean\": 824839.2,\n        \"activo_total_mean\": 38551402.08203753,\n        \"pasivo_total_mean\": 25188426.702680964,\n        \"liquidez_corriente_mean\": 508.01809092246003,\n        \"endeudamiento_mean\": 0.8411919067224929,\n        \"roa_mean\": -0.25895988374587536\n      },\n      {\n        \"anio\": 2021,\n        \"companies\": 3586,\n        \"ingresos_mean\": 19703777.6514222,\n        \"utilidad_neta_mean\": 2804294.993028444,\n        \"activo_total_mean\": 57801129.63552705,\n        \"pasivo_total_mean\": 37819459.33658673,\n        \"liquidez_corriente_mean\": 101.36602071262381,\n        \"endeudamiento_mean\": 0.7537476097121585,\n        \"roa_mean\": -0.32611452943599745\n      },\n      {\n        \"anio\": 2022,\n        \"companies\": 3347,\n        \"ingresos_mean\": 14447370.184642963,\n        \"utilidad_neta_mean\": 1493354.0026889753,\n        \"activo_total_mean\": 50001067.208246194,\n        \"pasivo_total_mean\": 33581006.413803406,\n        \"liquidez_corriente_mean\": 99.76263327334226,\n        \"endeudamiento_mean\": 0.744017782102341,\n        \"roa_mean\": -0.10367878083601505\n      },\n      {\n        \"anio\": 2023,\n        \"companies\": 3100,\n        \"ingresos_mean\": 18006140.872580644,\n        \"utilidad_neta_mean\": 871930.0003225807,\n        \"activo_total_mean\": 57456729.26741935,\n        \"pasivo_total_mean\": 39627360.45612903,\n        \"liquidez_corriente_mean\": 712.8466560068641,\n        \"endeudamiento_mean\": 0.7927512524158177,\n        \"roa_mean\": -0.00918551514190065\n      },\n      {\n        \"anio\": 2024,\n        \"companies\": 2735,\n        \"ingresos_mean\": 20201403.724680074,\n        \"utilidad_neta_mean\": 1746497.4120658136,\n        \"activo_total_mean\": 66087287.21791591,\n        \"pasivo_total_mean\": 44167297.02266911,\n        \"liquidez_corriente_mean\": 91.52477257213758,\n        \"endeudamiento_mean\": 0.6584396215088505,\n        \"roa_mean\": -0.014026484038381947\n      }\n    ],\n    \"warnings\": []\n  },\n  \"analysis\": {\n    \"ciiu\": \"41\",\n    \"descriptive\": [\n      {\n        \"anio\": 2017,\n        \"observations\": 1147,\n        \"activo_total_mean\": 49633269.09590235,\n        \"activo_total_median\": 16958826.0,\n        \"pasivo_total_mean\": 33883682.991281606,\n        \"pasivo_total_median\": 11787712.0,\n        \"patrimonio_mean\": 15749586.10462075,\n        \"patrimonio_median\": 3339755.0,\n        \"ingresos_mean\": 16346862.338273758,\n        \"ingresos_median\": 3671000.0,\n        \"utilidad_neta_mean\": 1565259.482999128,\n        \"utilidad_neta_median\": 170343.0,\n        \"liquidez_corriente_mean\": null,\n        \"liquidez_corriente_median\": null,\n        \"endeudamiento_mean\": 3.4838974055219536,\n        \"endeudamiento_median\": 0.7680478905243225,\n        \"roa_mean\": -22.148331756389677,\n        \"roa_median\": 0.0102607428840829\n      },\n      {\n        \"anio\": 2018,\n        \"observations\": 1504,\n        \"activo_total_mean\": 109781993.74933511,\n        \"activo_total_median\": 12239788.0,\n        \"pasivo_total_mean\": 70766257.58510639,\n        \"pasivo_total_median\": 7561618.5,\n        \"patrimonio_mean\": 39015736.16422872,\n        \"patrimonio_median\": 2302531.0,\n        \"ingresos_mean\": 20132410.996675532,\n        \"ingresos_median\": 2150455.0,\n        \"utilidad_neta_mean\": 2227771.361037234,\n        \"utilidad_neta_median\": 72762.5,\n        \"liquidez_corriente_mean\": null,\n        \"liquidez_corriente_median\": null,\n        \"endeudamiento_mean\": 1.195150307741913,\n        \"endeudamiento_median\": 0.7337491062912386,\n        \"roa_mean\": -0.10644712585774867,\n        \"roa_median\": 0.00679353213786265\n      },\n      {\n        \"anio\": 2019,\n        \"observations\": 1755,\n        \"activo_total_mean\": 41439012.39544159,\n        \"activo_total_median\": 10944108.0,\n        \"pasivo_total_mean\": 27683241.944159545,\n        \"pasivo_total_median\": 6887513.0,\n        \"patrimonio_mean\": 13755770.45128205,\n        \"patrimonio_median\": 1839925.0,\n        \"ingresos_mean\": 11814238.417094016,\n        \"ingresos_median\": 2009030.0,\n        \"utilidad_neta_mean\": 763617.8,\n        \"utilidad_neta_median\": 62449.0,\n        \"liquidez_corriente_mean\": null,\n        \"liquidez_corriente_median\": null,\n        \"endeudamiento_mean\": 1287.3385535854356,\n        \"endeudamiento_median\": 0.7460894976336222,\n        \"roa_mean\": -0.7046956695854018,\n        \"roa_median\": 0.0064283796747372\n      },\n      {\n        \"anio\": 2020,\n        \"observations\": 3730,\n        \"activo_total_mean\": 38551402.08203753,\n        \"activo_total_median\": 9490817.0,\n        \"pasivo_total_mean\": 25188426.702680964,\n        \"pasivo_total_median\": 6114408.5,\n        \"patrimonio_mean\": 13362975.379356569,\n        \"patrimonio_median\": 1862213.0,\n        \"ingresos_mean\": 9779785.514745308,\n        \"ingresos_median\": 1401007.0,\n        \"utilidad_neta_mean\": 824839.2,\n        \"utilidad_neta_median\": 43942.5,\n        \"liquidez_corriente_mean\": 508.0180909224599,\n        \"liquidez_corriente_median\": 2.2718535909054673,\n        \"endeudamiento_mean\": 0.841191906722493,\n        \"endeudamiento_median\": 0.7340811942594845,\n        \"roa_mean\": -0.25895988374587536,\n        \"roa_median\": 0.004600724239554229\n      },\n      {\n        \"anio\": 2021,\n        \"observations\": 3586,\n        \"activo_total_mean\": 57801129.63552705,\n        \"activo_total_median\": 10874419.0,\n        \"pasivo_total_mean\": 37819459.33658673,\n        \"pasivo_total_median\": 6690506.0,\n        \"patrimonio_mean\": 19981670.298940323,\n        \"patrimonio_median\": 2289987.0,\n        \"ingresos_mean\": 19703777.6514222,\n        \"ingresos_median\": 1799391.0,\n        \"utilidad_neta_mean\": 2804294.993028444,\n        \"utilidad_neta_median\": 57664.0,\n        \"liquidez_corriente_mean\": 101.36602071262382,\n        \"liquidez_corriente_median\": 2.4945498931972736,\n        \"endeudamiento_mean\": 0.7537476097121585,\n        \"endeudamiento_median\": 0.7222679509937353,\n        \"roa_mean\": -0.32611452943599745,\n        \"roa_median\": 0.005683360642765728\n      },\n      {\n        \"anio\": 2022,\n        \"observations\": 3347,\n        \"activo_total_mean\": 50001067.208246194,\n        \"activo_total_median\": 12554495.0,\n        \"pasivo_total_mean\": 33581006.413803406,\n        \"pasivo_total_median\": 7303694.0,\n        \"patrimonio_mean\": 16420060.794442784,\n        \"patrimonio_median\": 2819985.0,\n        \"ingresos_mean\": 14447370.184642963,\n        \"ingresos_median\": 1984365.0,\n        \"utilidad_neta_mean\": 1493354.0026889753,\n        \"utilidad_neta_median\": 78321.0,\n        \"liquidez_corriente_mean\": 99.76263327334226,\n        \"liquidez_corriente_median\": 2.646439159160074,\n        \"endeudamiento_mean\": 0.744017782102341,\n        \"endeudamiento_median\": 0.7019849917813468,\n        \"roa_mean\": -0.10367878083601505,\n        \"roa_median\": 0.007067920172218352\n      },\n      {\n        \"anio\": 2023,\n        \"observations\": 3100,\n        \"activo_total_mean\": 57456729.26741935,\n        \"activo_total_median\": 14330198.0,\n        \"pasivo_total_mean\": 39627360.45612903,\n        \"pasivo_total_median\": 8365789.0,\n        \"patrimonio_mean\": 17829368.811290324,\n        \"patrimonio_median\": 3162193.5,\n        \"ingresos_mean\": 18006140.872580644,\n        \"ingresos_median\": 1966167.0,\n        \"utilidad_neta_mean\": 871930.0003225807,\n        \"utilidad_neta_median\": 87432.5,\n        \"liquidez_corriente_mean\": 712.8466560068642,\n        \"liquidez_corriente_median\": 2.60493137022276,\n        \"endeudamiento_mean\": 0.7927512524158177,\n        \"endeudamiento_median\": 0.6932177102046027,\n        \"roa_mean\": -0.00918551514190065,\n        \"roa_median\": 0.006654948454052103\n      },\n      {\n        \"anio\": 2024,\n        \"observations\": 2735,\n        \"activo_total_mean\": 66087287.21791591,\n        \"activo_total_median\": 17598511.0,\n        \"pasivo_total_mean\": 44167297.02266911,\n        \"pasivo_total_median\": 9689062.0,\n        \"patrimonio_mean\": 21919990.1952468,\n        \"patrimonio_median\": 4149142.0,\n        \"ingresos_mean\": 20201403.724680074,\n        \"ingresos_median\": 2550277.0,\n        \"utilidad_neta_mean\": 1746497.4120658136,\n        \"utilidad_neta_median\": 99491.0,\n        \"liquidez_corriente_mean\": 91.52477257213758,\n        \"liquidez_corriente_median\": 2.620326630214926,\n        \"endeudamiento_mean\": 0.6584396215088505,\n        \"endeudamiento_median\": 0.6815823127387115,\n        \"roa_mean\": -0.014026484038381947,\n        \"roa_median\": 0.006309059372721979\n      }\n    ],\n    \"comparative\": {\n      \"baseline_period\": [\n        2017,\n        2018,\n        2019\n      ],\n      \"stress_period\": [\n        2020,\n        2021,\n        2022,\n        2023,\n        2024\n      ],\n      \"delta_ingresos_mean\": 323572.45077140257,\n      \"baseline_roa_mean\": -6.082835656375712,\n      \"stress_roa_mean\": -0.1545040955022502\n    },\n    \"inference\": {\n      \"pearson_ingresos_activos\": 0.6984231380587855,\n      \"pearson_roa_endeudamiento\": -0.04754505509647327,\n      \"sample_size\": 20902,\n      \"methodological_note\": \"Inferencia exploratoria; no se presentan p-values como verdad fuerte en esta capa base.\"\n    },\n    \"reliability\": {\n      \"coverage\": {\n        \"activo_total\": 1.0,\n        \"pasivo_total\": 1.0,\n        \"ingresos\": 1.0,\n        \"utilidad_neta\": 1.0,\n        \"activo_corriente\": 0.37705702257941065,\n        \"pasivo_corriente\": 0.37705702257941065\n      },\n      \"warnings\": []\n    }\n  },\n  \"diagnostic\": {\n    \"ciiu\": \"41\",\n    \"native\": {\n      \"executive_readout\": \"Existe base observada suficiente para producir un resumen ejecutivo inicial.\",\n      \"findings\": [\n        \"Existe base observada suficiente para producir un resumen ejecutivo inicial.\"\n      ],\n      \"alerts\": [\n        \"Rentabilidad promedio negativa en el ultimo anio observado.\",\n        \"Endeudamiento promedio alto frente al umbral base del backend.\"\n      ],\n      \"pain_points\": [\n        \"Rentabilidad promedio negativa en el ultimo anio observado.\",\n        \"Endeudamiento promedio alto frente al umbral base del backend.\"\n      ],\n      \"recommendations\": [\n        \"Separar bloques observados y heredados al consumir este diagnostico.\",\n        \"Revisar cobertura de corrientes antes de interpretar liquidez como observable.\"\n      ]\n    },\n    \"legacy_context\": \"No hay suficiente información para formular el problema cuantitativo.\",\n    \"warnings\": [\n      \"Las recomendaciones automáticas son explicables y separan contexto nativo de legado.\"\n    ]\n  }\n}"},"coverage":{"year_start":2017,"year_end":2024,"available_years":[2017,2018,2019,2020,2021,2022,2023,2024],"coverage_ratio":1.0,"data_state":"observado","comparability":"ventana_comparable_observada","sources":["diagnostico_manual_legacy","supersociedades_financials"],"warnings":["La ventana observada extendida excede la interseccion comparable integrada."]},"provenance":null,"warnings":[]}