ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Delta" and fips = 26041 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20524 | 20524 | 2020-03-30 | Delta | Michigan | 26041 | 1 | 0 |
22635 | 22635 | 2020-03-31 | Delta | Michigan | 26041 | 1 | 0 |
24814 | 24814 | 2020-04-01 | Delta | Michigan | 26041 | 3 | 0 |
27066 | 27066 | 2020-04-02 | Delta | Michigan | 26041 | 4 | 0 |
29384 | 29384 | 2020-04-03 | Delta | Michigan | 26041 | 5 | 0 |
31762 | 31762 | 2020-04-04 | Delta | Michigan | 26041 | 5 | 0 |
34187 | 34187 | 2020-04-05 | Delta | Michigan | 26041 | 7 | 0 |
36646 | 36646 | 2020-04-06 | Delta | Michigan | 26041 | 7 | 0 |
39154 | 39154 | 2020-04-07 | Delta | Michigan | 26041 | 7 | 0 |
41706 | 41706 | 2020-04-08 | Delta | Michigan | 26041 | 8 | 0 |
44282 | 44282 | 2020-04-09 | Delta | Michigan | 26041 | 9 | 1 |
46890 | 46890 | 2020-04-10 | Delta | Michigan | 26041 | 9 | 1 |
49533 | 49533 | 2020-04-11 | Delta | Michigan | 26041 | 9 | 1 |
52203 | 52203 | 2020-04-12 | Delta | Michigan | 26041 | 9 | 1 |
54884 | 54884 | 2020-04-13 | Delta | Michigan | 26041 | 9 | 1 |
57582 | 57582 | 2020-04-14 | Delta | Michigan | 26041 | 9 | 1 |
60292 | 60292 | 2020-04-15 | Delta | Michigan | 26041 | 9 | 1 |
63014 | 63014 | 2020-04-16 | Delta | Michigan | 26041 | 10 | 1 |
65752 | 65752 | 2020-04-17 | Delta | Michigan | 26041 | 10 | 1 |
68503 | 68503 | 2020-04-18 | Delta | Michigan | 26041 | 12 | 1 |
71267 | 71267 | 2020-04-19 | Delta | Michigan | 26041 | 12 | 1 |
74039 | 74039 | 2020-04-20 | Delta | Michigan | 26041 | 13 | 1 |
76819 | 76819 | 2020-04-21 | Delta | Michigan | 26041 | 12 | 2 |
79605 | 79605 | 2020-04-22 | Delta | Michigan | 26041 | 12 | 2 |
82400 | 82400 | 2020-04-23 | Delta | Michigan | 26041 | 12 | 2 |
85204 | 85204 | 2020-04-24 | Delta | Michigan | 26041 | 12 | 2 |
88014 | 88014 | 2020-04-25 | Delta | Michigan | 26041 | 12 | 2 |
90830 | 90830 | 2020-04-26 | Delta | Michigan | 26041 | 12 | 2 |
93651 | 93651 | 2020-04-27 | Delta | Michigan | 26041 | 13 | 2 |
96486 | 96486 | 2020-04-28 | Delta | Michigan | 26041 | 13 | 2 |
99332 | 99332 | 2020-04-29 | Delta | Michigan | 26041 | 13 | 2 |
102184 | 102184 | 2020-04-30 | Delta | Michigan | 26041 | 13 | 2 |
105044 | 105044 | 2020-05-01 | Delta | Michigan | 26041 | 13 | 2 |
107908 | 107908 | 2020-05-02 | Delta | Michigan | 26041 | 13 | 2 |
110780 | 110780 | 2020-05-03 | Delta | Michigan | 26041 | 13 | 2 |
113658 | 113658 | 2020-05-04 | Delta | Michigan | 26041 | 13 | 2 |
116539 | 116539 | 2020-05-05 | Delta | Michigan | 26041 | 14 | 2 |
119500 | 119500 | 2020-05-06 | Delta | Michigan | 26041 | 14 | 2 |
122472 | 122472 | 2020-05-07 | Delta | Michigan | 26041 | 15 | 2 |
125454 | 125454 | 2020-05-08 | Delta | Michigan | 26041 | 15 | 2 |
128441 | 128441 | 2020-05-09 | Delta | Michigan | 26041 | 14 | 2 |
131431 | 131431 | 2020-05-10 | Delta | Michigan | 26041 | 14 | 2 |
134422 | 134422 | 2020-05-11 | Delta | Michigan | 26041 | 14 | 2 |
137412 | 137412 | 2020-05-12 | Delta | Michigan | 26041 | 14 | 2 |
140406 | 140406 | 2020-05-13 | Delta | Michigan | 26041 | 14 | 2 |
143401 | 143401 | 2020-05-14 | Delta | Michigan | 26041 | 14 | 2 |
146401 | 146401 | 2020-05-15 | Delta | Michigan | 26041 | 14 | 2 |
149406 | 149406 | 2020-05-16 | Delta | Michigan | 26041 | 14 | 2 |
152417 | 152417 | 2020-05-17 | Delta | Michigan | 26041 | 14 | 2 |
155431 | 155431 | 2020-05-18 | Delta | Michigan | 26041 | 14 | 2 |
158449 | 158449 | 2020-05-19 | Delta | Michigan | 26041 | 15 | 2 |
161475 | 161475 | 2020-05-20 | Delta | Michigan | 26041 | 16 | 2 |
164504 | 164504 | 2020-05-21 | Delta | Michigan | 26041 | 17 | 2 |
167540 | 167540 | 2020-05-22 | Delta | Michigan | 26041 | 17 | 2 |
170577 | 170577 | 2020-05-23 | Delta | Michigan | 26041 | 17 | 2 |
173619 | 173619 | 2020-05-24 | Delta | Michigan | 26041 | 17 | 2 |
176662 | 176662 | 2020-05-25 | Delta | Michigan | 26041 | 17 | 2 |
179706 | 179706 | 2020-05-26 | Delta | Michigan | 26041 | 17 | 2 |
182752 | 182752 | 2020-05-27 | Delta | Michigan | 26041 | 17 | 2 |
185807 | 185807 | 2020-05-28 | Delta | Michigan | 26041 | 17 | 2 |
188865 | 188865 | 2020-05-29 | Delta | Michigan | 26041 | 17 | 2 |
191929 | 191929 | 2020-05-30 | Delta | Michigan | 26041 | 17 | 2 |
194997 | 194997 | 2020-05-31 | Delta | Michigan | 26041 | 17 | 2 |
198068 | 198068 | 2020-06-01 | Delta | Michigan | 26041 | 17 | 2 |
201140 | 201140 | 2020-06-02 | Delta | Michigan | 26041 | 17 | 2 |
204217 | 204217 | 2020-06-03 | Delta | Michigan | 26041 | 17 | 2 |
207298 | 207298 | 2020-06-04 | Delta | Michigan | 26041 | 17 | 2 |
210379 | 210379 | 2020-06-05 | Delta | Michigan | 26041 | 20 | 2 |
213463 | 213463 | 2020-06-06 | Delta | Michigan | 26041 | 20 | 2 |
216551 | 216551 | 2020-06-07 | Delta | Michigan | 26041 | 20 | 2 |
219643 | 219643 | 2020-06-08 | Delta | Michigan | 26041 | 20 | 2 |
222738 | 222738 | 2020-06-09 | Delta | Michigan | 26041 | 20 | 2 |
225835 | 225835 | 2020-06-10 | Delta | Michigan | 26041 | 20 | 2 |
228937 | 228937 | 2020-06-11 | Delta | Michigan | 26041 | 20 | 2 |
232041 | 232041 | 2020-06-12 | Delta | Michigan | 26041 | 21 | 2 |
235146 | 235146 | 2020-06-13 | Delta | Michigan | 26041 | 21 | 2 |
238253 | 238253 | 2020-06-14 | Delta | Michigan | 26041 | 21 | 2 |
241362 | 241362 | 2020-06-15 | Delta | Michigan | 26041 | 21 | 2 |
244473 | 244473 | 2020-06-16 | Delta | Michigan | 26041 | 21 | 2 |
247586 | 247586 | 2020-06-17 | Delta | Michigan | 26041 | 21 | 2 |
250698 | 250698 | 2020-06-18 | Delta | Michigan | 26041 | 21 | 2 |
253813 | 253813 | 2020-06-19 | Delta | Michigan | 26041 | 21 | 2 |
256933 | 256933 | 2020-06-20 | Delta | Michigan | 26041 | 21 | 2 |
260059 | 260059 | 2020-06-21 | Delta | Michigan | 26041 | 21 | 2 |
263188 | 263188 | 2020-06-22 | Delta | Michigan | 26041 | 21 | 2 |
266314 | 266314 | 2020-06-23 | Delta | Michigan | 26041 | 21 | 2 |
269447 | 269447 | 2020-06-24 | Delta | Michigan | 26041 | 21 | 2 |
272584 | 272584 | 2020-06-25 | Delta | Michigan | 26041 | 22 | 2 |
275727 | 275727 | 2020-06-26 | Delta | Michigan | 26041 | 21 | 3 |
278875 | 278875 | 2020-06-27 | Delta | Michigan | 26041 | 21 | 3 |
282023 | 282023 | 2020-06-28 | Delta | Michigan | 26041 | 21 | 3 |
285168 | 285168 | 2020-06-29 | Delta | Michigan | 26041 | 21 | 3 |
288318 | 288318 | 2020-06-30 | Delta | Michigan | 26041 | 23 | 3 |
291469 | 291469 | 2020-07-01 | Delta | Michigan | 26041 | 24 | 3 |
294623 | 294623 | 2020-07-02 | Delta | Michigan | 26041 | 26 | 3 |
297781 | 297781 | 2020-07-03 | Delta | Michigan | 26041 | 27 | 3 |
300943 | 300943 | 2020-07-04 | Delta | Michigan | 26041 | 27 | 3 |
304107 | 304107 | 2020-07-05 | Delta | Michigan | 26041 | 27 | 3 |
307274 | 307274 | 2020-07-06 | Delta | Michigan | 26041 | 27 | 3 |
310442 | 310442 | 2020-07-07 | Delta | Michigan | 26041 | 27 | 3 |
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);