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-11-19 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
747713 | 747713 | 2020-11-19 | Anderson | Tennessee | 47001 | 2535 | 25 |
747714 | 747714 | 2020-11-19 | Bedford | Tennessee | 47003 | 2381 | 28 |
747715 | 747715 | 2020-11-19 | Benton | Tennessee | 47005 | 718 | 14 |
747716 | 747716 | 2020-11-19 | Bledsoe | Tennessee | 47007 | 1127 | 5 |
747717 | 747717 | 2020-11-19 | Blount | Tennessee | 47009 | 4804 | 50 |
747718 | 747718 | 2020-11-19 | Bradley | Tennessee | 47011 | 4622 | 31 |
747719 | 747719 | 2020-11-19 | Campbell | Tennessee | 47013 | 1383 | 20 |
747720 | 747720 | 2020-11-19 | Cannon | Tennessee | 47015 | 653 | 2 |
747721 | 747721 | 2020-11-19 | Carroll | Tennessee | 47017 | 1540 | 30 |
747722 | 747722 | 2020-11-19 | Carter | Tennessee | 47019 | 2427 | 49 |
747723 | 747723 | 2020-11-19 | Cheatham | Tennessee | 47021 | 1421 | 16 |
747724 | 747724 | 2020-11-19 | Chester | Tennessee | 47023 | 931 | 19 |
747725 | 747725 | 2020-11-19 | Claiborne | Tennessee | 47025 | 698 | 9 |
747726 | 747726 | 2020-11-19 | Clay | Tennessee | 47027 | 510 | 18 |
747727 | 747727 | 2020-11-19 | Cocke | Tennessee | 47029 | 1488 | 26 |
747728 | 747728 | 2020-11-19 | Coffee | Tennessee | 47031 | 2518 | 38 |
747729 | 747729 | 2020-11-19 | Crockett | Tennessee | 47033 | 1091 | 25 |
747730 | 747730 | 2020-11-19 | Cumberland | Tennessee | 47035 | 2271 | 34 |
747731 | 747731 | 2020-11-19 | Davidson | Tennessee | 47037 | 42004 | 393 |
747732 | 747732 | 2020-11-19 | DeKalb | Tennessee | 47041 | 1020 | 20 |
747733 | 747733 | 2020-11-19 | Decatur | Tennessee | 47039 | 860 | 11 |
747734 | 747734 | 2020-11-19 | Dickson | Tennessee | 47043 | 2528 | 26 |
747735 | 747735 | 2020-11-19 | Dyer | Tennessee | 47045 | 2972 | 48 |
747736 | 747736 | 2020-11-19 | Fayette | Tennessee | 47047 | 2071 | 37 |
747737 | 747737 | 2020-11-19 | Fentress | Tennessee | 47049 | 1114 | 19 |
747738 | 747738 | 2020-11-19 | Franklin | Tennessee | 47051 | 1821 | 29 |
747739 | 747739 | 2020-11-19 | Gibson | Tennessee | 47053 | 2871 | 60 |
747740 | 747740 | 2020-11-19 | Giles | Tennessee | 47055 | 1300 | 40 |
747741 | 747741 | 2020-11-19 | Grainger | Tennessee | 47057 | 842 | 12 |
747742 | 747742 | 2020-11-19 | Greene | Tennessee | 47059 | 2693 | 67 |
747743 | 747743 | 2020-11-19 | Grundy | Tennessee | 47061 | 714 | 14 |
747744 | 747744 | 2020-11-19 | Hamblen | Tennessee | 47063 | 3131 | 57 |
747745 | 747745 | 2020-11-19 | Hamilton | Tennessee | 47065 | 15938 | 134 |
747746 | 747746 | 2020-11-19 | Hancock | Tennessee | 47067 | 138 | 3 |
747747 | 747747 | 2020-11-19 | Hardeman | Tennessee | 47069 | 2168 | 36 |
747748 | 747748 | 2020-11-19 | Hardin | Tennessee | 47071 | 1673 | 25 |
747749 | 747749 | 2020-11-19 | Hawkins | Tennessee | 47073 | 1707 | 34 |
747750 | 747750 | 2020-11-19 | Haywood | Tennessee | 47075 | 1534 | 29 |
747751 | 747751 | 2020-11-19 | Henderson | Tennessee | 47077 | 1728 | 30 |
747752 | 747752 | 2020-11-19 | Henry | Tennessee | 47079 | 1339 | 16 |
747753 | 747753 | 2020-11-19 | Hickman | Tennessee | 47081 | 1060 | 17 |
747754 | 747754 | 2020-11-19 | Houston | Tennessee | 47083 | 558 | 19 |
747755 | 747755 | 2020-11-19 | Humphreys | Tennessee | 47085 | 621 | 7 |
747756 | 747756 | 2020-11-19 | Jackson | Tennessee | 47087 | 639 | 9 |
747757 | 747757 | 2020-11-19 | Jefferson | Tennessee | 47089 | 2033 | 30 |
747758 | 747758 | 2020-11-19 | Johnson | Tennessee | 47091 | 1350 | 18 |
747759 | 747759 | 2020-11-19 | Knox | Tennessee | 47093 | 17298 | 140 |
747760 | 747760 | 2020-11-19 | Lake | Tennessee | 47095 | 1127 | 5 |
747761 | 747761 | 2020-11-19 | Lauderdale | Tennessee | 47097 | 1932 | 20 |
747762 | 747762 | 2020-11-19 | Lawrence | Tennessee | 47099 | 2399 | 31 |
747763 | 747763 | 2020-11-19 | Lewis | Tennessee | 47101 | 680 | 10 |
747764 | 747764 | 2020-11-19 | Lincoln | Tennessee | 47103 | 1337 | 11 |
747765 | 747765 | 2020-11-19 | Loudon | Tennessee | 47105 | 2073 | 16 |
747766 | 747766 | 2020-11-19 | Macon | Tennessee | 47111 | 1707 | 27 |
747767 | 747767 | 2020-11-19 | Madison | Tennessee | 47113 | 4922 | 100 |
747768 | 747768 | 2020-11-19 | Marion | Tennessee | 47115 | 1009 | 15 |
747769 | 747769 | 2020-11-19 | Marshall | Tennessee | 47117 | 1561 | 17 |
747770 | 747770 | 2020-11-19 | Maury | Tennessee | 47119 | 5226 | 52 |
747771 | 747771 | 2020-11-19 | McMinn | Tennessee | 47107 | 2249 | 53 |
747772 | 747772 | 2020-11-19 | McNairy | Tennessee | 47109 | 1354 | 32 |
747773 | 747773 | 2020-11-19 | Meigs | Tennessee | 47121 | 437 | 12 |
747774 | 747774 | 2020-11-19 | Monroe | Tennessee | 47123 | 1889 | 42 |
747775 | 747775 | 2020-11-19 | Montgomery | Tennessee | 47125 | 5805 | 77 |
747776 | 747776 | 2020-11-19 | Moore | Tennessee | 47127 | 352 | 2 |
747777 | 747777 | 2020-11-19 | Morgan | Tennessee | 47129 | 600 | 6 |
747778 | 747778 | 2020-11-19 | Obion | Tennessee | 47131 | 2397 | 40 |
747779 | 747779 | 2020-11-19 | Overton | Tennessee | 47133 | 1448 | 33 |
747780 | 747780 | 2020-11-19 | Perry | Tennessee | 47135 | 450 | 21 |
747781 | 747781 | 2020-11-19 | Pickett | Tennessee | 47137 | 352 | 12 |
747782 | 747782 | 2020-11-19 | Polk | Tennessee | 47139 | 612 | 14 |
747783 | 747783 | 2020-11-19 | Putnam | Tennessee | 47141 | 5498 | 74 |
747784 | 747784 | 2020-11-19 | Rhea | Tennessee | 47143 | 1485 | 29 |
747785 | 747785 | 2020-11-19 | Roane | Tennessee | 47145 | 2096 | 21 |
747786 | 747786 | 2020-11-19 | Robertson | Tennessee | 47147 | 3353 | 49 |
747787 | 747787 | 2020-11-19 | Rutherford | Tennessee | 47149 | 16052 | 143 |
747788 | 747788 | 2020-11-19 | Scott | Tennessee | 47151 | 843 | 6 |
747789 | 747789 | 2020-11-19 | Sequatchie | Tennessee | 47153 | 479 | 5 |
747790 | 747790 | 2020-11-19 | Sevier | Tennessee | 47155 | 4346 | 28 |
747791 | 747791 | 2020-11-19 | Shelby | Tennessee | 47157 | 44474 | 626 |
747792 | 747792 | 2020-11-19 | Smith | Tennessee | 47159 | 1314 | 17 |
747793 | 747793 | 2020-11-19 | Stewart | Tennessee | 47161 | 527 | 14 |
747794 | 747794 | 2020-11-19 | Sullivan | Tennessee | 47163 | 5620 | 89 |
747795 | 747795 | 2020-11-19 | Sumner | Tennessee | 47165 | 8529 | 129 |
747796 | 747796 | 2020-11-19 | Tipton | Tennessee | 47167 | 3233 | 34 |
747797 | 747797 | 2020-11-19 | Trousdale | Tennessee | 47169 | 1885 | 12 |
747798 | 747798 | 2020-11-19 | Unicoi | Tennessee | 47171 | 719 | 22 |
747799 | 747799 | 2020-11-19 | Union | Tennessee | 47173 | 666 | 5 |
747800 | 747800 | 2020-11-19 | Unknown | Tennessee | 227 | 1 | |
747801 | 747801 | 2020-11-19 | Van Buren | Tennessee | 47175 | 309 | 2 |
747802 | 747802 | 2020-11-19 | Warren | Tennessee | 47177 | 2140 | 16 |
747803 | 747803 | 2020-11-19 | Washington | Tennessee | 47179 | 5277 | 92 |
747804 | 747804 | 2020-11-19 | Wayne | Tennessee | 47181 | 1749 | 9 |
747805 | 747805 | 2020-11-19 | Weakley | Tennessee | 47183 | 2012 | 34 |
747806 | 747806 | 2020-11-19 | White | Tennessee | 47185 | 1602 | 17 |
747807 | 747807 | 2020-11-19 | Williamson | Tennessee | 47187 | 10055 | 70 |
747808 | 747808 | 2020-11-19 | Wilson | Tennessee | 47189 | 6581 | 71 |
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);