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-08-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 |
---|---|---|---|---|---|---|---|
1614477 | 1614477 | 2021-08-13 | Anderson | Tennessee | 47001 | 9360 | 179 |
1614478 | 1614478 | 2021-08-13 | Bedford | Tennessee | 47003 | 7074 | 135 |
1614479 | 1614479 | 2021-08-13 | Benton | Tennessee | 47005 | 1858 | 41 |
1614480 | 1614480 | 2021-08-13 | Bledsoe | Tennessee | 47007 | 2421 | 13 |
1614481 | 1614481 | 2021-08-13 | Blount | Tennessee | 47009 | 17221 | 208 |
1614482 | 1614482 | 2021-08-13 | Bradley | Tennessee | 47011 | 16365 | 158 |
1614483 | 1614483 | 2021-08-13 | Campbell | Tennessee | 47013 | 4460 | 64 |
1614484 | 1614484 | 2021-08-13 | Cannon | Tennessee | 47015 | 2055 | 32 |
1614485 | 1614485 | 2021-08-13 | Carroll | Tennessee | 47017 | 3956 | 84 |
1614486 | 1614486 | 2021-08-13 | Carter | Tennessee | 47019 | 7245 | 168 |
1614487 | 1614487 | 2021-08-13 | Cheatham | Tennessee | 47021 | 4958 | 56 |
1614488 | 1614488 | 2021-08-13 | Chester | Tennessee | 47023 | 2462 | 51 |
1614489 | 1614489 | 2021-08-13 | Claiborne | Tennessee | 47025 | 3430 | 77 |
1614490 | 1614490 | 2021-08-13 | Clay | Tennessee | 47027 | 1141 | 30 |
1614491 | 1614491 | 2021-08-13 | Cocke | Tennessee | 47029 | 4964 | 102 |
1614492 | 1614492 | 2021-08-13 | Coffee | Tennessee | 47031 | 7332 | 123 |
1614493 | 1614493 | 2021-08-13 | Crockett | Tennessee | 47033 | 2406 | 52 |
1614494 | 1614494 | 2021-08-13 | Cumberland | Tennessee | 47035 | 7548 | 146 |
1614495 | 1614495 | 2021-08-13 | Davidson | Tennessee | 47037 | 106203 | 980 |
1614496 | 1614496 | 2021-08-13 | DeKalb | Tennessee | 47041 | 3012 | 57 |
1614497 | 1614497 | 2021-08-13 | Decatur | Tennessee | 47039 | 1746 | 39 |
1614498 | 1614498 | 2021-08-13 | Dickson | Tennessee | 47043 | 7572 | 118 |
1614499 | 1614499 | 2021-08-13 | Dyer | Tennessee | 47045 | 5890 | 110 |
1614500 | 1614500 | 2021-08-13 | Fayette | Tennessee | 47047 | 5738 | 85 |
1614501 | 1614501 | 2021-08-13 | Fentress | Tennessee | 47049 | 2647 | 49 |
1614502 | 1614502 | 2021-08-13 | Franklin | Tennessee | 47051 | 5704 | 92 |
1614503 | 1614503 | 2021-08-13 | Gibson | Tennessee | 47053 | 7499 | 152 |
1614504 | 1614504 | 2021-08-13 | Giles | Tennessee | 47055 | 4324 | 100 |
1614505 | 1614505 | 2021-08-13 | Grainger | Tennessee | 47057 | 2877 | 51 |
1614506 | 1614506 | 2021-08-13 | Greene | Tennessee | 47059 | 8686 | 163 |
1614507 | 1614507 | 2021-08-13 | Grundy | Tennessee | 47061 | 1961 | 35 |
1614508 | 1614508 | 2021-08-13 | Hamblen | Tennessee | 47063 | 9552 | 177 |
1614509 | 1614509 | 2021-08-13 | Hamilton | Tennessee | 47065 | 49961 | 529 |
1614510 | 1614510 | 2021-08-13 | Hancock | Tennessee | 47067 | 697 | 13 |
1614511 | 1614511 | 2021-08-13 | Hardeman | Tennessee | 47069 | 3872 | 65 |
1614512 | 1614512 | 2021-08-13 | Hardin | Tennessee | 47071 | 3926 | 70 |
1614513 | 1614513 | 2021-08-13 | Hawkins | Tennessee | 47073 | 6874 | 124 |
1614514 | 1614514 | 2021-08-13 | Haywood | Tennessee | 47075 | 2960 | 62 |
1614515 | 1614515 | 2021-08-13 | Henderson | Tennessee | 47077 | 4104 | 79 |
1614516 | 1614516 | 2021-08-13 | Henry | Tennessee | 47079 | 3824 | 76 |
1614517 | 1614517 | 2021-08-13 | Hickman | Tennessee | 47081 | 3132 | 48 |
1614518 | 1614518 | 2021-08-13 | Houston | Tennessee | 47083 | 1270 | 34 |
1614519 | 1614519 | 2021-08-13 | Humphreys | Tennessee | 47085 | 2154 | 32 |
1614520 | 1614520 | 2021-08-13 | Jackson | Tennessee | 47087 | 1430 | 37 |
1614521 | 1614521 | 2021-08-13 | Jefferson | Tennessee | 47089 | 6848 | 129 |
1614522 | 1614522 | 2021-08-13 | Johnson | Tennessee | 47091 | 2570 | 39 |
1614523 | 1614523 | 2021-08-13 | Knox | Tennessee | 47093 | 55617 | 669 |
1614524 | 1614524 | 2021-08-13 | Lake | Tennessee | 47095 | 1753 | 31 |
1614525 | 1614525 | 2021-08-13 | Lauderdale | Tennessee | 47097 | 3561 | 50 |
1614526 | 1614526 | 2021-08-13 | Lawrence | Tennessee | 47099 | 6575 | 101 |
1614527 | 1614527 | 2021-08-13 | Lewis | Tennessee | 47101 | 1788 | 27 |
1614528 | 1614528 | 2021-08-13 | Lincoln | Tennessee | 47103 | 4816 | 69 |
1614529 | 1614529 | 2021-08-13 | Loudon | Tennessee | 47105 | 6653 | 71 |
1614530 | 1614530 | 2021-08-13 | Macon | Tennessee | 47111 | 3931 | 78 |
1614531 | 1614531 | 2021-08-13 | Madison | Tennessee | 47113 | 12885 | 251 |
1614532 | 1614532 | 2021-08-13 | Marion | Tennessee | 47115 | 3590 | 50 |
1614533 | 1614533 | 2021-08-13 | Marshall | Tennessee | 47117 | 4703 | 65 |
1614534 | 1614534 | 2021-08-13 | Maury | Tennessee | 47119 | 14718 | 181 |
1614535 | 1614535 | 2021-08-13 | McMinn | Tennessee | 47107 | 7248 | 108 |
1614536 | 1614536 | 2021-08-13 | McNairy | Tennessee | 47109 | 3200 | 57 |
1614537 | 1614537 | 2021-08-13 | Meigs | Tennessee | 47121 | 1526 | 24 |
1614538 | 1614538 | 2021-08-13 | Monroe | Tennessee | 47123 | 6419 | 98 |
1614539 | 1614539 | 2021-08-13 | Montgomery | Tennessee | 47125 | 23086 | 236 |
1614540 | 1614540 | 2021-08-13 | Moore | Tennessee | 47127 | 1112 | 18 |
1614541 | 1614541 | 2021-08-13 | Morgan | Tennessee | 47129 | 2765 | 39 |
1614542 | 1614542 | 2021-08-13 | Obion | Tennessee | 47131 | 4886 | 98 |
1614543 | 1614543 | 2021-08-13 | Overton | Tennessee | 47133 | 3202 | 63 |
1614544 | 1614544 | 2021-08-13 | Perry | Tennessee | 47135 | 1157 | 29 |
1614545 | 1614545 | 2021-08-13 | Pickett | Tennessee | 47137 | 804 | 24 |
1614546 | 1614546 | 2021-08-13 | Polk | Tennessee | 47139 | 2283 | 25 |
1614547 | 1614547 | 2021-08-13 | Putnam | Tennessee | 47141 | 12417 | 183 |
1614548 | 1614548 | 2021-08-13 | Rhea | Tennessee | 47143 | 4726 | 83 |
1614549 | 1614549 | 2021-08-13 | Roane | Tennessee | 47145 | 6936 | 112 |
1614550 | 1614550 | 2021-08-13 | Robertson | Tennessee | 47147 | 10639 | 145 |
1614551 | 1614551 | 2021-08-13 | Rutherford | Tennessee | 47149 | 46828 | 458 |
1614552 | 1614552 | 2021-08-13 | Scott | Tennessee | 47151 | 3365 | 48 |
1614553 | 1614553 | 2021-08-13 | Sequatchie | Tennessee | 47153 | 1936 | 30 |
1614554 | 1614554 | 2021-08-13 | Sevier | Tennessee | 47155 | 14837 | 183 |
1614555 | 1614555 | 2021-08-13 | Shelby | Tennessee | 47157 | 112026 | 1777 |
1614556 | 1614556 | 2021-08-13 | Smith | Tennessee | 47159 | 3002 | 40 |
1614557 | 1614557 | 2021-08-13 | Stewart | Tennessee | 47161 | 1457 | 28 |
1614558 | 1614558 | 2021-08-13 | Sullivan | Tennessee | 47163 | 18698 | 323 |
1614559 | 1614559 | 2021-08-13 | Sumner | Tennessee | 47165 | 26688 | 364 |
1614560 | 1614560 | 2021-08-13 | Tipton | Tennessee | 47167 | 8436 | 107 |
1614561 | 1614561 | 2021-08-13 | Trousdale | Tennessee | 47169 | 2652 | 22 |
1614562 | 1614562 | 2021-08-13 | Unicoi | Tennessee | 47171 | 2187 | 51 |
1614563 | 1614563 | 2021-08-13 | Union | Tennessee | 47173 | 2041 | 34 |
1614564 | 1614564 | 2021-08-13 | Unknown | Tennessee | 9368 | 92 | |
1614565 | 1614565 | 2021-08-13 | Van Buren | Tennessee | 47175 | 919 | 23 |
1614566 | 1614566 | 2021-08-13 | Warren | Tennessee | 47177 | 5862 | 86 |
1614567 | 1614567 | 2021-08-13 | Washington | Tennessee | 47179 | 15845 | 258 |
1614568 | 1614568 | 2021-08-13 | Wayne | Tennessee | 47181 | 3140 | 36 |
1614569 | 1614569 | 2021-08-13 | Weakley | Tennessee | 47183 | 4506 | 70 |
1614570 | 1614570 | 2021-08-13 | White | Tennessee | 47185 | 3943 | 75 |
1614571 | 1614571 | 2021-08-13 | Williamson | Tennessee | 47187 | 31172 | 225 |
1614572 | 1614572 | 2021-08-13 | Wilson | Tennessee | 47189 | 20904 | 261 |
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);