Public record · the channel
Published, not delivered.
The government publishes these records. It does not deliver them: each source has its own key, format, cadence and failure mode, and the person with a duty to read them rebuilds the join by hand. This page lists what we found broken in each channel and the repair we shipped — as facts about publishing, not judgments about agencies.
Method and refusals: /methodology · field limits: /dictionary · the screening record built on these repairs: /screening
since 2026-06
Published as
Monthly CSV download, individuals and entities mixed; a web search that returns one name at a time.
Broken
No API; no dated proof of a check; screening 2,000 staff monthly means 2,000 searches.
Repair shipped
File stored verbatim with its SHA-256 and date; exact business-name and exact-NPI lookup; batch check of a pasted list; one dated record per run.
since 2026-06
Published as
Daily ZIP behind a click-through modal; the API requires a personal key and a system account for the full extract.
Broken
The file service the page itself uses is undocumented on the page; 'no result' on the website leaves no artifact.
Repair shipped
Daily extract pulled from the public file service, 35k firm rows stored verbatim, exact name or UEI, file name and hash on every answer.
since 2026-06
Published as
CSV with no header row and '-0-' for empty fields; aliases in a separate file; a sanctions-search site.
Broken
Names without an official key; aliases must be joined by entity number; most screening tools match fuzzily and hide it.
Repair shipped
SDN and ALT files stored verbatim; exact name or exact listed alias only, alias matches labelled; date and hash shown.
since 2026-05
Published as
Rich API keyed on UEI; name search returns near-matches without saying so.
Broken
Slow under load; a name search silently mixes registrants with similar names.
Repair shipped
Recipients counted only when the registered name equals the searched name; the others listed as 'not counted'; shared 24 h cache; 'did not answer' instead of a zero.
since 2026-06
Published as
Keyed API by auditee UEI, behind a free per-person API key.
Broken
The key gate means most readers never reach the filings; findings and general data are separate tables.
Repair shipped
Connector joins general and findings under one UEI; filings shown as filed with the auditor's terms; says plainly when no key is configured.
FMCSA SAFER / Motor Carrier Census
since 2026-05
Published as
HTML snapshot per USDOT; a Socrata dataset for the census.
Broken
Snapshots are overwritten, so history is lost; Socrata throttles and returns 503s.
Repair shipped
Every snapshot kept as a dated version with a change log; last-good census list served with its pull time when the service throttles.
since 2026-06
Published as
Public API and search.
Broken
Company names are free text; a typed name can match the wrong company with high confidence; categories are revised without a changelog.
Repair shipped
Exact company-field match with a published rule version; matches under retired rules discarded; refusals published; composition changes shown with the taxonomy caveat.
since 2026-06
Published as
A JSF web application with an export button; no API.
Broken
Resolved cases move to an archive, so the current list thins and old months look quieter than they were.
Repair shipped
Export pulled through the portal's own report endpoint; current and archive lists read; the thinning stated on every chart.
since 2026-05
Published as
Provider Data Catalog API.
Broken
Times out under load; a failed lookup used to fall through to an unrelated company of the same name.
Repair shipped
Hospital intent preserved on failure; the page says CMS did not answer.
since 2026-06
Published as
timeseries API with undocumented GOVTYPE codes.
Broken
Documented parameters return 404; the state total needs GOVTYPE 001, not 1.
Repair shipped
Working parameters recorded in the method; per-resident lines with the population year stated.
since 2026-06
Published as
Clean REST API, no key.
Broken
Bracketed paging parameters must be sent literally; the monthly statement mixes current- and prior-year blocks in one table.
Repair shipped
Current-year block selected by sequence; department lines taken from Treasury's own 'Total--' rows; formulas shown.
State Medicaid exclusion lists (44 states + DC)
since 2026-06
Published as
45 separate lists: Excel with the header on row 1, 3 or 33; tab-delimited; PDF only; ASP.NET postback downloads; search forms with no file; two pages that return 403 to any program.
Broken
No federal file joins them, no common column names, no common key; file names change every month, so last month's link dies. Every Medicaid provider must still check its own state list each time it checks the LEIE.
Repair shipped
Fifteen state files read as published, header found by column meaning, entities by exact printed name and individuals by exact NPI, each state's file date and hash kept; the other thirty said plainly as 'not read' with the official link. One column on the screening record and the batch check.
since 2026-06
Published as
Seven states publish machine-readable registries: CT, CO, NY, OR and PA on Socrata open-data APIs; Virginia as ad hoc CSV/XLSX extracts (the LLC file stops at Excel's 1,048,575-row ceiling); Florida as a 1.8 GB fixed-width quarterly zip on a public SFTP. The other 43 states and DC offer a search page only.
Broken
No common key, no common layout, no common cadence; officers and owners are in some files and not others.
Repair shipped
Exact registered name across all seven, file date printed on every row, Florida's placeholder FEI 000000000 never used as an EIN; the 43 unread states named as not read with the official search link. Officers, agents and owners deliberately not loaded.
HHS Medicaid Provider Spending
since 2026-06
Published as
One 3.07 GB parquet file (238 million rows: billing NPI × servicing NPI × HCPCS × month, 2018–2024) on HHS Open Data; no API.
Broken
Unreadable without a columnar engine; the NPI columns are unsorted, so every lookup is a full pass over the file.
Repair shipped
File pulled once with resumable range requests and its SHA-256 recorded; each NPI read straight from the file in one pass and cached; sums by year and by HCPCS stated as sums of the file's rows, nothing compared or flagged.
since 2026-06
Published as
DKAN API, one dataset per program year per kind (general, research, ownership); returns 403 to a bare client.
Broken
Seven years × three kinds = twenty-one datasets to query for one NPI; sums are not available server-side.
Repair shipped
Datasets discovered from CMS's own metastore daily; all twenty-one read by exact NPI; rows printed with CMS's dispute-status field; sums are of the rows read and say so.
since 2026-06
Published as
DHS published ~400 infrastructure layers (hospitals, colleges, nursing homes, power plants, fire/EMS, law enforcement, courthouses) on HIFLD Open, then retired the portal in August 2025 with a crosswalk back to originating agencies.
Broken
The portal is gone; the Data Rescue Project's snapshot lives on DataLumos and HIFLD Next, a non-government host that has begun adding third-party updates (a 2026 hospitals layer produced by Niyam IT) beside the rescued versions.
Repair shipped
Nine layers read from HIFLD Next pinned to the rescued v1.0.0 only, catalog checksum verified against our SHA-256; every row carries the custody chain (DHS inventory dates, producer, DataLumos archive, HIFLD Next release) and the originating agency's current lookup; later non-DHS versions named and not read.
CMS Care Compare (Provider Data Catalog)
since 2026-06
Published as
DKAN datastore per dataset (hospitals xubh-q36u, nursing homes 4pq5-n9py); CCN is the key; CMS's own star ratings and footnotes are columns.
Broken
Ratings are easy to re-badge as someone else's 'score'; hospital and nursing-home files use different key column names; blanks and footnotes carry meaning.
Repair shipped
Exact CCN (or exact printed name, labelled), every CMS field printed as published including blanks and footnotes, dataset id and modified date on each row; ratings labelled as CMS's own, none added by us.
since 2026-06
Published as
LDA: REST API at lda.gov (moved from lda.senate.gov; the old host now 301s), anonymous rate limit. FEC: OpenFEC API with an api.data.gov key; committee names embed sponsor names in free text.
Broken
Name search on both is fuzzy by design; a PAC's committee name is rarely the sponsor's name; amounts are as filed and not comparable across filers.
Repair shipped
Search, then keep only rows whose printed registrant/client name, committee name or Form 1 connected-organization name equals the name; amounts printed per filing as filed; filing document linked; nothing totalled or inferred.
since 2026-06
Published as
Twelve agencies and forty-five states, each with its own key.
Broken
No agency says where its records do or do not join another's; nobody archives what a page said on a date.
Repair shipped
Match register with published refusals; daily archive hash chain with OpenTimestamps proof; free, logged corrections.
Not fixable from outside — and said so
- • Death Master File and IRS TIN matching are not public; we do not read them and say so wherever a buyer might expect them.
- • 43 state business registries and UCC filings publish no machine-readable file; we link to their search pages rather than scrape them.
- • County property records have no common channel; not read.
- • Officer, owner and affiliate relationships are not published with keys; we do not infer them.
What the government has documented about its own sources
The government has documented, in its own reports, where its eligibility and spending data is inconsistent, incomplete or not linkable. This page collects those findings per source and prints the one that bears on each check next to the check. A finding is about the source, never about the name on a receipt.
sam
- Most SAM Exclusion records did not have a UEI because the source does not always require one; GAO could therefore not link most exclusion records to award recipients. — A SAM check by exact UEI can miss an exclusion filed without one. This receipt runs exact printed name AND exact UEI, and prints per entry whether a UEI is on the record (see the SAM check's uei_status line). GAO-26-107466 · 2026-06-16
- For exclusion records that did carry a UEI, GAO found 2,074 awards in FY2023–2024 to recipients listed in SAM Exclusions at the time of the transaction, and states that a match 'does not indicate that the awards were improper'. — An entry on this receipt is what the file says on the date shown; the eligibility decision is the buyer's officer's, as GAO's own language reflects. GAO-26-107466 · 2026-06-16
usaspending
- Across nine federal eligibility data sources GAO analyzed, 11 of 26 data elements were significantly inconsistent with one another (names, addresses and identifiers among them); data dictionaries and validation rules were incomplete or undocumented. — Recipient name and address fields in USAspending can disagree with the agency's own record. This receipt matches USAspending by exact registered recipient name only and prints the figure as USAspending reports it. GAO-26-107466 · 2026-06-16
leie
- GAO found no government-wide standard or governance body for the identifiers used across eligibility sources; each source carries its own keys and formats. — LEIE carries NPI for some individuals and none for others; this receipt matches individuals by exact NPI only and says so when a name-only row is shown. GAO-26-107466 · 2026-06-16
state
- No federal join, no common format or key; 15 lists publish in a form a program can read, 30 do not (PDF, search forms, blocked pages, or not located). — The state check names how many lists were NOT checked. A clean state line covers only the lists read as files on that date. /exclusions/states · 2026-09-27
doge wall of receipts
- Of 13,476 contracts reported as terminated on the DOGE 'Wall of Receipts', 27.8% lacked identifying information such as a contract number, so GAO could not corroborate the claimed savings against the Federal Procurement Data System. — This platform does not cite the Wall of Receipts as a source for any figure. Where a termination or saving is claimed, we cite FPDS/USAspending or nothing. GAO-26-108615 · 2026-08-06
Sources we decline to read — and why
- CMS/DOGE Medicaid provider-spending dataset (released 2026 for public fraud review) — not read. It shows what was billed, not whether a bill was wrong; a billing volume is not a record of anything on its own. It omits inpatient, pharmacy and long-term-care claims and may omit managed-care encounter data, so a 'total' from it is partial by construction. Publishing a name from it beside the word 'fraud' would label conduct that may be entirely lawful. Our receipts carry entries from official exclusion and enforcement files, dated and hashed — not patterns. Instead: Exclusions as filed (LEIE, SAM, OFAC, state lists), audits as filed (FAC), facility records as EPA prints them (ECHO) — with each source's own documented limits printed beside it.
File history — every file we read: first read, last read, every version
Every file this platform reads, with its first read, its last read, and every date on which the file's SHA-256 changed. A change line means the bytes differed on that date — the source posted a new version; it says nothing about why. A file that stops answering is shown as 'not readable since' with the last good version, not as 'no records'.
33 files · 31 readable now · 2 not readable now · 258 versions recorded
| File | First read | Last read | Versions | Current SHA-256 | Rows | State |
|---|---|---|---|---|---|---|
| HHS-OIG LEIE (monthly CSV) | 2026-10-04 | 2026-11-08 | 22026-10-04 17535204 · 2026-10-11 7483d47b | 7483d47bc48734f7… | 84093 | readable |
| SAM.gov Exclusions public extract (daily) | 2026-09-28 | 2026-11-11 | 452026-11-08 dab2ebf4 · 2026-11-09 4bb73d15 · 2026-11-10 42a5ce4b · 2026-11-11 07a6cc8d | 07a6cc8de4fa0130… | 169192 | readable |
| OFAC SDN list (SDN.CSV) | 2026-09-28 | 2026-11-10 | 142026-10-28 5f240bed · 2026-11-04 ebbbce82 · 2026-11-05 8e94d871 · 2026-11-06 7f43332d | 7f43332dae0d1b78… | 19563 | readable |
| Consolidated Screening List (trade.gov CSV; SDN rows skipped) | 2026-09-28 | 2026-11-11 | 482026-11-08 9defedfa · 2026-11-09 9448817c · 2026-11-10 da10acb7 · 2026-11-11 0ab6c5ad | 0ab6c5adf4f1fcb9… | 6702 | readable |
| FDA Debarment List (HTML table, hashed as parsed) | 2026-09-28 | 2026-11-11 | 32026-09-28 83c8a7b9 · 2026-09-29 ff70ed77 · 2026-10-03 98c8a953 | 98c8a953a579c605… | 157 | readable |
| UFLPA Entity List (complete list in the appendix to the latest Federal Register notice, full-text XML) | 2026-10-03 | 2026-11-11 | 22026-10-03 b87e64e4 · 2026-11-03 73bff360 | 73bff36048e97505… | 210 | readable |
| FARA active registrants (DOJ eFile API JSON) | 2026-10-04 | 2026-11-11 | 172026-11-03 dbc90201 · 2026-11-04 c089d88d · 2026-11-05 14175384 · 2026-11-10 cb620342 | cb6203428405113c… | 540 | readable |
| DoD Section 1260H list (latest Federal Register designation notice, full-text XML) | 2026-10-04 | 2026-11-11 | 1 | df7a615282fd49af… | 79 | readable |
| PHMSA pipeline enforcement raw data file (tab-delimited, every case since 2002) | 2026-10-04 | 2026-11-10 | 22026-10-04 23d8d5c6 · 2026-11-03 ac29ec42 | ac29ec425cc00e03… | 5103 | readable |
| UN Security Council Consolidated List (official XML) | 2026-10-04 | 2026-11-11 | 322026-11-07 f9598639 · 2026-11-08 a61ed598 · 2026-11-10 93c239ab · 2026-11-11 a3561ec4 | a3561ec4338dc55b… | 1007 | readable |
| NRC significant enforcement actions (HTML pages, hashed as parsed) | 2026-10-04 | 2026-11-10 | 52026-10-16 d7ad6c00 · 2026-10-30 514ef4a0 · 2026-11-03 d92a7acd · 2026-11-04 ef4bd791 | ef4bd7915ef38b0c… | 1862 | readable |
| IRS Automatic Revocation of Exemption list (bulk zip, pipe-delimited) | 2026-09-28 | 2026-11-11 | 52026-10-05 565b543f · 2026-10-12 e908bb5c · 2026-10-21 7ea1b3a7 · 2026-11-11 a28638a5 | a28638a5550ecde1… | 1247443 | readable |
| IRS Publication 78 data (bulk zip, pipe-delimited) | 2026-09-28 | 2026-11-11 | 22026-09-28 a587da65 · 2026-10-21 06c9f70c | 06c9f70cb98eed64… | 1428501 | readable |
| Virginia SCC — LLC extract (Open Data Portal CSV) | 2026-09-29 | 2026-09-29 | 1 | dcf14ad33067515a… | 1048575 | readable |
| Virginia SCC — Corporation extract (Open Data Portal XLSX) | 2026-09-29 | 2026-09-29 | 1 | 2b7edd4e8ca9d5c3… | 465855 | readable |
| HHS Open Data — Medicaid Provider Spending (T-MSIS aggregate, parquet, 2018–2024) | 2026-09-29 | 2026-09-30 | 1 | f646d426126638dd… | 238015729 | readable |
| Florida Division of Corporations — quarterly corporate data file (Sunbiz public SFTP, fixed-width) | 2026-09-29 | 2026-09-29 | 1 | ddaa7c4d8f9e217d… | 12808196 | readable |
| GA — Georgia Department of Community Health, Office of Inspector General List of Excluded Individuals and Entities | 2026-09-28 | 2026-11-11 | 1 | 09ce8b072f000617… | 1375 | readable |
| NY — New York State Office of the Medicaid Inspector General NYS Medicaid Exclusion List | 2026-09-28 | 2026-11-11 | 412026-11-08 4f073a9f · 2026-11-09 a37ba89e · 2026-11-10 1f68d972 · 2026-11-11 ce117468 | ce117468875428a5… | 9177 | readable |
| KY — Kentucky Department for Medicaid Services Terminated and Excluded Providers | 2026-09-28 | 2026-11-11 | 42026-09-28 f1461e7f · 2026-10-01 fd3ac551 · 2026-10-17 82139623 · 2026-11-04 083d3b4d | 083d3b4de9e10fba… | 401 | readable |
| SC — South Carolina Department of Health and Human Services Excluded / Terminated Providers | 2026-09-28 | 2026-11-11 | 22026-09-28 2bb2b69e · 2026-10-31 d2e87e0e | d2e87e0e5924ecbd… | 1372 | readable |
| OH — Ohio Department of Medicaid Provider Exclusion and Suspension List | 2026-09-28 | 2026-11-11 | 42026-09-28 a8ca0144 · 2026-10-02 edb39253 · 2026-10-16 8ec9544e · 2026-11-06 371d9dd7 | 371d9dd788db68c8… | 2122 | readable |
| CO — Colorado Department of Health Care Policy & Financing Terminated Provider List | 2026-09-28 | 2026-11-11 | 42026-09-28 1d37c8db · 2026-09-29 1b94b632 · 2026-10-13 79c47b82 · 2026-11-05 c0799308 | c07993086f3ef5ea… | 321 | readable |
| CO — Colorado Department of Health Care Policy & Financing Reinstated Provider List (terminations later lifted) (reinstatements) | 2026-09-28 | 2026-11-11 | 42026-09-28 390b597b · 2026-09-29 9e2c5989 · 2026-10-13 afa1c463 · 2026-11-05 35dcfe6a | 35dcfe6aa5435deb… | 17 | readable |
| KS — Kansas Department of Health and Environment (KMAP) Termination List | 2026-09-28 | 2026-10-04 | 1 | 9530adfaf457b711… | 206 | not readable since 2026-11-11 |
| IA — Iowa HHS, Iowa Medicaid Excluded Individuals and Entities (Sanctions List) | 2026-09-28 | 2026-11-11 | 32026-09-28 4b6b4d01 · 2026-10-01 c13063bc · 2026-11-03 b1705e2a | b1705e2a75f813e6… | 1329 | readable |
| MS — Mississippi Division of Medicaid Sanctioned Providers List | 2026-09-28 | 2026-10-07 | 1 | 53ae00090f12e7fb… | 211 | not readable since 2026-11-11 |
| IN — Indiana FSSA, Office of Medicaid Policy and Planning Terminated Providers | 2026-09-28 | 2026-11-11 | 1 | 77a75b6a0326cd64… | 112 | readable |
| MT — Montana DPHHS Excluded or Terminated Providers | 2026-09-28 | 2026-11-11 | 22026-09-28 7ad82cf8 · 2026-11-04 c6f834f8 | c6f834f82dad88a4… | 173 | readable |
| AL — Alabama Medicaid Agency Suspended / Sanctioned Providers | 2026-09-28 | 2026-11-11 | 22026-09-28 0e44854c · 2026-10-09 52e6e89b | 52e6e89b8e23e591… | 2086 | readable |
| NC — NC Medicaid, Division of Health Benefits State Excluded Provider List | 2026-09-28 | 2026-11-11 | 22026-09-28 2e2a8c89 · 2026-10-31 e4eadcb1 | e4eadcb1a4f9d9aa… | 183 | readable |
| MO — Missouri Medicaid Audit and Compliance Sanction List | 2026-09-28 | 2026-11-11 | 22026-09-28 08ea1250 · 2026-10-08 a3d9a809 | a3d9a8094f0c9824… | 280 | readable |
| MD — Maryland Department of Health, Medicaid Sanctioned Provider List | 2026-09-28 | 2026-11-11 | 22026-09-28 d50d8676 · 2026-10-10 ac542d61 | ac542d6103c69449… | 1615 | readable |