PRIVATE Marathon Pacing Study export 20260912-0934

PRIVATE export — includes runner names. Intended for trusted offline analysis agents. Do not commit names into the public site tree.

Freeze stamp	20260912-0934
Tag	private-export-20260912-0934
n_records	4,462,379
cities	34
race_years	256
max(ingested_at)	2026-09-12T10:00:03Z
Freeze wall-clock (ET)	2026-09-12T09:34:49-04:00
Freeze sqlite sha256	b5da2f6557eec5bf382f291f86c040cf50302cbaa55aa248f076c723f9cd822f

Δ vs private-export-20260911-1107

• +254,923 records (4,207,456 → 4,462,379)
• +16 race-years (240 → 256); cities unchanged (34)
• New ids only; 0 deleted; 0 updated same-id rows
• Features 1:1 with CORE ids (record_id = race_records.id)

Website

• Website pin unchanged. No live.json PUT. Live ingest was not interrupted.

Assets

• htw-private-export-CORE-*.tar.gz — 8 CORE files
• htw-private-export-FULL-*.tar.gz — CORE 8 byte-identical + features.parquet
• Standalone features.parquet, race_records.parquet, overlays, docs, SHA256SUMS.txt, audits-*-freeze.zip, freeze *.sqlite.gz

Anonymous downloads enabled (public release assets).

Private export 20260911-1107

Private synchronized export for Andrew’s website analysis agent / Wall Analyst consumers.

Vintage: freeze snapshot private-export-20260911-1107
Freeze wall-clock (ET): 2026-09-11T11:07:22-04:00 (UTC 2026-09-11T15:07:22Z)
Integrity: PRAGMA integrity_check = ok
n_records / n_features: 4,207,456 (1:1; set equality on record_id = race_records.id)
Cities / race-years: 34 / 240
max(ingested_at): 2026-09-11T15:04:44Z
Canonical ID: features.record_id = race_records.id (NOT 0..n-1 row index)
valid_splits: 3,326,908
HTW among valid: 1,022,545 (~30.74%)
features: race + runner_name retained (9 runner_name nulls)

vs prior private-export-20260911-0336

• New ids: +228,796 · deleted: 0 · updated same id: 0
• New editions: Chicago 2016/2017, Cologne 2016/2017, Hamburg 2025, New York 2008 (partial, n=200 live ingest), 2009, 2010

Archives (importer-compatible; analysis/download_release.py expects 8/9 members)

• htw-private-export-CORE-20260911-1107.tar.gz — exactly 8 files at archive root
• htw-private-export-FULL-20260911-1107.tar.gz — same 8 + features.parquet (9). Shared 8 are byte-identical to CORE.

Standalone assets

• parquet copies + freeze sqlite.gz + ID-CONTRACT / COUNT-DIFF / FEATURE-FIELD-NOTES / README / MANIFEST
• audits-20260911-1107-freeze.zip + RELEASE-SHA256SUMS.txt

Do not commit runner names to the public tree. Website pin / deploy unchanged.

Private export 20260911-0336

Private synchronized export for outside analyzer / Wall Analyst consumers.

Vintage: freeze snapshot private-20260911-0336
n_records / n_features: 3,978,660 (1:1; set equality on record_id = race_records.id)
Cities / race-years: 34 / 232
Canonical ID: features.record_id = race_records.id (NOT 0..n-1 row index)
valid_splits: 3,110,426
features: race + runner_name retained (9 runner_name nulls)

Archives (importer-compatible; analysis/download_release.py expects 8/9 members)

• htw-private-export-CORE-20260911-0336.tar.gz — exactly 8 files at archive root
• htw-private-export-FULL-20260911-0336.tar.gz — same 8 + features.parquet (9). Shared 8 are byte-identical to CORE.

Standalone assets

• parquet copies + freeze sqlite.gz + ID-CONTRACT / COUNT-DIFF / FEATURE-FIELD-NOTES
• audits-20260911-0336-freeze.zip + RELEASE-SHA256SUMS.txt

Do not commit runner names to the public tree. Website pin / deploy unchanged.

htw-db-2026-09-11

Daily HTW race DB backup (2026-09-11 08:03 EDT).

• race_records: 4162816
• live path left in place: /workspace/race-data-platform/data/platform.sqlite
• asset: htw-db-2026-09-11.sqlite.gz (528M)

Private export 20260910-1412 (synchronized CORE+FULL)

Private synchronized export for outside analyzer / Wall Analyst consumers.

Vintage: freeze snapshot private-20260910-1412
n_records / n_features: 3,580,279 (1:1)
Cities / race-years: 33 / 207
Canonical ID: features.record_id = race_records.id (NOT 0..n-1 row index)
valid_splits: 2,807,231

Archives (importer-compatible names)

• htw-private-export-CORE-20260910-1412.tar.gz
• htw-private-export-FULL-20260910-1412.tar.gz (includes features + COUNT-DIFF + FEATURE-FIELD-NOTES)

Separate audit assets (not inside archives)

• split exclusion / checkpoint null reports
• RELEASE-ASSETS-NOTE

Do not commit runner names to the public tree. Sight/site publish still gated until Lead verifies.

HTW DB backup 2026-09-10

Daily snapshot of platform.sqlite (gzipped). n_records≈3543512. Live DB untouched.

Private data export 2026-09-07 (names included)

Private analysis export (runner names included)

Bundle id: private-20260907-1318
Corpus: 3,451,055 race_records · 33 cities · 203 race-years

Assets

• htw-private-export-CORE-20260907-1318.tar.gz (~115MB) — race_records + overlays + sources + summary (start here)
• htw-private-export-FULL-20260907-1318.tar.gz (~994MB) — CORE + Analyst features.parquet
• OUTSIDE-AGENT-PASTE-BRIEF.md — instructions for outside AI agents

Do not make this repo or release public. Invite collaborators only.

HTW DB 2026-09-06

Daily off-machine backup of live platform.sqlite (America/New_York).

• Records (race_records): 2,169,026
• Sources: 364
• Health: ok at backup time
• Asset: platform-2026-09-06.sqlite.gz

Live DB left in place for ingest; this is a copied snapshot.

HTW DB 2026-09-05

Wave backup ~1.81M records. Live platform.sqlite left on box.

HTW DB recovered backup 2026-09-04

Recovered via sqlite .recover; integrity ok; n_records=1578465; cities=31; race_years=129; sources=351; live file left in place for ingest.

Morning tag htw-db-2026-09-04 was a pre-recovery/corrupt snapshot — use this release instead.