ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where "date" is on date 2021-03-20 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1140430 | 1140430 | 2021-03-20 | Anderson | Tennessee | 47001 | 8334 | 160 |
1140431 | 1140431 | 2021-03-20 | Bedford | Tennessee | 47003 | 6030 | 123 |
1140432 | 1140432 | 2021-03-20 | Benton | Tennessee | 47005 | 1540 | 39 |
1140433 | 1140433 | 2021-03-20 | Bledsoe | Tennessee | 47007 | 2047 | 10 |
1140434 | 1140434 | 2021-03-20 | Blount | Tennessee | 47009 | 14498 | 189 |
1140435 | 1140435 | 2021-03-20 | Bradley | Tennessee | 47011 | 13655 | 142 |
1140436 | 1140436 | 2021-03-20 | Campbell | Tennessee | 47013 | 3955 | 59 |
1140437 | 1140437 | 2021-03-20 | Cannon | Tennessee | 47015 | 1826 | 31 |
1140438 | 1140438 | 2021-03-20 | Carroll | Tennessee | 47017 | 3520 | 81 |
1140439 | 1140439 | 2021-03-20 | Carter | Tennessee | 47019 | 6083 | 155 |
1140440 | 1140440 | 2021-03-20 | Cheatham | Tennessee | 47021 | 4130 | 47 |
1140441 | 1140441 | 2021-03-20 | Chester | Tennessee | 47023 | 2056 | 48 |
1140442 | 1140442 | 2021-03-20 | Claiborne | Tennessee | 47025 | 2927 | 71 |
1140443 | 1140443 | 2021-03-20 | Clay | Tennessee | 47027 | 1074 | 31 |
1140444 | 1140444 | 2021-03-20 | Cocke | Tennessee | 47029 | 4234 | 96 |
1140445 | 1140445 | 2021-03-20 | Coffee | Tennessee | 47031 | 6593 | 117 |
1140446 | 1140446 | 2021-03-20 | Crockett | Tennessee | 47033 | 1975 | 48 |
1140447 | 1140447 | 2021-03-20 | Cumberland | Tennessee | 47035 | 6243 | 123 |
1140448 | 1140448 | 2021-03-20 | Davidson | Tennessee | 47037 | 92607 | 881 |
1140449 | 1140449 | 2021-03-20 | DeKalb | Tennessee | 47041 | 2701 | 52 |
1140450 | 1140450 | 2021-03-20 | Decatur | Tennessee | 47039 | 1555 | 37 |
1140451 | 1140451 | 2021-03-20 | Dickson | Tennessee | 47043 | 6407 | 107 |
1140452 | 1140452 | 2021-03-20 | Dyer | Tennessee | 47045 | 5291 | 103 |
1140453 | 1140453 | 2021-03-20 | Fayette | Tennessee | 47047 | 4756 | 75 |
1140454 | 1140454 | 2021-03-20 | Fentress | Tennessee | 47049 | 2328 | 45 |
1140455 | 1140455 | 2021-03-20 | Franklin | Tennessee | 47051 | 4890 | 87 |
1140456 | 1140456 | 2021-03-20 | Gibson | Tennessee | 47053 | 6249 | 141 |
1140457 | 1140457 | 2021-03-20 | Giles | Tennessee | 47055 | 3807 | 98 |
1140458 | 1140458 | 2021-03-20 | Grainger | Tennessee | 47057 | 2489 | 47 |
1140459 | 1140459 | 2021-03-20 | Greene | Tennessee | 47059 | 7402 | 149 |
1140460 | 1140460 | 2021-03-20 | Grundy | Tennessee | 47061 | 1725 | 30 |
1140461 | 1140461 | 2021-03-20 | Hamblen | Tennessee | 47063 | 8245 | 169 |
1140462 | 1140462 | 2021-03-20 | Hamilton | Tennessee | 47065 | 41954 | 469 |
1140463 | 1140463 | 2021-03-20 | Hancock | Tennessee | 47067 | 515 | 12 |
1140464 | 1140464 | 2021-03-20 | Hardeman | Tennessee | 47069 | 3412 | 63 |
1140465 | 1140465 | 2021-03-20 | Hardin | Tennessee | 47071 | 3358 | 64 |
1140466 | 1140466 | 2021-03-20 | Hawkins | Tennessee | 47073 | 5417 | 102 |
1140467 | 1140467 | 2021-03-20 | Haywood | Tennessee | 47075 | 2663 | 60 |
1140468 | 1140468 | 2021-03-20 | Henderson | Tennessee | 47077 | 3647 | 74 |
1140469 | 1140469 | 2021-03-20 | Henry | Tennessee | 47079 | 3052 | 76 |
1140470 | 1140470 | 2021-03-20 | Hickman | Tennessee | 47081 | 2723 | 43 |
1140471 | 1140471 | 2021-03-20 | Houston | Tennessee | 47083 | 1048 | 33 |
1140472 | 1140472 | 2021-03-20 | Humphreys | Tennessee | 47085 | 1589 | 21 |
1140473 | 1140473 | 2021-03-20 | Jackson | Tennessee | 47087 | 1270 | 35 |
1140474 | 1140474 | 2021-03-20 | Jefferson | Tennessee | 47089 | 5850 | 121 |
1140475 | 1140475 | 2021-03-20 | Johnson | Tennessee | 47091 | 2194 | 38 |
1140476 | 1140476 | 2021-03-20 | Knox | Tennessee | 47093 | 48446 | 602 |
1140477 | 1140477 | 2021-03-20 | Lake | Tennessee | 47095 | 1683 | 26 |
1140478 | 1140478 | 2021-03-20 | Lauderdale | Tennessee | 47097 | 3105 | 44 |
1140479 | 1140479 | 2021-03-20 | Lawrence | Tennessee | 47099 | 5626 | 86 |
1140480 | 1140480 | 2021-03-20 | Lewis | Tennessee | 47101 | 1492 | 25 |
1140481 | 1140481 | 2021-03-20 | Lincoln | Tennessee | 47103 | 4201 | 62 |
1140482 | 1140482 | 2021-03-20 | Loudon | Tennessee | 47105 | 5830 | 68 |
1140483 | 1140483 | 2021-03-20 | Macon | Tennessee | 47111 | 3420 | 74 |
1140484 | 1140484 | 2021-03-20 | Madison | Tennessee | 47113 | 10289 | 236 |
1140485 | 1140485 | 2021-03-20 | Marion | Tennessee | 47115 | 3020 | 45 |
1140486 | 1140486 | 2021-03-20 | Marshall | Tennessee | 47117 | 3981 | 57 |
1140487 | 1140487 | 2021-03-20 | Maury | Tennessee | 47119 | 12486 | 162 |
1140488 | 1140488 | 2021-03-20 | McMinn | Tennessee | 47107 | 6093 | 94 |
1140489 | 1140489 | 2021-03-20 | McNairy | Tennessee | 47109 | 2716 | 53 |
1140490 | 1140490 | 2021-03-20 | Meigs | Tennessee | 47121 | 1287 | 23 |
1140491 | 1140491 | 2021-03-20 | Monroe | Tennessee | 47123 | 5499 | 93 |
1140492 | 1140492 | 2021-03-20 | Montgomery | Tennessee | 47125 | 17951 | 214 |
1140493 | 1140493 | 2021-03-20 | Moore | Tennessee | 47127 | 959 | 17 |
1140494 | 1140494 | 2021-03-20 | Morgan | Tennessee | 47129 | 2348 | 38 |
1140495 | 1140495 | 2021-03-20 | Obion | Tennessee | 47131 | 4403 | 95 |
1140496 | 1140496 | 2021-03-20 | Overton | Tennessee | 47133 | 2899 | 58 |
1140497 | 1140497 | 2021-03-20 | Perry | Tennessee | 47135 | 1048 | 28 |
1140498 | 1140498 | 2021-03-20 | Pickett | Tennessee | 47137 | 751 | 23 |
1140499 | 1140499 | 2021-03-20 | Polk | Tennessee | 47139 | 1868 | 24 |
1140500 | 1140500 | 2021-03-20 | Putnam | Tennessee | 47141 | 10841 | 172 |
1140501 | 1140501 | 2021-03-20 | Rhea | Tennessee | 47143 | 4213 | 75 |
1140502 | 1140502 | 2021-03-20 | Roane | Tennessee | 47145 | 6031 | 97 |
1140503 | 1140503 | 2021-03-20 | Robertson | Tennessee | 47147 | 9204 | 124 |
1140504 | 1140504 | 2021-03-20 | Rutherford | Tennessee | 47149 | 39910 | 398 |
1140505 | 1140505 | 2021-03-20 | Scott | Tennessee | 47151 | 2937 | 44 |
1140506 | 1140506 | 2021-03-20 | Sequatchie | Tennessee | 47153 | 1606 | 26 |
1140507 | 1140507 | 2021-03-20 | Sevier | Tennessee | 47155 | 12553 | 166 |
1140508 | 1140508 | 2021-03-20 | Shelby | Tennessee | 47157 | 90110 | 1546 |
1140509 | 1140509 | 2021-03-20 | Smith | Tennessee | 47159 | 2635 | 36 |
1140510 | 1140510 | 2021-03-20 | Stewart | Tennessee | 47161 | 1265 | 25 |
1140511 | 1140511 | 2021-03-20 | Sullivan | Tennessee | 47163 | 14983 | 279 |
1140512 | 1140512 | 2021-03-20 | Sumner | Tennessee | 47165 | 22074 | 327 |
1140513 | 1140513 | 2021-03-20 | Tipton | Tennessee | 47167 | 7062 | 104 |
1140514 | 1140514 | 2021-03-20 | Trousdale | Tennessee | 47169 | 2429 | 22 |
1140515 | 1140515 | 2021-03-20 | Unicoi | Tennessee | 47171 | 1849 | 47 |
1140516 | 1140516 | 2021-03-20 | Union | Tennessee | 47173 | 1790 | 34 |
1140517 | 1140517 | 2021-03-20 | Unknown | Tennessee | 8711 | 119 | |
1140518 | 1140518 | 2021-03-20 | Van Buren | Tennessee | 47175 | 807 | 20 |
1140519 | 1140519 | 2021-03-20 | Warren | Tennessee | 47177 | 5386 | 79 |
1140520 | 1140520 | 2021-03-20 | Washington | Tennessee | 47179 | 13112 | 235 |
1140521 | 1140521 | 2021-03-20 | Wayne | Tennessee | 47181 | 2918 | 31 |
1140522 | 1140522 | 2021-03-20 | Weakley | Tennessee | 47183 | 3857 | 60 |
1140523 | 1140523 | 2021-03-20 | White | Tennessee | 47185 | 3442 | 67 |
1140524 | 1140524 | 2021-03-20 | Williamson | Tennessee | 47187 | 26058 | 210 |
1140525 | 1140525 | 2021-03-20 | Wilson | Tennessee | 47189 | 17172 | 214 |
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);