ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 26087 and state = "Michigan" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
10080 | 10080 | 2020-03-24 | Lapeer | Michigan | 26087 | 1 | 0 |
11493 | 11493 | 2020-03-25 | Lapeer | Michigan | 26087 | 1 | 0 |
13076 | 13076 | 2020-03-26 | Lapeer | Michigan | 26087 | 3 | 0 |
14788 | 14788 | 2020-03-27 | Lapeer | Michigan | 26087 | 4 | 0 |
16608 | 16608 | 2020-03-28 | Lapeer | Michigan | 26087 | 4 | 0 |
18524 | 18524 | 2020-03-29 | Lapeer | Michigan | 26087 | 4 | 0 |
20543 | 20543 | 2020-03-30 | Lapeer | Michigan | 26087 | 6 | 0 |
22654 | 22654 | 2020-03-31 | Lapeer | Michigan | 26087 | 8 | 0 |
24833 | 24833 | 2020-04-01 | Lapeer | Michigan | 26087 | 8 | 0 |
27086 | 27086 | 2020-04-02 | Lapeer | Michigan | 26087 | 21 | 0 |
29404 | 29404 | 2020-04-03 | Lapeer | Michigan | 26087 | 22 | 0 |
31782 | 31782 | 2020-04-04 | Lapeer | Michigan | 26087 | 27 | 0 |
34207 | 34207 | 2020-04-05 | Lapeer | Michigan | 26087 | 45 | 0 |
36666 | 36666 | 2020-04-06 | Lapeer | Michigan | 26087 | 49 | 0 |
39174 | 39174 | 2020-04-07 | Lapeer | Michigan | 26087 | 56 | 3 |
41726 | 41726 | 2020-04-08 | Lapeer | Michigan | 26087 | 64 | 5 |
44302 | 44302 | 2020-04-09 | Lapeer | Michigan | 26087 | 77 | 5 |
46910 | 46910 | 2020-04-10 | Lapeer | Michigan | 26087 | 87 | 6 |
49554 | 49554 | 2020-04-11 | Lapeer | Michigan | 26087 | 95 | 6 |
52224 | 52224 | 2020-04-12 | Lapeer | Michigan | 26087 | 101 | 6 |
54905 | 54905 | 2020-04-13 | Lapeer | Michigan | 26087 | 106 | 6 |
57603 | 57603 | 2020-04-14 | Lapeer | Michigan | 26087 | 117 | 9 |
60313 | 60313 | 2020-04-15 | Lapeer | Michigan | 26087 | 125 | 10 |
63035 | 63035 | 2020-04-16 | Lapeer | Michigan | 26087 | 137 | 13 |
65773 | 65773 | 2020-04-17 | Lapeer | Michigan | 26087 | 146 | 13 |
68524 | 68524 | 2020-04-18 | Lapeer | Michigan | 26087 | 147 | 18 |
71288 | 71288 | 2020-04-19 | Lapeer | Michigan | 26087 | 153 | 18 |
74060 | 74060 | 2020-04-20 | Lapeer | Michigan | 26087 | 155 | 20 |
76840 | 76840 | 2020-04-21 | Lapeer | Michigan | 26087 | 158 | 22 |
79626 | 79626 | 2020-04-22 | Lapeer | Michigan | 26087 | 172 | 23 |
82421 | 82421 | 2020-04-23 | Lapeer | Michigan | 26087 | 177 | 23 |
85225 | 85225 | 2020-04-24 | Lapeer | Michigan | 26087 | 181 | 23 |
88035 | 88035 | 2020-04-25 | Lapeer | Michigan | 26087 | 181 | 23 |
90851 | 90851 | 2020-04-26 | Lapeer | Michigan | 26087 | 188 | 24 |
93672 | 93672 | 2020-04-27 | Lapeer | Michigan | 26087 | 193 | 24 |
96507 | 96507 | 2020-04-28 | Lapeer | Michigan | 26087 | 195 | 25 |
99353 | 99353 | 2020-04-29 | Lapeer | Michigan | 26087 | 196 | 26 |
102205 | 102205 | 2020-04-30 | Lapeer | Michigan | 26087 | 204 | 25 |
105065 | 105065 | 2020-05-01 | Lapeer | Michigan | 26087 | 214 | 26 |
107929 | 107929 | 2020-05-02 | Lapeer | Michigan | 26087 | 214 | 27 |
110801 | 110801 | 2020-05-03 | Lapeer | Michigan | 26087 | 221 | 27 |
113679 | 113679 | 2020-05-04 | Lapeer | Michigan | 26087 | 223 | 28 |
116560 | 116560 | 2020-05-05 | Lapeer | Michigan | 26087 | 225 | 28 |
119521 | 119521 | 2020-05-06 | Lapeer | Michigan | 26087 | 226 | 30 |
122493 | 122493 | 2020-05-07 | Lapeer | Michigan | 26087 | 229 | 30 |
125475 | 125475 | 2020-05-08 | Lapeer | Michigan | 26087 | 229 | 30 |
128462 | 128462 | 2020-05-09 | Lapeer | Michigan | 26087 | 230 | 30 |
131452 | 131452 | 2020-05-10 | Lapeer | Michigan | 26087 | 231 | 30 |
134443 | 134443 | 2020-05-11 | Lapeer | Michigan | 26087 | 232 | 31 |
137433 | 137433 | 2020-05-12 | Lapeer | Michigan | 26087 | 230 | 31 |
140427 | 140427 | 2020-05-13 | Lapeer | Michigan | 26087 | 233 | 32 |
143422 | 143422 | 2020-05-14 | Lapeer | Michigan | 26087 | 234 | 32 |
146422 | 146422 | 2020-05-15 | Lapeer | Michigan | 26087 | 237 | 33 |
149427 | 149427 | 2020-05-16 | Lapeer | Michigan | 26087 | 238 | 33 |
152438 | 152438 | 2020-05-17 | Lapeer | Michigan | 26087 | 239 | 33 |
155452 | 155452 | 2020-05-18 | Lapeer | Michigan | 26087 | 446 | 33 |
158470 | 158470 | 2020-05-19 | Lapeer | Michigan | 26087 | 463 | 33 |
161496 | 161496 | 2020-05-20 | Lapeer | Michigan | 26087 | 465 | 33 |
164525 | 164525 | 2020-05-21 | Lapeer | Michigan | 26087 | 465 | 33 |
167561 | 167561 | 2020-05-22 | Lapeer | Michigan | 26087 | 466 | 33 |
170598 | 170598 | 2020-05-23 | Lapeer | Michigan | 26087 | 470 | 33 |
173640 | 173640 | 2020-05-24 | Lapeer | Michigan | 26087 | 479 | 33 |
176683 | 176683 | 2020-05-25 | Lapeer | Michigan | 26087 | 477 | 33 |
179727 | 179727 | 2020-05-26 | Lapeer | Michigan | 26087 | 477 | 33 |
182773 | 182773 | 2020-05-27 | Lapeer | Michigan | 26087 | 477 | 36 |
185828 | 185828 | 2020-05-28 | Lapeer | Michigan | 26087 | 477 | 36 |
188886 | 188886 | 2020-05-29 | Lapeer | Michigan | 26087 | 477 | 36 |
191950 | 191950 | 2020-05-30 | Lapeer | Michigan | 26087 | 478 | 36 |
195018 | 195018 | 2020-05-31 | Lapeer | Michigan | 26087 | 479 | 37 |
198089 | 198089 | 2020-06-01 | Lapeer | Michigan | 26087 | 489 | 37 |
201162 | 201162 | 2020-06-02 | Lapeer | Michigan | 26087 | 492 | 37 |
204239 | 204239 | 2020-06-03 | Lapeer | Michigan | 26087 | 492 | 37 |
207320 | 207320 | 2020-06-04 | Lapeer | Michigan | 26087 | 494 | 37 |
210401 | 210401 | 2020-06-05 | Lapeer | Michigan | 26087 | 511 | 38 |
213485 | 213485 | 2020-06-06 | Lapeer | Michigan | 26087 | 512 | 38 |
216573 | 216573 | 2020-06-07 | Lapeer | Michigan | 26087 | 514 | 38 |
219665 | 219665 | 2020-06-08 | Lapeer | Michigan | 26087 | 514 | 38 |
222760 | 222760 | 2020-06-09 | Lapeer | Michigan | 26087 | 517 | 38 |
225858 | 225858 | 2020-06-10 | Lapeer | Michigan | 26087 | 516 | 39 |
228960 | 228960 | 2020-06-11 | Lapeer | Michigan | 26087 | 517 | 38 |
232064 | 232064 | 2020-06-12 | Lapeer | Michigan | 26087 | 517 | 38 |
235169 | 235169 | 2020-06-13 | Lapeer | Michigan | 26087 | 519 | 38 |
238276 | 238276 | 2020-06-14 | Lapeer | Michigan | 26087 | 520 | 38 |
241385 | 241385 | 2020-06-15 | Lapeer | Michigan | 26087 | 520 | 38 |
244496 | 244496 | 2020-06-16 | Lapeer | Michigan | 26087 | 521 | 38 |
247609 | 247609 | 2020-06-17 | Lapeer | Michigan | 26087 | 522 | 38 |
250721 | 250721 | 2020-06-18 | Lapeer | Michigan | 26087 | 533 | 38 |
253836 | 253836 | 2020-06-19 | Lapeer | Michigan | 26087 | 534 | 38 |
256956 | 256956 | 2020-06-20 | Lapeer | Michigan | 26087 | 535 | 38 |
260082 | 260082 | 2020-06-21 | Lapeer | Michigan | 26087 | 535 | 38 |
263211 | 263211 | 2020-06-22 | Lapeer | Michigan | 26087 | 557 | 38 |
266337 | 266337 | 2020-06-23 | Lapeer | Michigan | 26087 | 559 | 38 |
269470 | 269470 | 2020-06-24 | Lapeer | Michigan | 26087 | 565 | 38 |
272607 | 272607 | 2020-06-25 | Lapeer | Michigan | 26087 | 567 | 38 |
275750 | 275750 | 2020-06-26 | Lapeer | Michigan | 26087 | 585 | 38 |
278898 | 278898 | 2020-06-27 | Lapeer | Michigan | 26087 | 595 | 38 |
282046 | 282046 | 2020-06-28 | Lapeer | Michigan | 26087 | 595 | 38 |
285191 | 285191 | 2020-06-29 | Lapeer | Michigan | 26087 | 598 | 38 |
288341 | 288341 | 2020-06-30 | Lapeer | Michigan | 26087 | 599 | 38 |
291492 | 291492 | 2020-07-01 | Lapeer | Michigan | 26087 | 602 | 38 |
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);