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 2021-01-05 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
900247 | 900247 | 2021-01-05 | Anderson | Tennessee | 47001 | 5998 | 75 |
900248 | 900248 | 2021-01-05 | Bedford | Tennessee | 47003 | 4822 | 69 |
900249 | 900249 | 2021-01-05 | Benton | Tennessee | 47005 | 1215 | 31 |
900250 | 900250 | 2021-01-05 | Bledsoe | Tennessee | 47007 | 1637 | 9 |
900251 | 900251 | 2021-01-05 | Blount | Tennessee | 47009 | 10494 | 100 |
900252 | 900252 | 2021-01-05 | Bradley | Tennessee | 47011 | 9605 | 77 |
900253 | 900253 | 2021-01-05 | Campbell | Tennessee | 47013 | 2914 | 38 |
900254 | 900254 | 2021-01-05 | Cannon | Tennessee | 47015 | 1436 | 16 |
900255 | 900255 | 2021-01-05 | Carroll | Tennessee | 47017 | 2795 | 52 |
900256 | 900256 | 2021-01-05 | Carter | Tennessee | 47019 | 4706 | 90 |
900257 | 900257 | 2021-01-05 | Cheatham | Tennessee | 47021 | 3030 | 27 |
900258 | 900258 | 2021-01-05 | Chester | Tennessee | 47023 | 1582 | 32 |
900259 | 900259 | 2021-01-05 | Claiborne | Tennessee | 47025 | 1764 | 20 |
900260 | 900260 | 2021-01-05 | Clay | Tennessee | 47027 | 859 | 23 |
900261 | 900261 | 2021-01-05 | Cocke | Tennessee | 47029 | 3059 | 50 |
900262 | 900262 | 2021-01-05 | Coffee | Tennessee | 47031 | 5132 | 72 |
900263 | 900263 | 2021-01-05 | Crockett | Tennessee | 47033 | 1713 | 32 |
900264 | 900264 | 2021-01-05 | Cumberland | Tennessee | 47035 | 4750 | 53 |
900265 | 900265 | 2021-01-05 | Davidson | Tennessee | 47037 | 71936 | 600 |
900266 | 900266 | 2021-01-05 | DeKalb | Tennessee | 47041 | 2182 | 36 |
900267 | 900267 | 2021-01-05 | Decatur | Tennessee | 47039 | 1388 | 22 |
900268 | 900268 | 2021-01-05 | Dickson | Tennessee | 47043 | 4859 | 65 |
900269 | 900269 | 2021-01-05 | Dyer | Tennessee | 47045 | 4407 | 77 |
900270 | 900270 | 2021-01-05 | Fayette | Tennessee | 47047 | 3559 | 49 |
900271 | 900271 | 2021-01-05 | Fentress | Tennessee | 47049 | 1967 | 30 |
900272 | 900272 | 2021-01-05 | Franklin | Tennessee | 47051 | 3726 | 48 |
900273 | 900273 | 2021-01-05 | Gibson | Tennessee | 47053 | 5218 | 95 |
900274 | 900274 | 2021-01-05 | Giles | Tennessee | 47055 | 2870 | 63 |
900275 | 900275 | 2021-01-05 | Grainger | Tennessee | 47057 | 1878 | 26 |
900276 | 900276 | 2021-01-05 | Greene | Tennessee | 47059 | 5916 | 102 |
900277 | 900277 | 2021-01-05 | Grundy | Tennessee | 47061 | 1272 | 20 |
900278 | 900278 | 2021-01-05 | Hamblen | Tennessee | 47063 | 6200 | 91 |
900279 | 900279 | 2021-01-05 | Hamilton | Tennessee | 47065 | 31353 | 283 |
900280 | 900280 | 2021-01-05 | Hancock | Tennessee | 47067 | 354 | 5 |
900281 | 900281 | 2021-01-05 | Hardeman | Tennessee | 47069 | 2914 | 43 |
900282 | 900282 | 2021-01-05 | Hardin | Tennessee | 47071 | 2757 | 36 |
900283 | 900283 | 2021-01-05 | Hawkins | Tennessee | 47073 | 3911 | 60 |
900284 | 900284 | 2021-01-05 | Haywood | Tennessee | 47075 | 2250 | 37 |
900285 | 900285 | 2021-01-05 | Henderson | Tennessee | 47077 | 3077 | 44 |
900286 | 900286 | 2021-01-05 | Henry | Tennessee | 47079 | 2384 | 43 |
900287 | 900287 | 2021-01-05 | Hickman | Tennessee | 47081 | 2014 | 28 |
900288 | 900288 | 2021-01-05 | Houston | Tennessee | 47083 | 828 | 22 |
900289 | 900289 | 2021-01-05 | Humphreys | Tennessee | 47085 | 1205 | 12 |
900290 | 900290 | 2021-01-05 | Jackson | Tennessee | 47087 | 986 | 20 |
900291 | 900291 | 2021-01-05 | Jefferson | Tennessee | 47089 | 4133 | 67 |
900292 | 900292 | 2021-01-05 | Johnson | Tennessee | 47091 | 1842 | 28 |
900293 | 900293 | 2021-01-05 | Knox | Tennessee | 47093 | 35529 | 346 |
900294 | 900294 | 2021-01-05 | Lake | Tennessee | 47095 | 1470 | 15 |
900295 | 900295 | 2021-01-05 | Lauderdale | Tennessee | 47097 | 2726 | 29 |
900296 | 900296 | 2021-01-05 | Lawrence | Tennessee | 47099 | 4630 | 63 |
900297 | 900297 | 2021-01-05 | Lewis | Tennessee | 47101 | 1188 | 20 |
900298 | 900298 | 2021-01-05 | Lincoln | Tennessee | 47103 | 3444 | 38 |
900299 | 900299 | 2021-01-05 | Loudon | Tennessee | 47105 | 4408 | 42 |
900300 | 900300 | 2021-01-05 | Macon | Tennessee | 47111 | 2662 | 47 |
900301 | 900301 | 2021-01-05 | Madison | Tennessee | 47113 | 8348 | 159 |
900302 | 900302 | 2021-01-05 | Marion | Tennessee | 47115 | 1974 | 26 |
900303 | 900303 | 2021-01-05 | Marshall | Tennessee | 47117 | 3012 | 30 |
900304 | 900304 | 2021-01-05 | Maury | Tennessee | 47119 | 9724 | 107 |
900305 | 900305 | 2021-01-05 | McMinn | Tennessee | 47107 | 4587 | 66 |
900306 | 900306 | 2021-01-05 | McNairy | Tennessee | 47109 | 2147 | 38 |
900307 | 900307 | 2021-01-05 | Meigs | Tennessee | 47121 | 1010 | 16 |
900308 | 900308 | 2021-01-05 | Monroe | Tennessee | 47123 | 4055 | 57 |
900309 | 900309 | 2021-01-05 | Montgomery | Tennessee | 47125 | 12263 | 129 |
900310 | 900310 | 2021-01-05 | Moore | Tennessee | 47127 | 728 | 6 |
900311 | 900311 | 2021-01-05 | Morgan | Tennessee | 47129 | 1672 | 12 |
900312 | 900312 | 2021-01-05 | Obion | Tennessee | 47131 | 3749 | 73 |
900313 | 900313 | 2021-01-05 | Overton | Tennessee | 47133 | 2285 | 41 |
900314 | 900314 | 2021-01-05 | Perry | Tennessee | 47135 | 880 | 23 |
900315 | 900315 | 2021-01-05 | Pickett | Tennessee | 47137 | 596 | 17 |
900316 | 900316 | 2021-01-05 | Polk | Tennessee | 47139 | 1247 | 16 |
900317 | 900317 | 2021-01-05 | Putnam | Tennessee | 47141 | 9063 | 124 |
900318 | 900318 | 2021-01-05 | Rhea | Tennessee | 47143 | 3391 | 51 |
900319 | 900319 | 2021-01-05 | Roane | Tennessee | 47145 | 4646 | 64 |
900320 | 900320 | 2021-01-05 | Robertson | Tennessee | 47147 | 6847 | 75 |
900321 | 900321 | 2021-01-05 | Rutherford | Tennessee | 47149 | 29823 | 252 |
900322 | 900322 | 2021-01-05 | Scott | Tennessee | 47151 | 2078 | 25 |
900323 | 900323 | 2021-01-05 | Sequatchie | Tennessee | 47153 | 1221 | 17 |
900324 | 900324 | 2021-01-05 | Sevier | Tennessee | 47155 | 9366 | 76 |
900325 | 900325 | 2021-01-05 | Shelby | Tennessee | 47157 | 70532 | 947 |
900326 | 900326 | 2021-01-05 | Smith | Tennessee | 47159 | 2119 | 24 |
900327 | 900327 | 2021-01-05 | Stewart | Tennessee | 47161 | 928 | 20 |
900328 | 900328 | 2021-01-05 | Sullivan | Tennessee | 47163 | 11377 | 192 |
900329 | 900329 | 2021-01-05 | Sumner | Tennessee | 47165 | 16501 | 210 |
900330 | 900330 | 2021-01-05 | Tipton | Tennessee | 47167 | 5679 | 55 |
900331 | 900331 | 2021-01-05 | Trousdale | Tennessee | 47169 | 2197 | 12 |
900332 | 900332 | 2021-01-05 | Unicoi | Tennessee | 47171 | 1516 | 40 |
900333 | 900333 | 2021-01-05 | Union | Tennessee | 47173 | 1279 | 18 |
900334 | 900334 | 2021-01-05 | Unknown | Tennessee | 7910 | 75 | |
900335 | 900335 | 2021-01-05 | Van Buren | Tennessee | 47175 | 577 | 6 |
900336 | 900336 | 2021-01-05 | Warren | Tennessee | 47177 | 4578 | 46 |
900337 | 900337 | 2021-01-05 | Washington | Tennessee | 47179 | 10849 | 172 |
900338 | 900338 | 2021-01-05 | Wayne | Tennessee | 47181 | 2496 | 18 |
900339 | 900339 | 2021-01-05 | Weakley | Tennessee | 47183 | 3189 | 45 |
900340 | 900340 | 2021-01-05 | White | Tennessee | 47185 | 2849 | 39 |
900341 | 900341 | 2021-01-05 | Williamson | Tennessee | 47187 | 19037 | 128 |
900342 | 900342 | 2021-01-05 | Wilson | Tennessee | 47189 | 13118 | 135 |
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);