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)
Suggested facets: date (date)
fips 84
- 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
- 26055 783
- 26143 783
- 26033 782
- 26077 782
- 26121 782
- 26123 782
- 26059 781
- 26073 781
- 26079 781
- 26087 781
- 26101 781
- 26069 780
- 26091 780
- 26103 780
- 26151 780
- 26159 780
- 26053 779
- 26067 779
- 26107 779
- 26113 779
- 26127 779
- 26129 779
- 26155 779
- 26027 778
- 26039 778
- 26057 778
- 26063 778
- - 778
- 26133 777
- 26031 776
- 26009 775
- 26041 775
- 26061 775
- 26149 775
- 26011 774
- 26023 774
- 26135 774
- 26097 773
- 26043 772
- 26095 771
- 26141 768
- 26105 767
- 26153 766
- 26109 764
- 26007 763
- 26085 763
- 26119 761
- 26001 759
- 26013 758
- 26019 756
- 26071 711
- 26003 703
- 26083 703
- 26131 679
county 84
- 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
- Grand Traverse 783
- Roscommon 783
- Chippewa 782
- Kalamazoo 782
- Muskegon 782
- Newaygo 782
- Hillsdale 781
- Isabella 781
- Kalkaska 781
- Lapeer 781
- Manistee 781
- Iosco 780
- Lenawee 780
- Marquette 780
- Sanilac 780
- Van Buren 780
- Gogebic 779
- Ionia 779
- Mecosta 779
- Missaukee 779
- Oceana 779
- Ogemaw 779
- Shiawassee 779
- Cass 778
- Crawford 778
- Gratiot 778
- Huron 778
- Unknown 778
- Osceola 777
- Cheboygan 776
- Antrim 775
- Delta 775
- Houghton 775
- St. Joseph 775
- Arenac 774
- Branch 774
- Oscoda 774
- Mackinac 773
- Dickinson 772
- Luce 771
- Presque Isle 768
- Mason 767
- Schoolcraft 766
- Menominee 764
- Alpena 763
- Lake 763
- Montmorency 761
- Alcona 759
- Baraga 758
- Benzie 756
- Iron 711
- Alger 703
- Keweenaw 703
- Ontonagon 679
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 |
4051 | 4051 | 2020-03-18 | Wayne | Michigan | 26163 | 23 | 1 |
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 |
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);