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-11-21 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1939374 | 1939374 | 2021-11-21 | Anderson | Tennessee | 47001 | 13358 | 232 |
1939375 | 1939375 | 2021-11-21 | Bedford | Tennessee | 47003 | 9419 | 158 |
1939376 | 1939376 | 2021-11-21 | Benton | Tennessee | 47005 | 2907 | 55 |
1939377 | 1939377 | 2021-11-21 | Bledsoe | Tennessee | 47007 | 3530 | 18 |
1939378 | 1939378 | 2021-11-21 | Blount | Tennessee | 47009 | 24208 | 272 |
1939379 | 1939379 | 2021-11-21 | Bradley | Tennessee | 47011 | 22475 | 212 |
1939380 | 1939380 | 2021-11-21 | Campbell | Tennessee | 47013 | 7468 | 88 |
1939381 | 1939381 | 2021-11-21 | Cannon | Tennessee | 47015 | 2832 | 43 |
1939382 | 1939382 | 2021-11-21 | Carroll | Tennessee | 47017 | 5849 | 107 |
1939383 | 1939383 | 2021-11-21 | Carter | Tennessee | 47019 | 10760 | 223 |
1939384 | 1939384 | 2021-11-21 | Cheatham | Tennessee | 47021 | 7096 | 76 |
1939385 | 1939385 | 2021-11-21 | Chester | Tennessee | 47023 | 3574 | 76 |
1939386 | 1939386 | 2021-11-21 | Claiborne | Tennessee | 47025 | 5811 | 115 |
1939387 | 1939387 | 2021-11-21 | Clay | Tennessee | 47027 | 1547 | 37 |
1939388 | 1939388 | 2021-11-21 | Cocke | Tennessee | 47029 | 7541 | 109 |
1939389 | 1939389 | 2021-11-21 | Coffee | Tennessee | 47031 | 10769 | 163 |
1939390 | 1939390 | 2021-11-21 | Crockett | Tennessee | 47033 | 3392 | 62 |
1939391 | 1939391 | 2021-11-21 | Cumberland | Tennessee | 47035 | 11372 | 227 |
1939392 | 1939392 | 2021-11-21 | Davidson | Tennessee | 47037 | 134682 | 1192 |
1939393 | 1939393 | 2021-11-21 | DeKalb | Tennessee | 47041 | 4264 | 76 |
1939394 | 1939394 | 2021-11-21 | Decatur | Tennessee | 47039 | 2468 | 44 |
1939395 | 1939395 | 2021-11-21 | Dickson | Tennessee | 47043 | 10659 | 169 |
1939396 | 1939396 | 2021-11-21 | Dyer | Tennessee | 47045 | 8156 | 150 |
1939397 | 1939397 | 2021-11-21 | Fayette | Tennessee | 47047 | 7414 | 108 |
1939398 | 1939398 | 2021-11-21 | Fentress | Tennessee | 47049 | 3747 | 68 |
1939399 | 1939399 | 2021-11-21 | Franklin | Tennessee | 47051 | 8123 | 103 |
1939400 | 1939400 | 2021-11-21 | Gibson | Tennessee | 47053 | 10778 | 191 |
1939401 | 1939401 | 2021-11-21 | Giles | Tennessee | 47055 | 6140 | 127 |
1939402 | 1939402 | 2021-11-21 | Grainger | Tennessee | 47057 | 4467 | 68 |
1939403 | 1939403 | 2021-11-21 | Greene | Tennessee | 47059 | 14092 | 247 |
1939404 | 1939404 | 2021-11-21 | Grundy | Tennessee | 47061 | 2920 | 40 |
1939405 | 1939405 | 2021-11-21 | Hamblen | Tennessee | 47063 | 13211 | 206 |
1939406 | 1939406 | 2021-11-21 | Hamilton | Tennessee | 47065 | 64982 | 669 |
1939407 | 1939407 | 2021-11-21 | Hancock | Tennessee | 47067 | 1243 | 20 |
1939408 | 1939408 | 2021-11-21 | Hardeman | Tennessee | 47069 | 5160 | 84 |
1939409 | 1939409 | 2021-11-21 | Hardin | Tennessee | 47071 | 5646 | 88 |
1939410 | 1939410 | 2021-11-21 | Hawkins | Tennessee | 47073 | 10583 | 179 |
1939411 | 1939411 | 2021-11-21 | Haywood | Tennessee | 47075 | 3895 | 77 |
1939412 | 1939412 | 2021-11-21 | Henderson | Tennessee | 47077 | 5857 | 105 |
1939413 | 1939413 | 2021-11-21 | Henry | Tennessee | 47079 | 5553 | 88 |
1939414 | 1939414 | 2021-11-21 | Hickman | Tennessee | 47081 | 4707 | 78 |
1939415 | 1939415 | 2021-11-21 | Houston | Tennessee | 47083 | 1874 | 45 |
1939416 | 1939416 | 2021-11-21 | Humphreys | Tennessee | 47085 | 3320 | 48 |
1939417 | 1939417 | 2021-11-21 | Jackson | Tennessee | 47087 | 2106 | 40 |
1939418 | 1939418 | 2021-11-21 | Jefferson | Tennessee | 47089 | 10088 | 149 |
1939419 | 1939419 | 2021-11-21 | Johnson | Tennessee | 47091 | 3853 | 52 |
1939420 | 1939420 | 2021-11-21 | Knox | Tennessee | 47093 | 80093 | 946 |
1939421 | 1939421 | 2021-11-21 | Lake | Tennessee | 47095 | 2022 | 31 |
1939422 | 1939422 | 2021-11-21 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1939423 | 1939423 | 2021-11-21 | Lawrence | Tennessee | 47099 | 9701 | 125 |
1939424 | 1939424 | 2021-11-21 | Lewis | Tennessee | 47101 | 2555 | 41 |
1939425 | 1939425 | 2021-11-21 | Lincoln | Tennessee | 47103 | 6800 | 88 |
1939426 | 1939426 | 2021-11-21 | Loudon | Tennessee | 47105 | 9365 | 101 |
1939427 | 1939427 | 2021-11-21 | Macon | Tennessee | 47111 | 5529 | 94 |
1939428 | 1939428 | 2021-11-21 | Madison | Tennessee | 47113 | 17979 | 323 |
1939429 | 1939429 | 2021-11-21 | Marion | Tennessee | 47115 | 5867 | 57 |
1939430 | 1939430 | 2021-11-21 | Marshall | Tennessee | 47117 | 6942 | 90 |
1939431 | 1939431 | 2021-11-21 | Maury | Tennessee | 47119 | 19688 | 238 |
1939432 | 1939432 | 2021-11-21 | McMinn | Tennessee | 47107 | 10669 | 137 |
1939433 | 1939433 | 2021-11-21 | McNairy | Tennessee | 47109 | 4744 | 71 |
1939434 | 1939434 | 2021-11-21 | Meigs | Tennessee | 47121 | 2215 | 30 |
1939435 | 1939435 | 2021-11-21 | Monroe | Tennessee | 47123 | 9875 | 126 |
1939436 | 1939436 | 2021-11-21 | Montgomery | Tennessee | 47125 | 33395 | 347 |
1939437 | 1939437 | 2021-11-21 | Moore | Tennessee | 47127 | 1450 | 24 |
1939438 | 1939438 | 2021-11-21 | Morgan | Tennessee | 47129 | 3880 | 50 |
1939439 | 1939439 | 2021-11-21 | Obion | Tennessee | 47131 | 6776 | 112 |
1939440 | 1939440 | 2021-11-21 | Overton | Tennessee | 47133 | 4880 | 83 |
1939441 | 1939441 | 2021-11-21 | Perry | Tennessee | 47135 | 1634 | 34 |
1939442 | 1939442 | 2021-11-21 | Pickett | Tennessee | 47137 | 1111 | 25 |
1939443 | 1939443 | 2021-11-21 | Polk | Tennessee | 47139 | 3231 | 31 |
1939444 | 1939444 | 2021-11-21 | Putnam | Tennessee | 47141 | 16957 | 223 |
1939445 | 1939445 | 2021-11-21 | Rhea | Tennessee | 47143 | 7067 | 97 |
1939446 | 1939446 | 2021-11-21 | Roane | Tennessee | 47145 | 10248 | 159 |
1939447 | 1939447 | 2021-11-21 | Robertson | Tennessee | 47147 | 14282 | 196 |
1939448 | 1939448 | 2021-11-21 | Rutherford | Tennessee | 47149 | 63136 | 574 |
1939449 | 1939449 | 2021-11-21 | Scott | Tennessee | 47151 | 5608 | 63 |
1939450 | 1939450 | 2021-11-21 | Sequatchie | Tennessee | 47153 | 3045 | 33 |
1939451 | 1939451 | 2021-11-21 | Sevier | Tennessee | 47155 | 20463 | 280 |
1939452 | 1939452 | 2021-11-21 | Shelby | Tennessee | 47157 | 148317 | 2307 |
1939453 | 1939453 | 2021-11-21 | Smith | Tennessee | 47159 | 4230 | 53 |
1939454 | 1939454 | 2021-11-21 | Stewart | Tennessee | 47161 | 2175 | 35 |
1939455 | 1939455 | 2021-11-21 | Sullivan | Tennessee | 47163 | 27710 | 439 |
1939456 | 1939456 | 2021-11-21 | Sumner | Tennessee | 47165 | 34924 | 426 |
1939457 | 1939457 | 2021-11-21 | Tipton | Tennessee | 47167 | 11593 | 140 |
1939458 | 1939458 | 2021-11-21 | Trousdale | Tennessee | 47169 | 3219 | 26 |
1939459 | 1939459 | 2021-11-21 | Unicoi | Tennessee | 47171 | 3211 | 65 |
1939460 | 1939460 | 2021-11-21 | Union | Tennessee | 47173 | 3372 | 50 |
1939461 | 1939461 | 2021-11-21 | Unknown | Tennessee | 8680 | 128 | |
1939462 | 1939462 | 2021-11-21 | Van Buren | Tennessee | 47175 | 1269 | 29 |
1939463 | 1939463 | 2021-11-21 | Warren | Tennessee | 47177 | 8764 | 128 |
1939464 | 1939464 | 2021-11-21 | Washington | Tennessee | 47179 | 22460 | 336 |
1939465 | 1939465 | 2021-11-21 | Wayne | Tennessee | 47181 | 4133 | 39 |
1939466 | 1939466 | 2021-11-21 | Weakley | Tennessee | 47183 | 6326 | 89 |
1939467 | 1939467 | 2021-11-21 | White | Tennessee | 47185 | 5709 | 98 |
1939468 | 1939468 | 2021-11-21 | Williamson | Tennessee | 47187 | 40479 | 276 |
1939469 | 1939469 | 2021-11-21 | Wilson | Tennessee | 47189 | 27558 | 343 |
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);