ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where "date" is on date 2020-08-16 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
439973 | 439973 | 2020-08-16 | Anderson | Tennessee | 47001 | 759 | 6 |
439974 | 439974 | 2020-08-16 | Bedford | Tennessee | 47003 | 984 | 12 |
439975 | 439975 | 2020-08-16 | Benton | Tennessee | 47005 | 183 | 2 |
439976 | 439976 | 2020-08-16 | Bledsoe | Tennessee | 47007 | 749 | 2 |
439977 | 439977 | 2020-08-16 | Blount | Tennessee | 47009 | 1477 | 15 |
439978 | 439978 | 2020-08-16 | Bradley | Tennessee | 47011 | 2166 | 16 |
439979 | 439979 | 2020-08-16 | Campbell | Tennessee | 47013 | 271 | 1 |
439980 | 439980 | 2020-08-16 | Cannon | Tennessee | 47015 | 163 | 0 |
439981 | 439981 | 2020-08-16 | Carroll | Tennessee | 47017 | 394 | 6 |
439982 | 439982 | 2020-08-16 | Carter | Tennessee | 47019 | 634 | 6 |
439983 | 439983 | 2020-08-16 | Cheatham | Tennessee | 47021 | 637 | 9 |
439984 | 439984 | 2020-08-16 | Chester | Tennessee | 47023 | 274 | 2 |
439985 | 439985 | 2020-08-16 | Claiborne | Tennessee | 47025 | 306 | 1 |
439986 | 439986 | 2020-08-16 | Clay | Tennessee | 47027 | 89 | 0 |
439987 | 439987 | 2020-08-16 | Cocke | Tennessee | 47029 | 547 | 5 |
439988 | 439988 | 2020-08-16 | Coffee | Tennessee | 47031 | 608 | 4 |
439989 | 439989 | 2020-08-16 | Crockett | Tennessee | 47033 | 303 | 7 |
439990 | 439990 | 2020-08-16 | Cumberland | Tennessee | 47035 | 567 | 7 |
439991 | 439991 | 2020-08-16 | Davidson | Tennessee | 47037 | 24143 | 227 |
439992 | 439992 | 2020-08-16 | DeKalb | Tennessee | 47041 | 387 | 2 |
439993 | 439993 | 2020-08-16 | Decatur | Tennessee | 47039 | 239 | 3 |
439994 | 439994 | 2020-08-16 | Dickson | Tennessee | 47043 | 777 | 4 |
439995 | 439995 | 2020-08-16 | Dyer | Tennessee | 47045 | 737 | 9 |
439996 | 439996 | 2020-08-16 | Fayette | Tennessee | 47047 | 755 | 8 |
439997 | 439997 | 2020-08-16 | Fentress | Tennessee | 47049 | 122 | 0 |
439998 | 439998 | 2020-08-16 | Franklin | Tennessee | 47051 | 380 | 4 |
439999 | 439999 | 2020-08-16 | Gibson | Tennessee | 47053 | 819 | 9 |
440000 | 440000 | 2020-08-16 | Giles | Tennessee | 47055 | 415 | 13 |
440001 | 440001 | 2020-08-16 | Grainger | Tennessee | 47057 | 219 | 1 |
440002 | 440002 | 2020-08-16 | Greene | Tennessee | 47059 | 605 | 9 |
440003 | 440003 | 2020-08-16 | Grundy | Tennessee | 47061 | 130 | 2 |
440004 | 440004 | 2020-08-16 | Hamblen | Tennessee | 47063 | 1494 | 15 |
440005 | 440005 | 2020-08-16 | Hamilton | Tennessee | 47065 | 6801 | 61 |
440006 | 440006 | 2020-08-16 | Hancock | Tennessee | 47067 | 84 | 2 |
440007 | 440007 | 2020-08-16 | Hardeman | Tennessee | 47069 | 1056 | 18 |
440008 | 440008 | 2020-08-16 | Hardin | Tennessee | 47071 | 510 | 8 |
440009 | 440009 | 2020-08-16 | Hawkins | Tennessee | 47073 | 572 | 10 |
440010 | 440010 | 2020-08-16 | Haywood | Tennessee | 47075 | 608 | 7 |
440011 | 440011 | 2020-08-16 | Henderson | Tennessee | 47077 | 684 | 3 |
440012 | 440012 | 2020-08-16 | Henry | Tennessee | 47079 | 328 | 1 |
440013 | 440013 | 2020-08-16 | Hickman | Tennessee | 47081 | 305 | 1 |
440014 | 440014 | 2020-08-16 | Houston | Tennessee | 47083 | 66 | 0 |
440015 | 440015 | 2020-08-16 | Humphreys | Tennessee | 47085 | 140 | 3 |
440016 | 440016 | 2020-08-16 | Jackson | Tennessee | 47087 | 149 | 1 |
440017 | 440017 | 2020-08-16 | Jefferson | Tennessee | 47089 | 650 | 4 |
440018 | 440018 | 2020-08-16 | Johnson | Tennessee | 47091 | 349 | 0 |
440019 | 440019 | 2020-08-16 | Knox | Tennessee | 47093 | 5509 | 49 |
440020 | 440020 | 2020-08-16 | Lake | Tennessee | 47095 | 801 | 1 |
440021 | 440021 | 2020-08-16 | Lauderdale | Tennessee | 47097 | 565 | 9 |
440022 | 440022 | 2020-08-16 | Lawrence | Tennessee | 47099 | 639 | 7 |
440023 | 440023 | 2020-08-16 | Lewis | Tennessee | 47101 | 88 | 1 |
440024 | 440024 | 2020-08-16 | Lincoln | Tennessee | 47103 | 344 | 1 |
440025 | 440025 | 2020-08-16 | Loudon | Tennessee | 47105 | 809 | 3 |
440026 | 440026 | 2020-08-16 | Macon | Tennessee | 47111 | 864 | 13 |
440027 | 440027 | 2020-08-16 | Madison | Tennessee | 47113 | 1330 | 26 |
440028 | 440028 | 2020-08-16 | Marion | Tennessee | 47115 | 256 | 5 |
440029 | 440029 | 2020-08-16 | Marshall | Tennessee | 47117 | 369 | 4 |
440030 | 440030 | 2020-08-16 | Maury | Tennessee | 47119 | 1433 | 10 |
440031 | 440031 | 2020-08-16 | McMinn | Tennessee | 47107 | 609 | 20 |
440032 | 440032 | 2020-08-16 | McNairy | Tennessee | 47109 | 419 | 6 |
440033 | 440033 | 2020-08-16 | Meigs | Tennessee | 47121 | 121 | 0 |
440034 | 440034 | 2020-08-16 | Monroe | Tennessee | 47123 | 511 | 10 |
440035 | 440035 | 2020-08-16 | Montgomery | Tennessee | 47125 | 2150 | 16 |
440036 | 440036 | 2020-08-16 | Moore | Tennessee | 47127 | 75 | 0 |
440037 | 440037 | 2020-08-16 | Morgan | Tennessee | 47129 | 141 | 1 |
440038 | 440038 | 2020-08-16 | Obion | Tennessee | 47131 | 665 | 4 |
440039 | 440039 | 2020-08-16 | Overton | Tennessee | 47133 | 272 | 1 |
440040 | 440040 | 2020-08-16 | Perry | Tennessee | 47135 | 90 | 0 |
440041 | 440041 | 2020-08-16 | Pickett | Tennessee | 47137 | 38 | 1 |
440042 | 440042 | 2020-08-16 | Polk | Tennessee | 47139 | 268 | 8 |
440043 | 440043 | 2020-08-16 | Putnam | Tennessee | 47141 | 1931 | 20 |
440044 | 440044 | 2020-08-16 | Rhea | Tennessee | 47143 | 581 | 2 |
440045 | 440045 | 2020-08-16 | Roane | Tennessee | 47145 | 533 | 2 |
440046 | 440046 | 2020-08-16 | Robertson | Tennessee | 47147 | 1638 | 21 |
440047 | 440047 | 2020-08-16 | Rutherford | Tennessee | 47149 | 7080 | 59 |
440048 | 440048 | 2020-08-16 | Scott | Tennessee | 47151 | 142 | 2 |
440049 | 440049 | 2020-08-16 | Sequatchie | Tennessee | 47153 | 122 | 1 |
440050 | 440050 | 2020-08-16 | Sevier | Tennessee | 47155 | 2038 | 9 |
440051 | 440051 | 2020-08-16 | Shelby | Tennessee | 47157 | 25046 | 327 |
440052 | 440052 | 2020-08-16 | Smith | Tennessee | 47159 | 479 | 4 |
440053 | 440053 | 2020-08-16 | Stewart | Tennessee | 47161 | 82 | 0 |
440054 | 440054 | 2020-08-16 | Sullivan | Tennessee | 47163 | 1197 | 16 |
440055 | 440055 | 2020-08-16 | Sumner | Tennessee | 47165 | 3636 | 75 |
440056 | 440056 | 2020-08-16 | Tipton | Tennessee | 47167 | 1256 | 12 |
440057 | 440057 | 2020-08-16 | Trousdale | Tennessee | 47169 | 1585 | 6 |
440058 | 440058 | 2020-08-16 | Unicoi | Tennessee | 47171 | 184 | 0 |
440059 | 440059 | 2020-08-16 | Union | Tennessee | 47173 | 177 | 0 |
440060 | 440060 | 2020-08-16 | Unknown | Tennessee | 300 | 0 | |
440061 | 440061 | 2020-08-16 | Van Buren | Tennessee | 47175 | 45 | 0 |
440062 | 440062 | 2020-08-16 | Warren | Tennessee | 47177 | 592 | 6 |
440063 | 440063 | 2020-08-16 | Washington | Tennessee | 47179 | 1455 | 2 |
440064 | 440064 | 2020-08-16 | Wayne | Tennessee | 47181 | 236 | 2 |
440065 | 440065 | 2020-08-16 | Weakley | Tennessee | 47183 | 603 | 5 |
440066 | 440066 | 2020-08-16 | White | Tennessee | 47185 | 336 | 6 |
440067 | 440067 | 2020-08-16 | Williamson | Tennessee | 47187 | 3861 | 26 |
440068 | 440068 | 2020-08-16 | Wilson | Tennessee | 47189 | 2484 | 24 |
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);