inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "64-B-0104" sorted by inspection_date descending
This data as json, CSV (advanced)
inspection_type 0
| id | cert_number | inspection_date ▲ | inspection_type | critical_count | noncritical_count | direct_count | teachable_moment_count | pdf_url | pdf_local_path | cert_verification | pdf_sha256 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| a0b0c64089d53e25 | Garrison's Livestock & Poultry Auction, LLC 64-B-0104 | 2023-02-07 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000007dmuM&d=%2Fa%2F3d000000yG5i%2FYRcPcpWrr4RcH.8YTmMFOEDU.C5XsOps6gPycoDdesY&asPdf=false | pdfs/64-B-0104_2023-02-07_a0b0c64089d53e25.pdf | match | c04b16da90aba8f68084ace4e5c12a3c97de236f7262758ea952a9e4f8221489 | |
| ed10961b039f1d27 | Garrison's Livestock & Poultry Auction, LLC 64-B-0104 | 2022-03-25 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000YwQuP&d=%2Fa%2F3d000000phHK%2FXI_uCRsMUyQ8.DUW12BTjWuep.LPN.D1RMpzaakIKos&asPdf=false | pdfs/64-B-0104_2022-03-25_ed10961b039f1d27.pdf | no_cert_ok | a76cd2740ee08db18c894f3c748c264a6bece7b8bd622565e69bf00678d1677d |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE inspections (
id TEXT PRIMARY KEY,
cert_number TEXT REFERENCES facilities(cert_number),
inspection_date TEXT,
inspection_type TEXT,
critical_count INTEGER,
noncritical_count INTEGER,
direct_count INTEGER,
teachable_moment_count INTEGER,
pdf_url TEXT,
pdf_local_path TEXT
, cert_verification TEXT, pdf_sha256 TEXT);
CREATE INDEX idx_inspections_date ON inspections(inspection_date);
CREATE INDEX idx_inspections_cert ON inspections(cert_number);