inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "21-R-0219" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| f2cd42340d01e2b8 | ALBANY COLLEGE OF PHARMACY & HEALTH SCIENCES 21-R-0219 | 2015-05-06 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egm7D&d=%2Fa%2F3d000000pUsA%2F4t2XdM8aDaJ8g.eP16RJkaFlfArpJXf6Jcp07IouHM4&asPdf=false | pdfs/21-R-0219_2015-05-06_f2cd42340d01e2b8.pdf | match | f10295e25552220386f211882b2f6967bcd5010a8d9e427abadd36601a494697 | |
| 2ce927900f7ab8fc | ALBANY COLLEGE OF PHARMACY & HEALTH SCIENCES 21-R-0219 | 2014-02-26 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EglWq&d=%2Fa%2F3d000000pp12%2FaDTdp54lgP5TxP5nkiUJhOIAMd_xRKo74ts_4gAcOCA&asPdf=false | pdfs/21-R-0219_2014-02-26_2ce927900f7ab8fc.pdf | match | 65bbf873197767412253dcbec2dd769d1899dc2b430045a50d5e1627d21ec713 |
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);