ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Kalamazoo" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 267 ✖
- 403 22
- 402 19
- 673 14
- 96 13
- 91 12
- 401 11
- 406 10
- 63 8
- 83 8
- 86 8
- 0 7
- 67 7
- 68 7
- 88 7
- 316 7
- 325 7
- 418 7
- 434 7
- 666 7
- 670 7
- 672 7
- 674 7
- 102 6
- 324 6
- 390 6
- 396 6
- 1 5
- 11 5
- 70 5
- 74 5
- 98 5
- 315 5
- 319 5
- 321 5
- 323 5
- 327 5
- 328 5
- 410 5
- 414 5
- 426 5
- 432 5
- 437 5
- 458 5
- 467 5
- 485 5
- 496 5
- 525 5
- 536 5
- 548 5
- 573 5
- 646 5
- 660 5
- 665 5
- 669 5
- 7 4
- 9 4
- 61 4
- 78 4
- 87 4
- 89 4
- 93 4
- 181 4
- 228 4
- 240 4
- 309 4
- 346 4
- 407 4
- 439 4
- 631 4
- 3 3
- 8 3
- 12 3
- 18 3
- 42 3
- 47 3
- 54 3
- 58 3
- 72 3
- 82 3
- 163 3
- 274 3
- 304 3
- 313 3
- 329 3
- 333 3
- 351 3
- 397 3
- 398 3
- 405 3
- 440 3
- 443 3
- 450 3
- 472 3
- 479 3
- 511 3
- 557 3
- 593 3
- 606 3
- 615 3
- 624 3
- 634 3
- 655 3
- 675 3
- 6 2
- 22 2
- 25 2
- 36 2
- 45 2
- 51 2
- 64 2
- 65 2
- 66 2
- 71 2
- 76 2
- 81 2
- 84 2
- 92 2
- 94 2
- 106 2
- 114 2
- 118 2
- 129 2
- 135 2
- 143 2
- 157 2
- 161 2
- 170 2
- 201 2
- 221 2
- 231 2
- 247 2
- 272 2
- 273 2
- 285 2
- 287 2
- 302 2
- 318 2
- 320 2
- 330 2
- 338 2
- 344 2
- 353 2
- 358 2
- 365 2
- 369 2
- 381 2
- 385 2
- 394 2
- 411 2
- 423 2
- 429 2
- 430 2
- 441 2
- 444 2
- 446 2
- 452 2
- 454 2
- 465 2
- 471 2
- 474 2
- 478 2
- 480 2
- 488 2
- 491 2
- 503 2
- 512 2
- 518 2
- 540 2
- 550 2
- 555 2
- 559 2
- 569 2
- 584 2
- 595 2
- 601 2
- 608 2
- 613 2
- 616 2
- 623 2
- 625 2
- 643 2
- 652 2
- 656 2
- 658 2
- 661 2
- 668 2
- 5 1
- 10 1
- 13 1
- 23 1
- 27 1
- 29 1
- 32 1
- 40 1
- 41 1
- 44 1
- 49 1
- 55 1
- 57 1
- 59 1
- 69 1
- 73 1
- 80 1
- 85 1
- 90 1
- 99 1
- 100 1
- 105 1
- 110 1
- 112 1
- 115 1
- 121 1
- 126 1
- 131 1
- 134 1
- 139 1
- 144 1
- 147 1
- 149 1
- 150 1
- 154 1
- 158 1
- 159 1
- 166 1
- 172 1
- 174 1
- 180 1
- 190 1
- 192 1
- 202 1
- 208 1
- 209 1
- 216 1
- 218 1
- 225 1
- 234 1
- 250 1
- 264 1
- 268 1
- 277 1
- 278 1
- 284 1
- 292 1
- 293 1
- 307 1
- 312 1
- 322 1
- 326 1
- 331 1
- 336 1
- 341 1
- 343 1
- 345 1
- 355 1
- 357 1
- 361 1
- 363 1
- 364 1
- 370 1
- 376 1
- 377 1
- 386 1
- 389 1
- 392 1
- 393 1
- 399 1
- 400 1
state 1
- Michigan 782
fips 1
- 26077 782
county 1
- Kalamazoo · 782 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
8786 | 8786 | 2020-03-23 | Kalamazoo | Michigan | 26077 | 3 | 0 |
10077 | 10077 | 2020-03-24 | Kalamazoo | Michigan | 26077 | 3 | 0 |
11490 | 11490 | 2020-03-25 | Kalamazoo | Michigan | 26077 | 5 | 0 |
13073 | 13073 | 2020-03-26 | Kalamazoo | Michigan | 26077 | 10 | 0 |
14785 | 14785 | 2020-03-27 | Kalamazoo | Michigan | 26077 | 11 | 0 |
16605 | 16605 | 2020-03-28 | Kalamazoo | Michigan | 26077 | 15 | 0 |
18521 | 18521 | 2020-03-29 | Kalamazoo | Michigan | 26077 | 19 | 0 |
20540 | 20540 | 2020-03-30 | Kalamazoo | Michigan | 26077 | 24 | 1 |
22651 | 22651 | 2020-03-31 | Kalamazoo | Michigan | 26077 | 24 | 1 |
24830 | 24830 | 2020-04-01 | Kalamazoo | Michigan | 26077 | 30 | 1 |
27083 | 27083 | 2020-04-02 | Kalamazoo | Michigan | 26077 | 34 | 1 |
29401 | 29401 | 2020-04-03 | Kalamazoo | Michigan | 26077 | 40 | 1 |
31779 | 31779 | 2020-04-04 | Kalamazoo | Michigan | 26077 | 45 | 3 |
34204 | 34204 | 2020-04-05 | Kalamazoo | Michigan | 26077 | 53 | 3 |
36663 | 36663 | 2020-04-06 | Kalamazoo | Michigan | 26077 | 58 | 3 |
39171 | 39171 | 2020-04-07 | Kalamazoo | Michigan | 26077 | 64 | 5 |
41723 | 41723 | 2020-04-08 | Kalamazoo | Michigan | 26077 | 67 | 6 |
44299 | 44299 | 2020-04-09 | Kalamazoo | Michigan | 26077 | 74 | 6 |
46907 | 46907 | 2020-04-10 | Kalamazoo | Michigan | 26077 | 77 | 7 |
49550 | 49550 | 2020-04-11 | Kalamazoo | Michigan | 26077 | 79 | 7 |
52220 | 52220 | 2020-04-12 | Kalamazoo | Michigan | 26077 | 84 | 7 |
54901 | 54901 | 2020-04-13 | Kalamazoo | Michigan | 26077 | 91 | 7 |
57599 | 57599 | 2020-04-14 | Kalamazoo | Michigan | 26077 | 94 | 8 |
60309 | 60309 | 2020-04-15 | Kalamazoo | Michigan | 26077 | 103 | 8 |
63031 | 63031 | 2020-04-16 | Kalamazoo | Michigan | 26077 | 118 | 8 |
65769 | 65769 | 2020-04-17 | Kalamazoo | Michigan | 26077 | 130 | 9 |
68520 | 68520 | 2020-04-18 | Kalamazoo | Michigan | 26077 | 154 | 9 |
71284 | 71284 | 2020-04-19 | Kalamazoo | Michigan | 26077 | 166 | 9 |
74056 | 74056 | 2020-04-20 | Kalamazoo | Michigan | 26077 | 185 | 9 |
76836 | 76836 | 2020-04-21 | Kalamazoo | Michigan | 26077 | 201 | 10 |
79622 | 79622 | 2020-04-22 | Kalamazoo | Michigan | 26077 | 212 | 11 |
82417 | 82417 | 2020-04-23 | Kalamazoo | Michigan | 26077 | 229 | 11 |
85221 | 85221 | 2020-04-24 | Kalamazoo | Michigan | 26077 | 266 | 11 |
88031 | 88031 | 2020-04-25 | Kalamazoo | Michigan | 26077 | 280 | 11 |
90847 | 90847 | 2020-04-26 | Kalamazoo | Michigan | 26077 | 292 | 11 |
93668 | 93668 | 2020-04-27 | Kalamazoo | Michigan | 26077 | 300 | 12 |
96503 | 96503 | 2020-04-28 | Kalamazoo | Michigan | 26077 | 327 | 12 |
99349 | 99349 | 2020-04-29 | Kalamazoo | Michigan | 26077 | 348 | 12 |
102201 | 102201 | 2020-04-30 | Kalamazoo | Michigan | 26077 | 364 | 13 |
105061 | 105061 | 2020-05-01 | Kalamazoo | Michigan | 26077 | 405 | 18 |
107925 | 107925 | 2020-05-02 | Kalamazoo | Michigan | 26077 | 442 | 18 |
110797 | 110797 | 2020-05-03 | Kalamazoo | Michigan | 26077 | 456 | 18 |
113675 | 113675 | 2020-05-04 | Kalamazoo | Michigan | 26077 | 480 | 22 |
116556 | 116556 | 2020-05-05 | Kalamazoo | Michigan | 26077 | 489 | 22 |
119517 | 119517 | 2020-05-06 | Kalamazoo | Michigan | 26077 | 539 | 23 |
122489 | 122489 | 2020-05-07 | Kalamazoo | Michigan | 26077 | 561 | 25 |
125471 | 125471 | 2020-05-08 | Kalamazoo | Michigan | 26077 | 573 | 25 |
128458 | 128458 | 2020-05-09 | Kalamazoo | Michigan | 26077 | 591 | 27 |
131448 | 131448 | 2020-05-10 | Kalamazoo | Michigan | 26077 | 601 | 29 |
134439 | 134439 | 2020-05-11 | Kalamazoo | Michigan | 26077 | 622 | 32 |
137429 | 137429 | 2020-05-12 | Kalamazoo | Michigan | 26077 | 636 | 36 |
140423 | 140423 | 2020-05-13 | Kalamazoo | Michigan | 26077 | 643 | 36 |
143418 | 143418 | 2020-05-14 | Kalamazoo | Michigan | 26077 | 669 | 40 |
146418 | 146418 | 2020-05-15 | Kalamazoo | Michigan | 26077 | 679 | 41 |
152434 | 152434 | 2020-05-17 | Kalamazoo | Michigan | 26077 | 707 | 42 |
149423 | 149423 | 2020-05-16 | Kalamazoo | Michigan | 26077 | 708 | 42 |
155448 | 155448 | 2020-05-18 | Kalamazoo | Michigan | 26077 | 719 | 42 |
158466 | 158466 | 2020-05-19 | Kalamazoo | Michigan | 26077 | 739 | 44 |
161492 | 161492 | 2020-05-20 | Kalamazoo | Michigan | 26077 | 751 | 45 |
164521 | 164521 | 2020-05-21 | Kalamazoo | Michigan | 26077 | 762 | 45 |
167557 | 167557 | 2020-05-22 | Kalamazoo | Michigan | 26077 | 778 | 47 |
170594 | 170594 | 2020-05-23 | Kalamazoo | Michigan | 26077 | 793 | 47 |
173636 | 173636 | 2020-05-24 | Kalamazoo | Michigan | 26077 | 797 | 47 |
176679 | 176679 | 2020-05-25 | Kalamazoo | Michigan | 26077 | 801 | 49 |
179723 | 179723 | 2020-05-26 | Kalamazoo | Michigan | 26077 | 802 | 51 |
182769 | 182769 | 2020-05-27 | Kalamazoo | Michigan | 26077 | 814 | 51 |
185824 | 185824 | 2020-05-28 | Kalamazoo | Michigan | 26077 | 820 | 54 |
188882 | 188882 | 2020-05-29 | Kalamazoo | Michigan | 26077 | 833 | 54 |
191946 | 191946 | 2020-05-30 | Kalamazoo | Michigan | 26077 | 834 | 54 |
195014 | 195014 | 2020-05-31 | Kalamazoo | Michigan | 26077 | 844 | 55 |
198085 | 198085 | 2020-06-01 | Kalamazoo | Michigan | 26077 | 844 | 57 |
201158 | 201158 | 2020-06-02 | Kalamazoo | Michigan | 26077 | 848 | 58 |
204235 | 204235 | 2020-06-03 | Kalamazoo | Michigan | 26077 | 850 | 58 |
207316 | 207316 | 2020-06-04 | Kalamazoo | Michigan | 26077 | 858 | 58 |
210397 | 210397 | 2020-06-05 | Kalamazoo | Michigan | 26077 | 919 | 59 |
213481 | 213481 | 2020-06-06 | Kalamazoo | Michigan | 26077 | 926 | 61 |
216569 | 216569 | 2020-06-07 | Kalamazoo | Michigan | 26077 | 929 | 61 |
219661 | 219661 | 2020-06-08 | Kalamazoo | Michigan | 26077 | 934 | 61 |
222756 | 222756 | 2020-06-09 | Kalamazoo | Michigan | 26077 | 935 | 61 |
225853 | 225853 | 2020-06-10 | Kalamazoo | Michigan | 26077 | 940 | 63 |
228955 | 228955 | 2020-06-11 | Kalamazoo | Michigan | 26077 | 943 | 63 |
232059 | 232059 | 2020-06-12 | Kalamazoo | Michigan | 26077 | 949 | 63 |
235164 | 235164 | 2020-06-13 | Kalamazoo | Michigan | 26077 | 952 | 63 |
238271 | 238271 | 2020-06-14 | Kalamazoo | Michigan | 26077 | 954 | 63 |
241380 | 241380 | 2020-06-15 | Kalamazoo | Michigan | 26077 | 955 | 63 |
244491 | 244491 | 2020-06-16 | Kalamazoo | Michigan | 26077 | 958 | 63 |
247604 | 247604 | 2020-06-17 | Kalamazoo | Michigan | 26077 | 969 | 63 |
250716 | 250716 | 2020-06-18 | Kalamazoo | Michigan | 26077 | 977 | 64 |
253831 | 253831 | 2020-06-19 | Kalamazoo | Michigan | 26077 | 984 | 64 |
256951 | 256951 | 2020-06-20 | Kalamazoo | Michigan | 26077 | 995 | 65 |
260077 | 260077 | 2020-06-21 | Kalamazoo | Michigan | 26077 | 996 | 65 |
263206 | 263206 | 2020-06-22 | Kalamazoo | Michigan | 26077 | 996 | 66 |
266332 | 266332 | 2020-06-23 | Kalamazoo | Michigan | 26077 | 1002 | 66 |
269465 | 269465 | 2020-06-24 | Kalamazoo | Michigan | 26077 | 1017 | 67 |
272602 | 272602 | 2020-06-25 | Kalamazoo | Michigan | 26077 | 1042 | 67 |
275745 | 275745 | 2020-06-26 | Kalamazoo | Michigan | 26077 | 1048 | 67 |
278893 | 278893 | 2020-06-27 | Kalamazoo | Michigan | 26077 | 1055 | 67 |
282041 | 282041 | 2020-06-28 | Kalamazoo | Michigan | 26077 | 1063 | 67 |
285186 | 285186 | 2020-06-29 | Kalamazoo | Michigan | 26077 | 1069 | 67 |
288336 | 288336 | 2020-06-30 | Kalamazoo | Michigan | 26077 | 1084 | 67 |
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);