ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-11-16" 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 |
---|---|---|---|---|---|---|---|
1921838 | 1921838 | 2021-11-16 | Alcona | Michigan | 26001 | 1236 | 47 |
1921839 | 1921839 | 2021-11-16 | Alger | Michigan | 26003 | 1064 | 9 |
1921840 | 1921840 | 2021-11-16 | Allegan | Michigan | 26005 | 16489 | 203 |
1921841 | 1921841 | 2021-11-16 | Alpena | Michigan | 26007 | 3662 | 79 |
1921842 | 1921842 | 2021-11-16 | Antrim | Michigan | 26009 | 2650 | 40 |
1921843 | 1921843 | 2021-11-16 | Arenac | Michigan | 26011 | 1978 | 38 |
1921844 | 1921844 | 2021-11-16 | Baraga | Michigan | 26013 | 1483 | 47 |
1921845 | 1921845 | 2021-11-16 | Barry | Michigan | 26015 | 8756 | 94 |
1921846 | 1921846 | 2021-11-16 | Bay | Michigan | 26017 | 16138 | 411 |
1921847 | 1921847 | 2021-11-16 | Benzie | Michigan | 26019 | 1866 | 41 |
1921848 | 1921848 | 2021-11-16 | Berrien | Michigan | 26021 | 20437 | 337 |
1921849 | 1921849 | 2021-11-16 | Branch | Michigan | 26023 | 7907 | 138 |
1921850 | 1921850 | 2021-11-16 | Calhoun | Michigan | 26025 | 20192 | 369 |
1921851 | 1921851 | 2021-11-16 | Cass | Michigan | 26027 | 7567 | 95 |
1921852 | 1921852 | 2021-11-16 | Charlevoix | Michigan | 26029 | 2796 | 39 |
1921853 | 1921853 | 2021-11-16 | Cheboygan | Michigan | 26031 | 3098 | 71 |
1921854 | 1921854 | 2021-11-16 | Chippewa | Michigan | 26033 | 7291 | 69 |
1921855 | 1921855 | 2021-11-16 | Clare | Michigan | 26035 | 4251 | 112 |
1921856 | 1921856 | 2021-11-16 | Clinton | Michigan | 26037 | 11311 | 122 |
1921857 | 1921857 | 2021-11-16 | Crawford | Michigan | 26039 | 1547 | 17 |
1921858 | 1921858 | 2021-11-16 | Delta | Michigan | 26041 | 6240 | 112 |
1921859 | 1921859 | 2021-11-16 | Dickinson | Michigan | 26043 | 4308 | 84 |
1921860 | 1921860 | 2021-11-16 | Eaton | Michigan | 26045 | 14686 | 255 |
1921861 | 1921861 | 2021-11-16 | Emmet | Michigan | 26047 | 3735 | 53 |
1921862 | 1921862 | 2021-11-16 | Genesee | Michigan | 26049 | 56558 | 1118 |
1921863 | 1921863 | 2021-11-16 | Gladwin | Michigan | 26051 | 3556 | 79 |
1921864 | 1921864 | 2021-11-16 | Gogebic | Michigan | 26053 | 1934 | 54 |
1921865 | 1921865 | 2021-11-16 | Grand Traverse | Michigan | 26055 | 9908 | 122 |
1921866 | 1921866 | 2021-11-16 | Gratiot | Michigan | 26057 | 9443 | 139 |
1921867 | 1921867 | 2021-11-16 | Hillsdale | Michigan | 26059 | 6801 | 132 |
1921868 | 1921868 | 2021-11-16 | Houghton | Michigan | 26061 | 4735 | 57 |
1921869 | 1921869 | 2021-11-16 | Huron | Michigan | 26063 | 5306 | 97 |
1921870 | 1921870 | 2021-11-16 | Ingham | Michigan | 26065 | 33899 | 473 |
1921871 | 1921871 | 2021-11-16 | Ionia | Michigan | 26067 | 12794 | 113 |
1921872 | 1921872 | 2021-11-16 | Iosco | Michigan | 26069 | 3327 | 100 |
1921873 | 1921873 | 2021-11-16 | Iron | Michigan | 26071 | 1563 | 61 |
1921874 | 1921874 | 2021-11-16 | Isabella | Michigan | 26073 | 9828 | 137 |
1921875 | 1921875 | 2021-11-16 | Jackson | Michigan | 26075 | 28608 | 386 |
1921876 | 1921876 | 2021-11-16 | Kalamazoo | Michigan | 26077 | 32174 | 474 |
1921877 | 1921877 | 2021-11-16 | Kalkaska | Michigan | 26079 | 1948 | 40 |
1921878 | 1921878 | 2021-11-16 | Kent | Michigan | 26081 | 101346 | 1035 |
1921879 | 1921879 | 2021-11-16 | Keweenaw | Michigan | 26083 | 320 | 6 |
1921880 | 1921880 | 2021-11-16 | Lake | Michigan | 26085 | 1072 | 24 |
1921881 | 1921881 | 2021-11-16 | Lapeer | Michigan | 26087 | 13013 | 267 |
1921882 | 1921882 | 2021-11-16 | Leelanau | Michigan | 26089 | 1874 | 26 |
1921883 | 1921883 | 2021-11-16 | Lenawee | Michigan | 26091 | 16124 | 215 |
1921884 | 1921884 | 2021-11-16 | Livingston | Michigan | 26093 | 25930 | 258 |
1921885 | 1921885 | 2021-11-16 | Luce | Michigan | 26095 | 1664 | 6 |
1921886 | 1921886 | 2021-11-16 | Mackinac | Michigan | 26097 | 1396 | 14 |
1921887 | 1921887 | 2021-11-16 | Macomb | Michigan | 26099 | 130748 | 2774 |
1921888 | 1921888 | 2021-11-16 | Manistee | Michigan | 26101 | 2692 | 42 |
1921889 | 1921889 | 2021-11-16 | Marquette | Michigan | 26103 | 8628 | 86 |
1921890 | 1921890 | 2021-11-16 | Mason | Michigan | 26105 | 3658 | 50 |
1921891 | 1921891 | 2021-11-16 | Mecosta | Michigan | 26107 | 5237 | 54 |
1921892 | 1921892 | 2021-11-16 | Menominee | Michigan | 26109 | 3633 | 53 |
1921893 | 1921893 | 2021-11-16 | Midland | Michigan | 26111 | 11295 | 150 |
1921894 | 1921894 | 2021-11-16 | Missaukee | Michigan | 26113 | 1969 | 41 |
1921895 | 1921895 | 2021-11-16 | Monroe | Michigan | 26115 | 22373 | 314 |
1921896 | 1921896 | 2021-11-16 | Montcalm | Michigan | 26117 | 11727 | 140 |
1921897 | 1921897 | 2021-11-16 | Montmorency | Michigan | 26119 | 1150 | 32 |
1921898 | 1921898 | 2021-11-16 | Muskegon | Michigan | 26121 | 25840 | 436 |
1921899 | 1921899 | 2021-11-16 | Newaygo | Michigan | 26123 | 7237 | 85 |
1921900 | 1921900 | 2021-11-16 | Oakland | Michigan | 26125 | 156443 | 2734 |
1921901 | 1921901 | 2021-11-16 | Oceana | Michigan | 26127 | 4061 | 71 |
1921902 | 1921902 | 2021-11-16 | Ogemaw | Michigan | 26129 | 2898 | 68 |
1921903 | 1921903 | 2021-11-16 | Ontonagon | Michigan | 26131 | 673 | 23 |
1921904 | 1921904 | 2021-11-16 | Osceola | Michigan | 26133 | 3347 | 47 |
1921905 | 1921905 | 2021-11-16 | Oscoda | Michigan | 26135 | 1048 | 41 |
1921906 | 1921906 | 2021-11-16 | Otsego | Michigan | 26137 | 3683 | 63 |
1921907 | 1921907 | 2021-11-16 | Ottawa | Michigan | 26139 | 45474 | 530 |
1921908 | 1921908 | 2021-11-16 | Presque Isle | Michigan | 26141 | 1518 | 41 |
1921909 | 1921909 | 2021-11-16 | Roscommon | Michigan | 26143 | 2951 | 72 |
1921910 | 1921910 | 2021-11-16 | Saginaw | Michigan | 26145 | 30737 | 694 |
1921911 | 1921911 | 2021-11-16 | Sanilac | Michigan | 26151 | 5446 | 139 |
1921912 | 1921912 | 2021-11-16 | Schoolcraft | Michigan | 26153 | 926 | 6 |
1921913 | 1921913 | 2021-11-16 | Shiawassee | Michigan | 26155 | 9828 | 137 |
1921914 | 1921914 | 2021-11-16 | St. Clair | Michigan | 26147 | 24298 | 533 |
1921915 | 1921915 | 2021-11-16 | St. Joseph | Michigan | 26149 | 9148 | 123 |
1921916 | 1921916 | 2021-11-16 | Tuscola | Michigan | 26157 | 8151 | 205 |
1921917 | 1921917 | 2021-11-16 | Unknown | Michigan | 1306 | 18 | |
1921918 | 1921918 | 2021-11-16 | Van Buren | Michigan | 26159 | 10085 | 169 |
1921919 | 1921919 | 2021-11-16 | Washtenaw | Michigan | 26161 | 36644 | 343 |
1921920 | 1921920 | 2021-11-16 | Wayne | Michigan | 26163 | 212684 | 5696 |
1921921 | 1921921 | 2021-11-16 | Wexford | Michigan | 26165 | 4123 | 59 |
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);