ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where "date" is on date 2020-08-17 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
443200 | 443200 | 2020-08-17 | Anderson | Tennessee | 47001 | 772 | 6 |
443201 | 443201 | 2020-08-17 | Bedford | Tennessee | 47003 | 987 | 12 |
443202 | 443202 | 2020-08-17 | Benton | Tennessee | 47005 | 187 | 2 |
443203 | 443203 | 2020-08-17 | Bledsoe | Tennessee | 47007 | 751 | 2 |
443204 | 443204 | 2020-08-17 | Blount | Tennessee | 47009 | 1507 | 15 |
443205 | 443205 | 2020-08-17 | Bradley | Tennessee | 47011 | 2175 | 16 |
443206 | 443206 | 2020-08-17 | Campbell | Tennessee | 47013 | 275 | 2 |
443207 | 443207 | 2020-08-17 | Cannon | Tennessee | 47015 | 166 | 0 |
443208 | 443208 | 2020-08-17 | Carroll | Tennessee | 47017 | 401 | 6 |
443209 | 443209 | 2020-08-17 | Carter | Tennessee | 47019 | 643 | 6 |
443210 | 443210 | 2020-08-17 | Cheatham | Tennessee | 47021 | 648 | 9 |
443211 | 443211 | 2020-08-17 | Chester | Tennessee | 47023 | 278 | 2 |
443212 | 443212 | 2020-08-17 | Claiborne | Tennessee | 47025 | 313 | 1 |
443213 | 443213 | 2020-08-17 | Clay | Tennessee | 47027 | 91 | 0 |
443214 | 443214 | 2020-08-17 | Cocke | Tennessee | 47029 | 557 | 5 |
443215 | 443215 | 2020-08-17 | Coffee | Tennessee | 47031 | 617 | 4 |
443216 | 443216 | 2020-08-17 | Crockett | Tennessee | 47033 | 308 | 7 |
443217 | 443217 | 2020-08-17 | Cumberland | Tennessee | 47035 | 592 | 7 |
443218 | 443218 | 2020-08-17 | Davidson | Tennessee | 47037 | 24388 | 230 |
443219 | 443219 | 2020-08-17 | DeKalb | Tennessee | 47041 | 390 | 2 |
443220 | 443220 | 2020-08-17 | Decatur | Tennessee | 47039 | 244 | 3 |
443221 | 443221 | 2020-08-17 | Dickson | Tennessee | 47043 | 784 | 4 |
443222 | 443222 | 2020-08-17 | Dyer | Tennessee | 47045 | 747 | 9 |
443223 | 443223 | 2020-08-17 | Fayette | Tennessee | 47047 | 759 | 8 |
443224 | 443224 | 2020-08-17 | Fentress | Tennessee | 47049 | 124 | 0 |
443225 | 443225 | 2020-08-17 | Franklin | Tennessee | 47051 | 383 | 4 |
443226 | 443226 | 2020-08-17 | Gibson | Tennessee | 47053 | 832 | 9 |
443227 | 443227 | 2020-08-17 | Giles | Tennessee | 47055 | 416 | 14 |
443228 | 443228 | 2020-08-17 | Grainger | Tennessee | 47057 | 223 | 1 |
443229 | 443229 | 2020-08-17 | Greene | Tennessee | 47059 | 609 | 9 |
443230 | 443230 | 2020-08-17 | Grundy | Tennessee | 47061 | 130 | 2 |
443231 | 443231 | 2020-08-17 | Hamblen | Tennessee | 47063 | 1507 | 15 |
443232 | 443232 | 2020-08-17 | Hamilton | Tennessee | 47065 | 6862 | 62 |
443233 | 443233 | 2020-08-17 | Hancock | Tennessee | 47067 | 84 | 2 |
443234 | 443234 | 2020-08-17 | Hardeman | Tennessee | 47069 | 1082 | 18 |
443235 | 443235 | 2020-08-17 | Hardin | Tennessee | 47071 | 517 | 8 |
443236 | 443236 | 2020-08-17 | Hawkins | Tennessee | 47073 | 579 | 10 |
443237 | 443237 | 2020-08-17 | Haywood | Tennessee | 47075 | 619 | 7 |
443238 | 443238 | 2020-08-17 | Henderson | Tennessee | 47077 | 695 | 3 |
443239 | 443239 | 2020-08-17 | Henry | Tennessee | 47079 | 336 | 1 |
443240 | 443240 | 2020-08-17 | Hickman | Tennessee | 47081 | 305 | 1 |
443241 | 443241 | 2020-08-17 | Houston | Tennessee | 47083 | 67 | 0 |
443242 | 443242 | 2020-08-17 | Humphreys | Tennessee | 47085 | 140 | 3 |
443243 | 443243 | 2020-08-17 | Jackson | Tennessee | 47087 | 153 | 1 |
443244 | 443244 | 2020-08-17 | Jefferson | Tennessee | 47089 | 651 | 4 |
443245 | 443245 | 2020-08-17 | Johnson | Tennessee | 47091 | 349 | 1 |
443246 | 443246 | 2020-08-17 | Knox | Tennessee | 47093 | 5623 | 50 |
443247 | 443247 | 2020-08-17 | Lake | Tennessee | 47095 | 804 | 1 |
443248 | 443248 | 2020-08-17 | Lauderdale | Tennessee | 47097 | 569 | 9 |
443249 | 443249 | 2020-08-17 | Lawrence | Tennessee | 47099 | 646 | 7 |
443250 | 443250 | 2020-08-17 | Lewis | Tennessee | 47101 | 89 | 1 |
443251 | 443251 | 2020-08-17 | Lincoln | Tennessee | 47103 | 349 | 1 |
443252 | 443252 | 2020-08-17 | Loudon | Tennessee | 47105 | 815 | 3 |
443253 | 443253 | 2020-08-17 | Macon | Tennessee | 47111 | 871 | 13 |
443254 | 443254 | 2020-08-17 | Madison | Tennessee | 47113 | 1373 | 26 |
443255 | 443255 | 2020-08-17 | Marion | Tennessee | 47115 | 258 | 5 |
443256 | 443256 | 2020-08-17 | Marshall | Tennessee | 47117 | 372 | 4 |
443257 | 443257 | 2020-08-17 | Maury | Tennessee | 47119 | 1445 | 10 |
443258 | 443258 | 2020-08-17 | McMinn | Tennessee | 47107 | 617 | 20 |
443259 | 443259 | 2020-08-17 | McNairy | Tennessee | 47109 | 430 | 6 |
443260 | 443260 | 2020-08-17 | Meigs | Tennessee | 47121 | 121 | 1 |
443261 | 443261 | 2020-08-17 | Monroe | Tennessee | 47123 | 524 | 10 |
443262 | 443262 | 2020-08-17 | Montgomery | Tennessee | 47125 | 2169 | 16 |
443263 | 443263 | 2020-08-17 | Moore | Tennessee | 47127 | 77 | 0 |
443264 | 443264 | 2020-08-17 | Morgan | Tennessee | 47129 | 145 | 1 |
443265 | 443265 | 2020-08-17 | Obion | Tennessee | 47131 | 681 | 4 |
443266 | 443266 | 2020-08-17 | Overton | Tennessee | 47133 | 280 | 1 |
443267 | 443267 | 2020-08-17 | Perry | Tennessee | 47135 | 91 | 0 |
443268 | 443268 | 2020-08-17 | Pickett | Tennessee | 47137 | 38 | 1 |
443269 | 443269 | 2020-08-17 | Polk | Tennessee | 47139 | 270 | 8 |
443270 | 443270 | 2020-08-17 | Putnam | Tennessee | 47141 | 1959 | 20 |
443271 | 443271 | 2020-08-17 | Rhea | Tennessee | 47143 | 583 | 2 |
443272 | 443272 | 2020-08-17 | Roane | Tennessee | 47145 | 542 | 2 |
443273 | 443273 | 2020-08-17 | Robertson | Tennessee | 47147 | 1647 | 21 |
443274 | 443274 | 2020-08-17 | Rutherford | Tennessee | 47149 | 7137 | 59 |
443275 | 443275 | 2020-08-17 | Scott | Tennessee | 47151 | 144 | 2 |
443276 | 443276 | 2020-08-17 | Sequatchie | Tennessee | 47153 | 124 | 1 |
443277 | 443277 | 2020-08-17 | Sevier | Tennessee | 47155 | 2055 | 10 |
443278 | 443278 | 2020-08-17 | Shelby | Tennessee | 47157 | 25275 | 334 |
443279 | 443279 | 2020-08-17 | Smith | Tennessee | 47159 | 483 | 4 |
443280 | 443280 | 2020-08-17 | Stewart | Tennessee | 47161 | 84 | 0 |
443281 | 443281 | 2020-08-17 | Sullivan | Tennessee | 47163 | 1202 | 18 |
443282 | 443282 | 2020-08-17 | Sumner | Tennessee | 47165 | 3649 | 76 |
443283 | 443283 | 2020-08-17 | Tipton | Tennessee | 47167 | 1268 | 12 |
443284 | 443284 | 2020-08-17 | Trousdale | Tennessee | 47169 | 1587 | 6 |
443285 | 443285 | 2020-08-17 | Unicoi | Tennessee | 47171 | 184 | 0 |
443286 | 443286 | 2020-08-17 | Union | Tennessee | 47173 | 179 | 0 |
443287 | 443287 | 2020-08-17 | Van Buren | Tennessee | 47175 | 45 | 0 |
443288 | 443288 | 2020-08-17 | Warren | Tennessee | 47177 | 626 | 6 |
443289 | 443289 | 2020-08-17 | Washington | Tennessee | 47179 | 1466 | 2 |
443290 | 443290 | 2020-08-17 | Wayne | Tennessee | 47181 | 239 | 2 |
443291 | 443291 | 2020-08-17 | Weakley | Tennessee | 47183 | 625 | 5 |
443292 | 443292 | 2020-08-17 | White | Tennessee | 47185 | 345 | 6 |
443293 | 443293 | 2020-08-17 | Williamson | Tennessee | 47187 | 3893 | 26 |
443294 | 443294 | 2020-08-17 | Wilson | Tennessee | 47189 | 2501 | 25 |
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);