ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where fips = 26119 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 ▼ |
---|---|---|---|---|---|---|---|
54921 | 54921 | 2020-04-13 | Montmorency | Michigan | 26119 | 1 | 0 |
57619 | 57619 | 2020-04-14 | Montmorency | Michigan | 26119 | 1 | 0 |
60329 | 60329 | 2020-04-15 | Montmorency | Michigan | 26119 | 1 | 0 |
63051 | 63051 | 2020-04-16 | Montmorency | Michigan | 26119 | 2 | 0 |
65789 | 65789 | 2020-04-17 | Montmorency | Michigan | 26119 | 3 | 0 |
68540 | 68540 | 2020-04-18 | Montmorency | Michigan | 26119 | 4 | 0 |
71304 | 71304 | 2020-04-19 | Montmorency | Michigan | 26119 | 4 | 0 |
74076 | 74076 | 2020-04-20 | Montmorency | Michigan | 26119 | 4 | 0 |
76856 | 76856 | 2020-04-21 | Montmorency | Michigan | 26119 | 4 | 0 |
79642 | 79642 | 2020-04-22 | Montmorency | Michigan | 26119 | 6 | 0 |
82437 | 82437 | 2020-04-23 | Montmorency | Michigan | 26119 | 5 | 0 |
85241 | 85241 | 2020-04-24 | Montmorency | Michigan | 26119 | 6 | 0 |
88051 | 88051 | 2020-04-25 | Montmorency | Michigan | 26119 | 5 | 0 |
90867 | 90867 | 2020-04-26 | Montmorency | Michigan | 26119 | 5 | 0 |
93688 | 93688 | 2020-04-27 | Montmorency | Michigan | 26119 | 5 | 0 |
96523 | 96523 | 2020-04-28 | Montmorency | Michigan | 26119 | 5 | 0 |
99369 | 99369 | 2020-04-29 | Montmorency | Michigan | 26119 | 5 | 0 |
102221 | 102221 | 2020-04-30 | Montmorency | Michigan | 26119 | 5 | 0 |
105081 | 105081 | 2020-05-01 | Montmorency | Michigan | 26119 | 5 | 0 |
107945 | 107945 | 2020-05-02 | Montmorency | Michigan | 26119 | 5 | 0 |
110817 | 110817 | 2020-05-03 | Montmorency | Michigan | 26119 | 5 | 0 |
113695 | 113695 | 2020-05-04 | Montmorency | Michigan | 26119 | 5 | 0 |
116576 | 116576 | 2020-05-05 | Montmorency | Michigan | 26119 | 5 | 0 |
119537 | 119537 | 2020-05-06 | Montmorency | Michigan | 26119 | 5 | 0 |
122509 | 122509 | 2020-05-07 | Montmorency | Michigan | 26119 | 5 | 0 |
125491 | 125491 | 2020-05-08 | Montmorency | Michigan | 26119 | 5 | 0 |
128478 | 128478 | 2020-05-09 | Montmorency | Michigan | 26119 | 5 | 0 |
131468 | 131468 | 2020-05-10 | Montmorency | Michigan | 26119 | 5 | 0 |
134459 | 134459 | 2020-05-11 | Montmorency | Michigan | 26119 | 5 | 0 |
137449 | 137449 | 2020-05-12 | Montmorency | Michigan | 26119 | 5 | 0 |
140443 | 140443 | 2020-05-13 | Montmorency | Michigan | 26119 | 5 | 0 |
143438 | 143438 | 2020-05-14 | Montmorency | Michigan | 26119 | 5 | 0 |
146438 | 146438 | 2020-05-15 | Montmorency | Michigan | 26119 | 5 | 0 |
149443 | 149443 | 2020-05-16 | Montmorency | Michigan | 26119 | 5 | 0 |
152454 | 152454 | 2020-05-17 | Montmorency | Michigan | 26119 | 5 | 0 |
155468 | 155468 | 2020-05-18 | Montmorency | Michigan | 26119 | 5 | 0 |
158486 | 158486 | 2020-05-19 | Montmorency | Michigan | 26119 | 5 | 0 |
161512 | 161512 | 2020-05-20 | Montmorency | Michigan | 26119 | 5 | 0 |
164541 | 164541 | 2020-05-21 | Montmorency | Michigan | 26119 | 5 | 0 |
167577 | 167577 | 2020-05-22 | Montmorency | Michigan | 26119 | 5 | 0 |
170614 | 170614 | 2020-05-23 | Montmorency | Michigan | 26119 | 5 | 0 |
173656 | 173656 | 2020-05-24 | Montmorency | Michigan | 26119 | 5 | 0 |
176699 | 176699 | 2020-05-25 | Montmorency | Michigan | 26119 | 5 | 0 |
179743 | 179743 | 2020-05-26 | Montmorency | Michigan | 26119 | 5 | 0 |
182789 | 182789 | 2020-05-27 | Montmorency | Michigan | 26119 | 5 | 0 |
185844 | 185844 | 2020-05-28 | Montmorency | Michigan | 26119 | 5 | 0 |
188902 | 188902 | 2020-05-29 | Montmorency | Michigan | 26119 | 5 | 0 |
191966 | 191966 | 2020-05-30 | Montmorency | Michigan | 26119 | 5 | 0 |
195034 | 195034 | 2020-05-31 | Montmorency | Michigan | 26119 | 5 | 0 |
198105 | 198105 | 2020-06-01 | Montmorency | Michigan | 26119 | 5 | 0 |
201178 | 201178 | 2020-06-02 | Montmorency | Michigan | 26119 | 5 | 0 |
204255 | 204255 | 2020-06-03 | Montmorency | Michigan | 26119 | 5 | 0 |
207336 | 207336 | 2020-06-04 | Montmorency | Michigan | 26119 | 5 | 0 |
210417 | 210417 | 2020-06-05 | Montmorency | Michigan | 26119 | 5 | 0 |
213501 | 213501 | 2020-06-06 | Montmorency | Michigan | 26119 | 5 | 0 |
216589 | 216589 | 2020-06-07 | Montmorency | Michigan | 26119 | 5 | 0 |
219681 | 219681 | 2020-06-08 | Montmorency | Michigan | 26119 | 5 | 0 |
222776 | 222776 | 2020-06-09 | Montmorency | Michigan | 26119 | 5 | 0 |
225874 | 225874 | 2020-06-10 | Montmorency | Michigan | 26119 | 5 | 0 |
228976 | 228976 | 2020-06-11 | Montmorency | Michigan | 26119 | 5 | 0 |
232080 | 232080 | 2020-06-12 | Montmorency | Michigan | 26119 | 5 | 0 |
235185 | 235185 | 2020-06-13 | Montmorency | Michigan | 26119 | 5 | 0 |
238292 | 238292 | 2020-06-14 | Montmorency | Michigan | 26119 | 5 | 0 |
241401 | 241401 | 2020-06-15 | Montmorency | Michigan | 26119 | 5 | 0 |
244512 | 244512 | 2020-06-16 | Montmorency | Michigan | 26119 | 5 | 0 |
247625 | 247625 | 2020-06-17 | Montmorency | Michigan | 26119 | 5 | 0 |
250737 | 250737 | 2020-06-18 | Montmorency | Michigan | 26119 | 5 | 0 |
253852 | 253852 | 2020-06-19 | Montmorency | Michigan | 26119 | 5 | 0 |
256972 | 256972 | 2020-06-20 | Montmorency | Michigan | 26119 | 5 | 0 |
260098 | 260098 | 2020-06-21 | Montmorency | Michigan | 26119 | 5 | 0 |
263227 | 263227 | 2020-06-22 | Montmorency | Michigan | 26119 | 5 | 0 |
266353 | 266353 | 2020-06-23 | Montmorency | Michigan | 26119 | 5 | 0 |
269486 | 269486 | 2020-06-24 | Montmorency | Michigan | 26119 | 5 | 0 |
272623 | 272623 | 2020-06-25 | Montmorency | Michigan | 26119 | 5 | 0 |
275766 | 275766 | 2020-06-26 | Montmorency | Michigan | 26119 | 5 | 0 |
278914 | 278914 | 2020-06-27 | Montmorency | Michigan | 26119 | 5 | 0 |
282062 | 282062 | 2020-06-28 | Montmorency | Michigan | 26119 | 5 | 0 |
285207 | 285207 | 2020-06-29 | Montmorency | Michigan | 26119 | 5 | 0 |
288357 | 288357 | 2020-06-30 | Montmorency | Michigan | 26119 | 5 | 0 |
291508 | 291508 | 2020-07-01 | Montmorency | Michigan | 26119 | 5 | 0 |
294662 | 294662 | 2020-07-02 | Montmorency | Michigan | 26119 | 5 | 0 |
297820 | 297820 | 2020-07-03 | Montmorency | Michigan | 26119 | 5 | 0 |
300982 | 300982 | 2020-07-04 | Montmorency | Michigan | 26119 | 5 | 0 |
304146 | 304146 | 2020-07-05 | Montmorency | Michigan | 26119 | 5 | 0 |
307313 | 307313 | 2020-07-06 | Montmorency | Michigan | 26119 | 5 | 0 |
310481 | 310481 | 2020-07-07 | Montmorency | Michigan | 26119 | 5 | 0 |
313651 | 313651 | 2020-07-08 | Montmorency | Michigan | 26119 | 5 | 0 |
316825 | 316825 | 2020-07-09 | Montmorency | Michigan | 26119 | 5 | 0 |
320000 | 320000 | 2020-07-10 | Montmorency | Michigan | 26119 | 6 | 0 |
323179 | 323179 | 2020-07-11 | Montmorency | Michigan | 26119 | 7 | 0 |
326362 | 326362 | 2020-07-12 | Montmorency | Michigan | 26119 | 7 | 0 |
329548 | 329548 | 2020-07-13 | Montmorency | Michigan | 26119 | 7 | 0 |
332735 | 332735 | 2020-07-14 | Montmorency | Michigan | 26119 | 7 | 0 |
335928 | 335928 | 2020-07-15 | Montmorency | Michigan | 26119 | 7 | 0 |
339124 | 339124 | 2020-07-16 | Montmorency | Michigan | 26119 | 8 | 0 |
342320 | 342320 | 2020-07-17 | Montmorency | Michigan | 26119 | 8 | 0 |
345520 | 345520 | 2020-07-18 | Montmorency | Michigan | 26119 | 7 | 0 |
348721 | 348721 | 2020-07-19 | Montmorency | Michigan | 26119 | 7 | 0 |
351921 | 351921 | 2020-07-20 | Montmorency | Michigan | 26119 | 7 | 0 |
355123 | 355123 | 2020-07-21 | Montmorency | Michigan | 26119 | 7 | 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);