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

23 rows where cert_number = "14-R-0192" 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
15e6f002b28b Biomedical Research Models Inc 14-R-0192 2026-07-15   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00001KpBx5&d=%2Fa%2FSJ00000Bh2g9%2F.B_sherYOmrk2IU4kjbW2IFCjA9MuS8jkJnYtu1jeNk&asPdf=false pdfs/14-R-0192_2026-07-15_15e6f002b28b.pdf match f75876f6ec013088f98e79286e140dbe2d15d14f9c0e09adb68205d464adf470
2210398bba76 Biomedical Research Models Inc 14-R-0192 2026-06-15   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00001GlTTM&d=%2Fa%2FSJ00000B47Kk%2F.O.L7ZTAsEFlFbBWOPE7.QgT2KPaMZShjfl4MChjxx4&asPdf=false pdfs/14-R-0192_2026-06-15_2210398bba76.pdf match 322f79925e594799a5939a6ed0e6f44eaf779c54efbbe34f183f3ff78bdaeb49
d65565ab7a2e Biomedical Research Models Inc 14-R-0192 2026-04-07   1 2 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00001A7eGz&d=%2Fa%2FSJ000009pgkn%2F1OeUVtBuRC3ru1Idd7W3qzdHxVrYolejJLIopyuXE7g&asPdf=false pdfs/14-R-0192_2026-04-07_d65565ab7a2e.pdf match e24488b3838355d7d45d4dbe92741e51e9816f9574ad43be662d3842e149c88d
859c5973651f8408 Biomedical Research Models Inc 14-R-0192 2025-07-01   0 3 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000e1Igr&d=%2Fa%2FSJ000004mHHB%2FHrvraUiCZncAYKvnJ.R0vadZtYffRUO9x_k0bEm2doo&asPdf=false pdfs/14-R-0192_2025-07-01_859c5973651f8408.pdf match 7e879fbba8bf1ea1c4a11b5a7591e0c41f7d8007f0ead119b4678726c62a0fb7
4471662af3cf965e Biomedical Research Models Inc 14-R-0192 2024-07-30   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000001FgBF&d=%2Fa%2FSJ0000003lIX%2Fgt5kSbn2lpRNv1wrVUpGL7q_adysCoME_soHxLmCR8U&asPdf=false pdfs/14-R-0192_2024-07-30_4471662af3cf965e.pdf match bc64565a4f03a51e126aabe24d7d064dd6f9c24004f9d8b6e3a392067725901e
f9e4890454a6026f Biomedical Research Models Inc 14-R-0192 2024-03-13   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000CgzpS&d=%2Fa%2F3d000002dl51%2FGY1v2vhDu6pJXZOuezJiou.MVjuuzRfsrhmzQCuE1Y4&asPdf=false pdfs/14-R-0192_2024-03-13_f9e4890454a6026f.pdf match c93244414b738c7a37563007987a8cde319171ff4424a835e86efe16556d8995
26b142ad432733fa Biomedical Research Models Inc 14-R-0192 2023-09-05   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000009qhfo&d=%2Fa%2F3d000001lYo6%2F9K6k7T_r8vk0yQB3_faWykDPWsVGLdlRCguxz68F7J4&asPdf=false pdfs/14-R-0192_2023-09-05_26b142ad432733fa.pdf match 4bec25cf803b843920973f673c6618b2f6db72571eced6f7568316d20c9d7ae4
0a4c8ac36238a0b2 Biomedical Research Models Inc 14-R-0192 2023-07-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000009EFM7&d=%2Fa%2F3d000001TYRI%2FIl5OIcfr7ZukzcUAZabKC9HbTKKjyIMYhMqVkM.yskM&asPdf=false pdfs/14-R-0192_2023-07-19_0a4c8ac36238a0b2.pdf match 17889a0c79101e70930de3c3dcb026d63db806a398e5aac82d26206bd7b5506f
8346cf4bf5f03c6b Biomedical Research Models Inc 14-R-0192 2022-09-12   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000awBFb&d=%2Fa%2F3d000000pZ9d%2Fpegby.7fX7sgBIqErctmNEnIYayPcACijK22S5u5eSU&asPdf=false pdfs/14-R-0192_2022-09-12_8346cf4bf5f03c6b.pdf match bbe062c8c165a21669f5f13dddc4ea792433160c8fff59cd44bdf5f7954aa376
6e08a5df58b0d582 Biomedical Research Models Inc 14-R-0192 2021-06-29   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000V8Xd2&d=%2Fa%2F3d000000pZ9H%2Frdazio2e_Saxku.EkFYTbLIaAiUzbnHFkINS8dz_p3I&asPdf=false pdfs/14-R-0192_2021-06-29_6e08a5df58b0d582.pdf mismatch e67103eac982be47173f352a184fa837526f71a21e5bcc9f56ccef58015d0f8b
d07320b77517 Biomedical Research Models Inc 14-R-0192 2020-09-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EpyNG&d=%2Fa%2F3d000000pZ8f%2F2SIMlS._swi5OPMCaCDQsPLNyl8t6YgaRskKP44HQak&asPdf=false pdfs/14-R-0192_2020-09-23_d07320b77517.pdf match 42f919c104b12fdf020e5ab81dfbf58e03541c258df7ef1e6cd364b374bbd4ab
68a766d912a85cac Biomedical Research Models Inc 14-R-0192 2020-09-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EpyDi&d=%2Fa%2F3d000000pRjo%2Fs1wkQAOzl.Gtm..Zu9P7RmGNcKv.nIU5Fr3mpc12ZPg&asPdf=false pdfs/14-R-0192_2020-09-23_68a766d912a85cac.pdf match 6efdaf7a2684e912b48124272e9c27d3340175470a2c27243dbae35a375c3c44
c89c62316489 Biomedical Research Models Inc 14-R-0192 2019-05-16   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgaT9&d=%2Fa%2F3d000000pZ9U%2FD2ewIyY1Oj8GUZ8HL_QpgaolQSjwPfM4OxyNyry.BZ8&asPdf=false pdfs/14-R-0192_2019-05-16_c89c62316489.pdf match a742f24da6e77fce84efc1cbbd48b8c9e8a770cdd319dee819dc966bb530c2db
11b9154832c13011 Biomedical Research Models Inc 14-R-0192 2019-05-16   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgfqW&d=%2Fa%2F3d000000phzG%2FaNOAyVmxc40TAfzB07CB9JXlmVvp6rZYknSygdvbK2o&asPdf=false pdfs/14-R-0192_2019-05-16_11b9154832c13011.pdf match 68d97e3be3bc935cc0a0a98550300b2e7d18c453dfaddc23c912154448a8b6d1
49f6a08b2a81 Biomedical Research Models Inc 14-R-0192 2018-07-24   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgaTq&d=%2Fa%2F3d000000pZ9P%2F07px6WTzd5mU0Na4IcccWqkEZaSef9Ul9WkW8xE_BKI&asPdf=false pdfs/14-R-0192_2018-07-24_49f6a08b2a81.pdf match 4f465b3a18d21b0005455332532826a672513263877d2ad1c3eda9cedb830dea
7c032490e195511c Biomedical Research Models Inc 14-R-0192 2018-07-24   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egh4e&d=%2Fa%2F3d000000pfpU%2FFjoPiqFolYOYQXI_frhFVK4W7NCAXwjmqpWAPFOkZWY&asPdf=false pdfs/14-R-0192_2018-07-24_7c032490e195511c.pdf match 1b1a0de62b9e28aad8dfbd62ec2bbdecd0a62d958f141bcaf00803d9450c0c79
2741092b1b29 Biomedical Research Models Inc 14-R-0192 2017-06-28   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egg9x&d=%2Fa%2F3d000000pTMA%2FEIkfk5T5axR9KGjT0tUFOfhOXRGSMgTCGGC39Mo2Mts&asPdf=false pdfs/14-R-0192_2017-06-28_2741092b1b29.pdf match 376ffeb0a4c616eae05bfd5956b4ff97db412e2d3c614907976f6a5199c258f7
dd898bd5359d2ecc Biomedical Research Models Inc 14-R-0192 2017-06-28   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgaKS&d=%2Fa%2F3d000000pZ9i%2F4yJPrRozy0qOhZqWwiAqpWJpbslNe5m7cKR1lSSMIZ4&asPdf=false pdfs/14-R-0192_2017-06-28_dd898bd5359d2ecc.pdf match c09890a5b5bc441fc012fe31bd00ad728a9f36edcf1e6529c398998bb3cbf5b3
72f0ff6595c4 Biomedical Research Models Inc 14-R-0192 2016-08-22   0 1 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgWsa&d=%2Fa%2F3d000000pZ8a%2FhNHVofbhfSBUBupPyP9oaVa5OFgQ7NiWiII.c4GxrWU&asPdf=false pdfs/14-R-0192_2016-08-22_72f0ff6595c4.pdf match 757c3aa722eda6a036c0e2cf5b5d0be068702e02d09779dc8c6d160011e01b65
8cb2f649c36548c7 Biomedical Research Models Inc 14-R-0192 2016-08-22   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgaYs&d=%2Fa%2F3d000000pp0N%2FBI8t.UmMrG.ldxj7m59Hq_9t4vIm_kEYuM2uvPbxgkY&asPdf=false pdfs/14-R-0192_2016-08-22_8cb2f649c36548c7.pdf match 37c5da91f1a0fde7e586970e569bcfacefcce66dfb696a0fe141c2e6168ede00
668d9f667561 Biomedical Research Models Inc 14-R-0192 2015-07-28   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000DnwCg&d=%2Fa%2F3d000000poCQ%2FUhK3yypSJ5e7Ld4Lp6YewgBQ9aGXOzBs0zQ5uDnqGPY&asPdf=false pdfs/14-R-0192_2015-07-28_668d9f667561.pdf match 0719326f23b4643caae012e163c4b5a19eeeed4088a96c2b480c94c154d303e6
9af82c9233babf87 Biomedical Research Models Inc 14-R-0192 2015-07-28   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgXN5&d=%2Fa%2F3d000000pZ9m%2FJnrs.BdEKLvd9lJISHo6cj_zrJHWbqk8LDjYXDLQnGc&asPdf=false pdfs/14-R-0192_2015-07-28_9af82c9233babf87.pdf match e78f887088af33b7f629462ebb68e68b617343e865695627300599b6ed0b406a
f6552c688dd51443 Biomedical Research Models Inc 14-R-0192 2014-05-13   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egd5G&d=%2Fa%2F3d000000pjpO%2FsKlyxM4ilxlTJtgdMK_3EjwTFLc8_H7YOqiqcNm_Eks&asPdf=false pdfs/14-R-0192_2014-05-13_f6552c688dd51443.pdf match b7d521c0548587a5a07f31e97f7008296830c23fca7ecccef187e68a1ebf582b

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