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-04-26 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1260589 | 1260589 | 2021-04-26 | Anderson | Tennessee | 47001 | 8690 | 172 |
1260590 | 1260590 | 2021-04-26 | Bedford | Tennessee | 47003 | 6477 | 129 |
1260591 | 1260591 | 2021-04-26 | Benton | Tennessee | 47005 | 1643 | 40 |
1260592 | 1260592 | 2021-04-26 | Bledsoe | Tennessee | 47007 | 2112 | 11 |
1260593 | 1260593 | 2021-04-26 | Blount | Tennessee | 47009 | 15292 | 193 |
1260594 | 1260594 | 2021-04-26 | Bradley | Tennessee | 47011 | 14811 | 149 |
1260595 | 1260595 | 2021-04-26 | Campbell | Tennessee | 47013 | 4118 | 63 |
1260596 | 1260596 | 2021-04-26 | Cannon | Tennessee | 47015 | 1901 | 31 |
1260597 | 1260597 | 2021-04-26 | Carroll | Tennessee | 47017 | 3596 | 83 |
1260598 | 1260598 | 2021-04-26 | Carter | Tennessee | 47019 | 6541 | 156 |
1260599 | 1260599 | 2021-04-26 | Cheatham | Tennessee | 47021 | 4508 | 55 |
1260600 | 1260600 | 2021-04-26 | Chester | Tennessee | 47023 | 2113 | 51 |
1260601 | 1260601 | 2021-04-26 | Claiborne | Tennessee | 47025 | 3118 | 73 |
1260602 | 1260602 | 2021-04-26 | Clay | Tennessee | 47027 | 1100 | 31 |
1260603 | 1260603 | 2021-04-26 | Cocke | Tennessee | 47029 | 4466 | 98 |
1260604 | 1260604 | 2021-04-26 | Coffee | Tennessee | 47031 | 6873 | 121 |
1260605 | 1260605 | 2021-04-26 | Crockett | Tennessee | 47033 | 2022 | 48 |
1260606 | 1260606 | 2021-04-26 | Cumberland | Tennessee | 47035 | 6654 | 128 |
1260607 | 1260607 | 2021-04-26 | Davidson | Tennessee | 47037 | 97870 | 929 |
1260608 | 1260608 | 2021-04-26 | DeKalb | Tennessee | 47041 | 2776 | 53 |
1260609 | 1260609 | 2021-04-26 | Decatur | Tennessee | 47039 | 1578 | 39 |
1260610 | 1260610 | 2021-04-26 | Dickson | Tennessee | 47043 | 6787 | 109 |
1260611 | 1260611 | 2021-04-26 | Dyer | Tennessee | 47045 | 5390 | 105 |
1260612 | 1260612 | 2021-04-26 | Fayette | Tennessee | 47047 | 4959 | 76 |
1260613 | 1260613 | 2021-04-26 | Fentress | Tennessee | 47049 | 2396 | 47 |
1260614 | 1260614 | 2021-04-26 | Franklin | Tennessee | 47051 | 5117 | 89 |
1260615 | 1260615 | 2021-04-26 | Gibson | Tennessee | 47053 | 6460 | 145 |
1260616 | 1260616 | 2021-04-26 | Giles | Tennessee | 47055 | 3968 | 99 |
1260617 | 1260617 | 2021-04-26 | Grainger | Tennessee | 47057 | 2607 | 50 |
1260618 | 1260618 | 2021-04-26 | Greene | Tennessee | 47059 | 7802 | 152 |
1260619 | 1260619 | 2021-04-26 | Grundy | Tennessee | 47061 | 1785 | 34 |
1260620 | 1260620 | 2021-04-26 | Hamblen | Tennessee | 47063 | 8553 | 171 |
1260621 | 1260621 | 2021-04-26 | Hamilton | Tennessee | 47065 | 43956 | 491 |
1260622 | 1260622 | 2021-04-26 | Hancock | Tennessee | 47067 | 567 | 12 |
1260623 | 1260623 | 2021-04-26 | Hardeman | Tennessee | 47069 | 3489 | 64 |
1260624 | 1260624 | 2021-04-26 | Hardin | Tennessee | 47071 | 3539 | 66 |
1260625 | 1260625 | 2021-04-26 | Hawkins | Tennessee | 47073 | 5887 | 107 |
1260626 | 1260626 | 2021-04-26 | Haywood | Tennessee | 47075 | 2689 | 61 |
1260627 | 1260627 | 2021-04-26 | Henderson | Tennessee | 47077 | 3759 | 76 |
1260628 | 1260628 | 2021-04-26 | Henry | Tennessee | 47079 | 3137 | 75 |
1260629 | 1260629 | 2021-04-26 | Hickman | Tennessee | 47081 | 2819 | 46 |
1260630 | 1260630 | 2021-04-26 | Houston | Tennessee | 47083 | 1088 | 33 |
1260631 | 1260631 | 2021-04-26 | Humphreys | Tennessee | 47085 | 1771 | 22 |
1260632 | 1260632 | 2021-04-26 | Jackson | Tennessee | 47087 | 1314 | 35 |
1260633 | 1260633 | 2021-04-26 | Jefferson | Tennessee | 47089 | 6122 | 124 |
1260634 | 1260634 | 2021-04-26 | Johnson | Tennessee | 47091 | 2353 | 38 |
1260635 | 1260635 | 2021-04-26 | Knox | Tennessee | 47093 | 51346 | 627 |
1260636 | 1260636 | 2021-04-26 | Lake | Tennessee | 47095 | 1697 | 26 |
1260637 | 1260637 | 2021-04-26 | Lauderdale | Tennessee | 47097 | 3159 | 44 |
1260638 | 1260638 | 2021-04-26 | Lawrence | Tennessee | 47099 | 5854 | 86 |
1260639 | 1260639 | 2021-04-26 | Lewis | Tennessee | 47101 | 1570 | 26 |
1260640 | 1260640 | 2021-04-26 | Lincoln | Tennessee | 47103 | 4335 | 63 |
1260641 | 1260641 | 2021-04-26 | Loudon | Tennessee | 47105 | 6052 | 69 |
1260642 | 1260642 | 2021-04-26 | Macon | Tennessee | 47111 | 3594 | 77 |
1260643 | 1260643 | 2021-04-26 | Madison | Tennessee | 47113 | 10950 | 241 |
1260644 | 1260644 | 2021-04-26 | Marion | Tennessee | 47115 | 3112 | 47 |
1260645 | 1260645 | 2021-04-26 | Marshall | Tennessee | 47117 | 4146 | 58 |
1260646 | 1260646 | 2021-04-26 | Maury | Tennessee | 47119 | 13324 | 171 |
1260647 | 1260647 | 2021-04-26 | McMinn | Tennessee | 47107 | 6431 | 98 |
1260648 | 1260648 | 2021-04-26 | McNairy | Tennessee | 47109 | 2790 | 54 |
1260649 | 1260649 | 2021-04-26 | Meigs | Tennessee | 47121 | 1371 | 24 |
1260650 | 1260650 | 2021-04-26 | Monroe | Tennessee | 47123 | 5775 | 95 |
1260651 | 1260651 | 2021-04-26 | Montgomery | Tennessee | 47125 | 19947 | 224 |
1260652 | 1260652 | 2021-04-26 | Moore | Tennessee | 47127 | 1004 | 17 |
1260653 | 1260653 | 2021-04-26 | Morgan | Tennessee | 47129 | 2472 | 39 |
1260654 | 1260654 | 2021-04-26 | Obion | Tennessee | 47131 | 4512 | 96 |
1260655 | 1260655 | 2021-04-26 | Overton | Tennessee | 47133 | 2997 | 61 |
1260656 | 1260656 | 2021-04-26 | Perry | Tennessee | 47135 | 1060 | 28 |
1260657 | 1260657 | 2021-04-26 | Pickett | Tennessee | 47137 | 757 | 24 |
1260658 | 1260658 | 2021-04-26 | Polk | Tennessee | 47139 | 2027 | 24 |
1260659 | 1260659 | 2021-04-26 | Putnam | Tennessee | 47141 | 11258 | 174 |
1260660 | 1260660 | 2021-04-26 | Rhea | Tennessee | 47143 | 4326 | 75 |
1260661 | 1260661 | 2021-04-26 | Roane | Tennessee | 47145 | 6224 | 103 |
1260662 | 1260662 | 2021-04-26 | Robertson | Tennessee | 47147 | 9692 | 130 |
1260663 | 1260663 | 2021-04-26 | Rutherford | Tennessee | 47149 | 42631 | 425 |
1260664 | 1260664 | 2021-04-26 | Scott | Tennessee | 47151 | 3073 | 45 |
1260665 | 1260665 | 2021-04-26 | Sequatchie | Tennessee | 47153 | 1681 | 29 |
1260666 | 1260666 | 2021-04-26 | Sevier | Tennessee | 47155 | 13264 | 175 |
1260667 | 1260667 | 2021-04-26 | Shelby | Tennessee | 47157 | 94856 | 1613 |
1260668 | 1260668 | 2021-04-26 | Smith | Tennessee | 47159 | 2758 | 39 |
1260669 | 1260669 | 2021-04-26 | Stewart | Tennessee | 47161 | 1315 | 28 |
1260670 | 1260670 | 2021-04-26 | Sullivan | Tennessee | 47163 | 16425 | 287 |
1260671 | 1260671 | 2021-04-26 | Sumner | Tennessee | 47165 | 23692 | 346 |
1260672 | 1260672 | 2021-04-26 | Tipton | Tennessee | 47167 | 7269 | 101 |
1260673 | 1260673 | 2021-04-26 | Trousdale | Tennessee | 47169 | 2495 | 22 |
1260674 | 1260674 | 2021-04-26 | Unicoi | Tennessee | 47171 | 1982 | 49 |
1260675 | 1260675 | 2021-04-26 | Union | Tennessee | 47173 | 1883 | 34 |
1260676 | 1260676 | 2021-04-26 | Unknown | Tennessee | 9167 | 121 | |
1260677 | 1260677 | 2021-04-26 | Van Buren | Tennessee | 47175 | 841 | 23 |
1260678 | 1260678 | 2021-04-26 | Warren | Tennessee | 47177 | 5533 | 81 |
1260679 | 1260679 | 2021-04-26 | Washington | Tennessee | 47179 | 14364 | 244 |
1260680 | 1260680 | 2021-04-26 | Wayne | Tennessee | 47181 | 2945 | 34 |
1260681 | 1260681 | 2021-04-26 | Weakley | Tennessee | 47183 | 4052 | 64 |
1260682 | 1260682 | 2021-04-26 | White | Tennessee | 47185 | 3586 | 68 |
1260683 | 1260683 | 2021-04-26 | Williamson | Tennessee | 47187 | 27730 | 216 |
1260684 | 1260684 | 2021-04-26 | Wilson | Tennessee | 47189 | 18631 | 230 |
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);