ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Lake" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282045 | 282045 | 2020-06-28 | Lake | Michigan | 26085 | 7 | 0 |
278897 | 278897 | 2020-06-27 | Lake | Michigan | 26085 | 7 | 0 |
275749 | 275749 | 2020-06-26 | Lake | Michigan | 26085 | 7 | 0 |
272606 | 272606 | 2020-06-25 | Lake | Michigan | 26085 | 7 | 0 |
269469 | 269469 | 2020-06-24 | Lake | Michigan | 26085 | 7 | 0 |
266336 | 266336 | 2020-06-23 | Lake | Michigan | 26085 | 7 | 0 |
263210 | 263210 | 2020-06-22 | Lake | Michigan | 26085 | 7 | 0 |
260081 | 260081 | 2020-06-21 | Lake | Michigan | 26085 | 7 | 0 |
256955 | 256955 | 2020-06-20 | Lake | Michigan | 26085 | 7 | 0 |
253835 | 253835 | 2020-06-19 | Lake | Michigan | 26085 | 7 | 0 |
250720 | 250720 | 2020-06-18 | Lake | Michigan | 26085 | 7 | 0 |
247608 | 247608 | 2020-06-17 | Lake | Michigan | 26085 | 7 | 0 |
244495 | 244495 | 2020-06-16 | Lake | Michigan | 26085 | 7 | 0 |
241384 | 241384 | 2020-06-15 | Lake | Michigan | 26085 | 7 | 0 |
238275 | 238275 | 2020-06-14 | Lake | Michigan | 26085 | 7 | 0 |
235168 | 235168 | 2020-06-13 | Lake | Michigan | 26085 | 7 | 0 |
232063 | 232063 | 2020-06-12 | Lake | Michigan | 26085 | 7 | 0 |
228959 | 228959 | 2020-06-11 | Lake | Michigan | 26085 | 7 | 0 |
225857 | 225857 | 2020-06-10 | Lake | Michigan | 26085 | 7 | 0 |
222759 | 222759 | 2020-06-09 | Lake | Michigan | 26085 | 7 | 0 |
219664 | 219664 | 2020-06-08 | Lake | Michigan | 26085 | 7 | 0 |
216572 | 216572 | 2020-06-07 | Lake | Michigan | 26085 | 7 | 0 |
213484 | 213484 | 2020-06-06 | Lake | Michigan | 26085 | 7 | 0 |
210400 | 210400 | 2020-06-05 | Lake | Michigan | 26085 | 7 | 0 |
207319 | 207319 | 2020-06-04 | Lake | Michigan | 26085 | 7 | 0 |
204238 | 204238 | 2020-06-03 | Lake | Michigan | 26085 | 7 | 0 |
201161 | 201161 | 2020-06-02 | Lake | Michigan | 26085 | 7 | 0 |
198088 | 198088 | 2020-06-01 | Lake | Michigan | 26085 | 7 | 0 |
195017 | 195017 | 2020-05-31 | Lake | Michigan | 26085 | 6 | 0 |
191949 | 191949 | 2020-05-30 | Lake | Michigan | 26085 | 5 | 0 |
188885 | 188885 | 2020-05-29 | Lake | Michigan | 26085 | 7 | 0 |
185827 | 185827 | 2020-05-28 | Lake | Michigan | 26085 | 5 | 0 |
182772 | 182772 | 2020-05-27 | Lake | Michigan | 26085 | 5 | 0 |
179726 | 179726 | 2020-05-26 | Lake | Michigan | 26085 | 5 | 0 |
176682 | 176682 | 2020-05-25 | Lake | Michigan | 26085 | 6 | 0 |
173639 | 173639 | 2020-05-24 | Lake | Michigan | 26085 | 5 | 0 |
170597 | 170597 | 2020-05-23 | Lake | Michigan | 26085 | 5 | 0 |
167560 | 167560 | 2020-05-22 | Lake | Michigan | 26085 | 5 | 0 |
164524 | 164524 | 2020-05-21 | Lake | Michigan | 26085 | 3 | 0 |
161495 | 161495 | 2020-05-20 | Lake | Michigan | 26085 | 3 | 0 |
158469 | 158469 | 2020-05-19 | Lake | Michigan | 26085 | 3 | 0 |
155451 | 155451 | 2020-05-18 | Lake | Michigan | 26085 | 3 | 0 |
152437 | 152437 | 2020-05-17 | Lake | Michigan | 26085 | 3 | 0 |
149426 | 149426 | 2020-05-16 | Lake | Michigan | 26085 | 3 | 0 |
146421 | 146421 | 2020-05-15 | Lake | Michigan | 26085 | 2 | 0 |
143421 | 143421 | 2020-05-14 | Lake | Michigan | 26085 | 2 | 0 |
140426 | 140426 | 2020-05-13 | Lake | Michigan | 26085 | 2 | 0 |
137432 | 137432 | 2020-05-12 | Lake | Michigan | 26085 | 2 | 0 |
134442 | 134442 | 2020-05-11 | Lake | Michigan | 26085 | 2 | 0 |
131451 | 131451 | 2020-05-10 | Lake | Michigan | 26085 | 2 | 0 |
128461 | 128461 | 2020-05-09 | Lake | Michigan | 26085 | 2 | 0 |
125474 | 125474 | 2020-05-08 | Lake | Michigan | 26085 | 2 | 0 |
122492 | 122492 | 2020-05-07 | Lake | Michigan | 26085 | 2 | 0 |
119520 | 119520 | 2020-05-06 | Lake | Michigan | 26085 | 2 | 0 |
116559 | 116559 | 2020-05-05 | Lake | Michigan | 26085 | 2 | 0 |
113678 | 113678 | 2020-05-04 | Lake | Michigan | 26085 | 2 | 0 |
110800 | 110800 | 2020-05-03 | Lake | Michigan | 26085 | 2 | 0 |
107928 | 107928 | 2020-05-02 | Lake | Michigan | 26085 | 2 | 0 |
105064 | 105064 | 2020-05-01 | Lake | Michigan | 26085 | 2 | 0 |
102204 | 102204 | 2020-04-30 | Lake | Michigan | 26085 | 2 | 0 |
99352 | 99352 | 2020-04-29 | Lake | Michigan | 26085 | 2 | 0 |
96506 | 96506 | 2020-04-28 | Lake | Michigan | 26085 | 2 | 0 |
93671 | 93671 | 2020-04-27 | Lake | Michigan | 26085 | 2 | 0 |
90850 | 90850 | 2020-04-26 | Lake | Michigan | 26085 | 2 | 0 |
88034 | 88034 | 2020-04-25 | Lake | Michigan | 26085 | 2 | 0 |
85224 | 85224 | 2020-04-24 | Lake | Michigan | 26085 | 2 | 0 |
82420 | 82420 | 2020-04-23 | Lake | Michigan | 26085 | 2 | 0 |
79625 | 79625 | 2020-04-22 | Lake | Michigan | 26085 | 2 | 0 |
76839 | 76839 | 2020-04-21 | Lake | Michigan | 26085 | 2 | 0 |
74059 | 74059 | 2020-04-20 | Lake | Michigan | 26085 | 2 | 0 |
71287 | 71287 | 2020-04-19 | Lake | Michigan | 26085 | 2 | 0 |
68523 | 68523 | 2020-04-18 | Lake | Michigan | 26085 | 2 | 0 |
65772 | 65772 | 2020-04-17 | Lake | Michigan | 26085 | 2 | 0 |
63034 | 63034 | 2020-04-16 | Lake | Michigan | 26085 | 2 | 0 |
60312 | 60312 | 2020-04-15 | Lake | Michigan | 26085 | 2 | 0 |
57602 | 57602 | 2020-04-14 | Lake | Michigan | 26085 | 2 | 0 |
54904 | 54904 | 2020-04-13 | Lake | Michigan | 26085 | 2 | 0 |
52223 | 52223 | 2020-04-12 | Lake | Michigan | 26085 | 1 | 0 |
49553 | 49553 | 2020-04-11 | Lake | Michigan | 26085 | 1 | 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);