ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
605 rows where deaths = 13 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Alger 92
- Keweenaw 63
- Clinton 58
- Charlevoix 51
- Unknown 46
- Alpena 34
- Schoolcraft 28
- Gratiot 19
- Grand Traverse 15
- Iosco 12
- Midland 12
- Ionia 10
- Montmorency 9
- Houghton 8
- Wexford 8
- Crawford 7
- Huron 7
- Lake 7
- Luce 7
- Montcalm 7
- Isabella 6
- Tuscola 5
- Van Buren 5
- Delta 4
- Emmet 4
- Kent 4
- Menominee 4
- Missaukee 4
- Muskegon 4
- Alcona 3
- …
state 1
- Michigan · 605 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500822 | 2500822 | 2022-05-13 | Alger | Michigan | 26003 | 1880 | 13 |
2497564 | 2497564 | 2022-05-12 | Alger | Michigan | 26003 | 1880 | 13 |
2494306 | 2494306 | 2022-05-11 | Alger | Michigan | 26003 | 1880 | 13 |
2491048 | 2491048 | 2022-05-10 | Alger | Michigan | 26003 | 1870 | 13 |
2487791 | 2487791 | 2022-05-09 | Alger | Michigan | 26003 | 1870 | 13 |
2484533 | 2484533 | 2022-05-08 | Alger | Michigan | 26003 | 1870 | 13 |
2481275 | 2481275 | 2022-05-07 | Alger | Michigan | 26003 | 1870 | 13 |
2478017 | 2478017 | 2022-05-06 | Alger | Michigan | 26003 | 1870 | 13 |
2474759 | 2474759 | 2022-05-05 | Alger | Michigan | 26003 | 1870 | 13 |
2471502 | 2471502 | 2022-05-04 | Alger | Michigan | 26003 | 1870 | 13 |
2468246 | 2468246 | 2022-05-03 | Alger | Michigan | 26003 | 1867 | 13 |
2464991 | 2464991 | 2022-05-02 | Alger | Michigan | 26003 | 1867 | 13 |
2461735 | 2461735 | 2022-05-01 | Alger | Michigan | 26003 | 1867 | 13 |
2458479 | 2458479 | 2022-04-30 | Alger | Michigan | 26003 | 1867 | 13 |
2455223 | 2455223 | 2022-04-29 | Alger | Michigan | 26003 | 1867 | 13 |
2451967 | 2451967 | 2022-04-28 | Alger | Michigan | 26003 | 1867 | 13 |
2448711 | 2448711 | 2022-04-27 | Alger | Michigan | 26003 | 1867 | 13 |
2445455 | 2445455 | 2022-04-26 | Alger | Michigan | 26003 | 1867 | 13 |
2445495 | 2445495 | 2022-04-26 | Keweenaw | Michigan | 26083 | 511 | 13 |
2442199 | 2442199 | 2022-04-25 | Alger | Michigan | 26003 | 1867 | 13 |
2442239 | 2442239 | 2022-04-25 | Keweenaw | Michigan | 26083 | 511 | 13 |
2438943 | 2438943 | 2022-04-24 | Alger | Michigan | 26003 | 1867 | 13 |
2438983 | 2438983 | 2022-04-24 | Keweenaw | Michigan | 26083 | 511 | 13 |
2435687 | 2435687 | 2022-04-23 | Alger | Michigan | 26003 | 1867 | 13 |
2435727 | 2435727 | 2022-04-23 | Keweenaw | Michigan | 26083 | 511 | 13 |
2432431 | 2432431 | 2022-04-22 | Alger | Michigan | 26003 | 1867 | 13 |
2432471 | 2432471 | 2022-04-22 | Keweenaw | Michigan | 26083 | 511 | 13 |
2429175 | 2429175 | 2022-04-21 | Alger | Michigan | 26003 | 1867 | 13 |
2429215 | 2429215 | 2022-04-21 | Keweenaw | Michigan | 26083 | 511 | 13 |
2425919 | 2425919 | 2022-04-20 | Alger | Michigan | 26003 | 1867 | 13 |
2425959 | 2425959 | 2022-04-20 | Keweenaw | Michigan | 26083 | 511 | 13 |
2422663 | 2422663 | 2022-04-19 | Alger | Michigan | 26003 | 1867 | 13 |
2422703 | 2422703 | 2022-04-19 | Keweenaw | Michigan | 26083 | 511 | 13 |
2419407 | 2419407 | 2022-04-18 | Alger | Michigan | 26003 | 1867 | 13 |
2419447 | 2419447 | 2022-04-18 | Keweenaw | Michigan | 26083 | 511 | 13 |
2416151 | 2416151 | 2022-04-17 | Alger | Michigan | 26003 | 1867 | 13 |
2416191 | 2416191 | 2022-04-17 | Keweenaw | Michigan | 26083 | 511 | 13 |
2412895 | 2412895 | 2022-04-16 | Alger | Michigan | 26003 | 1867 | 13 |
2412935 | 2412935 | 2022-04-16 | Keweenaw | Michigan | 26083 | 511 | 13 |
2409639 | 2409639 | 2022-04-15 | Alger | Michigan | 26003 | 1867 | 13 |
2409679 | 2409679 | 2022-04-15 | Keweenaw | Michigan | 26083 | 511 | 13 |
2406383 | 2406383 | 2022-04-14 | Alger | Michigan | 26003 | 1867 | 13 |
2406423 | 2406423 | 2022-04-14 | Keweenaw | Michigan | 26083 | 511 | 13 |
2403127 | 2403127 | 2022-04-13 | Alger | Michigan | 26003 | 1867 | 13 |
2403167 | 2403167 | 2022-04-13 | Keweenaw | Michigan | 26083 | 511 | 13 |
2399873 | 2399873 | 2022-04-12 | Alger | Michigan | 26003 | 1865 | 13 |
2399913 | 2399913 | 2022-04-12 | Keweenaw | Michigan | 26083 | 513 | 13 |
2399919 | 2399919 | 2022-04-12 | Luce | Michigan | 26095 | 2281 | 13 |
2396617 | 2396617 | 2022-04-11 | Alger | Michigan | 26003 | 1865 | 13 |
2396657 | 2396657 | 2022-04-11 | Keweenaw | Michigan | 26083 | 513 | 13 |
2396663 | 2396663 | 2022-04-11 | Luce | Michigan | 26095 | 2281 | 13 |
2393362 | 2393362 | 2022-04-10 | Alger | Michigan | 26003 | 1865 | 13 |
2393402 | 2393402 | 2022-04-10 | Keweenaw | Michigan | 26083 | 513 | 13 |
2393408 | 2393408 | 2022-04-10 | Luce | Michigan | 26095 | 2281 | 13 |
2390106 | 2390106 | 2022-04-09 | Alger | Michigan | 26003 | 1865 | 13 |
2390146 | 2390146 | 2022-04-09 | Keweenaw | Michigan | 26083 | 513 | 13 |
2390152 | 2390152 | 2022-04-09 | Luce | Michigan | 26095 | 2281 | 13 |
2386850 | 2386850 | 2022-04-08 | Alger | Michigan | 26003 | 1865 | 13 |
2386890 | 2386890 | 2022-04-08 | Keweenaw | Michigan | 26083 | 513 | 13 |
2386896 | 2386896 | 2022-04-08 | Luce | Michigan | 26095 | 2281 | 13 |
2383595 | 2383595 | 2022-04-07 | Alger | Michigan | 26003 | 1865 | 13 |
2383635 | 2383635 | 2022-04-07 | Keweenaw | Michigan | 26083 | 513 | 13 |
2383641 | 2383641 | 2022-04-07 | Luce | Michigan | 26095 | 2281 | 13 |
2380340 | 2380340 | 2022-04-06 | Alger | Michigan | 26003 | 1865 | 13 |
2380380 | 2380380 | 2022-04-06 | Keweenaw | Michigan | 26083 | 513 | 13 |
2380386 | 2380386 | 2022-04-06 | Luce | Michigan | 26095 | 2281 | 13 |
2377085 | 2377085 | 2022-04-05 | Alger | Michigan | 26003 | 1866 | 13 |
2377125 | 2377125 | 2022-04-05 | Keweenaw | Michigan | 26083 | 512 | 13 |
2373833 | 2373833 | 2022-04-04 | Alger | Michigan | 26003 | 1866 | 13 |
2373873 | 2373873 | 2022-04-04 | Keweenaw | Michigan | 26083 | 512 | 13 |
2370580 | 2370580 | 2022-04-03 | Alger | Michigan | 26003 | 1866 | 13 |
2370620 | 2370620 | 2022-04-03 | Keweenaw | Michigan | 26083 | 512 | 13 |
2367327 | 2367327 | 2022-04-02 | Alger | Michigan | 26003 | 1866 | 13 |
2367367 | 2367367 | 2022-04-02 | Keweenaw | Michigan | 26083 | 512 | 13 |
2364074 | 2364074 | 2022-04-01 | Alger | Michigan | 26003 | 1866 | 13 |
2364114 | 2364114 | 2022-04-01 | Keweenaw | Michigan | 26083 | 512 | 13 |
2360820 | 2360820 | 2022-03-31 | Alger | Michigan | 26003 | 1866 | 13 |
2360860 | 2360860 | 2022-03-31 | Keweenaw | Michigan | 26083 | 511 | 13 |
2357566 | 2357566 | 2022-03-30 | Alger | Michigan | 26003 | 1866 | 13 |
2357606 | 2357606 | 2022-03-30 | Keweenaw | Michigan | 26083 | 511 | 13 |
2354313 | 2354313 | 2022-03-29 | Alger | Michigan | 26003 | 1864 | 13 |
2354353 | 2354353 | 2022-03-29 | Keweenaw | Michigan | 26083 | 510 | 13 |
2351061 | 2351061 | 2022-03-28 | Alger | Michigan | 26003 | 1864 | 13 |
2351101 | 2351101 | 2022-03-28 | Keweenaw | Michigan | 26083 | 510 | 13 |
2347808 | 2347808 | 2022-03-27 | Alger | Michigan | 26003 | 1864 | 13 |
2347848 | 2347848 | 2022-03-27 | Keweenaw | Michigan | 26083 | 510 | 13 |
2344555 | 2344555 | 2022-03-26 | Alger | Michigan | 26003 | 1864 | 13 |
2344595 | 2344595 | 2022-03-26 | Keweenaw | Michigan | 26083 | 510 | 13 |
2341302 | 2341302 | 2022-03-25 | Alger | Michigan | 26003 | 1864 | 13 |
2341342 | 2341342 | 2022-03-25 | Keweenaw | Michigan | 26083 | 510 | 13 |
2338049 | 2338049 | 2022-03-24 | Alger | Michigan | 26003 | 1863 | 13 |
2338089 | 2338089 | 2022-03-24 | Keweenaw | Michigan | 26083 | 507 | 13 |
2334795 | 2334795 | 2022-03-23 | Alger | Michigan | 26003 | 1863 | 13 |
2334835 | 2334835 | 2022-03-23 | Keweenaw | Michigan | 26083 | 507 | 13 |
2331541 | 2331541 | 2022-03-22 | Alger | Michigan | 26003 | 1863 | 13 |
2331581 | 2331581 | 2022-03-22 | Keweenaw | Michigan | 26083 | 504 | 13 |
2328289 | 2328289 | 2022-03-21 | Alger | Michigan | 26003 | 1863 | 13 |
2328329 | 2328329 | 2022-03-21 | Keweenaw | Michigan | 26083 | 504 | 13 |
2325036 | 2325036 | 2022-03-20 | Alger | Michigan | 26003 | 1862 | 13 |
2325076 | 2325076 | 2022-03-20 | Keweenaw | Michigan | 26083 | 504 | 13 |
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);