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-05-23 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1348252 | 1348252 | 2021-05-23 | Anderson | Tennessee | 47001 | 8817 | 172 |
1348253 | 1348253 | 2021-05-23 | Bedford | Tennessee | 47003 | 6543 | 129 |
1348254 | 1348254 | 2021-05-23 | Benton | Tennessee | 47005 | 1682 | 40 |
1348255 | 1348255 | 2021-05-23 | Bledsoe | Tennessee | 47007 | 2172 | 11 |
1348256 | 1348256 | 2021-05-23 | Blount | Tennessee | 47009 | 15600 | 196 |
1348257 | 1348257 | 2021-05-23 | Bradley | Tennessee | 47011 | 15166 | 152 |
1348258 | 1348258 | 2021-05-23 | Campbell | Tennessee | 47013 | 4186 | 63 |
1348259 | 1348259 | 2021-05-23 | Cannon | Tennessee | 47015 | 1931 | 31 |
1348260 | 1348260 | 2021-05-23 | Carroll | Tennessee | 47017 | 3648 | 83 |
1348261 | 1348261 | 2021-05-23 | Carter | Tennessee | 47019 | 6686 | 158 |
1348262 | 1348262 | 2021-05-23 | Cheatham | Tennessee | 47021 | 4597 | 56 |
1348263 | 1348263 | 2021-05-23 | Chester | Tennessee | 47023 | 2163 | 51 |
1348264 | 1348264 | 2021-05-23 | Claiborne | Tennessee | 47025 | 3194 | 74 |
1348265 | 1348265 | 2021-05-23 | Clay | Tennessee | 47027 | 1104 | 30 |
1348266 | 1348266 | 2021-05-23 | Cocke | Tennessee | 47029 | 4534 | 100 |
1348267 | 1348267 | 2021-05-23 | Coffee | Tennessee | 47031 | 6936 | 124 |
1348268 | 1348268 | 2021-05-23 | Crockett | Tennessee | 47033 | 2039 | 49 |
1348269 | 1348269 | 2021-05-23 | Cumberland | Tennessee | 47035 | 6800 | 133 |
1348270 | 1348270 | 2021-05-23 | Davidson | Tennessee | 47037 | 99058 | 946 |
1348271 | 1348271 | 2021-05-23 | DeKalb | Tennessee | 47041 | 2815 | 54 |
1348272 | 1348272 | 2021-05-23 | Decatur | Tennessee | 47039 | 1596 | 39 |
1348273 | 1348273 | 2021-05-23 | Dickson | Tennessee | 47043 | 6878 | 114 |
1348274 | 1348274 | 2021-05-23 | Dyer | Tennessee | 47045 | 5453 | 106 |
1348275 | 1348275 | 2021-05-23 | Fayette | Tennessee | 47047 | 5134 | 79 |
1348276 | 1348276 | 2021-05-23 | Fentress | Tennessee | 47049 | 2437 | 47 |
1348277 | 1348277 | 2021-05-23 | Franklin | Tennessee | 47051 | 5166 | 90 |
1348278 | 1348278 | 2021-05-23 | Gibson | Tennessee | 47053 | 6578 | 147 |
1348279 | 1348279 | 2021-05-23 | Giles | Tennessee | 47055 | 4021 | 101 |
1348280 | 1348280 | 2021-05-23 | Grainger | Tennessee | 47057 | 2646 | 50 |
1348281 | 1348281 | 2021-05-23 | Greene | Tennessee | 47059 | 7951 | 157 |
1348282 | 1348282 | 2021-05-23 | Grundy | Tennessee | 47061 | 1795 | 35 |
1348283 | 1348283 | 2021-05-23 | Hamblen | Tennessee | 47063 | 8638 | 174 |
1348284 | 1348284 | 2021-05-23 | Hamilton | Tennessee | 47065 | 44951 | 498 |
1348285 | 1348285 | 2021-05-23 | Hancock | Tennessee | 47067 | 599 | 12 |
1348286 | 1348286 | 2021-05-23 | Hardeman | Tennessee | 47069 | 3543 | 64 |
1348287 | 1348287 | 2021-05-23 | Hardin | Tennessee | 47071 | 3588 | 68 |
1348288 | 1348288 | 2021-05-23 | Hawkins | Tennessee | 47073 | 6225 | 110 |
1348289 | 1348289 | 2021-05-23 | Haywood | Tennessee | 47075 | 2714 | 62 |
1348290 | 1348290 | 2021-05-23 | Henderson | Tennessee | 47077 | 3818 | 76 |
1348291 | 1348291 | 2021-05-23 | Henry | Tennessee | 47079 | 3223 | 76 |
1348292 | 1348292 | 2021-05-23 | Hickman | Tennessee | 47081 | 2854 | 46 |
1348293 | 1348293 | 2021-05-23 | Houston | Tennessee | 47083 | 1100 | 33 |
1348294 | 1348294 | 2021-05-23 | Humphreys | Tennessee | 47085 | 1835 | 28 |
1348295 | 1348295 | 2021-05-23 | Jackson | Tennessee | 47087 | 1325 | 36 |
1348296 | 1348296 | 2021-05-23 | Jefferson | Tennessee | 47089 | 6272 | 125 |
1348297 | 1348297 | 2021-05-23 | Johnson | Tennessee | 47091 | 2429 | 39 |
1348298 | 1348298 | 2021-05-23 | Knox | Tennessee | 47093 | 52146 | 638 |
1348299 | 1348299 | 2021-05-23 | Lake | Tennessee | 47095 | 1709 | 26 |
1348300 | 1348300 | 2021-05-23 | Lauderdale | Tennessee | 47097 | 3219 | 46 |
1348301 | 1348301 | 2021-05-23 | Lawrence | Tennessee | 47099 | 6006 | 92 |
1348302 | 1348302 | 2021-05-23 | Lewis | Tennessee | 47101 | 1589 | 26 |
1348303 | 1348303 | 2021-05-23 | Lincoln | Tennessee | 47103 | 4371 | 63 |
1348304 | 1348304 | 2021-05-23 | Loudon | Tennessee | 47105 | 6203 | 69 |
1348305 | 1348305 | 2021-05-23 | Macon | Tennessee | 47111 | 3637 | 78 |
1348306 | 1348306 | 2021-05-23 | Madison | Tennessee | 47113 | 11323 | 241 |
1348307 | 1348307 | 2021-05-23 | Marion | Tennessee | 47115 | 3140 | 47 |
1348308 | 1348308 | 2021-05-23 | Marshall | Tennessee | 47117 | 4210 | 58 |
1348309 | 1348309 | 2021-05-23 | Maury | Tennessee | 47119 | 13590 | 173 |
1348310 | 1348310 | 2021-05-23 | McMinn | Tennessee | 47107 | 6568 | 99 |
1348311 | 1348311 | 2021-05-23 | McNairy | Tennessee | 47109 | 2852 | 54 |
1348312 | 1348312 | 2021-05-23 | Meigs | Tennessee | 47121 | 1400 | 25 |
1348313 | 1348313 | 2021-05-23 | Monroe | Tennessee | 47123 | 5902 | 96 |
1348314 | 1348314 | 2021-05-23 | Montgomery | Tennessee | 47125 | 20613 | 228 |
1348315 | 1348315 | 2021-05-23 | Moore | Tennessee | 47127 | 1018 | 17 |
1348316 | 1348316 | 2021-05-23 | Morgan | Tennessee | 47129 | 2523 | 39 |
1348317 | 1348317 | 2021-05-23 | Obion | Tennessee | 47131 | 4570 | 96 |
1348318 | 1348318 | 2021-05-23 | Overton | Tennessee | 47133 | 3029 | 61 |
1348319 | 1348319 | 2021-05-23 | Perry | Tennessee | 47135 | 1073 | 28 |
1348320 | 1348320 | 2021-05-23 | Pickett | Tennessee | 47137 | 761 | 24 |
1348321 | 1348321 | 2021-05-23 | Polk | Tennessee | 47139 | 2100 | 25 |
1348322 | 1348322 | 2021-05-23 | Putnam | Tennessee | 47141 | 11458 | 175 |
1348323 | 1348323 | 2021-05-23 | Rhea | Tennessee | 47143 | 4375 | 75 |
1348324 | 1348324 | 2021-05-23 | Roane | Tennessee | 47145 | 6342 | 105 |
1348325 | 1348325 | 2021-05-23 | Robertson | Tennessee | 47147 | 9824 | 132 |
1348326 | 1348326 | 2021-05-23 | Rutherford | Tennessee | 47149 | 43358 | 440 |
1348327 | 1348327 | 2021-05-23 | Scott | Tennessee | 47151 | 3170 | 45 |
1348328 | 1348328 | 2021-05-23 | Sequatchie | Tennessee | 47153 | 1727 | 29 |
1348329 | 1348329 | 2021-05-23 | Sevier | Tennessee | 47155 | 13482 | 176 |
1348330 | 1348330 | 2021-05-23 | Shelby | Tennessee | 47157 | 98068 | 1661 |
1348331 | 1348331 | 2021-05-23 | Smith | Tennessee | 47159 | 2788 | 39 |
1348332 | 1348332 | 2021-05-23 | Stewart | Tennessee | 47161 | 1346 | 28 |
1348333 | 1348333 | 2021-05-23 | Sullivan | Tennessee | 47163 | 17084 | 302 |
1348334 | 1348334 | 2021-05-23 | Sumner | Tennessee | 47165 | 24233 | 349 |
1348335 | 1348335 | 2021-05-23 | Tipton | Tennessee | 47167 | 7427 | 104 |
1348336 | 1348336 | 2021-05-23 | Trousdale | Tennessee | 47169 | 2508 | 22 |
1348337 | 1348337 | 2021-05-23 | Unicoi | Tennessee | 47171 | 2050 | 49 |
1348338 | 1348338 | 2021-05-23 | Union | Tennessee | 47173 | 1935 | 34 |
1348339 | 1348339 | 2021-05-23 | Unknown | Tennessee | 9298 | 124 | |
1348340 | 1348340 | 2021-05-23 | Van Buren | Tennessee | 47175 | 856 | 23 |
1348341 | 1348341 | 2021-05-23 | Warren | Tennessee | 47177 | 5551 | 82 |
1348342 | 1348342 | 2021-05-23 | Washington | Tennessee | 47179 | 14753 | 248 |
1348343 | 1348343 | 2021-05-23 | Wayne | Tennessee | 47181 | 2970 | 34 |
1348344 | 1348344 | 2021-05-23 | Weakley | Tennessee | 47183 | 4180 | 67 |
1348345 | 1348345 | 2021-05-23 | White | Tennessee | 47185 | 3703 | 71 |
1348346 | 1348346 | 2021-05-23 | Williamson | Tennessee | 47187 | 28204 | 217 |
1348347 | 1348347 | 2021-05-23 | Wilson | Tennessee | 47189 | 18967 | 236 |
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);