Sankey Findings: Región Assignment Anomalies
Generated from hospital Sankey diagram development. Each HCODE links to the hospital page.
1. REGION
2. REGION CDLA
3. Delta
1. REGION (Región MAS) — 5 regiones + blanks
6 states have hospitals assigned to multiple regiones ·
4 hospitals have no región at all ·
15 hospitals total with questionable assignments
1a. Hospitals Without a Región (REGION blank)
These 4 hospitals have an empty REGION field and show as "Sin Región" in the Sankey diagram.
HCODE City State Likely Región?
MXL Mexicali
Baja California
Noroeste — all other BC hospitals are Noroeste
PCF Monterrey
Nuevo León
Noreste — 8 other NL hospitals are Noreste
PGC Cancún
Quintana Roo
Sureste — other QR hospitals are mostly Sureste
PVO San Pedro
Nuevo León
Noreste — 8 other NL hospitals are Noreste
1b. Multi-Región States
These states have hospitals assigned to different regiones. The highlighted rows are the minority assignments.
HCODE Name City Región COP COP Tijuana Noroeste IBC IBC Tijuana Noroeste IQO IQO Tijuana Noroeste ITJ ITJ Tijuana Noroeste TCA TCA Tijuana Noroeste TIJ Tijuana Tijuana Noroeste MXL MXL Mexicali Sin Región
4 Puente hospitals assigned to Centro despite being in Jalisco.
HCODE Name City Región FAA Alcalde Guadalajara Occidente GDL Civil nuevo Guadalajara Occidente OCC CMNO Guadalajara Occidente PMA PMA Guadalajara Occidente SGF SGF Zapopan Occidente ZQP Zoquipan Guadalajara Occidente PLC PLC Zapopan Centro PPH PPH Zapopan Centro PSJ PSJ Guadalajara Centro PVR PVR Zapopan Centro
HCODE Name City Región CNV CNV San Nicolás de los Garza Noreste DCH DCH Monterrey Noreste INE INE Monterrey Noreste MTY Monterrey Monterrey Noreste PCM PCM Monterrey Noreste SMT SMT Monterrey Noreste TEC TEC Monterrey Noreste ZHE ZHE Monterrey Noreste MNL MNL Guadalupe Centro PCF PCF Monterrey Sin Región PVO PVO San Pedro Sin Región
HCODE Name City Región IPB IPB Puebla Centro PUE Puebla Puebla Centro SPB SPB Puebla Centro TPB TPB Puebla Centro PAU PAU Puebla Occidente POP POP Puebla Occidente
HCODE Name City Región CTM CTM Chetumal Sureste CUN CUN Cancún Sureste ICN ICN Cancún Sureste BOC BOC Chetumal Occidente PGC PGC Cancún Sin Región
HCODE Name City Región CCV CCV Tampico Noreste CVM Tamaulipas Cd. Victoria Noreste IRY IRY Reynosa Noreste MIR MIR Reynosa Noreste HAT HAT Cd. Victoria Sureste
2. REGION CDLA (Región CDLA) — 4 regiones + blanks
1 state with multiple regiones ·
2 hospitals with no región ·
Much cleaner than REGION
2a. Hospitals Without a Región (REGION CDLA blank)
Only 2 hospitals have blank REGION CDLA (down from 4 in REGION). Both are in Nuevo León.
HCODE City State REGION (for reference)
PCF Monterrey
Nuevo León
Sin Región (also blank in REGION)
PVO San Pedro
Nuevo León
Sin Región (also blank in REGION)
2b. Multi-Región States
Only 1 state has hospitals in multiple CDLA regiones (down from 6 in REGION).
The 2 blank hospitals (PCF, PVO) are the only anomaly. MNL was reassigned from Centro to Norte.
HCODE Name City CDLA Región CNV CNV San Nicolás de los Garza Norte DCH DCH Monterrey Norte INE INE Monterrey Norte MNL MNL Guadalupe Norte MTY Monterrey Monterrey Norte PCM PCM Monterrey Norte SMT SMT Monterrey Norte TEC TEC Monterrey Norte ZHE ZHE Monterrey Norte PCF PCF Monterrey Sin Región PVO PVO San Pedro Sin Región
3. REGION vs REGION CDLA — What Changed
53 hospitals changed región ·
Multi-región states: 6 → 1 ·
Blanks: 4 → 2 ·
Regiones: 5 → 4
3a. Structural Change
The biggest change: Noroeste and Noreste were merged into a single Norte región (43 hospitals). Several border-state hospitals were also reassigned between neighboring regiones.
3b. Región Size Comparison
Región REGION REGION CDLA Change Centro 44 41 −3 Noroeste 23 — merged into Norte Noreste 19 — merged into Norte Norte — 43 new (from Noroeste + Noreste + 1 blank) Occidente 30 33 +3 Sureste 30 31 +1 Sin Región 4 2 −2 (MXL→Norte, PGC→Sureste)
3c. All 53 Changed Hospitals
Grouped by the type of change.
Noroeste → Norte (23 hospitals)
All 23 Noroeste hospitals moved to Norte. States: Baja California (6), Baja California Sur (2), Chihuahua (2), Sinaloa (4), Sonora (9).
Noreste → Norte (14 hospitals)
Most Noreste hospitals moved to Norte. States: Coahuila (2), Durango (3), Nuevo León (8), Tamaulipas (1 — HAT stayed Noreste→Norte, the rest went to Norte too).
Border reassignments (16 hospitals)
HCODE State City REGION REGION CDLA PLC Jalisco Zapopan Centro → Occidente PPH Jalisco Zapopan Centro → Occidente PSJ Jalisco Guadalajara Centro → Occidente PVR Jalisco Zapopan Centro → Occidente PAU Puebla Puebla Occidente → Centro POP Puebla Puebla Occidente → Centro BOC Quintana Roo Chetumal Occidente → Sureste HAT Tamaulipas Cd. Victoria Sureste → Norte IDS San Luis Potosí San Luis Potosí Noreste → Occidente SLP San Luis Potosí San Luis Potosí Noreste → Occidente MNL Nuevo León Guadalupe Centro → Norte
Gained a región (2 hospitals)
HCODE State City REGION REGION CDLA MXL Baja California Mexicali Sin Región → Norte PGC Quintana Roo Cancún Sin Región → Sureste