ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-11-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 |
---|---|---|---|---|---|---|---|
762659 | 762659 | 2020-11-24 | Alcona | Michigan | 26001 | 147 | 3 |
762660 | 762660 | 2020-11-24 | Alger | Michigan | 26003 | 231 | 2 |
762661 | 762661 | 2020-11-24 | Allegan | Michigan | 26005 | 3612 | 26 |
762662 | 762662 | 2020-11-24 | Alpena | Michigan | 26007 | 520 | 16 |
762663 | 762663 | 2020-11-24 | Antrim | Michigan | 26009 | 357 | 5 |
762664 | 762664 | 2020-11-24 | Arenac | Michigan | 26011 | 366 | 11 |
762665 | 762665 | 2020-11-24 | Baraga | Michigan | 26013 | 415 | 6 |
762666 | 762666 | 2020-11-24 | Barry | Michigan | 26015 | 1841 | 12 |
762667 | 762667 | 2020-11-24 | Bay | Michigan | 26017 | 3935 | 88 |
762668 | 762668 | 2020-11-24 | Benzie | Michigan | 26019 | 335 | 5 |
762669 | 762669 | 2020-11-24 | Berrien | Michigan | 26021 | 6004 | 108 |
762670 | 762670 | 2020-11-24 | Branch | Michigan | 26023 | 2866 | 49 |
762671 | 762671 | 2020-11-24 | Calhoun | Michigan | 26025 | 5538 | 113 |
762672 | 762672 | 2020-11-24 | Cass | Michigan | 26027 | 2035 | 29 |
762673 | 762673 | 2020-11-24 | Charlevoix | Michigan | 26029 | 502 | 6 |
762674 | 762674 | 2020-11-24 | Cheboygan | Michigan | 26031 | 438 | 17 |
762675 | 762675 | 2020-11-24 | Chippewa | Michigan | 26033 | 748 | 4 |
762676 | 762676 | 2020-11-24 | Clare | Michigan | 26035 | 668 | 23 |
762677 | 762677 | 2020-11-24 | Clinton | Michigan | 26037 | 2513 | 20 |
762678 | 762678 | 2020-11-24 | Crawford | Michigan | 26039 | 302 | 5 |
762679 | 762679 | 2020-11-24 | Delta | Michigan | 26041 | 2336 | 58 |
762680 | 762680 | 2020-11-24 | Dickinson | Michigan | 26043 | 1590 | 31 |
762681 | 762681 | 2020-11-24 | Eaton | Michigan | 26045 | 2774 | 33 |
762682 | 762682 | 2020-11-24 | Emmet | Michigan | 26047 | 870 | 28 |
762683 | 762683 | 2020-11-24 | Genesee | Michigan | 26049 | 13378 | 407 |
762684 | 762684 | 2020-11-24 | Gladwin | Michigan | 26051 | 709 | 9 |
762685 | 762685 | 2020-11-24 | Gogebic | Michigan | 26053 | 739 | 22 |
762686 | 762686 | 2020-11-24 | Grand Traverse | Michigan | 26055 | 1743 | 19 |
762687 | 762687 | 2020-11-24 | Gratiot | Michigan | 26057 | 1428 | 29 |
762688 | 762688 | 2020-11-24 | Hillsdale | Michigan | 26059 | 1471 | 35 |
762689 | 762689 | 2020-11-24 | Houghton | Michigan | 26061 | 1448 | 12 |
762690 | 762690 | 2020-11-24 | Huron | Michigan | 26063 | 669 | 13 |
762691 | 762691 | 2020-11-24 | Ingham | Michigan | 26065 | 8159 | 101 |
762692 | 762692 | 2020-11-24 | Ionia | Michigan | 26067 | 2818 | 14 |
762693 | 762693 | 2020-11-24 | Iosco | Michigan | 26069 | 652 | 21 |
762694 | 762694 | 2020-11-24 | Iron | Michigan | 26071 | 692 | 33 |
762695 | 762695 | 2020-11-24 | Isabella | Michigan | 26073 | 2237 | 19 |
762696 | 762696 | 2020-11-24 | Jackson | Michigan | 26075 | 6162 | 111 |
762697 | 762697 | 2020-11-24 | Kalamazoo | Michigan | 26077 | 8677 | 159 |
762698 | 762698 | 2020-11-24 | Kalkaska | Michigan | 26079 | 318 | 5 |
762699 | 762699 | 2020-11-24 | Kent | Michigan | 26081 | 30084 | 312 |
762700 | 762700 | 2020-11-24 | Keweenaw | Michigan | 26083 | 65 | 1 |
762701 | 762701 | 2020-11-24 | Lake | Michigan | 26085 | 181 | 4 |
762702 | 762702 | 2020-11-24 | Lapeer | Michigan | 26087 | 2412 | 56 |
762703 | 762703 | 2020-11-24 | Leelanau | Michigan | 26089 | 342 | 3 |
762704 | 762704 | 2020-11-24 | Lenawee | Michigan | 26091 | 2977 | 26 |
762705 | 762705 | 2020-11-24 | Livingston | Michigan | 26093 | 4934 | 45 |
762706 | 762706 | 2020-11-24 | Luce | Michigan | 26095 | 577 | 0 |
762707 | 762707 | 2020-11-24 | Mackinac | Michigan | 26097 | 259 | 0 |
762708 | 762708 | 2020-11-24 | Macomb | Michigan | 26099 | 33790 | 1237 |
762709 | 762709 | 2020-11-24 | Manistee | Michigan | 26101 | 352 | 5 |
762710 | 762710 | 2020-11-24 | Marquette | Michigan | 26103 | 3529 | 27 |
762711 | 762711 | 2020-11-24 | Mason | Michigan | 26105 | 552 | 7 |
762712 | 762712 | 2020-11-24 | Mecosta | Michigan | 26107 | 1103 | 7 |
762713 | 762713 | 2020-11-24 | Menominee | Michigan | 26109 | 1220 | 13 |
762714 | 762714 | 2020-11-24 | Midland | Michigan | 26111 | 2734 | 26 |
762715 | 762715 | 2020-11-24 | Missaukee | Michigan | 26113 | 262 | 3 |
762716 | 762716 | 2020-11-24 | Monroe | Michigan | 26115 | 4740 | 66 |
762717 | 762717 | 2020-11-24 | Montcalm | Michigan | 26117 | 1682 | 22 |
762718 | 762718 | 2020-11-24 | Montmorency | Michigan | 26119 | 132 | 2 |
762719 | 762719 | 2020-11-24 | Muskegon | Michigan | 26121 | 7737 | 166 |
762720 | 762720 | 2020-11-24 | Newaygo | Michigan | 26123 | 1433 | 16 |
762721 | 762721 | 2020-11-24 | Oakland | Michigan | 26125 | 42349 | 1322 |
762722 | 762722 | 2020-11-24 | Oceana | Michigan | 26127 | 1110 | 16 |
762723 | 762723 | 2020-11-24 | Ogemaw | Michigan | 26129 | 433 | 11 |
762724 | 762724 | 2020-11-24 | Ontonagon | Michigan | 26131 | 270 | 12 |
762725 | 762725 | 2020-11-24 | Osceola | Michigan | 26133 | 463 | 3 |
762726 | 762726 | 2020-11-24 | Oscoda | Michigan | 26135 | 132 | 3 |
762727 | 762727 | 2020-11-24 | Otsego | Michigan | 26137 | 682 | 16 |
762728 | 762728 | 2020-11-24 | Ottawa | Michigan | 26139 | 12467 | 130 |
762729 | 762729 | 2020-11-24 | Presque Isle | Michigan | 26141 | 223 | 3 |
762730 | 762730 | 2020-11-24 | Roscommon | Michigan | 26143 | 536 | 9 |
762731 | 762731 | 2020-11-24 | Saginaw | Michigan | 26145 | 7834 | 221 |
762732 | 762732 | 2020-11-24 | Sanilac | Michigan | 26151 | 620 | 12 |
762733 | 762733 | 2020-11-24 | Schoolcraft | Michigan | 26153 | 166 | 2 |
762734 | 762734 | 2020-11-24 | Shiawassee | Michigan | 26155 | 1737 | 40 |
762735 | 762735 | 2020-11-24 | St. Clair | Michigan | 26147 | 3916 | 78 |
762736 | 762736 | 2020-11-24 | St. Joseph | Michigan | 26149 | 2376 | 31 |
762737 | 762737 | 2020-11-24 | Tuscola | Michigan | 26157 | 1521 | 50 |
762738 | 762738 | 2020-11-24 | Unknown | Michigan | 4666 | 8 | |
762739 | 762739 | 2020-11-24 | Van Buren | Michigan | 26159 | 2569 | 34 |
762740 | 762740 | 2020-11-24 | Washtenaw | Michigan | 26161 | 9659 | 140 |
762741 | 762741 | 2020-11-24 | Wayne | Michigan | 26163 | 59316 | 3189 |
762742 | 762742 | 2020-11-24 | Wexford | Michigan | 26165 | 541 | 13 |
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);