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-16 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1127443 | 1127443 | 2021-03-16 | Anderson | Tennessee | 47001 | 8272 | 159 |
1127444 | 1127444 | 2021-03-16 | Bedford | Tennessee | 47003 | 5966 | 122 |
1127445 | 1127445 | 2021-03-16 | Benton | Tennessee | 47005 | 1528 | 39 |
1127446 | 1127446 | 2021-03-16 | Bledsoe | Tennessee | 47007 | 2034 | 10 |
1127447 | 1127447 | 2021-03-16 | Blount | Tennessee | 47009 | 14412 | 186 |
1127448 | 1127448 | 2021-03-16 | Bradley | Tennessee | 47011 | 13492 | 141 |
1127449 | 1127449 | 2021-03-16 | Campbell | Tennessee | 47013 | 3929 | 59 |
1127450 | 1127450 | 2021-03-16 | Cannon | Tennessee | 47015 | 1814 | 31 |
1127451 | 1127451 | 2021-03-16 | Carroll | Tennessee | 47017 | 3516 | 81 |
1127452 | 1127452 | 2021-03-16 | Carter | Tennessee | 47019 | 6055 | 155 |
1127453 | 1127453 | 2021-03-16 | Cheatham | Tennessee | 47021 | 4087 | 47 |
1127454 | 1127454 | 2021-03-16 | Chester | Tennessee | 47023 | 2052 | 48 |
1127455 | 1127455 | 2021-03-16 | Claiborne | Tennessee | 47025 | 2910 | 71 |
1127456 | 1127456 | 2021-03-16 | Clay | Tennessee | 47027 | 1073 | 31 |
1127457 | 1127457 | 2021-03-16 | Cocke | Tennessee | 47029 | 4186 | 96 |
1127458 | 1127458 | 2021-03-16 | Coffee | Tennessee | 47031 | 6548 | 117 |
1127459 | 1127459 | 2021-03-16 | Crockett | Tennessee | 47033 | 1975 | 48 |
1127460 | 1127460 | 2021-03-16 | Cumberland | Tennessee | 47035 | 6216 | 123 |
1127461 | 1127461 | 2021-03-16 | Davidson | Tennessee | 47037 | 92049 | 872 |
1127462 | 1127462 | 2021-03-16 | DeKalb | Tennessee | 47041 | 2695 | 52 |
1127463 | 1127463 | 2021-03-16 | Decatur | Tennessee | 47039 | 1548 | 37 |
1127464 | 1127464 | 2021-03-16 | Dickson | Tennessee | 47043 | 6375 | 107 |
1127465 | 1127465 | 2021-03-16 | Dyer | Tennessee | 47045 | 5278 | 103 |
1127466 | 1127466 | 2021-03-16 | Fayette | Tennessee | 47047 | 4735 | 75 |
1127467 | 1127467 | 2021-03-16 | Fentress | Tennessee | 47049 | 2319 | 44 |
1127468 | 1127468 | 2021-03-16 | Franklin | Tennessee | 47051 | 4862 | 85 |
1127469 | 1127469 | 2021-03-16 | Gibson | Tennessee | 47053 | 6235 | 141 |
1127470 | 1127470 | 2021-03-16 | Giles | Tennessee | 47055 | 3794 | 97 |
1127471 | 1127471 | 2021-03-16 | Grainger | Tennessee | 47057 | 2474 | 47 |
1127472 | 1127472 | 2021-03-16 | Greene | Tennessee | 47059 | 7376 | 149 |
1127473 | 1127473 | 2021-03-16 | Grundy | Tennessee | 47061 | 1717 | 30 |
1127474 | 1127474 | 2021-03-16 | Hamblen | Tennessee | 47063 | 8197 | 169 |
1127475 | 1127475 | 2021-03-16 | Hamilton | Tennessee | 47065 | 41650 | 467 |
1127476 | 1127476 | 2021-03-16 | Hancock | Tennessee | 47067 | 514 | 12 |
1127477 | 1127477 | 2021-03-16 | Hardeman | Tennessee | 47069 | 3404 | 63 |
1127478 | 1127478 | 2021-03-16 | Hardin | Tennessee | 47071 | 3343 | 64 |
1127479 | 1127479 | 2021-03-16 | Hawkins | Tennessee | 47073 | 5382 | 100 |
1127480 | 1127480 | 2021-03-16 | Haywood | Tennessee | 47075 | 2660 | 60 |
1127481 | 1127481 | 2021-03-16 | Henderson | Tennessee | 47077 | 3640 | 74 |
1127482 | 1127482 | 2021-03-16 | Henry | Tennessee | 47079 | 3043 | 75 |
1127483 | 1127483 | 2021-03-16 | Hickman | Tennessee | 47081 | 2715 | 42 |
1127484 | 1127484 | 2021-03-16 | Houston | Tennessee | 47083 | 1048 | 33 |
1127485 | 1127485 | 2021-03-16 | Humphreys | Tennessee | 47085 | 1582 | 21 |
1127486 | 1127486 | 2021-03-16 | Jackson | Tennessee | 47087 | 1266 | 34 |
1127487 | 1127487 | 2021-03-16 | Jefferson | Tennessee | 47089 | 5823 | 121 |
1127488 | 1127488 | 2021-03-16 | Johnson | Tennessee | 47091 | 2184 | 38 |
1127489 | 1127489 | 2021-03-16 | Knox | Tennessee | 47093 | 48240 | 596 |
1127490 | 1127490 | 2021-03-16 | Lake | Tennessee | 47095 | 1681 | 26 |
1127491 | 1127491 | 2021-03-16 | Lauderdale | Tennessee | 47097 | 3104 | 44 |
1127492 | 1127492 | 2021-03-16 | Lawrence | Tennessee | 47099 | 5614 | 84 |
1127493 | 1127493 | 2021-03-16 | Lewis | Tennessee | 47101 | 1488 | 25 |
1127494 | 1127494 | 2021-03-16 | Lincoln | Tennessee | 47103 | 4194 | 62 |
1127495 | 1127495 | 2021-03-16 | Loudon | Tennessee | 47105 | 5807 | 67 |
1127496 | 1127496 | 2021-03-16 | Macon | Tennessee | 47111 | 3407 | 74 |
1127497 | 1127497 | 2021-03-16 | Madison | Tennessee | 47113 | 10251 | 235 |
1127498 | 1127498 | 2021-03-16 | Marion | Tennessee | 47115 | 3011 | 45 |
1127499 | 1127499 | 2021-03-16 | Marshall | Tennessee | 47117 | 3963 | 57 |
1127500 | 1127500 | 2021-03-16 | Maury | Tennessee | 47119 | 12410 | 162 |
1127501 | 1127501 | 2021-03-16 | McMinn | Tennessee | 47107 | 6059 | 93 |
1127502 | 1127502 | 2021-03-16 | McNairy | Tennessee | 47109 | 2714 | 53 |
1127503 | 1127503 | 2021-03-16 | Meigs | Tennessee | 47121 | 1282 | 23 |
1127504 | 1127504 | 2021-03-16 | Monroe | Tennessee | 47123 | 5466 | 92 |
1127505 | 1127505 | 2021-03-16 | Montgomery | Tennessee | 47125 | 17834 | 213 |
1127506 | 1127506 | 2021-03-16 | Moore | Tennessee | 47127 | 953 | 17 |
1127507 | 1127507 | 2021-03-16 | Morgan | Tennessee | 47129 | 2339 | 38 |
1127508 | 1127508 | 2021-03-16 | Obion | Tennessee | 47131 | 4392 | 95 |
1127509 | 1127509 | 2021-03-16 | Overton | Tennessee | 47133 | 2895 | 58 |
1127510 | 1127510 | 2021-03-16 | Perry | Tennessee | 47135 | 1046 | 28 |
1127511 | 1127511 | 2021-03-16 | Pickett | Tennessee | 47137 | 750 | 23 |
1127512 | 1127512 | 2021-03-16 | Polk | Tennessee | 47139 | 1836 | 24 |
1127513 | 1127513 | 2021-03-16 | Putnam | Tennessee | 47141 | 10786 | 171 |
1127514 | 1127514 | 2021-03-16 | Rhea | Tennessee | 47143 | 4201 | 73 |
1127515 | 1127515 | 2021-03-16 | Roane | Tennessee | 47145 | 6008 | 96 |
1127516 | 1127516 | 2021-03-16 | Robertson | Tennessee | 47147 | 9160 | 123 |
1127517 | 1127517 | 2021-03-16 | Rutherford | Tennessee | 47149 | 39622 | 396 |
1127518 | 1127518 | 2021-03-16 | Scott | Tennessee | 47151 | 2925 | 44 |
1127519 | 1127519 | 2021-03-16 | Sequatchie | Tennessee | 47153 | 1601 | 26 |
1127520 | 1127520 | 2021-03-16 | Sevier | Tennessee | 47155 | 12443 | 166 |
1127521 | 1127521 | 2021-03-16 | Shelby | Tennessee | 47157 | 89681 | 1539 |
1127522 | 1127522 | 2021-03-16 | Smith | Tennessee | 47159 | 2619 | 36 |
1127523 | 1127523 | 2021-03-16 | Stewart | Tennessee | 47161 | 1260 | 25 |
1127524 | 1127524 | 2021-03-16 | Sullivan | Tennessee | 47163 | 14864 | 278 |
1127525 | 1127525 | 2021-03-16 | Sumner | Tennessee | 47165 | 21933 | 325 |
1127526 | 1127526 | 2021-03-16 | Tipton | Tennessee | 47167 | 7039 | 104 |
1127527 | 1127527 | 2021-03-16 | Trousdale | Tennessee | 47169 | 2421 | 22 |
1127528 | 1127528 | 2021-03-16 | Unicoi | Tennessee | 47171 | 1835 | 47 |
1127529 | 1127529 | 2021-03-16 | Union | Tennessee | 47173 | 1778 | 34 |
1127530 | 1127530 | 2021-03-16 | Unknown | Tennessee | 8696 | 118 | |
1127531 | 1127531 | 2021-03-16 | Van Buren | Tennessee | 47175 | 805 | 20 |
1127532 | 1127532 | 2021-03-16 | Warren | Tennessee | 47177 | 5371 | 79 |
1127533 | 1127533 | 2021-03-16 | Washington | Tennessee | 47179 | 13025 | 235 |
1127534 | 1127534 | 2021-03-16 | Wayne | Tennessee | 47181 | 2908 | 31 |
1127535 | 1127535 | 2021-03-16 | Weakley | Tennessee | 47183 | 3839 | 60 |
1127536 | 1127536 | 2021-03-16 | White | Tennessee | 47185 | 3433 | 67 |
1127537 | 1127537 | 2021-03-16 | Williamson | Tennessee | 47187 | 25908 | 208 |
1127538 | 1127538 | 2021-03-16 | Wilson | Tennessee | 47189 | 17018 | 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);