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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
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 |
149423 | 149423 | 2020-05-16 | Kalamazoo | Michigan | 26077 | 708 | 42 |
152434 | 152434 | 2020-05-17 | Kalamazoo | Michigan | 26077 | 707 | 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);