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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
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,102 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1226911 | 1226911 | 2021-04-16 | Unknown | Michigan | 0 | 17 | |
1233407 | 1233407 | 2021-04-18 | Unknown | Michigan | 0 | 17 | |
1236654 | 1236654 | 2021-04-19 | Unknown | Michigan | 0 | 17 | |
2126711 | 2126711 | 2022-01-18 | Unknown | Michigan | 0 | 25 | |
1080 | 1080 | 2020-03-10 | Oakland | Michigan | 26125 | 1 | 0 |
1081 | 1081 | 2020-03-10 | Wayne | Michigan | 26163 | 1 | 0 |
1260 | 1260 | 2020-03-11 | Oakland | Michigan | 26125 | 1 | 0 |
1261 | 1261 | 2020-03-11 | Wayne | Michigan | 26163 | 1 | 0 |
1478 | 1478 | 2020-03-12 | Ingham | Michigan | 26065 | 1 | 0 |
1480 | 1480 | 2020-03-12 | Montcalm | Michigan | 26117 | 1 | 0 |
1482 | 1482 | 2020-03-12 | St. Clair | Michigan | 26147 | 1 | 0 |
1484 | 1484 | 2020-03-12 | Wayne | Michigan | 26163 | 1 | 0 |
1757 | 1757 | 2020-03-13 | Bay | Michigan | 26017 | 1 | 0 |
1758 | 1758 | 2020-03-13 | Charlevoix | Michigan | 26029 | 1 | 0 |
1759 | 1759 | 2020-03-13 | Ingham | Michigan | 26065 | 1 | 0 |
1761 | 1761 | 2020-03-13 | Leelanau | Michigan | 26089 | 1 | 0 |
1762 | 1762 | 2020-03-13 | Macomb | Michigan | 26099 | 1 | 0 |
1763 | 1763 | 2020-03-13 | Montcalm | Michigan | 26117 | 1 | 0 |
1765 | 1765 | 2020-03-13 | St. Clair | Michigan | 26147 | 1 | 0 |
2100 | 2100 | 2020-03-14 | Bay | Michigan | 26017 | 1 | 0 |
2101 | 2101 | 2020-03-14 | Charlevoix | Michigan | 26029 | 1 | 0 |
2102 | 2102 | 2020-03-14 | Ingham | Michigan | 26065 | 1 | 0 |
2104 | 2104 | 2020-03-14 | Leelanau | Michigan | 26089 | 1 | 0 |
2106 | 2106 | 2020-03-14 | Monroe | Michigan | 26115 | 1 | 0 |
2107 | 2107 | 2020-03-14 | Montcalm | Michigan | 26117 | 1 | 0 |
2109 | 2109 | 2020-03-14 | St. Clair | Michigan | 26147 | 1 | 0 |
2503 | 2503 | 2020-03-15 | Bay | Michigan | 26017 | 1 | 0 |
2504 | 2504 | 2020-03-15 | Charlevoix | Michigan | 26029 | 1 | 0 |
2505 | 2505 | 2020-03-15 | Ingham | Michigan | 26065 | 1 | 0 |
2507 | 2507 | 2020-03-15 | Leelanau | Michigan | 26089 | 1 | 0 |
2509 | 2509 | 2020-03-15 | Monroe | Michigan | 26115 | 1 | 0 |
2510 | 2510 | 2020-03-15 | Montcalm | Michigan | 26117 | 1 | 0 |
2512 | 2512 | 2020-03-15 | Ottawa | Michigan | 26139 | 1 | 0 |
2953 | 2953 | 2020-03-16 | Bay | Michigan | 26017 | 1 | 0 |
2954 | 2954 | 2020-03-16 | Charlevoix | Michigan | 26029 | 1 | 0 |
2955 | 2955 | 2020-03-16 | Ingham | Michigan | 26065 | 1 | 0 |
2957 | 2957 | 2020-03-16 | Leelanau | Michigan | 26089 | 1 | 0 |
2959 | 2959 | 2020-03-16 | Monroe | Michigan | 26115 | 1 | 0 |
2960 | 2960 | 2020-03-16 | Montcalm | Michigan | 26117 | 1 | 0 |
2962 | 2962 | 2020-03-16 | Ottawa | Michigan | 26139 | 1 | 0 |
3454 | 3454 | 2020-03-17 | Bay | Michigan | 26017 | 1 | 0 |
3455 | 3455 | 2020-03-17 | Charlevoix | Michigan | 26029 | 1 | 0 |
3457 | 3457 | 2020-03-17 | Jackson | Michigan | 26075 | 1 | 0 |
3459 | 3459 | 2020-03-17 | Leelanau | Michigan | 26089 | 1 | 0 |
3461 | 3461 | 2020-03-17 | Monroe | Michigan | 26115 | 1 | 0 |
3462 | 3462 | 2020-03-17 | Montcalm | Michigan | 26117 | 1 | 0 |
3464 | 3464 | 2020-03-17 | Otsego | Michigan | 26137 | 1 | 0 |
3465 | 3465 | 2020-03-17 | Ottawa | Michigan | 26139 | 1 | 0 |
4037 | 4037 | 2020-03-18 | Bay | Michigan | 26017 | 1 | 0 |
4038 | 4038 | 2020-03-18 | Charlevoix | Michigan | 26029 | 1 | 0 |
4040 | 4040 | 2020-03-18 | Jackson | Michigan | 26075 | 1 | 0 |
4042 | 4042 | 2020-03-18 | Leelanau | Michigan | 26089 | 1 | 0 |
4044 | 4044 | 2020-03-18 | Monroe | Michigan | 26115 | 1 | 0 |
4045 | 4045 | 2020-03-18 | Montcalm | Michigan | 26117 | 1 | 0 |
4047 | 4047 | 2020-03-18 | Otsego | Michigan | 26137 | 1 | 0 |
4048 | 4048 | 2020-03-18 | Ottawa | Michigan | 26139 | 1 | 0 |
4742 | 4742 | 2020-03-19 | Bay | Michigan | 26017 | 1 | 0 |
4743 | 4743 | 2020-03-19 | Charlevoix | Michigan | 26029 | 1 | 0 |
4744 | 4744 | 2020-03-19 | Clinton | Michigan | 26037 | 1 | 0 |
4746 | 4746 | 2020-03-19 | Genesee | Michigan | 26049 | 1 | 0 |
4748 | 4748 | 2020-03-19 | Jackson | Michigan | 26075 | 1 | 0 |
4750 | 4750 | 2020-03-19 | Leelanau | Michigan | 26089 | 1 | 0 |
4753 | 4753 | 2020-03-19 | Midland | Michigan | 26111 | 1 | 0 |
4755 | 4755 | 2020-03-19 | Montcalm | Michigan | 26117 | 1 | 0 |
4757 | 4757 | 2020-03-19 | Otsego | Michigan | 26137 | 1 | 0 |
4758 | 4758 | 2020-03-19 | Ottawa | Michigan | 26139 | 1 | 0 |
5561 | 5561 | 2020-03-20 | Bay | Michigan | 26017 | 1 | 0 |
5562 | 5562 | 2020-03-20 | Charlevoix | Michigan | 26029 | 1 | 0 |
5563 | 5563 | 2020-03-20 | Clinton | Michigan | 26037 | 1 | 0 |
5565 | 5565 | 2020-03-20 | Genesee | Michigan | 26049 | 1 | 0 |
5567 | 5567 | 2020-03-20 | Jackson | Michigan | 26075 | 1 | 0 |
5569 | 5569 | 2020-03-20 | Leelanau | Michigan | 26089 | 1 | 0 |
5574 | 5574 | 2020-03-20 | Montcalm | Michigan | 26117 | 1 | 0 |
5576 | 5576 | 2020-03-20 | Otsego | Michigan | 26137 | 1 | 0 |
5577 | 5577 | 2020-03-20 | Ottawa | Michigan | 26139 | 1 | 0 |
6521 | 6521 | 2020-03-21 | Allegan | Michigan | 26005 | 1 | 0 |
6522 | 6522 | 2020-03-21 | Barry | Michigan | 26015 | 1 | 0 |
6523 | 6523 | 2020-03-21 | Bay | Michigan | 26017 | 1 | 0 |
6525 | 6525 | 2020-03-21 | Calhoun | Michigan | 26025 | 1 | 0 |
6526 | 6526 | 2020-03-21 | Charlevoix | Michigan | 26029 | 1 | 0 |
6527 | 6527 | 2020-03-21 | Clare | Michigan | 26035 | 1 | 0 |
6532 | 6532 | 2020-03-21 | Jackson | Michigan | 26075 | 1 | 0 |
6534 | 6534 | 2020-03-21 | Leelanau | Michigan | 26089 | 1 | 0 |
6539 | 6539 | 2020-03-21 | Montcalm | Michigan | 26117 | 1 | 0 |
6541 | 6541 | 2020-03-21 | Otsego | Michigan | 26137 | 1 | 0 |
6543 | 6543 | 2020-03-21 | Saginaw | Michigan | 26145 | 1 | 0 |
6545 | 6545 | 2020-03-21 | Tuscola | Michigan | 26157 | 1 | 0 |
6548 | 6548 | 2020-03-21 | Wexford | Michigan | 26165 | 1 | 0 |
7598 | 7598 | 2020-03-22 | Allegan | Michigan | 26005 | 1 | 0 |
7599 | 7599 | 2020-03-22 | Barry | Michigan | 26015 | 1 | 0 |
7600 | 7600 | 2020-03-22 | Bay | Michigan | 26017 | 1 | 0 |
7604 | 7604 | 2020-03-22 | Clare | Michigan | 26035 | 1 | 0 |
7607 | 7607 | 2020-03-22 | Emmet | Michigan | 26047 | 1 | 0 |
7609 | 7609 | 2020-03-22 | Gladwin | Michigan | 26051 | 1 | 0 |
7610 | 7610 | 2020-03-22 | Grand Traverse | Michigan | 26055 | 1 | 0 |
7612 | 7612 | 2020-03-22 | Jackson | Michigan | 26075 | 1 | 0 |
7614 | 7614 | 2020-03-22 | Leelanau | Michigan | 26089 | 1 | 0 |
7619 | 7619 | 2020-03-22 | Montcalm | Michigan | 26117 | 1 | 0 |
7621 | 7621 | 2020-03-22 | Otsego | Michigan | 26137 | 1 | 0 |
7623 | 7623 | 2020-03-22 | Roscommon | Michigan | 26143 | 1 | 0 |
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);