ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74,719 rows where state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 47187 116
- 47037 113
- 47157 113
- 47163 111
- 47093 109
- 47065 108
- 47089 108
- 47149 108
- 47013 107
- 47155 105
- 47021 103
- 47147 103
- 47165 103
- 47035 102
- 47045 102
- 47125 102
- 47179 102
- 47189 102
- 47001 101
- 47009 101
- 47011 101
- 47043 101
- 47059 101
- 47063 101
- 47119 101
- 47167 101
- 47017 100
- 47029 100
- 47047 100
- 47123 100
- …
county >30
- Williamson 116
- Davidson 113
- Shelby 113
- Sullivan 111
- Knox 109
- Hamilton 108
- Jefferson 108
- Rutherford 108
- Campbell 107
- Sevier 105
- Cheatham 103
- Robertson 103
- Sumner 103
- Cumberland 102
- Dyer 102
- Montgomery 102
- Washington 102
- Wilson 102
- Anderson 101
- Blount 101
- Bradley 101
- Dickson 101
- Greene 101
- Hamblen 101
- Maury 101
- Tipton 101
- Carroll 100
- Cocke 100
- Fayette 100
- Monroe 100
- …
state 1
- Tennessee · 9,085 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
283229 | 283229 | 2020-06-28 | Anderson | Tennessee | 47001 | 90 | 2 |
283230 | 283230 | 2020-06-28 | Bedford | Tennessee | 47003 | 482 | 5 |
283231 | 283231 | 2020-06-28 | Benton | Tennessee | 47005 | 12 | 1 |
283232 | 283232 | 2020-06-28 | Bledsoe | Tennessee | 47007 | 616 | 1 |
283233 | 283233 | 2020-06-28 | Blount | Tennessee | 47009 | 156 | 3 |
283234 | 283234 | 2020-06-28 | Bradley | Tennessee | 47011 | 444 | 3 |
283235 | 283235 | 2020-06-28 | Campbell | Tennessee | 47013 | 31 | 1 |
283236 | 283236 | 2020-06-28 | Cannon | Tennessee | 47015 | 25 | 0 |
283237 | 283237 | 2020-06-28 | Carroll | Tennessee | 47017 | 38 | 1 |
283238 | 283238 | 2020-06-28 | Carter | Tennessee | 47019 | 49 | 1 |
283239 | 283239 | 2020-06-28 | Cheatham | Tennessee | 47021 | 194 | 0 |
283240 | 283240 | 2020-06-28 | Chester | Tennessee | 47023 | 19 | 0 |
283241 | 283241 | 2020-06-28 | Claiborne | Tennessee | 47025 | 21 | 0 |
283242 | 283242 | 2020-06-28 | Clay | Tennessee | 47027 | 13 | 0 |
283243 | 283243 | 2020-06-28 | Cocke | Tennessee | 47029 | 48 | 0 |
283244 | 283244 | 2020-06-28 | Coffee | Tennessee | 47031 | 103 | 0 |
283245 | 283245 | 2020-06-28 | Crockett | Tennessee | 47033 | 28 | 3 |
283246 | 283246 | 2020-06-28 | Cumberland | Tennessee | 47035 | 159 | 3 |
283247 | 283247 | 2020-06-28 | Davidson | Tennessee | 47037 | 9348 | 110 |
283248 | 283248 | 2020-06-28 | DeKalb | Tennessee | 47041 | 47 | 0 |
283249 | 283249 | 2020-06-28 | Decatur | Tennessee | 47039 | 18 | 0 |
283250 | 283250 | 2020-06-28 | Dickson | Tennessee | 47043 | 159 | 0 |
283251 | 283251 | 2020-06-28 | Dyer | Tennessee | 47045 | 192 | 0 |
283252 | 283252 | 2020-06-28 | Fayette | Tennessee | 47047 | 244 | 2 |
283253 | 283253 | 2020-06-28 | Fentress | Tennessee | 47049 | 16 | 0 |
283254 | 283254 | 2020-06-28 | Franklin | Tennessee | 47051 | 73 | 3 |
283255 | 283255 | 2020-06-28 | Gibson | Tennessee | 47053 | 90 | 1 |
283256 | 283256 | 2020-06-28 | Giles | Tennessee | 47055 | 45 | 0 |
283257 | 283257 | 2020-06-28 | Grainger | Tennessee | 47057 | 28 | 0 |
283258 | 283258 | 2020-06-28 | Greene | Tennessee | 47059 | 74 | 2 |
283259 | 283259 | 2020-06-28 | Grundy | Tennessee | 47061 | 59 | 1 |
283260 | 283260 | 2020-06-28 | Hamblen | Tennessee | 47063 | 181 | 4 |
283261 | 283261 | 2020-06-28 | Hamilton | Tennessee | 47065 | 2423 | 29 |
283262 | 283262 | 2020-06-28 | Hancock | Tennessee | 47067 | 3 | 0 |
283263 | 283263 | 2020-06-28 | Hardeman | Tennessee | 47069 | 276 | 1 |
283264 | 283264 | 2020-06-28 | Hardin | Tennessee | 47071 | 89 | 5 |
283265 | 283265 | 2020-06-28 | Hawkins | Tennessee | 47073 | 45 | 2 |
283266 | 283266 | 2020-06-28 | Haywood | Tennessee | 47075 | 62 | 2 |
283267 | 283267 | 2020-06-28 | Henderson | Tennessee | 47077 | 31 | 0 |
283268 | 283268 | 2020-06-28 | Henry | Tennessee | 47079 | 40 | 0 |
283269 | 283269 | 2020-06-28 | Hickman | Tennessee | 47081 | 69 | 0 |
283270 | 283270 | 2020-06-28 | Houston | Tennessee | 47083 | 10 | 0 |
283271 | 283271 | 2020-06-28 | Humphreys | Tennessee | 47085 | 20 | 1 |
283272 | 283272 | 2020-06-28 | Jackson | Tennessee | 47087 | 22 | 0 |
283273 | 283273 | 2020-06-28 | Jefferson | Tennessee | 47089 | 91 | 0 |
283274 | 283274 | 2020-06-28 | Johnson | Tennessee | 47091 | 34 | 0 |
283275 | 283275 | 2020-06-28 | Knox | Tennessee | 47093 | 888 | 5 |
283276 | 283276 | 2020-06-28 | Lake | Tennessee | 47095 | 691 | 0 |
283277 | 283277 | 2020-06-28 | Lauderdale | Tennessee | 47097 | 99 | 2 |
283278 | 283278 | 2020-06-28 | Lawrence | Tennessee | 47099 | 113 | 4 |
283279 | 283279 | 2020-06-28 | Lewis | Tennessee | 47101 | 5 | 0 |
283280 | 283280 | 2020-06-28 | Lincoln | Tennessee | 47103 | 52 | 0 |
283281 | 283281 | 2020-06-28 | Loudon | Tennessee | 47105 | 248 | 1 |
283282 | 283282 | 2020-06-28 | Macon | Tennessee | 47111 | 293 | 3 |
283283 | 283283 | 2020-06-28 | Madison | Tennessee | 47113 | 228 | 2 |
283284 | 283284 | 2020-06-28 | Marion | Tennessee | 47115 | 57 | 4 |
283285 | 283285 | 2020-06-28 | Marshall | Tennessee | 47117 | 60 | 1 |
283286 | 283286 | 2020-06-28 | Maury | Tennessee | 47119 | 276 | 3 |
283287 | 283287 | 2020-06-28 | McMinn | Tennessee | 47107 | 203 | 17 |
283288 | 283288 | 2020-06-28 | McNairy | Tennessee | 47109 | 52 | 0 |
283289 | 283289 | 2020-06-28 | Meigs | Tennessee | 47121 | 32 | 0 |
283290 | 283290 | 2020-06-28 | Monroe | Tennessee | 47123 | 118 | 4 |
283291 | 283291 | 2020-06-28 | Montgomery | Tennessee | 47125 | 438 | 7 |
283292 | 283292 | 2020-06-28 | Moore | Tennessee | 47127 | 6 | 0 |
283293 | 283293 | 2020-06-28 | Morgan | Tennessee | 47129 | 23 | 1 |
283294 | 283294 | 2020-06-28 | Obion | Tennessee | 47131 | 87 | 2 |
283295 | 283295 | 2020-06-28 | Overton | Tennessee | 47133 | 51 | 0 |
283296 | 283296 | 2020-06-28 | Perry | Tennessee | 47135 | 29 | 0 |
283297 | 283297 | 2020-06-28 | Pickett | Tennessee | 47137 | 6 | 0 |
283298 | 283298 | 2020-06-28 | Polk | Tennessee | 47139 | 38 | 0 |
283299 | 283299 | 2020-06-28 | Putnam | Tennessee | 47141 | 735 | 7 |
283300 | 283300 | 2020-06-28 | Rhea | Tennessee | 47143 | 262 | 0 |
283301 | 283301 | 2020-06-28 | Roane | Tennessee | 47145 | 43 | 0 |
283302 | 283302 | 2020-06-28 | Robertson | Tennessee | 47147 | 751 | 11 |
283303 | 283303 | 2020-06-28 | Rutherford | Tennessee | 47149 | 2362 | 34 |
283304 | 283304 | 2020-06-28 | Scott | Tennessee | 47151 | 14 | 0 |
283305 | 283305 | 2020-06-28 | Sequatchie | Tennessee | 47153 | 24 | 0 |
283306 | 283306 | 2020-06-28 | Sevier | Tennessee | 47155 | 549 | 3 |
283307 | 283307 | 2020-06-28 | Shelby | Tennessee | 47157 | 9139 | 182 |
283308 | 283308 | 2020-06-28 | Smith | Tennessee | 47159 | 67 | 1 |
283309 | 283309 | 2020-06-28 | Stewart | Tennessee | 47161 | 19 | 0 |
283310 | 283310 | 2020-06-28 | Sullivan | Tennessee | 47163 | 83 | 2 |
283311 | 283311 | 2020-06-28 | Sumner | Tennessee | 47165 | 1318 | 51 |
283312 | 283312 | 2020-06-28 | Tipton | Tennessee | 47167 | 593 | 4 |
283313 | 283313 | 2020-06-28 | Trousdale | Tennessee | 47169 | 1476 | 5 |
283314 | 283314 | 2020-06-28 | Unicoi | Tennessee | 47171 | 53 | 0 |
283315 | 283315 | 2020-06-28 | Union | Tennessee | 47173 | 11 | 0 |
283316 | 283316 | 2020-06-28 | Van Buren | Tennessee | 47175 | 6 | 0 |
283317 | 283317 | 2020-06-28 | Warren | Tennessee | 47177 | 55 | 0 |
283318 | 283318 | 2020-06-28 | Washington | Tennessee | 47179 | 121 | 0 |
283319 | 283319 | 2020-06-28 | Wayne | Tennessee | 47181 | 74 | 0 |
283320 | 283320 | 2020-06-28 | Weakley | Tennessee | 47183 | 49 | 1 |
283321 | 283321 | 2020-06-28 | White | Tennessee | 47185 | 61 | 3 |
283322 | 283322 | 2020-06-28 | Williamson | Tennessee | 47187 | 945 | 14 |
283323 | 283323 | 2020-06-28 | Wilson | Tennessee | 47189 | 725 | 16 |
280083 | 280083 | 2020-06-27 | Anderson | Tennessee | 47001 | 90 | 2 |
280084 | 280084 | 2020-06-27 | Bedford | Tennessee | 47003 | 482 | 5 |
280085 | 280085 | 2020-06-27 | Benton | Tennessee | 47005 | 12 | 1 |
280086 | 280086 | 2020-06-27 | Bledsoe | Tennessee | 47007 | 616 | 1 |
280087 | 280087 | 2020-06-27 | Blount | Tennessee | 47009 | 156 | 3 |
Advanced export
JSON shape: default, array, newline-delimited
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] desc);