ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 26045 and state = "Michigan" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4745 | 4745 | 2020-03-19 | Eaton | Michigan | 26045 | 2 | 0 |
5564 | 5564 | 2020-03-20 | Eaton | Michigan | 26045 | 2 | 0 |
6529 | 6529 | 2020-03-21 | Eaton | Michigan | 26045 | 2 | 0 |
7606 | 7606 | 2020-03-22 | Eaton | Michigan | 26045 | 2 | 0 |
8779 | 8779 | 2020-03-23 | Eaton | Michigan | 26045 | 2 | 0 |
10068 | 10068 | 2020-03-24 | Eaton | Michigan | 26045 | 3 | 0 |
11480 | 11480 | 2020-03-25 | Eaton | Michigan | 26045 | 3 | 0 |
13061 | 13061 | 2020-03-26 | Eaton | Michigan | 26045 | 4 | 0 |
14771 | 14771 | 2020-03-27 | Eaton | Michigan | 26045 | 8 | 0 |
16591 | 16591 | 2020-03-28 | Eaton | Michigan | 26045 | 8 | 0 |
18507 | 18507 | 2020-03-29 | Eaton | Michigan | 26045 | 8 | 0 |
20525 | 20525 | 2020-03-30 | Eaton | Michigan | 26045 | 15 | 0 |
22636 | 22636 | 2020-03-31 | Eaton | Michigan | 26045 | 21 | 0 |
24815 | 24815 | 2020-04-01 | Eaton | Michigan | 26045 | 27 | 0 |
27068 | 27068 | 2020-04-02 | Eaton | Michigan | 26045 | 37 | 1 |
29386 | 29386 | 2020-04-03 | Eaton | Michigan | 26045 | 47 | 2 |
31764 | 31764 | 2020-04-04 | Eaton | Michigan | 26045 | 53 | 2 |
34189 | 34189 | 2020-04-05 | Eaton | Michigan | 26045 | 55 | 2 |
36648 | 36648 | 2020-04-06 | Eaton | Michigan | 26045 | 57 | 2 |
39156 | 39156 | 2020-04-07 | Eaton | Michigan | 26045 | 61 | 2 |
41708 | 41708 | 2020-04-08 | Eaton | Michigan | 26045 | 67 | 3 |
44284 | 44284 | 2020-04-09 | Eaton | Michigan | 26045 | 69 | 3 |
46892 | 46892 | 2020-04-10 | Eaton | Michigan | 26045 | 69 | 4 |
49535 | 49535 | 2020-04-11 | Eaton | Michigan | 26045 | 71 | 4 |
52205 | 52205 | 2020-04-12 | Eaton | Michigan | 26045 | 74 | 4 |
54886 | 54886 | 2020-04-13 | Eaton | Michigan | 26045 | 74 | 5 |
57584 | 57584 | 2020-04-14 | Eaton | Michigan | 26045 | 76 | 5 |
60294 | 60294 | 2020-04-15 | Eaton | Michigan | 26045 | 77 | 5 |
63016 | 63016 | 2020-04-16 | Eaton | Michigan | 26045 | 84 | 5 |
65754 | 65754 | 2020-04-17 | Eaton | Michigan | 26045 | 87 | 5 |
68505 | 68505 | 2020-04-18 | Eaton | Michigan | 26045 | 88 | 5 |
71269 | 71269 | 2020-04-19 | Eaton | Michigan | 26045 | 88 | 5 |
74041 | 74041 | 2020-04-20 | Eaton | Michigan | 26045 | 90 | 5 |
76821 | 76821 | 2020-04-21 | Eaton | Michigan | 26045 | 99 | 5 |
79607 | 79607 | 2020-04-22 | Eaton | Michigan | 26045 | 104 | 5 |
82402 | 82402 | 2020-04-23 | Eaton | Michigan | 26045 | 111 | 5 |
85206 | 85206 | 2020-04-24 | Eaton | Michigan | 26045 | 114 | 5 |
88016 | 88016 | 2020-04-25 | Eaton | Michigan | 26045 | 114 | 5 |
90832 | 90832 | 2020-04-26 | Eaton | Michigan | 26045 | 115 | 5 |
93653 | 93653 | 2020-04-27 | Eaton | Michigan | 26045 | 116 | 6 |
96488 | 96488 | 2020-04-28 | Eaton | Michigan | 26045 | 119 | 6 |
99334 | 99334 | 2020-04-29 | Eaton | Michigan | 26045 | 124 | 6 |
102186 | 102186 | 2020-04-30 | Eaton | Michigan | 26045 | 131 | 6 |
105046 | 105046 | 2020-05-01 | Eaton | Michigan | 26045 | 133 | 6 |
107910 | 107910 | 2020-05-02 | Eaton | Michigan | 26045 | 136 | 6 |
110782 | 110782 | 2020-05-03 | Eaton | Michigan | 26045 | 136 | 6 |
113660 | 113660 | 2020-05-04 | Eaton | Michigan | 26045 | 137 | 6 |
116541 | 116541 | 2020-05-05 | Eaton | Michigan | 26045 | 138 | 6 |
119502 | 119502 | 2020-05-06 | Eaton | Michigan | 26045 | 141 | 6 |
122474 | 122474 | 2020-05-07 | Eaton | Michigan | 26045 | 146 | 6 |
125456 | 125456 | 2020-05-08 | Eaton | Michigan | 26045 | 152 | 6 |
128443 | 128443 | 2020-05-09 | Eaton | Michigan | 26045 | 150 | 6 |
131433 | 131433 | 2020-05-10 | Eaton | Michigan | 26045 | 150 | 6 |
134424 | 134424 | 2020-05-11 | Eaton | Michigan | 26045 | 151 | 6 |
137414 | 137414 | 2020-05-12 | Eaton | Michigan | 26045 | 152 | 6 |
140408 | 140408 | 2020-05-13 | Eaton | Michigan | 26045 | 155 | 6 |
143403 | 143403 | 2020-05-14 | Eaton | Michigan | 26045 | 161 | 6 |
146403 | 146403 | 2020-05-15 | Eaton | Michigan | 26045 | 162 | 6 |
149408 | 149408 | 2020-05-16 | Eaton | Michigan | 26045 | 162 | 6 |
152419 | 152419 | 2020-05-17 | Eaton | Michigan | 26045 | 163 | 6 |
155433 | 155433 | 2020-05-18 | Eaton | Michigan | 26045 | 165 | 6 |
158451 | 158451 | 2020-05-19 | Eaton | Michigan | 26045 | 165 | 6 |
161477 | 161477 | 2020-05-20 | Eaton | Michigan | 26045 | 168 | 6 |
164506 | 164506 | 2020-05-21 | Eaton | Michigan | 26045 | 170 | 6 |
167542 | 167542 | 2020-05-22 | Eaton | Michigan | 26045 | 173 | 6 |
170579 | 170579 | 2020-05-23 | Eaton | Michigan | 26045 | 175 | 6 |
173621 | 173621 | 2020-05-24 | Eaton | Michigan | 26045 | 176 | 6 |
176664 | 176664 | 2020-05-25 | Eaton | Michigan | 26045 | 178 | 6 |
179708 | 179708 | 2020-05-26 | Eaton | Michigan | 26045 | 178 | 6 |
182754 | 182754 | 2020-05-27 | Eaton | Michigan | 26045 | 179 | 6 |
185809 | 185809 | 2020-05-28 | Eaton | Michigan | 26045 | 183 | 6 |
188867 | 188867 | 2020-05-29 | Eaton | Michigan | 26045 | 185 | 6 |
191931 | 191931 | 2020-05-30 | Eaton | Michigan | 26045 | 187 | 6 |
194999 | 194999 | 2020-05-31 | Eaton | Michigan | 26045 | 190 | 6 |
198070 | 198070 | 2020-06-01 | Eaton | Michigan | 26045 | 190 | 6 |
201142 | 201142 | 2020-06-02 | Eaton | Michigan | 26045 | 189 | 6 |
204219 | 204219 | 2020-06-03 | Eaton | Michigan | 26045 | 192 | 6 |
207300 | 207300 | 2020-06-04 | Eaton | Michigan | 26045 | 192 | 6 |
210381 | 210381 | 2020-06-05 | Eaton | Michigan | 26045 | 235 | 7 |
213465 | 213465 | 2020-06-06 | Eaton | Michigan | 26045 | 244 | 7 |
216553 | 216553 | 2020-06-07 | Eaton | Michigan | 26045 | 245 | 7 |
219645 | 219645 | 2020-06-08 | Eaton | Michigan | 26045 | 244 | 7 |
222740 | 222740 | 2020-06-09 | Eaton | Michigan | 26045 | 252 | 7 |
225837 | 225837 | 2020-06-10 | Eaton | Michigan | 26045 | 255 | 7 |
228939 | 228939 | 2020-06-11 | Eaton | Michigan | 26045 | 255 | 7 |
232043 | 232043 | 2020-06-12 | Eaton | Michigan | 26045 | 256 | 7 |
235148 | 235148 | 2020-06-13 | Eaton | Michigan | 26045 | 256 | 7 |
238255 | 238255 | 2020-06-14 | Eaton | Michigan | 26045 | 257 | 7 |
241364 | 241364 | 2020-06-15 | Eaton | Michigan | 26045 | 258 | 7 |
244475 | 244475 | 2020-06-16 | Eaton | Michigan | 26045 | 258 | 7 |
247588 | 247588 | 2020-06-17 | Eaton | Michigan | 26045 | 261 | 7 |
250700 | 250700 | 2020-06-18 | Eaton | Michigan | 26045 | 263 | 7 |
253815 | 253815 | 2020-06-19 | Eaton | Michigan | 26045 | 265 | 7 |
256935 | 256935 | 2020-06-20 | Eaton | Michigan | 26045 | 267 | 7 |
260061 | 260061 | 2020-06-21 | Eaton | Michigan | 26045 | 269 | 7 |
263190 | 263190 | 2020-06-22 | Eaton | Michigan | 26045 | 271 | 7 |
266316 | 266316 | 2020-06-23 | Eaton | Michigan | 26045 | 274 | 7 |
269449 | 269449 | 2020-06-24 | Eaton | Michigan | 26045 | 287 | 7 |
272586 | 272586 | 2020-06-25 | Eaton | Michigan | 26045 | 297 | 7 |
275729 | 275729 | 2020-06-26 | Eaton | Michigan | 26045 | 306 | 7 |
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);