ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
332 rows where deaths = 39 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Emmet 33
- Houghton 27
- Lapeer 24
- Mason 24
- Mecosta 24
- Alcona 21
- Calhoun 20
- Baraga 15
- Montmorency 14
- Presque Isle 14
- Gogebic 11
- Oscoda 7
- Roscommon 7
- Unknown 7
- Barry 5
- Cass 5
- Newaygo 5
- Isabella 4
- Missaukee 4
- Oceana 4
- Ogemaw 4
- Tuscola 4
- Bay 3
- Clinton 3
- Grand Traverse 3
- Ionia 3
- Leelanau 3
- Manistee 3
- Benzie 2
- Charlevoix 2
- …
state 1
- Michigan · 332 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494384 | 2494384 | 2022-05-11 | Unknown | Michigan | 12461 | 39 | |
2471580 | 2471580 | 2022-05-04 | Unknown | Michigan | 12342 | 39 | |
2448789 | 2448789 | 2022-04-27 | Unknown | Michigan | 12263 | 39 | |
2425997 | 2425997 | 2022-04-20 | Unknown | Michigan | 12218 | 39 | |
2403205 | 2403205 | 2022-04-13 | Unknown | Michigan | 12190 | 39 | |
2035666 | 2035666 | 2021-12-21 | Montmorency | Michigan | 26119 | 1328 | 39 |
2032416 | 2032416 | 2021-12-20 | Montmorency | Michigan | 26119 | 1328 | 39 |
2029150 | 2029150 | 2021-12-19 | Leelanau | Michigan | 26089 | 2389 | 39 |
2029165 | 2029165 | 2021-12-19 | Montmorency | Michigan | 26119 | 1324 | 39 |
2025899 | 2025899 | 2021-12-18 | Leelanau | Michigan | 26089 | 2389 | 39 |
2025914 | 2025914 | 2021-12-18 | Montmorency | Michigan | 26119 | 1324 | 39 |
2022648 | 2022648 | 2021-12-17 | Leelanau | Michigan | 26089 | 2389 | 39 |
2022663 | 2022663 | 2021-12-17 | Montmorency | Michigan | 26119 | 1324 | 39 |
2019412 | 2019412 | 2021-12-16 | Montmorency | Michigan | 26119 | 1317 | 39 |
2016162 | 2016162 | 2021-12-15 | Montmorency | Michigan | 26119 | 1317 | 39 |
2012911 | 2012911 | 2021-12-14 | Montmorency | Michigan | 26119 | 1309 | 39 |
2009660 | 2009660 | 2021-12-13 | Montmorency | Michigan | 26119 | 1309 | 39 |
2006409 | 2006409 | 2021-12-12 | Montmorency | Michigan | 26119 | 1304 | 39 |
2003158 | 2003158 | 2021-12-11 | Montmorency | Michigan | 26119 | 1304 | 39 |
1999908 | 1999908 | 2021-12-10 | Montmorency | Michigan | 26119 | 1304 | 39 |
1996657 | 1996657 | 2021-12-09 | Montmorency | Michigan | 26119 | 1297 | 39 |
1993406 | 1993406 | 2021-12-08 | Montmorency | Michigan | 26119 | 1297 | 39 |
1921852 | 1921852 | 2021-11-16 | Charlevoix | Michigan | 26029 | 2796 | 39 |
1918602 | 1918602 | 2021-11-15 | Charlevoix | Michigan | 26029 | 2780 | 39 |
1905645 | 1905645 | 2021-11-11 | Missaukee | Michigan | 26113 | 1920 | 39 |
1902396 | 1902396 | 2021-11-10 | Missaukee | Michigan | 26113 | 1920 | 39 |
1899157 | 1899157 | 2021-11-09 | Oscoda | Michigan | 26135 | 1016 | 39 |
1899160 | 1899160 | 2021-11-09 | Presque Isle | Michigan | 26141 | 1450 | 39 |
1895907 | 1895907 | 2021-11-08 | Oscoda | Michigan | 26135 | 1016 | 39 |
1895910 | 1895910 | 2021-11-08 | Presque Isle | Michigan | 26141 | 1450 | 39 |
1892640 | 1892640 | 2021-11-07 | Manistee | Michigan | 26101 | 2601 | 39 |
1892657 | 1892657 | 2021-11-07 | Oscoda | Michigan | 26135 | 1005 | 39 |
1892660 | 1892660 | 2021-11-07 | Presque Isle | Michigan | 26141 | 1431 | 39 |
1889390 | 1889390 | 2021-11-06 | Manistee | Michigan | 26101 | 2601 | 39 |
1889407 | 1889407 | 2021-11-06 | Oscoda | Michigan | 26135 | 1005 | 39 |
1889410 | 1889410 | 2021-11-06 | Presque Isle | Michigan | 26141 | 1431 | 39 |
1886140 | 1886140 | 2021-11-05 | Manistee | Michigan | 26101 | 2601 | 39 |
1886157 | 1886157 | 2021-11-05 | Oscoda | Michigan | 26135 | 1005 | 39 |
1886160 | 1886160 | 2021-11-05 | Presque Isle | Michigan | 26141 | 1431 | 39 |
1882908 | 1882908 | 2021-11-04 | Oscoda | Michigan | 26135 | 995 | 39 |
1882911 | 1882911 | 2021-11-04 | Presque Isle | Michigan | 26141 | 1410 | 39 |
1879659 | 1879659 | 2021-11-03 | Oscoda | Michigan | 26135 | 995 | 39 |
1879662 | 1879662 | 2021-11-03 | Presque Isle | Michigan | 26141 | 1410 | 39 |
1876399 | 1876399 | 2021-11-02 | Missaukee | Michigan | 26113 | 1884 | 39 |
1876413 | 1876413 | 2021-11-02 | Presque Isle | Michigan | 26141 | 1400 | 39 |
1873150 | 1873150 | 2021-11-01 | Missaukee | Michigan | 26113 | 1884 | 39 |
1873164 | 1873164 | 2021-11-01 | Presque Isle | Michigan | 26141 | 1400 | 39 |
1869915 | 1869915 | 2021-10-31 | Presque Isle | Michigan | 26141 | 1388 | 39 |
1866666 | 1866666 | 2021-10-30 | Presque Isle | Michigan | 26141 | 1388 | 39 |
1863417 | 1863417 | 2021-10-29 | Presque Isle | Michigan | 26141 | 1388 | 39 |
1860168 | 1860168 | 2021-10-28 | Presque Isle | Michigan | 26141 | 1373 | 39 |
1856919 | 1856919 | 2021-10-27 | Presque Isle | Michigan | 26141 | 1373 | 39 |
1837361 | 1837361 | 2021-10-21 | Benzie | Michigan | 26019 | 1616 | 39 |
1834112 | 1834112 | 2021-10-20 | Benzie | Michigan | 26019 | 1616 | 39 |
1808112 | 1808112 | 2021-10-12 | Alcona | Michigan | 26001 | 998 | 39 |
1804861 | 1804861 | 2021-10-11 | Alcona | Michigan | 26001 | 998 | 39 |
1801612 | 1801612 | 2021-10-10 | Alcona | Michigan | 26001 | 986 | 39 |
1798363 | 1798363 | 2021-10-09 | Alcona | Michigan | 26001 | 986 | 39 |
1795114 | 1795114 | 2021-10-08 | Alcona | Michigan | 26001 | 986 | 39 |
1791865 | 1791865 | 2021-10-07 | Alcona | Michigan | 26001 | 970 | 39 |
1788616 | 1788616 | 2021-10-06 | Alcona | Michigan | 26001 | 970 | 39 |
1785368 | 1785368 | 2021-10-05 | Alcona | Michigan | 26001 | 958 | 39 |
1782119 | 1782119 | 2021-10-04 | Alcona | Michigan | 26001 | 958 | 39 |
1778869 | 1778869 | 2021-10-03 | Alcona | Michigan | 26001 | 942 | 39 |
1775619 | 1775619 | 2021-10-02 | Alcona | Michigan | 26001 | 942 | 39 |
1772369 | 1772369 | 2021-10-01 | Alcona | Michigan | 26001 | 942 | 39 |
1769120 | 1769120 | 2021-09-30 | Alcona | Michigan | 26001 | 930 | 39 |
1765871 | 1765871 | 2021-09-29 | Alcona | Michigan | 26001 | 930 | 39 |
1762622 | 1762622 | 2021-09-28 | Alcona | Michigan | 26001 | 908 | 39 |
1759373 | 1759373 | 2021-09-27 | Alcona | Michigan | 26001 | 908 | 39 |
1756125 | 1756125 | 2021-09-26 | Alcona | Michigan | 26001 | 899 | 39 |
1756178 | 1756178 | 2021-09-26 | Mecosta | Michigan | 26107 | 3839 | 39 |
1752877 | 1752877 | 2021-09-25 | Alcona | Michigan | 26001 | 899 | 39 |
1752930 | 1752930 | 2021-09-25 | Mecosta | Michigan | 26107 | 3839 | 39 |
1749629 | 1749629 | 2021-09-24 | Alcona | Michigan | 26001 | 899 | 39 |
1749682 | 1749682 | 2021-09-24 | Mecosta | Michigan | 26107 | 3839 | 39 |
1746379 | 1746379 | 2021-09-23 | Alcona | Michigan | 26001 | 889 | 39 |
1746432 | 1746432 | 2021-09-23 | Mecosta | Michigan | 26107 | 3787 | 39 |
1743130 | 1743130 | 2021-09-22 | Alcona | Michigan | 26001 | 889 | 39 |
1743183 | 1743183 | 2021-09-22 | Mecosta | Michigan | 26107 | 3787 | 39 |
1739934 | 1739934 | 2021-09-21 | Mecosta | Michigan | 26107 | 3744 | 39 |
1736685 | 1736685 | 2021-09-20 | Mecosta | Michigan | 26107 | 3744 | 39 |
1733435 | 1733435 | 2021-09-19 | Mecosta | Michigan | 26107 | 3685 | 39 |
1730185 | 1730185 | 2021-09-18 | Mecosta | Michigan | 26107 | 3685 | 39 |
1726935 | 1726935 | 2021-09-17 | Mecosta | Michigan | 26107 | 3685 | 39 |
1723686 | 1723686 | 2021-09-16 | Mecosta | Michigan | 26107 | 3643 | 39 |
1720437 | 1720437 | 2021-09-15 | Mecosta | Michigan | 26107 | 3643 | 39 |
1717189 | 1717189 | 2021-09-14 | Mecosta | Michigan | 26107 | 3584 | 39 |
1713941 | 1713941 | 2021-09-13 | Mecosta | Michigan | 26107 | 3584 | 39 |
1710695 | 1710695 | 2021-09-12 | Mecosta | Michigan | 26107 | 3532 | 39 |
1707448 | 1707448 | 2021-09-11 | Mecosta | Michigan | 26107 | 3532 | 39 |
1704201 | 1704201 | 2021-09-10 | Mecosta | Michigan | 26107 | 3532 | 39 |
1700951 | 1700951 | 2021-09-09 | Mecosta | Michigan | 26107 | 3484 | 39 |
1697702 | 1697702 | 2021-09-08 | Mecosta | Michigan | 26107 | 3484 | 39 |
1694453 | 1694453 | 2021-09-07 | Mason | Michigan | 26105 | 2458 | 39 |
1694454 | 1694454 | 2021-09-07 | Mecosta | Michigan | 26107 | 3476 | 39 |
1691204 | 1691204 | 2021-09-06 | Mason | Michigan | 26105 | 2433 | 39 |
1691205 | 1691205 | 2021-09-06 | Mecosta | Michigan | 26107 | 3432 | 39 |
1687954 | 1687954 | 2021-09-05 | Mason | Michigan | 26105 | 2433 | 39 |
1687955 | 1687955 | 2021-09-05 | Mecosta | Michigan | 26107 | 3432 | 39 |
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);