ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where "date" is on date 2020-06-17 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
248776 | 248776 | 2020-06-17 | Anderson | Tennessee | 47001 | 66 | 2 |
248777 | 248777 | 2020-06-17 | Bedford | Tennessee | 47003 | 403 | 4 |
248778 | 248778 | 2020-06-17 | Benton | Tennessee | 47005 | 8 | 1 |
248779 | 248779 | 2020-06-17 | Bledsoe | Tennessee | 47007 | 614 | 1 |
248780 | 248780 | 2020-06-17 | Blount | Tennessee | 47009 | 115 | 3 |
248781 | 248781 | 2020-06-17 | Bradley | Tennessee | 47011 | 303 | 2 |
248782 | 248782 | 2020-06-17 | Campbell | Tennessee | 47013 | 25 | 1 |
248783 | 248783 | 2020-06-17 | Cannon | Tennessee | 47015 | 34 | 0 |
248784 | 248784 | 2020-06-17 | Carroll | Tennessee | 47017 | 36 | 1 |
248785 | 248785 | 2020-06-17 | Carter | Tennessee | 47019 | 22 | 1 |
248786 | 248786 | 2020-06-17 | Cheatham | Tennessee | 47021 | 159 | 0 |
248787 | 248787 | 2020-06-17 | Chester | Tennessee | 47023 | 14 | 0 |
248788 | 248788 | 2020-06-17 | Claiborne | Tennessee | 47025 | 15 | 0 |
248789 | 248789 | 2020-06-17 | Clay | Tennessee | 47027 | 11 | 0 |
248790 | 248790 | 2020-06-17 | Cocke | Tennessee | 47029 | 27 | 0 |
248791 | 248791 | 2020-06-17 | Coffee | Tennessee | 47031 | 97 | 0 |
248792 | 248792 | 2020-06-17 | Crockett | Tennessee | 47033 | 19 | 3 |
248793 | 248793 | 2020-06-17 | Cumberland | Tennessee | 47035 | 137 | 3 |
248794 | 248794 | 2020-06-17 | Davidson | Tennessee | 47037 | 7483 | 91 |
248795 | 248795 | 2020-06-17 | DeKalb | Tennessee | 47041 | 41 | 0 |
248796 | 248796 | 2020-06-17 | Decatur | Tennessee | 47039 | 14 | 0 |
248797 | 248797 | 2020-06-17 | Dickson | Tennessee | 47043 | 140 | 0 |
248798 | 248798 | 2020-06-17 | Dyer | Tennessee | 47045 | 116 | 0 |
248799 | 248799 | 2020-06-17 | Fayette | Tennessee | 47047 | 186 | 2 |
248800 | 248800 | 2020-06-17 | Fentress | Tennessee | 47049 | 15 | 0 |
248801 | 248801 | 2020-06-17 | Franklin | Tennessee | 47051 | 64 | 2 |
248802 | 248802 | 2020-06-17 | Gibson | Tennessee | 47053 | 69 | 1 |
248803 | 248803 | 2020-06-17 | Giles | Tennessee | 47055 | 23 | 0 |
248804 | 248804 | 2020-06-17 | Grainger | Tennessee | 47057 | 22 | 0 |
248805 | 248805 | 2020-06-17 | Greene | Tennessee | 47059 | 55 | 2 |
248806 | 248806 | 2020-06-17 | Grundy | Tennessee | 47061 | 37 | 1 |
248807 | 248807 | 2020-06-17 | Hamblen | Tennessee | 47063 | 92 | 4 |
248808 | 248808 | 2020-06-17 | Hamilton | Tennessee | 47065 | 1988 | 24 |
248809 | 248809 | 2020-06-17 | Hancock | Tennessee | 47067 | 1 | 0 |
248810 | 248810 | 2020-06-17 | Hardeman | Tennessee | 47069 | 226 | 0 |
248811 | 248811 | 2020-06-17 | Hardin | Tennessee | 47071 | 44 | 5 |
248812 | 248812 | 2020-06-17 | Hawkins | Tennessee | 47073 | 37 | 2 |
248813 | 248813 | 2020-06-17 | Haywood | Tennessee | 47075 | 39 | 2 |
248814 | 248814 | 2020-06-17 | Henderson | Tennessee | 47077 | 19 | 0 |
248815 | 248815 | 2020-06-17 | Henry | Tennessee | 47079 | 35 | 0 |
248816 | 248816 | 2020-06-17 | Hickman | Tennessee | 47081 | 62 | 0 |
248817 | 248817 | 2020-06-17 | Houston | Tennessee | 47083 | 10 | 0 |
248818 | 248818 | 2020-06-17 | Humphreys | Tennessee | 47085 | 18 | 1 |
248819 | 248819 | 2020-06-17 | Jackson | Tennessee | 47087 | 20 | 0 |
248820 | 248820 | 2020-06-17 | Jefferson | Tennessee | 47089 | 48 | 0 |
248821 | 248821 | 2020-06-17 | Johnson | Tennessee | 47091 | 25 | 0 |
248822 | 248822 | 2020-06-17 | Knox | Tennessee | 47093 | 617 | 5 |
248823 | 248823 | 2020-06-17 | Lake | Tennessee | 47095 | 689 | 0 |
248824 | 248824 | 2020-06-17 | Lauderdale | Tennessee | 47097 | 71 | 1 |
248825 | 248825 | 2020-06-17 | Lawrence | Tennessee | 47099 | 72 | 2 |
248826 | 248826 | 2020-06-17 | Lewis | Tennessee | 47101 | 5 | 0 |
248827 | 248827 | 2020-06-17 | Lincoln | Tennessee | 47103 | 48 | 0 |
248828 | 248828 | 2020-06-17 | Loudon | Tennessee | 47105 | 214 | 1 |
248829 | 248829 | 2020-06-17 | Macon | Tennessee | 47111 | 209 | 3 |
248830 | 248830 | 2020-06-17 | Madison | Tennessee | 47113 | 188 | 2 |
248831 | 248831 | 2020-06-17 | Marion | Tennessee | 47115 | 49 | 2 |
248832 | 248832 | 2020-06-17 | Marshall | Tennessee | 47117 | 44 | 1 |
248833 | 248833 | 2020-06-17 | Maury | Tennessee | 47119 | 177 | 1 |
248834 | 248834 | 2020-06-17 | McMinn | Tennessee | 47107 | 170 | 15 |
248835 | 248835 | 2020-06-17 | McNairy | Tennessee | 47109 | 33 | 0 |
248836 | 248836 | 2020-06-17 | Meigs | Tennessee | 47121 | 29 | 0 |
248837 | 248837 | 2020-06-17 | Monroe | Tennessee | 47123 | 93 | 4 |
248838 | 248838 | 2020-06-17 | Montgomery | Tennessee | 47125 | 341 | 5 |
248839 | 248839 | 2020-06-17 | Moore | Tennessee | 47127 | 5 | 0 |
248840 | 248840 | 2020-06-17 | Morgan | Tennessee | 47129 | 21 | 1 |
248841 | 248841 | 2020-06-17 | Obion | Tennessee | 47131 | 67 | 1 |
248842 | 248842 | 2020-06-17 | Overton | Tennessee | 47133 | 38 | 0 |
248843 | 248843 | 2020-06-17 | Perry | Tennessee | 47135 | 28 | 0 |
248844 | 248844 | 2020-06-17 | Pickett | Tennessee | 47137 | 4 | 0 |
248845 | 248845 | 2020-06-17 | Polk | Tennessee | 47139 | 32 | 0 |
248846 | 248846 | 2020-06-17 | Putnam | Tennessee | 47141 | 612 | 6 |
248847 | 248847 | 2020-06-17 | Rhea | Tennessee | 47143 | 243 | 0 |
248848 | 248848 | 2020-06-17 | Roane | Tennessee | 47145 | 32 | 0 |
248849 | 248849 | 2020-06-17 | Robertson | Tennessee | 47147 | 658 | 9 |
248850 | 248850 | 2020-06-17 | Rutherford | Tennessee | 47149 | 1851 | 31 |
248851 | 248851 | 2020-06-17 | Scott | Tennessee | 47151 | 14 | 0 |
248852 | 248852 | 2020-06-17 | Sequatchie | Tennessee | 47153 | 23 | 0 |
248853 | 248853 | 2020-06-17 | Sevier | Tennessee | 47155 | 297 | 3 |
248854 | 248854 | 2020-06-17 | Shelby | Tennessee | 47157 | 7244 | 154 |
248855 | 248855 | 2020-06-17 | Smith | Tennessee | 47159 | 43 | 1 |
248856 | 248856 | 2020-06-17 | Stewart | Tennessee | 47161 | 16 | 0 |
248857 | 248857 | 2020-06-17 | Sullivan | Tennessee | 47163 | 71 | 2 |
248858 | 248858 | 2020-06-17 | Sumner | Tennessee | 47165 | 1119 | 48 |
248859 | 248859 | 2020-06-17 | Tipton | Tennessee | 47167 | 534 | 4 |
248860 | 248860 | 2020-06-17 | Trousdale | Tennessee | 47169 | 1460 | 4 |
248861 | 248861 | 2020-06-17 | Unicoi | Tennessee | 47171 | 52 | 0 |
248862 | 248862 | 2020-06-17 | Union | Tennessee | 47173 | 9 | 0 |
248863 | 248863 | 2020-06-17 | Van Buren | Tennessee | 47175 | 5 | 0 |
248864 | 248864 | 2020-06-17 | Warren | Tennessee | 47177 | 35 | 0 |
248865 | 248865 | 2020-06-17 | Washington | Tennessee | 47179 | 93 | 0 |
248866 | 248866 | 2020-06-17 | Wayne | Tennessee | 47181 | 64 | 0 |
248867 | 248867 | 2020-06-17 | Weakley | Tennessee | 47183 | 35 | 0 |
248868 | 248868 | 2020-06-17 | White | Tennessee | 47185 | 50 | 2 |
248869 | 248869 | 2020-06-17 | Williamson | Tennessee | 47187 | 730 | 12 |
248870 | 248870 | 2020-06-17 | Wilson | Tennessee | 47189 | 544 | 14 |
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);