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-01-24 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
961908 | 961908 | 2021-01-24 | Anderson | Tennessee | 47001 | 7013 | 114 |
961909 | 961909 | 2021-01-24 | Bedford | Tennessee | 47003 | 5449 | 91 |
961910 | 961910 | 2021-01-24 | Benton | Tennessee | 47005 | 1340 | 35 |
961911 | 961911 | 2021-01-24 | Bledsoe | Tennessee | 47007 | 1781 | 11 |
961912 | 961912 | 2021-01-24 | Blount | Tennessee | 47009 | 12366 | 134 |
961913 | 961913 | 2021-01-24 | Bradley | Tennessee | 47011 | 11210 | 98 |
961914 | 961914 | 2021-01-24 | Campbell | Tennessee | 47013 | 3384 | 41 |
961915 | 961915 | 2021-01-24 | Cannon | Tennessee | 47015 | 1616 | 20 |
961916 | 961916 | 2021-01-24 | Carroll | Tennessee | 47017 | 3182 | 61 |
961917 | 961917 | 2021-01-24 | Carter | Tennessee | 47019 | 5199 | 119 |
961918 | 961918 | 2021-01-24 | Cheatham | Tennessee | 47021 | 3495 | 31 |
961919 | 961919 | 2021-01-24 | Chester | Tennessee | 47023 | 1785 | 39 |
961920 | 961920 | 2021-01-24 | Claiborne | Tennessee | 47025 | 2288 | 33 |
961921 | 961921 | 2021-01-24 | Clay | Tennessee | 47027 | 965 | 26 |
961922 | 961922 | 2021-01-24 | Cocke | Tennessee | 47029 | 3565 | 61 |
961923 | 961923 | 2021-01-24 | Coffee | Tennessee | 47031 | 5781 | 82 |
961924 | 961924 | 2021-01-24 | Crockett | Tennessee | 47033 | 1834 | 38 |
961925 | 961925 | 2021-01-24 | Cumberland | Tennessee | 47035 | 5556 | 76 |
961926 | 961926 | 2021-01-24 | Davidson | Tennessee | 47037 | 81561 | 693 |
961927 | 961927 | 2021-01-24 | DeKalb | Tennessee | 47041 | 2473 | 42 |
961928 | 961928 | 2021-01-24 | Decatur | Tennessee | 47039 | 1489 | 27 |
961929 | 961929 | 2021-01-24 | Dickson | Tennessee | 47043 | 5584 | 82 |
961930 | 961930 | 2021-01-24 | Dyer | Tennessee | 47045 | 4869 | 86 |
961931 | 961931 | 2021-01-24 | Fayette | Tennessee | 47047 | 4146 | 52 |
961932 | 961932 | 2021-01-24 | Fentress | Tennessee | 47049 | 2177 | 35 |
961933 | 961933 | 2021-01-24 | Franklin | Tennessee | 47051 | 4249 | 65 |
961934 | 961934 | 2021-01-24 | Gibson | Tennessee | 47053 | 5761 | 116 |
961935 | 961935 | 2021-01-24 | Giles | Tennessee | 47055 | 3333 | 76 |
961936 | 961936 | 2021-01-24 | Grainger | Tennessee | 47057 | 2169 | 39 |
961937 | 961937 | 2021-01-24 | Greene | Tennessee | 47059 | 6766 | 116 |
961938 | 961938 | 2021-01-24 | Grundy | Tennessee | 47061 | 1430 | 22 |
961939 | 961939 | 2021-01-24 | Hamblen | Tennessee | 47063 | 7244 | 118 |
961940 | 961940 | 2021-01-24 | Hamilton | Tennessee | 47065 | 36978 | 338 |
961941 | 961941 | 2021-01-24 | Hancock | Tennessee | 47067 | 419 | 7 |
961942 | 961942 | 2021-01-24 | Hardeman | Tennessee | 47069 | 3156 | 54 |
961943 | 961943 | 2021-01-24 | Hardin | Tennessee | 47071 | 3063 | 50 |
961944 | 961944 | 2021-01-24 | Hawkins | Tennessee | 47073 | 4606 | 72 |
961945 | 961945 | 2021-01-24 | Haywood | Tennessee | 47075 | 2455 | 48 |
961946 | 961946 | 2021-01-24 | Henderson | Tennessee | 47077 | 3382 | 59 |
961947 | 961947 | 2021-01-24 | Henry | Tennessee | 47079 | 2691 | 59 |
961948 | 961948 | 2021-01-24 | Hickman | Tennessee | 47081 | 2297 | 35 |
961949 | 961949 | 2021-01-24 | Houston | Tennessee | 47083 | 951 | 25 |
961950 | 961950 | 2021-01-24 | Humphreys | Tennessee | 47085 | 1373 | 17 |
961951 | 961951 | 2021-01-24 | Jackson | Tennessee | 47087 | 1061 | 23 |
961952 | 961952 | 2021-01-24 | Jefferson | Tennessee | 47089 | 4960 | 78 |
961953 | 961953 | 2021-01-24 | Johnson | Tennessee | 47091 | 2052 | 34 |
961954 | 961954 | 2021-01-24 | Knox | Tennessee | 47093 | 41520 | 443 |
961955 | 961955 | 2021-01-24 | Lake | Tennessee | 47095 | 1584 | 21 |
961956 | 961956 | 2021-01-24 | Lauderdale | Tennessee | 47097 | 2992 | 34 |
961957 | 961957 | 2021-01-24 | Lawrence | Tennessee | 47099 | 5233 | 69 |
961958 | 961958 | 2021-01-24 | Lewis | Tennessee | 47101 | 1310 | 21 |
961959 | 961959 | 2021-01-24 | Lincoln | Tennessee | 47103 | 3878 | 47 |
961960 | 961960 | 2021-01-24 | Loudon | Tennessee | 47105 | 5089 | 52 |
961961 | 961961 | 2021-01-24 | Macon | Tennessee | 47111 | 2946 | 51 |
961962 | 961962 | 2021-01-24 | Madison | Tennessee | 47113 | 9344 | 183 |
961963 | 961963 | 2021-01-24 | Marion | Tennessee | 47115 | 2360 | 33 |
961964 | 961964 | 2021-01-24 | Marshall | Tennessee | 47117 | 3579 | 39 |
961965 | 961965 | 2021-01-24 | Maury | Tennessee | 47119 | 11295 | 131 |
961966 | 961966 | 2021-01-24 | McMinn | Tennessee | 47107 | 5227 | 74 |
961967 | 961967 | 2021-01-24 | McNairy | Tennessee | 47109 | 2489 | 42 |
961968 | 961968 | 2021-01-24 | Meigs | Tennessee | 47121 | 1191 | 16 |
961969 | 961969 | 2021-01-24 | Monroe | Tennessee | 47123 | 4716 | 63 |
961970 | 961970 | 2021-01-24 | Montgomery | Tennessee | 47125 | 15154 | 149 |
961971 | 961971 | 2021-01-24 | Moore | Tennessee | 47127 | 829 | 9 |
961972 | 961972 | 2021-01-24 | Morgan | Tennessee | 47129 | 1973 | 16 |
961973 | 961973 | 2021-01-24 | Obion | Tennessee | 47131 | 4064 | 83 |
961974 | 961974 | 2021-01-24 | Overton | Tennessee | 47133 | 2601 | 46 |
961975 | 961975 | 2021-01-24 | Perry | Tennessee | 47135 | 962 | 25 |
961976 | 961976 | 2021-01-24 | Pickett | Tennessee | 47137 | 692 | 20 |
961977 | 961977 | 2021-01-24 | Polk | Tennessee | 47139 | 1500 | 17 |
961978 | 961978 | 2021-01-24 | Putnam | Tennessee | 47141 | 10187 | 152 |
961979 | 961979 | 2021-01-24 | Rhea | Tennessee | 47143 | 3913 | 57 |
961980 | 961980 | 2021-01-24 | Roane | Tennessee | 47145 | 5350 | 82 |
961981 | 961981 | 2021-01-24 | Robertson | Tennessee | 47147 | 7918 | 87 |
961982 | 961982 | 2021-01-24 | Rutherford | Tennessee | 47149 | 34166 | 296 |
961983 | 961983 | 2021-01-24 | Scott | Tennessee | 47151 | 2303 | 32 |
961984 | 961984 | 2021-01-24 | Sequatchie | Tennessee | 47153 | 1419 | 19 |
961985 | 961985 | 2021-01-24 | Sevier | Tennessee | 47155 | 10839 | 122 |
961986 | 961986 | 2021-01-24 | Shelby | Tennessee | 47157 | 80770 | 1194 |
961987 | 961987 | 2021-01-24 | Smith | Tennessee | 47159 | 2355 | 30 |
961988 | 961988 | 2021-01-24 | Stewart | Tennessee | 47161 | 1121 | 20 |
961989 | 961989 | 2021-01-24 | Sullivan | Tennessee | 47163 | 12961 | 220 |
961990 | 961990 | 2021-01-24 | Sumner | Tennessee | 47165 | 18819 | 232 |
961991 | 961991 | 2021-01-24 | Tipton | Tennessee | 47167 | 6380 | 69 |
961992 | 961992 | 2021-01-24 | Trousdale | Tennessee | 47169 | 2307 | 16 |
961993 | 961993 | 2021-01-24 | Unicoi | Tennessee | 47171 | 1700 | 45 |
961994 | 961994 | 2021-01-24 | Union | Tennessee | 47173 | 1454 | 25 |
961995 | 961995 | 2021-01-24 | Unknown | Tennessee | 13059 | 121 | |
961996 | 961996 | 2021-01-24 | Van Buren | Tennessee | 47175 | 674 | 8 |
961997 | 961997 | 2021-01-24 | Warren | Tennessee | 47177 | 5112 | 55 |
961998 | 961998 | 2021-01-24 | Washington | Tennessee | 47179 | 12184 | 205 |
961999 | 961999 | 2021-01-24 | Wayne | Tennessee | 47181 | 2704 | 24 |
962000 | 962000 | 2021-01-24 | Weakley | Tennessee | 47183 | 3456 | 48 |
962001 | 962001 | 2021-01-24 | White | Tennessee | 47185 | 3177 | 47 |
962002 | 962002 | 2021-01-24 | Williamson | Tennessee | 47187 | 22175 | 144 |
962003 | 962003 | 2021-01-24 | Wilson | Tennessee | 47189 | 14846 | 164 |
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);