ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where "date" is on date 2020-11-05 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
702293 | 702293 | 2020-11-05 | Anderson | Tennessee | 47001 | 1959 | 18 |
702294 | 702294 | 2020-11-05 | Bedford | Tennessee | 47003 | 1925 | 23 |
702295 | 702295 | 2020-11-05 | Benton | Tennessee | 47005 | 482 | 10 |
702296 | 702296 | 2020-11-05 | Bledsoe | Tennessee | 47007 | 1057 | 4 |
702297 | 702297 | 2020-11-05 | Blount | Tennessee | 47009 | 3753 | 44 |
702298 | 702298 | 2020-11-05 | Bradley | Tennessee | 47011 | 3879 | 24 |
702299 | 702299 | 2020-11-05 | Campbell | Tennessee | 47013 | 1176 | 14 |
702300 | 702300 | 2020-11-05 | Cannon | Tennessee | 47015 | 469 | 2 |
702301 | 702301 | 2020-11-05 | Carroll | Tennessee | 47017 | 1250 | 28 |
702302 | 702302 | 2020-11-05 | Carter | Tennessee | 47019 | 1869 | 38 |
702303 | 702303 | 2020-11-05 | Cheatham | Tennessee | 47021 | 1164 | 12 |
702304 | 702304 | 2020-11-05 | Chester | Tennessee | 47023 | 778 | 17 |
702305 | 702305 | 2020-11-05 | Claiborne | Tennessee | 47025 | 565 | 8 |
702306 | 702306 | 2020-11-05 | Clay | Tennessee | 47027 | 433 | 16 |
702307 | 702307 | 2020-11-05 | Cocke | Tennessee | 47029 | 1246 | 20 |
702308 | 702308 | 2020-11-05 | Coffee | Tennessee | 47031 | 2135 | 32 |
702309 | 702309 | 2020-11-05 | Crockett | Tennessee | 47033 | 984 | 24 |
702310 | 702310 | 2020-11-05 | Cumberland | Tennessee | 47035 | 1786 | 29 |
702311 | 702311 | 2020-11-05 | Davidson | Tennessee | 47037 | 36089 | 360 |
702312 | 702312 | 2020-11-05 | DeKalb | Tennessee | 47041 | 820 | 18 |
702313 | 702313 | 2020-11-05 | Decatur | Tennessee | 47039 | 706 | 11 |
702314 | 702314 | 2020-11-05 | Dickson | Tennessee | 47043 | 1925 | 21 |
702315 | 702315 | 2020-11-05 | Dyer | Tennessee | 47045 | 2502 | 38 |
702316 | 702316 | 2020-11-05 | Fayette | Tennessee | 47047 | 1827 | 29 |
702317 | 702317 | 2020-11-05 | Fentress | Tennessee | 47049 | 985 | 13 |
702318 | 702318 | 2020-11-05 | Franklin | Tennessee | 47051 | 1426 | 27 |
702319 | 702319 | 2020-11-05 | Gibson | Tennessee | 47053 | 2330 | 50 |
702320 | 702320 | 2020-11-05 | Giles | Tennessee | 47055 | 1081 | 38 |
702321 | 702321 | 2020-11-05 | Grainger | Tennessee | 47057 | 726 | 4 |
702322 | 702322 | 2020-11-05 | Greene | Tennessee | 47059 | 2143 | 58 |
702323 | 702323 | 2020-11-05 | Grundy | Tennessee | 47061 | 630 | 14 |
702324 | 702324 | 2020-11-05 | Hamblen | Tennessee | 47063 | 2648 | 51 |
702325 | 702325 | 2020-11-05 | Hamilton | Tennessee | 47065 | 13213 | 114 |
702326 | 702326 | 2020-11-05 | Hancock | Tennessee | 47067 | 126 | 3 |
702327 | 702327 | 2020-11-05 | Hardeman | Tennessee | 47069 | 2007 | 34 |
702328 | 702328 | 2020-11-05 | Hardin | Tennessee | 47071 | 1480 | 23 |
702329 | 702329 | 2020-11-05 | Hawkins | Tennessee | 47073 | 1372 | 30 |
702330 | 702330 | 2020-11-05 | Haywood | Tennessee | 47075 | 1378 | 28 |
702331 | 702331 | 2020-11-05 | Henderson | Tennessee | 47077 | 1484 | 28 |
702332 | 702332 | 2020-11-05 | Henry | Tennessee | 47079 | 936 | 13 |
702333 | 702333 | 2020-11-05 | Hickman | Tennessee | 47081 | 868 | 16 |
702334 | 702334 | 2020-11-05 | Houston | Tennessee | 47083 | 461 | 18 |
702335 | 702335 | 2020-11-05 | Humphreys | Tennessee | 47085 | 497 | 6 |
702336 | 702336 | 2020-11-05 | Jackson | Tennessee | 47087 | 501 | 7 |
702337 | 702337 | 2020-11-05 | Jefferson | Tennessee | 47089 | 1674 | 25 |
702338 | 702338 | 2020-11-05 | Johnson | Tennessee | 47091 | 1252 | 13 |
702339 | 702339 | 2020-11-05 | Knox | Tennessee | 47093 | 14439 | 111 |
702340 | 702340 | 2020-11-05 | Lake | Tennessee | 47095 | 1014 | 4 |
702341 | 702341 | 2020-11-05 | Lauderdale | Tennessee | 47097 | 1554 | 18 |
702342 | 702342 | 2020-11-05 | Lawrence | Tennessee | 47099 | 1864 | 24 |
702343 | 702343 | 2020-11-05 | Lewis | Tennessee | 47101 | 550 | 7 |
702344 | 702344 | 2020-11-05 | Lincoln | Tennessee | 47103 | 1052 | 7 |
702345 | 702345 | 2020-11-05 | Loudon | Tennessee | 47105 | 1768 | 13 |
702346 | 702346 | 2020-11-05 | Macon | Tennessee | 47111 | 1432 | 26 |
702347 | 702347 | 2020-11-05 | Madison | Tennessee | 47113 | 4092 | 86 |
702348 | 702348 | 2020-11-05 | Marion | Tennessee | 47115 | 877 | 14 |
702349 | 702349 | 2020-11-05 | Marshall | Tennessee | 47117 | 1276 | 12 |
702350 | 702350 | 2020-11-05 | Maury | Tennessee | 47119 | 3931 | 39 |
702351 | 702351 | 2020-11-05 | McMinn | Tennessee | 47107 | 1824 | 41 |
702352 | 702352 | 2020-11-05 | McNairy | Tennessee | 47109 | 1197 | 30 |
702353 | 702353 | 2020-11-05 | Meigs | Tennessee | 47121 | 359 | 8 |
702354 | 702354 | 2020-11-05 | Monroe | Tennessee | 47123 | 1600 | 32 |
702355 | 702355 | 2020-11-05 | Montgomery | Tennessee | 47125 | 4621 | 63 |
702356 | 702356 | 2020-11-05 | Moore | Tennessee | 47127 | 297 | 2 |
702357 | 702357 | 2020-11-05 | Morgan | Tennessee | 47129 | 472 | 6 |
702358 | 702358 | 2020-11-05 | Obion | Tennessee | 47131 | 1944 | 28 |
702359 | 702359 | 2020-11-05 | Overton | Tennessee | 47133 | 1313 | 26 |
702360 | 702360 | 2020-11-05 | Perry | Tennessee | 47135 | 376 | 12 |
702361 | 702361 | 2020-11-05 | Pickett | Tennessee | 47137 | 299 | 10 |
702362 | 702362 | 2020-11-05 | Polk | Tennessee | 47139 | 554 | 13 |
702363 | 702363 | 2020-11-05 | Putnam | Tennessee | 47141 | 4743 | 63 |
702364 | 702364 | 2020-11-05 | Rhea | Tennessee | 47143 | 1225 | 23 |
702365 | 702365 | 2020-11-05 | Roane | Tennessee | 47145 | 1590 | 10 |
702366 | 702366 | 2020-11-05 | Robertson | Tennessee | 47147 | 2774 | 43 |
702367 | 702367 | 2020-11-05 | Rutherford | Tennessee | 47149 | 13111 | 122 |
702368 | 702368 | 2020-11-05 | Scott | Tennessee | 47151 | 483 | 5 |
702369 | 702369 | 2020-11-05 | Sequatchie | Tennessee | 47153 | 395 | 5 |
702370 | 702370 | 2020-11-05 | Sevier | Tennessee | 47155 | 3662 | 24 |
702371 | 702371 | 2020-11-05 | Shelby | Tennessee | 47157 | 38875 | 580 |
702372 | 702372 | 2020-11-05 | Smith | Tennessee | 47159 | 1068 | 16 |
702373 | 702373 | 2020-11-05 | Stewart | Tennessee | 47161 | 391 | 13 |
702374 | 702374 | 2020-11-05 | Sullivan | Tennessee | 47163 | 4365 | 61 |
702375 | 702375 | 2020-11-05 | Sumner | Tennessee | 47165 | 6770 | 120 |
702376 | 702376 | 2020-11-05 | Tipton | Tennessee | 47167 | 2612 | 24 |
702377 | 702377 | 2020-11-05 | Trousdale | Tennessee | 47169 | 1811 | 10 |
702378 | 702378 | 2020-11-05 | Unicoi | Tennessee | 47171 | 541 | 7 |
702379 | 702379 | 2020-11-05 | Union | Tennessee | 47173 | 573 | 4 |
702380 | 702380 | 2020-11-05 | Van Buren | Tennessee | 47175 | 223 | 2 |
702381 | 702381 | 2020-11-05 | Warren | Tennessee | 47177 | 1603 | 11 |
702382 | 702382 | 2020-11-05 | Washington | Tennessee | 47179 | 4268 | 72 |
702383 | 702383 | 2020-11-05 | Wayne | Tennessee | 47181 | 1639 | 7 |
702384 | 702384 | 2020-11-05 | Weakley | Tennessee | 47183 | 1672 | 27 |
702385 | 702385 | 2020-11-05 | White | Tennessee | 47185 | 1336 | 16 |
702386 | 702386 | 2020-11-05 | Williamson | Tennessee | 47187 | 7911 | 59 |
702387 | 702387 | 2020-11-05 | Wilson | Tennessee | 47189 | 5214 | 65 |
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);