ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26005 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 500 ✖
- 1 7
- 27041 7
- 27094 7
- 27133 7
- 27205 7
- 27287 7
- 17563 5
- 19899 5
- 20295 5
- 22475 5
- 27030 5
- 573 4
- 11191 4
- 11209 4
- 11234 4
- 11266 4
- 11339 4
- 12148 4
- 26610 4
- 2 3
- 18 3
- 301 3
- 507 3
- 1015 3
- 5509 3
- 5758 3
- 11079 3
- 11165 3
- 11183 3
- 11186 3
- 11200 3
- 11224 3
- 11247 3
- 11299 3
- 11378 3
- 11463 3
- 11617 3
- 11765 3
- 11950 3
- 12371 3
- 12676 3
- 12992 3
- 13383 3
- 13729 3
- 14151 3
- 14505 3
- 14894 3
- 15467 3
- 16069 3
- 17036 3
- 18568 3
- 19120 3
- 19616 3
- 21376 3
- 23955 3
- 25344 3
- 26060 3
- 26478 3
- 26662 3
- 26822 3
- 26875 3
- 26938 3
- 26979 3
- 27008 3
- 27448 3
- 5 2
- 19 2
- 23 2
- 25 2
- 210 2
- 258 2
- 263 2
- 288 2
- 303 2
- 529 2
- 663 2
- 694 2
- 729 2
- 737 2
- 765 2
- 815 2
- 901 2
- 1201 2
- 1503 2
- 1941 2
- 2596 2
- 3348 2
- 3655 2
- 3870 2
- 4496 2
- 4955 2
- 5355 2
- 5620 2
- 5865 2
- 6190 2
- 6491 2
- 6734 2
- 6918 2
- 7055 2
- 7145 2
- 7211 2
- 7298 2
- 7405 2
- 7557 2
- 7752 2
- 8048 2
- 8478 2
- 8985 2
- 9569 2
- 10015 2
- 10353 2
- 10640 2
- 10827 2
- 11000 2
- 11118 2
- 11151 2
- 11508 2
- 11561 2
- 11662 2
- 11699 2
- 11816 2
- 11888 2
- 12019 2
- 12088 2
- 12284 2
- 12462 2
- 12592 2
- 12787 2
- 12908 2
- 13137 2
- 13245 2
- 13508 2
- 13617 2
- 13859 2
- 14011 2
- 14270 2
- 14391 2
- 14616 2
- 14751 2
- 15038 2
- 15252 2
- 15630 2
- 15757 2
- 16489 2
- 16728 2
- 17299 2
- 17979 2
- 18243 2
- 18780 2
- 18988 2
- 19328 2
- 19494 2
- 19758 2
- 20135 2
- 20764 2
- 21069 2
- 21803 2
- 22184 2
- 23475 2
- 24578 2
- 24955 2
- 25605 2
- 25878 2
- 26206 2
- 26352 2
- 26555 2
- 26753 2
- 26838 2
- 26854 2
- 26894 2
- 26927 2
- 26946 2
- 26961 2
- 26985 2
- 26998 2
- 27014 2
- 27022 2
- 3 1
- 6 1
- 10 1
- 14 1
- 15 1
- 21 1
- 29 1
- 33 1
- 41 1
- 42 1
- 47 1
- 50 1
- 56 1
- 60 1
- 65 1
- 69 1
- 72 1
- 84 1
- 94 1
- 98 1
- 104 1
- 108 1
- 113 1
- 116 1
- 120 1
- 124 1
- 126 1
- 130 1
- 136 1
- 150 1
- 157 1
- 161 1
- 165 1
- 168 1
- 173 1
- 174 1
- 179 1
- 184 1
- 186 1
- 191 1
- 195 1
- 197 1
- 202 1
- 211 1
- 212 1
- 214 1
- 216 1
- 217 1
- 218 1
- 257 1
- 261 1
- 266 1
- 268 1
- 273 1
- 274 1
- 277 1
- 280 1
- 283 1
- 286 1
- 287 1
- 291 1
- 292 1
- 297 1
- 299 1
- 302 1
- 306 1
- 308 1
- 312 1
- 317 1
- 325 1
- 328 1
- 331 1
- 333 1
- 338 1
- 346 1
- 353 1
- 358 1
- 362 1
- 371 1
- 373 1
- 378 1
- 388 1
- 400 1
- 404 1
- 408 1
- 415 1
- 424 1
- 435 1
- 440 1
- 443 1
- 449 1
- 458 1
- 465 1
- 470 1
- 472 1
- 477 1
- 482 1
- 485 1
- 495 1
- 498 1
- 504 1
- 505 1
- 510 1
- 522 1
- 532 1
- 542 1
- 548 1
- 549 1
- 564 1
- 571 1
- 572 1
- 583 1
- 597 1
- 600 1
- 606 1
- 613 1
- 616 1
- 620 1
- 630 1
- 637 1
- 643 1
- 644 1
- 648 1
- 650 1
- 658 1
- 669 1
- 672 1
- 680 1
- 684 1
- 690 1
- 702 1
- 711 1
- 713 1
- 718 1
- 724 1
- 743 1
- 752 1
- 755 1
- 774 1
- 776 1
- 785 1
- 791 1
- 805 1
- 834 1
- 850 1
- 859 1
- 873 1
- 888 1
- 927 1
- 943 1
- 961 1
- 989 1
- 1061 1
- 1088 1
- 1109 1
- 1142 1
- 1165 1
- 1265 1
- 1289 1
- 1325 1
- 1368 1
- 1434 1
- 1591 1
- 1644 1
- 1716 1
- 1800 1
- 1857 1
- 2100 1
- 2185 1
- 2266 1
- 2383 1
- 2496 1
- 2818 1
- 2945 1
- 3020 1
- 3138 1
- 3212 1
- 3505 1
- 3612 1
- 3813 1
- 4065 1
- 4151 1
- 4214 1
- 4325 1
- 4429 1
- 4624 1
- 4686 1
- 4758 1
- 4857 1
- 4892 1
- 5065 1
- 5102 1
- 5185 1
- 5244 1
- 5298 1
- 5421 1
- 5477 1
- 5660 1
- 5703 1
- 5928 1
- 5964 1
- 6029 1
- 6085 1
- 6141 1
- 6256 1
- 6284 1
- 6338 1
- 6409 1
- 6457 1
- 6550 1
- 6579 1
- 6641 1
- 6671 1
- 6698 1
- 6780 1
- 6800 1
- 6848 1
- 6878 1
- 6899 1
- 6952 1
- 6973 1
- 6991 1
- 7019 1
- 7044 1
- 7072 1
- 7076 1
- 7087 1
- 7110 1
- 7134 1
- 7163 1
- 7178 1
- 7193 1
- 7200 1
- 7202 1
- 7235 1
- 7238 1
- 7256 1
- 7266 1
- 7287 1
- 7316 1
- 7331 1
- 7348 1
- 7367 1
- 7394 1
- 7434 1
- 7443 1
- 7472 1
- 7492 1
- 7533 1
- 7598 1
- 7623 1
- 7654 1
- 7679 1
- 7729 1
- 7809 1
- 7848 1
- 7920 1
- 7964 1
- 8011 1
- 8123 1
- 8184 1
- 8273 1
- 8341 1
- 8396 1
- 8578 1
- 8633 1
- 8738 1
- 8815 1
- 8889 1
- 9076 1
- 9191 1
- 9324 1
- 9420 1
- 9518 1
- 9700 1
- 9755 1
- 9828 1
- 9906 1
- 9961 1
- 10120 1
- 10176 1
- 10237 1
- 10277 1
- 10308 1
- 10416 1
- 10453 1
- 10491 1
- 10558 1
- 10616 1
- 10676 1
- 10715 1
- 10748 1
- 10784 1
- 10815 1
- 10859 1
- 10900 1
- 10933 1
- 10957 1
- 10980 1
- 11019 1
- 11032 1
- 11051 1
- 11060 1
- 11073 1
- 11092 1
- 11099 1
- 11107 1
- 11117 1
- 11124 1
- 11134 1
- 11135 1
- 11146 1
- 11149 1
- 11154 1
- 11155 1
- 11158 1
- 11161 1
- 11173 1
- 11177 1
- 11182 1
- 11184 1
- 11189 1
- 12238 1
state 1
- Michigan 784
fips 1
- 26005 · 784 ✖
county 1
- Allegan 784
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6521 | 6521 | 2020-03-21 | Allegan | Michigan | 26005 | 1 | 0 |
7598 | 7598 | 2020-03-22 | Allegan | Michigan | 26005 | 1 | 0 |
8770 | 8770 | 2020-03-23 | Allegan | Michigan | 26005 | 1 | 0 |
10059 | 10059 | 2020-03-24 | Allegan | Michigan | 26005 | 1 | 0 |
11471 | 11471 | 2020-03-25 | Allegan | Michigan | 26005 | 1 | 0 |
13052 | 13052 | 2020-03-26 | Allegan | Michigan | 26005 | 1 | 0 |
14760 | 14760 | 2020-03-27 | Allegan | Michigan | 26005 | 1 | 0 |
16580 | 16580 | 2020-03-28 | Allegan | Michigan | 26005 | 2 | 0 |
18495 | 18495 | 2020-03-29 | Allegan | Michigan | 26005 | 2 | 0 |
20511 | 20511 | 2020-03-30 | Allegan | Michigan | 26005 | 2 | 0 |
22620 | 22620 | 2020-03-31 | Allegan | Michigan | 26005 | 3 | 0 |
24799 | 24799 | 2020-04-01 | Allegan | Michigan | 26005 | 5 | 0 |
27051 | 27051 | 2020-04-02 | Allegan | Michigan | 26005 | 5 | 0 |
29369 | 29369 | 2020-04-03 | Allegan | Michigan | 26005 | 6 | 0 |
31747 | 31747 | 2020-04-04 | Allegan | Michigan | 26005 | 10 | 0 |
34172 | 34172 | 2020-04-05 | Allegan | Michigan | 26005 | 14 | 0 |
36631 | 36631 | 2020-04-06 | Allegan | Michigan | 26005 | 15 | 0 |
39139 | 39139 | 2020-04-07 | Allegan | Michigan | 26005 | 18 | 0 |
41691 | 41691 | 2020-04-08 | Allegan | Michigan | 26005 | 18 | 0 |
44267 | 44267 | 2020-04-09 | Allegan | Michigan | 26005 | 18 | 0 |
46875 | 46875 | 2020-04-10 | Allegan | Michigan | 26005 | 19 | 0 |
49517 | 49517 | 2020-04-11 | Allegan | Michigan | 26005 | 19 | 0 |
52187 | 52187 | 2020-04-12 | Allegan | Michigan | 26005 | 21 | 0 |
54868 | 54868 | 2020-04-13 | Allegan | Michigan | 26005 | 23 | 0 |
57566 | 57566 | 2020-04-14 | Allegan | Michigan | 26005 | 23 | 0 |
60276 | 60276 | 2020-04-15 | Allegan | Michigan | 26005 | 25 | 0 |
62997 | 62997 | 2020-04-16 | Allegan | Michigan | 26005 | 25 | 0 |
65735 | 65735 | 2020-04-17 | Allegan | Michigan | 26005 | 29 | 0 |
68485 | 68485 | 2020-04-18 | Allegan | Michigan | 26005 | 33 | 0 |
71249 | 71249 | 2020-04-19 | Allegan | Michigan | 26005 | 41 | 0 |
74021 | 74021 | 2020-04-20 | Allegan | Michigan | 26005 | 42 | 0 |
76801 | 76801 | 2020-04-21 | Allegan | Michigan | 26005 | 47 | 0 |
79587 | 79587 | 2020-04-22 | Allegan | Michigan | 26005 | 50 | 0 |
82382 | 82382 | 2020-04-23 | Allegan | Michigan | 26005 | 56 | 0 |
85186 | 85186 | 2020-04-24 | Allegan | Michigan | 26005 | 60 | 1 |
87996 | 87996 | 2020-04-25 | Allegan | Michigan | 26005 | 65 | 1 |
90812 | 90812 | 2020-04-26 | Allegan | Michigan | 26005 | 69 | 1 |
93633 | 93633 | 2020-04-27 | Allegan | Michigan | 26005 | 72 | 1 |
96468 | 96468 | 2020-04-28 | Allegan | Michigan | 26005 | 84 | 1 |
99314 | 99314 | 2020-04-29 | Allegan | Michigan | 26005 | 94 | 2 |
102166 | 102166 | 2020-04-30 | Allegan | Michigan | 26005 | 98 | 2 |
105026 | 105026 | 2020-05-01 | Allegan | Michigan | 26005 | 104 | 2 |
107890 | 107890 | 2020-05-02 | Allegan | Michigan | 26005 | 108 | 2 |
110762 | 110762 | 2020-05-03 | Allegan | Michigan | 26005 | 113 | 2 |
113640 | 113640 | 2020-05-04 | Allegan | Michigan | 26005 | 116 | 2 |
116521 | 116521 | 2020-05-05 | Allegan | Michigan | 26005 | 120 | 2 |
119482 | 119482 | 2020-05-06 | Allegan | Michigan | 26005 | 124 | 2 |
122454 | 122454 | 2020-05-07 | Allegan | Michigan | 26005 | 126 | 2 |
125436 | 125436 | 2020-05-08 | Allegan | Michigan | 26005 | 130 | 2 |
128423 | 128423 | 2020-05-09 | Allegan | Michigan | 26005 | 136 | 2 |
131413 | 131413 | 2020-05-10 | Allegan | Michigan | 26005 | 150 | 2 |
134404 | 134404 | 2020-05-11 | Allegan | Michigan | 26005 | 157 | 2 |
137394 | 137394 | 2020-05-12 | Allegan | Michigan | 26005 | 161 | 2 |
140388 | 140388 | 2020-05-13 | Allegan | Michigan | 26005 | 165 | 2 |
143383 | 143383 | 2020-05-14 | Allegan | Michigan | 26005 | 168 | 2 |
146383 | 146383 | 2020-05-15 | Allegan | Michigan | 26005 | 173 | 2 |
149388 | 149388 | 2020-05-16 | Allegan | Michigan | 26005 | 174 | 2 |
152399 | 152399 | 2020-05-17 | Allegan | Michigan | 26005 | 179 | 2 |
155413 | 155413 | 2020-05-18 | Allegan | Michigan | 26005 | 186 | 2 |
158431 | 158431 | 2020-05-19 | Allegan | Michigan | 26005 | 184 | 3 |
161457 | 161457 | 2020-05-20 | Allegan | Michigan | 26005 | 191 | 5 |
164486 | 164486 | 2020-05-21 | Allegan | Michigan | 26005 | 195 | 5 |
167522 | 167522 | 2020-05-22 | Allegan | Michigan | 26005 | 197 | 6 |
170559 | 170559 | 2020-05-23 | Allegan | Michigan | 26005 | 202 | 7 |
173601 | 173601 | 2020-05-24 | Allegan | Michigan | 26005 | 210 | 7 |
176644 | 176644 | 2020-05-25 | Allegan | Michigan | 26005 | 210 | 6 |
179688 | 179688 | 2020-05-26 | Allegan | Michigan | 26005 | 212 | 6 |
182734 | 182734 | 2020-05-27 | Allegan | Michigan | 26005 | 211 | 6 |
185789 | 185789 | 2020-05-28 | Allegan | Michigan | 26005 | 214 | 6 |
188847 | 188847 | 2020-05-29 | Allegan | Michigan | 26005 | 216 | 6 |
191911 | 191911 | 2020-05-30 | Allegan | Michigan | 26005 | 217 | 6 |
194979 | 194979 | 2020-05-31 | Allegan | Michigan | 26005 | 218 | 6 |
198050 | 198050 | 2020-06-01 | Allegan | Michigan | 26005 | 257 | 6 |
201122 | 201122 | 2020-06-02 | Allegan | Michigan | 26005 | 258 | 6 |
204199 | 204199 | 2020-06-03 | Allegan | Michigan | 26005 | 258 | 6 |
207280 | 207280 | 2020-06-04 | Allegan | Michigan | 26005 | 261 | 6 |
210361 | 210361 | 2020-06-05 | Allegan | Michigan | 26005 | 263 | 6 |
213445 | 213445 | 2020-06-06 | Allegan | Michigan | 26005 | 263 | 6 |
216533 | 216533 | 2020-06-07 | Allegan | Michigan | 26005 | 266 | 6 |
219625 | 219625 | 2020-06-08 | Allegan | Michigan | 26005 | 268 | 6 |
222720 | 222720 | 2020-06-09 | Allegan | Michigan | 26005 | 273 | 6 |
225817 | 225817 | 2020-06-10 | Allegan | Michigan | 26005 | 274 | 6 |
228919 | 228919 | 2020-06-11 | Allegan | Michigan | 26005 | 277 | 6 |
232023 | 232023 | 2020-06-12 | Allegan | Michigan | 26005 | 280 | 6 |
235128 | 235128 | 2020-06-13 | Allegan | Michigan | 26005 | 283 | 6 |
238235 | 238235 | 2020-06-14 | Allegan | Michigan | 26005 | 286 | 6 |
241344 | 241344 | 2020-06-15 | Allegan | Michigan | 26005 | 287 | 6 |
244455 | 244455 | 2020-06-16 | Allegan | Michigan | 26005 | 288 | 6 |
247568 | 247568 | 2020-06-17 | Allegan | Michigan | 26005 | 288 | 6 |
250680 | 250680 | 2020-06-18 | Allegan | Michigan | 26005 | 291 | 6 |
253795 | 253795 | 2020-06-19 | Allegan | Michigan | 26005 | 292 | 6 |
256915 | 256915 | 2020-06-20 | Allegan | Michigan | 26005 | 297 | 6 |
260041 | 260041 | 2020-06-21 | Allegan | Michigan | 26005 | 299 | 6 |
263170 | 263170 | 2020-06-22 | Allegan | Michigan | 26005 | 301 | 6 |
266296 | 266296 | 2020-06-23 | Allegan | Michigan | 26005 | 301 | 6 |
269429 | 269429 | 2020-06-24 | Allegan | Michigan | 26005 | 303 | 6 |
272566 | 272566 | 2020-06-25 | Allegan | Michigan | 26005 | 301 | 6 |
275709 | 275709 | 2020-06-26 | Allegan | Michigan | 26005 | 302 | 6 |
278857 | 278857 | 2020-06-27 | Allegan | Michigan | 26005 | 303 | 6 |
282005 | 282005 | 2020-06-28 | Allegan | Michigan | 26005 | 306 | 6 |
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);