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 2020-12-30 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
880773 | 880773 | 2020-12-30 | Anderson | Tennessee | 47001 | 5595 | 66 |
880774 | 880774 | 2020-12-30 | Bedford | Tennessee | 47003 | 4500 | 60 |
880775 | 880775 | 2020-12-30 | Benton | Tennessee | 47005 | 1167 | 30 |
880776 | 880776 | 2020-12-30 | Bledsoe | Tennessee | 47007 | 1559 | 9 |
880777 | 880777 | 2020-12-30 | Blount | Tennessee | 47009 | 9859 | 97 |
880778 | 880778 | 2020-12-30 | Bradley | Tennessee | 47011 | 8994 | 72 |
880779 | 880779 | 2020-12-30 | Campbell | Tennessee | 47013 | 2711 | 36 |
880780 | 880780 | 2020-12-30 | Cannon | Tennessee | 47015 | 1351 | 15 |
880781 | 880781 | 2020-12-30 | Carroll | Tennessee | 47017 | 2679 | 52 |
880782 | 880782 | 2020-12-30 | Carter | Tennessee | 47019 | 4415 | 86 |
880783 | 880783 | 2020-12-30 | Cheatham | Tennessee | 47021 | 2831 | 24 |
880784 | 880784 | 2020-12-30 | Chester | Tennessee | 47023 | 1474 | 31 |
880785 | 880785 | 2020-12-30 | Claiborne | Tennessee | 47025 | 1659 | 18 |
880786 | 880786 | 2020-12-30 | Clay | Tennessee | 47027 | 840 | 23 |
880787 | 880787 | 2020-12-30 | Cocke | Tennessee | 47029 | 2814 | 40 |
880788 | 880788 | 2020-12-30 | Coffee | Tennessee | 47031 | 4866 | 65 |
880789 | 880789 | 2020-12-30 | Crockett | Tennessee | 47033 | 1628 | 29 |
880790 | 880790 | 2020-12-30 | Cumberland | Tennessee | 47035 | 4358 | 51 |
880791 | 880791 | 2020-12-30 | Davidson | Tennessee | 47037 | 67644 | 564 |
880792 | 880792 | 2020-12-30 | DeKalb | Tennessee | 47041 | 2074 | 32 |
880793 | 880793 | 2020-12-30 | Decatur | Tennessee | 47039 | 1324 | 20 |
880794 | 880794 | 2020-12-30 | Dickson | Tennessee | 47043 | 4593 | 59 |
880795 | 880795 | 2020-12-30 | Dyer | Tennessee | 47045 | 4229 | 70 |
880796 | 880796 | 2020-12-30 | Fayette | Tennessee | 47047 | 3305 | 48 |
880797 | 880797 | 2020-12-30 | Fentress | Tennessee | 47049 | 1870 | 29 |
880798 | 880798 | 2020-12-30 | Franklin | Tennessee | 47051 | 3491 | 48 |
880799 | 880799 | 2020-12-30 | Gibson | Tennessee | 47053 | 5000 | 90 |
880800 | 880800 | 2020-12-30 | Giles | Tennessee | 47055 | 2599 | 60 |
880801 | 880801 | 2020-12-30 | Grainger | Tennessee | 47057 | 1757 | 25 |
880802 | 880802 | 2020-12-30 | Greene | Tennessee | 47059 | 5482 | 92 |
880803 | 880803 | 2020-12-30 | Grundy | Tennessee | 47061 | 1186 | 18 |
880804 | 880804 | 2020-12-30 | Hamblen | Tennessee | 47063 | 5799 | 83 |
880805 | 880805 | 2020-12-30 | Hamilton | Tennessee | 47065 | 28930 | 269 |
880806 | 880806 | 2020-12-30 | Hancock | Tennessee | 47067 | 323 | 5 |
880807 | 880807 | 2020-12-30 | Hardeman | Tennessee | 47069 | 2814 | 41 |
880808 | 880808 | 2020-12-30 | Hardin | Tennessee | 47071 | 2612 | 35 |
880809 | 880809 | 2020-12-30 | Hawkins | Tennessee | 47073 | 3596 | 56 |
880810 | 880810 | 2020-12-30 | Haywood | Tennessee | 47075 | 2156 | 36 |
880811 | 880811 | 2020-12-30 | Henderson | Tennessee | 47077 | 2918 | 44 |
880812 | 880812 | 2020-12-30 | Henry | Tennessee | 47079 | 2304 | 36 |
880813 | 880813 | 2020-12-30 | Hickman | Tennessee | 47081 | 1889 | 26 |
880814 | 880814 | 2020-12-30 | Houston | Tennessee | 47083 | 796 | 22 |
880815 | 880815 | 2020-12-30 | Humphreys | Tennessee | 47085 | 1165 | 12 |
880816 | 880816 | 2020-12-30 | Jackson | Tennessee | 47087 | 940 | 19 |
880817 | 880817 | 2020-12-30 | Jefferson | Tennessee | 47089 | 3825 | 60 |
880818 | 880818 | 2020-12-30 | Johnson | Tennessee | 47091 | 1769 | 28 |
880819 | 880819 | 2020-12-30 | Knox | Tennessee | 47093 | 32974 | 315 |
880820 | 880820 | 2020-12-30 | Lake | Tennessee | 47095 | 1393 | 13 |
880821 | 880821 | 2020-12-30 | Lauderdale | Tennessee | 47097 | 2612 | 28 |
880822 | 880822 | 2020-12-30 | Lawrence | Tennessee | 47099 | 4369 | 57 |
880823 | 880823 | 2020-12-30 | Lewis | Tennessee | 47101 | 1144 | 19 |
880824 | 880824 | 2020-12-30 | Lincoln | Tennessee | 47103 | 3227 | 32 |
880825 | 880825 | 2020-12-30 | Loudon | Tennessee | 47105 | 4164 | 36 |
880826 | 880826 | 2020-12-30 | Macon | Tennessee | 47111 | 2565 | 44 |
880827 | 880827 | 2020-12-30 | Madison | Tennessee | 47113 | 7966 | 151 |
880828 | 880828 | 2020-12-30 | Marion | Tennessee | 47115 | 1839 | 25 |
880829 | 880829 | 2020-12-30 | Marshall | Tennessee | 47117 | 2821 | 30 |
880830 | 880830 | 2020-12-30 | Maury | Tennessee | 47119 | 9173 | 104 |
880831 | 880831 | 2020-12-30 | McMinn | Tennessee | 47107 | 4301 | 65 |
880832 | 880832 | 2020-12-30 | McNairy | Tennessee | 47109 | 2033 | 38 |
880833 | 880833 | 2020-12-30 | Meigs | Tennessee | 47121 | 955 | 15 |
880834 | 880834 | 2020-12-30 | Monroe | Tennessee | 47123 | 3820 | 54 |
880835 | 880835 | 2020-12-30 | Montgomery | Tennessee | 47125 | 11385 | 124 |
880836 | 880836 | 2020-12-30 | Moore | Tennessee | 47127 | 684 | 6 |
880837 | 880837 | 2020-12-30 | Morgan | Tennessee | 47129 | 1511 | 11 |
880838 | 880838 | 2020-12-30 | Obion | Tennessee | 47131 | 3603 | 71 |
880839 | 880839 | 2020-12-30 | Overton | Tennessee | 47133 | 2168 | 41 |
880840 | 880840 | 2020-12-30 | Perry | Tennessee | 47135 | 847 | 23 |
880841 | 880841 | 2020-12-30 | Pickett | Tennessee | 47137 | 563 | 17 |
880842 | 880842 | 2020-12-30 | Polk | Tennessee | 47139 | 1156 | 16 |
880843 | 880843 | 2020-12-30 | Putnam | Tennessee | 47141 | 8600 | 119 |
880844 | 880844 | 2020-12-30 | Rhea | Tennessee | 47143 | 3141 | 48 |
880845 | 880845 | 2020-12-30 | Roane | Tennessee | 47145 | 4289 | 54 |
880846 | 880846 | 2020-12-30 | Robertson | Tennessee | 47147 | 6473 | 73 |
880847 | 880847 | 2020-12-30 | Rutherford | Tennessee | 47149 | 28272 | 241 |
880848 | 880848 | 2020-12-30 | Scott | Tennessee | 47151 | 1967 | 22 |
880849 | 880849 | 2020-12-30 | Sequatchie | Tennessee | 47153 | 1144 | 16 |
880850 | 880850 | 2020-12-30 | Sevier | Tennessee | 47155 | 8818 | 70 |
880851 | 880851 | 2020-12-30 | Shelby | Tennessee | 47157 | 66437 | 889 |
880852 | 880852 | 2020-12-30 | Smith | Tennessee | 47159 | 2021 | 24 |
880853 | 880853 | 2020-12-30 | Stewart | Tennessee | 47161 | 875 | 20 |
880854 | 880854 | 2020-12-30 | Sullivan | Tennessee | 47163 | 10739 | 177 |
880855 | 880855 | 2020-12-30 | Sumner | Tennessee | 47165 | 15645 | 203 |
880856 | 880856 | 2020-12-30 | Tipton | Tennessee | 47167 | 5388 | 53 |
880857 | 880857 | 2020-12-30 | Trousdale | Tennessee | 47169 | 2154 | 12 |
880858 | 880858 | 2020-12-30 | Unicoi | Tennessee | 47171 | 1437 | 40 |
880859 | 880859 | 2020-12-30 | Union | Tennessee | 47173 | 1208 | 14 |
880860 | 880860 | 2020-12-30 | Unknown | Tennessee | 7679 | 50 | |
880861 | 880861 | 2020-12-30 | Van Buren | Tennessee | 47175 | 541 | 6 |
880862 | 880862 | 2020-12-30 | Warren | Tennessee | 47177 | 4367 | 41 |
880863 | 880863 | 2020-12-30 | Washington | Tennessee | 47179 | 10131 | 164 |
880864 | 880864 | 2020-12-30 | Wayne | Tennessee | 47181 | 2401 | 17 |
880865 | 880865 | 2020-12-30 | Weakley | Tennessee | 47183 | 3047 | 43 |
880866 | 880866 | 2020-12-30 | White | Tennessee | 47185 | 2714 | 39 |
880867 | 880867 | 2020-12-30 | Williamson | Tennessee | 47187 | 17681 | 122 |
880868 | 880868 | 2020-12-30 | Wilson | Tennessee | 47189 | 12325 | 125 |
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);