ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Alpena" and state = "Michigan" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
49518 | 49518 | 2020-04-11 | Alpena | Michigan | 26007 | 1 | 0 |
52188 | 52188 | 2020-04-12 | Alpena | Michigan | 26007 | 1 | 0 |
54869 | 54869 | 2020-04-13 | Alpena | Michigan | 26007 | 1 | 0 |
57567 | 57567 | 2020-04-14 | Alpena | Michigan | 26007 | 1 | 0 |
60277 | 60277 | 2020-04-15 | Alpena | Michigan | 26007 | 1 | 0 |
62998 | 62998 | 2020-04-16 | Alpena | Michigan | 26007 | 2 | 0 |
65736 | 65736 | 2020-04-17 | Alpena | Michigan | 26007 | 2 | 1 |
68486 | 68486 | 2020-04-18 | Alpena | Michigan | 26007 | 2 | 1 |
71250 | 71250 | 2020-04-19 | Alpena | Michigan | 26007 | 14 | 1 |
74022 | 74022 | 2020-04-20 | Alpena | Michigan | 26007 | 15 | 1 |
76802 | 76802 | 2020-04-21 | Alpena | Michigan | 26007 | 35 | 1 |
79588 | 79588 | 2020-04-22 | Alpena | Michigan | 26007 | 38 | 1 |
82383 | 82383 | 2020-04-23 | Alpena | Michigan | 26007 | 47 | 1 |
85187 | 85187 | 2020-04-24 | Alpena | Michigan | 26007 | 60 | 2 |
87997 | 87997 | 2020-04-25 | Alpena | Michigan | 26007 | 60 | 2 |
90813 | 90813 | 2020-04-26 | Alpena | Michigan | 26007 | 60 | 2 |
93634 | 93634 | 2020-04-27 | Alpena | Michigan | 26007 | 60 | 2 |
96469 | 96469 | 2020-04-28 | Alpena | Michigan | 26007 | 67 | 4 |
99315 | 99315 | 2020-04-29 | Alpena | Michigan | 26007 | 76 | 4 |
102167 | 102167 | 2020-04-30 | Alpena | Michigan | 26007 | 82 | 5 |
105027 | 105027 | 2020-05-01 | Alpena | Michigan | 26007 | 82 | 6 |
107891 | 107891 | 2020-05-02 | Alpena | Michigan | 26007 | 82 | 6 |
110763 | 110763 | 2020-05-03 | Alpena | Michigan | 26007 | 83 | 6 |
113641 | 113641 | 2020-05-04 | Alpena | Michigan | 26007 | 83 | 7 |
116522 | 116522 | 2020-05-05 | Alpena | Michigan | 26007 | 85 | 7 |
119483 | 119483 | 2020-05-06 | Alpena | Michigan | 26007 | 86 | 7 |
122455 | 122455 | 2020-05-07 | Alpena | Michigan | 26007 | 86 | 8 |
125437 | 125437 | 2020-05-08 | Alpena | Michigan | 26007 | 86 | 8 |
128424 | 128424 | 2020-05-09 | Alpena | Michigan | 26007 | 87 | 8 |
131414 | 131414 | 2020-05-10 | Alpena | Michigan | 26007 | 87 | 8 |
134405 | 134405 | 2020-05-11 | Alpena | Michigan | 26007 | 87 | 8 |
137395 | 137395 | 2020-05-12 | Alpena | Michigan | 26007 | 87 | 8 |
140389 | 140389 | 2020-05-13 | Alpena | Michigan | 26007 | 88 | 8 |
143384 | 143384 | 2020-05-14 | Alpena | Michigan | 26007 | 88 | 8 |
146384 | 146384 | 2020-05-15 | Alpena | Michigan | 26007 | 90 | 8 |
149389 | 149389 | 2020-05-16 | Alpena | Michigan | 26007 | 91 | 9 |
152400 | 152400 | 2020-05-17 | Alpena | Michigan | 26007 | 91 | 9 |
155414 | 155414 | 2020-05-18 | Alpena | Michigan | 26007 | 91 | 9 |
158432 | 158432 | 2020-05-19 | Alpena | Michigan | 26007 | 91 | 9 |
161458 | 161458 | 2020-05-20 | Alpena | Michigan | 26007 | 91 | 9 |
164487 | 164487 | 2020-05-21 | Alpena | Michigan | 26007 | 92 | 9 |
167523 | 167523 | 2020-05-22 | Alpena | Michigan | 26007 | 93 | 9 |
170560 | 170560 | 2020-05-23 | Alpena | Michigan | 26007 | 94 | 9 |
185790 | 185790 | 2020-05-28 | Alpena | Michigan | 26007 | 94 | 9 |
188848 | 188848 | 2020-05-29 | Alpena | Michigan | 26007 | 94 | 9 |
191912 | 191912 | 2020-05-30 | Alpena | Michigan | 26007 | 94 | 9 |
194980 | 194980 | 2020-05-31 | Alpena | Michigan | 26007 | 94 | 9 |
173602 | 173602 | 2020-05-24 | Alpena | Michigan | 26007 | 95 | 9 |
176645 | 176645 | 2020-05-25 | Alpena | Michigan | 26007 | 95 | 9 |
179689 | 179689 | 2020-05-26 | Alpena | Michigan | 26007 | 95 | 9 |
182735 | 182735 | 2020-05-27 | Alpena | Michigan | 26007 | 95 | 9 |
198051 | 198051 | 2020-06-01 | Alpena | Michigan | 26007 | 103 | 9 |
201123 | 201123 | 2020-06-02 | Alpena | Michigan | 26007 | 103 | 9 |
210362 | 210362 | 2020-06-05 | Alpena | Michigan | 26007 | 103 | 9 |
204200 | 204200 | 2020-06-03 | Alpena | Michigan | 26007 | 104 | 9 |
207281 | 207281 | 2020-06-04 | Alpena | Michigan | 26007 | 104 | 9 |
213446 | 213446 | 2020-06-06 | Alpena | Michigan | 26007 | 104 | 9 |
216534 | 216534 | 2020-06-07 | Alpena | Michigan | 26007 | 104 | 9 |
219626 | 219626 | 2020-06-08 | Alpena | Michigan | 26007 | 107 | 9 |
222721 | 222721 | 2020-06-09 | Alpena | Michigan | 26007 | 108 | 9 |
225818 | 225818 | 2020-06-10 | Alpena | Michigan | 26007 | 113 | 9 |
228920 | 228920 | 2020-06-11 | Alpena | Michigan | 26007 | 114 | 11 |
232024 | 232024 | 2020-06-12 | Alpena | Michigan | 26007 | 115 | 12 |
235129 | 235129 | 2020-06-13 | Alpena | Michigan | 26007 | 115 | 12 |
238236 | 238236 | 2020-06-14 | Alpena | Michigan | 26007 | 115 | 12 |
241345 | 241345 | 2020-06-15 | Alpena | Michigan | 26007 | 115 | 13 |
244456 | 244456 | 2020-06-16 | Alpena | Michigan | 26007 | 115 | 12 |
247569 | 247569 | 2020-06-17 | Alpena | Michigan | 26007 | 115 | 12 |
250681 | 250681 | 2020-06-18 | Alpena | Michigan | 26007 | 115 | 12 |
253796 | 253796 | 2020-06-19 | Alpena | Michigan | 26007 | 115 | 12 |
256916 | 256916 | 2020-06-20 | Alpena | Michigan | 26007 | 115 | 12 |
260042 | 260042 | 2020-06-21 | Alpena | Michigan | 26007 | 115 | 12 |
263171 | 263171 | 2020-06-22 | Alpena | Michigan | 26007 | 116 | 12 |
266297 | 266297 | 2020-06-23 | Alpena | Michigan | 26007 | 116 | 12 |
269430 | 269430 | 2020-06-24 | Alpena | Michigan | 26007 | 116 | 12 |
272567 | 272567 | 2020-06-25 | Alpena | Michigan | 26007 | 117 | 12 |
275710 | 275710 | 2020-06-26 | Alpena | Michigan | 26007 | 117 | 12 |
278858 | 278858 | 2020-06-27 | Alpena | Michigan | 26007 | 117 | 12 |
282006 | 282006 | 2020-06-28 | Alpena | Michigan | 26007 | 118 | 12 |
285151 | 285151 | 2020-06-29 | Alpena | Michigan | 26007 | 119 | 12 |
288301 | 288301 | 2020-06-30 | Alpena | Michigan | 26007 | 120 | 12 |
291452 | 291452 | 2020-07-01 | Alpena | Michigan | 26007 | 122 | 12 |
294606 | 294606 | 2020-07-02 | Alpena | Michigan | 26007 | 122 | 12 |
297764 | 297764 | 2020-07-03 | Alpena | Michigan | 26007 | 123 | 12 |
300926 | 300926 | 2020-07-04 | Alpena | Michigan | 26007 | 123 | 12 |
304090 | 304090 | 2020-07-05 | Alpena | Michigan | 26007 | 123 | 12 |
307257 | 307257 | 2020-07-06 | Alpena | Michigan | 26007 | 123 | 12 |
310425 | 310425 | 2020-07-07 | Alpena | Michigan | 26007 | 123 | 12 |
313595 | 313595 | 2020-07-08 | Alpena | Michigan | 26007 | 123 | 12 |
316769 | 316769 | 2020-07-09 | Alpena | Michigan | 26007 | 123 | 12 |
319944 | 319944 | 2020-07-10 | Alpena | Michigan | 26007 | 123 | 12 |
323123 | 323123 | 2020-07-11 | Alpena | Michigan | 26007 | 123 | 12 |
326306 | 326306 | 2020-07-12 | Alpena | Michigan | 26007 | 123 | 12 |
329492 | 329492 | 2020-07-13 | Alpena | Michigan | 26007 | 123 | 12 |
332679 | 332679 | 2020-07-14 | Alpena | Michigan | 26007 | 123 | 12 |
335872 | 335872 | 2020-07-15 | Alpena | Michigan | 26007 | 123 | 12 |
339068 | 339068 | 2020-07-16 | Alpena | Michigan | 26007 | 124 | 13 |
342264 | 342264 | 2020-07-17 | Alpena | Michigan | 26007 | 125 | 13 |
345464 | 345464 | 2020-07-18 | Alpena | Michigan | 26007 | 125 | 13 |
348665 | 348665 | 2020-07-19 | Alpena | Michigan | 26007 | 125 | 13 |
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);