ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2021-08-28" 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 |
---|---|---|---|---|---|---|---|
1663200 | 1663200 | 2021-08-28 | Anderson | Tennessee | 47001 | 10115 | 184 |
1663201 | 1663201 | 2021-08-28 | Bedford | Tennessee | 47003 | 7505 | 135 |
1663202 | 1663202 | 2021-08-28 | Benton | Tennessee | 47005 | 2024 | 42 |
1663203 | 1663203 | 2021-08-28 | Bledsoe | Tennessee | 47007 | 2667 | 13 |
1663204 | 1663204 | 2021-08-28 | Blount | Tennessee | 47009 | 18522 | 212 |
1663205 | 1663205 | 2021-08-28 | Bradley | Tennessee | 47011 | 17716 | 161 |
1663206 | 1663206 | 2021-08-28 | Campbell | Tennessee | 47013 | 4851 | 66 |
1663207 | 1663207 | 2021-08-28 | Cannon | Tennessee | 47015 | 2205 | 32 |
1663208 | 1663208 | 2021-08-28 | Carroll | Tennessee | 47017 | 4397 | 87 |
1663209 | 1663209 | 2021-08-28 | Carter | Tennessee | 47019 | 8090 | 177 |
1663210 | 1663210 | 2021-08-28 | Cheatham | Tennessee | 47021 | 5368 | 57 |
1663211 | 1663211 | 2021-08-28 | Chester | Tennessee | 47023 | 2751 | 54 |
1663212 | 1663212 | 2021-08-28 | Claiborne | Tennessee | 47025 | 3790 | 80 |
1663213 | 1663213 | 2021-08-28 | Clay | Tennessee | 47027 | 1201 | 30 |
1663214 | 1663214 | 2021-08-28 | Cocke | Tennessee | 47029 | 5615 | 104 |
1663215 | 1663215 | 2021-08-28 | Coffee | Tennessee | 47031 | 8207 | 126 |
1663216 | 1663216 | 2021-08-28 | Crockett | Tennessee | 47033 | 2809 | 54 |
1663217 | 1663217 | 2021-08-28 | Cumberland | Tennessee | 47035 | 8356 | 153 |
1663218 | 1663218 | 2021-08-28 | Davidson | Tennessee | 47037 | 111899 | 999 |
1663219 | 1663219 | 2021-08-28 | DeKalb | Tennessee | 47041 | 3293 | 58 |
1663220 | 1663220 | 2021-08-28 | Decatur | Tennessee | 47039 | 1926 | 39 |
1663221 | 1663221 | 2021-08-28 | Dickson | Tennessee | 47043 | 8105 | 131 |
1663222 | 1663222 | 2021-08-28 | Dyer | Tennessee | 47045 | 6560 | 113 |
1663223 | 1663223 | 2021-08-28 | Fayette | Tennessee | 47047 | 6123 | 86 |
1663224 | 1663224 | 2021-08-28 | Fentress | Tennessee | 47049 | 2770 | 50 |
1663225 | 1663225 | 2021-08-28 | Franklin | Tennessee | 47051 | 6281 | 93 |
1663226 | 1663226 | 2021-08-28 | Gibson | Tennessee | 47053 | 8517 | 158 |
1663227 | 1663227 | 2021-08-28 | Giles | Tennessee | 47055 | 4638 | 100 |
1663228 | 1663228 | 2021-08-28 | Grainger | Tennessee | 47057 | 3189 | 52 |
1663229 | 1663229 | 2021-08-28 | Greene | Tennessee | 47059 | 9631 | 175 |
1663230 | 1663230 | 2021-08-28 | Grundy | Tennessee | 47061 | 2099 | 36 |
1663231 | 1663231 | 2021-08-28 | Hamblen | Tennessee | 47063 | 10460 | 181 |
1663232 | 1663232 | 2021-08-28 | Hamilton | Tennessee | 47065 | 53576 | 551 |
1663233 | 1663233 | 2021-08-28 | Hancock | Tennessee | 47067 | 790 | 13 |
1663234 | 1663234 | 2021-08-28 | Hardeman | Tennessee | 47069 | 4255 | 66 |
1663235 | 1663235 | 2021-08-28 | Hardin | Tennessee | 47071 | 4412 | 71 |
1663236 | 1663236 | 2021-08-28 | Hawkins | Tennessee | 47073 | 7544 | 129 |
1663237 | 1663237 | 2021-08-28 | Haywood | Tennessee | 47075 | 3181 | 66 |
1663238 | 1663238 | 2021-08-28 | Henderson | Tennessee | 47077 | 4358 | 80 |
1663239 | 1663239 | 2021-08-28 | Henry | Tennessee | 47079 | 4343 | 76 |
1663240 | 1663240 | 2021-08-28 | Hickman | Tennessee | 47081 | 3526 | 49 |
1663241 | 1663241 | 2021-08-28 | Houston | Tennessee | 47083 | 1435 | 35 |
1663242 | 1663242 | 2021-08-28 | Humphreys | Tennessee | 47085 | 2368 | 33 |
1663243 | 1663243 | 2021-08-28 | Jackson | Tennessee | 47087 | 1588 | 37 |
1663244 | 1663244 | 2021-08-28 | Jefferson | Tennessee | 47089 | 7541 | 132 |
1663245 | 1663245 | 2021-08-28 | Johnson | Tennessee | 47091 | 2738 | 40 |
1663246 | 1663246 | 2021-08-28 | Knox | Tennessee | 47093 | 59957 | 692 |
1663247 | 1663247 | 2021-08-28 | Lake | Tennessee | 47095 | 1816 | 31 |
1663248 | 1663248 | 2021-08-28 | Lauderdale | Tennessee | 47097 | 4127 | 50 |
1663249 | 1663249 | 2021-08-28 | Lawrence | Tennessee | 47099 | 7219 | 103 |
1663250 | 1663250 | 2021-08-28 | Lewis | Tennessee | 47101 | 2044 | 29 |
1663251 | 1663251 | 2021-08-28 | Lincoln | Tennessee | 47103 | 5303 | 71 |
1663252 | 1663252 | 2021-08-28 | Loudon | Tennessee | 47105 | 7072 | 74 |
1663253 | 1663253 | 2021-08-28 | Macon | Tennessee | 47111 | 4353 | 79 |
1663254 | 1663254 | 2021-08-28 | Madison | Tennessee | 47113 | 14424 | 262 |
1663255 | 1663255 | 2021-08-28 | Marion | Tennessee | 47115 | 4208 | 51 |
1663256 | 1663256 | 2021-08-28 | Marshall | Tennessee | 47117 | 5361 | 67 |
1663257 | 1663257 | 2021-08-28 | Maury | Tennessee | 47119 | 15825 | 188 |
1663258 | 1663258 | 2021-08-28 | McMinn | Tennessee | 47107 | 7925 | 110 |
1663259 | 1663259 | 2021-08-28 | McNairy | Tennessee | 47109 | 3640 | 58 |
1663260 | 1663260 | 2021-08-28 | Meigs | Tennessee | 47121 | 1700 | 24 |
1663261 | 1663261 | 2021-08-28 | Monroe | Tennessee | 47123 | 7254 | 102 |
1663262 | 1663262 | 2021-08-28 | Montgomery | Tennessee | 47125 | 24951 | 239 |
1663263 | 1663263 | 2021-08-28 | Moore | Tennessee | 47127 | 1194 | 19 |
1663264 | 1663264 | 2021-08-28 | Morgan | Tennessee | 47129 | 2958 | 41 |
1663265 | 1663265 | 2021-08-28 | Obion | Tennessee | 47131 | 5292 | 99 |
1663266 | 1663266 | 2021-08-28 | Overton | Tennessee | 47133 | 3546 | 63 |
1663267 | 1663267 | 2021-08-28 | Perry | Tennessee | 47135 | 1260 | 30 |
1663268 | 1663268 | 2021-08-28 | Pickett | Tennessee | 47137 | 853 | 24 |
1663269 | 1663269 | 2021-08-28 | Polk | Tennessee | 47139 | 2468 | 25 |
1663270 | 1663270 | 2021-08-28 | Putnam | Tennessee | 47141 | 13283 | 185 |
1663271 | 1663271 | 2021-08-28 | Rhea | Tennessee | 47143 | 5314 | 83 |
1663272 | 1663272 | 2021-08-28 | Roane | Tennessee | 47145 | 7670 | 121 |
1663273 | 1663273 | 2021-08-28 | Robertson | Tennessee | 47147 | 11477 | 146 |
1663274 | 1663274 | 2021-08-28 | Rutherford | Tennessee | 47149 | 50229 | 470 |
1663275 | 1663275 | 2021-08-28 | Scott | Tennessee | 47151 | 3621 | 50 |
1663276 | 1663276 | 2021-08-28 | Sequatchie | Tennessee | 47153 | 2146 | 30 |
1663277 | 1663277 | 2021-08-28 | Sevier | Tennessee | 47155 | 15898 | 195 |
1663278 | 1663278 | 2021-08-28 | Shelby | Tennessee | 47157 | 123316 | 1849 |
1663279 | 1663279 | 2021-08-28 | Smith | Tennessee | 47159 | 3309 | 41 |
1663280 | 1663280 | 2021-08-28 | Stewart | Tennessee | 47161 | 1544 | 28 |
1663281 | 1663281 | 2021-08-28 | Sullivan | Tennessee | 47163 | 20565 | 339 |
1663282 | 1663282 | 2021-08-28 | Sumner | Tennessee | 47165 | 28853 | 375 |
1663283 | 1663283 | 2021-08-28 | Tipton | Tennessee | 47167 | 9232 | 110 |
1663284 | 1663284 | 2021-08-28 | Trousdale | Tennessee | 47169 | 2752 | 22 |
1663285 | 1663285 | 2021-08-28 | Unicoi | Tennessee | 47171 | 2398 | 54 |
1663286 | 1663286 | 2021-08-28 | Union | Tennessee | 47173 | 2182 | 35 |
1663287 | 1663287 | 2021-08-28 | Unknown | Tennessee | 9026 | 94 | |
1663288 | 1663288 | 2021-08-28 | Van Buren | Tennessee | 47175 | 961 | 23 |
1663289 | 1663289 | 2021-08-28 | Warren | Tennessee | 47177 | 6324 | 91 |
1663290 | 1663290 | 2021-08-28 | Washington | Tennessee | 47179 | 17332 | 266 |
1663291 | 1663291 | 2021-08-28 | Wayne | Tennessee | 47181 | 3377 | 37 |
1663292 | 1663292 | 2021-08-28 | Weakley | Tennessee | 47183 | 4827 | 72 |
1663293 | 1663293 | 2021-08-28 | White | Tennessee | 47185 | 4216 | 75 |
1663294 | 1663294 | 2021-08-28 | Williamson | Tennessee | 47187 | 33250 | 235 |
1663295 | 1663295 | 2021-08-28 | Wilson | Tennessee | 47189 | 22451 | 268 |
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);