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-19 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
647150 | 647150 | 2020-10-19 | Anderson | Tennessee | 47001 | 1555 | 13 |
647151 | 647151 | 2020-10-19 | Bedford | Tennessee | 47003 | 1590 | 20 |
647152 | 647152 | 2020-10-19 | Benton | Tennessee | 47005 | 387 | 9 |
647153 | 647153 | 2020-10-19 | Bledsoe | Tennessee | 47007 | 924 | 4 |
647154 | 647154 | 2020-10-19 | Blount | Tennessee | 47009 | 3102 | 31 |
647155 | 647155 | 2020-10-19 | Bradley | Tennessee | 47011 | 3408 | 21 |
647156 | 647156 | 2020-10-19 | Campbell | Tennessee | 47013 | 864 | 7 |
647157 | 647157 | 2020-10-19 | Cannon | Tennessee | 47015 | 386 | 2 |
647158 | 647158 | 2020-10-19 | Carroll | Tennessee | 47017 | 1093 | 24 |
647159 | 647159 | 2020-10-19 | Carter | Tennessee | 47019 | 1415 | 32 |
647160 | 647160 | 2020-10-19 | Cheatham | Tennessee | 47021 | 969 | 11 |
647161 | 647161 | 2020-10-19 | Chester | Tennessee | 47023 | 712 | 14 |
647162 | 647162 | 2020-10-19 | Claiborne | Tennessee | 47025 | 495 | 6 |
647163 | 647163 | 2020-10-19 | Clay | Tennessee | 47027 | 363 | 12 |
647164 | 647164 | 2020-10-19 | Cocke | Tennessee | 47029 | 922 | 12 |
647165 | 647165 | 2020-10-19 | Coffee | Tennessee | 47031 | 1760 | 20 |
647166 | 647166 | 2020-10-19 | Crockett | Tennessee | 47033 | 766 | 20 |
647167 | 647167 | 2020-10-19 | Cumberland | Tennessee | 47035 | 1489 | 24 |
647168 | 647168 | 2020-10-19 | Davidson | Tennessee | 47037 | 31759 | 325 |
647169 | 647169 | 2020-10-19 | DeKalb | Tennessee | 47041 | 672 | 16 |
647170 | 647170 | 2020-10-19 | Decatur | Tennessee | 47039 | 625 | 11 |
647171 | 647171 | 2020-10-19 | Dickson | Tennessee | 47043 | 1562 | 18 |
647172 | 647172 | 2020-10-19 | Dyer | Tennessee | 47045 | 2023 | 26 |
647173 | 647173 | 2020-10-19 | Fayette | Tennessee | 47047 | 1520 | 22 |
647174 | 647174 | 2020-10-19 | Fentress | Tennessee | 47049 | 849 | 7 |
647175 | 647175 | 2020-10-19 | Franklin | Tennessee | 47051 | 1211 | 15 |
647176 | 647176 | 2020-10-19 | Gibson | Tennessee | 47053 | 2054 | 37 |
647177 | 647177 | 2020-10-19 | Giles | Tennessee | 47055 | 892 | 34 |
647178 | 647178 | 2020-10-19 | Grainger | Tennessee | 47057 | 531 | 4 |
647179 | 647179 | 2020-10-19 | Greene | Tennessee | 47059 | 1556 | 50 |
647180 | 647180 | 2020-10-19 | Grundy | Tennessee | 47061 | 516 | 8 |
647181 | 647181 | 2020-10-19 | Hamblen | Tennessee | 47063 | 2327 | 43 |
647182 | 647182 | 2020-10-19 | Hamilton | Tennessee | 47065 | 11289 | 105 |
647183 | 647183 | 2020-10-19 | Hancock | Tennessee | 47067 | 112 | 3 |
647184 | 647184 | 2020-10-19 | Hardeman | Tennessee | 47069 | 1787 | 32 |
647185 | 647185 | 2020-10-19 | Hardin | Tennessee | 47071 | 1313 | 19 |
647186 | 647186 | 2020-10-19 | Hawkins | Tennessee | 47073 | 1099 | 23 |
647187 | 647187 | 2020-10-19 | Haywood | Tennessee | 47075 | 1190 | 25 |
647188 | 647188 | 2020-10-19 | Henderson | Tennessee | 47077 | 1354 | 25 |
647189 | 647189 | 2020-10-19 | Henry | Tennessee | 47079 | 741 | 10 |
647190 | 647190 | 2020-10-19 | Hickman | Tennessee | 47081 | 739 | 13 |
647191 | 647191 | 2020-10-19 | Houston | Tennessee | 47083 | 389 | 14 |
647192 | 647192 | 2020-10-19 | Humphreys | Tennessee | 47085 | 409 | 4 |
647193 | 647193 | 2020-10-19 | Jackson | Tennessee | 47087 | 416 | 5 |
647194 | 647194 | 2020-10-19 | Jefferson | Tennessee | 47089 | 1458 | 18 |
647195 | 647195 | 2020-10-19 | Johnson | Tennessee | 47091 | 1104 | 6 |
647196 | 647196 | 2020-10-19 | Knox | Tennessee | 47093 | 12269 | 95 |
647197 | 647197 | 2020-10-19 | Lake | Tennessee | 47095 | 968 | 3 |
647198 | 647198 | 2020-10-19 | Lauderdale | Tennessee | 47097 | 1308 | 18 |
647199 | 647199 | 2020-10-19 | Lawrence | Tennessee | 47099 | 1462 | 17 |
647200 | 647200 | 2020-10-19 | Lewis | Tennessee | 47101 | 350 | 2 |
647201 | 647201 | 2020-10-19 | Lincoln | Tennessee | 47103 | 801 | 2 |
647202 | 647202 | 2020-10-19 | Loudon | Tennessee | 47105 | 1540 | 10 |
647203 | 647203 | 2020-10-19 | Macon | Tennessee | 47111 | 1257 | 24 |
647204 | 647204 | 2020-10-19 | Madison | Tennessee | 47113 | 3613 | 78 |
647205 | 647205 | 2020-10-19 | Marion | Tennessee | 47115 | 699 | 9 |
647206 | 647206 | 2020-10-19 | Marshall | Tennessee | 47117 | 1052 | 8 |
647207 | 647207 | 2020-10-19 | Maury | Tennessee | 47119 | 3074 | 35 |
647208 | 647208 | 2020-10-19 | McMinn | Tennessee | 47107 | 1508 | 32 |
647209 | 647209 | 2020-10-19 | McNairy | Tennessee | 47109 | 1088 | 25 |
647210 | 647210 | 2020-10-19 | Meigs | Tennessee | 47121 | 294 | 4 |
647211 | 647211 | 2020-10-19 | Monroe | Tennessee | 47123 | 1348 | 23 |
647212 | 647212 | 2020-10-19 | Montgomery | Tennessee | 47125 | 3857 | 51 |
647213 | 647213 | 2020-10-19 | Moore | Tennessee | 47127 | 245 | 2 |
647214 | 647214 | 2020-10-19 | Morgan | Tennessee | 47129 | 408 | 6 |
647215 | 647215 | 2020-10-19 | Obion | Tennessee | 47131 | 1636 | 17 |
647216 | 647216 | 2020-10-19 | Overton | Tennessee | 47133 | 1112 | 11 |
647217 | 647217 | 2020-10-19 | Perry | Tennessee | 47135 | 204 | 1 |
647218 | 647218 | 2020-10-19 | Pickett | Tennessee | 47137 | 244 | 5 |
647219 | 647219 | 2020-10-19 | Polk | Tennessee | 47139 | 469 | 13 |
647220 | 647220 | 2020-10-19 | Putnam | Tennessee | 47141 | 4110 | 53 |
647221 | 647221 | 2020-10-19 | Rhea | Tennessee | 47143 | 1048 | 16 |
647222 | 647222 | 2020-10-19 | Roane | Tennessee | 47145 | 1185 | 7 |
647223 | 647223 | 2020-10-19 | Robertson | Tennessee | 47147 | 2485 | 39 |
647224 | 647224 | 2020-10-19 | Rutherford | Tennessee | 47149 | 11031 | 106 |
647225 | 647225 | 2020-10-19 | Scott | Tennessee | 47151 | 324 | 4 |
647226 | 647226 | 2020-10-19 | Sequatchie | Tennessee | 47153 | 329 | 4 |
647227 | 647227 | 2020-10-19 | Sevier | Tennessee | 47155 | 3149 | 20 |
647228 | 647228 | 2020-10-19 | Shelby | Tennessee | 47157 | 34508 | 553 |
647229 | 647229 | 2020-10-19 | Smith | Tennessee | 47159 | 933 | 13 |
647230 | 647230 | 2020-10-19 | Stewart | Tennessee | 47161 | 308 | 7 |
647231 | 647231 | 2020-10-19 | Sullivan | Tennessee | 47163 | 3188 | 44 |
647232 | 647232 | 2020-10-19 | Sumner | Tennessee | 47165 | 5636 | 107 |
647233 | 647233 | 2020-10-19 | Tipton | Tennessee | 47167 | 2192 | 22 |
647234 | 647234 | 2020-10-19 | Trousdale | Tennessee | 47169 | 1740 | 7 |
647235 | 647235 | 2020-10-19 | Unicoi | Tennessee | 47171 | 364 | 1 |
647236 | 647236 | 2020-10-19 | Union | Tennessee | 47173 | 493 | 2 |
647237 | 647237 | 2020-10-19 | Unknown | Tennessee | 1041 | 0 | |
647238 | 647238 | 2020-10-19 | Van Buren | Tennessee | 47175 | 191 | 1 |
647239 | 647239 | 2020-10-19 | Warren | Tennessee | 47177 | 1339 | 9 |
647240 | 647240 | 2020-10-19 | Washington | Tennessee | 47179 | 3080 | 43 |
647241 | 647241 | 2020-10-19 | Wayne | Tennessee | 47181 | 1560 | 7 |
647242 | 647242 | 2020-10-19 | Weakley | Tennessee | 47183 | 1434 | 25 |
647243 | 647243 | 2020-10-19 | White | Tennessee | 47185 | 1076 | 14 |
647244 | 647244 | 2020-10-19 | Williamson | Tennessee | 47187 | 6618 | 48 |
647245 | 647245 | 2020-10-19 | Wilson | Tennessee | 47189 | 4402 | 53 |
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);