inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "47-B-0123" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 39fec464adc31dd3 | ROGGENKAMP QUAIL LLC 47-B-0123 | 2019-03-06 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egn0v&d=%2Fa%2F3d000000pkTv%2FMntnNFM9FO._H5KZ9.zrlpbhQpV9CJsQMhSMQ6jLUVk&asPdf=false | pdfs/47-B-0123_2019-03-06_39fec464adc31dd3.pdf | match | c0fa9df7004b83c6fb6009e10c19afbf863d6ca543d0480820e935eb443b2713 | |
| 89051805e19d289c | ROGGENKAMP QUAIL LLC 47-B-0123 | 2018-08-09 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgdG0&d=%2Fa%2F3d000000ploR%2F3rg305szw56HVn9rXg56ZBojEBYy4fshhOnIjsjjJSI&asPdf=false | pdfs/47-B-0123_2018-08-09_89051805e19d289c.pdf | match | 200e5db3cb8a58ae802241a5182190121c924197d76b64e4d3c0c6cd3d1561dc |
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);