ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
110 rows where cases = 38 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 30
county 30
- Arenac 41
- Mason 16
- Sanilac 9
- Lake 7
- Alcona 3
- Cheboygan 3
- Iron 3
- Clare 2
- Gratiot 2
- Keweenaw 2
- Missaukee 2
- Unknown 2
- Alpena 1
- Antrim 1
- Berrien 1
- Emmet 1
- Houghton 1
- Huron 1
- Isabella 1
- Mackinac 1
- Manistee 1
- Monroe 1
- Montcalm 1
- Montmorency 1
- Newaygo 1
- Oceana 1
- Ogemaw 1
- Roscommon 1
- Schoolcraft 1
- St. Joseph 1
state 1
- Michigan · 110 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
733486 | 733486 | 2020-11-15 | Keweenaw | Michigan | 26083 | 38 | 1 |
730241 | 730241 | 2020-11-14 | Keweenaw | Michigan | 26083 | 38 | 1 |
691341 | 691341 | 2020-11-02 | Montmorency | Michigan | 26119 | 38 | 0 |
619949 | 619949 | 2020-10-11 | Lake | Michigan | 26085 | 38 | 0 |
616707 | 616707 | 2020-10-10 | Lake | Michigan | 26085 | 38 | 0 |
613466 | 613466 | 2020-10-09 | Lake | Michigan | 26085 | 38 | 0 |
610224 | 610224 | 2020-10-08 | Lake | Michigan | 26085 | 38 | 0 |
606982 | 606982 | 2020-10-07 | Lake | Michigan | 26085 | 38 | 0 |
603739 | 603739 | 2020-10-06 | Lake | Michigan | 26085 | 38 | 0 |
603771 | 603771 | 2020-10-06 | Schoolcraft | Michigan | 26153 | 38 | 0 |
600497 | 600497 | 2020-10-05 | Lake | Michigan | 26085 | 38 | 0 |
516282 | 516282 | 2020-09-09 | Iron | Michigan | 26071 | 38 | 1 |
513048 | 513048 | 2020-09-08 | Iron | Michigan | 26071 | 38 | 1 |
509781 | 509781 | 2020-09-07 | Alcona | Michigan | 26001 | 38 | 2 |
509816 | 509816 | 2020-09-07 | Iron | Michigan | 26071 | 38 | 1 |
506548 | 506548 | 2020-09-06 | Alcona | Michigan | 26001 | 38 | 2 |
503315 | 503315 | 2020-09-05 | Alcona | Michigan | 26001 | 38 | 2 |
496895 | 496895 | 2020-09-03 | Mackinac | Michigan | 26097 | 38 | 0 |
396840 | 396840 | 2020-08-03 | Cheboygan | Michigan | 26031 | 38 | 2 |
396904 | 396904 | 2020-08-03 | Unknown | Michigan | 38 | 3 | |
393613 | 393613 | 2020-08-02 | Antrim | Michigan | 26009 | 38 | 0 |
393624 | 393624 | 2020-08-02 | Cheboygan | Michigan | 26031 | 38 | 2 |
390407 | 390407 | 2020-08-01 | Cheboygan | Michigan | 26031 | 38 | 2 |
358297 | 358297 | 2020-07-22 | Houghton | Michigan | 26061 | 38 | 0 |
348679 | 348679 | 2020-07-19 | Clare | Michigan | 26035 | 38 | 3 |
345478 | 345478 | 2020-07-18 | Clare | Michigan | 26035 | 38 | 3 |
345517 | 345517 | 2020-07-18 | Missaukee | Michigan | 26113 | 38 | 1 |
342266 | 342266 | 2020-07-17 | Arenac | Michigan | 26011 | 38 | 2 |
342317 | 342317 | 2020-07-17 | Missaukee | Michigan | 26113 | 38 | 1 |
339070 | 339070 | 2020-07-16 | Arenac | Michigan | 26011 | 38 | 2 |
335874 | 335874 | 2020-07-15 | Arenac | Michigan | 26011 | 38 | 2 |
335940 | 335940 | 2020-07-15 | Roscommon | Michigan | 26143 | 38 | 0 |
332681 | 332681 | 2020-07-14 | Arenac | Michigan | 26011 | 38 | 2 |
329494 | 329494 | 2020-07-13 | Arenac | Michigan | 26011 | 38 | 2 |
326308 | 326308 | 2020-07-12 | Arenac | Michigan | 26011 | 38 | 2 |
326353 | 326353 | 2020-07-12 | Manistee | Michigan | 26101 | 38 | 0 |
323125 | 323125 | 2020-07-11 | Arenac | Michigan | 26011 | 38 | 2 |
319946 | 319946 | 2020-07-10 | Arenac | Michigan | 26011 | 38 | 2 |
319964 | 319964 | 2020-07-10 | Emmet | Michigan | 26047 | 38 | 2 |
316771 | 316771 | 2020-07-09 | Arenac | Michigan | 26011 | 38 | 2 |
313597 | 313597 | 2020-07-08 | Arenac | Michigan | 26011 | 38 | 2 |
310427 | 310427 | 2020-07-07 | Arenac | Michigan | 26011 | 38 | 2 |
307259 | 307259 | 2020-07-06 | Arenac | Michigan | 26011 | 38 | 2 |
304092 | 304092 | 2020-07-05 | Arenac | Michigan | 26011 | 38 | 2 |
304151 | 304151 | 2020-07-05 | Ogemaw | Michigan | 26129 | 38 | 2 |
300928 | 300928 | 2020-07-04 | Arenac | Michigan | 26011 | 38 | 2 |
297766 | 297766 | 2020-07-03 | Arenac | Michigan | 26011 | 38 | 2 |
294608 | 294608 | 2020-07-02 | Arenac | Michigan | 26011 | 38 | 2 |
288303 | 288303 | 2020-06-30 | Arenac | Michigan | 26011 | 38 | 2 |
285153 | 285153 | 2020-06-29 | Arenac | Michigan | 26011 | 38 | 2 |
278860 | 278860 | 2020-06-27 | Arenac | Michigan | 26011 | 38 | 2 |
275712 | 275712 | 2020-06-26 | Arenac | Michigan | 26011 | 38 | 2 |
272569 | 272569 | 2020-06-25 | Arenac | Michigan | 26011 | 38 | 2 |
269432 | 269432 | 2020-06-24 | Arenac | Michigan | 26011 | 38 | 2 |
266299 | 266299 | 2020-06-23 | Arenac | Michigan | 26011 | 38 | 2 |
263173 | 263173 | 2020-06-22 | Arenac | Michigan | 26011 | 38 | 2 |
260044 | 260044 | 2020-06-21 | Arenac | Michigan | 26011 | 38 | 2 |
256918 | 256918 | 2020-06-20 | Arenac | Michigan | 26011 | 38 | 2 |
253798 | 253798 | 2020-06-19 | Arenac | Michigan | 26011 | 38 | 1 |
250683 | 250683 | 2020-06-18 | Arenac | Michigan | 26011 | 38 | 1 |
247571 | 247571 | 2020-06-17 | Arenac | Michigan | 26011 | 38 | 1 |
247618 | 247618 | 2020-06-17 | Mason | Michigan | 26105 | 38 | 0 |
244458 | 244458 | 2020-06-16 | Arenac | Michigan | 26011 | 38 | 1 |
244505 | 244505 | 2020-06-16 | Mason | Michigan | 26105 | 38 | 0 |
241347 | 241347 | 2020-06-15 | Arenac | Michigan | 26011 | 38 | 1 |
238238 | 238238 | 2020-06-14 | Arenac | Michigan | 26011 | 38 | 1 |
238285 | 238285 | 2020-06-14 | Mason | Michigan | 26105 | 38 | 0 |
235131 | 235131 | 2020-06-13 | Arenac | Michigan | 26011 | 38 | 1 |
235178 | 235178 | 2020-06-13 | Mason | Michigan | 26105 | 38 | 0 |
232026 | 232026 | 2020-06-12 | Arenac | Michigan | 26011 | 38 | 1 |
232073 | 232073 | 2020-06-12 | Mason | Michigan | 26105 | 38 | 0 |
228922 | 228922 | 2020-06-11 | Arenac | Michigan | 26011 | 38 | 1 |
228969 | 228969 | 2020-06-11 | Mason | Michigan | 26105 | 38 | 0 |
225820 | 225820 | 2020-06-10 | Arenac | Michigan | 26011 | 38 | 1 |
225867 | 225867 | 2020-06-10 | Mason | Michigan | 26105 | 38 | 0 |
222723 | 222723 | 2020-06-09 | Arenac | Michigan | 26011 | 38 | 1 |
222769 | 222769 | 2020-06-09 | Mason | Michigan | 26105 | 38 | 0 |
219628 | 219628 | 2020-06-08 | Arenac | Michigan | 26011 | 38 | 1 |
219674 | 219674 | 2020-06-08 | Mason | Michigan | 26105 | 38 | 0 |
216536 | 216536 | 2020-06-07 | Arenac | Michigan | 26011 | 38 | 1 |
216582 | 216582 | 2020-06-07 | Mason | Michigan | 26105 | 38 | 0 |
213448 | 213448 | 2020-06-06 | Arenac | Michigan | 26011 | 38 | 1 |
213494 | 213494 | 2020-06-06 | Mason | Michigan | 26105 | 38 | 0 |
210364 | 210364 | 2020-06-05 | Arenac | Michigan | 26011 | 38 | 1 |
210410 | 210410 | 2020-06-05 | Mason | Michigan | 26105 | 38 | 0 |
207329 | 207329 | 2020-06-04 | Mason | Michigan | 26105 | 38 | 0 |
204248 | 204248 | 2020-06-03 | Mason | Michigan | 26105 | 38 | 0 |
201171 | 201171 | 2020-06-02 | Mason | Michigan | 26105 | 38 | 0 |
198098 | 198098 | 2020-06-01 | Mason | Michigan | 26105 | 38 | 0 |
149456 | 149456 | 2020-05-16 | Sanilac | Michigan | 26151 | 38 | 5 |
146412 | 146412 | 2020-05-15 | Huron | Michigan | 26063 | 38 | 1 |
146451 | 146451 | 2020-05-15 | Sanilac | Michigan | 26151 | 38 | 5 |
143440 | 143440 | 2020-05-14 | Newaygo | Michigan | 26123 | 38 | 0 |
143451 | 143451 | 2020-05-14 | Sanilac | Michigan | 26151 | 38 | 5 |
140447 | 140447 | 2020-05-13 | Oceana | Michigan | 26127 | 38 | 2 |
140456 | 140456 | 2020-05-13 | Sanilac | Michigan | 26151 | 38 | 5 |
137420 | 137420 | 2020-05-12 | Gratiot | Michigan | 26057 | 38 | 4 |
137462 | 137462 | 2020-05-12 | Sanilac | Michigan | 26151 | 38 | 5 |
137468 | 137468 | 2020-05-12 | Unknown | Michigan | 38 | 7 | |
134430 | 134430 | 2020-05-11 | Gratiot | Michigan | 26057 | 38 | 4 |
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);