ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2021-11-09" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1900376 | 1900376 | 2021-11-09 | Anderson | Tennessee | 47001 | 13180 | 223 |
1900377 | 1900377 | 2021-11-09 | Bedford | Tennessee | 47003 | 9288 | 158 |
1900378 | 1900378 | 2021-11-09 | Benton | Tennessee | 47005 | 2850 | 54 |
1900379 | 1900379 | 2021-11-09 | Bledsoe | Tennessee | 47007 | 3514 | 18 |
1900380 | 1900380 | 2021-11-09 | Blount | Tennessee | 47009 | 23951 | 270 |
1900381 | 1900381 | 2021-11-09 | Bradley | Tennessee | 47011 | 22319 | 203 |
1900382 | 1900382 | 2021-11-09 | Campbell | Tennessee | 47013 | 7351 | 87 |
1900383 | 1900383 | 2021-11-09 | Cannon | Tennessee | 47015 | 2809 | 43 |
1900384 | 1900384 | 2021-11-09 | Carroll | Tennessee | 47017 | 5811 | 105 |
1900385 | 1900385 | 2021-11-09 | Carter | Tennessee | 47019 | 10620 | 221 |
1900386 | 1900386 | 2021-11-09 | Cheatham | Tennessee | 47021 | 7051 | 75 |
1900387 | 1900387 | 2021-11-09 | Chester | Tennessee | 47023 | 3542 | 75 |
1900388 | 1900388 | 2021-11-09 | Claiborne | Tennessee | 47025 | 5508 | 114 |
1900389 | 1900389 | 2021-11-09 | Clay | Tennessee | 47027 | 1540 | 37 |
1900390 | 1900390 | 2021-11-09 | Cocke | Tennessee | 47029 | 7472 | 108 |
1900391 | 1900391 | 2021-11-09 | Coffee | Tennessee | 47031 | 10657 | 162 |
1900392 | 1900392 | 2021-11-09 | Crockett | Tennessee | 47033 | 3368 | 62 |
1900393 | 1900393 | 2021-11-09 | Cumberland | Tennessee | 47035 | 11205 | 226 |
1900394 | 1900394 | 2021-11-09 | Davidson | Tennessee | 47037 | 133486 | 1177 |
1900395 | 1900395 | 2021-11-09 | DeKalb | Tennessee | 47041 | 4233 | 75 |
1900396 | 1900396 | 2021-11-09 | Decatur | Tennessee | 47039 | 2456 | 44 |
1900397 | 1900397 | 2021-11-09 | Dickson | Tennessee | 47043 | 10541 | 167 |
1900398 | 1900398 | 2021-11-09 | Dyer | Tennessee | 47045 | 8125 | 146 |
1900399 | 1900399 | 2021-11-09 | Fayette | Tennessee | 47047 | 7350 | 108 |
1900400 | 1900400 | 2021-11-09 | Fentress | Tennessee | 47049 | 3714 | 67 |
1900401 | 1900401 | 2021-11-09 | Franklin | Tennessee | 47051 | 8024 | 102 |
1900402 | 1900402 | 2021-11-09 | Gibson | Tennessee | 47053 | 10720 | 190 |
1900403 | 1900403 | 2021-11-09 | Giles | Tennessee | 47055 | 6103 | 126 |
1900404 | 1900404 | 2021-11-09 | Grainger | Tennessee | 47057 | 4396 | 68 |
1900405 | 1900405 | 2021-11-09 | Greene | Tennessee | 47059 | 13892 | 246 |
1900406 | 1900406 | 2021-11-09 | Grundy | Tennessee | 47061 | 2883 | 39 |
1900407 | 1900407 | 2021-11-09 | Hamblen | Tennessee | 47063 | 13113 | 202 |
1900408 | 1900408 | 2021-11-09 | Hamilton | Tennessee | 47065 | 64473 | 658 |
1900409 | 1900409 | 2021-11-09 | Hancock | Tennessee | 47067 | 1229 | 20 |
1900410 | 1900410 | 2021-11-09 | Hardeman | Tennessee | 47069 | 5151 | 82 |
1900411 | 1900411 | 2021-11-09 | Hardin | Tennessee | 47071 | 5584 | 83 |
1900412 | 1900412 | 2021-11-09 | Hawkins | Tennessee | 47073 | 10377 | 174 |
1900413 | 1900413 | 2021-11-09 | Haywood | Tennessee | 47075 | 3848 | 76 |
1900414 | 1900414 | 2021-11-09 | Henderson | Tennessee | 47077 | 5800 | 103 |
1900415 | 1900415 | 2021-11-09 | Henry | Tennessee | 47079 | 5505 | 87 |
1900416 | 1900416 | 2021-11-09 | Hickman | Tennessee | 47081 | 4642 | 78 |
1900417 | 1900417 | 2021-11-09 | Houston | Tennessee | 47083 | 1848 | 44 |
1900418 | 1900418 | 2021-11-09 | Humphreys | Tennessee | 47085 | 3282 | 47 |
1900419 | 1900419 | 2021-11-09 | Jackson | Tennessee | 47087 | 2093 | 40 |
1900420 | 1900420 | 2021-11-09 | Jefferson | Tennessee | 47089 | 10009 | 148 |
1900421 | 1900421 | 2021-11-09 | Johnson | Tennessee | 47091 | 3720 | 50 |
1900422 | 1900422 | 2021-11-09 | Knox | Tennessee | 47093 | 79328 | 938 |
1900423 | 1900423 | 2021-11-09 | Lake | Tennessee | 47095 | 2020 | 31 |
1900424 | 1900424 | 2021-11-09 | Lauderdale | Tennessee | 47097 | 5226 | 68 |
1900425 | 1900425 | 2021-11-09 | Lawrence | Tennessee | 47099 | 9620 | 125 |
1900426 | 1900426 | 2021-11-09 | Lewis | Tennessee | 47101 | 2542 | 40 |
1900427 | 1900427 | 2021-11-09 | Lincoln | Tennessee | 47103 | 6739 | 87 |
1900428 | 1900428 | 2021-11-09 | Loudon | Tennessee | 47105 | 9268 | 98 |
1900429 | 1900429 | 2021-11-09 | Macon | Tennessee | 47111 | 5487 | 93 |
1900430 | 1900430 | 2021-11-09 | Madison | Tennessee | 47113 | 17776 | 318 |
1900431 | 1900431 | 2021-11-09 | Marion | Tennessee | 47115 | 5818 | 55 |
1900432 | 1900432 | 2021-11-09 | Marshall | Tennessee | 47117 | 6893 | 88 |
1900433 | 1900433 | 2021-11-09 | Maury | Tennessee | 47119 | 19510 | 235 |
1900434 | 1900434 | 2021-11-09 | McMinn | Tennessee | 47107 | 10603 | 134 |
1900435 | 1900435 | 2021-11-09 | McNairy | Tennessee | 47109 | 4688 | 71 |
1900436 | 1900436 | 2021-11-09 | Meigs | Tennessee | 47121 | 2200 | 29 |
1900437 | 1900437 | 2021-11-09 | Monroe | Tennessee | 47123 | 9787 | 126 |
1900438 | 1900438 | 2021-11-09 | Montgomery | Tennessee | 47125 | 33111 | 344 |
1900439 | 1900439 | 2021-11-09 | Moore | Tennessee | 47127 | 1438 | 22 |
1900440 | 1900440 | 2021-11-09 | Morgan | Tennessee | 47129 | 3841 | 49 |
1900441 | 1900441 | 2021-11-09 | Obion | Tennessee | 47131 | 6685 | 110 |
1900442 | 1900442 | 2021-11-09 | Overton | Tennessee | 47133 | 4824 | 83 |
1900443 | 1900443 | 2021-11-09 | Perry | Tennessee | 47135 | 1625 | 34 |
1900444 | 1900444 | 2021-11-09 | Pickett | Tennessee | 47137 | 1090 | 24 |
1900445 | 1900445 | 2021-11-09 | Polk | Tennessee | 47139 | 3208 | 31 |
1900446 | 1900446 | 2021-11-09 | Putnam | Tennessee | 47141 | 16829 | 220 |
1900447 | 1900447 | 2021-11-09 | Rhea | Tennessee | 47143 | 7025 | 93 |
1900448 | 1900448 | 2021-11-09 | Roane | Tennessee | 47145 | 10118 | 154 |
1900449 | 1900449 | 2021-11-09 | Robertson | Tennessee | 47147 | 14171 | 195 |
1900450 | 1900450 | 2021-11-09 | Rutherford | Tennessee | 47149 | 62462 | 562 |
1900451 | 1900451 | 2021-11-09 | Scott | Tennessee | 47151 | 5393 | 61 |
1900452 | 1900452 | 2021-11-09 | Sequatchie | Tennessee | 47153 | 3031 | 33 |
1900453 | 1900453 | 2021-11-09 | Sevier | Tennessee | 47155 | 20252 | 277 |
1900454 | 1900454 | 2021-11-09 | Shelby | Tennessee | 47157 | 146718 | 2288 |
1900455 | 1900455 | 2021-11-09 | Smith | Tennessee | 47159 | 4187 | 53 |
1900456 | 1900456 | 2021-11-09 | Stewart | Tennessee | 47161 | 2157 | 35 |
1900457 | 1900457 | 2021-11-09 | Sullivan | Tennessee | 47163 | 27201 | 433 |
1900458 | 1900458 | 2021-11-09 | Sumner | Tennessee | 47165 | 34567 | 413 |
1900459 | 1900459 | 2021-11-09 | Tipton | Tennessee | 47167 | 11437 | 138 |
1900460 | 1900460 | 2021-11-09 | Trousdale | Tennessee | 47169 | 3185 | 26 |
1900461 | 1900461 | 2021-11-09 | Unicoi | Tennessee | 47171 | 3177 | 65 |
1900462 | 1900462 | 2021-11-09 | Union | Tennessee | 47173 | 3214 | 48 |
1900463 | 1900463 | 2021-11-09 | Unknown | Tennessee | 8713 | 125 | |
1900464 | 1900464 | 2021-11-09 | Van Buren | Tennessee | 47175 | 1256 | 28 |
1900465 | 1900465 | 2021-11-09 | Warren | Tennessee | 47177 | 8672 | 125 |
1900466 | 1900466 | 2021-11-09 | Washington | Tennessee | 47179 | 21944 | 331 |
1900467 | 1900467 | 2021-11-09 | Wayne | Tennessee | 47181 | 4082 | 39 |
1900468 | 1900468 | 2021-11-09 | Weakley | Tennessee | 47183 | 6284 | 89 |
1900469 | 1900469 | 2021-11-09 | White | Tennessee | 47185 | 5669 | 98 |
1900470 | 1900470 | 2021-11-09 | Williamson | Tennessee | 47187 | 40014 | 273 |
1900471 | 1900471 | 2021-11-09 | Wilson | Tennessee | 47189 | 27322 | 340 |
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);