ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 136 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1041805 | 1041805 | 2021-02-18 | Keweenaw | Michigan | 26083 | 136 | 2 |
1022332 | 1022332 | 2021-02-12 | Keweenaw | Michigan | 26083 | 136 | 2 |
720545 | 720545 | 2020-11-11 | Schoolcraft | Michigan | 26153 | 136 | 1 |
675068 | 675068 | 2020-10-28 | Antrim | Michigan | 26009 | 136 | 0 |
649155 | 649155 | 2020-10-20 | Leelanau | Michigan | 26089 | 136 | 2 |
642639 | 642639 | 2020-10-18 | Crawford | Michigan | 26039 | 136 | 5 |
639392 | 639392 | 2020-10-17 | Crawford | Michigan | 26039 | 136 | 5 |
636146 | 636146 | 2020-10-16 | Crawford | Michigan | 26039 | 136 | 5 |
613441 | 613441 | 2020-10-09 | Clare | Michigan | 26035 | 136 | 6 |
561613 | 561613 | 2020-09-23 | Mason | Michigan | 26105 | 136 | 0 |
545375 | 545375 | 2020-09-18 | Alpena | Michigan | 26007 | 136 | 14 |
529214 | 529214 | 2020-09-13 | Emmet | Michigan | 26047 | 136 | 4 |
525978 | 525978 | 2020-09-12 | Emmet | Michigan | 26047 | 136 | 4 |
522742 | 522742 | 2020-09-11 | Emmet | Michigan | 26047 | 136 | 4 |
519505 | 519505 | 2020-09-10 | Emmet | Michigan | 26047 | 136 | 4 |
480725 | 480725 | 2020-08-29 | Luce | Michigan | 26095 | 136 | 0 |
477493 | 477493 | 2020-08-28 | Luce | Michigan | 26095 | 136 | 0 |
441962 | 441962 | 2020-08-17 | Iosco | Michigan | 26069 | 136 | 12 |
438735 | 438735 | 2020-08-16 | Iosco | Michigan | 26069 | 136 | 12 |
435510 | 435510 | 2020-08-15 | Iosco | Michigan | 26069 | 136 | 12 |
432284 | 432284 | 2020-08-14 | Iosco | Michigan | 26069 | 136 | 12 |
393660 | 393660 | 2020-08-02 | Marquette | Michigan | 26103 | 136 | 11 |
361551 | 361551 | 2020-07-23 | Unknown | Michigan | 136 | 2 | |
348741 | 348741 | 2020-07-19 | Unknown | Michigan | 136 | 2 | |
329557 | 329557 | 2020-07-13 | Otsego | Michigan | 26137 | 136 | 10 |
307290 | 307290 | 2020-07-06 | Isabella | Michigan | 26073 | 136 | 8 |
282016 | 282016 | 2020-06-28 | Cass | Michigan | 26027 | 136 | 4 |
188922 | 188922 | 2020-05-29 | Van Buren | Michigan | 26159 | 136 | 6 |
167538 | 167538 | 2020-05-22 | Clinton | Michigan | 26037 | 136 | 10 |
161473 | 161473 | 2020-05-20 | Clinton | Michigan | 26037 | 136 | 10 |
158447 | 158447 | 2020-05-19 | Clinton | Michigan | 26037 | 136 | 10 |
128423 | 128423 | 2020-05-09 | Allegan | Michigan | 26005 | 136 | 2 |
110782 | 110782 | 2020-05-03 | Eaton | Michigan | 26045 | 136 | 6 |
110803 | 110803 | 2020-05-03 | Lenawee | Michigan | 26091 | 136 | 2 |
107910 | 107910 | 2020-05-02 | Eaton | Michigan | 26045 | 136 | 6 |
68495 | 68495 | 2020-04-18 | Calhoun | Michigan | 26025 | 136 | 5 |
68541 | 68541 | 2020-04-18 | Muskegon | Michigan | 26121 | 136 | 5 |
29403 | 29403 | 2020-04-03 | Kent | Michigan | 26081 | 136 | 2 |
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);