ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-02-18" 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 |
---|---|---|---|---|---|---|---|
1041764 | 1041764 | 2021-02-18 | Alcona | Michigan | 26001 | 427 | 24 |
1041765 | 1041765 | 2021-02-18 | Alger | Michigan | 26003 | 580 | 3 |
1041766 | 1041766 | 2021-02-18 | Allegan | Michigan | 26005 | 7202 | 118 |
1041767 | 1041767 | 2021-02-18 | Alpena | Michigan | 26007 | 1459 | 47 |
1041768 | 1041768 | 2021-02-18 | Antrim | Michigan | 26009 | 907 | 19 |
1041769 | 1041769 | 2021-02-18 | Arenac | Michigan | 26011 | 739 | 24 |
1041770 | 1041770 | 2021-02-18 | Baraga | Michigan | 26013 | 772 | 33 |
1041771 | 1041771 | 2021-02-18 | Barry | Michigan | 26015 | 3680 | 42 |
1041772 | 1041772 | 2021-02-18 | Bay | Michigan | 26017 | 7295 | 283 |
1041773 | 1041773 | 2021-02-18 | Benzie | Michigan | 26019 | 897 | 31 |
1041774 | 1041774 | 2021-02-18 | Berrien | Michigan | 26021 | 11356 | 235 |
1041775 | 1041775 | 2021-02-18 | Branch | Michigan | 26023 | 4556 | 108 |
1041776 | 1041776 | 2021-02-18 | Calhoun | Michigan | 26025 | 9376 | 232 |
1041777 | 1041777 | 2021-02-18 | Cass | Michigan | 26027 | 3903 | 63 |
1041778 | 1041778 | 2021-02-18 | Charlevoix | Michigan | 26029 | 1032 | 13 |
1041779 | 1041779 | 2021-02-18 | Cheboygan | Michigan | 26031 | 911 | 35 |
1041780 | 1041780 | 2021-02-18 | Chippewa | Michigan | 26033 | 4791 | 41 |
1041781 | 1041781 | 2021-02-18 | Clare | Michigan | 26035 | 1592 | 69 |
1041782 | 1041782 | 2021-02-18 | Clinton | Michigan | 26037 | 4964 | 69 |
1041783 | 1041783 | 2021-02-18 | Crawford | Michigan | 26039 | 579 | 5 |
1041784 | 1041784 | 2021-02-18 | Delta | Michigan | 26041 | 3108 | 84 |
1041785 | 1041785 | 2021-02-18 | Dickinson | Michigan | 26043 | 2356 | 69 |
1041786 | 1041786 | 2021-02-18 | Eaton | Michigan | 26045 | 6109 | 147 |
1041787 | 1041787 | 2021-02-18 | Emmet | Michigan | 26047 | 1483 | 37 |
1041788 | 1041788 | 2021-02-18 | Genesee | Michigan | 26049 | 25055 | 746 |
1041789 | 1041789 | 2021-02-18 | Gladwin | Michigan | 26051 | 1460 | 42 |
1041790 | 1041790 | 2021-02-18 | Gogebic | Michigan | 26053 | 1248 | 47 |
1041791 | 1041791 | 2021-02-18 | Grand Traverse | Michigan | 26055 | 4162 | 68 |
1041792 | 1041792 | 2021-02-18 | Gratiot | Michigan | 26057 | 5627 | 105 |
1041793 | 1041793 | 2021-02-18 | Hillsdale | Michigan | 26059 | 3287 | 72 |
1041794 | 1041794 | 2021-02-18 | Houghton | Michigan | 26061 | 2586 | 40 |
1041795 | 1041795 | 2021-02-18 | Huron | Michigan | 26063 | 2088 | 58 |
1041796 | 1041796 | 2021-02-18 | Ingham | Michigan | 26065 | 16037 | 272 |
1041797 | 1041797 | 2021-02-18 | Ionia | Michigan | 26067 | 6800 | 73 |
1041798 | 1041798 | 2021-02-18 | Iosco | Michigan | 26069 | 1271 | 67 |
1041799 | 1041799 | 2021-02-18 | Iron | Michigan | 26071 | 926 | 48 |
1041800 | 1041800 | 2021-02-18 | Isabella | Michigan | 26073 | 3965 | 73 |
1041801 | 1041801 | 2021-02-18 | Jackson | Michigan | 26075 | 13926 | 239 |
1041802 | 1041802 | 2021-02-18 | Kalamazoo | Michigan | 26077 | 14679 | 318 |
1041803 | 1041803 | 2021-02-18 | Kalkaska | Michigan | 26079 | 580 | 15 |
1041804 | 1041804 | 2021-02-18 | Kent | Michigan | 26081 | 50989 | 698 |
1041805 | 1041805 | 2021-02-18 | Keweenaw | Michigan | 26083 | 136 | 2 |
1041806 | 1041806 | 2021-02-18 | Lake | Michigan | 26085 | 356 | 11 |
1041807 | 1041807 | 2021-02-18 | Lapeer | Michigan | 26087 | 5400 | 128 |
1041808 | 1041808 | 2021-02-18 | Leelanau | Michigan | 26089 | 841 | 14 |
1041809 | 1041809 | 2021-02-18 | Lenawee | Michigan | 26091 | 7553 | 125 |
1041810 | 1041810 | 2021-02-18 | Livingston | Michigan | 26093 | 10141 | 136 |
1041811 | 1041811 | 2021-02-18 | Luce | Michigan | 26095 | 1071 | 2 |
1041812 | 1041812 | 2021-02-18 | Mackinac | Michigan | 26097 | 432 | 3 |
1041813 | 1041813 | 2021-02-18 | Macomb | Michigan | 26099 | 58222 | 1947 |
1041814 | 1041814 | 2021-02-18 | Manistee | Michigan | 26101 | 1479 | 23 |
1041815 | 1041815 | 2021-02-18 | Marquette | Michigan | 26103 | 4784 | 56 |
1041816 | 1041816 | 2021-02-18 | Mason | Michigan | 26105 | 1224 | 26 |
1041817 | 1041817 | 2021-02-18 | Mecosta | Michigan | 26107 | 1988 | 19 |
1041818 | 1041818 | 2021-02-18 | Menominee | Michigan | 26109 | 1869 | 37 |
1041819 | 1041819 | 2021-02-18 | Midland | Michigan | 26111 | 4891 | 64 |
1041820 | 1041820 | 2021-02-18 | Missaukee | Michigan | 26113 | 735 | 17 |
1041821 | 1041821 | 2021-02-18 | Monroe | Michigan | 26115 | 9567 | 198 |
1041822 | 1041822 | 2021-02-18 | Montcalm | Michigan | 26117 | 5565 | 92 |
1041823 | 1041823 | 2021-02-18 | Montmorency | Michigan | 26119 | 356 | 17 |
1041824 | 1041824 | 2021-02-18 | Muskegon | Michigan | 26121 | 12636 | 315 |
1041825 | 1041825 | 2021-02-18 | Newaygo | Michigan | 26123 | 2779 | 49 |
1041826 | 1041826 | 2021-02-18 | Oakland | Michigan | 26125 | 73470 | 1965 |
1041827 | 1041827 | 2021-02-18 | Oceana | Michigan | 26127 | 1854 | 50 |
1041828 | 1041828 | 2021-02-18 | Ogemaw | Michigan | 26129 | 1110 | 33 |
1041829 | 1041829 | 2021-02-18 | Ontonagon | Michigan | 26131 | 408 | 20 |
1041830 | 1041830 | 2021-02-18 | Osceola | Michigan | 26133 | 1034 | 23 |
1041831 | 1041831 | 2021-02-18 | Oscoda | Michigan | 26135 | 394 | 19 |
1041832 | 1041832 | 2021-02-18 | Otsego | Michigan | 26137 | 1146 | 25 |
1041833 | 1041833 | 2021-02-18 | Ottawa | Michigan | 26139 | 22087 | 347 |
1041834 | 1041834 | 2021-02-18 | Presque Isle | Michigan | 26141 | 647 | 28 |
1041835 | 1041835 | 2021-02-18 | Roscommon | Michigan | 26143 | 1125 | 31 |
1041836 | 1041836 | 2021-02-18 | Saginaw | Michigan | 26145 | 15739 | 502 |
1041837 | 1041837 | 2021-02-18 | Sanilac | Michigan | 26151 | 1977 | 74 |
1041838 | 1041838 | 2021-02-18 | Schoolcraft | Michigan | 26153 | 257 | 5 |
1041839 | 1041839 | 2021-02-18 | Shiawassee | Michigan | 26155 | 3733 | 77 |
1041840 | 1041840 | 2021-02-18 | St. Clair | Michigan | 26147 | 8510 | 252 |
1041841 | 1041841 | 2021-02-18 | St. Joseph | Michigan | 26149 | 4578 | 82 |
1041842 | 1041842 | 2021-02-18 | Tuscola | Michigan | 26157 | 3126 | 133 |
1041843 | 1041843 | 2021-02-18 | Unknown | Michigan | 0 | 13 | |
1041844 | 1041844 | 2021-02-18 | Van Buren | Michigan | 26159 | 4912 | 95 |
1041845 | 1041845 | 2021-02-18 | Washtenaw | Michigan | 26161 | 18759 | 249 |
1041846 | 1041846 | 2021-02-18 | Wayne | Michigan | 26163 | 100060 | 4107 |
1041847 | 1041847 | 2021-02-18 | Wexford | Michigan | 26165 | 1420 | 20 |
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);