ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26005 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282005 | 282005 | 2020-06-28 | Allegan | Michigan | 26005 | 306 | 6 |
278857 | 278857 | 2020-06-27 | Allegan | Michigan | 26005 | 303 | 6 |
275709 | 275709 | 2020-06-26 | Allegan | Michigan | 26005 | 302 | 6 |
272566 | 272566 | 2020-06-25 | Allegan | Michigan | 26005 | 301 | 6 |
269429 | 269429 | 2020-06-24 | Allegan | Michigan | 26005 | 303 | 6 |
266296 | 266296 | 2020-06-23 | Allegan | Michigan | 26005 | 301 | 6 |
263170 | 263170 | 2020-06-22 | Allegan | Michigan | 26005 | 301 | 6 |
260041 | 260041 | 2020-06-21 | Allegan | Michigan | 26005 | 299 | 6 |
256915 | 256915 | 2020-06-20 | Allegan | Michigan | 26005 | 297 | 6 |
253795 | 253795 | 2020-06-19 | Allegan | Michigan | 26005 | 292 | 6 |
250680 | 250680 | 2020-06-18 | Allegan | Michigan | 26005 | 291 | 6 |
247568 | 247568 | 2020-06-17 | Allegan | Michigan | 26005 | 288 | 6 |
244455 | 244455 | 2020-06-16 | Allegan | Michigan | 26005 | 288 | 6 |
241344 | 241344 | 2020-06-15 | Allegan | Michigan | 26005 | 287 | 6 |
238235 | 238235 | 2020-06-14 | Allegan | Michigan | 26005 | 286 | 6 |
235128 | 235128 | 2020-06-13 | Allegan | Michigan | 26005 | 283 | 6 |
232023 | 232023 | 2020-06-12 | Allegan | Michigan | 26005 | 280 | 6 |
228919 | 228919 | 2020-06-11 | Allegan | Michigan | 26005 | 277 | 6 |
225817 | 225817 | 2020-06-10 | Allegan | Michigan | 26005 | 274 | 6 |
222720 | 222720 | 2020-06-09 | Allegan | Michigan | 26005 | 273 | 6 |
219625 | 219625 | 2020-06-08 | Allegan | Michigan | 26005 | 268 | 6 |
216533 | 216533 | 2020-06-07 | Allegan | Michigan | 26005 | 266 | 6 |
213445 | 213445 | 2020-06-06 | Allegan | Michigan | 26005 | 263 | 6 |
210361 | 210361 | 2020-06-05 | Allegan | Michigan | 26005 | 263 | 6 |
207280 | 207280 | 2020-06-04 | Allegan | Michigan | 26005 | 261 | 6 |
204199 | 204199 | 2020-06-03 | Allegan | Michigan | 26005 | 258 | 6 |
201122 | 201122 | 2020-06-02 | Allegan | Michigan | 26005 | 258 | 6 |
198050 | 198050 | 2020-06-01 | Allegan | Michigan | 26005 | 257 | 6 |
194979 | 194979 | 2020-05-31 | Allegan | Michigan | 26005 | 218 | 6 |
191911 | 191911 | 2020-05-30 | Allegan | Michigan | 26005 | 217 | 6 |
188847 | 188847 | 2020-05-29 | Allegan | Michigan | 26005 | 216 | 6 |
185789 | 185789 | 2020-05-28 | Allegan | Michigan | 26005 | 214 | 6 |
182734 | 182734 | 2020-05-27 | Allegan | Michigan | 26005 | 211 | 6 |
179688 | 179688 | 2020-05-26 | Allegan | Michigan | 26005 | 212 | 6 |
176644 | 176644 | 2020-05-25 | Allegan | Michigan | 26005 | 210 | 6 |
173601 | 173601 | 2020-05-24 | Allegan | Michigan | 26005 | 210 | 7 |
170559 | 170559 | 2020-05-23 | Allegan | Michigan | 26005 | 202 | 7 |
167522 | 167522 | 2020-05-22 | Allegan | Michigan | 26005 | 197 | 6 |
164486 | 164486 | 2020-05-21 | Allegan | Michigan | 26005 | 195 | 5 |
161457 | 161457 | 2020-05-20 | Allegan | Michigan | 26005 | 191 | 5 |
158431 | 158431 | 2020-05-19 | Allegan | Michigan | 26005 | 184 | 3 |
155413 | 155413 | 2020-05-18 | Allegan | Michigan | 26005 | 186 | 2 |
152399 | 152399 | 2020-05-17 | Allegan | Michigan | 26005 | 179 | 2 |
149388 | 149388 | 2020-05-16 | Allegan | Michigan | 26005 | 174 | 2 |
146383 | 146383 | 2020-05-15 | Allegan | Michigan | 26005 | 173 | 2 |
143383 | 143383 | 2020-05-14 | Allegan | Michigan | 26005 | 168 | 2 |
140388 | 140388 | 2020-05-13 | Allegan | Michigan | 26005 | 165 | 2 |
137394 | 137394 | 2020-05-12 | Allegan | Michigan | 26005 | 161 | 2 |
134404 | 134404 | 2020-05-11 | Allegan | Michigan | 26005 | 157 | 2 |
131413 | 131413 | 2020-05-10 | Allegan | Michigan | 26005 | 150 | 2 |
128423 | 128423 | 2020-05-09 | Allegan | Michigan | 26005 | 136 | 2 |
125436 | 125436 | 2020-05-08 | Allegan | Michigan | 26005 | 130 | 2 |
122454 | 122454 | 2020-05-07 | Allegan | Michigan | 26005 | 126 | 2 |
119482 | 119482 | 2020-05-06 | Allegan | Michigan | 26005 | 124 | 2 |
116521 | 116521 | 2020-05-05 | Allegan | Michigan | 26005 | 120 | 2 |
113640 | 113640 | 2020-05-04 | Allegan | Michigan | 26005 | 116 | 2 |
110762 | 110762 | 2020-05-03 | Allegan | Michigan | 26005 | 113 | 2 |
107890 | 107890 | 2020-05-02 | Allegan | Michigan | 26005 | 108 | 2 |
105026 | 105026 | 2020-05-01 | Allegan | Michigan | 26005 | 104 | 2 |
102166 | 102166 | 2020-04-30 | Allegan | Michigan | 26005 | 98 | 2 |
99314 | 99314 | 2020-04-29 | Allegan | Michigan | 26005 | 94 | 2 |
96468 | 96468 | 2020-04-28 | Allegan | Michigan | 26005 | 84 | 1 |
93633 | 93633 | 2020-04-27 | Allegan | Michigan | 26005 | 72 | 1 |
90812 | 90812 | 2020-04-26 | Allegan | Michigan | 26005 | 69 | 1 |
87996 | 87996 | 2020-04-25 | Allegan | Michigan | 26005 | 65 | 1 |
85186 | 85186 | 2020-04-24 | Allegan | Michigan | 26005 | 60 | 1 |
82382 | 82382 | 2020-04-23 | Allegan | Michigan | 26005 | 56 | 0 |
79587 | 79587 | 2020-04-22 | Allegan | Michigan | 26005 | 50 | 0 |
76801 | 76801 | 2020-04-21 | Allegan | Michigan | 26005 | 47 | 0 |
74021 | 74021 | 2020-04-20 | Allegan | Michigan | 26005 | 42 | 0 |
71249 | 71249 | 2020-04-19 | Allegan | Michigan | 26005 | 41 | 0 |
68485 | 68485 | 2020-04-18 | Allegan | Michigan | 26005 | 33 | 0 |
65735 | 65735 | 2020-04-17 | Allegan | Michigan | 26005 | 29 | 0 |
62997 | 62997 | 2020-04-16 | Allegan | Michigan | 26005 | 25 | 0 |
60276 | 60276 | 2020-04-15 | Allegan | Michigan | 26005 | 25 | 0 |
57566 | 57566 | 2020-04-14 | Allegan | Michigan | 26005 | 23 | 0 |
54868 | 54868 | 2020-04-13 | Allegan | Michigan | 26005 | 23 | 0 |
52187 | 52187 | 2020-04-12 | Allegan | Michigan | 26005 | 21 | 0 |
49517 | 49517 | 2020-04-11 | Allegan | Michigan | 26005 | 19 | 0 |
46875 | 46875 | 2020-04-10 | Allegan | Michigan | 26005 | 19 | 0 |
44267 | 44267 | 2020-04-09 | Allegan | Michigan | 26005 | 18 | 0 |
41691 | 41691 | 2020-04-08 | Allegan | Michigan | 26005 | 18 | 0 |
39139 | 39139 | 2020-04-07 | Allegan | Michigan | 26005 | 18 | 0 |
36631 | 36631 | 2020-04-06 | Allegan | Michigan | 26005 | 15 | 0 |
34172 | 34172 | 2020-04-05 | Allegan | Michigan | 26005 | 14 | 0 |
31747 | 31747 | 2020-04-04 | Allegan | Michigan | 26005 | 10 | 0 |
29369 | 29369 | 2020-04-03 | Allegan | Michigan | 26005 | 6 | 0 |
27051 | 27051 | 2020-04-02 | Allegan | Michigan | 26005 | 5 | 0 |
24799 | 24799 | 2020-04-01 | Allegan | Michigan | 26005 | 5 | 0 |
22620 | 22620 | 2020-03-31 | Allegan | Michigan | 26005 | 3 | 0 |
20511 | 20511 | 2020-03-30 | Allegan | Michigan | 26005 | 2 | 0 |
18495 | 18495 | 2020-03-29 | Allegan | Michigan | 26005 | 2 | 0 |
16580 | 16580 | 2020-03-28 | Allegan | Michigan | 26005 | 2 | 0 |
14760 | 14760 | 2020-03-27 | Allegan | Michigan | 26005 | 1 | 0 |
13052 | 13052 | 2020-03-26 | Allegan | Michigan | 26005 | 1 | 0 |
11471 | 11471 | 2020-03-25 | Allegan | Michigan | 26005 | 1 | 0 |
10059 | 10059 | 2020-03-24 | Allegan | Michigan | 26005 | 1 | 0 |
8770 | 8770 | 2020-03-23 | Allegan | Michigan | 26005 | 1 | 0 |
7598 | 7598 | 2020-03-22 | Allegan | Michigan | 26005 | 1 | 0 |
6521 | 6521 | 2020-03-21 | Allegan | Michigan | 26005 | 1 | 0 |
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);