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-10-10 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
617947 | 617947 | 2020-10-10 | Anderson | Tennessee | 47001 | 1371 | 13 |
617948 | 617948 | 2020-10-10 | Bedford | Tennessee | 47003 | 1466 | 19 |
617949 | 617949 | 2020-10-10 | Benton | Tennessee | 47005 | 356 | 9 |
617950 | 617950 | 2020-10-10 | Bledsoe | Tennessee | 47007 | 893 | 4 |
617951 | 617951 | 2020-10-10 | Blount | Tennessee | 47009 | 2834 | 30 |
617952 | 617952 | 2020-10-10 | Bradley | Tennessee | 47011 | 3199 | 20 |
617953 | 617953 | 2020-10-10 | Campbell | Tennessee | 47013 | 654 | 4 |
617954 | 617954 | 2020-10-10 | Cannon | Tennessee | 47015 | 348 | 2 |
617955 | 617955 | 2020-10-10 | Carroll | Tennessee | 47017 | 1030 | 24 |
617956 | 617956 | 2020-10-10 | Carter | Tennessee | 47019 | 1297 | 31 |
617957 | 617957 | 2020-10-10 | Cheatham | Tennessee | 47021 | 886 | 10 |
617958 | 617958 | 2020-10-10 | Chester | Tennessee | 47023 | 679 | 13 |
617959 | 617959 | 2020-10-10 | Claiborne | Tennessee | 47025 | 471 | 5 |
617960 | 617960 | 2020-10-10 | Clay | Tennessee | 47027 | 305 | 6 |
617961 | 617961 | 2020-10-10 | Cocke | Tennessee | 47029 | 848 | 11 |
617962 | 617962 | 2020-10-10 | Coffee | Tennessee | 47031 | 1538 | 17 |
617963 | 617963 | 2020-10-10 | Crockett | Tennessee | 47033 | 643 | 19 |
617964 | 617964 | 2020-10-10 | Cumberland | Tennessee | 47035 | 1384 | 23 |
617965 | 617965 | 2020-10-10 | Davidson | Tennessee | 47037 | 30196 | 321 |
617966 | 617966 | 2020-10-10 | DeKalb | Tennessee | 47041 | 619 | 17 |
617967 | 617967 | 2020-10-10 | Decatur | Tennessee | 47039 | 584 | 11 |
617968 | 617968 | 2020-10-10 | Dickson | Tennessee | 47043 | 1415 | 17 |
617969 | 617969 | 2020-10-10 | Dyer | Tennessee | 47045 | 1700 | 21 |
617970 | 617970 | 2020-10-10 | Fayette | Tennessee | 47047 | 1362 | 23 |
617971 | 617971 | 2020-10-10 | Fentress | Tennessee | 47049 | 750 | 5 |
617972 | 617972 | 2020-10-10 | Franklin | Tennessee | 47051 | 1109 | 12 |
617973 | 617973 | 2020-10-10 | Gibson | Tennessee | 47053 | 1923 | 28 |
617974 | 617974 | 2020-10-10 | Giles | Tennessee | 47055 | 788 | 26 |
617975 | 617975 | 2020-10-10 | Grainger | Tennessee | 47057 | 463 | 4 |
617976 | 617976 | 2020-10-10 | Greene | Tennessee | 47059 | 1308 | 48 |
617977 | 617977 | 2020-10-10 | Grundy | Tennessee | 47061 | 428 | 8 |
617978 | 617978 | 2020-10-10 | Hamblen | Tennessee | 47063 | 2167 | 40 |
617979 | 617979 | 2020-10-10 | Hamilton | Tennessee | 47065 | 10603 | 101 |
617980 | 617980 | 2020-10-10 | Hancock | Tennessee | 47067 | 110 | 3 |
617981 | 617981 | 2020-10-10 | Hardeman | Tennessee | 47069 | 1676 | 30 |
617982 | 617982 | 2020-10-10 | Hardin | Tennessee | 47071 | 1167 | 18 |
617983 | 617983 | 2020-10-10 | Hawkins | Tennessee | 47073 | 955 | 22 |
617984 | 617984 | 2020-10-10 | Haywood | Tennessee | 47075 | 1132 | 25 |
617985 | 617985 | 2020-10-10 | Henderson | Tennessee | 47077 | 1290 | 24 |
617986 | 617986 | 2020-10-10 | Henry | Tennessee | 47079 | 692 | 10 |
617987 | 617987 | 2020-10-10 | Hickman | Tennessee | 47081 | 686 | 13 |
617988 | 617988 | 2020-10-10 | Houston | Tennessee | 47083 | 349 | 13 |
617989 | 617989 | 2020-10-10 | Humphreys | Tennessee | 47085 | 337 | 4 |
617990 | 617990 | 2020-10-10 | Jackson | Tennessee | 47087 | 382 | 5 |
617991 | 617991 | 2020-10-10 | Jefferson | Tennessee | 47089 | 1324 | 17 |
617992 | 617992 | 2020-10-10 | Johnson | Tennessee | 47091 | 1030 | 4 |
617993 | 617993 | 2020-10-10 | Knox | Tennessee | 47093 | 11272 | 86 |
617994 | 617994 | 2020-10-10 | Lake | Tennessee | 47095 | 941 | 3 |
617995 | 617995 | 2020-10-10 | Lauderdale | Tennessee | 47097 | 1135 | 16 |
617996 | 617996 | 2020-10-10 | Lawrence | Tennessee | 47099 | 1244 | 17 |
617997 | 617997 | 2020-10-10 | Lewis | Tennessee | 47101 | 274 | 1 |
617998 | 617998 | 2020-10-10 | Lincoln | Tennessee | 47103 | 716 | 2 |
617999 | 617999 | 2020-10-10 | Loudon | Tennessee | 47105 | 1396 | 9 |
618000 | 618000 | 2020-10-10 | Macon | Tennessee | 47111 | 1168 | 22 |
618001 | 618001 | 2020-10-10 | Madison | Tennessee | 47113 | 3339 | 76 |
618002 | 618002 | 2020-10-10 | Marion | Tennessee | 47115 | 617 | 9 |
618003 | 618003 | 2020-10-10 | Marshall | Tennessee | 47117 | 900 | 5 |
618004 | 618004 | 2020-10-10 | Maury | Tennessee | 47119 | 2723 | 33 |
618005 | 618005 | 2020-10-10 | McMinn | Tennessee | 47107 | 1316 | 30 |
618006 | 618006 | 2020-10-10 | McNairy | Tennessee | 47109 | 1016 | 23 |
618007 | 618007 | 2020-10-10 | Meigs | Tennessee | 47121 | 254 | 4 |
618008 | 618008 | 2020-10-10 | Monroe | Tennessee | 47123 | 1179 | 21 |
618009 | 618009 | 2020-10-10 | Montgomery | Tennessee | 47125 | 3468 | 48 |
618010 | 618010 | 2020-10-10 | Moore | Tennessee | 47127 | 216 | 1 |
618011 | 618011 | 2020-10-10 | Morgan | Tennessee | 47129 | 360 | 4 |
618012 | 618012 | 2020-10-10 | Obion | Tennessee | 47131 | 1470 | 16 |
618013 | 618013 | 2020-10-10 | Overton | Tennessee | 47133 | 957 | 8 |
618014 | 618014 | 2020-10-10 | Perry | Tennessee | 47135 | 166 | 1 |
618015 | 618015 | 2020-10-10 | Pickett | Tennessee | 47137 | 201 | 3 |
618016 | 618016 | 2020-10-10 | Polk | Tennessee | 47139 | 442 | 13 |
618017 | 618017 | 2020-10-10 | Putnam | Tennessee | 47141 | 3725 | 50 |
618018 | 618018 | 2020-10-10 | Rhea | Tennessee | 47143 | 966 | 16 |
618019 | 618019 | 2020-10-10 | Roane | Tennessee | 47145 | 1036 | 6 |
618020 | 618020 | 2020-10-10 | Robertson | Tennessee | 47147 | 2352 | 39 |
618021 | 618021 | 2020-10-10 | Rutherford | Tennessee | 47149 | 10242 | 103 |
618022 | 618022 | 2020-10-10 | Scott | Tennessee | 47151 | 271 | 3 |
618023 | 618023 | 2020-10-10 | Sequatchie | Tennessee | 47153 | 265 | 1 |
618024 | 618024 | 2020-10-10 | Sevier | Tennessee | 47155 | 2886 | 19 |
618025 | 618025 | 2020-10-10 | Shelby | Tennessee | 47157 | 32916 | 533 |
618026 | 618026 | 2020-10-10 | Smith | Tennessee | 47159 | 844 | 12 |
618027 | 618027 | 2020-10-10 | Stewart | Tennessee | 47161 | 268 | 5 |
618028 | 618028 | 2020-10-10 | Sullivan | Tennessee | 47163 | 2623 | 36 |
618029 | 618029 | 2020-10-10 | Sumner | Tennessee | 47165 | 5222 | 105 |
618030 | 618030 | 2020-10-10 | Tipton | Tennessee | 47167 | 2014 | 22 |
618031 | 618031 | 2020-10-10 | Trousdale | Tennessee | 47169 | 1709 | 7 |
618032 | 618032 | 2020-10-10 | Unicoi | Tennessee | 47171 | 302 | 1 |
618033 | 618033 | 2020-10-10 | Union | Tennessee | 47173 | 448 | 2 |
618034 | 618034 | 2020-10-10 | Unknown | Tennessee | 153 | 1 | |
618035 | 618035 | 2020-10-10 | Van Buren | Tennessee | 47175 | 178 | 1 |
618036 | 618036 | 2020-10-10 | Warren | Tennessee | 47177 | 1185 | 9 |
618037 | 618037 | 2020-10-10 | Washington | Tennessee | 47179 | 2672 | 40 |
618038 | 618038 | 2020-10-10 | Wayne | Tennessee | 47181 | 1541 | 6 |
618039 | 618039 | 2020-10-10 | Weakley | Tennessee | 47183 | 1340 | 23 |
618040 | 618040 | 2020-10-10 | White | Tennessee | 47185 | 978 | 10 |
618041 | 618041 | 2020-10-10 | Williamson | Tennessee | 47187 | 5969 | 46 |
618042 | 618042 | 2020-10-10 | Wilson | Tennessee | 47189 | 3971 | 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);