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-04-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 |
---|---|---|---|---|---|---|---|
1192388 | 1192388 | 2021-04-05 | Anderson | Tennessee | 47001 | 8493 | 166 |
1192389 | 1192389 | 2021-04-05 | Bedford | Tennessee | 47003 | 6295 | 125 |
1192390 | 1192390 | 2021-04-05 | Benton | Tennessee | 47005 | 1594 | 40 |
1192391 | 1192391 | 2021-04-05 | Bledsoe | Tennessee | 47007 | 2075 | 11 |
1192392 | 1192392 | 2021-04-05 | Blount | Tennessee | 47009 | 14762 | 194 |
1192393 | 1192393 | 2021-04-05 | Bradley | Tennessee | 47011 | 14153 | 145 |
1192394 | 1192394 | 2021-04-05 | Campbell | Tennessee | 47013 | 4033 | 62 |
1192395 | 1192395 | 2021-04-05 | Cannon | Tennessee | 47015 | 1865 | 31 |
1192396 | 1192396 | 2021-04-05 | Carroll | Tennessee | 47017 | 3546 | 82 |
1192397 | 1192397 | 2021-04-05 | Carter | Tennessee | 47019 | 6265 | 156 |
1192398 | 1192398 | 2021-04-05 | Cheatham | Tennessee | 47021 | 4316 | 50 |
1192399 | 1192399 | 2021-04-05 | Chester | Tennessee | 47023 | 2080 | 48 |
1192400 | 1192400 | 2021-04-05 | Claiborne | Tennessee | 47025 | 2998 | 74 |
1192401 | 1192401 | 2021-04-05 | Clay | Tennessee | 47027 | 1080 | 31 |
1192402 | 1192402 | 2021-04-05 | Cocke | Tennessee | 47029 | 4370 | 98 |
1192403 | 1192403 | 2021-04-05 | Coffee | Tennessee | 47031 | 6741 | 120 |
1192404 | 1192404 | 2021-04-05 | Crockett | Tennessee | 47033 | 1987 | 48 |
1192405 | 1192405 | 2021-04-05 | Cumberland | Tennessee | 47035 | 6412 | 125 |
1192406 | 1192406 | 2021-04-05 | Davidson | Tennessee | 47037 | 95125 | 907 |
1192407 | 1192407 | 2021-04-05 | DeKalb | Tennessee | 47041 | 2735 | 53 |
1192408 | 1192408 | 2021-04-05 | Decatur | Tennessee | 47039 | 1564 | 38 |
1192409 | 1192409 | 2021-04-05 | Dickson | Tennessee | 47043 | 6578 | 107 |
1192410 | 1192410 | 2021-04-05 | Dyer | Tennessee | 47045 | 5327 | 103 |
1192411 | 1192411 | 2021-04-05 | Fayette | Tennessee | 47047 | 4823 | 77 |
1192412 | 1192412 | 2021-04-05 | Fentress | Tennessee | 47049 | 2354 | 45 |
1192413 | 1192413 | 2021-04-05 | Franklin | Tennessee | 47051 | 5024 | 87 |
1192414 | 1192414 | 2021-04-05 | Gibson | Tennessee | 47053 | 6326 | 143 |
1192415 | 1192415 | 2021-04-05 | Giles | Tennessee | 47055 | 3882 | 98 |
1192416 | 1192416 | 2021-04-05 | Grainger | Tennessee | 47057 | 2535 | 48 |
1192417 | 1192417 | 2021-04-05 | Greene | Tennessee | 47059 | 7589 | 151 |
1192418 | 1192418 | 2021-04-05 | Grundy | Tennessee | 47061 | 1754 | 31 |
1192419 | 1192419 | 2021-04-05 | Hamblen | Tennessee | 47063 | 8387 | 170 |
1192420 | 1192420 | 2021-04-05 | Hamilton | Tennessee | 47065 | 42805 | 479 |
1192421 | 1192421 | 2021-04-05 | Hancock | Tennessee | 47067 | 529 | 12 |
1192422 | 1192422 | 2021-04-05 | Hardeman | Tennessee | 47069 | 3435 | 63 |
1192423 | 1192423 | 2021-04-05 | Hardin | Tennessee | 47071 | 3438 | 66 |
1192424 | 1192424 | 2021-04-05 | Hawkins | Tennessee | 47073 | 5610 | 104 |
1192425 | 1192425 | 2021-04-05 | Haywood | Tennessee | 47075 | 2675 | 60 |
1192426 | 1192426 | 2021-04-05 | Henderson | Tennessee | 47077 | 3672 | 74 |
1192427 | 1192427 | 2021-04-05 | Henry | Tennessee | 47079 | 3083 | 75 |
1192428 | 1192428 | 2021-04-05 | Hickman | Tennessee | 47081 | 2764 | 43 |
1192429 | 1192429 | 2021-04-05 | Houston | Tennessee | 47083 | 1066 | 33 |
1192430 | 1192430 | 2021-04-05 | Humphreys | Tennessee | 47085 | 1650 | 21 |
1192431 | 1192431 | 2021-04-05 | Jackson | Tennessee | 47087 | 1290 | 35 |
1192432 | 1192432 | 2021-04-05 | Jefferson | Tennessee | 47089 | 5971 | 121 |
1192433 | 1192433 | 2021-04-05 | Johnson | Tennessee | 47091 | 2234 | 38 |
1192434 | 1192434 | 2021-04-05 | Knox | Tennessee | 47093 | 49854 | 621 |
1192435 | 1192435 | 2021-04-05 | Lake | Tennessee | 47095 | 1693 | 26 |
1192436 | 1192436 | 2021-04-05 | Lauderdale | Tennessee | 47097 | 3121 | 44 |
1192437 | 1192437 | 2021-04-05 | Lawrence | Tennessee | 47099 | 5717 | 86 |
1192438 | 1192438 | 2021-04-05 | Lewis | Tennessee | 47101 | 1540 | 25 |
1192439 | 1192439 | 2021-04-05 | Lincoln | Tennessee | 47103 | 4264 | 63 |
1192440 | 1192440 | 2021-04-05 | Loudon | Tennessee | 47105 | 5921 | 69 |
1192441 | 1192441 | 2021-04-05 | Macon | Tennessee | 47111 | 3521 | 74 |
1192442 | 1192442 | 2021-04-05 | Madison | Tennessee | 47113 | 10562 | 238 |
1192443 | 1192443 | 2021-04-05 | Marion | Tennessee | 47115 | 3065 | 46 |
1192444 | 1192444 | 2021-04-05 | Marshall | Tennessee | 47117 | 4050 | 57 |
1192445 | 1192445 | 2021-04-05 | Maury | Tennessee | 47119 | 12790 | 162 |
1192446 | 1192446 | 2021-04-05 | McMinn | Tennessee | 47107 | 6233 | 96 |
1192447 | 1192447 | 2021-04-05 | McNairy | Tennessee | 47109 | 2746 | 54 |
1192448 | 1192448 | 2021-04-05 | Meigs | Tennessee | 47121 | 1318 | 23 |
1192449 | 1192449 | 2021-04-05 | Monroe | Tennessee | 47123 | 5599 | 95 |
1192450 | 1192450 | 2021-04-05 | Montgomery | Tennessee | 47125 | 18617 | 221 |
1192451 | 1192451 | 2021-04-05 | Moore | Tennessee | 47127 | 990 | 17 |
1192452 | 1192452 | 2021-04-05 | Morgan | Tennessee | 47129 | 2409 | 39 |
1192453 | 1192453 | 2021-04-05 | Obion | Tennessee | 47131 | 4453 | 96 |
1192454 | 1192454 | 2021-04-05 | Overton | Tennessee | 47133 | 2939 | 60 |
1192455 | 1192455 | 2021-04-05 | Perry | Tennessee | 47135 | 1056 | 28 |
1192456 | 1192456 | 2021-04-05 | Pickett | Tennessee | 47137 | 754 | 24 |
1192457 | 1192457 | 2021-04-05 | Polk | Tennessee | 47139 | 1940 | 24 |
1192458 | 1192458 | 2021-04-05 | Putnam | Tennessee | 47141 | 11032 | 173 |
1192459 | 1192459 | 2021-04-05 | Rhea | Tennessee | 47143 | 4271 | 75 |
1192460 | 1192460 | 2021-04-05 | Roane | Tennessee | 47145 | 6098 | 100 |
1192461 | 1192461 | 2021-04-05 | Robertson | Tennessee | 47147 | 9444 | 127 |
1192462 | 1192462 | 2021-04-05 | Rutherford | Tennessee | 47149 | 41160 | 411 |
1192463 | 1192463 | 2021-04-05 | Scott | Tennessee | 47151 | 3011 | 45 |
1192464 | 1192464 | 2021-04-05 | Sequatchie | Tennessee | 47153 | 1643 | 29 |
1192465 | 1192465 | 2021-04-05 | Sevier | Tennessee | 47155 | 12917 | 172 |
1192466 | 1192466 | 2021-04-05 | Shelby | Tennessee | 47157 | 91792 | 1574 |
1192467 | 1192467 | 2021-04-05 | Smith | Tennessee | 47159 | 2700 | 37 |
1192468 | 1192468 | 2021-04-05 | Stewart | Tennessee | 47161 | 1288 | 27 |
1192469 | 1192469 | 2021-04-05 | Sullivan | Tennessee | 47163 | 15582 | 281 |
1192470 | 1192470 | 2021-04-05 | Sumner | Tennessee | 47165 | 22742 | 337 |
1192471 | 1192471 | 2021-04-05 | Tipton | Tennessee | 47167 | 7145 | 104 |
1192472 | 1192472 | 2021-04-05 | Trousdale | Tennessee | 47169 | 2467 | 22 |
1192473 | 1192473 | 2021-04-05 | Unicoi | Tennessee | 47171 | 1888 | 49 |
1192474 | 1192474 | 2021-04-05 | Union | Tennessee | 47173 | 1828 | 34 |
1192475 | 1192475 | 2021-04-05 | Unknown | Tennessee | 8791 | 121 | |
1192476 | 1192476 | 2021-04-05 | Van Buren | Tennessee | 47175 | 819 | 21 |
1192477 | 1192477 | 2021-04-05 | Warren | Tennessee | 47177 | 5474 | 80 |
1192478 | 1192478 | 2021-04-05 | Washington | Tennessee | 47179 | 13660 | 239 |
1192479 | 1192479 | 2021-04-05 | Wayne | Tennessee | 47181 | 2940 | 33 |
1192480 | 1192480 | 2021-04-05 | Weakley | Tennessee | 47183 | 3963 | 61 |
1192481 | 1192481 | 2021-04-05 | White | Tennessee | 47185 | 3496 | 68 |
1192482 | 1192482 | 2021-04-05 | Williamson | Tennessee | 47187 | 26790 | 213 |
1192483 | 1192483 | 2021-04-05 | Wilson | Tennessee | 47189 | 17645 | 219 |
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);