Fundaciones ↔ Hospitals — Matching Report

Parsed the free-text Fundaciones column in hospitals.csv and matched against fundaciones.csv (92 entries) and instituciones.csv (23 entries) from the Hospitals Source spreadsheet.

150

Hospitals

44

Have text

68

Source matches

49

External mentions

26

Unique source

66

Unmatched fund.

23

Unmatched inst.

In source (fundaciones/instituciones CSV) External (mentioned by hospital, not in source) No match / gap

Source Matches — Fundaciones in CSV

These entities exist in fundaciones.csv or instituciones.csv AND were mentioned by at least one hospital.

External Mentions — Not in Source

Mentioned by hospitals but not found in the Fundaciones/Instituciones tabs. Candidates to add?

Hospital-by-Hospital Matches

Only showing the 44 hospitals with fundaciones text. Hover raw text to expand. Sorted by match count.

HCODE	Hospital	State	Matches	Src	Ext	Raw text

Unmatched Fundaciones (66 of 92)

In the Fundaciones tab but NOT mentioned by any hospital. Many are regional AMANC branches.

Code	Name	Short

Unmatched Instituciones (23 of 23)

Zero instituciones were mentioned in the hospital Fundaciones column. The column name may only cover fundaciones.

Code	Name

Analysis

Coverage gap: Only 44 of 150 hospitals (29%) have any fundaciones data. Of those, 4 explicitly say "No".
CDLA dominates: Casa de la Amistad appears in 23 hospitals (52% of those with data) — by far the most connected fundación.
AMANC network: AMANC México appears 15 times generically, plus 3 state-specific branches (Quintana Roo, Yucatán, Michoacán). The other ~20 AMANC branches in the source have no hospital match — either unlinked or hospitals reference "AMANC" generically.
"Nariz Roja" missing from source: Mentioned by 5 hospitals but not in fundaciones.csv — a notable gap.
Instituciones irrelevant here: Zero instituciones appear in the hospital Fundaciones column. The column captures supporting NGOs/charities, not government institutions — so the two datasets serve different purposes.
Free-text chaos: The Fundaciones column mixes names with descriptions of services, amounts, bullet points, and even "we'd like to start collaborating." Structured data entry would help.
66 fundaciones with no hospital: Many are AMANC state branches, but also standalone orgs like Fundación ABC, Teletón, PAHO — these may support hospitals not captured in this column, or may be inactive.