ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2022-03-03" 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 |
---|---|---|---|---|---|---|---|
2269743 | 2269743 | 2022-03-03 | Alcona | Michigan | 26001 | 1707 | 68 |
2269744 | 2269744 | 2022-03-03 | Alger | Michigan | 26003 | 1845 | 13 |
2269745 | 2269745 | 2022-03-03 | Allegan | Michigan | 26005 | 26854 | 332 |
2269746 | 2269746 | 2022-03-03 | Alpena | Michigan | 26007 | 5536 | 133 |
2269747 | 2269747 | 2022-03-03 | Antrim | Michigan | 26009 | 4269 | 60 |
2269748 | 2269748 | 2022-03-03 | Arenac | Michigan | 26011 | 3178 | 63 |
2269749 | 2269749 | 2022-03-03 | Baraga | Michigan | 26013 | 2189 | 54 |
2269750 | 2269750 | 2022-03-03 | Barry | Michigan | 26015 | 14185 | 159 |
2269751 | 2269751 | 2022-03-03 | Bay | Michigan | 26017 | 26851 | 564 |
2269752 | 2269752 | 2022-03-03 | Benzie | Michigan | 26019 | 3390 | 64 |
2269753 | 2269753 | 2022-03-03 | Berrien | Michigan | 26021 | 34393 | 528 |
2269754 | 2269754 | 2022-03-03 | Branch | Michigan | 26023 | 12067 | 196 |
2269755 | 2269755 | 2022-03-03 | Calhoun | Michigan | 26025 | 33727 | 554 |
2269756 | 2269756 | 2022-03-03 | Cass | Michigan | 26027 | 11039 | 137 |
2269757 | 2269757 | 2022-03-03 | Charlevoix | Michigan | 26029 | 4880 | 58 |
2269758 | 2269758 | 2022-03-03 | Cheboygan | Michigan | 26031 | 4549 | 100 |
2269759 | 2269759 | 2022-03-03 | Chippewa | Michigan | 26033 | 11486 | 112 |
2269760 | 2269760 | 2022-03-03 | Clare | Michigan | 26035 | 6685 | 153 |
2269761 | 2269761 | 2022-03-03 | Clinton | Michigan | 26037 | 20896 | 201 |
2269762 | 2269762 | 2022-03-03 | Crawford | Michigan | 26039 | 2528 | 29 |
2269763 | 2269763 | 2022-03-03 | Delta | Michigan | 26041 | 9882 | 153 |
2269764 | 2269764 | 2022-03-03 | Dickinson | Michigan | 26043 | 7346 | 106 |
2269765 | 2269765 | 2022-03-03 | Eaton | Michigan | 26045 | 26440 | 385 |
2269766 | 2269766 | 2022-03-03 | Emmet | Michigan | 26047 | 6324 | 83 |
2269767 | 2269767 | 2022-03-03 | Genesee | Michigan | 26049 | 100218 | 1671 |
2269768 | 2269768 | 2022-03-03 | Gladwin | Michigan | 26051 | 5545 | 110 |
2269769 | 2269769 | 2022-03-03 | Gogebic | Michigan | 26053 | 3236 | 67 |
2269770 | 2269770 | 2022-03-03 | Grand Traverse | Michigan | 26055 | 16963 | 218 |
2269771 | 2269771 | 2022-03-03 | Gratiot | Michigan | 26057 | 13464 | 181 |
2269772 | 2269772 | 2022-03-03 | Hillsdale | Michigan | 26059 | 10259 | 194 |
2269773 | 2269773 | 2022-03-03 | Houghton | Michigan | 26061 | 7698 | 89 |
2269774 | 2269774 | 2022-03-03 | Huron | Michigan | 26063 | 7987 | 144 |
2269775 | 2269775 | 2022-03-03 | Ingham | Michigan | 26065 | 63156 | 730 |
2269776 | 2269776 | 2022-03-03 | Ionia | Michigan | 26067 | 19352 | 174 |
2269777 | 2269777 | 2022-03-03 | Iosco | Michigan | 26069 | 4763 | 134 |
2269778 | 2269778 | 2022-03-03 | Iron | Michigan | 26071 | 2630 | 85 |
2269779 | 2269779 | 2022-03-03 | Isabella | Michigan | 26073 | 15439 | 198 |
2269780 | 2269780 | 2022-03-03 | Jackson | Michigan | 26075 | 44268 | 557 |
2269781 | 2269781 | 2022-03-03 | Kalamazoo | Michigan | 26077 | 58377 | 652 |
2269782 | 2269782 | 2022-03-03 | Kalkaska | Michigan | 26079 | 3489 | 54 |
2269783 | 2269783 | 2022-03-03 | Kent | Michigan | 26081 | 165085 | 1476 |
2269784 | 2269784 | 2022-03-03 | Keweenaw | Michigan | 26083 | 504 | 13 |
2269785 | 2269785 | 2022-03-03 | Lake | Michigan | 26085 | 1824 | 35 |
2269786 | 2269786 | 2022-03-03 | Lapeer | Michigan | 26087 | 20653 | 416 |
2269787 | 2269787 | 2022-03-03 | Leelanau | Michigan | 26089 | 3533 | 50 |
2269788 | 2269788 | 2022-03-03 | Lenawee | Michigan | 26091 | 25708 | 316 |
2269789 | 2269789 | 2022-03-03 | Livingston | Michigan | 26093 | 45405 | 436 |
2269790 | 2269790 | 2022-03-03 | Luce | Michigan | 26095 | 2273 | 10 |
2269791 | 2269791 | 2022-03-03 | Mackinac | Michigan | 26097 | 2364 | 28 |
2269792 | 2269792 | 2022-03-03 | Macomb | Michigan | 26099 | 225494 | 3837 |
2269793 | 2269793 | 2022-03-03 | Manistee | Michigan | 26101 | 4425 | 84 |
2269794 | 2269794 | 2022-03-03 | Marquette | Michigan | 26103 | 15675 | 122 |
2269795 | 2269795 | 2022-03-03 | Mason | Michigan | 26105 | 6639 | 86 |
2269796 | 2269796 | 2022-03-03 | Mecosta | Michigan | 26107 | 8576 | 105 |
2269797 | 2269797 | 2022-03-03 | Menominee | Michigan | 26109 | 5541 | 69 |
2269798 | 2269798 | 2022-03-03 | Midland | Michigan | 26111 | 18907 | 219 |
2269799 | 2269799 | 2022-03-03 | Missaukee | Michigan | 26113 | 2885 | 58 |
2269800 | 2269800 | 2022-03-03 | Monroe | Michigan | 26115 | 37575 | 456 |
2269801 | 2269801 | 2022-03-03 | Montcalm | Michigan | 26117 | 17032 | 205 |
2269802 | 2269802 | 2022-03-03 | Montmorency | Michigan | 26119 | 1696 | 46 |
2269803 | 2269803 | 2022-03-03 | Muskegon | Michigan | 26121 | 41366 | 628 |
2269804 | 2269804 | 2022-03-03 | Newaygo | Michigan | 26123 | 11389 | 153 |
2269805 | 2269805 | 2022-03-03 | Oakland | Michigan | 26125 | 282438 | 3712 |
2269806 | 2269806 | 2022-03-03 | Oceana | Michigan | 26127 | 6245 | 89 |
2269807 | 2269807 | 2022-03-03 | Ogemaw | Michigan | 26129 | 4292 | 99 |
2269808 | 2269808 | 2022-03-03 | Ontonagon | Michigan | 26131 | 970 | 36 |
2269809 | 2269809 | 2022-03-03 | Osceola | Michigan | 26133 | 4948 | 77 |
2269810 | 2269810 | 2022-03-03 | Oscoda | Michigan | 26135 | 1423 | 54 |
2269811 | 2269811 | 2022-03-03 | Otsego | Michigan | 26137 | 5573 | 95 |
2269812 | 2269812 | 2022-03-03 | Ottawa | Michigan | 26139 | 74092 | 770 |
2269813 | 2269813 | 2022-03-03 | Presque Isle | Michigan | 26141 | 2057 | 55 |
2269814 | 2269814 | 2022-03-03 | Roscommon | Michigan | 26143 | 4576 | 110 |
2269815 | 2269815 | 2022-03-03 | Saginaw | Michigan | 26145 | 50083 | 921 |
2269816 | 2269816 | 2022-03-03 | Sanilac | Michigan | 26151 | 8622 | 183 |
2269817 | 2269817 | 2022-03-03 | Schoolcraft | Michigan | 26153 | 1744 | 14 |
2269818 | 2269818 | 2022-03-03 | Shiawassee | Michigan | 26155 | 17640 | 224 |
2269819 | 2269819 | 2022-03-03 | St. Clair | Michigan | 26147 | 40115 | 807 |
2269820 | 2269820 | 2022-03-03 | St. Joseph | Michigan | 26149 | 13588 | 199 |
2269821 | 2269821 | 2022-03-03 | Tuscola | Michigan | 26157 | 13157 | 271 |
2269822 | 2269822 | 2022-03-03 | Unknown | Michigan | 11830 | 32 | |
2269823 | 2269823 | 2022-03-03 | Van Buren | Michigan | 26159 | 16863 | 261 |
2269824 | 2269824 | 2022-03-03 | Washtenaw | Michigan | 26161 | 73808 | 510 |
2269825 | 2269825 | 2022-03-03 | Wayne | Michigan | 26163 | 393190 | 7694 |
2269826 | 2269826 | 2022-03-03 | Wexford | Michigan | 26165 | 6987 | 103 |
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);