ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where "date" is on date 2020-04-11 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
49517 | 49517 | 2020-04-11 | Allegan | Michigan | 26005 | 19 | 0 |
49518 | 49518 | 2020-04-11 | Alpena | Michigan | 26007 | 1 | 0 |
49519 | 49519 | 2020-04-11 | Antrim | Michigan | 26009 | 7 | 0 |
49520 | 49520 | 2020-04-11 | Arenac | Michigan | 26011 | 4 | 0 |
49521 | 49521 | 2020-04-11 | Barry | Michigan | 26015 | 8 | 0 |
49522 | 49522 | 2020-04-11 | Bay | Michigan | 26017 | 53 | 0 |
49523 | 49523 | 2020-04-11 | Berrien | Michigan | 26021 | 94 | 3 |
49524 | 49524 | 2020-04-11 | Branch | Michigan | 26023 | 26 | 2 |
49525 | 49525 | 2020-04-11 | Calhoun | Michigan | 26025 | 71 | 1 |
49526 | 49526 | 2020-04-11 | Cass | Michigan | 26027 | 12 | 1 |
49527 | 49527 | 2020-04-11 | Charlevoix | Michigan | 26029 | 11 | 0 |
49528 | 49528 | 2020-04-11 | Cheboygan | Michigan | 26031 | 11 | 1 |
49529 | 49529 | 2020-04-11 | Chippewa | Michigan | 26033 | 1 | 1 |
49530 | 49530 | 2020-04-11 | Clare | Michigan | 26035 | 4 | 1 |
49531 | 49531 | 2020-04-11 | Clinton | Michigan | 26037 | 90 | 3 |
49532 | 49532 | 2020-04-11 | Crawford | Michigan | 26039 | 8 | 1 |
49533 | 49533 | 2020-04-11 | Delta | Michigan | 26041 | 9 | 1 |
49534 | 49534 | 2020-04-11 | Dickinson | Michigan | 26043 | 3 | 2 |
49535 | 49535 | 2020-04-11 | Eaton | Michigan | 26045 | 71 | 4 |
49536 | 49536 | 2020-04-11 | Emmet | Michigan | 26047 | 21 | 2 |
49537 | 49537 | 2020-04-11 | Genesee | Michigan | 26049 | 919 | 62 |
49538 | 49538 | 2020-04-11 | Gladwin | Michigan | 26051 | 4 | 0 |
49539 | 49539 | 2020-04-11 | Gogebic | Michigan | 26053 | 4 | 1 |
49540 | 49540 | 2020-04-11 | Grand Traverse | Michigan | 26055 | 17 | 3 |
49541 | 49541 | 2020-04-11 | Gratiot | Michigan | 26057 | 7 | 0 |
49542 | 49542 | 2020-04-11 | Hillsdale | Michigan | 26059 | 75 | 6 |
49543 | 49543 | 2020-04-11 | Houghton | Michigan | 26061 | 1 | 0 |
49544 | 49544 | 2020-04-11 | Huron | Michigan | 26063 | 5 | 0 |
49545 | 49545 | 2020-04-11 | Ingham | Michigan | 26065 | 241 | 3 |
49546 | 49546 | 2020-04-11 | Ionia | Michigan | 26067 | 14 | 2 |
49547 | 49547 | 2020-04-11 | Iosco | Michigan | 26069 | 5 | 1 |
49548 | 49548 | 2020-04-11 | Isabella | Michigan | 26073 | 38 | 3 |
49549 | 49549 | 2020-04-11 | Jackson | Michigan | 26075 | 152 | 4 |
49550 | 49550 | 2020-04-11 | Kalamazoo | Michigan | 26077 | 79 | 7 |
49551 | 49551 | 2020-04-11 | Kalkaska | Michigan | 26079 | 13 | 2 |
49552 | 49552 | 2020-04-11 | Kent | Michigan | 26081 | 270 | 13 |
49553 | 49553 | 2020-04-11 | Lake | Michigan | 26085 | 1 | 0 |
49554 | 49554 | 2020-04-11 | Lapeer | Michigan | 26087 | 95 | 6 |
49555 | 49555 | 2020-04-11 | Leelanau | Michigan | 26089 | 4 | 0 |
49556 | 49556 | 2020-04-11 | Lenawee | Michigan | 26091 | 43 | 0 |
49557 | 49557 | 2020-04-11 | Livingston | Michigan | 26093 | 206 | 3 |
49558 | 49558 | 2020-04-11 | Luce | Michigan | 26095 | 1 | 0 |
49559 | 49559 | 2020-04-11 | Mackinac | Michigan | 26097 | 4 | 0 |
49560 | 49560 | 2020-04-11 | Macomb | Michigan | 26099 | 3164 | 209 |
49561 | 49561 | 2020-04-11 | Manistee | Michigan | 26101 | 9 | 0 |
49562 | 49562 | 2020-04-11 | Marquette | Michigan | 26103 | 21 | 2 |
49563 | 49563 | 2020-04-11 | Mason | Michigan | 26105 | 2 | 0 |
49564 | 49564 | 2020-04-11 | Mecosta | Michigan | 26107 | 11 | 1 |
49565 | 49565 | 2020-04-11 | Menominee | Michigan | 26109 | 1 | 0 |
49566 | 49566 | 2020-04-11 | Midland | Michigan | 26111 | 30 | 1 |
49567 | 49567 | 2020-04-11 | Missaukee | Michigan | 26113 | 1 | 1 |
49568 | 49568 | 2020-04-11 | Monroe | Michigan | 26115 | 183 | 7 |
49569 | 49569 | 2020-04-11 | Montcalm | Michigan | 26117 | 21 | 1 |
49570 | 49570 | 2020-04-11 | Muskegon | Michigan | 26121 | 57 | 4 |
49571 | 49571 | 2020-04-11 | Newaygo | Michigan | 26123 | 6 | 0 |
49572 | 49572 | 2020-04-11 | Oakland | Michigan | 26125 | 4802 | 316 |
49573 | 49573 | 2020-04-11 | Oceana | Michigan | 26127 | 3 | 1 |
49574 | 49574 | 2020-04-11 | Ogemaw | Michigan | 26129 | 4 | 0 |
49575 | 49575 | 2020-04-11 | Osceola | Michigan | 26133 | 4 | 0 |
49576 | 49576 | 2020-04-11 | Oscoda | Michigan | 26135 | 4 | 0 |
49577 | 49577 | 2020-04-11 | Otsego | Michigan | 26137 | 31 | 2 |
49578 | 49578 | 2020-04-11 | Ottawa | Michigan | 26139 | 64 | 2 |
49579 | 49579 | 2020-04-11 | Presque Isle | Michigan | 26141 | 2 | 0 |
49580 | 49580 | 2020-04-11 | Roscommon | Michigan | 26143 | 8 | 0 |
49581 | 49581 | 2020-04-11 | Saginaw | Michigan | 26145 | 254 | 9 |
49582 | 49582 | 2020-04-11 | Sanilac | Michigan | 26151 | 23 | 2 |
49583 | 49583 | 2020-04-11 | Schoolcraft | Michigan | 26153 | 2 | 0 |
49584 | 49584 | 2020-04-11 | Shiawassee | Michigan | 26155 | 37 | 1 |
49585 | 49585 | 2020-04-11 | St. Clair | Michigan | 26147 | 190 | 4 |
49586 | 49586 | 2020-04-11 | St. Joseph | Michigan | 26149 | 20 | 0 |
49587 | 49587 | 2020-04-11 | Tuscola | Michigan | 26157 | 41 | 6 |
49588 | 49588 | 2020-04-11 | Unknown | Michigan | 474 | 15 | |
49589 | 49589 | 2020-04-11 | Van Buren | Michigan | 26159 | 21 | 1 |
49590 | 49590 | 2020-04-11 | Washtenaw | Michigan | 26161 | 685 | 18 |
49591 | 49591 | 2020-04-11 | Wayne | Michigan | 26163 | 10951 | 652 |
49592 | 49592 | 2020-04-11 | Wexford | Michigan | 26165 | 7 | 1 |
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);