Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

NYC Drinking Water Tank Inspections and Audits Compliance Results

rytv-g5uiHealth22 columns
This is an official NYC Health Department dataset. The Health Department does not endorse datasets using these data that may be created by others. The dataset contains the drinking water tank oversight activity and compliance results for NYC buildings that have water tanks. The buildings listed have been reported to the NYC Health Department through the NYC Drinking Water Tank Inspection Reporting Site or were identified by the NYC Health Department during field observations. This dataset includes self-reported annual inspections (submitted by a certified water tank inspector on behalf of the building owner), NYC Health Department inspections, NYC Health Department audits, and other drinking water tank regulatory activity results.
View on NYC Open Data↗

Quality

A91.2 / 100

From a 500-row sample across 22 columns.

completeness99/ 25% weight
consistency68/ 20% weight
accuracy91/ 20% weight
timeliness98/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Self-Reported Drinking Water Tank Inspection Results0.52
    joins onlatitudestreet_namecouncil_district+6
  • NYC Cooling Tower System Inspection Results0.48
    joins onlatitudecouncil_districtlaw_section+12
  • NYC Pool Inspections0.38
    joins oncouncil_districtbincensus_tract+3
  • Active NYC Health Code Regulated Child Care Programs0.37
    joins onlatitudecouncil_district

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

binhousestreet_namezip_codeboroughstatusnumber_of_dwtactivity_typeactivity_yearviolation_codelaw_sectionviolation_text
108896120Hudson Yards10001ManhattanActive3NYC Health Department Audit2021AH7DNYCHC 141.07(b)Failure to inspect drinking water tank, including testing water for bacteriological content.

Columns

22 queryable · 22 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
bintextDepartment of Buildings (DOB) Building Identification Number0%202414510011673396962
housetextHouse number of the physical location of the drinking water tank(s)0%200150
street_nametextStreet name of the physical location of the drinking water tank(s)0%BROADWAYFIFTH AVENUEPARK AVENUE
zip_codetextZIP code of the physical location of the drinking water tank(s)0%100161002210001

Query this from your own app

GET /api/datasets/rytv-g5ui
GET /api/datasets/rytv-g5ui/quality
GET /api/datasets/rytv-g5ui/related
GET /api/columns?dataset=rytv-g5ui
bin
+6
  • DOHMH School Cafeteria Inspections (2020-Present)0.37
    joins onlatitudebinbbl+2
  • DOHMH Indoor Environmental Complaints0.35
    joins onlatitudecouncil_districtbin+4
  • NYC Cooling Tower Registrations0.35
    joins onlatitudecouncil_districtbin+5
  • Rodent Inspection0.34
    joins onlatitudestreet_namecouncil_district+7
    • 1088961
    20
    Hudson Yards
    10001
    Manhattan
    Active
    3
    NYC Health Department Audit
    2021
    AH7D
    NYCHC 141.07(b)
    Failure to inspect drinking water tank, including testing water for bacteriological content.
    108972255510 Avenue10036ManhattanActive1NYC Health Department Audit2021AH7DNYCHC 141.07(b)Failure to inspect drinking water tank, including testing water for bacteriological content.
    108972255510 Avenue10036ManhattanActive1NYC Health Department Audit2021AH7DNYCHC 141.07(b)Failure to inspect drinking water tank, including testing water for bacteriological content.
    1089862509West 29 Street10001ManhattanActive2NYC Health Department Audit2021AH7DNYCHC 141.07(b)Failure to inspect drinking water tank, including testing water for bacteriological content.
    1089862509West 29 Street10001ManhattanActive2NYC Health Department Audit2021AH7DNYCHC 141.07(b)Failure to inspect drinking water tank, including testing water for bacteriological content.
    10225681450Broadway10018ManhattanActive2NYC Health Department Audit2021AH7DNYCHC 141.07(b)Failure to inspect drinking water tank, including testing water for bacteriological content.
    101580831West 31 Street10001ManhattanActive1NYC Health Department Audit2021AH7DNYCHC 141.07(b)Failure to inspect drinking water tank, including testing water for bacteriological content.
    101580831West 31 Street10001ManhattanActive1NYC Health Department Audit2021AH7DNYCHC 141.07(b)Failure to inspect drinking water tank, including testing water for bacteriological content.
    300209426Court Street11242BrooklynActive2NYC Health Department Audit2021AH7DNYCHC 141.07(b)Failure to inspect drinking water tank, including testing water for bacteriological content.

    Showing 12 of 22 columns. All of them are listed below.

    borough
    categorical
    Borough of the physical location of the drinking water tank(s)
    0%
    MANHATTANManhattanBROOKLYNof 11
    statuscategoricalStatus of a building's drinking water tank(s)0%ActiveACTIVENot Activeof 4
    number_of_dwtcategoricalNumber of drinking water tank(s) (DWT) reported by building owner, certified water tank inspector or confirmed by the NYC Health Department during inspections, audits or other activities.0%123of 13
    activity_typecategoricalActivity type regarding the drinking water tank(s) (DWT)0%Self-Reported Annual Ins…SELF-REPORTED ANNUAL INS…NYC Health Department In…of 8
    activity_yearcategoricalYear in which activity took place0%202120222023of 6
    violation_codecategoricalOATH (Office of Administrative Trials and Hearings) Code92%AH7AAH7DAH7Eof 7
    law_sectioncategoricalSection/Rule of Law of Violation92%24RCNY 31-02(a)24RCNY 31-02(A)NYCHC 141.07(b)of 15
    violation_textcategoricalDescription of Violation92%Failure to submit report…FAILURE TO SUBMIT REPORT…Failure to inspect drink…of 14
    compliance_yearcategoricalYear for which a water tank was inspected, audited or other type of activity occurred0%202120222023of 8
    date_of_occurrencedatetimeDate of occurrence of the violation92%2022-01-24T00:00:00.0002026-02-02T00:00:00.0002023-02-10T00:00:00.000
    summons_numbertextSummons or Ticket Number for OATH hearing at ECB (Environmental Control Board)92%NA08713282150871269044
    bbltextBorough Block Lot of the building with the drinking water tank0%100721000720514101202039447501
    longitudefloatLongitude of the location of the building with the drinking water tank0%-74.005764-73.983135-73.870695
    latitudefloatLatitude of the location of the building with the drinking water tank0%40.70767140.82972640.764521
    community_boardtextCommunity Board of the location of the building with the drinking water tank0%105108107
    council_districttextCouncil District of the location of the building with the drinking water tank0%040306
    census_tracttextThe Census Tract of the location of the building with the drinking water tank0%013700010900009600
    nta_codetextNTA code of the location of the building with the drinking water tank0%MN0502MN0802MN0501