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-06-01 and state = "Tennessee" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
199236 | 199236 | 2020-06-01 | Anderson | Tennessee | 47001 | 40 | 1 |
199237 | 199237 | 2020-06-01 | Bedford | Tennessee | 47003 | 283 | 4 |
199238 | 199238 | 2020-06-01 | Benton | Tennessee | 47005 | 7 | 1 |
199239 | 199239 | 2020-06-01 | Bledsoe | Tennessee | 47007 | 607 | 1 |
199240 | 199240 | 2020-06-01 | Blount | Tennessee | 47009 | 91 | 3 |
199241 | 199241 | 2020-06-01 | Bradley | Tennessee | 47011 | 122 | 1 |
199242 | 199242 | 2020-06-01 | Campbell | Tennessee | 47013 | 18 | 1 |
199243 | 199243 | 2020-06-01 | Cannon | Tennessee | 47015 | 21 | 0 |
199244 | 199244 | 2020-06-01 | Carroll | Tennessee | 47017 | 27 | 1 |
199245 | 199245 | 2020-06-01 | Carter | Tennessee | 47019 | 19 | 1 |
199246 | 199246 | 2020-06-01 | Cheatham | Tennessee | 47021 | 123 | 0 |
199247 | 199247 | 2020-06-01 | Chester | Tennessee | 47023 | 12 | 0 |
199248 | 199248 | 2020-06-01 | Claiborne | Tennessee | 47025 | 9 | 0 |
199249 | 199249 | 2020-06-01 | Clay | Tennessee | 47027 | 7 | 0 |
199250 | 199250 | 2020-06-01 | Cocke | Tennessee | 47029 | 20 | 0 |
199251 | 199251 | 2020-06-01 | Coffee | Tennessee | 47031 | 73 | 0 |
199252 | 199252 | 2020-06-01 | Crockett | Tennessee | 47033 | 16 | 2 |
199253 | 199253 | 2020-06-01 | Cumberland | Tennessee | 47035 | 112 | 1 |
199254 | 199254 | 2020-06-01 | Davidson | Tennessee | 47037 | 5517 | 63 |
199255 | 199255 | 2020-06-01 | DeKalb | Tennessee | 47041 | 37 | 0 |
199256 | 199256 | 2020-06-01 | Decatur | Tennessee | 47039 | 5 | 0 |
199257 | 199257 | 2020-06-01 | Dickson | Tennessee | 47043 | 109 | 0 |
199258 | 199258 | 2020-06-01 | Dyer | Tennessee | 47045 | 50 | 0 |
199259 | 199259 | 2020-06-01 | Fayette | Tennessee | 47047 | 115 | 2 |
199260 | 199260 | 2020-06-01 | Fentress | Tennessee | 47049 | 12 | 0 |
199261 | 199261 | 2020-06-01 | Franklin | Tennessee | 47051 | 53 | 1 |
199262 | 199262 | 2020-06-01 | Gibson | Tennessee | 47053 | 63 | 1 |
199263 | 199263 | 2020-06-01 | Giles | Tennessee | 47055 | 12 | 0 |
199264 | 199264 | 2020-06-01 | Grainger | Tennessee | 47057 | 8 | 0 |
199265 | 199265 | 2020-06-01 | Greene | Tennessee | 47059 | 50 | 2 |
199266 | 199266 | 2020-06-01 | Grundy | Tennessee | 47061 | 31 | 1 |
199267 | 199267 | 2020-06-01 | Hamblen | Tennessee | 47063 | 36 | 2 |
199268 | 199268 | 2020-06-01 | Hamilton | Tennessee | 47065 | 1132 | 15 |
199269 | 199269 | 2020-06-01 | Hancock | Tennessee | 47067 | 1 | 0 |
199270 | 199270 | 2020-06-01 | Hardeman | Tennessee | 47069 | 196 | 0 |
199271 | 199271 | 2020-06-01 | Hardin | Tennessee | 47071 | 15 | 2 |
199272 | 199272 | 2020-06-01 | Hawkins | Tennessee | 47073 | 33 | 2 |
199273 | 199273 | 2020-06-01 | Haywood | Tennessee | 47075 | 31 | 2 |
199274 | 199274 | 2020-06-01 | Henderson | Tennessee | 47077 | 15 | 0 |
199275 | 199275 | 2020-06-01 | Henry | Tennessee | 47079 | 30 | 0 |
199276 | 199276 | 2020-06-01 | Hickman | Tennessee | 47081 | 58 | 0 |
199277 | 199277 | 2020-06-01 | Houston | Tennessee | 47083 | 8 | 0 |
199278 | 199278 | 2020-06-01 | Humphreys | Tennessee | 47085 | 13 | 1 |
199279 | 199279 | 2020-06-01 | Jackson | Tennessee | 47087 | 17 | 0 |
199280 | 199280 | 2020-06-01 | Jefferson | Tennessee | 47089 | 28 | 0 |
199281 | 199281 | 2020-06-01 | Johnson | Tennessee | 47091 | 16 | 0 |
199282 | 199282 | 2020-06-01 | Knox | Tennessee | 47093 | 421 | 5 |
199283 | 199283 | 2020-06-01 | Lake | Tennessee | 47095 | 414 | 0 |
199284 | 199284 | 2020-06-01 | Lauderdale | Tennessee | 47097 | 56 | 1 |
199285 | 199285 | 2020-06-01 | Lawrence | Tennessee | 47099 | 31 | 0 |
199286 | 199286 | 2020-06-01 | Lewis | Tennessee | 47101 | 3 | 0 |
199287 | 199287 | 2020-06-01 | Lincoln | Tennessee | 47103 | 25 | 0 |
199288 | 199288 | 2020-06-01 | Loudon | Tennessee | 47105 | 143 | 0 |
199289 | 199289 | 2020-06-01 | Macon | Tennessee | 47111 | 136 | 3 |
199290 | 199290 | 2020-06-01 | Madison | Tennessee | 47113 | 175 | 2 |
199291 | 199291 | 2020-06-01 | Marion | Tennessee | 47115 | 40 | 1 |
199292 | 199292 | 2020-06-01 | Marshall | Tennessee | 47117 | 31 | 1 |
199293 | 199293 | 2020-06-01 | Maury | Tennessee | 47119 | 89 | 0 |
199294 | 199294 | 2020-06-01 | McMinn | Tennessee | 47107 | 141 | 14 |
199295 | 199295 | 2020-06-01 | McNairy | Tennessee | 47109 | 12 | 0 |
199296 | 199296 | 2020-06-01 | Meigs | Tennessee | 47121 | 26 | 0 |
199297 | 199297 | 2020-06-01 | Monroe | Tennessee | 47123 | 62 | 2 |
199298 | 199298 | 2020-06-01 | Montgomery | Tennessee | 47125 | 269 | 3 |
199299 | 199299 | 2020-06-01 | Moore | Tennessee | 47127 | 3 | 0 |
199300 | 199300 | 2020-06-01 | Morgan | Tennessee | 47129 | 17 | 0 |
199301 | 199301 | 2020-06-01 | Obion | Tennessee | 47131 | 30 | 1 |
199302 | 199302 | 2020-06-01 | Overton | Tennessee | 47133 | 26 | 0 |
199303 | 199303 | 2020-06-01 | Perry | Tennessee | 47135 | 21 | 0 |
199304 | 199304 | 2020-06-01 | Pickett | Tennessee | 47137 | 3 | 0 |
199305 | 199305 | 2020-06-01 | Polk | Tennessee | 47139 | 16 | 0 |
199306 | 199306 | 2020-06-01 | Putnam | Tennessee | 47141 | 479 | 5 |
199307 | 199307 | 2020-06-01 | Rhea | Tennessee | 47143 | 210 | 0 |
199308 | 199308 | 2020-06-01 | Roane | Tennessee | 47145 | 16 | 0 |
199309 | 199309 | 2020-06-01 | Robertson | Tennessee | 47147 | 465 | 3 |
199310 | 199310 | 2020-06-01 | Rutherford | Tennessee | 47149 | 1196 | 23 |
199311 | 199311 | 2020-06-01 | Scott | Tennessee | 47151 | 12 | 0 |
199312 | 199312 | 2020-06-01 | Sequatchie | Tennessee | 47153 | 15 | 0 |
199313 | 199313 | 2020-06-01 | Sevier | Tennessee | 47155 | 81 | 2 |
199314 | 199314 | 2020-06-01 | Shelby | Tennessee | 47157 | 5124 | 111 |
199315 | 199315 | 2020-06-01 | Smith | Tennessee | 47159 | 34 | 1 |
199316 | 199316 | 2020-06-01 | Stewart | Tennessee | 47161 | 11 | 0 |
199317 | 199317 | 2020-06-01 | Sullivan | Tennessee | 47163 | 60 | 2 |
199318 | 199318 | 2020-06-01 | Sumner | Tennessee | 47165 | 881 | 45 |
199319 | 199319 | 2020-06-01 | Tipton | Tennessee | 47167 | 442 | 3 |
199320 | 199320 | 2020-06-01 | Trousdale | Tennessee | 47169 | 1392 | 4 |
199321 | 199321 | 2020-06-01 | Unicoi | Tennessee | 47171 | 4 | 0 |
199322 | 199322 | 2020-06-01 | Union | Tennessee | 47173 | 4 | 0 |
199323 | 199323 | 2020-06-01 | Unknown | Tennessee | 144 | 0 | |
199324 | 199324 | 2020-06-01 | Van Buren | Tennessee | 47175 | 4 | 0 |
199325 | 199325 | 2020-06-01 | Warren | Tennessee | 47177 | 23 | 0 |
199326 | 199326 | 2020-06-01 | Washington | Tennessee | 47179 | 75 | 0 |
199327 | 199327 | 2020-06-01 | Wayne | Tennessee | 47181 | 64 | 0 |
199328 | 199328 | 2020-06-01 | Weakley | Tennessee | 47183 | 26 | 0 |
199329 | 199329 | 2020-06-01 | White | Tennessee | 47185 | 33 | 0 |
199330 | 199330 | 2020-06-01 | Williamson | Tennessee | 47187 | 552 | 10 |
199331 | 199331 | 2020-06-01 | Wilson | Tennessee | 47189 | 407 | 8 |
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);