home / aphis_reports / inspections

inspections: dd77b186228ae7dd

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
22-R-0036 Class R - Research Facility WEST POINT 0 181 0 2014-06-17 Merck Sharp and Dohme LLC 1 https://aphis--c.na107.content.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Dnxg2&d=%2Fa%2F3d000000pYbr%2FfZ2K6_VhXATeV5OE7OpTRdeSDRb5Ntx6nNClrzFxA3w&asPdf=false MERCK SHARP & DOHME CORP Pennsylvania 0 19486 dd77b186228ae7dd 1970-01-01 00:00:00+00:00 170140945080533 a 181.0 Merck Sharp & Dohme Corp 126 E Lincoln Ave, Ry 33-508 Rahway, NJ 07065 22-R-0036 001 MERCK SHARP & DOHME CORP ROUTINE INSPECTION 17-JUN-2014 20-JUN-2014 1981.0 https://www.documentcloud.org/documents/23471431-aphis-inspection-170140945080533 R NJ 40.5939492 -74.29149129999999

Links from other tables

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