ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
756 rows where county = "Benzie" 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 ▼ |
---|---|---|---|---|---|---|---|
68492 | 68492 | 2020-04-18 | Benzie | Michigan | 26019 | 2 | 0 |
71256 | 71256 | 2020-04-19 | Benzie | Michigan | 26019 | 3 | 0 |
74028 | 74028 | 2020-04-20 | Benzie | Michigan | 26019 | 4 | 0 |
76808 | 76808 | 2020-04-21 | Benzie | Michigan | 26019 | 4 | 0 |
79594 | 79594 | 2020-04-22 | Benzie | Michigan | 26019 | 4 | 0 |
82389 | 82389 | 2020-04-23 | Benzie | Michigan | 26019 | 4 | 0 |
85193 | 85193 | 2020-04-24 | Benzie | Michigan | 26019 | 4 | 0 |
88003 | 88003 | 2020-04-25 | Benzie | Michigan | 26019 | 4 | 0 |
90819 | 90819 | 2020-04-26 | Benzie | Michigan | 26019 | 4 | 0 |
93640 | 93640 | 2020-04-27 | Benzie | Michigan | 26019 | 4 | 0 |
96475 | 96475 | 2020-04-28 | Benzie | Michigan | 26019 | 4 | 0 |
99321 | 99321 | 2020-04-29 | Benzie | Michigan | 26019 | 6 | 0 |
102173 | 102173 | 2020-04-30 | Benzie | Michigan | 26019 | 6 | 0 |
105033 | 105033 | 2020-05-01 | Benzie | Michigan | 26019 | 4 | 0 |
107897 | 107897 | 2020-05-02 | Benzie | Michigan | 26019 | 5 | 0 |
110769 | 110769 | 2020-05-03 | Benzie | Michigan | 26019 | 4 | 0 |
113647 | 113647 | 2020-05-04 | Benzie | Michigan | 26019 | 4 | 0 |
116528 | 116528 | 2020-05-05 | Benzie | Michigan | 26019 | 4 | 0 |
119489 | 119489 | 2020-05-06 | Benzie | Michigan | 26019 | 4 | 0 |
122461 | 122461 | 2020-05-07 | Benzie | Michigan | 26019 | 4 | 0 |
125443 | 125443 | 2020-05-08 | Benzie | Michigan | 26019 | 4 | 0 |
128430 | 128430 | 2020-05-09 | Benzie | Michigan | 26019 | 4 | 0 |
131420 | 131420 | 2020-05-10 | Benzie | Michigan | 26019 | 4 | 0 |
134411 | 134411 | 2020-05-11 | Benzie | Michigan | 26019 | 4 | 0 |
137401 | 137401 | 2020-05-12 | Benzie | Michigan | 26019 | 4 | 0 |
140395 | 140395 | 2020-05-13 | Benzie | Michigan | 26019 | 4 | 0 |
143390 | 143390 | 2020-05-14 | Benzie | Michigan | 26019 | 4 | 0 |
146390 | 146390 | 2020-05-15 | Benzie | Michigan | 26019 | 4 | 0 |
149395 | 149395 | 2020-05-16 | Benzie | Michigan | 26019 | 4 | 0 |
152406 | 152406 | 2020-05-17 | Benzie | Michigan | 26019 | 4 | 0 |
155420 | 155420 | 2020-05-18 | Benzie | Michigan | 26019 | 4 | 0 |
158438 | 158438 | 2020-05-19 | Benzie | Michigan | 26019 | 4 | 0 |
161464 | 161464 | 2020-05-20 | Benzie | Michigan | 26019 | 4 | 0 |
164493 | 164493 | 2020-05-21 | Benzie | Michigan | 26019 | 4 | 0 |
167529 | 167529 | 2020-05-22 | Benzie | Michigan | 26019 | 4 | 0 |
170566 | 170566 | 2020-05-23 | Benzie | Michigan | 26019 | 4 | 0 |
173608 | 173608 | 2020-05-24 | Benzie | Michigan | 26019 | 4 | 0 |
176651 | 176651 | 2020-05-25 | Benzie | Michigan | 26019 | 4 | 0 |
179695 | 179695 | 2020-05-26 | Benzie | Michigan | 26019 | 4 | 0 |
182741 | 182741 | 2020-05-27 | Benzie | Michigan | 26019 | 4 | 0 |
185796 | 185796 | 2020-05-28 | Benzie | Michigan | 26019 | 4 | 0 |
188854 | 188854 | 2020-05-29 | Benzie | Michigan | 26019 | 4 | 0 |
191918 | 191918 | 2020-05-30 | Benzie | Michigan | 26019 | 4 | 0 |
194986 | 194986 | 2020-05-31 | Benzie | Michigan | 26019 | 4 | 0 |
198057 | 198057 | 2020-06-01 | Benzie | Michigan | 26019 | 4 | 0 |
201129 | 201129 | 2020-06-02 | Benzie | Michigan | 26019 | 4 | 0 |
204206 | 204206 | 2020-06-03 | Benzie | Michigan | 26019 | 4 | 0 |
207287 | 207287 | 2020-06-04 | Benzie | Michigan | 26019 | 4 | 0 |
210368 | 210368 | 2020-06-05 | Benzie | Michigan | 26019 | 4 | 0 |
213452 | 213452 | 2020-06-06 | Benzie | Michigan | 26019 | 5 | 0 |
216540 | 216540 | 2020-06-07 | Benzie | Michigan | 26019 | 5 | 0 |
219632 | 219632 | 2020-06-08 | Benzie | Michigan | 26019 | 5 | 0 |
222727 | 222727 | 2020-06-09 | Benzie | Michigan | 26019 | 5 | 0 |
225824 | 225824 | 2020-06-10 | Benzie | Michigan | 26019 | 5 | 0 |
228926 | 228926 | 2020-06-11 | Benzie | Michigan | 26019 | 5 | 0 |
232030 | 232030 | 2020-06-12 | Benzie | Michigan | 26019 | 5 | 0 |
235135 | 235135 | 2020-06-13 | Benzie | Michigan | 26019 | 5 | 0 |
238242 | 238242 | 2020-06-14 | Benzie | Michigan | 26019 | 5 | 0 |
241351 | 241351 | 2020-06-15 | Benzie | Michigan | 26019 | 5 | 0 |
244462 | 244462 | 2020-06-16 | Benzie | Michigan | 26019 | 5 | 0 |
247575 | 247575 | 2020-06-17 | Benzie | Michigan | 26019 | 5 | 0 |
250687 | 250687 | 2020-06-18 | Benzie | Michigan | 26019 | 5 | 0 |
253802 | 253802 | 2020-06-19 | Benzie | Michigan | 26019 | 5 | 0 |
256922 | 256922 | 2020-06-20 | Benzie | Michigan | 26019 | 5 | 0 |
260048 | 260048 | 2020-06-21 | Benzie | Michigan | 26019 | 5 | 0 |
263177 | 263177 | 2020-06-22 | Benzie | Michigan | 26019 | 5 | 0 |
266303 | 266303 | 2020-06-23 | Benzie | Michigan | 26019 | 5 | 0 |
269436 | 269436 | 2020-06-24 | Benzie | Michigan | 26019 | 6 | 0 |
272573 | 272573 | 2020-06-25 | Benzie | Michigan | 26019 | 6 | 0 |
275716 | 275716 | 2020-06-26 | Benzie | Michigan | 26019 | 7 | 0 |
278864 | 278864 | 2020-06-27 | Benzie | Michigan | 26019 | 7 | 0 |
282012 | 282012 | 2020-06-28 | Benzie | Michigan | 26019 | 7 | 0 |
285157 | 285157 | 2020-06-29 | Benzie | Michigan | 26019 | 9 | 0 |
288307 | 288307 | 2020-06-30 | Benzie | Michigan | 26019 | 12 | 0 |
291458 | 291458 | 2020-07-01 | Benzie | Michigan | 26019 | 10 | 0 |
294612 | 294612 | 2020-07-02 | Benzie | Michigan | 26019 | 10 | 0 |
297770 | 297770 | 2020-07-03 | Benzie | Michigan | 26019 | 10 | 0 |
300932 | 300932 | 2020-07-04 | Benzie | Michigan | 26019 | 10 | 0 |
304096 | 304096 | 2020-07-05 | Benzie | Michigan | 26019 | 10 | 0 |
307263 | 307263 | 2020-07-06 | Benzie | Michigan | 26019 | 11 | 0 |
310431 | 310431 | 2020-07-07 | Benzie | Michigan | 26019 | 11 | 0 |
313601 | 313601 | 2020-07-08 | Benzie | Michigan | 26019 | 11 | 0 |
316775 | 316775 | 2020-07-09 | Benzie | Michigan | 26019 | 11 | 0 |
319950 | 319950 | 2020-07-10 | Benzie | Michigan | 26019 | 11 | 0 |
323129 | 323129 | 2020-07-11 | Benzie | Michigan | 26019 | 14 | 0 |
326312 | 326312 | 2020-07-12 | Benzie | Michigan | 26019 | 14 | 0 |
329498 | 329498 | 2020-07-13 | Benzie | Michigan | 26019 | 15 | 0 |
332685 | 332685 | 2020-07-14 | Benzie | Michigan | 26019 | 16 | 0 |
335878 | 335878 | 2020-07-15 | Benzie | Michigan | 26019 | 16 | 1 |
339074 | 339074 | 2020-07-16 | Benzie | Michigan | 26019 | 17 | 1 |
342270 | 342270 | 2020-07-17 | Benzie | Michigan | 26019 | 20 | 1 |
345470 | 345470 | 2020-07-18 | Benzie | Michigan | 26019 | 21 | 1 |
348671 | 348671 | 2020-07-19 | Benzie | Michigan | 26019 | 22 | 1 |
351871 | 351871 | 2020-07-20 | Benzie | Michigan | 26019 | 22 | 1 |
355073 | 355073 | 2020-07-21 | Benzie | Michigan | 26019 | 24 | 1 |
358276 | 358276 | 2020-07-22 | Benzie | Michigan | 26019 | 24 | 1 |
361481 | 361481 | 2020-07-23 | Benzie | Michigan | 26019 | 28 | 1 |
364688 | 364688 | 2020-07-24 | Benzie | Michigan | 26019 | 29 | 1 |
367895 | 367895 | 2020-07-25 | Benzie | Michigan | 26019 | 28 | 1 |
371105 | 371105 | 2020-07-26 | Benzie | Michigan | 26019 | 28 | 1 |
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);