ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 26045 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 186 ✖
- 7 59
- 6 39
- 10 37
- 211 31
- 8 29
- 212 29
- 213 18
- 11 15
- 0 14
- 5 14
- 9 11
- 160 11
- 207 11
- 156 10
- 208 9
- 393 9
- 209 8
- 218 7
- 249 7
- 331 7
- 382 7
- 397 7
- 398 7
- 400 7
- 401 7
- 403 7
- 2 5
- 82 5
- 117 5
- 162 5
- 233 5
- 236 5
- 247 5
- 254 5
- 276 5
- 313 5
- 326 5
- 336 5
- 342 5
- 349 5
- 387 5
- 392 5
- 394 5
- 23 4
- 147 4
- 159 4
- 167 4
- 180 4
- 374 4
- 391 4
- 4 3
- 33 3
- 87 3
- 88 3
- 129 3
- 135 3
- 141 3
- 150 3
- 151 3
- 153 3
- 158 3
- 182 3
- 187 3
- 195 3
- 203 3
- 220 3
- 225 3
- 229 3
- 241 3
- 264 3
- 285 3
- 295 3
- 310 3
- 360 3
- 371 3
- 375 3
- 390 3
- 402 3
- 3 2
- 12 2
- 13 2
- 14 2
- 21 2
- 24 2
- 29 2
- 37 2
- 52 2
- 67 2
- 79 2
- 95 2
- 100 2
- 102 2
- 106 2
- 122 2
- 132 2
- 138 2
- 142 2
- 144 2
- 145 2
- 146 2
- 155 2
- 165 2
- 169 2
- 170 2
- 189 2
- 190 2
- 193 2
- 202 2
- 205 2
- 206 2
- 216 2
- 222 2
- 224 2
- 227 2
- 228 2
- 231 2
- 232 2
- 234 2
- 237 2
- 242 2
- 245 2
- 255 2
- 261 2
- 268 2
- 279 2
- 282 2
- 288 2
- 291 2
- 298 2
- 302 2
- 311 2
- 318 2
- 329 2
- 333 2
- 341 2
- 346 2
- 353 2
- 363 2
- 365 2
- 370 2
- 385 2
- 389 2
- 1 1
- 16 1
- 19 1
- 25 1
- 27 1
- 30 1
- 36 1
- 42 1
- 44 1
- 45 1
- 48 1
- 51 1
- 56 1
- 59 1
- 61 1
- 62 1
- 64 1
- 69 1
- 71 1
- 72 1
- 74 1
- 76 1
- 89 1
- 97 1
- 110 1
- 111 1
- 113 1
- 116 1
- 118 1
- 130 1
- 133 1
- 152 1
- 161 1
- 163 1
- 164 1
- 168 1
- 173 1
- 174 1
- 176 1
- 179 1
- 184 1
- 198 1
- 199 1
- 214 1
state 1
- Michigan 786
fips 1
- 26045 · 786 ✖
county 1
- Eaton 786
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);