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 2020-10-24 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
663372 | 663372 | 2020-10-24 | Anderson | Tennessee | 47001 | 1666 | 14 |
663373 | 663373 | 2020-10-24 | Bedford | Tennessee | 47003 | 1681 | 20 |
663374 | 663374 | 2020-10-24 | Benton | Tennessee | 47005 | 413 | 9 |
663375 | 663375 | 2020-10-24 | Bledsoe | Tennessee | 47007 | 1011 | 4 |
663376 | 663376 | 2020-10-24 | Blount | Tennessee | 47009 | 3309 | 36 |
663377 | 663377 | 2020-10-24 | Bradley | Tennessee | 47011 | 3558 | 23 |
663378 | 663378 | 2020-10-24 | Campbell | Tennessee | 47013 | 1000 | 11 |
663379 | 663379 | 2020-10-24 | Cannon | Tennessee | 47015 | 408 | 2 |
663380 | 663380 | 2020-10-24 | Carroll | Tennessee | 47017 | 1130 | 25 |
663381 | 663381 | 2020-10-24 | Carter | Tennessee | 47019 | 1529 | 32 |
663382 | 663382 | 2020-10-24 | Cheatham | Tennessee | 47021 | 1041 | 11 |
663383 | 663383 | 2020-10-24 | Chester | Tennessee | 47023 | 725 | 14 |
663384 | 663384 | 2020-10-24 | Claiborne | Tennessee | 47025 | 518 | 6 |
663385 | 663385 | 2020-10-24 | Clay | Tennessee | 47027 | 401 | 13 |
663386 | 663386 | 2020-10-24 | Cocke | Tennessee | 47029 | 1035 | 14 |
663387 | 663387 | 2020-10-24 | Coffee | Tennessee | 47031 | 1853 | 23 |
663388 | 663388 | 2020-10-24 | Crockett | Tennessee | 47033 | 833 | 20 |
663389 | 663389 | 2020-10-24 | Cumberland | Tennessee | 47035 | 1595 | 25 |
663390 | 663390 | 2020-10-24 | Davidson | Tennessee | 47037 | 33016 | 336 |
663391 | 663391 | 2020-10-24 | DeKalb | Tennessee | 47041 | 725 | 17 |
663392 | 663392 | 2020-10-24 | Decatur | Tennessee | 47039 | 655 | 11 |
663393 | 663393 | 2020-10-24 | Dickson | Tennessee | 47043 | 1648 | 19 |
663394 | 663394 | 2020-10-24 | Dyer | Tennessee | 47045 | 2189 | 30 |
663395 | 663395 | 2020-10-24 | Fayette | Tennessee | 47047 | 1667 | 23 |
663396 | 663396 | 2020-10-24 | Fentress | Tennessee | 47049 | 908 | 11 |
663397 | 663397 | 2020-10-24 | Franklin | Tennessee | 47051 | 1278 | 19 |
663398 | 663398 | 2020-10-24 | Gibson | Tennessee | 47053 | 2130 | 43 |
663399 | 663399 | 2020-10-24 | Giles | Tennessee | 47055 | 951 | 35 |
663400 | 663400 | 2020-10-24 | Grainger | Tennessee | 47057 | 603 | 4 |
663401 | 663401 | 2020-10-24 | Greene | Tennessee | 47059 | 1684 | 51 |
663402 | 663402 | 2020-10-24 | Grundy | Tennessee | 47061 | 553 | 11 |
663403 | 663403 | 2020-10-24 | Hamblen | Tennessee | 47063 | 2445 | 48 |
663404 | 663404 | 2020-10-24 | Hamilton | Tennessee | 47065 | 11860 | 108 |
663405 | 663405 | 2020-10-24 | Hancock | Tennessee | 47067 | 117 | 3 |
663406 | 663406 | 2020-10-24 | Hardeman | Tennessee | 47069 | 1864 | 33 |
663407 | 663407 | 2020-10-24 | Hardin | Tennessee | 47071 | 1379 | 19 |
663408 | 663408 | 2020-10-24 | Hawkins | Tennessee | 47073 | 1188 | 25 |
663409 | 663409 | 2020-10-24 | Haywood | Tennessee | 47075 | 1272 | 27 |
663410 | 663410 | 2020-10-24 | Henderson | Tennessee | 47077 | 1402 | 26 |
663411 | 663411 | 2020-10-24 | Henry | Tennessee | 47079 | 781 | 10 |
663412 | 663412 | 2020-10-24 | Hickman | Tennessee | 47081 | 779 | 15 |
663413 | 663413 | 2020-10-24 | Houston | Tennessee | 47083 | 409 | 17 |
663414 | 663414 | 2020-10-24 | Humphreys | Tennessee | 47085 | 440 | 4 |
663415 | 663415 | 2020-10-24 | Jackson | Tennessee | 47087 | 452 | 5 |
663416 | 663416 | 2020-10-24 | Jefferson | Tennessee | 47089 | 1537 | 20 |
663417 | 663417 | 2020-10-24 | Johnson | Tennessee | 47091 | 1132 | 7 |
663418 | 663418 | 2020-10-24 | Knox | Tennessee | 47093 | 12932 | 99 |
663419 | 663419 | 2020-10-24 | Lake | Tennessee | 47095 | 983 | 3 |
663420 | 663420 | 2020-10-24 | Lauderdale | Tennessee | 47097 | 1423 | 17 |
663421 | 663421 | 2020-10-24 | Lawrence | Tennessee | 47099 | 1587 | 19 |
663422 | 663422 | 2020-10-24 | Lewis | Tennessee | 47101 | 385 | 2 |
663423 | 663423 | 2020-10-24 | Lincoln | Tennessee | 47103 | 880 | 3 |
663424 | 663424 | 2020-10-24 | Loudon | Tennessee | 47105 | 1612 | 11 |
663425 | 663425 | 2020-10-24 | Macon | Tennessee | 47111 | 1324 | 25 |
663426 | 663426 | 2020-10-24 | Madison | Tennessee | 47113 | 3740 | 79 |
663427 | 663427 | 2020-10-24 | Marion | Tennessee | 47115 | 747 | 9 |
663428 | 663428 | 2020-10-24 | Marshall | Tennessee | 47117 | 1126 | 9 |
663429 | 663429 | 2020-10-24 | Maury | Tennessee | 47119 | 3218 | 37 |
663430 | 663430 | 2020-10-24 | McMinn | Tennessee | 47107 | 1615 | 35 |
663431 | 663431 | 2020-10-24 | McNairy | Tennessee | 47109 | 1112 | 27 |
663432 | 663432 | 2020-10-24 | Meigs | Tennessee | 47121 | 307 | 6 |
663433 | 663433 | 2020-10-24 | Monroe | Tennessee | 47123 | 1443 | 28 |
663434 | 663434 | 2020-10-24 | Montgomery | Tennessee | 47125 | 4115 | 55 |
663435 | 663435 | 2020-10-24 | Moore | Tennessee | 47127 | 265 | 2 |
663436 | 663436 | 2020-10-24 | Morgan | Tennessee | 47129 | 435 | 7 |
663437 | 663437 | 2020-10-24 | Obion | Tennessee | 47131 | 1741 | 21 |
663438 | 663438 | 2020-10-24 | Overton | Tennessee | 47133 | 1213 | 16 |
663439 | 663439 | 2020-10-24 | Perry | Tennessee | 47135 | 291 | 2 |
663440 | 663440 | 2020-10-24 | Pickett | Tennessee | 47137 | 272 | 7 |
663441 | 663441 | 2020-10-24 | Polk | Tennessee | 47139 | 503 | 13 |
663442 | 663442 | 2020-10-24 | Putnam | Tennessee | 47141 | 4403 | 56 |
663443 | 663443 | 2020-10-24 | Rhea | Tennessee | 47143 | 1093 | 17 |
663444 | 663444 | 2020-10-24 | Roane | Tennessee | 47145 | 1285 | 7 |
663445 | 663445 | 2020-10-24 | Robertson | Tennessee | 47147 | 2589 | 41 |
663446 | 663446 | 2020-10-24 | Rutherford | Tennessee | 47149 | 11611 | 112 |
663447 | 663447 | 2020-10-24 | Scott | Tennessee | 47151 | 374 | 5 |
663448 | 663448 | 2020-10-24 | Sequatchie | Tennessee | 47153 | 342 | 2 |
663449 | 663449 | 2020-10-24 | Sevier | Tennessee | 47155 | 3328 | 21 |
663450 | 663450 | 2020-10-24 | Shelby | Tennessee | 47157 | 35901 | 563 |
663451 | 663451 | 2020-10-24 | Smith | Tennessee | 47159 | 984 | 13 |
663452 | 663452 | 2020-10-24 | Stewart | Tennessee | 47161 | 320 | 10 |
663453 | 663453 | 2020-10-24 | Sullivan | Tennessee | 47163 | 3653 | 46 |
663454 | 663454 | 2020-10-24 | Sumner | Tennessee | 47165 | 5948 | 109 |
663455 | 663455 | 2020-10-24 | Tipton | Tennessee | 47167 | 2322 | 22 |
663456 | 663456 | 2020-10-24 | Trousdale | Tennessee | 47169 | 1768 | 7 |
663457 | 663457 | 2020-10-24 | Unicoi | Tennessee | 47171 | 404 | 3 |
663458 | 663458 | 2020-10-24 | Union | Tennessee | 47173 | 538 | 3 |
663459 | 663459 | 2020-10-24 | Unknown | Tennessee | 382 | 0 | |
663460 | 663460 | 2020-10-24 | Van Buren | Tennessee | 47175 | 205 | 1 |
663461 | 663461 | 2020-10-24 | Warren | Tennessee | 47177 | 1425 | 10 |
663462 | 663462 | 2020-10-24 | Washington | Tennessee | 47179 | 3388 | 50 |
663463 | 663463 | 2020-10-24 | Wayne | Tennessee | 47181 | 1591 | 7 |
663464 | 663464 | 2020-10-24 | Weakley | Tennessee | 47183 | 1523 | 25 |
663465 | 663465 | 2020-10-24 | White | Tennessee | 47185 | 1175 | 14 |
663466 | 663466 | 2020-10-24 | Williamson | Tennessee | 47187 | 6971 | 56 |
663467 | 663467 | 2020-10-24 | Wilson | Tennessee | 47189 | 4629 | 56 |
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);