Baselight

Public Health Statistics - Screening For Elevated Blood Lead Levels In Children Aged 0-6 Years By Year, Chicago, 1999-2013 - Historical

City of Chicago

@usgov.city_of_chicago_public_health_statistics_screening_for_16444ac1

Loading...
Loading...

About this Dataset

Public Health Statistics - Screening For Elevated Blood Lead Levels In Children Aged 0-6 Years By Year, Chicago, 1999-2013 - Historical

Note: This dataset is historical only and there are not corresponding datasets for more recent time periods. For that more-recent information, please visit the Chicago Health Atlas at https://chicagohealthatlas.org.

This dataset contains the annual number and estimated rate per 1,000 children aged 0-6 years receiving a blood lead level test, and the annual number and estimated percentage of those tested found to have an elevated blood lead level, with corresponding 95% confidence intervals, by Chicago community area, for the years 1999 – 2013. See the full dataset description for more information at https://data.cityofchicago.org/api/views/gpjh-i4j2/files/vIHuTqqgxDT1UFX9XhgCeYddaOhsG2nzgoMLUoRjeOI?download=true&filename=P:\EPI\OEPHI\MATERIALS\REFERENCES\LEAD_POISONING\Dataset_Description_BloodLeadTesting_1999-2013.pdf
Organization: City of Chicago
Last updated: 2020-11-10T16:55:30.839539
Tags: historical

Tables

Table 1

@usgov.city_of_chicago_public_health_statistics_screening_for_16444ac1.table_1
  • 142.82 KB
  • 79 rows
  • 122 columns
Loading...

