ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-10-15" 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 |
---|---|---|---|---|---|---|---|
634164 | 634164 | 2020-10-15 | Anderson | Tennessee | 47001 | 1486 | 13 |
634165 | 634165 | 2020-10-15 | Bedford | Tennessee | 47003 | 1548 | 19 |
634166 | 634166 | 2020-10-15 | Benton | Tennessee | 47005 | 370 | 9 |
634167 | 634167 | 2020-10-15 | Bledsoe | Tennessee | 47007 | 906 | 4 |
634168 | 634168 | 2020-10-15 | Blount | Tennessee | 47009 | 2974 | 31 |
634169 | 634169 | 2020-10-15 | Bradley | Tennessee | 47011 | 3306 | 21 |
634170 | 634170 | 2020-10-15 | Campbell | Tennessee | 47013 | 786 | 6 |
634171 | 634171 | 2020-10-15 | Cannon | Tennessee | 47015 | 366 | 2 |
634172 | 634172 | 2020-10-15 | Carroll | Tennessee | 47017 | 1072 | 24 |
634173 | 634173 | 2020-10-15 | Carter | Tennessee | 47019 | 1359 | 32 |
634174 | 634174 | 2020-10-15 | Cheatham | Tennessee | 47021 | 927 | 10 |
634175 | 634175 | 2020-10-15 | Chester | Tennessee | 47023 | 703 | 13 |
634176 | 634176 | 2020-10-15 | Claiborne | Tennessee | 47025 | 487 | 6 |
634177 | 634177 | 2020-10-15 | Clay | Tennessee | 47027 | 351 | 7 |
634178 | 634178 | 2020-10-15 | Cocke | Tennessee | 47029 | 878 | 12 |
634179 | 634179 | 2020-10-15 | Coffee | Tennessee | 47031 | 1668 | 19 |
634180 | 634180 | 2020-10-15 | Crockett | Tennessee | 47033 | 715 | 19 |
634181 | 634181 | 2020-10-15 | Cumberland | Tennessee | 47035 | 1446 | 24 |
634182 | 634182 | 2020-10-15 | Davidson | Tennessee | 47037 | 31011 | 324 |
634183 | 634183 | 2020-10-15 | DeKalb | Tennessee | 47041 | 653 | 16 |
634184 | 634184 | 2020-10-15 | Decatur | Tennessee | 47039 | 607 | 11 |
634185 | 634185 | 2020-10-15 | Dickson | Tennessee | 47043 | 1487 | 18 |
634186 | 634186 | 2020-10-15 | Dyer | Tennessee | 47045 | 1874 | 24 |
634187 | 634187 | 2020-10-15 | Fayette | Tennessee | 47047 | 1453 | 21 |
634188 | 634188 | 2020-10-15 | Fentress | Tennessee | 47049 | 812 | 5 |
634189 | 634189 | 2020-10-15 | Franklin | Tennessee | 47051 | 1169 | 14 |
634190 | 634190 | 2020-10-15 | Gibson | Tennessee | 47053 | 1997 | 36 |
634191 | 634191 | 2020-10-15 | Giles | Tennessee | 47055 | 850 | 30 |
634192 | 634192 | 2020-10-15 | Grainger | Tennessee | 47057 | 497 | 4 |
634193 | 634193 | 2020-10-15 | Greene | Tennessee | 47059 | 1435 | 48 |
634194 | 634194 | 2020-10-15 | Grundy | Tennessee | 47061 | 483 | 8 |
634195 | 634195 | 2020-10-15 | Hamblen | Tennessee | 47063 | 2271 | 43 |
634196 | 634196 | 2020-10-15 | Hamilton | Tennessee | 47065 | 10984 | 103 |
634197 | 634197 | 2020-10-15 | Hancock | Tennessee | 47067 | 112 | 3 |
634198 | 634198 | 2020-10-15 | Hardeman | Tennessee | 47069 | 1733 | 32 |
634199 | 634199 | 2020-10-15 | Hardin | Tennessee | 47071 | 1245 | 19 |
634200 | 634200 | 2020-10-15 | Hawkins | Tennessee | 47073 | 1039 | 23 |
634201 | 634201 | 2020-10-15 | Haywood | Tennessee | 47075 | 1169 | 25 |
634202 | 634202 | 2020-10-15 | Henderson | Tennessee | 47077 | 1335 | 24 |
634203 | 634203 | 2020-10-15 | Henry | Tennessee | 47079 | 708 | 10 |
634204 | 634204 | 2020-10-15 | Hickman | Tennessee | 47081 | 711 | 13 |
634205 | 634205 | 2020-10-15 | Houston | Tennessee | 47083 | 373 | 14 |
634206 | 634206 | 2020-10-15 | Humphreys | Tennessee | 47085 | 377 | 4 |
634207 | 634207 | 2020-10-15 | Jackson | Tennessee | 47087 | 403 | 5 |
634208 | 634208 | 2020-10-15 | Jefferson | Tennessee | 47089 | 1393 | 18 |
634209 | 634209 | 2020-10-15 | Johnson | Tennessee | 47091 | 1060 | 6 |
634210 | 634210 | 2020-10-15 | Knox | Tennessee | 47093 | 11841 | 90 |
634211 | 634211 | 2020-10-15 | Lake | Tennessee | 47095 | 954 | 3 |
634212 | 634212 | 2020-10-15 | Lauderdale | Tennessee | 47097 | 1232 | 17 |
634213 | 634213 | 2020-10-15 | Lawrence | Tennessee | 47099 | 1368 | 17 |
634214 | 634214 | 2020-10-15 | Lewis | Tennessee | 47101 | 300 | 2 |
634215 | 634215 | 2020-10-15 | Lincoln | Tennessee | 47103 | 763 | 2 |
634216 | 634216 | 2020-10-15 | Loudon | Tennessee | 47105 | 1498 | 10 |
634217 | 634217 | 2020-10-15 | Macon | Tennessee | 47111 | 1231 | 23 |
634218 | 634218 | 2020-10-15 | Madison | Tennessee | 47113 | 3468 | 78 |
634219 | 634219 | 2020-10-15 | Marion | Tennessee | 47115 | 652 | 9 |
634220 | 634220 | 2020-10-15 | Marshall | Tennessee | 47117 | 987 | 8 |
634221 | 634221 | 2020-10-15 | Maury | Tennessee | 47119 | 2874 | 34 |
634222 | 634222 | 2020-10-15 | McMinn | Tennessee | 47107 | 1406 | 32 |
634223 | 634223 | 2020-10-15 | McNairy | Tennessee | 47109 | 1058 | 25 |
634224 | 634224 | 2020-10-15 | Meigs | Tennessee | 47121 | 269 | 4 |
634225 | 634225 | 2020-10-15 | Monroe | Tennessee | 47123 | 1263 | 21 |
634226 | 634226 | 2020-10-15 | Montgomery | Tennessee | 47125 | 3678 | 51 |
634227 | 634227 | 2020-10-15 | Moore | Tennessee | 47127 | 228 | 1 |
634228 | 634228 | 2020-10-15 | Morgan | Tennessee | 47129 | 391 | 6 |
634229 | 634229 | 2020-10-15 | Obion | Tennessee | 47131 | 1580 | 18 |
634230 | 634230 | 2020-10-15 | Overton | Tennessee | 47133 | 1055 | 11 |
634231 | 634231 | 2020-10-15 | Perry | Tennessee | 47135 | 176 | 1 |
634232 | 634232 | 2020-10-15 | Pickett | Tennessee | 47137 | 220 | 3 |
634233 | 634233 | 2020-10-15 | Polk | Tennessee | 47139 | 451 | 13 |
634234 | 634234 | 2020-10-15 | Putnam | Tennessee | 47141 | 3948 | 51 |
634235 | 634235 | 2020-10-15 | Rhea | Tennessee | 47143 | 998 | 16 |
634236 | 634236 | 2020-10-15 | Roane | Tennessee | 47145 | 1123 | 6 |
634237 | 634237 | 2020-10-15 | Robertson | Tennessee | 47147 | 2419 | 39 |
634238 | 634238 | 2020-10-15 | Rutherford | Tennessee | 47149 | 10637 | 105 |
634239 | 634239 | 2020-10-15 | Scott | Tennessee | 47151 | 299 | 3 |
634240 | 634240 | 2020-10-15 | Sequatchie | Tennessee | 47153 | 301 | 4 |
634241 | 634241 | 2020-10-15 | Sevier | Tennessee | 47155 | 3044 | 20 |
634242 | 634242 | 2020-10-15 | Shelby | Tennessee | 47157 | 33710 | 547 |
634243 | 634243 | 2020-10-15 | Smith | Tennessee | 47159 | 907 | 12 |
634244 | 634244 | 2020-10-15 | Stewart | Tennessee | 47161 | 297 | 7 |
634245 | 634245 | 2020-10-15 | Sullivan | Tennessee | 47163 | 2914 | 42 |
634246 | 634246 | 2020-10-15 | Sumner | Tennessee | 47165 | 5428 | 106 |
634247 | 634247 | 2020-10-15 | Tipton | Tennessee | 47167 | 2123 | 22 |
634248 | 634248 | 2020-10-15 | Trousdale | Tennessee | 47169 | 1717 | 7 |
634249 | 634249 | 2020-10-15 | Unicoi | Tennessee | 47171 | 330 | 1 |
634250 | 634250 | 2020-10-15 | Union | Tennessee | 47173 | 474 | 2 |
634251 | 634251 | 2020-10-15 | Unknown | Tennessee | 403 | 0 | |
634252 | 634252 | 2020-10-15 | Van Buren | Tennessee | 47175 | 186 | 1 |
634253 | 634253 | 2020-10-15 | Warren | Tennessee | 47177 | 1282 | 9 |
634254 | 634254 | 2020-10-15 | Washington | Tennessee | 47179 | 2855 | 42 |
634255 | 634255 | 2020-10-15 | Wayne | Tennessee | 47181 | 1546 | 7 |
634256 | 634256 | 2020-10-15 | Weakley | Tennessee | 47183 | 1400 | 23 |
634257 | 634257 | 2020-10-15 | White | Tennessee | 47185 | 1032 | 14 |
634258 | 634258 | 2020-10-15 | Williamson | Tennessee | 47187 | 6274 | 47 |
634259 | 634259 | 2020-10-15 | Wilson | Tennessee | 47189 | 4176 | 52 |
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);