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-09-25 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
569322 | 569322 | 2020-09-25 | Anderson | Tennessee | 47001 | 1165 | 13 |
569323 | 569323 | 2020-09-25 | Bedford | Tennessee | 47003 | 1328 | 17 |
569324 | 569324 | 2020-09-25 | Benton | Tennessee | 47005 | 336 | 9 |
569325 | 569325 | 2020-09-25 | Bledsoe | Tennessee | 47007 | 854 | 4 |
569326 | 569326 | 2020-09-25 | Blount | Tennessee | 47009 | 2504 | 24 |
569327 | 569327 | 2020-09-25 | Bradley | Tennessee | 47011 | 2914 | 17 |
569328 | 569328 | 2020-09-25 | Campbell | Tennessee | 47013 | 439 | 4 |
569329 | 569329 | 2020-09-25 | Cannon | Tennessee | 47015 | 283 | 0 |
569330 | 569330 | 2020-09-25 | Carroll | Tennessee | 47017 | 874 | 20 |
569331 | 569331 | 2020-09-25 | Carter | Tennessee | 47019 | 1158 | 28 |
569332 | 569332 | 2020-09-25 | Cheatham | Tennessee | 47021 | 805 | 10 |
569333 | 569333 | 2020-09-25 | Chester | Tennessee | 47023 | 623 | 10 |
569334 | 569334 | 2020-09-25 | Claiborne | Tennessee | 47025 | 441 | 5 |
569335 | 569335 | 2020-09-25 | Clay | Tennessee | 47027 | 224 | 5 |
569336 | 569336 | 2020-09-25 | Cocke | Tennessee | 47029 | 743 | 9 |
569337 | 569337 | 2020-09-25 | Coffee | Tennessee | 47031 | 1210 | 13 |
569338 | 569338 | 2020-09-25 | Crockett | Tennessee | 47033 | 536 | 19 |
569339 | 569339 | 2020-09-25 | Cumberland | Tennessee | 47035 | 1192 | 18 |
569340 | 569340 | 2020-09-25 | Davidson | Tennessee | 47037 | 28415 | 303 |
569341 | 569341 | 2020-09-25 | DeKalb | Tennessee | 47041 | 561 | 14 |
569342 | 569342 | 2020-09-25 | Decatur | Tennessee | 47039 | 512 | 7 |
569343 | 569343 | 2020-09-25 | Dickson | Tennessee | 47043 | 1250 | 15 |
569344 | 569344 | 2020-09-25 | Dyer | Tennessee | 47045 | 1350 | 14 |
569345 | 569345 | 2020-09-25 | Fayette | Tennessee | 47047 | 1183 | 19 |
569346 | 569346 | 2020-09-25 | Fentress | Tennessee | 47049 | 493 | 3 |
569347 | 569347 | 2020-09-25 | Franklin | Tennessee | 47051 | 963 | 9 |
569348 | 569348 | 2020-09-25 | Gibson | Tennessee | 47053 | 1636 | 22 |
569349 | 569349 | 2020-09-25 | Giles | Tennessee | 47055 | 591 | 17 |
569350 | 569350 | 2020-09-25 | Grainger | Tennessee | 47057 | 372 | 3 |
569351 | 569351 | 2020-09-25 | Greene | Tennessee | 47059 | 1142 | 44 |
569352 | 569352 | 2020-09-25 | Grundy | Tennessee | 47061 | 283 | 5 |
569353 | 569353 | 2020-09-25 | Hamblen | Tennessee | 47063 | 1899 | 26 |
569354 | 569354 | 2020-09-25 | Hamilton | Tennessee | 47065 | 9542 | 94 |
569355 | 569355 | 2020-09-25 | Hancock | Tennessee | 47067 | 106 | 3 |
569356 | 569356 | 2020-09-25 | Hardeman | Tennessee | 47069 | 1558 | 26 |
569357 | 569357 | 2020-09-25 | Hardin | Tennessee | 47071 | 1022 | 16 |
569358 | 569358 | 2020-09-25 | Hawkins | Tennessee | 47073 | 796 | 18 |
569359 | 569359 | 2020-09-25 | Haywood | Tennessee | 47075 | 968 | 19 |
569360 | 569360 | 2020-09-25 | Henderson | Tennessee | 47077 | 1169 | 24 |
569361 | 569361 | 2020-09-25 | Henry | Tennessee | 47079 | 618 | 9 |
569362 | 569362 | 2020-09-25 | Hickman | Tennessee | 47081 | 573 | 8 |
569363 | 569363 | 2020-09-25 | Houston | Tennessee | 47083 | 214 | 3 |
569364 | 569364 | 2020-09-25 | Humphreys | Tennessee | 47085 | 246 | 3 |
569365 | 569365 | 2020-09-25 | Jackson | Tennessee | 47087 | 324 | 5 |
569366 | 569366 | 2020-09-25 | Jefferson | Tennessee | 47089 | 1110 | 14 |
569367 | 569367 | 2020-09-25 | Johnson | Tennessee | 47091 | 696 | 2 |
569368 | 569368 | 2020-09-25 | Knox | Tennessee | 47093 | 9893 | 78 |
569369 | 569369 | 2020-09-25 | Lake | Tennessee | 47095 | 918 | 2 |
569370 | 569370 | 2020-09-25 | Lauderdale | Tennessee | 47097 | 979 | 16 |
569371 | 569371 | 2020-09-25 | Lawrence | Tennessee | 47099 | 1023 | 12 |
569372 | 569372 | 2020-09-25 | Lewis | Tennessee | 47101 | 196 | 1 |
569373 | 569373 | 2020-09-25 | Lincoln | Tennessee | 47103 | 611 | 1 |
569374 | 569374 | 2020-09-25 | Loudon | Tennessee | 47105 | 1154 | 6 |
569375 | 569375 | 2020-09-25 | Macon | Tennessee | 47111 | 1046 | 20 |
569376 | 569376 | 2020-09-25 | Madison | Tennessee | 47113 | 2832 | 64 |
569377 | 569377 | 2020-09-25 | Marion | Tennessee | 47115 | 525 | 8 |
569378 | 569378 | 2020-09-25 | Marshall | Tennessee | 47117 | 749 | 5 |
569379 | 569379 | 2020-09-25 | Maury | Tennessee | 47119 | 2329 | 23 |
569380 | 569380 | 2020-09-25 | McMinn | Tennessee | 47107 | 1113 | 25 |
569381 | 569381 | 2020-09-25 | McNairy | Tennessee | 47109 | 876 | 18 |
569382 | 569382 | 2020-09-25 | Meigs | Tennessee | 47121 | 226 | 3 |
569383 | 569383 | 2020-09-25 | Monroe | Tennessee | 47123 | 1030 | 18 |
569384 | 569384 | 2020-09-25 | Montgomery | Tennessee | 47125 | 3045 | 44 |
569385 | 569385 | 2020-09-25 | Moore | Tennessee | 47127 | 169 | 1 |
569386 | 569386 | 2020-09-25 | Morgan | Tennessee | 47129 | 315 | 3 |
569387 | 569387 | 2020-09-25 | Obion | Tennessee | 47131 | 1156 | 10 |
569388 | 569388 | 2020-09-25 | Overton | Tennessee | 47133 | 735 | 5 |
569389 | 569389 | 2020-09-25 | Perry | Tennessee | 47135 | 150 | 0 |
569390 | 569390 | 2020-09-25 | Pickett | Tennessee | 47137 | 114 | 2 |
569391 | 569391 | 2020-09-25 | Polk | Tennessee | 47139 | 388 | 10 |
569392 | 569392 | 2020-09-25 | Putnam | Tennessee | 47141 | 3277 | 40 |
569393 | 569393 | 2020-09-25 | Rhea | Tennessee | 47143 | 821 | 12 |
569394 | 569394 | 2020-09-25 | Roane | Tennessee | 47145 | 885 | 4 |
569395 | 569395 | 2020-09-25 | Robertson | Tennessee | 47147 | 2203 | 35 |
569396 | 569396 | 2020-09-25 | Rutherford | Tennessee | 47149 | 9240 | 89 |
569397 | 569397 | 2020-09-25 | Scott | Tennessee | 47151 | 213 | 2 |
569398 | 569398 | 2020-09-25 | Sequatchie | Tennessee | 47153 | 231 | 2 |
569399 | 569399 | 2020-09-25 | Sevier | Tennessee | 47155 | 2596 | 15 |
569400 | 569400 | 2020-09-25 | Shelby | Tennessee | 47157 | 30922 | 455 |
569401 | 569401 | 2020-09-25 | Smith | Tennessee | 47159 | 713 | 11 |
569402 | 569402 | 2020-09-25 | Stewart | Tennessee | 47161 | 198 | 2 |
569403 | 569403 | 2020-09-25 | Sullivan | Tennessee | 47163 | 2148 | 33 |
569404 | 569404 | 2020-09-25 | Sumner | Tennessee | 47165 | 4794 | 97 |
569405 | 569405 | 2020-09-25 | Tipton | Tennessee | 47167 | 1805 | 19 |
569406 | 569406 | 2020-09-25 | Trousdale | Tennessee | 47169 | 1653 | 7 |
569407 | 569407 | 2020-09-25 | Unicoi | Tennessee | 47171 | 285 | 1 |
569408 | 569408 | 2020-09-25 | Union | Tennessee | 47173 | 353 | 1 |
569409 | 569409 | 2020-09-25 | Unknown | Tennessee | 0 | 1 | |
569410 | 569410 | 2020-09-25 | Van Buren | Tennessee | 47175 | 164 | 0 |
569411 | 569411 | 2020-09-25 | Warren | Tennessee | 47177 | 1047 | 7 |
569412 | 569412 | 2020-09-25 | Washington | Tennessee | 47179 | 2276 | 35 |
569413 | 569413 | 2020-09-25 | Wayne | Tennessee | 47181 | 1495 | 5 |
569414 | 569414 | 2020-09-25 | Weakley | Tennessee | 47183 | 1176 | 19 |
569415 | 569415 | 2020-09-25 | White | Tennessee | 47185 | 830 | 9 |
569416 | 569416 | 2020-09-25 | Williamson | Tennessee | 47187 | 5198 | 36 |
569417 | 569417 | 2020-09-25 | Wilson | Tennessee | 47189 | 3453 | 44 |
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);