ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where "date" is on date 2020-08-22 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
459338 | 459338 | 2020-08-22 | Anderson | Tennessee | 47001 | 828 | 8 |
459339 | 459339 | 2020-08-22 | Bedford | Tennessee | 47003 | 1037 | 14 |
459340 | 459340 | 2020-08-22 | Benton | Tennessee | 47005 | 214 | 3 |
459341 | 459341 | 2020-08-22 | Bledsoe | Tennessee | 47007 | 763 | 3 |
459342 | 459342 | 2020-08-22 | Blount | Tennessee | 47009 | 1715 | 15 |
459343 | 459343 | 2020-08-22 | Bradley | Tennessee | 47011 | 2306 | 16 |
459344 | 459344 | 2020-08-22 | Campbell | Tennessee | 47013 | 295 | 2 |
459345 | 459345 | 2020-08-22 | Cannon | Tennessee | 47015 | 180 | 0 |
459346 | 459346 | 2020-08-22 | Carroll | Tennessee | 47017 | 482 | 6 |
459347 | 459347 | 2020-08-22 | Carter | Tennessee | 47019 | 711 | 14 |
459348 | 459348 | 2020-08-22 | Cheatham | Tennessee | 47021 | 688 | 10 |
459349 | 459349 | 2020-08-22 | Chester | Tennessee | 47023 | 325 | 4 |
459350 | 459350 | 2020-08-22 | Claiborne | Tennessee | 47025 | 338 | 2 |
459351 | 459351 | 2020-08-22 | Clay | Tennessee | 47027 | 99 | 0 |
459352 | 459352 | 2020-08-22 | Cocke | Tennessee | 47029 | 591 | 6 |
459353 | 459353 | 2020-08-22 | Coffee | Tennessee | 47031 | 675 | 5 |
459354 | 459354 | 2020-08-22 | Crockett | Tennessee | 47033 | 349 | 12 |
459355 | 459355 | 2020-08-22 | Cumberland | Tennessee | 47035 | 688 | 7 |
459356 | 459356 | 2020-08-22 | Davidson | Tennessee | 47037 | 25144 | 245 |
459357 | 459357 | 2020-08-22 | DeKalb | Tennessee | 47041 | 412 | 5 |
459358 | 459358 | 2020-08-22 | Decatur | Tennessee | 47039 | 267 | 4 |
459359 | 459359 | 2020-08-22 | Dickson | Tennessee | 47043 | 832 | 7 |
459360 | 459360 | 2020-08-22 | Dyer | Tennessee | 47045 | 829 | 9 |
459361 | 459361 | 2020-08-22 | Fayette | Tennessee | 47047 | 806 | 10 |
459362 | 459362 | 2020-08-22 | Fentress | Tennessee | 47049 | 142 | 0 |
459363 | 459363 | 2020-08-22 | Franklin | Tennessee | 47051 | 417 | 4 |
459364 | 459364 | 2020-08-22 | Gibson | Tennessee | 47053 | 969 | 12 |
459365 | 459365 | 2020-08-22 | Giles | Tennessee | 47055 | 427 | 14 |
459366 | 459366 | 2020-08-22 | Grainger | Tennessee | 47057 | 244 | 1 |
459367 | 459367 | 2020-08-22 | Greene | Tennessee | 47059 | 712 | 10 |
459368 | 459368 | 2020-08-22 | Grundy | Tennessee | 47061 | 139 | 2 |
459369 | 459369 | 2020-08-22 | Hamblen | Tennessee | 47063 | 1564 | 18 |
459370 | 459370 | 2020-08-22 | Hamilton | Tennessee | 47065 | 7373 | 63 |
459371 | 459371 | 2020-08-22 | Hancock | Tennessee | 47067 | 88 | 2 |
459372 | 459372 | 2020-08-22 | Hardeman | Tennessee | 47069 | 1167 | 22 |
459373 | 459373 | 2020-08-22 | Hardin | Tennessee | 47071 | 592 | 8 |
459374 | 459374 | 2020-08-22 | Hawkins | Tennessee | 47073 | 629 | 12 |
459375 | 459375 | 2020-08-22 | Haywood | Tennessee | 47075 | 686 | 10 |
459376 | 459376 | 2020-08-22 | Henderson | Tennessee | 47077 | 778 | 6 |
459377 | 459377 | 2020-08-22 | Henry | Tennessee | 47079 | 391 | 4 |
459378 | 459378 | 2020-08-22 | Hickman | Tennessee | 47081 | 328 | 1 |
459379 | 459379 | 2020-08-22 | Houston | Tennessee | 47083 | 71 | 0 |
459380 | 459380 | 2020-08-22 | Humphreys | Tennessee | 47085 | 150 | 3 |
459381 | 459381 | 2020-08-22 | Jackson | Tennessee | 47087 | 188 | 1 |
459382 | 459382 | 2020-08-22 | Jefferson | Tennessee | 47089 | 688 | 5 |
459383 | 459383 | 2020-08-22 | Johnson | Tennessee | 47091 | 384 | 1 |
459384 | 459384 | 2020-08-22 | Knox | Tennessee | 47093 | 6029 | 53 |
459385 | 459385 | 2020-08-22 | Lake | Tennessee | 47095 | 815 | 1 |
459386 | 459386 | 2020-08-22 | Lauderdale | Tennessee | 47097 | 621 | 12 |
459387 | 459387 | 2020-08-22 | Lawrence | Tennessee | 47099 | 694 | 8 |
459388 | 459388 | 2020-08-22 | Lewis | Tennessee | 47101 | 117 | 1 |
459389 | 459389 | 2020-08-22 | Lincoln | Tennessee | 47103 | 379 | 1 |
459390 | 459390 | 2020-08-22 | Loudon | Tennessee | 47105 | 862 | 3 |
459391 | 459391 | 2020-08-22 | Macon | Tennessee | 47111 | 879 | 14 |
459392 | 459392 | 2020-08-22 | Madison | Tennessee | 47113 | 1533 | 31 |
459393 | 459393 | 2020-08-22 | Marion | Tennessee | 47115 | 289 | 5 |
459394 | 459394 | 2020-08-22 | Marshall | Tennessee | 47117 | 443 | 4 |
459395 | 459395 | 2020-08-22 | Maury | Tennessee | 47119 | 1540 | 11 |
459396 | 459396 | 2020-08-22 | McMinn | Tennessee | 47107 | 695 | 20 |
459397 | 459397 | 2020-08-22 | McNairy | Tennessee | 47109 | 482 | 7 |
459398 | 459398 | 2020-08-22 | Meigs | Tennessee | 47121 | 134 | 2 |
459399 | 459399 | 2020-08-22 | Monroe | Tennessee | 47123 | 591 | 10 |
459400 | 459400 | 2020-08-22 | Montgomery | Tennessee | 47125 | 2294 | 24 |
459401 | 459401 | 2020-08-22 | Moore | Tennessee | 47127 | 82 | 0 |
459402 | 459402 | 2020-08-22 | Morgan | Tennessee | 47129 | 176 | 1 |
459403 | 459403 | 2020-08-22 | Obion | Tennessee | 47131 | 735 | 5 |
459404 | 459404 | 2020-08-22 | Overton | Tennessee | 47133 | 347 | 1 |
459405 | 459405 | 2020-08-22 | Perry | Tennessee | 47135 | 96 | 0 |
459406 | 459406 | 2020-08-22 | Pickett | Tennessee | 47137 | 45 | 1 |
459407 | 459407 | 2020-08-22 | Polk | Tennessee | 47139 | 298 | 10 |
459408 | 459408 | 2020-08-22 | Putnam | Tennessee | 47141 | 2121 | 23 |
459409 | 459409 | 2020-08-22 | Rhea | Tennessee | 47143 | 612 | 2 |
459410 | 459410 | 2020-08-22 | Roane | Tennessee | 47145 | 581 | 2 |
459411 | 459411 | 2020-08-22 | Robertson | Tennessee | 47147 | 1732 | 25 |
459412 | 459412 | 2020-08-22 | Rutherford | Tennessee | 47149 | 7404 | 64 |
459413 | 459413 | 2020-08-22 | Scott | Tennessee | 47151 | 153 | 2 |
459414 | 459414 | 2020-08-22 | Sequatchie | Tennessee | 47153 | 135 | 1 |
459415 | 459415 | 2020-08-22 | Sevier | Tennessee | 47155 | 2140 | 11 |
459416 | 459416 | 2020-08-22 | Shelby | Tennessee | 47157 | 26030 | 364 |
459417 | 459417 | 2020-08-22 | Smith | Tennessee | 47159 | 498 | 8 |
459418 | 459418 | 2020-08-22 | Stewart | Tennessee | 47161 | 89 | 0 |
459419 | 459419 | 2020-08-22 | Sullivan | Tennessee | 47163 | 1437 | 22 |
459420 | 459420 | 2020-08-22 | Sumner | Tennessee | 47165 | 3846 | 82 |
459421 | 459421 | 2020-08-22 | Tipton | Tennessee | 47167 | 1309 | 13 |
459422 | 459422 | 2020-08-22 | Trousdale | Tennessee | 47169 | 1592 | 6 |
459423 | 459423 | 2020-08-22 | Unicoi | Tennessee | 47171 | 207 | 1 |
459424 | 459424 | 2020-08-22 | Union | Tennessee | 47173 | 201 | 0 |
459425 | 459425 | 2020-08-22 | Van Buren | Tennessee | 47175 | 51 | 0 |
459426 | 459426 | 2020-08-22 | Warren | Tennessee | 47177 | 704 | 7 |
459427 | 459427 | 2020-08-22 | Washington | Tennessee | 47179 | 1555 | 6 |
459428 | 459428 | 2020-08-22 | Wayne | Tennessee | 47181 | 253 | 2 |
459429 | 459429 | 2020-08-22 | Weakley | Tennessee | 47183 | 703 | 7 |
459430 | 459430 | 2020-08-22 | White | Tennessee | 47185 | 413 | 7 |
459431 | 459431 | 2020-08-22 | Williamson | Tennessee | 47187 | 4096 | 27 |
459432 | 459432 | 2020-08-22 | Wilson | Tennessee | 47189 | 2627 | 29 |
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);