ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where "date" is on date 2020-08-05 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
404523 | 404523 | 2020-08-05 | Anderson | Tennessee | 47001 | 637 | 6 |
404524 | 404524 | 2020-08-05 | Bedford | Tennessee | 47003 | 890 | 11 |
404525 | 404525 | 2020-08-05 | Benton | Tennessee | 47005 | 111 | 1 |
404526 | 404526 | 2020-08-05 | Bledsoe | Tennessee | 47007 | 674 | 1 |
404527 | 404527 | 2020-08-05 | Blount | Tennessee | 47009 | 1186 | 8 |
404528 | 404528 | 2020-08-05 | Bradley | Tennessee | 47011 | 1771 | 12 |
404529 | 404529 | 2020-08-05 | Campbell | Tennessee | 47013 | 224 | 1 |
404530 | 404530 | 2020-08-05 | Cannon | Tennessee | 47015 | 131 | 0 |
404531 | 404531 | 2020-08-05 | Carroll | Tennessee | 47017 | 251 | 3 |
404532 | 404532 | 2020-08-05 | Carter | Tennessee | 47019 | 452 | 5 |
404533 | 404533 | 2020-08-05 | Cheatham | Tennessee | 47021 | 554 | 6 |
404534 | 404534 | 2020-08-05 | Chester | Tennessee | 47023 | 201 | 2 |
404535 | 404535 | 2020-08-05 | Claiborne | Tennessee | 47025 | 235 | 0 |
404536 | 404536 | 2020-08-05 | Clay | Tennessee | 47027 | 66 | 0 |
404537 | 404537 | 2020-08-05 | Cocke | Tennessee | 47029 | 421 | 2 |
404538 | 404538 | 2020-08-05 | Coffee | Tennessee | 47031 | 448 | 2 |
404539 | 404539 | 2020-08-05 | Crockett | Tennessee | 47033 | 246 | 4 |
404540 | 404540 | 2020-08-05 | Cumberland | Tennessee | 47035 | 397 | 6 |
404541 | 404541 | 2020-08-05 | Davidson | Tennessee | 47037 | 21997 | 208 |
404542 | 404542 | 2020-08-05 | DeKalb | Tennessee | 47041 | 326 | 1 |
404543 | 404543 | 2020-08-05 | Decatur | Tennessee | 47039 | 174 | 2 |
404544 | 404544 | 2020-08-05 | Dickson | Tennessee | 47043 | 630 | 1 |
404545 | 404545 | 2020-08-05 | Dyer | Tennessee | 47045 | 579 | 7 |
404546 | 404546 | 2020-08-05 | Fayette | Tennessee | 47047 | 646 | 8 |
404547 | 404547 | 2020-08-05 | Fentress | Tennessee | 47049 | 76 | 0 |
404548 | 404548 | 2020-08-05 | Franklin | Tennessee | 47051 | 296 | 4 |
404549 | 404549 | 2020-08-05 | Gibson | Tennessee | 47053 | 615 | 2 |
404550 | 404550 | 2020-08-05 | Giles | Tennessee | 47055 | 360 | 12 |
404551 | 404551 | 2020-08-05 | Grainger | Tennessee | 47057 | 181 | 0 |
404552 | 404552 | 2020-08-05 | Greene | Tennessee | 47059 | 398 | 6 |
404553 | 404553 | 2020-08-05 | Grundy | Tennessee | 47061 | 104 | 2 |
404554 | 404554 | 2020-08-05 | Hamblen | Tennessee | 47063 | 1311 | 13 |
404555 | 404555 | 2020-08-05 | Hamilton | Tennessee | 47065 | 5803 | 49 |
404556 | 404556 | 2020-08-05 | Hancock | Tennessee | 47067 | 76 | 1 |
404557 | 404557 | 2020-08-05 | Hardeman | Tennessee | 47069 | 843 | 12 |
404558 | 404558 | 2020-08-05 | Hardin | Tennessee | 47071 | 426 | 7 |
404559 | 404559 | 2020-08-05 | Hawkins | Tennessee | 47073 | 391 | 5 |
404560 | 404560 | 2020-08-05 | Haywood | Tennessee | 47075 | 414 | 5 |
404561 | 404561 | 2020-08-05 | Henderson | Tennessee | 47077 | 483 | 0 |
404562 | 404562 | 2020-08-05 | Henry | Tennessee | 47079 | 231 | 0 |
404563 | 404563 | 2020-08-05 | Hickman | Tennessee | 47081 | 240 | 0 |
404564 | 404564 | 2020-08-05 | Houston | Tennessee | 47083 | 54 | 0 |
404565 | 404565 | 2020-08-05 | Humphreys | Tennessee | 47085 | 113 | 3 |
404566 | 404566 | 2020-08-05 | Jackson | Tennessee | 47087 | 109 | 1 |
404567 | 404567 | 2020-08-05 | Jefferson | Tennessee | 47089 | 513 | 3 |
404568 | 404568 | 2020-08-05 | Johnson | Tennessee | 47091 | 214 | 0 |
404569 | 404569 | 2020-08-05 | Knox | Tennessee | 47093 | 4440 | 40 |
404570 | 404570 | 2020-08-05 | Lake | Tennessee | 47095 | 758 | 0 |
404571 | 404571 | 2020-08-05 | Lauderdale | Tennessee | 47097 | 445 | 7 |
404572 | 404572 | 2020-08-05 | Lawrence | Tennessee | 47099 | 497 | 6 |
404573 | 404573 | 2020-08-05 | Lewis | Tennessee | 47101 | 62 | 1 |
404574 | 404574 | 2020-08-05 | Lincoln | Tennessee | 47103 | 259 | 1 |
404575 | 404575 | 2020-08-05 | Loudon | Tennessee | 47105 | 686 | 3 |
404576 | 404576 | 2020-08-05 | Macon | Tennessee | 47111 | 847 | 13 |
404577 | 404577 | 2020-08-05 | Madison | Tennessee | 47113 | 957 | 14 |
404578 | 404578 | 2020-08-05 | Marion | Tennessee | 47115 | 210 | 4 |
404579 | 404579 | 2020-08-05 | Marshall | Tennessee | 47117 | 271 | 3 |
404580 | 404580 | 2020-08-05 | Maury | Tennessee | 47119 | 1107 | 7 |
404581 | 404581 | 2020-08-05 | McMinn | Tennessee | 47107 | 498 | 20 |
404582 | 404582 | 2020-08-05 | McNairy | Tennessee | 47109 | 335 | 5 |
404583 | 404583 | 2020-08-05 | Meigs | Tennessee | 47121 | 99 | 0 |
404584 | 404584 | 2020-08-05 | Monroe | Tennessee | 47123 | 380 | 9 |
404585 | 404585 | 2020-08-05 | Montgomery | Tennessee | 47125 | 1781 | 13 |
404586 | 404586 | 2020-08-05 | Moore | Tennessee | 47127 | 53 | 0 |
404587 | 404587 | 2020-08-05 | Morgan | Tennessee | 47129 | 94 | 1 |
404588 | 404588 | 2020-08-05 | Obion | Tennessee | 47131 | 464 | 4 |
404589 | 404589 | 2020-08-05 | Overton | Tennessee | 47133 | 141 | 1 |
404590 | 404590 | 2020-08-05 | Perry | Tennessee | 47135 | 77 | 0 |
404591 | 404591 | 2020-08-05 | Pickett | Tennessee | 47137 | 27 | 1 |
404592 | 404592 | 2020-08-05 | Polk | Tennessee | 47139 | 181 | 3 |
404593 | 404593 | 2020-08-05 | Putnam | Tennessee | 47141 | 1646 | 13 |
404594 | 404594 | 2020-08-05 | Rhea | Tennessee | 47143 | 514 | 1 |
404595 | 404595 | 2020-08-05 | Roane | Tennessee | 47145 | 398 | 2 |
404596 | 404596 | 2020-08-05 | Robertson | Tennessee | 47147 | 1475 | 19 |
404597 | 404597 | 2020-08-05 | Rutherford | Tennessee | 47149 | 6254 | 53 |
404598 | 404598 | 2020-08-05 | Scott | Tennessee | 47151 | 105 | 0 |
404599 | 404599 | 2020-08-05 | Sequatchie | Tennessee | 47153 | 96 | 0 |
404600 | 404600 | 2020-08-05 | Sevier | Tennessee | 47155 | 1763 | 6 |
404601 | 404601 | 2020-08-05 | Shelby | Tennessee | 47157 | 22317 | 298 |
404602 | 404602 | 2020-08-05 | Smith | Tennessee | 47159 | 393 | 3 |
404603 | 404603 | 2020-08-05 | Stewart | Tennessee | 47161 | 72 | 0 |
404604 | 404604 | 2020-08-05 | Sullivan | Tennessee | 47163 | 859 | 11 |
404605 | 404605 | 2020-08-05 | Sumner | Tennessee | 47165 | 3264 | 71 |
404606 | 404606 | 2020-08-05 | Tipton | Tennessee | 47167 | 1137 | 9 |
404607 | 404607 | 2020-08-05 | Trousdale | Tennessee | 47169 | 1576 | 6 |
404608 | 404608 | 2020-08-05 | Unicoi | Tennessee | 47171 | 141 | 0 |
404609 | 404609 | 2020-08-05 | Union | Tennessee | 47173 | 133 | 0 |
404610 | 404610 | 2020-08-05 | Unknown | Tennessee | 96 | 1 | |
404611 | 404611 | 2020-08-05 | Van Buren | Tennessee | 47175 | 33 | 0 |
404612 | 404612 | 2020-08-05 | Warren | Tennessee | 47177 | 454 | 4 |
404613 | 404613 | 2020-08-05 | Washington | Tennessee | 47179 | 1114 | 2 |
404614 | 404614 | 2020-08-05 | Wayne | Tennessee | 47181 | 222 | 2 |
404615 | 404615 | 2020-08-05 | Weakley | Tennessee | 47183 | 329 | 3 |
404616 | 404616 | 2020-08-05 | White | Tennessee | 47185 | 232 | 3 |
404617 | 404617 | 2020-08-05 | Williamson | Tennessee | 47187 | 3363 | 22 |
404618 | 404618 | 2020-08-05 | Wilson | Tennessee | 47189 | 2152 | 23 |
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);