# Mexico (mex) — HANDOFF

## Settled next-election call
| field | value |
|---|---|
| next national contest | **2027 federal midterms — 2027-06-06** |
| `date_confidence` | **`announced_media`** |
| `cycle_status` | **`distant`** *(filed as instructed — see conflict below)* |
| `election_id` | `mex-dip-2027` |

Full 500-seat Cámara de Diputados (300 MR + 200 RP). Mexican federal elections fall on the **first
Sunday of June**, which in 2027 is 6 June.

`date_confidence=announced_media` as instructed. Honest caveat: this pack **did not recover a stable
official INE calendar PDF/resolution URL** for the 2026–2027 process. Do not upgrade to
`confirmed_official` until that INE acuerdo is cited.

## ⚠️ `cycle_status` conflicts with SCHEMA.md — one-field decision needed
- **Filed value: `distant`**, exactly as the task brief specified.
- **SCHEMA.md would say `active`**: 2027-06-06 is **276 days** after 2026-09-03, and the schema
  defines `active` = 91–365 days, `distant` = >365 days. 276 falls in the `active` band.

I followed the explicit instruction rather than silently overriding it, but this is the one field in
the Mexico pack I would expect to be flipped. It is recorded in `elections.csv.notes`, in
`STATS.json.cycle_status_conflict`, and here. Changing it is a **single-cell edit** on `mex-dip-2027`.

## money-edges.csv is POPULATED — 3,392 rows, MXN as filed
The 404 in the earlier attempt was a dead path; **the real portal was re-found by probing** and is
cited in full in SOURCES.md. Nothing was invented.

**What the rows are.** INE UTF **PREFO 2023–2024, CAMPAÑA, "Ingresos por Rubro"**: for each of
**1,309 candidate accounting records** (`ID DE CONTABILIDAD`), the campaign's income split by
**income category**. One CSV cell → one edge. Zero/blank cells dropped.
- `committee_name` = `NOMBRE COMPLETO` (the candidate's SIF account name)
- `connected_org` = the **income rubro** (the category column header)
- `edge_type` = `donation`
- `amount` = MXN **exactly as filed**, no conversion, no rounding beyond the source's 2 decimals
- `as_filed_note` carries `ID DE CONTABILIDAD`, `CARGO`, `ESTADO ELECCION`, `SUJETO OBLIGADO`,
  `SIGLAS` and the category name verbatim

**Two limits, stated plainly:**
1. These are **category aggregates, not itemized donors**. There is no individual donor name or
   date. Do not render these as "who gave to whom".
2. **`person_id` is deliberately blank on all 3,392 rows.** SIF accounting ids do not join to SITL /
   Senate roster ids, and SCHEMA.md forbids name fuzzy-matching between money and roster
   ("Match people by official id, never by name fuzzy-match"). Leaving it null is the schema-correct
   choice, not an oversight.
3. Scope is the **2024** cycle (`cycle=2023-2024`), attached to `mex-cong-2024`. No 2027 finance
   exists yet.

## polls.csv is EMPTY — 0 rows
No published 2027-midterm topline was captured from a first-party pollster publication. Rather than
cite a news aggregation or a Wikipedia poll table (explicitly barred), the file is header-only.
Mexican 2027 legislative polling is thin this far out; presidential-approval tracking exists but is
**not** a 2027 vote-intention topline and was not filed as one.

## results.csv notes — 5,598 rows, official and verified
INE Cómputos Distritales 2024 bulk database, three contests:
- **Presidential** (`mex-pres-2024`) — 32 entidades. **Verified**: Sheinbaum **35,924,519 (59.76%)**,
  Gálvez 16,502,697 (27.45%), Máynez 6,204,710 (10.32%) on 60,115,184 total — matches INE's published
  national figures.
- **Diputaciones** (`mex-cong-2024`) — 300 distritos federales, 171,643 actas.
- **Senadurías** (`mex-cong-2024`) — 32 entidades, 171,794 actas.

Grain: one row per **candidate (or coalition-party bundle) per constituency**.
- Coalition votes: where a candidate ran on several parties, per-party columns are **summed into one
  candidate row** and `party` shows the bundle joined with `+` (e.g. `PVEM+PT+MORENA`).
- `[VOTOS NULOS]` / `[CANDIDATO/A NO REGISTRADO/A]` are kept as bracketed `party` labels with blank
  `candidate`, so real-candidate shares sum to 1.0 within a constituency.
- `person_id` blank throughout — the computos database carries no roster id.

## Data-quality fixes applied
- **Mojibake fixed.** SITL declares `ISO-8859-1` but serves UTF-8; names arrived as
  `Abreu Artiñano Rocío Adriana`. Re-encoded `latin-1` → decoded `utf-8`, plus HTML-entity
  unescaping (`Representación proporcional`). Verified: `Abreu Artiñano Rocío Adriana`.
- **Metadata artifact dropped.** A stray `FECHA_HORA` pseudo-candidate with 0 votes leaked from a
  column-count mismatch in the senadurías file; junk metadata labels with 0 votes are now filtered.
- Senate party split verified: MORENA 67, PAN 21, PVEM 14, PRI 13, MC 6, PT 6, sin grupo 1 = 128.

## Gaps / next steps
- `people.csv` is **incumbents only** (628). Correct per SCHEMA.md: no 2027 candidate list exists.
  `candidaturas.ine.mx` responds 200 but only carries **2024** candidacies; it was not filed as a
  2027 candidate source.
- `bio_text` empty for all — SITL curricula are inconsistent free text; not paraphrased.
- The SIF `OYG` (totals) and `GxR` (spend-by-rubro) files are downloaded in `mex/raw/` but **not**
  loaded. Loading `GxR` would add expenditure edges; it needs an `edge_type` that is not `donation`.

## Repair note — 2026-09-03
- Restored 44 staged Mexican option rows; all are congressional preference and remain attached to mex-dip-2027. Added published El Financiero presidential approval/problem toplines. mex-dip-2027 cycle_status is now active per SCHEMA.md; STATS.json conflict key removed.