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-09-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 |
---|---|---|---|---|---|---|---|
559603 | 559603 | 2020-09-22 | Anderson | Tennessee | 47001 | 1138 | 11 |
559604 | 559604 | 2020-09-22 | Bedford | Tennessee | 47003 | 1313 | 17 |
559605 | 559605 | 2020-09-22 | Benton | Tennessee | 47005 | 332 | 9 |
559606 | 559606 | 2020-09-22 | Bledsoe | Tennessee | 47007 | 845 | 4 |
559607 | 559607 | 2020-09-22 | Blount | Tennessee | 47009 | 2449 | 23 |
559608 | 559608 | 2020-09-22 | Bradley | Tennessee | 47011 | 2868 | 17 |
559609 | 559609 | 2020-09-22 | Campbell | Tennessee | 47013 | 421 | 3 |
559610 | 559610 | 2020-09-22 | Cannon | Tennessee | 47015 | 279 | 0 |
559611 | 559611 | 2020-09-22 | Carroll | Tennessee | 47017 | 839 | 18 |
559612 | 559612 | 2020-09-22 | Carter | Tennessee | 47019 | 1127 | 28 |
559613 | 559613 | 2020-09-22 | Cheatham | Tennessee | 47021 | 793 | 10 |
559614 | 559614 | 2020-09-22 | Chester | Tennessee | 47023 | 595 | 9 |
559615 | 559615 | 2020-09-22 | Claiborne | Tennessee | 47025 | 438 | 4 |
559616 | 559616 | 2020-09-22 | Clay | Tennessee | 47027 | 211 | 5 |
559617 | 559617 | 2020-09-22 | Cocke | Tennessee | 47029 | 736 | 9 |
559618 | 559618 | 2020-09-22 | Coffee | Tennessee | 47031 | 1125 | 12 |
559619 | 559619 | 2020-09-22 | Crockett | Tennessee | 47033 | 513 | 19 |
559620 | 559620 | 2020-09-22 | Cumberland | Tennessee | 47035 | 1155 | 18 |
559621 | 559621 | 2020-09-22 | Davidson | Tennessee | 47037 | 28223 | 294 |
559622 | 559622 | 2020-09-22 | DeKalb | Tennessee | 47041 | 547 | 13 |
559623 | 559623 | 2020-09-22 | Decatur | Tennessee | 47039 | 479 | 6 |
559624 | 559624 | 2020-09-22 | Dickson | Tennessee | 47043 | 1207 | 14 |
559625 | 559625 | 2020-09-22 | Dyer | Tennessee | 47045 | 1287 | 12 |
559626 | 559626 | 2020-09-22 | Fayette | Tennessee | 47047 | 1144 | 18 |
559627 | 559627 | 2020-09-22 | Fentress | Tennessee | 47049 | 447 | 3 |
559628 | 559628 | 2020-09-22 | Franklin | Tennessee | 47051 | 926 | 7 |
559629 | 559629 | 2020-09-22 | Gibson | Tennessee | 47053 | 1545 | 20 |
559630 | 559630 | 2020-09-22 | Giles | Tennessee | 47055 | 569 | 17 |
559631 | 559631 | 2020-09-22 | Grainger | Tennessee | 47057 | 354 | 3 |
559632 | 559632 | 2020-09-22 | Greene | Tennessee | 47059 | 1112 | 37 |
559633 | 559633 | 2020-09-22 | Grundy | Tennessee | 47061 | 256 | 5 |
559634 | 559634 | 2020-09-22 | Hamblen | Tennessee | 47063 | 1839 | 25 |
559635 | 559635 | 2020-09-22 | Hamilton | Tennessee | 47065 | 9342 | 92 |
559636 | 559636 | 2020-09-22 | Hancock | Tennessee | 47067 | 106 | 3 |
559637 | 559637 | 2020-09-22 | Hardeman | Tennessee | 47069 | 1534 | 25 |
559638 | 559638 | 2020-09-22 | Hardin | Tennessee | 47071 | 972 | 14 |
559639 | 559639 | 2020-09-22 | Hawkins | Tennessee | 47073 | 773 | 16 |
559640 | 559640 | 2020-09-22 | Haywood | Tennessee | 47075 | 924 | 16 |
559641 | 559641 | 2020-09-22 | Henderson | Tennessee | 47077 | 1135 | 20 |
559642 | 559642 | 2020-09-22 | Henry | Tennessee | 47079 | 607 | 9 |
559643 | 559643 | 2020-09-22 | Hickman | Tennessee | 47081 | 546 | 5 |
559644 | 559644 | 2020-09-22 | Houston | Tennessee | 47083 | 193 | 1 |
559645 | 559645 | 2020-09-22 | Humphreys | Tennessee | 47085 | 235 | 3 |
559646 | 559646 | 2020-09-22 | Jackson | Tennessee | 47087 | 308 | 5 |
559647 | 559647 | 2020-09-22 | Jefferson | Tennessee | 47089 | 1074 | 14 |
559648 | 559648 | 2020-09-22 | Johnson | Tennessee | 47091 | 649 | 2 |
559649 | 559649 | 2020-09-22 | Knox | Tennessee | 47093 | 9692 | 76 |
559650 | 559650 | 2020-09-22 | Lake | Tennessee | 47095 | 915 | 2 |
559651 | 559651 | 2020-09-22 | Lauderdale | Tennessee | 47097 | 942 | 15 |
559652 | 559652 | 2020-09-22 | Lawrence | Tennessee | 47099 | 977 | 11 |
559653 | 559653 | 2020-09-22 | Lewis | Tennessee | 47101 | 179 | 1 |
559654 | 559654 | 2020-09-22 | Lincoln | Tennessee | 47103 | 581 | 1 |
559655 | 559655 | 2020-09-22 | Loudon | Tennessee | 47105 | 1121 | 6 |
559656 | 559656 | 2020-09-22 | Macon | Tennessee | 47111 | 1023 | 20 |
559657 | 559657 | 2020-09-22 | Madison | Tennessee | 47113 | 2750 | 60 |
559658 | 559658 | 2020-09-22 | Marion | Tennessee | 47115 | 504 | 7 |
559659 | 559659 | 2020-09-22 | Marshall | Tennessee | 47117 | 720 | 5 |
559660 | 559660 | 2020-09-22 | Maury | Tennessee | 47119 | 2274 | 23 |
559661 | 559661 | 2020-09-22 | McMinn | Tennessee | 47107 | 1076 | 24 |
559662 | 559662 | 2020-09-22 | McNairy | Tennessee | 47109 | 816 | 18 |
559663 | 559663 | 2020-09-22 | Meigs | Tennessee | 47121 | 221 | 3 |
559664 | 559664 | 2020-09-22 | Monroe | Tennessee | 47123 | 1003 | 16 |
559665 | 559665 | 2020-09-22 | Montgomery | Tennessee | 47125 | 2971 | 43 |
559666 | 559666 | 2020-09-22 | Moore | Tennessee | 47127 | 154 | 1 |
559667 | 559667 | 2020-09-22 | Morgan | Tennessee | 47129 | 306 | 3 |
559668 | 559668 | 2020-09-22 | Obion | Tennessee | 47131 | 1096 | 9 |
559669 | 559669 | 2020-09-22 | Overton | Tennessee | 47133 | 681 | 5 |
559670 | 559670 | 2020-09-22 | Perry | Tennessee | 47135 | 150 | 0 |
559671 | 559671 | 2020-09-22 | Pickett | Tennessee | 47137 | 103 | 2 |
559672 | 559672 | 2020-09-22 | Polk | Tennessee | 47139 | 380 | 11 |
559673 | 559673 | 2020-09-22 | Putnam | Tennessee | 47141 | 3088 | 38 |
559674 | 559674 | 2020-09-22 | Rhea | Tennessee | 47143 | 788 | 11 |
559675 | 559675 | 2020-09-22 | Roane | Tennessee | 47145 | 849 | 3 |
559676 | 559676 | 2020-09-22 | Robertson | Tennessee | 47147 | 2173 | 34 |
559677 | 559677 | 2020-09-22 | Rutherford | Tennessee | 47149 | 9058 | 88 |
559678 | 559678 | 2020-09-22 | Scott | Tennessee | 47151 | 202 | 2 |
559679 | 559679 | 2020-09-22 | Sequatchie | Tennessee | 47153 | 223 | 3 |
559680 | 559680 | 2020-09-22 | Sevier | Tennessee | 47155 | 2537 | 15 |
559681 | 559681 | 2020-09-22 | Shelby | Tennessee | 47157 | 30594 | 449 |
559682 | 559682 | 2020-09-22 | Smith | Tennessee | 47159 | 678 | 10 |
559683 | 559683 | 2020-09-22 | Stewart | Tennessee | 47161 | 177 | 2 |
559684 | 559684 | 2020-09-22 | Sullivan | Tennessee | 47163 | 2071 | 31 |
559685 | 559685 | 2020-09-22 | Sumner | Tennessee | 47165 | 4721 | 93 |
559686 | 559686 | 2020-09-22 | Tipton | Tennessee | 47167 | 1745 | 17 |
559687 | 559687 | 2020-09-22 | Trousdale | Tennessee | 47169 | 1651 | 7 |
559688 | 559688 | 2020-09-22 | Unicoi | Tennessee | 47171 | 280 | 1 |
559689 | 559689 | 2020-09-22 | Union | Tennessee | 47173 | 339 | 1 |
559690 | 559690 | 2020-09-22 | Van Buren | Tennessee | 47175 | 154 | 0 |
559691 | 559691 | 2020-09-22 | Warren | Tennessee | 47177 | 1012 | 7 |
559692 | 559692 | 2020-09-22 | Washington | Tennessee | 47179 | 2186 | 34 |
559693 | 559693 | 2020-09-22 | Wayne | Tennessee | 47181 | 1485 | 6 |
559694 | 559694 | 2020-09-22 | Weakley | Tennessee | 47183 | 1122 | 19 |
559695 | 559695 | 2020-09-22 | White | Tennessee | 47185 | 788 | 9 |
559696 | 559696 | 2020-09-22 | Williamson | Tennessee | 47187 | 5096 | 36 |
559697 | 559697 | 2020-09-22 | Wilson | Tennessee | 47189 | 3384 | 43 |
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);