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

30 rows where cert_number = "14-R-0017" 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
bda9bc3cb602 Boston University 14-R-0017 2026-07-01   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00001JDWoV&d=%2Fa%2FSJ00000BS2F4%2F0fUrZPZElFxq3nXYf8j3rOchPmxw5wvyb.2f3877IcA&asPdf=false pdfs/14-R-0017_2026-07-01_bda9bc3cb602.pdf match c9b988e944c7b5c3b1941e30a543809b099c5b0c6bae10c1ac4f1ea2501468a2
46d1a9c8d050 Boston University 14-R-0017 2026-04-30   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00001BqjOy&d=%2Fa%2FSJ00000ACcYP%2Fliw1ix8OrdVp9EoJQL46d35kWzQmr8EyDRSuRJMJ8CQ&asPdf=false pdfs/14-R-0017_2026-04-30_46d1a9c8d050.pdf match 7baaf0ff0547f058ff6ee60438819b4165c7ab00ef84582bc6ffc9cebbaa4765
dd683551e021 Boston University 14-R-0017 2026-04-29   1 2 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00001BszVx&d=%2Fa%2FSJ00000AD1Bp%2FCQYnBnCyWSANxKW2BIAQTmkvYMtPzmw7SEsRjNN4wIs&asPdf=false pdfs/14-R-0017_2026-04-29_dd683551e021.pdf match e0b1e9568478d4daaa9d82165eb66bfa0f0cac8ea2a38345c101ab40472fc449
5839ed632cd98d7e Boston University 14-R-0017 2025-07-02   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000df7gi&d=%2Fa%2FSJ000004ikhZ%2F8XkmptphG.Jz5BcIS2wyPiPgTMFsXVUWhft1CLNWRMY&asPdf=false pdfs/14-R-0017_2025-07-02_5839ed632cd98d7e.pdf match 44f9c7bc68b68048e6794867f4e86fec6d11a67c96ae16a5b956265e0e28e874
81ed3103ea3aefd2 Boston University 14-R-0017 2025-02-26   0 2 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000PFIRL&d=%2Fa%2FSJ000002QRMn%2F3.mbjcsEVWeajdfOEhDbQR4pKXRJAk6sEUXdSEGpRJM&asPdf=false pdfs/14-R-0017_2025-02-26_81ed3103ea3aefd2.pdf match 119048555ae1c1152f106486514398edf1dca373984eb9d53cca178bf33c01f7
dee143a166f12207 Boston University 14-R-0017 2024-06-11   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000EBqZJ&d=%2Fa%2F3d00000362WT%2Fl2AR_apIqS4Fb9ZiOUKC.JmaFtCTaXqsj4zo5VT8t78&asPdf=false pdfs/14-R-0017_2024-06-11_dee143a166f12207.pdf match 0c47e9fccd113f89e939dd53eb227e54d7bfb39cee5e0b0563aea498ff61663f
33bf4ec3fc900262 Boston University 14-R-0017 2024-03-07   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000CdYzg&d=%2Fa%2F3d000002chWk%2FoTIrP0WV3TttyN8F9qHJvDze18_wuSCtwJpxKVlXTwA&asPdf=false pdfs/14-R-0017_2024-03-07_33bf4ec3fc900262.pdf match f2ed52f4607a7c2ba32942f47129f06c9c74c14cd5c2fa23258843bacc15a4dd
32b8e3969421 Boston University 14-R-0017 2023-12-13   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000BN6nt&d=%2Fa%2F3d000002FOLD%2F2PtsBnIc2RODneh_JePE9_GPAI8wNX3Fn7M6cAxsrkw&asPdf=false pdfs/14-R-0017_2023-12-13_32b8e3969421.pdf match 04a82bdb67201095f1f32c45ea8a530d2ca6f51ef6b4ef0db2c822ee399f6ff1
f2add067709dcd98 Boston University 14-R-0017 2023-12-13   1 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000BRJWK&d=%2Fa%2F3d000002Gl8b%2FHHaT3t._3acvgHKWKHLdg7YvO7QqYa8ORCJa8sbANtQ&asPdf=false pdfs/14-R-0017_2023-12-13_f2add067709dcd98.pdf match 737a71b90959c94afc87c60aef4f9924db2989efa52c53bd6eb09b2e2ae86f31
995418b7557125b5 Boston University 14-R-0017 2023-09-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000A8uGw&d=%2Fa%2F3d000001uZBX%2FWjIJy3.yWvW7JMHUfvVAvLlREXWr.nCk74vjtMpv4Dk&asPdf=false pdfs/14-R-0017_2023-09-18_995418b7557125b5.pdf match 40aca0a12a31aaf3caca8de93ac4f885fe4181c0554b098bf9467fdba730032f
805d4f3a9f949972 Boston University 14-R-0017 2023-01-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000007dmiv&d=%2Fa%2F3d000000yGQ2%2Fbd1Q0wCz7iZWGCHF9CRkT9BsCSJm3exaxqNSJLAdckU&asPdf=false pdfs/14-R-0017_2023-01-19_805d4f3a9f949972.pdf match 8a3f087baef73afbf1c3ec6a0d42ab94b6524950aa42155bab2b576505b1b2d9
59aeef6a2b26d253 Boston University 14-R-0017 2022-10-18   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000gurMq&d=%2Fa%2F3d000000pYO2%2FRfGO9uR42eWAhW1i41BhzqLE_hhBNkFLUKlJY6qLTaY&asPdf=false pdfs/14-R-0017_2022-10-18_59aeef6a2b26d253.pdf match 0796c56017ee1e518586372341f9140e5a47121db33045296ec00a0a32c8d451
69dbf728c84f4735 Boston University 14-R-0017 2022-07-14   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000YxdKh&d=%2Fa%2F3d000000pW9V%2FqHbl33SYGqyKO4gkuFC5X0QD3vHmaNRccfb2yYZGN_M&asPdf=false pdfs/14-R-0017_2022-07-14_69dbf728c84f4735.pdf match 823034d043ca2fcdba811716edcf11a16f754ba7087fc67ca1b85802fb782ef7
77aedc6ce063 Boston University 14-R-0017 2022-05-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Yx1iE&d=%2Fa%2F3d000000pgE7%2FNNP_UM.PNtTqKT649bEsdcxZRFbBUVUTgxNGG4esz.Q&asPdf=false pdfs/14-R-0017_2022-05-18_77aedc6ce063.pdf match ca79ab9847f5a56b31afe4fd7db63b25935e3199990f026f065630fabea5232b
7c6968e366ba16e6 Boston University 14-R-0017 2022-05-18   1 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Yx1vX&d=%2Fa%2F3d000000pW9o%2FFW1ZNkVDqman4rMYDs.LviSIk4MH.zYdxEREsqwvP04&asPdf=false pdfs/14-R-0017_2022-05-18_7c6968e366ba16e6.pdf match c922b5c5909fb83077d3ad424fee836b445c41de06e4524e56074e3ca4de41f2
9cd668228958 Boston University 14-R-0017 2021-07-28   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PMk6Z&d=%2Fa%2F3d000000pW9F%2Fu6uycJ3xonmc7rdPo0DQTWsLly1fHjHH_tEmXSjIbEk&asPdf=false pdfs/14-R-0017_2021-07-28_9cd668228958.pdf match b90d7542f308ac326571ecf11a8c840398e2d4c83cab41909866e80a141925ba
3e48698e164d146d Boston University 14-R-0017 2021-07-28   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PMk6A&d=%2Fa%2F3d000000peie%2Ft_sfxP8XfSZxQAb._CIHw9B3IfBXjcFLXJfEwxAtS_8&asPdf=false pdfs/14-R-0017_2021-07-28_3e48698e164d146d.pdf match 476071eb82d855d460f8e72a2117ce7c2cffd2e6a41f50e792090696326f6eec
0552163a014c Boston University 14-R-0017 2020-09-28   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000ErCU2&d=%2Fa%2F3d000000pW9N%2FkB3X8QFbmm6AvD.i4CVJwaac_RYqaFWgZXkOK9hpEas&asPdf=false pdfs/14-R-0017_2020-09-28_0552163a014c.pdf match 6567865f04c4e9ea1c4355e4e5cb11ea9a046c07886f0a58d86a1aa17f66e1f7
0f5a1b912212c0a9 Boston University 14-R-0017 2020-09-28   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000ErCRr&d=%2Fa%2F3d000000pei2%2FOfcPs43QWZkI4_YOURF0h5KXo.EpgeeqJZos3aRlG2o&asPdf=false pdfs/14-R-0017_2020-09-28_0f5a1b912212c0a9.pdf match 4528588f9d7d799435105c699b0a91ffb29a8b5959a4d29a62266be265771074
10dc191105ef Boston University 14-R-0017 2019-08-29   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egd5A&d=%2Fa%2F3d000000pWAW%2FhGo0jr8v251hetbJisQpwUXkKfEBKJxjkiLTguOhRXA&asPdf=false pdfs/14-R-0017_2019-08-29_10dc191105ef.pdf match 75c5420c1ed615389579237b7c4140c0dae9ab9e0ae55691e4bd6de8eea9c06b
3c964fedf140209b Boston University 14-R-0017 2019-08-29   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EglrU&d=%2Fa%2F3d000000peiB%2Fkn6P.nuBnuHsfyDOnJYKoXhlIBTIrVt0t.eltZl7ZWc&asPdf=false pdfs/14-R-0017_2019-08-29_3c964fedf140209b.pdf match 039c7abbb8976cb6ef664cd04b9b937db5a5b7b67c2425e4fb3c8cacc73f5cbf
16072ca6e379 Boston University 14-R-0017 2018-07-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgbQ3&d=%2Fa%2F3d000000pW9k%2Fx6tQ1YOXZijxYol38zLdw6luP0tgv9ZqMjtlP6PeL2A&asPdf=false pdfs/14-R-0017_2018-07-23_16072ca6e379.pdf match 1a2a7e337922a58991d498ad350bf8a95ffe6f1fbc496762cd66d2479031dd98
abc4d538f94a2ed0 Boston University 14-R-0017 2018-07-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgeMN&d=%2Fa%2F3d000000pehI%2F9QVrip7rW2VTpeAfhr3W91hpgWIqSlqEaeUTHFPvFjg&asPdf=false pdfs/14-R-0017_2018-07-23_abc4d538f94a2ed0.pdf match a82cc2419e9f9712283adad2e851a5d1a141389bfed311776dbcf316a90bc5c9
c891ce43abfa Boston University 14-R-0017 2017-06-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgZc2&d=%2Fa%2F3d000000pWAY%2FjMwrbbbAswiwSk81CwaLUrw.xTIvrtxGCxs72sSMn3M&asPdf=false pdfs/14-R-0017_2017-06-27_c891ce43abfa.pdf match 13f5c11756e157615c4a7587f1fe4ffe3126af362cbeb7a25ca82166b86c3227
e354a309121b5bcb Boston University 14-R-0017 2017-06-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eglab&d=%2Fa%2F3d000000pgC1%2Fwl0xFI3nEVGpL.AyX3Azm9njg1CVLyXul4osx8b95E4&asPdf=false pdfs/14-R-0017_2017-06-27_e354a309121b5bcb.pdf match dc2e6df5a5831330897675b1df5a451cbcf4e02f514500ea8b8d6e2ae24f9905
697f47bc18cb574e Boston University 14-R-0017 2016-09-14   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egn4f&d=%2Fa%2F3d000000pei9%2FyoqJGToVJeelr5MDMtqAUiq.L._Ehu.8kSVEtc3zHks&asPdf=false pdfs/14-R-0017_2016-09-14_697f47bc18cb574e.pdf match 45b99fd099e9fdfb03e71150508c54461d7bc0163d5ee5c4ba026a5bf3aef613
aa4bb03f46f1ac5e Boston University 14-R-0017 2016-09-07   0 2 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgWLG&d=%2Fa%2F3d000000pWA2%2FW_aRGE7_axhYwzR1s4I0lJTGtYTsIGHf.eiWA22shyY&asPdf=false pdfs/14-R-0017_2016-09-07_aa4bb03f46f1ac5e.pdf match d35c351a70c726d1d7a3da894112e042eb803f3ef12ad541d7cd9fd1c77158fb
0e204e01ab643dc4 Boston University 14-R-0017 2015-07-29   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgbHq&d=%2Fa%2F3d000000pWAU%2FYmGhDV5Y3guB.aO_DzWh5G4tV9IGrsGjg8DMW8zws0Q&asPdf=false pdfs/14-R-0017_2015-07-29_0e204e01ab643dc4.pdf match 65400423a21b94442098195dfc2b1107f08ce4a97d60b4872cc546259f390c17
3075b0d48f24a37e Boston University 14-R-0017 2015-04-30   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgnCp&d=%2Fa%2F3d000000pei6%2FJULfuykljVg8w43dD15jtvvkDXaTB0I11mITWTB_p1w&asPdf=false pdfs/14-R-0017_2015-04-30_3075b0d48f24a37e.pdf match 878c116ce36b55493c7d36629ee928f0186741adf827f2b4f48cc4b9856578ab
9c8f6d4e41528db1 Boston University 14-R-0017 2014-04-22   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EghnL&d=%2Fa%2F3d000000peiC%2FBfZ3BDayUAE.P7xl5tjVsKGRDRsNx8pO64hXantHud4&asPdf=false pdfs/14-R-0017_2014-04-22_9c8f6d4e41528db1.pdf match e4323efeedbd1fda6a908a2a2b6fa8b7737bba82d90125e302f6b2fc86e3043a

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