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
Dataset for the paper - Geospatiotemporal and Causal Inferential Analysis of United States Congenital Anomalies as a Function of Multiple Cannabinoid- and Substance- Exposures: Phenocopying Thalidomide and Hundred Megabase-Scale Genotoxicity
Reece, Albert (2021), “csv Files to Accompany : Geospatiotemporal and Causal Inferential Analysis of United States Congenital Anomalies as a Function of Multiple Cannabinoid- and Substance- Exposures: Phenocopying Thalidomide and Hundred Megabase-Scale Genotoxicity", V1, doi: 10.17632/jz6777vv72.1
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 -- S.D.,
"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 -- S.D.,
"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
);CREATE TABLE pdazaeesc (
"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,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"cigmonsc" DOUBLE,
"bngalcsc" DOUBLE,
"mrjmonsc" DOUBLE,
"anlyrsc" DOUBLE,
"cocyrsc" DOUBLE,
"d9thcrtsc" DOUBLE,
"cbcrtsc" DOUBLE,
"cbgrtsc" DOUBLE
);CREATE TABLE pdazaeescia (
"state" VARCHAR,
"year" BIGINT,
"rate" DOUBLE,
"status" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);CREATE TABLE potconc4 (
"year" BIGINT,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE
);CREATE TABLE pre45dat (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR,
"canrel2" VARCHAR,
"yi" DOUBLE,
"vi" DOUBLE,
"sei" DOUBLE,
"lci" DOUBLE,
"uci" DOUBLE,
"ab" VARCHAR
);CREATE TABLE pre45dateg (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR,
"canrel2" VARCHAR,
"yi" DOUBLE,
"vi" DOUBLE,
"sei" DOUBLE,
"lci" DOUBLE,
"uci" DOUBLE,
"ab" VARCHAR,
"ev_upper" DOUBLE,
"ev_lower" DOUBLE,
"ev_bound" DOUBLE
);CREATE TABLE pre45datej (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR,
"canrel2" VARCHAR,
"yi" DOUBLE,
"vi" DOUBLE,
"sei" DOUBLE,
"lci" DOUBLE,
"uci" DOUBLE,
"ab" VARCHAR,
"ev_upper" DOUBLE,
"ev_lower" DOUBLE,
"ev_bound" DOUBLE,
"or" DOUBLE,
"or_lci" DOUBLE,
"or_uci" DOUBLE,
"rr" DOUBLE,
"rr_lci" DOUBLE,
"rr_uci" DOUBLE
);CREATE TABLE pre45datek (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR,
"canrel2" VARCHAR,
"yi" DOUBLE,
"vi" DOUBLE,
"sei" DOUBLE,
"lci" DOUBLE,
"uci" DOUBLE,
"ab" VARCHAR,
"ev_upper" DOUBLE,
"ev_lower" DOUBLE,
"ev_bound" DOUBLE,
"or" DOUBLE,
"or_lci" DOUBLE,
"or_uci" DOUBLE
);CREATE TABLE pre45datevalues (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR,
"canrel2" VARCHAR,
"yi" DOUBLE,
"vi" DOUBLE,
"sei" DOUBLE,
"lci" DOUBLE,
"uci" DOUBLE,
"ab" VARCHAR,
"ev_upper" DOUBLE,
"ev_lower" DOUBLE,
"ev_bound" DOUBLE,
"or" DOUBLE,
"or_lci" DOUBLE,
"or_uci" DOUBLE,
"rr" DOUBLE,
"rr_lci" DOUBLE,
"rr_uci" DOUBLE
);CREATE TABLE pres45 (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR
);CREATE TABLE q15_3 (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE
);CREATE TABLE q45_3 (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE
);CREATE TABLE racstt (
"state" VARCHAR,
"year" BIGINT,
"race" VARCHAR,
"race_fr" DOUBLE
);CREATE TABLE sexp7 (
"cannabis" BIGINT,
"thc" BIGINT,
"cbg" BIGINT,
"cbc" BIGINT,
"cbn" BIGINT,
"thcv" BIGINT,
"cbd" BIGINT
);CREATE TABLE siasabeesc (
"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,
"ltruert" DOUBLE,
"cigmonsc" DOUBLE,
"bngalcsc" DOUBLE,
"mrjmonsc" DOUBLE,
"anlyrsc" DOUBLE,
"cocyrsc" DOUBLE,
"d9thcrtsc" DOUBLE,
"cbcrtsc" DOUBLE,
"cbgrtsc" DOUBLE
);CREATE TABLE siasabeescia (
"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,
"ltruert" 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 siasabeesciasocdem (
"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,
"ltruert" 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,
"mhy" BIGINT,
"white" DOUBLE,
"black" DOUBLE,
"asian" DOUBLE,
"aian" DOUBLE,
"hispanic" DOUBLE,
"nhpi" DOUBLE,
"nhwhitet" DOUBLE,
"nhblackt" DOUBLE,
"hispanict" DOUBLE,
"asiant" DOUBLE,
"aiant" DOUBLE,
"nhpit" DOUBLE,
"statusnew" VARCHAR,
"dichstatnew" VARCHAR,
"dichstatnew3" VARCHAR,
"quincim" VARCHAR,
"quincnm" VARCHAR,
"quincnm2" VARCHAR,
"quincnmint" BIGINT,
"quincnmqint" VARCHAR,
"pop" BIGINT,
"medage" DOUBLE,
"nhwhitetppthc" DOUBLE,
"nhblacktppthc" DOUBLE,
"asiantppthc" DOUBLE,
"hispanictppthc" DOUBLE,
"aiantppthc" DOUBLE,
"nhpitppthc" DOUBLE,
"nhwhitetppcbd" DOUBLE,
"nhblacktppcbd" DOUBLE,
"asiantppcbd" DOUBLE,
"hispanictppcbd" DOUBLE,
"aiantppcbd" DOUBLE,
"nhpitppcbd" DOUBLE,
"births" BIGINT
);CREATE TABLE smmcc (
"no" BIGINT -- No.,
"group" VARCHAR,
"defect" VARCHAR,
"cannabis" DOUBLE,
"cannabinoids" DOUBLE,
"mixedeff" DOUBLE,
"robust" DOUBLE,
"panel" DOUBLE,
"st" DOUBLE,
"stst" DOUBLE,
"spml" DOUBLE,
"alone" DOUBLE,
"add" DOUBLE,
"ir" DOUBLE,
"lags2" DOUBLE,
"lags4" DOUBLE,
"description" VARCHAR,
"smmcc" DOUBLE
);CREATE TABLE smmccpcdefmd (
"defect" VARCHAR,
"median_smmcc" DOUBLE,
"median_mixed_effects_smmcc" DOUBLE,
"median_robust_smmcc" DOUBLE,
"median_geospatial_smmcc" DOUBLE,
"median_smmcc_2_lags" DOUBLE,
"median_smmcc_4_lags" DOUBLE,
"median_smmcc_additive_model" DOUBLE,
"median_smmcc_interactive" DOUBLE,
"median_geospatial_interactive_smmcc" DOUBLE,
"median_smmcc_alone" DOUBLE
);CREATE TABLE smmccpcdefmn (
"defect" VARCHAR,
"mean_smmcc" DOUBLE,
"mean_mixed_effects_smmcc" DOUBLE,
"mean_robust_smmcc" DOUBLE,
"mean_geospatial_smmcc" DOUBLE,
"mean_smmcc_2_lags" DOUBLE,
"mean_smmcc_4_lags" DOUBLE,
"mean_smmcc_additive_model" DOUBLE,
"mean_smmcc_interactive" DOUBLE,
"mean_geospatial_interactive_smmcc" DOUBLE,
"mean_smmcc_alone" DOUBLE
);CREATE TABLE summarytable (
"data_type" VARCHAR,
"quintile_type" VARCHAR,
"cas_in_quintile_5" BIGINT,
"births_in_quintile_5" BIGINT,
"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 t13baeesciadf (
"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,
"ltruert" 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 t18baeesc (
"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,
"cigmonsc" DOUBLE,
"bngalcsc" DOUBLE,
"mrjmonsc" DOUBLE,
"anlyrsc" DOUBLE,
"cocyrsc" DOUBLE,
"d9thcrtsc" DOUBLE,
"cbcrtsc" DOUBLE,
"cbgrtsc" DOUBLE
);CREATE TABLE t18baeescia (
"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,
"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 tabldefmean (
"defect" VARCHAR,
"mnsmmcc" DOUBLE,
"mnsmmcclm" DOUBLE,
"mnsmmccsg" DOUBLE,
"mnsmmccst" DOUBLE,
"mnsmmcc2lag" DOUBLE,
"mnsmmcc4lag" DOUBLE,
"mnsmmccadd" DOUBLE,
"mnsmmccir" DOUBLE,
"mnsmmccstir" DOUBLE,
"mnsmmccst2lag" DOUBLE,
"mnsmmcconly" DOUBLE
);CREATE TABLE tabldefmedian (
"defect" VARCHAR,
"mdsmmcc" DOUBLE,
"mdsmmcclm" DOUBLE,
"mdsmmccsg" DOUBLE,
"mdsmmccst" DOUBLE,
"mdsmmcc2lag" DOUBLE,
"mdsmmcc4lag" DOUBLE,
"mdsmmccadd" DOUBLE,
"mdsmmccir" DOUBLE,
"mdsmmccstir" DOUBLE,
"mdsmmccst2lag" DOUBLE,
"mdsmmcconly" DOUBLE
);Anyone who has the link will be able to view this.