ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where date = "2020-04-26" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
91848 | 91848 | 2020-04-26 | Anderson | Tennessee | 47001 | 25 | 1 |
91849 | 91849 | 2020-04-26 | Bedford | Tennessee | 47003 | 159 | 2 |
91850 | 91850 | 2020-04-26 | Benton | Tennessee | 47005 | 6 | 1 |
91851 | 91851 | 2020-04-26 | Bledsoe | Tennessee | 47007 | 588 | 0 |
91852 | 91852 | 2020-04-26 | Blount | Tennessee | 47009 | 53 | 3 |
91853 | 91853 | 2020-04-26 | Bradley | Tennessee | 47011 | 43 | 1 |
91854 | 91854 | 2020-04-26 | Campbell | Tennessee | 47013 | 14 | 1 |
91855 | 91855 | 2020-04-26 | Cannon | Tennessee | 47015 | 10 | 0 |
91856 | 91856 | 2020-04-26 | Carroll | Tennessee | 47017 | 16 | 1 |
91857 | 91857 | 2020-04-26 | Carter | Tennessee | 47019 | 12 | 1 |
91858 | 91858 | 2020-04-26 | Cheatham | Tennessee | 47021 | 36 | 0 |
91859 | 91859 | 2020-04-26 | Chester | Tennessee | 47023 | 10 | 0 |
91860 | 91860 | 2020-04-26 | Claiborne | Tennessee | 47025 | 5 | 0 |
91861 | 91861 | 2020-04-26 | Clay | Tennessee | 47027 | 5 | 0 |
91862 | 91862 | 2020-04-26 | Cocke | Tennessee | 47029 | 14 | 0 |
91863 | 91863 | 2020-04-26 | Coffee | Tennessee | 47031 | 32 | 0 |
91864 | 91864 | 2020-04-26 | Crockett | Tennessee | 47033 | 7 | 0 |
91865 | 91865 | 2020-04-26 | Cumberland | Tennessee | 47035 | 67 | 0 |
91866 | 91866 | 2020-04-26 | Davidson | Tennessee | 47037 | 2370 | 23 |
91867 | 91867 | 2020-04-26 | DeKalb | Tennessee | 47041 | 13 | 0 |
91868 | 91868 | 2020-04-26 | Decatur | Tennessee | 47039 | 4 | 0 |
91869 | 91869 | 2020-04-26 | Dickson | Tennessee | 47043 | 66 | 0 |
91870 | 91870 | 2020-04-26 | Dyer | Tennessee | 47045 | 31 | 0 |
91871 | 91871 | 2020-04-26 | Fayette | Tennessee | 47047 | 52 | 1 |
91872 | 91872 | 2020-04-26 | Fentress | Tennessee | 47049 | 4 | 0 |
91873 | 91873 | 2020-04-26 | Franklin | Tennessee | 47051 | 29 | 1 |
91874 | 91874 | 2020-04-26 | Gibson | Tennessee | 47053 | 38 | 1 |
91875 | 91875 | 2020-04-26 | Giles | Tennessee | 47055 | 6 | 0 |
91876 | 91876 | 2020-04-26 | Grainger | Tennessee | 47057 | 4 | 0 |
91877 | 91877 | 2020-04-26 | Greene | Tennessee | 47059 | 41 | 2 |
91878 | 91878 | 2020-04-26 | Grundy | Tennessee | 47061 | 28 | 1 |
91879 | 91879 | 2020-04-26 | Hamblen | Tennessee | 47063 | 15 | 2 |
91880 | 91880 | 2020-04-26 | Hamilton | Tennessee | 47065 | 141 | 14 |
91881 | 91881 | 2020-04-26 | Hardeman | Tennessee | 47069 | 11 | 0 |
91882 | 91882 | 2020-04-26 | Hardin | Tennessee | 47071 | 5 | 0 |
91883 | 91883 | 2020-04-26 | Hawkins | Tennessee | 47073 | 29 | 2 |
91884 | 91884 | 2020-04-26 | Haywood | Tennessee | 47075 | 18 | 1 |
91885 | 91885 | 2020-04-26 | Henderson | Tennessee | 47077 | 6 | 0 |
91886 | 91886 | 2020-04-26 | Henry | Tennessee | 47079 | 11 | 0 |
91887 | 91887 | 2020-04-26 | Hickman | Tennessee | 47081 | 41 | 0 |
91888 | 91888 | 2020-04-26 | Houston | Tennessee | 47083 | 4 | 0 |
91889 | 91889 | 2020-04-26 | Humphreys | Tennessee | 47085 | 9 | 1 |
91890 | 91890 | 2020-04-26 | Jackson | Tennessee | 47087 | 7 | 0 |
91891 | 91891 | 2020-04-26 | Jefferson | Tennessee | 47089 | 18 | 0 |
91892 | 91892 | 2020-04-26 | Johnson | Tennessee | 47091 | 2 | 0 |
91893 | 91893 | 2020-04-26 | Knox | Tennessee | 47093 | 210 | 4 |
91894 | 91894 | 2020-04-26 | Lake | Tennessee | 47095 | 48 | 0 |
91895 | 91895 | 2020-04-26 | Lauderdale | Tennessee | 47097 | 18 | 0 |
91896 | 91896 | 2020-04-26 | Lawrence | Tennessee | 47099 | 16 | 0 |
91897 | 91897 | 2020-04-26 | Lewis | Tennessee | 47101 | 2 | 0 |
91898 | 91898 | 2020-04-26 | Lincoln | Tennessee | 47103 | 12 | 0 |
91899 | 91899 | 2020-04-26 | Loudon | Tennessee | 47105 | 27 | 0 |
91900 | 91900 | 2020-04-26 | Macon | Tennessee | 47111 | 38 | 3 |
91901 | 91901 | 2020-04-26 | Madison | Tennessee | 47113 | 101 | 1 |
91902 | 91902 | 2020-04-26 | Marion | Tennessee | 47115 | 28 | 1 |
91903 | 91903 | 2020-04-26 | Marshall | Tennessee | 47117 | 22 | 1 |
91904 | 91904 | 2020-04-26 | Maury | Tennessee | 47119 | 40 | 1 |
91905 | 91905 | 2020-04-26 | McMinn | Tennessee | 47107 | 14 | 0 |
91906 | 91906 | 2020-04-26 | McNairy | Tennessee | 47109 | 11 | 0 |
91907 | 91907 | 2020-04-26 | Meigs | Tennessee | 47121 | 6 | 0 |
91908 | 91908 | 2020-04-26 | Monroe | Tennessee | 47123 | 13 | 1 |
91909 | 91909 | 2020-04-26 | Montgomery | Tennessee | 47125 | 136 | 2 |
91910 | 91910 | 2020-04-26 | Moore | Tennessee | 47127 | 3 | 0 |
91911 | 91911 | 2020-04-26 | Morgan | Tennessee | 47129 | 6 | 0 |
91912 | 91912 | 2020-04-26 | Obion | Tennessee | 47131 | 12 | 1 |
91913 | 91913 | 2020-04-26 | Overton | Tennessee | 47133 | 7 | 0 |
91914 | 91914 | 2020-04-26 | Perry | Tennessee | 47135 | 8 | 0 |
91915 | 91915 | 2020-04-26 | Polk | Tennessee | 47139 | 7 | 0 |
91916 | 91916 | 2020-04-26 | Putnam | Tennessee | 47141 | 109 | 5 |
91917 | 91917 | 2020-04-26 | Rhea | Tennessee | 47143 | 4 | 0 |
91918 | 91918 | 2020-04-26 | Roane | Tennessee | 47145 | 8 | 0 |
91919 | 91919 | 2020-04-26 | Robertson | Tennessee | 47147 | 136 | 0 |
91920 | 91920 | 2020-04-26 | Rutherford | Tennessee | 47149 | 405 | 9 |
91921 | 91921 | 2020-04-26 | Scott | Tennessee | 47151 | 11 | 0 |
91922 | 91922 | 2020-04-26 | Sequatchie | Tennessee | 47153 | 5 | 0 |
91923 | 91923 | 2020-04-26 | Sevier | Tennessee | 47155 | 45 | 1 |
91924 | 91924 | 2020-04-26 | Shelby | Tennessee | 47157 | 2296 | 45 |
91925 | 91925 | 2020-04-26 | Smith | Tennessee | 47159 | 19 | 1 |
91926 | 91926 | 2020-04-26 | Stewart | Tennessee | 47161 | 7 | 0 |
91927 | 91927 | 2020-04-26 | Sullivan | Tennessee | 47163 | 47 | 1 |
91928 | 91928 | 2020-04-26 | Sumner | Tennessee | 47165 | 593 | 34 |
91929 | 91929 | 2020-04-26 | Tipton | Tennessee | 47167 | 94 | 0 |
91930 | 91930 | 2020-04-26 | Trousdale | Tennessee | 47169 | 48 | 1 |
91931 | 91931 | 2020-04-26 | Unicoi | Tennessee | 47171 | 1 | 0 |
91932 | 91932 | 2020-04-26 | Union | Tennessee | 47173 | 3 | 0 |
91933 | 91933 | 2020-04-26 | Van Buren | Tennessee | 47175 | 2 | 0 |
91934 | 91934 | 2020-04-26 | Warren | Tennessee | 47177 | 5 | 0 |
91935 | 91935 | 2020-04-26 | Washington | Tennessee | 47179 | 52 | 0 |
91936 | 91936 | 2020-04-26 | Wayne | Tennessee | 47181 | 2 | 0 |
91937 | 91937 | 2020-04-26 | Weakley | Tennessee | 47183 | 19 | 0 |
91938 | 91938 | 2020-04-26 | White | Tennessee | 47185 | 4 | 0 |
91939 | 91939 | 2020-04-26 | Williamson | Tennessee | 47187 | 397 | 7 |
91940 | 91940 | 2020-04-26 | Wilson | Tennessee | 47189 | 233 | 3 |
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);