home / aphis

inspections

APHIS inspection records for licensed facilities. 110,000+ inspections from 2014–present with violation counts and links to official reports.

Data license: Public Domain (U.S. Government data) · Data source: USDA Animal and Plant Health Inspection Service, Animal Care public search tool

16 rows where cert_number = "93-R-0528" sorted by inspection_date descending

✎ View and edit SQL

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
7265980aadc2 AMPHASTAR LABORATORIES INC. 93-R-0528 2026-02-09   0 2 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000012K2da&d=%2Fa%2FSJ000008RLF3%2FjmslNmW3dQNxMcp28w.U69woXfAG_SIsItIhqIIi6Ko&asPdf=false pdfs/93-R-0528_2026-02-09_7265980aadc2.pdf match 5eb5a1d7aaf9a859d3e5be9d1684111cf7b96017630e72b05a35a587f6ded91a
2bdaeecdf96027b3 AMPHASTAR LABORATORIES INC. 93-R-0528 2025-06-03   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000aHGMz&d=%2Fa%2FSJ000004EtSA%2FjXh2o1dm5VOonnKBaY1Z3ETPaW6EjIQCI0_W26VX6wc&asPdf=false pdfs/93-R-0528_2025-06-03_2bdaeecdf96027b3.pdf match 2afe548b29079e84ac5fa44f2231e3d68f393b3fe80b34f5bb4ba1b8b1c0b814
bc8229bcc34d8484 AMPHASTAR LABORATORIES INC. 93-R-0528 2024-07-30   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000001GBGf&d=%2Fa%2FSJ0000003n5p%2FRgbUzs9BBH9r7ZRFhwMXO5dzXnuyLavyjcuTQ0yy98o&asPdf=false pdfs/93-R-0528_2024-07-30_bc8229bcc34d8484.pdf match 73664d0a9a28061673e0e052fb2cb804cb7f3e64f591b8e532835fb03ee12b79
a1fee80719f23143 AMPHASTAR LABORATORIES INC. 93-R-0528 2024-01-12   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000BiiM5&d=%2Fa%2F3d000002MShq%2Fd2nE01P9sdW.F13DRo4RtbFd0At.fUw0P7OuaU79n1s&asPdf=false pdfs/93-R-0528_2024-01-12_a1fee80719f23143.pdf match 952283336217390c5abad8233712a9dd19acacd08c6dda6c90c9ef65b468527d
efcfa7846dbe343b AMPHASTAR LABORATORIES INC. 93-R-0528 2023-10-04   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000AItNe&d=%2Fa%2F3d000001yfHB%2FdFXgQPbLv7Ce.fxf2t5.Mz_rOmbyKlsNNO8ViMPUXDo&asPdf=false pdfs/93-R-0528_2023-10-04_efcfa7846dbe343b.pdf match d8b8d8490e93502c1c4135fd9fd385aecd309cb68f766ee130b23a00d3bf987c
0a76cfeb1ec58609 AMPHASTAR LABORATORIES INC. 93-R-0528 2023-06-28   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000008vr3Q&d=%2Fa%2F3d000001NDZu%2FkBziLygDJXM3Nw0uhRfjYTkqypi0etgXKJlLm_RCEcU&asPdf=false pdfs/93-R-0528_2023-06-28_0a76cfeb1ec58609.pdf match 1df92f632a89b44815610fdabe4cd5274825f8d6a906126f143b488d5eb636ca
1d6bcb5bfdbb68af AMPHASTAR LABORATORIES INC. 93-R-0528 2023-03-16   1 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d0000082xmy&d=%2Fa%2F3d0000015PSe%2FvObImpcA6QuLZuMaWuX4VEikpduUxSfHINJj0W5u_Io&asPdf=false pdfs/93-R-0528_2023-03-16_1d6bcb5bfdbb68af.pdf match cff223ba44480bf6061ecef5c4e18d81248d7ac6496d52d71ce8ef8d7a2d4edf
16734c0efb452aa2 AMPHASTAR LABORATORIES INC. 93-R-0528 2022-03-04   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000V9VPj&d=%2Fa%2F3d000000phA1%2F2a72liAyP9lfxWDfsWBKadN0APmR7NxU8awWLHBU0LE&asPdf=false pdfs/93-R-0528_2022-03-04_16734c0efb452aa2.pdf match 90062a278344e9f7fbc26a6a2f86175b7147360d7542eda03df3c2c6cec5f4b2
834e7414ac27793a AMPHASTAR LABORATORIES INC. 93-R-0528 2020-11-04   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000FyPhy&d=%2Fa%2F3d000000pRl7%2FeUd2dqw5mpiwYKFflr8T6Ifu7rqIE9lv1KW5uePjXtQ&asPdf=false pdfs/93-R-0528_2020-11-04_834e7414ac27793a.pdf match 9875c2c71f71862dcd13c40fc6f90b7271d42525c5c0db1830620a98e8f16f32
93a7dcf17aaa28eb AMPHASTAR LABORATORIES INC. 93-R-0528 2019-12-05   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmcX&d=%2Fa%2F3d000000pSmd%2FqLABq1LzOB0MTZ2ESwecw_8JYCb5dO1m1w_2QS.GVtY&asPdf=false pdfs/93-R-0528_2019-12-05_93a7dcf17aaa28eb.pdf match 2b1b146ad9e62e57a77117b50e364b5f8c505cdadd87aff4bfaf739d5a170501
5014c27c22c1dafd AMPHASTAR LABORATORIES INC. 93-R-0528 2018-11-01   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EggNZ&d=%2Fa%2F3d000000pk0f%2FiwQB26eloqkisSchCgycIjOg2fTAANKRhjBjPpEYQ9Y&asPdf=false pdfs/93-R-0528_2018-11-01_5014c27c22c1dafd.pdf match e117010714fc4c14dbd4251a20fc73965f8ff422100746a2a3055d406343a3c4
ad43e045d105ee31 AMPHASTAR LABORATORIES INC. 93-R-0528 2017-10-20   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgeBE&d=%2Fa%2F3d000000pjFF%2FGGoKzlDXiDNnKlsgNdO0BP7dBmlqpowYxklu5.HCp34&asPdf=false pdfs/93-R-0528_2017-10-20_ad43e045d105ee31.pdf match aac0b652ae410492c7039c53f20c5fe344cbb094a41d456fcf4b01457fccf0d5
2077ec91835ad309 AMPHASTAR LABORATORIES INC. 93-R-0528 2016-10-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgeBn&d=%2Fa%2F3d000000pfBT%2Fs_Io_zAvc2e5Pudm84f14gTIb7cUSda7TS8tsX8Iw6M&asPdf=false pdfs/93-R-0528_2016-10-21_2077ec91835ad309.pdf match e696ee1bc2537a57d667eeac940e9136449480af2a6332a91f3d4523fc5dfdb2
68d4b459e1ad8016 AMPHASTAR LABORATORIES INC. 93-R-0528 2015-10-06   0 5 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000DnwiU&d=%2Fa%2F3d000000pacl%2FXiOSHqWdLm43qfHJpMw6iuQDo0eyH8RFt.CwV4oefBk&asPdf=false pdfs/93-R-0528_2015-10-06_68d4b459e1ad8016.pdf match f7e43997044362074d1b020c48ed48567a6eeef9dd46ef493dfd4c3a62885da1
b47fe87595abb770 AMPHASTAR LABORATORIES INC. 93-R-0528 2014-12-22   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgewR&d=%2Fa%2F3d000000pWoZ%2FfBKXBUVVS9_5PNddhiIYLgR8D184dniL4BAoTVDo6jI&asPdf=false pdfs/93-R-0528_2014-12-22_b47fe87595abb770.pdf match 7070838172669ee61a19379247822787dae9e3def2840ff3fbc7a2a52bed3b42
7ad671646121a882 AMPHASTAR LABORATORIES INC. 93-R-0528 2014-06-10   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgcbE&d=%2Fa%2F3d000000pUIt%2F.N1mk9mDyPzWrCKUhBO.Qs44w8z7_kIYHjWQEBk5X6Y&asPdf=false pdfs/93-R-0528_2014-06-10_7ad671646121a882.pdf match 2f01a7505f5042ccb135910724c22796b77e924bde37edc9e9e33c3fcb6c90d2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 1.084ms · Data license: Public Domain (U.S. Government data) · Data source: USDA Animal and Plant Health Inspection Service, Animal Care public search tool · Privacy