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-27 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1361236 | 1361236 | 2021-05-27 | Anderson | Tennessee | 47001 | 8830 | 172 |
1361237 | 1361237 | 2021-05-27 | Bedford | Tennessee | 47003 | 6546 | 130 |
1361238 | 1361238 | 2021-05-27 | Benton | Tennessee | 47005 | 1681 | 41 |
1361239 | 1361239 | 2021-05-27 | Bledsoe | Tennessee | 47007 | 2180 | 11 |
1361240 | 1361240 | 2021-05-27 | Blount | Tennessee | 47009 | 15620 | 196 |
1361241 | 1361241 | 2021-05-27 | Bradley | Tennessee | 47011 | 15195 | 153 |
1361242 | 1361242 | 2021-05-27 | Campbell | Tennessee | 47013 | 4200 | 63 |
1361243 | 1361243 | 2021-05-27 | Cannon | Tennessee | 47015 | 1935 | 31 |
1361244 | 1361244 | 2021-05-27 | Carroll | Tennessee | 47017 | 3653 | 83 |
1361245 | 1361245 | 2021-05-27 | Carter | Tennessee | 47019 | 6695 | 158 |
1361246 | 1361246 | 2021-05-27 | Cheatham | Tennessee | 47021 | 4605 | 56 |
1361247 | 1361247 | 2021-05-27 | Chester | Tennessee | 47023 | 2171 | 51 |
1361248 | 1361248 | 2021-05-27 | Claiborne | Tennessee | 47025 | 3198 | 74 |
1361249 | 1361249 | 2021-05-27 | Clay | Tennessee | 47027 | 1103 | 30 |
1361250 | 1361250 | 2021-05-27 | Cocke | Tennessee | 47029 | 4540 | 100 |
1361251 | 1361251 | 2021-05-27 | Coffee | Tennessee | 47031 | 6947 | 125 |
1361252 | 1361252 | 2021-05-27 | Crockett | Tennessee | 47033 | 2041 | 49 |
1361253 | 1361253 | 2021-05-27 | Cumberland | Tennessee | 47035 | 6816 | 138 |
1361254 | 1361254 | 2021-05-27 | Davidson | Tennessee | 47037 | 99242 | 948 |
1361255 | 1361255 | 2021-05-27 | DeKalb | Tennessee | 47041 | 2819 | 54 |
1361256 | 1361256 | 2021-05-27 | Decatur | Tennessee | 47039 | 1604 | 39 |
1361257 | 1361257 | 2021-05-27 | Dickson | Tennessee | 47043 | 6900 | 114 |
1361258 | 1361258 | 2021-05-27 | Dyer | Tennessee | 47045 | 5456 | 106 |
1361259 | 1361259 | 2021-05-27 | Fayette | Tennessee | 47047 | 5156 | 83 |
1361260 | 1361260 | 2021-05-27 | Fentress | Tennessee | 47049 | 2441 | 48 |
1361261 | 1361261 | 2021-05-27 | Franklin | Tennessee | 47051 | 5174 | 90 |
1361262 | 1361262 | 2021-05-27 | Gibson | Tennessee | 47053 | 6611 | 147 |
1361263 | 1361263 | 2021-05-27 | Giles | Tennessee | 47055 | 4025 | 101 |
1361264 | 1361264 | 2021-05-27 | Grainger | Tennessee | 47057 | 2652 | 49 |
1361265 | 1361265 | 2021-05-27 | Greene | Tennessee | 47059 | 7963 | 158 |
1361266 | 1361266 | 2021-05-27 | Grundy | Tennessee | 47061 | 1793 | 35 |
1361267 | 1361267 | 2021-05-27 | Hamblen | Tennessee | 47063 | 8638 | 174 |
1361268 | 1361268 | 2021-05-27 | Hamilton | Tennessee | 47065 | 45099 | 499 |
1361269 | 1361269 | 2021-05-27 | Hancock | Tennessee | 47067 | 602 | 12 |
1361270 | 1361270 | 2021-05-27 | Hardeman | Tennessee | 47069 | 3549 | 65 |
1361271 | 1361271 | 2021-05-27 | Hardin | Tennessee | 47071 | 3589 | 68 |
1361272 | 1361272 | 2021-05-27 | Hawkins | Tennessee | 47073 | 6274 | 110 |
1361273 | 1361273 | 2021-05-27 | Haywood | Tennessee | 47075 | 2715 | 62 |
1361274 | 1361274 | 2021-05-27 | Henderson | Tennessee | 47077 | 3826 | 76 |
1361275 | 1361275 | 2021-05-27 | Henry | Tennessee | 47079 | 3238 | 76 |
1361276 | 1361276 | 2021-05-27 | Hickman | Tennessee | 47081 | 2864 | 46 |
1361277 | 1361277 | 2021-05-27 | Houston | Tennessee | 47083 | 1106 | 33 |
1361278 | 1361278 | 2021-05-27 | Humphreys | Tennessee | 47085 | 1852 | 28 |
1361279 | 1361279 | 2021-05-27 | Jackson | Tennessee | 47087 | 1326 | 36 |
1361280 | 1361280 | 2021-05-27 | Jefferson | Tennessee | 47089 | 6280 | 125 |
1361281 | 1361281 | 2021-05-27 | Johnson | Tennessee | 47091 | 2438 | 39 |
1361282 | 1361282 | 2021-05-27 | Knox | Tennessee | 47093 | 52028 | 639 |
1361283 | 1361283 | 2021-05-27 | Lake | Tennessee | 47095 | 1711 | 26 |
1361284 | 1361284 | 2021-05-27 | Lauderdale | Tennessee | 47097 | 3232 | 47 |
1361285 | 1361285 | 2021-05-27 | Lawrence | Tennessee | 47099 | 6026 | 92 |
1361286 | 1361286 | 2021-05-27 | Lewis | Tennessee | 47101 | 1590 | 26 |
1361287 | 1361287 | 2021-05-27 | Lincoln | Tennessee | 47103 | 4373 | 65 |
1361288 | 1361288 | 2021-05-27 | Loudon | Tennessee | 47105 | 6217 | 70 |
1361289 | 1361289 | 2021-05-27 | Macon | Tennessee | 47111 | 3641 | 78 |
1361290 | 1361290 | 2021-05-27 | Madison | Tennessee | 47113 | 11355 | 241 |
1361291 | 1361291 | 2021-05-27 | Marion | Tennessee | 47115 | 3150 | 47 |
1361292 | 1361292 | 2021-05-27 | Marshall | Tennessee | 47117 | 4218 | 58 |
1361293 | 1361293 | 2021-05-27 | Maury | Tennessee | 47119 | 13604 | 173 |
1361294 | 1361294 | 2021-05-27 | McMinn | Tennessee | 47107 | 6582 | 99 |
1361295 | 1361295 | 2021-05-27 | McNairy | Tennessee | 47109 | 2856 | 54 |
1361296 | 1361296 | 2021-05-27 | Meigs | Tennessee | 47121 | 1400 | 25 |
1361297 | 1361297 | 2021-05-27 | Monroe | Tennessee | 47123 | 5918 | 96 |
1361298 | 1361298 | 2021-05-27 | Montgomery | Tennessee | 47125 | 20674 | 228 |
1361299 | 1361299 | 2021-05-27 | Moore | Tennessee | 47127 | 1019 | 17 |
1361300 | 1361300 | 2021-05-27 | Morgan | Tennessee | 47129 | 2524 | 39 |
1361301 | 1361301 | 2021-05-27 | Obion | Tennessee | 47131 | 4584 | 96 |
1361302 | 1361302 | 2021-05-27 | Overton | Tennessee | 47133 | 3033 | 61 |
1361303 | 1361303 | 2021-05-27 | Perry | Tennessee | 47135 | 1073 | 28 |
1361304 | 1361304 | 2021-05-27 | Pickett | Tennessee | 47137 | 763 | 24 |
1361305 | 1361305 | 2021-05-27 | Polk | Tennessee | 47139 | 2105 | 25 |
1361306 | 1361306 | 2021-05-27 | Putnam | Tennessee | 47141 | 11472 | 178 |
1361307 | 1361307 | 2021-05-27 | Rhea | Tennessee | 47143 | 4377 | 75 |
1361308 | 1361308 | 2021-05-27 | Roane | Tennessee | 47145 | 6346 | 105 |
1361309 | 1361309 | 2021-05-27 | Robertson | Tennessee | 47147 | 9834 | 132 |
1361310 | 1361310 | 2021-05-27 | Rutherford | Tennessee | 47149 | 43441 | 442 |
1361311 | 1361311 | 2021-05-27 | Scott | Tennessee | 47151 | 3186 | 45 |
1361312 | 1361312 | 2021-05-27 | Sequatchie | Tennessee | 47153 | 1737 | 29 |
1361313 | 1361313 | 2021-05-27 | Sevier | Tennessee | 47155 | 13486 | 176 |
1361314 | 1361314 | 2021-05-27 | Shelby | Tennessee | 47157 | 98542 | 1671 |
1361315 | 1361315 | 2021-05-27 | Smith | Tennessee | 47159 | 2791 | 40 |
1361316 | 1361316 | 2021-05-27 | Stewart | Tennessee | 47161 | 1356 | 28 |
1361317 | 1361317 | 2021-05-27 | Sullivan | Tennessee | 47163 | 17156 | 303 |
1361318 | 1361318 | 2021-05-27 | Sumner | Tennessee | 47165 | 24305 | 349 |
1361319 | 1361319 | 2021-05-27 | Tipton | Tennessee | 47167 | 7445 | 104 |
1361320 | 1361320 | 2021-05-27 | Trousdale | Tennessee | 47169 | 2510 | 22 |
1361321 | 1361321 | 2021-05-27 | Unicoi | Tennessee | 47171 | 2050 | 49 |
1361322 | 1361322 | 2021-05-27 | Union | Tennessee | 47173 | 1940 | 34 |
1361323 | 1361323 | 2021-05-27 | Unknown | Tennessee | 9548 | 125 | |
1361324 | 1361324 | 2021-05-27 | Van Buren | Tennessee | 47175 | 858 | 23 |
1361325 | 1361325 | 2021-05-27 | Warren | Tennessee | 47177 | 5554 | 82 |
1361326 | 1361326 | 2021-05-27 | Washington | Tennessee | 47179 | 14781 | 248 |
1361327 | 1361327 | 2021-05-27 | Wayne | Tennessee | 47181 | 2976 | 34 |
1361328 | 1361328 | 2021-05-27 | Weakley | Tennessee | 47183 | 4190 | 67 |
1361329 | 1361329 | 2021-05-27 | White | Tennessee | 47185 | 3706 | 74 |
1361330 | 1361330 | 2021-05-27 | Williamson | Tennessee | 47187 | 28253 | 218 |
1361331 | 1361331 | 2021-05-27 | Wilson | Tennessee | 47189 | 19006 | 239 |
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);