Lead Testing in School Drinking Water Sampling and Results Compliance Year 2016
health.data.ny.gov | Last Updated 23 Mar 2020This 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.
This dataset has the following 27 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| School District | school_district | text | School district name | NYC DOE BOCES No District Name BUFFALO CITY SCHOOLS ROCHESTER CITY SCHOOLS YONKERS CITY SCHOOLS view top 100 |
| School | school | text | School name | JOHN F KENNEDY SCHOOL LINCOLN SCHOOL PARK AVENUE SCHOOL GEORGE WASHINGTON SCHOOL THEODORE ROOSEVELT SCHOOL view top 100 |
| County | county | text | County where the school is located | Kings Queens Suffolk Bronx Nassau view top 100 |
| Type of Organization | type_of_organization | text | Public school or Board of Cooperative Educational Services (BOCES) | Public School BOCES School view top 100 |
| Number of Outlets | number_of_outlets | number | The total number of outlets required to be sampled | 62 80 74 50 61 view top 100 |
| Any Buildings with Lead-Free Plumbing? | any_lead_free_buildings | text | “No” or “This school has one or more buildings with lead-free plumbing” | No This school has one or more lead-free buildings view top 100 |
| Previously Sampled Outlets | outlets_sampled_before | number | Number of outlets sampled before September 2016, consistent with the regulation (10 NYCRR Subpart 67) | 0 10 20 30 28 view top 100 |
| Outlets Waiver Requested | outlets_waiver_requested | number | Number of outlets sampled before September 2016, substantially in compliance with the regulation, and a formal waiver was requested | 0 1 3 64 10 view top 100 |
| Waivers Granted | waivers_granted | number | Number of outlets that did not require sampling for Compliance Year 2016, as a formal waiver was granted | 0 64 65 57 74 view top 100 |
| Outlets Sampled After Regulation | outlets_sampled_after | number | Number of outlets sampled after the regulation went into effect | 0 4 1 2 3 view top 100 |
| Sampling Complete | sampling_complete | text | Indicates if all sampling for the school is complete. “Yes” = Complete/ “No” = Incomplete | Yes No view top 100 |
| Sampling Completion Date | sampling_completion_date | calendar_date | Date all sampling was completed including post-remediation sampling | view top 100 |
| Number of Outlets, Result ≤ 15 ppb | number_of_outlets_result_less | number | Number of outlets with lead results less than or equal to 15 parts per billion (ppb) (or 15 μg/L or 0.015 mg/L) | 47 62 54 53 74 view top 100 |
| Number of Outlets, Result > 15 ppb | number_of_outlets_result_greater | number | Number of outlets with lead result(s) greater than 15 ppb (or 15 μg/L or 0.015 mg/L) | 0 1 2 3 4 view top 100 |
| Out of Service | out_of_service | text | Indicates if all outlets with lead results greater than 15 ppb (or 15 μg/L or 0.015 mg/L) have been taken out of service. “Yes” = Outlets taken out of service/ “No” = Outlets not taken out of service or no outlets exceeded 15 ppb. | Yes No view top 100 |
| All Results Received | results_complete | text | Indicates if all lead results, including post-remediation sampling results, for all samples collected have been received. “Yes” = Received/ “No” = Not received | Yes No view top 100 |
| Date All Results Received | results_completion_date | calendar_date | Date all lead results were received, including post-remediation sampling results | 2018-09-25T00:00:00.000 2016-11-09T00:00:00.000 2016-10-31T00:00:00.000 2018-08-01T00:00:00.000 2016-11-10T00:00:00.000 view top 100 |
| School Website | school_website | text | The website where the lead results are/were posted | http://schools.nyc.gov/about-us/reports/water-safety www.buffaloschools.org rcsdk12.org www.yonkerspublicschools.org www.syracusecityschools.com view top 100 |
| BEDS Code | beds_code | text | Basic Education Data System (BEDS) code, the New York State Education Department identifier for NY schools | No School Q331 K768 R080 R037 view top 100 |
| School Street | school_street_address | text | School street | view top 100 |
| School City | school_city | text | School city | Brooklyn Queens Bronx Manhattan Staten Island view top 100 |
| School State | school_state | text | School state | NY view top 100 |
| School Zip Code | school_zip_code | text | School zip code | 10456 10457 11207 11746 11208 view top 100 |
| Date Sampling Updated | date_sampling_updated | calendar_date | Date sampling survey was last updated by the school | 2019-04-03T00:00:00.000 2018-10-11T00:00:00.000 2018-10-12T00:00:00.000 2016-11-10T00:00:00.000 2018-10-10T00:00:00.000 view top 100 |
| Date Results Updated | date_results_updated | calendar_date | Date results survey was last updated by the school | 2019-04-03T00:00:00.000 2018-10-11T00:00:00.000 2018-10-12T00:00:00.000 2018-10-10T00:00:00.000 2018-09-27T00:00:00.000 view top 100 |
| County Location | county_location | location | Latitude/longitude decimal degree coordinates for the region covered by the indicator, for use in mapping | view top 100 |
| Location | location | location | Latitude and longitude | view top 100 |