ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-01-24" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
960625 | 960625 | 2021-01-24 | Alcona | Michigan | 26001 | 391 | 22 |
960626 | 960626 | 2021-01-24 | Alger | Michigan | 26003 | 549 | 3 |
960627 | 960627 | 2021-01-24 | Allegan | Michigan | 26005 | 6734 | 98 |
960628 | 960628 | 2021-01-24 | Alpena | Michigan | 26007 | 1400 | 43 |
960629 | 960629 | 2021-01-24 | Antrim | Michigan | 26009 | 814 | 17 |
960630 | 960630 | 2021-01-24 | Arenac | Michigan | 26011 | 694 | 23 |
960631 | 960631 | 2021-01-24 | Baraga | Michigan | 26013 | 743 | 31 |
960632 | 960632 | 2021-01-24 | Barry | Michigan | 26015 | 3433 | 40 |
960633 | 960633 | 2021-01-24 | Bay | Michigan | 26017 | 6984 | 253 |
960634 | 960634 | 2021-01-24 | Benzie | Michigan | 26019 | 827 | 29 |
960635 | 960635 | 2021-01-24 | Berrien | Michigan | 26021 | 10603 | 222 |
960636 | 960636 | 2021-01-24 | Branch | Michigan | 26023 | 4384 | 103 |
960637 | 960637 | 2021-01-24 | Calhoun | Michigan | 26025 | 8669 | 213 |
960638 | 960638 | 2021-01-24 | Cass | Michigan | 26027 | 3631 | 57 |
960639 | 960639 | 2021-01-24 | Charlevoix | Michigan | 26029 | 955 | 12 |
960640 | 960640 | 2021-01-24 | Cheboygan | Michigan | 26031 | 845 | 34 |
960641 | 960641 | 2021-01-24 | Chippewa | Michigan | 26033 | 4550 | 35 |
960642 | 960642 | 2021-01-24 | Clare | Michigan | 26035 | 1444 | 65 |
960643 | 960643 | 2021-01-24 | Clinton | Michigan | 26037 | 4607 | 59 |
960644 | 960644 | 2021-01-24 | Crawford | Michigan | 26039 | 533 | 5 |
960645 | 960645 | 2021-01-24 | Delta | Michigan | 26041 | 3055 | 80 |
960646 | 960646 | 2021-01-24 | Dickinson | Michigan | 26043 | 2310 | 70 |
960647 | 960647 | 2021-01-24 | Eaton | Michigan | 26045 | 5614 | 129 |
960648 | 960648 | 2021-01-24 | Emmet | Michigan | 26047 | 1358 | 34 |
960649 | 960649 | 2021-01-24 | Genesee | Michigan | 26049 | 23981 | 704 |
960650 | 960650 | 2021-01-24 | Gladwin | Michigan | 26051 | 1382 | 41 |
960651 | 960651 | 2021-01-24 | Gogebic | Michigan | 26053 | 1123 | 42 |
960652 | 960652 | 2021-01-24 | Grand Traverse | Michigan | 26055 | 3824 | 56 |
960653 | 960653 | 2021-01-24 | Gratiot | Michigan | 26057 | 5530 | 98 |
960654 | 960654 | 2021-01-24 | Hillsdale | Michigan | 26059 | 3056 | 68 |
960655 | 960655 | 2021-01-24 | Houghton | Michigan | 26061 | 2407 | 36 |
960656 | 960656 | 2021-01-24 | Huron | Michigan | 26063 | 1928 | 54 |
960657 | 960657 | 2021-01-24 | Ingham | Michigan | 26065 | 14534 | 249 |
960658 | 960658 | 2021-01-24 | Ionia | Michigan | 26067 | 6021 | 63 |
960659 | 960659 | 2021-01-24 | Iosco | Michigan | 26069 | 1222 | 63 |
960660 | 960660 | 2021-01-24 | Iron | Michigan | 26071 | 903 | 41 |
960661 | 960661 | 2021-01-24 | Isabella | Michigan | 26073 | 3801 | 66 |
960662 | 960662 | 2021-01-24 | Jackson | Michigan | 26075 | 13105 | 228 |
960663 | 960663 | 2021-01-24 | Kalamazoo | Michigan | 26077 | 13888 | 302 |
960664 | 960664 | 2021-01-24 | Kalkaska | Michigan | 26079 | 538 | 14 |
960665 | 960665 | 2021-01-24 | Kent | Michigan | 26081 | 48326 | 636 |
960666 | 960666 | 2021-01-24 | Keweenaw | Michigan | 26083 | 125 | 2 |
960667 | 960667 | 2021-01-24 | Lake | Michigan | 26085 | 340 | 11 |
960668 | 960668 | 2021-01-24 | Lapeer | Michigan | 26087 | 4984 | 121 |
960669 | 960669 | 2021-01-24 | Leelanau | Michigan | 26089 | 799 | 10 |
960670 | 960670 | 2021-01-24 | Lenawee | Michigan | 26091 | 6899 | 91 |
960671 | 960671 | 2021-01-24 | Livingston | Michigan | 26093 | 9333 | 104 |
960672 | 960672 | 2021-01-24 | Luce | Michigan | 26095 | 1058 | 1 |
960673 | 960673 | 2021-01-24 | Mackinac | Michigan | 26097 | 414 | 3 |
960674 | 960674 | 2021-01-24 | Macomb | Michigan | 26099 | 55141 | 1822 |
960675 | 960675 | 2021-01-24 | Manistee | Michigan | 26101 | 953 | 20 |
960676 | 960676 | 2021-01-24 | Marquette | Michigan | 26103 | 4696 | 54 |
960677 | 960677 | 2021-01-24 | Mason | Michigan | 26105 | 1144 | 24 |
960678 | 960678 | 2021-01-24 | Mecosta | Michigan | 26107 | 1822 | 17 |
960679 | 960679 | 2021-01-24 | Menominee | Michigan | 26109 | 1828 | 36 |
960680 | 960680 | 2021-01-24 | Midland | Michigan | 26111 | 4608 | 55 |
960681 | 960681 | 2021-01-24 | Missaukee | Michigan | 26113 | 649 | 15 |
960682 | 960682 | 2021-01-24 | Monroe | Michigan | 26115 | 8909 | 176 |
960683 | 960683 | 2021-01-24 | Montcalm | Michigan | 26117 | 5417 | 86 |
960684 | 960684 | 2021-01-24 | Montmorency | Michigan | 26119 | 344 | 16 |
960685 | 960685 | 2021-01-24 | Muskegon | Michigan | 26121 | 12251 | 301 |
960686 | 960686 | 2021-01-24 | Newaygo | Michigan | 26123 | 2561 | 41 |
960687 | 960687 | 2021-01-24 | Oakland | Michigan | 26125 | 68958 | 1866 |
960688 | 960688 | 2021-01-24 | Oceana | Michigan | 26127 | 1777 | 45 |
960689 | 960689 | 2021-01-24 | Ogemaw | Michigan | 26129 | 1031 | 31 |
960690 | 960690 | 2021-01-24 | Ontonagon | Michigan | 26131 | 343 | 18 |
960691 | 960691 | 2021-01-24 | Osceola | Michigan | 26133 | 969 | 21 |
960692 | 960692 | 2021-01-24 | Oscoda | Michigan | 26135 | 351 | 19 |
960693 | 960693 | 2021-01-24 | Otsego | Michigan | 26137 | 1089 | 25 |
960694 | 960694 | 2021-01-24 | Ottawa | Michigan | 26139 | 20776 | 324 |
960695 | 960695 | 2021-01-24 | Presque Isle | Michigan | 26141 | 605 | 23 |
960696 | 960696 | 2021-01-24 | Roscommon | Michigan | 26143 | 1069 | 30 |
960697 | 960697 | 2021-01-24 | Saginaw | Michigan | 26145 | 14911 | 468 |
960698 | 960698 | 2021-01-24 | Sanilac | Michigan | 26151 | 1806 | 71 |
960699 | 960699 | 2021-01-24 | Schoolcraft | Michigan | 26153 | 249 | 5 |
960700 | 960700 | 2021-01-24 | Shiawassee | Michigan | 26155 | 3461 | 68 |
960701 | 960701 | 2021-01-24 | St. Clair | Michigan | 26147 | 8095 | 224 |
960702 | 960702 | 2021-01-24 | St. Joseph | Michigan | 26149 | 4271 | 73 |
960703 | 960703 | 2021-01-24 | Tuscola | Michigan | 26157 | 2993 | 124 |
960704 | 960704 | 2021-01-24 | Unknown | Michigan | 0 | 19 | |
960705 | 960705 | 2021-01-24 | Van Buren | Michigan | 26159 | 4623 | 92 |
960706 | 960706 | 2021-01-24 | Washtenaw | Michigan | 26161 | 16402 | 231 |
960707 | 960707 | 2021-01-24 | Wayne | Michigan | 26163 | 94716 | 3930 |
960708 | 960708 | 2021-01-24 | Wexford | Michigan | 26165 | 1234 | 19 |
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);