ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-12-28" 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 |
---|---|---|---|---|---|---|---|
874283 | 874283 | 2020-12-28 | Anderson | Tennessee | 47001 | 5461 | 58 |
874284 | 874284 | 2020-12-28 | Bedford | Tennessee | 47003 | 4430 | 59 |
874285 | 874285 | 2020-12-28 | Benton | Tennessee | 47005 | 1150 | 30 |
874286 | 874286 | 2020-12-28 | Bledsoe | Tennessee | 47007 | 1538 | 9 |
874287 | 874287 | 2020-12-28 | Blount | Tennessee | 47009 | 9449 | 94 |
874288 | 874288 | 2020-12-28 | Bradley | Tennessee | 47011 | 8754 | 65 |
874289 | 874289 | 2020-12-28 | Campbell | Tennessee | 47013 | 2620 | 35 |
874290 | 874290 | 2020-12-28 | Cannon | Tennessee | 47015 | 1328 | 11 |
874291 | 874291 | 2020-12-28 | Carroll | Tennessee | 47017 | 2622 | 50 |
874292 | 874292 | 2020-12-28 | Carter | Tennessee | 47019 | 4307 | 82 |
874293 | 874293 | 2020-12-28 | Cheatham | Tennessee | 47021 | 2755 | 23 |
874294 | 874294 | 2020-12-28 | Chester | Tennessee | 47023 | 1447 | 28 |
874295 | 874295 | 2020-12-28 | Claiborne | Tennessee | 47025 | 1611 | 18 |
874296 | 874296 | 2020-12-28 | Clay | Tennessee | 47027 | 825 | 23 |
874297 | 874297 | 2020-12-28 | Cocke | Tennessee | 47029 | 2739 | 39 |
874298 | 874298 | 2020-12-28 | Coffee | Tennessee | 47031 | 4769 | 66 |
874299 | 874299 | 2020-12-28 | Crockett | Tennessee | 47033 | 1585 | 29 |
874300 | 874300 | 2020-12-28 | Cumberland | Tennessee | 47035 | 4225 | 51 |
874301 | 874301 | 2020-12-28 | Davidson | Tennessee | 47037 | 66724 | 549 |
874302 | 874302 | 2020-12-28 | DeKalb | Tennessee | 47041 | 2024 | 31 |
874303 | 874303 | 2020-12-28 | Decatur | Tennessee | 47039 | 1314 | 18 |
874304 | 874304 | 2020-12-28 | Dickson | Tennessee | 47043 | 4505 | 58 |
874305 | 874305 | 2020-12-28 | Dyer | Tennessee | 47045 | 4138 | 68 |
874306 | 874306 | 2020-12-28 | Fayette | Tennessee | 47047 | 3238 | 47 |
874307 | 874307 | 2020-12-28 | Fentress | Tennessee | 47049 | 1836 | 27 |
874308 | 874308 | 2020-12-28 | Franklin | Tennessee | 47051 | 3423 | 46 |
874309 | 874309 | 2020-12-28 | Gibson | Tennessee | 47053 | 4871 | 87 |
874310 | 874310 | 2020-12-28 | Giles | Tennessee | 47055 | 2554 | 60 |
874311 | 874311 | 2020-12-28 | Grainger | Tennessee | 47057 | 1735 | 24 |
874312 | 874312 | 2020-12-28 | Greene | Tennessee | 47059 | 5371 | 90 |
874313 | 874313 | 2020-12-28 | Grundy | Tennessee | 47061 | 1162 | 16 |
874314 | 874314 | 2020-12-28 | Hamblen | Tennessee | 47063 | 5662 | 79 |
874315 | 874315 | 2020-12-28 | Hamilton | Tennessee | 47065 | 27793 | 261 |
874316 | 874316 | 2020-12-28 | Hancock | Tennessee | 47067 | 319 | 4 |
874317 | 874317 | 2020-12-28 | Hardeman | Tennessee | 47069 | 2793 | 41 |
874318 | 874318 | 2020-12-28 | Hardin | Tennessee | 47071 | 2535 | 34 |
874319 | 874319 | 2020-12-28 | Hawkins | Tennessee | 47073 | 3495 | 54 |
874320 | 874320 | 2020-12-28 | Haywood | Tennessee | 47075 | 2131 | 36 |
874321 | 874321 | 2020-12-28 | Henderson | Tennessee | 47077 | 2858 | 41 |
874322 | 874322 | 2020-12-28 | Henry | Tennessee | 47079 | 2269 | 34 |
874323 | 874323 | 2020-12-28 | Hickman | Tennessee | 47081 | 1851 | 26 |
874324 | 874324 | 2020-12-28 | Houston | Tennessee | 47083 | 785 | 22 |
874325 | 874325 | 2020-12-28 | Humphreys | Tennessee | 47085 | 1138 | 12 |
874326 | 874326 | 2020-12-28 | Jackson | Tennessee | 47087 | 932 | 19 |
874327 | 874327 | 2020-12-28 | Jefferson | Tennessee | 47089 | 3736 | 57 |
874328 | 874328 | 2020-12-28 | Johnson | Tennessee | 47091 | 1758 | 28 |
874329 | 874329 | 2020-12-28 | Knox | Tennessee | 47093 | 32465 | 306 |
874330 | 874330 | 2020-12-28 | Lake | Tennessee | 47095 | 1386 | 12 |
874331 | 874331 | 2020-12-28 | Lauderdale | Tennessee | 47097 | 2565 | 28 |
874332 | 874332 | 2020-12-28 | Lawrence | Tennessee | 47099 | 4294 | 57 |
874333 | 874333 | 2020-12-28 | Lewis | Tennessee | 47101 | 1132 | 19 |
874334 | 874334 | 2020-12-28 | Lincoln | Tennessee | 47103 | 3160 | 31 |
874335 | 874335 | 2020-12-28 | Loudon | Tennessee | 47105 | 4046 | 35 |
874336 | 874336 | 2020-12-28 | Macon | Tennessee | 47111 | 2492 | 41 |
874337 | 874337 | 2020-12-28 | Madison | Tennessee | 47113 | 7779 | 151 |
874338 | 874338 | 2020-12-28 | Marion | Tennessee | 47115 | 1791 | 25 |
874339 | 874339 | 2020-12-28 | Marshall | Tennessee | 47117 | 2753 | 28 |
874340 | 874340 | 2020-12-28 | Maury | Tennessee | 47119 | 9023 | 102 |
874341 | 874341 | 2020-12-28 | McMinn | Tennessee | 47107 | 4241 | 61 |
874342 | 874342 | 2020-12-28 | McNairy | Tennessee | 47109 | 1985 | 37 |
874343 | 874343 | 2020-12-28 | Meigs | Tennessee | 47121 | 934 | 15 |
874344 | 874344 | 2020-12-28 | Monroe | Tennessee | 47123 | 3723 | 53 |
874345 | 874345 | 2020-12-28 | Montgomery | Tennessee | 47125 | 11076 | 121 |
874346 | 874346 | 2020-12-28 | Moore | Tennessee | 47127 | 670 | 6 |
874347 | 874347 | 2020-12-28 | Morgan | Tennessee | 47129 | 1469 | 11 |
874348 | 874348 | 2020-12-28 | Obion | Tennessee | 47131 | 3535 | 68 |
874349 | 874349 | 2020-12-28 | Overton | Tennessee | 47133 | 2105 | 41 |
874350 | 874350 | 2020-12-28 | Perry | Tennessee | 47135 | 838 | 23 |
874351 | 874351 | 2020-12-28 | Pickett | Tennessee | 47137 | 542 | 17 |
874352 | 874352 | 2020-12-28 | Polk | Tennessee | 47139 | 1114 | 16 |
874353 | 874353 | 2020-12-28 | Putnam | Tennessee | 47141 | 8481 | 118 |
874354 | 874354 | 2020-12-28 | Rhea | Tennessee | 47143 | 3067 | 46 |
874355 | 874355 | 2020-12-28 | Roane | Tennessee | 47145 | 4170 | 49 |
874356 | 874356 | 2020-12-28 | Robertson | Tennessee | 47147 | 6316 | 73 |
874357 | 874357 | 2020-12-28 | Rutherford | Tennessee | 47149 | 27679 | 235 |
874358 | 874358 | 2020-12-28 | Scott | Tennessee | 47151 | 1924 | 20 |
874359 | 874359 | 2020-12-28 | Sequatchie | Tennessee | 47153 | 1123 | 10 |
874360 | 874360 | 2020-12-28 | Sevier | Tennessee | 47155 | 8667 | 64 |
874361 | 874361 | 2020-12-28 | Shelby | Tennessee | 47157 | 66084 | 861 |
874362 | 874362 | 2020-12-28 | Smith | Tennessee | 47159 | 2012 | 23 |
874363 | 874363 | 2020-12-28 | Stewart | Tennessee | 47161 | 852 | 20 |
874364 | 874364 | 2020-12-28 | Sullivan | Tennessee | 47163 | 10443 | 172 |
874365 | 874365 | 2020-12-28 | Sumner | Tennessee | 47165 | 15219 | 199 |
874366 | 874366 | 2020-12-28 | Tipton | Tennessee | 47167 | 5274 | 52 |
874367 | 874367 | 2020-12-28 | Trousdale | Tennessee | 47169 | 2136 | 12 |
874368 | 874368 | 2020-12-28 | Unicoi | Tennessee | 47171 | 1403 | 39 |
874369 | 874369 | 2020-12-28 | Union | Tennessee | 47173 | 1189 | 14 |
874370 | 874370 | 2020-12-28 | Unknown | Tennessee | 5048 | 41 | |
874371 | 874371 | 2020-12-28 | Van Buren | Tennessee | 47175 | 536 | 6 |
874372 | 874372 | 2020-12-28 | Warren | Tennessee | 47177 | 4295 | 34 |
874373 | 874373 | 2020-12-28 | Washington | Tennessee | 47179 | 9908 | 157 |
874374 | 874374 | 2020-12-28 | Wayne | Tennessee | 47181 | 2367 | 16 |
874375 | 874375 | 2020-12-28 | Weakley | Tennessee | 47183 | 3003 | 42 |
874376 | 874376 | 2020-12-28 | White | Tennessee | 47185 | 2670 | 37 |
874377 | 874377 | 2020-12-28 | Williamson | Tennessee | 47187 | 17207 | 119 |
874378 | 874378 | 2020-12-28 | Wilson | Tennessee | 47189 | 12038 | 122 |
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);