home / aphis_reports / inspections

inspections: a2d17e556e14642a

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
21-R-0223 Class R - Research Facility NEW YORK 0 325904 0 2016-01-05 NEW YORK STATE PSYCHIATRIC INSTITUTE 1 https://aphis--c.na107.content.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgXlE&d=%2Fa%2F3d000000pgLS%2F5SNxmKv_B5gcBQRTFCKxnLZ8OboTZQQyQ4TsLcy5j7g&asPdf=false NEW YORK STATE PSYCHIATRIC INSTITUTE New York 0 10032.0 a2d17e556e14642a 1970-01-01 00:00:00+00:00 5161121190525 a 325904.0 New York State Psychiatric Institute 1051 Riverside Drive New York, NY 10032 21-R-0223 001 NEW YORK STATE PSYCHIATRIC INSTITUTE ROUTINE INSPECTION 05-JAN-2016 05-JAN-2016 185.0 https://www.documentcloud.org/documents/23526783-aphis-inspection-5161121190525 R NY    

Links from other tables

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