ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-11-03" 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 |
---|---|---|---|---|---|---|---|
694524 | 694524 | 2020-11-03 | Alcona | Michigan | 26001 | 59 | 3 |
694525 | 694525 | 2020-11-03 | Alger | Michigan | 26003 | 148 | 1 |
694526 | 694526 | 2020-11-03 | Allegan | Michigan | 26005 | 1644 | 7 |
694527 | 694527 | 2020-11-03 | Alpena | Michigan | 26007 | 192 | 14 |
694528 | 694528 | 2020-11-03 | Antrim | Michigan | 26009 | 157 | 0 |
694529 | 694529 | 2020-11-03 | Arenac | Michigan | 26011 | 121 | 3 |
694530 | 694530 | 2020-11-03 | Baraga | Michigan | 26013 | 146 | 4 |
694531 | 694531 | 2020-11-03 | Barry | Michigan | 26015 | 908 | 6 |
694532 | 694532 | 2020-11-03 | Bay | Michigan | 26017 | 1762 | 66 |
694533 | 694533 | 2020-11-03 | Benzie | Michigan | 26019 | 161 | 2 |
694534 | 694534 | 2020-11-03 | Berrien | Michigan | 26021 | 3238 | 89 |
694535 | 694535 | 2020-11-03 | Branch | Michigan | 26023 | 1861 | 35 |
694536 | 694536 | 2020-11-03 | Calhoun | Michigan | 26025 | 3521 | 72 |
694537 | 694537 | 2020-11-03 | Cass | Michigan | 26027 | 1178 | 24 |
694538 | 694538 | 2020-11-03 | Charlevoix | Michigan | 26029 | 255 | 4 |
694539 | 694539 | 2020-11-03 | Cheboygan | Michigan | 26031 | 212 | 3 |
694540 | 694540 | 2020-11-03 | Chippewa | Michigan | 26033 | 236 | 0 |
694541 | 694541 | 2020-11-03 | Clare | Michigan | 26035 | 346 | 14 |
694542 | 694542 | 2020-11-03 | Clinton | Michigan | 26037 | 1380 | 16 |
694543 | 694543 | 2020-11-03 | Crawford | Michigan | 26039 | 169 | 5 |
694544 | 694544 | 2020-11-03 | Delta | Michigan | 26041 | 1456 | 40 |
694545 | 694545 | 2020-11-03 | Dickinson | Michigan | 26043 | 833 | 21 |
694546 | 694546 | 2020-11-03 | Eaton | Michigan | 26045 | 1390 | 12 |
694547 | 694547 | 2020-11-03 | Emmet | Michigan | 26047 | 422 | 5 |
694548 | 694548 | 2020-11-03 | Genesee | Michigan | 26049 | 7712 | 347 |
694549 | 694549 | 2020-11-03 | Gladwin | Michigan | 26051 | 260 | 3 |
694550 | 694550 | 2020-11-03 | Gogebic | Michigan | 26053 | 488 | 14 |
694551 | 694551 | 2020-11-03 | Grand Traverse | Michigan | 26055 | 926 | 13 |
694552 | 694552 | 2020-11-03 | Gratiot | Michigan | 26057 | 667 | 17 |
694553 | 694553 | 2020-11-03 | Hillsdale | Michigan | 26059 | 633 | 29 |
694554 | 694554 | 2020-11-03 | Houghton | Michigan | 26061 | 1029 | 9 |
694555 | 694555 | 2020-11-03 | Huron | Michigan | 26063 | 321 | 7 |
694556 | 694556 | 2020-11-03 | Ingham | Michigan | 26065 | 5079 | 70 |
694557 | 694557 | 2020-11-03 | Ionia | Michigan | 26067 | 1651 | 9 |
694558 | 694558 | 2020-11-03 | Iosco | Michigan | 26069 | 338 | 17 |
694559 | 694559 | 2020-11-03 | Iron | Michigan | 26071 | 495 | 27 |
694560 | 694560 | 2020-11-03 | Isabella | Michigan | 26073 | 1203 | 15 |
694561 | 694561 | 2020-11-03 | Jackson | Michigan | 26075 | 3860 | 92 |
694562 | 694562 | 2020-11-03 | Kalamazoo | Michigan | 26077 | 5501 | 118 |
694563 | 694563 | 2020-11-03 | Kalkaska | Michigan | 26079 | 162 | 4 |
694564 | 694564 | 2020-11-03 | Kent | Michigan | 26081 | 17042 | 193 |
694565 | 694565 | 2020-11-03 | Keweenaw | Michigan | 26083 | 25 | 0 |
694566 | 694566 | 2020-11-03 | Lake | Michigan | 26085 | 80 | 1 |
694567 | 694567 | 2020-11-03 | Lapeer | Michigan | 26087 | 1361 | 45 |
694568 | 694568 | 2020-11-03 | Leelanau | Michigan | 26089 | 172 | 2 |
694569 | 694569 | 2020-11-03 | Lenawee | Michigan | 26091 | 1993 | 24 |
694570 | 694570 | 2020-11-03 | Livingston | Michigan | 26093 | 2533 | 36 |
694571 | 694571 | 2020-11-03 | Luce | Michigan | 26095 | 504 | 0 |
694572 | 694572 | 2020-11-03 | Mackinac | Michigan | 26097 | 179 | 0 |
694573 | 694573 | 2020-11-03 | Macomb | Michigan | 26099 | 20883 | 1107 |
694574 | 694574 | 2020-11-03 | Manistee | Michigan | 26101 | 186 | 3 |
694575 | 694575 | 2020-11-03 | Marquette | Michigan | 26103 | 2199 | 18 |
694576 | 694576 | 2020-11-03 | Mason | Michigan | 26105 | 322 | 3 |
694577 | 694577 | 2020-11-03 | Mecosta | Michigan | 26107 | 686 | 4 |
694578 | 694578 | 2020-11-03 | Menominee | Michigan | 26109 | 821 | 7 |
694579 | 694579 | 2020-11-03 | Midland | Michigan | 26111 | 1311 | 14 |
694580 | 694580 | 2020-11-03 | Missaukee | Michigan | 26113 | 122 | 1 |
694581 | 694581 | 2020-11-03 | Monroe | Michigan | 26115 | 2341 | 44 |
694582 | 694582 | 2020-11-03 | Montcalm | Michigan | 26117 | 853 | 13 |
694583 | 694583 | 2020-11-03 | Montmorency | Michigan | 26119 | 39 | 0 |
694584 | 694584 | 2020-11-03 | Muskegon | Michigan | 26121 | 3891 | 91 |
694585 | 694585 | 2020-11-03 | Newaygo | Michigan | 26123 | 783 | 3 |
694586 | 694586 | 2020-11-03 | Oakland | Michigan | 26125 | 27839 | 1244 |
694587 | 694587 | 2020-11-03 | Oceana | Michigan | 26127 | 709 | 6 |
694588 | 694588 | 2020-11-03 | Ogemaw | Michigan | 26129 | 153 | 5 |
694589 | 694589 | 2020-11-03 | Ontonagon | Michigan | 26131 | 145 | 1 |
694590 | 694590 | 2020-11-03 | Osceola | Michigan | 26133 | 227 | 1 |
694591 | 694591 | 2020-11-03 | Oscoda | Michigan | 26135 | 64 | 2 |
694592 | 694592 | 2020-11-03 | Otsego | Michigan | 26137 | 331 | 12 |
694593 | 694593 | 2020-11-03 | Ottawa | Michigan | 26139 | 6282 | 82 |
694594 | 694594 | 2020-11-03 | Presque Isle | Michigan | 26141 | 90 | 1 |
694595 | 694595 | 2020-11-03 | Roscommon | Michigan | 26143 | 235 | 6 |
694596 | 694596 | 2020-11-03 | Saginaw | Michigan | 26145 | 4489 | 159 |
694597 | 694597 | 2020-11-03 | Sanilac | Michigan | 26151 | 265 | 7 |
694598 | 694598 | 2020-11-03 | Schoolcraft | Michigan | 26153 | 109 | 1 |
694599 | 694599 | 2020-11-03 | Shiawassee | Michigan | 26155 | 868 | 34 |
694600 | 694600 | 2020-11-03 | St. Clair | Michigan | 26147 | 1853 | 66 |
694601 | 694601 | 2020-11-03 | St. Joseph | Michigan | 26149 | 1478 | 25 |
694602 | 694602 | 2020-11-03 | Tuscola | Michigan | 26157 | 783 | 37 |
694603 | 694603 | 2020-11-03 | Unknown | Michigan | 0 | 3 | |
694604 | 694604 | 2020-11-03 | Van Buren | Michigan | 26159 | 1338 | 20 |
694605 | 694605 | 2020-11-03 | Washtenaw | Michigan | 26161 | 6499 | 129 |
694606 | 694606 | 2020-11-03 | Wayne | Michigan | 26163 | 43375 | 3067 |
694607 | 694607 | 2020-11-03 | Wexford | Michigan | 26165 | 221 | 4 |
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);