Baselight
Sign In

Geospatiotemporal And Causal Inferential Analysis

Geospatiotemporal and Causal Inferential Analysis of US Congenital Anomalies

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8

Loading...
Loading...

About this Dataset

Geospatiotemporal And Causal Inferential Analysis

Context

Dataset for the paper - Geospatiotemporal and Causal Inferential Analysis of United States Congenital Anomalies as a Function of Multiple Cannabinoid- and Substance- Exposures: Phenocopying Thalidomide and Hundred Megabase-Scale Genotoxicity

Acknowledgements

Reece, Albert (2021), “csv Files to Accompany : Geospatiotemporal and Causal Inferential Analysis of United States Congenital Anomalies as a Function of Multiple Cannabinoid- and Substance- Exposures: Phenocopying Thalidomide and Hundred Megabase-Scale Genotoxicity", V1, doi: 10.17632/jz6777vv72.1

Tables

Pdazaeesc

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.pdazaeesc
  • 31.23 KB
  • 64 rows
  • 28 columns
Loading... 

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
);

Pdazaeescia

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.pdazaeescia
  • 22.05 KB
  • 48 rows
  • 23 columns
Loading... 

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
);

Potconc4

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.potconc4
  • 5.23 KB
  • 24 rows
  • 6 columns
Loading... 

CREATE TABLE potconc4 (
  "year" BIGINT,
  "d9thc" DOUBLE,
  "cbd" DOUBLE,
  "cbc" DOUBLE,
  "cbn" DOUBLE,
  "cbg" DOUBLE
);

Pre45dat

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.pre45dat
  • 21.95 KB
  • 61 rows
  • 20 columns
Loading... 

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
);

Pre45dateg

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.pre45dateg
  • 24.67 KB
  • 61 rows
  • 23 columns
Loading... 

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
);

Pre45datej

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.pre45datej
  • 30.28 KB
  • 61 rows
  • 29 columns
Loading... 

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
);

Pre45datek

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.pre45datek
  • 27.47 KB
  • 61 rows
  • 26 columns
Loading... 

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
);

Pre45datevalues

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.pre45datevalues
  • 30.28 KB
  • 61 rows
  • 29 columns
Loading... 

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
);

Pres45

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.pres45
  • 15.23 KB
  • 61 rows
  • 13 columns
Loading... 

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
);

Q15–3

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.q15_3
  • 9.67 KB
  • 33 rows
  • 10 columns
Loading... 

CREATE TABLE q15_3 (
  "defect" VARCHAR,
  "pr" DOUBLE,
  "prlci" DOUBLE,
  "pruci" DOUBLE,
  "afe" DOUBLE,
  "afelci" DOUBLE,
  "afeuci" DOUBLE,
  "afp" DOUBLE,
  "afplci" DOUBLE,
  "afpuci" DOUBLE
);

Q45–3

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.q45_3
  • 9.67 KB
  • 33 rows
  • 10 columns
Loading... 

CREATE TABLE q45_3 (
  "defect" VARCHAR,
  "pr" DOUBLE,
  "prlci" DOUBLE,
  "pruci" DOUBLE,
  "afe" DOUBLE,
  "afelci" DOUBLE,
  "afeuci" DOUBLE,
  "afp" DOUBLE,
  "afplci" DOUBLE,
  "afpuci" DOUBLE
);

Racstt

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.racstt
  • 85.66 KB
  • 8517 rows
  • 4 columns
Loading... 

CREATE TABLE racstt (
  "state" VARCHAR,
  "year" BIGINT,
  "race" VARCHAR,
  "race_fr" DOUBLE
);

Sexp7

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.sexp7
  • 5.06 KB
  • 1 row
  • 7 columns
Loading... 

CREATE TABLE sexp7 (
  "cannabis" BIGINT,
  "thc" BIGINT,
  "cbg" BIGINT,
  "cbc" BIGINT,
  "cbn" BIGINT,
  "thcv" BIGINT,
  "cbd" BIGINT
);

Siasabeesc

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.siasabeesc
  • 50.06 KB
  • 140 rows
  • 32 columns
Loading... 

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
);

Siasabeescia

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.siasabeescia
  • 55.88 KB
  • 140 rows
  • 37 columns
Loading... 

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
);

Siasabeesciasocdem

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.siasabeesciasocdem
  • 102.93 KB
  • 140 rows
  • 73 columns
Loading... 

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
);

Smmcc

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.smmcc
  • 19.03 KB
  • 468 rows
  • 18 columns
Loading... 

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
);

Smmccpcdefmd

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.smmccpcdefmd
  • 11.46 KB
  • 34 rows
  • 11 columns
Loading... 

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
);

Smmccpcdefmn

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.smmccpcdefmn
  • 11.51 KB
  • 34 rows
  • 11 columns
Loading... 

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
);

Summarytable

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.summarytable
  • 10.05 KB
  • 4 rows
  • 13 columns
Loading... 

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
);

T13baeesciadf

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.t13baeesciadf
  • 73.19 KB
  • 208 rows
  • 37 columns
Loading... 

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
);

T18baeesc

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.t18baeesc
  • 67.26 KB
  • 216 rows
  • 31 columns
Loading... 

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
);

T18baeescia

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.t18baeescia
  • 74.24 KB
  • 216 rows
  • 36 columns
Loading... 

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
);

Tabldefmean

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.tabldefmean
  • 11.47 KB
  • 30 rows
  • 12 columns
Loading... 

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
);

Tabldefmedian

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.tabldefmedian
  • 11.26 KB
  • 30 rows
  • 12 columns
Loading... 

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
);

Share link

Anyone who has the link will be able to view this.