ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2021-09-10" 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 |
---|---|---|---|---|---|---|---|
1705433 | 1705433 | 2021-09-10 | Anderson | Tennessee | 47001 | 11107 | 185 |
1705434 | 1705434 | 2021-09-10 | Bedford | Tennessee | 47003 | 8056 | 136 |
1705435 | 1705435 | 2021-09-10 | Benton | Tennessee | 47005 | 2265 | 44 |
1705436 | 1705436 | 2021-09-10 | Bledsoe | Tennessee | 47007 | 3050 | 13 |
1705437 | 1705437 | 2021-09-10 | Blount | Tennessee | 47009 | 20285 | 218 |
1705438 | 1705438 | 2021-09-10 | Bradley | Tennessee | 47011 | 19716 | 164 |
1705439 | 1705439 | 2021-09-10 | Campbell | Tennessee | 47013 | 5422 | 68 |
1705440 | 1705440 | 2021-09-10 | Cannon | Tennessee | 47015 | 2450 | 36 |
1705441 | 1705441 | 2021-09-10 | Carroll | Tennessee | 47017 | 4856 | 91 |
1705442 | 1705442 | 2021-09-10 | Carter | Tennessee | 47019 | 9013 | 188 |
1705443 | 1705443 | 2021-09-10 | Cheatham | Tennessee | 47021 | 6111 | 58 |
1705444 | 1705444 | 2021-09-10 | Chester | Tennessee | 47023 | 3051 | 57 |
1705445 | 1705445 | 2021-09-10 | Claiborne | Tennessee | 47025 | 4333 | 80 |
1705446 | 1705446 | 2021-09-10 | Clay | Tennessee | 47027 | 1290 | 32 |
1705447 | 1705447 | 2021-09-10 | Cocke | Tennessee | 47029 | 6204 | 104 |
1705448 | 1705448 | 2021-09-10 | Coffee | Tennessee | 47031 | 9104 | 136 |
1705449 | 1705449 | 2021-09-10 | Crockett | Tennessee | 47033 | 3060 | 54 |
1705450 | 1705450 | 2021-09-10 | Cumberland | Tennessee | 47035 | 9470 | 168 |
1705451 | 1705451 | 2021-09-10 | Davidson | Tennessee | 47037 | 119511 | 1029 |
1705452 | 1705452 | 2021-09-10 | DeKalb | Tennessee | 47041 | 3757 | 59 |
1705453 | 1705453 | 2021-09-10 | Decatur | Tennessee | 47039 | 2138 | 41 |
1705454 | 1705454 | 2021-09-10 | Dickson | Tennessee | 47043 | 9004 | 136 |
1705455 | 1705455 | 2021-09-10 | Dyer | Tennessee | 47045 | 7360 | 119 |
1705456 | 1705456 | 2021-09-10 | Fayette | Tennessee | 47047 | 6585 | 93 |
1705457 | 1705457 | 2021-09-10 | Fentress | Tennessee | 47049 | 3084 | 50 |
1705458 | 1705458 | 2021-09-10 | Franklin | Tennessee | 47051 | 6966 | 94 |
1705459 | 1705459 | 2021-09-10 | Gibson | Tennessee | 47053 | 9471 | 169 |
1705460 | 1705460 | 2021-09-10 | Giles | Tennessee | 47055 | 5114 | 103 |
1705461 | 1705461 | 2021-09-10 | Grainger | Tennessee | 47057 | 3630 | 52 |
1705462 | 1705462 | 2021-09-10 | Greene | Tennessee | 47059 | 11119 | 187 |
1705463 | 1705463 | 2021-09-10 | Grundy | Tennessee | 47061 | 2344 | 36 |
1705464 | 1705464 | 2021-09-10 | Hamblen | Tennessee | 47063 | 11614 | 183 |
1705465 | 1705465 | 2021-09-10 | Hamilton | Tennessee | 47065 | 57877 | 578 |
1705466 | 1705466 | 2021-09-10 | Hancock | Tennessee | 47067 | 954 | 15 |
1705467 | 1705467 | 2021-09-10 | Hardeman | Tennessee | 47069 | 4623 | 70 |
1705468 | 1705468 | 2021-09-10 | Hardin | Tennessee | 47071 | 4888 | 71 |
1705469 | 1705469 | 2021-09-10 | Hawkins | Tennessee | 47073 | 8540 | 134 |
1705470 | 1705470 | 2021-09-10 | Haywood | Tennessee | 47075 | 3453 | 66 |
1705471 | 1705471 | 2021-09-10 | Henderson | Tennessee | 47077 | 4836 | 82 |
1705472 | 1705472 | 2021-09-10 | Henry | Tennessee | 47079 | 4835 | 76 |
1705473 | 1705473 | 2021-09-10 | Hickman | Tennessee | 47081 | 4063 | 53 |
1705474 | 1705474 | 2021-09-10 | Houston | Tennessee | 47083 | 1577 | 38 |
1705475 | 1705475 | 2021-09-10 | Humphreys | Tennessee | 47085 | 2632 | 37 |
1705476 | 1705476 | 2021-09-10 | Jackson | Tennessee | 47087 | 1768 | 37 |
1705477 | 1705477 | 2021-09-10 | Jefferson | Tennessee | 47089 | 8540 | 132 |
1705478 | 1705478 | 2021-09-10 | Johnson | Tennessee | 47091 | 3015 | 41 |
1705479 | 1705479 | 2021-09-10 | Knox | Tennessee | 47093 | 66798 | 734 |
1705480 | 1705480 | 2021-09-10 | Lake | Tennessee | 47095 | 1875 | 31 |
1705481 | 1705481 | 2021-09-10 | Lauderdale | Tennessee | 47097 | 4679 | 52 |
1705482 | 1705482 | 2021-09-10 | Lawrence | Tennessee | 47099 | 8167 | 106 |
1705483 | 1705483 | 2021-09-10 | Lewis | Tennessee | 47101 | 2316 | 30 |
1705484 | 1705484 | 2021-09-10 | Lincoln | Tennessee | 47103 | 5809 | 76 |
1705485 | 1705485 | 2021-09-10 | Loudon | Tennessee | 47105 | 7903 | 78 |
1705486 | 1705486 | 2021-09-10 | Macon | Tennessee | 47111 | 4799 | 81 |
1705487 | 1705487 | 2021-09-10 | Madison | Tennessee | 47113 | 15869 | 274 |
1705488 | 1705488 | 2021-09-10 | Marion | Tennessee | 47115 | 5016 | 51 |
1705489 | 1705489 | 2021-09-10 | Marshall | Tennessee | 47117 | 6072 | 70 |
1705490 | 1705490 | 2021-09-10 | Maury | Tennessee | 47119 | 17344 | 192 |
1705491 | 1705491 | 2021-09-10 | McMinn | Tennessee | 47107 | 9093 | 112 |
1705492 | 1705492 | 2021-09-10 | McNairy | Tennessee | 47109 | 3984 | 61 |
1705493 | 1705493 | 2021-09-10 | Meigs | Tennessee | 47121 | 1888 | 24 |
1705494 | 1705494 | 2021-09-10 | Monroe | Tennessee | 47123 | 8388 | 106 |
1705495 | 1705495 | 2021-09-10 | Montgomery | Tennessee | 47125 | 28295 | 248 |
1705496 | 1705496 | 2021-09-10 | Moore | Tennessee | 47127 | 1264 | 19 |
1705497 | 1705497 | 2021-09-10 | Morgan | Tennessee | 47129 | 3204 | 41 |
1705498 | 1705498 | 2021-09-10 | Obion | Tennessee | 47131 | 5808 | 101 |
1705499 | 1705499 | 2021-09-10 | Overton | Tennessee | 47133 | 4068 | 65 |
1705500 | 1705500 | 2021-09-10 | Perry | Tennessee | 47135 | 1385 | 31 |
1705501 | 1705501 | 2021-09-10 | Pickett | Tennessee | 47137 | 921 | 24 |
1705502 | 1705502 | 2021-09-10 | Polk | Tennessee | 47139 | 2759 | 25 |
1705503 | 1705503 | 2021-09-10 | Putnam | Tennessee | 47141 | 14650 | 190 |
1705504 | 1705504 | 2021-09-10 | Rhea | Tennessee | 47143 | 5980 | 86 |
1705505 | 1705505 | 2021-09-10 | Roane | Tennessee | 47145 | 8574 | 126 |
1705506 | 1705506 | 2021-09-10 | Robertson | Tennessee | 47147 | 12509 | 160 |
1705507 | 1705507 | 2021-09-10 | Rutherford | Tennessee | 47149 | 55172 | 478 |
1705508 | 1705508 | 2021-09-10 | Scott | Tennessee | 47151 | 4080 | 51 |
1705509 | 1705509 | 2021-09-10 | Sequatchie | Tennessee | 47153 | 2547 | 30 |
1705510 | 1705510 | 2021-09-10 | Sevier | Tennessee | 47155 | 17351 | 204 |
1705511 | 1705511 | 2021-09-10 | Shelby | Tennessee | 47157 | 132734 | 1937 |
1705512 | 1705512 | 2021-09-10 | Smith | Tennessee | 47159 | 3694 | 42 |
1705513 | 1705513 | 2021-09-10 | Stewart | Tennessee | 47161 | 1773 | 28 |
1705514 | 1705514 | 2021-09-10 | Sullivan | Tennessee | 47163 | 22746 | 356 |
1705515 | 1705515 | 2021-09-10 | Sumner | Tennessee | 47165 | 31121 | 388 |
1705516 | 1705516 | 2021-09-10 | Tipton | Tennessee | 47167 | 10165 | 115 |
1705517 | 1705517 | 2021-09-10 | Trousdale | Tennessee | 47169 | 2877 | 23 |
1705518 | 1705518 | 2021-09-10 | Unicoi | Tennessee | 47171 | 2707 | 56 |
1705519 | 1705519 | 2021-09-10 | Union | Tennessee | 47173 | 2499 | 37 |
1705520 | 1705520 | 2021-09-10 | Unknown | Tennessee | 6665 | 100 | |
1705521 | 1705521 | 2021-09-10 | Van Buren | Tennessee | 47175 | 1043 | 24 |
1705522 | 1705522 | 2021-09-10 | Warren | Tennessee | 47177 | 7362 | 94 |
1705523 | 1705523 | 2021-09-10 | Washington | Tennessee | 47179 | 19021 | 280 |
1705524 | 1705524 | 2021-09-10 | Wayne | Tennessee | 47181 | 3639 | 37 |
1705525 | 1705525 | 2021-09-10 | Weakley | Tennessee | 47183 | 5383 | 74 |
1705526 | 1705526 | 2021-09-10 | White | Tennessee | 47185 | 4808 | 82 |
1705527 | 1705527 | 2021-09-10 | Williamson | Tennessee | 47187 | 35818 | 246 |
1705528 | 1705528 | 2021-09-10 | Wilson | Tennessee | 47189 | 24355 | 289 |
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);