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

15 rows where cert_number = "57-R-0004" 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
b522585320a4 Mercer University 57-R-0004 2026-02-03   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000011173E&d=%2Fa%2FSJ000008Ez5R%2Fzq2XQiLMasipc.gHwP3HhSKnLT3fqoAcKcG.1YWHaIc&asPdf=false pdfs/57-R-0004_2026-02-03_b522585320a4.pdf match cbeeb9c30978dae3d1e00646ff9b5ec16e41cb7d2876ec375fc932e596b2afe9
c072ab19a5d7506c Mercer University 57-R-0004 2025-05-07   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000XEYIO&d=%2Fa%2FSJ000003l3S9%2Ft4TGKQ2T.6Zx0qacojNnrg9Z_R.WemtsyFC20cT.39E&asPdf=false pdfs/57-R-0004_2025-05-07_c072ab19a5d7506c.pdf match 6e6d08272df54bd60b2d13495f305b10b786faba133700927190e8273f99f067
042459cc9a9884c4 Mercer University 57-R-0004 2024-02-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000CRQBg&d=%2Fa%2F3d000002Z2W2%2FVnpMnCndL3pLOf5IprcY4lnDO9u7ubollFYw3Bbj_E0&asPdf=false pdfs/57-R-0004_2024-02-27_042459cc9a9884c4.pdf match 518dcf956493f5f58154981518ec878347905dbf64f14481b7fb9eeeb6b253e3
fd58da05375900d2 Mercer University 57-R-0004 2023-07-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000009Cf3U&d=%2Fa%2F3d000001T6Se%2FZdOk1lEL299uc28LX9wfpzfkvjp4r1k1PkBWsa4fAXk&asPdf=false pdfs/57-R-0004_2023-07-19_fd58da05375900d2.pdf match 6bbc626bbf35af49e54ef48533961eefb4e99c727dd1d10fa6012eb318c50ed8
916d73e376caf5f8 Mercer University 57-R-0004 2022-04-13   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000YwiZK&d=%2Fa%2F3d000000piU8%2FS6MJnQBV40m2cZjR9I9nFSfQoFJ9A41H1UYFjSnWN1Q&asPdf=false pdfs/57-R-0004_2022-04-13_916d73e376caf5f8.pdf match fa0a6b5781c2b1ed64f3b000027b49227642d0e313c960a2dc546a06c5d488ca
aa14dc05a9e49fb9 Mercer University 57-R-0004 2020-11-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000FyMJD&d=%2Fa%2F3d000000pRkg%2F9TWeNKpe8Mgy4xnHbWVeJkzqgaMtFzg3AyHMpsXXKyU&asPdf=false pdfs/57-R-0004_2020-11-18_aa14dc05a9e49fb9.pdf match fb143d877ce000f23562462e1210a41b0be3941c75e61d8b8bf090a70e6653ee
649e610d7f16c3a7 Mercer University 57-R-0004 2019-07-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgjPY&d=%2Fa%2F3d000000pUkt%2FyZaY0APL5NQHU.Muc8uo7X47CAzXJ9ISPRr1x6CXYFs&asPdf=false pdfs/57-R-0004_2019-07-25_649e610d7f16c3a7.pdf match 6b71ca1d28e45d70b241b97478b5061df09eb1f9e69783126963cbceaeb94c00
579fa91d4590bef9 Mercer University 57-R-0004 2019-03-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgnrL&d=%2Fa%2F3d000000pn0u%2FcJoFEZXjREOqRtJlzOWJ.AEoV4e6WA6tRE9t7QhD_ZQ&asPdf=false pdfs/57-R-0004_2019-03-19_579fa91d4590bef9.pdf match d0da90b1d293196b50bab0357729f1983e07759dc5c2c3d5d048f14d35934f99
216adf430e19a179 Mercer University 57-R-0004 2018-07-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgoFX&d=%2Fa%2F3d000000potj%2F7uUmbA7tQEi4P4SpixWmPubAcHzUy9KAwXLtDlQA5lo&asPdf=false pdfs/57-R-0004_2018-07-23_216adf430e19a179.pdf match 2c4e926c6f4c6ae8b744efd8ef9ce193692497a27e1aba38301e7d157ebd79d0
31b6f720963d936e Mercer University 57-R-0004 2018-02-08   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eginl&d=%2Fa%2F3d000000ppBX%2F1L2M_rbixvGoAy9bvkf9cN9cmCxfqbFUQviAhnwTffk&asPdf=false pdfs/57-R-0004_2018-02-08_31b6f720963d936e.pdf match 229c2228b7dc897f5571e959347fb8769b81beeb7a46b201c5e80037a0e2e70f
34c73dd21f284797 Mercer University 57-R-0004 2017-04-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgeKf&d=%2Fa%2F3d000000pngp%2Fjw3OAHZ3MCbbz8.uscFoM2HbTj_F_Amsgee45s.N5CM&asPdf=false pdfs/57-R-0004_2017-04-25_34c73dd21f284797.pdf match fc2e863d26a255eb9fa3d80dd4b010b9d33b79ca72f7acc8898eb964b72ad284
694d714dc31100d5 Mercer University 57-R-0004 2016-08-10   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgklJ&d=%2Fa%2F3d000000pUKo%2F3BTQieyn023Z8ajxEZxozbcgEwujJ.AGvsRxLJ9QWv0&asPdf=false pdfs/57-R-0004_2016-08-10_694d714dc31100d5.pdf match b89338070db336cae27f191f61833e38cea6193770a52edf7839ecc734d431fa
16de01bbdeb7cf11 Mercer University 57-R-0004 2015-07-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eggkp&d=%2Fa%2F3d000000pdih%2Fu6zD4.FHM1EJ0P2zKAZtI8TRHiWWp0cTCg4zRw0QZ8U&asPdf=false pdfs/57-R-0004_2015-07-23_16de01bbdeb7cf11.pdf match 6e5d0a11d577cbd592f59bbcb98cac5ebae0d047890ab5d82ffb0e4aa1124e7e
af153f4a6a08e5b5 Mercer University 57-R-0004 2014-10-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egkob&d=%2Fa%2F3d000000pjBE%2FffPBd49DRSRlKOI_7beuapHIn1DcblbwXHkrn6N_9Uo&asPdf=false pdfs/57-R-0004_2014-10-23_af153f4a6a08e5b5.pdf match 5769c45af115ac21058c92314722f081fbcc65b961aa068b33cf3e1abeeebde0
182a3aae3e044358 Mercer University 57-R-0004 2014-03-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgjY7&d=%2Fa%2F3d000000poWt%2FISp3nl9XjpSaLhM2ecG6T.mAhbgagWokJl2a04XI3tE&asPdf=false pdfs/57-R-0004_2014-03-19_182a3aae3e044358.pdf match 3a52ad125f93871500527eb9f00e5e5a4b244356b4e4215c07f7937fe02aa581

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