CREATE TABLE table_1 (
  "community_area_number" BIGINT,
  "community_area_name" VARCHAR,
  "screened_for_lead_in_1999" BIGINT,
  "lead_screening_rate_1999" DOUBLE,
  "lead_screening_rate_1999_lower_ci" DOUBLE,
  "lead_screening_rate_1999_upper_ci" DOUBLE,
  "elevated_blood_lead_level_in_1999" BIGINT,
  "percent_elevated_1999" DOUBLE,
  "percent_elevated_1999_lower_ci" DOUBLE,
  "percent_elevated_1999_upper_ci" DOUBLE,
  "screened_for_lead_in_2000" BIGINT,
  "lead_screening_rate_2000" DOUBLE,
  "lead_screening_rate_2000_lower_ci" DOUBLE,
  "lead_screening_rate_2000_upper_ci" DOUBLE,
  "elevated_blood_lead_level_in_2000" BIGINT,
  "percent_elevated_2000" DOUBLE,
  "percent_elevated_2000_lower_ci" DOUBLE,
  "percent_elevated_2000_upper_ci" DOUBLE,
  "screened_for_lead_in_2001" BIGINT,
  "lead_screening_rate_2001" DOUBLE,
  "lead_screening_rate_2001_lower_ci" DOUBLE,
  "lead_screening_rate_2001_upper_ci" DOUBLE,
  "elevated_blood_lead_level_in_2001" BIGINT,
  "percent_elevated_2001" DOUBLE,
  "percent_elevated_2001_lower_ci" DOUBLE,
  "percent_elevated_2001_upper_ci" DOUBLE,
  "screened_for_lead_in_2002" BIGINT,
  "lead_screening_rate_2002" DOUBLE,
  "lead_screening_rate_2002_lower_ci" DOUBLE,
  "lead_screening_rate_2002_upper_ci" DOUBLE,
  "elevated_blood_lead_level_in_2002" BIGINT,
  "percent_elevated_2002" DOUBLE,
  "percent_elevated_2002_lower_ci" DOUBLE,
  "percent_elevated_2002_upper_ci" DOUBLE,
  "screened_for_lead_in_2003" BIGINT,
  "lead_screening_rate_2003" DOUBLE,
  "lead_screening_rate_2003_lower_ci" DOUBLE,
  "lead_screening_rate_2003_upper_ci" DOUBLE,
  "elevated_blood_lead_level_in_2003" BIGINT,
  "percent_elevated_2003" DOUBLE,
  "percent_elevated_2003_lower_ci" DOUBLE,
  "percent_elevated_2003_upper_ci" DOUBLE,
  "screened_for_lead_in_2004" BIGINT,
  "lead_screening_rate_2004" DOUBLE,
  "lead_screening_rate_2004_lower_ci" DOUBLE,
  "lead_screening_rate_2004_upper_ci" DOUBLE,
  "elevated_blood_lead_level_in_2004" BIGINT,
  "percent_elevated_2004" DOUBLE,
  "percent_elevated_2004_lower_ci" DOUBLE,
  "percent_elevated_2004_upper_ci" DOUBLE,
  "screened_for_lead_in_2005" BIGINT,
  "lead_screening_rate_2005" DOUBLE,
  "lead_screening_rate_2005_lower_ci" DOUBLE,
  "lead_screening_rate_2005_upper_ci" DOUBLE,
  "elevated_blood_lead_level_in_2005" BIGINT,
  "percent_elevated_2005" DOUBLE,
  "percent_elevated_2005_lower_ci" DOUBLE,
  "percent_elevated_2005_upper_ci" DOUBLE,
  "screened_for_lead_in_2006" BIGINT,
  "lead_screening_rate_2006" DOUBLE,
  "lead_screening_rate_2006_lower_ci" DOUBLE,
  "lead_screening_rate_2006_upper_ci" DOUBLE,
  "elevated_blood_lead_level_in_2006" BIGINT,
  "percent_elevated_2006" DOUBLE,
  "percent_elevated_2006_lower_ci" DOUBLE,
  "percent_elevated_2006_upper_ci" DOUBLE,
  "screened_for_lead_in_2007" BIGINT,
  "lead_screening_rate_2007" DOUBLE,
  "lead_screening_rate_2007_lower_ci" DOUBLE,
  "lead_screening_rate_2007_upper_ci" DOUBLE,
  "elevated_blood_lead_level_in_2007" BIGINT,
  "percent_elevated_2007" DOUBLE,
  "percent_elevated_2007_lower_ci" DOUBLE,
  "percent_elevated_2007_upper_ci" DOUBLE,
  "screened_for_lead_in_2008" BIGINT,
  "lead_screening_rate_2008" DOUBLE,
  "lead_screening_rate_2008_lower_ci" DOUBLE,
  "lead_screening_rate_2008_upper_ci" DOUBLE,
  "elevated_blood_lead_level_in_2008" BIGINT,
  "percent_elevated_2008" DOUBLE,
  "percent_elevated_2008_lower_ci" DOUBLE,
  "percent_elevated_2008_upper_ci" DOUBLE,
  "screened_for_lead_in_2009" BIGINT,
  "lead_screening_rate_2009" DOUBLE,
  "lead_screening_rate_2009_lower_ci" DOUBLE,
  "lead_screening_rate_2009_upper_ci" DOUBLE,
  "elevated_blood_lead_level_in_2009" BIGINT,
  "percent_elevated_2009" DOUBLE,
  "percent_elevated_2009_lower_ci" DOUBLE,
  "percent_elevated_2009_upper_ci" DOUBLE,
  "screened_for_lead_in_2010" BIGINT,
  "lead_screening_rate_2010" DOUBLE,
  "lead_screening_rate_2010_lower_ci" DOUBLE,
  "lead_screening_rate_2010_upper_ci" DOUBLE,
  "elevated_blood_lead_level_in_2010" BIGINT,
  "percent_elevated_2010" DOUBLE,
  "percent_elevated_2010_lower_ci" DOUBLE,
  "percent_elevated_2010_upper_ci" DOUBLE,
  "screened_for_lead_in_2011" BIGINT,
  "lead_screening_rate_in_2011" DOUBLE
);

Share link

Anyone who has the link will be able to view this.