ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 26043 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 ▼ |
---|---|---|---|---|---|---|---|
27067 | 27067 | 2020-04-02 | Dickinson | Michigan | 26043 | 1 | 0 |
29385 | 29385 | 2020-04-03 | Dickinson | Michigan | 26043 | 1 | 1 |
31763 | 31763 | 2020-04-04 | Dickinson | Michigan | 26043 | 1 | 1 |
34188 | 34188 | 2020-04-05 | Dickinson | Michigan | 26043 | 1 | 1 |
36647 | 36647 | 2020-04-06 | Dickinson | Michigan | 26043 | 2 | 1 |
39155 | 39155 | 2020-04-07 | Dickinson | Michigan | 26043 | 2 | 1 |
41707 | 41707 | 2020-04-08 | Dickinson | Michigan | 26043 | 2 | 1 |
44283 | 44283 | 2020-04-09 | Dickinson | Michigan | 26043 | 3 | 1 |
46891 | 46891 | 2020-04-10 | Dickinson | Michigan | 26043 | 3 | 1 |
49534 | 49534 | 2020-04-11 | Dickinson | Michigan | 26043 | 3 | 2 |
52204 | 52204 | 2020-04-12 | Dickinson | Michigan | 26043 | 3 | 2 |
54885 | 54885 | 2020-04-13 | Dickinson | Michigan | 26043 | 3 | 2 |
57583 | 57583 | 2020-04-14 | Dickinson | Michigan | 26043 | 3 | 2 |
60293 | 60293 | 2020-04-15 | Dickinson | Michigan | 26043 | 3 | 2 |
63015 | 63015 | 2020-04-16 | Dickinson | Michigan | 26043 | 3 | 2 |
65753 | 65753 | 2020-04-17 | Dickinson | Michigan | 26043 | 3 | 2 |
68504 | 68504 | 2020-04-18 | Dickinson | Michigan | 26043 | 3 | 2 |
71268 | 71268 | 2020-04-19 | Dickinson | Michigan | 26043 | 3 | 2 |
74040 | 74040 | 2020-04-20 | Dickinson | Michigan | 26043 | 3 | 2 |
76820 | 76820 | 2020-04-21 | Dickinson | Michigan | 26043 | 3 | 2 |
79606 | 79606 | 2020-04-22 | Dickinson | Michigan | 26043 | 3 | 2 |
82401 | 82401 | 2020-04-23 | Dickinson | Michigan | 26043 | 3 | 2 |
85205 | 85205 | 2020-04-24 | Dickinson | Michigan | 26043 | 3 | 2 |
88015 | 88015 | 2020-04-25 | Dickinson | Michigan | 26043 | 3 | 2 |
90831 | 90831 | 2020-04-26 | Dickinson | Michigan | 26043 | 3 | 2 |
93652 | 93652 | 2020-04-27 | Dickinson | Michigan | 26043 | 3 | 2 |
96487 | 96487 | 2020-04-28 | Dickinson | Michigan | 26043 | 3 | 2 |
99333 | 99333 | 2020-04-29 | Dickinson | Michigan | 26043 | 3 | 2 |
102185 | 102185 | 2020-04-30 | Dickinson | Michigan | 26043 | 3 | 2 |
105045 | 105045 | 2020-05-01 | Dickinson | Michigan | 26043 | 3 | 2 |
107909 | 107909 | 2020-05-02 | Dickinson | Michigan | 26043 | 3 | 2 |
110781 | 110781 | 2020-05-03 | Dickinson | Michigan | 26043 | 4 | 2 |
113659 | 113659 | 2020-05-04 | Dickinson | Michigan | 26043 | 3 | 2 |
116540 | 116540 | 2020-05-05 | Dickinson | Michigan | 26043 | 3 | 2 |
119501 | 119501 | 2020-05-06 | Dickinson | Michigan | 26043 | 4 | 2 |
122473 | 122473 | 2020-05-07 | Dickinson | Michigan | 26043 | 4 | 2 |
125455 | 125455 | 2020-05-08 | Dickinson | Michigan | 26043 | 5 | 2 |
128442 | 128442 | 2020-05-09 | Dickinson | Michigan | 26043 | 5 | 2 |
131432 | 131432 | 2020-05-10 | Dickinson | Michigan | 26043 | 5 | 2 |
134423 | 134423 | 2020-05-11 | Dickinson | Michigan | 26043 | 5 | 2 |
137413 | 137413 | 2020-05-12 | Dickinson | Michigan | 26043 | 5 | 2 |
140407 | 140407 | 2020-05-13 | Dickinson | Michigan | 26043 | 5 | 2 |
143402 | 143402 | 2020-05-14 | Dickinson | Michigan | 26043 | 5 | 2 |
146402 | 146402 | 2020-05-15 | Dickinson | Michigan | 26043 | 5 | 2 |
149407 | 149407 | 2020-05-16 | Dickinson | Michigan | 26043 | 5 | 2 |
152418 | 152418 | 2020-05-17 | Dickinson | Michigan | 26043 | 5 | 2 |
155432 | 155432 | 2020-05-18 | Dickinson | Michigan | 26043 | 5 | 2 |
158450 | 158450 | 2020-05-19 | Dickinson | Michigan | 26043 | 5 | 2 |
161476 | 161476 | 2020-05-20 | Dickinson | Michigan | 26043 | 5 | 2 |
164505 | 164505 | 2020-05-21 | Dickinson | Michigan | 26043 | 5 | 2 |
167541 | 167541 | 2020-05-22 | Dickinson | Michigan | 26043 | 5 | 2 |
170578 | 170578 | 2020-05-23 | Dickinson | Michigan | 26043 | 5 | 2 |
173620 | 173620 | 2020-05-24 | Dickinson | Michigan | 26043 | 5 | 2 |
176663 | 176663 | 2020-05-25 | Dickinson | Michigan | 26043 | 5 | 2 |
179707 | 179707 | 2020-05-26 | Dickinson | Michigan | 26043 | 5 | 2 |
182753 | 182753 | 2020-05-27 | Dickinson | Michigan | 26043 | 5 | 2 |
185808 | 185808 | 2020-05-28 | Dickinson | Michigan | 26043 | 5 | 2 |
188866 | 188866 | 2020-05-29 | Dickinson | Michigan | 26043 | 5 | 2 |
191930 | 191930 | 2020-05-30 | Dickinson | Michigan | 26043 | 5 | 2 |
194998 | 194998 | 2020-05-31 | Dickinson | Michigan | 26043 | 5 | 2 |
198069 | 198069 | 2020-06-01 | Dickinson | Michigan | 26043 | 5 | 2 |
201141 | 201141 | 2020-06-02 | Dickinson | Michigan | 26043 | 5 | 2 |
204218 | 204218 | 2020-06-03 | Dickinson | Michigan | 26043 | 5 | 2 |
207299 | 207299 | 2020-06-04 | Dickinson | Michigan | 26043 | 5 | 2 |
210380 | 210380 | 2020-06-05 | Dickinson | Michigan | 26043 | 5 | 2 |
213464 | 213464 | 2020-06-06 | Dickinson | Michigan | 26043 | 6 | 2 |
216552 | 216552 | 2020-06-07 | Dickinson | Michigan | 26043 | 6 | 2 |
219644 | 219644 | 2020-06-08 | Dickinson | Michigan | 26043 | 6 | 2 |
222739 | 222739 | 2020-06-09 | Dickinson | Michigan | 26043 | 6 | 2 |
225836 | 225836 | 2020-06-10 | Dickinson | Michigan | 26043 | 6 | 2 |
228938 | 228938 | 2020-06-11 | Dickinson | Michigan | 26043 | 6 | 2 |
232042 | 232042 | 2020-06-12 | Dickinson | Michigan | 26043 | 7 | 2 |
235147 | 235147 | 2020-06-13 | Dickinson | Michigan | 26043 | 7 | 2 |
238254 | 238254 | 2020-06-14 | Dickinson | Michigan | 26043 | 7 | 2 |
241363 | 241363 | 2020-06-15 | Dickinson | Michigan | 26043 | 7 | 2 |
244474 | 244474 | 2020-06-16 | Dickinson | Michigan | 26043 | 7 | 2 |
247587 | 247587 | 2020-06-17 | Dickinson | Michigan | 26043 | 7 | 2 |
250699 | 250699 | 2020-06-18 | Dickinson | Michigan | 26043 | 7 | 2 |
253814 | 253814 | 2020-06-19 | Dickinson | Michigan | 26043 | 7 | 2 |
256934 | 256934 | 2020-06-20 | Dickinson | Michigan | 26043 | 7 | 2 |
260060 | 260060 | 2020-06-21 | Dickinson | Michigan | 26043 | 7 | 2 |
263189 | 263189 | 2020-06-22 | Dickinson | Michigan | 26043 | 7 | 2 |
266315 | 266315 | 2020-06-23 | Dickinson | Michigan | 26043 | 7 | 2 |
269448 | 269448 | 2020-06-24 | Dickinson | Michigan | 26043 | 7 | 2 |
272585 | 272585 | 2020-06-25 | Dickinson | Michigan | 26043 | 7 | 2 |
275728 | 275728 | 2020-06-26 | Dickinson | Michigan | 26043 | 7 | 2 |
278876 | 278876 | 2020-06-27 | Dickinson | Michigan | 26043 | 7 | 2 |
282024 | 282024 | 2020-06-28 | Dickinson | Michigan | 26043 | 7 | 2 |
285169 | 285169 | 2020-06-29 | Dickinson | Michigan | 26043 | 7 | 2 |
288319 | 288319 | 2020-06-30 | Dickinson | Michigan | 26043 | 7 | 2 |
291470 | 291470 | 2020-07-01 | Dickinson | Michigan | 26043 | 7 | 2 |
294624 | 294624 | 2020-07-02 | Dickinson | Michigan | 26043 | 7 | 2 |
297782 | 297782 | 2020-07-03 | Dickinson | Michigan | 26043 | 9 | 2 |
300944 | 300944 | 2020-07-04 | Dickinson | Michigan | 26043 | 10 | 2 |
304108 | 304108 | 2020-07-05 | Dickinson | Michigan | 26043 | 10 | 2 |
307275 | 307275 | 2020-07-06 | Dickinson | Michigan | 26043 | 14 | 2 |
310443 | 310443 | 2020-07-07 | Dickinson | Michigan | 26043 | 15 | 2 |
313613 | 313613 | 2020-07-08 | Dickinson | Michigan | 26043 | 16 | 2 |
316787 | 316787 | 2020-07-09 | Dickinson | Michigan | 26043 | 16 | 2 |
319962 | 319962 | 2020-07-10 | Dickinson | Michigan | 26043 | 18 | 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);