Geospatiotemporal And Causal Inferential Analysis
Geospatiotemporal and Causal Inferential Analysis of US Congenital Anomalies
@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8
Geospatiotemporal and Causal Inferential Analysis of US Congenital Anomalies
@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8
CREATE TABLE nbdxwwlcorrexprelra (
"defect" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"state" VARCHAR,
"rate" DOUBLE,
"status" VARCHAR,
"dichstat" VARCHAR,
"abbrev" VARCHAR,
"rel" VARCHAR,
"group" VARCHAR,
"thcrel3" VARCHAR,
"cvs" VARCHAR,
"endoc" VARCHAR,
"brain" VARCHAR,
"chromo" VARCHAR,
"chromo2" VARCHAR,
"equivocal" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"year2" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"quinci" VARCHAR,
"quincn" VARCHAR,
"regn" VARCHAR,
"region" VARCHAR,
"composite" DOUBLE,
"toprt" DOUBLE,
"fmaxtr" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"pt" BIGINT,
"ptt" BIGINT,
"pttt" BIGINT,
"ppttt" BIGINT
);
CREATE TABLE nbdxwwlcorrexprelradx (
"defect" VARCHAR,
"year" BIGINT,
"mtruertsc" VARCHAR,
"mltruert" VARCHAR,
"mltruertsc" VARCHAR,
"mratesc" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpthccbdcigalcoholslopes (
"state" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"defect" VARCHAR,
"rate" DOUBLE,
"status" VARCHAR,
"dichstat" VARCHAR,
"abbrev" VARCHAR,
"rel" VARCHAR,
"group" VARCHAR,
"thcrel3" VARCHAR,
"cvs" VARCHAR,
"endocardial_cushions" VARCHAR,
"brain" VARCHAR,
"chromosomal" VARCHAR,
"chromosomal2" VARCHAR,
"equivocal" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"year2" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"quinci" VARCHAR,
"quincn" VARCHAR,
"regn" VARCHAR,
"region" VARCHAR,
"composite" DOUBLE,
"toprt" DOUBLE,
"fmaxtr" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"thcslope" DOUBLE,
"ixthc" BIGINT,
"cbdslope" DOUBLE,
"ixcbd" BIGINT,
"cigslope" DOUBLE,
"ix" BIGINT,
"audslope" DOUBLE,
"ixaud" BIGINT,
"mrjslope" DOUBLE,
"ixmrj" BIGINT,
"alcmonslope" DOUBLE,
"ixalcmon" BIGINT
);
CREATE TABLE nbdxwwlcorrexpthccbdcigalcoholslopes33 (
"state" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"defect" VARCHAR,
"rate" DOUBLE,
"status" VARCHAR,
"dichstat" VARCHAR,
"abbrev" VARCHAR,
"rel" VARCHAR,
"group" VARCHAR,
"thcrel3" VARCHAR,
"cvs" VARCHAR,
"endoc" VARCHAR,
"brain" VARCHAR,
"chromo" VARCHAR,
"chromo2" VARCHAR,
"equivocal" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"year2" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"quinci" VARCHAR,
"quincn" VARCHAR,
"regn" VARCHAR,
"region" VARCHAR,
"composite" DOUBLE,
"toprt" DOUBLE,
"fmaxtr" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"pt" BIGINT,
"ptt" BIGINT,
"gx" BIGINT,
"canrel" VARCHAR,
"ratesc" DOUBLE,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"thcslope" DOUBLE,
"ixthc" BIGINT,
"cbdslope" DOUBLE,
"ixcbd" BIGINT,
"cigslope" DOUBLE,
"ix" BIGINT,
"audslope" DOUBLE,
"ixaud" BIGINT,
"mrjslope" DOUBLE,
"ixmrj" BIGINT,
"alcmonslope" DOUBLE,
"ixalcmon" BIGINT
);
CREATE TABLE nbdxwwlcorrexpthccbdcigalcoholslopestimecanlis (
"state" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"defect" VARCHAR,
"rate" DOUBLE,
"status" VARCHAR,
"dichstat" VARCHAR,
"abbrev" VARCHAR,
"rel" VARCHAR,
"group" VARCHAR,
"thcrel3" VARCHAR,
"cvs" VARCHAR,
"endocardial_cushions" VARCHAR,
"brain" VARCHAR,
"chromosomal" VARCHAR,
"chromosomal2" VARCHAR,
"equivocal" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"year2" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"quinci" VARCHAR,
"quincn" VARCHAR,
"regn" VARCHAR,
"region" VARCHAR,
"composite" DOUBLE,
"toprt" DOUBLE,
"fmaxtr" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"thcslope" DOUBLE,
"ixthc" BIGINT,
"cbdslope" DOUBLE,
"ixcbd" BIGINT,
"cigslope" DOUBLE,
"ix" BIGINT,
"audslope" DOUBLE,
"ixaud" BIGINT,
"alcmonslope" DOUBLE,
"ixalcmon" BIGINT,
"estimate" DOUBLE,
"timeslope" DOUBLE,
"ixtime" BIGINT,
"canlis" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpthccbdslopes (
"state" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"defect" VARCHAR,
"rate" DOUBLE,
"status" VARCHAR,
"dichstat" VARCHAR,
"abbrev" VARCHAR,
"rel" VARCHAR,
"group" VARCHAR,
"thcrel3" VARCHAR,
"cvs" VARCHAR,
"endocardial_cushions" VARCHAR,
"brain" VARCHAR,
"chromosomal" VARCHAR,
"chromosomal2" VARCHAR,
"equivocal" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"year2" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"quinci" VARCHAR,
"quincn" VARCHAR,
"regn" VARCHAR,
"region" VARCHAR,
"composite" DOUBLE,
"toprt" DOUBLE,
"fmaxtr" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"thcslope" DOUBLE,
"cbdslope" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpthcslope (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"thcslope" DOUBLE,
"p_value" DOUBLE,
"r_squared" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"statistic1" DOUBLE,
"p_value1" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpthcslope2eva (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"timeslope" DOUBLE,
"p_value" DOUBLE,
"r_squared" DOUBLE,
"adj_r_squared" DOUBLE,
"s_d" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"ixthc" BIGINT,
"evalolsptthcl" DOUBLE,
"evalolslothcl" DOUBLE,
"ix" BIGINT,
"fix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpthcslope2eva2 (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"slope" DOUBLE,
"p_value" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolsptthcl" DOUBLE,
"evalolslothcl" DOUBLE,
"ix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpthcslope2eva3 (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"slope" DOUBLE,
"p_value" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolsptthcl" DOUBLE,
"evalolslothcl" DOUBLE,
"ixthc" BIGINT
);
CREATE TABLE nbdxwwlcorrexpthcslopeev (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"thcslope" DOUBLE,
"p_value" DOUBLE,
"r_squared" DOUBLE,
"adj_r_squared" DOUBLE,
"s_d" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolsptthcl" DOUBLE,
"evalolslothcl" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpthvslope (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"thvslope" DOUBLE,
"p_value" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolsptl" DOUBLE,
"evalolslol" DOUBLE,
"ixthv" BIGINT
);
CREATE TABLE nbdxwwlcorrexpthvslope2 (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"slope" DOUBLE,
"p_value" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolspt" DOUBLE,
"evalolslo" DOUBLE,
"ix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpthvslope3 (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"slope" DOUBLE,
"p_value" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolsptl" DOUBLE,
"evalolslothv" DOUBLE,
"ixthv" BIGINT
);
CREATE TABLE nbdxwwlexpna338dxbbquincihilo15epieva2 (
"defect" VARCHAR,
"sn_defxhi" BIGINT,
"sn_birthshi" BIGINT,
"sn_defxlo" BIGINT,
"sn_birthslo" BIGINT,
"def_ratehi" DOUBLE,
"def_ratelo" DOUBLE,
"sn_defxcorrhi" BIGINT,
"sn_birthscorrhi" BIGINT,
"sn_defxcorrlo" BIGINT,
"sn_birthscorrlo" BIGINT,
"def_ratecorrhi" DOUBLE,
"def_ratecorrlo" DOUBLE,
"rr_corr" DOUBLE,
"canrel2_x" VARCHAR,
"chisq" DOUBLE,
"pvalue" DOUBLE,
"ciquinrrpt" DOUBLE,
"ciquinrrlo" DOUBLE,
"ciquinrrhi" DOUBLE,
"ciquinevalpt" DOUBLE,
"ciquinevallo" DOUBLE
);
CREATE TABLE nbdxwwlexpna338dxbbquincihilo15epieva3 (
"defect" VARCHAR,
"sn_defxhi" BIGINT,
"sn_birthshi" BIGINT,
"sn_defxlo" BIGINT,
"sn_birthslo" BIGINT,
"def_ratehi" DOUBLE,
"def_ratelo" DOUBLE,
"rr_ci" VARCHAR,
"chisq" DOUBLE,
"pvalue" DOUBLE,
"ciquinevalpt" DOUBLE,
"ciquinevallo" DOUBLE
);
CREATE TABLE nbdxwwlexpna338dxbbquincihilo15epieva3sst (
"data_type" VARCHAR,
"quintile_type" VARCHAR,
"cas_in_quintile_5" BIGINT,
"births_in_quintile_5" DOUBLE,
"cas_in_lower_quintiles" BIGINT,
"births_in_lower_quintiles" DOUBLE,
"rr_ci" VARCHAR,
"afe_ci" VARCHAR,
"par_ci" VARCHAR,
"chisqu" DOUBLE,
"pvalue" VARCHAR,
"evaluerrpt" DOUBLE,
"evaluerrlo" DOUBLE
);
CREATE TABLE newdfdf (
"state" VARCHAR,
"year" BIGINT,
"pcancrt" DOUBLE,
"allrate" DOUBLE,
"testcartwh" DOUBLE,
"tri21rt" DOUBLE,
"tri18rt" DOUBLE,
"tri13rt" DOUBLE,
"del22rt" DOUBLE,
"turnsynrt" DOUBLE,
"tri21trurt" DOUBLE,
"tri18trurt" DOUBLE,
"tri13trurt" DOUBLE,
"del22trurt" DOUBLE,
"turnstrurt" DOUBLE,
"cigmon" DOUBLE,
"abodalc" DOUBLE,
"mrjmon" DOUBLE,
"anlyr" DOUBLE,
"cocyr" DOUBLE,
"income" BIGINT,
"caucasian" DOUBLE,
"african" DOUBLE,
"asian" DOUBLE,
"aian" DOUBLE,
"hispanic" DOUBLE,
"nhpi" DOUBLE,
"nhwhitet" DOUBLE,
"nhblackt" DOUBLE,
"hispanict" DOUBLE,
"asiant" DOUBLE,
"aiant" DOUBLE,
"nhpit" DOUBLE,
"sw" DOUBLE,
"trw" DOUBLE,
"quincim" VARCHAR,
"quincnm" VARCHAR,
"quincnm2" VARCHAR,
"quincnmint" BIGINT,
"statusnew" VARCHAR,
"dichstatnew" VARCHAR,
"dichstatnew3" VARCHAR,
"quincnm514" VARCHAR,
"thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"cbnrt" DOUBLE,
"cbdrt" DOUBLE,
"nhwhitetppot" DOUBLE,
"nhblacktppot" DOUBLE,
"hispanictppot" DOUBLE,
"asiantppot" DOUBLE,
"aiantppot" DOUBLE,
"nhpitppot" DOUBLE,
"pc1canc" DOUBLE,
"pc1triraw" DOUBLE,
"pc1defxraw" DOUBLE,
"pc1truedefx" DOUBLE,
"pc1cannbd" DOUBLE,
"ltestcartwh" DOUBLE,
"ltri21rt" DOUBLE,
"ltri18rt" DOUBLE,
"ltri13rt" DOUBLE,
"ldel22rt" DOUBLE,
"lturnsynrt" DOUBLE,
"quincnmgross" VARCHAR,
"quincnmgrossa" VARCHAR,
"quincnmgross514" VARCHAR,
"pc1ca2" DOUBLE
);
CREATE TABLE no_s_cannabis_related_defects (
"defect" VARCHAR,
"sn_defxq5" DOUBLE,
"sn_birthsq5" DOUBLE,
"sn_defxq1" DOUBLE,
"sn_birthsq1" DOUBLE,
"rateq5" DOUBLE,
"rateq1" DOUBLE,
"rr" DOUBLE
);
CREATE TABLE no_s_cannabis_related_defects_qs4_5_2 (
"defect" VARCHAR,
"sn_defxcorrq5" DOUBLE,
"sn_birthsq5" DOUBLE,
"sn_defxcorrq4" DOUBLE,
"sn_birthsq4" DOUBLE
);
CREATE TABLE ogudaeesc (
"state" VARCHAR,
"year" BIGINT,
"rate" DOUBLE,
"status" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"pt" DOUBLE,
"cigmonsc" DOUBLE,
"bngalcsc" DOUBLE,
"mrjmonsc" DOUBLE,
"anlyrsc" DOUBLE,
"cocyrsc" DOUBLE,
"d9thcrtsc" DOUBLE,
"cbcrtsc" DOUBLE,
"cbgrtsc" DOUBLE
);
CREATE TABLE ogudaeescia (
"state" VARCHAR,
"year" BIGINT,
"rate" DOUBLE,
"status" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"pt" DOUBLE,
"cigmonsc" DOUBLE,
"bngalcsc" DOUBLE,
"mrjmonsc" DOUBLE,
"anlyrsc" DOUBLE,
"cocyrsc" DOUBLE,
"d9thcrtsc" DOUBLE,
"cbcrtsc" DOUBLE,
"cbgrtsc" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE ompha (
"state" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"defect" VARCHAR,
"rate" DOUBLE,
"status" VARCHAR,
"dichstat" VARCHAR,
"abbrev" VARCHAR,
"rel" VARCHAR,
"group" VARCHAR,
"thcrel3" VARCHAR,
"cvs" VARCHAR,
"endoc" VARCHAR,
"brain" VARCHAR,
"chromo" VARCHAR,
"chromo2" VARCHAR,
"equivocal" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"year2" BIGINT,
"aian" BIGINT,
"aspi" BIGINT,
"black" BIGINT,
"white" BIGINT,
"totpop" BIGINT,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" BIGINT,
"quinci" VARCHAR,
"quincn" VARCHAR,
"regn" VARCHAR,
"region" VARCHAR,
"composite" DOUBLE,
"toprt" DOUBLE,
"fmaxtr" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"pt" BIGINT,
"ptt" BIGINT,
"gx" BIGINT,
"canrel" VARCHAR,
"ratesc" DOUBLE,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE
);
CREATE TABLE omphaia (
"state" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"defect" VARCHAR,
"rate" DOUBLE,
"status" VARCHAR,
"dichstat" VARCHAR,
"abbrev" VARCHAR,
"rel" VARCHAR,
"group" VARCHAR,
"thcrel3" VARCHAR,
"cvs" VARCHAR,
"endoc" VARCHAR,
"brain" VARCHAR,
"chromo" VARCHAR,
"chromo2" VARCHAR,
"equivocal" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"year2" BIGINT,
"aian" BIGINT,
"aspi" BIGINT,
"black" BIGINT,
"white" BIGINT,
"totpop" BIGINT,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" BIGINT,
"quinci" VARCHAR,
"quincn" VARCHAR,
"regn" VARCHAR,
"region" VARCHAR,
"composite" DOUBLE,
"toprt" DOUBLE,
"fmaxtr" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"pt" BIGINT,
"ptt" BIGINT,
"gx" BIGINT,
"canrel" VARCHAR,
"ratesc" DOUBLE,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE omphaiaaees (
"state" VARCHAR,
"year" BIGINT,
"rate" DOUBLE,
"status" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"canrel" VARCHAR,
"ratesc" DOUBLE,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE
);
Anyone who has the link will be able to view this.