health-data-ny-gov/lead-testing-in-school-drinking-water-sampling-and-rkyy-fsv9
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 4 years ago
Indexed 2 hours ago

Lead Testing in School Drinking Water Sampling and Results Compliance Year 2016

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.

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 \"health-data-ny-gov/lead-testing-in-school-drinking-water-sampling-and-rkyy-fsv9\".\"lead_testing_in_school_drinking_water_sampling_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • lead_testing_in_school_drinking_water_sampling_and
     
     
     
     
     
Upstream Metadata