ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2021-08-16" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1624220 | 1624220 | 2021-08-16 | Anderson | Tennessee | 47001 | 9500 | 181 |
1624221 | 1624221 | 2021-08-16 | Bedford | Tennessee | 47003 | 7163 | 135 |
1624222 | 1624222 | 2021-08-16 | Benton | Tennessee | 47005 | 1877 | 41 |
1624223 | 1624223 | 2021-08-16 | Bledsoe | Tennessee | 47007 | 2454 | 13 |
1624224 | 1624224 | 2021-08-16 | Blount | Tennessee | 47009 | 17395 | 210 |
1624225 | 1624225 | 2021-08-16 | Bradley | Tennessee | 47011 | 16578 | 158 |
1624226 | 1624226 | 2021-08-16 | Campbell | Tennessee | 47013 | 4519 | 64 |
1624227 | 1624227 | 2021-08-16 | Cannon | Tennessee | 47015 | 2083 | 32 |
1624228 | 1624228 | 2021-08-16 | Carroll | Tennessee | 47017 | 4019 | 84 |
1624229 | 1624229 | 2021-08-16 | Carter | Tennessee | 47019 | 7338 | 169 |
1624230 | 1624230 | 2021-08-16 | Cheatham | Tennessee | 47021 | 5014 | 56 |
1624231 | 1624231 | 2021-08-16 | Chester | Tennessee | 47023 | 2518 | 51 |
1624232 | 1624232 | 2021-08-16 | Claiborne | Tennessee | 47025 | 3481 | 77 |
1624233 | 1624233 | 2021-08-16 | Clay | Tennessee | 47027 | 1148 | 30 |
1624234 | 1624234 | 2021-08-16 | Cocke | Tennessee | 47029 | 5059 | 102 |
1624235 | 1624235 | 2021-08-16 | Coffee | Tennessee | 47031 | 7437 | 123 |
1624236 | 1624236 | 2021-08-16 | Crockett | Tennessee | 47033 | 2484 | 52 |
1624237 | 1624237 | 2021-08-16 | Cumberland | Tennessee | 47035 | 7678 | 146 |
1624238 | 1624238 | 2021-08-16 | Davidson | Tennessee | 47037 | 107425 | 984 |
1624239 | 1624239 | 2021-08-16 | DeKalb | Tennessee | 47041 | 3040 | 57 |
1624240 | 1624240 | 2021-08-16 | Decatur | Tennessee | 47039 | 1771 | 39 |
1624241 | 1624241 | 2021-08-16 | Dickson | Tennessee | 47043 | 7641 | 119 |
1624242 | 1624242 | 2021-08-16 | Dyer | Tennessee | 47045 | 5961 | 110 |
1624243 | 1624243 | 2021-08-16 | Fayette | Tennessee | 47047 | 5804 | 85 |
1624244 | 1624244 | 2021-08-16 | Fentress | Tennessee | 47049 | 2660 | 50 |
1624245 | 1624245 | 2021-08-16 | Franklin | Tennessee | 47051 | 5762 | 92 |
1624246 | 1624246 | 2021-08-16 | Gibson | Tennessee | 47053 | 7728 | 152 |
1624247 | 1624247 | 2021-08-16 | Giles | Tennessee | 47055 | 4382 | 100 |
1624248 | 1624248 | 2021-08-16 | Grainger | Tennessee | 47057 | 2908 | 51 |
1624249 | 1624249 | 2021-08-16 | Greene | Tennessee | 47059 | 8816 | 164 |
1624250 | 1624250 | 2021-08-16 | Grundy | Tennessee | 47061 | 1972 | 35 |
1624251 | 1624251 | 2021-08-16 | Hamblen | Tennessee | 47063 | 9704 | 178 |
1624252 | 1624252 | 2021-08-16 | Hamilton | Tennessee | 47065 | 50510 | 533 |
1624253 | 1624253 | 2021-08-16 | Hancock | Tennessee | 47067 | 711 | 13 |
1624254 | 1624254 | 2021-08-16 | Hardeman | Tennessee | 47069 | 3932 | 65 |
1624255 | 1624255 | 2021-08-16 | Hardin | Tennessee | 47071 | 3986 | 70 |
1624256 | 1624256 | 2021-08-16 | Hawkins | Tennessee | 47073 | 6972 | 124 |
1624257 | 1624257 | 2021-08-16 | Haywood | Tennessee | 47075 | 3005 | 62 |
1624258 | 1624258 | 2021-08-16 | Henderson | Tennessee | 47077 | 4144 | 79 |
1624259 | 1624259 | 2021-08-16 | Henry | Tennessee | 47079 | 3918 | 76 |
1624260 | 1624260 | 2021-08-16 | Hickman | Tennessee | 47081 | 3198 | 48 |
1624261 | 1624261 | 2021-08-16 | Houston | Tennessee | 47083 | 1309 | 34 |
1624262 | 1624262 | 2021-08-16 | Humphreys | Tennessee | 47085 | 2187 | 32 |
1624263 | 1624263 | 2021-08-16 | Jackson | Tennessee | 47087 | 1453 | 37 |
1624264 | 1624264 | 2021-08-16 | Jefferson | Tennessee | 47089 | 6938 | 130 |
1624265 | 1624265 | 2021-08-16 | Johnson | Tennessee | 47091 | 2587 | 39 |
1624266 | 1624266 | 2021-08-16 | Knox | Tennessee | 47093 | 56302 | 673 |
1624267 | 1624267 | 2021-08-16 | Lake | Tennessee | 47095 | 1754 | 31 |
1624268 | 1624268 | 2021-08-16 | Lauderdale | Tennessee | 47097 | 3658 | 50 |
1624269 | 1624269 | 2021-08-16 | Lawrence | Tennessee | 47099 | 6664 | 101 |
1624270 | 1624270 | 2021-08-16 | Lewis | Tennessee | 47101 | 1824 | 28 |
1624271 | 1624271 | 2021-08-16 | Lincoln | Tennessee | 47103 | 4897 | 69 |
1624272 | 1624272 | 2021-08-16 | Loudon | Tennessee | 47105 | 6714 | 71 |
1624273 | 1624273 | 2021-08-16 | Macon | Tennessee | 47111 | 3978 | 78 |
1624274 | 1624274 | 2021-08-16 | Madison | Tennessee | 47113 | 13214 | 251 |
1624275 | 1624275 | 2021-08-16 | Marion | Tennessee | 47115 | 3636 | 51 |
1624276 | 1624276 | 2021-08-16 | Marshall | Tennessee | 47117 | 4773 | 65 |
1624277 | 1624277 | 2021-08-16 | Maury | Tennessee | 47119 | 14883 | 182 |
1624278 | 1624278 | 2021-08-16 | McMinn | Tennessee | 47107 | 7365 | 108 |
1624279 | 1624279 | 2021-08-16 | McNairy | Tennessee | 47109 | 3278 | 57 |
1624280 | 1624280 | 2021-08-16 | Meigs | Tennessee | 47121 | 1550 | 24 |
1624281 | 1624281 | 2021-08-16 | Monroe | Tennessee | 47123 | 6532 | 98 |
1624282 | 1624282 | 2021-08-16 | Montgomery | Tennessee | 47125 | 23369 | 236 |
1624283 | 1624283 | 2021-08-16 | Moore | Tennessee | 47127 | 1132 | 19 |
1624284 | 1624284 | 2021-08-16 | Morgan | Tennessee | 47129 | 2792 | 40 |
1624285 | 1624285 | 2021-08-16 | Obion | Tennessee | 47131 | 4932 | 98 |
1624286 | 1624286 | 2021-08-16 | Overton | Tennessee | 47133 | 3246 | 63 |
1624287 | 1624287 | 2021-08-16 | Perry | Tennessee | 47135 | 1169 | 29 |
1624288 | 1624288 | 2021-08-16 | Pickett | Tennessee | 47137 | 808 | 24 |
1624289 | 1624289 | 2021-08-16 | Polk | Tennessee | 47139 | 2306 | 25 |
1624290 | 1624290 | 2021-08-16 | Putnam | Tennessee | 47141 | 12523 | 183 |
1624291 | 1624291 | 2021-08-16 | Rhea | Tennessee | 47143 | 4804 | 83 |
1624292 | 1624292 | 2021-08-16 | Roane | Tennessee | 47145 | 7102 | 114 |
1624293 | 1624293 | 2021-08-16 | Robertson | Tennessee | 47147 | 10768 | 145 |
1624294 | 1624294 | 2021-08-16 | Rutherford | Tennessee | 47149 | 47405 | 458 |
1624295 | 1624295 | 2021-08-16 | Scott | Tennessee | 47151 | 3390 | 48 |
1624296 | 1624296 | 2021-08-16 | Sequatchie | Tennessee | 47153 | 1959 | 30 |
1624297 | 1624297 | 2021-08-16 | Sevier | Tennessee | 47155 | 15054 | 183 |
1624298 | 1624298 | 2021-08-16 | Shelby | Tennessee | 47157 | 114967 | 1783 |
1624299 | 1624299 | 2021-08-16 | Smith | Tennessee | 47159 | 3032 | 40 |
1624300 | 1624300 | 2021-08-16 | Stewart | Tennessee | 47161 | 1470 | 28 |
1624301 | 1624301 | 2021-08-16 | Sullivan | Tennessee | 47163 | 18964 | 325 |
1624302 | 1624302 | 2021-08-16 | Sumner | Tennessee | 47165 | 27032 | 366 |
1624303 | 1624303 | 2021-08-16 | Tipton | Tennessee | 47167 | 8568 | 107 |
1624304 | 1624304 | 2021-08-16 | Trousdale | Tennessee | 47169 | 2662 | 22 |
1624305 | 1624305 | 2021-08-16 | Unicoi | Tennessee | 47171 | 2217 | 51 |
1624306 | 1624306 | 2021-08-16 | Union | Tennessee | 47173 | 2062 | 34 |
1624307 | 1624307 | 2021-08-16 | Unknown | Tennessee | 8855 | 92 | |
1624308 | 1624308 | 2021-08-16 | Van Buren | Tennessee | 47175 | 927 | 23 |
1624309 | 1624309 | 2021-08-16 | Warren | Tennessee | 47177 | 5904 | 87 |
1624310 | 1624310 | 2021-08-16 | Washington | Tennessee | 47179 | 16040 | 259 |
1624311 | 1624311 | 2021-08-16 | Wayne | Tennessee | 47181 | 3162 | 36 |
1624312 | 1624312 | 2021-08-16 | Weakley | Tennessee | 47183 | 4545 | 70 |
1624313 | 1624313 | 2021-08-16 | White | Tennessee | 47185 | 3974 | 75 |
1624314 | 1624314 | 2021-08-16 | Williamson | Tennessee | 47187 | 31550 | 228 |
1624315 | 1624315 | 2021-08-16 | Wilson | Tennessee | 47189 | 21125 | 261 |
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);