Reporte de calidad de datos

2026-09-09T05:35:55.384915+00:00 · pytest: 16 passed in 1.37s · 122 tablas DuckDB · 192 variables municipales · share de celdas imputadas 9.6%

13 familias de tests

EstadoTest
PASSEDtest_universo_1122_municipios
PASSEDtest_cotas_lb_le_ub
PASSEDtest_theta_dentro_de_cotas_y_rango
PASSEDtest_intervalos_ordenados
PASSEDtest_nowcast_nacional_plausible
PASSEDtest_indices_rango_y_cuadrantes
PASSEDtest_observations_lineage
PASSEDtest_money_map_monotono
PASSEDtest_supuestos_marcados
PASSEDtest_geo_pesos_y_moran
PASSEDtest_corredores_particion
PASSEDtest_social_sin_pii_y_shares
PASSEDtest_channel_best_distinto
PASSEDtest_top20_tabla
PASSEDtest_manifest_figuras
PASSEDtest_informe_html

Cobertura del corpus social

{"n": 12723, "con_fecha": 5701, "con_geo_mpio": 3075, "con_geo_dpto": 3976}

Variables con menor completitud (top 25)

VariableCompletitud
men_sedes_conectadas_a_internet_20240.0%
men_tamano_promedio_de_grupo_20240.0%
icfes_punt_global_20240.0%
icfes_n_20240.0%
icfes_share_nocturna_sabatina0.0%
icfes_share_no_oficial0.0%
pop_total_201899.9%
niv_share_prim_o_menos99.9%
cota_ub_sin_media_share99.9%
cota_lb_sin_media_share99.9%
cota_ub_sin_media_n99.9%
cota_lb_sin_media_n99.9%
lb_share_18p99.9%
ub_share_18p99.9%
lb_18p99.9%
ub_18p99.9%
pop_18p_con_nivel99.9%
cod_mpio100.0%
cod_dpto100.0%
nombre_mpio100.0%
nombre_dpto100.0%
tipo100.0%
is_anm100.0%
is_capital_dpto100.0%
is_distrito100.0%

Bloqueos y accesos denegados

