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 nbdxwwlcorrexpna338dxbbquincihiloepievacorr3 (
"defect" VARCHAR,
"sn_defxhi" BIGINT,
"sn_birthshi" BIGINT,
"sn_defxlo" BIGINT,
"sn_birthslo" BIGINT,
"def_ratehi" DOUBLE,
"def_ratelo" DOUBLE,
"rr_corr" VARCHAR,
"chisq" DOUBLE,
"pvalue" DOUBLE,
"ciquinevalpt" DOUBLE,
"ciquinevallo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincihiloepievacorr3ss (
"s_sn_defxhi" BIGINT,
"s_sn_birthshi" DOUBLE,
"s_sn_defxlo" BIGINT,
"s_sn_birthslo" DOUBLE,
"rr_ci" VARCHAR,
"afe_ci" VARCHAR,
"par_ci" VARCHAR,
"chisqu" DOUBLE,
"pvalue" BIGINT,
"evaluerrpt" DOUBLE,
"evaluerrlo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincihiloepievacorrcorr3 (
"defect" VARCHAR,
"sn_defxcorrhi" BIGINT,
"sn_birthscorrhi" BIGINT,
"sn_defxcorrlo" BIGINT,
"sn_birthscorrlo" BIGINT,
"def_ratecorrhi" DOUBLE,
"def_ratecorrlo" DOUBLE,
"rr_etop_corr" VARCHAR,
"chisq" DOUBLE,
"pvalue" DOUBLE,
"ciquinevalpt" DOUBLE,
"ciquinevallo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincihiloepievacorrcorr3ss (
"s_sn_defxcorrhi" BIGINT,
"s_sn_birthscorrhi" DOUBLE,
"s_sn_defxcorrlo" BIGINT,
"s_sn_birthscorrlo" DOUBLE,
"rr_ci" VARCHAR,
"afe_ci" VARCHAR,
"par_ci" VARCHAR,
"chisqu" DOUBLE,
"pvalue" BIGINT,
"evaluerrpt" DOUBLE,
"evaluerrlo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincnhilo (
"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" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincnhiloepicorreva2 (
"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" VARCHAR,
"chisq" DOUBLE,
"pvalue" DOUBLE,
"cnquinrrptcorr" DOUBLE,
"cnquinrrlocorr" DOUBLE,
"cnquinrrhicorr" DOUBLE,
"cnquinevalpt" DOUBLE,
"cnquinevallo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincnhiloepieva2 (
"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" VARCHAR,
"cnquinchisq" DOUBLE,
"cnquinpvalue" DOUBLE,
"cnquinrrpt" DOUBLE,
"cnquinrrlo" DOUBLE,
"cnquinrrhi" DOUBLE,
"cnquinevalpt" DOUBLE,
"cnquinevallo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincnhiloepievacorr3 (
"defect" VARCHAR,
"sn_defxhi" BIGINT,
"sn_birthshi" BIGINT,
"sn_defxlo" BIGINT,
"sn_birthslo" BIGINT,
"def_ratehi" DOUBLE,
"def_ratelo" DOUBLE,
"rr_corr" VARCHAR,
"chisq" DOUBLE,
"pvalue" DOUBLE,
"cnquinevalpt" DOUBLE,
"cnquinevallo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincnhiloepievacorr3ss (
"s_sn_defxhi" BIGINT,
"s_sn_birthshi" DOUBLE,
"s_sn_defxlo" BIGINT,
"s_sn_birthslo" DOUBLE,
"rr_ci" VARCHAR,
"afe_ci" VARCHAR,
"par_ci" VARCHAR,
"chisqu" DOUBLE,
"pvalue" BIGINT,
"evaluerrpt" DOUBLE,
"evaluerrlo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincnhiloepievacorrcorr3 (
"defect" VARCHAR,
"sn_defxcorrhi" BIGINT,
"sn_birthscorrhi" BIGINT,
"sn_defxcorrlo" BIGINT,
"sn_birthscorrlo" BIGINT,
"def_ratecorrhi" DOUBLE,
"def_ratecorrlo" DOUBLE,
"rr_etop_corr" VARCHAR,
"chisq" DOUBLE,
"pvalue" DOUBLE,
"cnquinevalpt" DOUBLE,
"cnquinevallo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincnhiloepievacorrcorr3ss (
"s_sn_defxcorrhi" BIGINT,
"s_sn_birthscorrhi" DOUBLE,
"s_sn_defxcorrlo" BIGINT,
"s_sn_birthscorrlo" DOUBLE,
"rr_ci" VARCHAR,
"afe_ci" VARCHAR,
"par_ci" VARCHAR,
"chisqu" DOUBLE,
"pvalue" BIGINT,
"evaluerrpt" DOUBLE,
"evaluerrlo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbquin22both (
"defect" VARCHAR,
"sn_defxhi" BIGINT,
"sn_birthshi" BIGINT,
"sn_defxlo" BIGINT,
"sn_birthslo" BIGINT,
"def_ratehi" DOUBLE,
"def_ratelo" DOUBLE,
"relative_rate" DOUBLE,
"sn_defxcorrhi" BIGINT,
"sn_birthscorrhi" BIGINT,
"sn_defxcorrlo" BIGINT,
"sn_birthscorrlo" BIGINT,
"def_ratecorrhi" DOUBLE,
"def_ratecorrlo" DOUBLE,
"relative_ratecorr2" DOUBLE,
"canrel2" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna338dxbquin22both33 (
"defect" VARCHAR,
"sn_defxhi" BIGINT,
"sn_birthshi" BIGINT,
"sn_defxlo" BIGINT,
"sn_birthslo" BIGINT,
"def_ratehi" DOUBLE,
"def_ratelo" DOUBLE,
"relative_rate" DOUBLE,
"sn_defxcorrhi" BIGINT,
"sn_birthscorrhi" BIGINT,
"sn_defxcorrlo" BIGINT,
"sn_birthscorrlo" BIGINT,
"def_ratecorrhi" DOUBLE,
"def_ratecorrlo" DOUBLE,
"relative_ratecorr2" DOUBLE,
"canrel2" VARCHAR,
"adj_rr_diffc" DOUBLE,
"ix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpna338dxbquinboth_all_defects (
"defect" VARCHAR,
"sn_defxhi" BIGINT,
"sn_birthshi" BIGINT,
"sn_defxlo" BIGINT,
"sn_birthslo" BIGINT,
"def_ratehi" DOUBLE,
"def_ratelo" DOUBLE,
"relative_rate" DOUBLE,
"sn_defxcorrhi" BIGINT,
"sn_birthscorrhi" BIGINT,
"sn_defxcorrlo" BIGINT,
"sn_birthscorrlo" BIGINT,
"def_ratecorrhi" DOUBLE,
"def_ratecorrlo" DOUBLE,
"relative_ratecorr" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbquinboth_w_yi_vi_lci_uci (
"defect" VARCHAR,
"sn_defxhi" BIGINT,
"sn_birthshi" BIGINT,
"sn_defxlo" BIGINT,
"sn_birthslo" BIGINT,
"def_ratehi" DOUBLE,
"def_ratelo" DOUBLE,
"relative_rate" DOUBLE,
"sn_defxcorrhi" BIGINT,
"sn_birthscorrhi" BIGINT,
"sn_defxcorrlo" BIGINT,
"sn_birthscorrlo" BIGINT,
"def_ratecorrhi" DOUBLE,
"def_ratecorrlo" DOUBLE,
"relative_ratecorr" DOUBLE,
"canrel2" VARCHAR,
"yi" DOUBLE,
"vi" DOUBLE,
"lci" DOUBLE,
"uci" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33bqq9515hrelcleftsjrsumqs (
"defect" VARCHAR,
"sn_defxcorrq5" DOUBLE,
"sn_birthsq5" DOUBLE,
"sn_defxcorrq1" DOUBLE,
"sn_birthsq1" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33bqq9515hrelcleftsjrsumqskb (
"defect" VARCHAR,
"sn_defxcorrq5" DOUBLE,
"sn_birthsq5" DOUBLE,
"sn_defxcorrq1" DOUBLE,
"sn_birthsq1" DOUBLE,
"sn_defxq5" DOUBLE,
"sn_birthsq51" DOUBLE,
"sn_defxq1" DOUBLE,
"sn_birthsq11" DOUBLE,
"corrratio" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33bqq9515hrelcleftsrsumqs (
"defect" VARCHAR,
"sn_defxq5" DOUBLE,
"sn_birthsq5" DOUBLE,
"sn_defxq1" DOUBLE,
"sn_birthsq1" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33bqq9545mrsumq45 (
"defect" VARCHAR,
"sn_defxcorrq5" BIGINT,
"sn_birthsq5" BIGINT,
"sn_defxcorrq4" BIGINT,
"sn_birthsq4" BIGINT
);
CREATE TABLE nbdxwwlcorrexpna33bth (
"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,
"births" BIGINT,
"defnos" DOUBLE,
"notdefx" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33bthquin (
"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
);
CREATE TABLE nbdxwwlcorrexpna33bthquintru (
"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 nbdxwwlcorrexpna33bthquintrucbd (
"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
);
CREATE TABLE nbdxwwlcorrexpna33bthquintrucbdeva (
"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 nbdxwwlcorrexpna33bthquintruthc (
"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
);
Anyone who has the link will be able to view this.