{"generated_at":"2026-11-14T22:42:04Z","cells_checked":13329947,"cells_matching":13329947,"match_rate":1.0,"passed":true,"skipped":[],"not_checked":["Salmonella category months FSIS no longer hosts online: verified when each posting was ingested","What pages and the API display: this audit compares source files with the stored data files only. Displayed values are checked by the render audit (/api/render-audit)"],"datasets":[{"dataset":"FSIS recalls","source":"FSIS Recall API snapshot","cells_checked":10144,"cells_matching":10144,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":["source file 2026-11-13-d25e1499-fsis_recalls.json.gz","1,244 source recalls; 836 linked, 408 quarantined in recalls_unlinked.csv","28 links rest on a unique company-name match (FSIS printed no establishment number)"]},{"dataset":"FSIS lab sampling","source":"FSIS establishment-specific laboratory sampling zips","cells_checked":53880,"cells_matching":53880,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":["18 source files"]},{"dataset":"NARMS cecal detection","source":"FSIS NARMS cecal zips","cells_checked":25060,"cells_matching":25060,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":[]},{"dataset":"NARMS resistance (WGS)","source":"FSIS NARMS cecal zips","cells_checked":123856,"cells_matching":123856,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":["WGS determinations only (AST results are not published), per methodology"]},{"dataset":"FSIS chemical residues","source":"FSIS National Residue Program quarterly spreadsheets","cells_checked":2594,"cells_matching":2594,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":["counted once: finding 103217854/Ampicillin listed 2 times","counted once: finding 102882864/Tetracycline listed 2 times","counted once: finding 102878185/Oxytetracycline listed 2 times","counted once: finding 102880025/Neomycin listed 2 times","counted once: finding 102878922/Desfuroylceftiofur listed 2 times","counted once: finding 102879985/Desfuroylceftiofur listed 2 times","counted once: finding 102879626/Dihydrostreptomycin listed 2 times","counted once: finding 102877995/Eprinomectin listed 2 times","counted once: finding 102879664/Tulathromycin listed 2 times","counted once: finding 102881218/Tulathromycin listed 2 times","counted once: finding 102879690/DDT and Metabolites listed 2 times","counted once: finding 102879677/Diclofenac listed 2 times","counted once: finding 102879975/Tildipirosin listed 2 times","counted once: finding 102879562/Desfuroylceftiofur listed 2 times","counted once: finding 102878185/Tulathromycin listed 2 times","counted once: finding 102879909/Tulathromycin listed 2 times","Residue_Results sheets only; FSIS's PFAS and metals sheets are not published"]},{"dataset":"Salmonella categories -> establishment profiles","source":"data/fsis-salmonella-verification FACT table","cells_checked":67588,"cells_matching":67588,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":["category values are verified against the FSIS posting at ingest by fsis_update.py; FSIS keeps only the latest postings online"]},{"dataset":"FSIS Salmonella categories (online postings)","source":"FSIS Salmonella Verification Testing Program monthly postings","cells_checked":65130,"cells_matching":65130,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":["202611: 719 FSIS lines vs 719 published","202610: 720 FSIS lines vs 720 published","202609: 724 FSIS lines vs 724 published","202608: 722 FSIS lines vs 722 published","202607: 723 FSIS lines vs 723 published","202606: 725 FSIS lines vs 725 published","202605: 720 FSIS lines vs 720 published","202604: 720 FSIS lines vs 720 published","202603: 721 FSIS lines vs 721 published","202602: 720 FSIS lines vs 720 published","202601: 723 FSIS lines vs 723 published","202512: 717 FSIS lines vs 717 published","202511: 719 FSIS lines vs 719 published","202510: 720 FSIS lines vs 720 published","202509: 725 FSIS lines vs 725 published","202508: 727 FSIS lines vs 727 published","202506: 736 FSIS lines vs 736 published","202505: 745 FSIS lines vs 745 published","label standardization (one display name/city per plant across months, from crosswalks/establishment_dimension.csv): {'Establishment Name': 8834, 'City': 4}"]},{"dataset":"CDC BEAM","source":"data.cdc.gov","cells_checked":3414008,"cells_matching":3414008,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":["262,616 source rows, 262,616 feed rows"]},{"dataset":"CDC NORS","source":"data.cdc.gov","cells_checked":1267547,"cells_matching":1267547,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":["66,713 source rows, 66,713 feed rows"]},{"dataset":"CDC BEAM site summaries","source":"data.cdc.gov jbhn-e8xn","cells_checked":181,"cells_matching":181,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":[]},{"dataset":"CDC NORS site summaries","source":"data.cdc.gov 5xkq-dg7x","cells_checked":215,"cells_matching":215,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":[]},{"dataset":"FSIS raw poultry sampling (site)","source":"FSIS raw poultry sampling FY zips","cells_checked":385,"cells_matching":385,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":["FY2027 not posted by FSIS yet"]},{"dataset":"FSIS plant directory and line-speed waivers","source":"FSIS MPI directory + modernization page","cells_checked":73871,"cells_matching":73871,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":[]},{"dataset":"FSIS inspection tasks and MOI/NR records","source":"FSIS Inspection Task Data (quarterly xlsx)","cells_checked":8225488,"cells_matching":8225488,"match_rate":1.0,"mismatches_by_field":{},"examples":[],"notes":[]}]}