Metal Content of Consumer Products Tested by the NYC Health Department
New York City Department of Health and Mental Hygiene tests consumer products, those collected during investigations of lead poisonings and store surveys, for lead. Certain consumer products are also tested for other metals such as arsenic 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/hazardousproducts.</p>
Health department staff collects information as it appears on product labels or as reported to staff during investigations. Factors such as language barriers and terminology variations may result in misspellings in some of the data fields. Also, there are many variables that may affect the amount of metal found in a consumer product. Variations in product ingredients and manufacturing processes may result in different metal concentrations found within a given product. Therefore, results are representative of only the tested samples at the time they were tested. The data does not reflect any changes to the product that may have been made since the date of testing.
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.