ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
614 rows where deaths = 14 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Crawford 121
- Alpena 84
- Kalkaska 39
- Luce 31
- Clinton 28
- Leelanau 22
- Midland 22
- Unknown 20
- Mackinac 18
- Keweenaw 17
- Mecosta 17
- Alcona 14
- Gratiot 13
- Oscoda 12
- Grand Traverse 11
- Osceola 10
- Cass 9
- Gladwin 9
- Van Buren 9
- Isabella 7
- Ontonagon 7
- Otsego 7
- Iosco 6
- Manistee 6
- Tuscola 6
- Lake 5
- Barry 4
- Charlevoix 4
- Clare 4
- Cheboygan 3
- …
state 1
- Michigan · 614 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500862 | 2500862 | 2022-05-13 | Keweenaw | Michigan | 26083 | 523 | 14 |
2500868 | 2500868 | 2022-05-13 | Luce | Michigan | 26095 | 2306 | 14 |
2497604 | 2497604 | 2022-05-12 | Keweenaw | Michigan | 26083 | 523 | 14 |
2497610 | 2497610 | 2022-05-12 | Luce | Michigan | 26095 | 2306 | 14 |
2494346 | 2494346 | 2022-05-11 | Keweenaw | Michigan | 26083 | 523 | 14 |
2494352 | 2494352 | 2022-05-11 | Luce | Michigan | 26095 | 2306 | 14 |
2491088 | 2491088 | 2022-05-10 | Keweenaw | Michigan | 26083 | 520 | 14 |
2491094 | 2491094 | 2022-05-10 | Luce | Michigan | 26095 | 2298 | 14 |
2487831 | 2487831 | 2022-05-09 | Keweenaw | Michigan | 26083 | 520 | 14 |
2487837 | 2487837 | 2022-05-09 | Luce | Michigan | 26095 | 2298 | 14 |
2484573 | 2484573 | 2022-05-08 | Keweenaw | Michigan | 26083 | 520 | 14 |
2484579 | 2484579 | 2022-05-08 | Luce | Michigan | 26095 | 2298 | 14 |
2481315 | 2481315 | 2022-05-07 | Keweenaw | Michigan | 26083 | 520 | 14 |
2481321 | 2481321 | 2022-05-07 | Luce | Michigan | 26095 | 2298 | 14 |
2478057 | 2478057 | 2022-05-06 | Keweenaw | Michigan | 26083 | 520 | 14 |
2478063 | 2478063 | 2022-05-06 | Luce | Michigan | 26095 | 2298 | 14 |
2474799 | 2474799 | 2022-05-05 | Keweenaw | Michigan | 26083 | 520 | 14 |
2474805 | 2474805 | 2022-05-05 | Luce | Michigan | 26095 | 2298 | 14 |
2471542 | 2471542 | 2022-05-04 | Keweenaw | Michigan | 26083 | 520 | 14 |
2471548 | 2471548 | 2022-05-04 | Luce | Michigan | 26095 | 2298 | 14 |
2468286 | 2468286 | 2022-05-03 | Keweenaw | Michigan | 26083 | 515 | 14 |
2468292 | 2468292 | 2022-05-03 | Luce | Michigan | 26095 | 2292 | 14 |
2465031 | 2465031 | 2022-05-02 | Keweenaw | Michigan | 26083 | 515 | 14 |
2465037 | 2465037 | 2022-05-02 | Luce | Michigan | 26095 | 2292 | 14 |
2461775 | 2461775 | 2022-05-01 | Keweenaw | Michigan | 26083 | 515 | 14 |
2461781 | 2461781 | 2022-05-01 | Luce | Michigan | 26095 | 2292 | 14 |
2458519 | 2458519 | 2022-04-30 | Keweenaw | Michigan | 26083 | 515 | 14 |
2458525 | 2458525 | 2022-04-30 | Luce | Michigan | 26095 | 2292 | 14 |
2455263 | 2455263 | 2022-04-29 | Keweenaw | Michigan | 26083 | 515 | 14 |
2455269 | 2455269 | 2022-04-29 | Luce | Michigan | 26095 | 2292 | 14 |
2452007 | 2452007 | 2022-04-28 | Keweenaw | Michigan | 26083 | 515 | 14 |
2452013 | 2452013 | 2022-04-28 | Luce | Michigan | 26095 | 2292 | 14 |
2448751 | 2448751 | 2022-04-27 | Keweenaw | Michigan | 26083 | 515 | 14 |
2448757 | 2448757 | 2022-04-27 | Luce | Michigan | 26095 | 2292 | 14 |
2445501 | 2445501 | 2022-04-26 | Luce | Michigan | 26095 | 2280 | 14 |
2442245 | 2442245 | 2022-04-25 | Luce | Michigan | 26095 | 2280 | 14 |
2438989 | 2438989 | 2022-04-24 | Luce | Michigan | 26095 | 2280 | 14 |
2435733 | 2435733 | 2022-04-23 | Luce | Michigan | 26095 | 2280 | 14 |
2432477 | 2432477 | 2022-04-22 | Luce | Michigan | 26095 | 2280 | 14 |
2429221 | 2429221 | 2022-04-21 | Luce | Michigan | 26095 | 2280 | 14 |
2425965 | 2425965 | 2022-04-20 | Luce | Michigan | 26095 | 2280 | 14 |
2422709 | 2422709 | 2022-04-19 | Luce | Michigan | 26095 | 2283 | 14 |
2419453 | 2419453 | 2022-04-18 | Luce | Michigan | 26095 | 2283 | 14 |
2416197 | 2416197 | 2022-04-17 | Luce | Michigan | 26095 | 2283 | 14 |
2412941 | 2412941 | 2022-04-16 | Luce | Michigan | 26095 | 2283 | 14 |
2409685 | 2409685 | 2022-04-15 | Luce | Michigan | 26095 | 2283 | 14 |
2406429 | 2406429 | 2022-04-14 | Luce | Michigan | 26095 | 2283 | 14 |
2403173 | 2403173 | 2022-04-13 | Luce | Michigan | 26095 | 2283 | 14 |
2269817 | 2269817 | 2022-03-03 | Schoolcraft | Michigan | 26153 | 1744 | 14 |
2266564 | 2266564 | 2022-03-02 | Schoolcraft | Michigan | 26153 | 1744 | 14 |
1973894 | 1973894 | 2021-12-02 | Mackinac | Michigan | 26097 | 1522 | 14 |
1970645 | 1970645 | 2021-12-01 | Mackinac | Michigan | 26097 | 1522 | 14 |
1967395 | 1967395 | 2021-11-30 | Mackinac | Michigan | 26097 | 1485 | 14 |
1964143 | 1964143 | 2021-11-29 | Mackinac | Michigan | 26097 | 1485 | 14 |
1960892 | 1960892 | 2021-11-28 | Mackinac | Michigan | 26097 | 1460 | 14 |
1957641 | 1957641 | 2021-11-27 | Mackinac | Michigan | 26097 | 1460 | 14 |
1954390 | 1954390 | 2021-11-26 | Mackinac | Michigan | 26097 | 1460 | 14 |
1951139 | 1951139 | 2021-11-25 | Mackinac | Michigan | 26097 | 1460 | 14 |
1947888 | 1947888 | 2021-11-24 | Mackinac | Michigan | 26097 | 1460 | 14 |
1944637 | 1944637 | 2021-11-23 | Mackinac | Michigan | 26097 | 1440 | 14 |
1941386 | 1941386 | 2021-11-22 | Mackinac | Michigan | 26097 | 1440 | 14 |
1938136 | 1938136 | 2021-11-21 | Mackinac | Michigan | 26097 | 1426 | 14 |
1934886 | 1934886 | 2021-11-20 | Mackinac | Michigan | 26097 | 1426 | 14 |
1931636 | 1931636 | 2021-11-19 | Mackinac | Michigan | 26097 | 1426 | 14 |
1928385 | 1928385 | 2021-11-18 | Mackinac | Michigan | 26097 | 1412 | 14 |
1925135 | 1925135 | 2021-11-17 | Mackinac | Michigan | 26097 | 1412 | 14 |
1921886 | 1921886 | 2021-11-16 | Mackinac | Michigan | 26097 | 1396 | 14 |
1918636 | 1918636 | 2021-11-15 | Mackinac | Michigan | 26097 | 1396 | 14 |
1915417 | 1915417 | 2021-11-14 | Unknown | Michigan | 1374 | 14 | |
1912167 | 1912167 | 2021-11-13 | Unknown | Michigan | 1664 | 14 | |
1908917 | 1908917 | 2021-11-12 | Unknown | Michigan | 1664 | 14 | |
1899169 | 1899169 | 2021-11-09 | Unknown | Michigan | 1229 | 14 | |
1895919 | 1895919 | 2021-11-08 | Unknown | Michigan | 1513 | 14 | |
1892669 | 1892669 | 2021-11-07 | Unknown | Michigan | 1363 | 14 | |
1889419 | 1889419 | 2021-11-06 | Unknown | Michigan | 1488 | 14 | |
1886169 | 1886169 | 2021-11-05 | Unknown | Michigan | 1488 | 14 | |
1879671 | 1879671 | 2021-11-03 | Unknown | Michigan | 1434 | 14 | |
1873173 | 1873173 | 2021-11-01 | Unknown | Michigan | 1393 | 14 | |
1850430 | 1850430 | 2021-10-25 | Unknown | Michigan | 1181 | 14 | |
1827684 | 1827684 | 2021-10-18 | Unknown | Michigan | 1076 | 14 | |
1804940 | 1804940 | 2021-10-11 | Unknown | Michigan | 1032 | 14 | |
1801691 | 1801691 | 2021-10-10 | Unknown | Michigan | 938 | 14 | |
1798442 | 1798442 | 2021-10-09 | Unknown | Michigan | 938 | 14 | |
1795193 | 1795193 | 2021-10-08 | Unknown | Michigan | 938 | 14 | |
1710661 | 1710661 | 2021-09-12 | Crawford | Michigan | 26039 | 1081 | 14 |
1707414 | 1707414 | 2021-09-11 | Crawford | Michigan | 26039 | 1081 | 14 |
1704167 | 1704167 | 2021-09-10 | Crawford | Michigan | 26039 | 1081 | 14 |
1700917 | 1700917 | 2021-09-09 | Crawford | Michigan | 26039 | 1076 | 14 |
1697668 | 1697668 | 2021-09-08 | Crawford | Michigan | 26039 | 1076 | 14 |
1694420 | 1694420 | 2021-09-07 | Crawford | Michigan | 26039 | 1076 | 14 |
1691171 | 1691171 | 2021-09-06 | Crawford | Michigan | 26039 | 1059 | 14 |
1687921 | 1687921 | 2021-09-05 | Crawford | Michigan | 26039 | 1059 | 14 |
1684671 | 1684671 | 2021-09-04 | Crawford | Michigan | 26039 | 1059 | 14 |
1681420 | 1681420 | 2021-09-03 | Crawford | Michigan | 26039 | 1059 | 14 |
1678172 | 1678172 | 2021-09-02 | Crawford | Michigan | 26039 | 1056 | 14 |
1674924 | 1674924 | 2021-09-01 | Crawford | Michigan | 26039 | 1056 | 14 |
1671676 | 1671676 | 2021-08-31 | Crawford | Michigan | 26039 | 1051 | 14 |
1668429 | 1668429 | 2021-08-30 | Crawford | Michigan | 26039 | 1051 | 14 |
1665182 | 1665182 | 2021-08-29 | Crawford | Michigan | 26039 | 1043 | 14 |
1661934 | 1661934 | 2021-08-28 | Crawford | Michigan | 26039 | 1043 | 14 |
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);