ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-12-24" 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 |
---|---|---|---|---|---|---|---|
861303 | 861303 | 2020-12-24 | Anderson | Tennessee | 47001 | 5218 | 55 |
861304 | 861304 | 2020-12-24 | Bedford | Tennessee | 47003 | 4292 | 57 |
861305 | 861305 | 2020-12-24 | Benton | Tennessee | 47005 | 1123 | 28 |
861306 | 861306 | 2020-12-24 | Bledsoe | Tennessee | 47007 | 1493 | 9 |
861307 | 861307 | 2020-12-24 | Blount | Tennessee | 47009 | 9059 | 93 |
861308 | 861308 | 2020-12-24 | Bradley | Tennessee | 47011 | 8471 | 64 |
861309 | 861309 | 2020-12-24 | Campbell | Tennessee | 47013 | 2503 | 34 |
861310 | 861310 | 2020-12-24 | Cannon | Tennessee | 47015 | 1283 | 10 |
861311 | 861311 | 2020-12-24 | Carroll | Tennessee | 47017 | 2539 | 47 |
861312 | 861312 | 2020-12-24 | Carter | Tennessee | 47019 | 4160 | 79 |
861313 | 861313 | 2020-12-24 | Cheatham | Tennessee | 47021 | 2642 | 22 |
861314 | 861314 | 2020-12-24 | Chester | Tennessee | 47023 | 1398 | 28 |
861315 | 861315 | 2020-12-24 | Claiborne | Tennessee | 47025 | 1516 | 18 |
861316 | 861316 | 2020-12-24 | Clay | Tennessee | 47027 | 808 | 23 |
861317 | 861317 | 2020-12-24 | Cocke | Tennessee | 47029 | 2596 | 39 |
861318 | 861318 | 2020-12-24 | Coffee | Tennessee | 47031 | 4612 | 64 |
861319 | 861319 | 2020-12-24 | Crockett | Tennessee | 47033 | 1544 | 30 |
861320 | 861320 | 2020-12-24 | Cumberland | Tennessee | 47035 | 4024 | 48 |
861321 | 861321 | 2020-12-24 | Davidson | Tennessee | 47037 | 64835 | 537 |
861322 | 861322 | 2020-12-24 | DeKalb | Tennessee | 47041 | 1937 | 30 |
861323 | 861323 | 2020-12-24 | Decatur | Tennessee | 47039 | 1280 | 17 |
861324 | 861324 | 2020-12-24 | Dickson | Tennessee | 47043 | 4385 | 57 |
861325 | 861325 | 2020-12-24 | Dyer | Tennessee | 47045 | 4047 | 67 |
861326 | 861326 | 2020-12-24 | Fayette | Tennessee | 47047 | 3094 | 45 |
861327 | 861327 | 2020-12-24 | Fentress | Tennessee | 47049 | 1766 | 27 |
861328 | 861328 | 2020-12-24 | Franklin | Tennessee | 47051 | 3265 | 46 |
861329 | 861329 | 2020-12-24 | Gibson | Tennessee | 47053 | 4699 | 87 |
861330 | 861330 | 2020-12-24 | Giles | Tennessee | 47055 | 2423 | 60 |
861331 | 861331 | 2020-12-24 | Grainger | Tennessee | 47057 | 1648 | 23 |
861332 | 861332 | 2020-12-24 | Greene | Tennessee | 47059 | 5129 | 88 |
861333 | 861333 | 2020-12-24 | Grundy | Tennessee | 47061 | 1122 | 15 |
861334 | 861334 | 2020-12-24 | Hamblen | Tennessee | 47063 | 5397 | 77 |
861335 | 861335 | 2020-12-24 | Hamilton | Tennessee | 47065 | 26718 | 252 |
861336 | 861336 | 2020-12-24 | Hancock | Tennessee | 47067 | 300 | 4 |
861337 | 861337 | 2020-12-24 | Hardeman | Tennessee | 47069 | 2742 | 41 |
861338 | 861338 | 2020-12-24 | Hardin | Tennessee | 47071 | 2456 | 34 |
861339 | 861339 | 2020-12-24 | Hawkins | Tennessee | 47073 | 3337 | 52 |
861340 | 861340 | 2020-12-24 | Haywood | Tennessee | 47075 | 2093 | 35 |
861341 | 861341 | 2020-12-24 | Henderson | Tennessee | 47077 | 2749 | 41 |
861342 | 861342 | 2020-12-24 | Henry | Tennessee | 47079 | 2209 | 34 |
861343 | 861343 | 2020-12-24 | Hickman | Tennessee | 47081 | 1774 | 26 |
861344 | 861344 | 2020-12-24 | Houston | Tennessee | 47083 | 765 | 21 |
861345 | 861345 | 2020-12-24 | Humphreys | Tennessee | 47085 | 1106 | 12 |
861346 | 861346 | 2020-12-24 | Jackson | Tennessee | 47087 | 912 | 18 |
861347 | 861347 | 2020-12-24 | Jefferson | Tennessee | 47089 | 3562 | 56 |
861348 | 861348 | 2020-12-24 | Johnson | Tennessee | 47091 | 1729 | 28 |
861349 | 861349 | 2020-12-24 | Knox | Tennessee | 47093 | 30904 | 287 |
861350 | 861350 | 2020-12-24 | Lake | Tennessee | 47095 | 1367 | 12 |
861351 | 861351 | 2020-12-24 | Lauderdale | Tennessee | 47097 | 2523 | 28 |
861352 | 861352 | 2020-12-24 | Lawrence | Tennessee | 47099 | 4149 | 55 |
861353 | 861353 | 2020-12-24 | Lewis | Tennessee | 47101 | 1097 | 19 |
861354 | 861354 | 2020-12-24 | Lincoln | Tennessee | 47103 | 3028 | 31 |
861355 | 861355 | 2020-12-24 | Loudon | Tennessee | 47105 | 3849 | 30 |
861356 | 861356 | 2020-12-24 | Macon | Tennessee | 47111 | 2455 | 41 |
861357 | 861357 | 2020-12-24 | Madison | Tennessee | 47113 | 7521 | 150 |
861358 | 861358 | 2020-12-24 | Marion | Tennessee | 47115 | 1727 | 25 |
861359 | 861359 | 2020-12-24 | Marshall | Tennessee | 47117 | 2648 | 28 |
861360 | 861360 | 2020-12-24 | Maury | Tennessee | 47119 | 8675 | 100 |
861361 | 861361 | 2020-12-24 | McMinn | Tennessee | 47107 | 4095 | 61 |
861362 | 861362 | 2020-12-24 | McNairy | Tennessee | 47109 | 1900 | 37 |
861363 | 861363 | 2020-12-24 | Meigs | Tennessee | 47121 | 889 | 14 |
861364 | 861364 | 2020-12-24 | Monroe | Tennessee | 47123 | 3544 | 52 |
861365 | 861365 | 2020-12-24 | Montgomery | Tennessee | 47125 | 10660 | 116 |
861366 | 861366 | 2020-12-24 | Moore | Tennessee | 47127 | 637 | 6 |
861367 | 861367 | 2020-12-24 | Morgan | Tennessee | 47129 | 1396 | 11 |
861368 | 861368 | 2020-12-24 | Obion | Tennessee | 47131 | 3476 | 67 |
861369 | 861369 | 2020-12-24 | Overton | Tennessee | 47133 | 2026 | 41 |
861370 | 861370 | 2020-12-24 | Perry | Tennessee | 47135 | 808 | 23 |
861371 | 861371 | 2020-12-24 | Pickett | Tennessee | 47137 | 526 | 17 |
861372 | 861372 | 2020-12-24 | Polk | Tennessee | 47139 | 1076 | 15 |
861373 | 861373 | 2020-12-24 | Putnam | Tennessee | 47141 | 8171 | 114 |
861374 | 861374 | 2020-12-24 | Rhea | Tennessee | 47143 | 2920 | 45 |
861375 | 861375 | 2020-12-24 | Roane | Tennessee | 47145 | 3951 | 48 |
861376 | 861376 | 2020-12-24 | Robertson | Tennessee | 47147 | 6068 | 71 |
861377 | 861377 | 2020-12-24 | Rutherford | Tennessee | 47149 | 26681 | 228 |
861378 | 861378 | 2020-12-24 | Scott | Tennessee | 47151 | 1849 | 20 |
861379 | 861379 | 2020-12-24 | Sequatchie | Tennessee | 47153 | 1063 | 10 |
861380 | 861380 | 2020-12-24 | Sevier | Tennessee | 47155 | 8218 | 63 |
861381 | 861381 | 2020-12-24 | Shelby | Tennessee | 47157 | 63394 | 837 |
861382 | 861382 | 2020-12-24 | Smith | Tennessee | 47159 | 1963 | 23 |
861383 | 861383 | 2020-12-24 | Stewart | Tennessee | 47161 | 816 | 19 |
861384 | 861384 | 2020-12-24 | Sullivan | Tennessee | 47163 | 10151 | 167 |
861385 | 861385 | 2020-12-24 | Sumner | Tennessee | 47165 | 14760 | 195 |
861386 | 861386 | 2020-12-24 | Tipton | Tennessee | 47167 | 5085 | 51 |
861387 | 861387 | 2020-12-24 | Trousdale | Tennessee | 47169 | 2113 | 12 |
861388 | 861388 | 2020-12-24 | Unicoi | Tennessee | 47171 | 1346 | 38 |
861389 | 861389 | 2020-12-24 | Union | Tennessee | 47173 | 1150 | 12 |
861390 | 861390 | 2020-12-24 | Unknown | Tennessee | 4887 | 48 | |
861391 | 861391 | 2020-12-24 | Van Buren | Tennessee | 47175 | 519 | 6 |
861392 | 861392 | 2020-12-24 | Warren | Tennessee | 47177 | 4102 | 33 |
861393 | 861393 | 2020-12-24 | Washington | Tennessee | 47179 | 9562 | 153 |
861394 | 861394 | 2020-12-24 | Wayne | Tennessee | 47181 | 2328 | 16 |
861395 | 861395 | 2020-12-24 | Weakley | Tennessee | 47183 | 2907 | 41 |
861396 | 861396 | 2020-12-24 | White | Tennessee | 47185 | 2581 | 37 |
861397 | 861397 | 2020-12-24 | Williamson | Tennessee | 47187 | 16459 | 118 |
861398 | 861398 | 2020-12-24 | Wilson | Tennessee | 47189 | 11595 | 118 |
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);