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 = "43-R-0122" 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
0b4f05a075c2 Altasciences Preclinical Columbia LLC 43-R-0122 2026-07-01   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00001Iuhlo&d=%2Fa%2FSJ00000BPoL3%2Fcna7YnSx5A82d.1.7YK7RH3xJiBoI05fa00sRzofmeY&asPdf=false pdfs/43-R-0122_2026-07-01_0b4f05a075c2.pdf match 215256145606179e61b6663aeb62699167b87b3fc621ca3eb3272279e427d659
eb76d25102dd5be6 Altasciences Preclinical Columbia LLC 43-R-0122 2025-04-28   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000W0ipx&d=%2Fa%2FSJ000003UmYX%2FCNdAT5YiqSkvNVAGlHzwHsjDX50hfixiVyRao8bQuNY&asPdf=false pdfs/43-R-0122_2025-04-28_eb76d25102dd5be6.pdf match 2d33afbd4da75f291bbf48178ba7c435b86ffdc734aa7bc4b64e059702526f54
d6b4fa43d2c95ce0 Altasciences Preclinical Columbia LLC 43-R-0122 2024-08-20   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000002dCxq&d=%2Fa%2FSJ000002T3hz%2FdK1YBXRoRqON_bUmDi_5EuqMR0_ENWMfHXz9Dja8NMM&asPdf=false pdfs/43-R-0122_2024-08-20_d6b4fa43d2c95ce0.pdf match f07655411c25642a59f71e016a1ec0c717ff4c067116b4849e0d06b6513be2dd
baaf0e995ddfad52 Altasciences Preclinical Columbia LLC 43-R-0122 2023-07-24   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000009J4b8&d=%2Fa%2FSJ000002T3ip%2FnOqIxq7NmHJ6YVflZNwsUrAQAjyksnf8Ni2EmtFIVf0&asPdf=false pdfs/43-R-0122_2023-07-24_baaf0e995ddfad52.pdf match 2ca060c708e24eaf9135c8ce4f26bbe91215719fe7cebd755c3f820628664e43
30227604d4776d9b Altasciences Preclinical Columbia LLC 43-R-0122 2022-08-29   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000aw4kX&d=%2Fa%2FSJ000002T3ii%2F7HrF4_sVWkpAu1DFAwxoe7UcgUVXqNsMEfB_qi46qWQ&asPdf=false pdfs/43-R-0122_2022-08-29_30227604d4776d9b.pdf match bcae6f05046ae9f871e06b57d02750879fdd951e53f5d093732240ddba020e5b
596207171d04d6d7 Altasciences Preclinical Columbia LLC 43-R-0122 2021-08-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PN1qU&d=%2Fa%2FSJ000002T3jE%2FmsH1vUiMCWlncUjCYGZC1R2Z8QNPpMkf67ponIeLHa4&asPdf=false pdfs/43-R-0122_2021-08-23_596207171d04d6d7.pdf match 78107566a8c416f952a7490d997ca2b265cfecc2997b51504e4fd438cccda34c
3f4f6cc03372d8df Altasciences Preclinical Columbia LLC 43-R-0122 2020-09-09   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000DnVdo&d=%2Fa%2FSJ000002T3i2%2FcsE5gZGma1SaWTsVVogQwj88sbTB0MCqv4bDI02FLso&asPdf=false pdfs/43-R-0122_2020-09-09_3f4f6cc03372d8df.pdf match 79c155b354e7061a6769ec576791e7071bb828fc8dead1c913f7133e5e68ffd2
f4997fd6d172372d Altasciences Preclinical Columbia LLC 43-R-0122 2019-06-04   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egj2g&d=%2Fa%2FSJ000002T3hN%2F9TB1wHLw4I1YkTUnWP3VTKfjoQgoEtACRT6W93_GQao&asPdf=false pdfs/43-R-0122_2019-06-04_f4997fd6d172372d.pdf match d7050fba9bce73178252c3dd9c7b698850763384b64aefaa725ed9ac113984d3
bd0a31a8dd3d1ea2 Altasciences Preclinical Columbia LLC 43-R-0122 2018-09-04   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgZB3&d=%2Fa%2FSJ000002T3i4%2FKDuzmjQX7KhrE2kQhC5kjieb1kMjQOgjkkJc2pwUH8M&asPdf=false pdfs/43-R-0122_2018-09-04_bd0a31a8dd3d1ea2.pdf match 36b344f654d5ea6985501b628bc38d7aa789f749e9f1e880375c598429b00c44
c008ae97be0227b8 Altasciences Preclinical Columbia LLC 43-R-0122 2017-09-05   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgYnw&d=%2Fa%2FSJ000002T3iP%2FIUvqHdavm8.A5isY_z5FwVXyQQIH6fKT8nuVTfmvsjU&asPdf=false pdfs/43-R-0122_2017-09-05_c008ae97be0227b8.pdf match a5786e0f2007c805e2d08bd9fcdabebd4a133de078e054bfb53dc068b7c88a3d
9c4b0cc25d84fe43 Altasciences Preclinical Columbia LLC 43-R-0122 2016-06-20   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgYJz&d=%2Fa%2FSJ000002T3hn%2FNLAfLpeVv9gcx9kETCQxbzMbggwugqQ3AEUeEjN_yN8&asPdf=false pdfs/43-R-0122_2016-06-20_9c4b0cc25d84fe43.pdf match c83943c0d8e35320888b0c6d8cf63d6b44231817f2858870c8c43ac222391058
7a6ec1bab4f75bc8 Altasciences Preclinical Columbia LLC 43-R-0122 2015-07-27   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgWTu&d=%2Fa%2FSJ000002T3iX%2FpoJldVndP0POlyoP.CCntl8V0srhJzgg_pcgaWLXBj4&asPdf=false pdfs/43-R-0122_2015-07-27_7a6ec1bab4f75bc8.pdf match 2a0a54ed2950b01619cb8e24c57bbf7b83d5e131e5d9c625a451de9350e328bb
96904db8460fece9 Altasciences Preclinical Columbia LLC 43-R-0122 2014-09-02   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgXeI&d=%2Fa%2FSJ000002T3kV%2FNgAD7u4PSLOnaY79G5UtwzPvvsFeMBrAC75FsQ_P02M&asPdf=false pdfs/43-R-0122_2014-09-02_96904db8460fece9.pdf match 86d5f059ae1e0bd7b75957ed11aa5859f4dc2ee632215567f49d14200a464ad2

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