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-14 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
239441 | 239441 | 2020-06-14 | Anderson | Tennessee | 47001 | 59 | 2 |
239442 | 239442 | 2020-06-14 | Bedford | Tennessee | 47003 | 378 | 4 |
239443 | 239443 | 2020-06-14 | Benton | Tennessee | 47005 | 8 | 1 |
239444 | 239444 | 2020-06-14 | Bledsoe | Tennessee | 47007 | 614 | 1 |
239445 | 239445 | 2020-06-14 | Blount | Tennessee | 47009 | 104 | 3 |
239446 | 239446 | 2020-06-14 | Bradley | Tennessee | 47011 | 281 | 2 |
239447 | 239447 | 2020-06-14 | Campbell | Tennessee | 47013 | 24 | 1 |
239448 | 239448 | 2020-06-14 | Cannon | Tennessee | 47015 | 34 | 0 |
239449 | 239449 | 2020-06-14 | Carroll | Tennessee | 47017 | 36 | 1 |
239450 | 239450 | 2020-06-14 | Carter | Tennessee | 47019 | 20 | 1 |
239451 | 239451 | 2020-06-14 | Cheatham | Tennessee | 47021 | 153 | 0 |
239452 | 239452 | 2020-06-14 | Chester | Tennessee | 47023 | 12 | 0 |
239453 | 239453 | 2020-06-14 | Claiborne | Tennessee | 47025 | 15 | 0 |
239454 | 239454 | 2020-06-14 | Clay | Tennessee | 47027 | 11 | 0 |
239455 | 239455 | 2020-06-14 | Cocke | Tennessee | 47029 | 26 | 0 |
239456 | 239456 | 2020-06-14 | Coffee | Tennessee | 47031 | 94 | 0 |
239457 | 239457 | 2020-06-14 | Crockett | Tennessee | 47033 | 18 | 3 |
239458 | 239458 | 2020-06-14 | Cumberland | Tennessee | 47035 | 131 | 2 |
239459 | 239459 | 2020-06-14 | Davidson | Tennessee | 47037 | 6885 | 84 |
239460 | 239460 | 2020-06-14 | DeKalb | Tennessee | 47041 | 41 | 0 |
239461 | 239461 | 2020-06-14 | Decatur | Tennessee | 47039 | 14 | 0 |
239462 | 239462 | 2020-06-14 | Dickson | Tennessee | 47043 | 135 | 0 |
239463 | 239463 | 2020-06-14 | Dyer | Tennessee | 47045 | 91 | 0 |
239464 | 239464 | 2020-06-14 | Fayette | Tennessee | 47047 | 172 | 2 |
239465 | 239465 | 2020-06-14 | Fentress | Tennessee | 47049 | 14 | 0 |
239466 | 239466 | 2020-06-14 | Franklin | Tennessee | 47051 | 62 | 2 |
239467 | 239467 | 2020-06-14 | Gibson | Tennessee | 47053 | 68 | 1 |
239468 | 239468 | 2020-06-14 | Giles | Tennessee | 47055 | 22 | 0 |
239469 | 239469 | 2020-06-14 | Grainger | Tennessee | 47057 | 19 | 0 |
239470 | 239470 | 2020-06-14 | Greene | Tennessee | 47059 | 53 | 2 |
239471 | 239471 | 2020-06-14 | Grundy | Tennessee | 47061 | 33 | 1 |
239472 | 239472 | 2020-06-14 | Hamblen | Tennessee | 47063 | 75 | 3 |
239473 | 239473 | 2020-06-14 | Hamilton | Tennessee | 47065 | 1842 | 20 |
239474 | 239474 | 2020-06-14 | Hancock | Tennessee | 47067 | 1 | 0 |
239475 | 239475 | 2020-06-14 | Hardeman | Tennessee | 47069 | 217 | 0 |
239476 | 239476 | 2020-06-14 | Hardin | Tennessee | 47071 | 33 | 4 |
239477 | 239477 | 2020-06-14 | Hawkins | Tennessee | 47073 | 34 | 2 |
239478 | 239478 | 2020-06-14 | Haywood | Tennessee | 47075 | 37 | 2 |
239479 | 239479 | 2020-06-14 | Henderson | Tennessee | 47077 | 18 | 0 |
239480 | 239480 | 2020-06-14 | Henry | Tennessee | 47079 | 35 | 0 |
239481 | 239481 | 2020-06-14 | Hickman | Tennessee | 47081 | 61 | 0 |
239482 | 239482 | 2020-06-14 | Houston | Tennessee | 47083 | 10 | 0 |
239483 | 239483 | 2020-06-14 | Humphreys | Tennessee | 47085 | 18 | 1 |
239484 | 239484 | 2020-06-14 | Jackson | Tennessee | 47087 | 20 | 0 |
239485 | 239485 | 2020-06-14 | Jefferson | Tennessee | 47089 | 45 | 0 |
239486 | 239486 | 2020-06-14 | Johnson | Tennessee | 47091 | 24 | 0 |
239487 | 239487 | 2020-06-14 | Knox | Tennessee | 47093 | 587 | 5 |
239488 | 239488 | 2020-06-14 | Lake | Tennessee | 47095 | 690 | 0 |
239489 | 239489 | 2020-06-14 | Lauderdale | Tennessee | 47097 | 63 | 1 |
239490 | 239490 | 2020-06-14 | Lawrence | Tennessee | 47099 | 64 | 1 |
239491 | 239491 | 2020-06-14 | Lewis | Tennessee | 47101 | 6 | 0 |
239492 | 239492 | 2020-06-14 | Lincoln | Tennessee | 47103 | 47 | 0 |
239493 | 239493 | 2020-06-14 | Loudon | Tennessee | 47105 | 198 | 1 |
239494 | 239494 | 2020-06-14 | Macon | Tennessee | 47111 | 204 | 3 |
239495 | 239495 | 2020-06-14 | Madison | Tennessee | 47113 | 184 | 2 |
239496 | 239496 | 2020-06-14 | Marion | Tennessee | 47115 | 49 | 2 |
239497 | 239497 | 2020-06-14 | Marshall | Tennessee | 47117 | 41 | 1 |
239498 | 239498 | 2020-06-14 | Maury | Tennessee | 47119 | 152 | 1 |
239499 | 239499 | 2020-06-14 | McMinn | Tennessee | 47107 | 165 | 14 |
239500 | 239500 | 2020-06-14 | McNairy | Tennessee | 47109 | 27 | 0 |
239501 | 239501 | 2020-06-14 | Meigs | Tennessee | 47121 | 29 | 0 |
239502 | 239502 | 2020-06-14 | Monroe | Tennessee | 47123 | 86 | 4 |
239503 | 239503 | 2020-06-14 | Montgomery | Tennessee | 47125 | 332 | 5 |
239504 | 239504 | 2020-06-14 | Moore | Tennessee | 47127 | 5 | 0 |
239505 | 239505 | 2020-06-14 | Morgan | Tennessee | 47129 | 19 | 0 |
239506 | 239506 | 2020-06-14 | Obion | Tennessee | 47131 | 61 | 1 |
239507 | 239507 | 2020-06-14 | Overton | Tennessee | 47133 | 37 | 0 |
239508 | 239508 | 2020-06-14 | Perry | Tennessee | 47135 | 27 | 0 |
239509 | 239509 | 2020-06-14 | Pickett | Tennessee | 47137 | 4 | 0 |
239510 | 239510 | 2020-06-14 | Polk | Tennessee | 47139 | 29 | 0 |
239511 | 239511 | 2020-06-14 | Putnam | Tennessee | 47141 | 601 | 6 |
239512 | 239512 | 2020-06-14 | Rhea | Tennessee | 47143 | 232 | 0 |
239513 | 239513 | 2020-06-14 | Roane | Tennessee | 47145 | 33 | 0 |
239514 | 239514 | 2020-06-14 | Robertson | Tennessee | 47147 | 633 | 9 |
239515 | 239515 | 2020-06-14 | Rutherford | Tennessee | 47149 | 1719 | 30 |
239516 | 239516 | 2020-06-14 | Scott | Tennessee | 47151 | 14 | 0 |
239517 | 239517 | 2020-06-14 | Sequatchie | Tennessee | 47153 | 22 | 0 |
239518 | 239518 | 2020-06-14 | Sevier | Tennessee | 47155 | 233 | 2 |
239519 | 239519 | 2020-06-14 | Shelby | Tennessee | 47157 | 6773 | 151 |
239520 | 239520 | 2020-06-14 | Smith | Tennessee | 47159 | 40 | 1 |
239521 | 239521 | 2020-06-14 | Stewart | Tennessee | 47161 | 16 | 0 |
239522 | 239522 | 2020-06-14 | Sullivan | Tennessee | 47163 | 70 | 2 |
239523 | 239523 | 2020-06-14 | Sumner | Tennessee | 47165 | 1088 | 48 |
239524 | 239524 | 2020-06-14 | Tipton | Tennessee | 47167 | 510 | 3 |
239525 | 239525 | 2020-06-14 | Trousdale | Tennessee | 47169 | 1456 | 4 |
239526 | 239526 | 2020-06-14 | Unicoi | Tennessee | 47171 | 53 | 0 |
239527 | 239527 | 2020-06-14 | Union | Tennessee | 47173 | 8 | 0 |
239528 | 239528 | 2020-06-14 | Van Buren | Tennessee | 47175 | 4 | 0 |
239529 | 239529 | 2020-06-14 | Warren | Tennessee | 47177 | 33 | 0 |
239530 | 239530 | 2020-06-14 | Washington | Tennessee | 47179 | 90 | 0 |
239531 | 239531 | 2020-06-14 | Wayne | Tennessee | 47181 | 64 | 0 |
239532 | 239532 | 2020-06-14 | Weakley | Tennessee | 47183 | 30 | 0 |
239533 | 239533 | 2020-06-14 | White | Tennessee | 47185 | 48 | 1 |
239534 | 239534 | 2020-06-14 | Williamson | Tennessee | 47187 | 686 | 12 |
239535 | 239535 | 2020-06-14 | Wilson | Tennessee | 47189 | 515 | 12 |
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);