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-11-29 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
780169 | 780169 | 2020-11-29 | Anderson | Tennessee | 47001 | 2987 | 29 |
780170 | 780170 | 2020-11-29 | Bedford | Tennessee | 47003 | 2788 | 30 |
780171 | 780171 | 2020-11-29 | Benton | Tennessee | 47005 | 816 | 14 |
780172 | 780172 | 2020-11-29 | Bledsoe | Tennessee | 47007 | 1174 | 5 |
780173 | 780173 | 2020-11-29 | Blount | Tennessee | 47009 | 5531 | 61 |
780174 | 780174 | 2020-11-29 | Bradley | Tennessee | 47011 | 5252 | 34 |
780175 | 780175 | 2020-11-29 | Campbell | Tennessee | 47013 | 1552 | 23 |
780176 | 780176 | 2020-11-29 | Cannon | Tennessee | 47015 | 769 | 3 |
780177 | 780177 | 2020-11-29 | Carroll | Tennessee | 47017 | 1764 | 34 |
780178 | 780178 | 2020-11-29 | Carter | Tennessee | 47019 | 2749 | 55 |
780179 | 780179 | 2020-11-29 | Cheatham | Tennessee | 47021 | 1598 | 17 |
780180 | 780180 | 2020-11-29 | Chester | Tennessee | 47023 | 1028 | 21 |
780181 | 780181 | 2020-11-29 | Claiborne | Tennessee | 47025 | 849 | 9 |
780182 | 780182 | 2020-11-29 | Clay | Tennessee | 47027 | 554 | 18 |
780183 | 780183 | 2020-11-29 | Cocke | Tennessee | 47029 | 1623 | 30 |
780184 | 780184 | 2020-11-29 | Coffee | Tennessee | 47031 | 2848 | 41 |
780185 | 780185 | 2020-11-29 | Crockett | Tennessee | 47033 | 1156 | 26 |
780186 | 780186 | 2020-11-29 | Cumberland | Tennessee | 47035 | 2611 | 36 |
780187 | 780187 | 2020-11-29 | Davidson | Tennessee | 47037 | 44042 | 420 |
780188 | 780188 | 2020-11-29 | DeKalb | Tennessee | 47041 | 1173 | 22 |
780189 | 780189 | 2020-11-29 | Decatur | Tennessee | 47039 | 957 | 12 |
780190 | 780190 | 2020-11-29 | Dickson | Tennessee | 47043 | 2938 | 34 |
780191 | 780191 | 2020-11-29 | Dyer | Tennessee | 47045 | 3220 | 51 |
780192 | 780192 | 2020-11-29 | Fayette | Tennessee | 47047 | 2269 | 38 |
780193 | 780193 | 2020-11-29 | Fentress | Tennessee | 47049 | 1221 | 20 |
780194 | 780194 | 2020-11-29 | Franklin | Tennessee | 47051 | 2119 | 34 |
780195 | 780195 | 2020-11-29 | Gibson | Tennessee | 47053 | 3242 | 65 |
780196 | 780196 | 2020-11-29 | Giles | Tennessee | 47055 | 1475 | 49 |
780197 | 780197 | 2020-11-29 | Grainger | Tennessee | 47057 | 1015 | 18 |
780198 | 780198 | 2020-11-29 | Greene | Tennessee | 47059 | 3116 | 72 |
780199 | 780199 | 2020-11-29 | Grundy | Tennessee | 47061 | 779 | 14 |
780200 | 780200 | 2020-11-29 | Hamblen | Tennessee | 47063 | 3501 | 61 |
780201 | 780201 | 2020-11-29 | Hamilton | Tennessee | 47065 | 17826 | 153 |
780202 | 780202 | 2020-11-29 | Hancock | Tennessee | 47067 | 172 | 3 |
780203 | 780203 | 2020-11-29 | Hardeman | Tennessee | 47069 | 2253 | 37 |
780204 | 780204 | 2020-11-29 | Hardin | Tennessee | 47071 | 1790 | 25 |
780205 | 780205 | 2020-11-29 | Hawkins | Tennessee | 47073 | 1968 | 34 |
780206 | 780206 | 2020-11-29 | Haywood | Tennessee | 47075 | 1633 | 30 |
780207 | 780207 | 2020-11-29 | Henderson | Tennessee | 47077 | 1854 | 34 |
780208 | 780208 | 2020-11-29 | Henry | Tennessee | 47079 | 1543 | 19 |
780209 | 780209 | 2020-11-29 | Hickman | Tennessee | 47081 | 1193 | 19 |
780210 | 780210 | 2020-11-29 | Houston | Tennessee | 47083 | 588 | 20 |
780211 | 780211 | 2020-11-29 | Humphreys | Tennessee | 47085 | 719 | 8 |
780212 | 780212 | 2020-11-29 | Jackson | Tennessee | 47087 | 684 | 10 |
780213 | 780213 | 2020-11-29 | Jefferson | Tennessee | 47089 | 2295 | 33 |
780214 | 780214 | 2020-11-29 | Johnson | Tennessee | 47091 | 1424 | 21 |
780215 | 780215 | 2020-11-29 | Knox | Tennessee | 47093 | 19419 | 163 |
780216 | 780216 | 2020-11-29 | Lake | Tennessee | 47095 | 1178 | 6 |
780217 | 780217 | 2020-11-29 | Lauderdale | Tennessee | 47097 | 2058 | 23 |
780218 | 780218 | 2020-11-29 | Lawrence | Tennessee | 47099 | 2701 | 34 |
780219 | 780219 | 2020-11-29 | Lewis | Tennessee | 47101 | 765 | 14 |
780220 | 780220 | 2020-11-29 | Lincoln | Tennessee | 47103 | 1614 | 16 |
780221 | 780221 | 2020-11-29 | Loudon | Tennessee | 47105 | 2293 | 19 |
780222 | 780222 | 2020-11-29 | Macon | Tennessee | 47111 | 1846 | 28 |
780223 | 780223 | 2020-11-29 | Madison | Tennessee | 47113 | 5368 | 110 |
780224 | 780224 | 2020-11-29 | Marion | Tennessee | 47115 | 1101 | 19 |
780225 | 780225 | 2020-11-29 | Marshall | Tennessee | 47117 | 1765 | 20 |
780226 | 780226 | 2020-11-29 | Maury | Tennessee | 47119 | 5918 | 67 |
780227 | 780227 | 2020-11-29 | McMinn | Tennessee | 47107 | 2550 | 55 |
780228 | 780228 | 2020-11-29 | McNairy | Tennessee | 47109 | 1411 | 33 |
780229 | 780229 | 2020-11-29 | Meigs | Tennessee | 47121 | 495 | 13 |
780230 | 780230 | 2020-11-29 | Monroe | Tennessee | 47123 | 2178 | 44 |
780231 | 780231 | 2020-11-29 | Montgomery | Tennessee | 47125 | 6680 | 83 |
780232 | 780232 | 2020-11-29 | Moore | Tennessee | 47127 | 394 | 3 |
780233 | 780233 | 2020-11-29 | Morgan | Tennessee | 47129 | 739 | 6 |
780234 | 780234 | 2020-11-29 | Obion | Tennessee | 47131 | 2686 | 51 |
780235 | 780235 | 2020-11-29 | Overton | Tennessee | 47133 | 1550 | 35 |
780236 | 780236 | 2020-11-29 | Perry | Tennessee | 47135 | 484 | 21 |
780237 | 780237 | 2020-11-29 | Pickett | Tennessee | 47137 | 389 | 13 |
780238 | 780238 | 2020-11-29 | Polk | Tennessee | 47139 | 673 | 15 |
780239 | 780239 | 2020-11-29 | Putnam | Tennessee | 47141 | 5975 | 82 |
780240 | 780240 | 2020-11-29 | Rhea | Tennessee | 47143 | 1714 | 31 |
780241 | 780241 | 2020-11-29 | Roane | Tennessee | 47145 | 2370 | 29 |
780242 | 780242 | 2020-11-29 | Robertson | Tennessee | 47147 | 3812 | 53 |
780243 | 780243 | 2020-11-29 | Rutherford | Tennessee | 47149 | 17930 | 161 |
780244 | 780244 | 2020-11-29 | Scott | Tennessee | 47151 | 1085 | 7 |
780245 | 780245 | 2020-11-29 | Sequatchie | Tennessee | 47153 | 532 | 5 |
780246 | 780246 | 2020-11-29 | Sevier | Tennessee | 47155 | 4937 | 31 |
780247 | 780247 | 2020-11-29 | Shelby | Tennessee | 47157 | 47963 | 660 |
780248 | 780248 | 2020-11-29 | Smith | Tennessee | 47159 | 1453 | 19 |
780249 | 780249 | 2020-11-29 | Stewart | Tennessee | 47161 | 601 | 15 |
780250 | 780250 | 2020-11-29 | Sullivan | Tennessee | 47163 | 6485 | 97 |
780251 | 780251 | 2020-11-29 | Sumner | Tennessee | 47165 | 9817 | 137 |
780252 | 780252 | 2020-11-29 | Tipton | Tennessee | 47167 | 3711 | 39 |
780253 | 780253 | 2020-11-29 | Trousdale | Tennessee | 47169 | 1908 | 12 |
780254 | 780254 | 2020-11-29 | Unicoi | Tennessee | 47171 | 862 | 26 |
780255 | 780255 | 2020-11-29 | Union | Tennessee | 47173 | 722 | 5 |
780256 | 780256 | 2020-11-29 | Unknown | Tennessee | 2278 | 7 | |
780257 | 780257 | 2020-11-29 | Van Buren | Tennessee | 47175 | 369 | 2 |
780258 | 780258 | 2020-11-29 | Warren | Tennessee | 47177 | 2410 | 20 |
780259 | 780259 | 2020-11-29 | Washington | Tennessee | 47179 | 6073 | 106 |
780260 | 780260 | 2020-11-29 | Wayne | Tennessee | 47181 | 1928 | 10 |
780261 | 780261 | 2020-11-29 | Weakley | Tennessee | 47183 | 2178 | 37 |
780262 | 780262 | 2020-11-29 | White | Tennessee | 47185 | 1767 | 18 |
780263 | 780263 | 2020-11-29 | Williamson | Tennessee | 47187 | 11490 | 80 |
780264 | 780264 | 2020-11-29 | Wilson | Tennessee | 47189 | 7526 | 78 |
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);