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 anenzabeesc (
"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,
"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 anenzabeescia (
"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,
"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 anotabeesc (
"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 anotabeescia (
"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 armsaees (
"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,
"canrel" VARCHAR,
"ratesc" DOUBLE,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE
);
CREATE TABLE armsaeesc (
"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,
"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 armsaeescia (
"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,
"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 ascerttf (
"state" VARCHAR,
"n_2006" VARCHAR,
"n_2007" VARCHAR,
"n_2009" VARCHAR,
"n_2010" VARCHAR,
"n_2011" VARCHAR,
"n_2012" VARCHAR,
"n_2013" VARCHAR,
"n_2014" VARCHAR
);
CREATE TABLE ascerttl (
"state" VARCHAR,
"year" BIGINT,
"ascertt" VARCHAR
);
CREATE TABLE asdddaabeesc (
"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 asdddaabeescia (
"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 asmstaugpopregedfr (
"region" VARCHAR,
"year" BIGINT,
"nautreg" DOUBLE,
"nchilreg" BIGINT,
"autrtreg" DOUBLE,
"tpop" DOUBLE,
"mthcrt" DOUBLE,
"mcbdrt" DOUBLE,
"mcbcrt" DOUBLE,
"mcbgrt" DOUBLE,
"mcbnrt" DOUBLE,
"mabdalc" DOUBLE,
"manlyr" DOUBLE,
"mcigmon" DOUBLE,
"mcocyr" DOUBLE,
"mmrjmon" DOUBLE,
"mmhinc" DOUBLE
);
CREATE TABLE avsdabeesc (
"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 avsdabeescia (
"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 braind (
"defect" VARCHAR,
"group" VARCHAR,
"year" BIGINT,
"mcigmon" VARCHAR,
"mbngalc" VARCHAR,
"mmrjmon" VARCHAR,
"mcocyr" VARCHAR,
"manlyr" VARCHAR,
"md9thcrt" VARCHAR,
"mcbdrt" VARCHAR,
"mcbcrt" VARCHAR,
"mcbgrt" VARCHAR,
"mcnbrt" VARCHAR,
"mtruertsc" VARCHAR,
"mltruert" VARCHAR,
"mltruertsc" VARCHAR,
"mratesc" VARCHAR
);
CREATE TABLE candefxlistdf (
"defect" VARCHAR,
"ixmrj" BIGINT,
"ixthc" BIGINT,
"ixcbd" BIGINT,
"ixcbg" BIGINT,
"ixcbc" BIGINT,
"ixcbn" BIGINT,
"ixthv" BIGINT,
"evalolslomrj" DOUBLE,
"evalolslothcl" DOUBLE,
"evalolslocbdl" DOUBLE,
"evalolslocbg" DOUBLE,
"evalolslocbc" DOUBLE,
"evalolslocbn" DOUBLE,
"evalolslothv" DOUBLE,
"sumev" DOUBLE
);
CREATE TABLE cari (
"sex" VARCHAR,
"race_ethnicity" VARCHAR,
"age" VARCHAR,
"ratetype" VARCHAR,
"year" BIGINT,
"ageadjrate" VARCHAR,
"aartlci" VARCHAR,
"aarateuci" VARCHAR,
"race" VARCHAR,
"site" VARCHAR
);
CREATE TABLE carie (
"sex" VARCHAR,
"race_ethnicity" VARCHAR,
"age" VARCHAR,
"ratetype" VARCHAR,
"year" BIGINT,
"ageadjrate" VARCHAR,
"aartlci" VARCHAR,
"aarateuci" VARCHAR,
"race" VARCHAR,
"site" VARCHAR
);
CREATE TABLE chromod (
"defect" VARCHAR,
"group" VARCHAR,
"year" BIGINT,
"mcigmon" VARCHAR,
"mbngalc" VARCHAR,
"mmrjmon" VARCHAR,
"mcocyr" VARCHAR,
"manlyr" VARCHAR,
"md9thcrt" VARCHAR,
"mcbdrt" VARCHAR,
"mcbcrt" VARCHAR,
"mcbgrt" VARCHAR,
"mcnbrt" VARCHAR,
"mtruertsc" VARCHAR,
"mltruert" VARCHAR,
"mltruertsc" VARCHAR,
"mratesc" VARCHAR
);
CREATE TABLE chromodd05 (
"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,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE
);
CREATE TABLE chromodd05easpcomp (
"state" VARCHAR,
"year" BIGINT,
"status" VARCHAR,
"cigmon" DOUBLE,
"bngalc" DOUBLE,
"mrjmon" DOUBLE,
"anlyr" DOUBLE,
"cocyr" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"rate" DOUBLE,
"truert" DOUBLE,
"deletion22q11_2" VARCHAR,
"trisomy13" VARCHAR,
"trisomy18" VARCHAR,
"trisomy21" VARCHAR,
"turnersyn" VARCHAR
);
CREATE TABLE chromodd05easpcomppcna (
"state" VARCHAR,
"year" BIGINT,
"status" VARCHAR,
"cigmon" DOUBLE,
"bngalc" DOUBLE,
"mrjmon" DOUBLE,
"anlyr" DOUBLE,
"cocyr" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"rate" DOUBLE,
"deletion22q11_2" DOUBLE,
"trisomy13" DOUBLE,
"trisomy18" DOUBLE,
"trisomy21" DOUBLE,
"turnersyn" DOUBLE,
"pc1" DOUBLE
);
CREATE TABLE chromodd05easpcomppcnaipw (
"state" VARCHAR,
"year" BIGINT,
"status" VARCHAR,
"cigmon" DOUBLE,
"bngalc" DOUBLE,
"mrjmon" DOUBLE,
"anlyr" DOUBLE,
"cocyr" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"rate" DOUBLE,
"deletion22q11_2" DOUBLE,
"trisomy13" DOUBLE,
"trisomy18" DOUBLE,
"trisomy21" DOUBLE,
"turnersyn" DOUBLE,
"pc1" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT
);
CREATE TABLE chromodd05easpcomppcnaipwdf (
"state" VARCHAR,
"year" BIGINT,
"status" VARCHAR,
"cigmon" DOUBLE,
"bngalc" DOUBLE,
"mrjmon" DOUBLE,
"anlyr" DOUBLE,
"cocyr" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"rate" DOUBLE,
"deletion22q11_2" DOUBLE,
"trisomy13" DOUBLE,
"trisomy18" DOUBLE,
"trisomy21" DOUBLE,
"turnersyn" DOUBLE,
"pc1" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE chromodd05easpcomppcnaipwe (
"state" VARCHAR,
"year" BIGINT,
"status" VARCHAR,
"cigmon" DOUBLE,
"bngalc" DOUBLE,
"mrjmon" DOUBLE,
"anlyr" DOUBLE,
"cocyr" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"rate" DOUBLE,
"deletion22q11_2" DOUBLE,
"trisomy13" DOUBLE,
"trisomy18" DOUBLE,
"trisomy21" DOUBLE,
"turnersyn" DOUBLE,
"pc1" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT
);
Anyone who has the link will be able to view this.