ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where "date" is on date 2020-07-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 |
---|---|---|---|---|---|---|---|
340317 | 340317 | 2020-07-16 | Anderson | Tennessee | 47001 | 252 | 2 |
340318 | 340318 | 2020-07-16 | Bedford | Tennessee | 47003 | 654 | 10 |
340319 | 340319 | 2020-07-16 | Benton | Tennessee | 47005 | 26 | 1 |
340320 | 340320 | 2020-07-16 | Bledsoe | Tennessee | 47007 | 636 | 1 |
340321 | 340321 | 2020-07-16 | Blount | Tennessee | 47009 | 416 | 4 |
340322 | 340322 | 2020-07-16 | Bradley | Tennessee | 47011 | 1114 | 6 |
340323 | 340323 | 2020-07-16 | Campbell | Tennessee | 47013 | 79 | 1 |
340324 | 340324 | 2020-07-16 | Cannon | Tennessee | 47015 | 66 | 0 |
340325 | 340325 | 2020-07-16 | Carroll | Tennessee | 47017 | 69 | 1 |
340326 | 340326 | 2020-07-16 | Carter | Tennessee | 47019 | 141 | 2 |
340327 | 340327 | 2020-07-16 | Cheatham | Tennessee | 47021 | 332 | 4 |
340328 | 340328 | 2020-07-16 | Chester | Tennessee | 47023 | 99 | 0 |
340329 | 340329 | 2020-07-16 | Claiborne | Tennessee | 47025 | 91 | 0 |
340330 | 340330 | 2020-07-16 | Clay | Tennessee | 47027 | 31 | 0 |
340331 | 340331 | 2020-07-16 | Cocke | Tennessee | 47029 | 180 | 1 |
340332 | 340332 | 2020-07-16 | Coffee | Tennessee | 47031 | 168 | 0 |
340333 | 340333 | 2020-07-16 | Crockett | Tennessee | 47033 | 84 | 3 |
340334 | 340334 | 2020-07-16 | Cumberland | Tennessee | 47035 | 244 | 5 |
340335 | 340335 | 2020-07-16 | Davidson | Tennessee | 47037 | 16079 | 160 |
340336 | 340336 | 2020-07-16 | DeKalb | Tennessee | 47041 | 128 | 0 |
340337 | 340337 | 2020-07-16 | Decatur | Tennessee | 47039 | 49 | 0 |
340338 | 340338 | 2020-07-16 | Dickson | Tennessee | 47043 | 323 | 0 |
340339 | 340339 | 2020-07-16 | Dyer | Tennessee | 47045 | 337 | 3 |
340340 | 340340 | 2020-07-16 | Fayette | Tennessee | 47047 | 424 | 6 |
340341 | 340341 | 2020-07-16 | Fentress | Tennessee | 47049 | 36 | 0 |
340342 | 340342 | 2020-07-16 | Franklin | Tennessee | 47051 | 136 | 3 |
340343 | 340343 | 2020-07-16 | Gibson | Tennessee | 47053 | 259 | 1 |
340344 | 340344 | 2020-07-16 | Giles | Tennessee | 47055 | 163 | 1 |
340345 | 340345 | 2020-07-16 | Grainger | Tennessee | 47057 | 67 | 0 |
340346 | 340346 | 2020-07-16 | Greene | Tennessee | 47059 | 187 | 2 |
340347 | 340347 | 2020-07-16 | Grundy | Tennessee | 47061 | 71 | 2 |
340348 | 340348 | 2020-07-16 | Hamblen | Tennessee | 47063 | 571 | 5 |
340349 | 340349 | 2020-07-16 | Hamilton | Tennessee | 47065 | 3939 | 39 |
340350 | 340350 | 2020-07-16 | Hancock | Tennessee | 47067 | 24 | 0 |
340351 | 340351 | 2020-07-16 | Hardeman | Tennessee | 47069 | 503 | 4 |
340352 | 340352 | 2020-07-16 | Hardin | Tennessee | 47071 | 171 | 7 |
340353 | 340353 | 2020-07-16 | Hawkins | Tennessee | 47073 | 117 | 2 |
340354 | 340354 | 2020-07-16 | Haywood | Tennessee | 47075 | 172 | 3 |
340355 | 340355 | 2020-07-16 | Henderson | Tennessee | 47077 | 132 | 0 |
340356 | 340356 | 2020-07-16 | Henry | Tennessee | 47079 | 60 | 0 |
340357 | 340357 | 2020-07-16 | Hickman | Tennessee | 47081 | 129 | 0 |
340358 | 340358 | 2020-07-16 | Houston | Tennessee | 47083 | 25 | 0 |
340359 | 340359 | 2020-07-16 | Humphreys | Tennessee | 47085 | 55 | 2 |
340360 | 340360 | 2020-07-16 | Jackson | Tennessee | 47087 | 65 | 0 |
340361 | 340361 | 2020-07-16 | Jefferson | Tennessee | 47089 | 227 | 1 |
340362 | 340362 | 2020-07-16 | Johnson | Tennessee | 47091 | 51 | 0 |
340363 | 340363 | 2020-07-16 | Knox | Tennessee | 47093 | 1991 | 17 |
340364 | 340364 | 2020-07-16 | Lake | Tennessee | 47095 | 698 | 0 |
340365 | 340365 | 2020-07-16 | Lauderdale | Tennessee | 47097 | 229 | 4 |
340366 | 340366 | 2020-07-16 | Lawrence | Tennessee | 47099 | 272 | 6 |
340367 | 340367 | 2020-07-16 | Lewis | Tennessee | 47101 | 13 | 0 |
340368 | 340368 | 2020-07-16 | Lincoln | Tennessee | 47103 | 126 | 0 |
340369 | 340369 | 2020-07-16 | Loudon | Tennessee | 47105 | 368 | 3 |
340370 | 340370 | 2020-07-16 | Macon | Tennessee | 47111 | 680 | 7 |
340371 | 340371 | 2020-07-16 | Madison | Tennessee | 47113 | 428 | 2 |
340372 | 340372 | 2020-07-16 | Marion | Tennessee | 47115 | 113 | 4 |
340373 | 340373 | 2020-07-16 | Marshall | Tennessee | 47117 | 150 | 2 |
340374 | 340374 | 2020-07-16 | Maury | Tennessee | 47119 | 557 | 4 |
340375 | 340375 | 2020-07-16 | McMinn | Tennessee | 47107 | 326 | 19 |
340376 | 340376 | 2020-07-16 | McNairy | Tennessee | 47109 | 146 | 1 |
340377 | 340377 | 2020-07-16 | Meigs | Tennessee | 47121 | 43 | 0 |
340378 | 340378 | 2020-07-16 | Monroe | Tennessee | 47123 | 165 | 7 |
340379 | 340379 | 2020-07-16 | Montgomery | Tennessee | 47125 | 974 | 7 |
340380 | 340380 | 2020-07-16 | Moore | Tennessee | 47127 | 28 | 0 |
340381 | 340381 | 2020-07-16 | Morgan | Tennessee | 47129 | 38 | 1 |
340382 | 340382 | 2020-07-16 | Obion | Tennessee | 47131 | 155 | 3 |
340383 | 340383 | 2020-07-16 | Overton | Tennessee | 47133 | 88 | 1 |
340384 | 340384 | 2020-07-16 | Perry | Tennessee | 47135 | 47 | 0 |
340385 | 340385 | 2020-07-16 | Pickett | Tennessee | 47137 | 9 | 0 |
340386 | 340386 | 2020-07-16 | Polk | Tennessee | 47139 | 63 | 0 |
340387 | 340387 | 2020-07-16 | Putnam | Tennessee | 47141 | 1136 | 7 |
340388 | 340388 | 2020-07-16 | Rhea | Tennessee | 47143 | 370 | 0 |
340389 | 340389 | 2020-07-16 | Roane | Tennessee | 47145 | 105 | 0 |
340390 | 340390 | 2020-07-16 | Robertson | Tennessee | 47147 | 1084 | 14 |
340391 | 340391 | 2020-07-16 | Rutherford | Tennessee | 47149 | 4114 | 40 |
340392 | 340392 | 2020-07-16 | Scott | Tennessee | 47151 | 32 | 0 |
340393 | 340393 | 2020-07-16 | Sequatchie | Tennessee | 47153 | 54 | 0 |
340394 | 340394 | 2020-07-16 | Sevier | Tennessee | 47155 | 1010 | 4 |
340395 | 340395 | 2020-07-16 | Shelby | Tennessee | 47157 | 15324 | 233 |
340396 | 340396 | 2020-07-16 | Smith | Tennessee | 47159 | 205 | 2 |
340397 | 340397 | 2020-07-16 | Stewart | Tennessee | 47161 | 35 | 0 |
340398 | 340398 | 2020-07-16 | Sullivan | Tennessee | 47163 | 305 | 5 |
340399 | 340399 | 2020-07-16 | Sumner | Tennessee | 47165 | 2264 | 57 |
340400 | 340400 | 2020-07-16 | Tipton | Tennessee | 47167 | 763 | 7 |
340401 | 340401 | 2020-07-16 | Trousdale | Tennessee | 47169 | 1528 | 6 |
340402 | 340402 | 2020-07-16 | Unicoi | Tennessee | 47171 | 63 | 0 |
340403 | 340403 | 2020-07-16 | Union | Tennessee | 47173 | 32 | 0 |
340404 | 340404 | 2020-07-16 | Van Buren | Tennessee | 47175 | 14 | 0 |
340405 | 340405 | 2020-07-16 | Warren | Tennessee | 47177 | 189 | 1 |
340406 | 340406 | 2020-07-16 | Washington | Tennessee | 47179 | 336 | 0 |
340407 | 340407 | 2020-07-16 | Wayne | Tennessee | 47181 | 135 | 0 |
340408 | 340408 | 2020-07-16 | Weakley | Tennessee | 47183 | 94 | 1 |
340409 | 340409 | 2020-07-16 | White | Tennessee | 47185 | 117 | 3 |
340410 | 340410 | 2020-07-16 | Williamson | Tennessee | 47187 | 2217 | 18 |
340411 | 340411 | 2020-07-16 | Wilson | Tennessee | 47189 | 1412 | 18 |
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);