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

12 rows where cert_number = "72-R-0011" 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
69f809beaf27c5b8 Xavier University Of Louisiana 72-R-0011 2025-01-31   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000MLEmY&d=%2Fa%2FSJ00000236z0%2Flo3LKlxDvyTi4NEWSN2EZ_ExStfXtBeLcl_JUemNXUE&asPdf=false pdfs/72-R-0011_2025-01-31_69f809beaf27c5b8.pdf match b733e1b662477ebed3d95a03938b2aa5ef3c9593190bec8a89681ddd1ba29480
b2bde0da89391212 Xavier University Of Louisiana 72-R-0011 2024-06-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000EFSRh&d=%2Fa%2F3d0000036fTu%2FQSkid78LLb8pj_Rf0iQHpgletSnxbC3fFZMJDLSy.UM&asPdf=false pdfs/72-R-0011_2024-06-21_b2bde0da89391212.pdf match 30f317ecade2a624f261a2c14762388067c1fcbd1daa1f0157a938df54cddbf1
4189828da47b5593 Xavier University Of Louisiana 72-R-0011 2023-04-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000008AvQH&d=%2Fa%2F3d0000017tAz%2FDVDyxg4h0q_IG5E45ZcPWo2kP3fzJUpGrDPknp.GjgM&asPdf=false pdfs/72-R-0011_2023-04-18_4189828da47b5593.pdf match 076c4f8f1156699c16e767d754ddef9d9f139c067245060fc4ed1cf6e93838c1
67a346a1e818adde Xavier University Of Louisiana 72-R-0011 2022-07-12   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000YxeIm&d=%2Fa%2F3d000000pj48%2F63HRYXkgm0POg3tecrY._EUcIdptb34WI3FORrEkWX4&asPdf=false pdfs/72-R-0011_2022-07-12_67a346a1e818adde.pdf match 71d781c1a5f8880b0c998ce957cdae89b4cdfc6d9fef5496ccb1884c8d81c615
de161c8de4d24653 Xavier University Of Louisiana 72-R-0011 2021-05-05   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Nh3K4&d=%2Fa%2F3d000000pj45%2FY9OHoO0oAsPzYrGEdquV2wuCU_oq3ux7KcUiYx9ODe0&asPdf=false pdfs/72-R-0011_2021-05-05_de161c8de4d24653.pdf match 26c5f73e682970c46f9be5a40b17700d7dec06c753b202d607a02f231dfc7f32
a783ce5eeff23a35 Xavier University Of Louisiana 72-R-0011 2020-02-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egmui&d=%2Fa%2F3d000000pj5Q%2F0NUtssC9zFQoG2mrmw_k.gGPX0JUuObPPYwomViXNF0&asPdf=false pdfs/72-R-0011_2020-02-18_a783ce5eeff23a35.pdf match f734506393fc581e21bf0e1d2f4b15e02b104d1fe955daa1dde081b223d6ac67
cebcc44d4d0eb73e Xavier University Of Louisiana 72-R-0011 2019-08-26   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmV0&d=%2Fa%2F3d000000pj50%2F3x7k8B8g1wx.1okP933dWp8rYQMsgoLiXaKJd.DUbvw&asPdf=false pdfs/72-R-0011_2019-08-26_cebcc44d4d0eb73e.pdf match 3226964a9780c6b5334d58bd287e4be33e9cf2a2e5909784d685f5c3ec8fcea5
3e424b85eb56a6e4 Xavier University Of Louisiana 72-R-0011 2018-05-09   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egn6Y&d=%2Fa%2F3d000000pj5F%2FvktyCYtdgiqxgQC4gNgMvPgPu6iVLhE6azp6TOO1A2g&asPdf=false pdfs/72-R-0011_2018-05-09_3e424b85eb56a6e4.pdf match d334ba51d61988a692468563447a3d0f0e52c589aab37aaabff82a495864574f
183ce8fddfde97b2 Xavier University Of Louisiana 72-R-0011 2017-05-03   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egn59&d=%2Fa%2F3d000000pj3z%2FZKyKcywdDGSOPY7FNwoD1t7blPUEG1W0wp.vvvcqNSk&asPdf=false pdfs/72-R-0011_2017-05-03_183ce8fddfde97b2.pdf match 007942faf4874747c6d522494521f4e50642ffc1c57fbad76f092eef9605845f
3ea6725637bb624b Xavier University Of Louisiana 72-R-0011 2016-02-22   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgiI8&d=%2Fa%2F3d000000pj4E%2F2fLaMZSd92ntlNiRofMajYqpgvjbQFtQUK8EJslzocc&asPdf=false pdfs/72-R-0011_2016-02-22_3ea6725637bb624b.pdf match 485f68561f39b4633eaf916d651b67973984c917fc3eaf67d79eb4afe07f84da
ba561c5223d46e18 Xavier University Of Louisiana 72-R-0011 2015-05-15   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgksH&d=%2Fa%2F3d000000pj5E%2F6grfY7FETcCpnTHSE9N3JzIaB05sWCQlbvq7ZdY6CPA&asPdf=false pdfs/72-R-0011_2015-05-15_ba561c5223d46e18.pdf match 376d559d91666bc3b221e50994ad7062ea32626ffe914dc1e740647ef5ab16fe
721fbbc6f8b53157 Xavier University Of Louisiana 72-R-0011 2014-07-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EglZN&d=%2Fa%2F3d000000pj43%2FTwVYcgsV1Aqc8rBSWr7A_QHLnW2sOR_Lh9ix28Gr79I&asPdf=false pdfs/72-R-0011_2014-07-23_721fbbc6f8b53157.pdf match 99d02644fc4012640b586a834444c5e080f293e6d45e0b36dac74ea635bcd4c3

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