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-08-31 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
488424 | 488424 | 2020-08-31 | Anderson | Tennessee | 47001 | 874 | 8 |
488425 | 488425 | 2020-08-31 | Bedford | Tennessee | 47003 | 1114 | 14 |
488426 | 488426 | 2020-08-31 | Benton | Tennessee | 47005 | 257 | 5 |
488427 | 488427 | 2020-08-31 | Bledsoe | Tennessee | 47007 | 775 | 4 |
488428 | 488428 | 2020-08-31 | Blount | Tennessee | 47009 | 2010 | 17 |
488429 | 488429 | 2020-08-31 | Bradley | Tennessee | 47011 | 2473 | 16 |
488430 | 488430 | 2020-08-31 | Campbell | Tennessee | 47013 | 328 | 2 |
488431 | 488431 | 2020-08-31 | Cannon | Tennessee | 47015 | 200 | 0 |
488432 | 488432 | 2020-08-31 | Carroll | Tennessee | 47017 | 637 | 8 |
488433 | 488433 | 2020-08-31 | Carter | Tennessee | 47019 | 829 | 18 |
488434 | 488434 | 2020-08-31 | Cheatham | Tennessee | 47021 | 710 | 10 |
488435 | 488435 | 2020-08-31 | Chester | Tennessee | 47023 | 377 | 5 |
488436 | 488436 | 2020-08-31 | Claiborne | Tennessee | 47025 | 366 | 3 |
488437 | 488437 | 2020-08-31 | Clay | Tennessee | 47027 | 112 | 0 |
488438 | 488438 | 2020-08-31 | Cocke | Tennessee | 47029 | 642 | 7 |
488439 | 488439 | 2020-08-31 | Coffee | Tennessee | 47031 | 764 | 6 |
488440 | 488440 | 2020-08-31 | Crockett | Tennessee | 47033 | 403 | 14 |
488441 | 488441 | 2020-08-31 | Cumberland | Tennessee | 47035 | 826 | 8 |
488442 | 488442 | 2020-08-31 | Davidson | Tennessee | 47037 | 25975 | 259 |
488443 | 488443 | 2020-08-31 | DeKalb | Tennessee | 47041 | 469 | 5 |
488444 | 488444 | 2020-08-31 | Decatur | Tennessee | 47039 | 303 | 4 |
488445 | 488445 | 2020-08-31 | Dickson | Tennessee | 47043 | 913 | 9 |
488446 | 488446 | 2020-08-31 | Dyer | Tennessee | 47045 | 964 | 10 |
488447 | 488447 | 2020-08-31 | Fayette | Tennessee | 47047 | 886 | 10 |
488448 | 488448 | 2020-08-31 | Fentress | Tennessee | 47049 | 223 | 0 |
488449 | 488449 | 2020-08-31 | Franklin | Tennessee | 47051 | 492 | 4 |
488450 | 488450 | 2020-08-31 | Gibson | Tennessee | 47053 | 1115 | 14 |
488451 | 488451 | 2020-08-31 | Giles | Tennessee | 47055 | 442 | 14 |
488452 | 488452 | 2020-08-31 | Grainger | Tennessee | 47057 | 278 | 1 |
488453 | 488453 | 2020-08-31 | Greene | Tennessee | 47059 | 820 | 16 |
488454 | 488454 | 2020-08-31 | Grundy | Tennessee | 47061 | 149 | 2 |
488455 | 488455 | 2020-08-31 | Hamblen | Tennessee | 47063 | 1659 | 22 |
488456 | 488456 | 2020-08-31 | Hamilton | Tennessee | 47065 | 7998 | 75 |
488457 | 488457 | 2020-08-31 | Hancock | Tennessee | 47067 | 92 | 2 |
488458 | 488458 | 2020-08-31 | Hardeman | Tennessee | 47069 | 1238 | 21 |
488459 | 488459 | 2020-08-31 | Hardin | Tennessee | 47071 | 700 | 10 |
488460 | 488460 | 2020-08-31 | Hawkins | Tennessee | 47073 | 669 | 13 |
488461 | 488461 | 2020-08-31 | Haywood | Tennessee | 47075 | 744 | 11 |
488462 | 488462 | 2020-08-31 | Henderson | Tennessee | 47077 | 878 | 7 |
488463 | 488463 | 2020-08-31 | Henry | Tennessee | 47079 | 460 | 5 |
488464 | 488464 | 2020-08-31 | Hickman | Tennessee | 47081 | 376 | 3 |
488465 | 488465 | 2020-08-31 | Houston | Tennessee | 47083 | 93 | 0 |
488466 | 488466 | 2020-08-31 | Humphreys | Tennessee | 47085 | 168 | 3 |
488467 | 488467 | 2020-08-31 | Jackson | Tennessee | 47087 | 217 | 1 |
488468 | 488468 | 2020-08-31 | Jefferson | Tennessee | 47089 | 815 | 6 |
488469 | 488469 | 2020-08-31 | Johnson | Tennessee | 47091 | 407 | 1 |
488470 | 488470 | 2020-08-31 | Knox | Tennessee | 47093 | 6786 | 58 |
488471 | 488471 | 2020-08-31 | Lake | Tennessee | 47095 | 837 | 2 |
488472 | 488472 | 2020-08-31 | Lauderdale | Tennessee | 47097 | 725 | 12 |
488473 | 488473 | 2020-08-31 | Lawrence | Tennessee | 47099 | 762 | 9 |
488474 | 488474 | 2020-08-31 | Lewis | Tennessee | 47101 | 132 | 1 |
488475 | 488475 | 2020-08-31 | Lincoln | Tennessee | 47103 | 412 | 1 |
488476 | 488476 | 2020-08-31 | Loudon | Tennessee | 47105 | 952 | 3 |
488477 | 488477 | 2020-08-31 | Macon | Tennessee | 47111 | 906 | 15 |
488478 | 488478 | 2020-08-31 | Madison | Tennessee | 47113 | 1804 | 40 |
488479 | 488479 | 2020-08-31 | Marion | Tennessee | 47115 | 325 | 7 |
488480 | 488480 | 2020-08-31 | Marshall | Tennessee | 47117 | 533 | 4 |
488481 | 488481 | 2020-08-31 | Maury | Tennessee | 47119 | 1749 | 15 |
488482 | 488482 | 2020-08-31 | McMinn | Tennessee | 47107 | 791 | 23 |
488483 | 488483 | 2020-08-31 | McNairy | Tennessee | 47109 | 549 | 11 |
488484 | 488484 | 2020-08-31 | Meigs | Tennessee | 47121 | 162 | 2 |
488485 | 488485 | 2020-08-31 | Monroe | Tennessee | 47123 | 749 | 15 |
488486 | 488486 | 2020-08-31 | Montgomery | Tennessee | 47125 | 2475 | 30 |
488487 | 488487 | 2020-08-31 | Moore | Tennessee | 47127 | 93 | 0 |
488488 | 488488 | 2020-08-31 | Morgan | Tennessee | 47129 | 209 | 2 |
488489 | 488489 | 2020-08-31 | Obion | Tennessee | 47131 | 829 | 8 |
488490 | 488490 | 2020-08-31 | Overton | Tennessee | 47133 | 435 | 2 |
488491 | 488491 | 2020-08-31 | Perry | Tennessee | 47135 | 110 | 0 |
488492 | 488492 | 2020-08-31 | Pickett | Tennessee | 47137 | 63 | 1 |
488493 | 488493 | 2020-08-31 | Polk | Tennessee | 47139 | 327 | 10 |
488494 | 488494 | 2020-08-31 | Putnam | Tennessee | 47141 | 2368 | 30 |
488495 | 488495 | 2020-08-31 | Rhea | Tennessee | 47143 | 652 | 4 |
488496 | 488496 | 2020-08-31 | Roane | Tennessee | 47145 | 651 | 2 |
488497 | 488497 | 2020-08-31 | Robertson | Tennessee | 47147 | 1886 | 26 |
488498 | 488498 | 2020-08-31 | Rutherford | Tennessee | 47149 | 7825 | 70 |
488499 | 488499 | 2020-08-31 | Scott | Tennessee | 47151 | 155 | 2 |
488500 | 488500 | 2020-08-31 | Sequatchie | Tennessee | 47153 | 142 | 1 |
488501 | 488501 | 2020-08-31 | Sevier | Tennessee | 47155 | 2236 | 12 |
488502 | 488502 | 2020-08-31 | Shelby | Tennessee | 47157 | 27697 | 387 |
488503 | 488503 | 2020-08-31 | Smith | Tennessee | 47159 | 516 | 8 |
488504 | 488504 | 2020-08-31 | Stewart | Tennessee | 47161 | 96 | 0 |
488505 | 488505 | 2020-08-31 | Sullivan | Tennessee | 47163 | 1640 | 25 |
488506 | 488506 | 2020-08-31 | Sumner | Tennessee | 47165 | 4094 | 86 |
488507 | 488507 | 2020-08-31 | Tipton | Tennessee | 47167 | 1462 | 15 |
488508 | 488508 | 2020-08-31 | Trousdale | Tennessee | 47169 | 1618 | 6 |
488509 | 488509 | 2020-08-31 | Unicoi | Tennessee | 47171 | 225 | 1 |
488510 | 488510 | 2020-08-31 | Union | Tennessee | 47173 | 225 | 1 |
488511 | 488511 | 2020-08-31 | Unknown | Tennessee | 43 | 5 | |
488512 | 488512 | 2020-08-31 | Van Buren | Tennessee | 47175 | 71 | 0 |
488513 | 488513 | 2020-08-31 | Warren | Tennessee | 47177 | 853 | 7 |
488514 | 488514 | 2020-08-31 | Washington | Tennessee | 47179 | 1741 | 13 |
488515 | 488515 | 2020-08-31 | Wayne | Tennessee | 47181 | 1279 | 3 |
488516 | 488516 | 2020-08-31 | Weakley | Tennessee | 47183 | 842 | 13 |
488517 | 488517 | 2020-08-31 | White | Tennessee | 47185 | 564 | 7 |
488518 | 488518 | 2020-08-31 | Williamson | Tennessee | 47187 | 4369 | 28 |
488519 | 488519 | 2020-08-31 | Wilson | Tennessee | 47189 | 2828 | 31 |
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);