ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-07-17" 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 |
---|---|---|---|---|---|---|---|
1525492 | 1525492 | 2021-07-17 | Alcona | Michigan | 26001 | 741 | 33 |
1525493 | 1525493 | 2021-07-17 | Alger | Michigan | 26003 | 670 | 7 |
1525494 | 1525494 | 2021-07-17 | Allegan | Michigan | 26005 | 11234 | 162 |
1525495 | 1525495 | 2021-07-17 | Alpena | Michigan | 26007 | 2275 | 64 |
1525496 | 1525496 | 2021-07-17 | Antrim | Michigan | 26009 | 1640 | 30 |
1525497 | 1525497 | 2021-07-17 | Arenac | Michigan | 26011 | 1219 | 29 |
1525498 | 1525498 | 2021-07-17 | Baraga | Michigan | 26013 | 994 | 40 |
1525499 | 1525499 | 2021-07-17 | Barry | Michigan | 26015 | 5977 | 70 |
1525500 | 1525500 | 2021-07-17 | Bay | Michigan | 26017 | 11287 | 354 |
1525501 | 1525501 | 2021-07-17 | Benzie | Michigan | 26019 | 1285 | 36 |
1525502 | 1525502 | 2021-07-17 | Berrien | Michigan | 26021 | 15654 | 297 |
1525503 | 1525503 | 2021-07-17 | Branch | Michigan | 26023 | 5798 | 121 |
1525504 | 1525504 | 2021-07-17 | Calhoun | Michigan | 26025 | 14641 | 321 |
1525505 | 1525505 | 2021-07-17 | Cass | Michigan | 26027 | 5516 | 78 |
1525506 | 1525506 | 2021-07-17 | Charlevoix | Michigan | 26029 | 1688 | 22 |
1525507 | 1525507 | 2021-07-17 | Cheboygan | Michigan | 26031 | 1934 | 47 |
1525508 | 1525508 | 2021-07-17 | Chippewa | Michigan | 26033 | 5657 | 50 |
1525509 | 1525509 | 2021-07-17 | Clare | Michigan | 26035 | 2487 | 85 |
1525510 | 1525510 | 2021-07-17 | Clinton | Michigan | 26037 | 7673 | 95 |
1525511 | 1525511 | 2021-07-17 | Crawford | Michigan | 26039 | 996 | 14 |
1525512 | 1525512 | 2021-07-17 | Delta | Michigan | 26041 | 4061 | 95 |
1525513 | 1525513 | 2021-07-17 | Dickinson | Michigan | 26043 | 2760 | 74 |
1525514 | 1525514 | 2021-07-17 | Eaton | Michigan | 26045 | 10184 | 212 |
1525515 | 1525515 | 2021-07-17 | Emmet | Michigan | 26047 | 2391 | 43 |
1525516 | 1525516 | 2021-07-17 | Genesee | Michigan | 26049 | 41840 | 975 |
1525517 | 1525517 | 2021-07-17 | Gladwin | Michigan | 26051 | 2308 | 61 |
1525518 | 1525518 | 2021-07-17 | Gogebic | Michigan | 26053 | 1437 | 52 |
1525519 | 1525519 | 2021-07-17 | Grand Traverse | Michigan | 26055 | 6508 | 100 |
1525520 | 1525520 | 2021-07-17 | Gratiot | Michigan | 26057 | 6977 | 125 |
1525521 | 1525521 | 2021-07-17 | Hillsdale | Michigan | 26059 | 4410 | 94 |
1525522 | 1525522 | 2021-07-17 | Houghton | Michigan | 26061 | 3143 | 43 |
1525523 | 1525523 | 2021-07-17 | Huron | Michigan | 26063 | 4095 | 82 |
1525524 | 1525524 | 2021-07-17 | Ingham | Michigan | 26065 | 24976 | 393 |
1525525 | 1525525 | 2021-07-17 | Ionia | Michigan | 26067 | 9369 | 85 |
1525526 | 1525526 | 2021-07-17 | Iosco | Michigan | 26069 | 2009 | 75 |
1525527 | 1525527 | 2021-07-17 | Iron | Michigan | 26071 | 1064 | 53 |
1525528 | 1525528 | 2021-07-17 | Isabella | Michigan | 26073 | 6346 | 100 |
1525529 | 1525529 | 2021-07-17 | Jackson | Michigan | 26075 | 21121 | 324 |
1525530 | 1525530 | 2021-07-17 | Kalamazoo | Michigan | 26077 | 23276 | 403 |
1525531 | 1525531 | 2021-07-17 | Kalkaska | Michigan | 26079 | 1147 | 27 |
1525532 | 1525532 | 2021-07-17 | Kent | Michigan | 26081 | 74031 | 868 |
1525533 | 1525533 | 2021-07-17 | Keweenaw | Michigan | 26083 | 174 | 2 |
1525534 | 1525534 | 2021-07-17 | Lake | Michigan | 26085 | 640 | 16 |
1525535 | 1525535 | 2021-07-17 | Lapeer | Michigan | 26087 | 9787 | 215 |
1525536 | 1525536 | 2021-07-17 | Leelanau | Michigan | 26089 | 1249 | 20 |
1525537 | 1525537 | 2021-07-17 | Lenawee | Michigan | 26091 | 10875 | 178 |
1525538 | 1525538 | 2021-07-17 | Livingston | Michigan | 26093 | 16870 | 197 |
1525539 | 1525539 | 2021-07-17 | Luce | Michigan | 26095 | 1338 | 6 |
1525540 | 1525540 | 2021-07-17 | Mackinac | Michigan | 26097 | 717 | 3 |
1525541 | 1525541 | 2021-07-17 | Macomb | Michigan | 26099 | 100905 | 2505 |
1525542 | 1525542 | 2021-07-17 | Manistee | Michigan | 26101 | 1982 | 25 |
1525543 | 1525543 | 2021-07-17 | Marquette | Michigan | 26103 | 5943 | 65 |
1525544 | 1525544 | 2021-07-17 | Mason | Michigan | 26105 | 2144 | 37 |
1525545 | 1525545 | 2021-07-17 | Mecosta | Michigan | 26107 | 3223 | 37 |
1525546 | 1525546 | 2021-07-17 | Menominee | Michigan | 26109 | 2133 | 43 |
1525547 | 1525547 | 2021-07-17 | Midland | Michigan | 26111 | 7614 | 94 |
1525548 | 1525548 | 2021-07-17 | Missaukee | Michigan | 26113 | 1519 | 27 |
1525549 | 1525549 | 2021-07-17 | Monroe | Michigan | 26115 | 15486 | 266 |
1525550 | 1525550 | 2021-07-17 | Montcalm | Michigan | 26117 | 8211 | 120 |
1525551 | 1525551 | 2021-07-17 | Montmorency | Michigan | 26119 | 618 | 20 |
1525552 | 1525552 | 2021-07-17 | Muskegon | Michigan | 26121 | 18495 | 382 |
1525553 | 1525553 | 2021-07-17 | Newaygo | Michigan | 26123 | 4912 | 69 |
1525554 | 1525554 | 2021-07-17 | Oakland | Michigan | 26125 | 119220 | 2465 |
1525555 | 1525555 | 2021-07-17 | Oceana | Michigan | 26127 | 2779 | 60 |
1525556 | 1525556 | 2021-07-17 | Ogemaw | Michigan | 26129 | 1749 | 43 |
1525557 | 1525557 | 2021-07-17 | Ontonagon | Michigan | 26131 | 484 | 21 |
1525558 | 1525558 | 2021-07-17 | Osceola | Michigan | 26133 | 1970 | 31 |
1525559 | 1525559 | 2021-07-17 | Oscoda | Michigan | 26135 | 692 | 31 |
1525560 | 1525560 | 2021-07-17 | Otsego | Michigan | 26137 | 2370 | 41 |
1525561 | 1525561 | 2021-07-17 | Ottawa | Michigan | 26139 | 33024 | 442 |
1525562 | 1525562 | 2021-07-17 | Presque Isle | Michigan | 26141 | 1058 | 34 |
1525563 | 1525563 | 2021-07-17 | Roscommon | Michigan | 26143 | 1905 | 55 |
1525564 | 1525564 | 2021-07-17 | Saginaw | Michigan | 26145 | 22594 | 638 |
1525565 | 1525565 | 2021-07-17 | Sanilac | Michigan | 26151 | 4262 | 125 |
1525566 | 1525566 | 2021-07-17 | Schoolcraft | Michigan | 26153 | 439 | 5 |
1525567 | 1525567 | 2021-07-17 | Shiawassee | Michigan | 26155 | 6456 | 110 |
1525568 | 1525568 | 2021-07-17 | St. Clair | Michigan | 26147 | 18561 | 451 |
1525569 | 1525569 | 2021-07-17 | St. Joseph | Michigan | 26149 | 6276 | 101 |
1525570 | 1525570 | 2021-07-17 | Tuscola | Michigan | 26157 | 5684 | 174 |
1525571 | 1525571 | 2021-07-17 | Unknown | Michigan | 749 | 16 | |
1525572 | 1525572 | 2021-07-17 | Van Buren | Michigan | 26159 | 7167 | 133 |
1525573 | 1525573 | 2021-07-17 | Washtenaw | Michigan | 26161 | 27224 | 311 |
1525574 | 1525574 | 2021-07-17 | Wayne | Michigan | 26163 | 166784 | 5194 |
1525575 | 1525575 | 2021-07-17 | Wexford | Michigan | 26165 | 2906 | 48 |
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);