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 nbdxwwlcorrexpna33bthquintruthceva (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"t_statistic" DOUBLE,
"p_value" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolshil" DOUBLE,
"evalolsptl" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33canlisrel (
"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,
"canlis" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33mrjslopefull (
"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,
"mrjslope" DOUBLE,
"ixmrj" BIGINT
);
CREATE TABLE nbdxwwlcorrexpna33quin (
"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,
"thcrt" 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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quinamn15 (
"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,
"thcrt" 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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quinamn15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinamn15rtt (
"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,
"thcrt" 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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinanl15 (
"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,
"thcrt" 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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quinanl15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinanl15rtt (
"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,
"thcrt" 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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbng15 (
"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,
"thcrt" 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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quinbng15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbng15rtt (
"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,
"thcrt" 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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthamn15 (
"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,
"thcrt" 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,
"births" BIGINT,
"defnos" DOUBLE,
"notdefx" DOUBLE,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"cbdquincnmug" VARCHAR,
"defnostrue" DOUBLE,
"notdefxtrue" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthanl15 (
"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,
"thcrt" 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,
"births" BIGINT,
"defnos" DOUBLE,
"notdefx" DOUBLE,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"cbdquincnmug" VARCHAR,
"defnostrue" DOUBLE,
"notdefxtrue" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthanl1515rtt (
"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,
"thcrt" 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,
"births" BIGINT,
"defnos" DOUBLE,
"notdefx" DOUBLE,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"cbdquincnmug" VARCHAR,
"defnostrue" DOUBLE,
"notdefxtrue" DOUBLE,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthanl1515rttdichepiev (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rrcihi" DOUBLE,
"or" DOUBLE,
"orcilo" DOUBLE,
"orcihi" DOUBLE,
"afe" DOUBLE,
"afecilo" DOUBLE,
"afecihi" DOUBLE,
"paf" DOUBLE,
"pafcilo" DOUBLE,
"pafcihi" DOUBLE,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthanl1515rttdichepievpres (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr_c_i" VARCHAR,
"or_c_i" VARCHAR,
"afe_c_i" VARCHAR,
"paf_c_i" VARCHAR,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthbng15 (
"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,
"thcrt" 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,
"births" BIGINT,
"defnos" DOUBLE,
"notdefx" DOUBLE,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"cbdquincnmug" VARCHAR,
"defnostrue" DOUBLE,
"notdefxtrue" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthbng1515rtt (
"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,
"thcrt" 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,
"births" BIGINT,
"defnos" DOUBLE,
"notdefx" DOUBLE,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"cbdquincnmug" VARCHAR,
"defnostrue" DOUBLE,
"notdefxtrue" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthbng1515rttdichepiev (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rrcihi" DOUBLE,
"or" DOUBLE,
"orcilo" DOUBLE,
"orcihi" DOUBLE,
"afe" DOUBLE,
"afecilo" DOUBLE,
"afecihi" DOUBLE,
"paf" DOUBLE,
"pafcilo" DOUBLE,
"pafcihi" DOUBLE,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthbng1515rttdichepievpres (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr_c_i" VARCHAR,
"or_c_i" VARCHAR,
"afe_c_i" VARCHAR,
"paf_c_i" VARCHAR,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthcan15 (
"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,
"thcrt" 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,
"births" BIGINT,
"defnos" DOUBLE,
"notdefx" DOUBLE,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"cbdquincnmug" VARCHAR,
"defnostrue" DOUBLE,
"notdefxtrue" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthcan1515rtt (
"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,
"thcrt" 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,
"births" BIGINT,
"defnos" DOUBLE,
"notdefx" DOUBLE,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"cbdquincnmug" VARCHAR,
"defnostrue" DOUBLE,
"notdefxtrue" DOUBLE,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthcan1515rttdichepiev (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rrcihi" DOUBLE,
"or" DOUBLE,
"orcilo" DOUBLE,
"orcihi" DOUBLE,
"afe" DOUBLE,
"afecilo" DOUBLE,
"afecihi" DOUBLE,
"paf" DOUBLE,
"pafcilo" DOUBLE,
"pafcihi" DOUBLE,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
Anyone who has the link will be able to view this.