ejscreen_merged
Tables schema
ejscreen_single_table
ID, STATE_NAME, CNTY_NAME, REGION, ACSTOTPOP, ACSIPOVBAS, ACSEDUCBAS, ACSTOTHH, ACSTOTHU, ACSUNEMPBAS, ACSDISABBAS, DEMOGIDX_2, DEMOGIDX_5, PEOPCOLOR, PEOPCOLORPCT, LOWINCOME, LOWINCPCT, UNEMPLOYED, UNEMPPCT, DISABILITY, DISABILITYPCT, LINGISO, LINGISOPCT, LESSHS, LESSHSPCT, UNDER5, UNDER5PCT, OVER64, OVER64PCT, LIFEEXPPCT, PM25, OZONE, DSLPM, RSEI_AIR, PTRAF, PRE1960, PRE1960PCT, PNPL, PRMP, PTSDF, UST, PWDIS, NO2, DWATER, D2_PM25, D5_PM25, D2_OZONE, D5_OZONE, D2_DSLPM, D5_DSLPM, D2_RSEI_AIR, D5_RSEI_AIR, D2_PTRAF, D5_PTRAF, D2_LDPNT, D5_LDPNT, D2_PNPL, D5_PNPL, D2_PRMP, D5_PRMP, D2_PTSDF, D5_PTSDF, D2_UST, D5_UST, D2_PWDIS, D5_PWDIS, D2_NO2, D5_NO2, D2_DWATER, D5_DWATER, P_DEMOGIDX_2, P_DEMOGIDX_5, P_PEOPCOLORPCT, P_LOWINCPCT, P_UNEMPPCT, P_DISABILITYPCT, P_LINGISOPCT, P_LESSHSPCT, P_UNDER5PCT, P_OVER64PCT, P_LIFEEXPPCT, P_PM25, P_OZONE, P_DSLPM, P_RSEI_AIR, P_PTRAF, P_LDPNT, P_PNPL, P_PRMP, P_PTSDF, P_UST, P_PWDIS, P_NO2, P_DWATER, P_D2_PM25, P_D5_PM25, P_D2_OZONE, P_D5_OZONE, P_D2_DSLPM, P_D5_DSLPM, P_D2_RSEI_AIR, P_D5_RSEI_AIR, P_D2_PTRAF, P_D5_PTRAF, P_D2_LDPNT, P_D5_LDPNT, P_D2_PNPL, P_D5_PNPL, P_D2_PRMP, P_D5_PRMP, P_D2_PTSDF, P_D5_PTSDF, P_D2_UST, P_D5_UST, P_D2_PWDIS, P_D5_PWDIS, P_D2_NO2, P_D5_NO2, P_D2_DWATER, P_D5_DWATER, AREALAND, AREAWATER, NPL_CNT, TSDF_CNT, EXCEED_COUNT_80, EXCEED_COUNT_80_SUP, DEMOGIDX_2ST, DEMOGIDX_5ST, Shape_Length, Shape_Area, T_fire_y00, T_fire_y30, percentile_wildfire, T_flood_y00, T_flood_y30, percentile_flood, Days_Above_90_2019, Days_Above_90_2020, Days_Above_90_2021, Days_Above_90_2022, Days_Above_90_2023, Max_Days_Above_90, Average_Days_Above_90, bgfips, RAW_CG_NOHINCPCT, S_CG_NOHINCPCT_AVG, S_CG_NOHINCPCT_PCTILE, N_CG_NOHINCPCT_AVG, N_CG_NOHINCPCT_PCTILE, RAW_HI_HEARTDISEASE, S_HI_HEARTDISEASE_AVG, S_HI_HEARTDISEASE_PCTILE, N_HI_HEARTDISEASE_AVG, N_HI_HEARTDISEASE_PCTILE, RAW_HI_ASTHMA, S_HI_ASTHMA_AVG, S_HI_ASTHMA_PCTILE, N_HI_ASTHMA_AVG, N_HI_ASTHMA_PCTILE, RAW_HI_CANCER, S_HI_CANCER_AVG, S_HI_CANCER_PCTILE, N_HI_CANCER_AVG, N_HI_CANCER_PCTILE, RAW_CI_FLOOD30, S_CI_FLOOD30_AVG, S_CI_FLOOD30_PCTILE, N_CI_FLOOD30_AVG, N_CI_FLOOD30_PCTILE, RAW_CI_FIRE30, S_CI_FIRE30_AVG, S_CI_FIRE30_PCTILE, N_CI_FIRE30_AVG, N_CI_FIRE30_PCTILE, NUM_NPL, NUM_TSDF, NUM_WATERDIS, NUM_AIRPOLL, NUM_BROWNFIELD, NUM_TRI, NUM_SCHOOL, NUM_HOSPITAL, NUM_CHURCH, YESNO_TRIBAL, YESNO_CEJSTDIS, YESNO_IRADIS, YESNO_AIRNONATT, YESNO_IMPWATERS, YESNO_HOUSEBURDEN, YESNO_TRANSDIS, YESNO_FOODDESERT, P_ENGLISH, P_SPANISH, P_FRENCH, P_RUS_POL_SLAV, P_OTHER_IE, P_VIETNAMESE, P_OTHER_ASIAN, P_ARABIC, P_OTHER, P_NON_ENGLISH, RAW_CG_LIMITEDBBPCT, S_CG_LIMITEDBBPCT_AVG, S_CG_LIMITEDBBPCT_PCTILE, N_CG_LIMITEDBBPCT_AVG, N_CG_LIMITEDBBPCT_PCTILE
243,022 rows
Download SQLite DB: ejscreen_merged.db 234.5 MB