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 deaths
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 ▼ |
---|---|---|---|---|---|---|---|
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 |
1479 | 1479 | 2020-03-12 | Kent | Michigan | 26081 | 3 | 0 |
1480 | 1480 | 2020-03-12 | Montcalm | Michigan | 26117 | 1 | 0 |
1481 | 1481 | 2020-03-12 | Oakland | Michigan | 26125 | 3 | 0 |
1482 | 1482 | 2020-03-12 | St. Clair | Michigan | 26147 | 1 | 0 |
1483 | 1483 | 2020-03-12 | Washtenaw | Michigan | 26161 | 2 | 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 |
1760 | 1760 | 2020-03-13 | Kent | Michigan | 26081 | 3 | 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 |
1764 | 1764 | 2020-03-13 | Oakland | Michigan | 26125 | 6 | 0 |
1765 | 1765 | 2020-03-13 | St. Clair | Michigan | 26147 | 1 | 0 |
1766 | 1766 | 2020-03-13 | Washtenaw | Michigan | 26161 | 3 | 0 |
1767 | 1767 | 2020-03-13 | Wayne | Michigan | 26163 | 6 | 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 |
2103 | 2103 | 2020-03-14 | Kent | Michigan | 26081 | 3 | 0 |
2104 | 2104 | 2020-03-14 | Leelanau | Michigan | 26089 | 1 | 0 |
2105 | 2105 | 2020-03-14 | Macomb | Michigan | 26099 | 2 | 0 |
2106 | 2106 | 2020-03-14 | Monroe | Michigan | 26115 | 1 | 0 |
2107 | 2107 | 2020-03-14 | Montcalm | Michigan | 26117 | 1 | 0 |
2108 | 2108 | 2020-03-14 | Oakland | Michigan | 26125 | 9 | 0 |
2109 | 2109 | 2020-03-14 | St. Clair | Michigan | 26147 | 1 | 0 |
2110 | 2110 | 2020-03-14 | Washtenaw | Michigan | 26161 | 4 | 0 |
2111 | 2111 | 2020-03-14 | Wayne | Michigan | 26163 | 8 | 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 |
2506 | 2506 | 2020-03-15 | Kent | Michigan | 26081 | 5 | 0 |
2507 | 2507 | 2020-03-15 | Leelanau | Michigan | 26089 | 1 | 0 |
2508 | 2508 | 2020-03-15 | Macomb | Michigan | 26099 | 5 | 0 |
2509 | 2509 | 2020-03-15 | Monroe | Michigan | 26115 | 1 | 0 |
2510 | 2510 | 2020-03-15 | Montcalm | Michigan | 26117 | 1 | 0 |
2511 | 2511 | 2020-03-15 | Oakland | Michigan | 26125 | 14 | 0 |
2512 | 2512 | 2020-03-15 | Ottawa | Michigan | 26139 | 1 | 0 |
2513 | 2513 | 2020-03-15 | St. Clair | Michigan | 26147 | 2 | 0 |
2514 | 2514 | 2020-03-15 | Washtenaw | Michigan | 26161 | 7 | 0 |
2515 | 2515 | 2020-03-15 | Wayne | Michigan | 26163 | 13 | 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 |
2956 | 2956 | 2020-03-16 | Kent | Michigan | 26081 | 5 | 0 |
2957 | 2957 | 2020-03-16 | Leelanau | Michigan | 26089 | 1 | 0 |
2958 | 2958 | 2020-03-16 | Macomb | Michigan | 26099 | 6 | 0 |
2959 | 2959 | 2020-03-16 | Monroe | Michigan | 26115 | 1 | 0 |
2960 | 2960 | 2020-03-16 | Montcalm | Michigan | 26117 | 1 | 0 |
2961 | 2961 | 2020-03-16 | Oakland | Michigan | 26125 | 14 | 0 |
2962 | 2962 | 2020-03-16 | Ottawa | Michigan | 26139 | 1 | 0 |
2963 | 2963 | 2020-03-16 | St. Clair | Michigan | 26147 | 2 | 0 |
2964 | 2964 | 2020-03-16 | Washtenaw | Michigan | 26161 | 7 | 0 |
2965 | 2965 | 2020-03-16 | Wayne | Michigan | 26163 | 13 | 0 |
3454 | 3454 | 2020-03-17 | Bay | Michigan | 26017 | 1 | 0 |
3455 | 3455 | 2020-03-17 | Charlevoix | Michigan | 26029 | 1 | 0 |
3456 | 3456 | 2020-03-17 | Ingham | Michigan | 26065 | 2 | 0 |
3457 | 3457 | 2020-03-17 | Jackson | Michigan | 26075 | 1 | 0 |
3458 | 3458 | 2020-03-17 | Kent | Michigan | 26081 | 5 | 0 |
3459 | 3459 | 2020-03-17 | Leelanau | Michigan | 26089 | 1 | 0 |
3460 | 3460 | 2020-03-17 | Macomb | Michigan | 26099 | 8 | 0 |
3461 | 3461 | 2020-03-17 | Monroe | Michigan | 26115 | 1 | 0 |
3462 | 3462 | 2020-03-17 | Montcalm | Michigan | 26117 | 1 | 0 |
3463 | 3463 | 2020-03-17 | Oakland | Michigan | 26125 | 16 | 0 |
3464 | 3464 | 2020-03-17 | Otsego | Michigan | 26137 | 1 | 0 |
3465 | 3465 | 2020-03-17 | Ottawa | Michigan | 26139 | 1 | 0 |
3466 | 3466 | 2020-03-17 | St. Clair | Michigan | 26147 | 2 | 0 |
3467 | 3467 | 2020-03-17 | Washtenaw | Michigan | 26161 | 7 | 0 |
3468 | 3468 | 2020-03-17 | Wayne | Michigan | 26163 | 17 | 0 |
4037 | 4037 | 2020-03-18 | Bay | Michigan | 26017 | 1 | 0 |
4038 | 4038 | 2020-03-18 | Charlevoix | Michigan | 26029 | 1 | 0 |
4039 | 4039 | 2020-03-18 | Ingham | Michigan | 26065 | 2 | 0 |
4040 | 4040 | 2020-03-18 | Jackson | Michigan | 26075 | 1 | 0 |
4041 | 4041 | 2020-03-18 | Kent | Michigan | 26081 | 5 | 0 |
4042 | 4042 | 2020-03-18 | Leelanau | Michigan | 26089 | 1 | 0 |
4043 | 4043 | 2020-03-18 | Macomb | Michigan | 26099 | 10 | 0 |
4044 | 4044 | 2020-03-18 | Monroe | Michigan | 26115 | 1 | 0 |
4045 | 4045 | 2020-03-18 | Montcalm | Michigan | 26117 | 1 | 0 |
4046 | 4046 | 2020-03-18 | Oakland | Michigan | 26125 | 23 | 0 |
4047 | 4047 | 2020-03-18 | Otsego | Michigan | 26137 | 1 | 0 |
4048 | 4048 | 2020-03-18 | Ottawa | Michigan | 26139 | 1 | 0 |
4049 | 4049 | 2020-03-18 | St. Clair | Michigan | 26147 | 2 | 0 |
4050 | 4050 | 2020-03-18 | Washtenaw | Michigan | 26161 | 7 | 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 |
4745 | 4745 | 2020-03-19 | Eaton | Michigan | 26045 | 2 | 0 |
4746 | 4746 | 2020-03-19 | Genesee | Michigan | 26049 | 1 | 0 |
4747 | 4747 | 2020-03-19 | Ingham | Michigan | 26065 | 7 | 0 |
4748 | 4748 | 2020-03-19 | Jackson | Michigan | 26075 | 1 | 0 |
4749 | 4749 | 2020-03-19 | Kent | Michigan | 26081 | 12 | 0 |
4750 | 4750 | 2020-03-19 | Leelanau | Michigan | 26089 | 1 | 0 |
4751 | 4751 | 2020-03-19 | Livingston | Michigan | 26093 | 3 | 0 |
4752 | 4752 | 2020-03-19 | Macomb | Michigan | 26099 | 55 | 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);