ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where "date" is on date 2020-04-09 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
45212 | 45212 | 2020-04-09 | Anderson | Tennessee | 47001 | 11 | 1 |
45213 | 45213 | 2020-04-09 | Bedford | Tennessee | 47003 | 14 | 0 |
45214 | 45214 | 2020-04-09 | Benton | Tennessee | 47005 | 4 | 0 |
45215 | 45215 | 2020-04-09 | Bledsoe | Tennessee | 47007 | 3 | 0 |
45216 | 45216 | 2020-04-09 | Blount | Tennessee | 47009 | 44 | 2 |
45217 | 45217 | 2020-04-09 | Bradley | Tennessee | 47011 | 28 | 0 |
45218 | 45218 | 2020-04-09 | Campbell | Tennessee | 47013 | 9 | 0 |
45219 | 45219 | 2020-04-09 | Cannon | Tennessee | 47015 | 7 | 0 |
45220 | 45220 | 2020-04-09 | Carroll | Tennessee | 47017 | 10 | 0 |
45221 | 45221 | 2020-04-09 | Carter | Tennessee | 47019 | 3 | 0 |
45222 | 45222 | 2020-04-09 | Cheatham | Tennessee | 47021 | 15 | 0 |
45223 | 45223 | 2020-04-09 | Chester | Tennessee | 47023 | 7 | 0 |
45224 | 45224 | 2020-04-09 | Claiborne | Tennessee | 47025 | 2 | 0 |
45225 | 45225 | 2020-04-09 | Clay | Tennessee | 47027 | 2 | 0 |
45226 | 45226 | 2020-04-09 | Cocke | Tennessee | 47029 | 3 | 0 |
45227 | 45227 | 2020-04-09 | Coffee | Tennessee | 47031 | 10 | 0 |
45228 | 45228 | 2020-04-09 | Cumberland | Tennessee | 47035 | 34 | 0 |
45229 | 45229 | 2020-04-09 | Davidson | Tennessee | 47037 | 1140 | 13 |
45230 | 45230 | 2020-04-09 | DeKalb | Tennessee | 47041 | 7 | 0 |
45231 | 45231 | 2020-04-09 | Decatur | Tennessee | 47039 | 1 | 0 |
45232 | 45232 | 2020-04-09 | Dickson | Tennessee | 47043 | 28 | 0 |
45233 | 45233 | 2020-04-09 | Dyer | Tennessee | 47045 | 14 | 0 |
45234 | 45234 | 2020-04-09 | Fayette | Tennessee | 47047 | 25 | 0 |
45235 | 45235 | 2020-04-09 | Fentress | Tennessee | 47049 | 2 | 0 |
45236 | 45236 | 2020-04-09 | Franklin | Tennessee | 47051 | 17 | 1 |
45237 | 45237 | 2020-04-09 | Gibson | Tennessee | 47053 | 16 | 0 |
45238 | 45238 | 2020-04-09 | Giles | Tennessee | 47055 | 3 | 0 |
45239 | 45239 | 2020-04-09 | Grainger | Tennessee | 47057 | 3 | 0 |
45240 | 45240 | 2020-04-09 | Greene | Tennessee | 47059 | 22 | 1 |
45241 | 45241 | 2020-04-09 | Grundy | Tennessee | 47061 | 17 | 0 |
45242 | 45242 | 2020-04-09 | Hamblen | Tennessee | 47063 | 4 | 0 |
45243 | 45243 | 2020-04-09 | Hamilton | Tennessee | 47065 | 98 | 9 |
45244 | 45244 | 2020-04-09 | Hardeman | Tennessee | 47069 | 6 | 0 |
45245 | 45245 | 2020-04-09 | Hardin | Tennessee | 47071 | 2 | 0 |
45246 | 45246 | 2020-04-09 | Hawkins | Tennessee | 47073 | 21 | 1 |
45247 | 45247 | 2020-04-09 | Haywood | Tennessee | 47075 | 9 | 0 |
45248 | 45248 | 2020-04-09 | Henderson | Tennessee | 47077 | 2 | 0 |
45249 | 45249 | 2020-04-09 | Henry | Tennessee | 47079 | 6 | 0 |
45250 | 45250 | 2020-04-09 | Hickman | Tennessee | 47081 | 2 | 0 |
45251 | 45251 | 2020-04-09 | Houston | Tennessee | 47083 | 2 | 0 |
45252 | 45252 | 2020-04-09 | Humphreys | Tennessee | 47085 | 4 | 0 |
45253 | 45253 | 2020-04-09 | Jackson | Tennessee | 47087 | 5 | 0 |
45254 | 45254 | 2020-04-09 | Jefferson | Tennessee | 47089 | 12 | 0 |
45255 | 45255 | 2020-04-09 | Johnson | Tennessee | 47091 | 2 | 0 |
45256 | 45256 | 2020-04-09 | Knox | Tennessee | 47093 | 157 | 4 |
45257 | 45257 | 2020-04-09 | Lauderdale | Tennessee | 47097 | 7 | 0 |
45258 | 45258 | 2020-04-09 | Lawrence | Tennessee | 47099 | 11 | 0 |
45259 | 45259 | 2020-04-09 | Lewis | Tennessee | 47101 | 2 | 0 |
45260 | 45260 | 2020-04-09 | Lincoln | Tennessee | 47103 | 7 | 0 |
45261 | 45261 | 2020-04-09 | Loudon | Tennessee | 47105 | 15 | 0 |
45262 | 45262 | 2020-04-09 | Macon | Tennessee | 47111 | 16 | 1 |
45263 | 45263 | 2020-04-09 | Madison | Tennessee | 47113 | 47 | 0 |
45264 | 45264 | 2020-04-09 | Marion | Tennessee | 47115 | 22 | 1 |
45265 | 45265 | 2020-04-09 | Marshall | Tennessee | 47117 | 9 | 0 |
45266 | 45266 | 2020-04-09 | Maury | Tennessee | 47119 | 31 | 1 |
45267 | 45267 | 2020-04-09 | McMinn | Tennessee | 47107 | 3 | 0 |
45268 | 45268 | 2020-04-09 | McNairy | Tennessee | 47109 | 9 | 0 |
45269 | 45269 | 2020-04-09 | Meigs | Tennessee | 47121 | 3 | 0 |
45270 | 45270 | 2020-04-09 | Monroe | Tennessee | 47123 | 7 | 0 |
45271 | 45271 | 2020-04-09 | Montgomery | Tennessee | 47125 | 79 | 2 |
45272 | 45272 | 2020-04-09 | Morgan | Tennessee | 47129 | 5 | 0 |
45273 | 45273 | 2020-04-09 | Obion | Tennessee | 47131 | 4 | 1 |
45274 | 45274 | 2020-04-09 | Overton | Tennessee | 47133 | 5 | 0 |
45275 | 45275 | 2020-04-09 | Perry | Tennessee | 47135 | 3 | 0 |
45276 | 45276 | 2020-04-09 | Polk | Tennessee | 47139 | 3 | 0 |
45277 | 45277 | 2020-04-09 | Putnam | Tennessee | 47141 | 82 | 0 |
45278 | 45278 | 2020-04-09 | Roane | Tennessee | 47145 | 5 | 0 |
45279 | 45279 | 2020-04-09 | Robertson | Tennessee | 47147 | 70 | 0 |
45280 | 45280 | 2020-04-09 | Rutherford | Tennessee | 47149 | 203 | 3 |
45281 | 45281 | 2020-04-09 | Scott | Tennessee | 47151 | 5 | 0 |
45282 | 45282 | 2020-04-09 | Sequatchie | Tennessee | 47153 | 1 | 0 |
45283 | 45283 | 2020-04-09 | Sevier | Tennessee | 47155 | 21 | 0 |
45284 | 45284 | 2020-04-09 | Shelby | Tennessee | 47157 | 1006 | 23 |
45285 | 45285 | 2020-04-09 | Smith | Tennessee | 47159 | 5 | 0 |
45286 | 45286 | 2020-04-09 | Stewart | Tennessee | 47161 | 2 | 0 |
45287 | 45287 | 2020-04-09 | Sullivan | Tennessee | 47163 | 34 | 1 |
45288 | 45288 | 2020-04-09 | Sumner | Tennessee | 47165 | 389 | 18 |
45289 | 45289 | 2020-04-09 | Tipton | Tennessee | 47167 | 39 | 0 |
45290 | 45290 | 2020-04-09 | Trousdale | Tennessee | 47169 | 14 | 1 |
45291 | 45291 | 2020-04-09 | Unicoi | Tennessee | 47171 | 1 | 0 |
45292 | 45292 | 2020-04-09 | Union | Tennessee | 47173 | 2 | 0 |
45293 | 45293 | 2020-04-09 | Unknown | Tennessee | 0 | 8 | |
45294 | 45294 | 2020-04-09 | Warren | Tennessee | 47177 | 3 | 0 |
45295 | 45295 | 2020-04-09 | Washington | Tennessee | 47179 | 32 | 0 |
45296 | 45296 | 2020-04-09 | Wayne | Tennessee | 47181 | 2 | 0 |
45297 | 45297 | 2020-04-09 | Weakley | Tennessee | 47183 | 5 | 0 |
45298 | 45298 | 2020-04-09 | White | Tennessee | 47185 | 3 | 0 |
45299 | 45299 | 2020-04-09 | Williamson | Tennessee | 47187 | 288 | 3 |
45300 | 45300 | 2020-04-09 | Wilson | Tennessee | 47189 | 123 | 0 |
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);