PLACES: Place Data (GIS Friendly Format), 2021 Release
U.S. Department of Health & Human Services
@usgov.hhs_gov_places_place_gis_friendly_format_2021_release_725b1
U.S. Department of Health & Human Services
@usgov.hhs_gov_places_place_gis_friendly_format_2021_release_725b1
CREATE TABLE table_1 (
"stateabbr" VARCHAR,
"statedesc" VARCHAR,
"placename" VARCHAR,
"placefips" BIGINT,
"totalpopulation" 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,
"cervical_crudeprev" DOUBLE,
"cervical_crude95ci" VARCHAR,
"cervical_adjprev" DOUBLE,
"cervical_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,
"depression_crudeprev" DOUBLE,
"depression_crude95ci" VARCHAR,
"depression_adjprev" DOUBLE,
"depression_adj95ci" VARCHAR,
"diabetes_crudeprev" DOUBLE,
"diabetes_crude95ci" VARCHAR,
"diabetes_adjprev" DOUBLE,
"diabetes_adj95ci" VARCHAR,
"ghlth_crudeprev" DOUBLE,
"ghlth_crude95ci" VARCHAR,
"ghlth_adjprev" DOUBLE,
"ghlth_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
);
Anyone who has the link will be able to view this.