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 nbdxwwlcorrexpna33quincbd15ugrttbth (
"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,
"cbdquincnmug" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE,
"births" BIGINT,
"defnos" DOUBLE,
"notdefx" DOUBLE,
"defnostrue" DOUBLE,
"notdefxtrue" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15ugrttbthdich (
"defect" VARCHAR,
"cbdquincnmug" VARCHAR,
"totdefnos" BIGINT,
"totnotdefx" BIGINT,
"totdefnostrue" BIGINT,
"totnotdefxtrue" BIGINT
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15ugrttbthdichepiev (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" 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 nbdxwwlcorrexpna33quincbd15ugrttbthdichepievel (
"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 nbdxwwlcorrexpna33quincbd15ugrttbthdichepievellt (
"defect" VARCHAR,
"cbdquin5defx" DOUBLE,
"cbdquin5notdefx" DOUBLE,
"cbdrr" DOUBLE,
"cbdrrcilo" DOUBLE,
"cbdrrcihi" DOUBLE,
"cbdor" DOUBLE,
"cbdorcilo" DOUBLE,
"cbdorcihi" DOUBLE,
"cbdafe" DOUBLE,
"cbdafecilo" DOUBLE,
"cbdafecihi" DOUBLE,
"cbdpaf" DOUBLE,
"cbdpafcilo" DOUBLE,
"cbdpafcihi" DOUBLE,
"cbdchisqu" DOUBLE,
"cbdpvalue" DOUBLE,
"cbdevalrrhil" DOUBLE,
"cbdevalrrlol" DOUBLE,
"quin5defx" DOUBLE,
"quin5notdefx" DOUBLE,
"quin1defx" DOUBLE,
"quin1notdefx" DOUBLE,
"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 nbdxwwlcorrexpna33quincbd15ugrttbthdichepievelltpres (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rr_c_i" VARCHAR,
"or_c_i" VARCHAR,
"afe_c_i" VARCHAR,
"paf_c_i" VARCHAR,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE,
"quin1defx" DOUBLE,
"quin1notdefx" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15ugrttbthdichepievtrueval (
"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 nbdxwwlcorrexpna33quincbg15 (
"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 nbdxwwlcorrexpna33quincbg15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbg15rtt (
"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 nbdxwwlcorrexpna33quincbn15 (
"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 nbdxwwlcorrexpna33quincbn15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbn15rtt (
"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 nbdxwwlcorrexpna33quincig15 (
"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 nbdxwwlcorrexpna33quincig15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincig15rtt (
"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 nbdxwwlcorrexpna33quincoc15 (
"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 nbdxwwlcorrexpna33quincoc15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincoc15rtt (
"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 nbdxwwlcorrexpna33quinthc15 (
"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 nbdxwwlcorrexpna33quinthc15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinthc15rtt (
"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 nbdxwwlcorrexpna33quinug (
"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
);
CREATE TABLE nbdxwwlcorrexpna33_revised (
"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
);
CREATE TABLE nbdxwwlcorrexprel (
"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,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"pt" BIGINT,
"ptt" BIGINT,
"pttt" BIGINT,
"ppttt" BIGINT
);
Anyone who has the link will be able to view this.