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-19 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1335261 | 1335261 | 2021-05-19 | Anderson | Tennessee | 47001 | 8814 | 172 |
1335262 | 1335262 | 2021-05-19 | Bedford | Tennessee | 47003 | 6538 | 129 |
1335263 | 1335263 | 2021-05-19 | Benton | Tennessee | 47005 | 1682 | 40 |
1335264 | 1335264 | 2021-05-19 | Bledsoe | Tennessee | 47007 | 2168 | 11 |
1335265 | 1335265 | 2021-05-19 | Blount | Tennessee | 47009 | 15599 | 196 |
1335266 | 1335266 | 2021-05-19 | Bradley | Tennessee | 47011 | 15145 | 152 |
1335267 | 1335267 | 2021-05-19 | Campbell | Tennessee | 47013 | 4182 | 63 |
1335268 | 1335268 | 2021-05-19 | Cannon | Tennessee | 47015 | 1929 | 31 |
1335269 | 1335269 | 2021-05-19 | Carroll | Tennessee | 47017 | 3642 | 83 |
1335270 | 1335270 | 2021-05-19 | Carter | Tennessee | 47019 | 6682 | 158 |
1335271 | 1335271 | 2021-05-19 | Cheatham | Tennessee | 47021 | 4595 | 56 |
1335272 | 1335272 | 2021-05-19 | Chester | Tennessee | 47023 | 2158 | 51 |
1335273 | 1335273 | 2021-05-19 | Claiborne | Tennessee | 47025 | 3193 | 73 |
1335274 | 1335274 | 2021-05-19 | Clay | Tennessee | 47027 | 1104 | 30 |
1335275 | 1335275 | 2021-05-19 | Cocke | Tennessee | 47029 | 4530 | 100 |
1335276 | 1335276 | 2021-05-19 | Coffee | Tennessee | 47031 | 6933 | 124 |
1335277 | 1335277 | 2021-05-19 | Crockett | Tennessee | 47033 | 2038 | 49 |
1335278 | 1335278 | 2021-05-19 | Cumberland | Tennessee | 47035 | 6785 | 133 |
1335279 | 1335279 | 2021-05-19 | Davidson | Tennessee | 47037 | 98989 | 945 |
1335280 | 1335280 | 2021-05-19 | DeKalb | Tennessee | 47041 | 2810 | 54 |
1335281 | 1335281 | 2021-05-19 | Decatur | Tennessee | 47039 | 1593 | 39 |
1335282 | 1335282 | 2021-05-19 | Dickson | Tennessee | 47043 | 6861 | 114 |
1335283 | 1335283 | 2021-05-19 | Dyer | Tennessee | 47045 | 5447 | 106 |
1335284 | 1335284 | 2021-05-19 | Fayette | Tennessee | 47047 | 5129 | 78 |
1335285 | 1335285 | 2021-05-19 | Fentress | Tennessee | 47049 | 2436 | 47 |
1335286 | 1335286 | 2021-05-19 | Franklin | Tennessee | 47051 | 5164 | 90 |
1335287 | 1335287 | 2021-05-19 | Gibson | Tennessee | 47053 | 6567 | 147 |
1335288 | 1335288 | 2021-05-19 | Giles | Tennessee | 47055 | 4015 | 101 |
1335289 | 1335289 | 2021-05-19 | Grainger | Tennessee | 47057 | 2642 | 50 |
1335290 | 1335290 | 2021-05-19 | Greene | Tennessee | 47059 | 7944 | 157 |
1335291 | 1335291 | 2021-05-19 | Grundy | Tennessee | 47061 | 1794 | 35 |
1335292 | 1335292 | 2021-05-19 | Hamblen | Tennessee | 47063 | 8640 | 174 |
1335293 | 1335293 | 2021-05-19 | Hamilton | Tennessee | 47065 | 44879 | 497 |
1335294 | 1335294 | 2021-05-19 | Hancock | Tennessee | 47067 | 598 | 12 |
1335295 | 1335295 | 2021-05-19 | Hardeman | Tennessee | 47069 | 3543 | 64 |
1335296 | 1335296 | 2021-05-19 | Hardin | Tennessee | 47071 | 3588 | 68 |
1335297 | 1335297 | 2021-05-19 | Hawkins | Tennessee | 47073 | 6207 | 109 |
1335298 | 1335298 | 2021-05-19 | Haywood | Tennessee | 47075 | 2715 | 62 |
1335299 | 1335299 | 2021-05-19 | Henderson | Tennessee | 47077 | 3817 | 76 |
1335300 | 1335300 | 2021-05-19 | Henry | Tennessee | 47079 | 3217 | 76 |
1335301 | 1335301 | 2021-05-19 | Hickman | Tennessee | 47081 | 2853 | 46 |
1335302 | 1335302 | 2021-05-19 | Houston | Tennessee | 47083 | 1099 | 33 |
1335303 | 1335303 | 2021-05-19 | Humphreys | Tennessee | 47085 | 1830 | 28 |
1335304 | 1335304 | 2021-05-19 | Jackson | Tennessee | 47087 | 1326 | 36 |
1335305 | 1335305 | 2021-05-19 | Jefferson | Tennessee | 47089 | 6256 | 125 |
1335306 | 1335306 | 2021-05-19 | Johnson | Tennessee | 47091 | 2427 | 39 |
1335307 | 1335307 | 2021-05-19 | Knox | Tennessee | 47093 | 52157 | 638 |
1335308 | 1335308 | 2021-05-19 | Lake | Tennessee | 47095 | 1707 | 26 |
1335309 | 1335309 | 2021-05-19 | Lauderdale | Tennessee | 47097 | 3214 | 45 |
1335310 | 1335310 | 2021-05-19 | Lawrence | Tennessee | 47099 | 6000 | 91 |
1335311 | 1335311 | 2021-05-19 | Lewis | Tennessee | 47101 | 1586 | 26 |
1335312 | 1335312 | 2021-05-19 | Lincoln | Tennessee | 47103 | 4372 | 63 |
1335313 | 1335313 | 2021-05-19 | Loudon | Tennessee | 47105 | 6178 | 69 |
1335314 | 1335314 | 2021-05-19 | Macon | Tennessee | 47111 | 3632 | 78 |
1335315 | 1335315 | 2021-05-19 | Madison | Tennessee | 47113 | 11295 | 241 |
1335316 | 1335316 | 2021-05-19 | Marion | Tennessee | 47115 | 3135 | 47 |
1335317 | 1335317 | 2021-05-19 | Marshall | Tennessee | 47117 | 4207 | 58 |
1335318 | 1335318 | 2021-05-19 | Maury | Tennessee | 47119 | 13585 | 172 |
1335319 | 1335319 | 2021-05-19 | McMinn | Tennessee | 47107 | 6567 | 99 |
1335320 | 1335320 | 2021-05-19 | McNairy | Tennessee | 47109 | 2850 | 54 |
1335321 | 1335321 | 2021-05-19 | Meigs | Tennessee | 47121 | 1396 | 25 |
1335322 | 1335322 | 2021-05-19 | Monroe | Tennessee | 47123 | 5895 | 96 |
1335323 | 1335323 | 2021-05-19 | Montgomery | Tennessee | 47125 | 20564 | 228 |
1335324 | 1335324 | 2021-05-19 | Moore | Tennessee | 47127 | 1018 | 17 |
1335325 | 1335325 | 2021-05-19 | Morgan | Tennessee | 47129 | 2523 | 39 |
1335326 | 1335326 | 2021-05-19 | Obion | Tennessee | 47131 | 4562 | 96 |
1335327 | 1335327 | 2021-05-19 | Overton | Tennessee | 47133 | 3026 | 61 |
1335328 | 1335328 | 2021-05-19 | Perry | Tennessee | 47135 | 1073 | 28 |
1335329 | 1335329 | 2021-05-19 | Pickett | Tennessee | 47137 | 758 | 24 |
1335330 | 1335330 | 2021-05-19 | Polk | Tennessee | 47139 | 2097 | 25 |
1335331 | 1335331 | 2021-05-19 | Putnam | Tennessee | 47141 | 11448 | 175 |
1335332 | 1335332 | 2021-05-19 | Rhea | Tennessee | 47143 | 4371 | 75 |
1335333 | 1335333 | 2021-05-19 | Roane | Tennessee | 47145 | 6331 | 105 |
1335334 | 1335334 | 2021-05-19 | Robertson | Tennessee | 47147 | 9817 | 132 |
1335335 | 1335335 | 2021-05-19 | Rutherford | Tennessee | 47149 | 43309 | 438 |
1335336 | 1335336 | 2021-05-19 | Scott | Tennessee | 47151 | 3167 | 45 |
1335337 | 1335337 | 2021-05-19 | Sequatchie | Tennessee | 47153 | 1725 | 29 |
1335338 | 1335338 | 2021-05-19 | Sevier | Tennessee | 47155 | 13472 | 176 |
1335339 | 1335339 | 2021-05-19 | Shelby | Tennessee | 47157 | 97761 | 1648 |
1335340 | 1335340 | 2021-05-19 | Smith | Tennessee | 47159 | 2788 | 39 |
1335341 | 1335341 | 2021-05-19 | Stewart | Tennessee | 47161 | 1344 | 28 |
1335342 | 1335342 | 2021-05-19 | Sullivan | Tennessee | 47163 | 17034 | 302 |
1335343 | 1335343 | 2021-05-19 | Sumner | Tennessee | 47165 | 24207 | 349 |
1335344 | 1335344 | 2021-05-19 | Tipton | Tennessee | 47167 | 7414 | 104 |
1335345 | 1335345 | 2021-05-19 | Trousdale | Tennessee | 47169 | 2507 | 22 |
1335346 | 1335346 | 2021-05-19 | Unicoi | Tennessee | 47171 | 2047 | 49 |
1335347 | 1335347 | 2021-05-19 | Union | Tennessee | 47173 | 1930 | 34 |
1335348 | 1335348 | 2021-05-19 | Unknown | Tennessee | 9290 | 123 | |
1335349 | 1335349 | 2021-05-19 | Van Buren | Tennessee | 47175 | 855 | 23 |
1335350 | 1335350 | 2021-05-19 | Warren | Tennessee | 47177 | 5560 | 81 |
1335351 | 1335351 | 2021-05-19 | Washington | Tennessee | 47179 | 14736 | 247 |
1335352 | 1335352 | 2021-05-19 | Wayne | Tennessee | 47181 | 2968 | 34 |
1335353 | 1335353 | 2021-05-19 | Weakley | Tennessee | 47183 | 4173 | 67 |
1335354 | 1335354 | 2021-05-19 | White | Tennessee | 47185 | 3697 | 71 |
1335355 | 1335355 | 2021-05-19 | Williamson | Tennessee | 47187 | 28179 | 217 |
1335356 | 1335356 | 2021-05-19 | Wilson | Tennessee | 47189 | 18949 | 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);