inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "72-A-0183" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| edae6b4b42920aa6 | Julie Roe 72-A-0183 | 2016-10-25 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EglCx&d=%2Fa%2F3d000000pV3U%2FGhzdm.8jqgk7py8f9DwvJ1_w_JZ0BrqJ.V9kW2ggg.8&asPdf=false | pdfs/72-A-0183_2016-10-25_edae6b4b42920aa6.pdf | match | 231cf76abb6663e77fd8437971f76b7eee9cca04b5582dd9b28357de2626134b | |
| 5caf14e1e7540867 | Julie Roe 72-A-0183 | 2016-04-04 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egcn7&d=%2Fa%2F3d000000poGV%2FZSZPqnxnGA34VpeOi2TN8kzw2m59WUSzC8srdvJtdGM&asPdf=false | pdfs/72-A-0183_2016-04-04_5caf14e1e7540867.pdf | match | a1bcd6e10f4465d696f61bd2354868e0320f45c25fd53d83fb742e25be8dcc89 |
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);