ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "St. Clair" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282078 | 282078 | 2020-06-28 | St. Clair | Michigan | 26147 | 549 | 49 |
278930 | 278930 | 2020-06-27 | St. Clair | Michigan | 26147 | 547 | 49 |
275782 | 275782 | 2020-06-26 | St. Clair | Michigan | 26147 | 543 | 49 |
272639 | 272639 | 2020-06-25 | St. Clair | Michigan | 26147 | 538 | 49 |
269502 | 269502 | 2020-06-24 | St. Clair | Michigan | 26147 | 534 | 49 |
266369 | 266369 | 2020-06-23 | St. Clair | Michigan | 26147 | 530 | 49 |
263243 | 263243 | 2020-06-22 | St. Clair | Michigan | 26147 | 530 | 48 |
260114 | 260114 | 2020-06-21 | St. Clair | Michigan | 26147 | 525 | 48 |
256988 | 256988 | 2020-06-20 | St. Clair | Michigan | 26147 | 525 | 48 |
253868 | 253868 | 2020-06-19 | St. Clair | Michigan | 26147 | 525 | 48 |
250753 | 250753 | 2020-06-18 | St. Clair | Michigan | 26147 | 521 | 48 |
247641 | 247641 | 2020-06-17 | St. Clair | Michigan | 26147 | 521 | 48 |
244528 | 244528 | 2020-06-16 | St. Clair | Michigan | 26147 | 521 | 48 |
241417 | 241417 | 2020-06-15 | St. Clair | Michigan | 26147 | 521 | 46 |
238308 | 238308 | 2020-06-14 | St. Clair | Michigan | 26147 | 521 | 45 |
235201 | 235201 | 2020-06-13 | St. Clair | Michigan | 26147 | 519 | 45 |
232096 | 232096 | 2020-06-12 | St. Clair | Michigan | 26147 | 517 | 45 |
228992 | 228992 | 2020-06-11 | St. Clair | Michigan | 26147 | 517 | 45 |
225890 | 225890 | 2020-06-10 | St. Clair | Michigan | 26147 | 517 | 45 |
222792 | 222792 | 2020-06-09 | St. Clair | Michigan | 26147 | 516 | 45 |
219697 | 219697 | 2020-06-08 | St. Clair | Michigan | 26147 | 516 | 44 |
216605 | 216605 | 2020-06-07 | St. Clair | Michigan | 26147 | 515 | 44 |
213517 | 213517 | 2020-06-06 | St. Clair | Michigan | 26147 | 515 | 44 |
210433 | 210433 | 2020-06-05 | St. Clair | Michigan | 26147 | 515 | 44 |
207352 | 207352 | 2020-06-04 | St. Clair | Michigan | 26147 | 515 | 44 |
204271 | 204271 | 2020-06-03 | St. Clair | Michigan | 26147 | 514 | 44 |
201194 | 201194 | 2020-06-02 | St. Clair | Michigan | 26147 | 511 | 43 |
198121 | 198121 | 2020-06-01 | St. Clair | Michigan | 26147 | 511 | 42 |
195050 | 195050 | 2020-05-31 | St. Clair | Michigan | 26147 | 449 | 41 |
191982 | 191982 | 2020-05-30 | St. Clair | Michigan | 26147 | 448 | 41 |
188918 | 188918 | 2020-05-29 | St. Clair | Michigan | 26147 | 448 | 39 |
185860 | 185860 | 2020-05-28 | St. Clair | Michigan | 26147 | 438 | 37 |
182805 | 182805 | 2020-05-27 | St. Clair | Michigan | 26147 | 431 | 37 |
179759 | 179759 | 2020-05-26 | St. Clair | Michigan | 26147 | 431 | 36 |
176715 | 176715 | 2020-05-25 | St. Clair | Michigan | 26147 | 431 | 35 |
173672 | 173672 | 2020-05-24 | St. Clair | Michigan | 26147 | 430 | 34 |
170630 | 170630 | 2020-05-23 | St. Clair | Michigan | 26147 | 429 | 34 |
167593 | 167593 | 2020-05-22 | St. Clair | Michigan | 26147 | 426 | 33 |
164557 | 164557 | 2020-05-21 | St. Clair | Michigan | 26147 | 422 | 33 |
161528 | 161528 | 2020-05-20 | St. Clair | Michigan | 26147 | 419 | 33 |
158502 | 158502 | 2020-05-19 | St. Clair | Michigan | 26147 | 412 | 32 |
155484 | 155484 | 2020-05-18 | St. Clair | Michigan | 26147 | 407 | 31 |
152470 | 152470 | 2020-05-17 | St. Clair | Michigan | 26147 | 403 | 31 |
149459 | 149459 | 2020-05-16 | St. Clair | Michigan | 26147 | 408 | 30 |
146454 | 146454 | 2020-05-15 | St. Clair | Michigan | 26147 | 399 | 30 |
143454 | 143454 | 2020-05-14 | St. Clair | Michigan | 26147 | 394 | 28 |
140459 | 140459 | 2020-05-13 | St. Clair | Michigan | 26147 | 373 | 28 |
137465 | 137465 | 2020-05-12 | St. Clair | Michigan | 26147 | 366 | 28 |
134475 | 134475 | 2020-05-11 | St. Clair | Michigan | 26147 | 358 | 25 |
131484 | 131484 | 2020-05-10 | St. Clair | Michigan | 26147 | 357 | 25 |
128494 | 128494 | 2020-05-09 | St. Clair | Michigan | 26147 | 353 | 25 |
125507 | 125507 | 2020-05-08 | St. Clair | Michigan | 26147 | 353 | 23 |
122525 | 122525 | 2020-05-07 | St. Clair | Michigan | 26147 | 342 | 23 |
119553 | 119553 | 2020-05-06 | St. Clair | Michigan | 26147 | 342 | 22 |
116592 | 116592 | 2020-05-05 | St. Clair | Michigan | 26147 | 342 | 21 |
113711 | 113711 | 2020-05-04 | St. Clair | Michigan | 26147 | 339 | 21 |
110833 | 110833 | 2020-05-03 | St. Clair | Michigan | 26147 | 335 | 21 |
107961 | 107961 | 2020-05-02 | St. Clair | Michigan | 26147 | 336 | 21 |
105097 | 105097 | 2020-05-01 | St. Clair | Michigan | 26147 | 331 | 21 |
102237 | 102237 | 2020-04-30 | St. Clair | Michigan | 26147 | 328 | 21 |
99385 | 99385 | 2020-04-29 | St. Clair | Michigan | 26147 | 313 | 21 |
96539 | 96539 | 2020-04-28 | St. Clair | Michigan | 26147 | 309 | 21 |
93704 | 93704 | 2020-04-27 | St. Clair | Michigan | 26147 | 304 | 18 |
90883 | 90883 | 2020-04-26 | St. Clair | Michigan | 26147 | 302 | 18 |
88067 | 88067 | 2020-04-25 | St. Clair | Michigan | 26147 | 297 | 18 |
85257 | 85257 | 2020-04-24 | St. Clair | Michigan | 26147 | 294 | 16 |
82453 | 82453 | 2020-04-23 | St. Clair | Michigan | 26147 | 284 | 16 |
79658 | 79658 | 2020-04-22 | St. Clair | Michigan | 26147 | 271 | 16 |
76872 | 76872 | 2020-04-21 | St. Clair | Michigan | 26147 | 259 | 15 |
74092 | 74092 | 2020-04-20 | St. Clair | Michigan | 26147 | 252 | 11 |
71320 | 71320 | 2020-04-19 | St. Clair | Michigan | 26147 | 244 | 11 |
68556 | 68556 | 2020-04-18 | St. Clair | Michigan | 26147 | 241 | 7 |
65805 | 65805 | 2020-04-17 | St. Clair | Michigan | 26147 | 236 | 8 |
63067 | 63067 | 2020-04-16 | St. Clair | Michigan | 26147 | 232 | 8 |
60345 | 60345 | 2020-04-15 | St. Clair | Michigan | 26147 | 221 | 8 |
57635 | 57635 | 2020-04-14 | St. Clair | Michigan | 26147 | 211 | 7 |
54937 | 54937 | 2020-04-13 | St. Clair | Michigan | 26147 | 206 | 7 |
52255 | 52255 | 2020-04-12 | St. Clair | Michigan | 26147 | 199 | 6 |
49585 | 49585 | 2020-04-11 | St. Clair | Michigan | 26147 | 190 | 4 |
46941 | 46941 | 2020-04-10 | St. Clair | Michigan | 26147 | 179 | 4 |
44332 | 44332 | 2020-04-09 | St. Clair | Michigan | 26147 | 162 | 4 |
41756 | 41756 | 2020-04-08 | St. Clair | Michigan | 26147 | 140 | 3 |
39203 | 39203 | 2020-04-07 | St. Clair | Michigan | 26147 | 129 | 3 |
36694 | 36694 | 2020-04-06 | St. Clair | Michigan | 26147 | 110 | 3 |
34234 | 34234 | 2020-04-05 | St. Clair | Michigan | 26147 | 94 | 2 |
31809 | 31809 | 2020-04-04 | St. Clair | Michigan | 26147 | 85 | 2 |
29431 | 29431 | 2020-04-03 | St. Clair | Michigan | 26147 | 66 | 0 |
27112 | 27112 | 2020-04-02 | St. Clair | Michigan | 26147 | 53 | 0 |
24859 | 24859 | 2020-04-01 | St. Clair | Michigan | 26147 | 41 | 0 |
22679 | 22679 | 2020-03-31 | St. Clair | Michigan | 26147 | 32 | 0 |
20567 | 20567 | 2020-03-30 | St. Clair | Michigan | 26147 | 25 | 0 |
18548 | 18548 | 2020-03-29 | St. Clair | Michigan | 26147 | 20 | 0 |
16632 | 16632 | 2020-03-28 | St. Clair | Michigan | 26147 | 16 | 0 |
14811 | 14811 | 2020-03-27 | St. Clair | Michigan | 26147 | 15 | 0 |
13099 | 13099 | 2020-03-26 | St. Clair | Michigan | 26147 | 13 | 0 |
11511 | 11511 | 2020-03-25 | St. Clair | Michigan | 26147 | 10 | 0 |
10095 | 10095 | 2020-03-24 | St. Clair | Michigan | 26147 | 8 | 0 |
8801 | 8801 | 2020-03-23 | St. Clair | Michigan | 26147 | 7 | 0 |
7625 | 7625 | 2020-03-22 | St. Clair | Michigan | 26147 | 7 | 0 |
6544 | 6544 | 2020-03-21 | St. Clair | Michigan | 26147 | 7 | 0 |
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);