inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "33-B-0438" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 6429a736e812be29 | A AND B SUGAR BEARS 33-B-0438 | 2018-01-03 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgnhD&d=%2Fa%2F3d000000pX6l%2FbcFZ_jh1kVcDln4xU0e_S82KeWL7lEQhRXbfgLmNr1I&asPdf=false | pdfs/33-B-0438_2018-01-03_6429a736e812be29.pdf | match | d0838ffc477ab881020cd9629fad823ba2a9e54dacf54a50bcfed0182f8a3336 | |
| c1aeef9ff1ed0c52 | A AND B SUGAR BEARS 33-B-0438 | 2017-11-01 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egbie&d=%2Fa%2F3d000000pgfo%2FfhksAkOCgVlNDx.L8KH1XsjqqSvefK8RWd22BIjORFg&asPdf=false | pdfs/33-B-0438_2017-11-01_c1aeef9ff1ed0c52.pdf | match | 8d8bd90a4bc5e7727a258a33c4dfccbdccce15f43de7b7595a78a1604ffa2953 |
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);