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

10 rows where cert_number = "52-R-0130" 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
7ad31df39d47cafa James Madison University 52-R-0130 2023-05-22   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000008Vdr5&d=%2Fa%2F3d000001EDby%2FJqSXjPUtkKh9FS46_LPgbEbrxiGZqujPWGjaXyLvKCo&asPdf=false pdfs/52-R-0130_2023-05-22_7ad31df39d47cafa.pdf match 85c70e2a7c7e5f4b7e4f5d947c05b93fc86042d85aa48ca1af6fa8764fef4125
9f0fb4b408e04527 James Madison University 52-R-0130 2022-07-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Yxhtu&d=%2Fa%2F3d000000pjad%2FOM.x_KUdt2zX8MX2x51bcr0vGlFRo9ejo.oeB9TIbeU&asPdf=false pdfs/52-R-0130_2022-07-21_9f0fb4b408e04527.pdf match 7d15660592dfa5800212752e83921c6eca6f97231c979dec135acd34ce2d5e21
63b0f7f1940ac3d5 James Madison University 52-R-0130 2021-05-17   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Nh7Tg&d=%2Fa%2F3d000000pjb2%2F3qd.ILXg8AThlsUfA4TktFSYYJymVmDNQrGhk3p.mvU&asPdf=false pdfs/52-R-0130_2021-05-17_63b0f7f1940ac3d5.pdf match c7f3f27839714350cb45b737a39268edca1bc319b47860b20bd87873816dcb53
3d0a10241377e41f James Madison University 52-R-0130 2020-01-08   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eggd0&d=%2Fa%2F3d000000pjbS%2FjygrFkwScsC06kTVPjOBlZs6tL7nw_dblhOPm9qLZ4U&asPdf=false pdfs/52-R-0130_2020-01-08_3d0a10241377e41f.pdf match 24ea67b047000d74248ed85afa6145a923bcd11021f633e9e3626ff6d0f63d1c
3cb79d4c7480fd59 James Madison University 52-R-0130 2019-04-09   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eghj0&d=%2Fa%2F3d000000pjaM%2FB21uO6Z7N_0oyaVt3ic5tilGdhzMmLuaxG6gSB0rudc&asPdf=false pdfs/52-R-0130_2019-04-09_3cb79d4c7480fd59.pdf match 6b840fc05790b7855d14b56f3c1de581a5e5305b0b34e121f27f5d925c94ccff
196a36b6346588b6 James Madison University 52-R-0130 2018-05-17   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EggZm&d=%2Fa%2F3d000000pjai%2FympTywsSI3ZWzEX4.Cgu.6OqkmU_qTC2HHyVhKY7szQ&asPdf=false pdfs/52-R-0130_2018-05-17_196a36b6346588b6.pdf match 8a9a165665be54943881c9512a3f3512abcddc400dc60c7f40d99bffba019cd0
ae0365f27bdde368 James Madison University 52-R-0130 2017-02-06   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egfz2&d=%2Fa%2F3d000000pjaW%2FabMoLMXHWAiPt_ohSfQUJLV.Y_2BPdNRI2f6gbLBIUE&asPdf=false pdfs/52-R-0130_2017-02-06_ae0365f27bdde368.pdf match b10cb88bd351c7c5e558c2974af4c6ec1fd0c9824f7c33862f9029ab9810c376
647405f28f6f426a James Madison University 52-R-0130 2016-04-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eghdk&d=%2Fa%2F3d000000pjar%2FdXB9A1qbZF619CQDK5AfY4MvGZpWPqOb6Dh1sBFBw1Y&asPdf=false pdfs/52-R-0130_2016-04-25_647405f28f6f426a.pdf match f5085ed9a3548f93574d0ad78ba393453db33b4aef4d6e82dbff9e7749a9fdbf
6ba48087dc674272 James Madison University 52-R-0130 2015-09-14   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egfna&d=%2Fa%2F3d000000pjac%2FA_LkwL4CKGreVXvEcEs6Cl1DkAjzBRBKpS.o9YRgJCc&asPdf=false pdfs/52-R-0130_2015-09-14_6ba48087dc674272.pdf match bf40447c6656649d514a4be1927075ccd1ec30e4356d4f7db9a59f7a50c06a1e
2813980944b98237 James Madison University 52-R-0130 2014-07-08   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgaCl&d=%2Fa%2F3d000000pjaO%2FI09CMyB3pDdM.m1dCaJpNXnl3Z8wCJQelJPAfDGufYI&asPdf=false pdfs/52-R-0130_2014-07-08_2813980944b98237.pdf match 1376379536dcf003b2034f4550ce59a65f5997f8751bcb86b504a06d803f30de

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