ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 26081 and state = "Michigan" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1479 | 1479 | 2020-03-12 | Kent | Michigan | 26081 | 3 | 0 |
1760 | 1760 | 2020-03-13 | Kent | Michigan | 26081 | 3 | 0 |
2103 | 2103 | 2020-03-14 | Kent | Michigan | 26081 | 3 | 0 |
2506 | 2506 | 2020-03-15 | Kent | Michigan | 26081 | 5 | 0 |
2956 | 2956 | 2020-03-16 | Kent | Michigan | 26081 | 5 | 0 |
3458 | 3458 | 2020-03-17 | Kent | Michigan | 26081 | 5 | 0 |
4041 | 4041 | 2020-03-18 | Kent | Michigan | 26081 | 5 | 0 |
4749 | 4749 | 2020-03-19 | Kent | Michigan | 26081 | 12 | 0 |
5568 | 5568 | 2020-03-20 | Kent | Michigan | 26081 | 12 | 0 |
6533 | 6533 | 2020-03-21 | Kent | Michigan | 26081 | 21 | 1 |
7613 | 7613 | 2020-03-22 | Kent | Michigan | 26081 | 21 | 1 |
8787 | 8787 | 2020-03-23 | Kent | Michigan | 26081 | 28 | 1 |
10079 | 10079 | 2020-03-24 | Kent | Michigan | 26081 | 31 | 1 |
11492 | 11492 | 2020-03-25 | Kent | Michigan | 26081 | 36 | 1 |
13075 | 13075 | 2020-03-26 | Kent | Michigan | 26081 | 41 | 1 |
14787 | 14787 | 2020-03-27 | Kent | Michigan | 26081 | 45 | 1 |
16607 | 16607 | 2020-03-28 | Kent | Michigan | 26081 | 53 | 1 |
18523 | 18523 | 2020-03-29 | Kent | Michigan | 26081 | 72 | 1 |
20542 | 20542 | 2020-03-30 | Kent | Michigan | 26081 | 96 | 1 |
22653 | 22653 | 2020-03-31 | Kent | Michigan | 26081 | 108 | 1 |
24832 | 24832 | 2020-04-01 | Kent | Michigan | 26081 | 119 | 2 |
27085 | 27085 | 2020-04-02 | Kent | Michigan | 26081 | 125 | 2 |
29403 | 29403 | 2020-04-03 | Kent | Michigan | 26081 | 136 | 2 |
31781 | 31781 | 2020-04-04 | Kent | Michigan | 26081 | 153 | 3 |
34206 | 34206 | 2020-04-05 | Kent | Michigan | 26081 | 165 | 3 |
36665 | 36665 | 2020-04-06 | Kent | Michigan | 26081 | 177 | 5 |
39173 | 39173 | 2020-04-07 | Kent | Michigan | 26081 | 187 | 7 |
41725 | 41725 | 2020-04-08 | Kent | Michigan | 26081 | 207 | 9 |
44301 | 44301 | 2020-04-09 | Kent | Michigan | 26081 | 233 | 10 |
46909 | 46909 | 2020-04-10 | Kent | Michigan | 26081 | 250 | 13 |
49552 | 49552 | 2020-04-11 | Kent | Michigan | 26081 | 270 | 13 |
52222 | 52222 | 2020-04-12 | Kent | Michigan | 26081 | 287 | 13 |
54903 | 54903 | 2020-04-13 | Kent | Michigan | 26081 | 311 | 13 |
57601 | 57601 | 2020-04-14 | Kent | Michigan | 26081 | 325 | 14 |
60311 | 60311 | 2020-04-15 | Kent | Michigan | 26081 | 355 | 16 |
63033 | 63033 | 2020-04-16 | Kent | Michigan | 26081 | 386 | 17 |
65771 | 65771 | 2020-04-17 | Kent | Michigan | 26081 | 431 | 20 |
68522 | 68522 | 2020-04-18 | Kent | Michigan | 26081 | 461 | 23 |
71286 | 71286 | 2020-04-19 | Kent | Michigan | 26081 | 504 | 25 |
74058 | 74058 | 2020-04-20 | Kent | Michigan | 26081 | 551 | 24 |
76838 | 76838 | 2020-04-21 | Kent | Michigan | 26081 | 628 | 25 |
79624 | 79624 | 2020-04-22 | Kent | Michigan | 26081 | 759 | 25 |
82419 | 82419 | 2020-04-23 | Kent | Michigan | 26081 | 817 | 27 |
85223 | 85223 | 2020-04-24 | Kent | Michigan | 26081 | 908 | 29 |
88033 | 88033 | 2020-04-25 | Kent | Michigan | 26081 | 931 | 32 |
90849 | 90849 | 2020-04-26 | Kent | Michigan | 26081 | 1033 | 32 |
93670 | 93670 | 2020-04-27 | Kent | Michigan | 26081 | 1102 | 34 |
96505 | 96505 | 2020-04-28 | Kent | Michigan | 26081 | 1307 | 33 |
99351 | 99351 | 2020-04-29 | Kent | Michigan | 26081 | 1397 | 33 |
102203 | 102203 | 2020-04-30 | Kent | Michigan | 26081 | 1482 | 33 |
105063 | 105063 | 2020-05-01 | Kent | Michigan | 26081 | 1603 | 36 |
107927 | 107927 | 2020-05-02 | Kent | Michigan | 26081 | 1700 | 36 |
110799 | 110799 | 2020-05-03 | Kent | Michigan | 26081 | 1789 | 39 |
113677 | 113677 | 2020-05-04 | Kent | Michigan | 26081 | 1857 | 39 |
116558 | 116558 | 2020-05-05 | Kent | Michigan | 26081 | 1917 | 40 |
119519 | 119519 | 2020-05-06 | Kent | Michigan | 26081 | 2019 | 40 |
122491 | 122491 | 2020-05-07 | Kent | Michigan | 26081 | 2079 | 41 |
125473 | 125473 | 2020-05-08 | Kent | Michigan | 26081 | 2138 | 41 |
128460 | 128460 | 2020-05-09 | Kent | Michigan | 26081 | 2216 | 41 |
131450 | 131450 | 2020-05-10 | Kent | Michigan | 26081 | 2284 | 41 |
134441 | 134441 | 2020-05-11 | Kent | Michigan | 26081 | 2335 | 42 |
137431 | 137431 | 2020-05-12 | Kent | Michigan | 26081 | 2420 | 45 |
140425 | 140425 | 2020-05-13 | Kent | Michigan | 26081 | 2450 | 47 |
143420 | 143420 | 2020-05-14 | Kent | Michigan | 26081 | 2631 | 48 |
146420 | 146420 | 2020-05-15 | Kent | Michigan | 26081 | 2709 | 53 |
149425 | 149425 | 2020-05-16 | Kent | Michigan | 26081 | 2770 | 54 |
152436 | 152436 | 2020-05-17 | Kent | Michigan | 26081 | 2829 | 55 |
155450 | 155450 | 2020-05-18 | Kent | Michigan | 26081 | 2872 | 56 |
158468 | 158468 | 2020-05-19 | Kent | Michigan | 26081 | 2938 | 58 |
161494 | 161494 | 2020-05-20 | Kent | Michigan | 26081 | 3040 | 60 |
164523 | 164523 | 2020-05-21 | Kent | Michigan | 26081 | 3149 | 62 |
167559 | 167559 | 2020-05-22 | Kent | Michigan | 26081 | 3235 | 65 |
170596 | 170596 | 2020-05-23 | Kent | Michigan | 26081 | 3312 | 67 |
173638 | 173638 | 2020-05-24 | Kent | Michigan | 26081 | 3363 | 67 |
176681 | 176681 | 2020-05-25 | Kent | Michigan | 26081 | 3389 | 68 |
179725 | 179725 | 2020-05-26 | Kent | Michigan | 26081 | 3424 | 72 |
182771 | 182771 | 2020-05-27 | Kent | Michigan | 26081 | 3458 | 76 |
185826 | 185826 | 2020-05-28 | Kent | Michigan | 26081 | 3544 | 79 |
188884 | 188884 | 2020-05-29 | Kent | Michigan | 26081 | 3600 | 80 |
191948 | 191948 | 2020-05-30 | Kent | Michigan | 26081 | 3646 | 84 |
195016 | 195016 | 2020-05-31 | Kent | Michigan | 26081 | 3720 | 85 |
198087 | 198087 | 2020-06-01 | Kent | Michigan | 26081 | 3753 | 89 |
201160 | 201160 | 2020-06-02 | Kent | Michigan | 26081 | 3783 | 93 |
204237 | 204237 | 2020-06-03 | Kent | Michigan | 26081 | 3821 | 93 |
207318 | 207318 | 2020-06-04 | Kent | Michigan | 26081 | 3857 | 95 |
210399 | 210399 | 2020-06-05 | Kent | Michigan | 26081 | 4136 | 96 |
213483 | 213483 | 2020-06-06 | Kent | Michigan | 26081 | 4170 | 100 |
216571 | 216571 | 2020-06-07 | Kent | Michigan | 26081 | 4196 | 101 |
219663 | 219663 | 2020-06-08 | Kent | Michigan | 26081 | 4209 | 104 |
222758 | 222758 | 2020-06-09 | Kent | Michigan | 26081 | 4231 | 107 |
225855 | 225855 | 2020-06-10 | Kent | Michigan | 26081 | 4267 | 108 |
228957 | 228957 | 2020-06-11 | Kent | Michigan | 26081 | 4297 | 112 |
232061 | 232061 | 2020-06-12 | Kent | Michigan | 26081 | 4426 | 114 |
235166 | 235166 | 2020-06-13 | Kent | Michigan | 26081 | 4433 | 114 |
238273 | 238273 | 2020-06-14 | Kent | Michigan | 26081 | 4467 | 116 |
241382 | 241382 | 2020-06-15 | Kent | Michigan | 26081 | 4469 | 116 |
244493 | 244493 | 2020-06-16 | Kent | Michigan | 26081 | 4477 | 116 |
247606 | 247606 | 2020-06-17 | Kent | Michigan | 26081 | 4497 | 116 |
250718 | 250718 | 2020-06-18 | Kent | Michigan | 26081 | 4532 | 118 |
253833 | 253833 | 2020-06-19 | Kent | Michigan | 26081 | 4557 | 122 |
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);