ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 121 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
746429 | 746429 | 2020-11-19 | Alcona | Michigan | 26001 | 121 | 3 |
694529 | 694529 | 2020-11-03 | Arenac | Michigan | 26011 | 121 | 3 |
665374 | 665374 | 2020-10-25 | Kalkaska | Michigan | 26079 | 121 | 4 |
662129 | 662129 | 2020-10-24 | Kalkaska | Michigan | 26079 | 121 | 4 |
623194 | 623194 | 2020-10-12 | Leelanau | Michigan | 26089 | 121 | 1 |
607019 | 607019 | 2020-10-07 | Unknown | Michigan | 121 | 4 | |
558343 | 558343 | 2020-09-22 | Crawford | Michigan | 26039 | 121 | 5 |
506578 | 506578 | 2020-09-06 | Houghton | Michigan | 26061 | 121 | 3 |
503345 | 503345 | 2020-09-05 | Houghton | Michigan | 26061 | 121 | 3 |
496894 | 496894 | 2020-09-03 | Luce | Michigan | 26095 | 121 | 0 |
493661 | 493661 | 2020-09-02 | Luce | Michigan | 26095 | 121 | 0 |
493666 | 493666 | 2020-09-02 | Mason | Michigan | 26105 | 121 | 0 |
490427 | 490427 | 2020-09-01 | Luce | Michigan | 26095 | 121 | 0 |
490432 | 490432 | 2020-09-01 | Mason | Michigan | 26105 | 121 | 0 |
487194 | 487194 | 2020-08-31 | Luce | Michigan | 26095 | 121 | 0 |
483960 | 483960 | 2020-08-30 | Luce | Michigan | 26095 | 121 | 0 |
471054 | 471054 | 2020-08-26 | Sanilac | Michigan | 26151 | 121 | 7 |
454856 | 454856 | 2020-08-21 | Delta | Michigan | 26041 | 121 | 3 |
451628 | 451628 | 2020-08-20 | Delta | Michigan | 26041 | 121 | 3 |
348690 | 348690 | 2020-07-19 | Gratiot | Michigan | 26057 | 121 | 14 |
345489 | 345489 | 2020-07-18 | Gratiot | Michigan | 26057 | 121 | 14 |
323154 | 323154 | 2020-07-11 | Iosco | Michigan | 26069 | 121 | 11 |
319975 | 319975 | 2020-07-10 | Iosco | Michigan | 26069 | 121 | 11 |
313599 | 313599 | 2020-07-08 | Barry | Michigan | 26015 | 121 | 2 |
278891 | 278891 | 2020-06-27 | Isabella | Michigan | 26073 | 121 | 8 |
275743 | 275743 | 2020-06-26 | Isabella | Michigan | 26073 | 121 | 8 |
256926 | 256926 | 2020-06-20 | Cass | Michigan | 26027 | 121 | 4 |
216585 | 216585 | 2020-06-07 | Midland | Michigan | 26111 | 121 | 9 |
216591 | 216591 | 2020-06-07 | Newaygo | Michigan | 26123 | 121 | 0 |
213503 | 213503 | 2020-06-06 | Newaygo | Michigan | 26123 | 121 | 0 |
210419 | 210419 | 2020-06-05 | Newaygo | Michigan | 26123 | 121 | 0 |
173676 | 173676 | 2020-05-24 | Van Buren | Michigan | 26159 | 121 | 6 |
170634 | 170634 | 2020-05-23 | Van Buren | Michigan | 26159 | 121 | 6 |
149419 | 149419 | 2020-05-16 | Ionia | Michigan | 26067 | 121 | 3 |
99341 | 99341 | 2020-04-29 | Hillsdale | Michigan | 26059 | 121 | 17 |
76871 | 76871 | 2020-04-21 | Shiawassee | Michigan | 26155 | 121 | 3 |
29407 | 29407 | 2020-04-03 | Livingston | Michigan | 26093 | 121 | 2 |
24825 | 24825 | 2020-04-01 | Ingham | Michigan | 26065 | 121 | 1 |
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);