Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Metal Content of Consumer Products Tested by the NYC Health Department

da9u-wz3rHealth12 columns
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. 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.
View on NYC Open Data↗

Quality

A93.2 / 100

From a 500-row sample across 12 columns.

completeness100/ 25% weight
consistency88/ 20% weight
accuracy89/ 20% weight
timeliness92/ 15% weight
usability95/ 20% weight

Related datasets

  • DOHMH School Cafeteria Inspections (2020-Present)0.37
  • NYC Farmers Markets0.36
  • NYC Dog Licensing Dataset0.34
  • NYC Cooling Tower Registrations0.34
  • Recognized Shop Healthy Stores0.34
  • Active NYC Health Code Regulated Child Care Programs0.33
  • DOHMH Indoor Environmental Complaints0.32
  • Beach Water Samples0.32

Sample rows

row_idproduct_typeproduct_namemetalconcentrationunitsmanufacturermade_in_countrypurchase_countrycollection_dateinvestigation_typeanalysis_type
1Food-SpiceTurmeric powderLead2.9ppmUNKNOWN OR NOT STATEDINDIAUNITED STATES2011-01-04T00:00:00.000CLaboratory
2

Columns

12 queryable · 12 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
row_idintegerEach row ID represents unique laboratory test result for the consumer product tested.0%477327472482
product_typecategoricalType of consumer product tested: • Cosmetics • Food-Spice; Food-Candy; Food-Other • Jewelry • Dietary Supplement/Medications/Remedy • Paint Supplies • Religious powder • Tableware/Pottery • Toys/Children’s products • QA/QC – Lab test • Other0%Food-SpiceDietary Supplement/Medic…Food Otherof 12
product_nametextName of product as it appears on product label or as reported to staff during investigation.0%TurmericCuminTurmeric Powder
metalcategorical"Name of metal for which product was tested: • Arsenic • Cadmium • Lead • Mercury "

Query this from your own app

GET /api/datasets/da9u-wz3r
GET /api/datasets/da9u-wz3r/quality
GET /api/datasets/da9u-wz3r/related
GET /api/columns?dataset=da9u-wz3r
Food-Spice
Cumin powder
Lead
2.4
ppm
UNKNOWN OR NOT STATED
INDIA
UNITED STATES
2011-01-04T00:00:00.000
C
Laboratory
3Food-SpiceCumin seedsLead2.8ppmUNKNOWN OR NOT STATEDINDIAUNITED STATES2011-01-04T00:00:00.000CLaboratory
4Food-SpiceMasalaLead12ppmUNKNOWN OR NOT STATEDUNKNOWN OR NOT STATEDUNITED STATES2011-01-04T00:00:00.000CLaboratory
5Food-CandyTamarind CandyLead-1ppmUNKNOWN OR NOT STATEDUNKNOWN OR NOT STATEDUNITED STATES2011-01-06T00:00:00.000ALaboratory
6Food-CandyLucas Muecas candyLead-1ppmLucas MuecasMEXICOUNITED STATES2011-01-06T00:00:00.000ALaboratory
7JewelryAmulet (Tabeez)Lead580000ppmUNKNOWN OR NOT STATEDBANGLADESHBANGLADESH2011-01-13T00:00:00.000CLaboratory
8CosmeticsSurma (Hashmi)Lead410000ppmUNKNOWN OR NOT STATEDPAKISTANPAKISTAN2011-01-19T00:00:00.000CLaboratory
9Food-SpicePowdered red pepperLead-1ppmUNKNOWN OR NOT STATEDINDIAINDIA2011-01-19T00:00:00.000CLaboratory
10Food-SpiceTurmeric (Haldi)Lead-1ppmUNKNOWN OR NOT STATEDINDIAINDIA2011-01-19T00:00:00.000CLaboratory
0%
LeadMercuryArsenicof 5
concentrationfloatThe amount of metal found in the sample of product tested. Sample with a metal concentration below the laboratory reporting limit is marked “-1”, meaning “Not Detected”.0%-109.9
unitscategoricalUnit of measurement: • ppm or parts per million • mg/cm2 or milligram per square centimeter • mg/L0%ppmmg/cm^2mg/lof 4
manufacturertextThe name of the manufacturer as it appears on product label or as reported to staff during investigation.0%UNKNOWN OR NOT STATEDLanzhou Traditional Herb…Goodcare Pharma Pvt. Ltd…
made_in_countrytextName of country where the product was made as it appears on product label or as reported to staff during investigation.0%UNKNOWN OR NOT STATEDINDIABANGLADESH
purchase_countrytextName of country in which the product was purchased as reported to staff during case investigation or noted by staff during store survey.0%UNITED STATESUNKNOWN OR NOT STATEDBANGLADESH
collection_datedatetimeDate the product sample was collected.0%2019-06-27T00:00:00.0002015-02-25T00:00:00.0002016-11-03T00:00:00.000
investigation_typecategoricalHow the product was obtained0%CSAof 3
analysis_typecategoricalHow the product was tested0%LaboratoryXRFof 2