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
City of Chicago
@usgov.city_of_chicago_public_health_statistics_screening_for_16444ac1
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
);
Anyone who has the link will be able to view this.