ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 26069 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 ▼ |
---|---|---|---|---|---|---|---|
11487 | 11487 | 2020-03-25 | Iosco | Michigan | 26069 | 1 | 0 |
13070 | 13070 | 2020-03-26 | Iosco | Michigan | 26069 | 1 | 0 |
14782 | 14782 | 2020-03-27 | Iosco | Michigan | 26069 | 1 | 0 |
16602 | 16602 | 2020-03-28 | Iosco | Michigan | 26069 | 1 | 0 |
18518 | 18518 | 2020-03-29 | Iosco | Michigan | 26069 | 1 | 0 |
20537 | 20537 | 2020-03-30 | Iosco | Michigan | 26069 | 1 | 0 |
22648 | 22648 | 2020-03-31 | Iosco | Michigan | 26069 | 1 | 0 |
24827 | 24827 | 2020-04-01 | Iosco | Michigan | 26069 | 1 | 0 |
27080 | 27080 | 2020-04-02 | Iosco | Michigan | 26069 | 1 | 0 |
29398 | 29398 | 2020-04-03 | Iosco | Michigan | 26069 | 1 | 0 |
31776 | 31776 | 2020-04-04 | Iosco | Michigan | 26069 | 2 | 1 |
34201 | 34201 | 2020-04-05 | Iosco | Michigan | 26069 | 3 | 1 |
36660 | 36660 | 2020-04-06 | Iosco | Michigan | 26069 | 3 | 1 |
39168 | 39168 | 2020-04-07 | Iosco | Michigan | 26069 | 4 | 1 |
41720 | 41720 | 2020-04-08 | Iosco | Michigan | 26069 | 4 | 1 |
44296 | 44296 | 2020-04-09 | Iosco | Michigan | 26069 | 4 | 1 |
46904 | 46904 | 2020-04-10 | Iosco | Michigan | 26069 | 4 | 1 |
49547 | 49547 | 2020-04-11 | Iosco | Michigan | 26069 | 5 | 1 |
52217 | 52217 | 2020-04-12 | Iosco | Michigan | 26069 | 4 | 1 |
54898 | 54898 | 2020-04-13 | Iosco | Michigan | 26069 | 4 | 1 |
57596 | 57596 | 2020-04-14 | Iosco | Michigan | 26069 | 4 | 1 |
60306 | 60306 | 2020-04-15 | Iosco | Michigan | 26069 | 4 | 1 |
63028 | 63028 | 2020-04-16 | Iosco | Michigan | 26069 | 6 | 1 |
65766 | 65766 | 2020-04-17 | Iosco | Michigan | 26069 | 8 | 1 |
68517 | 68517 | 2020-04-18 | Iosco | Michigan | 26069 | 11 | 1 |
71281 | 71281 | 2020-04-19 | Iosco | Michigan | 26069 | 11 | 1 |
74053 | 74053 | 2020-04-20 | Iosco | Michigan | 26069 | 13 | 2 |
76833 | 76833 | 2020-04-21 | Iosco | Michigan | 26069 | 15 | 2 |
79619 | 79619 | 2020-04-22 | Iosco | Michigan | 26069 | 15 | 2 |
82414 | 82414 | 2020-04-23 | Iosco | Michigan | 26069 | 21 | 3 |
85218 | 85218 | 2020-04-24 | Iosco | Michigan | 26069 | 29 | 4 |
88028 | 88028 | 2020-04-25 | Iosco | Michigan | 26069 | 29 | 4 |
90844 | 90844 | 2020-04-26 | Iosco | Michigan | 26069 | 33 | 4 |
93665 | 93665 | 2020-04-27 | Iosco | Michigan | 26069 | 41 | 4 |
96500 | 96500 | 2020-04-28 | Iosco | Michigan | 26069 | 48 | 4 |
99346 | 99346 | 2020-04-29 | Iosco | Michigan | 26069 | 47 | 4 |
102198 | 102198 | 2020-04-30 | Iosco | Michigan | 26069 | 52 | 4 |
105058 | 105058 | 2020-05-01 | Iosco | Michigan | 26069 | 51 | 7 |
107922 | 107922 | 2020-05-02 | Iosco | Michigan | 26069 | 52 | 7 |
110794 | 110794 | 2020-05-03 | Iosco | Michigan | 26069 | 52 | 7 |
113672 | 113672 | 2020-05-04 | Iosco | Michigan | 26069 | 52 | 7 |
116553 | 116553 | 2020-05-05 | Iosco | Michigan | 26069 | 52 | 7 |
119514 | 119514 | 2020-05-06 | Iosco | Michigan | 26069 | 53 | 7 |
122486 | 122486 | 2020-05-07 | Iosco | Michigan | 26069 | 54 | 8 |
125468 | 125468 | 2020-05-08 | Iosco | Michigan | 26069 | 54 | 8 |
128455 | 128455 | 2020-05-09 | Iosco | Michigan | 26069 | 54 | 8 |
131445 | 131445 | 2020-05-10 | Iosco | Michigan | 26069 | 55 | 8 |
134436 | 134436 | 2020-05-11 | Iosco | Michigan | 26069 | 55 | 8 |
137426 | 137426 | 2020-05-12 | Iosco | Michigan | 26069 | 55 | 8 |
140420 | 140420 | 2020-05-13 | Iosco | Michigan | 26069 | 55 | 8 |
143415 | 143415 | 2020-05-14 | Iosco | Michigan | 26069 | 56 | 8 |
146415 | 146415 | 2020-05-15 | Iosco | Michigan | 26069 | 57 | 8 |
149420 | 149420 | 2020-05-16 | Iosco | Michigan | 26069 | 58 | 8 |
152431 | 152431 | 2020-05-17 | Iosco | Michigan | 26069 | 58 | 8 |
155445 | 155445 | 2020-05-18 | Iosco | Michigan | 26069 | 59 | 8 |
158463 | 158463 | 2020-05-19 | Iosco | Michigan | 26069 | 65 | 8 |
210393 | 210393 | 2020-06-05 | Iosco | Michigan | 26069 | 111 | 8 |
161489 | 161489 | 2020-05-20 | Iosco | Michigan | 26069 | 71 | 9 |
164518 | 164518 | 2020-05-21 | Iosco | Michigan | 26069 | 73 | 9 |
167554 | 167554 | 2020-05-22 | Iosco | Michigan | 26069 | 76 | 9 |
170591 | 170591 | 2020-05-23 | Iosco | Michigan | 26069 | 77 | 9 |
173633 | 173633 | 2020-05-24 | Iosco | Michigan | 26069 | 77 | 9 |
176676 | 176676 | 2020-05-25 | Iosco | Michigan | 26069 | 82 | 9 |
179720 | 179720 | 2020-05-26 | Iosco | Michigan | 26069 | 84 | 9 |
182766 | 182766 | 2020-05-27 | Iosco | Michigan | 26069 | 89 | 9 |
185821 | 185821 | 2020-05-28 | Iosco | Michigan | 26069 | 90 | 9 |
188879 | 188879 | 2020-05-29 | Iosco | Michigan | 26069 | 94 | 9 |
191943 | 191943 | 2020-05-30 | Iosco | Michigan | 26069 | 94 | 9 |
195011 | 195011 | 2020-05-31 | Iosco | Michigan | 26069 | 94 | 9 |
198082 | 198082 | 2020-06-01 | Iosco | Michigan | 26069 | 112 | 9 |
201154 | 201154 | 2020-06-02 | Iosco | Michigan | 26069 | 112 | 9 |
204231 | 204231 | 2020-06-03 | Iosco | Michigan | 26069 | 112 | 9 |
207312 | 207312 | 2020-06-04 | Iosco | Michigan | 26069 | 111 | 9 |
213477 | 213477 | 2020-06-06 | Iosco | Michigan | 26069 | 111 | 10 |
216565 | 216565 | 2020-06-07 | Iosco | Michigan | 26069 | 111 | 10 |
219657 | 219657 | 2020-06-08 | Iosco | Michigan | 26069 | 111 | 10 |
222752 | 222752 | 2020-06-09 | Iosco | Michigan | 26069 | 111 | 10 |
225849 | 225849 | 2020-06-10 | Iosco | Michigan | 26069 | 111 | 10 |
228951 | 228951 | 2020-06-11 | Iosco | Michigan | 26069 | 111 | 10 |
232055 | 232055 | 2020-06-12 | Iosco | Michigan | 26069 | 112 | 10 |
235160 | 235160 | 2020-06-13 | Iosco | Michigan | 26069 | 112 | 10 |
238267 | 238267 | 2020-06-14 | Iosco | Michigan | 26069 | 112 | 10 |
241376 | 241376 | 2020-06-15 | Iosco | Michigan | 26069 | 112 | 10 |
244487 | 244487 | 2020-06-16 | Iosco | Michigan | 26069 | 112 | 10 |
247600 | 247600 | 2020-06-17 | Iosco | Michigan | 26069 | 112 | 10 |
250712 | 250712 | 2020-06-18 | Iosco | Michigan | 26069 | 112 | 10 |
253827 | 253827 | 2020-06-19 | Iosco | Michigan | 26069 | 112 | 10 |
256947 | 256947 | 2020-06-20 | Iosco | Michigan | 26069 | 112 | 10 |
260073 | 260073 | 2020-06-21 | Iosco | Michigan | 26069 | 112 | 10 |
263202 | 263202 | 2020-06-22 | Iosco | Michigan | 26069 | 112 | 10 |
266328 | 266328 | 2020-06-23 | Iosco | Michigan | 26069 | 112 | 10 |
269461 | 269461 | 2020-06-24 | Iosco | Michigan | 26069 | 112 | 10 |
272598 | 272598 | 2020-06-25 | Iosco | Michigan | 26069 | 112 | 10 |
275741 | 275741 | 2020-06-26 | Iosco | Michigan | 26069 | 112 | 10 |
278889 | 278889 | 2020-06-27 | Iosco | Michigan | 26069 | 112 | 10 |
282037 | 282037 | 2020-06-28 | Iosco | Michigan | 26069 | 112 | 10 |
285182 | 285182 | 2020-06-29 | Iosco | Michigan | 26069 | 113 | 10 |
288332 | 288332 | 2020-06-30 | Iosco | Michigan | 26069 | 113 | 10 |
291483 | 291483 | 2020-07-01 | Iosco | Michigan | 26069 | 114 | 11 |
294637 | 294637 | 2020-07-02 | Iosco | Michigan | 26069 | 116 | 11 |
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);