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-04-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 |
---|---|---|---|---|---|---|---|
1239822 | 1239822 | 2021-04-20 | Alcona | Michigan | 26001 | 655 | 27 |
1239823 | 1239823 | 2021-04-20 | Alger | Michigan | 26003 | 636 | 6 |
1239824 | 1239824 | 2021-04-20 | Allegan | Michigan | 26005 | 9755 | 126 |
1239825 | 1239825 | 2021-04-20 | Alpena | Michigan | 26007 | 1942 | 54 |
1239826 | 1239826 | 2021-04-20 | Antrim | Michigan | 26009 | 1464 | 23 |
1239827 | 1239827 | 2021-04-20 | Arenac | Michigan | 26011 | 1003 | 28 |
1239828 | 1239828 | 2021-04-20 | Baraga | Michigan | 26013 | 821 | 34 |
1239829 | 1239829 | 2021-04-20 | Barry | Michigan | 26015 | 5071 | 57 |
1239830 | 1239830 | 2021-04-20 | Bay | Michigan | 26017 | 9927 | 314 |
1239831 | 1239831 | 2021-04-20 | Benzie | Michigan | 26019 | 1154 | 32 |
1239832 | 1239832 | 2021-04-20 | Berrien | Michigan | 26021 | 14160 | 259 |
1239833 | 1239833 | 2021-04-20 | Branch | Michigan | 26023 | 5253 | 115 |
1239834 | 1239834 | 2021-04-20 | Calhoun | Michigan | 26025 | 12801 | 263 |
1239835 | 1239835 | 2021-04-20 | Cass | Michigan | 26027 | 5037 | 72 |
1239836 | 1239836 | 2021-04-20 | Charlevoix | Michigan | 26029 | 1505 | 17 |
1239837 | 1239837 | 2021-04-20 | Cheboygan | Michigan | 26031 | 1680 | 40 |
1239838 | 1239838 | 2021-04-20 | Chippewa | Michigan | 26033 | 5409 | 48 |
1239839 | 1239839 | 2021-04-20 | Clare | Michigan | 26035 | 2135 | 70 |
1239840 | 1239840 | 2021-04-20 | Clinton | Michigan | 26037 | 6934 | 80 |
1239841 | 1239841 | 2021-04-20 | Crawford | Michigan | 26039 | 901 | 7 |
1239842 | 1239842 | 2021-04-20 | Delta | Michigan | 26041 | 3653 | 87 |
1239843 | 1239843 | 2021-04-20 | Dickinson | Michigan | 26043 | 2609 | 72 |
1239844 | 1239844 | 2021-04-20 | Eaton | Michigan | 26045 | 9209 | 174 |
1239845 | 1239845 | 2021-04-20 | Emmet | Michigan | 26047 | 2098 | 41 |
1239846 | 1239846 | 2021-04-20 | Genesee | Michigan | 26049 | 37296 | 836 |
1239847 | 1239847 | 2021-04-20 | Gladwin | Michigan | 26051 | 2064 | 43 |
1239848 | 1239848 | 2021-04-20 | Gogebic | Michigan | 26053 | 1354 | 50 |
1239849 | 1239849 | 2021-04-20 | Grand Traverse | Michigan | 26055 | 5945 | 85 |
1239850 | 1239850 | 2021-04-20 | Gratiot | Michigan | 26057 | 6380 | 112 |
1239851 | 1239851 | 2021-04-20 | Hillsdale | Michigan | 26059 | 3996 | 82 |
1239852 | 1239852 | 2021-04-20 | Houghton | Michigan | 26061 | 2991 | 40 |
1239853 | 1239853 | 2021-04-20 | Huron | Michigan | 26063 | 3674 | 70 |
1239854 | 1239854 | 2021-04-20 | Ingham | Michigan | 26065 | 22690 | 329 |
1239855 | 1239855 | 2021-04-20 | Ionia | Michigan | 26067 | 8343 | 81 |
1239856 | 1239856 | 2021-04-20 | Iosco | Michigan | 26069 | 1772 | 69 |
1239857 | 1239857 | 2021-04-20 | Iron | Michigan | 26071 | 975 | 51 |
1239858 | 1239858 | 2021-04-20 | Isabella | Michigan | 26073 | 5500 | 81 |
1239859 | 1239859 | 2021-04-20 | Jackson | Michigan | 26075 | 19360 | 280 |
1239860 | 1239860 | 2021-04-20 | Kalamazoo | Michigan | 26077 | 20418 | 346 |
1239861 | 1239861 | 2021-04-20 | Kalkaska | Michigan | 26079 | 993 | 18 |
1239862 | 1239862 | 2021-04-20 | Kent | Michigan | 26081 | 64850 | 767 |
1239863 | 1239863 | 2021-04-20 | Keweenaw | Michigan | 26083 | 169 | 2 |
1239864 | 1239864 | 2021-04-20 | Lake | Michigan | 26085 | 539 | 13 |
1239865 | 1239865 | 2021-04-20 | Lapeer | Michigan | 26087 | 8663 | 165 |
1239866 | 1239866 | 2021-04-20 | Leelanau | Michigan | 26089 | 1156 | 16 |
1239867 | 1239867 | 2021-04-20 | Lenawee | Michigan | 26091 | 9858 | 148 |
1239868 | 1239868 | 2021-04-20 | Livingston | Michigan | 26093 | 14981 | 162 |
1239869 | 1239869 | 2021-04-20 | Luce | Michigan | 26095 | 1184 | 2 |
1239870 | 1239870 | 2021-04-20 | Mackinac | Michigan | 26097 | 588 | 3 |
1239871 | 1239871 | 2021-04-20 | Macomb | Michigan | 26099 | 90326 | 2130 |
1239872 | 1239872 | 2021-04-20 | Manistee | Michigan | 26101 | 1834 | 23 |
1239873 | 1239873 | 2021-04-20 | Marquette | Michigan | 26103 | 5571 | 58 |
1239874 | 1239874 | 2021-04-20 | Mason | Michigan | 26105 | 1846 | 30 |
1239875 | 1239875 | 2021-04-20 | Mecosta | Michigan | 26107 | 2792 | 27 |
1239876 | 1239876 | 2021-04-20 | Menominee | Michigan | 26109 | 2012 | 41 |
1239877 | 1239877 | 2021-04-20 | Midland | Michigan | 26111 | 6615 | 75 |
1239878 | 1239878 | 2021-04-20 | Missaukee | Michigan | 26113 | 1343 | 21 |
1239879 | 1239879 | 2021-04-20 | Monroe | Michigan | 26115 | 13896 | 228 |
1239880 | 1239880 | 2021-04-20 | Montcalm | Michigan | 26117 | 7119 | 100 |
1239881 | 1239881 | 2021-04-20 | Montmorency | Michigan | 26119 | 501 | 18 |
1239882 | 1239882 | 2021-04-20 | Muskegon | Michigan | 26121 | 15077 | 327 |
1239883 | 1239883 | 2021-04-20 | Newaygo | Michigan | 26123 | 4100 | 57 |
1239884 | 1239884 | 2021-04-20 | Oakland | Michigan | 26125 | 105398 | 2143 |
1239885 | 1239885 | 2021-04-20 | Oceana | Michigan | 26127 | 2424 | 51 |
1239886 | 1239886 | 2021-04-20 | Ogemaw | Michigan | 26129 | 1458 | 35 |
1239887 | 1239887 | 2021-04-20 | Ontonagon | Michigan | 26131 | 446 | 21 |
1239888 | 1239888 | 2021-04-20 | Osceola | Michigan | 26133 | 1653 | 25 |
1239889 | 1239889 | 2021-04-20 | Oscoda | Michigan | 26135 | 560 | 23 |
1239890 | 1239890 | 2021-04-20 | Otsego | Michigan | 26137 | 2089 | 34 |
1239891 | 1239891 | 2021-04-20 | Ottawa | Michigan | 26139 | 29067 | 387 |
1239892 | 1239892 | 2021-04-20 | Presque Isle | Michigan | 26141 | 915 | 30 |
1239893 | 1239893 | 2021-04-20 | Roscommon | Michigan | 26143 | 1723 | 45 |
1239894 | 1239894 | 2021-04-20 | Saginaw | Michigan | 26145 | 19863 | 559 |
1239895 | 1239895 | 2021-04-20 | Sanilac | Michigan | 26151 | 3882 | 98 |
1239896 | 1239896 | 2021-04-20 | Schoolcraft | Michigan | 26153 | 331 | 5 |
1239897 | 1239897 | 2021-04-20 | Shiawassee | Michigan | 26155 | 5650 | 93 |
1239898 | 1239898 | 2021-04-20 | St. Clair | Michigan | 26147 | 16473 | 349 |
1239899 | 1239899 | 2021-04-20 | St. Joseph | Michigan | 26149 | 5621 | 93 |
1239900 | 1239900 | 2021-04-20 | Tuscola | Michigan | 26157 | 5111 | 154 |
1239901 | 1239901 | 2021-04-20 | Unknown | Michigan | 58 | 17 | |
1239902 | 1239902 | 2021-04-20 | Van Buren | Michigan | 26159 | 6426 | 107 |
1239903 | 1239903 | 2021-04-20 | Washtenaw | Michigan | 26161 | 25050 | 269 |
1239904 | 1239904 | 2021-04-20 | Wayne | Michigan | 26163 | 146304 | 4471 |
1239905 | 1239905 | 2021-04-20 | Wexford | Michigan | 26165 | 2557 | 34 |
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);