ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where "date" is on date 2022-03-26 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2344554 | 2344554 | 2022-03-26 | Alcona | Michigan | 26001 | 1727 | 71 |
2344555 | 2344555 | 2022-03-26 | Alger | Michigan | 26003 | 1864 | 13 |
2344556 | 2344556 | 2022-03-26 | Allegan | Michigan | 26005 | 27008 | 342 |
2344557 | 2344557 | 2022-03-26 | Alpena | Michigan | 26007 | 5584 | 135 |
2344558 | 2344558 | 2022-03-26 | Antrim | Michigan | 26009 | 4303 | 64 |
2344559 | 2344559 | 2022-03-26 | Arenac | Michigan | 26011 | 3195 | 67 |
2344560 | 2344560 | 2022-03-26 | Baraga | Michigan | 26013 | 2204 | 54 |
2344561 | 2344561 | 2022-03-26 | Barry | Michigan | 26015 | 14266 | 166 |
2344562 | 2344562 | 2022-03-26 | Bay | Michigan | 26017 | 26963 | 575 |
2344563 | 2344563 | 2022-03-26 | Benzie | Michigan | 26019 | 3420 | 65 |
2344564 | 2344564 | 2022-03-26 | Berrien | Michigan | 26021 | 34584 | 543 |
2344565 | 2344565 | 2022-03-26 | Branch | Michigan | 26023 | 12136 | 205 |
2344566 | 2344566 | 2022-03-26 | Calhoun | Michigan | 26025 | 34009 | 569 |
2344567 | 2344567 | 2022-03-26 | Cass | Michigan | 26027 | 11081 | 141 |
2344568 | 2344568 | 2022-03-26 | Charlevoix | Michigan | 26029 | 4901 | 60 |
2344569 | 2344569 | 2022-03-26 | Cheboygan | Michigan | 26031 | 4583 | 102 |
2344570 | 2344570 | 2022-03-26 | Chippewa | Michigan | 26033 | 11581 | 119 |
2344571 | 2344571 | 2022-03-26 | Clare | Michigan | 26035 | 6728 | 156 |
2344572 | 2344572 | 2022-03-26 | Clinton | Michigan | 26037 | 21139 | 207 |
2344573 | 2344573 | 2022-03-26 | Crawford | Michigan | 26039 | 2553 | 30 |
2344574 | 2344574 | 2022-03-26 | Delta | Michigan | 26041 | 9915 | 155 |
2344575 | 2344575 | 2022-03-26 | Dickinson | Michigan | 26043 | 7360 | 108 |
2344576 | 2344576 | 2022-03-26 | Eaton | Michigan | 26045 | 26689 | 393 |
2344577 | 2344577 | 2022-03-26 | Emmet | Michigan | 26047 | 6364 | 86 |
2344578 | 2344578 | 2022-03-26 | Genesee | Michigan | 26049 | 100916 | 1698 |
2344579 | 2344579 | 2022-03-26 | Gladwin | Michigan | 26051 | 5557 | 113 |
2344580 | 2344580 | 2022-03-26 | Gogebic | Michigan | 26053 | 3246 | 68 |
2344581 | 2344581 | 2022-03-26 | Grand Traverse | Michigan | 26055 | 17154 | 228 |
2344582 | 2344582 | 2022-03-26 | Gratiot | Michigan | 26057 | 13649 | 183 |
2344583 | 2344583 | 2022-03-26 | Hillsdale | Michigan | 26059 | 10314 | 204 |
2344584 | 2344584 | 2022-03-26 | Houghton | Michigan | 26061 | 7782 | 89 |
2344585 | 2344585 | 2022-03-26 | Huron | Michigan | 26063 | 7997 | 146 |
2344586 | 2344586 | 2022-03-26 | Ingham | Michigan | 26065 | 63718 | 753 |
2344587 | 2344587 | 2022-03-26 | Ionia | Michigan | 26067 | 19476 | 181 |
2344588 | 2344588 | 2022-03-26 | Iosco | Michigan | 26069 | 4798 | 139 |
2344589 | 2344589 | 2022-03-26 | Iron | Michigan | 26071 | 2643 | 87 |
2344590 | 2344590 | 2022-03-26 | Isabella | Michigan | 26073 | 15506 | 206 |
2344591 | 2344591 | 2022-03-26 | Jackson | Michigan | 26075 | 44485 | 579 |
2344592 | 2344592 | 2022-03-26 | Kalamazoo | Michigan | 26077 | 58867 | 666 |
2344593 | 2344593 | 2022-03-26 | Kalkaska | Michigan | 26079 | 3521 | 60 |
2344594 | 2344594 | 2022-03-26 | Kent | Michigan | 26081 | 166033 | 1505 |
2344595 | 2344595 | 2022-03-26 | Keweenaw | Michigan | 26083 | 510 | 13 |
2344596 | 2344596 | 2022-03-26 | Lake | Michigan | 26085 | 1838 | 37 |
2344597 | 2344597 | 2022-03-26 | Lapeer | Michigan | 26087 | 20757 | 425 |
2344598 | 2344598 | 2022-03-26 | Leelanau | Michigan | 26089 | 3567 | 52 |
2344599 | 2344599 | 2022-03-26 | Lenawee | Michigan | 26091 | 25873 | 322 |
2344600 | 2344600 | 2022-03-26 | Livingston | Michigan | 26093 | 45918 | 443 |
2344601 | 2344601 | 2022-03-26 | Luce | Michigan | 26095 | 2279 | 12 |
2344602 | 2344602 | 2022-03-26 | Mackinac | Michigan | 26097 | 2384 | 30 |
2344603 | 2344603 | 2022-03-26 | Macomb | Michigan | 26099 | 228541 | 3914 |
2344604 | 2344604 | 2022-03-26 | Manistee | Michigan | 26101 | 4451 | 88 |
2344605 | 2344605 | 2022-03-26 | Marquette | Michigan | 26103 | 15784 | 127 |
2344606 | 2344606 | 2022-03-26 | Mason | Michigan | 26105 | 6720 | 90 |
2344607 | 2344607 | 2022-03-26 | Mecosta | Michigan | 26107 | 8622 | 108 |
2344608 | 2344608 | 2022-03-26 | Menominee | Michigan | 26109 | 5614 | 69 |
2344609 | 2344609 | 2022-03-26 | Midland | Michigan | 26111 | 19003 | 223 |
2344610 | 2344610 | 2022-03-26 | Missaukee | Michigan | 26113 | 2902 | 59 |
2344611 | 2344611 | 2022-03-26 | Monroe | Michigan | 26115 | 37850 | 466 |
2344612 | 2344612 | 2022-03-26 | Montcalm | Michigan | 26117 | 17115 | 214 |
2344613 | 2344613 | 2022-03-26 | Montmorency | Michigan | 26119 | 1716 | 47 |
2344614 | 2344614 | 2022-03-26 | Muskegon | Michigan | 26121 | 41588 | 640 |
2344615 | 2344615 | 2022-03-26 | Newaygo | Michigan | 26123 | 11448 | 155 |
2344616 | 2344616 | 2022-03-26 | Oakland | Michigan | 26125 | 285014 | 3787 |
2344617 | 2344617 | 2022-03-26 | Oceana | Michigan | 26127 | 6313 | 89 |
2344618 | 2344618 | 2022-03-26 | Ogemaw | Michigan | 26129 | 4304 | 105 |
2344619 | 2344619 | 2022-03-26 | Ontonagon | Michigan | 26131 | 981 | 38 |
2344620 | 2344620 | 2022-03-26 | Osceola | Michigan | 26133 | 4980 | 80 |
2344621 | 2344621 | 2022-03-26 | Oscoda | Michigan | 26135 | 1431 | 54 |
2344622 | 2344622 | 2022-03-26 | Otsego | Michigan | 26137 | 5625 | 99 |
2344623 | 2344623 | 2022-03-26 | Ottawa | Michigan | 26139 | 74526 | 783 |
2344624 | 2344624 | 2022-03-26 | Presque Isle | Michigan | 26141 | 2063 | 57 |
2344625 | 2344625 | 2022-03-26 | Roscommon | Michigan | 26143 | 4607 | 113 |
2344626 | 2344626 | 2022-03-26 | Saginaw | Michigan | 26145 | 50254 | 940 |
2344627 | 2344627 | 2022-03-26 | Sanilac | Michigan | 26151 | 8658 | 189 |
2344628 | 2344628 | 2022-03-26 | Schoolcraft | Michigan | 26153 | 1748 | 17 |
2344629 | 2344629 | 2022-03-26 | Shiawassee | Michigan | 26155 | 17736 | 229 |
2344630 | 2344630 | 2022-03-26 | St. Clair | Michigan | 26147 | 40426 | 824 |
2344631 | 2344631 | 2022-03-26 | St. Joseph | Michigan | 26149 | 13641 | 205 |
2344632 | 2344632 | 2022-03-26 | Tuscola | Michigan | 26157 | 13197 | 275 |
2344633 | 2344633 | 2022-03-26 | Unknown | Michigan | 12050 | 37 | |
2344634 | 2344634 | 2022-03-26 | Van Buren | Michigan | 26159 | 16960 | 266 |
2344635 | 2344635 | 2022-03-26 | Washtenaw | Michigan | 26161 | 74854 | 512 |
2344636 | 2344636 | 2022-03-26 | Wayne | Michigan | 26163 | 397678 | 7862 |
2344637 | 2344637 | 2022-03-26 | Wexford | Michigan | 26165 | 7050 | 106 |
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);