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

42 rows where cert_number = "93-R-0516" 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
d80e36244a33e7dd CARRINGTON COLLEGE 93-R-0516 2020-02-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eglut&d=%2Fa%2F3d000000pnhH%2FbyPQ.CPzvFwDaGXDFIYyrDOJNTRCoDSO.gCdAGdJnBw&asPdf=false pdfs/93-R-0516_2020-02-25_d80e36244a33e7dd.pdf match 9092189a682afa21483516396cd60890df4f97cfbc57d82fd6cf1fe3227afa33
76e551f77c0f CARRINGTON COLLEGE 93-R-0516 2020-02-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egm8X&d=%2Fa%2F3d000000po5u%2Fw7c3ewxrSko05ISU5l4ZG1F4RkIjpTH9j9RNqD0mKtY&asPdf=false pdfs/93-R-0516_2020-02-18_76e551f77c0f.pdf match c385ed192284a03ddaf77730dde5b93dc76d4f93bc30edc4ebd00272da31d641
c2fb211a17e25912 CARRINGTON COLLEGE 93-R-0516 2020-02-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egkis&d=%2Fa%2F3d000000pdqX%2FQa5p9lVAb9.cCJVdHpT2rqEauqOW6szdZFzg.IE8Gok&asPdf=false pdfs/93-R-0516_2020-02-18_c2fb211a17e25912.pdf match 29dcbc4c7ef68aa28a61d8b9fafdd37296f3d99df7247d7626fb5441a490ce83
ee6b54065ea55fd5 CARRINGTON COLLEGE 93-R-0516 2020-02-05   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egl0j&d=%2Fa%2F3d000000poPh%2FtPzM_SsORooKeiVNkFIC7VLTg1m5uYHDnMU0d2I2F44&asPdf=false pdfs/93-R-0516_2020-02-05_ee6b54065ea55fd5.pdf match 7ace889dcf2c9dc9858bb549428ab90786cee37e99b29a0dd5f41e5909c9bf69
85fb981cdbce3b6c CARRINGTON COLLEGE 93-R-0516 2019-11-13   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgjWL&d=%2Fa%2F3d000000pSFm%2Fv.ZS3SfNqP.yv8qazscnhO8GbEYcVoM7JJl1J0c5CkI&asPdf=false pdfs/93-R-0516_2019-11-13_85fb981cdbce3b6c.pdf match 2615f0686773679c3cf59affe5811d0e3476455cd2f0770a50978ee4c5be7c9a
02725b162d92eb0e CARRINGTON COLLEGE 93-R-0516 2019-05-07   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egl8y&d=%2Fa%2F3d000000pb9I%2FMe4IGhC2BX1JctGIuhNxAsDtU9KxHj6I.bAsDrkS.1o&asPdf=false pdfs/93-R-0516_2019-05-07_02725b162d92eb0e.pdf match 8ddad444aed2241d62474b87cd3d5517f90d2cbd72c79a792670c620ebc9a3b9
c17d38f8da289096 CARRINGTON COLLEGE 93-R-0516 2019-04-24   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egjok&d=%2Fa%2F3d000000pfsW%2FrObbn0PQUMwKsXS7z3QJ1A9vVa7BqskuxKmbVPGptYk&asPdf=false pdfs/93-R-0516_2019-04-24_c17d38f8da289096.pdf match 83f16884002e4369380431b342819aac59e131a07bd802514877206a38e6c40e
82e7ad1d808585e2 CARRINGTON COLLEGE 93-R-0516 2019-04-17   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgkM9&d=%2Fa%2F3d000000pdMu%2FxMaQ_ODViv.1x0kKDlXAjyKZXgU0X5.UfOgp0.40N_E&asPdf=false pdfs/93-R-0516_2019-04-17_82e7ad1d808585e2.pdf match f7c44a5e662c85f0666f9e5e985fe568b3d6023a1e75487f06c93d94ddbc17d3
ce22988ec87cdad6 CARRINGTON COLLEGE 93-R-0516 2019-04-10   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgjDc&d=%2Fa%2F3d000000pbeX%2FU6rbknPHbiZ_xTzaWHvEbt2WKIV8HWxiUikJVViDcD4&asPdf=false pdfs/93-R-0516_2019-04-10_ce22988ec87cdad6.pdf match e41b9c06eb4b9903be702d22b48cb407ea57b898954db76584651b8062c1d017
50a316403a8d87bd CARRINGTON COLLEGE 93-R-0516 2019-04-05   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egm2B&d=%2Fa%2F3d000000pSlV%2FhdMzv4je9lMl5ywT8TTgArFq1zPmoMCJgepqMyMQc3I&asPdf=false pdfs/93-R-0516_2019-04-05_50a316403a8d87bd.pdf match 90bc6f565b454dfde3ada581ccb4c0e102b3c900d4afcdd4efa2a4f6f961be23
2c4bb244de02d8c5 CARRINGTON COLLEGE 93-R-0516 2018-11-08   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgkVO&d=%2Fa%2F3d000000pdtI%2FSk_qN_NZJ6JwoLShecfBr1QRvcRjTzqAYq3xx8bp1xg&asPdf=false pdfs/93-R-0516_2018-11-08_2c4bb244de02d8c5.pdf match efbb9c706c135063fe4dd52d43692a2d287e520d79f3a4540ea3842a81b1703b
a72ef1f50da999c8 CARRINGTON COLLEGE 93-R-0516 2018-08-08   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EglF0&d=%2Fa%2F3d000000pjhP%2FRd.P1zMasAvuwX.UYajuZ7cwEukvXsD6TzjZhDfBeJE&asPdf=false pdfs/93-R-0516_2018-08-08_a72ef1f50da999c8.pdf match 1a1a278c8d4f407c3f0461e51716fd89c6b1c195ea482bfb301e7fd07af18c10
4a572b2449f87832 CARRINGTON COLLEGE 93-R-0516 2018-04-09   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgjEO&d=%2Fa%2F3d000000pe2M%2FYiysTyotrPMSWnZ.C8aVTxEhIIDVt7RTeI33JatqBBw&asPdf=false pdfs/93-R-0516_2018-04-09_4a572b2449f87832.pdf match 9b0a4e78505dcb12d0df856316ede309fd3fb6a054df61e2afd8daed5adf5c2c
0f85a3d8bd7e29e8 CARRINGTON COLLEGE 93-R-0516 2018-04-04   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgjJu&d=%2Fa%2F3d000000pnTH%2FdSsLLnZruFazLq.5bPjjKqzD_EVyQRbB.XcyqQ_BBQM&asPdf=false pdfs/93-R-0516_2018-04-04_0f85a3d8bd7e29e8.pdf match 9c8461ae7d2a6bd399492e565e8edeb17dfcf09a416a20aa80233e5a38552216
73d0f84f963df28c CARRINGTON COLLEGE 93-R-0516 2018-02-20   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EglC7&d=%2Fa%2F3d000000pdOV%2Fvf1GDDFnp_NugDmiChNXV03jOYfV1Yj5eqQ3VuAmEpw&asPdf=false pdfs/93-R-0516_2018-02-20_73d0f84f963df28c.pdf match 59476fd5f335858f7cf932d5b02df427a90b033df90baf085c6275fb94928d35
d2cbb6fa9603c1e6 CARRINGTON COLLEGE 93-R-0516 2017-12-06   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgfgV&d=%2Fa%2F3d000000pnt1%2FSjJt.B5_cEjsiYDyuUKa4fBdNpFZZ66F_sPQrmPELFU&asPdf=false pdfs/93-R-0516_2017-12-06_d2cbb6fa9603c1e6.pdf match 9384572f96d56cd57024159c077022b111038a98ce642b97c0231dfdd8e420e4
3e1d89f53ab5a05c CARRINGTON COLLEGE 93-R-0516 2017-11-14   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egktk&d=%2Fa%2F3d000000piCE%2FiivZJYWZnZB5yivoK4VYvbtFzGx8QWmscFJxYE5aca8&asPdf=false pdfs/93-R-0516_2017-11-14_3e1d89f53ab5a05c.pdf match f019a369d983216cc4feca98764fb409d44f05f3d2c239e9fcc14099cf57f186
e5d45a3249687d5c CARRINGTON COLLEGE 93-R-0516 2017-06-14   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgXSU&d=%2Fa%2F3d000000pSnZ%2FWZUR_sqVvjx929iUVxgjkY24ZQkuITgvdNGFwMMuuTs&asPdf=false pdfs/93-R-0516_2017-06-14_e5d45a3249687d5c.pdf match be350a2e4ceff1323ec018c67d42f1dafd3aedcdfa5555ad5baee3701324fa35
51845e42d9022a03 CARRINGTON COLLEGE 93-R-0516 2017-05-09   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgdWY&d=%2Fa%2F3d000000pSqz%2F4iM_KZET7spFMm6aJrwlmju18RoY8CTtkrUDGnFL.qc&asPdf=false pdfs/93-R-0516_2017-05-09_51845e42d9022a03.pdf match dfe7e61d7912d408561369f37aa98175ab7911f7479466950d74fef3d33090eb
92ccaf17541b8e33 CARRINGTON COLLEGE 93-R-0516 2017-02-08   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgXoy&d=%2Fa%2F3d000000pWQ7%2FF5hLMx816kXRX7wo3syr_1bv20cSvEe8PyQJx66ieTg&asPdf=false pdfs/93-R-0516_2017-02-08_92ccaf17541b8e33.pdf match dcbc4e8afb3ec0560c0042ca68ea53778c956c33dae207de174c3aa8084c7548
f7fdebd16b4511a3 CARRINGTON COLLEGE 93-R-0516 2017-02-07   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgebF&d=%2Fa%2F3d000000pdOA%2FUNJpcNHk2hIUZ4WBcOqH49C42N_PRFzpHMVkU_2AnCQ&asPdf=false pdfs/93-R-0516_2017-02-07_f7fdebd16b4511a3.pdf match b8df70419bbeed63f50b489732ed9a88abf445ffab3fa2ddc87e4ec68f85a6ed
47c7359bbf17ab4f CARRINGTON COLLEGE 93-R-0516 2017-01-12   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EggsB&d=%2Fa%2F3d000000po88%2FupRUWvBNqnyzR4.tICPG_nZe8ovXKiJkSEdZC8ug3MQ&asPdf=false pdfs/93-R-0516_2017-01-12_47c7359bbf17ab4f.pdf match 174673c473d623cb4f27bfcf769222b7f44732ad53781670ad29e24a5088445f
d779123b6a60ca0f CARRINGTON COLLEGE 93-R-0516 2016-10-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgkrG&d=%2Fa%2F3d000000pf8e%2FrSZTkDupyFJ14dBDZMNc9zETAc6fc_0LDw6_FuCwwnQ&asPdf=false pdfs/93-R-0516_2016-10-27_d779123b6a60ca0f.pdf match 410e9001c76930edd7677dbb162700dee23a25f60f4c53c65b4804d2c06f03a8
f5e6f8d60c39ae71 CARRINGTON COLLEGE 93-R-0516 2016-03-22   0 2 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000DnuuB&d=%2Fa%2F3d000000pSb9%2FdSfzoJj_MOd0qInxEkch_Szei7ertHIme8zTvN54QLs&asPdf=false pdfs/93-R-0516_2016-03-22_f5e6f8d60c39ae71.pdf match f435cb6286f82bc9009be1fb70812a876521ae15bef69b3cbd9c2c00b8eb7f3f
9ce57265776d8310 CARRINGTON COLLEGE 93-R-0516 2016-03-08   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EglUj&d=%2Fa%2F3d000000pmAc%2Fm0dIeEYbR1f4Pkn38hoVUFEiGkf5ZZxelblAMyd5BNQ&asPdf=false pdfs/93-R-0516_2016-03-08_9ce57265776d8310.pdf match 8d3eca84416787fd9e5552c4403144fae24ea7a86665550fdc0950727eb94c0f
6557bc5043adea34 CARRINGTON COLLEGE 93-R-0516 2016-02-03   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgjRZ&d=%2Fa%2F3d000000pfTq%2FGh.2F_zjXSUQn9jYf0MMVSMpAHAa4NJjpfsJhUwBLWk&asPdf=false pdfs/93-R-0516_2016-02-03_6557bc5043adea34.pdf match 71278af47ebde4220bc9fbd50e915f19fdb69005bcdef84c693764e340d38979
70c4ea6b31b1c8fa CARRINGTON COLLEGE 93-R-0516 2016-01-28   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EglVL&d=%2Fa%2F3d000000pSjm%2FTlmHuyRJC7eEyWkVoXWqmGSfP0B2Qp6QNwt6c6oEAWM&asPdf=false pdfs/93-R-0516_2016-01-28_70c4ea6b31b1c8fa.pdf match 6c5daeed490453d5a0e57065ecdf16b3f0d93c1d86016e50cb23888cc0fda4df
b44c8dd3a3dd9e11 CARRINGTON COLLEGE 93-R-0516 2016-01-14   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgdVy&d=%2Fa%2F3d000000pUCu%2F0I2d2QwQm.sNbjdGQVf.Y_euDDQGC9i3EthTdx2XWvg&asPdf=false pdfs/93-R-0516_2016-01-14_b44c8dd3a3dd9e11.pdf match bd9350eb9d7a5a5a3f1c42cf8b791179ed88930f4ed07ad7dbb6b552f4c7b34d
31321f192be6e423 CARRINGTON COLLEGE 93-R-0516 2016-01-11   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgjcK&d=%2Fa%2F3d000000plJn%2F5o15zcju2v2ueZ66dXpMuDNM2iKu2Hf.dT10KnT.aXs&asPdf=false pdfs/93-R-0516_2016-01-11_31321f192be6e423.pdf match 073a4b1da4cb8e95df27dd893fa674111f060126b6f760e88671521d7d794e54
aa701434f3ba2d48 CARRINGTON COLLEGE 93-R-0516 2015-11-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgiGi&d=%2Fa%2F3d000000pdWV%2FEBvQC3CoYsvvwW.PKIlNWdwdELyLjLRFRQ3RK8hRdLg&asPdf=false pdfs/93-R-0516_2015-11-19_aa701434f3ba2d48.pdf match 4b935c48ec6b0b53e5d950b0e1a0f23fb7a3ab0661d70e981670bdf34d6cc7cc
64cf165dcd4d5950 CARRINGTON COLLEGE 93-R-0516 2015-08-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgctY&d=%2Fa%2F3d000000poxi%2FLrOkvlW0VT81slFkzDEK0xBPI5onNtU5nCRD3YIZHvg&asPdf=false pdfs/93-R-0516_2015-08-25_64cf165dcd4d5950.pdf match 59db160cd9ab7a026ac3f14d8b5ded8f566d94aa07607dfbe39eddb3a83e977f
523514e6623e7554 CARRINGTON COLLEGE 93-R-0516 2015-07-06   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgiT3&d=%2Fa%2F3d000000pf4Q%2FS5cxc.GJbclRjNdYuT.l88MbqNApfA9pDlokXLisqJo&asPdf=false pdfs/93-R-0516_2015-07-06_523514e6623e7554.pdf match 4f1a27ad545a18ebea172a492f850d2525ac93f58caa7df4d2941d6213799c03
0e3eda3ad5cecc22 CARRINGTON COLLEGE 93-R-0516 2015-04-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egf84&d=%2Fa%2F3d000000pdVv%2FcsCTkwwdTXVsfhY44KxSjl7s2QC76bKAR_2G_2y3l3c&asPdf=false pdfs/93-R-0516_2015-04-27_0e3eda3ad5cecc22.pdf match c0eceaae6a307aab4941b5a52dc46649ee2861285fbf5b4232a2b4fc0c5db93b
93399003f34333f5 CARRINGTON COLLEGE 93-R-0516 2015-03-31   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egk6w&d=%2Fa%2F3d000000pmZk%2FYOy2HGAblNlNC0MV9A5JWaZDA8ex5fnMzi3gN5K0WTY&asPdf=false pdfs/93-R-0516_2015-03-31_93399003f34333f5.pdf match d741af1aeaa03c76a1eefdbec7812e7d239496ef20e1bca3c45b45a8d8396ded
ac412927eeae116f CARRINGTON COLLEGE 93-R-0516 2015-03-17   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EglZh&d=%2Fa%2F3d000000pf7a%2FElzwKANx3ZQjUPDz8skoMjJZvwB9_YMBQXaZ._b_yfw&asPdf=false pdfs/93-R-0516_2015-03-17_ac412927eeae116f.pdf match 0341e276dfa0d6d93007af75dd253079a0150bb9c8fab92a20984f8ea02ed35a
316b51565b46dd48 CARRINGTON COLLEGE 93-R-0516 2015-03-12   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgiPo&d=%2Fa%2F3d000000pSaS%2Fw9.6sgtlsgjtHgvkR2NyKtkpSSfUvnTfA_VtQovbpD8&asPdf=false pdfs/93-R-0516_2015-03-12_316b51565b46dd48.pdf match b25566a08ed76d106d03bcd69981cb24b1255d097d42a6ba8a5bc65b298726da
48cf0e32e1454d76 CARRINGTON COLLEGE 93-R-0516 2015-02-11   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgfDD&d=%2Fa%2F3d000000pdTs%2FGnO3SfjbNEZlWkM.ggrqUetNK2.jUYuVhCD2w3TCDYA&asPdf=false pdfs/93-R-0516_2015-02-11_48cf0e32e1454d76.pdf match 862d2b127cc0323791fc401bcfcd3f983d81d02dbbd6960463ba283c8fc7c24a
a60fd35604f85603 CARRINGTON COLLEGE 93-R-0516 2015-02-05   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgXl5&d=%2Fa%2F3d000000pexL%2FSTI_Vq5flHtU8ED5ZIBC7lZuCgmY75FIjK3TMpwF50c&asPdf=false pdfs/93-R-0516_2015-02-05_a60fd35604f85603.pdf match aefeed3069dc327f60379963615ef3c337d8712bc1f1caaf98d44c78cf04ede1
1d560e069fe74993 CARRINGTON COLLEGE 93-R-0516 2014-06-16   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egj9i&d=%2Fa%2F3d000000pkts%2Fye105kILEDGZF5OXLsAx.p.yO.fJQJOa49Ow4c5mV.k&asPdf=false pdfs/93-R-0516_2014-06-16_1d560e069fe74993.pdf match 7e62727a20d9119818a00fd49f8b5e16936298d93a22ac0201471f5a84bf6f00
e2f6347024a39e4e CARRINGTON COLLEGE 93-R-0516 2014-06-09   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eghgg&d=%2Fa%2F3d000000palV%2F_psrn6QI9UHZWKObTA.L5OH95wcyB4FtzHATvGIn4aI&asPdf=false pdfs/93-R-0516_2014-06-09_e2f6347024a39e4e.pdf match f155c2be426b2a2875bc98bad8313832907aa470d0b6e14c4db0ce42918503c7
75063c2644799b74 CARRINGTON COLLEGE 93-R-0516 2014-03-17   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgdSX&d=%2Fa%2F3d000000pnnV%2FTwJ0243X2DaNPrGg_iTW1BNMmvvN9U9naGRZddgM2oE&asPdf=false pdfs/93-R-0516_2014-03-17_75063c2644799b74.pdf match 49d0ad8243524acacbc3046cc16702a583bf2351416a82df3a4323567f035688
cf81e1f37fc24dbc CARRINGTON COLLEGE 93-R-0516 2014-02-13   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egf2w&d=%2Fa%2F3d000000pWNL%2F4s3wislTUzRAaKwEJ_SzrJGzCojSTBZUcC80gpoDico&asPdf=false pdfs/93-R-0516_2014-02-13_cf81e1f37fc24dbc.pdf match 5bd1357d723a424284c84954bcd0b56917d4e2e94bd67a7b6b18a4a99bcaa8ae

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