ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
648 rows where deaths = 11 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Marquette 107
- Lake 67
- Otsego 52
- St. Joseph 49
- Midland 41
- Keweenaw 40
- Alger 37
- Iosco 28
- Clinton 25
- Luce 16
- Eaton 15
- Gratiot 11
- Van Buren 11
- Leelanau 10
- Mecosta 9
- Crawford 8
- Charlevoix 7
- Kalkaska 6
- Arenac 5
- Kalamazoo 5
- Livingston 5
- Osceola 5
- Oscoda 5
- Gogebic 4
- Hillsdale 4
- Houghton 4
- Isabella 4
- Ogemaw 4
- Tuscola 4
- Antrim 3
- …
state 1
- Michigan · 648 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338095 | 2338095 | 2022-03-24 | Luce | Michigan | 26095 | 2280 | 11 |
2334841 | 2334841 | 2022-03-23 | Luce | Michigan | 26095 | 2280 | 11 |
2331587 | 2331587 | 2022-03-22 | Luce | Michigan | 26095 | 2280 | 11 |
2328335 | 2328335 | 2022-03-21 | Luce | Michigan | 26095 | 2280 | 11 |
2325082 | 2325082 | 2022-03-20 | Luce | Michigan | 26095 | 2280 | 11 |
2321828 | 2321828 | 2022-03-19 | Luce | Michigan | 26095 | 2280 | 11 |
2318574 | 2318574 | 2022-03-18 | Luce | Michigan | 26095 | 2280 | 11 |
2315321 | 2315321 | 2022-03-17 | Luce | Michigan | 26095 | 2280 | 11 |
2312068 | 2312068 | 2022-03-16 | Luce | Michigan | 26095 | 2280 | 11 |
2308815 | 2308815 | 2022-03-15 | Luce | Michigan | 26095 | 2278 | 11 |
2305564 | 2305564 | 2022-03-14 | Luce | Michigan | 26095 | 2278 | 11 |
2302312 | 2302312 | 2022-03-13 | Luce | Michigan | 26095 | 2277 | 11 |
2299060 | 2299060 | 2022-03-12 | Luce | Michigan | 26095 | 2277 | 11 |
2295808 | 2295808 | 2022-03-11 | Luce | Michigan | 26095 | 2277 | 11 |
2292556 | 2292556 | 2022-03-10 | Luce | Michigan | 26095 | 2275 | 11 |
2289304 | 2289304 | 2022-03-09 | Luce | Michigan | 26095 | 2275 | 11 |
2149410 | 2149410 | 2022-01-25 | Alger | Michigan | 26003 | 1686 | 11 |
2149450 | 2149450 | 2022-01-25 | Keweenaw | Michigan | 26083 | 462 | 11 |
2146158 | 2146158 | 2022-01-24 | Alger | Michigan | 26003 | 1686 | 11 |
2146198 | 2146198 | 2022-01-24 | Keweenaw | Michigan | 26083 | 462 | 11 |
2142903 | 2142903 | 2022-01-23 | Alger | Michigan | 26003 | 1654 | 11 |
2142943 | 2142943 | 2022-01-23 | Keweenaw | Michigan | 26083 | 454 | 11 |
2139648 | 2139648 | 2022-01-22 | Alger | Michigan | 26003 | 1654 | 11 |
2139688 | 2139688 | 2022-01-22 | Keweenaw | Michigan | 26083 | 454 | 11 |
2136392 | 2136392 | 2022-01-21 | Alger | Michigan | 26003 | 1654 | 11 |
2136432 | 2136432 | 2022-01-21 | Keweenaw | Michigan | 26083 | 454 | 11 |
2133140 | 2133140 | 2022-01-20 | Alger | Michigan | 26003 | 1620 | 11 |
2133180 | 2133180 | 2022-01-20 | Keweenaw | Michigan | 26083 | 445 | 11 |
2129887 | 2129887 | 2022-01-19 | Alger | Michigan | 26003 | 1620 | 11 |
2129927 | 2129927 | 2022-01-19 | Keweenaw | Michigan | 26083 | 445 | 11 |
2126633 | 2126633 | 2022-01-18 | Alger | Michigan | 26003 | 1490 | 11 |
2126673 | 2126673 | 2022-01-18 | Keweenaw | Michigan | 26083 | 419 | 11 |
2123381 | 2123381 | 2022-01-17 | Alger | Michigan | 26003 | 1490 | 11 |
2123421 | 2123421 | 2022-01-17 | Keweenaw | Michigan | 26083 | 419 | 11 |
2120129 | 2120129 | 2022-01-16 | Alger | Michigan | 26003 | 1490 | 11 |
2120169 | 2120169 | 2022-01-16 | Keweenaw | Michigan | 26083 | 419 | 11 |
2116877 | 2116877 | 2022-01-15 | Alger | Michigan | 26003 | 1490 | 11 |
2116917 | 2116917 | 2022-01-15 | Keweenaw | Michigan | 26083 | 419 | 11 |
2113626 | 2113626 | 2022-01-14 | Alger | Michigan | 26003 | 1490 | 11 |
2113666 | 2113666 | 2022-01-14 | Keweenaw | Michigan | 26083 | 419 | 11 |
2110374 | 2110374 | 2022-01-13 | Alger | Michigan | 26003 | 1414 | 11 |
2110414 | 2110414 | 2022-01-13 | Keweenaw | Michigan | 26083 | 409 | 11 |
2107123 | 2107123 | 2022-01-12 | Alger | Michigan | 26003 | 1414 | 11 |
2107163 | 2107163 | 2022-01-12 | Keweenaw | Michigan | 26083 | 409 | 11 |
2103872 | 2103872 | 2022-01-11 | Alger | Michigan | 26003 | 1367 | 11 |
2103912 | 2103912 | 2022-01-11 | Keweenaw | Michigan | 26083 | 407 | 11 |
2100621 | 2100621 | 2022-01-10 | Alger | Michigan | 26003 | 1367 | 11 |
2100661 | 2100661 | 2022-01-10 | Keweenaw | Michigan | 26083 | 407 | 11 |
2097370 | 2097370 | 2022-01-09 | Alger | Michigan | 26003 | 1346 | 11 |
2097410 | 2097410 | 2022-01-09 | Keweenaw | Michigan | 26083 | 405 | 11 |
2094118 | 2094118 | 2022-01-08 | Alger | Michigan | 26003 | 1346 | 11 |
2094158 | 2094158 | 2022-01-08 | Keweenaw | Michigan | 26083 | 405 | 11 |
2090866 | 2090866 | 2022-01-07 | Alger | Michigan | 26003 | 1346 | 11 |
2090906 | 2090906 | 2022-01-07 | Keweenaw | Michigan | 26083 | 405 | 11 |
2087615 | 2087615 | 2022-01-06 | Alger | Michigan | 26003 | 1308 | 11 |
2087655 | 2087655 | 2022-01-06 | Keweenaw | Michigan | 26083 | 405 | 11 |
2084363 | 2084363 | 2022-01-05 | Alger | Michigan | 26003 | 1308 | 11 |
2084403 | 2084403 | 2022-01-05 | Keweenaw | Michigan | 26083 | 405 | 11 |
2081111 | 2081111 | 2022-01-04 | Alger | Michigan | 26003 | 1284 | 11 |
2081151 | 2081151 | 2022-01-04 | Keweenaw | Michigan | 26083 | 398 | 11 |
2077859 | 2077859 | 2022-01-03 | Alger | Michigan | 26003 | 1284 | 11 |
2077899 | 2077899 | 2022-01-03 | Keweenaw | Michigan | 26083 | 398 | 11 |
2074608 | 2074608 | 2022-01-02 | Alger | Michigan | 26003 | 1247 | 11 |
2074648 | 2074648 | 2022-01-02 | Keweenaw | Michigan | 26083 | 391 | 11 |
2071357 | 2071357 | 2022-01-01 | Alger | Michigan | 26003 | 1247 | 11 |
2071397 | 2071397 | 2022-01-01 | Keweenaw | Michigan | 26083 | 391 | 11 |
2068106 | 2068106 | 2021-12-31 | Alger | Michigan | 26003 | 1247 | 11 |
2068146 | 2068146 | 2021-12-31 | Keweenaw | Michigan | 26083 | 391 | 11 |
2064855 | 2064855 | 2021-12-30 | Alger | Michigan | 26003 | 1247 | 11 |
2064895 | 2064895 | 2021-12-30 | Keweenaw | Michigan | 26083 | 391 | 11 |
2061605 | 2061605 | 2021-12-29 | Alger | Michigan | 26003 | 1247 | 11 |
2061645 | 2061645 | 2021-12-29 | Keweenaw | Michigan | 26083 | 391 | 11 |
2058356 | 2058356 | 2021-12-28 | Alger | Michigan | 26003 | 1231 | 11 |
2058396 | 2058396 | 2021-12-28 | Keweenaw | Michigan | 26083 | 389 | 11 |
2055107 | 2055107 | 2021-12-27 | Alger | Michigan | 26003 | 1231 | 11 |
2055147 | 2055147 | 2021-12-27 | Keweenaw | Michigan | 26083 | 389 | 11 |
2051857 | 2051857 | 2021-12-26 | Alger | Michigan | 26003 | 1217 | 11 |
2051897 | 2051897 | 2021-12-26 | Keweenaw | Michigan | 26083 | 387 | 11 |
2048607 | 2048607 | 2021-12-25 | Alger | Michigan | 26003 | 1217 | 11 |
2048647 | 2048647 | 2021-12-25 | Keweenaw | Michigan | 26083 | 387 | 11 |
2045357 | 2045357 | 2021-12-24 | Alger | Michigan | 26003 | 1217 | 11 |
2045397 | 2045397 | 2021-12-24 | Keweenaw | Michigan | 26083 | 387 | 11 |
2042107 | 2042107 | 2021-12-23 | Alger | Michigan | 26003 | 1217 | 11 |
2042147 | 2042147 | 2021-12-23 | Keweenaw | Michigan | 26083 | 387 | 11 |
2038858 | 2038858 | 2021-12-22 | Alger | Michigan | 26003 | 1217 | 11 |
2038898 | 2038898 | 2021-12-22 | Keweenaw | Michigan | 26083 | 387 | 11 |
2035608 | 2035608 | 2021-12-21 | Alger | Michigan | 26003 | 1208 | 11 |
2035648 | 2035648 | 2021-12-21 | Keweenaw | Michigan | 26083 | 387 | 11 |
2032358 | 2032358 | 2021-12-20 | Alger | Michigan | 26003 | 1208 | 11 |
2032398 | 2032398 | 2021-12-20 | Keweenaw | Michigan | 26083 | 387 | 11 |
2029147 | 2029147 | 2021-12-19 | Keweenaw | Michigan | 26083 | 386 | 11 |
2025896 | 2025896 | 2021-12-18 | Keweenaw | Michigan | 26083 | 386 | 11 |
2022645 | 2022645 | 2021-12-17 | Keweenaw | Michigan | 26083 | 386 | 11 |
1860146 | 1860146 | 2021-10-28 | Mackinac | Michigan | 26097 | 1294 | 11 |
1860177 | 1860177 | 2021-10-28 | Unknown | Michigan | 1011 | 11 | |
1856897 | 1856897 | 2021-10-27 | Mackinac | Michigan | 26097 | 1294 | 11 |
1272311 | 1272311 | 2021-04-30 | Crawford | Michigan | 26039 | 931 | 11 |
1269064 | 1269064 | 2021-04-29 | Crawford | Michigan | 26039 | 931 | 11 |
1265817 | 1265817 | 2021-04-28 | Crawford | Michigan | 26039 | 928 | 11 |
1262570 | 1262570 | 2021-04-27 | Crawford | Michigan | 26039 | 928 | 11 |
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);