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-29 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
481956 | 481956 | 2020-08-29 | Anderson | Tennessee | 47001 | 857 | 8 |
481957 | 481957 | 2020-08-29 | Bedford | Tennessee | 47003 | 1105 | 14 |
481958 | 481958 | 2020-08-29 | Benton | Tennessee | 47005 | 250 | 5 |
481959 | 481959 | 2020-08-29 | Bledsoe | Tennessee | 47007 | 775 | 3 |
481960 | 481960 | 2020-08-29 | Blount | Tennessee | 47009 | 1992 | 17 |
481961 | 481961 | 2020-08-29 | Bradley | Tennessee | 47011 | 2460 | 16 |
481962 | 481962 | 2020-08-29 | Campbell | Tennessee | 47013 | 322 | 2 |
481963 | 481963 | 2020-08-29 | Cannon | Tennessee | 47015 | 198 | 0 |
481964 | 481964 | 2020-08-29 | Carroll | Tennessee | 47017 | 611 | 8 |
481965 | 481965 | 2020-08-29 | Carter | Tennessee | 47019 | 815 | 18 |
481966 | 481966 | 2020-08-29 | Cheatham | Tennessee | 47021 | 709 | 10 |
481967 | 481967 | 2020-08-29 | Chester | Tennessee | 47023 | 376 | 5 |
481968 | 481968 | 2020-08-29 | Claiborne | Tennessee | 47025 | 354 | 3 |
481969 | 481969 | 2020-08-29 | Clay | Tennessee | 47027 | 110 | 0 |
481970 | 481970 | 2020-08-29 | Cocke | Tennessee | 47029 | 639 | 7 |
481971 | 481971 | 2020-08-29 | Coffee | Tennessee | 47031 | 757 | 6 |
481972 | 481972 | 2020-08-29 | Crockett | Tennessee | 47033 | 397 | 14 |
481973 | 481973 | 2020-08-29 | Cumberland | Tennessee | 47035 | 802 | 8 |
481974 | 481974 | 2020-08-29 | Davidson | Tennessee | 47037 | 25860 | 255 |
481975 | 481975 | 2020-08-29 | DeKalb | Tennessee | 47041 | 458 | 5 |
481976 | 481976 | 2020-08-29 | Decatur | Tennessee | 47039 | 302 | 4 |
481977 | 481977 | 2020-08-29 | Dickson | Tennessee | 47043 | 904 | 9 |
481978 | 481978 | 2020-08-29 | Dyer | Tennessee | 47045 | 947 | 10 |
481979 | 481979 | 2020-08-29 | Fayette | Tennessee | 47047 | 875 | 10 |
481980 | 481980 | 2020-08-29 | Fentress | Tennessee | 47049 | 208 | 0 |
481981 | 481981 | 2020-08-29 | Franklin | Tennessee | 47051 | 483 | 4 |
481982 | 481982 | 2020-08-29 | Gibson | Tennessee | 47053 | 1087 | 14 |
481983 | 481983 | 2020-08-29 | Giles | Tennessee | 47055 | 440 | 14 |
481984 | 481984 | 2020-08-29 | Grainger | Tennessee | 47057 | 270 | 1 |
481985 | 481985 | 2020-08-29 | Greene | Tennessee | 47059 | 816 | 16 |
481986 | 481986 | 2020-08-29 | Grundy | Tennessee | 47061 | 149 | 2 |
481987 | 481987 | 2020-08-29 | Hamblen | Tennessee | 47063 | 1646 | 21 |
481988 | 481988 | 2020-08-29 | Hamilton | Tennessee | 47065 | 7939 | 74 |
481989 | 481989 | 2020-08-29 | Hancock | Tennessee | 47067 | 91 | 2 |
481990 | 481990 | 2020-08-29 | Hardeman | Tennessee | 47069 | 1231 | 21 |
481991 | 481991 | 2020-08-29 | Hardin | Tennessee | 47071 | 685 | 10 |
481992 | 481992 | 2020-08-29 | Hawkins | Tennessee | 47073 | 665 | 13 |
481993 | 481993 | 2020-08-29 | Haywood | Tennessee | 47075 | 737 | 11 |
481994 | 481994 | 2020-08-29 | Henderson | Tennessee | 47077 | 865 | 7 |
481995 | 481995 | 2020-08-29 | Henry | Tennessee | 47079 | 452 | 5 |
481996 | 481996 | 2020-08-29 | Hickman | Tennessee | 47081 | 371 | 3 |
481997 | 481997 | 2020-08-29 | Houston | Tennessee | 47083 | 92 | 0 |
481998 | 481998 | 2020-08-29 | Humphreys | Tennessee | 47085 | 167 | 3 |
481999 | 481999 | 2020-08-29 | Jackson | Tennessee | 47087 | 214 | 1 |
482000 | 482000 | 2020-08-29 | Jefferson | Tennessee | 47089 | 785 | 6 |
482001 | 482001 | 2020-08-29 | Johnson | Tennessee | 47091 | 407 | 1 |
482002 | 482002 | 2020-08-29 | Knox | Tennessee | 47093 | 6578 | 56 |
482003 | 482003 | 2020-08-29 | Lake | Tennessee | 47095 | 834 | 2 |
482004 | 482004 | 2020-08-29 | Lauderdale | Tennessee | 47097 | 714 | 12 |
482005 | 482005 | 2020-08-29 | Lawrence | Tennessee | 47099 | 751 | 9 |
482006 | 482006 | 2020-08-29 | Lewis | Tennessee | 47101 | 131 | 1 |
482007 | 482007 | 2020-08-29 | Lincoln | Tennessee | 47103 | 403 | 1 |
482008 | 482008 | 2020-08-29 | Loudon | Tennessee | 47105 | 939 | 3 |
482009 | 482009 | 2020-08-29 | Macon | Tennessee | 47111 | 902 | 15 |
482010 | 482010 | 2020-08-29 | Madison | Tennessee | 47113 | 1763 | 41 |
482011 | 482011 | 2020-08-29 | Marion | Tennessee | 47115 | 323 | 6 |
482012 | 482012 | 2020-08-29 | Marshall | Tennessee | 47117 | 529 | 4 |
482013 | 482013 | 2020-08-29 | Maury | Tennessee | 47119 | 1725 | 14 |
482014 | 482014 | 2020-08-29 | McMinn | Tennessee | 47107 | 788 | 21 |
482015 | 482015 | 2020-08-29 | McNairy | Tennessee | 47109 | 541 | 11 |
482016 | 482016 | 2020-08-29 | Meigs | Tennessee | 47121 | 163 | 2 |
482017 | 482017 | 2020-08-29 | Monroe | Tennessee | 47123 | 726 | 15 |
482018 | 482018 | 2020-08-29 | Montgomery | Tennessee | 47125 | 2452 | 28 |
482019 | 482019 | 2020-08-29 | Moore | Tennessee | 47127 | 92 | 0 |
482020 | 482020 | 2020-08-29 | Morgan | Tennessee | 47129 | 205 | 1 |
482021 | 482021 | 2020-08-29 | Obion | Tennessee | 47131 | 809 | 8 |
482022 | 482022 | 2020-08-29 | Overton | Tennessee | 47133 | 427 | 2 |
482023 | 482023 | 2020-08-29 | Perry | Tennessee | 47135 | 106 | 0 |
482024 | 482024 | 2020-08-29 | Pickett | Tennessee | 47137 | 59 | 1 |
482025 | 482025 | 2020-08-29 | Polk | Tennessee | 47139 | 326 | 10 |
482026 | 482026 | 2020-08-29 | Putnam | Tennessee | 47141 | 2345 | 30 |
482027 | 482027 | 2020-08-29 | Rhea | Tennessee | 47143 | 644 | 3 |
482028 | 482028 | 2020-08-29 | Roane | Tennessee | 47145 | 632 | 2 |
482029 | 482029 | 2020-08-29 | Robertson | Tennessee | 47147 | 1869 | 26 |
482030 | 482030 | 2020-08-29 | Rutherford | Tennessee | 47149 | 7770 | 68 |
482031 | 482031 | 2020-08-29 | Scott | Tennessee | 47151 | 155 | 2 |
482032 | 482032 | 2020-08-29 | Sequatchie | Tennessee | 47153 | 142 | 1 |
482033 | 482033 | 2020-08-29 | Sevier | Tennessee | 47155 | 2219 | 12 |
482034 | 482034 | 2020-08-29 | Shelby | Tennessee | 47157 | 27273 | 380 |
482035 | 482035 | 2020-08-29 | Smith | Tennessee | 47159 | 515 | 8 |
482036 | 482036 | 2020-08-29 | Stewart | Tennessee | 47161 | 95 | 0 |
482037 | 482037 | 2020-08-29 | Sullivan | Tennessee | 47163 | 1597 | 25 |
482038 | 482038 | 2020-08-29 | Sumner | Tennessee | 47165 | 4051 | 86 |
482039 | 482039 | 2020-08-29 | Tipton | Tennessee | 47167 | 1448 | 15 |
482040 | 482040 | 2020-08-29 | Trousdale | Tennessee | 47169 | 1617 | 6 |
482041 | 482041 | 2020-08-29 | Unicoi | Tennessee | 47171 | 221 | 1 |
482042 | 482042 | 2020-08-29 | Union | Tennessee | 47173 | 221 | 1 |
482043 | 482043 | 2020-08-29 | Unknown | Tennessee | 146 | 5 | |
482044 | 482044 | 2020-08-29 | Van Buren | Tennessee | 47175 | 70 | 0 |
482045 | 482045 | 2020-08-29 | Warren | Tennessee | 47177 | 830 | 7 |
482046 | 482046 | 2020-08-29 | Washington | Tennessee | 47179 | 1700 | 12 |
482047 | 482047 | 2020-08-29 | Wayne | Tennessee | 47181 | 297 | 3 |
482048 | 482048 | 2020-08-29 | Weakley | Tennessee | 47183 | 824 | 13 |
482049 | 482049 | 2020-08-29 | White | Tennessee | 47185 | 549 | 7 |
482050 | 482050 | 2020-08-29 | Williamson | Tennessee | 47187 | 4328 | 27 |
482051 | 482051 | 2020-08-29 | Wilson | Tennessee | 47189 | 2791 | 31 |
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);