- [search] `secretaría de educación Amazonas educación de adultos CLEI` → timeout
- [search] `San Andrés y Providencia matrícula ciclos adultos 2026 circular` → timeout
- [search] `plan de desarrollo Vichada educación de adultos meta` → timeout
- [search] `site:reddit.com/r/Bogota CLEI` → No results found.
- [search] `site:reddit.com/r/Cali bachillerato adultos` → No results found.
- [search] `site:reddit.com/r/Cali validar bachillerato` → No results found.
- [search] `site:reddit.com/r/medellin CLEI` → No results found.
- [search] `site:reddit.com/r/Cali terminar bachillerato` → No results found.
- [search] `site:reddit.com/r/Cali CLEI` → No results found.
- [search] `site:reddit.com/r/Cali bachillerato virtual` → No results found.
- [search] `site:reddit.com/r/Cali no terminé el colegio` → No results found.
- [search] `site:reddit.com/r/Barranquilla validar bachillerato` → No results found.
- [search] `site:reddit.com/r/Barranquilla CLEI` → No results found.
- [search] `site:reddit.com/r/Bucaramanga validar bachillerato` → No results found.
- [search] `site:reddit.com/r/Bucaramanga no terminé el colegio` → No results found.
- [search] `site:reddit.com/r/Bucaramanga CLEI` → No results found.
- [scrape] `https://www.medellin.gov.co/es/centro-documental/tarifas-de-liquidacion-del-impuesto-de-industria-y-comercio-ica` → Error: The URL failed to load in the browser with error code "ERR_TUNNEL_CONNECTION_FAILED". Firecrawl encountered an internal proxy error while establishing the tunnel. This is an internal Firecrawl
- [scrape] `https://seducacion.cordoba.gov.co/` → Error: All scraping engines failed to retrieve content from this URL. Engines tried: [index, fire-engine;chrome-cdp, fire-engine(retry);chrome-cdp]. This usually happens when: (1) The URL is invalid o
- [scrape] `https://educacion.alcaldiafusagasuga.gov.co/` → Scrape ID: 01a0839c-e6d5-7250-99e2-e330695d654e
- [scrape] `https://sedcauca.gov.co/` → Error: The URL failed to load in the browser with error code "ERR_TUNNEL_CONNECTION_FAILED". Firecrawl encountered an internal proxy error while establishing the tunnel. This is an internal Firecrawl
- [map] `https://meta.gov.co` → Error: We apologize for the inconvenience but we do not support this site. If you are part of an enterprise and want to have a further conversation about this, please fill out our intake form here: ht
- [scrape] `https://villavicencio.gov.co/abren-inscripciones-de-cursos-para-adultos-mayores-y-madres-cuidadoras` → Error: All scraping engines failed to retrieve content from this URL. Engines tried: [index, index;documents, fire-engine;chrome-cdp;stealth, fire-engine(retry);chrome-cdp;stealth, pdf, document, imag
- [scrape] `https://sempitalito.gov.co/web/` → Error: All scraping engines failed to retrieve content from this URL. Engines tried: [index, fire-engine;chrome-cdp, fire-engine(retry);chrome-cdp]. This usually happens when: (1) The URL is invalid o
- [scrape] `https://www.sedtolima.gov.co/normatividad/resoluciones` → Error: All scraping engines failed to retrieve content from this URL. Engines tried: [index, index;documents, fire-engine;chrome-cdp;stealth, fire-engine(retry);chrome-cdp;stealth, pdf, document, imag

Conteo de filas por tabla

TablaFilas
bronze_apify_google352
bronze_apify_maps1,012
bronze_apify_tiktok451
bronze_apify_youtube412
bronze_apify_youtube_comments2,084
bronze_arcgis_cnpv2018_clases_integradas3,155
bronze_arcgis_cnpv2018_departamentos_integrados33
bronze_arcgis_cnpv2018_municipios_integrados1,122
bronze_arcgis_cnpv2018_sector_rural_integrado7,060
bronze_arcgis_cnpv2018_zona_urbana_integrada7,644
bronze_arcgis_niveduca_cabecera_doctorado_20181,102
bronze_arcgis_niveduca_cabecera_especializada_20181,102
bronze_arcgis_niveduca_cabecera_maestria_20181,102
bronze_arcgis_niveduca_cabecera_normal_20181,102
bronze_arcgis_niveduca_cabecera_prim_20181,102
bronze_arcgis_niveduca_cabecera_secundaria_20181,102
bronze_arcgis_niveduca_cabecera_tecnica_20181,102
bronze_arcgis_niveduca_cabecera_tecnologo_20181,102
bronze_arcgis_niveduca_cabecera_universitaria_20181,102
bronze_divipola_gdxc_w37w1,122
bronze_divipola_xlsx1,122
bronze_dnp_nkjx_rsq722,020
bronze_educ23_desplazados29,681
bronze_educ23_docentes_clei2,175
bronze_educ23_etnicos36,522
bronze_educ23_flexibles60,836
bronze_educ23_matricula_edad421,731
bronze_educ23_matricula_jornada_nivel129,968
bronze_educ23_poblacion_especial260,664
bronze_educ23_sedes55,401
bronze_educ23_servicio129,046
bronze_firecrawl_scrape504
bronze_firecrawl_search4,015
bronze_icfes_kgxf_xxbe_agg_colegio_mpio34,576
bronze_icfes_kgxf_xxbe_agg_jornada_nacional232
bronze_icfes_kgxf_xxbe_agg_residencia_mpio14,319
bronze_manifest74
bronze_men_55ui_fvbb205
bronze_men_5c2k_ahfc7,850
bronze_men_establecimientos_cfw5606,206
bronze_men_ji8i_4anb462
bronze_men_nudc_7mev15,707
bronze_men_pvpi_9wjb70
bronze_men_sras_4t5p1,336
bronze_men_upgu_2ytp29,408
bronze_men_y9ga_zwzy19,618
bronze_mintic_9mey_c8s8407,281
bronze_mintic_n48w_gutb2,795,052
bronze_proy_pped_areamun_2018_2042_vp84,225
bronze_proy_pped_areasexoedadmun_2018_2042_vp84,225
bronze_ruv_9qih_4vkc_agg_mpio_hecho85,663
bronze_secop_jbjy_vk9h_CLEI132
bronze_secop_jbjy_vk9h_alfabetizacion180
bronze_secop_jbjy_vk9h_ciclos_lectivos_especiales_integrados94
bronze_secop_jbjy_vk9h_educacion_de_adultos723
bronze_secop_jbjy_vk9h_educacion_de_adultos_acc1,867
bronze_secop_jbjy_vk9h_jovenes_en_extraedad4
bronze_secop_jbjy_vk9h_jovenes_en_extraedad_acc25
bronze_secop_jbjy_vk9h_modelo_educativo_flexible305
bronze_secop_jbjy_vk9h_validacion_del_bachillerato2
bronze_secop_rpmr_utcd_CLEI743
bronze_secop_rpmr_utcd_alfabetizacion2,274
bronze_secop_rpmr_utcd_ciclos_lectivos_especiales_integrados261
bronze_secop_rpmr_utcd_educacion_de_adultos5,542
bronze_secop_rpmr_utcd_educacion_de_adultos_acc2,255
bronze_secop_rpmr_utcd_jovenes_en_extraedad337
bronze_secop_rpmr_utcd_jovenes_en_extraedad_acc41
bronze_secop_rpmr_utcd_modelo_educativo_flexible895
bronze_secop_rpmr_utcd_validacion_del_bachillerato33
bronze_sedes_65zu_5xdk2,852
bronze_sedes_7g6s_xche204
bronze_sedes_c56g_ubd21,420
bronze_sedes_qnhy_zizv70
bronze_sedes_tgsp_kujm7,164
bronze_sedes_y3rh_2hj3491
cnpv_personas_manifest33
dim_dataset44
dim_etc97
dim_source81
dim_territory1,122
fact_bachilleres6,729
fact_capa0_cells104,559
fact_capa0_mpio1,122
fact_capa1_mpio1,122
fact_clei_mpio_20233,907
fact_clusters1,122
fact_cnpv2018_clase3,155
fact_cnpv2018_dpto33
fact_cnpv2018_mpio1,122
fact_cnpv2018_niveduca_cabecera9,455
fact_cnpv2018_personas_agg1,086,786
fact_cnpv2018_personas_ctx2,882,060
fact_cnpv2018_sector_rural7,060
fact_cnpv2018_zona_urbana7,644
fact_cobertura_movil1,121
fact_docentes_clei_mpio_2023547
fact_establecimientos192,438
fact_estimates_mpio1,122
fact_flexibles_mpio_20232,845
fact_geih_dpto_202533
fact_geih_split_cells1,597
fact_indices1,122
fact_internet_fijo129,560
fact_ipm_censal_20181,122
fact_matricula_edad_2023421,731
fact_matricula_grado_mpio_202314,557
fact_men_dpto462
fact_men_etc1,336
fact_men_municipal513,083
fact_men_municipal_wide15,707
fact_ml_predictions1,122
fact_proyecciones_mun11,342,300
fact_secop_epja11,739
fact_secop_epja_resolved11,739
fact_sedes_202355,401
fact_supply_maps1,012
map_mpio_etc1,124
municipal_master1,122
observations744,782
revenue_map1,122
social_conversations_raw12,907
temporal_trends7,854