home / aphis_reports / inspections

inspections: 17bbe85a89da7862

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
95-R-0003 Class R - Research Facility HONOLULU 0 18 0 2014-07-29 QUEENS MEDICAL CENTER 1 https://aphis--c.na107.content.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egfbh&d=%2Fa%2F3d000000pXgJ%2FfYUglGRZFhK2Lp4Q5LdfgPHku5XQHbmWWROwLgJiDYM&asPdf=false QUEEN'S MEDICAL CENTER Hawaii 0 96813 17bbe85a89da7862 1970-01-01 00:00:00+00:00 224141247040767 a 18.0 Queens Medical Center 1301 Punchbowl Street Honolulu, HI 96813 95-R-0003 001 QUEEN'S MEDICAL CENTER ATTEMPTED INSPECTION 29-JUL-2014 12-AUG-2014 0.0 https://www.documentcloud.org/documents/23470219-aphis-inspection-224141247040767 R HI 21.3080814 -157.8543616

Links from other tables

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