inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "42-A-1658" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 3f8d391b2c8940ac | Alvin F Bontrager 42-A-1658 | 2022-03-07 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000V9TzG&d=%2Fa%2F3d000000ph8g%2FeBDFO865lCL3Tl.7xLOe5UvT_WYc81u06nnmFwGV2I8&asPdf=false | pdfs/42-A-1658_2022-03-07_3f8d391b2c8940ac.pdf | match | 914766b6e928faecaa0a6378b3dbaca48a8af2c8bddfc5173e07b0e1c01aff42 | |
| 4275261d921271a6 | Alvin F Bontrager 42-A-1658 | 2021-05-24 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000NhB3d&d=%2Fa%2F3d000000pgmI%2FvLxelyGGFhxJ4MsBM.dWKS_YrPQw3FUD0lyCmvTaFvM&asPdf=false | pdfs/42-A-1658_2021-05-24_4275261d921271a6.pdf | no_cert_ok | 249fc2e882ae224e980165cec69c220646ce6851e0bdd51c4b98203346a5ead6 |
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);