ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-10-15" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
632881 | 632881 | 2020-10-15 | Alcona | Michigan | 26001 | 50 | 2 |
632882 | 632882 | 2020-10-15 | Alger | Michigan | 26003 | 68 | 0 |
632883 | 632883 | 2020-10-15 | Allegan | Michigan | 26005 | 989 | 7 |
632884 | 632884 | 2020-10-15 | Alpena | Michigan | 26007 | 148 | 14 |
632885 | 632885 | 2020-10-15 | Antrim | Michigan | 26009 | 88 | 0 |
632886 | 632886 | 2020-10-15 | Arenac | Michigan | 26011 | 84 | 3 |
632887 | 632887 | 2020-10-15 | Baraga | Michigan | 26013 | 64 | 3 |
632888 | 632888 | 2020-10-15 | Barry | Michigan | 26015 | 494 | 5 |
632889 | 632889 | 2020-10-15 | Bay | Michigan | 26017 | 1187 | 55 |
632890 | 632890 | 2020-10-15 | Benzie | Michigan | 26019 | 101 | 2 |
632891 | 632891 | 2020-10-15 | Berrien | Michigan | 26021 | 2254 | 77 |
632892 | 632892 | 2020-10-15 | Branch | Michigan | 26023 | 1557 | 33 |
632893 | 632893 | 2020-10-15 | Calhoun | Michigan | 26025 | 2087 | 51 |
632894 | 632894 | 2020-10-15 | Cass | Michigan | 26027 | 753 | 23 |
632895 | 632895 | 2020-10-15 | Charlevoix | Michigan | 26029 | 134 | 4 |
632896 | 632896 | 2020-10-15 | Cheboygan | Michigan | 26031 | 108 | 2 |
632897 | 632897 | 2020-10-15 | Chippewa | Michigan | 26033 | 98 | 0 |
632898 | 632898 | 2020-10-15 | Clare | Michigan | 26035 | 189 | 6 |
632899 | 632899 | 2020-10-15 | Clinton | Michigan | 26037 | 844 | 14 |
632900 | 632900 | 2020-10-15 | Crawford | Michigan | 26039 | 132 | 5 |
632901 | 632901 | 2020-10-15 | Delta | Michigan | 26041 | 912 | 16 |
632902 | 632902 | 2020-10-15 | Dickinson | Michigan | 26043 | 382 | 5 |
632903 | 632903 | 2020-10-15 | Eaton | Michigan | 26045 | 878 | 10 |
632904 | 632904 | 2020-10-15 | Emmet | Michigan | 26047 | 182 | 4 |
632905 | 632905 | 2020-10-15 | Genesee | Michigan | 26049 | 5694 | 320 |
632906 | 632906 | 2020-10-15 | Gladwin | Michigan | 26051 | 147 | 2 |
632907 | 632907 | 2020-10-15 | Gogebic | Michigan | 26053 | 224 | 2 |
632908 | 632908 | 2020-10-15 | Grand Traverse | Michigan | 26055 | 619 | 12 |
632909 | 632909 | 2020-10-15 | Gratiot | Michigan | 26057 | 395 | 16 |
632910 | 632910 | 2020-10-15 | Hillsdale | Michigan | 26059 | 429 | 27 |
632911 | 632911 | 2020-10-15 | Houghton | Michigan | 26061 | 832 | 6 |
632912 | 632912 | 2020-10-15 | Huron | Michigan | 26063 | 251 | 5 |
632913 | 632913 | 2020-10-15 | Ingham | Michigan | 26065 | 4176 | 57 |
632914 | 632914 | 2020-10-15 | Ionia | Michigan | 26067 | 697 | 8 |
632915 | 632915 | 2020-10-15 | Iosco | Michigan | 26069 | 253 | 14 |
632916 | 632916 | 2020-10-15 | Iron | Michigan | 26071 | 315 | 17 |
632917 | 632917 | 2020-10-15 | Isabella | Michigan | 26073 | 878 | 15 |
632918 | 632918 | 2020-10-15 | Jackson | Michigan | 26075 | 3122 | 82 |
632919 | 632919 | 2020-10-15 | Kalamazoo | Michigan | 26077 | 3932 | 99 |
632920 | 632920 | 2020-10-15 | Kalkaska | Michigan | 26079 | 106 | 4 |
632921 | 632921 | 2020-10-15 | Kent | Michigan | 26081 | 12030 | 173 |
632922 | 632922 | 2020-10-15 | Keweenaw | Michigan | 26083 | 16 | 0 |
632923 | 632923 | 2020-10-15 | Lake | Michigan | 26085 | 40 | 0 |
632924 | 632924 | 2020-10-15 | Lapeer | Michigan | 26087 | 1064 | 45 |
632925 | 632925 | 2020-10-15 | Leelanau | Michigan | 26089 | 125 | 1 |
632926 | 632926 | 2020-10-15 | Lenawee | Michigan | 26091 | 1713 | 22 |
632927 | 632927 | 2020-10-15 | Livingston | Michigan | 26093 | 1743 | 33 |
632928 | 632928 | 2020-10-15 | Luce | Michigan | 26095 | 284 | 0 |
632929 | 632929 | 2020-10-15 | Mackinac | Michigan | 26097 | 123 | 0 |
632930 | 632930 | 2020-10-15 | Macomb | Michigan | 26099 | 16793 | 1060 |
632931 | 632931 | 2020-10-15 | Manistee | Michigan | 26101 | 115 | 3 |
632932 | 632932 | 2020-10-15 | Marquette | Michigan | 26103 | 655 | 12 |
632933 | 632933 | 2020-10-15 | Mason | Michigan | 26105 | 164 | 1 |
632934 | 632934 | 2020-10-15 | Mecosta | Michigan | 26107 | 326 | 4 |
632935 | 632935 | 2020-10-15 | Menominee | Michigan | 26109 | 577 | 3 |
632936 | 632936 | 2020-10-15 | Midland | Michigan | 26111 | 767 | 13 |
632937 | 632937 | 2020-10-15 | Missaukee | Michigan | 26113 | 70 | 1 |
632938 | 632938 | 2020-10-15 | Monroe | Michigan | 26115 | 1753 | 29 |
632939 | 632939 | 2020-10-15 | Montcalm | Michigan | 26117 | 456 | 7 |
632940 | 632940 | 2020-10-15 | Montmorency | Michigan | 26119 | 19 | 0 |
632941 | 632941 | 2020-10-15 | Muskegon | Michigan | 26121 | 2772 | 78 |
632942 | 632942 | 2020-10-15 | Newaygo | Michigan | 26123 | 495 | 2 |
632943 | 632943 | 2020-10-15 | Oakland | Michigan | 26125 | 22571 | 1224 |
632944 | 632944 | 2020-10-15 | Oceana | Michigan | 26127 | 562 | 6 |
632945 | 632945 | 2020-10-15 | Ogemaw | Michigan | 26129 | 81 | 5 |
632946 | 632946 | 2020-10-15 | Ontonagon | Michigan | 26131 | 60 | 0 |
632947 | 632947 | 2020-10-15 | Osceola | Michigan | 26133 | 117 | 0 |
632948 | 632948 | 2020-10-15 | Oscoda | Michigan | 26135 | 50 | 1 |
632949 | 632949 | 2020-10-15 | Otsego | Michigan | 26137 | 214 | 12 |
632950 | 632950 | 2020-10-15 | Ottawa | Michigan | 26139 | 4187 | 70 |
632951 | 632951 | 2020-10-15 | Presque Isle | Michigan | 26141 | 33 | 1 |
632952 | 632952 | 2020-10-15 | Roscommon | Michigan | 26143 | 125 | 4 |
632953 | 632953 | 2020-10-15 | Saginaw | Michigan | 26145 | 3316 | 148 |
632954 | 632954 | 2020-10-15 | Sanilac | Michigan | 26151 | 163 | 7 |
632955 | 632955 | 2020-10-15 | Schoolcraft | Michigan | 26153 | 53 | 0 |
632956 | 632956 | 2020-10-15 | Shiawassee | Michigan | 26155 | 598 | 33 |
632957 | 632957 | 2020-10-15 | St. Clair | Michigan | 26147 | 1223 | 62 |
632958 | 632958 | 2020-10-15 | St. Joseph | Michigan | 26149 | 998 | 12 |
632959 | 632959 | 2020-10-15 | Tuscola | Michigan | 26157 | 557 | 34 |
632960 | 632960 | 2020-10-15 | Unknown | Michigan | 280 | 4 | |
632961 | 632961 | 2020-10-15 | Van Buren | Michigan | 26159 | 904 | 18 |
632962 | 632962 | 2020-10-15 | Washtenaw | Michigan | 26161 | 5004 | 126 |
632963 | 632963 | 2020-10-15 | Wayne | Michigan | 26163 | 37728 | 3019 |
632964 | 632964 | 2020-10-15 | Wexford | Michigan | 26165 | 149 | 4 |
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);