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 2022-02-16 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2222263 | 2222263 | 2022-02-16 | Anderson | Tennessee | 47001 | 21413 | 303 |
2222264 | 2222264 | 2022-02-16 | Bedford | Tennessee | 47003 | 14732 | 213 |
2222265 | 2222265 | 2022-02-16 | Benton | Tennessee | 47005 | 4321 | 85 |
2222266 | 2222266 | 2022-02-16 | Bledsoe | Tennessee | 47007 | 4585 | 44 |
2222267 | 2222267 | 2022-02-16 | Blount | Tennessee | 47009 | 38344 | 375 |
2222268 | 2222268 | 2022-02-16 | Bradley | Tennessee | 47011 | 32615 | 363 |
2222269 | 2222269 | 2022-02-16 | Campbell | Tennessee | 47013 | 11456 | 141 |
2222270 | 2222270 | 2022-02-16 | Cannon | Tennessee | 47015 | 4100 | 53 |
2222271 | 2222271 | 2022-02-16 | Carroll | Tennessee | 47017 | 8716 | 140 |
2222272 | 2222272 | 2022-02-16 | Carter | Tennessee | 47019 | 15803 | 296 |
2222273 | 2222273 | 2022-02-16 | Cheatham | Tennessee | 47021 | 10720 | 110 |
2222274 | 2222274 | 2022-02-16 | Chester | Tennessee | 47023 | 5598 | 88 |
2222275 | 2222275 | 2022-02-16 | Claiborne | Tennessee | 47025 | 8588 | 157 |
2222276 | 2222276 | 2022-02-16 | Clay | Tennessee | 47027 | 2186 | 45 |
2222277 | 2222277 | 2022-02-16 | Cocke | Tennessee | 47029 | 10960 | 193 |
2222278 | 2222278 | 2022-02-16 | Coffee | Tennessee | 47031 | 16595 | 234 |
2222279 | 2222279 | 2022-02-16 | Crockett | Tennessee | 47033 | 4926 | 80 |
2222280 | 2222280 | 2022-02-16 | Cumberland | Tennessee | 47035 | 15708 | 296 |
2222281 | 2222281 | 2022-02-16 | Davidson | Tennessee | 47037 | 203961 | 1534 |
2222282 | 2222282 | 2022-02-16 | DeKalb | Tennessee | 47041 | 6181 | 94 |
2222283 | 2222283 | 2022-02-16 | Decatur | Tennessee | 47039 | 3581 | 60 |
2222284 | 2222284 | 2022-02-16 | Dickson | Tennessee | 47043 | 15521 | 225 |
2222285 | 2222285 | 2022-02-16 | Dyer | Tennessee | 47045 | 12401 | 182 |
2222286 | 2222286 | 2022-02-16 | Fayette | Tennessee | 47047 | 11250 | 156 |
2222287 | 2222287 | 2022-02-16 | Fentress | Tennessee | 47049 | 5563 | 111 |
2222288 | 2222288 | 2022-02-16 | Franklin | Tennessee | 47051 | 12599 | 157 |
2222289 | 2222289 | 2022-02-16 | Gibson | Tennessee | 47053 | 16912 | 236 |
2222290 | 2222290 | 2022-02-16 | Giles | Tennessee | 47055 | 9251 | 164 |
2222291 | 2222291 | 2022-02-16 | Grainger | Tennessee | 47057 | 6610 | 100 |
2222292 | 2222292 | 2022-02-16 | Greene | Tennessee | 47059 | 21459 | 336 |
2222293 | 2222293 | 2022-02-16 | Grundy | Tennessee | 47061 | 3913 | 68 |
2222294 | 2222294 | 2022-02-16 | Hamblen | Tennessee | 47063 | 19323 | 324 |
2222295 | 2222295 | 2022-02-16 | Hamilton | Tennessee | 47065 | 96578 | 1052 |
2222296 | 2222296 | 2022-02-16 | Hancock | Tennessee | 47067 | 1935 | 30 |
2222297 | 2222297 | 2022-02-16 | Hardeman | Tennessee | 47069 | 7257 | 112 |
2222298 | 2222298 | 2022-02-16 | Hardin | Tennessee | 47071 | 8417 | 122 |
2222299 | 2222299 | 2022-02-16 | Hawkins | Tennessee | 47073 | 16103 | 270 |
2222300 | 2222300 | 2022-02-16 | Haywood | Tennessee | 47075 | 6040 | 90 |
2222301 | 2222301 | 2022-02-16 | Henderson | Tennessee | 47077 | 8644 | 139 |
2222302 | 2222302 | 2022-02-16 | Henry | Tennessee | 47079 | 7914 | 138 |
2222303 | 2222303 | 2022-02-16 | Hickman | Tennessee | 47081 | 6706 | 102 |
2222304 | 2222304 | 2022-02-16 | Houston | Tennessee | 47083 | 2614 | 58 |
2222305 | 2222305 | 2022-02-16 | Humphreys | Tennessee | 47085 | 4717 | 66 |
2222306 | 2222306 | 2022-02-16 | Jackson | Tennessee | 47087 | 3119 | 53 |
2222307 | 2222307 | 2022-02-16 | Jefferson | Tennessee | 47089 | 15302 | 245 |
2222308 | 2222308 | 2022-02-16 | Johnson | Tennessee | 47091 | 4970 | 75 |
2222309 | 2222309 | 2022-02-16 | Knox | Tennessee | 47093 | 124460 | 1234 |
2222310 | 2222310 | 2022-02-16 | Lake | Tennessee | 47095 | 2636 | 37 |
2222311 | 2222311 | 2022-02-16 | Lauderdale | Tennessee | 47097 | 7603 | 91 |
2222312 | 2222312 | 2022-02-16 | Lawrence | Tennessee | 47099 | 14041 | 172 |
2222313 | 2222313 | 2022-02-16 | Lewis | Tennessee | 47101 | 3521 | 50 |
2222314 | 2222314 | 2022-02-16 | Lincoln | Tennessee | 47103 | 9795 | 140 |
2222315 | 2222315 | 2022-02-16 | Loudon | Tennessee | 47105 | 14073 | 174 |
2222316 | 2222316 | 2022-02-16 | Macon | Tennessee | 47111 | 8257 | 135 |
2222317 | 2222317 | 2022-02-16 | Madison | Tennessee | 47113 | 28750 | 390 |
2222318 | 2222318 | 2022-02-16 | Marion | Tennessee | 47115 | 8648 | 119 |
2222319 | 2222319 | 2022-02-16 | Marshall | Tennessee | 47117 | 10208 | 111 |
2222320 | 2222320 | 2022-02-16 | Maury | Tennessee | 47119 | 28459 | 299 |
2222321 | 2222321 | 2022-02-16 | McMinn | Tennessee | 47107 | 16414 | 222 |
2222322 | 2222322 | 2022-02-16 | McNairy | Tennessee | 47109 | 7300 | 99 |
2222323 | 2222323 | 2022-02-16 | Meigs | Tennessee | 47121 | 3297 | 52 |
2222324 | 2222324 | 2022-02-16 | Monroe | Tennessee | 47123 | 14171 | 212 |
2222325 | 2222325 | 2022-02-16 | Montgomery | Tennessee | 47125 | 48720 | 525 |
2222326 | 2222326 | 2022-02-16 | Moore | Tennessee | 47127 | 2186 | 36 |
2222327 | 2222327 | 2022-02-16 | Morgan | Tennessee | 47129 | 5872 | 73 |
2222328 | 2222328 | 2022-02-16 | Obion | Tennessee | 47131 | 10558 | 163 |
2222329 | 2222329 | 2022-02-16 | Overton | Tennessee | 47133 | 7031 | 118 |
2222330 | 2222330 | 2022-02-16 | Perry | Tennessee | 47135 | 2265 | 43 |
2222331 | 2222331 | 2022-02-16 | Pickett | Tennessee | 47137 | 1734 | 30 |
2222332 | 2222332 | 2022-02-16 | Polk | Tennessee | 47139 | 4568 | 54 |
2222333 | 2222333 | 2022-02-16 | Putnam | Tennessee | 47141 | 24545 | 283 |
2222334 | 2222334 | 2022-02-16 | Rhea | Tennessee | 47143 | 9813 | 141 |
2222335 | 2222335 | 2022-02-16 | Roane | Tennessee | 47145 | 15418 | 215 |
2222336 | 2222336 | 2022-02-16 | Robertson | Tennessee | 47147 | 21228 | 276 |
2222337 | 2222337 | 2022-02-16 | Rutherford | Tennessee | 47149 | 93990 | 828 |
2222338 | 2222338 | 2022-02-16 | Scott | Tennessee | 47151 | 8612 | 103 |
2222339 | 2222339 | 2022-02-16 | Sequatchie | Tennessee | 47153 | 4116 | 64 |
2222340 | 2222340 | 2022-02-16 | Sevier | Tennessee | 47155 | 29563 | 377 |
2222341 | 2222341 | 2022-02-16 | Shelby | Tennessee | 47157 | 234441 | 3045 |
2222342 | 2222342 | 2022-02-16 | Smith | Tennessee | 47159 | 6010 | 73 |
2222343 | 2222343 | 2022-02-16 | Stewart | Tennessee | 47161 | 3219 | 47 |
2222344 | 2222344 | 2022-02-16 | Sullivan | Tennessee | 47163 | 44000 | 621 |
2222345 | 2222345 | 2022-02-16 | Sumner | Tennessee | 47165 | 52168 | 660 |
2222346 | 2222346 | 2022-02-16 | Tipton | Tennessee | 47167 | 17359 | 200 |
2222347 | 2222347 | 2022-02-16 | Trousdale | Tennessee | 47169 | 4165 | 44 |
2222348 | 2222348 | 2022-02-16 | Unicoi | Tennessee | 47171 | 4946 | 87 |
2222349 | 2222349 | 2022-02-16 | Union | Tennessee | 47173 | 5254 | 70 |
2222350 | 2222350 | 2022-02-16 | Unknown | Tennessee | 21718 | 214 | |
2222351 | 2222351 | 2022-02-16 | Van Buren | Tennessee | 47175 | 1813 | 46 |
2222352 | 2222352 | 2022-02-16 | Warren | Tennessee | 47177 | 12768 | 160 |
2222353 | 2222353 | 2022-02-16 | Washington | Tennessee | 47179 | 36643 | 448 |
2222354 | 2222354 | 2022-02-16 | Wayne | Tennessee | 47181 | 5568 | 53 |
2222355 | 2222355 | 2022-02-16 | Weakley | Tennessee | 47183 | 9314 | 123 |
2222356 | 2222356 | 2022-02-16 | White | Tennessee | 47185 | 8077 | 123 |
2222357 | 2222357 | 2022-02-16 | Williamson | Tennessee | 47187 | 60877 | 370 |
2222358 | 2222358 | 2022-02-16 | Wilson | Tennessee | 47189 | 40885 | 452 |
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);