Dataset: CDC 500 Cities

About this Dataset

CDC 500 Cities

Context:

Public health is a large and expensive problem for policymakers to understand in order to provide health services and prevent future epidemics. Self-reported data can be tricky due to many sampling issues, but it can paint an interesting picture of how healthy a given area’s population might be.

Content:

Data includes small area samples of residents from 500 US cities. Recorded is the percent of residents who answered a public health-related question affirmatively (see here). In addition to crude data, additional data is provided with age adjustment applied. 95% Confidence Intervals also provided for both datapoints.

Acknowledgements:

This data was collected by Centers for Disease Control and Prevention, National Center for Chronic Disease Prevention and Health Promotion, Division of Population Health. 500 Cities Project Data [online]. 2016 [accessed Aug 10, 2017]. URL: https://www.cdc.gov/500cities.

Inspiration:

Are there any regional health trends?
Any unusual hotspots of declining health? Higher levels of wellness?
Can you split the data by geography and predict neighboring cities health?
Who's healthier, larger or smaller cities?

Tables

N 500 Cities Cdc

@kaggle.cdc_500_cities.n_500_cities_cdc

309.84 KB
500 rows
117 columns


CREATE TABLE n_500_cities_cdc (
  "stateabbr" VARCHAR,
  "placename" VARCHAR,
  "placefips" BIGINT,
  "population2010" BIGINT,
  "access2_crudeprev" DOUBLE,
  "access2_crude95ci" VARCHAR,
  "access2_adjprev" DOUBLE,
  "access2_adj95ci" VARCHAR,
  "arthritis_crudeprev" DOUBLE,
  "arthritis_crude95ci" VARCHAR,
  "arthritis_adjprev" DOUBLE,
  "arthritis_adj95ci" VARCHAR,
  "binge_crudeprev" DOUBLE,
  "binge_crude95ci" VARCHAR,
  "binge_adjprev" DOUBLE,
  "binge_adj95ci" VARCHAR,
  "bphigh_crudeprev" DOUBLE,
  "bphigh_crude95ci" VARCHAR,
  "bphigh_adjprev" DOUBLE,
  "bphigh_adj95ci" VARCHAR,
  "bpmed_crudeprev" DOUBLE,
  "bpmed_crude95ci" VARCHAR,
  "bpmed_adjprev" DOUBLE,
  "bpmed_adj95ci" VARCHAR,
  "cancer_crudeprev" DOUBLE,
  "cancer_crude95ci" VARCHAR,
  "cancer_adjprev" DOUBLE,
  "cancer_adj95ci" VARCHAR,
  "casthma_crudeprev" DOUBLE,
  "casthma_crude95ci" VARCHAR,
  "casthma_adjprev" DOUBLE,
  "casthma_adj95ci" VARCHAR,
  "chd_crudeprev" DOUBLE,
  "chd_crude95ci" VARCHAR,
  "chd_adjprev" DOUBLE,
  "chd_adj95ci" VARCHAR,
  "checkup_crudeprev" DOUBLE,
  "checkup_crude95ci" VARCHAR,
  "checkup_adjprev" DOUBLE,
  "checkup_adj95ci" VARCHAR,
  "cholscreen_crudeprev" DOUBLE,
  "cholscreen_crude95ci" VARCHAR,
  "cholscreen_adjprev" DOUBLE,
  "cholscreen_adj95ci" VARCHAR,
  "colon_screen_crudeprev" DOUBLE,
  "colon_screen_crude95ci" VARCHAR,
  "colon_screen_adjprev" DOUBLE,
  "colon_screen_adj95ci" VARCHAR,
  "copd_crudeprev" DOUBLE,
  "copd_crude95ci" VARCHAR,
  "copd_adjprev" DOUBLE,
  "copd_adj95ci" VARCHAR,
  "corem_crudeprev" DOUBLE,
  "corem_crude95ci" VARCHAR,
  "corem_adjprev" DOUBLE,
  "corem_adj95ci" VARCHAR,
  "corew_crudeprev" DOUBLE,
  "corew_crude95ci" VARCHAR,
  "corew_adjprev" DOUBLE,
  "corew_adj95ci" VARCHAR,
  "csmoking_crudeprev" DOUBLE,
  "csmoking_crude95ci" VARCHAR,
  "csmoking_adjprev" DOUBLE,
  "csmoking_adj95ci" VARCHAR,
  "dental_crudeprev" DOUBLE,
  "dental_crude95ci" VARCHAR,
  "dental_adjprev" DOUBLE,
  "dental_adj95ci" VARCHAR,
  "diabetes_crudeprev" DOUBLE,
  "diabetes_crude95ci" VARCHAR,
  "diabetes_adjprev" DOUBLE,
  "diabetes_adj95ci" VARCHAR,
  "highchol_crudeprev" DOUBLE,
  "highchol_crude95ci" VARCHAR,
  "highchol_adjprev" DOUBLE,
  "highchol_adj95ci" VARCHAR,
  "kidney_crudeprev" DOUBLE,
  "kidney_crude95ci" VARCHAR,
  "kidney_adjprev" DOUBLE,
  "kidney_adj95ci" VARCHAR,
  "lpa_crudeprev" DOUBLE,
  "lpa_crude95ci" VARCHAR,
  "lpa_adjprev" DOUBLE,
  "lpa_adj95ci" VARCHAR,
  "mammouse_crudeprev" DOUBLE,
  "mammouse_crude95ci" VARCHAR,
  "mammouse_adjprev" DOUBLE,
  "mammouse_adj95ci" VARCHAR,
  "mhlth_crudeprev" DOUBLE,
  "mhlth_crude95ci" VARCHAR,
  "mhlth_adjprev" DOUBLE,
  "mhlth_adj95ci" VARCHAR,
  "obesity_crudeprev" DOUBLE,
  "obesity_crude95ci" VARCHAR,
  "obesity_adjprev" DOUBLE,
  "obesity_adj95ci" VARCHAR,
  "paptest_crudeprev" DOUBLE,
  "paptest_crude95ci" VARCHAR,
  "paptest_adjprev" DOUBLE,
  "paptest_adj95ci" VARCHAR
);