ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-02-25" 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 |
---|---|---|---|---|---|---|---|
1064485 | 1064485 | 2021-02-25 | Alcona | Michigan | 26001 | 429 | 24 |
1064486 | 1064486 | 2021-02-25 | Alger | Michigan | 26003 | 582 | 5 |
1064487 | 1064487 | 2021-02-25 | Allegan | Michigan | 26005 | 7266 | 118 |
1064488 | 1064488 | 2021-02-25 | Alpena | Michigan | 26007 | 1482 | 47 |
1064489 | 1064489 | 2021-02-25 | Antrim | Michigan | 26009 | 931 | 20 |
1064490 | 1064490 | 2021-02-25 | Arenac | Michigan | 26011 | 752 | 24 |
1064491 | 1064491 | 2021-02-25 | Baraga | Michigan | 26013 | 776 | 33 |
1064492 | 1064492 | 2021-02-25 | Barry | Michigan | 26015 | 3742 | 44 |
1064493 | 1064493 | 2021-02-25 | Bay | Michigan | 26017 | 7407 | 287 |
1064494 | 1064494 | 2021-02-25 | Benzie | Michigan | 26019 | 912 | 31 |
1064495 | 1064495 | 2021-02-25 | Berrien | Michigan | 26021 | 11458 | 239 |
1064496 | 1064496 | 2021-02-25 | Branch | Michigan | 26023 | 4595 | 110 |
1064497 | 1064497 | 2021-02-25 | Calhoun | Michigan | 26025 | 9545 | 234 |
1064498 | 1064498 | 2021-02-25 | Cass | Michigan | 26027 | 3973 | 64 |
1064499 | 1064499 | 2021-02-25 | Charlevoix | Michigan | 26029 | 1042 | 13 |
1064500 | 1064500 | 2021-02-25 | Cheboygan | Michigan | 26031 | 970 | 35 |
1064501 | 1064501 | 2021-02-25 | Chippewa | Michigan | 26033 | 4826 | 43 |
1064502 | 1064502 | 2021-02-25 | Clare | Michigan | 26035 | 1605 | 69 |
1064503 | 1064503 | 2021-02-25 | Clinton | Michigan | 26037 | 5027 | 70 |
1064504 | 1064504 | 2021-02-25 | Crawford | Michigan | 26039 | 584 | 5 |
1064505 | 1064505 | 2021-02-25 | Delta | Michigan | 26041 | 3124 | 84 |
1064506 | 1064506 | 2021-02-25 | Dickinson | Michigan | 26043 | 2370 | 69 |
1064507 | 1064507 | 2021-02-25 | Eaton | Michigan | 26045 | 6245 | 152 |
1064508 | 1064508 | 2021-02-25 | Emmet | Michigan | 26047 | 1523 | 38 |
1064509 | 1064509 | 2021-02-25 | Genesee | Michigan | 26049 | 25410 | 752 |
1064510 | 1064510 | 2021-02-25 | Gladwin | Michigan | 26051 | 1479 | 43 |
1064511 | 1064511 | 2021-02-25 | Gogebic | Michigan | 26053 | 1267 | 47 |
1064512 | 1064512 | 2021-02-25 | Grand Traverse | Michigan | 26055 | 4249 | 69 |
1064513 | 1064513 | 2021-02-25 | Gratiot | Michigan | 26057 | 5646 | 105 |
1064514 | 1064514 | 2021-02-25 | Hillsdale | Michigan | 26059 | 3339 | 72 |
1064515 | 1064515 | 2021-02-25 | Houghton | Michigan | 26061 | 2643 | 40 |
1064516 | 1064516 | 2021-02-25 | Huron | Michigan | 26063 | 2135 | 59 |
1064517 | 1064517 | 2021-02-25 | Ingham | Michigan | 26065 | 16303 | 278 |
1064518 | 1064518 | 2021-02-25 | Ionia | Michigan | 26067 | 6988 | 74 |
1064519 | 1064519 | 2021-02-25 | Iosco | Michigan | 26069 | 1276 | 67 |
1064520 | 1064520 | 2021-02-25 | Iron | Michigan | 26071 | 927 | 49 |
1064521 | 1064521 | 2021-02-25 | Isabella | Michigan | 26073 | 4003 | 73 |
1064522 | 1064522 | 2021-02-25 | Jackson | Michigan | 26075 | 14122 | 250 |
1064523 | 1064523 | 2021-02-25 | Kalamazoo | Michigan | 26077 | 14900 | 320 |
1064524 | 1064524 | 2021-02-25 | Kalkaska | Michigan | 26079 | 601 | 15 |
1064525 | 1064525 | 2021-02-25 | Kent | Michigan | 26081 | 51588 | 706 |
1064526 | 1064526 | 2021-02-25 | Keweenaw | Michigan | 26083 | 144 | 2 |
1064527 | 1064527 | 2021-02-25 | Lake | Michigan | 26085 | 360 | 11 |
1064528 | 1064528 | 2021-02-25 | Lapeer | Michigan | 26087 | 5541 | 129 |
1064529 | 1064529 | 2021-02-25 | Leelanau | Michigan | 26089 | 868 | 14 |
1064530 | 1064530 | 2021-02-25 | Lenawee | Michigan | 26091 | 7695 | 129 |
1064531 | 1064531 | 2021-02-25 | Livingston | Michigan | 26093 | 10319 | 141 |
1064532 | 1064532 | 2021-02-25 | Luce | Michigan | 26095 | 1074 | 2 |
1064533 | 1064533 | 2021-02-25 | Mackinac | Michigan | 26097 | 441 | 3 |
1064534 | 1064534 | 2021-02-25 | Macomb | Michigan | 26099 | 59094 | 1965 |
1064535 | 1064535 | 2021-02-25 | Manistee | Michigan | 26101 | 1519 | 23 |
1064536 | 1064536 | 2021-02-25 | Marquette | Michigan | 26103 | 4799 | 56 |
1064537 | 1064537 | 2021-02-25 | Mason | Michigan | 26105 | 1236 | 26 |
1064538 | 1064538 | 2021-02-25 | Mecosta | Michigan | 26107 | 2013 | 19 |
1064539 | 1064539 | 2021-02-25 | Menominee | Michigan | 26109 | 1877 | 37 |
1064540 | 1064540 | 2021-02-25 | Midland | Michigan | 26111 | 4956 | 64 |
1064541 | 1064541 | 2021-02-25 | Missaukee | Michigan | 26113 | 772 | 17 |
1064542 | 1064542 | 2021-02-25 | Monroe | Michigan | 26115 | 9705 | 202 |
1064543 | 1064543 | 2021-02-25 | Montcalm | Michigan | 26117 | 5605 | 92 |
1064544 | 1064544 | 2021-02-25 | Montmorency | Michigan | 26119 | 359 | 17 |
1064545 | 1064545 | 2021-02-25 | Muskegon | Michigan | 26121 | 12680 | 315 |
1064546 | 1064546 | 2021-02-25 | Newaygo | Michigan | 26123 | 2826 | 51 |
1064547 | 1064547 | 2021-02-25 | Oakland | Michigan | 26125 | 74481 | 1989 |
1064548 | 1064548 | 2021-02-25 | Oceana | Michigan | 26127 | 1871 | 50 |
1064549 | 1064549 | 2021-02-25 | Ogemaw | Michigan | 26129 | 1111 | 34 |
1064550 | 1064550 | 2021-02-25 | Ontonagon | Michigan | 26131 | 411 | 20 |
1064551 | 1064551 | 2021-02-25 | Osceola | Michigan | 26133 | 1050 | 23 |
1064552 | 1064552 | 2021-02-25 | Oscoda | Michigan | 26135 | 399 | 19 |
1064553 | 1064553 | 2021-02-25 | Otsego | Michigan | 26137 | 1166 | 25 |
1064554 | 1064554 | 2021-02-25 | Ottawa | Michigan | 26139 | 22280 | 350 |
1064555 | 1064555 | 2021-02-25 | Presque Isle | Michigan | 26141 | 659 | 28 |
1064556 | 1064556 | 2021-02-25 | Roscommon | Michigan | 26143 | 1155 | 32 |
1064557 | 1064557 | 2021-02-25 | Saginaw | Michigan | 26145 | 15903 | 517 |
1064558 | 1064558 | 2021-02-25 | Sanilac | Michigan | 26151 | 2046 | 77 |
1064559 | 1064559 | 2021-02-25 | Schoolcraft | Michigan | 26153 | 257 | 5 |
1064560 | 1064560 | 2021-02-25 | Shiawassee | Michigan | 26155 | 3785 | 78 |
1064561 | 1064561 | 2021-02-25 | St. Clair | Michigan | 26147 | 8647 | 256 |
1064562 | 1064562 | 2021-02-25 | St. Joseph | Michigan | 26149 | 4641 | 84 |
1064563 | 1064563 | 2021-02-25 | Tuscola | Michigan | 26157 | 3176 | 137 |
1064564 | 1064564 | 2021-02-25 | Unknown | Michigan | 0 | 12 | |
1064565 | 1064565 | 2021-02-25 | Van Buren | Michigan | 26159 | 4959 | 95 |
1064566 | 1064566 | 2021-02-25 | Washtenaw | Michigan | 26161 | 19198 | 251 |
1064567 | 1064567 | 2021-02-25 | Wayne | Michigan | 26163 | 101370 | 4134 |
1064568 | 1064568 | 2021-02-25 | Wexford | Michigan | 26165 | 1435 | 20 |
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);