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

13 rows where cert_number = "42-R-0052" 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
713bdb6a1f50 Ape Cognition And Conservation Initiative 42-R-0052 2026-02-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ0000137MGC&d=%2Fa%2FSJ000008Y9lp%2FJmt7V6HPWXaQu3YYtgjNH1VVmHLlXzVrZczTznj0jko&asPdf=false pdfs/42-R-0052_2026-02-19_713bdb6a1f50.pdf match 80ecd7e8ae4a0877bdc8aa8bf855daa20a7bd3d7366618cbee1c8792109bc398
f168a1c06903f93e Ape Cognition And Conservation Initiative 42-R-0052 2024-10-02   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000008CxkT&d=%2Fa%2FSJ000000Xtk5%2Fn_6jWehZb4bAau1hTuWFtDqiMUyOgHBEFXUY5YL6n7M&asPdf=false pdfs/42-R-0052_2024-10-02_f168a1c06903f93e.pdf match a009c60758625091d1764f1ee27d2d06c079f6036d18cd7d448dc5c5bef5e142
ed035f894176067c Ape Cognition And Conservation Initiative 42-R-0052 2023-12-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000BQacu&d=%2Fa%2F3d000002GW0N%2F1k_iOIB1eN5Vn3CaY8HpEupLLrKDjsLhwmm49kGEIps&asPdf=false pdfs/42-R-0052_2023-12-21_ed035f894176067c.pdf match 6e0e63cf77826e2ba413ce598ef9c9e704279b8edb9c51ae483195e9721af1c5
8edc6e3124fb7208 Ape Cognition And Conservation Initiative 42-R-0052 2023-02-14   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000007uG1l&d=%2Fa%2F3d0000012nIm%2FrnE64DtYelzW5mtjuMTl2YpE4jd11YX92n2SOfCnGgc&asPdf=false pdfs/42-R-0052_2023-02-14_8edc6e3124fb7208.pdf match 1ca5ccc449bb688800b584e001ae162bdf289733022bad4ef83301d04a10b9f6
0e43c206fc89a519 Ape Cognition And Conservation Initiative 42-R-0052 2022-05-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Yx3wm&d=%2Fa%2F3d000000pgLs%2Fix31_weDt3_oTt812t4uWJ44xyrz_YuqCY2XaI3d0KE&asPdf=false pdfs/42-R-0052_2022-05-25_0e43c206fc89a519.pdf match 4c696cb1eac011dd1385cbd139a35bd9e04e159eead608a37adc3b1353eada5f
ade07f3baa17642e Ape Cognition And Conservation Initiative 42-R-0052 2021-09-03   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PN7tG&d=%2Fa%2F3d000000pgMw%2FeXF6HPwlSuHGgg2_1Xy7wToEgJXgEoEnbyjktUYJ2p4&asPdf=false pdfs/42-R-0052_2021-09-03_ade07f3baa17642e.pdf match 616719c2610db2b1724a9efe46c68f4a86d1678b55a76e020b687a1b9f77a704
f876821f0f2da080 Ape Cognition And Conservation Initiative 42-R-0052 2020-03-04   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eggoe&d=%2Fa%2F3d000000pgMI%2Fexs.v4gkbnl5QJ.NdQg16Z_M28JgoHcfVRaKd0KkIN4&asPdf=false pdfs/42-R-0052_2020-03-04_f876821f0f2da080.pdf match 58d5ea32e0e4d9be3249a28623aad33f5ff550b8479ee6c85ef63405d24d33bd
df5c65d395478f88 Ape Cognition And Conservation Initiative 42-R-0052 2019-03-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eggu0&d=%2Fa%2F3d000000pgMp%2FakOTI.sSpekSKVY7bvdIRQNwcEYRRbfkWLpBLGaid8s&asPdf=false pdfs/42-R-0052_2019-03-21_df5c65d395478f88.pdf match 238b998de685e09d3e0d48eff5f6afaa4c8b8ad74187099f1b8f6b056b457579
754702b8f35e2b66 Ape Cognition And Conservation Initiative 42-R-0052 2018-04-26   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgdYI&d=%2Fa%2F3d000000pgMd%2Fa3qnhYV1LjcwJGvNPrEqmOFAIqgVjCYd6EXFeo73n60&asPdf=false pdfs/42-R-0052_2018-04-26_754702b8f35e2b66.pdf match 6233487f5c86710eaa1cd2f57d0936774cee52530aeb9f5b895f30e5e358e108
7b9dd9d9f11bc2fa Ape Cognition And Conservation Initiative 42-R-0052 2017-05-22   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgddU&d=%2Fa%2F3d000000pgLn%2FTsT3rexK2J4ZeKQucRUUguUyWSdYSqp5TjHRwEkRpKE&asPdf=false pdfs/42-R-0052_2017-05-22_7b9dd9d9f11bc2fa.pdf match 18fc0436bfd04ed68dfc91b85983d21fd912ec527241ec1e124f4982ecbce45a
9716404ffc32699d Ape Cognition And Conservation Initiative 42-R-0052 2016-09-07   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EggDa&d=%2Fa%2F3d000000pgMa%2FpTYbLGwIEPxsEdwYSmKJhQ_kgzPBP7QKWNVtG.RgVfQ&asPdf=false pdfs/42-R-0052_2016-09-07_9716404ffc32699d.pdf match 67897593a31d9d263e1fc5904f89dee5482d215204cd854c9639d6b3b248f8e6
fca951bafe133d07 Ape Cognition And Conservation Initiative 42-R-0052 2015-07-20   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgcTA&d=%2Fa%2F3d000000pgMr%2FdvaZrCZOKlBKuGXqqq7qYcrhkjOYynmFK6jX_PXwK7c&asPdf=false pdfs/42-R-0052_2015-07-20_fca951bafe133d07.pdf match 268e5d132bcc4ac035fc14d9085dc2df7da56dc53c0a541973b304f6b92730f8
a2b13e7b022e5034 Ape Cognition And Conservation Initiative 42-R-0052 2014-09-09   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgfuM&d=%2Fa%2F3d000000pgN9%2FObcKXfNB_ZMvjS_GsTrtEFKovNlmwmmwwp4l6NlMiO0&asPdf=false pdfs/42-R-0052_2014-09-09_a2b13e7b022e5034.pdf match 28d5dc04ff153d7d0b9f093ccbe9c621d8a69fff6dee34bb238c5c23a64598b2

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