Schema for ejscreen_merged

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