PLACES: ZCTA Data (GIS Friendly Format), 2022 Release
U.S. Department of Health & Human Services
@usgov.hhs_gov_places_zcta_data_gis_friendly_format_2022_release
U.S. Department of Health & Human Services
@usgov.hhs_gov_places_zcta_data_gis_friendly_format_2022_release
CREATE TABLE table_1 (
"zcta5" BIGINT,
"totalpopulation" BIGINT,
"access2_crudeprev" DOUBLE,
"access2_crude95ci" VARCHAR,
"arthritis_crudeprev" DOUBLE,
"arthritis_crude95ci" VARCHAR,
"binge_crudeprev" DOUBLE,
"binge_crude95ci" VARCHAR,
"bphigh_crudeprev" DOUBLE,
"bphigh_crude95ci" VARCHAR,
"bpmed_crudeprev" DOUBLE,
"bpmed_crude95ci" VARCHAR,
"cancer_crudeprev" DOUBLE,
"cancer_crude95ci" VARCHAR,
"casthma_crudeprev" DOUBLE,
"casthma_crude95ci" VARCHAR,
"cervical_crudeprev" DOUBLE,
"cervical_crude95ci" VARCHAR,
"chd_crudeprev" DOUBLE,
"chd_crude95ci" VARCHAR,
"checkup_crudeprev" DOUBLE,
"checkup_crude95ci" VARCHAR,
"cholscreen_crudeprev" DOUBLE,
"cholscreen_crude95ci" VARCHAR,
"colon_screen_crudeprev" DOUBLE,
"colon_screen_crude95ci" VARCHAR,
"copd_crudeprev" DOUBLE,
"copd_crude95ci" VARCHAR,
"corem_crudeprev" DOUBLE,
"corem_crude95ci" VARCHAR,
"corew_crudeprev" DOUBLE,
"corew_crude95ci" VARCHAR,
"csmoking_crudeprev" DOUBLE,
"csmoking_crude95ci" VARCHAR,
"dental_crudeprev" DOUBLE,
"dental_crude95ci" VARCHAR,
"depression_crudeprev" DOUBLE,
"depression_crude95ci" VARCHAR,
"diabetes_crudeprev" DOUBLE,
"diabetes_crude95ci" VARCHAR,
"ghlth_crudeprev" DOUBLE,
"ghlth_crude95ci" VARCHAR,
"highchol_crudeprev" DOUBLE,
"highchol_crude95ci" VARCHAR,
"kidney_crudeprev" DOUBLE,
"kidney_crude95ci" VARCHAR,
"lpa_crudeprev" DOUBLE,
"lpa_crude95ci" VARCHAR,
"mammouse_crudeprev" DOUBLE,
"mammouse_crude95ci" VARCHAR,
"mhlth_crudeprev" DOUBLE,
"mhlth_crude95ci" VARCHAR,
"obesity_crudeprev" DOUBLE,
"obesity_crude95ci" VARCHAR,
"phlth_crudeprev" DOUBLE,
"phlth_crude95ci" VARCHAR,
"sleep_crudeprev" DOUBLE,
"sleep_crude95ci" VARCHAR,
"stroke_crudeprev" DOUBLE,
"stroke_crude95ci" VARCHAR,
"teethlost_crudeprev" DOUBLE,
"teethlost_crude95ci" VARCHAR,
"geolocation" VARCHAR
);
Anyone who has the link will be able to view this.