ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-05-09" 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 |
---|---|---|---|---|---|---|---|
1301511 | 1301511 | 2021-05-09 | Alcona | Michigan | 26001 | 721 | 28 |
1301512 | 1301512 | 2021-05-09 | Alger | Michigan | 26003 | 658 | 6 |
1301513 | 1301513 | 2021-05-09 | Allegan | Michigan | 26005 | 10640 | 136 |
1301514 | 1301514 | 2021-05-09 | Alpena | Michigan | 26007 | 2157 | 59 |
1301515 | 1301515 | 2021-05-09 | Antrim | Michigan | 26009 | 1573 | 27 |
1301516 | 1301516 | 2021-05-09 | Arenac | Michigan | 26011 | 1141 | 29 |
1301517 | 1301517 | 2021-05-09 | Baraga | Michigan | 26013 | 908 | 37 |
1301518 | 1301518 | 2021-05-09 | Barry | Michigan | 26015 | 5683 | 64 |
1301519 | 1301519 | 2021-05-09 | Bay | Michigan | 26017 | 10861 | 330 |
1301520 | 1301520 | 2021-05-09 | Benzie | Michigan | 26019 | 1252 | 34 |
1301521 | 1301521 | 2021-05-09 | Berrien | Michigan | 26021 | 15058 | 273 |
1301522 | 1301522 | 2021-05-09 | Branch | Michigan | 26023 | 5516 | 119 |
1301523 | 1301523 | 2021-05-09 | Calhoun | Michigan | 26025 | 13830 | 281 |
1301524 | 1301524 | 2021-05-09 | Cass | Michigan | 26027 | 5295 | 74 |
1301525 | 1301525 | 2021-05-09 | Charlevoix | Michigan | 26029 | 1600 | 20 |
1301526 | 1301526 | 2021-05-09 | Cheboygan | Michigan | 26031 | 1873 | 42 |
1301527 | 1301527 | 2021-05-09 | Chippewa | Michigan | 26033 | 5538 | 49 |
1301528 | 1301528 | 2021-05-09 | Clare | Michigan | 26035 | 2376 | 74 |
1301529 | 1301529 | 2021-05-09 | Clinton | Michigan | 26037 | 7392 | 85 |
1301530 | 1301530 | 2021-05-09 | Crawford | Michigan | 26039 | 961 | 12 |
1301531 | 1301531 | 2021-05-09 | Delta | Michigan | 26041 | 3931 | 90 |
1301532 | 1301532 | 2021-05-09 | Dickinson | Michigan | 26043 | 2696 | 74 |
1301533 | 1301533 | 2021-05-09 | Eaton | Michigan | 26045 | 9834 | 193 |
1301534 | 1301534 | 2021-05-09 | Emmet | Michigan | 26047 | 2296 | 41 |
1301535 | 1301535 | 2021-05-09 | Genesee | Michigan | 26049 | 40639 | 897 |
1301536 | 1301536 | 2021-05-09 | Gladwin | Michigan | 26051 | 2229 | 52 |
1301537 | 1301537 | 2021-05-09 | Gogebic | Michigan | 26053 | 1374 | 50 |
1301538 | 1301538 | 2021-05-09 | Grand Traverse | Michigan | 26055 | 6280 | 93 |
1301539 | 1301539 | 2021-05-09 | Gratiot | Michigan | 26057 | 6785 | 118 |
1301540 | 1301540 | 2021-05-09 | Hillsdale | Michigan | 26059 | 4245 | 88 |
1301541 | 1301541 | 2021-05-09 | Houghton | Michigan | 26061 | 3077 | 40 |
1301542 | 1301542 | 2021-05-09 | Huron | Michigan | 26063 | 4016 | 74 |
1301543 | 1301543 | 2021-05-09 | Ingham | Michigan | 26065 | 24100 | 366 |
1301544 | 1301544 | 2021-05-09 | Ionia | Michigan | 26067 | 8967 | 83 |
1301545 | 1301545 | 2021-05-09 | Iosco | Michigan | 26069 | 1904 | 70 |
1301546 | 1301546 | 2021-05-09 | Iron | Michigan | 26071 | 1024 | 51 |
1301547 | 1301547 | 2021-05-09 | Isabella | Michigan | 26073 | 6048 | 88 |
1301548 | 1301548 | 2021-05-09 | Jackson | Michigan | 26075 | 20386 | 297 |
1301549 | 1301549 | 2021-05-09 | Kalamazoo | Michigan | 26077 | 22190 | 369 |
1301550 | 1301550 | 2021-05-09 | Kalkaska | Michigan | 26079 | 1074 | 21 |
1301551 | 1301551 | 2021-05-09 | Kent | Michigan | 26081 | 70018 | 803 |
1301552 | 1301552 | 2021-05-09 | Keweenaw | Michigan | 26083 | 173 | 2 |
1301553 | 1301553 | 2021-05-09 | Lake | Michigan | 26085 | 602 | 15 |
1301554 | 1301554 | 2021-05-09 | Lapeer | Michigan | 26087 | 9438 | 192 |
1301555 | 1301555 | 2021-05-09 | Leelanau | Michigan | 26089 | 1213 | 18 |
1301556 | 1301556 | 2021-05-09 | Lenawee | Michigan | 26091 | 10546 | 161 |
1301557 | 1301557 | 2021-05-09 | Livingston | Michigan | 26093 | 16245 | 178 |
1301558 | 1301558 | 2021-05-09 | Luce | Michigan | 26095 | 1252 | 3 |
1301559 | 1301559 | 2021-05-09 | Mackinac | Michigan | 26097 | 640 | 3 |
1301560 | 1301560 | 2021-05-09 | Macomb | Michigan | 26099 | 97507 | 2325 |
1301561 | 1301561 | 2021-05-09 | Manistee | Michigan | 26101 | 1936 | 24 |
1301562 | 1301562 | 2021-05-09 | Marquette | Michigan | 26103 | 5836 | 59 |
1301563 | 1301563 | 2021-05-09 | Mason | Michigan | 26105 | 2072 | 35 |
1301564 | 1301564 | 2021-05-09 | Mecosta | Michigan | 26107 | 3074 | 30 |
1301565 | 1301565 | 2021-05-09 | Menominee | Michigan | 26109 | 2078 | 41 |
1301566 | 1301566 | 2021-05-09 | Midland | Michigan | 26111 | 7237 | 82 |
1301567 | 1301567 | 2021-05-09 | Missaukee | Michigan | 26113 | 1453 | 24 |
1301568 | 1301568 | 2021-05-09 | Monroe | Michigan | 26115 | 14912 | 244 |
1301569 | 1301569 | 2021-05-09 | Montcalm | Michigan | 26117 | 7760 | 112 |
1301570 | 1301570 | 2021-05-09 | Montmorency | Michigan | 26119 | 569 | 19 |
1301571 | 1301571 | 2021-05-09 | Muskegon | Michigan | 26121 | 17272 | 346 |
1301572 | 1301572 | 2021-05-09 | Newaygo | Michigan | 26123 | 4616 | 60 |
1301573 | 1301573 | 2021-05-09 | Oakland | Michigan | 26125 | 114310 | 2252 |
1301574 | 1301574 | 2021-05-09 | Oceana | Michigan | 26127 | 2679 | 58 |
1301575 | 1301575 | 2021-05-09 | Ogemaw | Michigan | 26129 | 1619 | 38 |
1301576 | 1301576 | 2021-05-09 | Ontonagon | Michigan | 26131 | 456 | 21 |
1301577 | 1301577 | 2021-05-09 | Osceola | Michigan | 26133 | 1853 | 28 |
1301578 | 1301578 | 2021-05-09 | Oscoda | Michigan | 26135 | 622 | 25 |
1301579 | 1301579 | 2021-05-09 | Otsego | Michigan | 26137 | 2275 | 38 |
1301580 | 1301580 | 2021-05-09 | Ottawa | Michigan | 26139 | 31549 | 405 |
1301581 | 1301581 | 2021-05-09 | Presque Isle | Michigan | 26141 | 1004 | 31 |
1301582 | 1301582 | 2021-05-09 | Roscommon | Michigan | 26143 | 1840 | 47 |
1301583 | 1301583 | 2021-05-09 | Saginaw | Michigan | 26145 | 21548 | 586 |
1301584 | 1301584 | 2021-05-09 | Sanilac | Michigan | 26151 | 4166 | 108 |
1301585 | 1301585 | 2021-05-09 | Schoolcraft | Michigan | 26153 | 386 | 5 |
1301586 | 1301586 | 2021-05-09 | Shiawassee | Michigan | 26155 | 6153 | 101 |
1301587 | 1301587 | 2021-05-09 | St. Clair | Michigan | 26147 | 17696 | 412 |
1301588 | 1301588 | 2021-05-09 | St. Joseph | Michigan | 26149 | 5994 | 94 |
1301589 | 1301589 | 2021-05-09 | Tuscola | Michigan | 26157 | 5519 | 164 |
1301590 | 1301590 | 2021-05-09 | Unknown | Michigan | 495 | 16 | |
1301591 | 1301591 | 2021-05-09 | Van Buren | Michigan | 26159 | 6871 | 120 |
1301592 | 1301592 | 2021-05-09 | Washtenaw | Michigan | 26161 | 26437 | 284 |
1301593 | 1301593 | 2021-05-09 | Wayne | Michigan | 26163 | 159224 | 4778 |
1301594 | 1301594 | 2021-05-09 | Wexford | Michigan | 26165 | 2795 | 42 |
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);