ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2021-11-20 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1934838 | 1934838 | 2021-11-20 | Alcona | Michigan | 26001 | 1264 | 47 |
1934839 | 1934839 | 2021-11-20 | Alger | Michigan | 26003 | 1091 | 9 |
1934840 | 1934840 | 2021-11-20 | Allegan | Michigan | 26005 | 17036 | 212 |
1934841 | 1934841 | 2021-11-20 | Alpena | Michigan | 26007 | 3814 | 81 |
1934842 | 1934842 | 2021-11-20 | Antrim | Michigan | 26009 | 2725 | 41 |
1934843 | 1934843 | 2021-11-20 | Arenac | Michigan | 26011 | 2025 | 41 |
1934844 | 1934844 | 2021-11-20 | Baraga | Michigan | 26013 | 1521 | 47 |
1934845 | 1934845 | 2021-11-20 | Barry | Michigan | 26015 | 9113 | 99 |
1934846 | 1934846 | 2021-11-20 | Bay | Michigan | 26017 | 16543 | 415 |
1934847 | 1934847 | 2021-11-20 | Benzie | Michigan | 26019 | 1961 | 44 |
1934848 | 1934848 | 2021-11-20 | Berrien | Michigan | 26021 | 20896 | 341 |
1934849 | 1934849 | 2021-11-20 | Branch | Michigan | 26023 | 8140 | 141 |
1934850 | 1934850 | 2021-11-20 | Calhoun | Michigan | 26025 | 20812 | 372 |
1934851 | 1934851 | 2021-11-20 | Cass | Michigan | 26027 | 7737 | 97 |
1934852 | 1934852 | 2021-11-20 | Charlevoix | Michigan | 26029 | 2886 | 42 |
1934853 | 1934853 | 2021-11-20 | Cheboygan | Michigan | 26031 | 3183 | 71 |
1934854 | 1934854 | 2021-11-20 | Chippewa | Michigan | 26033 | 7436 | 69 |
1934855 | 1934855 | 2021-11-20 | Clare | Michigan | 26035 | 4341 | 113 |
1934856 | 1934856 | 2021-11-20 | Clinton | Michigan | 26037 | 11641 | 126 |
1934857 | 1934857 | 2021-11-20 | Crawford | Michigan | 26039 | 1620 | 17 |
1934858 | 1934858 | 2021-11-20 | Delta | Michigan | 26041 | 6386 | 115 |
1934859 | 1934859 | 2021-11-20 | Dickinson | Michigan | 26043 | 4414 | 85 |
1934860 | 1934860 | 2021-11-20 | Eaton | Michigan | 26045 | 15227 | 264 |
1934861 | 1934861 | 2021-11-20 | Emmet | Michigan | 26047 | 3793 | 55 |
1934862 | 1934862 | 2021-11-20 | Genesee | Michigan | 26049 | 58231 | 1148 |
1934863 | 1934863 | 2021-11-20 | Gladwin | Michigan | 26051 | 3612 | 80 |
1934864 | 1934864 | 2021-11-20 | Gogebic | Michigan | 26053 | 1988 | 55 |
1934865 | 1934865 | 2021-11-20 | Grand Traverse | Michigan | 26055 | 10301 | 124 |
1934866 | 1934866 | 2021-11-20 | Gratiot | Michigan | 26057 | 9596 | 141 |
1934867 | 1934867 | 2021-11-20 | Hillsdale | Michigan | 26059 | 6984 | 140 |
1934868 | 1934868 | 2021-11-20 | Houghton | Michigan | 26061 | 4940 | 59 |
1934869 | 1934869 | 2021-11-20 | Huron | Michigan | 26063 | 5450 | 100 |
1934870 | 1934870 | 2021-11-20 | Ingham | Michigan | 26065 | 34852 | 487 |
1934871 | 1934871 | 2021-11-20 | Ionia | Michigan | 26067 | 13147 | 114 |
1934872 | 1934872 | 2021-11-20 | Iosco | Michigan | 26069 | 3385 | 103 |
1934873 | 1934873 | 2021-11-20 | Iron | Michigan | 26071 | 1623 | 62 |
1934874 | 1934874 | 2021-11-20 | Isabella | Michigan | 26073 | 10032 | 138 |
1934875 | 1934875 | 2021-11-20 | Jackson | Michigan | 26075 | 29583 | 393 |
1934876 | 1934876 | 2021-11-20 | Kalamazoo | Michigan | 26077 | 33154 | 479 |
1934877 | 1934877 | 2021-11-20 | Kalkaska | Michigan | 26079 | 2021 | 40 |
1934878 | 1934878 | 2021-11-20 | Kent | Michigan | 26081 | 104456 | 1050 |
1934879 | 1934879 | 2021-11-20 | Keweenaw | Michigan | 26083 | 334 | 7 |
1934880 | 1934880 | 2021-11-20 | Lake | Michigan | 26085 | 1120 | 24 |
1934881 | 1934881 | 2021-11-20 | Lapeer | Michigan | 26087 | 13381 | 268 |
1934882 | 1934882 | 2021-11-20 | Leelanau | Michigan | 26089 | 1956 | 29 |
1934883 | 1934883 | 2021-11-20 | Lenawee | Michigan | 26091 | 16606 | 218 |
1934884 | 1934884 | 2021-11-20 | Livingston | Michigan | 26093 | 26875 | 268 |
1934885 | 1934885 | 2021-11-20 | Luce | Michigan | 26095 | 1677 | 6 |
1934886 | 1934886 | 2021-11-20 | Mackinac | Michigan | 26097 | 1426 | 14 |
1934887 | 1934887 | 2021-11-20 | Macomb | Michigan | 26099 | 133940 | 2814 |
1934888 | 1934888 | 2021-11-20 | Manistee | Michigan | 26101 | 2816 | 44 |
1934889 | 1934889 | 2021-11-20 | Marquette | Michigan | 26103 | 8777 | 88 |
1934890 | 1934890 | 2021-11-20 | Mason | Michigan | 26105 | 3850 | 54 |
1934891 | 1934891 | 2021-11-20 | Mecosta | Michigan | 26107 | 5443 | 56 |
1934892 | 1934892 | 2021-11-20 | Menominee | Michigan | 26109 | 3725 | 52 |
1934893 | 1934893 | 2021-11-20 | Midland | Michigan | 26111 | 11539 | 154 |
1934894 | 1934894 | 2021-11-20 | Missaukee | Michigan | 26113 | 2012 | 41 |
1934895 | 1934895 | 2021-11-20 | Monroe | Michigan | 26115 | 22881 | 321 |
1934896 | 1934896 | 2021-11-20 | Montcalm | Michigan | 26117 | 12026 | 144 |
1934897 | 1934897 | 2021-11-20 | Montmorency | Michigan | 26119 | 1192 | 33 |
1934898 | 1934898 | 2021-11-20 | Muskegon | Michigan | 26121 | 26649 | 442 |
1934899 | 1934899 | 2021-11-20 | Newaygo | Michigan | 26123 | 7438 | 90 |
1934900 | 1934900 | 2021-11-20 | Oakland | Michigan | 26125 | 160301 | 2761 |
1934901 | 1934901 | 2021-11-20 | Oceana | Michigan | 26127 | 4187 | 72 |
1934902 | 1934902 | 2021-11-20 | Ogemaw | Michigan | 26129 | 2930 | 68 |
1934903 | 1934903 | 2021-11-20 | Ontonagon | Michigan | 26131 | 680 | 23 |
1934904 | 1934904 | 2021-11-20 | Osceola | Michigan | 26133 | 3429 | 47 |
1934905 | 1934905 | 2021-11-20 | Oscoda | Michigan | 26135 | 1063 | 41 |
1934906 | 1934906 | 2021-11-20 | Otsego | Michigan | 26137 | 3784 | 65 |
1934907 | 1934907 | 2021-11-20 | Ottawa | Michigan | 26139 | 46980 | 544 |
1934908 | 1934908 | 2021-11-20 | Presque Isle | Michigan | 26141 | 1562 | 43 |
1934909 | 1934909 | 2021-11-20 | Roscommon | Michigan | 26143 | 3050 | 75 |
1934910 | 1934910 | 2021-11-20 | Saginaw | Michigan | 26145 | 31523 | 702 |
1934911 | 1934911 | 2021-11-20 | Sanilac | Michigan | 26151 | 5676 | 145 |
1934912 | 1934912 | 2021-11-20 | Schoolcraft | Michigan | 26153 | 960 | 6 |
1934913 | 1934913 | 2021-11-20 | Shiawassee | Michigan | 26155 | 10280 | 142 |
1934914 | 1934914 | 2021-11-20 | St. Clair | Michigan | 26147 | 25021 | 541 |
1934915 | 1934915 | 2021-11-20 | St. Joseph | Michigan | 26149 | 9422 | 128 |
1934916 | 1934916 | 2021-11-20 | Tuscola | Michigan | 26157 | 8352 | 213 |
1934917 | 1934917 | 2021-11-20 | Unknown | Michigan | 1688 | 17 | |
1934918 | 1934918 | 2021-11-20 | Van Buren | Michigan | 26159 | 10431 | 176 |
1934919 | 1934919 | 2021-11-20 | Washtenaw | Michigan | 26161 | 37467 | 345 |
1934920 | 1934920 | 2021-11-20 | Wayne | Michigan | 26163 | 218136 | 5774 |
1934921 | 1934921 | 2021-11-20 | Wexford | Michigan | 26165 | 4265 | 62 |
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);