home / osha_enforcement / inspection

inspection: 101402

This data as json

activity_nr reporting_id state_flag estab_name site_address site_city site_state site_zip owner_type owner_code adv_notice safety_hlth sic_code naics_code insp_type insp_scope why_no_insp union_status safety_manuf safety_const safety_marit health_manuf health_const health_marit migrant mail_street mail_city mail_state mail_zip host_est_key nr_in_estab open_date case_mod_date close_conf_date close_case_date ld_dt
101402 215000   HUDSON PIPE NIPPLE MFG CO INC 28-32 LOCUST ST New York -Richmond NY 11206   0   H 3321 0 H A   A       X             0   12 1984-02-23   1984-04-09 1984-07-13 2011-10-14 16:38:47 EDT

Links from other tables

  • 1 row from activity_nr in violation
  • 0 rows from rel_insp_nr in accident_injury
  • 0 rows from activity_nr in optional_info
  • 0 rows from activity_nr in related_activity
  • 0 rows from activity_nr in strategic_codes
Powered by Datasette · Queries took 1.852ms