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 mickab2esia (
"state" VARCHAR,
"year" BIGINT,
"rate" DOUBLE,
"status" VARCHAR,
"dichstat" VARCHAR,
"thcrel3" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"quinci" VARCHAR,
"quincn" VARCHAR,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"canrel" VARCHAR,
"ratesc" DOUBLE,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE mocabeesc (
"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,
"ratesc" DOUBLE,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"canrel" VARCHAR,
"cigmonsc" DOUBLE,
"bngalcsc" DOUBLE,
"mrjmonsc" DOUBLE,
"anlyrsc" DOUBLE,
"cocyrsc" DOUBLE,
"d9thcrtsc" DOUBLE,
"cbcrtsc" DOUBLE,
"cbgrtsc" DOUBLE
);
CREATE TABLE mocabeescia (
"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,
"ratesc" DOUBLE,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"canrel" VARCHAR,
"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 nbdxwwlcorrexpaudslopealcmoneva (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"alcmonslope" DOUBLE,
"p_value" DOUBLE,
"r_squared" DOUBLE,
"adj_r_squared" DOUBLE,
"s_d" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"ixalcmon" BIGINT,
"evalolsptalcmonl" DOUBLE,
"evalolsloalcmonl" DOUBLE,
"ix" BIGINT,
"fix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpaudslopealcmoneva2 (
"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,
"evalolsptalcmonl" DOUBLE,
"evalolsloalcmonl" DOUBLE,
"ix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpaudslopealcmoneva3 (
"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,
"evalolsptalcmonl" DOUBLE,
"evalolsloalcmonl" DOUBLE,
"ixalcmn" BIGINT
);
CREATE TABLE nbdxwwlcorrexpaudslopeeva (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"audslope" DOUBLE,
"p_value" DOUBLE,
"r_squared" DOUBLE,
"adj_r_squared" DOUBLE,
"s_d" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"ixaud" BIGINT,
"evalolsptaudl" DOUBLE,
"evalolsloaudl" DOUBLE,
"ix" BIGINT,
"fix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpaudslopeeva2 (
"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,
"evalolsptaudl" DOUBLE,
"evalolsloaudl" DOUBLE,
"ix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpaudslopeeva3 (
"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,
"evalolsptaudl" DOUBLE,
"evalolsloaudl" DOUBLE,
"ixaud" BIGINT
);
CREATE TABLE nbdxwwlcorrexpcbcslope (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"cbcslope" DOUBLE,
"p_value" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolsptl" DOUBLE,
"evalolslol" DOUBLE,
"ixcbc" BIGINT
);
CREATE TABLE nbdxwwlcorrexpcbcslope2 (
"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 nbdxwwlcorrexpcbcslope3 (
"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,
"evalolslocbc" DOUBLE,
"ixcbc" BIGINT
);
CREATE TABLE nbdxwwlcorrexpcbdslope (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"cbdslope" DOUBLE,
"p_value" DOUBLE,
"r_squared" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"statistic1" DOUBLE,
"p_value1" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpcbdslopeev (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"cbdslope" DOUBLE,
"p_value" DOUBLE,
"r_squared" DOUBLE,
"adj_r_squared" DOUBLE,
"s_d" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolsptcbdl" DOUBLE,
"evalolslocbdl" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpcbdslopeeva (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"cbdslope" DOUBLE,
"p_value" DOUBLE,
"r_squared" DOUBLE,
"adj_r_squared" DOUBLE,
"s_d" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"ixcbd" BIGINT,
"evalolsptcbdl" DOUBLE,
"evalolslocbdl" DOUBLE,
"ix" BIGINT,
"fix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpcbdslopeeva2 (
"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,
"evalolsptcbdl" DOUBLE,
"evalolslocbdl" DOUBLE,
"ix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpcbdslopeeva3 (
"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,
"evalolsptcbdl" DOUBLE,
"evalolslocbdl" DOUBLE,
"ixcbd" BIGINT
);
CREATE TABLE nbdxwwlcorrexpcbgslope (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"cbgslope" DOUBLE,
"p_value" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolsptl" DOUBLE,
"evalolslol" DOUBLE,
"ixcbg" BIGINT
);
CREATE TABLE nbdxwwlcorrexpcbgslope2 (
"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 nbdxwwlcorrexpcbgslope3 (
"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,
"evalolslocbg" DOUBLE,
"ixcbg" BIGINT
);
CREATE TABLE nbdxwwlcorrexpcbnslope (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"cbnslope" DOUBLE,
"p_value" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolsptl" DOUBLE,
"evalolslol" DOUBLE,
"ixcbn" BIGINT
);
CREATE TABLE nbdxwwlcorrexpcbnslope2 (
"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 nbdxwwlcorrexpcbnslope3 (
"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,
"evalolslocbn" DOUBLE,
"ixcbn" BIGINT
);
CREATE TABLE nbdxwwlcorrexpcigslopeev (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"cigslope" DOUBLE,
"p_value" DOUBLE,
"r_squared" DOUBLE,
"adj_r_squared" DOUBLE,
"s_d" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"ix" BIGINT,
"evalolsptcigl" DOUBLE,
"evalolslocigl" DOUBLE,
"fix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpcigslopeev2 (
"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,
"evalolsptcigl" DOUBLE,
"evalolslocigl" DOUBLE,
"ix" BIGINT
);
Anyone who has the link will be able to view this.