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

28,914 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 · 28,914 ✖
Link rowid date ▲ county state fips cases deaths
1096942 1096942 2021-03-07 Alcona Michigan 26001 433 24
1096943 1096943 2021-03-07 Alger Michigan 26003 584 5
1096944 1096944 2021-03-07 Allegan Michigan 26005 7405 118
1096945 1096945 2021-03-07 Alpena Michigan 26007 1502 48
1096946 1096946 2021-03-07 Antrim Michigan 26009 1177 20
1096947 1096947 2021-03-07 Arenac Michigan 26011 767 25
1096948 1096948 2021-03-07 Baraga Michigan 26013 777 33
1096949 1096949 2021-03-07 Barry Michigan 26015 3821 47
1096950 1096950 2021-03-07 Bay Michigan 26017 7549 294
1096951 1096951 2021-03-07 Benzie Michigan 26019 931 31
1096952 1096952 2021-03-07 Berrien Michigan 26021 11732 245
1096953 1096953 2021-03-07 Branch Michigan 26023 4624 111
1096954 1096954 2021-03-07 Calhoun Michigan 26025 9822 235
1096955 1096955 2021-03-07 Cass Michigan 26027 4089 64
1096956 1096956 2021-03-07 Charlevoix Michigan 26029 1285 13
1096957 1096957 2021-03-07 Cheboygan Michigan 26031 1033 38
1096958 1096958 2021-03-07 Chippewa Michigan 26033 4891 43
1096959 1096959 2021-03-07 Clare Michigan 26035 1626 69
1096960 1096960 2021-03-07 Clinton Michigan 26037 5098 71
1096961 1096961 2021-03-07 Crawford Michigan 26039 607 5
1096962 1096962 2021-03-07 Delta Michigan 26041 3157 85
1096963 1096963 2021-03-07 Dickinson Michigan 26043 2373 70
1096964 1096964 2021-03-07 Eaton Michigan 26045 6407 156
1096965 1096965 2021-03-07 Emmet Michigan 26047 1840 39
1096966 1096966 2021-03-07 Genesee Michigan 26049 26111 757
1096967 1096967 2021-03-07 Gladwin Michigan 26051 1500 43
1096968 1096968 2021-03-07 Gogebic Michigan 26053 1289 48
1096969 1096969 2021-03-07 Grand Traverse Michigan 26055 4368 71
1096970 1096970 2021-03-07 Gratiot Michigan 26057 5684 108
1096971 1096971 2021-03-07 Hillsdale Michigan 26059 3392 76
1096972 1096972 2021-03-07 Houghton Michigan 26061 2686 40
1096973 1096973 2021-03-07 Huron Michigan 26063 2203 59
1096974 1096974 2021-03-07 Ingham Michigan 26065 16689 282
1096975 1096975 2021-03-07 Ionia Michigan 26067 7106 76
1096976 1096976 2021-03-07 Iosco Michigan 26069 1281 67
1096977 1096977 2021-03-07 Iron Michigan 26071 929 49
1096978 1096978 2021-03-07 Isabella Michigan 26073 4062 73
1096979 1096979 2021-03-07 Jackson Michigan 26075 14361 255
1096980 1096980 2021-03-07 Kalamazoo Michigan 26077 15274 324
1096981 1096981 2021-03-07 Kalkaska Michigan 26079 634 15
1096982 1096982 2021-03-07 Kent Michigan 26081 52310 717
1096983 1096983 2021-03-07 Keweenaw Michigan 26083 145 2
1096984 1096984 2021-03-07 Lake Michigan 26085 368 11
1096985 1096985 2021-03-07 Lapeer Michigan 26087 5704 131
1096986 1096986 2021-03-07 Leelanau Michigan 26089 890 15
1096987 1096987 2021-03-07 Lenawee Michigan 26091 7878 129
1096988 1096988 2021-03-07 Livingston Michigan 26093 10586 149
1096989 1096989 2021-03-07 Luce Michigan 26095 1087 2
1096990 1096990 2021-03-07 Mackinac Michigan 26097 448 3
1096991 1096991 2021-03-07 Macomb Michigan 26099 60588 1984
1096992 1096992 2021-03-07 Manistee Michigan 26101 1535 23
1096993 1096993 2021-03-07 Marquette Michigan 26103 4830 57
1096994 1096994 2021-03-07 Mason Michigan 26105 1250 26
1096995 1096995 2021-03-07 Mecosta Michigan 26107 2043 20
1096996 1096996 2021-03-07 Menominee Michigan 26109 1882 38
1096997 1096997 2021-03-07 Midland Michigan 26111 5088 66
1096998 1096998 2021-03-07 Missaukee Michigan 26113 813 18
1096999 1096999 2021-03-07 Monroe Michigan 26115 10008 204
1097000 1097000 2021-03-07 Montcalm Michigan 26117 5671 94
1097001 1097001 2021-03-07 Montmorency Michigan 26119 370 17
1097002 1097002 2021-03-07 Muskegon Michigan 26121 12730 317
1097003 1097003 2021-03-07 Newaygo Michigan 26123 2929 52
1097004 1097004 2021-03-07 Oakland Michigan 26125 75863 2019
1097005 1097005 2021-03-07 Oceana Michigan 26127 1889 50
1097006 1097006 2021-03-07 Ogemaw Michigan 26129 1116 34
1097007 1097007 2021-03-07 Ontonagon Michigan 26131 413 20
1097008 1097008 2021-03-07 Osceola Michigan 26133 1070 23
1097009 1097009 2021-03-07 Oscoda Michigan 26135 401 19
1097010 1097010 2021-03-07 Otsego Michigan 26137 1403 27
1097011 1097011 2021-03-07 Ottawa Michigan 26139 22619 357
1097012 1097012 2021-03-07 Presque Isle Michigan 26141 667 28
1097013 1097013 2021-03-07 Roscommon Michigan 26143 1188 33
1097014 1097014 2021-03-07 Saginaw Michigan 26145 16159 527
1097015 1097015 2021-03-07 Sanilac Michigan 26151 2155 77
1097016 1097016 2021-03-07 Schoolcraft Michigan 26153 260 5
1097017 1097017 2021-03-07 Shiawassee Michigan 26155 3894 81
1097018 1097018 2021-03-07 St. Clair Michigan 26147 8904 261
1097019 1097019 2021-03-07 St. Joseph Michigan 26149 4788 85
1097020 1097020 2021-03-07 Tuscola Michigan 26157 3293 138
1097021 1097021 2021-03-07 Unknown Michigan   0 12
1097022 1097022 2021-03-07 Van Buren Michigan 26159 5033 97
1097023 1097023 2021-03-07 Washtenaw Michigan 26161 19548 252
1097024 1097024 2021-03-07 Wayne Michigan 26163 103587 4174
1097025 1097025 2021-03-07 Wexford Michigan 26165 1481 21
1093695 1093695 2021-03-06 Alcona Michigan 26001 433 24
1093696 1093696 2021-03-06 Alger Michigan 26003 584 5
1093697 1093697 2021-03-06 Allegan Michigan 26005 7405 118
1093698 1093698 2021-03-06 Alpena Michigan 26007 1502 48
1093699 1093699 2021-03-06 Antrim Michigan 26009 1177 20
1093700 1093700 2021-03-06 Arenac Michigan 26011 767 25
1093701 1093701 2021-03-06 Baraga Michigan 26013 777 33
1093702 1093702 2021-03-06 Barry Michigan 26015 3821 47
1093703 1093703 2021-03-06 Bay Michigan 26017 7549 294
1093704 1093704 2021-03-06 Benzie Michigan 26019 931 31
1093705 1093705 2021-03-06 Berrien Michigan 26021 11722 245
1093706 1093706 2021-03-06 Branch Michigan 26023 4624 111
1093707 1093707 2021-03-06 Calhoun Michigan 26025 9822 235
1093708 1093708 2021-03-06 Cass Michigan 26027 4089 64
1093709 1093709 2021-03-06 Charlevoix Michigan 26029 1285 13
1093710 1093710 2021-03-06 Cheboygan Michigan 26031 1033 38

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