ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2021-07-13" 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 |
---|---|---|---|---|---|---|---|
1512503 | 1512503 | 2021-07-13 | Alcona | Michigan | 26001 | 741 | 33 |
1512504 | 1512504 | 2021-07-13 | Alger | Michigan | 26003 | 670 | 7 |
1512505 | 1512505 | 2021-07-13 | Allegan | Michigan | 26005 | 11224 | 162 |
1512506 | 1512506 | 2021-07-13 | Alpena | Michigan | 26007 | 2274 | 64 |
1512507 | 1512507 | 2021-07-13 | Antrim | Michigan | 26009 | 1639 | 30 |
1512508 | 1512508 | 2021-07-13 | Arenac | Michigan | 26011 | 1216 | 29 |
1512509 | 1512509 | 2021-07-13 | Baraga | Michigan | 26013 | 994 | 40 |
1512510 | 1512510 | 2021-07-13 | Barry | Michigan | 26015 | 5974 | 69 |
1512511 | 1512511 | 2021-07-13 | Bay | Michigan | 26017 | 11276 | 354 |
1512512 | 1512512 | 2021-07-13 | Benzie | Michigan | 26019 | 1285 | 36 |
1512513 | 1512513 | 2021-07-13 | Berrien | Michigan | 26021 | 15632 | 297 |
1512514 | 1512514 | 2021-07-13 | Branch | Michigan | 26023 | 5788 | 121 |
1512515 | 1512515 | 2021-07-13 | Calhoun | Michigan | 26025 | 14610 | 320 |
1512516 | 1512516 | 2021-07-13 | Cass | Michigan | 26027 | 5513 | 78 |
1512517 | 1512517 | 2021-07-13 | Charlevoix | Michigan | 26029 | 1686 | 22 |
1512518 | 1512518 | 2021-07-13 | Cheboygan | Michigan | 26031 | 1931 | 47 |
1512519 | 1512519 | 2021-07-13 | Chippewa | Michigan | 26033 | 5651 | 50 |
1512520 | 1512520 | 2021-07-13 | Clare | Michigan | 26035 | 2487 | 86 |
1512521 | 1512521 | 2021-07-13 | Clinton | Michigan | 26037 | 7673 | 95 |
1512522 | 1512522 | 2021-07-13 | Crawford | Michigan | 26039 | 996 | 14 |
1512523 | 1512523 | 2021-07-13 | Delta | Michigan | 26041 | 4060 | 95 |
1512524 | 1512524 | 2021-07-13 | Dickinson | Michigan | 26043 | 2758 | 74 |
1512525 | 1512525 | 2021-07-13 | Eaton | Michigan | 26045 | 10171 | 212 |
1512526 | 1512526 | 2021-07-13 | Emmet | Michigan | 26047 | 2390 | 43 |
1512527 | 1512527 | 2021-07-13 | Genesee | Michigan | 26049 | 41808 | 974 |
1512528 | 1512528 | 2021-07-13 | Gladwin | Michigan | 26051 | 2308 | 61 |
1512529 | 1512529 | 2021-07-13 | Gogebic | Michigan | 26053 | 1425 | 52 |
1512530 | 1512530 | 2021-07-13 | Grand Traverse | Michigan | 26055 | 6499 | 100 |
1512531 | 1512531 | 2021-07-13 | Gratiot | Michigan | 26057 | 6986 | 125 |
1512532 | 1512532 | 2021-07-13 | Hillsdale | Michigan | 26059 | 4409 | 94 |
1512533 | 1512533 | 2021-07-13 | Houghton | Michigan | 26061 | 3143 | 43 |
1512534 | 1512534 | 2021-07-13 | Huron | Michigan | 26063 | 4095 | 82 |
1512535 | 1512535 | 2021-07-13 | Ingham | Michigan | 26065 | 24958 | 393 |
1512536 | 1512536 | 2021-07-13 | Ionia | Michigan | 26067 | 9366 | 85 |
1512537 | 1512537 | 2021-07-13 | Iosco | Michigan | 26069 | 2009 | 75 |
1512538 | 1512538 | 2021-07-13 | Iron | Michigan | 26071 | 1062 | 53 |
1512539 | 1512539 | 2021-07-13 | Isabella | Michigan | 26073 | 6345 | 100 |
1512540 | 1512540 | 2021-07-13 | Jackson | Michigan | 26075 | 21105 | 324 |
1512541 | 1512541 | 2021-07-13 | Kalamazoo | Michigan | 26077 | 23249 | 403 |
1512542 | 1512542 | 2021-07-13 | Kalkaska | Michigan | 26079 | 1146 | 27 |
1512543 | 1512543 | 2021-07-13 | Kent | Michigan | 26081 | 73971 | 864 |
1512544 | 1512544 | 2021-07-13 | Keweenaw | Michigan | 26083 | 174 | 2 |
1512545 | 1512545 | 2021-07-13 | Lake | Michigan | 26085 | 639 | 16 |
1512546 | 1512546 | 2021-07-13 | Lapeer | Michigan | 26087 | 9781 | 215 |
1512547 | 1512547 | 2021-07-13 | Leelanau | Michigan | 26089 | 1247 | 20 |
1512548 | 1512548 | 2021-07-13 | Lenawee | Michigan | 26091 | 10867 | 178 |
1512549 | 1512549 | 2021-07-13 | Livingston | Michigan | 26093 | 16854 | 198 |
1512550 | 1512550 | 2021-07-13 | Luce | Michigan | 26095 | 1338 | 6 |
1512551 | 1512551 | 2021-07-13 | Mackinac | Michigan | 26097 | 715 | 3 |
1512552 | 1512552 | 2021-07-13 | Macomb | Michigan | 26099 | 100840 | 2503 |
1512553 | 1512553 | 2021-07-13 | Manistee | Michigan | 26101 | 1982 | 25 |
1512554 | 1512554 | 2021-07-13 | Marquette | Michigan | 26103 | 5942 | 65 |
1512555 | 1512555 | 2021-07-13 | Mason | Michigan | 26105 | 2141 | 37 |
1512556 | 1512556 | 2021-07-13 | Mecosta | Michigan | 26107 | 3223 | 37 |
1512557 | 1512557 | 2021-07-13 | Menominee | Michigan | 26109 | 2133 | 43 |
1512558 | 1512558 | 2021-07-13 | Midland | Michigan | 26111 | 7602 | 94 |
1512559 | 1512559 | 2021-07-13 | Missaukee | Michigan | 26113 | 1518 | 27 |
1512560 | 1512560 | 2021-07-13 | Monroe | Michigan | 26115 | 15460 | 265 |
1512561 | 1512561 | 2021-07-13 | Montcalm | Michigan | 26117 | 8221 | 120 |
1512562 | 1512562 | 2021-07-13 | Montmorency | Michigan | 26119 | 618 | 20 |
1512563 | 1512563 | 2021-07-13 | Muskegon | Michigan | 26121 | 18477 | 381 |
1512564 | 1512564 | 2021-07-13 | Newaygo | Michigan | 26123 | 4908 | 69 |
1512565 | 1512565 | 2021-07-13 | Oakland | Michigan | 26125 | 119094 | 2462 |
1512566 | 1512566 | 2021-07-13 | Oceana | Michigan | 26127 | 2777 | 60 |
1512567 | 1512567 | 2021-07-13 | Ogemaw | Michigan | 26129 | 1747 | 43 |
1512568 | 1512568 | 2021-07-13 | Ontonagon | Michigan | 26131 | 484 | 21 |
1512569 | 1512569 | 2021-07-13 | Osceola | Michigan | 26133 | 1967 | 31 |
1512570 | 1512570 | 2021-07-13 | Oscoda | Michigan | 26135 | 692 | 31 |
1512571 | 1512571 | 2021-07-13 | Otsego | Michigan | 26137 | 2369 | 41 |
1512572 | 1512572 | 2021-07-13 | Ottawa | Michigan | 26139 | 32997 | 442 |
1512573 | 1512573 | 2021-07-13 | Presque Isle | Michigan | 26141 | 1058 | 34 |
1512574 | 1512574 | 2021-07-13 | Roscommon | Michigan | 26143 | 1904 | 55 |
1512575 | 1512575 | 2021-07-13 | Saginaw | Michigan | 26145 | 22562 | 638 |
1512576 | 1512576 | 2021-07-13 | Sanilac | Michigan | 26151 | 4261 | 125 |
1512577 | 1512577 | 2021-07-13 | Schoolcraft | Michigan | 26153 | 438 | 5 |
1512578 | 1512578 | 2021-07-13 | Shiawassee | Michigan | 26155 | 6451 | 109 |
1512579 | 1512579 | 2021-07-13 | St. Clair | Michigan | 26147 | 18547 | 451 |
1512580 | 1512580 | 2021-07-13 | St. Joseph | Michigan | 26149 | 6271 | 101 |
1512581 | 1512581 | 2021-07-13 | Tuscola | Michigan | 26157 | 5676 | 174 |
1512582 | 1512582 | 2021-07-13 | Unknown | Michigan | 742 | 16 | |
1512583 | 1512583 | 2021-07-13 | Van Buren | Michigan | 26159 | 7161 | 133 |
1512584 | 1512584 | 2021-07-13 | Washtenaw | Michigan | 26161 | 27197 | 311 |
1512585 | 1512585 | 2021-07-13 | Wayne | Michigan | 26163 | 166558 | 5189 |
1512586 | 1512586 | 2021-07-13 | Wexford | Michigan | 26165 | 2905 | 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);