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-12-02 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
789903 | 789903 | 2020-12-02 | Anderson | Tennessee | 47001 | 3197 | 30 |
789904 | 789904 | 2020-12-02 | Bedford | Tennessee | 47003 | 2949 | 34 |
789905 | 789905 | 2020-12-02 | Benton | Tennessee | 47005 | 871 | 14 |
789906 | 789906 | 2020-12-02 | Bledsoe | Tennessee | 47007 | 1211 | 5 |
789907 | 789907 | 2020-12-02 | Blount | Tennessee | 47009 | 5986 | 62 |
789908 | 789908 | 2020-12-02 | Bradley | Tennessee | 47011 | 5643 | 37 |
789909 | 789909 | 2020-12-02 | Campbell | Tennessee | 47013 | 1637 | 23 |
789910 | 789910 | 2020-12-02 | Cannon | Tennessee | 47015 | 803 | 4 |
789911 | 789911 | 2020-12-02 | Carroll | Tennessee | 47017 | 1838 | 35 |
789912 | 789912 | 2020-12-02 | Carter | Tennessee | 47019 | 2952 | 56 |
789913 | 789913 | 2020-12-02 | Cheatham | Tennessee | 47021 | 1694 | 17 |
789914 | 789914 | 2020-12-02 | Chester | Tennessee | 47023 | 1055 | 21 |
789915 | 789915 | 2020-12-02 | Claiborne | Tennessee | 47025 | 963 | 9 |
789916 | 789916 | 2020-12-02 | Clay | Tennessee | 47027 | 571 | 18 |
789917 | 789917 | 2020-12-02 | Cocke | Tennessee | 47029 | 1692 | 30 |
789918 | 789918 | 2020-12-02 | Coffee | Tennessee | 47031 | 3026 | 42 |
789919 | 789919 | 2020-12-02 | Crockett | Tennessee | 47033 | 1182 | 28 |
789920 | 789920 | 2020-12-02 | Cumberland | Tennessee | 47035 | 2717 | 37 |
789921 | 789921 | 2020-12-02 | Davidson | Tennessee | 47037 | 47682 | 425 |
789922 | 789922 | 2020-12-02 | DeKalb | Tennessee | 47041 | 1239 | 23 |
789923 | 789923 | 2020-12-02 | Decatur | Tennessee | 47039 | 972 | 13 |
789924 | 789924 | 2020-12-02 | Dickson | Tennessee | 47043 | 3038 | 35 |
789925 | 789925 | 2020-12-02 | Dyer | Tennessee | 47045 | 3293 | 52 |
789926 | 789926 | 2020-12-02 | Fayette | Tennessee | 47047 | 2352 | 39 |
789927 | 789927 | 2020-12-02 | Fentress | Tennessee | 47049 | 1261 | 21 |
789928 | 789928 | 2020-12-02 | Franklin | Tennessee | 47051 | 2231 | 38 |
789929 | 789929 | 2020-12-02 | Gibson | Tennessee | 47053 | 3370 | 70 |
789930 | 789930 | 2020-12-02 | Giles | Tennessee | 47055 | 1557 | 49 |
789931 | 789931 | 2020-12-02 | Grainger | Tennessee | 47057 | 1085 | 17 |
789932 | 789932 | 2020-12-02 | Greene | Tennessee | 47059 | 3330 | 73 |
789933 | 789933 | 2020-12-02 | Grundy | Tennessee | 47061 | 803 | 14 |
789934 | 789934 | 2020-12-02 | Hamblen | Tennessee | 47063 | 3697 | 62 |
789935 | 789935 | 2020-12-02 | Hamilton | Tennessee | 47065 | 19069 | 161 |
789936 | 789936 | 2020-12-02 | Hancock | Tennessee | 47067 | 189 | 4 |
789937 | 789937 | 2020-12-02 | Hardeman | Tennessee | 47069 | 2292 | 38 |
789938 | 789938 | 2020-12-02 | Hardin | Tennessee | 47071 | 1848 | 25 |
789939 | 789939 | 2020-12-02 | Hawkins | Tennessee | 47073 | 2088 | 35 |
789940 | 789940 | 2020-12-02 | Haywood | Tennessee | 47075 | 1685 | 30 |
789941 | 789941 | 2020-12-02 | Henderson | Tennessee | 47077 | 1943 | 34 |
789942 | 789942 | 2020-12-02 | Henry | Tennessee | 47079 | 1626 | 19 |
789943 | 789943 | 2020-12-02 | Hickman | Tennessee | 47081 | 1240 | 19 |
789944 | 789944 | 2020-12-02 | Houston | Tennessee | 47083 | 603 | 20 |
789945 | 789945 | 2020-12-02 | Humphreys | Tennessee | 47085 | 760 | 8 |
789946 | 789946 | 2020-12-02 | Jackson | Tennessee | 47087 | 720 | 10 |
789947 | 789947 | 2020-12-02 | Jefferson | Tennessee | 47089 | 2425 | 34 |
789948 | 789948 | 2020-12-02 | Johnson | Tennessee | 47091 | 1460 | 23 |
789949 | 789949 | 2020-12-02 | Knox | Tennessee | 47093 | 20421 | 179 |
789950 | 789950 | 2020-12-02 | Lake | Tennessee | 47095 | 1189 | 6 |
789951 | 789951 | 2020-12-02 | Lauderdale | Tennessee | 47097 | 2115 | 23 |
789952 | 789952 | 2020-12-02 | Lawrence | Tennessee | 47099 | 2885 | 36 |
789953 | 789953 | 2020-12-02 | Lewis | Tennessee | 47101 | 807 | 15 |
789954 | 789954 | 2020-12-02 | Lincoln | Tennessee | 47103 | 1751 | 18 |
789955 | 789955 | 2020-12-02 | Loudon | Tennessee | 47105 | 2409 | 20 |
789956 | 789956 | 2020-12-02 | Macon | Tennessee | 47111 | 1884 | 29 |
789957 | 789957 | 2020-12-02 | Madison | Tennessee | 47113 | 5555 | 111 |
789958 | 789958 | 2020-12-02 | Marion | Tennessee | 47115 | 1166 | 19 |
789959 | 789959 | 2020-12-02 | Marshall | Tennessee | 47117 | 1842 | 22 |
789960 | 789960 | 2020-12-02 | Maury | Tennessee | 47119 | 6320 | 70 |
789961 | 789961 | 2020-12-02 | McMinn | Tennessee | 47107 | 2770 | 56 |
789962 | 789962 | 2020-12-02 | McNairy | Tennessee | 47109 | 1427 | 33 |
789963 | 789963 | 2020-12-02 | Meigs | Tennessee | 47121 | 522 | 12 |
789964 | 789964 | 2020-12-02 | Monroe | Tennessee | 47123 | 2312 | 45 |
789965 | 789965 | 2020-12-02 | Montgomery | Tennessee | 47125 | 7069 | 85 |
789966 | 789966 | 2020-12-02 | Moore | Tennessee | 47127 | 413 | 2 |
789967 | 789967 | 2020-12-02 | Morgan | Tennessee | 47129 | 788 | 6 |
789968 | 789968 | 2020-12-02 | Obion | Tennessee | 47131 | 2775 | 51 |
789969 | 789969 | 2020-12-02 | Overton | Tennessee | 47133 | 1571 | 35 |
789970 | 789970 | 2020-12-02 | Perry | Tennessee | 47135 | 508 | 22 |
789971 | 789971 | 2020-12-02 | Pickett | Tennessee | 47137 | 398 | 14 |
789972 | 789972 | 2020-12-02 | Polk | Tennessee | 47139 | 705 | 15 |
789973 | 789973 | 2020-12-02 | Putnam | Tennessee | 47141 | 6098 | 83 |
789974 | 789974 | 2020-12-02 | Rhea | Tennessee | 47143 | 1859 | 33 |
789975 | 789975 | 2020-12-02 | Roane | Tennessee | 47145 | 2533 | 31 |
789976 | 789976 | 2020-12-02 | Robertson | Tennessee | 47147 | 4002 | 53 |
789977 | 789977 | 2020-12-02 | Rutherford | Tennessee | 47149 | 18788 | 164 |
789978 | 789978 | 2020-12-02 | Scott | Tennessee | 47151 | 1171 | 7 |
789979 | 789979 | 2020-12-02 | Sequatchie | Tennessee | 47153 | 566 | 5 |
789980 | 789980 | 2020-12-02 | Sevier | Tennessee | 47155 | 5238 | 33 |
789981 | 789981 | 2020-12-02 | Shelby | Tennessee | 47157 | 49412 | 681 |
789982 | 789982 | 2020-12-02 | Smith | Tennessee | 47159 | 1496 | 20 |
789983 | 789983 | 2020-12-02 | Stewart | Tennessee | 47161 | 624 | 16 |
789984 | 789984 | 2020-12-02 | Sullivan | Tennessee | 47163 | 6913 | 105 |
789985 | 789985 | 2020-12-02 | Sumner | Tennessee | 47165 | 10404 | 138 |
789986 | 789986 | 2020-12-02 | Tipton | Tennessee | 47167 | 3839 | 39 |
789987 | 789987 | 2020-12-02 | Trousdale | Tennessee | 47169 | 1922 | 12 |
789988 | 789988 | 2020-12-02 | Unicoi | Tennessee | 47171 | 935 | 26 |
789989 | 789989 | 2020-12-02 | Union | Tennessee | 47173 | 759 | 5 |
789990 | 789990 | 2020-12-02 | Unknown | Tennessee | 641 | 0 | |
789991 | 789991 | 2020-12-02 | Van Buren | Tennessee | 47175 | 386 | 2 |
789992 | 789992 | 2020-12-02 | Warren | Tennessee | 47177 | 2507 | 20 |
789993 | 789993 | 2020-12-02 | Washington | Tennessee | 47179 | 6469 | 114 |
789994 | 789994 | 2020-12-02 | Wayne | Tennessee | 47181 | 1972 | 10 |
789995 | 789995 | 2020-12-02 | Weakley | Tennessee | 47183 | 2247 | 36 |
789996 | 789996 | 2020-12-02 | White | Tennessee | 47185 | 1873 | 19 |
789997 | 789997 | 2020-12-02 | Williamson | Tennessee | 47187 | 11951 | 83 |
789998 | 789998 | 2020-12-02 | Wilson | Tennessee | 47189 | 7943 | 83 |
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);