ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2020-03-30" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20511 | 20511 | 2020-03-30 | Allegan | Michigan | 26005 | 2 | 0 |
20512 | 20512 | 2020-03-30 | Antrim | Michigan | 26009 | 2 | 0 |
20513 | 20513 | 2020-03-30 | Barry | Michigan | 26015 | 1 | 0 |
20514 | 20514 | 2020-03-30 | Bay | Michigan | 26017 | 9 | 0 |
20515 | 20515 | 2020-03-30 | Berrien | Michigan | 26021 | 32 | 1 |
20516 | 20516 | 2020-03-30 | Calhoun | Michigan | 26025 | 17 | 0 |
20517 | 20517 | 2020-03-30 | Cass | Michigan | 26027 | 4 | 0 |
20518 | 20518 | 2020-03-30 | Charlevoix | Michigan | 26029 | 4 | 0 |
20519 | 20519 | 2020-03-30 | Cheboygan | Michigan | 26031 | 1 | 0 |
20520 | 20520 | 2020-03-30 | Chippewa | Michigan | 26033 | 1 | 0 |
20521 | 20521 | 2020-03-30 | Clare | Michigan | 26035 | 1 | 0 |
20522 | 20522 | 2020-03-30 | Clinton | Michigan | 26037 | 19 | 0 |
20523 | 20523 | 2020-03-30 | Crawford | Michigan | 26039 | 1 | 0 |
20524 | 20524 | 2020-03-30 | Delta | Michigan | 26041 | 1 | 0 |
20525 | 20525 | 2020-03-30 | Eaton | Michigan | 26045 | 15 | 0 |
20526 | 20526 | 2020-03-30 | Emmet | Michigan | 26047 | 4 | 0 |
20527 | 20527 | 2020-03-30 | Genesee | Michigan | 26049 | 150 | 7 |
20528 | 20528 | 2020-03-30 | Gladwin | Michigan | 26051 | 3 | 0 |
20529 | 20529 | 2020-03-30 | Gogebic | Michigan | 26053 | 1 | 1 |
20530 | 20530 | 2020-03-30 | Grand Traverse | Michigan | 26055 | 7 | 0 |
20531 | 20531 | 2020-03-30 | Gratiot | Michigan | 26057 | 3 | 0 |
20532 | 20532 | 2020-03-30 | Hillsdale | Michigan | 26059 | 12 | 1 |
20533 | 20533 | 2020-03-30 | Houghton | Michigan | 26061 | 1 | 0 |
20534 | 20534 | 2020-03-30 | Huron | Michigan | 26063 | 3 | 0 |
20535 | 20535 | 2020-03-30 | Ingham | Michigan | 26065 | 73 | 0 |
20536 | 20536 | 2020-03-30 | Ionia | Michigan | 26067 | 4 | 0 |
20537 | 20537 | 2020-03-30 | Iosco | Michigan | 26069 | 1 | 0 |
20538 | 20538 | 2020-03-30 | Isabella | Michigan | 26073 | 5 | 1 |
20539 | 20539 | 2020-03-30 | Jackson | Michigan | 26075 | 37 | 1 |
20540 | 20540 | 2020-03-30 | Kalamazoo | Michigan | 26077 | 24 | 1 |
20541 | 20541 | 2020-03-30 | Kalkaska | Michigan | 26079 | 5 | 1 |
20542 | 20542 | 2020-03-30 | Kent | Michigan | 26081 | 96 | 1 |
20543 | 20543 | 2020-03-30 | Lapeer | Michigan | 26087 | 6 | 0 |
20544 | 20544 | 2020-03-30 | Leelanau | Michigan | 26089 | 1 | 0 |
20545 | 20545 | 2020-03-30 | Lenawee | Michigan | 26091 | 15 | 0 |
20546 | 20546 | 2020-03-30 | Livingston | Michigan | 26093 | 64 | 2 |
20547 | 20547 | 2020-03-30 | Macomb | Michigan | 26099 | 728 | 27 |
20548 | 20548 | 2020-03-30 | Manistee | Michigan | 26101 | 1 | 0 |
20549 | 20549 | 2020-03-30 | Marquette | Michigan | 26103 | 3 | 0 |
20550 | 20550 | 2020-03-30 | Mecosta | Michigan | 26107 | 2 | 1 |
20551 | 20551 | 2020-03-30 | Midland | Michigan | 26111 | 9 | 0 |
20552 | 20552 | 2020-03-30 | Missaukee | Michigan | 26113 | 1 | 1 |
20553 | 20553 | 2020-03-30 | Monroe | Michigan | 26115 | 45 | 0 |
20554 | 20554 | 2020-03-30 | Montcalm | Michigan | 26117 | 4 | 0 |
20555 | 20555 | 2020-03-30 | Muskegon | Michigan | 26121 | 18 | 2 |
20556 | 20556 | 2020-03-30 | Newaygo | Michigan | 26123 | 1 | 0 |
20557 | 20557 | 2020-03-30 | Oakland | Michigan | 26125 | 1391 | 59 |
20558 | 20558 | 2020-03-30 | Oceana | Michigan | 26127 | 2 | 0 |
20559 | 20559 | 2020-03-30 | Ogemaw | Michigan | 26129 | 4 | 0 |
20560 | 20560 | 2020-03-30 | Osceola | Michigan | 26133 | 2 | 0 |
20561 | 20561 | 2020-03-30 | Otsego | Michigan | 26137 | 17 | 0 |
20562 | 20562 | 2020-03-30 | Ottawa | Michigan | 26139 | 28 | 0 |
20563 | 20563 | 2020-03-30 | Roscommon | Michigan | 26143 | 1 | 0 |
20564 | 20564 | 2020-03-30 | Saginaw | Michigan | 26145 | 36 | 0 |
20565 | 20565 | 2020-03-30 | Sanilac | Michigan | 26151 | 5 | 0 |
20566 | 20566 | 2020-03-30 | Shiawassee | Michigan | 26155 | 8 | 0 |
20567 | 20567 | 2020-03-30 | St. Clair | Michigan | 26147 | 25 | 0 |
20568 | 20568 | 2020-03-30 | St. Joseph | Michigan | 26149 | 3 | 0 |
20569 | 20569 | 2020-03-30 | Tuscola | Michigan | 26157 | 5 | 1 |
20570 | 20570 | 2020-03-30 | Unknown | Michigan | 77 | 0 | |
20571 | 20571 | 2020-03-30 | Van Buren | Michigan | 26159 | 4 | 0 |
20572 | 20572 | 2020-03-30 | Washtenaw | Michigan | 26161 | 266 | 6 |
20573 | 20573 | 2020-03-30 | Wayne | Michigan | 26163 | 3195 | 83 |
20574 | 20574 | 2020-03-30 | Wexford | Michigan | 26165 | 2 | 0 |
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);