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

24 rows where cert_number = "33-R-0025" 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
20ff8d44e87b Abbott Laboratories 33-R-0025 2025-06-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000chU5K&d=%2Fa%2FSJ000004aztt%2FR2WHShCXZGrzU7jhLB4M35WO87BQeJgdUnMF2bA_2lo&asPdf=false pdfs/33-R-0025_2025-06-25_20ff8d44e87b.pdf match 248d2ddd106c1e06d1a845d679378d604fde104eb0a755c2fc5cfdc0fb6b1b08
c992f0ae98cf1d77 Abbott Laboratories 33-R-0025 2025-06-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000chtcx&d=%2Fa%2FSJ000004awOA%2FOgA8fAqZ3cqzF71tidD3jCavRa..vfPLNccVXCyjHHo&asPdf=false pdfs/33-R-0025_2025-06-25_c992f0ae98cf1d77.pdf match 7ed44132e348251cd67cf21291f2d4596a2dd6e1ac0014df0dcc8b63134787b5
e5f5191c3ab2 Abbott Laboratories 33-R-0025 2024-06-11   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000EA33r&d=%2Fa%2F3d0000035NCL%2FpQV0YC3E0r8PbcaREAHQPGgRQ96jlInLpM1yE8jJDEk&asPdf=false pdfs/33-R-0025_2024-06-11_e5f5191c3ab2.pdf match ad47fc6fac9d2318ce9ca68cfdb87c0c7006b3a8e36fc73954e0b44f803e9f5b
122539435a63f38e Abbott Laboratories 33-R-0025 2024-06-11   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000EA3EZ&d=%2Fa%2F3d0000035NF5%2FZRilovSjKR1A1djXo1nytj3nlYt3BSPxDR9fg8GCyyM&asPdf=false pdfs/33-R-0025_2024-06-11_122539435a63f38e.pdf match 310479f8f28b450a374488295c9416c0f9ec2cd81cc56670fcf96a7126b146ae
7920a4a568fe Abbott Laboratories 33-R-0025 2023-09-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000ABC49&d=%2Fa%2F3d000001vf3h%2FF9N2V7vh8ehCVqd98aSSmoH7lJvPUSJEWJbQ7BASSac&asPdf=false pdfs/33-R-0025_2023-09-18_7920a4a568fe.pdf match c9e706387d5837a4d232348d97365f7c7a3103c21ca0179dadf7d471d598e3d6
e5a2d6051a2f8346 Abbott Laboratories 33-R-0025 2023-09-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000AB9e1&d=%2Fa%2F3d000001veyC%2Fo5hywqscEIvcI2Z7ym0YULVghAsF6WMBpObjqvkJbeA&asPdf=false pdfs/33-R-0025_2023-09-18_e5a2d6051a2f8346.pdf match 5d8e2601ab4bb6451aff0880708aae39fd5820e01d6d78d7e54081aecbc0af61
a3884cb6604f Abbott Laboratories 33-R-0025 2022-08-10   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000YxxZ6&d=%2Fa%2F3d000000pXZR%2FyFYHs_Nf6dAIPzLjXbuboUDbEMAiZIArY7hzGwBHFqs&asPdf=false pdfs/33-R-0025_2022-08-10_a3884cb6604f.pdf match 2f7db447abd51befab65b9a3aacd9f6f9ad5a6ab360920e91d6276343d0c27b0
e98cd03d45aa5802 Abbott Laboratories 33-R-0025 2022-08-10   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000YxxZ1&d=%2Fa%2F3d000000pXZA%2F9JrN80G3ru7vLYP1lxazLzpziG9MiNvKviz3uydvh88&asPdf=false pdfs/33-R-0025_2022-08-10_e98cd03d45aa5802.pdf match c75fcaa546f3c089717c033ce6028aac2c4a062ddda30c3fe81077ee106feb19
00d2e71d9a4d Abbott Laboratories 33-R-0025 2021-09-15   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PNEv3&d=%2Fa%2F3d000000pXZJ%2F2Bushkxg8A6vlH3j2oIT5JPlNaFFW5JkwdIV7fhtd3Q&asPdf=false pdfs/33-R-0025_2021-09-15_00d2e71d9a4d.pdf match ae166d322cda8757b9debcc7359d20e6d9e9c82dd0c299ec5a2635d50cb6368a
1bc819ba2cc6502f Abbott Laboratories 33-R-0025 2021-09-15   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PNEue&d=%2Fa%2F3d000000pXYX%2FD33gY6K0dMj2VJ5oggSFm.4m0ovWsEDvrxxtEJ9bak8&asPdf=false pdfs/33-R-0025_2021-09-15_1bc819ba2cc6502f.pdf match 946f21d8e20dc4321663f43d3259e74c96706f32871bd26ffbc0cc1d77c25964
1e5fbb0b3e56 Abbott Laboratories 33-R-0025 2020-09-29   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EqcgA&d=%2Fa%2F3d000000pXYo%2FyWdzUzuvgv4NzCvBhYEweNh8wQEHdYYFv1Ci8nh.32Q&asPdf=false pdfs/33-R-0025_2020-09-29_1e5fbb0b3e56.pdf match 31f6717c61cf30c3fb86afc405c26674d048a0d41f1ca7e319d8075d03ec4212
6b341d6eaa407d9e Abbott Laboratories 33-R-0025 2020-09-29   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eqch8&d=%2Fa%2F3d000000pXYv%2FmxRrx2X9TLEXeL9HqDCgOVOBMTtLp6NnXmzdSDtPl2Q&asPdf=false pdfs/33-R-0025_2020-09-29_6b341d6eaa407d9e.pdf match 2047baa57a8f55e299eae71a2cf468c08f4fb30ebdbb34516e6e439651699351
b30575e13332 Abbott Laboratories 33-R-0025 2019-05-29   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgnGp&d=%2Fa%2F3d000000pXZY%2Fj9HCm4C6rpJtpw.j9flDD4mfOQP0iGde79T2fblArRQ&asPdf=false pdfs/33-R-0025_2019-05-29_b30575e13332.pdf match fe7e9480bc9667bff30eaa6701a54a8135ddd400929ad02f4a841a2148ced859
b9858dce7b4c0971 Abbott Laboratories 33-R-0025 2019-05-29   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgncO&d=%2Fa%2F3d000000pXYW%2FG1Fdhqj3oCuL1T6NSNO1mdN74JScoq8WJCa6zCRjpg8&asPdf=false pdfs/33-R-0025_2019-05-29_b9858dce7b4c0971.pdf match d4e8510321e5039c00323b6c67955dfaa04680e25f580013c80ac5aafd0aaef5
fd578771d2fc Abbott Laboratories 33-R-0025 2018-06-05   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eggpk&d=%2Fa%2F3d000000pXYA%2FsSz1fXcrNzIBweKNWzM.71eCR.._fN6rzv0b2VkONyg&asPdf=false pdfs/33-R-0025_2018-06-05_fd578771d2fc.pdf match da63cff1542dbce279f45f843de9fbe496e738f8bf3f23d677f07b7f72c23dc1
6ab6de46c0036b3a Abbott Laboratories 33-R-0025 2018-06-05   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egf3h&d=%2Fa%2F3d000000pXZZ%2FXM2U7eJs5XD1ZJ49lvG0sqnfpGnoWKT7x519RwhN4fU&asPdf=false pdfs/33-R-0025_2018-06-05_6ab6de46c0036b3a.pdf match 706793e4c159015cf444247b0669a6d3a673a34196683281b074b8c84f1e8f1b
bd0e0d6aef56 Abbott Laboratories 33-R-0025 2017-06-02   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgZ8C&d=%2Fa%2F3d000000pXY4%2FFb.g7uHu2yZuY0KCQORfFeMVFpMM5pYjscE4e2PsZeU&asPdf=false pdfs/33-R-0025_2017-06-02_bd0e0d6aef56.pdf match 3ef3d9a02647dea03f5d20975d39dcbd9753415895c6992151a2666771746f2b
c48c459827218985 Abbott Laboratories 33-R-0025 2017-06-02   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgfFr&d=%2Fa%2F3d000000pXYI%2Fb3K5WxftkhtSVZRwe1Dl1Ir_AK_dXeh47okVHwvAyJw&asPdf=false pdfs/33-R-0025_2017-06-02_c48c459827218985.pdf match 32be7d756ace77fa1b6b4314a9c922af58a187b40717031753a04118da1061fe
c9f2caed4a76 Abbott Laboratories 33-R-0025 2016-03-30   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egi1l&d=%2Fa%2F3d000000pXZ7%2F.wVa1AdQvfu5ud3kO_2DKbbTXGoeZy56hY1rI6QFlEw&asPdf=false pdfs/33-R-0025_2016-03-30_c9f2caed4a76.pdf match 39a66b2c97959ddc7ae57e0c21ff73cf93e8303204c998f8f47d60a8eac90d66
57dfb058d274eaa2 Abbott Laboratories 33-R-0025 2016-03-30   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egdc2&d=%2Fa%2F3d000000pXZH%2FY3yK6s4GCxjH9oaoffEGPfFOCVRthNwm46TLSYn1dWM&asPdf=false pdfs/33-R-0025_2016-03-30_57dfb058d274eaa2.pdf match 232fc9cd05be7577422a215637ec266065ef6d1694ecda1ee0e28caff6ccf590
ad7c30941dff Abbott Laboratories 33-R-0025 2015-05-07   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egnk0&d=%2Fa%2F3d000000pXYy%2FdY4ajHZSe940BWKJW3BDw.j2XkCjT.w3CaA3O9Irsm8&asPdf=false pdfs/33-R-0025_2015-05-07_ad7c30941dff.pdf match 46aee6866100b670a5af984bfd05ed9e500b676971ffb7ea3992c49bd2c9f9e6
7080a84f7bb9ed4d Abbott Laboratories 33-R-0025 2015-05-07   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgdA5&d=%2Fa%2F3d000000pXY5%2FnyH7FBjjXrrXqM584wxBL.qfRubu3nFo5cqhjK3Ii64&asPdf=false pdfs/33-R-0025_2015-05-07_7080a84f7bb9ed4d.pdf match be4c645a56fdaf4fcbd3faef8d00ebc0d49f2caedc59efccb74e89ecddf19917
6324a20ab923 Abbott Laboratories 33-R-0025 2014-07-08   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egi0J&d=%2Fa%2F3d000000pXZT%2FoSw8_a0pWBH3ajD8YCKKqv0tBewNgtWJBLohobFJiuw&asPdf=false pdfs/33-R-0025_2014-07-08_6324a20ab923.pdf match d9a9a92367776ce0686e45b6def27b609855cc09cbe6df4f9c0b142c2b12ba0e
71c330753820cfd9 Abbott Laboratories 33-R-0025 2014-07-08   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgdBi&d=%2Fa%2F3d000000pXZ3%2FC7y9k.ZOV_IF5aeNE77273FKCUEV2OwTuffsxSQfZlI&asPdf=false pdfs/33-R-0025_2014-07-08_71c330753820cfd9.pdf match 4d23148b989f044247a78a3e21d27064ed164dc88a2e95e03db1638a590b2eec

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