Childhood Blood Lead Testing and Elevated Incidence by Zip Code: Beginning 2000

This dataset contains the number and rate of children that reside in each New York State zip code, excluding New York City, who were tested for lead and identified for the first time within the specified time period to have elevated concentrations of lead in their blood. Under current NYS Public Health Law and implementing regulations, health care providers are required to test all children for lead at or around age one year and again at or around age two years. Health care providers are also required to assess all children age six months to 72 months of age at least once annually for lead exposure, with blood lead testing for all children found to be at risk, based on those assessments. For more information, check out: http://www.health.ny.gov/environmental/lead/.

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/childhood-blood-lead-testing-and-elevated-d54z-enu8\".\"childhood_blood_lead_testing_and_elevated\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.