cityofnewyork-us/metal-content-of-consumer-products-tested-by-the-da9u-wz3r
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 4 months ago
Indexed 6 hours ago

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.

 
Preview
  • metal_content_of_consumer_products_tested_by_the
     
     
     
     
     
Upstream Metadata