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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/selfreported-drinking-water-tank-inspection-gjm4-k24g\".\"selfreported_drinking_water_tank_inspection\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.