inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "47-R-0037" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| fb507555d73ea4bb | Huvepharma Inc 47-R-0037 | 2022-07-26 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Yxnft&d=%2Fa%2F3d000000pThh%2FuebV2jyhXnA8SVL5GsLUXhSfa5jgmmW5zvmdmzlZzfo&asPdf=false | pdfs/47-R-0037_2022-07-26_fb507555d73ea4bb.pdf | match | b63b545b8cdb3018c2143e03379d48452d63a12ed803695f1acc840e02e0c82b | |
| 821a3f6a491a5ed3 | Huvepharma Inc 47-R-0037 | 2021-06-22 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000NhP80&d=%2Fa%2F3d000000pTho%2FKTDBq4oWbx_PZTky56t.YDREWIVvGcvYipxlq8jcG_w&asPdf=false | pdfs/47-R-0037_2021-06-22_821a3f6a491a5ed3.pdf | match | 8aa77c649ae7ab3efc89244a522f42931a242856b5e23252cbf496a5371677c2 |
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);