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-10-28 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
676346 | 676346 | 2020-10-28 | Anderson | Tennessee | 47001 | 1767 | 14 |
676347 | 676347 | 2020-10-28 | Bedford | Tennessee | 47003 | 1763 | 20 |
676348 | 676348 | 2020-10-28 | Benton | Tennessee | 47005 | 431 | 9 |
676349 | 676349 | 2020-10-28 | Bledsoe | Tennessee | 47007 | 1033 | 4 |
676350 | 676350 | 2020-10-28 | Blount | Tennessee | 47009 | 3464 | 36 |
676351 | 676351 | 2020-10-28 | Bradley | Tennessee | 47011 | 3667 | 23 |
676352 | 676352 | 2020-10-28 | Campbell | Tennessee | 47013 | 1071 | 13 |
676353 | 676353 | 2020-10-28 | Cannon | Tennessee | 47015 | 430 | 2 |
676354 | 676354 | 2020-10-28 | Carroll | Tennessee | 47017 | 1161 | 26 |
676355 | 676355 | 2020-10-28 | Carter | Tennessee | 47019 | 1630 | 34 |
676356 | 676356 | 2020-10-28 | Cheatham | Tennessee | 47021 | 1091 | 12 |
676357 | 676357 | 2020-10-28 | Chester | Tennessee | 47023 | 740 | 15 |
676358 | 676358 | 2020-10-28 | Claiborne | Tennessee | 47025 | 538 | 7 |
676359 | 676359 | 2020-10-28 | Clay | Tennessee | 47027 | 415 | 15 |
676360 | 676360 | 2020-10-28 | Cocke | Tennessee | 47029 | 1123 | 14 |
676361 | 676361 | 2020-10-28 | Coffee | Tennessee | 47031 | 1962 | 26 |
676362 | 676362 | 2020-10-28 | Crockett | Tennessee | 47033 | 897 | 22 |
676363 | 676363 | 2020-10-28 | Cumberland | Tennessee | 47035 | 1651 | 27 |
676364 | 676364 | 2020-10-28 | Davidson | Tennessee | 47037 | 34156 | 346 |
676365 | 676365 | 2020-10-28 | DeKalb | Tennessee | 47041 | 779 | 17 |
676366 | 676366 | 2020-10-28 | Decatur | Tennessee | 47039 | 674 | 11 |
676367 | 676367 | 2020-10-28 | Dickson | Tennessee | 47043 | 1747 | 19 |
676368 | 676368 | 2020-10-28 | Dyer | Tennessee | 47045 | 2324 | 38 |
676369 | 676369 | 2020-10-28 | Fayette | Tennessee | 47047 | 1744 | 25 |
676370 | 676370 | 2020-10-28 | Fentress | Tennessee | 47049 | 934 | 11 |
676371 | 676371 | 2020-10-28 | Franklin | Tennessee | 47051 | 1314 | 23 |
676372 | 676372 | 2020-10-28 | Gibson | Tennessee | 47053 | 2205 | 49 |
676373 | 676373 | 2020-10-28 | Giles | Tennessee | 47055 | 994 | 38 |
676374 | 676374 | 2020-10-28 | Grainger | Tennessee | 47057 | 635 | 4 |
676375 | 676375 | 2020-10-28 | Greene | Tennessee | 47059 | 1831 | 54 |
676376 | 676376 | 2020-10-28 | Grundy | Tennessee | 47061 | 585 | 11 |
676377 | 676377 | 2020-10-28 | Hamblen | Tennessee | 47063 | 2525 | 50 |
676378 | 676378 | 2020-10-28 | Hamilton | Tennessee | 47065 | 12312 | 111 |
676379 | 676379 | 2020-10-28 | Hancock | Tennessee | 47067 | 123 | 3 |
676380 | 676380 | 2020-10-28 | Hardeman | Tennessee | 47069 | 1929 | 33 |
676381 | 676381 | 2020-10-28 | Hardin | Tennessee | 47071 | 1426 | 22 |
676382 | 676382 | 2020-10-28 | Hawkins | Tennessee | 47073 | 1245 | 25 |
676383 | 676383 | 2020-10-28 | Haywood | Tennessee | 47075 | 1317 | 28 |
676384 | 676384 | 2020-10-28 | Henderson | Tennessee | 47077 | 1436 | 26 |
676385 | 676385 | 2020-10-28 | Henry | Tennessee | 47079 | 821 | 12 |
676386 | 676386 | 2020-10-28 | Hickman | Tennessee | 47081 | 820 | 15 |
676387 | 676387 | 2020-10-28 | Houston | Tennessee | 47083 | 428 | 17 |
676388 | 676388 | 2020-10-28 | Humphreys | Tennessee | 47085 | 462 | 4 |
676389 | 676389 | 2020-10-28 | Jackson | Tennessee | 47087 | 468 | 6 |
676390 | 676390 | 2020-10-28 | Jefferson | Tennessee | 47089 | 1588 | 23 |
676391 | 676391 | 2020-10-28 | Johnson | Tennessee | 47091 | 1171 | 7 |
676392 | 676392 | 2020-10-28 | Knox | Tennessee | 47093 | 13454 | 103 |
676393 | 676393 | 2020-10-28 | Lake | Tennessee | 47095 | 990 | 4 |
676394 | 676394 | 2020-10-28 | Lauderdale | Tennessee | 47097 | 1474 | 17 |
676395 | 676395 | 2020-10-28 | Lawrence | Tennessee | 47099 | 1696 | 20 |
676396 | 676396 | 2020-10-28 | Lewis | Tennessee | 47101 | 431 | 5 |
676397 | 676397 | 2020-10-28 | Lincoln | Tennessee | 47103 | 931 | 3 |
676398 | 676398 | 2020-10-28 | Loudon | Tennessee | 47105 | 1678 | 12 |
676399 | 676399 | 2020-10-28 | Macon | Tennessee | 47111 | 1371 | 25 |
676400 | 676400 | 2020-10-28 | Madison | Tennessee | 47113 | 3892 | 80 |
676401 | 676401 | 2020-10-28 | Marion | Tennessee | 47115 | 809 | 10 |
676402 | 676402 | 2020-10-28 | Marshall | Tennessee | 47117 | 1172 | 11 |
676403 | 676403 | 2020-10-28 | Maury | Tennessee | 47119 | 3431 | 38 |
676404 | 676404 | 2020-10-28 | McMinn | Tennessee | 47107 | 1683 | 38 |
676405 | 676405 | 2020-10-28 | McNairy | Tennessee | 47109 | 1150 | 29 |
676406 | 676406 | 2020-10-28 | Meigs | Tennessee | 47121 | 332 | 6 |
676407 | 676407 | 2020-10-28 | Monroe | Tennessee | 47123 | 1507 | 29 |
676408 | 676408 | 2020-10-28 | Montgomery | Tennessee | 47125 | 4333 | 60 |
676409 | 676409 | 2020-10-28 | Moore | Tennessee | 47127 | 277 | 2 |
676410 | 676410 | 2020-10-28 | Morgan | Tennessee | 47129 | 451 | 7 |
676411 | 676411 | 2020-10-28 | Obion | Tennessee | 47131 | 1847 | 23 |
676412 | 676412 | 2020-10-28 | Overton | Tennessee | 47133 | 1248 | 18 |
676413 | 676413 | 2020-10-28 | Perry | Tennessee | 47135 | 336 | 5 |
676414 | 676414 | 2020-10-28 | Pickett | Tennessee | 47137 | 283 | 9 |
676415 | 676415 | 2020-10-28 | Polk | Tennessee | 47139 | 533 | 13 |
676416 | 676416 | 2020-10-28 | Putnam | Tennessee | 47141 | 4548 | 57 |
676417 | 676417 | 2020-10-28 | Rhea | Tennessee | 47143 | 1132 | 19 |
676418 | 676418 | 2020-10-28 | Roane | Tennessee | 47145 | 1387 | 8 |
676419 | 676419 | 2020-10-28 | Robertson | Tennessee | 47147 | 2669 | 43 |
676420 | 676420 | 2020-10-28 | Rutherford | Tennessee | 47149 | 12271 | 115 |
676421 | 676421 | 2020-10-28 | Scott | Tennessee | 47151 | 400 | 5 |
676422 | 676422 | 2020-10-28 | Sequatchie | Tennessee | 47153 | 357 | 2 |
676423 | 676423 | 2020-10-28 | Sevier | Tennessee | 47155 | 3461 | 22 |
676424 | 676424 | 2020-10-28 | Shelby | Tennessee | 47157 | 37111 | 570 |
676425 | 676425 | 2020-10-28 | Smith | Tennessee | 47159 | 1024 | 14 |
676426 | 676426 | 2020-10-28 | Stewart | Tennessee | 47161 | 344 | 11 |
676427 | 676427 | 2020-10-28 | Sullivan | Tennessee | 47163 | 3923 | 49 |
676428 | 676428 | 2020-10-28 | Sumner | Tennessee | 47165 | 6305 | 113 |
676429 | 676429 | 2020-10-28 | Tipton | Tennessee | 47167 | 2439 | 23 |
676430 | 676430 | 2020-10-28 | Trousdale | Tennessee | 47169 | 1781 | 9 |
676431 | 676431 | 2020-10-28 | Unicoi | Tennessee | 47171 | 457 | 3 |
676432 | 676432 | 2020-10-28 | Union | Tennessee | 47173 | 552 | 3 |
676433 | 676433 | 2020-10-28 | Van Buren | Tennessee | 47175 | 212 | 2 |
676434 | 676434 | 2020-10-28 | Warren | Tennessee | 47177 | 1490 | 11 |
676435 | 676435 | 2020-10-28 | Washington | Tennessee | 47179 | 3663 | 53 |
676436 | 676436 | 2020-10-28 | Wayne | Tennessee | 47181 | 1612 | 7 |
676437 | 676437 | 2020-10-28 | Weakley | Tennessee | 47183 | 1601 | 26 |
676438 | 676438 | 2020-10-28 | White | Tennessee | 47185 | 1228 | 14 |
676439 | 676439 | 2020-10-28 | Williamson | Tennessee | 47187 | 7319 | 56 |
676440 | 676440 | 2020-10-28 | Wilson | Tennessee | 47189 | 4847 | 60 |
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);