New York State Department of Health | Health Data NY

Close
Author
Open Data NY - DOH
Description
This dataset shows the school drinking water lead sampling and results information reported by each NYS public school and Boards of Cooperative Educational Services (BOCES) for Compliance Year 2016. Public Health Law (Section 110) and New York State (NYS) Department of Health regulation (10 NYCRR 67-4) mandate that NYS public school districts and (BOCES) test drinking water for lead contamination and report the results to parents, the NYS Department of Health, NY State Education Department, and local health departments. The regulation required school districts and BOCES complete their sampling by the Fall of 2016, and test again in 2020 and at least every five years thereafter or at an earlier time as determined by the Commissioner of Health. More information is available at the NYS Department of Health’s website at http://www.health.ny.gov/environmental/water/drinking/lead/lead_testing_of_school_drinking_water.htm.
Category
Health
Tags
environmental health, school, lead, drinking water
Rating
Current value: 0 out of 5
Data Provided By
New York State Department of Health
Source Link
http://www.health.ny.gov/environmental/water/drinking/lead/lead_testing_of_school_drinking_water.htm
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

School District
school_district
School
school
County
county
Type of Organization
type_of_organization
Number of Outlets
number_of_outlets
Any Buildings with Lead-Free Plumbing?
any_lead_free_buildings
Previously Sampled Outlets
outlets_sampled_before
Outlets Waiver Requested
outlets_waiver_requested
Waivers Granted
waivers_granted
Outlets Sampled After Regulation
outlets_sampled_after
Sampling Complete
sampling_complete
Sampling Completion Date
sampling_completion_date
Number of Outlets, Result ≤ 15 ppb
number_of_outlets_result_less
Number of Outlets, Result > 15 ppb
number_of_outlets_result_greater
Out of Service
out_of_service
All Results Received
results_complete
Date All Results Received
results_completion_date
School Website
school_website
BEDS Code
beds_code
School Street
school_street_address
School City
school_city
School State
school_state
School Zip Code
school_zip_code
Date Sampling Updated
date_sampling_updated
Date Results Updated
date_results_updated
County Location
county_location
Location
location
Counties
:@computed_region_9yqb_tdyd

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.