home / aphis_reports / inspections

inspections: 78961d4d643df2f5

This data as json

web_certNumber web_certType web_city web_critical web_customerNumber web_direct web_inspectionDate web_legalName web_nonCritical web_reportLink web_siteName web_state web_teachableMoments web_zip hash_id discovered pdf_insp_id pdf_layout pdf_customer_id pdf_customer_name pdf_customer_addr pdf_certificate pdf_site_id pdf_site_name pdf_insp_type pdf_date pdf_report_date pdf_animals_total doccloud_url licenseType customer_state lat lng
16-R-0001 Class R - Research Facility NEW HAVEN 0 48 0 2021-07-12 Yale University 1 https://aphis--c.na107.content.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PMalV&d=%2Fa%2F3d000000pjSL%2FMGj_MSzYgL8Q87iu1lDIPDG0jwhSvgDTMLAB.Qp0HNI&asPdf=false YALE UNIVERSITY Connecticut 1 06510 78961d4d643df2f5 1970-01-01 00:00:00+00:00 2016090000659676 b 48.0 YALE UNIVERSITY OFFICE OF RESEARCH ADMIN PO BOX 208327 NEW HAVEN, CT 06520 16-R-0001 001 YALE UNIVERSITY ROUTINE INSPECTION 12-JUL-2021 15-JUL-2021 641.0 https://www.documentcloud.org/documents/23470377-aphis-inspection-2016090000659676 R CT 41.3064267 -72.9310217

Links from other tables

  • 1 row from hash_id in citations
  • 1 row from hash_id in citation_inspection
Powered by Datasette · Queries took 4.517ms