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-06-22 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
264387 | 264387 | 2020-06-22 | Anderson | Tennessee | 47001 | 75 | 2 |
264388 | 264388 | 2020-06-22 | Bedford | Tennessee | 47003 | 432 | 4 |
264389 | 264389 | 2020-06-22 | Benton | Tennessee | 47005 | 8 | 1 |
264390 | 264390 | 2020-06-22 | Bledsoe | Tennessee | 47007 | 613 | 1 |
264391 | 264391 | 2020-06-22 | Blount | Tennessee | 47009 | 130 | 3 |
264392 | 264392 | 2020-06-22 | Bradley | Tennessee | 47011 | 349 | 3 |
264393 | 264393 | 2020-06-22 | Campbell | Tennessee | 47013 | 26 | 1 |
264394 | 264394 | 2020-06-22 | Cannon | Tennessee | 47015 | 23 | 0 |
264395 | 264395 | 2020-06-22 | Carroll | Tennessee | 47017 | 36 | 1 |
264396 | 264396 | 2020-06-22 | Carter | Tennessee | 47019 | 30 | 1 |
264397 | 264397 | 2020-06-22 | Cheatham | Tennessee | 47021 | 167 | 0 |
264398 | 264398 | 2020-06-22 | Chester | Tennessee | 47023 | 14 | 0 |
264399 | 264399 | 2020-06-22 | Claiborne | Tennessee | 47025 | 16 | 0 |
264400 | 264400 | 2020-06-22 | Clay | Tennessee | 47027 | 13 | 0 |
264401 | 264401 | 2020-06-22 | Cocke | Tennessee | 47029 | 31 | 0 |
264402 | 264402 | 2020-06-22 | Coffee | Tennessee | 47031 | 99 | 0 |
264403 | 264403 | 2020-06-22 | Crockett | Tennessee | 47033 | 25 | 3 |
264404 | 264404 | 2020-06-22 | Cumberland | Tennessee | 47035 | 145 | 3 |
264405 | 264405 | 2020-06-22 | Davidson | Tennessee | 47037 | 8191 | 96 |
264406 | 264406 | 2020-06-22 | DeKalb | Tennessee | 47041 | 42 | 0 |
264407 | 264407 | 2020-06-22 | Decatur | Tennessee | 47039 | 15 | 0 |
264408 | 264408 | 2020-06-22 | Dickson | Tennessee | 47043 | 146 | 0 |
264409 | 264409 | 2020-06-22 | Dyer | Tennessee | 47045 | 164 | 0 |
264410 | 264410 | 2020-06-22 | Fayette | Tennessee | 47047 | 203 | 2 |
264411 | 264411 | 2020-06-22 | Fentress | Tennessee | 47049 | 15 | 0 |
264412 | 264412 | 2020-06-22 | Franklin | Tennessee | 47051 | 69 | 2 |
264413 | 264413 | 2020-06-22 | Gibson | Tennessee | 47053 | 77 | 1 |
264414 | 264414 | 2020-06-22 | Giles | Tennessee | 47055 | 24 | 0 |
264415 | 264415 | 2020-06-22 | Grainger | Tennessee | 47057 | 25 | 0 |
264416 | 264416 | 2020-06-22 | Greene | Tennessee | 47059 | 56 | 2 |
264417 | 264417 | 2020-06-22 | Grundy | Tennessee | 47061 | 48 | 1 |
264418 | 264418 | 2020-06-22 | Hamblen | Tennessee | 47063 | 121 | 4 |
264419 | 264419 | 2020-06-22 | Hamilton | Tennessee | 47065 | 2174 | 28 |
264420 | 264420 | 2020-06-22 | Hancock | Tennessee | 47067 | 3 | 0 |
264421 | 264421 | 2020-06-22 | Hardeman | Tennessee | 47069 | 257 | 1 |
264422 | 264422 | 2020-06-22 | Hardin | Tennessee | 47071 | 69 | 5 |
264423 | 264423 | 2020-06-22 | Hawkins | Tennessee | 47073 | 40 | 2 |
264424 | 264424 | 2020-06-22 | Haywood | Tennessee | 47075 | 48 | 2 |
264425 | 264425 | 2020-06-22 | Henderson | Tennessee | 47077 | 22 | 0 |
264426 | 264426 | 2020-06-22 | Henry | Tennessee | 47079 | 36 | 0 |
264427 | 264427 | 2020-06-22 | Hickman | Tennessee | 47081 | 64 | 0 |
264428 | 264428 | 2020-06-22 | Houston | Tennessee | 47083 | 10 | 0 |
264429 | 264429 | 2020-06-22 | Humphreys | Tennessee | 47085 | 18 | 1 |
264430 | 264430 | 2020-06-22 | Jackson | Tennessee | 47087 | 22 | 0 |
264431 | 264431 | 2020-06-22 | Jefferson | Tennessee | 47089 | 64 | 0 |
264432 | 264432 | 2020-06-22 | Johnson | Tennessee | 47091 | 26 | 0 |
264433 | 264433 | 2020-06-22 | Knox | Tennessee | 47093 | 706 | 5 |
264434 | 264434 | 2020-06-22 | Lake | Tennessee | 47095 | 689 | 0 |
264435 | 264435 | 2020-06-22 | Lauderdale | Tennessee | 47097 | 75 | 1 |
264436 | 264436 | 2020-06-22 | Lawrence | Tennessee | 47099 | 81 | 2 |
264437 | 264437 | 2020-06-22 | Lewis | Tennessee | 47101 | 5 | 0 |
264438 | 264438 | 2020-06-22 | Lincoln | Tennessee | 47103 | 49 | 0 |
264439 | 264439 | 2020-06-22 | Loudon | Tennessee | 47105 | 234 | 1 |
264440 | 264440 | 2020-06-22 | Macon | Tennessee | 47111 | 223 | 3 |
264441 | 264441 | 2020-06-22 | Madison | Tennessee | 47113 | 196 | 2 |
264442 | 264442 | 2020-06-22 | Marion | Tennessee | 47115 | 50 | 3 |
264443 | 264443 | 2020-06-22 | Marshall | Tennessee | 47117 | 46 | 1 |
264444 | 264444 | 2020-06-22 | Maury | Tennessee | 47119 | 224 | 2 |
264445 | 264445 | 2020-06-22 | McMinn | Tennessee | 47107 | 175 | 15 |
264446 | 264446 | 2020-06-22 | McNairy | Tennessee | 47109 | 42 | 0 |
264447 | 264447 | 2020-06-22 | Meigs | Tennessee | 47121 | 31 | 0 |
264448 | 264448 | 2020-06-22 | Monroe | Tennessee | 47123 | 109 | 4 |
264449 | 264449 | 2020-06-22 | Montgomery | Tennessee | 47125 | 385 | 5 |
264450 | 264450 | 2020-06-22 | Moore | Tennessee | 47127 | 5 | 0 |
264451 | 264451 | 2020-06-22 | Morgan | Tennessee | 47129 | 22 | 1 |
264452 | 264452 | 2020-06-22 | Obion | Tennessee | 47131 | 71 | 1 |
264453 | 264453 | 2020-06-22 | Overton | Tennessee | 47133 | 43 | 0 |
264454 | 264454 | 2020-06-22 | Perry | Tennessee | 47135 | 28 | 0 |
264455 | 264455 | 2020-06-22 | Pickett | Tennessee | 47137 | 5 | 0 |
264456 | 264456 | 2020-06-22 | Polk | Tennessee | 47139 | 36 | 0 |
264457 | 264457 | 2020-06-22 | Putnam | Tennessee | 47141 | 673 | 7 |
264458 | 264458 | 2020-06-22 | Rhea | Tennessee | 47143 | 255 | 0 |
264459 | 264459 | 2020-06-22 | Roane | Tennessee | 47145 | 34 | 0 |
264460 | 264460 | 2020-06-22 | Robertson | Tennessee | 47147 | 708 | 10 |
264461 | 264461 | 2020-06-22 | Rutherford | Tennessee | 47149 | 2100 | 32 |
264462 | 264462 | 2020-06-22 | Scott | Tennessee | 47151 | 14 | 0 |
264463 | 264463 | 2020-06-22 | Sequatchie | Tennessee | 47153 | 24 | 0 |
264464 | 264464 | 2020-06-22 | Sevier | Tennessee | 47155 | 422 | 3 |
264465 | 264465 | 2020-06-22 | Shelby | Tennessee | 47157 | 8064 | 165 |
264466 | 264466 | 2020-06-22 | Smith | Tennessee | 47159 | 50 | 1 |
264467 | 264467 | 2020-06-22 | Stewart | Tennessee | 47161 | 17 | 0 |
264468 | 264468 | 2020-06-22 | Sullivan | Tennessee | 47163 | 73 | 2 |
264469 | 264469 | 2020-06-22 | Sumner | Tennessee | 47165 | 1196 | 49 |
264470 | 264470 | 2020-06-22 | Tipton | Tennessee | 47167 | 563 | 4 |
264471 | 264471 | 2020-06-22 | Trousdale | Tennessee | 47169 | 1466 | 5 |
264472 | 264472 | 2020-06-22 | Unicoi | Tennessee | 47171 | 53 | 0 |
264473 | 264473 | 2020-06-22 | Union | Tennessee | 47173 | 10 | 0 |
264474 | 264474 | 2020-06-22 | Van Buren | Tennessee | 47175 | 5 | 0 |
264475 | 264475 | 2020-06-22 | Warren | Tennessee | 47177 | 34 | 0 |
264476 | 264476 | 2020-06-22 | Washington | Tennessee | 47179 | 103 | 0 |
264477 | 264477 | 2020-06-22 | Wayne | Tennessee | 47181 | 65 | 0 |
264478 | 264478 | 2020-06-22 | Weakley | Tennessee | 47183 | 43 | 0 |
264479 | 264479 | 2020-06-22 | White | Tennessee | 47185 | 54 | 3 |
264480 | 264480 | 2020-06-22 | Williamson | Tennessee | 47187 | 793 | 13 |
264481 | 264481 | 2020-06-22 | Wilson | Tennessee | 47189 | 625 | 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);