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 chromodd99 (
"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 chromosoaml_defect_final_table (
"state" VARCHAR,
"y2005" BIGINT,
"y2006" BIGINT,
"y2007" BIGINT,
"y2009" BIGINT,
"y2010" BIGINT,
"y2011" BIGINT,
"y2012" BIGINT,
"y2013" BIGINT,
"sum" BIGINT
);
CREATE TABLE cleftapsp (
"state" VARCHAR,
"year" BIGINT,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"d9thcrt" DOUBLE,
"cbgrt" DOUBLE,
"ltruertsc" DOUBLE,
"cleft_lip_alone" DOUBLE,
"cleft_lip_with_and_without_cleft_palate" DOUBLE,
"cleft_lip_with_cleft_palate" DOUBLE,
"cleft_palate_alone" DOUBLE,
"clefts_all" DOUBLE
);
CREATE TABLE cleftapspsmmm (
"state" VARCHAR,
"year" BIGINT,
"manlyr" DOUBLE,
"mbngalc" DOUBLE,
"mcigmon" DOUBLE,
"mcocyr" DOUBLE,
"mmrjmon" DOUBLE,
"md9thcrt" DOUBLE,
"mcbgrt" DOUBLE,
"clefts_all" DOUBLE
);
CREATE TABLE cleftapspsmmma (
"state" VARCHAR,
"year" BIGINT,
"manlyr" DOUBLE,
"mbngalc" DOUBLE,
"mcigmon" DOUBLE,
"mcocyr" DOUBLE,
"mmrjmon" DOUBLE,
"md9thcrt" DOUBLE,
"mcbgrt" DOUBLE,
"mcomp" DOUBLE,
"mtoprt" DOUBLE,
"mfmaxtr" DOUBLE,
"mquinci" VARCHAR,
"clefts_all" DOUBLE,
"clefts_allsc" DOUBLE,
"mclefts_allsc" DOUBLE,
"lclefts_allsc" DOUBLE,
"lclefts_all" DOUBLE,
"mtruert" DOUBLE,
"id" BIGINT,
"tstart" BIGINT,
"tend" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE cleftapspsmmmaaees (
"state" VARCHAR,
"year" BIGINT,
"manlyr" DOUBLE,
"mbngalc" DOUBLE,
"mcigmon" DOUBLE,
"mcocyr" DOUBLE,
"mmrjmon" DOUBLE,
"md9thcrt" DOUBLE,
"mcbgrt" DOUBLE,
"clefts_all" DOUBLE,
"lclefts_all" DOUBLE
);
CREATE TABLE cleftapspsmmmasaetablclefts_all (
"state" VARCHAR,
"n_2005" DOUBLE,
"n_2006" DOUBLE,
"n_2007" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE
);
CREATE TABLE cleftapspsmmmasaetabrt (
"state" VARCHAR,
"n_2005" DOUBLE,
"n_2006" DOUBLE,
"n_2007" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE
);
CREATE TABLE cleftspsp (
"state" VARCHAR,
"year" BIGINT,
"quinci" VARCHAR,
"clefts_all" DOUBLE
);
CREATE TABLE cpuv2aeesc (
"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,
"ltruertsc" DOUBLE,
"cigmonsc" DOUBLE,
"bngalcsc" DOUBLE,
"mrjmonsc" DOUBLE,
"anlyrsc" DOUBLE,
"cocyrsc" DOUBLE,
"d9thcrtsc" DOUBLE,
"cbcrtsc" DOUBLE,
"cbgrtsc" DOUBLE
);
CREATE TABLE cpuv2ascia (
"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" BIGINT,
"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,
"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 cumevals (
"congenital_anomaly" VARCHAR,
"cumeval" BIGINT
);
CREATE TABLE cumevals3 (
"substance" VARCHAR,
"sumevalue" BIGINT,
"no_defx" BIGINT
);
CREATE TABLE cumevals4 (
"substance" VARCHAR,
"sumevalue" BIGINT,
"no_defx" BIGINT
);
CREATE TABLE dat (
"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 dat_marginals_quin5_v_others_numbers_2 (
"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 defsum33na (
"state" VARCHAR,
"year" BIGINT,
"defect" VARCHAR,
"rate" DOUBLE,
"status" VARCHAR,
"mrjmon" DOUBLE,
"d9thcrt" DOUBLE,
"cbgrt" DOUBLE,
"canrel" VARCHAR,
"ltruertsc" DOUBLE
);
CREATE TABLE defsum441 (
"state" VARCHAR,
"year" BIGINT,
"rate" DOUBLE,
"mrjmon" DOUBLE,
"defect" VARCHAR,
"status" VARCHAR,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"lratesc" DOUBLE,
"canrel" VARCHAR
);
CREATE TABLE defsum441na (
"state" VARCHAR,
"year" BIGINT,
"rate" DOUBLE,
"mrjmon" DOUBLE,
"defect" VARCHAR,
"status" VARCHAR,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"lratesc" DOUBLE,
"canrel" VARCHAR
);
CREATE TABLE defsum55 (
"state" VARCHAR,
"year" BIGINT,
"rate" DOUBLE,
"mrjmon" DOUBLE,
"defect" VARCHAR,
"status" VARCHAR,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"canrel" VARCHAR,
"ratesc" DOUBLE,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE
);
CREATE TABLE del22aeesc (
"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,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"pt" BIGINT,
"ltruertsc" DOUBLE,
"ltruert" DOUBLE,
"cigmonsc" DOUBLE,
"bngalcsc" DOUBLE,
"mrjmonsc" DOUBLE,
"anlyrsc" DOUBLE,
"cocyrsc" DOUBLE,
"d9thcrtsc" DOUBLE,
"cbcrtsc" DOUBLE,
"cbgrtsc" DOUBLE
);
CREATE TABLE del22aeescia (
"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,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"pt" BIGINT,
"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 diaaia (
"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" BIGINT,
"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
);
CREATE TABLE diaaiaaees (
"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
);
CREATE TABLE dnsaaeesc (
"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
);
Anyone who has the link will be able to view this.