ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-10-09" 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 |
---|---|---|---|---|---|---|---|
614705 | 614705 | 2020-10-09 | Anderson | Tennessee | 47001 | 1363 | 13 |
614706 | 614706 | 2020-10-09 | Bedford | Tennessee | 47003 | 1448 | 19 |
614707 | 614707 | 2020-10-09 | Benton | Tennessee | 47005 | 353 | 9 |
614708 | 614708 | 2020-10-09 | Bledsoe | Tennessee | 47007 | 890 | 4 |
614709 | 614709 | 2020-10-09 | Blount | Tennessee | 47009 | 2815 | 28 |
614710 | 614710 | 2020-10-09 | Bradley | Tennessee | 47011 | 3186 | 19 |
614711 | 614711 | 2020-10-09 | Campbell | Tennessee | 47013 | 635 | 4 |
614712 | 614712 | 2020-10-09 | Cannon | Tennessee | 47015 | 341 | 2 |
614713 | 614713 | 2020-10-09 | Carroll | Tennessee | 47017 | 1024 | 24 |
614714 | 614714 | 2020-10-09 | Carter | Tennessee | 47019 | 1282 | 31 |
614715 | 614715 | 2020-10-09 | Cheatham | Tennessee | 47021 | 879 | 10 |
614716 | 614716 | 2020-10-09 | Chester | Tennessee | 47023 | 676 | 13 |
614717 | 614717 | 2020-10-09 | Claiborne | Tennessee | 47025 | 470 | 5 |
614718 | 614718 | 2020-10-09 | Clay | Tennessee | 47027 | 292 | 6 |
614719 | 614719 | 2020-10-09 | Cocke | Tennessee | 47029 | 843 | 11 |
614720 | 614720 | 2020-10-09 | Coffee | Tennessee | 47031 | 1512 | 17 |
614721 | 614721 | 2020-10-09 | Crockett | Tennessee | 47033 | 626 | 19 |
614722 | 614722 | 2020-10-09 | Cumberland | Tennessee | 47035 | 1374 | 23 |
614723 | 614723 | 2020-10-09 | Davidson | Tennessee | 47037 | 30045 | 321 |
614724 | 614724 | 2020-10-09 | DeKalb | Tennessee | 47041 | 617 | 17 |
614725 | 614725 | 2020-10-09 | Decatur | Tennessee | 47039 | 584 | 11 |
614726 | 614726 | 2020-10-09 | Dickson | Tennessee | 47043 | 1407 | 17 |
614727 | 614727 | 2020-10-09 | Dyer | Tennessee | 47045 | 1670 | 21 |
614728 | 614728 | 2020-10-09 | Fayette | Tennessee | 47047 | 1354 | 23 |
614729 | 614729 | 2020-10-09 | Fentress | Tennessee | 47049 | 728 | 5 |
614730 | 614730 | 2020-10-09 | Franklin | Tennessee | 47051 | 1099 | 12 |
614731 | 614731 | 2020-10-09 | Gibson | Tennessee | 47053 | 1914 | 28 |
614732 | 614732 | 2020-10-09 | Giles | Tennessee | 47055 | 776 | 24 |
614733 | 614733 | 2020-10-09 | Grainger | Tennessee | 47057 | 462 | 4 |
614734 | 614734 | 2020-10-09 | Greene | Tennessee | 47059 | 1288 | 48 |
614735 | 614735 | 2020-10-09 | Grundy | Tennessee | 47061 | 420 | 8 |
614736 | 614736 | 2020-10-09 | Hamblen | Tennessee | 47063 | 2134 | 38 |
614737 | 614737 | 2020-10-09 | Hamilton | Tennessee | 47065 | 10499 | 101 |
614738 | 614738 | 2020-10-09 | Hancock | Tennessee | 47067 | 110 | 3 |
614739 | 614739 | 2020-10-09 | Hardeman | Tennessee | 47069 | 1663 | 28 |
614740 | 614740 | 2020-10-09 | Hardin | Tennessee | 47071 | 1155 | 17 |
614741 | 614741 | 2020-10-09 | Hawkins | Tennessee | 47073 | 940 | 22 |
614742 | 614742 | 2020-10-09 | Haywood | Tennessee | 47075 | 1123 | 24 |
614743 | 614743 | 2020-10-09 | Henderson | Tennessee | 47077 | 1281 | 24 |
614744 | 614744 | 2020-10-09 | Henry | Tennessee | 47079 | 686 | 10 |
614745 | 614745 | 2020-10-09 | Hickman | Tennessee | 47081 | 684 | 13 |
614746 | 614746 | 2020-10-09 | Houston | Tennessee | 47083 | 342 | 13 |
614747 | 614747 | 2020-10-09 | Humphreys | Tennessee | 47085 | 326 | 3 |
614748 | 614748 | 2020-10-09 | Jackson | Tennessee | 47087 | 377 | 5 |
614749 | 614749 | 2020-10-09 | Jefferson | Tennessee | 47089 | 1296 | 16 |
614750 | 614750 | 2020-10-09 | Johnson | Tennessee | 47091 | 1019 | 4 |
614751 | 614751 | 2020-10-09 | Knox | Tennessee | 47093 | 11128 | 86 |
614752 | 614752 | 2020-10-09 | Lake | Tennessee | 47095 | 941 | 3 |
614753 | 614753 | 2020-10-09 | Lauderdale | Tennessee | 47097 | 1128 | 16 |
614754 | 614754 | 2020-10-09 | Lawrence | Tennessee | 47099 | 1224 | 17 |
614755 | 614755 | 2020-10-09 | Lewis | Tennessee | 47101 | 260 | 1 |
614756 | 614756 | 2020-10-09 | Lincoln | Tennessee | 47103 | 711 | 2 |
614757 | 614757 | 2020-10-09 | Loudon | Tennessee | 47105 | 1389 | 9 |
614758 | 614758 | 2020-10-09 | Macon | Tennessee | 47111 | 1162 | 22 |
614759 | 614759 | 2020-10-09 | Madison | Tennessee | 47113 | 3326 | 74 |
614760 | 614760 | 2020-10-09 | Marion | Tennessee | 47115 | 611 | 9 |
614761 | 614761 | 2020-10-09 | Marshall | Tennessee | 47117 | 878 | 5 |
614762 | 614762 | 2020-10-09 | Maury | Tennessee | 47119 | 2684 | 32 |
614763 | 614763 | 2020-10-09 | McMinn | Tennessee | 47107 | 1280 | 29 |
614764 | 614764 | 2020-10-09 | McNairy | Tennessee | 47109 | 1008 | 23 |
614765 | 614765 | 2020-10-09 | Meigs | Tennessee | 47121 | 252 | 3 |
614766 | 614766 | 2020-10-09 | Monroe | Tennessee | 47123 | 1179 | 21 |
614767 | 614767 | 2020-10-09 | Montgomery | Tennessee | 47125 | 3417 | 48 |
614768 | 614768 | 2020-10-09 | Moore | Tennessee | 47127 | 213 | 1 |
614769 | 614769 | 2020-10-09 | Morgan | Tennessee | 47129 | 355 | 4 |
614770 | 614770 | 2020-10-09 | Obion | Tennessee | 47131 | 1454 | 16 |
614771 | 614771 | 2020-10-09 | Overton | Tennessee | 47133 | 939 | 8 |
614772 | 614772 | 2020-10-09 | Perry | Tennessee | 47135 | 166 | 1 |
614773 | 614773 | 2020-10-09 | Pickett | Tennessee | 47137 | 184 | 3 |
614774 | 614774 | 2020-10-09 | Polk | Tennessee | 47139 | 442 | 13 |
614775 | 614775 | 2020-10-09 | Putnam | Tennessee | 47141 | 3714 | 50 |
614776 | 614776 | 2020-10-09 | Rhea | Tennessee | 47143 | 958 | 16 |
614777 | 614777 | 2020-10-09 | Roane | Tennessee | 47145 | 1025 | 6 |
614778 | 614778 | 2020-10-09 | Robertson | Tennessee | 47147 | 2348 | 39 |
614779 | 614779 | 2020-10-09 | Rutherford | Tennessee | 47149 | 10147 | 102 |
614780 | 614780 | 2020-10-09 | Scott | Tennessee | 47151 | 263 | 3 |
614781 | 614781 | 2020-10-09 | Sequatchie | Tennessee | 47153 | 265 | 3 |
614782 | 614782 | 2020-10-09 | Sevier | Tennessee | 47155 | 2871 | 19 |
614783 | 614783 | 2020-10-09 | Shelby | Tennessee | 47157 | 32770 | 529 |
614784 | 614784 | 2020-10-09 | Smith | Tennessee | 47159 | 841 | 12 |
614785 | 614785 | 2020-10-09 | Stewart | Tennessee | 47161 | 265 | 5 |
614786 | 614786 | 2020-10-09 | Sullivan | Tennessee | 47163 | 2581 | 35 |
614787 | 614787 | 2020-10-09 | Sumner | Tennessee | 47165 | 5200 | 104 |
614788 | 614788 | 2020-10-09 | Tipton | Tennessee | 47167 | 1996 | 22 |
614789 | 614789 | 2020-10-09 | Trousdale | Tennessee | 47169 | 1703 | 7 |
614790 | 614790 | 2020-10-09 | Unicoi | Tennessee | 47171 | 300 | 1 |
614791 | 614791 | 2020-10-09 | Union | Tennessee | 47173 | 444 | 2 |
614792 | 614792 | 2020-10-09 | Unknown | Tennessee | 118 | 0 | |
614793 | 614793 | 2020-10-09 | Van Buren | Tennessee | 47175 | 176 | 1 |
614794 | 614794 | 2020-10-09 | Warren | Tennessee | 47177 | 1184 | 9 |
614795 | 614795 | 2020-10-09 | Washington | Tennessee | 47179 | 2623 | 39 |
614796 | 614796 | 2020-10-09 | Wayne | Tennessee | 47181 | 1540 | 6 |
614797 | 614797 | 2020-10-09 | Weakley | Tennessee | 47183 | 1331 | 23 |
614798 | 614798 | 2020-10-09 | White | Tennessee | 47185 | 980 | 10 |
614799 | 614799 | 2020-10-09 | Williamson | Tennessee | 47187 | 5910 | 44 |
614800 | 614800 | 2020-10-09 | Wilson | Tennessee | 47189 | 3931 | 52 |
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);