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-02-25 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2251522 | 2251522 | 2022-02-25 | Anderson | Tennessee | 47001 | 21724 | 303 |
2251523 | 2251523 | 2022-02-25 | Bedford | Tennessee | 47003 | 14826 | 218 |
2251524 | 2251524 | 2022-02-25 | Benton | Tennessee | 47005 | 4386 | 85 |
2251525 | 2251525 | 2022-02-25 | Bledsoe | Tennessee | 47007 | 4618 | 48 |
2251526 | 2251526 | 2022-02-25 | Blount | Tennessee | 47009 | 38653 | 387 |
2251527 | 2251527 | 2022-02-25 | Bradley | Tennessee | 47011 | 32832 | 376 |
2251528 | 2251528 | 2022-02-25 | Campbell | Tennessee | 47013 | 11694 | 145 |
2251529 | 2251529 | 2022-02-25 | Cannon | Tennessee | 47015 | 4133 | 55 |
2251530 | 2251530 | 2022-02-25 | Carroll | Tennessee | 47017 | 8811 | 145 |
2251531 | 2251531 | 2022-02-25 | Carter | Tennessee | 47019 | 16164 | 305 |
2251532 | 2251532 | 2022-02-25 | Cheatham | Tennessee | 47021 | 10818 | 113 |
2251533 | 2251533 | 2022-02-25 | Chester | Tennessee | 47023 | 5685 | 90 |
2251534 | 2251534 | 2022-02-25 | Claiborne | Tennessee | 47025 | 8780 | 159 |
2251535 | 2251535 | 2022-02-25 | Clay | Tennessee | 47027 | 2207 | 46 |
2251536 | 2251536 | 2022-02-25 | Cocke | Tennessee | 47029 | 11172 | 201 |
2251537 | 2251537 | 2022-02-25 | Coffee | Tennessee | 47031 | 16777 | 237 |
2251538 | 2251538 | 2022-02-25 | Crockett | Tennessee | 47033 | 5008 | 81 |
2251539 | 2251539 | 2022-02-25 | Cumberland | Tennessee | 47035 | 15886 | 303 |
2251540 | 2251540 | 2022-02-25 | Davidson | Tennessee | 47037 | 205375 | 1568 |
2251541 | 2251541 | 2022-02-25 | DeKalb | Tennessee | 47041 | 6223 | 96 |
2251542 | 2251542 | 2022-02-25 | Decatur | Tennessee | 47039 | 3618 | 61 |
2251543 | 2251543 | 2022-02-25 | Dickson | Tennessee | 47043 | 15730 | 228 |
2251544 | 2251544 | 2022-02-25 | Dyer | Tennessee | 47045 | 12544 | 185 |
2251545 | 2251545 | 2022-02-25 | Fayette | Tennessee | 47047 | 11323 | 163 |
2251546 | 2251546 | 2022-02-25 | Fentress | Tennessee | 47049 | 5640 | 114 |
2251547 | 2251547 | 2022-02-25 | Franklin | Tennessee | 47051 | 12724 | 164 |
2251548 | 2251548 | 2022-02-25 | Gibson | Tennessee | 47053 | 17074 | 247 |
2251549 | 2251549 | 2022-02-25 | Giles | Tennessee | 47055 | 9342 | 166 |
2251550 | 2251550 | 2022-02-25 | Grainger | Tennessee | 47057 | 6688 | 101 |
2251551 | 2251551 | 2022-02-25 | Greene | Tennessee | 47059 | 21773 | 340 |
2251552 | 2251552 | 2022-02-25 | Grundy | Tennessee | 47061 | 3947 | 68 |
2251553 | 2251553 | 2022-02-25 | Hamblen | Tennessee | 47063 | 19502 | 336 |
2251554 | 2251554 | 2022-02-25 | Hamilton | Tennessee | 47065 | 97442 | 1071 |
2251555 | 2251555 | 2022-02-25 | Hancock | Tennessee | 47067 | 1966 | 30 |
2251556 | 2251556 | 2022-02-25 | Hardeman | Tennessee | 47069 | 7373 | 113 |
2251557 | 2251557 | 2022-02-25 | Hardin | Tennessee | 47071 | 8518 | 128 |
2251558 | 2251558 | 2022-02-25 | Hawkins | Tennessee | 47073 | 16388 | 281 |
2251559 | 2251559 | 2022-02-25 | Haywood | Tennessee | 47075 | 6081 | 95 |
2251560 | 2251560 | 2022-02-25 | Henderson | Tennessee | 47077 | 8798 | 143 |
2251561 | 2251561 | 2022-02-25 | Henry | Tennessee | 47079 | 8050 | 140 |
2251562 | 2251562 | 2022-02-25 | Hickman | Tennessee | 47081 | 6769 | 103 |
2251563 | 2251563 | 2022-02-25 | Houston | Tennessee | 47083 | 2644 | 59 |
2251564 | 2251564 | 2022-02-25 | Humphreys | Tennessee | 47085 | 4786 | 68 |
2251565 | 2251565 | 2022-02-25 | Jackson | Tennessee | 47087 | 3163 | 58 |
2251566 | 2251566 | 2022-02-25 | Jefferson | Tennessee | 47089 | 15485 | 249 |
2251567 | 2251567 | 2022-02-25 | Johnson | Tennessee | 47091 | 5047 | 77 |
2251568 | 2251568 | 2022-02-25 | Knox | Tennessee | 47093 | 126007 | 1257 |
2251569 | 2251569 | 2022-02-25 | Lake | Tennessee | 47095 | 2670 | 38 |
2251570 | 2251570 | 2022-02-25 | Lauderdale | Tennessee | 47097 | 7648 | 92 |
2251571 | 2251571 | 2022-02-25 | Lawrence | Tennessee | 47099 | 14166 | 175 |
2251572 | 2251572 | 2022-02-25 | Lewis | Tennessee | 47101 | 3550 | 50 |
2251573 | 2251573 | 2022-02-25 | Lincoln | Tennessee | 47103 | 9882 | 145 |
2251574 | 2251574 | 2022-02-25 | Loudon | Tennessee | 47105 | 14250 | 180 |
2251575 | 2251575 | 2022-02-25 | Macon | Tennessee | 47111 | 8340 | 138 |
2251576 | 2251576 | 2022-02-25 | Madison | Tennessee | 47113 | 29127 | 397 |
2251577 | 2251577 | 2022-02-25 | Marion | Tennessee | 47115 | 8745 | 121 |
2251578 | 2251578 | 2022-02-25 | Marshall | Tennessee | 47117 | 10269 | 115 |
2251579 | 2251579 | 2022-02-25 | Maury | Tennessee | 47119 | 28685 | 312 |
2251580 | 2251580 | 2022-02-25 | McMinn | Tennessee | 47107 | 16540 | 232 |
2251581 | 2251581 | 2022-02-25 | McNairy | Tennessee | 47109 | 7464 | 100 |
2251582 | 2251582 | 2022-02-25 | Meigs | Tennessee | 47121 | 3323 | 51 |
2251583 | 2251583 | 2022-02-25 | Monroe | Tennessee | 47123 | 14312 | 216 |
2251584 | 2251584 | 2022-02-25 | Montgomery | Tennessee | 47125 | 49416 | 531 |
2251585 | 2251585 | 2022-02-25 | Moore | Tennessee | 47127 | 2208 | 37 |
2251586 | 2251586 | 2022-02-25 | Morgan | Tennessee | 47129 | 5965 | 75 |
2251587 | 2251587 | 2022-02-25 | Obion | Tennessee | 47131 | 10659 | 168 |
2251588 | 2251588 | 2022-02-25 | Overton | Tennessee | 47133 | 7092 | 118 |
2251589 | 2251589 | 2022-02-25 | Perry | Tennessee | 47135 | 2292 | 46 |
2251590 | 2251590 | 2022-02-25 | Pickett | Tennessee | 47137 | 1753 | 30 |
2251591 | 2251591 | 2022-02-25 | Polk | Tennessee | 47139 | 4624 | 56 |
2251592 | 2251592 | 2022-02-25 | Putnam | Tennessee | 47141 | 24841 | 291 |
2251593 | 2251593 | 2022-02-25 | Rhea | Tennessee | 47143 | 9890 | 148 |
2251594 | 2251594 | 2022-02-25 | Roane | Tennessee | 47145 | 15588 | 217 |
2251595 | 2251595 | 2022-02-25 | Robertson | Tennessee | 47147 | 21356 | 284 |
2251596 | 2251596 | 2022-02-25 | Rutherford | Tennessee | 47149 | 94737 | 851 |
2251597 | 2251597 | 2022-02-25 | Scott | Tennessee | 47151 | 8816 | 105 |
2251598 | 2251598 | 2022-02-25 | Sequatchie | Tennessee | 47153 | 4165 | 64 |
2251599 | 2251599 | 2022-02-25 | Sevier | Tennessee | 47155 | 29882 | 383 |
2251600 | 2251600 | 2022-02-25 | Shelby | Tennessee | 47157 | 236228 | 3127 |
2251601 | 2251601 | 2022-02-25 | Smith | Tennessee | 47159 | 6102 | 73 |
2251602 | 2251602 | 2022-02-25 | Stewart | Tennessee | 47161 | 3253 | 48 |
2251603 | 2251603 | 2022-02-25 | Sullivan | Tennessee | 47163 | 44990 | 642 |
2251604 | 2251604 | 2022-02-25 | Sumner | Tennessee | 47165 | 52623 | 682 |
2251605 | 2251605 | 2022-02-25 | Tipton | Tennessee | 47167 | 17460 | 209 |
2251606 | 2251606 | 2022-02-25 | Trousdale | Tennessee | 47169 | 4188 | 44 |
2251607 | 2251607 | 2022-02-25 | Unicoi | Tennessee | 47171 | 5073 | 88 |
2251608 | 2251608 | 2022-02-25 | Union | Tennessee | 47173 | 5332 | 69 |
2251609 | 2251609 | 2022-02-25 | Unknown | Tennessee | 23465 | 557 | |
2251610 | 2251610 | 2022-02-25 | Van Buren | Tennessee | 47175 | 1831 | 45 |
2251611 | 2251611 | 2022-02-25 | Warren | Tennessee | 47177 | 12892 | 163 |
2251612 | 2251612 | 2022-02-25 | Washington | Tennessee | 47179 | 37964 | 461 |
2251613 | 2251613 | 2022-02-25 | Wayne | Tennessee | 47181 | 5609 | 53 |
2251614 | 2251614 | 2022-02-25 | Weakley | Tennessee | 47183 | 9387 | 131 |
2251615 | 2251615 | 2022-02-25 | White | Tennessee | 47185 | 8143 | 126 |
2251616 | 2251616 | 2022-02-25 | Williamson | Tennessee | 47187 | 61337 | 375 |
2251617 | 2251617 | 2022-02-25 | Wilson | Tennessee | 47189 | 41211 | 459 |
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);