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 testsrr4raceslaugshortshortwh (
"state" VARCHAR,
"year" BIGINT,
"testcartwh" DOUBLE,
"mrjmon" DOUBLE,
"thcrt" DOUBLE,
"nhwhitetppot" DOUBLE
);
CREATE TABLE tszaeesc (
"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 tszaeescia (
"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 tx4abeesc (
"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 tx4abeescia (
"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 txgrabeesc (
"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 txgrabeescia (
"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 vertdb (
"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" DOUBLE,
"evalolsptaudl" DOUBLE,
"evalolsloaudl" DOUBLE,
"evalolsptalcmonl" DOUBLE,
"evalolsloalcmonl" DOUBLE,
"evalolsptl" DOUBLE,
"evalolslol" DOUBLE,
"ixmrj" DOUBLE,
"evalolsptthcl" DOUBLE,
"evalolslothcl" DOUBLE,
"evalolsptcbdl" DOUBLE,
"evalolslocbdl" DOUBLE,
"evalolspt" DOUBLE,
"evalolslo" DOUBLE
);
CREATE TABLE vsddaes (
"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 vsddaesia (
"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
);
Anyone who has the link will be able to view this.