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-06-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 |
---|---|---|---|---|---|---|---|
1452114 | 1452114 | 2021-06-24 | Anderson | Tennessee | 47001 | 8811 | 175 |
1452115 | 1452115 | 2021-06-24 | Bedford | Tennessee | 47003 | 6708 | 131 |
1452116 | 1452116 | 2021-06-24 | Benton | Tennessee | 47005 | 1686 | 41 |
1452117 | 1452117 | 2021-06-24 | Bledsoe | Tennessee | 47007 | 2215 | 11 |
1452118 | 1452118 | 2021-06-24 | Blount | Tennessee | 47009 | 15902 | 197 |
1452119 | 1452119 | 2021-06-24 | Bradley | Tennessee | 47011 | 15299 | 152 |
1452120 | 1452120 | 2021-06-24 | Campbell | Tennessee | 47013 | 4199 | 62 |
1452121 | 1452121 | 2021-06-24 | Cannon | Tennessee | 47015 | 1940 | 32 |
1452122 | 1452122 | 2021-06-24 | Carroll | Tennessee | 47017 | 3709 | 83 |
1452123 | 1452123 | 2021-06-24 | Carter | Tennessee | 47019 | 6753 | 159 |
1452124 | 1452124 | 2021-06-24 | Cheatham | Tennessee | 47021 | 4669 | 56 |
1452125 | 1452125 | 2021-06-24 | Chester | Tennessee | 47023 | 2197 | 51 |
1452126 | 1452126 | 2021-06-24 | Claiborne | Tennessee | 47025 | 3225 | 74 |
1452127 | 1452127 | 2021-06-24 | Clay | Tennessee | 47027 | 1120 | 30 |
1452128 | 1452128 | 2021-06-24 | Cocke | Tennessee | 47029 | 4546 | 100 |
1452129 | 1452129 | 2021-06-24 | Coffee | Tennessee | 47031 | 6985 | 123 |
1452130 | 1452130 | 2021-06-24 | Crockett | Tennessee | 47033 | 2061 | 50 |
1452131 | 1452131 | 2021-06-24 | Cumberland | Tennessee | 47035 | 6888 | 140 |
1452132 | 1452132 | 2021-06-24 | Davidson | Tennessee | 47037 | 99527 | 948 |
1452133 | 1452133 | 2021-06-24 | DeKalb | Tennessee | 47041 | 2874 | 56 |
1452134 | 1452134 | 2021-06-24 | Decatur | Tennessee | 47039 | 1621 | 39 |
1452135 | 1452135 | 2021-06-24 | Dickson | Tennessee | 47043 | 7095 | 115 |
1452136 | 1452136 | 2021-06-24 | Dyer | Tennessee | 47045 | 5524 | 108 |
1452137 | 1452137 | 2021-06-24 | Fayette | Tennessee | 47047 | 5206 | 85 |
1452138 | 1452138 | 2021-06-24 | Fentress | Tennessee | 47049 | 2520 | 49 |
1452139 | 1452139 | 2021-06-24 | Franklin | Tennessee | 47051 | 5229 | 92 |
1452140 | 1452140 | 2021-06-24 | Gibson | Tennessee | 47053 | 6666 | 149 |
1452141 | 1452141 | 2021-06-24 | Giles | Tennessee | 47055 | 4046 | 100 |
1452142 | 1452142 | 2021-06-24 | Grainger | Tennessee | 47057 | 2672 | 50 |
1452143 | 1452143 | 2021-06-24 | Greene | Tennessee | 47059 | 8030 | 159 |
1452144 | 1452144 | 2021-06-24 | Grundy | Tennessee | 47061 | 1801 | 35 |
1452145 | 1452145 | 2021-06-24 | Hamblen | Tennessee | 47063 | 8679 | 173 |
1452146 | 1452146 | 2021-06-24 | Hamilton | Tennessee | 47065 | 45413 | 508 |
1452147 | 1452147 | 2021-06-24 | Hancock | Tennessee | 47067 | 620 | 13 |
1452148 | 1452148 | 2021-06-24 | Hardeman | Tennessee | 47069 | 3546 | 64 |
1452149 | 1452149 | 2021-06-24 | Hardin | Tennessee | 47071 | 3613 | 69 |
1452150 | 1452150 | 2021-06-24 | Hawkins | Tennessee | 47073 | 6323 | 112 |
1452151 | 1452151 | 2021-06-24 | Haywood | Tennessee | 47075 | 2719 | 62 |
1452152 | 1452152 | 2021-06-24 | Henderson | Tennessee | 47077 | 3869 | 78 |
1452153 | 1452153 | 2021-06-24 | Henry | Tennessee | 47079 | 3401 | 75 |
1452154 | 1452154 | 2021-06-24 | Hickman | Tennessee | 47081 | 2893 | 47 |
1452155 | 1452155 | 2021-06-24 | Houston | Tennessee | 47083 | 1120 | 34 |
1452156 | 1452156 | 2021-06-24 | Humphreys | Tennessee | 47085 | 1939 | 31 |
1452157 | 1452157 | 2021-06-24 | Jackson | Tennessee | 47087 | 1367 | 37 |
1452158 | 1452158 | 2021-06-24 | Jefferson | Tennessee | 47089 | 6328 | 126 |
1452159 | 1452159 | 2021-06-24 | Johnson | Tennessee | 47091 | 2444 | 39 |
1452160 | 1452160 | 2021-06-24 | Knox | Tennessee | 47093 | 52113 | 648 |
1452161 | 1452161 | 2021-06-24 | Lake | Tennessee | 47095 | 1728 | 29 |
1452162 | 1452162 | 2021-06-24 | Lauderdale | Tennessee | 47097 | 3268 | 50 |
1452163 | 1452163 | 2021-06-24 | Lawrence | Tennessee | 47099 | 6098 | 94 |
1452164 | 1452164 | 2021-06-24 | Lewis | Tennessee | 47101 | 1623 | 26 |
1452165 | 1452165 | 2021-06-24 | Lincoln | Tennessee | 47103 | 4403 | 67 |
1452166 | 1452166 | 2021-06-24 | Loudon | Tennessee | 47105 | 6233 | 71 |
1452167 | 1452167 | 2021-06-24 | Macon | Tennessee | 47111 | 3670 | 78 |
1452168 | 1452168 | 2021-06-24 | Madison | Tennessee | 47113 | 11570 | 243 |
1452169 | 1452169 | 2021-06-24 | Marion | Tennessee | 47115 | 3230 | 49 |
1452170 | 1452170 | 2021-06-24 | Marshall | Tennessee | 47117 | 4316 | 61 |
1452171 | 1452171 | 2021-06-24 | Maury | Tennessee | 47119 | 13735 | 177 |
1452172 | 1452172 | 2021-06-24 | McMinn | Tennessee | 47107 | 6665 | 102 |
1452173 | 1452173 | 2021-06-24 | McNairy | Tennessee | 47109 | 2877 | 55 |
1452174 | 1452174 | 2021-06-24 | Meigs | Tennessee | 47121 | 1429 | 24 |
1452175 | 1452175 | 2021-06-24 | Monroe | Tennessee | 47123 | 5978 | 96 |
1452176 | 1452176 | 2021-06-24 | Montgomery | Tennessee | 47125 | 21007 | 233 |
1452177 | 1452177 | 2021-06-24 | Moore | Tennessee | 47127 | 1034 | 17 |
1452178 | 1452178 | 2021-06-24 | Morgan | Tennessee | 47129 | 2555 | 37 |
1452179 | 1452179 | 2021-06-24 | Obion | Tennessee | 47131 | 4623 | 97 |
1452180 | 1452180 | 2021-06-24 | Overton | Tennessee | 47133 | 3089 | 62 |
1452181 | 1452181 | 2021-06-24 | Perry | Tennessee | 47135 | 1070 | 29 |
1452182 | 1452182 | 2021-06-24 | Pickett | Tennessee | 47137 | 773 | 24 |
1452183 | 1452183 | 2021-06-24 | Polk | Tennessee | 47139 | 2114 | 24 |
1452184 | 1452184 | 2021-06-24 | Putnam | Tennessee | 47141 | 11847 | 179 |
1452185 | 1452185 | 2021-06-24 | Rhea | Tennessee | 47143 | 4389 | 82 |
1452186 | 1452186 | 2021-06-24 | Roane | Tennessee | 47145 | 6376 | 107 |
1452187 | 1452187 | 2021-06-24 | Robertson | Tennessee | 47147 | 9957 | 140 |
1452188 | 1452188 | 2021-06-24 | Rutherford | Tennessee | 47149 | 43717 | 447 |
1452189 | 1452189 | 2021-06-24 | Scott | Tennessee | 47151 | 3225 | 48 |
1452190 | 1452190 | 2021-06-24 | Sequatchie | Tennessee | 47153 | 1757 | 29 |
1452191 | 1452191 | 2021-06-24 | Sevier | Tennessee | 47155 | 13574 | 177 |
1452192 | 1452192 | 2021-06-24 | Shelby | Tennessee | 47157 | 99626 | 1685 |
1452193 | 1452193 | 2021-06-24 | Smith | Tennessee | 47159 | 2811 | 40 |
1452194 | 1452194 | 2021-06-24 | Stewart | Tennessee | 47161 | 1371 | 28 |
1452195 | 1452195 | 2021-06-24 | Sullivan | Tennessee | 47163 | 17320 | 309 |
1452196 | 1452196 | 2021-06-24 | Sumner | Tennessee | 47165 | 24510 | 354 |
1452197 | 1452197 | 2021-06-24 | Tipton | Tennessee | 47167 | 7466 | 105 |
1452198 | 1452198 | 2021-06-24 | Trousdale | Tennessee | 47169 | 2534 | 21 |
1452199 | 1452199 | 2021-06-24 | Unicoi | Tennessee | 47171 | 2068 | 50 |
1452200 | 1452200 | 2021-06-24 | Union | Tennessee | 47173 | 1956 | 34 |
1452201 | 1452201 | 2021-06-24 | Unknown | Tennessee | 7662 | 89 | |
1452202 | 1452202 | 2021-06-24 | Van Buren | Tennessee | 47175 | 870 | 23 |
1452203 | 1452203 | 2021-06-24 | Warren | Tennessee | 47177 | 5601 | 84 |
1452204 | 1452204 | 2021-06-24 | Washington | Tennessee | 47179 | 14849 | 252 |
1452205 | 1452205 | 2021-06-24 | Wayne | Tennessee | 47181 | 2999 | 36 |
1452206 | 1452206 | 2021-06-24 | Weakley | Tennessee | 47183 | 4237 | 69 |
1452207 | 1452207 | 2021-06-24 | White | Tennessee | 47185 | 3794 | 73 |
1452208 | 1452208 | 2021-06-24 | Williamson | Tennessee | 47187 | 28619 | 218 |
1452209 | 1452209 | 2021-06-24 | Wilson | Tennessee | 47189 | 19367 | 250 |
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);