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-09-26 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1757410 | 1757410 | 2021-09-26 | Anderson | Tennessee | 47001 | 12065 | 194 |
1757411 | 1757411 | 2021-09-26 | Bedford | Tennessee | 47003 | 8603 | 145 |
1757412 | 1757412 | 2021-09-26 | Benton | Tennessee | 47005 | 2565 | 44 |
1757413 | 1757413 | 2021-09-26 | Bledsoe | Tennessee | 47007 | 3281 | 13 |
1757414 | 1757414 | 2021-09-26 | Blount | Tennessee | 47009 | 22212 | 236 |
1757415 | 1757415 | 2021-09-26 | Bradley | Tennessee | 47011 | 21135 | 169 |
1757416 | 1757416 | 2021-09-26 | Campbell | Tennessee | 47013 | 6197 | 70 |
1757417 | 1757417 | 2021-09-26 | Cannon | Tennessee | 47015 | 2675 | 38 |
1757418 | 1757418 | 2021-09-26 | Carroll | Tennessee | 47017 | 5369 | 94 |
1757419 | 1757419 | 2021-09-26 | Carter | Tennessee | 47019 | 9853 | 203 |
1757420 | 1757420 | 2021-09-26 | Cheatham | Tennessee | 47021 | 6607 | 62 |
1757421 | 1757421 | 2021-09-26 | Chester | Tennessee | 47023 | 3333 | 66 |
1757422 | 1757422 | 2021-09-26 | Claiborne | Tennessee | 47025 | 4934 | 85 |
1757423 | 1757423 | 2021-09-26 | Clay | Tennessee | 47027 | 1415 | 35 |
1757424 | 1757424 | 2021-09-26 | Cocke | Tennessee | 47029 | 6786 | 104 |
1757425 | 1757425 | 2021-09-26 | Coffee | Tennessee | 47031 | 9931 | 142 |
1757426 | 1757426 | 2021-09-26 | Crockett | Tennessee | 47033 | 3219 | 59 |
1757427 | 1757427 | 2021-09-26 | Cumberland | Tennessee | 47035 | 10378 | 196 |
1757428 | 1757428 | 2021-09-26 | Davidson | Tennessee | 47037 | 126328 | 1083 |
1757429 | 1757429 | 2021-09-26 | DeKalb | Tennessee | 47041 | 3998 | 60 |
1757430 | 1757430 | 2021-09-26 | Decatur | Tennessee | 47039 | 2299 | 42 |
1757431 | 1757431 | 2021-09-26 | Dickson | Tennessee | 47043 | 9788 | 154 |
1757432 | 1757432 | 2021-09-26 | Dyer | Tennessee | 47045 | 7796 | 131 |
1757433 | 1757433 | 2021-09-26 | Fayette | Tennessee | 47047 | 6962 | 96 |
1757434 | 1757434 | 2021-09-26 | Fentress | Tennessee | 47049 | 3351 | 59 |
1757435 | 1757435 | 2021-09-26 | Franklin | Tennessee | 47051 | 7531 | 96 |
1757436 | 1757436 | 2021-09-26 | Gibson | Tennessee | 47053 | 10164 | 178 |
1757437 | 1757437 | 2021-09-26 | Giles | Tennessee | 47055 | 5558 | 107 |
1757438 | 1757438 | 2021-09-26 | Grainger | Tennessee | 47057 | 4024 | 57 |
1757439 | 1757439 | 2021-09-26 | Greene | Tennessee | 47059 | 12295 | 209 |
1757440 | 1757440 | 2021-09-26 | Grundy | Tennessee | 47061 | 2609 | 36 |
1757441 | 1757441 | 2021-09-26 | Hamblen | Tennessee | 47063 | 12414 | 185 |
1757442 | 1757442 | 2021-09-26 | Hamilton | Tennessee | 47065 | 60893 | 614 |
1757443 | 1757443 | 2021-09-26 | Hancock | Tennessee | 47067 | 1077 | 15 |
1757444 | 1757444 | 2021-09-26 | Hardeman | Tennessee | 47069 | 4913 | 76 |
1757445 | 1757445 | 2021-09-26 | Hardin | Tennessee | 47071 | 5258 | 78 |
1757446 | 1757446 | 2021-09-26 | Hawkins | Tennessee | 47073 | 9475 | 145 |
1757447 | 1757447 | 2021-09-26 | Haywood | Tennessee | 47075 | 3682 | 69 |
1757448 | 1757448 | 2021-09-26 | Henderson | Tennessee | 47077 | 5375 | 90 |
1757449 | 1757449 | 2021-09-26 | Henry | Tennessee | 47079 | 5220 | 79 |
1757450 | 1757450 | 2021-09-26 | Hickman | Tennessee | 47081 | 4384 | 65 |
1757451 | 1757451 | 2021-09-26 | Houston | Tennessee | 47083 | 1745 | 41 |
1757452 | 1757452 | 2021-09-26 | Humphreys | Tennessee | 47085 | 2936 | 43 |
1757453 | 1757453 | 2021-09-26 | Jackson | Tennessee | 47087 | 1939 | 38 |
1757454 | 1757454 | 2021-09-26 | Jefferson | Tennessee | 47089 | 9330 | 134 |
1757455 | 1757455 | 2021-09-26 | Johnson | Tennessee | 47091 | 3283 | 45 |
1757456 | 1757456 | 2021-09-26 | Knox | Tennessee | 47093 | 73389 | 822 |
1757457 | 1757457 | 2021-09-26 | Lake | Tennessee | 47095 | 1939 | 31 |
1757458 | 1757458 | 2021-09-26 | Lauderdale | Tennessee | 47097 | 5008 | 59 |
1757459 | 1757459 | 2021-09-26 | Lawrence | Tennessee | 47099 | 8980 | 109 |
1757460 | 1757460 | 2021-09-26 | Lewis | Tennessee | 47101 | 2442 | 33 |
1757461 | 1757461 | 2021-09-26 | Lincoln | Tennessee | 47103 | 6296 | 79 |
1757462 | 1757462 | 2021-09-26 | Loudon | Tennessee | 47105 | 8653 | 85 |
1757463 | 1757463 | 2021-09-26 | Macon | Tennessee | 47111 | 5207 | 85 |
1757464 | 1757464 | 2021-09-26 | Madison | Tennessee | 47113 | 16893 | 284 |
1757465 | 1757465 | 2021-09-26 | Marion | Tennessee | 47115 | 5461 | 52 |
1757466 | 1757466 | 2021-09-26 | Marshall | Tennessee | 47117 | 6503 | 74 |
1757467 | 1757467 | 2021-09-26 | Maury | Tennessee | 47119 | 18457 | 205 |
1757468 | 1757468 | 2021-09-26 | McMinn | Tennessee | 47107 | 9975 | 115 |
1757469 | 1757469 | 2021-09-26 | McNairy | Tennessee | 47109 | 4352 | 62 |
1757470 | 1757470 | 2021-09-26 | Meigs | Tennessee | 47121 | 2064 | 25 |
1757471 | 1757471 | 2021-09-26 | Monroe | Tennessee | 47123 | 9155 | 112 |
1757472 | 1757472 | 2021-09-26 | Montgomery | Tennessee | 47125 | 30837 | 302 |
1757473 | 1757473 | 2021-09-26 | Moore | Tennessee | 47127 | 1363 | 19 |
1757474 | 1757474 | 2021-09-26 | Morgan | Tennessee | 47129 | 3528 | 43 |
1757475 | 1757475 | 2021-09-26 | Obion | Tennessee | 47131 | 6272 | 105 |
1757476 | 1757476 | 2021-09-26 | Overton | Tennessee | 47133 | 4451 | 76 |
1757477 | 1757477 | 2021-09-26 | Perry | Tennessee | 47135 | 1516 | 31 |
1757478 | 1757478 | 2021-09-26 | Pickett | Tennessee | 47137 | 986 | 24 |
1757479 | 1757479 | 2021-09-26 | Polk | Tennessee | 47139 | 2984 | 25 |
1757480 | 1757480 | 2021-09-26 | Putnam | Tennessee | 47141 | 15982 | 206 |
1757481 | 1757481 | 2021-09-26 | Rhea | Tennessee | 47143 | 6578 | 89 |
1757482 | 1757482 | 2021-09-26 | Roane | Tennessee | 47145 | 9288 | 138 |
1757483 | 1757483 | 2021-09-26 | Robertson | Tennessee | 47147 | 13440 | 170 |
1757484 | 1757484 | 2021-09-26 | Rutherford | Tennessee | 47149 | 59040 | 502 |
1757485 | 1757485 | 2021-09-26 | Scott | Tennessee | 47151 | 4671 | 54 |
1757486 | 1757486 | 2021-09-26 | Sequatchie | Tennessee | 47153 | 2810 | 30 |
1757487 | 1757487 | 2021-09-26 | Sevier | Tennessee | 47155 | 18732 | 235 |
1757488 | 1757488 | 2021-09-26 | Shelby | Tennessee | 47157 | 140616 | 2045 |
1757489 | 1757489 | 2021-09-26 | Smith | Tennessee | 47159 | 3984 | 44 |
1757490 | 1757490 | 2021-09-26 | Stewart | Tennessee | 47161 | 1979 | 30 |
1757491 | 1757491 | 2021-09-26 | Sullivan | Tennessee | 47163 | 24861 | 384 |
1757492 | 1757492 | 2021-09-26 | Sumner | Tennessee | 47165 | 32739 | 395 |
1757493 | 1757493 | 2021-09-26 | Tipton | Tennessee | 47167 | 10792 | 124 |
1757494 | 1757494 | 2021-09-26 | Trousdale | Tennessee | 47169 | 3017 | 24 |
1757495 | 1757495 | 2021-09-26 | Unicoi | Tennessee | 47171 | 2973 | 56 |
1757496 | 1757496 | 2021-09-26 | Union | Tennessee | 47173 | 2777 | 40 |
1757497 | 1757497 | 2021-09-26 | Unknown | Tennessee | 7238 | 112 | |
1757498 | 1757498 | 2021-09-26 | Van Buren | Tennessee | 47175 | 1154 | 25 |
1757499 | 1757499 | 2021-09-26 | Warren | Tennessee | 47177 | 8075 | 101 |
1757500 | 1757500 | 2021-09-26 | Washington | Tennessee | 47179 | 20396 | 299 |
1757501 | 1757501 | 2021-09-26 | Wayne | Tennessee | 47181 | 3861 | 38 |
1757502 | 1757502 | 2021-09-26 | Weakley | Tennessee | 47183 | 5910 | 78 |
1757503 | 1757503 | 2021-09-26 | White | Tennessee | 47185 | 5272 | 85 |
1757504 | 1757504 | 2021-09-26 | Williamson | Tennessee | 47187 | 37785 | 254 |
1757505 | 1757505 | 2021-09-26 | Wilson | Tennessee | 47189 | 25825 | 312 |
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);