King Hippopotamus

Evidence record

Data acquisition at scale

Every published claim on this page was checked by running the command shown. Claims that did not pass were withdrawn before publication; their count is stated below and the full record is available on request.

Measured 2026-08-23 · figures expire with the next publish run; the site is rebuilt from one figures ledger.

Research artifact · published claims

ClaimHow it was checkedStatus
18 upstream sources decompose into 33 collector modules — 32 live and 1 retired but retained; 30 of the 33 carry an offline test suite that runs against recorded upstream responses.ls -1 <raw-store-root> | wc -l → 18 ; find <providers-root> -mindepth 2 -maxdepth 2 -type d | wc -l → 33 ; the same listing filtered to directories containing a tests/ subdirectory → 30.published
The estate is 54 database files holding 105.4 GB (98.2 GiB); the whole platform tree, including raw blobs, code, logs and backups, is 114.4 GB (106.5 GiB).find <estate-root> -name '*.db' -type f -printf '%s\n' | awk '{s+=$1}END{print s}' → 105,441,099,776 B across 54 files ; du -sb <platform-root> → 114,355,413,279 Bpublished
397,679,393 rows under governance across 28 named surfaces.read-only SELECT COUNT(*) on each of the 28 row-bearing surfaces, summed. The sum mixes grains — filings, facts, positions, speaker turns — so it is a governed-row count, not a count of facts.published
SEC EDGAR spine: 18,697,338 filings spanning 1980-01-02 to 2026-08-21, 27,155,455 filer-to-filing links, 982,170 companies. XBRL: 125,307,255 company facts and 103,444,701 dimensioned fact rows, of which 78 carry implausible dates that are stored and named rather than dropped.SELECT COUNT(*) and MIN/MAX per table with each store opened mode=ro; dimensioned counts read from the nightly coverage contract fields num_rows and implausible_ddate.published
The 8-K narrative hole is named rather than silent: 342,275 events, 108,006 bodies fetched, 220,850 pending, 13,419 skipped.coverage contract, text_states block. The hole carries status backfill_running and a consumer rule that makes an absence-of-disclosure claim from event text illegal for that surface.published
Identifier registry: 10,429 identifier rows over 3,558 entities, 17 entities carrying more than one ticker. At the migration that built it, coverage of speaking companies moved from 3,479 of 3,495 to 3,495 of 3,495, with none unresolved at that point.SELECT COUNT(*) on the identifier table; COUNT(DISTINCT entity_id); GROUP BY entity_id HAVING COUNT(DISTINCT ticker) > 1 — all three re-run today. The coverage pair is not re-run: it is a migration-time record in the engineering log, and every identifier row carries a build timestamp from that single pass, so the pair is dated to the build and today's coverage is not measured here.published
Cross-provider overlap was measured before it was fixed: 166 calls and 1,429 questions net double-countable across the two transcript stores.join on (ticker, fiscal quarter, fiscal year) across both stores, excluding intra-store duplicates that an earlier document had folded into a larger figure. Measured once, before the fix, and recorded in the engineering log — it is not reproducible today because the fix now suppresses the superseded copy in any read spanning both stores. The fix keeps an include-duplicates escape hatch and deletes nothing.published
Deduplicated transcript corpus: 12,171 calls over 3,652 tickers, 2021-03-10 to 2026-08-21, from 12,712 raw captures — 541 rows (4.3%) removed by a cross-source pass and a within-source re-post pass.SELECT COUNT(*) FROM calls on the derived corpus (mode=ro) → 12,171 ; SELECT COUNT(*) FROM documents on each upstream store → 9,764 and 2,948.published
One holdings surface changed value-scale regime mid-history: roughly 76,898 filings on one convention through 2022 and 116,077 on another from 2023, with a mislabel rate around 7%.SELECT CASE WHEN filed_date < '2023-01-01' THEN 'through 2022' ELSE 'from 2023' END AS era, value_scale, COUNT(*) FROM filings GROUP BY era, value_scale; the ~7% is a separate measurement — the share of filings whose stored scale value disagrees with a market-anchored normalisation of the same position, not a product of the grouping. The consumer rule written into the coverage contract forbids trusting the stored value and requires the normalisation instead.published
The scheduled surface is 54 jobs: 43 timers loaded and scheduled, plus 11 active cron lines.systemctl --user list-timers --all --no-legend | wc -l → 43 ; crontab -l | grep -vcE '^\s*(#|$)' → 11. This counts jobs, not runs per day.published

12 claims tested · 10 published · 2 withdrawn before publication. Full evidence record available on request — king.hippopotamus@yahoo.com.

← Back to the case study

Author approval — 2026-08-23, hash 2377b38c