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-07-21 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
356321 | 356321 | 2020-07-21 | Anderson | Tennessee | 47001 | 327 | 3 |
356322 | 356322 | 2020-07-21 | Bedford | Tennessee | 47003 | 695 | 10 |
356323 | 356323 | 2020-07-21 | Benton | Tennessee | 47005 | 32 | 1 |
356324 | 356324 | 2020-07-21 | Bledsoe | Tennessee | 47007 | 643 | 1 |
356325 | 356325 | 2020-07-21 | Blount | Tennessee | 47009 | 592 | 6 |
356326 | 356326 | 2020-07-21 | Bradley | Tennessee | 47011 | 1271 | 8 |
356327 | 356327 | 2020-07-21 | Campbell | Tennessee | 47013 | 102 | 1 |
356328 | 356328 | 2020-07-21 | Cannon | Tennessee | 47015 | 72 | 0 |
356329 | 356329 | 2020-07-21 | Carroll | Tennessee | 47017 | 85 | 2 |
356330 | 356330 | 2020-07-21 | Carter | Tennessee | 47019 | 220 | 2 |
356331 | 356331 | 2020-07-21 | Cheatham | Tennessee | 47021 | 375 | 4 |
356332 | 356332 | 2020-07-21 | Chester | Tennessee | 47023 | 125 | 0 |
356333 | 356333 | 2020-07-21 | Claiborne | Tennessee | 47025 | 124 | 0 |
356334 | 356334 | 2020-07-21 | Clay | Tennessee | 47027 | 35 | 0 |
356335 | 356335 | 2020-07-21 | Cocke | Tennessee | 47029 | 231 | 1 |
356336 | 356336 | 2020-07-21 | Coffee | Tennessee | 47031 | 220 | 0 |
356337 | 356337 | 2020-07-21 | Crockett | Tennessee | 47033 | 113 | 3 |
356338 | 356338 | 2020-07-21 | Cumberland | Tennessee | 47035 | 273 | 6 |
356339 | 356339 | 2020-07-21 | Davidson | Tennessee | 47037 | 18076 | 172 |
356340 | 356340 | 2020-07-21 | DeKalb | Tennessee | 47041 | 180 | 1 |
356341 | 356341 | 2020-07-21 | Decatur | Tennessee | 47039 | 69 | 0 |
356342 | 356342 | 2020-07-21 | Dickson | Tennessee | 47043 | 398 | 0 |
356343 | 356343 | 2020-07-21 | Dyer | Tennessee | 47045 | 383 | 5 |
356344 | 356344 | 2020-07-21 | Fayette | Tennessee | 47047 | 495 | 7 |
356345 | 356345 | 2020-07-21 | Fentress | Tennessee | 47049 | 45 | 0 |
356346 | 356346 | 2020-07-21 | Franklin | Tennessee | 47051 | 166 | 3 |
356347 | 356347 | 2020-07-21 | Gibson | Tennessee | 47053 | 327 | 1 |
356348 | 356348 | 2020-07-21 | Giles | Tennessee | 47055 | 213 | 2 |
356349 | 356349 | 2020-07-21 | Grainger | Tennessee | 47057 | 92 | 0 |
356350 | 356350 | 2020-07-21 | Greene | Tennessee | 47059 | 238 | 4 |
356351 | 356351 | 2020-07-21 | Grundy | Tennessee | 47061 | 73 | 2 |
356352 | 356352 | 2020-07-21 | Hamblen | Tennessee | 47063 | 738 | 6 |
356353 | 356353 | 2020-07-21 | Hamilton | Tennessee | 47065 | 4461 | 41 |
356354 | 356354 | 2020-07-21 | Hancock | Tennessee | 47067 | 37 | 0 |
356355 | 356355 | 2020-07-21 | Hardeman | Tennessee | 47069 | 577 | 7 |
356356 | 356356 | 2020-07-21 | Hardin | Tennessee | 47071 | 231 | 7 |
356357 | 356357 | 2020-07-21 | Hawkins | Tennessee | 47073 | 153 | 2 |
356358 | 356358 | 2020-07-21 | Haywood | Tennessee | 47075 | 203 | 4 |
356359 | 356359 | 2020-07-21 | Henderson | Tennessee | 47077 | 206 | 0 |
356360 | 356360 | 2020-07-21 | Henry | Tennessee | 47079 | 69 | 0 |
356361 | 356361 | 2020-07-21 | Hickman | Tennessee | 47081 | 150 | 0 |
356362 | 356362 | 2020-07-21 | Houston | Tennessee | 47083 | 31 | 0 |
356363 | 356363 | 2020-07-21 | Humphreys | Tennessee | 47085 | 62 | 2 |
356364 | 356364 | 2020-07-21 | Jackson | Tennessee | 47087 | 87 | 0 |
356365 | 356365 | 2020-07-21 | Jefferson | Tennessee | 47089 | 284 | 1 |
356366 | 356366 | 2020-07-21 | Johnson | Tennessee | 47091 | 52 | 0 |
356367 | 356367 | 2020-07-21 | Knox | Tennessee | 47093 | 2539 | 20 |
356368 | 356368 | 2020-07-21 | Lake | Tennessee | 47095 | 702 | 0 |
356369 | 356369 | 2020-07-21 | Lauderdale | Tennessee | 47097 | 267 | 5 |
356370 | 356370 | 2020-07-21 | Lawrence | Tennessee | 47099 | 321 | 6 |
356371 | 356371 | 2020-07-21 | Lewis | Tennessee | 47101 | 21 | 0 |
356372 | 356372 | 2020-07-21 | Lincoln | Tennessee | 47103 | 148 | 0 |
356373 | 356373 | 2020-07-21 | Loudon | Tennessee | 47105 | 437 | 3 |
356374 | 356374 | 2020-07-21 | Macon | Tennessee | 47111 | 729 | 9 |
356375 | 356375 | 2020-07-21 | Madison | Tennessee | 47113 | 522 | 3 |
356376 | 356376 | 2020-07-21 | Marion | Tennessee | 47115 | 134 | 4 |
356377 | 356377 | 2020-07-21 | Marshall | Tennessee | 47117 | 173 | 2 |
356378 | 356378 | 2020-07-21 | Maury | Tennessee | 47119 | 689 | 4 |
356379 | 356379 | 2020-07-21 | McMinn | Tennessee | 47107 | 382 | 19 |
356380 | 356380 | 2020-07-21 | McNairy | Tennessee | 47109 | 178 | 1 |
356381 | 356381 | 2020-07-21 | Meigs | Tennessee | 47121 | 60 | 0 |
356382 | 356382 | 2020-07-21 | Monroe | Tennessee | 47123 | 213 | 7 |
356383 | 356383 | 2020-07-21 | Montgomery | Tennessee | 47125 | 1196 | 9 |
356384 | 356384 | 2020-07-21 | Moore | Tennessee | 47127 | 32 | 0 |
356385 | 356385 | 2020-07-21 | Morgan | Tennessee | 47129 | 45 | 1 |
356386 | 356386 | 2020-07-21 | Obion | Tennessee | 47131 | 191 | 3 |
356387 | 356387 | 2020-07-21 | Overton | Tennessee | 47133 | 98 | 1 |
356388 | 356388 | 2020-07-21 | Perry | Tennessee | 47135 | 52 | 0 |
356389 | 356389 | 2020-07-21 | Pickett | Tennessee | 47137 | 13 | 1 |
356390 | 356390 | 2020-07-21 | Polk | Tennessee | 47139 | 75 | 0 |
356391 | 356391 | 2020-07-21 | Putnam | Tennessee | 47141 | 1267 | 8 |
356392 | 356392 | 2020-07-21 | Rhea | Tennessee | 47143 | 409 | 0 |
356393 | 356393 | 2020-07-21 | Roane | Tennessee | 47145 | 147 | 0 |
356394 | 356394 | 2020-07-21 | Robertson | Tennessee | 47147 | 1160 | 15 |
356395 | 356395 | 2020-07-21 | Rutherford | Tennessee | 47149 | 4716 | 43 |
356396 | 356396 | 2020-07-21 | Scott | Tennessee | 47151 | 38 | 0 |
356397 | 356397 | 2020-07-21 | Sequatchie | Tennessee | 47153 | 64 | 0 |
356398 | 356398 | 2020-07-21 | Sevier | Tennessee | 47155 | 1156 | 4 |
356399 | 356399 | 2020-07-21 | Shelby | Tennessee | 47157 | 16978 | 252 |
356400 | 356400 | 2020-07-21 | Smith | Tennessee | 47159 | 259 | 2 |
356401 | 356401 | 2020-07-21 | Stewart | Tennessee | 47161 | 47 | 0 |
356402 | 356402 | 2020-07-21 | Sullivan | Tennessee | 47163 | 444 | 6 |
356403 | 356403 | 2020-07-21 | Sumner | Tennessee | 47165 | 2571 | 62 |
356404 | 356404 | 2020-07-21 | Tipton | Tennessee | 47167 | 835 | 8 |
356405 | 356405 | 2020-07-21 | Trousdale | Tennessee | 47169 | 1547 | 6 |
356406 | 356406 | 2020-07-21 | Unicoi | Tennessee | 47171 | 70 | 0 |
356407 | 356407 | 2020-07-21 | Union | Tennessee | 47173 | 56 | 0 |
356408 | 356408 | 2020-07-21 | Van Buren | Tennessee | 47175 | 15 | 0 |
356409 | 356409 | 2020-07-21 | Warren | Tennessee | 47177 | 248 | 3 |
356410 | 356410 | 2020-07-21 | Washington | Tennessee | 47179 | 490 | 0 |
356411 | 356411 | 2020-07-21 | Wayne | Tennessee | 47181 | 157 | 0 |
356412 | 356412 | 2020-07-21 | Weakley | Tennessee | 47183 | 109 | 1 |
356413 | 356413 | 2020-07-21 | White | Tennessee | 47185 | 132 | 3 |
356414 | 356414 | 2020-07-21 | Williamson | Tennessee | 47187 | 2599 | 18 |
356415 | 356415 | 2020-07-21 | Wilson | Tennessee | 47189 | 1664 | 19 |
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);