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-04 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
501358 | 501358 | 2020-09-04 | Anderson | Tennessee | 47001 | 920 | 8 |
501359 | 501359 | 2020-09-04 | Bedford | Tennessee | 47003 | 1144 | 14 |
501360 | 501360 | 2020-09-04 | Benton | Tennessee | 47005 | 278 | 6 |
501361 | 501361 | 2020-09-04 | Bledsoe | Tennessee | 47007 | 797 | 4 |
501362 | 501362 | 2020-09-04 | Blount | Tennessee | 47009 | 2111 | 17 |
501363 | 501363 | 2020-09-04 | Bradley | Tennessee | 47011 | 2535 | 16 |
501364 | 501364 | 2020-09-04 | Campbell | Tennessee | 47013 | 351 | 3 |
501365 | 501365 | 2020-09-04 | Cannon | Tennessee | 47015 | 222 | 0 |
501366 | 501366 | 2020-09-04 | Carroll | Tennessee | 47017 | 667 | 9 |
501367 | 501367 | 2020-09-04 | Carter | Tennessee | 47019 | 959 | 24 |
501368 | 501368 | 2020-09-04 | Cheatham | Tennessee | 47021 | 718 | 10 |
501369 | 501369 | 2020-09-04 | Chester | Tennessee | 47023 | 441 | 6 |
501370 | 501370 | 2020-09-04 | Claiborne | Tennessee | 47025 | 368 | 3 |
501371 | 501371 | 2020-09-04 | Clay | Tennessee | 47027 | 129 | 2 |
501372 | 501372 | 2020-09-04 | Cocke | Tennessee | 47029 | 655 | 7 |
501373 | 501373 | 2020-09-04 | Coffee | Tennessee | 47031 | 790 | 6 |
501374 | 501374 | 2020-09-04 | Crockett | Tennessee | 47033 | 417 | 14 |
501375 | 501375 | 2020-09-04 | Cumberland | Tennessee | 47035 | 970 | 9 |
501376 | 501376 | 2020-09-04 | Davidson | Tennessee | 47037 | 26279 | 261 |
501377 | 501377 | 2020-09-04 | DeKalb | Tennessee | 47041 | 498 | 6 |
501378 | 501378 | 2020-09-04 | Decatur | Tennessee | 47039 | 332 | 4 |
501379 | 501379 | 2020-09-04 | Dickson | Tennessee | 47043 | 970 | 9 |
501380 | 501380 | 2020-09-04 | Dyer | Tennessee | 47045 | 1025 | 10 |
501381 | 501381 | 2020-09-04 | Fayette | Tennessee | 47047 | 976 | 11 |
501382 | 501382 | 2020-09-04 | Fentress | Tennessee | 47049 | 278 | 0 |
501383 | 501383 | 2020-09-04 | Franklin | Tennessee | 47051 | 574 | 4 |
501384 | 501384 | 2020-09-04 | Gibson | Tennessee | 47053 | 1152 | 16 |
501385 | 501385 | 2020-09-04 | Giles | Tennessee | 47055 | 467 | 15 |
501386 | 501386 | 2020-09-04 | Grainger | Tennessee | 47057 | 291 | 1 |
501387 | 501387 | 2020-09-04 | Greene | Tennessee | 47059 | 890 | 18 |
501388 | 501388 | 2020-09-04 | Grundy | Tennessee | 47061 | 152 | 3 |
501389 | 501389 | 2020-09-04 | Hamblen | Tennessee | 47063 | 1675 | 22 |
501390 | 501390 | 2020-09-04 | Hamilton | Tennessee | 47065 | 8326 | 78 |
501391 | 501391 | 2020-09-04 | Hancock | Tennessee | 47067 | 97 | 2 |
501392 | 501392 | 2020-09-04 | Hardeman | Tennessee | 47069 | 1277 | 22 |
501393 | 501393 | 2020-09-04 | Hardin | Tennessee | 47071 | 772 | 12 |
501394 | 501394 | 2020-09-04 | Hawkins | Tennessee | 47073 | 684 | 13 |
501395 | 501395 | 2020-09-04 | Haywood | Tennessee | 47075 | 787 | 12 |
501396 | 501396 | 2020-09-04 | Henderson | Tennessee | 47077 | 940 | 10 |
501397 | 501397 | 2020-09-04 | Henry | Tennessee | 47079 | 513 | 7 |
501398 | 501398 | 2020-09-04 | Hickman | Tennessee | 47081 | 399 | 4 |
501399 | 501399 | 2020-09-04 | Houston | Tennessee | 47083 | 113 | 0 |
501400 | 501400 | 2020-09-04 | Humphreys | Tennessee | 47085 | 173 | 3 |
501401 | 501401 | 2020-09-04 | Jackson | Tennessee | 47087 | 258 | 2 |
501402 | 501402 | 2020-09-04 | Jefferson | Tennessee | 47089 | 859 | 7 |
501403 | 501403 | 2020-09-04 | Johnson | Tennessee | 47091 | 430 | 1 |
501404 | 501404 | 2020-09-04 | Knox | Tennessee | 47093 | 7283 | 64 |
501405 | 501405 | 2020-09-04 | Lake | Tennessee | 47095 | 844 | 2 |
501406 | 501406 | 2020-09-04 | Lauderdale | Tennessee | 47097 | 733 | 12 |
501407 | 501407 | 2020-09-04 | Lawrence | Tennessee | 47099 | 768 | 9 |
501408 | 501408 | 2020-09-04 | Lewis | Tennessee | 47101 | 146 | 1 |
501409 | 501409 | 2020-09-04 | Lincoln | Tennessee | 47103 | 438 | 1 |
501410 | 501410 | 2020-09-04 | Loudon | Tennessee | 47105 | 955 | 4 |
501411 | 501411 | 2020-09-04 | Macon | Tennessee | 47111 | 935 | 16 |
501412 | 501412 | 2020-09-04 | Madison | Tennessee | 47113 | 1988 | 46 |
501413 | 501413 | 2020-09-04 | Marion | Tennessee | 47115 | 361 | 7 |
501414 | 501414 | 2020-09-04 | Marshall | Tennessee | 47117 | 576 | 4 |
501415 | 501415 | 2020-09-04 | Maury | Tennessee | 47119 | 1831 | 17 |
501416 | 501416 | 2020-09-04 | McMinn | Tennessee | 47107 | 840 | 23 |
501417 | 501417 | 2020-09-04 | McNairy | Tennessee | 47109 | 610 | 13 |
501418 | 501418 | 2020-09-04 | Meigs | Tennessee | 47121 | 171 | 2 |
501419 | 501419 | 2020-09-04 | Monroe | Tennessee | 47123 | 848 | 15 |
501420 | 501420 | 2020-09-04 | Montgomery | Tennessee | 47125 | 2555 | 30 |
501421 | 501421 | 2020-09-04 | Moore | Tennessee | 47127 | 115 | 1 |
501422 | 501422 | 2020-09-04 | Morgan | Tennessee | 47129 | 255 | 2 |
501423 | 501423 | 2020-09-04 | Obion | Tennessee | 47131 | 908 | 8 |
501424 | 501424 | 2020-09-04 | Overton | Tennessee | 47133 | 519 | 2 |
501425 | 501425 | 2020-09-04 | Perry | Tennessee | 47135 | 117 | 0 |
501426 | 501426 | 2020-09-04 | Pickett | Tennessee | 47137 | 73 | 1 |
501427 | 501427 | 2020-09-04 | Polk | Tennessee | 47139 | 344 | 10 |
501428 | 501428 | 2020-09-04 | Putnam | Tennessee | 47141 | 2415 | 29 |
501429 | 501429 | 2020-09-04 | Rhea | Tennessee | 47143 | 663 | 5 |
501430 | 501430 | 2020-09-04 | Roane | Tennessee | 47145 | 669 | 2 |
501431 | 501431 | 2020-09-04 | Robertson | Tennessee | 47147 | 1956 | 29 |
501432 | 501432 | 2020-09-04 | Rutherford | Tennessee | 47149 | 8059 | 77 |
501433 | 501433 | 2020-09-04 | Scott | Tennessee | 47151 | 166 | 2 |
501434 | 501434 | 2020-09-04 | Sequatchie | Tennessee | 47153 | 168 | 2 |
501435 | 501435 | 2020-09-04 | Sevier | Tennessee | 47155 | 2302 | 13 |
501436 | 501436 | 2020-09-04 | Shelby | Tennessee | 47157 | 27975 | 398 |
501437 | 501437 | 2020-09-04 | Smith | Tennessee | 47159 | 559 | 8 |
501438 | 501438 | 2020-09-04 | Stewart | Tennessee | 47161 | 103 | 0 |
501439 | 501439 | 2020-09-04 | Sullivan | Tennessee | 47163 | 1820 | 26 |
501440 | 501440 | 2020-09-04 | Sumner | Tennessee | 47165 | 4220 | 87 |
501441 | 501441 | 2020-09-04 | Tipton | Tennessee | 47167 | 1522 | 15 |
501442 | 501442 | 2020-09-04 | Trousdale | Tennessee | 47169 | 1630 | 7 |
501443 | 501443 | 2020-09-04 | Unicoi | Tennessee | 47171 | 232 | 1 |
501444 | 501444 | 2020-09-04 | Union | Tennessee | 47173 | 245 | 1 |
501445 | 501445 | 2020-09-04 | Unknown | Tennessee | 332 | 6 | |
501446 | 501446 | 2020-09-04 | Van Buren | Tennessee | 47175 | 104 | 0 |
501447 | 501447 | 2020-09-04 | Warren | Tennessee | 47177 | 894 | 7 |
501448 | 501448 | 2020-09-04 | Washington | Tennessee | 47179 | 1773 | 14 |
501449 | 501449 | 2020-09-04 | Wayne | Tennessee | 47181 | 1485 | 2 |
501450 | 501450 | 2020-09-04 | Weakley | Tennessee | 47183 | 939 | 13 |
501451 | 501451 | 2020-09-04 | White | Tennessee | 47185 | 608 | 7 |
501452 | 501452 | 2020-09-04 | Williamson | Tennessee | 47187 | 4455 | 30 |
501453 | 501453 | 2020-09-04 | Wilson | Tennessee | 47189 | 2954 | 31 |
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);