Self-Reported Drinking Water Tank Inspection Results by US Government | Healthcare

About this Dataset

Self-Reported Drinking Water Tank Inspection Results

This is an official DOHMH dataset. The Health Department does not endorse datasets using these data that may be created by others. The dataset contains the self-inspections of drinking water tanks that have been reported to the DOHMH through the NYC Drinking Water Tank Inspection Reporting Site [https://www.nyc.gov/site/doh/business/permits-and-licenses/drinking-water-tank-inspection-reporting.page] by a certified water tank inspector on behalf of the building owner. Submissions of 0 Drinking Water Tanks are not displayed in this dataset.
Organization: City of New York
Last updated: 2020-11-10T17:03:08.944727
Tags: drinking-water, inspection, watertanks

Tables

Table 1

@usgov.city_of_new_york_rooftop_drinking_water_tank_inspection_results.table_1

2.01 MB
55838 rows
49 columns


CREATE TABLE table_1 (
  "bin" DOUBLE,
  "borough" VARCHAR,
  "zip" DOUBLE,
  "house_num" VARCHAR,
  "street_name" VARCHAR,
  "block" BIGINT,
  "lot" BIGINT,
  "confirmation_num" VARCHAR,
  "reporting_year" BIGINT,
  "tank_num" BIGINT,
  "inspection_by_firm" VARCHAR,
  "inspection_performed" VARCHAR,
  "inspection_date" TIMESTAMP,
  "gi_req_internal_structure" VARCHAR,
  "gi_result_internal_structure" VARCHAR,
  "gi_req_external_structure" VARCHAR,
  "gi_result_external_structure" VARCHAR,
  "gi_req_overflow_pipes" VARCHAR,
  "gi_result_overflow_pipes" VARCHAR,
  "gi_req_access_ladders" VARCHAR,
  "gi_result_access_ladders" VARCHAR,
  "gi_req_air_vents" VARCHAR,
  "gi_result_air_vents" VARCHAR,
  "gi_req_roof_access" VARCHAR,
  "gi_result_roof_access" VARCHAR,
  "si_req_sediment" VARCHAR,
  "si_result_sediment" VARCHAR,
  "si_req_biological_growth" VARCHAR,
  "si_result_biological_growth" VARCHAR,
  "si_req_debris_insects" VARCHAR,
  "si_result_debris_insects" VARCHAR,
  "si_req_rodent_bird" VARCHAR,
  "si_result_rodent_bird" VARCHAR,
  "sample_collected" VARCHAR,
  "lab_name" VARCHAR,
  "nys_certified" VARCHAR,
  "analytes" VARCHAR,
  "coliform" VARCHAR,
  "ecoli" VARCHAR,
  "meet_standards" VARCHAR,
  "deleted" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "batch_date" VARCHAR
);