ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65,202 rows where state = "Michigan" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 26125 795
- 26163 795
- 26065 793
- 26081 793
- 26117 793
- 26147 793
- 26161 793
- 26017 792
- 26029 792
- 26089 792
- 26099 792
- 26115 791
- 26139 790
- 26075 788
- 26137 788
- 26037 786
- 26045 786
- 26049 786
- 26093 786
- 26111 786
- 26005 784
- 26015 784
- 26021 784
- 26025 784
- 26035 784
- 26145 784
- 26157 784
- 26165 784
- 26047 783
- 26051 783
- …
county >30
- Oakland 795
- Wayne 795
- Ingham 793
- Kent 793
- Montcalm 793
- St. Clair 793
- Washtenaw 793
- Bay 792
- Charlevoix 792
- Leelanau 792
- Macomb 792
- Monroe 791
- Ottawa 790
- Jackson 788
- Otsego 788
- Clinton 786
- Eaton 786
- Genesee 786
- Livingston 786
- Midland 786
- Allegan 784
- Barry 784
- Berrien 784
- Calhoun 784
- Clare 784
- Saginaw 784
- Tuscola 784
- Wexford 784
- Emmet 783
- Gladwin 783
- …
state 1
- Michigan · 65,202 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
60275 | 60275 | 2020-04-15 | Alcona | Michigan | 26001 | 1 | 0 |
62996 | 62996 | 2020-04-16 | Alcona | Michigan | 26001 | 1 | 0 |
65734 | 65734 | 2020-04-17 | Alcona | Michigan | 26001 | 1 | 0 |
68484 | 68484 | 2020-04-18 | Alcona | Michigan | 26001 | 1 | 0 |
71248 | 71248 | 2020-04-19 | Alcona | Michigan | 26001 | 1 | 0 |
74020 | 74020 | 2020-04-20 | Alcona | Michigan | 26001 | 1 | 0 |
76800 | 76800 | 2020-04-21 | Alcona | Michigan | 26001 | 3 | 0 |
79586 | 79586 | 2020-04-22 | Alcona | Michigan | 26001 | 4 | 0 |
82381 | 82381 | 2020-04-23 | Alcona | Michigan | 26001 | 4 | 0 |
85185 | 85185 | 2020-04-24 | Alcona | Michigan | 26001 | 4 | 0 |
87995 | 87995 | 2020-04-25 | Alcona | Michigan | 26001 | 4 | 0 |
90811 | 90811 | 2020-04-26 | Alcona | Michigan | 26001 | 4 | 0 |
93632 | 93632 | 2020-04-27 | Alcona | Michigan | 26001 | 4 | 0 |
96467 | 96467 | 2020-04-28 | Alcona | Michigan | 26001 | 4 | 0 |
99313 | 99313 | 2020-04-29 | Alcona | Michigan | 26001 | 4 | 0 |
102165 | 102165 | 2020-04-30 | Alcona | Michigan | 26001 | 4 | 1 |
105025 | 105025 | 2020-05-01 | Alcona | Michigan | 26001 | 4 | 1 |
107889 | 107889 | 2020-05-02 | Alcona | Michigan | 26001 | 5 | 1 |
110761 | 110761 | 2020-05-03 | Alcona | Michigan | 26001 | 4 | 1 |
113639 | 113639 | 2020-05-04 | Alcona | Michigan | 26001 | 4 | 1 |
116520 | 116520 | 2020-05-05 | Alcona | Michigan | 26001 | 4 | 1 |
119481 | 119481 | 2020-05-06 | Alcona | Michigan | 26001 | 4 | 1 |
122453 | 122453 | 2020-05-07 | Alcona | Michigan | 26001 | 4 | 1 |
125435 | 125435 | 2020-05-08 | Alcona | Michigan | 26001 | 4 | 1 |
128422 | 128422 | 2020-05-09 | Alcona | Michigan | 26001 | 4 | 1 |
131412 | 131412 | 2020-05-10 | Alcona | Michigan | 26001 | 4 | 1 |
134403 | 134403 | 2020-05-11 | Alcona | Michigan | 26001 | 4 | 1 |
137393 | 137393 | 2020-05-12 | Alcona | Michigan | 26001 | 4 | 1 |
140387 | 140387 | 2020-05-13 | Alcona | Michigan | 26001 | 4 | 1 |
143382 | 143382 | 2020-05-14 | Alcona | Michigan | 26001 | 5 | 1 |
146382 | 146382 | 2020-05-15 | Alcona | Michigan | 26001 | 6 | 1 |
149387 | 149387 | 2020-05-16 | Alcona | Michigan | 26001 | 6 | 1 |
152398 | 152398 | 2020-05-17 | Alcona | Michigan | 26001 | 6 | 1 |
155412 | 155412 | 2020-05-18 | Alcona | Michigan | 26001 | 6 | 1 |
158430 | 158430 | 2020-05-19 | Alcona | Michigan | 26001 | 6 | 1 |
161456 | 161456 | 2020-05-20 | Alcona | Michigan | 26001 | 8 | 1 |
164485 | 164485 | 2020-05-21 | Alcona | Michigan | 26001 | 9 | 1 |
167521 | 167521 | 2020-05-22 | Alcona | Michigan | 26001 | 9 | 1 |
170558 | 170558 | 2020-05-23 | Alcona | Michigan | 26001 | 10 | 1 |
173600 | 173600 | 2020-05-24 | Alcona | Michigan | 26001 | 11 | 1 |
176643 | 176643 | 2020-05-25 | Alcona | Michigan | 26001 | 11 | 1 |
179687 | 179687 | 2020-05-26 | Alcona | Michigan | 26001 | 11 | 1 |
182733 | 182733 | 2020-05-27 | Alcona | Michigan | 26001 | 12 | 1 |
185788 | 185788 | 2020-05-28 | Alcona | Michigan | 26001 | 14 | 1 |
188846 | 188846 | 2020-05-29 | Alcona | Michigan | 26001 | 14 | 1 |
191910 | 191910 | 2020-05-30 | Alcona | Michigan | 26001 | 14 | 1 |
194978 | 194978 | 2020-05-31 | Alcona | Michigan | 26001 | 15 | 1 |
198049 | 198049 | 2020-06-01 | Alcona | Michigan | 26001 | 21 | 1 |
201121 | 201121 | 2020-06-02 | Alcona | Michigan | 26001 | 21 | 1 |
204198 | 204198 | 2020-06-03 | Alcona | Michigan | 26001 | 20 | 1 |
207279 | 207279 | 2020-06-04 | Alcona | Michigan | 26001 | 21 | 1 |
210360 | 210360 | 2020-06-05 | Alcona | Michigan | 26001 | 21 | 1 |
213444 | 213444 | 2020-06-06 | Alcona | Michigan | 26001 | 21 | 1 |
216532 | 216532 | 2020-06-07 | Alcona | Michigan | 26001 | 21 | 1 |
219624 | 219624 | 2020-06-08 | Alcona | Michigan | 26001 | 21 | 1 |
222719 | 222719 | 2020-06-09 | Alcona | Michigan | 26001 | 21 | 1 |
225815 | 225815 | 2020-06-10 | Alcona | Michigan | 26001 | 21 | 1 |
228917 | 228917 | 2020-06-11 | Alcona | Michigan | 26001 | 21 | 1 |
232021 | 232021 | 2020-06-12 | Alcona | Michigan | 26001 | 21 | 1 |
235126 | 235126 | 2020-06-13 | Alcona | Michigan | 26001 | 21 | 1 |
238233 | 238233 | 2020-06-14 | Alcona | Michigan | 26001 | 21 | 1 |
241342 | 241342 | 2020-06-15 | Alcona | Michigan | 26001 | 21 | 1 |
244453 | 244453 | 2020-06-16 | Alcona | Michigan | 26001 | 21 | 1 |
247566 | 247566 | 2020-06-17 | Alcona | Michigan | 26001 | 21 | 1 |
250678 | 250678 | 2020-06-18 | Alcona | Michigan | 26001 | 21 | 1 |
253793 | 253793 | 2020-06-19 | Alcona | Michigan | 26001 | 21 | 1 |
256913 | 256913 | 2020-06-20 | Alcona | Michigan | 26001 | 21 | 1 |
260039 | 260039 | 2020-06-21 | Alcona | Michigan | 26001 | 21 | 1 |
263168 | 263168 | 2020-06-22 | Alcona | Michigan | 26001 | 21 | 1 |
266294 | 266294 | 2020-06-23 | Alcona | Michigan | 26001 | 21 | 1 |
269427 | 269427 | 2020-06-24 | Alcona | Michigan | 26001 | 21 | 1 |
272564 | 272564 | 2020-06-25 | Alcona | Michigan | 26001 | 21 | 1 |
275707 | 275707 | 2020-06-26 | Alcona | Michigan | 26001 | 21 | 1 |
278855 | 278855 | 2020-06-27 | Alcona | Michigan | 26001 | 21 | 1 |
282003 | 282003 | 2020-06-28 | Alcona | Michigan | 26001 | 21 | 1 |
285148 | 285148 | 2020-06-29 | Alcona | Michigan | 26001 | 21 | 1 |
288298 | 288298 | 2020-06-30 | Alcona | Michigan | 26001 | 22 | 1 |
291449 | 291449 | 2020-07-01 | Alcona | Michigan | 26001 | 21 | 1 |
294603 | 294603 | 2020-07-02 | Alcona | Michigan | 26001 | 22 | 1 |
297761 | 297761 | 2020-07-03 | Alcona | Michigan | 26001 | 22 | 1 |
300923 | 300923 | 2020-07-04 | Alcona | Michigan | 26001 | 22 | 1 |
304087 | 304087 | 2020-07-05 | Alcona | Michigan | 26001 | 22 | 1 |
307254 | 307254 | 2020-07-06 | Alcona | Michigan | 26001 | 22 | 1 |
310422 | 310422 | 2020-07-07 | Alcona | Michigan | 26001 | 22 | 1 |
313592 | 313592 | 2020-07-08 | Alcona | Michigan | 26001 | 22 | 1 |
316766 | 316766 | 2020-07-09 | Alcona | Michigan | 26001 | 24 | 1 |
319941 | 319941 | 2020-07-10 | Alcona | Michigan | 26001 | 24 | 1 |
323120 | 323120 | 2020-07-11 | Alcona | Michigan | 26001 | 24 | 1 |
326303 | 326303 | 2020-07-12 | Alcona | Michigan | 26001 | 24 | 1 |
329489 | 329489 | 2020-07-13 | Alcona | Michigan | 26001 | 24 | 1 |
332676 | 332676 | 2020-07-14 | Alcona | Michigan | 26001 | 24 | 1 |
335869 | 335869 | 2020-07-15 | Alcona | Michigan | 26001 | 25 | 1 |
339065 | 339065 | 2020-07-16 | Alcona | Michigan | 26001 | 24 | 1 |
342261 | 342261 | 2020-07-17 | Alcona | Michigan | 26001 | 25 | 1 |
345461 | 345461 | 2020-07-18 | Alcona | Michigan | 26001 | 26 | 1 |
348662 | 348662 | 2020-07-19 | Alcona | Michigan | 26001 | 25 | 1 |
351862 | 351862 | 2020-07-20 | Alcona | Michigan | 26001 | 26 | 1 |
355064 | 355064 | 2020-07-21 | Alcona | Michigan | 26001 | 27 | 1 |
358267 | 358267 | 2020-07-22 | Alcona | Michigan | 26001 | 27 | 1 |
361472 | 361472 | 2020-07-23 | Alcona | Michigan | 26001 | 27 | 1 |
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);