inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "51-R-0104" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| c2e67a893276a687 | Elixirgen Therapeutics, Inc. 51-R-0104 | 2022-05-12 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000YwxGM&d=%2Fa%2F3d000000peVw%2Fq4JLJH42850E6i2qPVXNSU8ssRRQaL9rPYik2.cl7po&asPdf=false | pdfs/51-R-0104_2022-05-12_c2e67a893276a687.pdf | match | 805612f6fc0b4b9d066303b0b66fd14b849d02624bcc5072702b33b087e3db7e | |
| a3db1a79f3f5bd4b | Elixirgen Therapeutics, Inc. 51-R-0104 | 2021-08-03 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PMmNi&d=%2Fa%2F3d000000peNG%2FhtFil7LarjPbr1Id014qjVPYbJ7oi1xRWTKQFKtTGTw&asPdf=false | pdfs/51-R-0104_2021-08-03_a3db1a79f3f5bd4b.pdf | match | 82d01dc00e46f5a6827cc1e5d929d2be02b6ecb94722a656b16b13d627abb427 |
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);