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 2021-12-16 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2020640 | 2020640 | 2021-12-16 | Anderson | Tennessee | 47001 | 13929 | 241 |
2020641 | 2020641 | 2021-12-16 | Bedford | Tennessee | 47003 | 9735 | 176 |
2020642 | 2020642 | 2021-12-16 | Benton | Tennessee | 47005 | 3054 | 61 |
2020643 | 2020643 | 2021-12-16 | Bledsoe | Tennessee | 47007 | 3599 | 27 |
2020644 | 2020644 | 2021-12-16 | Blount | Tennessee | 47009 | 25118 | 285 |
2020645 | 2020645 | 2021-12-16 | Bradley | Tennessee | 47011 | 23073 | 248 |
2020646 | 2020646 | 2021-12-16 | Campbell | Tennessee | 47013 | 7752 | 95 |
2020647 | 2020647 | 2021-12-16 | Cannon | Tennessee | 47015 | 2920 | 45 |
2020648 | 2020648 | 2021-12-16 | Carroll | Tennessee | 47017 | 5993 | 114 |
2020649 | 2020649 | 2021-12-16 | Carter | Tennessee | 47019 | 11300 | 238 |
2020650 | 2020650 | 2021-12-16 | Cheatham | Tennessee | 47021 | 7364 | 79 |
2020651 | 2020651 | 2021-12-16 | Chester | Tennessee | 47023 | 3665 | 78 |
2020652 | 2020652 | 2021-12-16 | Claiborne | Tennessee | 47025 | 5965 | 120 |
2020653 | 2020653 | 2021-12-16 | Clay | Tennessee | 47027 | 1607 | 37 |
2020654 | 2020654 | 2021-12-16 | Cocke | Tennessee | 47029 | 7735 | 123 |
2020655 | 2020655 | 2021-12-16 | Coffee | Tennessee | 47031 | 11068 | 175 |
2020656 | 2020656 | 2021-12-16 | Crockett | Tennessee | 47033 | 3434 | 65 |
2020657 | 2020657 | 2021-12-16 | Cumberland | Tennessee | 47035 | 11807 | 237 |
2020658 | 2020658 | 2021-12-16 | Davidson | Tennessee | 47037 | 137964 | 1236 |
2020659 | 2020659 | 2021-12-16 | DeKalb | Tennessee | 47041 | 4399 | 79 |
2020660 | 2020660 | 2021-12-16 | Decatur | Tennessee | 47039 | 2524 | 44 |
2020661 | 2020661 | 2021-12-16 | Dickson | Tennessee | 47043 | 10943 | 173 |
2020662 | 2020662 | 2021-12-16 | Dyer | Tennessee | 47045 | 8313 | 157 |
2020663 | 2020663 | 2021-12-16 | Fayette | Tennessee | 47047 | 7629 | 110 |
2020664 | 2020664 | 2021-12-16 | Fentress | Tennessee | 47049 | 3925 | 73 |
2020665 | 2020665 | 2021-12-16 | Franklin | Tennessee | 47051 | 8332 | 110 |
2020666 | 2020666 | 2021-12-16 | Gibson | Tennessee | 47053 | 10965 | 196 |
2020667 | 2020667 | 2021-12-16 | Giles | Tennessee | 47055 | 6309 | 133 |
2020668 | 2020668 | 2021-12-16 | Grainger | Tennessee | 47057 | 4640 | 75 |
2020669 | 2020669 | 2021-12-16 | Greene | Tennessee | 47059 | 14818 | 251 |
2020670 | 2020670 | 2021-12-16 | Grundy | Tennessee | 47061 | 2976 | 45 |
2020671 | 2020671 | 2021-12-16 | Hamblen | Tennessee | 47063 | 13644 | 230 |
2020672 | 2020672 | 2021-12-16 | Hamilton | Tennessee | 47065 | 67102 | 736 |
2020673 | 2020673 | 2021-12-16 | Hancock | Tennessee | 47067 | 1333 | 21 |
2020674 | 2020674 | 2021-12-16 | Hardeman | Tennessee | 47069 | 5261 | 89 |
2020675 | 2020675 | 2021-12-16 | Hardin | Tennessee | 47071 | 5792 | 93 |
2020676 | 2020676 | 2021-12-16 | Hawkins | Tennessee | 47073 | 11155 | 194 |
2020677 | 2020677 | 2021-12-16 | Haywood | Tennessee | 47075 | 3962 | 79 |
2020678 | 2020678 | 2021-12-16 | Henderson | Tennessee | 47077 | 5982 | 111 |
2020679 | 2020679 | 2021-12-16 | Henry | Tennessee | 47079 | 5677 | 97 |
2020680 | 2020680 | 2021-12-16 | Hickman | Tennessee | 47081 | 4884 | 81 |
2020681 | 2020681 | 2021-12-16 | Houston | Tennessee | 47083 | 1970 | 47 |
2020682 | 2020682 | 2021-12-16 | Humphreys | Tennessee | 47085 | 3425 | 50 |
2020683 | 2020683 | 2021-12-16 | Jackson | Tennessee | 47087 | 2154 | 43 |
2020684 | 2020684 | 2021-12-16 | Jefferson | Tennessee | 47089 | 10478 | 167 |
2020685 | 2020685 | 2021-12-16 | Johnson | Tennessee | 47091 | 4090 | 54 |
2020686 | 2020686 | 2021-12-16 | Knox | Tennessee | 47093 | 82766 | 991 |
2020687 | 2020687 | 2021-12-16 | Lake | Tennessee | 47095 | 2041 | 32 |
2020688 | 2020688 | 2021-12-16 | Lauderdale | Tennessee | 47097 | 5303 | 73 |
2020689 | 2020689 | 2021-12-16 | Lawrence | Tennessee | 47099 | 9911 | 134 |
2020690 | 2020690 | 2021-12-16 | Lewis | Tennessee | 47101 | 2589 | 44 |
2020691 | 2020691 | 2021-12-16 | Lincoln | Tennessee | 47103 | 6916 | 102 |
2020692 | 2020692 | 2021-12-16 | Loudon | Tennessee | 47105 | 9654 | 110 |
2020693 | 2020693 | 2021-12-16 | Macon | Tennessee | 47111 | 5682 | 100 |
2020694 | 2020694 | 2021-12-16 | Madison | Tennessee | 47113 | 18464 | 331 |
2020695 | 2020695 | 2021-12-16 | Marion | Tennessee | 47115 | 5977 | 77 |
2020696 | 2020696 | 2021-12-16 | Marshall | Tennessee | 47117 | 7140 | 96 |
2020697 | 2020697 | 2021-12-16 | Maury | Tennessee | 47119 | 20233 | 248 |
2020698 | 2020698 | 2021-12-16 | McMinn | Tennessee | 47107 | 10963 | 152 |
2020699 | 2020699 | 2021-12-16 | McNairy | Tennessee | 47109 | 4877 | 78 |
2020700 | 2020700 | 2021-12-16 | Meigs | Tennessee | 47121 | 2299 | 33 |
2020701 | 2020701 | 2021-12-16 | Monroe | Tennessee | 47123 | 10141 | 142 |
2020702 | 2020702 | 2021-12-16 | Montgomery | Tennessee | 47125 | 34367 | 377 |
2020703 | 2020703 | 2021-12-16 | Moore | Tennessee | 47127 | 1483 | 25 |
2020704 | 2020704 | 2021-12-16 | Morgan | Tennessee | 47129 | 4010 | 51 |
2020705 | 2020705 | 2021-12-16 | Obion | Tennessee | 47131 | 7103 | 124 |
2020706 | 2020706 | 2021-12-16 | Overton | Tennessee | 47133 | 5018 | 89 |
2020707 | 2020707 | 2021-12-16 | Perry | Tennessee | 47135 | 1668 | 35 |
2020708 | 2020708 | 2021-12-16 | Pickett | Tennessee | 47137 | 1142 | 26 |
2020709 | 2020709 | 2021-12-16 | Polk | Tennessee | 47139 | 3316 | 37 |
2020710 | 2020710 | 2021-12-16 | Putnam | Tennessee | 47141 | 17423 | 230 |
2020711 | 2020711 | 2021-12-16 | Rhea | Tennessee | 47143 | 7280 | 102 |
2020712 | 2020712 | 2021-12-16 | Roane | Tennessee | 47145 | 10537 | 170 |
2020713 | 2020713 | 2021-12-16 | Robertson | Tennessee | 47147 | 14645 | 207 |
2020714 | 2020714 | 2021-12-16 | Rutherford | Tennessee | 47149 | 65249 | 615 |
2020715 | 2020715 | 2021-12-16 | Scott | Tennessee | 47151 | 5919 | 69 |
2020716 | 2020716 | 2021-12-16 | Sequatchie | Tennessee | 47153 | 3112 | 41 |
2020717 | 2020717 | 2021-12-16 | Sevier | Tennessee | 47155 | 21271 | 294 |
2020718 | 2020718 | 2021-12-16 | Shelby | Tennessee | 47157 | 151851 | 2430 |
2020719 | 2020719 | 2021-12-16 | Smith | Tennessee | 47159 | 4315 | 55 |
2020720 | 2020720 | 2021-12-16 | Stewart | Tennessee | 47161 | 2257 | 39 |
2020721 | 2020721 | 2021-12-16 | Sullivan | Tennessee | 47163 | 29766 | 482 |
2020722 | 2020722 | 2021-12-16 | Sumner | Tennessee | 47165 | 36057 | 461 |
2020723 | 2020723 | 2021-12-16 | Tipton | Tennessee | 47167 | 11946 | 154 |
2020724 | 2020724 | 2021-12-16 | Trousdale | Tennessee | 47169 | 3273 | 28 |
2020725 | 2020725 | 2021-12-16 | Unicoi | Tennessee | 47171 | 3338 | 71 |
2020726 | 2020726 | 2021-12-16 | Union | Tennessee | 47173 | 3585 | 52 |
2020727 | 2020727 | 2021-12-16 | Unknown | Tennessee | 9751 | 146 | |
2020728 | 2020728 | 2021-12-16 | Van Buren | Tennessee | 47175 | 1328 | 33 |
2020729 | 2020729 | 2021-12-16 | Warren | Tennessee | 47177 | 8976 | 135 |
2020730 | 2020730 | 2021-12-16 | Washington | Tennessee | 47179 | 24269 | 351 |
2020731 | 2020731 | 2021-12-16 | Wayne | Tennessee | 47181 | 4208 | 43 |
2020732 | 2020732 | 2021-12-16 | Weakley | Tennessee | 47183 | 6591 | 101 |
2020733 | 2020733 | 2021-12-16 | White | Tennessee | 47185 | 5855 | 103 |
2020734 | 2020734 | 2021-12-16 | Williamson | Tennessee | 47187 | 41991 | 285 |
2020735 | 2020735 | 2021-12-16 | Wilson | Tennessee | 47189 | 28379 | 360 |
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);