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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 26099 786
- 26111 786
- 26115 786
- 26117 786
- 26125 786
- 26137 786
- 26139 786
- 26147 786
- 26161 786
- 26163 786
- 26017 785
- 26029 785
- 26037 785
- 26045 785
- 26049 785
- 26065 785
- 26075 785
- 26081 785
- 26089 785
- 26093 785
- 26005 784
- 26015 784
- 26021 784
- 26025 784
- 26035 784
- 26145 784
- 26157 784
- 26165 784
- 26047 783
- 26051 783
- …
county >30
- Macomb 786
- Midland 786
- Monroe 786
- Montcalm 786
- Oakland 786
- Otsego 786
- Ottawa 786
- St. Clair 786
- Washtenaw 786
- Wayne 786
- Bay 785
- Charlevoix 785
- Clinton 785
- Eaton 785
- Genesee 785
- Ingham 785
- Jackson 785
- Kent 785
- Leelanau 785
- Livingston 785
- 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 |
---|---|---|---|---|---|---|---|
4752 | 4752 | 2020-03-19 | Macomb | Michigan | 26099 | 55 | 0 |
4753 | 4753 | 2020-03-19 | Midland | Michigan | 26111 | 1 | 0 |
4754 | 4754 | 2020-03-19 | Monroe | Michigan | 26115 | 3 | 0 |
4755 | 4755 | 2020-03-19 | Montcalm | Michigan | 26117 | 1 | 0 |
4756 | 4756 | 2020-03-19 | Oakland | Michigan | 26125 | 105 | 0 |
4757 | 4757 | 2020-03-19 | Otsego | Michigan | 26137 | 1 | 0 |
4758 | 4758 | 2020-03-19 | Ottawa | Michigan | 26139 | 1 | 0 |
4759 | 4759 | 2020-03-19 | St. Clair | Michigan | 26147 | 4 | 0 |
4760 | 4760 | 2020-03-19 | Washtenaw | Michigan | 26161 | 14 | 0 |
4761 | 4761 | 2020-03-19 | Wayne | Michigan | 26163 | 119 | 3 |
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 |
5564 | 5564 | 2020-03-20 | Eaton | Michigan | 26045 | 2 | 0 |
5565 | 5565 | 2020-03-20 | Genesee | Michigan | 26049 | 1 | 0 |
5566 | 5566 | 2020-03-20 | Ingham | Michigan | 26065 | 7 | 0 |
5567 | 5567 | 2020-03-20 | Jackson | Michigan | 26075 | 1 | 0 |
5568 | 5568 | 2020-03-20 | Kent | Michigan | 26081 | 12 | 0 |
5569 | 5569 | 2020-03-20 | Leelanau | Michigan | 26089 | 1 | 0 |
5570 | 5570 | 2020-03-20 | Livingston | Michigan | 26093 | 3 | 0 |
5571 | 5571 | 2020-03-20 | Macomb | Michigan | 26099 | 86 | 0 |
5572 | 5572 | 2020-03-20 | Midland | Michigan | 26111 | 3 | 0 |
5573 | 5573 | 2020-03-20 | Monroe | Michigan | 26115 | 3 | 0 |
5574 | 5574 | 2020-03-20 | Montcalm | Michigan | 26117 | 1 | 0 |
5575 | 5575 | 2020-03-20 | Oakland | Michigan | 26125 | 184 | 1 |
5576 | 5576 | 2020-03-20 | Otsego | Michigan | 26137 | 1 | 0 |
5577 | 5577 | 2020-03-20 | Ottawa | Michigan | 26139 | 1 | 0 |
5578 | 5578 | 2020-03-20 | St. Clair | Michigan | 26147 | 7 | 0 |
5579 | 5579 | 2020-03-20 | Washtenaw | Michigan | 26161 | 16 | 0 |
5580 | 5580 | 2020-03-20 | Wayne | Michigan | 26163 | 216 | 3 |
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 |
6524 | 6524 | 2020-03-21 | Berrien | Michigan | 26021 | 2 | 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 |
6528 | 6528 | 2020-03-21 | Clinton | Michigan | 26037 | 2 | 0 |
6529 | 6529 | 2020-03-21 | Eaton | Michigan | 26045 | 2 | 0 |
6530 | 6530 | 2020-03-21 | Genesee | Michigan | 26049 | 7 | 0 |
6531 | 6531 | 2020-03-21 | Ingham | Michigan | 26065 | 11 | 0 |
6532 | 6532 | 2020-03-21 | Jackson | Michigan | 26075 | 1 | 0 |
6533 | 6533 | 2020-03-21 | Kent | Michigan | 26081 | 21 | 1 |
6534 | 6534 | 2020-03-21 | Leelanau | Michigan | 26089 | 1 | 0 |
6535 | 6535 | 2020-03-21 | Livingston | Michigan | 26093 | 6 | 0 |
6536 | 6536 | 2020-03-21 | Macomb | Michigan | 26099 | 101 | 0 |
6537 | 6537 | 2020-03-21 | Midland | Michigan | 26111 | 3 | 0 |
6538 | 6538 | 2020-03-21 | Monroe | Michigan | 26115 | 3 | 0 |
6539 | 6539 | 2020-03-21 | Montcalm | Michigan | 26117 | 1 | 0 |
6540 | 6540 | 2020-03-21 | Oakland | Michigan | 26125 | 229 | 1 |
6541 | 6541 | 2020-03-21 | Otsego | Michigan | 26137 | 1 | 0 |
6542 | 6542 | 2020-03-21 | Ottawa | Michigan | 26139 | 2 | 0 |
6543 | 6543 | 2020-03-21 | Saginaw | Michigan | 26145 | 1 | 0 |
6544 | 6544 | 2020-03-21 | St. Clair | Michigan | 26147 | 7 | 0 |
6545 | 6545 | 2020-03-21 | Tuscola | Michigan | 26157 | 1 | 0 |
6546 | 6546 | 2020-03-21 | Washtenaw | Michigan | 26161 | 29 | 0 |
6547 | 6547 | 2020-03-21 | Wayne | Michigan | 26163 | 349 | 4 |
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 |
7601 | 7601 | 2020-03-22 | Berrien | Michigan | 26021 | 3 | 0 |
7602 | 7602 | 2020-03-22 | Calhoun | Michigan | 26025 | 2 | 0 |
7603 | 7603 | 2020-03-22 | Charlevoix | Michigan | 26029 | 2 | 0 |
7604 | 7604 | 2020-03-22 | Clare | Michigan | 26035 | 1 | 0 |
7605 | 7605 | 2020-03-22 | Clinton | Michigan | 26037 | 2 | 0 |
7606 | 7606 | 2020-03-22 | Eaton | Michigan | 26045 | 2 | 0 |
7607 | 7607 | 2020-03-22 | Emmet | Michigan | 26047 | 1 | 0 |
7608 | 7608 | 2020-03-22 | Genesee | Michigan | 26049 | 14 | 0 |
7609 | 7609 | 2020-03-22 | Gladwin | Michigan | 26051 | 1 | 0 |
7610 | 7610 | 2020-03-22 | Grand Traverse | Michigan | 26055 | 1 | 0 |
7611 | 7611 | 2020-03-22 | Ingham | Michigan | 26065 | 11 | 0 |
7612 | 7612 | 2020-03-22 | Jackson | Michigan | 26075 | 1 | 0 |
7613 | 7613 | 2020-03-22 | Kent | Michigan | 26081 | 21 | 1 |
7614 | 7614 | 2020-03-22 | Leelanau | Michigan | 26089 | 1 | 0 |
7615 | 7615 | 2020-03-22 | Livingston | Michigan | 26093 | 8 | 0 |
7616 | 7616 | 2020-03-22 | Macomb | Michigan | 26099 | 140 | 1 |
7617 | 7617 | 2020-03-22 | Midland | Michigan | 26111 | 5 | 0 |
7618 | 7618 | 2020-03-22 | Monroe | Michigan | 26115 | 6 | 0 |
7619 | 7619 | 2020-03-22 | Montcalm | Michigan | 26117 | 1 | 0 |
7620 | 7620 | 2020-03-22 | Oakland | Michigan | 26125 | 277 | 1 |
7621 | 7621 | 2020-03-22 | Otsego | Michigan | 26137 | 1 | 0 |
7622 | 7622 | 2020-03-22 | Ottawa | Michigan | 26139 | 6 | 0 |
7623 | 7623 | 2020-03-22 | Roscommon | Michigan | 26143 | 1 | 0 |
7624 | 7624 | 2020-03-22 | Saginaw | Michigan | 26145 | 2 | 0 |
7625 | 7625 | 2020-03-22 | St. Clair | Michigan | 26147 | 7 | 0 |
7626 | 7626 | 2020-03-22 | Tuscola | Michigan | 26157 | 1 | 0 |
7627 | 7627 | 2020-03-22 | Washtenaw | Michigan | 26161 | 34 | 1 |
7628 | 7628 | 2020-03-22 | Wayne | Michigan | 26163 | 477 | 5 |
7629 | 7629 | 2020-03-22 | Wexford | Michigan | 26165 | 1 | 0 |
8770 | 8770 | 2020-03-23 | Allegan | Michigan | 26005 | 1 | 0 |
8771 | 8771 | 2020-03-23 | Barry | Michigan | 26015 | 1 | 0 |
8772 | 8772 | 2020-03-23 | Bay | Michigan | 26017 | 1 | 0 |
8773 | 8773 | 2020-03-23 | Berrien | Michigan | 26021 | 5 | 0 |
8774 | 8774 | 2020-03-23 | Calhoun | Michigan | 26025 | 3 | 0 |
8775 | 8775 | 2020-03-23 | Charlevoix | Michigan | 26029 | 2 | 0 |
8776 | 8776 | 2020-03-23 | Chippewa | Michigan | 26033 | 1 | 0 |
8777 | 8777 | 2020-03-23 | Clare | Michigan | 26035 | 1 | 0 |
8778 | 8778 | 2020-03-23 | Clinton | Michigan | 26037 | 2 | 0 |
8779 | 8779 | 2020-03-23 | Eaton | Michigan | 26045 | 2 | 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);