About this Dataset

LeadBloodLevels 2017 ByMSA 20181129

This dataset contains lead blood levels, by Metropolitan Statistical Area (MSA), for the state of Michigan in 2017. An elevated blood lead level (EBLL) was defined by blood lead levels above 4.5 micrograms of lead per deciliter of blood (μg/dL). Data Driven Detroit received lead blood level test results for individuals in the state from Michigan Department of Health and Human Services, and then aggregated the data to anonymize results. Areas with null values represent no blood lead level testing or numbers that have been suppressed (less than 6) to protect the tested individuals.

Click here for metadata (descriptions of the fields).
Organization: City of Ferndale, Michigan
Last updated: 2024-02-21T06:55:29.190172
Tags: children, health, lead, msa

Tables

Table 1

@usgov.city_of_ferndale_michigan_leadbloodlevels_2017_bymsa_2_e78eea21.table_1

12.85 kB
35 rows
13 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "geoid10_msa" BIGINT,
  "cnttested" BIGINT,
  "ebll" BIGINT,
  "under6cnttested" BIGINT,
  "under6ebll" BIGINT,
  "under18cnttested" BIGINT,
  "under18ebll" BIGINT,
  "pctebll" DOUBLE,
  "pctunder6ebll" DOUBLE,
  "pctunder18ebll" DOUBLE,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);