Foodborne Disease Outbreaks, 1998-2015

What contaminant has caused the most hospitalizations and fatalities?

@kaggle.cdc_foodborne_diseases

Table List

1 table(181.31 KB)

Outbreaks

@kaggle.cdc_foodborne_diseases.outbreaks

181.31 KB
19119 rows
12 columns

year Year	month Month	state State	location Location	food Food	ingredient Ingredient	species Species	serotype_genotype Serotype/Genotype	status Status	illnesses Illnesses	hospitalizations Hospitalizations
1998	January	California	Restaurant	nan	nan	nan	nan	nan	20
1998	January	California	nan	Custard	nan	nan	nan	nan	112
1998	January	California	Restaurant	nan	nan	nan	nan	nan	35
1998	January	California	Restaurant	Fish, Ahi	nan	Scombroid toxin	nan	Confirmed	4
1998	January	California	Private Home/Residence	Lasagna, Unspecified; Eggs, Other	nan	Salmonella enterica	Enteritidis	Confirmed	26	3
1998	January	California	Restaurant	nan	nan	Shigella boydii	nan	Confirmed	25	3
1998	January	California	Restaurant	nan	nan	nan	nan	nan	8
1998	January	California	Restaurant	Stuffing, Unspecified; Sandwich, Turkey	nan	Salmonella enterica	Enteritidis	Confirmed	4	3
1998	January	Colorado	Restaurant	Salad, Unspecified	nan	Virus	nan	Suspected	21
1998	January	Colorado	Restaurant	Peppers, Chili	nan	Virus	nan	Suspected	3


CREATE TABLE outbreaks (
  "year" BIGINT,
  "month" VARCHAR,
  "state" VARCHAR,
  "location" VARCHAR,
  "food" VARCHAR,
  "ingredient" VARCHAR,
  "species" VARCHAR,
  "serotype_genotype" VARCHAR,
  "status" VARCHAR,
  "illnesses" BIGINT,
  "hospitalizations" DOUBLE,
  "fatalities" DOUBLE
);