ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-12-20" 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 |
---|---|---|---|---|---|---|---|
848323 | 848323 | 2020-12-20 | Anderson | Tennessee | 47001 | 4926 | 48 |
848324 | 848324 | 2020-12-20 | Bedford | Tennessee | 47003 | 4107 | 54 |
848325 | 848325 | 2020-12-20 | Benton | Tennessee | 47005 | 1104 | 26 |
848326 | 848326 | 2020-12-20 | Bledsoe | Tennessee | 47007 | 1454 | 7 |
848327 | 848327 | 2020-12-20 | Blount | Tennessee | 47009 | 8538 | 86 |
848328 | 848328 | 2020-12-20 | Bradley | Tennessee | 47011 | 8060 | 60 |
848329 | 848329 | 2020-12-20 | Campbell | Tennessee | 47013 | 2303 | 32 |
848330 | 848330 | 2020-12-20 | Cannon | Tennessee | 47015 | 1227 | 8 |
848331 | 848331 | 2020-12-20 | Carroll | Tennessee | 47017 | 2439 | 46 |
848332 | 848332 | 2020-12-20 | Carter | Tennessee | 47019 | 3965 | 76 |
848333 | 848333 | 2020-12-20 | Cheatham | Tennessee | 47021 | 2474 | 19 |
848334 | 848334 | 2020-12-20 | Chester | Tennessee | 47023 | 1329 | 26 |
848335 | 848335 | 2020-12-20 | Claiborne | Tennessee | 47025 | 1433 | 12 |
848336 | 848336 | 2020-12-20 | Clay | Tennessee | 47027 | 776 | 21 |
848337 | 848337 | 2020-12-20 | Cocke | Tennessee | 47029 | 2433 | 37 |
848338 | 848338 | 2020-12-20 | Coffee | Tennessee | 47031 | 4381 | 56 |
848339 | 848339 | 2020-12-20 | Crockett | Tennessee | 47033 | 1492 | 29 |
848340 | 848340 | 2020-12-20 | Cumberland | Tennessee | 47035 | 3823 | 48 |
848341 | 848341 | 2020-12-20 | Davidson | Tennessee | 47037 | 61556 | 503 |
848342 | 848342 | 2020-12-20 | DeKalb | Tennessee | 47041 | 1848 | 27 |
848343 | 848343 | 2020-12-20 | Decatur | Tennessee | 47039 | 1236 | 17 |
848344 | 848344 | 2020-12-20 | Dickson | Tennessee | 47043 | 4123 | 51 |
848345 | 848345 | 2020-12-20 | Dyer | Tennessee | 47045 | 3934 | 65 |
848346 | 848346 | 2020-12-20 | Fayette | Tennessee | 47047 | 2987 | 44 |
848347 | 848347 | 2020-12-20 | Fentress | Tennessee | 47049 | 1703 | 27 |
848348 | 848348 | 2020-12-20 | Franklin | Tennessee | 47051 | 3107 | 44 |
848349 | 848349 | 2020-12-20 | Gibson | Tennessee | 47053 | 4457 | 81 |
848350 | 848350 | 2020-12-20 | Giles | Tennessee | 47055 | 2240 | 56 |
848351 | 848351 | 2020-12-20 | Grainger | Tennessee | 47057 | 1584 | 22 |
848352 | 848352 | 2020-12-20 | Greene | Tennessee | 47059 | 4866 | 82 |
848353 | 848353 | 2020-12-20 | Grundy | Tennessee | 47061 | 1068 | 15 |
848354 | 848354 | 2020-12-20 | Hamblen | Tennessee | 47063 | 5155 | 71 |
848355 | 848355 | 2020-12-20 | Hamilton | Tennessee | 47065 | 25281 | 235 |
848356 | 848356 | 2020-12-20 | Hancock | Tennessee | 47067 | 289 | 4 |
848357 | 848357 | 2020-12-20 | Hardeman | Tennessee | 47069 | 2674 | 40 |
848358 | 848358 | 2020-12-20 | Hardin | Tennessee | 47071 | 2370 | 33 |
848359 | 848359 | 2020-12-20 | Hawkins | Tennessee | 47073 | 3172 | 48 |
848360 | 848360 | 2020-12-20 | Haywood | Tennessee | 47075 | 2031 | 34 |
848361 | 848361 | 2020-12-20 | Henderson | Tennessee | 47077 | 2608 | 40 |
848362 | 848362 | 2020-12-20 | Henry | Tennessee | 47079 | 2139 | 32 |
848363 | 848363 | 2020-12-20 | Hickman | Tennessee | 47081 | 1692 | 25 |
848364 | 848364 | 2020-12-20 | Houston | Tennessee | 47083 | 738 | 21 |
848365 | 848365 | 2020-12-20 | Humphreys | Tennessee | 47085 | 1044 | 11 |
848366 | 848366 | 2020-12-20 | Jackson | Tennessee | 47087 | 883 | 18 |
848367 | 848367 | 2020-12-20 | Jefferson | Tennessee | 47089 | 3343 | 54 |
848368 | 848368 | 2020-12-20 | Johnson | Tennessee | 47091 | 1698 | 27 |
848369 | 848369 | 2020-12-20 | Knox | Tennessee | 47093 | 28878 | 263 |
848370 | 848370 | 2020-12-20 | Lake | Tennessee | 47095 | 1345 | 12 |
848371 | 848371 | 2020-12-20 | Lauderdale | Tennessee | 47097 | 2467 | 27 |
848372 | 848372 | 2020-12-20 | Lawrence | Tennessee | 47099 | 3960 | 52 |
848373 | 848373 | 2020-12-20 | Lewis | Tennessee | 47101 | 1071 | 19 |
848374 | 848374 | 2020-12-20 | Lincoln | Tennessee | 47103 | 2879 | 27 |
848375 | 848375 | 2020-12-20 | Loudon | Tennessee | 47105 | 3571 | 29 |
848376 | 848376 | 2020-12-20 | Macon | Tennessee | 47111 | 2375 | 36 |
848377 | 848377 | 2020-12-20 | Madison | Tennessee | 47113 | 7204 | 141 |
848378 | 848378 | 2020-12-20 | Marion | Tennessee | 47115 | 1665 | 22 |
848379 | 848379 | 2020-12-20 | Marshall | Tennessee | 47117 | 2510 | 28 |
848380 | 848380 | 2020-12-20 | Maury | Tennessee | 47119 | 8300 | 95 |
848381 | 848381 | 2020-12-20 | McMinn | Tennessee | 47107 | 3899 | 60 |
848382 | 848382 | 2020-12-20 | McNairy | Tennessee | 47109 | 1802 | 35 |
848383 | 848383 | 2020-12-20 | Meigs | Tennessee | 47121 | 840 | 14 |
848384 | 848384 | 2020-12-20 | Monroe | Tennessee | 47123 | 3328 | 51 |
848385 | 848385 | 2020-12-20 | Montgomery | Tennessee | 47125 | 10065 | 106 |
848386 | 848386 | 2020-12-20 | Moore | Tennessee | 47127 | 604 | 4 |
848387 | 848387 | 2020-12-20 | Morgan | Tennessee | 47129 | 1306 | 11 |
848388 | 848388 | 2020-12-20 | Obion | Tennessee | 47131 | 3372 | 67 |
848389 | 848389 | 2020-12-20 | Overton | Tennessee | 47133 | 1952 | 39 |
848390 | 848390 | 2020-12-20 | Perry | Tennessee | 47135 | 763 | 23 |
848391 | 848391 | 2020-12-20 | Pickett | Tennessee | 47137 | 501 | 17 |
848392 | 848392 | 2020-12-20 | Polk | Tennessee | 47139 | 1022 | 15 |
848393 | 848393 | 2020-12-20 | Putnam | Tennessee | 47141 | 7856 | 108 |
848394 | 848394 | 2020-12-20 | Rhea | Tennessee | 47143 | 2763 | 44 |
848395 | 848395 | 2020-12-20 | Roane | Tennessee | 47145 | 3757 | 44 |
848396 | 848396 | 2020-12-20 | Robertson | Tennessee | 47147 | 5706 | 69 |
848397 | 848397 | 2020-12-20 | Rutherford | Tennessee | 47149 | 25529 | 214 |
848398 | 848398 | 2020-12-20 | Scott | Tennessee | 47151 | 1772 | 16 |
848399 | 848399 | 2020-12-20 | Sequatchie | Tennessee | 47153 | 1004 | 7 |
848400 | 848400 | 2020-12-20 | Sevier | Tennessee | 47155 | 7742 | 58 |
848401 | 848401 | 2020-12-20 | Shelby | Tennessee | 47157 | 61429 | 818 |
848402 | 848402 | 2020-12-20 | Smith | Tennessee | 47159 | 1896 | 23 |
848403 | 848403 | 2020-12-20 | Stewart | Tennessee | 47161 | 791 | 19 |
848404 | 848404 | 2020-12-20 | Sullivan | Tennessee | 47163 | 9680 | 161 |
848405 | 848405 | 2020-12-20 | Sumner | Tennessee | 47165 | 14081 | 182 |
848406 | 848406 | 2020-12-20 | Tipton | Tennessee | 47167 | 4870 | 49 |
848407 | 848407 | 2020-12-20 | Trousdale | Tennessee | 47169 | 2084 | 12 |
848408 | 848408 | 2020-12-20 | Unicoi | Tennessee | 47171 | 1283 | 36 |
848409 | 848409 | 2020-12-20 | Union | Tennessee | 47173 | 1102 | 7 |
848410 | 848410 | 2020-12-20 | Unknown | Tennessee | 3052 | 38 | |
848411 | 848411 | 2020-12-20 | Van Buren | Tennessee | 47175 | 515 | 5 |
848412 | 848412 | 2020-12-20 | Warren | Tennessee | 47177 | 3924 | 29 |
848413 | 848413 | 2020-12-20 | Washington | Tennessee | 47179 | 9134 | 144 |
848414 | 848414 | 2020-12-20 | Wayne | Tennessee | 47181 | 2255 | 16 |
848415 | 848415 | 2020-12-20 | Weakley | Tennessee | 47183 | 2817 | 40 |
848416 | 848416 | 2020-12-20 | White | Tennessee | 47185 | 2508 | 36 |
848417 | 848417 | 2020-12-20 | Williamson | Tennessee | 47187 | 15572 | 109 |
848418 | 848418 | 2020-12-20 | Wilson | Tennessee | 47189 | 10989 | 112 |
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);