Infectious Disease 2001-2014

Exploring the Incidence and Outcomes of Infectious Diseases from 2001-2014

@kaggle.jahaidulislam_infectious_disease_2001_2014

Table List

1 table(858.3 KB)

Infectious Disease 2001–2014

Infectious Disease 2001–2014

@kaggle.jahaidulislam_infectious_disease_2001_2014.infectious_disease_2001_2014

858.3 KB
141777 rows
10 columns

disease Disease	county County	year Year	sex Sex	count Count	population Population	rate Rate	ci_lower CI.lower	ci_upper CI.upper
Amebiasis	California	2001	Total	571	34514777	1.654	1.521	1.796
Amebiasis	California	2001	Female	176	17340743	1.015	0.871	1.176
Amebiasis	California	2001	Male	365	17174034	2.125	1.913	2.355
Amebiasis	California	2002	Total	442	34940334	1.265	1.15	1.389
Amebiasis	California	2002	Female	145	17555714	0.826	0.697	0.972
Amebiasis	California	2002	Male	279	17384620	1.605	1.422	1.805
Amebiasis	California	2003	Total	403	35390986	1.139	1.03	1.255
Amebiasis	California	2003	Female	127	17783924	0.714	0.595	0.85
Amebiasis	California	2003	Male	261	17607062	1.482	1.308	1.674
Amebiasis	California	2004	Total	359	35754827	1.004	0.903	1.113


CREATE TABLE infectious_disease_2001_2014 (
  "disease" VARCHAR,
  "county" VARCHAR,
  "year" BIGINT,
  "sex" VARCHAR,
  "count" BIGINT,
  "population" BIGINT,
  "rate" DOUBLE,
  "ci_lower" DOUBLE,
  "ci_upper" DOUBLE,
  "unstable" VARCHAR
);