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

Gsspaneldatascaledweighted

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.gsspaneldatascaledweighted
  • 71.92 KB
  • 258 rows
  • 35 columns
Loading... 

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

Heartd

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.heartd
  • 10.06 KB
  • 96 rows
  • 17 columns
Loading... 

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

Horizdb

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.horizdb
  • 15.37 KB
  • 43 rows
  • 16 columns
Loading... 

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

Horizdb2

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.horizdb2
  • 8.36 KB
  • 43 rows
  • 8 columns
Loading... 

CREATE TABLE horizdb2 (
  "defect" VARCHAR,
  "cannabis" DOUBLE,
  "thc" DOUBLE,
  "cbg" DOUBLE,
  "cbc" DOUBLE,
  "cbn" DOUBLE,
  "cbd" DOUBLE,
  "thcv" DOUBLE
);

Horizdb3

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.horizdb3
  • 5.6 KB
  • 43 rows
  • 7 columns
Loading... 

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

Horizdbcannbd

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.horizdbcannbd
  • 15.37 KB
  • 43 rows
  • 16 columns
Loading... 

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

Horizdb Z

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.horizdb_z
  • 15.42 KB
  • 46 rows
  • 16 columns
Loading... 

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

Hpedia

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.hpedia
  • 71.04 KB
  • 146 rows
  • 63 columns
Loading... 

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

Hpediabees

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.hpediabees
  • 40.57 KB
  • 140 rows
  • 27 columns
Loading... 

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

Legsaees

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.legsaees
  • 28.51 KB
  • 105 rows
  • 21 columns
Loading... 

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

Legsaeesc

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.legsaeesc
  • 40.39 KB
  • 105 rows
  • 29 columns
Loading... 

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

Legsaeesia

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.legsaeesia
  • 33.64 KB
  • 105 rows
  • 26 columns
Loading... 

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

Limbd

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.limbd
  • 9.87 KB
  • 24 rows
  • 17 columns
Loading... 

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

Lisaa

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.lisaa
  • 85.67 KB
  • 265 rows
  • 59 columns
Loading... 

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

Lisaaia

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.lisaaia
  • 94.52 KB
  • 265 rows
  • 64 columns
Loading... 

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

Lisada05sscare

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.lisada05sscare
  • 39.55 KB
  • 217 rows
  • 18 columns
Loading... 

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

Lisada05sscares

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.lisada05sscares
  • 39.56 KB
  • 232 rows
  • 18 columns
Loading... 

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

Llraees

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.llraees
  • 38.31 KB
  • 175 rows
  • 21 columns
Loading... 

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

Llraeesia

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.llraeesia
  • 44.8 KB
  • 175 rows
  • 26 columns
Loading... 

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

Marginals

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.marginals
  • 9.74 KB
  • 8 rows
  • 13 columns
Loading... 

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

Marginals Quin5 V Others Numbers

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.marginals_quin5_v_others_numbers
  • 9.74 KB
  • 8 rows
  • 13 columns
Loading... 

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

Meangrouptab

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.meangrouptab
  • 3.69 KB
  • 8 rows
  • 4 columns
Loading... 

CREATE TABLE meangrouptab (
  "group" VARCHAR,
  "mnsmmccsg" DOUBLE,
  "mnsmmcclm" DOUBLE,
  "mnsmmccst" DOUBLE
);

Mediangrouptab

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.mediangrouptab
  • 3.68 KB
  • 8 rows
  • 4 columns
Loading... 

CREATE TABLE mediangrouptab (
  "group" VARCHAR,
  "mdsmmccsg" DOUBLE,
  "mdsmmcclm" DOUBLE,
  "mdsmmccst" DOUBLE
);

Mickab

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.mickab
  • 55.27 KB
  • 91 rows
  • 59 columns
Loading... 

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

Mickab2es

@kaggle.saurabhshahane_geospatiotemporal_and_causal_inferentia_96b794c8.mickab2es
  • 27.94 KB
  • 96 rows
  • 24 columns
Loading... 

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

Share link

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