ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 26031 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 ▼ |
---|---|---|---|---|---|---|---|
18502 | 18502 | 2020-03-29 | Cheboygan | Michigan | 26031 | 1 | 0 |
20519 | 20519 | 2020-03-30 | Cheboygan | Michigan | 26031 | 1 | 0 |
22630 | 22630 | 2020-03-31 | Cheboygan | Michigan | 26031 | 1 | 0 |
24809 | 24809 | 2020-04-01 | Cheboygan | Michigan | 26031 | 2 | 0 |
27061 | 27061 | 2020-04-02 | Cheboygan | Michigan | 26031 | 3 | 0 |
29379 | 29379 | 2020-04-03 | Cheboygan | Michigan | 26031 | 6 | 0 |
31757 | 31757 | 2020-04-04 | Cheboygan | Michigan | 26031 | 7 | 1 |
34182 | 34182 | 2020-04-05 | Cheboygan | Michigan | 26031 | 8 | 1 |
36641 | 36641 | 2020-04-06 | Cheboygan | Michigan | 26031 | 8 | 1 |
39149 | 39149 | 2020-04-07 | Cheboygan | Michigan | 26031 | 10 | 1 |
41701 | 41701 | 2020-04-08 | Cheboygan | Michigan | 26031 | 10 | 1 |
44277 | 44277 | 2020-04-09 | Cheboygan | Michigan | 26031 | 10 | 1 |
46885 | 46885 | 2020-04-10 | Cheboygan | Michigan | 26031 | 10 | 1 |
49528 | 49528 | 2020-04-11 | Cheboygan | Michigan | 26031 | 11 | 1 |
52198 | 52198 | 2020-04-12 | Cheboygan | Michigan | 26031 | 10 | 1 |
54879 | 54879 | 2020-04-13 | Cheboygan | Michigan | 26031 | 12 | 1 |
57577 | 57577 | 2020-04-14 | Cheboygan | Michigan | 26031 | 12 | 1 |
60287 | 60287 | 2020-04-15 | Cheboygan | Michigan | 26031 | 12 | 1 |
63009 | 63009 | 2020-04-16 | Cheboygan | Michigan | 26031 | 12 | 1 |
65747 | 65747 | 2020-04-17 | Cheboygan | Michigan | 26031 | 12 | 1 |
68498 | 68498 | 2020-04-18 | Cheboygan | Michigan | 26031 | 14 | 1 |
71262 | 71262 | 2020-04-19 | Cheboygan | Michigan | 26031 | 14 | 1 |
74034 | 74034 | 2020-04-20 | Cheboygan | Michigan | 26031 | 14 | 1 |
76814 | 76814 | 2020-04-21 | Cheboygan | Michigan | 26031 | 14 | 1 |
79600 | 79600 | 2020-04-22 | Cheboygan | Michigan | 26031 | 14 | 1 |
82395 | 82395 | 2020-04-23 | Cheboygan | Michigan | 26031 | 14 | 1 |
85199 | 85199 | 2020-04-24 | Cheboygan | Michigan | 26031 | 15 | 1 |
88009 | 88009 | 2020-04-25 | Cheboygan | Michigan | 26031 | 17 | 1 |
90825 | 90825 | 2020-04-26 | Cheboygan | Michigan | 26031 | 17 | 1 |
93646 | 93646 | 2020-04-27 | Cheboygan | Michigan | 26031 | 17 | 1 |
96481 | 96481 | 2020-04-28 | Cheboygan | Michigan | 26031 | 17 | 1 |
99327 | 99327 | 2020-04-29 | Cheboygan | Michigan | 26031 | 17 | 1 |
102179 | 102179 | 2020-04-30 | Cheboygan | Michigan | 26031 | 19 | 1 |
105039 | 105039 | 2020-05-01 | Cheboygan | Michigan | 26031 | 19 | 1 |
107903 | 107903 | 2020-05-02 | Cheboygan | Michigan | 26031 | 19 | 1 |
110775 | 110775 | 2020-05-03 | Cheboygan | Michigan | 26031 | 19 | 1 |
113653 | 113653 | 2020-05-04 | Cheboygan | Michigan | 26031 | 19 | 1 |
116534 | 116534 | 2020-05-05 | Cheboygan | Michigan | 26031 | 19 | 1 |
119495 | 119495 | 2020-05-06 | Cheboygan | Michigan | 26031 | 19 | 1 |
122467 | 122467 | 2020-05-07 | Cheboygan | Michigan | 26031 | 19 | 1 |
125449 | 125449 | 2020-05-08 | Cheboygan | Michigan | 26031 | 19 | 1 |
128436 | 128436 | 2020-05-09 | Cheboygan | Michigan | 26031 | 19 | 1 |
131426 | 131426 | 2020-05-10 | Cheboygan | Michigan | 26031 | 19 | 1 |
134417 | 134417 | 2020-05-11 | Cheboygan | Michigan | 26031 | 19 | 1 |
137407 | 137407 | 2020-05-12 | Cheboygan | Michigan | 26031 | 19 | 1 |
140401 | 140401 | 2020-05-13 | Cheboygan | Michigan | 26031 | 19 | 1 |
143396 | 143396 | 2020-05-14 | Cheboygan | Michigan | 26031 | 19 | 1 |
146396 | 146396 | 2020-05-15 | Cheboygan | Michigan | 26031 | 19 | 1 |
149401 | 149401 | 2020-05-16 | Cheboygan | Michigan | 26031 | 19 | 1 |
152412 | 152412 | 2020-05-17 | Cheboygan | Michigan | 26031 | 19 | 1 |
155426 | 155426 | 2020-05-18 | Cheboygan | Michigan | 26031 | 19 | 1 |
158444 | 158444 | 2020-05-19 | Cheboygan | Michigan | 26031 | 19 | 1 |
161470 | 161470 | 2020-05-20 | Cheboygan | Michigan | 26031 | 21 | 1 |
164499 | 164499 | 2020-05-21 | Cheboygan | Michigan | 26031 | 21 | 1 |
167535 | 167535 | 2020-05-22 | Cheboygan | Michigan | 26031 | 21 | 1 |
170572 | 170572 | 2020-05-23 | Cheboygan | Michigan | 26031 | 21 | 1 |
173614 | 173614 | 2020-05-24 | Cheboygan | Michigan | 26031 | 21 | 1 |
176657 | 176657 | 2020-05-25 | Cheboygan | Michigan | 26031 | 21 | 1 |
179701 | 179701 | 2020-05-26 | Cheboygan | Michigan | 26031 | 21 | 1 |
182747 | 182747 | 2020-05-27 | Cheboygan | Michigan | 26031 | 21 | 1 |
185802 | 185802 | 2020-05-28 | Cheboygan | Michigan | 26031 | 21 | 1 |
188860 | 188860 | 2020-05-29 | Cheboygan | Michigan | 26031 | 21 | 1 |
191924 | 191924 | 2020-05-30 | Cheboygan | Michigan | 26031 | 21 | 1 |
194992 | 194992 | 2020-05-31 | Cheboygan | Michigan | 26031 | 21 | 1 |
198063 | 198063 | 2020-06-01 | Cheboygan | Michigan | 26031 | 26 | 1 |
201135 | 201135 | 2020-06-02 | Cheboygan | Michigan | 26031 | 26 | 1 |
204212 | 204212 | 2020-06-03 | Cheboygan | Michigan | 26031 | 26 | 1 |
207293 | 207293 | 2020-06-04 | Cheboygan | Michigan | 26031 | 26 | 1 |
210374 | 210374 | 2020-06-05 | Cheboygan | Michigan | 26031 | 26 | 1 |
213458 | 213458 | 2020-06-06 | Cheboygan | Michigan | 26031 | 26 | 1 |
216546 | 216546 | 2020-06-07 | Cheboygan | Michigan | 26031 | 26 | 1 |
219638 | 219638 | 2020-06-08 | Cheboygan | Michigan | 26031 | 26 | 1 |
222733 | 222733 | 2020-06-09 | Cheboygan | Michigan | 26031 | 26 | 1 |
225830 | 225830 | 2020-06-10 | Cheboygan | Michigan | 26031 | 26 | 1 |
228932 | 228932 | 2020-06-11 | Cheboygan | Michigan | 26031 | 26 | 1 |
232036 | 232036 | 2020-06-12 | Cheboygan | Michigan | 26031 | 26 | 1 |
235141 | 235141 | 2020-06-13 | Cheboygan | Michigan | 26031 | 26 | 1 |
238248 | 238248 | 2020-06-14 | Cheboygan | Michigan | 26031 | 26 | 1 |
241357 | 241357 | 2020-06-15 | Cheboygan | Michigan | 26031 | 26 | 1 |
244468 | 244468 | 2020-06-16 | Cheboygan | Michigan | 26031 | 26 | 1 |
247581 | 247581 | 2020-06-17 | Cheboygan | Michigan | 26031 | 26 | 1 |
250693 | 250693 | 2020-06-18 | Cheboygan | Michigan | 26031 | 26 | 2 |
253808 | 253808 | 2020-06-19 | Cheboygan | Michigan | 26031 | 26 | 2 |
256928 | 256928 | 2020-06-20 | Cheboygan | Michigan | 26031 | 26 | 2 |
260054 | 260054 | 2020-06-21 | Cheboygan | Michigan | 26031 | 26 | 2 |
263183 | 263183 | 2020-06-22 | Cheboygan | Michigan | 26031 | 26 | 2 |
266309 | 266309 | 2020-06-23 | Cheboygan | Michigan | 26031 | 26 | 2 |
269442 | 269442 | 2020-06-24 | Cheboygan | Michigan | 26031 | 26 | 2 |
272579 | 272579 | 2020-06-25 | Cheboygan | Michigan | 26031 | 27 | 2 |
275722 | 275722 | 2020-06-26 | Cheboygan | Michigan | 26031 | 27 | 2 |
278870 | 278870 | 2020-06-27 | Cheboygan | Michigan | 26031 | 28 | 2 |
282018 | 282018 | 2020-06-28 | Cheboygan | Michigan | 26031 | 27 | 2 |
285163 | 285163 | 2020-06-29 | Cheboygan | Michigan | 26031 | 27 | 2 |
288313 | 288313 | 2020-06-30 | Cheboygan | Michigan | 26031 | 27 | 2 |
291464 | 291464 | 2020-07-01 | Cheboygan | Michigan | 26031 | 27 | 2 |
294618 | 294618 | 2020-07-02 | Cheboygan | Michigan | 26031 | 27 | 2 |
297776 | 297776 | 2020-07-03 | Cheboygan | Michigan | 26031 | 27 | 2 |
300938 | 300938 | 2020-07-04 | Cheboygan | Michigan | 26031 | 27 | 2 |
304102 | 304102 | 2020-07-05 | Cheboygan | Michigan | 26031 | 27 | 2 |
307269 | 307269 | 2020-07-06 | Cheboygan | Michigan | 26031 | 28 | 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);