ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Gogebic" and state = "Michigan" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
13065 | 13065 | 2020-03-26 | Gogebic | Michigan | 26053 | 1 | 1 |
14775 | 14775 | 2020-03-27 | Gogebic | Michigan | 26053 | 1 | 1 |
16595 | 16595 | 2020-03-28 | Gogebic | Michigan | 26053 | 1 | 1 |
18511 | 18511 | 2020-03-29 | Gogebic | Michigan | 26053 | 1 | 1 |
20529 | 20529 | 2020-03-30 | Gogebic | Michigan | 26053 | 1 | 1 |
22640 | 22640 | 2020-03-31 | Gogebic | Michigan | 26053 | 2 | 1 |
24819 | 24819 | 2020-04-01 | Gogebic | Michigan | 26053 | 2 | 1 |
27072 | 27072 | 2020-04-02 | Gogebic | Michigan | 26053 | 3 | 1 |
29390 | 29390 | 2020-04-03 | Gogebic | Michigan | 26053 | 3 | 1 |
31768 | 31768 | 2020-04-04 | Gogebic | Michigan | 26053 | 3 | 1 |
34193 | 34193 | 2020-04-05 | Gogebic | Michigan | 26053 | 3 | 1 |
36652 | 36652 | 2020-04-06 | Gogebic | Michigan | 26053 | 3 | 1 |
39160 | 39160 | 2020-04-07 | Gogebic | Michigan | 26053 | 3 | 1 |
41712 | 41712 | 2020-04-08 | Gogebic | Michigan | 26053 | 3 | 1 |
44288 | 44288 | 2020-04-09 | Gogebic | Michigan | 26053 | 3 | 1 |
46896 | 46896 | 2020-04-10 | Gogebic | Michigan | 26053 | 4 | 1 |
49539 | 49539 | 2020-04-11 | Gogebic | Michigan | 26053 | 4 | 1 |
52209 | 52209 | 2020-04-12 | Gogebic | Michigan | 26053 | 4 | 1 |
54890 | 54890 | 2020-04-13 | Gogebic | Michigan | 26053 | 4 | 1 |
57588 | 57588 | 2020-04-14 | Gogebic | Michigan | 26053 | 4 | 1 |
60298 | 60298 | 2020-04-15 | Gogebic | Michigan | 26053 | 4 | 1 |
63020 | 63020 | 2020-04-16 | Gogebic | Michigan | 26053 | 4 | 1 |
65758 | 65758 | 2020-04-17 | Gogebic | Michigan | 26053 | 4 | 1 |
68509 | 68509 | 2020-04-18 | Gogebic | Michigan | 26053 | 4 | 1 |
71273 | 71273 | 2020-04-19 | Gogebic | Michigan | 26053 | 4 | 1 |
74045 | 74045 | 2020-04-20 | Gogebic | Michigan | 26053 | 4 | 1 |
76825 | 76825 | 2020-04-21 | Gogebic | Michigan | 26053 | 4 | 1 |
79611 | 79611 | 2020-04-22 | Gogebic | Michigan | 26053 | 4 | 1 |
82406 | 82406 | 2020-04-23 | Gogebic | Michigan | 26053 | 4 | 1 |
85210 | 85210 | 2020-04-24 | Gogebic | Michigan | 26053 | 4 | 1 |
88020 | 88020 | 2020-04-25 | Gogebic | Michigan | 26053 | 4 | 1 |
90836 | 90836 | 2020-04-26 | Gogebic | Michigan | 26053 | 4 | 1 |
93657 | 93657 | 2020-04-27 | Gogebic | Michigan | 26053 | 4 | 1 |
96492 | 96492 | 2020-04-28 | Gogebic | Michigan | 26053 | 4 | 1 |
99338 | 99338 | 2020-04-29 | Gogebic | Michigan | 26053 | 4 | 1 |
102190 | 102190 | 2020-04-30 | Gogebic | Michigan | 26053 | 4 | 1 |
105050 | 105050 | 2020-05-01 | Gogebic | Michigan | 26053 | 4 | 1 |
107914 | 107914 | 2020-05-02 | Gogebic | Michigan | 26053 | 4 | 1 |
110786 | 110786 | 2020-05-03 | Gogebic | Michigan | 26053 | 4 | 1 |
116545 | 116545 | 2020-05-05 | Gogebic | Michigan | 26053 | 4 | 1 |
119506 | 119506 | 2020-05-06 | Gogebic | Michigan | 26053 | 4 | 1 |
122478 | 122478 | 2020-05-07 | Gogebic | Michigan | 26053 | 4 | 1 |
125460 | 125460 | 2020-05-08 | Gogebic | Michigan | 26053 | 4 | 1 |
128447 | 128447 | 2020-05-09 | Gogebic | Michigan | 26053 | 4 | 1 |
131437 | 131437 | 2020-05-10 | Gogebic | Michigan | 26053 | 4 | 1 |
134428 | 134428 | 2020-05-11 | Gogebic | Michigan | 26053 | 4 | 1 |
137418 | 137418 | 2020-05-12 | Gogebic | Michigan | 26053 | 4 | 1 |
140412 | 140412 | 2020-05-13 | Gogebic | Michigan | 26053 | 4 | 1 |
143407 | 143407 | 2020-05-14 | Gogebic | Michigan | 26053 | 4 | 1 |
146407 | 146407 | 2020-05-15 | Gogebic | Michigan | 26053 | 4 | 1 |
149412 | 149412 | 2020-05-16 | Gogebic | Michigan | 26053 | 4 | 1 |
113664 | 113664 | 2020-05-04 | Gogebic | Michigan | 26053 | 5 | 1 |
152423 | 152423 | 2020-05-17 | Gogebic | Michigan | 26053 | 5 | 1 |
155437 | 155437 | 2020-05-18 | Gogebic | Michigan | 26053 | 5 | 1 |
158455 | 158455 | 2020-05-19 | Gogebic | Michigan | 26053 | 5 | 1 |
161481 | 161481 | 2020-05-20 | Gogebic | Michigan | 26053 | 5 | 1 |
164510 | 164510 | 2020-05-21 | Gogebic | Michigan | 26053 | 5 | 1 |
167546 | 167546 | 2020-05-22 | Gogebic | Michigan | 26053 | 5 | 1 |
170583 | 170583 | 2020-05-23 | Gogebic | Michigan | 26053 | 5 | 1 |
173625 | 173625 | 2020-05-24 | Gogebic | Michigan | 26053 | 5 | 1 |
176668 | 176668 | 2020-05-25 | Gogebic | Michigan | 26053 | 5 | 1 |
179712 | 179712 | 2020-05-26 | Gogebic | Michigan | 26053 | 5 | 1 |
182758 | 182758 | 2020-05-27 | Gogebic | Michigan | 26053 | 5 | 1 |
185813 | 185813 | 2020-05-28 | Gogebic | Michigan | 26053 | 5 | 1 |
188871 | 188871 | 2020-05-29 | Gogebic | Michigan | 26053 | 5 | 1 |
191935 | 191935 | 2020-05-30 | Gogebic | Michigan | 26053 | 5 | 1 |
195003 | 195003 | 2020-05-31 | Gogebic | Michigan | 26053 | 5 | 1 |
198074 | 198074 | 2020-06-01 | Gogebic | Michigan | 26053 | 5 | 1 |
201146 | 201146 | 2020-06-02 | Gogebic | Michigan | 26053 | 5 | 1 |
204223 | 204223 | 2020-06-03 | Gogebic | Michigan | 26053 | 5 | 1 |
207304 | 207304 | 2020-06-04 | Gogebic | Michigan | 26053 | 5 | 1 |
210385 | 210385 | 2020-06-05 | Gogebic | Michigan | 26053 | 5 | 1 |
213469 | 213469 | 2020-06-06 | Gogebic | Michigan | 26053 | 5 | 1 |
216557 | 216557 | 2020-06-07 | Gogebic | Michigan | 26053 | 5 | 1 |
219649 | 219649 | 2020-06-08 | Gogebic | Michigan | 26053 | 5 | 1 |
225841 | 225841 | 2020-06-10 | Gogebic | Michigan | 26053 | 5 | 1 |
228943 | 228943 | 2020-06-11 | Gogebic | Michigan | 26053 | 5 | 1 |
232047 | 232047 | 2020-06-12 | Gogebic | Michigan | 26053 | 5 | 1 |
235152 | 235152 | 2020-06-13 | Gogebic | Michigan | 26053 | 5 | 1 |
238259 | 238259 | 2020-06-14 | Gogebic | Michigan | 26053 | 5 | 1 |
241368 | 241368 | 2020-06-15 | Gogebic | Michigan | 26053 | 5 | 1 |
244479 | 244479 | 2020-06-16 | Gogebic | Michigan | 26053 | 5 | 1 |
247592 | 247592 | 2020-06-17 | Gogebic | Michigan | 26053 | 5 | 1 |
250704 | 250704 | 2020-06-18 | Gogebic | Michigan | 26053 | 5 | 1 |
222744 | 222744 | 2020-06-09 | Gogebic | Michigan | 26053 | 6 | 1 |
253819 | 253819 | 2020-06-19 | Gogebic | Michigan | 26053 | 6 | 1 |
256939 | 256939 | 2020-06-20 | Gogebic | Michigan | 26053 | 6 | 1 |
260065 | 260065 | 2020-06-21 | Gogebic | Michigan | 26053 | 6 | 1 |
263194 | 263194 | 2020-06-22 | Gogebic | Michigan | 26053 | 6 | 1 |
266320 | 266320 | 2020-06-23 | Gogebic | Michigan | 26053 | 6 | 1 |
269453 | 269453 | 2020-06-24 | Gogebic | Michigan | 26053 | 6 | 1 |
272590 | 272590 | 2020-06-25 | Gogebic | Michigan | 26053 | 6 | 1 |
275733 | 275733 | 2020-06-26 | Gogebic | Michigan | 26053 | 6 | 1 |
278881 | 278881 | 2020-06-27 | Gogebic | Michigan | 26053 | 7 | 1 |
282029 | 282029 | 2020-06-28 | Gogebic | Michigan | 26053 | 7 | 1 |
285174 | 285174 | 2020-06-29 | Gogebic | Michigan | 26053 | 7 | 1 |
288324 | 288324 | 2020-06-30 | Gogebic | Michigan | 26053 | 7 | 1 |
291475 | 291475 | 2020-07-01 | Gogebic | Michigan | 26053 | 7 | 1 |
294629 | 294629 | 2020-07-02 | Gogebic | Michigan | 26053 | 7 | 1 |
297787 | 297787 | 2020-07-03 | Gogebic | Michigan | 26053 | 7 | 1 |
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);