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-16 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1226832 | 1226832 | 2021-04-16 | Alcona | Michigan | 26001 | 631 | 26 |
1226833 | 1226833 | 2021-04-16 | Alger | Michigan | 26003 | 632 | 5 |
1226834 | 1226834 | 2021-04-16 | Allegan | Michigan | 26005 | 9518 | 124 |
1226835 | 1226835 | 2021-04-16 | Alpena | Michigan | 26007 | 1880 | 52 |
1226836 | 1226836 | 2021-04-16 | Antrim | Michigan | 26009 | 1432 | 22 |
1226837 | 1226837 | 2021-04-16 | Arenac | Michigan | 26011 | 968 | 27 |
1226838 | 1226838 | 2021-04-16 | Baraga | Michigan | 26013 | 814 | 34 |
1226839 | 1226839 | 2021-04-16 | Barry | Michigan | 26015 | 4906 | 57 |
1226840 | 1226840 | 2021-04-16 | Bay | Michigan | 26017 | 9709 | 313 |
1226841 | 1226841 | 2021-04-16 | Benzie | Michigan | 26019 | 1128 | 32 |
1226842 | 1226842 | 2021-04-16 | Berrien | Michigan | 26021 | 13943 | 259 |
1226843 | 1226843 | 2021-04-16 | Branch | Michigan | 26023 | 5177 | 115 |
1226844 | 1226844 | 2021-04-16 | Calhoun | Michigan | 26025 | 12549 | 258 |
1226845 | 1226845 | 2021-04-16 | Cass | Michigan | 26027 | 4948 | 71 |
1226846 | 1226846 | 2021-04-16 | Charlevoix | Michigan | 26029 | 1443 | 15 |
1226847 | 1226847 | 2021-04-16 | Cheboygan | Michigan | 26031 | 1609 | 38 |
1226848 | 1226848 | 2021-04-16 | Chippewa | Michigan | 26033 | 5374 | 48 |
1226849 | 1226849 | 2021-04-16 | Clare | Michigan | 26035 | 2079 | 70 |
1226850 | 1226850 | 2021-04-16 | Clinton | Michigan | 26037 | 6811 | 79 |
1226851 | 1226851 | 2021-04-16 | Crawford | Michigan | 26039 | 882 | 7 |
1226852 | 1226852 | 2021-04-16 | Delta | Michigan | 26041 | 3586 | 86 |
1226853 | 1226853 | 2021-04-16 | Dickinson | Michigan | 26043 | 2592 | 72 |
1226854 | 1226854 | 2021-04-16 | Eaton | Michigan | 26045 | 9036 | 169 |
1226855 | 1226855 | 2021-04-16 | Emmet | Michigan | 26047 | 2053 | 40 |
1226856 | 1226856 | 2021-04-16 | Genesee | Michigan | 26049 | 36248 | 819 |
1226857 | 1226857 | 2021-04-16 | Gladwin | Michigan | 26051 | 2003 | 43 |
1226858 | 1226858 | 2021-04-16 | Gogebic | Michigan | 26053 | 1350 | 50 |
1226859 | 1226859 | 2021-04-16 | Grand Traverse | Michigan | 26055 | 5803 | 81 |
1226860 | 1226860 | 2021-04-16 | Gratiot | Michigan | 26057 | 6310 | 111 |
1226861 | 1226861 | 2021-04-16 | Hillsdale | Michigan | 26059 | 3920 | 82 |
1226862 | 1226862 | 2021-04-16 | Houghton | Michigan | 26061 | 2981 | 40 |
1226863 | 1226863 | 2021-04-16 | Huron | Michigan | 26063 | 3608 | 67 |
1226864 | 1226864 | 2021-04-16 | Ingham | Michigan | 26065 | 22304 | 325 |
1226865 | 1226865 | 2021-04-16 | Ionia | Michigan | 26067 | 8237 | 79 |
1226866 | 1226866 | 2021-04-16 | Iosco | Michigan | 26069 | 1730 | 68 |
1226867 | 1226867 | 2021-04-16 | Iron | Michigan | 26071 | 966 | 51 |
1226868 | 1226868 | 2021-04-16 | Isabella | Michigan | 26073 | 5367 | 80 |
1226869 | 1226869 | 2021-04-16 | Jackson | Michigan | 26075 | 19020 | 279 |
1226870 | 1226870 | 2021-04-16 | Kalamazoo | Michigan | 26077 | 19876 | 343 |
1226871 | 1226871 | 2021-04-16 | Kalkaska | Michigan | 26079 | 956 | 16 |
1226872 | 1226872 | 2021-04-16 | Kent | Michigan | 26081 | 63302 | 760 |
1226873 | 1226873 | 2021-04-16 | Keweenaw | Michigan | 26083 | 167 | 2 |
1226874 | 1226874 | 2021-04-16 | Lake | Michigan | 26085 | 515 | 12 |
1226875 | 1226875 | 2021-04-16 | Lapeer | Michigan | 26087 | 8420 | 159 |
1226876 | 1226876 | 2021-04-16 | Leelanau | Michigan | 26089 | 1138 | 16 |
1226877 | 1226877 | 2021-04-16 | Lenawee | Michigan | 26091 | 9603 | 144 |
1226878 | 1226878 | 2021-04-16 | Livingston | Michigan | 26093 | 14624 | 161 |
1226879 | 1226879 | 2021-04-16 | Luce | Michigan | 26095 | 1172 | 2 |
1226880 | 1226880 | 2021-04-16 | Mackinac | Michigan | 26097 | 576 | 3 |
1226881 | 1226881 | 2021-04-16 | Macomb | Michigan | 26099 | 87467 | 2107 |
1226882 | 1226882 | 2021-04-16 | Manistee | Michigan | 26101 | 1803 | 23 |
1226883 | 1226883 | 2021-04-16 | Marquette | Michigan | 26103 | 5496 | 58 |
1226884 | 1226884 | 2021-04-16 | Mason | Michigan | 26105 | 1755 | 28 |
1226885 | 1226885 | 2021-04-16 | Mecosta | Michigan | 26107 | 2723 | 26 |
1226886 | 1226886 | 2021-04-16 | Menominee | Michigan | 26109 | 2000 | 41 |
1226887 | 1226887 | 2021-04-16 | Midland | Michigan | 26111 | 6473 | 75 |
1226888 | 1226888 | 2021-04-16 | Missaukee | Michigan | 26113 | 1300 | 20 |
1226889 | 1226889 | 2021-04-16 | Monroe | Michigan | 26115 | 13566 | 225 |
1226890 | 1226890 | 2021-04-16 | Montcalm | Michigan | 26117 | 6970 | 99 |
1226891 | 1226891 | 2021-04-16 | Montmorency | Michigan | 26119 | 479 | 18 |
1226892 | 1226892 | 2021-04-16 | Muskegon | Michigan | 26121 | 14805 | 326 |
1226893 | 1226893 | 2021-04-16 | Newaygo | Michigan | 26123 | 3940 | 56 |
1226894 | 1226894 | 2021-04-16 | Oakland | Michigan | 26125 | 102866 | 2120 |
1226895 | 1226895 | 2021-04-16 | Oceana | Michigan | 26127 | 2353 | 51 |
1226896 | 1226896 | 2021-04-16 | Ogemaw | Michigan | 26129 | 1420 | 35 |
1226897 | 1226897 | 2021-04-16 | Ontonagon | Michigan | 26131 | 444 | 21 |
1226898 | 1226898 | 2021-04-16 | Osceola | Michigan | 26133 | 1617 | 24 |
1226899 | 1226899 | 2021-04-16 | Oscoda | Michigan | 26135 | 545 | 23 |
1226900 | 1226900 | 2021-04-16 | Otsego | Michigan | 26137 | 2032 | 33 |
1226901 | 1226901 | 2021-04-16 | Ottawa | Michigan | 26139 | 28415 | 383 |
1226902 | 1226902 | 2021-04-16 | Presque Isle | Michigan | 26141 | 897 | 30 |
1226903 | 1226903 | 2021-04-16 | Roscommon | Michigan | 26143 | 1698 | 45 |
1226904 | 1226904 | 2021-04-16 | Saginaw | Michigan | 26145 | 19337 | 553 |
1226905 | 1226905 | 2021-04-16 | Sanilac | Michigan | 26151 | 3782 | 95 |
1226906 | 1226906 | 2021-04-16 | Schoolcraft | Michigan | 26153 | 325 | 5 |
1226907 | 1226907 | 2021-04-16 | Shiawassee | Michigan | 26155 | 5515 | 90 |
1226908 | 1226908 | 2021-04-16 | St. Clair | Michigan | 26147 | 15922 | 337 |
1226909 | 1226909 | 2021-04-16 | St. Joseph | Michigan | 26149 | 5527 | 93 |
1226910 | 1226910 | 2021-04-16 | Tuscola | Michigan | 26157 | 4960 | 152 |
1226911 | 1226911 | 2021-04-16 | Unknown | Michigan | 0 | 17 | |
1226912 | 1226912 | 2021-04-16 | Van Buren | Michigan | 26159 | 6292 | 106 |
1226913 | 1226913 | 2021-04-16 | Washtenaw | Michigan | 26161 | 24638 | 266 |
1226914 | 1226914 | 2021-04-16 | Wayne | Michigan | 26163 | 142132 | 4421 |
1226915 | 1226915 | 2021-04-16 | Wexford | Michigan | 26165 | 2486 | 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);