⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

33,151 rows where state = "Tennessee" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Tennessee · 33,151
Link rowid date ▲ county state fips cases deaths
1094979 2021-03-06 Anderson Tennessee 47001 8103 158
1094980 2021-03-06 Bedford Tennessee 47003 5841 120
1094981 2021-03-06 Benton Tennessee 47005 1513 39
1094982 2021-03-06 Bledsoe Tennessee 47007 2013 10
1094983 2021-03-06 Blount Tennessee 47009 14189 184
1094984 2021-03-06 Bradley Tennessee 47011 13067 141
1094985 2021-03-06 Campbell Tennessee 47013 3834 59
1094986 2021-03-06 Cannon Tennessee 47015 1786 30
1094987 2021-03-06 Carroll Tennessee 47017 3493 81
1094988 2021-03-06 Carter Tennessee 47019 5998 155
1094989 2021-03-06 Cheatham Tennessee 47021 3979 44
1094990 2021-03-06 Chester Tennessee 47023 2024 48
1094991 2021-03-06 Claiborne Tennessee 47025 2847 69
1094992 2021-03-06 Clay Tennessee 47027 1071 31
1094993 2021-03-06 Cocke Tennessee 47029 4039 96
1094994 2021-03-06 Coffee Tennessee 47031 6432 115
1094995 2021-03-06 Crockett Tennessee 47033 1974 47
1094996 2021-03-06 Cumberland Tennessee 47035 6137 123
1094997 2021-03-06 Davidson Tennessee 47037 90336 874
1094998 2021-03-06 DeKalb Tennessee 47041 2672 51
1094999 2021-03-06 Decatur Tennessee 47039 1542 37
1095000 2021-03-06 Dickson Tennessee 47043 6295 106
1095001 2021-03-06 Dyer Tennessee 47045 5248 101
1095002 2021-03-06 Fayette Tennessee 47047 4687 73
1095003 2021-03-06 Fentress Tennessee 47049 2300 44
1095004 2021-03-06 Franklin Tennessee 47051 4765 85
1095005 2021-03-06 Gibson Tennessee 47053 6200 141
1095006 2021-03-06 Giles Tennessee 47055 3758 97
1095007 2021-03-06 Grainger Tennessee 47057 2448 46
1095008 2021-03-06 Greene Tennessee 47059 7315 145
1095009 2021-03-06 Grundy Tennessee 47061 1702 30
1095010 2021-03-06 Hamblen Tennessee 47063 8088 166
1095011 2021-03-06 Hamilton Tennessee 47065 40974 466
1095012 2021-03-06 Hancock Tennessee 47067 500 12
1095013 2021-03-06 Hardeman Tennessee 47069 3394 65
1095014 2021-03-06 Hardin Tennessee 47071 3320 63
1095015 2021-03-06 Hawkins Tennessee 47073 5295 98
1095016 2021-03-06 Haywood Tennessee 47075 2651 60
1095017 2021-03-06 Henderson Tennessee 47077 3625 74
1095018 2021-03-06 Henry Tennessee 47079 3016 75
1095019 2021-03-06 Hickman Tennessee 47081 2679 41
1095020 2021-03-06 Houston Tennessee 47083 1038 32
1095021 2021-03-06 Humphreys Tennessee 47085 1556 21
1095022 2021-03-06 Jackson Tennessee 47087 1257 34
1095023 2021-03-06 Jefferson Tennessee 47089 5717 119
1095024 2021-03-06 Johnson Tennessee 47091 2175 38
1095025 2021-03-06 Knox Tennessee 47093 47452 589
1095026 2021-03-06 Lake Tennessee 47095 1679 26
1095027 2021-03-06 Lauderdale Tennessee 47097 3100 42
1095028 2021-03-06 Lawrence Tennessee 47099 5580 83
1095029 2021-03-06 Lewis Tennessee 47101 1476 25
1095030 2021-03-06 Lincoln Tennessee 47103 4164 62
1095031 2021-03-06 Loudon Tennessee 47105 5736 66
1095032 2021-03-06 Macon Tennessee 47111 3377 73
1095033 2021-03-06 Madison Tennessee 47113 10136 232
1095034 2021-03-06 Marion Tennessee 47115 2959 45
1095035 2021-03-06 Marshall Tennessee 47117 3928 57
1095036 2021-03-06 Maury Tennessee 47119 12273 162
1095037 2021-03-06 McMinn Tennessee 47107 5971 93
1095038 2021-03-06 McNairy Tennessee 47109 2687 53
1095039 2021-03-06 Meigs Tennessee 47121 1268 23
1095040 2021-03-06 Monroe Tennessee 47123 5395 91
1095041 2021-03-06 Montgomery Tennessee 47125 17539 213
1095042 2021-03-06 Moore Tennessee 47127 947 16
1095043 2021-03-06 Morgan Tennessee 47129 2311 38
1095044 2021-03-06 Obion Tennessee 47131 4371 95
1095045 2021-03-06 Overton Tennessee 47133 2865 58
1095046 2021-03-06 Perry Tennessee 47135 1035 28
1095047 2021-03-06 Pickett Tennessee 47137 747 23
1095048 2021-03-06 Polk Tennessee 47139 1791 22
1095049 2021-03-06 Putnam Tennessee 47141 10660 170
1095050 2021-03-06 Rhea Tennessee 47143 4155 73
1095051 2021-03-06 Roane Tennessee 47145 5946 96
1095052 2021-03-06 Robertson Tennessee 47147 9027 121
1095053 2021-03-06 Rutherford Tennessee 47149 38749 388
1095054 2021-03-06 Scott Tennessee 47151 2886 44
1095055 2021-03-06 Sequatchie Tennessee 47153 1575 27
1095056 2021-03-06 Sevier Tennessee 47155 12158 165
1095057 2021-03-06 Shelby Tennessee 47157 88768 1527
1095058 2021-03-06 Smith Tennessee 47159 2579 36
1095059 2021-03-06 Stewart Tennessee 47161 1244 25
1095060 2021-03-06 Sullivan Tennessee 47163 14499 275
1095061 2021-03-06 Sumner Tennessee 47165 21542 320
1095062 2021-03-06 Tipton Tennessee 47167 6974 103
1095063 2021-03-06 Trousdale Tennessee 47169 2400 22
1095064 2021-03-06 Unicoi Tennessee 47171 1821 47
1095065 2021-03-06 Union Tennessee 47173 1741 34
1095066 2021-03-06 Unknown Tennessee   8573 113
1095067 2021-03-06 Van Buren Tennessee 47175 797 20
1095068 2021-03-06 Warren Tennessee 47177 5333 77
1095069 2021-03-06 Washington Tennessee 47179 12840 234
1095070 2021-03-06 Wayne Tennessee 47181 2888 30
1095071 2021-03-06 Weakley Tennessee 47183 3799 60
1095072 2021-03-06 White Tennessee 47185 3398 66
1095073 2021-03-06 Williamson Tennessee 47187 25489 204
1095074 2021-03-06 Wilson Tennessee 47189 16618 211
1091733 2021-03-05 Anderson Tennessee 47001 8075 158
1091734 2021-03-05 Bedford Tennessee 47003 5826 120
1091735 2021-03-05 Benton Tennessee 47005 1511 39
1091736 2021-03-05 Bledsoe Tennessee 47007 2012 10

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);