ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26021 and state = "Michigan" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6524 | 6524 | 2020-03-21 | Berrien | Michigan | 26021 | 2 | 0 |
7601 | 7601 | 2020-03-22 | Berrien | Michigan | 26021 | 3 | 0 |
8773 | 8773 | 2020-03-23 | Berrien | Michigan | 26021 | 5 | 0 |
10062 | 10062 | 2020-03-24 | Berrien | Michigan | 26021 | 8 | 0 |
11474 | 11474 | 2020-03-25 | Berrien | Michigan | 26021 | 10 | 0 |
13055 | 13055 | 2020-03-26 | Berrien | Michigan | 26021 | 11 | 0 |
14763 | 14763 | 2020-03-27 | Berrien | Michigan | 26021 | 18 | 0 |
16583 | 16583 | 2020-03-28 | Berrien | Michigan | 26021 | 22 | 0 |
18498 | 18498 | 2020-03-29 | Berrien | Michigan | 26021 | 29 | 0 |
20515 | 20515 | 2020-03-30 | Berrien | Michigan | 26021 | 32 | 1 |
22625 | 22625 | 2020-03-31 | Berrien | Michigan | 26021 | 35 | 1 |
24804 | 24804 | 2020-04-01 | Berrien | Michigan | 26021 | 38 | 1 |
27056 | 27056 | 2020-04-02 | Berrien | Michigan | 26021 | 40 | 1 |
29374 | 29374 | 2020-04-03 | Berrien | Michigan | 26021 | 52 | 1 |
31752 | 31752 | 2020-04-04 | Berrien | Michigan | 26021 | 56 | 1 |
34177 | 34177 | 2020-04-05 | Berrien | Michigan | 26021 | 58 | 1 |
36636 | 36636 | 2020-04-06 | Berrien | Michigan | 26021 | 60 | 2 |
39144 | 39144 | 2020-04-07 | Berrien | Michigan | 26021 | 64 | 2 |
41696 | 41696 | 2020-04-08 | Berrien | Michigan | 26021 | 72 | 2 |
44272 | 44272 | 2020-04-09 | Berrien | Michigan | 26021 | 80 | 2 |
46880 | 46880 | 2020-04-10 | Berrien | Michigan | 26021 | 88 | 2 |
49523 | 49523 | 2020-04-11 | Berrien | Michigan | 26021 | 94 | 3 |
52193 | 52193 | 2020-04-12 | Berrien | Michigan | 26021 | 104 | 4 |
54874 | 54874 | 2020-04-13 | Berrien | Michigan | 26021 | 105 | 4 |
57572 | 57572 | 2020-04-14 | Berrien | Michigan | 26021 | 111 | 5 |
60282 | 60282 | 2020-04-15 | Berrien | Michigan | 26021 | 123 | 7 |
63004 | 63004 | 2020-04-16 | Berrien | Michigan | 26021 | 133 | 7 |
65742 | 65742 | 2020-04-17 | Berrien | Michigan | 26021 | 144 | 8 |
68493 | 68493 | 2020-04-18 | Berrien | Michigan | 26021 | 153 | 8 |
71257 | 71257 | 2020-04-19 | Berrien | Michigan | 26021 | 158 | 8 |
74029 | 74029 | 2020-04-20 | Berrien | Michigan | 26021 | 164 | 8 |
76809 | 76809 | 2020-04-21 | Berrien | Michigan | 26021 | 170 | 10 |
79595 | 79595 | 2020-04-22 | Berrien | Michigan | 26021 | 177 | 11 |
82390 | 82390 | 2020-04-23 | Berrien | Michigan | 26021 | 189 | 11 |
85194 | 85194 | 2020-04-24 | Berrien | Michigan | 26021 | 210 | 11 |
88004 | 88004 | 2020-04-25 | Berrien | Michigan | 26021 | 213 | 12 |
90820 | 90820 | 2020-04-26 | Berrien | Michigan | 26021 | 215 | 14 |
93641 | 93641 | 2020-04-27 | Berrien | Michigan | 26021 | 217 | 14 |
96476 | 96476 | 2020-04-28 | Berrien | Michigan | 26021 | 232 | 15 |
99322 | 99322 | 2020-04-29 | Berrien | Michigan | 26021 | 242 | 15 |
102174 | 102174 | 2020-04-30 | Berrien | Michigan | 26021 | 248 | 15 |
105034 | 105034 | 2020-05-01 | Berrien | Michigan | 26021 | 263 | 15 |
107898 | 107898 | 2020-05-02 | Berrien | Michigan | 26021 | 294 | 18 |
110770 | 110770 | 2020-05-03 | Berrien | Michigan | 26021 | 300 | 18 |
113648 | 113648 | 2020-05-04 | Berrien | Michigan | 26021 | 304 | 20 |
116529 | 116529 | 2020-05-05 | Berrien | Michigan | 26021 | 315 | 20 |
119490 | 119490 | 2020-05-06 | Berrien | Michigan | 26021 | 344 | 20 |
122462 | 122462 | 2020-05-07 | Berrien | Michigan | 26021 | 354 | 21 |
125444 | 125444 | 2020-05-08 | Berrien | Michigan | 26021 | 376 | 22 |
128431 | 128431 | 2020-05-09 | Berrien | Michigan | 26021 | 384 | 22 |
131421 | 131421 | 2020-05-10 | Berrien | Michigan | 26021 | 391 | 22 |
134412 | 134412 | 2020-05-11 | Berrien | Michigan | 26021 | 403 | 24 |
137402 | 137402 | 2020-05-12 | Berrien | Michigan | 26021 | 411 | 25 |
140396 | 140396 | 2020-05-13 | Berrien | Michigan | 26021 | 425 | 26 |
143391 | 143391 | 2020-05-14 | Berrien | Michigan | 26021 | 470 | 27 |
146391 | 146391 | 2020-05-15 | Berrien | Michigan | 26021 | 485 | 28 |
149396 | 149396 | 2020-05-16 | Berrien | Michigan | 26021 | 500 | 28 |
152407 | 152407 | 2020-05-17 | Berrien | Michigan | 26021 | 522 | 29 |
155421 | 155421 | 2020-05-18 | Berrien | Michigan | 26021 | 528 | 30 |
158439 | 158439 | 2020-05-19 | Berrien | Michigan | 26021 | 538 | 33 |
161465 | 161465 | 2020-05-20 | Berrien | Michigan | 26021 | 552 | 34 |
164494 | 164494 | 2020-05-21 | Berrien | Michigan | 26021 | 564 | 40 |
167530 | 167530 | 2020-05-22 | Berrien | Michigan | 26021 | 571 | 43 |
170567 | 170567 | 2020-05-23 | Berrien | Michigan | 26021 | 584 | 42 |
173609 | 173609 | 2020-05-24 | Berrien | Michigan | 26021 | 587 | 42 |
176652 | 176652 | 2020-05-25 | Berrien | Michigan | 26021 | 593 | 42 |
179696 | 179696 | 2020-05-26 | Berrien | Michigan | 26021 | 596 | 47 |
182742 | 182742 | 2020-05-27 | Berrien | Michigan | 26021 | 600 | 48 |
185797 | 185797 | 2020-05-28 | Berrien | Michigan | 26021 | 606 | 49 |
188855 | 188855 | 2020-05-29 | Berrien | Michigan | 26021 | 613 | 49 |
191919 | 191919 | 2020-05-30 | Berrien | Michigan | 26021 | 618 | 49 |
194987 | 194987 | 2020-05-31 | Berrien | Michigan | 26021 | 626 | 49 |
198058 | 198058 | 2020-06-01 | Berrien | Michigan | 26021 | 822 | 52 |
201130 | 201130 | 2020-06-02 | Berrien | Michigan | 26021 | 833 | 53 |
204207 | 204207 | 2020-06-03 | Berrien | Michigan | 26021 | 840 | 53 |
207288 | 207288 | 2020-06-04 | Berrien | Michigan | 26021 | 844 | 53 |
210369 | 210369 | 2020-06-05 | Berrien | Michigan | 26021 | 849 | 53 |
213453 | 213453 | 2020-06-06 | Berrien | Michigan | 26021 | 856 | 53 |
216541 | 216541 | 2020-06-07 | Berrien | Michigan | 26021 | 860 | 54 |
219633 | 219633 | 2020-06-08 | Berrien | Michigan | 26021 | 867 | 57 |
222728 | 222728 | 2020-06-09 | Berrien | Michigan | 26021 | 869 | 57 |
225825 | 225825 | 2020-06-10 | Berrien | Michigan | 26021 | 870 | 57 |
228927 | 228927 | 2020-06-11 | Berrien | Michigan | 26021 | 875 | 57 |
232031 | 232031 | 2020-06-12 | Berrien | Michigan | 26021 | 879 | 57 |
235136 | 235136 | 2020-06-13 | Berrien | Michigan | 26021 | 885 | 57 |
238243 | 238243 | 2020-06-14 | Berrien | Michigan | 26021 | 888 | 57 |
241352 | 241352 | 2020-06-15 | Berrien | Michigan | 26021 | 887 | 57 |
244463 | 244463 | 2020-06-16 | Berrien | Michigan | 26021 | 890 | 57 |
247576 | 247576 | 2020-06-17 | Berrien | Michigan | 26021 | 891 | 57 |
250688 | 250688 | 2020-06-18 | Berrien | Michigan | 26021 | 906 | 60 |
253803 | 253803 | 2020-06-19 | Berrien | Michigan | 26021 | 911 | 60 |
256923 | 256923 | 2020-06-20 | Berrien | Michigan | 26021 | 915 | 60 |
260049 | 260049 | 2020-06-21 | Berrien | Michigan | 26021 | 915 | 60 |
263178 | 263178 | 2020-06-22 | Berrien | Michigan | 26021 | 915 | 60 |
266304 | 266304 | 2020-06-23 | Berrien | Michigan | 26021 | 918 | 60 |
269437 | 269437 | 2020-06-24 | Berrien | Michigan | 26021 | 918 | 60 |
272574 | 272574 | 2020-06-25 | Berrien | Michigan | 26021 | 922 | 60 |
275717 | 275717 | 2020-06-26 | Berrien | Michigan | 26021 | 923 | 60 |
278865 | 278865 | 2020-06-27 | Berrien | Michigan | 26021 | 928 | 60 |
282013 | 282013 | 2020-06-28 | Berrien | Michigan | 26021 | 933 | 60 |
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);