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-02 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1182645 | 1182645 | 2021-04-02 | Anderson | Tennessee | 47001 | 8469 | 166 |
1182646 | 1182646 | 2021-04-02 | Bedford | Tennessee | 47003 | 6251 | 125 |
1182647 | 1182647 | 2021-04-02 | Benton | Tennessee | 47005 | 1576 | 40 |
1182648 | 1182648 | 2021-04-02 | Bledsoe | Tennessee | 47007 | 2072 | 11 |
1182649 | 1182649 | 2021-04-02 | Blount | Tennessee | 47009 | 14717 | 194 |
1182650 | 1182650 | 2021-04-02 | Bradley | Tennessee | 47011 | 14067 | 145 |
1182651 | 1182651 | 2021-04-02 | Campbell | Tennessee | 47013 | 4013 | 61 |
1182652 | 1182652 | 2021-04-02 | Cannon | Tennessee | 47015 | 1856 | 31 |
1182653 | 1182653 | 2021-04-02 | Carroll | Tennessee | 47017 | 3540 | 82 |
1182654 | 1182654 | 2021-04-02 | Carter | Tennessee | 47019 | 6232 | 156 |
1182655 | 1182655 | 2021-04-02 | Cheatham | Tennessee | 47021 | 4283 | 50 |
1182656 | 1182656 | 2021-04-02 | Chester | Tennessee | 47023 | 2077 | 48 |
1182657 | 1182657 | 2021-04-02 | Claiborne | Tennessee | 47025 | 2979 | 74 |
1182658 | 1182658 | 2021-04-02 | Clay | Tennessee | 47027 | 1079 | 31 |
1182659 | 1182659 | 2021-04-02 | Cocke | Tennessee | 47029 | 4359 | 98 |
1182660 | 1182660 | 2021-04-02 | Coffee | Tennessee | 47031 | 6718 | 120 |
1182661 | 1182661 | 2021-04-02 | Crockett | Tennessee | 47033 | 1981 | 48 |
1182662 | 1182662 | 2021-04-02 | Cumberland | Tennessee | 47035 | 6379 | 125 |
1182663 | 1182663 | 2021-04-02 | Davidson | Tennessee | 47037 | 94741 | 902 |
1182664 | 1182664 | 2021-04-02 | DeKalb | Tennessee | 47041 | 2734 | 53 |
1182665 | 1182665 | 2021-04-02 | Decatur | Tennessee | 47039 | 1562 | 38 |
1182666 | 1182666 | 2021-04-02 | Dickson | Tennessee | 47043 | 6526 | 107 |
1182667 | 1182667 | 2021-04-02 | Dyer | Tennessee | 47045 | 5321 | 103 |
1182668 | 1182668 | 2021-04-02 | Fayette | Tennessee | 47047 | 4808 | 78 |
1182669 | 1182669 | 2021-04-02 | Fentress | Tennessee | 47049 | 2349 | 45 |
1182670 | 1182670 | 2021-04-02 | Franklin | Tennessee | 47051 | 5009 | 87 |
1182671 | 1182671 | 2021-04-02 | Gibson | Tennessee | 47053 | 6304 | 143 |
1182672 | 1182672 | 2021-04-02 | Giles | Tennessee | 47055 | 3865 | 98 |
1182673 | 1182673 | 2021-04-02 | Grainger | Tennessee | 47057 | 2524 | 48 |
1182674 | 1182674 | 2021-04-02 | Greene | Tennessee | 47059 | 7535 | 151 |
1182675 | 1182675 | 2021-04-02 | Grundy | Tennessee | 47061 | 1744 | 31 |
1182676 | 1182676 | 2021-04-02 | Hamblen | Tennessee | 47063 | 8363 | 170 |
1182677 | 1182677 | 2021-04-02 | Hamilton | Tennessee | 47065 | 42645 | 478 |
1182678 | 1182678 | 2021-04-02 | Hancock | Tennessee | 47067 | 527 | 12 |
1182679 | 1182679 | 2021-04-02 | Hardeman | Tennessee | 47069 | 3428 | 63 |
1182680 | 1182680 | 2021-04-02 | Hardin | Tennessee | 47071 | 3426 | 66 |
1182681 | 1182681 | 2021-04-02 | Hawkins | Tennessee | 47073 | 5574 | 104 |
1182682 | 1182682 | 2021-04-02 | Haywood | Tennessee | 47075 | 2670 | 60 |
1182683 | 1182683 | 2021-04-02 | Henderson | Tennessee | 47077 | 3666 | 74 |
1182684 | 1182684 | 2021-04-02 | Henry | Tennessee | 47079 | 3079 | 75 |
1182685 | 1182685 | 2021-04-02 | Hickman | Tennessee | 47081 | 2753 | 43 |
1182686 | 1182686 | 2021-04-02 | Houston | Tennessee | 47083 | 1063 | 33 |
1182687 | 1182687 | 2021-04-02 | Humphreys | Tennessee | 47085 | 1636 | 21 |
1182688 | 1182688 | 2021-04-02 | Jackson | Tennessee | 47087 | 1288 | 35 |
1182689 | 1182689 | 2021-04-02 | Jefferson | Tennessee | 47089 | 5946 | 121 |
1182690 | 1182690 | 2021-04-02 | Johnson | Tennessee | 47091 | 2228 | 38 |
1182691 | 1182691 | 2021-04-02 | Knox | Tennessee | 47093 | 49511 | 617 |
1182692 | 1182692 | 2021-04-02 | Lake | Tennessee | 47095 | 1689 | 26 |
1182693 | 1182693 | 2021-04-02 | Lauderdale | Tennessee | 47097 | 3115 | 44 |
1182694 | 1182694 | 2021-04-02 | Lawrence | Tennessee | 47099 | 5703 | 86 |
1182695 | 1182695 | 2021-04-02 | Lewis | Tennessee | 47101 | 1529 | 25 |
1182696 | 1182696 | 2021-04-02 | Lincoln | Tennessee | 47103 | 4254 | 63 |
1182697 | 1182697 | 2021-04-02 | Loudon | Tennessee | 47105 | 5904 | 68 |
1182698 | 1182698 | 2021-04-02 | Macon | Tennessee | 47111 | 3496 | 74 |
1182699 | 1182699 | 2021-04-02 | Madison | Tennessee | 47113 | 10508 | 238 |
1182700 | 1182700 | 2021-04-02 | Marion | Tennessee | 47115 | 3057 | 46 |
1182701 | 1182701 | 2021-04-02 | Marshall | Tennessee | 47117 | 4039 | 57 |
1182702 | 1182702 | 2021-04-02 | Maury | Tennessee | 47119 | 12741 | 162 |
1182703 | 1182703 | 2021-04-02 | McMinn | Tennessee | 47107 | 6202 | 96 |
1182704 | 1182704 | 2021-04-02 | McNairy | Tennessee | 47109 | 2743 | 54 |
1182705 | 1182705 | 2021-04-02 | Meigs | Tennessee | 47121 | 1313 | 23 |
1182706 | 1182706 | 2021-04-02 | Monroe | Tennessee | 47123 | 5579 | 95 |
1182707 | 1182707 | 2021-04-02 | Montgomery | Tennessee | 47125 | 18441 | 221 |
1182708 | 1182708 | 2021-04-02 | Moore | Tennessee | 47127 | 988 | 17 |
1182709 | 1182709 | 2021-04-02 | Morgan | Tennessee | 47129 | 2399 | 39 |
1182710 | 1182710 | 2021-04-02 | Obion | Tennessee | 47131 | 4443 | 96 |
1182711 | 1182711 | 2021-04-02 | Overton | Tennessee | 47133 | 2932 | 60 |
1182712 | 1182712 | 2021-04-02 | Perry | Tennessee | 47135 | 1054 | 28 |
1182713 | 1182713 | 2021-04-02 | Pickett | Tennessee | 47137 | 753 | 24 |
1182714 | 1182714 | 2021-04-02 | Polk | Tennessee | 47139 | 1930 | 24 |
1182715 | 1182715 | 2021-04-02 | Putnam | Tennessee | 47141 | 11001 | 173 |
1182716 | 1182716 | 2021-04-02 | Rhea | Tennessee | 47143 | 4253 | 75 |
1182717 | 1182717 | 2021-04-02 | Roane | Tennessee | 47145 | 6076 | 100 |
1182718 | 1182718 | 2021-04-02 | Robertson | Tennessee | 47147 | 9393 | 127 |
1182719 | 1182719 | 2021-04-02 | Rutherford | Tennessee | 47149 | 40924 | 409 |
1182720 | 1182720 | 2021-04-02 | Scott | Tennessee | 47151 | 2995 | 45 |
1182721 | 1182721 | 2021-04-02 | Sequatchie | Tennessee | 47153 | 1631 | 29 |
1182722 | 1182722 | 2021-04-02 | Sevier | Tennessee | 47155 | 12859 | 172 |
1182723 | 1182723 | 2021-04-02 | Shelby | Tennessee | 47157 | 91524 | 1570 |
1182724 | 1182724 | 2021-04-02 | Smith | Tennessee | 47159 | 2695 | 37 |
1182725 | 1182725 | 2021-04-02 | Stewart | Tennessee | 47161 | 1283 | 27 |
1182726 | 1182726 | 2021-04-02 | Sullivan | Tennessee | 47163 | 15468 | 281 |
1182727 | 1182727 | 2021-04-02 | Sumner | Tennessee | 47165 | 22594 | 337 |
1182728 | 1182728 | 2021-04-02 | Tipton | Tennessee | 47167 | 7134 | 104 |
1182729 | 1182729 | 2021-04-02 | Trousdale | Tennessee | 47169 | 2463 | 22 |
1182730 | 1182730 | 2021-04-02 | Unicoi | Tennessee | 47171 | 1879 | 49 |
1182731 | 1182731 | 2021-04-02 | Union | Tennessee | 47173 | 1824 | 34 |
1182732 | 1182732 | 2021-04-02 | Unknown | Tennessee | 8776 | 120 | |
1182733 | 1182733 | 2021-04-02 | Van Buren | Tennessee | 47175 | 817 | 21 |
1182734 | 1182734 | 2021-04-02 | Warren | Tennessee | 47177 | 5447 | 80 |
1182735 | 1182735 | 2021-04-02 | Washington | Tennessee | 47179 | 13533 | 239 |
1182736 | 1182736 | 2021-04-02 | Wayne | Tennessee | 47181 | 2937 | 33 |
1182737 | 1182737 | 2021-04-02 | Weakley | Tennessee | 47183 | 3939 | 60 |
1182738 | 1182738 | 2021-04-02 | White | Tennessee | 47185 | 3490 | 68 |
1182739 | 1182739 | 2021-04-02 | Williamson | Tennessee | 47187 | 26668 | 213 |
1182740 | 1182740 | 2021-04-02 | Wilson | Tennessee | 47189 | 17557 | 219 |
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);