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 2021-10-06 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1789901 | 1789901 | 2021-10-06 | Anderson | Tennessee | 47001 | 12456 | 207 |
1789902 | 1789902 | 2021-10-06 | Bedford | Tennessee | 47003 | 8813 | 152 |
1789903 | 1789903 | 2021-10-06 | Benton | Tennessee | 47005 | 2671 | 49 |
1789904 | 1789904 | 2021-10-06 | Bledsoe | Tennessee | 47007 | 3390 | 14 |
1789905 | 1789905 | 2021-10-06 | Blount | Tennessee | 47009 | 23021 | 247 |
1789906 | 1789906 | 2021-10-06 | Bradley | Tennessee | 47011 | 21605 | 172 |
1789907 | 1789907 | 2021-10-06 | Campbell | Tennessee | 47013 | 6707 | 73 |
1789908 | 1789908 | 2021-10-06 | Cannon | Tennessee | 47015 | 2728 | 39 |
1789909 | 1789909 | 2021-10-06 | Carroll | Tennessee | 47017 | 5534 | 98 |
1789910 | 1789910 | 2021-10-06 | Carter | Tennessee | 47019 | 10187 | 204 |
1789911 | 1789911 | 2021-10-06 | Cheatham | Tennessee | 47021 | 6809 | 66 |
1789912 | 1789912 | 2021-10-06 | Chester | Tennessee | 47023 | 3423 | 68 |
1789913 | 1789913 | 2021-10-06 | Claiborne | Tennessee | 47025 | 5206 | 90 |
1789914 | 1789914 | 2021-10-06 | Clay | Tennessee | 47027 | 1464 | 36 |
1789915 | 1789915 | 2021-10-06 | Cocke | Tennessee | 47029 | 7058 | 104 |
1789916 | 1789916 | 2021-10-06 | Coffee | Tennessee | 47031 | 10237 | 146 |
1789917 | 1789917 | 2021-10-06 | Crockett | Tennessee | 47033 | 3285 | 59 |
1789918 | 1789918 | 2021-10-06 | Cumberland | Tennessee | 47035 | 10677 | 203 |
1789919 | 1789919 | 2021-10-06 | Davidson | Tennessee | 47037 | 129471 | 1118 |
1789920 | 1789920 | 2021-10-06 | DeKalb | Tennessee | 47041 | 4098 | 66 |
1789921 | 1789921 | 2021-10-06 | Decatur | Tennessee | 47039 | 2370 | 42 |
1789922 | 1789922 | 2021-10-06 | Dickson | Tennessee | 47043 | 10044 | 159 |
1789923 | 1789923 | 2021-10-06 | Dyer | Tennessee | 47045 | 7987 | 134 |
1789924 | 1789924 | 2021-10-06 | Fayette | Tennessee | 47047 | 7128 | 97 |
1789925 | 1789925 | 2021-10-06 | Fentress | Tennessee | 47049 | 3482 | 60 |
1789926 | 1789926 | 2021-10-06 | Franklin | Tennessee | 47051 | 7700 | 99 |
1789927 | 1789927 | 2021-10-06 | Gibson | Tennessee | 47053 | 10410 | 181 |
1789928 | 1789928 | 2021-10-06 | Giles | Tennessee | 47055 | 5796 | 114 |
1789929 | 1789929 | 2021-10-06 | Grainger | Tennessee | 47057 | 4160 | 60 |
1789930 | 1789930 | 2021-10-06 | Greene | Tennessee | 47059 | 12884 | 221 |
1789931 | 1789931 | 2021-10-06 | Grundy | Tennessee | 47061 | 2722 | 37 |
1789932 | 1789932 | 2021-10-06 | Hamblen | Tennessee | 47063 | 12690 | 189 |
1789933 | 1789933 | 2021-10-06 | Hamilton | Tennessee | 47065 | 62276 | 631 |
1789934 | 1789934 | 2021-10-06 | Hancock | Tennessee | 47067 | 1152 | 18 |
1789935 | 1789935 | 2021-10-06 | Hardeman | Tennessee | 47069 | 5021 | 77 |
1789936 | 1789936 | 2021-10-06 | Hardin | Tennessee | 47071 | 5398 | 81 |
1789937 | 1789937 | 2021-10-06 | Hawkins | Tennessee | 47073 | 9855 | 158 |
1789938 | 1789938 | 2021-10-06 | Haywood | Tennessee | 47075 | 3751 | 71 |
1789939 | 1789939 | 2021-10-06 | Henderson | Tennessee | 47077 | 5542 | 96 |
1789940 | 1789940 | 2021-10-06 | Henry | Tennessee | 47079 | 5330 | 80 |
1789941 | 1789941 | 2021-10-06 | Hickman | Tennessee | 47081 | 4482 | 72 |
1789942 | 1789942 | 2021-10-06 | Houston | Tennessee | 47083 | 1796 | 43 |
1789943 | 1789943 | 2021-10-06 | Humphreys | Tennessee | 47085 | 3070 | 44 |
1789944 | 1789944 | 2021-10-06 | Jackson | Tennessee | 47087 | 2016 | 39 |
1789945 | 1789945 | 2021-10-06 | Jefferson | Tennessee | 47089 | 9604 | 135 |
1789946 | 1789946 | 2021-10-06 | Johnson | Tennessee | 47091 | 3408 | 45 |
1789947 | 1789947 | 2021-10-06 | Knox | Tennessee | 47093 | 75817 | 865 |
1789948 | 1789948 | 2021-10-06 | Lake | Tennessee | 47095 | 1986 | 31 |
1789949 | 1789949 | 2021-10-06 | Lauderdale | Tennessee | 47097 | 5109 | 61 |
1789950 | 1789950 | 2021-10-06 | Lawrence | Tennessee | 47099 | 9262 | 114 |
1789951 | 1789951 | 2021-10-06 | Lewis | Tennessee | 47101 | 2478 | 37 |
1789952 | 1789952 | 2021-10-06 | Lincoln | Tennessee | 47103 | 6481 | 81 |
1789953 | 1789953 | 2021-10-06 | Loudon | Tennessee | 47105 | 8872 | 91 |
1789954 | 1789954 | 2021-10-06 | Macon | Tennessee | 47111 | 5324 | 88 |
1789955 | 1789955 | 2021-10-06 | Madison | Tennessee | 47113 | 17217 | 297 |
1789956 | 1789956 | 2021-10-06 | Marion | Tennessee | 47115 | 5605 | 52 |
1789957 | 1789957 | 2021-10-06 | Marshall | Tennessee | 47117 | 6666 | 83 |
1789958 | 1789958 | 2021-10-06 | Maury | Tennessee | 47119 | 18903 | 217 |
1789959 | 1789959 | 2021-10-06 | McMinn | Tennessee | 47107 | 10189 | 120 |
1789960 | 1789960 | 2021-10-06 | McNairy | Tennessee | 47109 | 4482 | 65 |
1789961 | 1789961 | 2021-10-06 | Meigs | Tennessee | 47121 | 2117 | 27 |
1789962 | 1789962 | 2021-10-06 | Monroe | Tennessee | 47123 | 9399 | 116 |
1789963 | 1789963 | 2021-10-06 | Montgomery | Tennessee | 47125 | 31834 | 322 |
1789964 | 1789964 | 2021-10-06 | Moore | Tennessee | 47127 | 1403 | 19 |
1789965 | 1789965 | 2021-10-06 | Morgan | Tennessee | 47129 | 3655 | 46 |
1789966 | 1789966 | 2021-10-06 | Obion | Tennessee | 47131 | 6442 | 110 |
1789967 | 1789967 | 2021-10-06 | Overton | Tennessee | 47133 | 4645 | 78 |
1789968 | 1789968 | 2021-10-06 | Perry | Tennessee | 47135 | 1548 | 34 |
1789969 | 1789969 | 2021-10-06 | Pickett | Tennessee | 47137 | 1045 | 24 |
1789970 | 1789970 | 2021-10-06 | Polk | Tennessee | 47139 | 3086 | 27 |
1789971 | 1789971 | 2021-10-06 | Putnam | Tennessee | 47141 | 16289 | 208 |
1789972 | 1789972 | 2021-10-06 | Rhea | Tennessee | 47143 | 6782 | 89 |
1789973 | 1789973 | 2021-10-06 | Roane | Tennessee | 47145 | 9606 | 145 |
1789974 | 1789974 | 2021-10-06 | Robertson | Tennessee | 47147 | 13756 | 175 |
1789975 | 1789975 | 2021-10-06 | Rutherford | Tennessee | 47149 | 60287 | 521 |
1789976 | 1789976 | 2021-10-06 | Scott | Tennessee | 47151 | 4896 | 54 |
1789977 | 1789977 | 2021-10-06 | Sequatchie | Tennessee | 47153 | 2881 | 30 |
1789978 | 1789978 | 2021-10-06 | Sevier | Tennessee | 47155 | 19316 | 250 |
1789979 | 1789979 | 2021-10-06 | Shelby | Tennessee | 47157 | 142973 | 2147 |
1789980 | 1789980 | 2021-10-06 | Smith | Tennessee | 47159 | 4083 | 48 |
1789981 | 1789981 | 2021-10-06 | Stewart | Tennessee | 47161 | 2079 | 33 |
1789982 | 1789982 | 2021-10-06 | Sullivan | Tennessee | 47163 | 25691 | 400 |
1789983 | 1789983 | 2021-10-06 | Sumner | Tennessee | 47165 | 33392 | 403 |
1789984 | 1789984 | 2021-10-06 | Tipton | Tennessee | 47167 | 11053 | 126 |
1789985 | 1789985 | 2021-10-06 | Trousdale | Tennessee | 47169 | 3080 | 24 |
1789986 | 1789986 | 2021-10-06 | Unicoi | Tennessee | 47171 | 3056 | 61 |
1789987 | 1789987 | 2021-10-06 | Union | Tennessee | 47173 | 2920 | 42 |
1789988 | 1789988 | 2021-10-06 | Unknown | Tennessee | 10209 | 119 | |
1789989 | 1789989 | 2021-10-06 | Van Buren | Tennessee | 47175 | 1187 | 26 |
1789990 | 1789990 | 2021-10-06 | Warren | Tennessee | 47177 | 8325 | 106 |
1789991 | 1789991 | 2021-10-06 | Washington | Tennessee | 47179 | 20995 | 316 |
1789992 | 1789992 | 2021-10-06 | Wayne | Tennessee | 47181 | 3954 | 39 |
1789993 | 1789993 | 2021-10-06 | Weakley | Tennessee | 47183 | 6047 | 81 |
1789994 | 1789994 | 2021-10-06 | White | Tennessee | 47185 | 5415 | 92 |
1789995 | 1789995 | 2021-10-06 | Williamson | Tennessee | 47187 | 38646 | 261 |
1789996 | 1789996 | 2021-10-06 | Wilson | Tennessee | 47189 | 26423 | 322 |
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);