ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where date = "2020-06-21" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
261259 | 261259 | 2020-06-21 | Anderson | Tennessee | 47001 | 74 | 2 |
261260 | 261260 | 2020-06-21 | Bedford | Tennessee | 47003 | 430 | 4 |
261261 | 261261 | 2020-06-21 | Benton | Tennessee | 47005 | 8 | 1 |
261262 | 261262 | 2020-06-21 | Bledsoe | Tennessee | 47007 | 613 | 1 |
261263 | 261263 | 2020-06-21 | Blount | Tennessee | 47009 | 127 | 3 |
261264 | 261264 | 2020-06-21 | Bradley | Tennessee | 47011 | 338 | 3 |
261265 | 261265 | 2020-06-21 | Campbell | Tennessee | 47013 | 26 | 1 |
261266 | 261266 | 2020-06-21 | Cannon | Tennessee | 47015 | 23 | 0 |
261267 | 261267 | 2020-06-21 | Carroll | Tennessee | 47017 | 36 | 1 |
261268 | 261268 | 2020-06-21 | Carter | Tennessee | 47019 | 30 | 1 |
261269 | 261269 | 2020-06-21 | Cheatham | Tennessee | 47021 | 165 | 0 |
261270 | 261270 | 2020-06-21 | Chester | Tennessee | 47023 | 14 | 0 |
261271 | 261271 | 2020-06-21 | Claiborne | Tennessee | 47025 | 16 | 0 |
261272 | 261272 | 2020-06-21 | Clay | Tennessee | 47027 | 13 | 0 |
261273 | 261273 | 2020-06-21 | Cocke | Tennessee | 47029 | 29 | 0 |
261274 | 261274 | 2020-06-21 | Coffee | Tennessee | 47031 | 99 | 0 |
261275 | 261275 | 2020-06-21 | Crockett | Tennessee | 47033 | 25 | 3 |
261276 | 261276 | 2020-06-21 | Cumberland | Tennessee | 47035 | 142 | 3 |
261277 | 261277 | 2020-06-21 | Davidson | Tennessee | 47037 | 8052 | 95 |
261278 | 261278 | 2020-06-21 | DeKalb | Tennessee | 47041 | 43 | 0 |
261279 | 261279 | 2020-06-21 | Decatur | Tennessee | 47039 | 15 | 0 |
261280 | 261280 | 2020-06-21 | Dickson | Tennessee | 47043 | 147 | 0 |
261281 | 261281 | 2020-06-21 | Dyer | Tennessee | 47045 | 158 | 0 |
261282 | 261282 | 2020-06-21 | Fayette | Tennessee | 47047 | 195 | 2 |
261283 | 261283 | 2020-06-21 | Fentress | Tennessee | 47049 | 15 | 0 |
261284 | 261284 | 2020-06-21 | Franklin | Tennessee | 47051 | 67 | 2 |
261285 | 261285 | 2020-06-21 | Gibson | Tennessee | 47053 | 77 | 1 |
261286 | 261286 | 2020-06-21 | Giles | Tennessee | 47055 | 24 | 0 |
261287 | 261287 | 2020-06-21 | Grainger | Tennessee | 47057 | 25 | 0 |
261288 | 261288 | 2020-06-21 | Greene | Tennessee | 47059 | 55 | 2 |
261289 | 261289 | 2020-06-21 | Grundy | Tennessee | 47061 | 46 | 1 |
261290 | 261290 | 2020-06-21 | Hamblen | Tennessee | 47063 | 117 | 4 |
261291 | 261291 | 2020-06-21 | Hamilton | Tennessee | 47065 | 2138 | 26 |
261292 | 261292 | 2020-06-21 | Hancock | Tennessee | 47067 | 3 | 0 |
261293 | 261293 | 2020-06-21 | Hardeman | Tennessee | 47069 | 255 | 1 |
261294 | 261294 | 2020-06-21 | Hardin | Tennessee | 47071 | 57 | 5 |
261295 | 261295 | 2020-06-21 | Hawkins | Tennessee | 47073 | 39 | 2 |
261296 | 261296 | 2020-06-21 | Haywood | Tennessee | 47075 | 45 | 2 |
261297 | 261297 | 2020-06-21 | Henderson | Tennessee | 47077 | 21 | 0 |
261298 | 261298 | 2020-06-21 | Henry | Tennessee | 47079 | 36 | 0 |
261299 | 261299 | 2020-06-21 | Hickman | Tennessee | 47081 | 64 | 0 |
261300 | 261300 | 2020-06-21 | Houston | Tennessee | 47083 | 10 | 0 |
261301 | 261301 | 2020-06-21 | Humphreys | Tennessee | 47085 | 18 | 1 |
261302 | 261302 | 2020-06-21 | Jackson | Tennessee | 47087 | 21 | 0 |
261303 | 261303 | 2020-06-21 | Jefferson | Tennessee | 47089 | 61 | 0 |
261304 | 261304 | 2020-06-21 | Johnson | Tennessee | 47091 | 26 | 0 |
261305 | 261305 | 2020-06-21 | Knox | Tennessee | 47093 | 681 | 5 |
261306 | 261306 | 2020-06-21 | Lake | Tennessee | 47095 | 689 | 0 |
261307 | 261307 | 2020-06-21 | Lauderdale | Tennessee | 47097 | 72 | 1 |
261308 | 261308 | 2020-06-21 | Lawrence | Tennessee | 47099 | 81 | 2 |
261309 | 261309 | 2020-06-21 | Lewis | Tennessee | 47101 | 5 | 0 |
261310 | 261310 | 2020-06-21 | Lincoln | Tennessee | 47103 | 49 | 0 |
261311 | 261311 | 2020-06-21 | Loudon | Tennessee | 47105 | 232 | 1 |
261312 | 261312 | 2020-06-21 | Macon | Tennessee | 47111 | 222 | 3 |
261313 | 261313 | 2020-06-21 | Madison | Tennessee | 47113 | 193 | 2 |
261314 | 261314 | 2020-06-21 | Marion | Tennessee | 47115 | 50 | 3 |
261315 | 261315 | 2020-06-21 | Marshall | Tennessee | 47117 | 46 | 1 |
261316 | 261316 | 2020-06-21 | Maury | Tennessee | 47119 | 220 | 2 |
261317 | 261317 | 2020-06-21 | McMinn | Tennessee | 47107 | 173 | 15 |
261318 | 261318 | 2020-06-21 | McNairy | Tennessee | 47109 | 40 | 0 |
261319 | 261319 | 2020-06-21 | Meigs | Tennessee | 47121 | 31 | 0 |
261320 | 261320 | 2020-06-21 | Monroe | Tennessee | 47123 | 108 | 4 |
261321 | 261321 | 2020-06-21 | Montgomery | Tennessee | 47125 | 384 | 5 |
261322 | 261322 | 2020-06-21 | Moore | Tennessee | 47127 | 5 | 0 |
261323 | 261323 | 2020-06-21 | Morgan | Tennessee | 47129 | 22 | 1 |
261324 | 261324 | 2020-06-21 | Obion | Tennessee | 47131 | 71 | 1 |
261325 | 261325 | 2020-06-21 | Overton | Tennessee | 47133 | 42 | 0 |
261326 | 261326 | 2020-06-21 | Perry | Tennessee | 47135 | 28 | 0 |
261327 | 261327 | 2020-06-21 | Pickett | Tennessee | 47137 | 4 | 0 |
261328 | 261328 | 2020-06-21 | Polk | Tennessee | 47139 | 32 | 0 |
261329 | 261329 | 2020-06-21 | Putnam | Tennessee | 47141 | 663 | 7 |
261330 | 261330 | 2020-06-21 | Rhea | Tennessee | 47143 | 256 | 0 |
261331 | 261331 | 2020-06-21 | Roane | Tennessee | 47145 | 34 | 0 |
261332 | 261332 | 2020-06-21 | Robertson | Tennessee | 47147 | 705 | 9 |
261333 | 261333 | 2020-06-21 | Rutherford | Tennessee | 47149 | 2060 | 32 |
261334 | 261334 | 2020-06-21 | Scott | Tennessee | 47151 | 14 | 0 |
261335 | 261335 | 2020-06-21 | Sequatchie | Tennessee | 47153 | 24 | 0 |
261336 | 261336 | 2020-06-21 | Sevier | Tennessee | 47155 | 420 | 3 |
261337 | 261337 | 2020-06-21 | Shelby | Tennessee | 47157 | 7916 | 163 |
261338 | 261338 | 2020-06-21 | Smith | Tennessee | 47159 | 50 | 1 |
261339 | 261339 | 2020-06-21 | Stewart | Tennessee | 47161 | 17 | 0 |
261340 | 261340 | 2020-06-21 | Sullivan | Tennessee | 47163 | 72 | 2 |
261341 | 261341 | 2020-06-21 | Sumner | Tennessee | 47165 | 1181 | 49 |
261342 | 261342 | 2020-06-21 | Tipton | Tennessee | 47167 | 562 | 4 |
261343 | 261343 | 2020-06-21 | Trousdale | Tennessee | 47169 | 1466 | 5 |
261344 | 261344 | 2020-06-21 | Unicoi | Tennessee | 47171 | 52 | 0 |
261345 | 261345 | 2020-06-21 | Union | Tennessee | 47173 | 10 | 0 |
261346 | 261346 | 2020-06-21 | Van Buren | Tennessee | 47175 | 5 | 0 |
261347 | 261347 | 2020-06-21 | Warren | Tennessee | 47177 | 34 | 0 |
261348 | 261348 | 2020-06-21 | Washington | Tennessee | 47179 | 102 | 0 |
261349 | 261349 | 2020-06-21 | Wayne | Tennessee | 47181 | 64 | 0 |
261350 | 261350 | 2020-06-21 | Weakley | Tennessee | 47183 | 42 | 0 |
261351 | 261351 | 2020-06-21 | White | Tennessee | 47185 | 54 | 3 |
261352 | 261352 | 2020-06-21 | Williamson | Tennessee | 47187 | 782 | 13 |
261353 | 261353 | 2020-06-21 | Wilson | Tennessee | 47189 | 616 | 15 |
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);