inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "34-B-0237" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| c472cc0c1e357444 | MELISSAS MAINE COONS LLC 34-B-0237 | 2019-10-31 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgkEt&d=%2Fa%2F3d000000pSw8%2FrjOwmigd_EDMRcKU.ArxtP6iUM8SE1yG3oF1wNo8aOc&asPdf=false | pdfs/34-B-0237_2019-10-31_c472cc0c1e357444.pdf | match | 713f62ae488b7d3e6883a346215057d824025e4a755ea4a3d9f30b4ee3b595cc | |
| 0527252359671906 | MELISSAS MAINE COONS LLC 34-B-0237 | 2019-08-06 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgbKt&d=%2Fa%2F3d000000pmzU%2FlGmW3Zk2hTthBmoFiwLqv082MKbGhk_x9S2tW7.Rx4E&asPdf=false | pdfs/34-B-0237_2019-08-06_0527252359671906.pdf | match | 0c14a2969eceb052e100feeedea142d1300b9e39d18ac9e75fb86ea5013b2081 |
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);