Metal Content of Consumer Products Tested by the NYC Health Department

<b>This is an official DOHMH dataset. Creating derivative/community datasets based on this dataset is allowed so long as it is done in a manner that is not misleading and does not imply endorsement of such datasets by DOHMH.</b>

NYC DOHMH tests consumer products collected during investigations of lead poisonings and store surveys, for lead. Certain consumer products are also tested for other metals such as arsenic, cadmium and mercury. This dataset contains the laboratory results for the consumer products that are tested. For more information on hazardous consumer products, visit nyc.gov/hazardous products.

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/metal-content-of-consumer-products-tested-by-the-da9u-wz3r\".\"metal_content_of_consumer_products_tested_by_the\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.