ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-07-25" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
369147 | 369147 | 2020-07-25 | Anderson | Tennessee | 47001 | 396 | 4 |
369148 | 369148 | 2020-07-25 | Bedford | Tennessee | 47003 | 741 | 10 |
369149 | 369149 | 2020-07-25 | Benton | Tennessee | 47005 | 44 | 1 |
369150 | 369150 | 2020-07-25 | Bledsoe | Tennessee | 47007 | 647 | 1 |
369151 | 369151 | 2020-07-25 | Blount | Tennessee | 47009 | 756 | 7 |
369152 | 369152 | 2020-07-25 | Bradley | Tennessee | 47011 | 1390 | 9 |
369153 | 369153 | 2020-07-25 | Campbell | Tennessee | 47013 | 132 | 1 |
369154 | 369154 | 2020-07-25 | Cannon | Tennessee | 47015 | 88 | 0 |
369155 | 369155 | 2020-07-25 | Carroll | Tennessee | 47017 | 121 | 2 |
369156 | 369156 | 2020-07-25 | Carter | Tennessee | 47019 | 274 | 3 |
369157 | 369157 | 2020-07-25 | Cheatham | Tennessee | 47021 | 418 | 4 |
369158 | 369158 | 2020-07-25 | Chester | Tennessee | 47023 | 136 | 0 |
369159 | 369159 | 2020-07-25 | Claiborne | Tennessee | 47025 | 152 | 0 |
369160 | 369160 | 2020-07-25 | Clay | Tennessee | 47027 | 41 | 0 |
369161 | 369161 | 2020-07-25 | Cocke | Tennessee | 47029 | 265 | 1 |
369162 | 369162 | 2020-07-25 | Coffee | Tennessee | 47031 | 261 | 0 |
369163 | 369163 | 2020-07-25 | Crockett | Tennessee | 47033 | 141 | 3 |
369164 | 369164 | 2020-07-25 | Cumberland | Tennessee | 47035 | 290 | 6 |
369165 | 369165 | 2020-07-25 | Davidson | Tennessee | 47037 | 19374 | 186 |
369166 | 369166 | 2020-07-25 | DeKalb | Tennessee | 47041 | 198 | 1 |
369167 | 369167 | 2020-07-25 | Decatur | Tennessee | 47039 | 89 | 0 |
369168 | 369168 | 2020-07-25 | Dickson | Tennessee | 47043 | 471 | 0 |
369169 | 369169 | 2020-07-25 | Dyer | Tennessee | 47045 | 424 | 5 |
369170 | 369170 | 2020-07-25 | Fayette | Tennessee | 47047 | 519 | 8 |
369171 | 369171 | 2020-07-25 | Fentress | Tennessee | 47049 | 49 | 0 |
369172 | 369172 | 2020-07-25 | Franklin | Tennessee | 47051 | 188 | 3 |
369173 | 369173 | 2020-07-25 | Gibson | Tennessee | 47053 | 379 | 1 |
369174 | 369174 | 2020-07-25 | Giles | Tennessee | 47055 | 256 | 5 |
369175 | 369175 | 2020-07-25 | Grainger | Tennessee | 47057 | 98 | 0 |
369176 | 369176 | 2020-07-25 | Greene | Tennessee | 47059 | 261 | 5 |
369177 | 369177 | 2020-07-25 | Grundy | Tennessee | 47061 | 78 | 2 |
369178 | 369178 | 2020-07-25 | Hamblen | Tennessee | 47063 | 852 | 9 |
369179 | 369179 | 2020-07-25 | Hamilton | Tennessee | 47065 | 4900 | 44 |
369180 | 369180 | 2020-07-25 | Hancock | Tennessee | 47067 | 56 | 0 |
369181 | 369181 | 2020-07-25 | Hardeman | Tennessee | 47069 | 647 | 11 |
369182 | 369182 | 2020-07-25 | Hardin | Tennessee | 47071 | 282 | 7 |
369183 | 369183 | 2020-07-25 | Hawkins | Tennessee | 47073 | 187 | 2 |
369184 | 369184 | 2020-07-25 | Haywood | Tennessee | 47075 | 236 | 4 |
369185 | 369185 | 2020-07-25 | Henderson | Tennessee | 47077 | 286 | 0 |
369186 | 369186 | 2020-07-25 | Henry | Tennessee | 47079 | 95 | 1 |
369187 | 369187 | 2020-07-25 | Hickman | Tennessee | 47081 | 167 | 0 |
369188 | 369188 | 2020-07-25 | Houston | Tennessee | 47083 | 39 | 0 |
369189 | 369189 | 2020-07-25 | Humphreys | Tennessee | 47085 | 71 | 3 |
369190 | 369190 | 2020-07-25 | Jackson | Tennessee | 47087 | 93 | 0 |
369191 | 369191 | 2020-07-25 | Jefferson | Tennessee | 47089 | 344 | 2 |
369192 | 369192 | 2020-07-25 | Johnson | Tennessee | 47091 | 59 | 0 |
369193 | 369193 | 2020-07-25 | Knox | Tennessee | 47093 | 3091 | 23 |
369194 | 369194 | 2020-07-25 | Lake | Tennessee | 47095 | 706 | 0 |
369195 | 369195 | 2020-07-25 | Lauderdale | Tennessee | 47097 | 313 | 6 |
369196 | 369196 | 2020-07-25 | Lawrence | Tennessee | 47099 | 353 | 6 |
369197 | 369197 | 2020-07-25 | Lewis | Tennessee | 47101 | 29 | 1 |
369198 | 369198 | 2020-07-25 | Lincoln | Tennessee | 47103 | 181 | 1 |
369199 | 369199 | 2020-07-25 | Loudon | Tennessee | 47105 | 503 | 3 |
369200 | 369200 | 2020-07-25 | Macon | Tennessee | 47111 | 761 | 11 |
369201 | 369201 | 2020-07-25 | Madison | Tennessee | 47113 | 585 | 10 |
369202 | 369202 | 2020-07-25 | Marion | Tennessee | 47115 | 153 | 4 |
369203 | 369203 | 2020-07-25 | Marshall | Tennessee | 47117 | 193 | 2 |
369204 | 369204 | 2020-07-25 | Maury | Tennessee | 47119 | 821 | 4 |
369205 | 369205 | 2020-07-25 | McMinn | Tennessee | 47107 | 413 | 20 |
369206 | 369206 | 2020-07-25 | McNairy | Tennessee | 47109 | 216 | 2 |
369207 | 369207 | 2020-07-25 | Meigs | Tennessee | 47121 | 66 | 0 |
369208 | 369208 | 2020-07-25 | Monroe | Tennessee | 47123 | 252 | 7 |
369209 | 369209 | 2020-07-25 | Montgomery | Tennessee | 47125 | 1350 | 9 |
369210 | 369210 | 2020-07-25 | Moore | Tennessee | 47127 | 35 | 0 |
369211 | 369211 | 2020-07-25 | Morgan | Tennessee | 47129 | 51 | 1 |
369212 | 369212 | 2020-07-25 | Obion | Tennessee | 47131 | 245 | 4 |
369213 | 369213 | 2020-07-25 | Overton | Tennessee | 47133 | 106 | 1 |
369214 | 369214 | 2020-07-25 | Perry | Tennessee | 47135 | 58 | 0 |
369215 | 369215 | 2020-07-25 | Pickett | Tennessee | 47137 | 17 | 1 |
369216 | 369216 | 2020-07-25 | Polk | Tennessee | 47139 | 93 | 0 |
369217 | 369217 | 2020-07-25 | Putnam | Tennessee | 47141 | 1349 | 11 |
369218 | 369218 | 2020-07-25 | Rhea | Tennessee | 47143 | 434 | 1 |
369219 | 369219 | 2020-07-25 | Roane | Tennessee | 47145 | 208 | 1 |
369220 | 369220 | 2020-07-25 | Robertson | Tennessee | 47147 | 1236 | 16 |
369221 | 369221 | 2020-07-25 | Rutherford | Tennessee | 47149 | 5202 | 47 |
369222 | 369222 | 2020-07-25 | Scott | Tennessee | 47151 | 46 | 0 |
369223 | 369223 | 2020-07-25 | Sequatchie | Tennessee | 47153 | 72 | 0 |
369224 | 369224 | 2020-07-25 | Sevier | Tennessee | 47155 | 1330 | 4 |
369225 | 369225 | 2020-07-25 | Shelby | Tennessee | 47157 | 18488 | 265 |
369226 | 369226 | 2020-07-25 | Smith | Tennessee | 47159 | 278 | 2 |
369227 | 369227 | 2020-07-25 | Stewart | Tennessee | 47161 | 54 | 0 |
369228 | 369228 | 2020-07-25 | Sullivan | Tennessee | 47163 | 539 | 6 |
369229 | 369229 | 2020-07-25 | Sumner | Tennessee | 47165 | 2833 | 67 |
369230 | 369230 | 2020-07-25 | Tipton | Tennessee | 47167 | 912 | 8 |
369231 | 369231 | 2020-07-25 | Trousdale | Tennessee | 47169 | 1559 | 6 |
369232 | 369232 | 2020-07-25 | Unicoi | Tennessee | 47171 | 92 | 0 |
369233 | 369233 | 2020-07-25 | Union | Tennessee | 47173 | 76 | 0 |
369234 | 369234 | 2020-07-25 | Unknown | Tennessee | 175 | 3 | |
369235 | 369235 | 2020-07-25 | Van Buren | Tennessee | 47175 | 21 | 0 |
369236 | 369236 | 2020-07-25 | Warren | Tennessee | 47177 | 282 | 3 |
369237 | 369237 | 2020-07-25 | Washington | Tennessee | 47179 | 626 | 0 |
369238 | 369238 | 2020-07-25 | Wayne | Tennessee | 47181 | 178 | 1 |
369239 | 369239 | 2020-07-25 | Weakley | Tennessee | 47183 | 133 | 1 |
369240 | 369240 | 2020-07-25 | White | Tennessee | 47185 | 152 | 3 |
369241 | 369241 | 2020-07-25 | Williamson | Tennessee | 47187 | 2812 | 21 |
369242 | 369242 | 2020-07-25 | Wilson | Tennessee | 47189 | 1790 | 20 |
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);