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

6 rows where cert_number = "67-R-0003" 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
3a05156cee1d Guardian Centers of Georgia, LLC 67-R-0003 2026-03-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000016W7da&d=%2Fa%2FSJ000009AR3T%2F3IQ6DJrR00keAG8UPfSccP_8sBhXunK1ut6QTRKDu0w&asPdf=false pdfs/67-R-0003_2026-03-19_3a05156cee1d.pdf match b44aaf1f100cc4c5087ae0e8ec9b97d85dd7965c26a7039704811fdb92330046
095fb59e58ef659e Guardian Centers of Georgia, LLC 67-R-0003 2025-07-09   0 3 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000enonz&d=%2Fa%2FSJ000004tEsr%2FICfPOjJSxSJpLBc5H4JJ.XJ3WWvAhVsblEkOdsHIbdk&asPdf=false pdfs/67-R-0003_2025-07-09_095fb59e58ef659e.pdf match e2a5869ffe7c28635c6e65926bd316bedce3da72ff89cc85b51eb76f3b88fef6
8d8a5078a6072198 Guardian Centers of Georgia, LLC 67-R-0003 2024-05-31   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000EBXSF&d=%2Fa%2F3d0000035xqx%2F974oxxO_0iSY4YfE1VlnWtbFe5VZtY6sYC6ZXjzq5Ts&asPdf=false pdfs/67-R-0003_2024-05-31_8d8a5078a6072198.pdf match 7925a07ec3bc70c7ea2f30439551bc124ed1e60f9f84893ded6166fc344618fb
edaba25de8c2a716 Guardian Centers of Georgia, LLC 67-R-0003 2024-01-10   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000BfYT0&d=%2Fa%2F3d000002LGLE%2FXCNysjJ7c4bk2dKDNEZCkYda1_4R7nz4.oD2CU7HvWk&asPdf=false pdfs/67-R-0003_2024-01-10_edaba25de8c2a716.pdf match 9afab169f98bc9593f48f994a8dd53e8d7bb80bdc6c1b23476decdb3b7cbe56b
a947dad38b047f05 Guardian Centers of Georgia, LLC 67-R-0003 2023-03-03   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000007ubeT&d=%2Fa%2F3d0000012uy5%2FjEwTvq4a0C87BXCZfWpgN5psqGvPeKNEIi2VyL.OkRA&asPdf=false pdfs/67-R-0003_2023-03-03_a947dad38b047f05.pdf match 7bf0d0a3b74e5bcdc1e6a6570c6e131689717ead02de52a567c8835cc1e7dbd5
64b6fb0d083da290 Guardian Centers of Georgia, LLC 67-R-0003 2022-09-22   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000awOyT&d=%2Fa%2F3d000000pZdK%2FnRNRXgFcsokrR5se5LPCsscjPuYkIycTR5QeM8Lk3oQ&asPdf=false pdfs/67-R-0003_2022-09-22_64b6fb0d083da290.pdf match 83cfb72701bd1e5ba74d1b0a70f2ba31404688f39e75c1e269891f62eb37ce82

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