ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 26097 and state = "Michigan" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
24837 | 24837 | 2020-04-01 | Mackinac | Michigan | 26097 | 1 | 0 |
27090 | 27090 | 2020-04-02 | Mackinac | Michigan | 26097 | 1 | 0 |
29409 | 29409 | 2020-04-03 | Mackinac | Michigan | 26097 | 2 | 0 |
31787 | 31787 | 2020-04-04 | Mackinac | Michigan | 26097 | 2 | 0 |
34212 | 34212 | 2020-04-05 | Mackinac | Michigan | 26097 | 2 | 0 |
36671 | 36671 | 2020-04-06 | Mackinac | Michigan | 26097 | 2 | 0 |
39179 | 39179 | 2020-04-07 | Mackinac | Michigan | 26097 | 3 | 0 |
41731 | 41731 | 2020-04-08 | Mackinac | Michigan | 26097 | 3 | 0 |
44307 | 44307 | 2020-04-09 | Mackinac | Michigan | 26097 | 4 | 0 |
46915 | 46915 | 2020-04-10 | Mackinac | Michigan | 26097 | 4 | 0 |
49559 | 49559 | 2020-04-11 | Mackinac | Michigan | 26097 | 4 | 0 |
52229 | 52229 | 2020-04-12 | Mackinac | Michigan | 26097 | 4 | 0 |
54910 | 54910 | 2020-04-13 | Mackinac | Michigan | 26097 | 4 | 0 |
57608 | 57608 | 2020-04-14 | Mackinac | Michigan | 26097 | 4 | 0 |
60318 | 60318 | 2020-04-15 | Mackinac | Michigan | 26097 | 4 | 0 |
63040 | 63040 | 2020-04-16 | Mackinac | Michigan | 26097 | 4 | 0 |
65778 | 65778 | 2020-04-17 | Mackinac | Michigan | 26097 | 5 | 0 |
68529 | 68529 | 2020-04-18 | Mackinac | Michigan | 26097 | 4 | 0 |
71293 | 71293 | 2020-04-19 | Mackinac | Michigan | 26097 | 4 | 0 |
74065 | 74065 | 2020-04-20 | Mackinac | Michigan | 26097 | 4 | 0 |
76845 | 76845 | 2020-04-21 | Mackinac | Michigan | 26097 | 4 | 0 |
79631 | 79631 | 2020-04-22 | Mackinac | Michigan | 26097 | 5 | 0 |
82426 | 82426 | 2020-04-23 | Mackinac | Michigan | 26097 | 5 | 0 |
85230 | 85230 | 2020-04-24 | Mackinac | Michigan | 26097 | 5 | 0 |
88040 | 88040 | 2020-04-25 | Mackinac | Michigan | 26097 | 5 | 0 |
90856 | 90856 | 2020-04-26 | Mackinac | Michigan | 26097 | 5 | 0 |
93677 | 93677 | 2020-04-27 | Mackinac | Michigan | 26097 | 5 | 0 |
96512 | 96512 | 2020-04-28 | Mackinac | Michigan | 26097 | 5 | 0 |
99358 | 99358 | 2020-04-29 | Mackinac | Michigan | 26097 | 6 | 0 |
102210 | 102210 | 2020-04-30 | Mackinac | Michigan | 26097 | 6 | 0 |
105070 | 105070 | 2020-05-01 | Mackinac | Michigan | 26097 | 6 | 0 |
107934 | 107934 | 2020-05-02 | Mackinac | Michigan | 26097 | 6 | 0 |
110806 | 110806 | 2020-05-03 | Mackinac | Michigan | 26097 | 6 | 0 |
113684 | 113684 | 2020-05-04 | Mackinac | Michigan | 26097 | 6 | 0 |
116565 | 116565 | 2020-05-05 | Mackinac | Michigan | 26097 | 6 | 0 |
119526 | 119526 | 2020-05-06 | Mackinac | Michigan | 26097 | 6 | 0 |
122498 | 122498 | 2020-05-07 | Mackinac | Michigan | 26097 | 6 | 0 |
125480 | 125480 | 2020-05-08 | Mackinac | Michigan | 26097 | 6 | 0 |
128467 | 128467 | 2020-05-09 | Mackinac | Michigan | 26097 | 6 | 0 |
131457 | 131457 | 2020-05-10 | Mackinac | Michigan | 26097 | 6 | 0 |
134448 | 134448 | 2020-05-11 | Mackinac | Michigan | 26097 | 6 | 0 |
137438 | 137438 | 2020-05-12 | Mackinac | Michigan | 26097 | 6 | 0 |
140432 | 140432 | 2020-05-13 | Mackinac | Michigan | 26097 | 6 | 0 |
143427 | 143427 | 2020-05-14 | Mackinac | Michigan | 26097 | 6 | 0 |
146427 | 146427 | 2020-05-15 | Mackinac | Michigan | 26097 | 6 | 0 |
149432 | 149432 | 2020-05-16 | Mackinac | Michigan | 26097 | 6 | 0 |
152443 | 152443 | 2020-05-17 | Mackinac | Michigan | 26097 | 6 | 0 |
155457 | 155457 | 2020-05-18 | Mackinac | Michigan | 26097 | 6 | 0 |
158475 | 158475 | 2020-05-19 | Mackinac | Michigan | 26097 | 6 | 0 |
161501 | 161501 | 2020-05-20 | Mackinac | Michigan | 26097 | 6 | 0 |
164530 | 164530 | 2020-05-21 | Mackinac | Michigan | 26097 | 6 | 0 |
167566 | 167566 | 2020-05-22 | Mackinac | Michigan | 26097 | 6 | 0 |
170603 | 170603 | 2020-05-23 | Mackinac | Michigan | 26097 | 6 | 0 |
173645 | 173645 | 2020-05-24 | Mackinac | Michigan | 26097 | 6 | 0 |
176688 | 176688 | 2020-05-25 | Mackinac | Michigan | 26097 | 6 | 0 |
179732 | 179732 | 2020-05-26 | Mackinac | Michigan | 26097 | 6 | 0 |
182778 | 182778 | 2020-05-27 | Mackinac | Michigan | 26097 | 6 | 0 |
185833 | 185833 | 2020-05-28 | Mackinac | Michigan | 26097 | 8 | 0 |
188891 | 188891 | 2020-05-29 | Mackinac | Michigan | 26097 | 8 | 0 |
191955 | 191955 | 2020-05-30 | Mackinac | Michigan | 26097 | 8 | 0 |
195023 | 195023 | 2020-05-31 | Mackinac | Michigan | 26097 | 8 | 0 |
198094 | 198094 | 2020-06-01 | Mackinac | Michigan | 26097 | 8 | 0 |
201167 | 201167 | 2020-06-02 | Mackinac | Michigan | 26097 | 8 | 0 |
204244 | 204244 | 2020-06-03 | Mackinac | Michigan | 26097 | 8 | 0 |
207325 | 207325 | 2020-06-04 | Mackinac | Michigan | 26097 | 8 | 0 |
210406 | 210406 | 2020-06-05 | Mackinac | Michigan | 26097 | 8 | 0 |
213490 | 213490 | 2020-06-06 | Mackinac | Michigan | 26097 | 8 | 0 |
216578 | 216578 | 2020-06-07 | Mackinac | Michigan | 26097 | 8 | 0 |
219670 | 219670 | 2020-06-08 | Mackinac | Michigan | 26097 | 8 | 0 |
222765 | 222765 | 2020-06-09 | Mackinac | Michigan | 26097 | 8 | 0 |
225863 | 225863 | 2020-06-10 | Mackinac | Michigan | 26097 | 8 | 0 |
228965 | 228965 | 2020-06-11 | Mackinac | Michigan | 26097 | 8 | 0 |
232069 | 232069 | 2020-06-12 | Mackinac | Michigan | 26097 | 8 | 0 |
235174 | 235174 | 2020-06-13 | Mackinac | Michigan | 26097 | 8 | 0 |
238281 | 238281 | 2020-06-14 | Mackinac | Michigan | 26097 | 8 | 0 |
241390 | 241390 | 2020-06-15 | Mackinac | Michigan | 26097 | 8 | 0 |
244501 | 244501 | 2020-06-16 | Mackinac | Michigan | 26097 | 8 | 0 |
247614 | 247614 | 2020-06-17 | Mackinac | Michigan | 26097 | 8 | 0 |
250726 | 250726 | 2020-06-18 | Mackinac | Michigan | 26097 | 8 | 0 |
253841 | 253841 | 2020-06-19 | Mackinac | Michigan | 26097 | 8 | 0 |
256961 | 256961 | 2020-06-20 | Mackinac | Michigan | 26097 | 8 | 0 |
260087 | 260087 | 2020-06-21 | Mackinac | Michigan | 26097 | 8 | 0 |
263216 | 263216 | 2020-06-22 | Mackinac | Michigan | 26097 | 8 | 0 |
266342 | 266342 | 2020-06-23 | Mackinac | Michigan | 26097 | 8 | 0 |
269475 | 269475 | 2020-06-24 | Mackinac | Michigan | 26097 | 8 | 0 |
272612 | 272612 | 2020-06-25 | Mackinac | Michigan | 26097 | 8 | 0 |
275755 | 275755 | 2020-06-26 | Mackinac | Michigan | 26097 | 8 | 0 |
278903 | 278903 | 2020-06-27 | Mackinac | Michigan | 26097 | 8 | 0 |
282051 | 282051 | 2020-06-28 | Mackinac | Michigan | 26097 | 8 | 0 |
285196 | 285196 | 2020-06-29 | Mackinac | Michigan | 26097 | 8 | 0 |
288346 | 288346 | 2020-06-30 | Mackinac | Michigan | 26097 | 9 | 0 |
291497 | 291497 | 2020-07-01 | Mackinac | Michigan | 26097 | 9 | 0 |
294651 | 294651 | 2020-07-02 | Mackinac | Michigan | 26097 | 9 | 0 |
297809 | 297809 | 2020-07-03 | Mackinac | Michigan | 26097 | 9 | 0 |
300971 | 300971 | 2020-07-04 | Mackinac | Michigan | 26097 | 9 | 0 |
304135 | 304135 | 2020-07-05 | Mackinac | Michigan | 26097 | 9 | 0 |
307302 | 307302 | 2020-07-06 | Mackinac | Michigan | 26097 | 9 | 0 |
310470 | 310470 | 2020-07-07 | Mackinac | Michigan | 26097 | 9 | 0 |
313640 | 313640 | 2020-07-08 | Mackinac | Michigan | 26097 | 9 | 0 |
316814 | 316814 | 2020-07-09 | Mackinac | Michigan | 26097 | 9 | 0 |
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);