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-10-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 |
---|---|---|---|---|---|---|---|
1835388 | 1835388 | 2021-10-20 | Anderson | Tennessee | 47001 | 12819 | 215 |
1835389 | 1835389 | 2021-10-20 | Bedford | Tennessee | 47003 | 9084 | 154 |
1835390 | 1835390 | 2021-10-20 | Benton | Tennessee | 47005 | 2764 | 50 |
1835391 | 1835391 | 2021-10-20 | Bledsoe | Tennessee | 47007 | 3477 | 17 |
1835392 | 1835392 | 2021-10-20 | Blount | Tennessee | 47009 | 23542 | 265 |
1835393 | 1835393 | 2021-10-20 | Bradley | Tennessee | 47011 | 21975 | 190 |
1835394 | 1835394 | 2021-10-20 | Campbell | Tennessee | 47013 | 7142 | 79 |
1835395 | 1835395 | 2021-10-20 | Cannon | Tennessee | 47015 | 2784 | 40 |
1835396 | 1835396 | 2021-10-20 | Carroll | Tennessee | 47017 | 5699 | 102 |
1835397 | 1835397 | 2021-10-20 | Carter | Tennessee | 47019 | 10450 | 212 |
1835398 | 1835398 | 2021-10-20 | Cheatham | Tennessee | 47021 | 6965 | 70 |
1835399 | 1835399 | 2021-10-20 | Chester | Tennessee | 47023 | 3506 | 72 |
1835400 | 1835400 | 2021-10-20 | Claiborne | Tennessee | 47025 | 5372 | 110 |
1835401 | 1835401 | 2021-10-20 | Clay | Tennessee | 47027 | 1512 | 36 |
1835402 | 1835402 | 2021-10-20 | Cocke | Tennessee | 47029 | 7326 | 105 |
1835403 | 1835403 | 2021-10-20 | Coffee | Tennessee | 47031 | 10468 | 154 |
1835404 | 1835404 | 2021-10-20 | Crockett | Tennessee | 47033 | 3341 | 62 |
1835405 | 1835405 | 2021-10-20 | Cumberland | Tennessee | 47035 | 10982 | 216 |
1835406 | 1835406 | 2021-10-20 | Davidson | Tennessee | 47037 | 131623 | 1144 |
1835407 | 1835407 | 2021-10-20 | DeKalb | Tennessee | 47041 | 4169 | 69 |
1835408 | 1835408 | 2021-10-20 | Decatur | Tennessee | 47039 | 2412 | 44 |
1835409 | 1835409 | 2021-10-20 | Dickson | Tennessee | 47043 | 10315 | 163 |
1835410 | 1835410 | 2021-10-20 | Dyer | Tennessee | 47045 | 8057 | 143 |
1835411 | 1835411 | 2021-10-20 | Fayette | Tennessee | 47047 | 7257 | 105 |
1835412 | 1835412 | 2021-10-20 | Fentress | Tennessee | 47049 | 3603 | 65 |
1835413 | 1835413 | 2021-10-20 | Franklin | Tennessee | 47051 | 7877 | 100 |
1835414 | 1835414 | 2021-10-20 | Gibson | Tennessee | 47053 | 10606 | 188 |
1835415 | 1835415 | 2021-10-20 | Giles | Tennessee | 47055 | 6014 | 116 |
1835416 | 1835416 | 2021-10-20 | Grainger | Tennessee | 47057 | 4311 | 66 |
1835417 | 1835417 | 2021-10-20 | Greene | Tennessee | 47059 | 13483 | 238 |
1835418 | 1835418 | 2021-10-20 | Grundy | Tennessee | 47061 | 2800 | 37 |
1835419 | 1835419 | 2021-10-20 | Hamblen | Tennessee | 47063 | 12936 | 196 |
1835420 | 1835420 | 2021-10-20 | Hamilton | Tennessee | 47065 | 63549 | 646 |
1835421 | 1835421 | 2021-10-20 | Hancock | Tennessee | 47067 | 1201 | 20 |
1835422 | 1835422 | 2021-10-20 | Hardeman | Tennessee | 47069 | 5088 | 79 |
1835423 | 1835423 | 2021-10-20 | Hardin | Tennessee | 47071 | 5508 | 81 |
1835424 | 1835424 | 2021-10-20 | Hawkins | Tennessee | 47073 | 10114 | 167 |
1835425 | 1835425 | 2021-10-20 | Haywood | Tennessee | 47075 | 3792 | 75 |
1835426 | 1835426 | 2021-10-20 | Henderson | Tennessee | 47077 | 5708 | 99 |
1835427 | 1835427 | 2021-10-20 | Henry | Tennessee | 47079 | 5444 | 86 |
1835428 | 1835428 | 2021-10-20 | Hickman | Tennessee | 47081 | 4561 | 75 |
1835429 | 1835429 | 2021-10-20 | Houston | Tennessee | 47083 | 1832 | 43 |
1835430 | 1835430 | 2021-10-20 | Humphreys | Tennessee | 47085 | 3200 | 45 |
1835431 | 1835431 | 2021-10-20 | Jackson | Tennessee | 47087 | 2066 | 40 |
1835432 | 1835432 | 2021-10-20 | Jefferson | Tennessee | 47089 | 9853 | 142 |
1835433 | 1835433 | 2021-10-20 | Johnson | Tennessee | 47091 | 3509 | 48 |
1835434 | 1835434 | 2021-10-20 | Knox | Tennessee | 47093 | 77902 | 908 |
1835435 | 1835435 | 2021-10-20 | Lake | Tennessee | 47095 | 2012 | 31 |
1835436 | 1835436 | 2021-10-20 | Lauderdale | Tennessee | 47097 | 5195 | 63 |
1835437 | 1835437 | 2021-10-20 | Lawrence | Tennessee | 47099 | 9487 | 119 |
1835438 | 1835438 | 2021-10-20 | Lewis | Tennessee | 47101 | 2514 | 38 |
1835439 | 1835439 | 2021-10-20 | Lincoln | Tennessee | 47103 | 6618 | 83 |
1835440 | 1835440 | 2021-10-20 | Loudon | Tennessee | 47105 | 9059 | 95 |
1835441 | 1835441 | 2021-10-20 | Macon | Tennessee | 47111 | 5436 | 90 |
1835442 | 1835442 | 2021-10-20 | Madison | Tennessee | 47113 | 17508 | 309 |
1835443 | 1835443 | 2021-10-20 | Marion | Tennessee | 47115 | 5728 | 53 |
1835444 | 1835444 | 2021-10-20 | Marshall | Tennessee | 47117 | 6806 | 84 |
1835445 | 1835445 | 2021-10-20 | Maury | Tennessee | 47119 | 19251 | 227 |
1835446 | 1835446 | 2021-10-20 | McMinn | Tennessee | 47107 | 10443 | 128 |
1835447 | 1835447 | 2021-10-20 | McNairy | Tennessee | 47109 | 4577 | 68 |
1835448 | 1835448 | 2021-10-20 | Meigs | Tennessee | 47121 | 2163 | 28 |
1835449 | 1835449 | 2021-10-20 | Monroe | Tennessee | 47123 | 9630 | 122 |
1835450 | 1835450 | 2021-10-20 | Montgomery | Tennessee | 47125 | 32644 | 328 |
1835451 | 1835451 | 2021-10-20 | Moore | Tennessee | 47127 | 1427 | 22 |
1835452 | 1835452 | 2021-10-20 | Morgan | Tennessee | 47129 | 3766 | 47 |
1835453 | 1835453 | 2021-10-20 | Obion | Tennessee | 47131 | 6580 | 110 |
1835454 | 1835454 | 2021-10-20 | Overton | Tennessee | 47133 | 4763 | 79 |
1835455 | 1835455 | 2021-10-20 | Perry | Tennessee | 47135 | 1599 | 34 |
1835456 | 1835456 | 2021-10-20 | Pickett | Tennessee | 47137 | 1074 | 24 |
1835457 | 1835457 | 2021-10-20 | Polk | Tennessee | 47139 | 3169 | 29 |
1835458 | 1835458 | 2021-10-20 | Putnam | Tennessee | 47141 | 16599 | 218 |
1835459 | 1835459 | 2021-10-20 | Rhea | Tennessee | 47143 | 6928 | 92 |
1835460 | 1835460 | 2021-10-20 | Roane | Tennessee | 47145 | 9908 | 149 |
1835461 | 1835461 | 2021-10-20 | Robertson | Tennessee | 47147 | 13990 | 182 |
1835462 | 1835462 | 2021-10-20 | Rutherford | Tennessee | 47149 | 61367 | 537 |
1835463 | 1835463 | 2021-10-20 | Scott | Tennessee | 47151 | 5148 | 58 |
1835464 | 1835464 | 2021-10-20 | Sequatchie | Tennessee | 47153 | 2964 | 32 |
1835465 | 1835465 | 2021-10-20 | Sevier | Tennessee | 47155 | 19899 | 266 |
1835466 | 1835466 | 2021-10-20 | Shelby | Tennessee | 47157 | 144968 | 2220 |
1835467 | 1835467 | 2021-10-20 | Smith | Tennessee | 47159 | 4148 | 52 |
1835468 | 1835468 | 2021-10-20 | Stewart | Tennessee | 47161 | 2120 | 35 |
1835469 | 1835469 | 2021-10-20 | Sullivan | Tennessee | 47163 | 26464 | 414 |
1835470 | 1835470 | 2021-10-20 | Sumner | Tennessee | 47165 | 34034 | 405 |
1835471 | 1835471 | 2021-10-20 | Tipton | Tennessee | 47167 | 11269 | 127 |
1835472 | 1835472 | 2021-10-20 | Trousdale | Tennessee | 47169 | 3148 | 26 |
1835473 | 1835473 | 2021-10-20 | Unicoi | Tennessee | 47171 | 3121 | 65 |
1835474 | 1835474 | 2021-10-20 | Union | Tennessee | 47173 | 3077 | 46 |
1835475 | 1835475 | 2021-10-20 | Unknown | Tennessee | 8480 | 120 | |
1835476 | 1835476 | 2021-10-20 | Van Buren | Tennessee | 47175 | 1230 | 27 |
1835477 | 1835477 | 2021-10-20 | Warren | Tennessee | 47177 | 8544 | 117 |
1835478 | 1835478 | 2021-10-20 | Washington | Tennessee | 47179 | 21481 | 322 |
1835479 | 1835479 | 2021-10-20 | Wayne | Tennessee | 47181 | 4020 | 39 |
1835480 | 1835480 | 2021-10-20 | Weakley | Tennessee | 47183 | 6223 | 87 |
1835481 | 1835481 | 2021-10-20 | White | Tennessee | 47185 | 5581 | 95 |
1835482 | 1835482 | 2021-10-20 | Williamson | Tennessee | 47187 | 39395 | 268 |
1835483 | 1835483 | 2021-10-20 | Wilson | Tennessee | 47189 | 26913 | 332 |
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);