ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where deaths = 247 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Michigan · 28 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110451 | 2110451 | 2022-01-13 | Tuscola | Michigan | 26157 | 10762 | 247 |
2107200 | 2107200 | 2022-01-12 | Tuscola | Michigan | 26157 | 10762 | 247 |
2035652 | 2035652 | 2021-12-21 | Lenawee | Michigan | 26091 | 18674 | 247 |
2032402 | 2032402 | 2021-12-20 | Lenawee | Michigan | 26091 | 18674 | 247 |
1882887 | 1882887 | 2021-11-04 | Livingston | Michigan | 26093 | 23976 | 247 |
1879638 | 1879638 | 2021-11-03 | Livingston | Michigan | 26093 | 23976 | 247 |
1876365 | 1876365 | 2021-11-02 | Eaton | Michigan | 26045 | 13451 | 247 |
1873116 | 1873116 | 2021-11-01 | Eaton | Michigan | 26045 | 13451 | 247 |
1869867 | 1869867 | 2021-10-31 | Eaton | Michigan | 26045 | 13325 | 247 |
1866618 | 1866618 | 2021-10-30 | Eaton | Michigan | 26045 | 13325 | 247 |
1863369 | 1863369 | 2021-10-29 | Eaton | Michigan | 26045 | 13325 | 247 |
1824399 | 1824399 | 2021-10-17 | Lapeer | Michigan | 26087 | 11723 | 247 |
1821150 | 1821150 | 2021-10-16 | Lapeer | Michigan | 26087 | 11723 | 247 |
1817901 | 1817901 | 2021-10-15 | Lapeer | Michigan | 26087 | 11723 | 247 |
1191114 | 1191114 | 2021-04-05 | Calhoun | Michigan | 26025 | 11554 | 247 |
1187866 | 1187866 | 2021-04-04 | Calhoun | Michigan | 26025 | 11443 | 247 |
1184619 | 1184619 | 2021-04-03 | Calhoun | Michigan | 26025 | 11443 | 247 |
1135910 | 1135910 | 2021-03-19 | Berrien | Michigan | 26021 | 12194 | 247 |
1132664 | 1132664 | 2021-03-18 | Berrien | Michigan | 26021 | 12113 | 247 |
1122923 | 1122923 | 2021-03-15 | Berrien | Michigan | 26021 | 11981 | 247 |
1119676 | 1119676 | 2021-03-14 | Berrien | Michigan | 26021 | 11959 | 247 |
1116429 | 1116429 | 2021-03-13 | Berrien | Michigan | 26021 | 11935 | 247 |
1061278 | 1061278 | 2021-02-24 | Jackson | Michigan | 26075 | 14090 | 247 |
892510 | 892510 | 2021-01-03 | Kalamazoo | Michigan | 26077 | 12437 | 247 |
889264 | 889264 | 2021-01-02 | Kalamazoo | Michigan | 26077 | 12437 | 247 |
733485 | 733485 | 2020-11-15 | Kent | Michigan | 26081 | 23631 | 247 |
730240 | 730240 | 2020-11-14 | Kent | Michigan | 26081 | 23631 | 247 |
182756 | 182756 | 2020-05-27 | Genesee | Michigan | 26049 | 1971 | 247 |
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);