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-06-13 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1416410 | 1416410 | 2021-06-13 | Anderson | Tennessee | 47001 | 8847 | 172 |
1416411 | 1416411 | 2021-06-13 | Bedford | Tennessee | 47003 | 6694 | 131 |
1416412 | 1416412 | 2021-06-13 | Benton | Tennessee | 47005 | 1687 | 42 |
1416413 | 1416413 | 2021-06-13 | Bledsoe | Tennessee | 47007 | 2198 | 11 |
1416414 | 1416414 | 2021-06-13 | Blount | Tennessee | 47009 | 15813 | 196 |
1416415 | 1416415 | 2021-06-13 | Bradley | Tennessee | 47011 | 15298 | 153 |
1416416 | 1416416 | 2021-06-13 | Campbell | Tennessee | 47013 | 4205 | 63 |
1416417 | 1416417 | 2021-06-13 | Cannon | Tennessee | 47015 | 1942 | 32 |
1416418 | 1416418 | 2021-06-13 | Carroll | Tennessee | 47017 | 3715 | 83 |
1416419 | 1416419 | 2021-06-13 | Carter | Tennessee | 47019 | 6717 | 159 |
1416420 | 1416420 | 2021-06-13 | Cheatham | Tennessee | 47021 | 4662 | 56 |
1416421 | 1416421 | 2021-06-13 | Chester | Tennessee | 47023 | 2183 | 51 |
1416422 | 1416422 | 2021-06-13 | Claiborne | Tennessee | 47025 | 3226 | 74 |
1416423 | 1416423 | 2021-06-13 | Clay | Tennessee | 47027 | 1107 | 31 |
1416424 | 1416424 | 2021-06-13 | Cocke | Tennessee | 47029 | 4548 | 100 |
1416425 | 1416425 | 2021-06-13 | Coffee | Tennessee | 47031 | 6987 | 125 |
1416426 | 1416426 | 2021-06-13 | Crockett | Tennessee | 47033 | 2063 | 50 |
1416427 | 1416427 | 2021-06-13 | Cumberland | Tennessee | 47035 | 6868 | 140 |
1416428 | 1416428 | 2021-06-13 | Davidson | Tennessee | 47037 | 99485 | 960 |
1416429 | 1416429 | 2021-06-13 | DeKalb | Tennessee | 47041 | 2859 | 55 |
1416430 | 1416430 | 2021-06-13 | Decatur | Tennessee | 47039 | 1620 | 39 |
1416431 | 1416431 | 2021-06-13 | Dickson | Tennessee | 47043 | 7073 | 116 |
1416432 | 1416432 | 2021-06-13 | Dyer | Tennessee | 47045 | 5510 | 108 |
1416433 | 1416433 | 2021-06-13 | Fayette | Tennessee | 47047 | 5176 | 84 |
1416434 | 1416434 | 2021-06-13 | Fentress | Tennessee | 47049 | 2516 | 49 |
1416435 | 1416435 | 2021-06-13 | Franklin | Tennessee | 47051 | 5230 | 91 |
1416436 | 1416436 | 2021-06-13 | Gibson | Tennessee | 47053 | 6677 | 148 |
1416437 | 1416437 | 2021-06-13 | Giles | Tennessee | 47055 | 4040 | 100 |
1416438 | 1416438 | 2021-06-13 | Grainger | Tennessee | 47057 | 2663 | 49 |
1416439 | 1416439 | 2021-06-13 | Greene | Tennessee | 47059 | 8002 | 159 |
1416440 | 1416440 | 2021-06-13 | Grundy | Tennessee | 47061 | 1802 | 35 |
1416441 | 1416441 | 2021-06-13 | Hamblen | Tennessee | 47063 | 8690 | 174 |
1416442 | 1416442 | 2021-06-13 | Hamilton | Tennessee | 47065 | 45287 | 504 |
1416443 | 1416443 | 2021-06-13 | Hancock | Tennessee | 47067 | 607 | 13 |
1416444 | 1416444 | 2021-06-13 | Hardeman | Tennessee | 47069 | 3562 | 65 |
1416445 | 1416445 | 2021-06-13 | Hardin | Tennessee | 47071 | 3607 | 69 |
1416446 | 1416446 | 2021-06-13 | Hawkins | Tennessee | 47073 | 6325 | 113 |
1416447 | 1416447 | 2021-06-13 | Haywood | Tennessee | 47075 | 2717 | 62 |
1416448 | 1416448 | 2021-06-13 | Henderson | Tennessee | 47077 | 3868 | 78 |
1416449 | 1416449 | 2021-06-13 | Henry | Tennessee | 47079 | 3381 | 76 |
1416450 | 1416450 | 2021-06-13 | Hickman | Tennessee | 47081 | 2885 | 47 |
1416451 | 1416451 | 2021-06-13 | Houston | Tennessee | 47083 | 1119 | 33 |
1416452 | 1416452 | 2021-06-13 | Humphreys | Tennessee | 47085 | 1927 | 28 |
1416453 | 1416453 | 2021-06-13 | Jackson | Tennessee | 47087 | 1354 | 36 |
1416454 | 1416454 | 2021-06-13 | Jefferson | Tennessee | 47089 | 6326 | 127 |
1416455 | 1416455 | 2021-06-13 | Johnson | Tennessee | 47091 | 2439 | 39 |
1416456 | 1416456 | 2021-06-13 | Knox | Tennessee | 47093 | 52113 | 642 |
1416457 | 1416457 | 2021-06-13 | Lake | Tennessee | 47095 | 1728 | 27 |
1416458 | 1416458 | 2021-06-13 | Lauderdale | Tennessee | 47097 | 3272 | 48 |
1416459 | 1416459 | 2021-06-13 | Lawrence | Tennessee | 47099 | 6105 | 94 |
1416460 | 1416460 | 2021-06-13 | Lewis | Tennessee | 47101 | 1618 | 26 |
1416461 | 1416461 | 2021-06-13 | Lincoln | Tennessee | 47103 | 4394 | 67 |
1416462 | 1416462 | 2021-06-13 | Loudon | Tennessee | 47105 | 6260 | 70 |
1416463 | 1416463 | 2021-06-13 | Macon | Tennessee | 47111 | 3671 | 78 |
1416464 | 1416464 | 2021-06-13 | Madison | Tennessee | 47113 | 11545 | 244 |
1416465 | 1416465 | 2021-06-13 | Marion | Tennessee | 47115 | 3217 | 47 |
1416466 | 1416466 | 2021-06-13 | Marshall | Tennessee | 47117 | 4306 | 60 |
1416467 | 1416467 | 2021-06-13 | Maury | Tennessee | 47119 | 13721 | 178 |
1416468 | 1416468 | 2021-06-13 | McMinn | Tennessee | 47107 | 6612 | 101 |
1416469 | 1416469 | 2021-06-13 | McNairy | Tennessee | 47109 | 2871 | 55 |
1416470 | 1416470 | 2021-06-13 | Meigs | Tennessee | 47121 | 1420 | 25 |
1416471 | 1416471 | 2021-06-13 | Monroe | Tennessee | 47123 | 6015 | 97 |
1416472 | 1416472 | 2021-06-13 | Montgomery | Tennessee | 47125 | 20907 | 231 |
1416473 | 1416473 | 2021-06-13 | Moore | Tennessee | 47127 | 1024 | 17 |
1416474 | 1416474 | 2021-06-13 | Morgan | Tennessee | 47129 | 2533 | 38 |
1416475 | 1416475 | 2021-06-13 | Obion | Tennessee | 47131 | 4623 | 97 |
1416476 | 1416476 | 2021-06-13 | Overton | Tennessee | 47133 | 3059 | 61 |
1416477 | 1416477 | 2021-06-13 | Perry | Tennessee | 47135 | 1076 | 28 |
1416478 | 1416478 | 2021-06-13 | Pickett | Tennessee | 47137 | 764 | 24 |
1416479 | 1416479 | 2021-06-13 | Polk | Tennessee | 47139 | 2112 | 25 |
1416480 | 1416480 | 2021-06-13 | Putnam | Tennessee | 47141 | 11904 | 180 |
1416481 | 1416481 | 2021-06-13 | Rhea | Tennessee | 47143 | 4402 | 75 |
1416482 | 1416482 | 2021-06-13 | Roane | Tennessee | 47145 | 6362 | 105 |
1416483 | 1416483 | 2021-06-13 | Robertson | Tennessee | 47147 | 9929 | 132 |
1416484 | 1416484 | 2021-06-13 | Rutherford | Tennessee | 47149 | 43601 | 444 |
1416485 | 1416485 | 2021-06-13 | Scott | Tennessee | 47151 | 3219 | 45 |
1416486 | 1416486 | 2021-06-13 | Sequatchie | Tennessee | 47153 | 1745 | 29 |
1416487 | 1416487 | 2021-06-13 | Sevier | Tennessee | 47155 | 13549 | 176 |
1416488 | 1416488 | 2021-06-13 | Shelby | Tennessee | 47157 | 99323 | 1681 |
1416489 | 1416489 | 2021-06-13 | Smith | Tennessee | 47159 | 2812 | 40 |
1416490 | 1416490 | 2021-06-13 | Stewart | Tennessee | 47161 | 1367 | 28 |
1416491 | 1416491 | 2021-06-13 | Sullivan | Tennessee | 47163 | 17280 | 304 |
1416492 | 1416492 | 2021-06-13 | Sumner | Tennessee | 47165 | 24449 | 352 |
1416493 | 1416493 | 2021-06-13 | Tipton | Tennessee | 47167 | 7465 | 105 |
1416494 | 1416494 | 2021-06-13 | Trousdale | Tennessee | 47169 | 2537 | 22 |
1416495 | 1416495 | 2021-06-13 | Unicoi | Tennessee | 47171 | 2057 | 49 |
1416496 | 1416496 | 2021-06-13 | Union | Tennessee | 47173 | 1959 | 34 |
1416497 | 1416497 | 2021-06-13 | Unknown | Tennessee | 7525 | 91 | |
1416498 | 1416498 | 2021-06-13 | Van Buren | Tennessee | 47175 | 866 | 23 |
1416499 | 1416499 | 2021-06-13 | Warren | Tennessee | 47177 | 5610 | 86 |
1416500 | 1416500 | 2021-06-13 | Washington | Tennessee | 47179 | 14842 | 251 |
1416501 | 1416501 | 2021-06-13 | Wayne | Tennessee | 47181 | 2996 | 35 |
1416502 | 1416502 | 2021-06-13 | Weakley | Tennessee | 47183 | 4220 | 67 |
1416503 | 1416503 | 2021-06-13 | White | Tennessee | 47185 | 3811 | 74 |
1416504 | 1416504 | 2021-06-13 | Williamson | Tennessee | 47187 | 28595 | 221 |
1416505 | 1416505 | 2021-06-13 | Wilson | Tennessee | 47189 | 19308 | 243 |
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);