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 352
- 47037 349
- 47157 349
- 47163 347
- 47093 345
- 47065 344
- 47089 344
- 47149 344
- 47013 343
- 47155 341
- 47021 339
- 47147 339
- 47165 339
- 47035 338
- 47045 338
- 47125 338
- 47179 338
- 47189 338
- 47001 337
- 47009 337
- 47011 337
- 47043 337
- 47059 337
- 47063 337
- 47119 337
- 47167 337
- 47017 336
- 47029 336
- 47047 336
- 47123 336
- …
county >30
- Williamson 352
- Davidson 349
- Shelby 349
- Sullivan 347
- Knox 345
- Hamilton 344
- Jefferson 344
- Rutherford 344
- Campbell 343
- Sevier 341
- Cheatham 339
- Robertson 339
- Sumner 339
- Cumberland 338
- Dyer 338
- Montgomery 338
- Washington 338
- Wilson 338
- Anderson 337
- Blount 337
- Bradley 337
- Dickson 337
- Greene 337
- Hamblen 337
- Maury 337
- Tipton 337
- Carroll 336
- Cocke 336
- Fayette 336
- Monroe 336
- …
state 1
- Tennessee · 31,711 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1046292 | 1046292 | 2021-02-19 | Anderson | Tennessee | 47001 | 7817 | 149 |
1046293 | 1046293 | 2021-02-19 | Bedford | Tennessee | 47003 | 5724 | 117 |
1046294 | 1046294 | 2021-02-19 | Benton | Tennessee | 47005 | 1497 | 39 |
1046295 | 1046295 | 2021-02-19 | Bledsoe | Tennessee | 47007 | 1975 | 10 |
1046296 | 1046296 | 2021-02-19 | Blount | Tennessee | 47009 | 13831 | 174 |
1046297 | 1046297 | 2021-02-19 | Bradley | Tennessee | 47011 | 12569 | 135 |
1046298 | 1046298 | 2021-02-19 | Campbell | Tennessee | 47013 | 3742 | 55 |
1046299 | 1046299 | 2021-02-19 | Cannon | Tennessee | 47015 | 1726 | 28 |
1046300 | 1046300 | 2021-02-19 | Carroll | Tennessee | 47017 | 3452 | 80 |
1046301 | 1046301 | 2021-02-19 | Carter | Tennessee | 47019 | 5886 | 150 |
1046302 | 1046302 | 2021-02-19 | Cheatham | Tennessee | 47021 | 3815 | 43 |
1046303 | 1046303 | 2021-02-19 | Chester | Tennessee | 47023 | 1998 | 45 |
1046304 | 1046304 | 2021-02-19 | Claiborne | Tennessee | 47025 | 2671 | 64 |
1046305 | 1046305 | 2021-02-19 | Clay | Tennessee | 47027 | 1055 | 29 |
1046306 | 1046306 | 2021-02-19 | Cocke | Tennessee | 47029 | 3933 | 91 |
1046307 | 1046307 | 2021-02-19 | Coffee | Tennessee | 47031 | 6213 | 112 |
1046308 | 1046308 | 2021-02-19 | Crockett | Tennessee | 47033 | 1958 | 46 |
1046309 | 1046309 | 2021-02-19 | Cumberland | Tennessee | 47035 | 6035 | 113 |
1046310 | 1046310 | 2021-02-19 | Davidson | Tennessee | 47037 | 88493 | 823 |
1046311 | 1046311 | 2021-02-19 | DeKalb | Tennessee | 47041 | 2605 | 47 |
1046312 | 1046312 | 2021-02-19 | Decatur | Tennessee | 47039 | 1531 | 35 |
1046313 | 1046313 | 2021-02-19 | Dickson | Tennessee | 47043 | 6064 | 102 |
1046314 | 1046314 | 2021-02-19 | Dyer | Tennessee | 47045 | 5213 | 99 |
1046315 | 1046315 | 2021-02-19 | Fayette | Tennessee | 47047 | 4615 | 71 |
1046316 | 1046316 | 2021-02-19 | Fentress | Tennessee | 47049 | 2276 | 43 |
1046317 | 1046317 | 2021-02-19 | Franklin | Tennessee | 47051 | 4651 | 80 |
1046318 | 1046318 | 2021-02-19 | Gibson | Tennessee | 47053 | 6144 | 138 |
1046319 | 1046319 | 2021-02-19 | Giles | Tennessee | 47055 | 3684 | 95 |
1046320 | 1046320 | 2021-02-19 | Grainger | Tennessee | 47057 | 2388 | 46 |
1046321 | 1046321 | 2021-02-19 | Greene | Tennessee | 47059 | 7220 | 142 |
1046322 | 1046322 | 2021-02-19 | Grundy | Tennessee | 47061 | 1639 | 29 |
1046323 | 1046323 | 2021-02-19 | Hamblen | Tennessee | 47063 | 7890 | 161 |
1046324 | 1046324 | 2021-02-19 | Hamilton | Tennessee | 47065 | 39878 | 442 |
1046325 | 1046325 | 2021-02-19 | Hancock | Tennessee | 47067 | 489 | 11 |
1046326 | 1046326 | 2021-02-19 | Hardeman | Tennessee | 47069 | 3369 | 61 |
1046327 | 1046327 | 2021-02-19 | Hardin | Tennessee | 47071 | 3287 | 62 |
1046328 | 1046328 | 2021-02-19 | Hawkins | Tennessee | 47073 | 5109 | 91 |
1046329 | 1046329 | 2021-02-19 | Haywood | Tennessee | 47075 | 2635 | 59 |
1046330 | 1046330 | 2021-02-19 | Henderson | Tennessee | 47077 | 3589 | 71 |
1046331 | 1046331 | 2021-02-19 | Henry | Tennessee | 47079 | 2977 | 73 |
1046332 | 1046332 | 2021-02-19 | Hickman | Tennessee | 47081 | 2611 | 38 |
1046333 | 1046333 | 2021-02-19 | Houston | Tennessee | 47083 | 1016 | 30 |
1046334 | 1046334 | 2021-02-19 | Humphreys | Tennessee | 47085 | 1498 | 21 |
1046335 | 1046335 | 2021-02-19 | Jackson | Tennessee | 47087 | 1245 | 33 |
1046336 | 1046336 | 2021-02-19 | Jefferson | Tennessee | 47089 | 5516 | 115 |
1046337 | 1046337 | 2021-02-19 | Johnson | Tennessee | 47091 | 2137 | 37 |
1046338 | 1046338 | 2021-02-19 | Knox | Tennessee | 47093 | 45856 | 558 |
1046339 | 1046339 | 2021-02-19 | Lake | Tennessee | 47095 | 1670 | 25 |
1046340 | 1046340 | 2021-02-19 | Lauderdale | Tennessee | 47097 | 3082 | 40 |
1046341 | 1046341 | 2021-02-19 | Lawrence | Tennessee | 47099 | 5528 | 79 |
1046342 | 1046342 | 2021-02-19 | Lewis | Tennessee | 47101 | 1438 | 24 |
1046343 | 1046343 | 2021-02-19 | Lincoln | Tennessee | 47103 | 4085 | 61 |
1046344 | 1046344 | 2021-02-19 | Loudon | Tennessee | 47105 | 5556 | 64 |
1046345 | 1046345 | 2021-02-19 | Macon | Tennessee | 47111 | 3324 | 73 |
1046346 | 1046346 | 2021-02-19 | Madison | Tennessee | 47113 | 9985 | 225 |
1046347 | 1046347 | 2021-02-19 | Marion | Tennessee | 47115 | 2871 | 44 |
1046348 | 1046348 | 2021-02-19 | Marshall | Tennessee | 47117 | 3867 | 54 |
1046349 | 1046349 | 2021-02-19 | Maury | Tennessee | 47119 | 12074 | 155 |
1046350 | 1046350 | 2021-02-19 | McMinn | Tennessee | 47107 | 5812 | 89 |
1046351 | 1046351 | 2021-02-19 | McNairy | Tennessee | 47109 | 2629 | 49 |
1046352 | 1046352 | 2021-02-19 | Meigs | Tennessee | 47121 | 1249 | 20 |
1046353 | 1046353 | 2021-02-19 | Monroe | Tennessee | 47123 | 5197 | 88 |
1046354 | 1046354 | 2021-02-19 | Montgomery | Tennessee | 47125 | 17063 | 203 |
1046355 | 1046355 | 2021-02-19 | Moore | Tennessee | 47127 | 929 | 15 |
1046356 | 1046356 | 2021-02-19 | Morgan | Tennessee | 47129 | 2272 | 34 |
1046357 | 1046357 | 2021-02-19 | Obion | Tennessee | 47131 | 4346 | 92 |
1046358 | 1046358 | 2021-02-19 | Overton | Tennessee | 47133 | 2819 | 57 |
1046359 | 1046359 | 2021-02-19 | Perry | Tennessee | 47135 | 1022 | 27 |
1046360 | 1046360 | 2021-02-19 | Pickett | Tennessee | 47137 | 743 | 23 |
1046361 | 1046361 | 2021-02-19 | Polk | Tennessee | 47139 | 1711 | 21 |
1046362 | 1046362 | 2021-02-19 | Putnam | Tennessee | 47141 | 10480 | 166 |
1046363 | 1046363 | 2021-02-19 | Rhea | Tennessee | 47143 | 4094 | 70 |
1046364 | 1046364 | 2021-02-19 | Roane | Tennessee | 47145 | 5743 | 95 |
1046365 | 1046365 | 2021-02-19 | Robertson | Tennessee | 47147 | 8801 | 112 |
1046366 | 1046366 | 2021-02-19 | Rutherford | Tennessee | 47149 | 37478 | 366 |
1046367 | 1046367 | 2021-02-19 | Scott | Tennessee | 47151 | 2836 | 42 |
1046368 | 1046368 | 2021-02-19 | Sequatchie | Tennessee | 47153 | 1521 | 27 |
1046369 | 1046369 | 2021-02-19 | Sevier | Tennessee | 47155 | 11784 | 158 |
1046370 | 1046370 | 2021-02-19 | Shelby | Tennessee | 47157 | 86759 | 1454 |
1046371 | 1046371 | 2021-02-19 | Smith | Tennessee | 47159 | 2512 | 36 |
1046372 | 1046372 | 2021-02-19 | Stewart | Tennessee | 47161 | 1228 | 24 |
1046373 | 1046373 | 2021-02-19 | Sullivan | Tennessee | 47163 | 14041 | 271 |
1046374 | 1046374 | 2021-02-19 | Sumner | Tennessee | 47165 | 20994 | 308 |
1046375 | 1046375 | 2021-02-19 | Tipton | Tennessee | 47167 | 6848 | 97 |
1046376 | 1046376 | 2021-02-19 | Trousdale | Tennessee | 47169 | 2374 | 21 |
1046377 | 1046377 | 2021-02-19 | Unicoi | Tennessee | 47171 | 1778 | 47 |
1046378 | 1046378 | 2021-02-19 | Union | Tennessee | 47173 | 1661 | 30 |
1046379 | 1046379 | 2021-02-19 | Unknown | Tennessee | 8450 | 113 | |
1046380 | 1046380 | 2021-02-19 | Van Buren | Tennessee | 47175 | 787 | 20 |
1046381 | 1046381 | 2021-02-19 | Warren | Tennessee | 47177 | 5282 | 73 |
1046382 | 1046382 | 2021-02-19 | Washington | Tennessee | 47179 | 12598 | 227 |
1046383 | 1046383 | 2021-02-19 | Wayne | Tennessee | 47181 | 2853 | 30 |
1046384 | 1046384 | 2021-02-19 | Weakley | Tennessee | 47183 | 3768 | 59 |
1046385 | 1046385 | 2021-02-19 | White | Tennessee | 47185 | 3306 | 64 |
1046386 | 1046386 | 2021-02-19 | Williamson | Tennessee | 47187 | 24713 | 200 |
1046387 | 1046387 | 2021-02-19 | Wilson | Tennessee | 47189 | 16029 | 206 |
1043047 | 1043047 | 2021-02-18 | Anderson | Tennessee | 47001 | 7794 | 149 |
1043048 | 1043048 | 2021-02-18 | Bedford | Tennessee | 47003 | 5717 | 117 |
1043049 | 1043049 | 2021-02-18 | Benton | Tennessee | 47005 | 1497 | 39 |
1043050 | 1043050 | 2021-02-18 | Bledsoe | Tennessee | 47007 | 1971 | 10 |
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);