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 2022-03-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 |
---|---|---|---|---|---|---|---|
2326324 | 2326324 | 2022-03-20 | Anderson | Tennessee | 47001 | 22027 | 317 |
2326325 | 2326325 | 2022-03-20 | Bedford | Tennessee | 47003 | 14917 | 228 |
2326326 | 2326326 | 2022-03-20 | Benton | Tennessee | 47005 | 4466 | 90 |
2326327 | 2326327 | 2022-03-20 | Bledsoe | Tennessee | 47007 | 4651 | 54 |
2326328 | 2326328 | 2022-03-20 | Blount | Tennessee | 47009 | 38990 | 413 |
2326329 | 2326329 | 2022-03-20 | Bradley | Tennessee | 47011 | 33047 | 399 |
2326330 | 2326330 | 2022-03-20 | Campbell | Tennessee | 47013 | 12127 | 157 |
2326331 | 2326331 | 2022-03-20 | Cannon | Tennessee | 47015 | 4181 | 57 |
2326332 | 2326332 | 2022-03-20 | Carroll | Tennessee | 47017 | 8926 | 155 |
2326333 | 2326333 | 2022-03-20 | Carter | Tennessee | 47019 | 16416 | 323 |
2326334 | 2326334 | 2022-03-20 | Cheatham | Tennessee | 47021 | 10883 | 118 |
2326335 | 2326335 | 2022-03-20 | Chester | Tennessee | 47023 | 5798 | 96 |
2326336 | 2326336 | 2022-03-20 | Claiborne | Tennessee | 47025 | 9070 | 175 |
2326337 | 2326337 | 2022-03-20 | Clay | Tennessee | 47027 | 2223 | 49 |
2326338 | 2326338 | 2022-03-20 | Cocke | Tennessee | 47029 | 11534 | 207 |
2326339 | 2326339 | 2022-03-20 | Coffee | Tennessee | 47031 | 16916 | 255 |
2326340 | 2326340 | 2022-03-20 | Crockett | Tennessee | 47033 | 5169 | 82 |
2326341 | 2326341 | 2022-03-20 | Cumberland | Tennessee | 47035 | 16061 | 319 |
2326342 | 2326342 | 2022-03-20 | Davidson | Tennessee | 47037 | 206615 | 1623 |
2326343 | 2326343 | 2022-03-20 | DeKalb | Tennessee | 47041 | 6272 | 99 |
2326344 | 2326344 | 2022-03-20 | Decatur | Tennessee | 47039 | 3725 | 67 |
2326345 | 2326345 | 2022-03-20 | Dickson | Tennessee | 47043 | 15842 | 239 |
2326346 | 2326346 | 2022-03-20 | Dyer | Tennessee | 47045 | 12737 | 198 |
2326347 | 2326347 | 2022-03-20 | Fayette | Tennessee | 47047 | 11393 | 177 |
2326348 | 2326348 | 2022-03-20 | Fentress | Tennessee | 47049 | 5686 | 123 |
2326349 | 2326349 | 2022-03-20 | Franklin | Tennessee | 47051 | 12815 | 173 |
2326350 | 2326350 | 2022-03-20 | Gibson | Tennessee | 47053 | 17339 | 254 |
2326351 | 2326351 | 2022-03-20 | Giles | Tennessee | 47055 | 9390 | 185 |
2326352 | 2326352 | 2022-03-20 | Grainger | Tennessee | 47057 | 6754 | 106 |
2326353 | 2326353 | 2022-03-20 | Greene | Tennessee | 47059 | 21992 | 360 |
2326354 | 2326354 | 2022-03-20 | Grundy | Tennessee | 47061 | 3979 | 70 |
2326355 | 2326355 | 2022-03-20 | Hamblen | Tennessee | 47063 | 19671 | 346 |
2326356 | 2326356 | 2022-03-20 | Hamilton | Tennessee | 47065 | 99400 | 1113 |
2326357 | 2326357 | 2022-03-20 | Hancock | Tennessee | 47067 | 2001 | 34 |
2326358 | 2326358 | 2022-03-20 | Hardeman | Tennessee | 47069 | 7578 | 116 |
2326359 | 2326359 | 2022-03-20 | Hardin | Tennessee | 47071 | 8717 | 140 |
2326360 | 2326360 | 2022-03-20 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2326361 | 2326361 | 2022-03-20 | Haywood | Tennessee | 47075 | 6147 | 99 |
2326362 | 2326362 | 2022-03-20 | Henderson | Tennessee | 47077 | 9087 | 153 |
2326363 | 2326363 | 2022-03-20 | Henry | Tennessee | 47079 | 8237 | 154 |
2326364 | 2326364 | 2022-03-20 | Hickman | Tennessee | 47081 | 6811 | 108 |
2326365 | 2326365 | 2022-03-20 | Houston | Tennessee | 47083 | 2672 | 60 |
2326366 | 2326366 | 2022-03-20 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2326367 | 2326367 | 2022-03-20 | Jackson | Tennessee | 47087 | 3200 | 62 |
2326368 | 2326368 | 2022-03-20 | Jefferson | Tennessee | 47089 | 15674 | 257 |
2326369 | 2326369 | 2022-03-20 | Johnson | Tennessee | 47091 | 5132 | 88 |
2326370 | 2326370 | 2022-03-20 | Knox | Tennessee | 47093 | 127369 | 1318 |
2326371 | 2326371 | 2022-03-20 | Lake | Tennessee | 47095 | 2736 | 40 |
2326372 | 2326372 | 2022-03-20 | Lauderdale | Tennessee | 47097 | 7729 | 103 |
2326373 | 2326373 | 2022-03-20 | Lawrence | Tennessee | 47099 | 14249 | 190 |
2326374 | 2326374 | 2022-03-20 | Lewis | Tennessee | 47101 | 3568 | 56 |
2326375 | 2326375 | 2022-03-20 | Lincoln | Tennessee | 47103 | 9968 | 163 |
2326376 | 2326376 | 2022-03-20 | Loudon | Tennessee | 47105 | 14399 | 187 |
2326377 | 2326377 | 2022-03-20 | Macon | Tennessee | 47111 | 8417 | 142 |
2326378 | 2326378 | 2022-03-20 | Madison | Tennessee | 47113 | 29729 | 415 |
2326379 | 2326379 | 2022-03-20 | Marion | Tennessee | 47115 | 8821 | 127 |
2326380 | 2326380 | 2022-03-20 | Marshall | Tennessee | 47117 | 10343 | 117 |
2326381 | 2326381 | 2022-03-20 | Maury | Tennessee | 47119 | 28852 | 327 |
2326382 | 2326382 | 2022-03-20 | McMinn | Tennessee | 47107 | 16646 | 250 |
2326383 | 2326383 | 2022-03-20 | McNairy | Tennessee | 47109 | 7627 | 117 |
2326384 | 2326384 | 2022-03-20 | Meigs | Tennessee | 47121 | 3349 | 55 |
2326385 | 2326385 | 2022-03-20 | Monroe | Tennessee | 47123 | 14460 | 233 |
2326386 | 2326386 | 2022-03-20 | Montgomery | Tennessee | 47125 | 50043 | 556 |
2326387 | 2326387 | 2022-03-20 | Moore | Tennessee | 47127 | 2236 | 40 |
2326388 | 2326388 | 2022-03-20 | Morgan | Tennessee | 47129 | 6151 | 80 |
2326389 | 2326389 | 2022-03-20 | Obion | Tennessee | 47131 | 10750 | 185 |
2326390 | 2326390 | 2022-03-20 | Overton | Tennessee | 47133 | 7145 | 120 |
2326391 | 2326391 | 2022-03-20 | Perry | Tennessee | 47135 | 2327 | 54 |
2326392 | 2326392 | 2022-03-20 | Pickett | Tennessee | 47137 | 1764 | 36 |
2326393 | 2326393 | 2022-03-20 | Polk | Tennessee | 47139 | 4715 | 68 |
2326394 | 2326394 | 2022-03-20 | Putnam | Tennessee | 47141 | 25056 | 301 |
2326395 | 2326395 | 2022-03-20 | Rhea | Tennessee | 47143 | 9941 | 153 |
2326396 | 2326396 | 2022-03-20 | Roane | Tennessee | 47145 | 15740 | 228 |
2326397 | 2326397 | 2022-03-20 | Robertson | Tennessee | 47147 | 21488 | 295 |
2326398 | 2326398 | 2022-03-20 | Rutherford | Tennessee | 47149 | 95446 | 875 |
2326399 | 2326399 | 2022-03-20 | Scott | Tennessee | 47151 | 9018 | 112 |
2326400 | 2326400 | 2022-03-20 | Sequatchie | Tennessee | 47153 | 4200 | 66 |
2326401 | 2326401 | 2022-03-20 | Sevier | Tennessee | 47155 | 30214 | 398 |
2326402 | 2326402 | 2022-03-20 | Shelby | Tennessee | 47157 | 237407 | 3219 |
2326403 | 2326403 | 2022-03-20 | Smith | Tennessee | 47159 | 6159 | 80 |
2326404 | 2326404 | 2022-03-20 | Stewart | Tennessee | 47161 | 3281 | 55 |
2326405 | 2326405 | 2022-03-20 | Sullivan | Tennessee | 47163 | 45622 | 688 |
2326406 | 2326406 | 2022-03-20 | Sumner | Tennessee | 47165 | 53026 | 707 |
2326407 | 2326407 | 2022-03-20 | Tipton | Tennessee | 47167 | 17578 | 230 |
2326408 | 2326408 | 2022-03-20 | Trousdale | Tennessee | 47169 | 4208 | 45 |
2326409 | 2326409 | 2022-03-20 | Unicoi | Tennessee | 47171 | 5147 | 93 |
2326410 | 2326410 | 2022-03-20 | Union | Tennessee | 47173 | 5392 | 72 |
2326411 | 2326411 | 2022-03-20 | Unknown | Tennessee | 19364 | 423 | |
2326412 | 2326412 | 2022-03-20 | Van Buren | Tennessee | 47175 | 1845 | 47 |
2326413 | 2326413 | 2022-03-20 | Warren | Tennessee | 47177 | 12975 | 174 |
2326414 | 2326414 | 2022-03-20 | Washington | Tennessee | 47179 | 38408 | 482 |
2326415 | 2326415 | 2022-03-20 | Wayne | Tennessee | 47181 | 5682 | 62 |
2326416 | 2326416 | 2022-03-20 | Weakley | Tennessee | 47183 | 9489 | 140 |
2326417 | 2326417 | 2022-03-20 | White | Tennessee | 47185 | 8221 | 126 |
2326418 | 2326418 | 2022-03-20 | Williamson | Tennessee | 47187 | 61783 | 393 |
2326419 | 2326419 | 2022-03-20 | Wilson | Tennessee | 47189 | 41503 | 471 |
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);