Lyme Disease Dataset

Lyme- An Autoimmune Disease-Dataset

@kaggle.tahmidmir_lyme_disease_dataset

Table List

1 table(42.73 KB)

Lymedisease 9211 County

@kaggle.tahmidmir_lyme_disease_dataset.lymedisease_9211_county

42.73 KB
3194 rows
8 columns

statecode StateCode	countycode CountyCode	statename StateName	countyname CountyName	confirmedcount_1992_1996 ConfirmedCount 1992–1996	confirmedcount_1997_2001 ConfirmedCount 1997–2001	confirmedcount_2002_2006 ConfirmedCount 2002–2006	confirmedcount_2007_2011 ConfirmedCount 2007–2011
1		Alabama	Alabama				1
1	1	Alabama	Autauga County		2
1	3	Alabama	Baldwin County	4	4	1	1
1	5	Alabama	Barbour County
1	7	Alabama	Bibb County	1
1	9	Alabama	Blount County
1	11	Alabama	Bullock County
1	13	Alabama	Butler County
1	15	Alabama	Calhoun County	1	3		2
1	17	Alabama	Chambers County				2


CREATE TABLE lymedisease_9211_county (
  "statecode" BIGINT,
  "countycode" BIGINT,
  "statename" VARCHAR,
  "countyname" VARCHAR,
  "confirmedcount_1992_1996" DOUBLE,
  "confirmedcount_1997_2001" DOUBLE,
  "confirmedcount_2002_2006" DOUBLE,
  "confirmedcount_2007_2011" DOUBLE
);