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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 26125 675
- 26163 675
- 26065 673
- 26081 673
- 26117 673
- 26147 673
- 26161 673
- 26017 672
- 26029 672
- 26089 672
- 26099 672
- 26115 671
- 26139 670
- 26075 668
- 26137 668
- 26037 666
- 26045 666
- 26049 666
- 26093 666
- 26111 666
- 26005 664
- 26015 664
- 26021 664
- 26025 664
- 26035 664
- 26145 664
- 26157 664
- 26165 664
- 26047 663
- 26051 663
- …
county >30
- Oakland 675
- Wayne 675
- Ingham 673
- Kent 673
- Montcalm 673
- St. Clair 673
- Washtenaw 673
- Bay 672
- Charlevoix 672
- Leelanau 672
- Macomb 672
- Monroe 671
- Ottawa 670
- Jackson 668
- Otsego 668
- Clinton 666
- Eaton 666
- Genesee 666
- Livingston 666
- Midland 666
- Allegan 664
- Barry 664
- Berrien 664
- Calhoun 664
- Clare 664
- Saginaw 664
- Tuscola 664
- Wexford 664
- Emmet 663
- Gladwin 663
- …
state 1
- Michigan · 55,122 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110373 | 2110373 | 2022-01-13 | Alcona | Michigan | 26001 | 1500 | 60 |
2110374 | 2110374 | 2022-01-13 | Alger | Michigan | 26003 | 1414 | 11 |
2110375 | 2110375 | 2022-01-13 | Allegan | Michigan | 26005 | 22184 | 290 |
2110376 | 2110376 | 2022-01-13 | Alpena | Michigan | 26007 | 4751 | 119 |
2110377 | 2110377 | 2022-01-13 | Antrim | Michigan | 26009 | 3517 | 52 |
2110378 | 2110378 | 2022-01-13 | Arenac | Michigan | 26011 | 2557 | 56 |
2110379 | 2110379 | 2022-01-13 | Baraga | Michigan | 26013 | 1823 | 49 |
2110380 | 2110380 | 2022-01-13 | Barry | Michigan | 26015 | 11645 | 137 |
2110381 | 2110381 | 2022-01-13 | Bay | Michigan | 26017 | 21196 | 500 |
2110382 | 2110382 | 2022-01-13 | Benzie | Michigan | 26019 | 2658 | 56 |
2110383 | 2110383 | 2022-01-13 | Berrien | Michigan | 26021 | 28681 | 428 |
2110384 | 2110384 | 2022-01-13 | Branch | Michigan | 26023 | 9974 | 171 |
2110385 | 2110385 | 2022-01-13 | Calhoun | Michigan | 26025 | 27223 | 491 |
2110386 | 2110386 | 2022-01-13 | Cass | Michigan | 26027 | 9644 | 116 |
2110387 | 2110387 | 2022-01-13 | Charlevoix | Michigan | 26029 | 3977 | 54 |
2110388 | 2110388 | 2022-01-13 | Cheboygan | Michigan | 26031 | 3952 | 84 |
2110389 | 2110389 | 2022-01-13 | Chippewa | Michigan | 26033 | 9119 | 88 |
2110390 | 2110390 | 2022-01-13 | Clare | Michigan | 26035 | 5478 | 142 |
2110391 | 2110391 | 2022-01-13 | Clinton | Michigan | 26037 | 15953 | 170 |
2110392 | 2110392 | 2022-01-13 | Crawford | Michigan | 26039 | 2073 | 23 |
2110393 | 2110393 | 2022-01-13 | Delta | Michigan | 26041 | 7862 | 139 |
2110394 | 2110394 | 2022-01-13 | Dickinson | Michigan | 26043 | 5712 | 95 |
2110395 | 2110395 | 2022-01-13 | Eaton | Michigan | 26045 | 20884 | 333 |
2110396 | 2110396 | 2022-01-13 | Emmet | Michigan | 26047 | 5124 | 65 |
2110397 | 2110397 | 2022-01-13 | Genesee | Michigan | 26049 | 82639 | 1425 |
2110398 | 2110398 | 2022-01-13 | Gladwin | Michigan | 26051 | 4538 | 101 |
2110399 | 2110399 | 2022-01-13 | Gogebic | Michigan | 26053 | 2572 | 63 |
2110400 | 2110400 | 2022-01-13 | Grand Traverse | Michigan | 26055 | 13554 | 188 |
2110401 | 2110401 | 2022-01-13 | Gratiot | Michigan | 26057 | 11382 | 169 |
2110402 | 2110402 | 2022-01-13 | Hillsdale | Michigan | 26059 | 8619 | 176 |
2110403 | 2110403 | 2022-01-13 | Houghton | Michigan | 26061 | 6132 | 77 |
2110404 | 2110404 | 2022-01-13 | Huron | Michigan | 26063 | 6679 | 129 |
2110405 | 2110405 | 2022-01-13 | Ingham | Michigan | 26065 | 49440 | 612 |
2110406 | 2110406 | 2022-01-13 | Ionia | Michigan | 26067 | 16146 | 152 |
2110407 | 2110407 | 2022-01-13 | Iosco | Michigan | 26069 | 4090 | 119 |
2110408 | 2110408 | 2022-01-13 | Iron | Michigan | 26071 | 2041 | 74 |
2110409 | 2110409 | 2022-01-13 | Isabella | Michigan | 26073 | 12554 | 171 |
2110410 | 2110410 | 2022-01-13 | Jackson | Michigan | 26075 | 37305 | 489 |
2110411 | 2110411 | 2022-01-13 | Kalamazoo | Michigan | 26077 | 46870 | 569 |
2110412 | 2110412 | 2022-01-13 | Kalkaska | Michigan | 26079 | 2750 | 48 |
2110413 | 2110413 | 2022-01-13 | Kent | Michigan | 26081 | 138186 | 1326 |
2110414 | 2110414 | 2022-01-13 | Keweenaw | Michigan | 26083 | 409 | 11 |
2110415 | 2110415 | 2022-01-13 | Lake | Michigan | 26085 | 1477 | 32 |
2110416 | 2110416 | 2022-01-13 | Lapeer | Michigan | 26087 | 17555 | 363 |
2110417 | 2110417 | 2022-01-13 | Leelanau | Michigan | 26089 | 2834 | 42 |
2110418 | 2110418 | 2022-01-13 | Lenawee | Michigan | 26091 | 21216 | 272 |
2110419 | 2110419 | 2022-01-13 | Livingston | Michigan | 26093 | 37370 | 377 |
2110420 | 2110420 | 2022-01-13 | Luce | Michigan | 26095 | 1990 | 6 |
2110421 | 2110421 | 2022-01-13 | Mackinac | Michigan | 26097 | 1900 | 24 |
2110422 | 2110422 | 2022-01-13 | Macomb | Michigan | 26099 | 190201 | 3367 |
2110423 | 2110423 | 2022-01-13 | Manistee | Michigan | 26101 | 3516 | 65 |
2110424 | 2110424 | 2022-01-13 | Marquette | Michigan | 26103 | 11875 | 100 |
2110425 | 2110425 | 2022-01-13 | Mason | Michigan | 26105 | 5120 | 74 |
2110426 | 2110426 | 2022-01-13 | Mecosta | Michigan | 26107 | 6885 | 89 |
2110427 | 2110427 | 2022-01-13 | Menominee | Michigan | 26109 | 4550 | 64 |
2110428 | 2110428 | 2022-01-13 | Midland | Michigan | 26111 | 15049 | 193 |
2110429 | 2110429 | 2022-01-13 | Missaukee | Michigan | 26113 | 2348 | 54 |
2110430 | 2110430 | 2022-01-13 | Monroe | Michigan | 26115 | 31462 | 391 |
2110431 | 2110431 | 2022-01-13 | Montcalm | Michigan | 26117 | 14428 | 182 |
2110432 | 2110432 | 2022-01-13 | Montmorency | Michigan | 26119 | 1428 | 43 |
2110433 | 2110433 | 2022-01-13 | Muskegon | Michigan | 26121 | 34864 | 545 |
2110434 | 2110434 | 2022-01-13 | Newaygo | Michigan | 26123 | 9387 | 133 |
2110435 | 2110435 | 2022-01-13 | Oakland | Michigan | 26125 | 232417 | 3244 |
2110436 | 2110436 | 2022-01-13 | Oceana | Michigan | 26127 | 5191 | 84 |
2110437 | 2110437 | 2022-01-13 | Ogemaw | Michigan | 26129 | 3557 | 84 |
2110438 | 2110438 | 2022-01-13 | Ontonagon | Michigan | 26131 | 832 | 28 |
2110439 | 2110439 | 2022-01-13 | Osceola | Michigan | 26133 | 4113 | 66 |
2110440 | 2110440 | 2022-01-13 | Oscoda | Michigan | 26135 | 1227 | 51 |
2110441 | 2110441 | 2022-01-13 | Otsego | Michigan | 26137 | 4593 | 86 |
2110442 | 2110442 | 2022-01-13 | Ottawa | Michigan | 26139 | 61146 | 684 |
2110443 | 2110443 | 2022-01-13 | Presque Isle | Michigan | 26141 | 1826 | 52 |
2110444 | 2110444 | 2022-01-13 | Roscommon | Michigan | 26143 | 3861 | 107 |
2110445 | 2110445 | 2022-01-13 | Saginaw | Michigan | 26145 | 40757 | 833 |
2110446 | 2110446 | 2022-01-13 | Sanilac | Michigan | 26151 | 7309 | 168 |
2110447 | 2110447 | 2022-01-13 | Schoolcraft | Michigan | 26153 | 1365 | 9 |
2110448 | 2110448 | 2022-01-13 | Shiawassee | Michigan | 26155 | 14120 | 196 |
2110449 | 2110449 | 2022-01-13 | St. Clair | Michigan | 26147 | 34077 | 707 |
2110450 | 2110450 | 2022-01-13 | St. Joseph | Michigan | 26149 | 11489 | 171 |
2110451 | 2110451 | 2022-01-13 | Tuscola | Michigan | 26157 | 10762 | 247 |
2110452 | 2110452 | 2022-01-13 | Unknown | Michigan | 3276 | 25 | |
2110453 | 2110453 | 2022-01-13 | Van Buren | Michigan | 26159 | 14067 | 225 |
2110454 | 2110454 | 2022-01-13 | Washtenaw | Michigan | 26161 | 58416 | 442 |
2110455 | 2110455 | 2022-01-13 | Wayne | Michigan | 26163 | 325483 | 6734 |
2110456 | 2110456 | 2022-01-13 | Wexford | Michigan | 26165 | 5362 | 90 |
2107122 | 2107122 | 2022-01-12 | Alcona | Michigan | 26001 | 1500 | 60 |
2107123 | 2107123 | 2022-01-12 | Alger | Michigan | 26003 | 1414 | 11 |
2107124 | 2107124 | 2022-01-12 | Allegan | Michigan | 26005 | 22184 | 290 |
2107125 | 2107125 | 2022-01-12 | Alpena | Michigan | 26007 | 4751 | 119 |
2107126 | 2107126 | 2022-01-12 | Antrim | Michigan | 26009 | 3517 | 52 |
2107127 | 2107127 | 2022-01-12 | Arenac | Michigan | 26011 | 2557 | 56 |
2107128 | 2107128 | 2022-01-12 | Baraga | Michigan | 26013 | 1823 | 49 |
2107129 | 2107129 | 2022-01-12 | Barry | Michigan | 26015 | 11645 | 137 |
2107130 | 2107130 | 2022-01-12 | Bay | Michigan | 26017 | 21196 | 500 |
2107131 | 2107131 | 2022-01-12 | Benzie | Michigan | 26019 | 2658 | 56 |
2107132 | 2107132 | 2022-01-12 | Berrien | Michigan | 26021 | 28681 | 428 |
2107133 | 2107133 | 2022-01-12 | Branch | Michigan | 26023 | 9974 | 171 |
2107134 | 2107134 | 2022-01-12 | Calhoun | Michigan | 26025 | 27223 | 491 |
2107135 | 2107135 | 2022-01-12 | Cass | Michigan | 26027 | 9644 | 116 |
2107136 | 2107136 | 2022-01-12 | Charlevoix | Michigan | 26029 | 3977 | 54 |
2107137 | 2107137 | 2022-01-12 | Cheboygan | Michigan | 26031 | 3952 | 84 |
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);