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-03-09 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2290545 | 2290545 | 2022-03-09 | Anderson | Tennessee | 47001 | 21942 | 312 |
2290546 | 2290546 | 2022-03-09 | Bedford | Tennessee | 47003 | 14906 | 221 |
2290547 | 2290547 | 2022-03-09 | Benton | Tennessee | 47005 | 4453 | 90 |
2290548 | 2290548 | 2022-03-09 | Bledsoe | Tennessee | 47007 | 4645 | 53 |
2290549 | 2290549 | 2022-03-09 | Blount | Tennessee | 47009 | 38940 | 399 |
2290550 | 2290550 | 2022-03-09 | Bradley | Tennessee | 47011 | 33031 | 387 |
2290551 | 2290551 | 2022-03-09 | Campbell | Tennessee | 47013 | 12010 | 153 |
2290552 | 2290552 | 2022-03-09 | Cannon | Tennessee | 47015 | 4170 | 56 |
2290553 | 2290553 | 2022-03-09 | Carroll | Tennessee | 47017 | 8914 | 150 |
2290554 | 2290554 | 2022-03-09 | Carter | Tennessee | 47019 | 16377 | 316 |
2290555 | 2290555 | 2022-03-09 | Cheatham | Tennessee | 47021 | 10876 | 117 |
2290556 | 2290556 | 2022-03-09 | Chester | Tennessee | 47023 | 5768 | 94 |
2290557 | 2290557 | 2022-03-09 | Claiborne | Tennessee | 47025 | 9027 | 168 |
2290558 | 2290558 | 2022-03-09 | Clay | Tennessee | 47027 | 2219 | 47 |
2290559 | 2290559 | 2022-03-09 | Cocke | Tennessee | 47029 | 11508 | 201 |
2290560 | 2290560 | 2022-03-09 | Coffee | Tennessee | 47031 | 16894 | 250 |
2290561 | 2290561 | 2022-03-09 | Crockett | Tennessee | 47033 | 5150 | 82 |
2290562 | 2290562 | 2022-03-09 | Cumberland | Tennessee | 47035 | 16042 | 310 |
2290563 | 2290563 | 2022-03-09 | Davidson | Tennessee | 47037 | 206190 | 1601 |
2290564 | 2290564 | 2022-03-09 | DeKalb | Tennessee | 47041 | 6268 | 97 |
2290565 | 2290565 | 2022-03-09 | Decatur | Tennessee | 47039 | 3715 | 64 |
2290566 | 2290566 | 2022-03-09 | Dickson | Tennessee | 47043 | 15826 | 235 |
2290567 | 2290567 | 2022-03-09 | Dyer | Tennessee | 47045 | 12720 | 192 |
2290568 | 2290568 | 2022-03-09 | Fayette | Tennessee | 47047 | 11387 | 171 |
2290569 | 2290569 | 2022-03-09 | Fentress | Tennessee | 47049 | 5681 | 117 |
2290570 | 2290570 | 2022-03-09 | Franklin | Tennessee | 47051 | 12802 | 165 |
2290571 | 2290571 | 2022-03-09 | Gibson | Tennessee | 47053 | 17286 | 252 |
2290572 | 2290572 | 2022-03-09 | Giles | Tennessee | 47055 | 9382 | 172 |
2290573 | 2290573 | 2022-03-09 | Grainger | Tennessee | 47057 | 6747 | 103 |
2290574 | 2290574 | 2022-03-09 | Greene | Tennessee | 47059 | 21952 | 353 |
2290575 | 2290575 | 2022-03-09 | Grundy | Tennessee | 47061 | 3974 | 69 |
2290576 | 2290576 | 2022-03-09 | Hamblen | Tennessee | 47063 | 19651 | 345 |
2290577 | 2290577 | 2022-03-09 | Hamilton | Tennessee | 47065 | 99176 | 1082 |
2290578 | 2290578 | 2022-03-09 | Hancock | Tennessee | 47067 | 1998 | 32 |
2290579 | 2290579 | 2022-03-09 | Hardeman | Tennessee | 47069 | 7550 | 115 |
2290580 | 2290580 | 2022-03-09 | Hardin | Tennessee | 47071 | 8695 | 137 |
2290581 | 2290581 | 2022-03-09 | Hawkins | Tennessee | 47073 | 16546 | 291 |
2290582 | 2290582 | 2022-03-09 | Haywood | Tennessee | 47075 | 6131 | 97 |
2290583 | 2290583 | 2022-03-09 | Henderson | Tennessee | 47077 | 9035 | 147 |
2290584 | 2290584 | 2022-03-09 | Henry | Tennessee | 47079 | 8221 | 148 |
2290585 | 2290585 | 2022-03-09 | Hickman | Tennessee | 47081 | 6808 | 104 |
2290586 | 2290586 | 2022-03-09 | Houston | Tennessee | 47083 | 2667 | 59 |
2290587 | 2290587 | 2022-03-09 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2290588 | 2290588 | 2022-03-09 | Jackson | Tennessee | 47087 | 3199 | 60 |
2290589 | 2290589 | 2022-03-09 | Jefferson | Tennessee | 47089 | 15650 | 255 |
2290590 | 2290590 | 2022-03-09 | Johnson | Tennessee | 47091 | 5131 | 87 |
2290591 | 2290591 | 2022-03-09 | Knox | Tennessee | 47093 | 127157 | 1298 |
2290592 | 2290592 | 2022-03-09 | Lake | Tennessee | 47095 | 2733 | 40 |
2290593 | 2290593 | 2022-03-09 | Lauderdale | Tennessee | 47097 | 7713 | 99 |
2290594 | 2290594 | 2022-03-09 | Lawrence | Tennessee | 47099 | 14241 | 187 |
2290595 | 2290595 | 2022-03-09 | Lewis | Tennessee | 47101 | 3567 | 50 |
2290596 | 2290596 | 2022-03-09 | Lincoln | Tennessee | 47103 | 9949 | 157 |
2290597 | 2290597 | 2022-03-09 | Loudon | Tennessee | 47105 | 14363 | 186 |
2290598 | 2290598 | 2022-03-09 | Macon | Tennessee | 47111 | 8405 | 139 |
2290599 | 2290599 | 2022-03-09 | Madison | Tennessee | 47113 | 29657 | 411 |
2290600 | 2290600 | 2022-03-09 | Marion | Tennessee | 47115 | 8810 | 124 |
2290601 | 2290601 | 2022-03-09 | Marshall | Tennessee | 47117 | 10334 | 116 |
2290602 | 2290602 | 2022-03-09 | Maury | Tennessee | 47119 | 28815 | 320 |
2290603 | 2290603 | 2022-03-09 | McMinn | Tennessee | 47107 | 16630 | 240 |
2290604 | 2290604 | 2022-03-09 | McNairy | Tennessee | 47109 | 7608 | 113 |
2290605 | 2290605 | 2022-03-09 | Meigs | Tennessee | 47121 | 3347 | 54 |
2290606 | 2290606 | 2022-03-09 | Monroe | Tennessee | 47123 | 14442 | 217 |
2290607 | 2290607 | 2022-03-09 | Montgomery | Tennessee | 47125 | 49919 | 550 |
2290608 | 2290608 | 2022-03-09 | Moore | Tennessee | 47127 | 2235 | 39 |
2290609 | 2290609 | 2022-03-09 | Morgan | Tennessee | 47129 | 6145 | 78 |
2290610 | 2290610 | 2022-03-09 | Obion | Tennessee | 47131 | 10742 | 179 |
2290611 | 2290611 | 2022-03-09 | Overton | Tennessee | 47133 | 7139 | 120 |
2290612 | 2290612 | 2022-03-09 | Perry | Tennessee | 47135 | 2327 | 48 |
2290613 | 2290613 | 2022-03-09 | Pickett | Tennessee | 47137 | 1763 | 31 |
2290614 | 2290614 | 2022-03-09 | Polk | Tennessee | 47139 | 4711 | 65 |
2290615 | 2290615 | 2022-03-09 | Putnam | Tennessee | 47141 | 25037 | 295 |
2290616 | 2290616 | 2022-03-09 | Rhea | Tennessee | 47143 | 9936 | 148 |
2290617 | 2290617 | 2022-03-09 | Roane | Tennessee | 47145 | 15712 | 225 |
2290618 | 2290618 | 2022-03-09 | Robertson | Tennessee | 47147 | 21471 | 290 |
2290619 | 2290619 | 2022-03-09 | Rutherford | Tennessee | 47149 | 95362 | 865 |
2290620 | 2290620 | 2022-03-09 | Scott | Tennessee | 47151 | 8987 | 111 |
2290621 | 2290621 | 2022-03-09 | Sequatchie | Tennessee | 47153 | 4194 | 66 |
2290622 | 2290622 | 2022-03-09 | Sevier | Tennessee | 47155 | 30156 | 393 |
2290623 | 2290623 | 2022-03-09 | Shelby | Tennessee | 47157 | 237084 | 3178 |
2290624 | 2290624 | 2022-03-09 | Smith | Tennessee | 47159 | 6154 | 76 |
2290625 | 2290625 | 2022-03-09 | Stewart | Tennessee | 47161 | 3280 | 52 |
2290626 | 2290626 | 2022-03-09 | Sullivan | Tennessee | 47163 | 45533 | 670 |
2290627 | 2290627 | 2022-03-09 | Sumner | Tennessee | 47165 | 52955 | 688 |
2290628 | 2290628 | 2022-03-09 | Tipton | Tennessee | 47167 | 17564 | 221 |
2290629 | 2290629 | 2022-03-09 | Trousdale | Tennessee | 47169 | 4206 | 45 |
2290630 | 2290630 | 2022-03-09 | Unicoi | Tennessee | 47171 | 5138 | 90 |
2290631 | 2290631 | 2022-03-09 | Union | Tennessee | 47173 | 5382 | 70 |
2290632 | 2290632 | 2022-03-09 | Unknown | Tennessee | 18739 | 249 | |
2290633 | 2290633 | 2022-03-09 | Van Buren | Tennessee | 47175 | 1845 | 46 |
2290634 | 2290634 | 2022-03-09 | Warren | Tennessee | 47177 | 12970 | 167 |
2290635 | 2290635 | 2022-03-09 | Washington | Tennessee | 47179 | 38342 | 471 |
2290636 | 2290636 | 2022-03-09 | Wayne | Tennessee | 47181 | 5672 | 60 |
2290637 | 2290637 | 2022-03-09 | Weakley | Tennessee | 47183 | 9474 | 138 |
2290638 | 2290638 | 2022-03-09 | White | Tennessee | 47185 | 8216 | 126 |
2290639 | 2290639 | 2022-03-09 | Williamson | Tennessee | 47187 | 61684 | 386 |
2290640 | 2290640 | 2022-03-09 | Wilson | Tennessee | 47189 | 41449 | 465 |
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);