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-08-14 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1617725 | 1617725 | 2021-08-14 | Anderson | Tennessee | 47001 | 9360 | 179 |
1617726 | 1617726 | 2021-08-14 | Bedford | Tennessee | 47003 | 7074 | 135 |
1617727 | 1617727 | 2021-08-14 | Benton | Tennessee | 47005 | 1858 | 41 |
1617728 | 1617728 | 2021-08-14 | Bledsoe | Tennessee | 47007 | 2421 | 13 |
1617729 | 1617729 | 2021-08-14 | Blount | Tennessee | 47009 | 17221 | 208 |
1617730 | 1617730 | 2021-08-14 | Bradley | Tennessee | 47011 | 16365 | 158 |
1617731 | 1617731 | 2021-08-14 | Campbell | Tennessee | 47013 | 4460 | 64 |
1617732 | 1617732 | 2021-08-14 | Cannon | Tennessee | 47015 | 2055 | 32 |
1617733 | 1617733 | 2021-08-14 | Carroll | Tennessee | 47017 | 3956 | 84 |
1617734 | 1617734 | 2021-08-14 | Carter | Tennessee | 47019 | 7245 | 168 |
1617735 | 1617735 | 2021-08-14 | Cheatham | Tennessee | 47021 | 4958 | 56 |
1617736 | 1617736 | 2021-08-14 | Chester | Tennessee | 47023 | 2462 | 51 |
1617737 | 1617737 | 2021-08-14 | Claiborne | Tennessee | 47025 | 3430 | 77 |
1617738 | 1617738 | 2021-08-14 | Clay | Tennessee | 47027 | 1141 | 30 |
1617739 | 1617739 | 2021-08-14 | Cocke | Tennessee | 47029 | 4964 | 102 |
1617740 | 1617740 | 2021-08-14 | Coffee | Tennessee | 47031 | 7332 | 123 |
1617741 | 1617741 | 2021-08-14 | Crockett | Tennessee | 47033 | 2406 | 52 |
1617742 | 1617742 | 2021-08-14 | Cumberland | Tennessee | 47035 | 7548 | 146 |
1617743 | 1617743 | 2021-08-14 | Davidson | Tennessee | 47037 | 106203 | 980 |
1617744 | 1617744 | 2021-08-14 | DeKalb | Tennessee | 47041 | 3012 | 57 |
1617745 | 1617745 | 2021-08-14 | Decatur | Tennessee | 47039 | 1746 | 39 |
1617746 | 1617746 | 2021-08-14 | Dickson | Tennessee | 47043 | 7572 | 118 |
1617747 | 1617747 | 2021-08-14 | Dyer | Tennessee | 47045 | 5890 | 110 |
1617748 | 1617748 | 2021-08-14 | Fayette | Tennessee | 47047 | 5738 | 85 |
1617749 | 1617749 | 2021-08-14 | Fentress | Tennessee | 47049 | 2647 | 49 |
1617750 | 1617750 | 2021-08-14 | Franklin | Tennessee | 47051 | 5704 | 92 |
1617751 | 1617751 | 2021-08-14 | Gibson | Tennessee | 47053 | 7499 | 152 |
1617752 | 1617752 | 2021-08-14 | Giles | Tennessee | 47055 | 4324 | 100 |
1617753 | 1617753 | 2021-08-14 | Grainger | Tennessee | 47057 | 2877 | 51 |
1617754 | 1617754 | 2021-08-14 | Greene | Tennessee | 47059 | 8686 | 163 |
1617755 | 1617755 | 2021-08-14 | Grundy | Tennessee | 47061 | 1961 | 35 |
1617756 | 1617756 | 2021-08-14 | Hamblen | Tennessee | 47063 | 9552 | 177 |
1617757 | 1617757 | 2021-08-14 | Hamilton | Tennessee | 47065 | 49961 | 529 |
1617758 | 1617758 | 2021-08-14 | Hancock | Tennessee | 47067 | 697 | 13 |
1617759 | 1617759 | 2021-08-14 | Hardeman | Tennessee | 47069 | 3872 | 65 |
1617760 | 1617760 | 2021-08-14 | Hardin | Tennessee | 47071 | 3926 | 70 |
1617761 | 1617761 | 2021-08-14 | Hawkins | Tennessee | 47073 | 6874 | 124 |
1617762 | 1617762 | 2021-08-14 | Haywood | Tennessee | 47075 | 2960 | 62 |
1617763 | 1617763 | 2021-08-14 | Henderson | Tennessee | 47077 | 4104 | 79 |
1617764 | 1617764 | 2021-08-14 | Henry | Tennessee | 47079 | 3824 | 76 |
1617765 | 1617765 | 2021-08-14 | Hickman | Tennessee | 47081 | 3132 | 48 |
1617766 | 1617766 | 2021-08-14 | Houston | Tennessee | 47083 | 1270 | 34 |
1617767 | 1617767 | 2021-08-14 | Humphreys | Tennessee | 47085 | 2154 | 32 |
1617768 | 1617768 | 2021-08-14 | Jackson | Tennessee | 47087 | 1430 | 37 |
1617769 | 1617769 | 2021-08-14 | Jefferson | Tennessee | 47089 | 6848 | 129 |
1617770 | 1617770 | 2021-08-14 | Johnson | Tennessee | 47091 | 2570 | 39 |
1617771 | 1617771 | 2021-08-14 | Knox | Tennessee | 47093 | 55617 | 669 |
1617772 | 1617772 | 2021-08-14 | Lake | Tennessee | 47095 | 1753 | 31 |
1617773 | 1617773 | 2021-08-14 | Lauderdale | Tennessee | 47097 | 3561 | 50 |
1617774 | 1617774 | 2021-08-14 | Lawrence | Tennessee | 47099 | 6575 | 101 |
1617775 | 1617775 | 2021-08-14 | Lewis | Tennessee | 47101 | 1788 | 27 |
1617776 | 1617776 | 2021-08-14 | Lincoln | Tennessee | 47103 | 4816 | 69 |
1617777 | 1617777 | 2021-08-14 | Loudon | Tennessee | 47105 | 6653 | 71 |
1617778 | 1617778 | 2021-08-14 | Macon | Tennessee | 47111 | 3931 | 78 |
1617779 | 1617779 | 2021-08-14 | Madison | Tennessee | 47113 | 12885 | 251 |
1617780 | 1617780 | 2021-08-14 | Marion | Tennessee | 47115 | 3590 | 50 |
1617781 | 1617781 | 2021-08-14 | Marshall | Tennessee | 47117 | 4703 | 65 |
1617782 | 1617782 | 2021-08-14 | Maury | Tennessee | 47119 | 14718 | 181 |
1617783 | 1617783 | 2021-08-14 | McMinn | Tennessee | 47107 | 7248 | 108 |
1617784 | 1617784 | 2021-08-14 | McNairy | Tennessee | 47109 | 3200 | 57 |
1617785 | 1617785 | 2021-08-14 | Meigs | Tennessee | 47121 | 1526 | 24 |
1617786 | 1617786 | 2021-08-14 | Monroe | Tennessee | 47123 | 6419 | 98 |
1617787 | 1617787 | 2021-08-14 | Montgomery | Tennessee | 47125 | 23086 | 236 |
1617788 | 1617788 | 2021-08-14 | Moore | Tennessee | 47127 | 1112 | 18 |
1617789 | 1617789 | 2021-08-14 | Morgan | Tennessee | 47129 | 2765 | 39 |
1617790 | 1617790 | 2021-08-14 | Obion | Tennessee | 47131 | 4886 | 98 |
1617791 | 1617791 | 2021-08-14 | Overton | Tennessee | 47133 | 3202 | 63 |
1617792 | 1617792 | 2021-08-14 | Perry | Tennessee | 47135 | 1157 | 29 |
1617793 | 1617793 | 2021-08-14 | Pickett | Tennessee | 47137 | 804 | 24 |
1617794 | 1617794 | 2021-08-14 | Polk | Tennessee | 47139 | 2283 | 25 |
1617795 | 1617795 | 2021-08-14 | Putnam | Tennessee | 47141 | 12417 | 183 |
1617796 | 1617796 | 2021-08-14 | Rhea | Tennessee | 47143 | 4726 | 83 |
1617797 | 1617797 | 2021-08-14 | Roane | Tennessee | 47145 | 6936 | 112 |
1617798 | 1617798 | 2021-08-14 | Robertson | Tennessee | 47147 | 10639 | 145 |
1617799 | 1617799 | 2021-08-14 | Rutherford | Tennessee | 47149 | 46828 | 458 |
1617800 | 1617800 | 2021-08-14 | Scott | Tennessee | 47151 | 3365 | 48 |
1617801 | 1617801 | 2021-08-14 | Sequatchie | Tennessee | 47153 | 1936 | 30 |
1617802 | 1617802 | 2021-08-14 | Sevier | Tennessee | 47155 | 14837 | 183 |
1617803 | 1617803 | 2021-08-14 | Shelby | Tennessee | 47157 | 112026 | 1777 |
1617804 | 1617804 | 2021-08-14 | Smith | Tennessee | 47159 | 3002 | 40 |
1617805 | 1617805 | 2021-08-14 | Stewart | Tennessee | 47161 | 1457 | 28 |
1617806 | 1617806 | 2021-08-14 | Sullivan | Tennessee | 47163 | 18698 | 323 |
1617807 | 1617807 | 2021-08-14 | Sumner | Tennessee | 47165 | 26688 | 364 |
1617808 | 1617808 | 2021-08-14 | Tipton | Tennessee | 47167 | 8436 | 107 |
1617809 | 1617809 | 2021-08-14 | Trousdale | Tennessee | 47169 | 2652 | 22 |
1617810 | 1617810 | 2021-08-14 | Unicoi | Tennessee | 47171 | 2187 | 51 |
1617811 | 1617811 | 2021-08-14 | Union | Tennessee | 47173 | 2041 | 34 |
1617812 | 1617812 | 2021-08-14 | Unknown | Tennessee | 9368 | 92 | |
1617813 | 1617813 | 2021-08-14 | Van Buren | Tennessee | 47175 | 919 | 23 |
1617814 | 1617814 | 2021-08-14 | Warren | Tennessee | 47177 | 5862 | 86 |
1617815 | 1617815 | 2021-08-14 | Washington | Tennessee | 47179 | 15845 | 258 |
1617816 | 1617816 | 2021-08-14 | Wayne | Tennessee | 47181 | 3140 | 36 |
1617817 | 1617817 | 2021-08-14 | Weakley | Tennessee | 47183 | 4506 | 70 |
1617818 | 1617818 | 2021-08-14 | White | Tennessee | 47185 | 3943 | 75 |
1617819 | 1617819 | 2021-08-14 | Williamson | Tennessee | 47187 | 31172 | 225 |
1617820 | 1617820 | 2021-08-14 | Wilson | Tennessee | 47189 | 20904 | 261 |
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);