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 2022-05-11 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495595 | 2495595 | 2022-05-11 | Anderson | Tennessee | 47001 | 22228 | 334 |
2495596 | 2495596 | 2022-05-11 | Bedford | Tennessee | 47003 | 15004 | 237 |
2495597 | 2495597 | 2022-05-11 | Benton | Tennessee | 47005 | 4533 | 93 |
2495598 | 2495598 | 2022-05-11 | Bledsoe | Tennessee | 47007 | 4669 | 57 |
2495599 | 2495599 | 2022-05-11 | Blount | Tennessee | 47009 | 39310 | 440 |
2495600 | 2495600 | 2022-05-11 | Bradley | Tennessee | 47011 | 33188 | 415 |
2495601 | 2495601 | 2022-05-11 | Campbell | Tennessee | 47013 | 12310 | 169 |
2495602 | 2495602 | 2022-05-11 | Cannon | Tennessee | 47015 | 4227 | 63 |
2495603 | 2495603 | 2022-05-11 | Carroll | Tennessee | 47017 | 8978 | 156 |
2495604 | 2495604 | 2022-05-11 | Carter | Tennessee | 47019 | 16546 | 336 |
2495605 | 2495605 | 2022-05-11 | Cheatham | Tennessee | 47021 | 10967 | 119 |
2495606 | 2495606 | 2022-05-11 | Chester | Tennessee | 47023 | 5870 | 99 |
2495607 | 2495607 | 2022-05-11 | Claiborne | Tennessee | 47025 | 9141 | 178 |
2495608 | 2495608 | 2022-05-11 | Clay | Tennessee | 47027 | 2300 | 50 |
2495609 | 2495609 | 2022-05-11 | Cocke | Tennessee | 47029 | 11634 | 217 |
2495610 | 2495610 | 2022-05-11 | Coffee | Tennessee | 47031 | 16994 | 267 |
2495611 | 2495611 | 2022-05-11 | Crockett | Tennessee | 47033 | 5199 | 85 |
2495612 | 2495612 | 2022-05-11 | Cumberland | Tennessee | 47035 | 16171 | 327 |
2495613 | 2495613 | 2022-05-11 | Davidson | Tennessee | 47037 | 210463 | 1676 |
2495614 | 2495614 | 2022-05-11 | DeKalb | Tennessee | 47041 | 6288 | 101 |
2495615 | 2495615 | 2022-05-11 | Decatur | Tennessee | 47039 | 3738 | 70 |
2495616 | 2495616 | 2022-05-11 | Dickson | Tennessee | 47043 | 15987 | 245 |
2495617 | 2495617 | 2022-05-11 | Dyer | Tennessee | 47045 | 12826 | 203 |
2495618 | 2495618 | 2022-05-11 | Fayette | Tennessee | 47047 | 11475 | 186 |
2495619 | 2495619 | 2022-05-11 | Fentress | Tennessee | 47049 | 5722 | 128 |
2495620 | 2495620 | 2022-05-11 | Franklin | Tennessee | 47051 | 12908 | 184 |
2495621 | 2495621 | 2022-05-11 | Gibson | Tennessee | 47053 | 17453 | 260 |
2495622 | 2495622 | 2022-05-11 | Giles | Tennessee | 47055 | 9448 | 190 |
2495623 | 2495623 | 2022-05-11 | Grainger | Tennessee | 47057 | 6793 | 109 |
2495624 | 2495624 | 2022-05-11 | Greene | Tennessee | 47059 | 22140 | 374 |
2495625 | 2495625 | 2022-05-11 | Grundy | Tennessee | 47061 | 3998 | 73 |
2495626 | 2495626 | 2022-05-11 | Hamblen | Tennessee | 47063 | 19740 | 353 |
2495627 | 2495627 | 2022-05-11 | Hamilton | Tennessee | 47065 | 100960 | 1151 |
2495628 | 2495628 | 2022-05-11 | Hancock | Tennessee | 47067 | 2023 | 37 |
2495629 | 2495629 | 2022-05-11 | Hardeman | Tennessee | 47069 | 7606 | 116 |
2495630 | 2495630 | 2022-05-11 | Hardin | Tennessee | 47071 | 8765 | 145 |
2495631 | 2495631 | 2022-05-11 | Hawkins | Tennessee | 47073 | 16702 | 321 |
2495632 | 2495632 | 2022-05-11 | Haywood | Tennessee | 47075 | 6191 | 102 |
2495633 | 2495633 | 2022-05-11 | Henderson | Tennessee | 47077 | 9150 | 160 |
2495634 | 2495634 | 2022-05-11 | Henry | Tennessee | 47079 | 8310 | 163 |
2495635 | 2495635 | 2022-05-11 | Hickman | Tennessee | 47081 | 6850 | 110 |
2495636 | 2495636 | 2022-05-11 | Houston | Tennessee | 47083 | 2689 | 62 |
2495637 | 2495637 | 2022-05-11 | Humphreys | Tennessee | 47085 | 4855 | 74 |
2495638 | 2495638 | 2022-05-11 | Jackson | Tennessee | 47087 | 3211 | 63 |
2495639 | 2495639 | 2022-05-11 | Jefferson | Tennessee | 47089 | 15804 | 265 |
2495640 | 2495640 | 2022-05-11 | Johnson | Tennessee | 47091 | 5181 | 95 |
2495641 | 2495641 | 2022-05-11 | Knox | Tennessee | 47093 | 128707 | 1385 |
2495642 | 2495642 | 2022-05-11 | Lake | Tennessee | 47095 | 2749 | 43 |
2495643 | 2495643 | 2022-05-11 | Lauderdale | Tennessee | 47097 | 7764 | 106 |
2495644 | 2495644 | 2022-05-11 | Lawrence | Tennessee | 47099 | 14329 | 203 |
2495645 | 2495645 | 2022-05-11 | Lewis | Tennessee | 47101 | 3573 | 60 |
2495646 | 2495646 | 2022-05-11 | Lincoln | Tennessee | 47103 | 10003 | 170 |
2495647 | 2495647 | 2022-05-11 | Loudon | Tennessee | 47105 | 14571 | 192 |
2495648 | 2495648 | 2022-05-11 | Macon | Tennessee | 47111 | 8478 | 145 |
2495649 | 2495649 | 2022-05-11 | Madison | Tennessee | 47113 | 30250 | 427 |
2495650 | 2495650 | 2022-05-11 | Marion | Tennessee | 47115 | 8870 | 132 |
2495651 | 2495651 | 2022-05-11 | Marshall | Tennessee | 47117 | 10403 | 124 |
2495652 | 2495652 | 2022-05-11 | Maury | Tennessee | 47119 | 29162 | 345 |
2495653 | 2495653 | 2022-05-11 | McMinn | Tennessee | 47107 | 16701 | 260 |
2495654 | 2495654 | 2022-05-11 | McNairy | Tennessee | 47109 | 7662 | 120 |
2495655 | 2495655 | 2022-05-11 | Meigs | Tennessee | 47121 | 3394 | 58 |
2495656 | 2495656 | 2022-05-11 | Monroe | Tennessee | 47123 | 14681 | 244 |
2495657 | 2495657 | 2022-05-11 | Montgomery | Tennessee | 47125 | 50488 | 579 |
2495658 | 2495658 | 2022-05-11 | Moore | Tennessee | 47127 | 2239 | 40 |
2495659 | 2495659 | 2022-05-11 | Morgan | Tennessee | 47129 | 6209 | 87 |
2495660 | 2495660 | 2022-05-11 | Obion | Tennessee | 47131 | 10786 | 195 |
2495661 | 2495661 | 2022-05-11 | Overton | Tennessee | 47133 | 7157 | 123 |
2495662 | 2495662 | 2022-05-11 | Perry | Tennessee | 47135 | 2332 | 56 |
2495663 | 2495663 | 2022-05-11 | Pickett | Tennessee | 47137 | 1774 | 36 |
2495664 | 2495664 | 2022-05-11 | Polk | Tennessee | 47139 | 4740 | 74 |
2495665 | 2495665 | 2022-05-11 | Putnam | Tennessee | 47141 | 25178 | 304 |
2495666 | 2495666 | 2022-05-11 | Rhea | Tennessee | 47143 | 9994 | 160 |
2495667 | 2495667 | 2022-05-11 | Roane | Tennessee | 47145 | 15839 | 234 |
2495668 | 2495668 | 2022-05-11 | Robertson | Tennessee | 47147 | 21626 | 305 |
2495669 | 2495669 | 2022-05-11 | Rutherford | Tennessee | 47149 | 96372 | 904 |
2495670 | 2495670 | 2022-05-11 | Scott | Tennessee | 47151 | 9097 | 117 |
2495671 | 2495671 | 2022-05-11 | Sequatchie | Tennessee | 47153 | 4226 | 69 |
2495672 | 2495672 | 2022-05-11 | Sevier | Tennessee | 47155 | 30457 | 415 |
2495673 | 2495673 | 2022-05-11 | Shelby | Tennessee | 47157 | 240281 | 3307 |
2495674 | 2495674 | 2022-05-11 | Smith | Tennessee | 47159 | 6171 | 85 |
2495675 | 2495675 | 2022-05-11 | Stewart | Tennessee | 47161 | 3294 | 59 |
2495676 | 2495676 | 2022-05-11 | Sullivan | Tennessee | 47163 | 46163 | 721 |
2495677 | 2495677 | 2022-05-11 | Sumner | Tennessee | 47165 | 53504 | 729 |
2495678 | 2495678 | 2022-05-11 | Tipton | Tennessee | 47167 | 17674 | 236 |
2495679 | 2495679 | 2022-05-11 | Trousdale | Tennessee | 47169 | 4238 | 45 |
2495680 | 2495680 | 2022-05-11 | Unicoi | Tennessee | 47171 | 5191 | 96 |
2495681 | 2495681 | 2022-05-11 | Union | Tennessee | 47173 | 5409 | 75 |
2495682 | 2495682 | 2022-05-11 | Unknown | Tennessee | 18304 | 281 | |
2495683 | 2495683 | 2022-05-11 | Van Buren | Tennessee | 47175 | 1852 | 48 |
2495684 | 2495684 | 2022-05-11 | Warren | Tennessee | 47177 | 13028 | 177 |
2495685 | 2495685 | 2022-05-11 | Washington | Tennessee | 47179 | 38862 | 496 |
2495686 | 2495686 | 2022-05-11 | Wayne | Tennessee | 47181 | 5700 | 72 |
2495687 | 2495687 | 2022-05-11 | Weakley | Tennessee | 47183 | 9586 | 152 |
2495688 | 2495688 | 2022-05-11 | White | Tennessee | 47185 | 8249 | 129 |
2495689 | 2495689 | 2022-05-11 | Williamson | Tennessee | 47187 | 62833 | 406 |
2495690 | 2495690 | 2022-05-11 | Wilson | Tennessee | 47189 | 41970 | 484 |
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);