ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where date = "2020-10-29" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
679589 | 679589 | 2020-10-29 | Anderson | Tennessee | 47001 | 1813 | 14 |
679590 | 679590 | 2020-10-29 | Bedford | Tennessee | 47003 | 1789 | 20 |
679591 | 679591 | 2020-10-29 | Benton | Tennessee | 47005 | 434 | 10 |
679592 | 679592 | 2020-10-29 | Bledsoe | Tennessee | 47007 | 1034 | 4 |
679593 | 679593 | 2020-10-29 | Blount | Tennessee | 47009 | 3515 | 36 |
679594 | 679594 | 2020-10-29 | Bradley | Tennessee | 47011 | 3703 | 23 |
679595 | 679595 | 2020-10-29 | Campbell | Tennessee | 47013 | 1104 | 13 |
679596 | 679596 | 2020-10-29 | Cannon | Tennessee | 47015 | 432 | 2 |
679597 | 679597 | 2020-10-29 | Carroll | Tennessee | 47017 | 1169 | 26 |
679598 | 679598 | 2020-10-29 | Carter | Tennessee | 47019 | 1666 | 36 |
679599 | 679599 | 2020-10-29 | Cheatham | Tennessee | 47021 | 1097 | 12 |
679600 | 679600 | 2020-10-29 | Chester | Tennessee | 47023 | 741 | 15 |
679601 | 679601 | 2020-10-29 | Claiborne | Tennessee | 47025 | 543 | 7 |
679602 | 679602 | 2020-10-29 | Clay | Tennessee | 47027 | 418 | 15 |
679603 | 679603 | 2020-10-29 | Cocke | Tennessee | 47029 | 1150 | 14 |
679604 | 679604 | 2020-10-29 | Coffee | Tennessee | 47031 | 1987 | 26 |
679605 | 679605 | 2020-10-29 | Crockett | Tennessee | 47033 | 907 | 22 |
679606 | 679606 | 2020-10-29 | Cumberland | Tennessee | 47035 | 1669 | 27 |
679607 | 679607 | 2020-10-29 | Davidson | Tennessee | 47037 | 34418 | 345 |
679608 | 679608 | 2020-10-29 | DeKalb | Tennessee | 47041 | 786 | 17 |
679609 | 679609 | 2020-10-29 | Decatur | Tennessee | 47039 | 679 | 11 |
679610 | 679610 | 2020-10-29 | Dickson | Tennessee | 47043 | 1763 | 19 |
679611 | 679611 | 2020-10-29 | Dyer | Tennessee | 47045 | 2336 | 38 |
679612 | 679612 | 2020-10-29 | Fayette | Tennessee | 47047 | 1759 | 25 |
679613 | 679613 | 2020-10-29 | Fentress | Tennessee | 47049 | 944 | 11 |
679614 | 679614 | 2020-10-29 | Franklin | Tennessee | 47051 | 1336 | 23 |
679615 | 679615 | 2020-10-29 | Gibson | Tennessee | 47053 | 2227 | 49 |
679616 | 679616 | 2020-10-29 | Giles | Tennessee | 47055 | 1007 | 38 |
679617 | 679617 | 2020-10-29 | Grainger | Tennessee | 47057 | 636 | 4 |
679618 | 679618 | 2020-10-29 | Greene | Tennessee | 47059 | 1876 | 54 |
679619 | 679619 | 2020-10-29 | Grundy | Tennessee | 47061 | 587 | 12 |
679620 | 679620 | 2020-10-29 | Hamblen | Tennessee | 47063 | 2547 | 50 |
679621 | 679621 | 2020-10-29 | Hamilton | Tennessee | 47065 | 12446 | 112 |
679622 | 679622 | 2020-10-29 | Hancock | Tennessee | 47067 | 125 | 3 |
679623 | 679623 | 2020-10-29 | Hardeman | Tennessee | 47069 | 1931 | 33 |
679624 | 679624 | 2020-10-29 | Hardin | Tennessee | 47071 | 1435 | 22 |
679625 | 679625 | 2020-10-29 | Hawkins | Tennessee | 47073 | 1272 | 28 |
679626 | 679626 | 2020-10-29 | Haywood | Tennessee | 47075 | 1320 | 28 |
679627 | 679627 | 2020-10-29 | Henderson | Tennessee | 47077 | 1441 | 26 |
679628 | 679628 | 2020-10-29 | Henry | Tennessee | 47079 | 837 | 12 |
679629 | 679629 | 2020-10-29 | Hickman | Tennessee | 47081 | 829 | 15 |
679630 | 679630 | 2020-10-29 | Houston | Tennessee | 47083 | 431 | 17 |
679631 | 679631 | 2020-10-29 | Humphreys | Tennessee | 47085 | 465 | 4 |
679632 | 679632 | 2020-10-29 | Jackson | Tennessee | 47087 | 471 | 6 |
679633 | 679633 | 2020-10-29 | Jefferson | Tennessee | 47089 | 1604 | 24 |
679634 | 679634 | 2020-10-29 | Johnson | Tennessee | 47091 | 1192 | 7 |
679635 | 679635 | 2020-10-29 | Knox | Tennessee | 47093 | 13538 | 103 |
679636 | 679636 | 2020-10-29 | Lake | Tennessee | 47095 | 990 | 4 |
679637 | 679637 | 2020-10-29 | Lauderdale | Tennessee | 47097 | 1495 | 17 |
679638 | 679638 | 2020-10-29 | Lawrence | Tennessee | 47099 | 1707 | 20 |
679639 | 679639 | 2020-10-29 | Lewis | Tennessee | 47101 | 442 | 5 |
679640 | 679640 | 2020-10-29 | Lincoln | Tennessee | 47103 | 945 | 3 |
679641 | 679641 | 2020-10-29 | Loudon | Tennessee | 47105 | 1690 | 12 |
679642 | 679642 | 2020-10-29 | Macon | Tennessee | 47111 | 1381 | 25 |
679643 | 679643 | 2020-10-29 | Madison | Tennessee | 47113 | 3918 | 80 |
679644 | 679644 | 2020-10-29 | Marion | Tennessee | 47115 | 812 | 10 |
679645 | 679645 | 2020-10-29 | Marshall | Tennessee | 47117 | 1190 | 11 |
679646 | 679646 | 2020-10-29 | Maury | Tennessee | 47119 | 3458 | 39 |
679647 | 679647 | 2020-10-29 | McMinn | Tennessee | 47107 | 1712 | 38 |
679648 | 679648 | 2020-10-29 | McNairy | Tennessee | 47109 | 1150 | 29 |
679649 | 679649 | 2020-10-29 | Meigs | Tennessee | 47121 | 337 | 6 |
679650 | 679650 | 2020-10-29 | Monroe | Tennessee | 47123 | 1521 | 29 |
679651 | 679651 | 2020-10-29 | Montgomery | Tennessee | 47125 | 4389 | 60 |
679652 | 679652 | 2020-10-29 | Moore | Tennessee | 47127 | 283 | 2 |
679653 | 679653 | 2020-10-29 | Morgan | Tennessee | 47129 | 458 | 7 |
679654 | 679654 | 2020-10-29 | Obion | Tennessee | 47131 | 1855 | 23 |
679655 | 679655 | 2020-10-29 | Overton | Tennessee | 47133 | 1261 | 20 |
679656 | 679656 | 2020-10-29 | Perry | Tennessee | 47135 | 343 | 5 |
679657 | 679657 | 2020-10-29 | Pickett | Tennessee | 47137 | 287 | 9 |
679658 | 679658 | 2020-10-29 | Polk | Tennessee | 47139 | 540 | 13 |
679659 | 679659 | 2020-10-29 | Putnam | Tennessee | 47141 | 4610 | 59 |
679660 | 679660 | 2020-10-29 | Rhea | Tennessee | 47143 | 1141 | 19 |
679661 | 679661 | 2020-10-29 | Roane | Tennessee | 47145 | 1420 | 8 |
679662 | 679662 | 2020-10-29 | Robertson | Tennessee | 47147 | 2681 | 43 |
679663 | 679663 | 2020-10-29 | Rutherford | Tennessee | 47149 | 12406 | 115 |
679664 | 679664 | 2020-10-29 | Scott | Tennessee | 47151 | 408 | 5 |
679665 | 679665 | 2020-10-29 | Sequatchie | Tennessee | 47153 | 363 | 2 |
679666 | 679666 | 2020-10-29 | Sevier | Tennessee | 47155 | 3497 | 22 |
679667 | 679667 | 2020-10-29 | Shelby | Tennessee | 47157 | 37335 | 570 |
679668 | 679668 | 2020-10-29 | Smith | Tennessee | 47159 | 1032 | 14 |
679669 | 679669 | 2020-10-29 | Stewart | Tennessee | 47161 | 348 | 11 |
679670 | 679670 | 2020-10-29 | Sullivan | Tennessee | 47163 | 3981 | 50 |
679671 | 679671 | 2020-10-29 | Sumner | Tennessee | 47165 | 6371 | 113 |
679672 | 679672 | 2020-10-29 | Tipton | Tennessee | 47167 | 2466 | 23 |
679673 | 679673 | 2020-10-29 | Trousdale | Tennessee | 47169 | 1789 | 9 |
679674 | 679674 | 2020-10-29 | Unicoi | Tennessee | 47171 | 477 | 5 |
679675 | 679675 | 2020-10-29 | Union | Tennessee | 47173 | 555 | 4 |
679676 | 679676 | 2020-10-29 | Van Buren | Tennessee | 47175 | 212 | 2 |
679677 | 679677 | 2020-10-29 | Warren | Tennessee | 47177 | 1507 | 11 |
679678 | 679678 | 2020-10-29 | Washington | Tennessee | 47179 | 3767 | 53 |
679679 | 679679 | 2020-10-29 | Wayne | Tennessee | 47181 | 1619 | 7 |
679680 | 679680 | 2020-10-29 | Weakley | Tennessee | 47183 | 1610 | 26 |
679681 | 679681 | 2020-10-29 | White | Tennessee | 47185 | 1252 | 14 |
679682 | 679682 | 2020-10-29 | Williamson | Tennessee | 47187 | 7387 | 56 |
679683 | 679683 | 2020-10-29 | Wilson | Tennessee | 47189 | 4920 | 63 |
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);