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 2020-12-15 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
830811 | 830811 | 2020-12-15 | Alcona | Michigan | 26001 | 304 | 11 |
830812 | 830812 | 2020-12-15 | Alger | Michigan | 26003 | 395 | 2 |
830813 | 830813 | 2020-12-15 | Allegan | Michigan | 26005 | 5102 | 46 |
830814 | 830814 | 2020-12-15 | Alpena | Michigan | 26007 | 1003 | 21 |
830815 | 830815 | 2020-12-15 | Antrim | Michigan | 26009 | 555 | 8 |
830816 | 830816 | 2020-12-15 | Arenac | Michigan | 26011 | 557 | 24 |
830817 | 830817 | 2020-12-15 | Baraga | Michigan | 26013 | 611 | 28 |
830818 | 830818 | 2020-12-15 | Barry | Michigan | 26015 | 2704 | 25 |
830819 | 830819 | 2020-12-15 | Bay | Michigan | 26017 | 5556 | 150 |
830820 | 830820 | 2020-12-15 | Benzie | Michigan | 26019 | 592 | 13 |
830821 | 830821 | 2020-12-15 | Berrien | Michigan | 26021 | 8530 | 154 |
830822 | 830822 | 2020-12-15 | Branch | Michigan | 26023 | 3599 | 70 |
830823 | 830823 | 2020-12-15 | Calhoun | Michigan | 26025 | 7183 | 159 |
830824 | 830824 | 2020-12-15 | Cass | Michigan | 26027 | 2826 | 39 |
830825 | 830825 | 2020-12-15 | Charlevoix | Michigan | 26029 | 790 | 8 |
830826 | 830826 | 2020-12-15 | Cheboygan | Michigan | 26031 | 657 | 27 |
830827 | 830827 | 2020-12-15 | Chippewa | Michigan | 26033 | 2523 | 16 |
830828 | 830828 | 2020-12-15 | Clare | Michigan | 26035 | 1038 | 28 |
830829 | 830829 | 2020-12-15 | Clinton | Michigan | 26037 | 3451 | 31 |
830830 | 830830 | 2020-12-15 | Crawford | Michigan | 26039 | 434 | 5 |
830831 | 830831 | 2020-12-15 | Delta | Michigan | 26041 | 2775 | 66 |
830832 | 830832 | 2020-12-15 | Dickinson | Michigan | 26043 | 2037 | 63 |
830833 | 830833 | 2020-12-15 | Eaton | Michigan | 26045 | 4077 | 71 |
830834 | 830834 | 2020-12-15 | Emmet | Michigan | 26047 | 1161 | 30 |
830835 | 830835 | 2020-12-15 | Genesee | Michigan | 26049 | 19205 | 522 |
830836 | 830836 | 2020-12-15 | Gladwin | Michigan | 26051 | 1060 | 18 |
830837 | 830837 | 2020-12-15 | Gogebic | Michigan | 26053 | 964 | 28 |
830838 | 830838 | 2020-12-15 | Grand Traverse | Michigan | 26055 | 2648 | 36 |
830839 | 830839 | 2020-12-15 | Gratiot | Michigan | 26057 | 3853 | 52 |
830840 | 830840 | 2020-12-15 | Hillsdale | Michigan | 26059 | 2245 | 49 |
830841 | 830841 | 2020-12-15 | Houghton | Michigan | 26061 | 1871 | 21 |
830842 | 830842 | 2020-12-15 | Huron | Michigan | 26063 | 1332 | 29 |
830843 | 830843 | 2020-12-15 | Ingham | Michigan | 26065 | 11225 | 153 |
830844 | 830844 | 2020-12-15 | Ionia | Michigan | 26067 | 4481 | 41 |
830845 | 830845 | 2020-12-15 | Iosco | Michigan | 26069 | 997 | 38 |
830846 | 830846 | 2020-12-15 | Iron | Michigan | 26071 | 776 | 37 |
830847 | 830847 | 2020-12-15 | Isabella | Michigan | 26073 | 3049 | 34 |
830848 | 830848 | 2020-12-15 | Jackson | Michigan | 26075 | 9469 | 151 |
830849 | 830849 | 2020-12-15 | Kalamazoo | Michigan | 26077 | 11146 | 208 |
830850 | 830850 | 2020-12-15 | Kalkaska | Michigan | 26079 | 450 | 9 |
830851 | 830851 | 2020-12-15 | Kent | Michigan | 26081 | 39888 | 471 |
830852 | 830852 | 2020-12-15 | Keweenaw | Michigan | 26083 | 82 | 2 |
830853 | 830853 | 2020-12-15 | Lake | Michigan | 26085 | 259 | 6 |
830854 | 830854 | 2020-12-15 | Lapeer | Michigan | 26087 | 3812 | 84 |
830855 | 830855 | 2020-12-15 | Leelanau | Michigan | 26089 | 522 | 4 |
830856 | 830856 | 2020-12-15 | Lenawee | Michigan | 26091 | 4710 | 53 |
830857 | 830857 | 2020-12-15 | Livingston | Michigan | 26093 | 7201 | 58 |
830858 | 830858 | 2020-12-15 | Luce | Michigan | 26095 | 966 | 0 |
830859 | 830859 | 2020-12-15 | Mackinac | Michigan | 26097 | 354 | 1 |
830860 | 830860 | 2020-12-15 | Macomb | Michigan | 26099 | 46118 | 1454 |
830861 | 830861 | 2020-12-15 | Manistee | Michigan | 26101 | 530 | 12 |
830862 | 830862 | 2020-12-15 | Marquette | Michigan | 26103 | 4187 | 48 |
830863 | 830863 | 2020-12-15 | Mason | Michigan | 26105 | 820 | 15 |
830864 | 830864 | 2020-12-15 | Mecosta | Michigan | 26107 | 1536 | 12 |
830865 | 830865 | 2020-12-15 | Menominee | Michigan | 26109 | 1515 | 22 |
830866 | 830866 | 2020-12-15 | Midland | Michigan | 26111 | 3578 | 34 |
830867 | 830867 | 2020-12-15 | Missaukee | Michigan | 26113 | 391 | 7 |
830868 | 830868 | 2020-12-15 | Monroe | Michigan | 26115 | 6867 | 120 |
830869 | 830869 | 2020-12-15 | Montcalm | Michigan | 26117 | 2916 | 49 |
830870 | 830870 | 2020-12-15 | Montmorency | Michigan | 26119 | 259 | 6 |
830871 | 830871 | 2020-12-15 | Muskegon | Michigan | 26121 | 10457 | 235 |
830872 | 830872 | 2020-12-15 | Newaygo | Michigan | 26123 | 2024 | 27 |
830873 | 830873 | 2020-12-15 | Oakland | Michigan | 26125 | 55885 | 1490 |
830874 | 830874 | 2020-12-15 | Oceana | Michigan | 26127 | 1501 | 33 |
830875 | 830875 | 2020-12-15 | Ogemaw | Michigan | 26129 | 779 | 23 |
830876 | 830876 | 2020-12-15 | Ontonagon | Michigan | 26131 | 300 | 15 |
830877 | 830877 | 2020-12-15 | Osceola | Michigan | 26133 | 727 | 14 |
830878 | 830878 | 2020-12-15 | Oscoda | Michigan | 26135 | 275 | 14 |
830879 | 830879 | 2020-12-15 | Otsego | Michigan | 26137 | 926 | 20 |
830880 | 830880 | 2020-12-15 | Ottawa | Michigan | 26139 | 16920 | 220 |
830881 | 830881 | 2020-12-15 | Presque Isle | Michigan | 26141 | 444 | 5 |
830882 | 830882 | 2020-12-15 | Roscommon | Michigan | 26143 | 843 | 25 |
830883 | 830883 | 2020-12-15 | Saginaw | Michigan | 26145 | 10974 | 320 |
830884 | 830884 | 2020-12-15 | Sanilac | Michigan | 26151 | 1276 | 46 |
830885 | 830885 | 2020-12-15 | Schoolcraft | Michigan | 26153 | 203 | 3 |
830886 | 830886 | 2020-12-15 | Shiawassee | Michigan | 26155 | 2580 | 51 |
830887 | 830887 | 2020-12-15 | St. Clair | Michigan | 26147 | 6153 | 126 |
830888 | 830888 | 2020-12-15 | St. Joseph | Michigan | 26149 | 3186 | 43 |
830889 | 830889 | 2020-12-15 | Tuscola | Michigan | 26157 | 2245 | 75 |
830890 | 830890 | 2020-12-15 | Unknown | Michigan | 4526 | 19 | |
830891 | 830891 | 2020-12-15 | Van Buren | Michigan | 26159 | 3685 | 69 |
830892 | 830892 | 2020-12-15 | Washtenaw | Michigan | 26161 | 12874 | 167 |
830893 | 830893 | 2020-12-15 | Wayne | Michigan | 26163 | 77768 | 3453 |
830894 | 830894 | 2020-12-15 | Wexford | Michigan | 26165 | 881 | 16 |
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);