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
);
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_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 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 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
);
CREATE TABLE dnsaaeescia (
"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,
"ltruert" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE downskriged (
"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 downskrigedipwweighted (
"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,
"ltruert" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE ebsda05sscare (
"state" VARCHAR,
"year" BIGINT,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"truert" DOUBLE,
"ltruertsc" DOUBLE
);
CREATE TABLE ebsda05sscares (
"state" VARCHAR,
"year" BIGINT,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"thcvrt" DOUBLE,
"truert" DOUBLE,
"ltruertsc" DOUBLE
);
CREATE TABLE ebsza (
"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,
"pt" BIGINT,
"ptt" BIGINT,
"gx" BIGINT,
"ltruertsc" DOUBLE
);
CREATE TABLE ebszaia (
"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,
"pt" BIGINT,
"ptt" BIGINT,
"gx" BIGINT,
"ltruertsc" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE eosaa (
"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
);
CREATE TABLE eosaaia (
"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 eosada05sscare (
"state" VARCHAR,
"year" BIGINT,
"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,
"rate" DOUBLE,
"truert" DOUBLE,
"ltruertsc" DOUBLE
);
CREATE TABLE eosada05sscares (
"state" VARCHAR,
"year" BIGINT,
"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,
"rate" DOUBLE,
"truert" DOUBLE,
"ltruertsc" DOUBLE
);
CREATE TABLE evaldescstats (
"minimum_e_value" VARCHAR,
"number_in_band" BIGINT,
"percent" DOUBLE,
"percentage" VARCHAR
);
CREATE TABLE evalsum (
"group_no" BIGINT,
"def_no" BIGINT,
"intradef_no" BIGINT,
"intragroup_no" BIGINT,
"group" VARCHAR,
"defect" VARCHAR,
"lleval" VARCHAR,
"levalexp" BIGINT
);
CREATE TABLE evalsumdefxinfadd (
"defect" VARCHAR,
"sumleval" BIGINT,
"no_evalues" BIGINT,
"mnleval" DOUBLE,
"no_infinite" BIGINT,
"infpercent" DOUBLE
);
CREATE TABLE evalsumgroupinfadd (
"group" VARCHAR,
"sumleval" BIGINT,
"no_evalues" BIGINT,
"defno" BIGINT,
"mnleval" DOUBLE,
"no_infinite" BIGINT,
"infpercent" DOUBLE
);
CREATE TABLE exp7cannbds (
"defect" VARCHAR,
"cannabis" BIGINT,
"thc" DOUBLE,
"cbg" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"thcv" DOUBLE,
"cbd" DOUBLE
);
CREATE TABLE faced (
"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 generald (
"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 gssaees (
"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 gssaeesc (
"state" VARCHAR,
"year" BIGINT,
"rate" DOUBLE,
"status" VARCHAR,
"canrel" VARCHAR,
"ratesc" DOUBLE,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"cigmon" DOUBLE,
"bngalc" DOUBLE,
"mrjmon" DOUBLE,
"anlyr" DOUBLE,
"cocyr" DOUBLE,
"d9thcrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE
);
CREATE TABLE gssaeesia (
"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,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE gssda05sscar (
"state" VARCHAR,
"year" BIGINT,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE
);
CREATE TABLE gssda05sscariaa (
"state" VARCHAR,
"year" BIGINT,
"rate" DOUBLE,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"truert" DOUBLE,
"ratesc" DOUBLE,
"ratesc1" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"lcocyr" DOUBLE,
"lanlyr" DOUBLE,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE gssda99 (
"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,
"pt" BIGINT,
"ptt" BIGINT,
"gx" BIGINT,
"ltruertsc" DOUBLE
);
CREATE TABLE gssda99r (
"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,
"pt" BIGINT,
"ptt" BIGINT,
"gx" BIGINT,
"ltruertsc" DOUBLE
);
CREATE TABLE gsspaneldatascaledweighted (
"state" VARCHAR,
"year" BIGINT,
"rate" DOUBLE,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"truert" DOUBLE,
"ratesc" DOUBLE,
"ratesc1" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"lcocyr" DOUBLE,
"lanlyr" DOUBLE,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE heartd (
"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 horizdb (
"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 horizdb2 (
"defect" VARCHAR,
"cannabis" DOUBLE,
"thc" DOUBLE,
"cbg" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbd" DOUBLE,
"thcv" DOUBLE
);
CREATE TABLE horizdb3 (
"cannabis" BIGINT,
"thc" DOUBLE,
"cbg" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbd" DOUBLE,
"thcv" DOUBLE
);
CREATE TABLE horizdbcannbd (
"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 horizdb_z (
"defect" VARCHAR,
"ixmrj" DOUBLE,
"ixthc" DOUBLE,
"ixcbd" DOUBLE,
"ixcbg" DOUBLE,
"ixcbc" DOUBLE,
"ixcbn" DOUBLE,
"ixthv" DOUBLE,
"evalolslomrj" DOUBLE,
"evalolslothcl" DOUBLE,
"evalolslocbdl" DOUBLE,
"evalolslocbg" DOUBLE,
"evalolslocbc" DOUBLE,
"evalolslocbn" DOUBLE,
"evalolslothv" DOUBLE,
"sumev" DOUBLE
);
CREATE TABLE hpedia (
"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,
"pt" BIGINT,
"ptt" BIGINT,
"gx" BIGINT,
"ltruertsc" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE hpediabees (
"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,
"ltruertsc" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE legsaees (
"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,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE
);
CREATE TABLE legsaeesc (
"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,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"cigmonsc" DOUBLE,
"bngalcsc" DOUBLE,
"mrjmonsc" DOUBLE,
"anlyrsc" DOUBLE,
"cocyrsc" DOUBLE,
"d9thcrtsc" DOUBLE,
"cbcrtsc" DOUBLE,
"cbgrtsc" DOUBLE
);
CREATE TABLE legsaeesia (
"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,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE limbd (
"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 lisaa (
"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
);
CREATE TABLE lisaaia (
"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 lisada05sscare (
"state" VARCHAR,
"year" BIGINT,
"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,
"rate" DOUBLE,
"truert" DOUBLE,
"ltruertsc" DOUBLE
);
CREATE TABLE lisada05sscares (
"state" VARCHAR,
"year" BIGINT,
"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,
"rate" DOUBLE,
"truert" DOUBLE,
"ltruertsc" DOUBLE
);
CREATE TABLE llraees (
"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,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE
);
CREATE TABLE llraeesia (
"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,
"truert" DOUBLE,
"ratesc" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE marginals (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR
);
CREATE TABLE marginals_quin5_v_others_numbers (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR
);
CREATE TABLE meangrouptab (
"group" VARCHAR,
"mnsmmccsg" DOUBLE,
"mnsmmcclm" DOUBLE,
"mnsmmccst" DOUBLE
);
CREATE TABLE mediangrouptab (
"group" VARCHAR,
"mdsmmccsg" DOUBLE,
"mdsmmcclm" DOUBLE,
"mdsmmccst" DOUBLE
);
CREATE TABLE mickab (
"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
);
CREATE TABLE mickab2es (
"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
);
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
);
CREATE TABLE nbdxwwlcorrexpcigslopeev3 (
"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,
"ixcig" BIGINT
);
CREATE TABLE nbdxwwlcorrexpjoin (
"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" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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,
"pt" BIGINT,
"ptt" DOUBLE,
"pttt" DOUBLE,
"ppttt" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpmrjslope (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"mrjslope" DOUBLE,
"p_value" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolsptl" DOUBLE,
"evalolslol" DOUBLE,
"ixmrj" BIGINT,
"fix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpmrjslope2 (
"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,
"evalolslol" DOUBLE,
"ixmrj" BIGINT
);
CREATE TABLE nbdxwwlcorrexpmrjslope3 (
"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,
"evalolslomrj" DOUBLE,
"ixmrj" BIGINT
);
CREATE TABLE nbdxwwlcorrexpmrjslopefull (
"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" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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,
"mrjslope" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna (
"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" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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,
"pt" BIGINT,
"ptt" BIGINT,
"pttt" BIGINT,
"ppttt" BIGINT
);
CREATE TABLE nbdxwwlcorrexpna22 (
"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" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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,
"ratesc" DOUBLE,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"canrel" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33 (
"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" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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 nbdxwwlcorrexpna33_revised (
"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" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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 nbdxwwlcorrexpna338canlis (
"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" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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,
"canlis" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna338dxbb (
"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" DOUBLE,
"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,
"quincidich" VARCHAR,
"births" BIGINT,
"quincndich" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna338dxbbcanlis (
"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" DOUBLE,
"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,
"quincidich" VARCHAR,
"births" BIGINT,
"quincndich" VARCHAR,
"canlis" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincihilo (
"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_x" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincihilo15epicorreva2 (
"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_x" VARCHAR,
"chisq" DOUBLE,
"pvalue" DOUBLE,
"ciquinrrptcorr" DOUBLE,
"ciquinrrlocorr" DOUBLE,
"ciquinrrhicorr" DOUBLE,
"ciquinevalpt" DOUBLE,
"ciquinevallo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincihilo15epievacorrcorr3 (
"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 nbdxwwlcorrexpna338dxbbquincihilo15epievacorrcorr3sst (
"data_type" VARCHAR,
"quintile_type" VARCHAR,
"cas_in_quintile_5" BIGINT,
"births_in_quintile_5" DOUBLE,
"cas_in_lower_quintiles" BIGINT,
"births_in_lower_quintiles" DOUBLE,
"rr_ci" VARCHAR,
"afe_ci" VARCHAR,
"par_ci" VARCHAR,
"chisqu" DOUBLE,
"pvalue" BIGINT,
"evaluerrpt" DOUBLE,
"evaluerrlo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincihilo45afeparetopfa2 (
"defect" VARCHAR,
"sn_defxcorrhi" BIGINT,
"sn_birthscorrhi" BIGINT,
"sn_defxcorrlo" BIGINT,
"sn_birthscorrlo" BIGINT,
"rr_ci" VARCHAR,
"afe_ci" VARCHAR,
"par_ci" VARCHAR,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evaluerrpt" DOUBLE,
"evaluerrlo" DOUBLE,
"rrpt" DOUBLE,
"afept" DOUBLE,
"parpt" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincihilo45afeparraw2 (
"defect" VARCHAR,
"sn_defxhi" BIGINT,
"sn_birthshi" BIGINT,
"sn_defxlo" BIGINT,
"sn_birthslo" BIGINT,
"rr_ci" VARCHAR,
"afe_ci" VARCHAR,
"par_ci" VARCHAR,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evaluerrpt" DOUBLE,
"evaluerrlo" DOUBLE,
"rrpt" DOUBLE,
"afept" DOUBLE,
"parpt" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincihilo45afeparraw2sst (
"data_type" VARCHAR,
"quintile_type" VARCHAR,
"cas_in_quintile_5" BIGINT,
"births_in_quintile_5" DOUBLE,
"cas_in_lower_quintiles" BIGINT,
"births_in_lower_quintiles" DOUBLE,
"rr_ci" VARCHAR,
"afe_ci" VARCHAR,
"par_ci" VARCHAR,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evaluerrpt" DOUBLE,
"evaluerrlo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincihilo45epicorreva2 (
"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_x" VARCHAR,
"chisq" DOUBLE,
"pvalue" DOUBLE,
"ciquinrrptcorr" DOUBLE,
"ciquinrrlocorr" DOUBLE,
"ciquinrrhicorr" DOUBLE,
"ciquinevalpt" DOUBLE,
"ciquinevallo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincihilo45epievacorrcorr3 (
"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 nbdxwwlcorrexpna338dxbbquincihilo45epievacorrcorr3sst (
"data_type" VARCHAR,
"quintile_type" VARCHAR,
"cas_in_quintile_5" BIGINT,
"births_in_quintile_5" DOUBLE,
"cas_in_lower_quintiles" BIGINT,
"births_in_lower_quintiles" DOUBLE,
"rr_ci" VARCHAR,
"afe_ci" VARCHAR,
"par_ci" VARCHAR,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evaluerrpt" DOUBLE,
"evaluerrlo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincihilo45epievaraw3 (
"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 nbdxwwlcorrexpna338dxbbquincihiloepicorreva2 (
"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_x" VARCHAR,
"chisq" DOUBLE,
"pvalue" DOUBLE,
"ciquinrrptcorr" DOUBLE,
"ciquinrrlocorr" DOUBLE,
"ciquinrrhicorr" DOUBLE,
"ciquinevalpt" DOUBLE,
"ciquinevallo" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna338dxbbquincihiloepieva2 (
"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_x" VARCHAR,
"ciquinchisq" DOUBLE,
"ciquinpvalue" DOUBLE,
"ciquinrrpt" DOUBLE,
"ciquinrrlo" DOUBLE,
"ciquinrrhi" DOUBLE,
"ciquinevalpt" DOUBLE,
"ciquinevallo" DOUBLE
);
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
);
CREATE TABLE nbdxwwlcorrexpna33bthquintruthceva (
"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 nbdxwwlcorrexpna33canlisrel (
"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" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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,
"canlis" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33mrjslopefull (
"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" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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,
"mrjslope" DOUBLE,
"ixmrj" BIGINT
);
CREATE TABLE nbdxwwlcorrexpna33quin (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quinamn15 (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quinamn15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinamn15rtt (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinanl15 (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quinanl15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinanl15rtt (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbng15 (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quinbng15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbng15rtt (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthamn15 (
"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 nbdxwwlcorrexpna33quinbthanl15 (
"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 nbdxwwlcorrexpna33quinbthanl1515rtt (
"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,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthanl1515rttdichepiev (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rrcihi" DOUBLE,
"or" DOUBLE,
"orcilo" DOUBLE,
"orcihi" DOUBLE,
"afe" DOUBLE,
"afecilo" DOUBLE,
"afecihi" DOUBLE,
"paf" DOUBLE,
"pafcilo" DOUBLE,
"pafcihi" DOUBLE,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthanl1515rttdichepievpres (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr_c_i" VARCHAR,
"or_c_i" VARCHAR,
"afe_c_i" VARCHAR,
"paf_c_i" VARCHAR,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthbng15 (
"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 nbdxwwlcorrexpna33quinbthbng1515rtt (
"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,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthbng1515rttdichepiev (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rrcihi" DOUBLE,
"or" DOUBLE,
"orcilo" DOUBLE,
"orcihi" DOUBLE,
"afe" DOUBLE,
"afecilo" DOUBLE,
"afecihi" DOUBLE,
"paf" DOUBLE,
"pafcilo" DOUBLE,
"pafcihi" DOUBLE,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthbng1515rttdichepievpres (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr_c_i" VARCHAR,
"or_c_i" VARCHAR,
"afe_c_i" VARCHAR,
"paf_c_i" VARCHAR,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthcan15 (
"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 nbdxwwlcorrexpna33quinbthcan1515rtt (
"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,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthcan1515rttdichepiev (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rrcihi" DOUBLE,
"or" DOUBLE,
"orcilo" DOUBLE,
"orcihi" DOUBLE,
"afe" DOUBLE,
"afecilo" DOUBLE,
"afecihi" DOUBLE,
"paf" DOUBLE,
"pafcilo" DOUBLE,
"pafcihi" DOUBLE,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthcan1515rttdichepievpres (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr_c_i" VARCHAR,
"or_c_i" VARCHAR,
"afe_c_i" VARCHAR,
"paf_c_i" VARCHAR,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthcbc15 (
"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 nbdxwwlcorrexpna33quinbthcbd15 (
"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 nbdxwwlcorrexpna33quinbthcbg15 (
"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 nbdxwwlcorrexpna33quinbthcbn15 (
"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 nbdxwwlcorrexpna33quinbthcig15 (
"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 nbdxwwlcorrexpna33quinbthcig1515rtt (
"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,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthcig1515rttdichepiev (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rrcihi" DOUBLE,
"or" DOUBLE,
"orcilo" DOUBLE,
"orcihi" DOUBLE,
"afe" DOUBLE,
"afecilo" DOUBLE,
"afecihi" DOUBLE,
"paf" DOUBLE,
"pafcilo" DOUBLE,
"pafcihi" DOUBLE,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthcig1515rttdichepievpres (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr_c_i" VARCHAR,
"or_c_i" VARCHAR,
"afe_c_i" VARCHAR,
"paf_c_i" VARCHAR,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthcoc15 (
"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 nbdxwwlcorrexpna33quinbthcoc1515rtt (
"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,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthcoc1515rttdichepiev (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rrcihi" DOUBLE,
"or" DOUBLE,
"orcilo" DOUBLE,
"orcihi" DOUBLE,
"afe" DOUBLE,
"afecilo" DOUBLE,
"afecihi" DOUBLE,
"paf" DOUBLE,
"pafcilo" DOUBLE,
"pafcihi" DOUBLE,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbthcoc1515rttdichepievpres (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr_c_i" VARCHAR,
"or_c_i" VARCHAR,
"afe_c_i" VARCHAR,
"paf_c_i" VARCHAR,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinbththc15 (
"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 nbdxwwlcorrexpna33quincan15 (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quincan15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincan15rtt (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbc15 (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quincbc15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbc15rtt (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15 (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15rtt (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15ug (
"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
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15ugrt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_2" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15ugrtt (
"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,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15ugrttbth (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"cbdquincnmug" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE,
"births" BIGINT,
"defnos" DOUBLE,
"notdefx" DOUBLE,
"defnostrue" DOUBLE,
"notdefxtrue" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15ugrttbthdich (
"defect" VARCHAR,
"cbdquincnmug" VARCHAR,
"totdefnos" BIGINT,
"totnotdefx" BIGINT,
"totdefnostrue" BIGINT,
"totnotdefxtrue" BIGINT
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15ugrttbthdichepiev (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rrcihi" DOUBLE,
"or" DOUBLE,
"orcilo" DOUBLE,
"orcihi" DOUBLE,
"afe" DOUBLE,
"afecilo" DOUBLE,
"afecihi" DOUBLE,
"paf" DOUBLE,
"pafcilo" DOUBLE,
"pafcihi" DOUBLE,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15ugrttbthdichepievel (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rrcihi" DOUBLE,
"or" DOUBLE,
"orcilo" DOUBLE,
"orcihi" DOUBLE,
"afe" DOUBLE,
"afecilo" DOUBLE,
"afecihi" DOUBLE,
"paf" DOUBLE,
"pafcilo" DOUBLE,
"pafcihi" DOUBLE,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15ugrttbthdichepievellt (
"defect" VARCHAR,
"cbdquin5defx" DOUBLE,
"cbdquin5notdefx" DOUBLE,
"cbdrr" DOUBLE,
"cbdrrcilo" DOUBLE,
"cbdrrcihi" DOUBLE,
"cbdor" DOUBLE,
"cbdorcilo" DOUBLE,
"cbdorcihi" DOUBLE,
"cbdafe" DOUBLE,
"cbdafecilo" DOUBLE,
"cbdafecihi" DOUBLE,
"cbdpaf" DOUBLE,
"cbdpafcilo" DOUBLE,
"cbdpafcihi" DOUBLE,
"cbdchisqu" DOUBLE,
"cbdpvalue" DOUBLE,
"cbdevalrrhil" DOUBLE,
"cbdevalrrlol" DOUBLE,
"quin5defx" DOUBLE,
"quin5notdefx" DOUBLE,
"quin1defx" DOUBLE,
"quin1notdefx" DOUBLE,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rrcihi" DOUBLE,
"or" DOUBLE,
"orcilo" DOUBLE,
"orcihi" DOUBLE,
"afe" DOUBLE,
"afecilo" DOUBLE,
"afecihi" DOUBLE,
"paf" DOUBLE,
"pafcilo" DOUBLE,
"pafcihi" DOUBLE,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15ugrttbthdichepievelltpres (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rr_c_i" VARCHAR,
"or_c_i" VARCHAR,
"afe_c_i" VARCHAR,
"paf_c_i" VARCHAR,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE,
"quin1defx" DOUBLE,
"quin1notdefx" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbd15ugrttbthdichepievtrueval (
"defect" VARCHAR,
"quin5defx" BIGINT,
"quin5notdefx" BIGINT,
"quin1defx" BIGINT,
"quin1notdefx" BIGINT,
"rr" DOUBLE,
"rrcilo" DOUBLE,
"rrcihi" DOUBLE,
"or" DOUBLE,
"orcilo" DOUBLE,
"orcihi" DOUBLE,
"afe" DOUBLE,
"afecilo" DOUBLE,
"afecihi" DOUBLE,
"paf" DOUBLE,
"pafcilo" DOUBLE,
"pafcihi" DOUBLE,
"chisqu" DOUBLE,
"pvalue" DOUBLE,
"evalrrhil" DOUBLE,
"evalrrlol" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbg15 (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quincbg15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbg15rtt (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbn15 (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quincbn15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincbn15rtt (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincig15 (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quincig15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincig15rtt (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincoc15 (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quincoc15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quincoc15rtt (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinthc15 (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpna33quinthc15rt (
"defect" VARCHAR,
"quintile_1" DOUBLE,
"quintile_5" DOUBLE,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinthc15rtt (
"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,
"cigquincnm" VARCHAR,
"bngquincnm" VARCHAR,
"amnquincnm" VARCHAR,
"canquincnm" VARCHAR,
"anlquincnm" VARCHAR,
"cocquincnm" VARCHAR,
"thcquincnm" VARCHAR,
"cbgquincnm" VARCHAR,
"cbcquincnm" VARCHAR,
"cbnquincnm" VARCHAR,
"cbdquincnm" VARCHAR,
"ratio" DOUBLE,
"diffc" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpna33quinug (
"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
);
CREATE TABLE nbdxwwlcorrexprel (
"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" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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,
"pt" BIGINT,
"ptt" BIGINT,
"pttt" BIGINT,
"ppttt" BIGINT
);
CREATE TABLE nbdxwwlcorrexprelra (
"defect" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"state" 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" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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,
"pt" BIGINT,
"ptt" BIGINT,
"pttt" BIGINT,
"ppttt" BIGINT
);
CREATE TABLE nbdxwwlcorrexprelradx (
"defect" VARCHAR,
"year" BIGINT,
"mtruertsc" VARCHAR,
"mltruert" VARCHAR,
"mltruertsc" VARCHAR,
"mratesc" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpthccbdcigalcoholslopes (
"state" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"defect" VARCHAR,
"rate" DOUBLE,
"status" VARCHAR,
"dichstat" VARCHAR,
"abbrev" VARCHAR,
"rel" VARCHAR,
"group" VARCHAR,
"thcrel3" VARCHAR,
"cvs" VARCHAR,
"endocardial_cushions" VARCHAR,
"brain" VARCHAR,
"chromosomal" VARCHAR,
"chromosomal2" VARCHAR,
"equivocal" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"year2" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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,
"thcslope" DOUBLE,
"ixthc" BIGINT,
"cbdslope" DOUBLE,
"ixcbd" BIGINT,
"cigslope" DOUBLE,
"ix" BIGINT,
"audslope" DOUBLE,
"ixaud" BIGINT,
"mrjslope" DOUBLE,
"ixmrj" BIGINT,
"alcmonslope" DOUBLE,
"ixalcmon" BIGINT
);
CREATE TABLE nbdxwwlcorrexpthccbdcigalcoholslopes33 (
"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" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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,
"thcslope" DOUBLE,
"ixthc" BIGINT,
"cbdslope" DOUBLE,
"ixcbd" BIGINT,
"cigslope" DOUBLE,
"ix" BIGINT,
"audslope" DOUBLE,
"ixaud" BIGINT,
"mrjslope" DOUBLE,
"ixmrj" BIGINT,
"alcmonslope" DOUBLE,
"ixalcmon" BIGINT
);
CREATE TABLE nbdxwwlcorrexpthccbdcigalcoholslopestimecanlis (
"state" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"defect" VARCHAR,
"rate" DOUBLE,
"status" VARCHAR,
"dichstat" VARCHAR,
"abbrev" VARCHAR,
"rel" VARCHAR,
"group" VARCHAR,
"thcrel3" VARCHAR,
"cvs" VARCHAR,
"endocardial_cushions" VARCHAR,
"brain" VARCHAR,
"chromosomal" VARCHAR,
"chromosomal2" VARCHAR,
"equivocal" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"year2" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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,
"thcslope" DOUBLE,
"ixthc" BIGINT,
"cbdslope" DOUBLE,
"ixcbd" BIGINT,
"cigslope" DOUBLE,
"ix" BIGINT,
"audslope" DOUBLE,
"ixaud" BIGINT,
"alcmonslope" DOUBLE,
"ixalcmon" BIGINT,
"estimate" DOUBLE,
"timeslope" DOUBLE,
"ixtime" BIGINT,
"canlis" VARCHAR
);
CREATE TABLE nbdxwwlcorrexpthccbdslopes (
"state" VARCHAR,
"year" BIGINT,
"period" VARCHAR,
"defect" VARCHAR,
"rate" DOUBLE,
"status" VARCHAR,
"dichstat" VARCHAR,
"abbrev" VARCHAR,
"rel" VARCHAR,
"group" VARCHAR,
"thcrel3" VARCHAR,
"cvs" VARCHAR,
"endocardial_cushions" VARCHAR,
"brain" VARCHAR,
"chromosomal" VARCHAR,
"chromosomal2" VARCHAR,
"equivocal" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"mrjyr" DOUBLE,
"tobmon" DOUBLE,
"year2" DOUBLE,
"aian" DOUBLE,
"aspi" DOUBLE,
"black" DOUBLE,
"white" DOUBLE,
"totpop" DOUBLE,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcv" DOUBLE,
"mhinc" DOUBLE,
"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,
"thcslope" DOUBLE,
"cbdslope" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpthcslope (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"thcslope" DOUBLE,
"p_value" DOUBLE,
"r_squared" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"statistic1" DOUBLE,
"p_value1" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpthcslope2eva (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"timeslope" DOUBLE,
"p_value" DOUBLE,
"r_squared" DOUBLE,
"adj_r_squared" DOUBLE,
"s_d" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"ixthc" BIGINT,
"evalolsptthcl" DOUBLE,
"evalolslothcl" DOUBLE,
"ix" BIGINT,
"fix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpthcslope2eva2 (
"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,
"evalolsptthcl" DOUBLE,
"evalolslothcl" DOUBLE,
"ix" BIGINT
);
CREATE TABLE nbdxwwlcorrexpthcslope2eva3 (
"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,
"evalolsptthcl" DOUBLE,
"evalolslothcl" DOUBLE,
"ixthc" BIGINT
);
CREATE TABLE nbdxwwlcorrexpthcslopeev (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"thcslope" DOUBLE,
"p_value" DOUBLE,
"r_squared" DOUBLE,
"adj_r_squared" DOUBLE,
"s_d" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolsptthcl" DOUBLE,
"evalolslothcl" DOUBLE
);
CREATE TABLE nbdxwwlcorrexpthvslope (
"defect" VARCHAR,
"term" VARCHAR,
"estimate" DOUBLE,
"std_error" DOUBLE,
"thvslope" DOUBLE,
"p_value" DOUBLE,
"adj_r_squared" DOUBLE,
"sigma" DOUBLE,
"model_t_statistic" DOUBLE,
"model_p_value" DOUBLE,
"evalolsptl" DOUBLE,
"evalolslol" DOUBLE,
"ixthv" BIGINT
);
CREATE TABLE nbdxwwlcorrexpthvslope2 (
"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 nbdxwwlcorrexpthvslope3 (
"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,
"evalolslothv" DOUBLE,
"ixthv" BIGINT
);
CREATE TABLE nbdxwwlexpna338dxbbquincihilo15epieva2 (
"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_x" VARCHAR,
"chisq" DOUBLE,
"pvalue" DOUBLE,
"ciquinrrpt" DOUBLE,
"ciquinrrlo" DOUBLE,
"ciquinrrhi" DOUBLE,
"ciquinevalpt" DOUBLE,
"ciquinevallo" DOUBLE
);
CREATE TABLE nbdxwwlexpna338dxbbquincihilo15epieva3 (
"defect" VARCHAR,
"sn_defxhi" BIGINT,
"sn_birthshi" BIGINT,
"sn_defxlo" BIGINT,
"sn_birthslo" BIGINT,
"def_ratehi" DOUBLE,
"def_ratelo" DOUBLE,
"rr_ci" VARCHAR,
"chisq" DOUBLE,
"pvalue" DOUBLE,
"ciquinevalpt" DOUBLE,
"ciquinevallo" DOUBLE
);
CREATE TABLE nbdxwwlexpna338dxbbquincihilo15epieva3sst (
"data_type" VARCHAR,
"quintile_type" VARCHAR,
"cas_in_quintile_5" BIGINT,
"births_in_quintile_5" DOUBLE,
"cas_in_lower_quintiles" BIGINT,
"births_in_lower_quintiles" DOUBLE,
"rr_ci" VARCHAR,
"afe_ci" VARCHAR,
"par_ci" VARCHAR,
"chisqu" DOUBLE,
"pvalue" VARCHAR,
"evaluerrpt" DOUBLE,
"evaluerrlo" DOUBLE
);
CREATE TABLE newdfdf (
"state" VARCHAR,
"year" BIGINT,
"pcancrt" DOUBLE,
"allrate" DOUBLE,
"testcartwh" DOUBLE,
"tri21rt" DOUBLE,
"tri18rt" DOUBLE,
"tri13rt" DOUBLE,
"del22rt" DOUBLE,
"turnsynrt" DOUBLE,
"tri21trurt" DOUBLE,
"tri18trurt" DOUBLE,
"tri13trurt" DOUBLE,
"del22trurt" DOUBLE,
"turnstrurt" DOUBLE,
"cigmon" DOUBLE,
"abodalc" DOUBLE,
"mrjmon" DOUBLE,
"anlyr" DOUBLE,
"cocyr" DOUBLE,
"income" BIGINT,
"caucasian" DOUBLE,
"african" DOUBLE,
"asian" DOUBLE,
"aian" DOUBLE,
"hispanic" DOUBLE,
"nhpi" DOUBLE,
"nhwhitet" DOUBLE,
"nhblackt" DOUBLE,
"hispanict" DOUBLE,
"asiant" DOUBLE,
"aiant" DOUBLE,
"nhpit" DOUBLE,
"sw" DOUBLE,
"trw" DOUBLE,
"quincim" VARCHAR,
"quincnm" VARCHAR,
"quincnm2" VARCHAR,
"quincnmint" BIGINT,
"statusnew" VARCHAR,
"dichstatnew" VARCHAR,
"dichstatnew3" VARCHAR,
"quincnm514" VARCHAR,
"thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE,
"thcrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"cbnrt" DOUBLE,
"cbdrt" DOUBLE,
"nhwhitetppot" DOUBLE,
"nhblacktppot" DOUBLE,
"hispanictppot" DOUBLE,
"asiantppot" DOUBLE,
"aiantppot" DOUBLE,
"nhpitppot" DOUBLE,
"pc1canc" DOUBLE,
"pc1triraw" DOUBLE,
"pc1defxraw" DOUBLE,
"pc1truedefx" DOUBLE,
"pc1cannbd" DOUBLE,
"ltestcartwh" DOUBLE,
"ltri21rt" DOUBLE,
"ltri18rt" DOUBLE,
"ltri13rt" DOUBLE,
"ldel22rt" DOUBLE,
"lturnsynrt" DOUBLE,
"quincnmgross" VARCHAR,
"quincnmgrossa" VARCHAR,
"quincnmgross514" VARCHAR,
"pc1ca2" DOUBLE
);
CREATE TABLE no_s_cannabis_related_defects (
"defect" VARCHAR,
"sn_defxq5" DOUBLE,
"sn_birthsq5" DOUBLE,
"sn_defxq1" DOUBLE,
"sn_birthsq1" DOUBLE,
"rateq5" DOUBLE,
"rateq1" DOUBLE,
"rr" DOUBLE
);
CREATE TABLE no_s_cannabis_related_defects_qs4_5_2 (
"defect" VARCHAR,
"sn_defxcorrq5" DOUBLE,
"sn_birthsq5" DOUBLE,
"sn_defxcorrq4" DOUBLE,
"sn_birthsq4" DOUBLE
);
CREATE TABLE ogudaeesc (
"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,
"ltruertsc" DOUBLE,
"pt" DOUBLE,
"cigmonsc" DOUBLE,
"bngalcsc" DOUBLE,
"mrjmonsc" DOUBLE,
"anlyrsc" DOUBLE,
"cocyrsc" DOUBLE,
"d9thcrtsc" DOUBLE,
"cbcrtsc" DOUBLE,
"cbgrtsc" DOUBLE
);
CREATE TABLE ogudaeescia (
"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,
"ltruertsc" DOUBLE,
"pt" 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 ompha (
"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 omphaia (
"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
);
CREATE TABLE omphaiaaees (
"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 pdazaeesc (
"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,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"cigmonsc" DOUBLE,
"bngalcsc" DOUBLE,
"mrjmonsc" DOUBLE,
"anlyrsc" DOUBLE,
"cocyrsc" DOUBLE,
"d9thcrtsc" DOUBLE,
"cbcrtsc" DOUBLE,
"cbgrtsc" DOUBLE
);
CREATE TABLE pdazaeescia (
"state" VARCHAR,
"year" BIGINT,
"rate" DOUBLE,
"status" VARCHAR,
"alcmon" DOUBLE,
"anlyr" DOUBLE,
"bngalc" DOUBLE,
"cigmon" DOUBLE,
"cocyr" DOUBLE,
"mrjmon" DOUBLE,
"d9thcrt" DOUBLE,
"cbdrt" DOUBLE,
"cbnrt" DOUBLE,
"cbcrt" DOUBLE,
"cbgrt" DOUBLE,
"truert" DOUBLE,
"truertsc" DOUBLE,
"ltruertsc" DOUBLE,
"tstart" BIGINT,
"tend" BIGINT,
"id" BIGINT,
"sw" DOUBLE,
"trw" DOUBLE
);
CREATE TABLE potconc4 (
"year" BIGINT,
"d9thc" DOUBLE,
"cbd" DOUBLE,
"cbc" DOUBLE,
"cbn" DOUBLE,
"cbg" DOUBLE
);
CREATE TABLE pre45dat (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR,
"canrel2" VARCHAR,
"yi" DOUBLE,
"vi" DOUBLE,
"sei" DOUBLE,
"lci" DOUBLE,
"uci" DOUBLE,
"ab" VARCHAR
);
CREATE TABLE pre45dateg (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR,
"canrel2" VARCHAR,
"yi" DOUBLE,
"vi" DOUBLE,
"sei" DOUBLE,
"lci" DOUBLE,
"uci" DOUBLE,
"ab" VARCHAR,
"ev_upper" DOUBLE,
"ev_lower" DOUBLE,
"ev_bound" DOUBLE
);
CREATE TABLE pre45datej (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR,
"canrel2" VARCHAR,
"yi" DOUBLE,
"vi" DOUBLE,
"sei" DOUBLE,
"lci" DOUBLE,
"uci" DOUBLE,
"ab" VARCHAR,
"ev_upper" DOUBLE,
"ev_lower" DOUBLE,
"ev_bound" DOUBLE,
"or" DOUBLE,
"or_lci" DOUBLE,
"or_uci" DOUBLE,
"rr" DOUBLE,
"rr_lci" DOUBLE,
"rr_uci" DOUBLE
);
CREATE TABLE pre45datek (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR,
"canrel2" VARCHAR,
"yi" DOUBLE,
"vi" DOUBLE,
"sei" DOUBLE,
"lci" DOUBLE,
"uci" DOUBLE,
"ab" VARCHAR,
"ev_upper" DOUBLE,
"ev_lower" DOUBLE,
"ev_bound" DOUBLE,
"or" DOUBLE,
"or_lci" DOUBLE,
"or_uci" DOUBLE
);
CREATE TABLE pre45datevalues (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR,
"canrel2" VARCHAR,
"yi" DOUBLE,
"vi" DOUBLE,
"sei" DOUBLE,
"lci" DOUBLE,
"uci" DOUBLE,
"ab" VARCHAR,
"ev_upper" DOUBLE,
"ev_lower" DOUBLE,
"ev_bound" DOUBLE,
"or" DOUBLE,
"or_lci" DOUBLE,
"or_uci" DOUBLE,
"rr" DOUBLE,
"rr_lci" DOUBLE,
"rr_uci" DOUBLE
);
CREATE TABLE pres45 (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE,
"pr_ci" VARCHAR,
"afe_ci" VARCHAR,
"afp_ci" VARCHAR
);
CREATE TABLE q15_3 (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE
);
CREATE TABLE q45_3 (
"defect" VARCHAR,
"pr" DOUBLE,
"prlci" DOUBLE,
"pruci" DOUBLE,
"afe" DOUBLE,
"afelci" DOUBLE,
"afeuci" DOUBLE,
"afp" DOUBLE,
"afplci" DOUBLE,
"afpuci" DOUBLE
);
CREATE TABLE racstt (
"state" VARCHAR,
"year" BIGINT,
"race" VARCHAR,
"race_fr" DOUBLE
);
CREATE TABLE sexp7 (
"cannabis" BIGINT,
"thc" BIGINT,
"cbg" BIGINT,
"cbc" BIGINT,
"cbn" BIGINT,
"thcv" BIGINT,
"cbd" BIGINT
);
CREATE TABLE siasabeesc (
"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 siasabeescia (
"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 siasabeesciasocdem (
"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,
"mhy" BIGINT,
"white" DOUBLE,
"black" DOUBLE,
"asian" DOUBLE,
"aian" DOUBLE,
"hispanic" DOUBLE,
"nhpi" DOUBLE,
"nhwhitet" DOUBLE,
"nhblackt" DOUBLE,
"hispanict" DOUBLE,
"asiant" DOUBLE,
"aiant" DOUBLE,
"nhpit" DOUBLE,
"statusnew" VARCHAR,
"dichstatnew" VARCHAR,
"dichstatnew3" VARCHAR,
"quincim" VARCHAR,
"quincnm" VARCHAR,
"quincnm2" VARCHAR,
"quincnmint" BIGINT,
"quincnmqint" VARCHAR,
"pop" BIGINT,
"medage" DOUBLE,
"nhwhitetppthc" DOUBLE,
"nhblacktppthc" DOUBLE,
"asiantppthc" DOUBLE,
"hispanictppthc" DOUBLE,
"aiantppthc" DOUBLE,
"nhpitppthc" DOUBLE,
"nhwhitetppcbd" DOUBLE,
"nhblacktppcbd" DOUBLE,
"asiantppcbd" DOUBLE,
"hispanictppcbd" DOUBLE,
"aiantppcbd" DOUBLE,
"nhpitppcbd" DOUBLE,
"births" BIGINT
);
CREATE TABLE smmcc (
"no" BIGINT,
"group" VARCHAR,
"defect" VARCHAR,
"cannabis" DOUBLE,
"cannabinoids" DOUBLE,
"mixedeff" DOUBLE,
"robust" DOUBLE,
"panel" DOUBLE,
"st" DOUBLE,
"stst" DOUBLE,
"spml" DOUBLE,
"alone" DOUBLE,
"add" DOUBLE,
"ir" DOUBLE,
"lags2" DOUBLE,
"lags4" DOUBLE,
"description" VARCHAR,
"smmcc" DOUBLE
);
CREATE TABLE smmccpcdefmd (
"defect" VARCHAR,
"median_smmcc" DOUBLE,
"median_mixed_effects_smmcc" DOUBLE,
"median_robust_smmcc" DOUBLE,
"median_geospatial_smmcc" DOUBLE,
"median_smmcc_2_lags" DOUBLE,
"median_smmcc_4_lags" DOUBLE,
"median_smmcc_additive_model" DOUBLE,
"median_smmcc_interactive" DOUBLE,
"median_geospatial_interactive_smmcc" DOUBLE,
"median_smmcc_alone" DOUBLE
);
CREATE TABLE smmccpcdefmn (
"defect" VARCHAR,
"mean_smmcc" DOUBLE,
"mean_mixed_effects_smmcc" DOUBLE,
"mean_robust_smmcc" DOUBLE,
"mean_geospatial_smmcc" DOUBLE,
"mean_smmcc_2_lags" DOUBLE,
"mean_smmcc_4_lags" DOUBLE,
"mean_smmcc_additive_model" DOUBLE,
"mean_smmcc_interactive" DOUBLE,
"mean_geospatial_interactive_smmcc" DOUBLE,
"mean_smmcc_alone" DOUBLE
);
CREATE TABLE summarytable (
"data_type" VARCHAR,
"quintile_type" VARCHAR,
"cas_in_quintile_5" BIGINT,
"births_in_quintile_5" BIGINT,
"cas_in_lower_quintiles" BIGINT,
"births_in_lower_quintiles" DOUBLE,
"rr_ci" VARCHAR,
"afe_ci" VARCHAR,
"par_ci" VARCHAR,
"chisqu" DOUBLE,
"pvalue" VARCHAR,
"evaluerrpt" DOUBLE,
"evaluerrlo" DOUBLE
);
CREATE TABLE t13baeesciadf (
"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 t18baeesc (
"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 t18baeescia (
"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 tabldefmean (
"defect" VARCHAR,
"mnsmmcc" DOUBLE,
"mnsmmcclm" DOUBLE,
"mnsmmccsg" DOUBLE,
"mnsmmccst" DOUBLE,
"mnsmmcc2lag" DOUBLE,
"mnsmmcc4lag" DOUBLE,
"mnsmmccadd" DOUBLE,
"mnsmmccir" DOUBLE,
"mnsmmccstir" DOUBLE,
"mnsmmccst2lag" DOUBLE,
"mnsmmcconly" DOUBLE
);
CREATE TABLE tabldefmedian (
"defect" VARCHAR,
"mdsmmcc" DOUBLE,
"mdsmmcclm" DOUBLE,
"mdsmmccsg" DOUBLE,
"mdsmmccst" DOUBLE,
"mdsmmcc2lag" DOUBLE,
"mdsmmcc4lag" DOUBLE,
"mdsmmccadd" DOUBLE,
"mdsmmccir" DOUBLE,
"mdsmmccstir" DOUBLE,
"mdsmmccst2lag" DOUBLE,
"mdsmmcconly" DOUBLE
);
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.