ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

47,562 rows where state = "Michigan" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Michigan · 47,562 ✖
Link rowid date ▲ county state fips cases deaths
1817858 1817858 2021-10-15 Alcona Michigan 26001 1043 40
1817859 1817859 2021-10-15 Alger Michigan 26003 978 8
1817860 1817860 2021-10-15 Allegan Michigan 26005 14151 184
1817861 1817861 2021-10-15 Alpena Michigan 26007 2968 69
1817862 1817862 2021-10-15 Antrim Michigan 26009 2245 36
1817863 1817863 2021-10-15 Arenac Michigan 26011 1671 33
1817864 1817864 2021-10-15 Baraga Michigan 26013 1248 46
1817865 1817865 2021-10-15 Barry Michigan 26015 7489 81
1817866 1817866 2021-10-15 Bay Michigan 26017 14201 379
1817867 1817867 2021-10-15 Benzie Michigan 26019 1592 38
1817868 1817868 2021-10-15 Berrien Michigan 26021 18802 328
1817869 1817869 2021-10-15 Branch Michigan 26023 7109 134
1817870 1817870 2021-10-15 Calhoun Michigan 26025 18176 345
1817871 1817871 2021-10-15 Cass Michigan 26027 6902 88
1817872 1817872 2021-10-15 Charlevoix Michigan 26029 2385 31
1817873 1817873 2021-10-15 Cheboygan Michigan 26031 2694 63
1817874 1817874 2021-10-15 Chippewa Michigan 26033 6730 58
1817875 1817875 2021-10-15 Clare Michigan 26035 3550 97
1817876 1817876 2021-10-15 Clinton Michigan 26037 9643 105
1817877 1817877 2021-10-15 Crawford Michigan 26039 1242 16
1817878 1817878 2021-10-15 Delta Michigan 26041 5549 103
1817879 1817879 2021-10-15 Dickinson Michigan 26043 3851 80
1817880 1817880 2021-10-15 Eaton Michigan 26045 12716 236
1817881 1817881 2021-10-15 Emmet Michigan 26047 3268 49
1817882 1817882 2021-10-15 Genesee Michigan 26049 50167 1059
1817883 1817883 2021-10-15 Gladwin Michigan 26051 3116 68
1817884 1817884 2021-10-15 Gogebic Michigan 26053 1766 53
1817885 1817885 2021-10-15 Grand Traverse Michigan 26055 8531 117
1817886 1817886 2021-10-15 Gratiot Michigan 26057 8320 129
1817887 1817887 2021-10-15 Hillsdale Michigan 26059 5940 118
1817888 1817888 2021-10-15 Houghton Michigan 26061 3812 55
1817889 1817889 2021-10-15 Huron Michigan 26063 4658 89
1817890 1817890 2021-10-15 Ingham Michigan 26065 30047 444
1817891 1817891 2021-10-15 Ionia Michigan 26067 11415 95
1817892 1817892 2021-10-15 Iosco Michigan 26069 2817 92
1817893 1817893 2021-10-15 Iron Michigan 26071 1377 55
1817894 1817894 2021-10-15 Isabella Michigan 26073 8538 111
1817895 1817895 2021-10-15 Jackson Michigan 26075 24991 352
1817896 1817896 2021-10-15 Kalamazoo Michigan 26077 28740 443
1817897 1817897 2021-10-15 Kalkaska Michigan 26079 1684 35
1817898 1817898 2021-10-15 Kent Michigan 26081 90019 961
1817899 1817899 2021-10-15 Keweenaw Michigan 26083 235 4
1817900 1817900 2021-10-15 Lake Michigan 26085 911 20
1817901 1817901 2021-10-15 Lapeer Michigan 26087 11723 247
1817902 1817902 2021-10-15 Leelanau Michigan 26089 1572 24
1817903 1817903 2021-10-15 Lenawee Michigan 26091 13899 197
1817904 1817904 2021-10-15 Livingston Michigan 26093 22143 230
1817905 1817905 2021-10-15 Luce Michigan 26095 1540 6
1817906 1817906 2021-10-15 Mackinac Michigan 26097 1215 7
1817907 1817907 2021-10-15 Macomb Michigan 26099 118281 2648
1817908 1817908 2021-10-15 Manistee Michigan 26101 2405 34
1817909 1817909 2021-10-15 Marquette Michigan 26103 7667 76
1817910 1817910 2021-10-15 Mason Michigan 26105 2965 45
1817911 1817911 2021-10-15 Mecosta Michigan 26107 4437 44
1817912 1817912 2021-10-15 Menominee Michigan 26109 3211 49
1817913 1817913 2021-10-15 Midland Michigan 26111 9874 125
1817914 1817914 2021-10-15 Missaukee Michigan 26113 1792 34
1817915 1817915 2021-10-15 Monroe Michigan 26115 19666 295
1817916 1817916 2021-10-15 Montcalm Michigan 26117 10275 129
1817917 1817917 2021-10-15 Montmorency Michigan 26119 862 25
1817918 1817918 2021-10-15 Muskegon Michigan 26121 22604 422
1817919 1817919 2021-10-15 Newaygo Michigan 26123 6312 79
1817920 1817920 2021-10-15 Oakland Michigan 26125 141782 2638
1817921 1817921 2021-10-15 Oceana Michigan 26127 3566 69
1817922 1817922 2021-10-15 Ogemaw Michigan 26129 2590 54
1817923 1817923 2021-10-15 Ontonagon Michigan 26131 593 22
1817924 1817924 2021-10-15 Osceola Michigan 26133 2836 34
1817925 1817925 2021-10-15 Oscoda Michigan 26135 903 33
1817926 1817926 2021-10-15 Otsego Michigan 26137 3120 51
1817927 1817927 2021-10-15 Ottawa Michigan 26139 39985 489
1817928 1817928 2021-10-15 Presque Isle Michigan 26141 1311 36
1817929 1817929 2021-10-15 Roscommon Michigan 26143 2344 62
1817930 1817930 2021-10-15 Saginaw Michigan 26145 27460 667
1817931 1817931 2021-10-15 Sanilac Michigan 26151 4831 132
1817932 1817932 2021-10-15 Schoolcraft Michigan 26153 753 5
1817933 1817933 2021-10-15 Shiawassee Michigan 26155 8333 125
1817934 1817934 2021-10-15 St. Clair Michigan 26147 21672 503
1817935 1817935 2021-10-15 St. Joseph Michigan 26149 8068 117
1817936 1817936 2021-10-15 Tuscola Michigan 26157 7125 190
1817937 1817937 2021-10-15 Unknown Michigan   1048 13
1817938 1817938 2021-10-15 Van Buren Michigan 26159 8936 157
1817939 1817939 2021-10-15 Washtenaw Michigan 26161 32962 331
1817940 1817940 2021-10-15 Wayne Michigan 26163 193985 5506
1817941 1817941 2021-10-15 Wexford Michigan 26165 3479 51
1814609 1814609 2021-10-14 Alcona Michigan 26001 1026 40
1814610 1814610 2021-10-14 Alger Michigan 26003 972 8
1814611 1814611 2021-10-14 Allegan Michigan 26005 14011 181
1814612 1814612 2021-10-14 Alpena Michigan 26007 2927 69
1814613 1814613 2021-10-14 Antrim Michigan 26009 2237 36
1814614 1814614 2021-10-14 Arenac Michigan 26011 1633 32
1814615 1814615 2021-10-14 Baraga Michigan 26013 1226 46
1814616 1814616 2021-10-14 Barry Michigan 26015 7417 79
1814617 1814617 2021-10-14 Bay Michigan 26017 14015 377
1814618 1814618 2021-10-14 Benzie Michigan 26019 1583 38
1814619 1814619 2021-10-14 Berrien Michigan 26021 18692 324
1814620 1814620 2021-10-14 Branch Michigan 26023 7078 134
1814621 1814621 2021-10-14 Calhoun Michigan 26025 18000 342
1814622 1814622 2021-10-14 Cass Michigan 26027 6848 88
1814623 1814623 2021-10-14 Charlevoix Michigan 26029 2367 31
1814624 1814624 2021-10-14 Cheboygan Michigan 26031 2653 63

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);