ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
737 rows where county = "Lake" and fips = 27075 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282123 | 282123 | 2020-06-28 | Lake | Minnesota | 27075 | 6 | 0 |
278975 | 278975 | 2020-06-27 | Lake | Minnesota | 27075 | 5 | 0 |
275827 | 275827 | 2020-06-26 | Lake | Minnesota | 27075 | 5 | 0 |
272684 | 272684 | 2020-06-25 | Lake | Minnesota | 27075 | 5 | 0 |
269547 | 269547 | 2020-06-24 | Lake | Minnesota | 27075 | 5 | 0 |
266414 | 266414 | 2020-06-23 | Lake | Minnesota | 27075 | 5 | 0 |
263288 | 263288 | 2020-06-22 | Lake | Minnesota | 27075 | 5 | 0 |
260159 | 260159 | 2020-06-21 | Lake | Minnesota | 27075 | 4 | 0 |
257033 | 257033 | 2020-06-20 | Lake | Minnesota | 27075 | 4 | 0 |
253913 | 253913 | 2020-06-19 | Lake | Minnesota | 27075 | 4 | 0 |
250798 | 250798 | 2020-06-18 | Lake | Minnesota | 27075 | 4 | 0 |
247686 | 247686 | 2020-06-17 | Lake | Minnesota | 27075 | 4 | 0 |
244573 | 244573 | 2020-06-16 | Lake | Minnesota | 27075 | 2 | 0 |
241462 | 241462 | 2020-06-15 | Lake | Minnesota | 27075 | 1 | 0 |
238353 | 238353 | 2020-06-14 | Lake | Minnesota | 27075 | 1 | 0 |
235246 | 235246 | 2020-06-13 | Lake | Minnesota | 27075 | 1 | 0 |
232140 | 232140 | 2020-06-12 | Lake | Minnesota | 27075 | 1 | 0 |
229036 | 229036 | 2020-06-11 | Lake | Minnesota | 27075 | 1 | 0 |
225934 | 225934 | 2020-06-10 | Lake | Minnesota | 27075 | 1 | 0 |
222836 | 222836 | 2020-06-09 | Lake | Minnesota | 27075 | 1 | 0 |
219741 | 219741 | 2020-06-08 | Lake | Minnesota | 27075 | 1 | 0 |
216649 | 216649 | 2020-06-07 | Lake | Minnesota | 27075 | 1 | 0 |
213561 | 213561 | 2020-06-06 | Lake | Minnesota | 27075 | 1 | 0 |
210477 | 210477 | 2020-06-05 | Lake | Minnesota | 27075 | 1 | 0 |
207396 | 207396 | 2020-06-04 | Lake | Minnesota | 27075 | 1 | 0 |
204315 | 204315 | 2020-06-03 | Lake | Minnesota | 27075 | 1 | 0 |
201238 | 201238 | 2020-06-02 | Lake | Minnesota | 27075 | 1 | 0 |
198165 | 198165 | 2020-06-01 | Lake | Minnesota | 27075 | 1 | 0 |
195094 | 195094 | 2020-05-31 | Lake | Minnesota | 27075 | 1 | 0 |
192026 | 192026 | 2020-05-30 | Lake | Minnesota | 27075 | 1 | 0 |
188962 | 188962 | 2020-05-29 | Lake | Minnesota | 27075 | 1 | 0 |
185904 | 185904 | 2020-05-28 | Lake | Minnesota | 27075 | 1 | 0 |
182849 | 182849 | 2020-05-27 | Lake | Minnesota | 27075 | 1 | 0 |
179803 | 179803 | 2020-05-26 | Lake | Minnesota | 27075 | 1 | 0 |
176759 | 176759 | 2020-05-25 | Lake | Minnesota | 27075 | 1 | 0 |
173716 | 173716 | 2020-05-24 | Lake | Minnesota | 27075 | 1 | 0 |
170674 | 170674 | 2020-05-23 | Lake | Minnesota | 27075 | 1 | 0 |
167636 | 167636 | 2020-05-22 | Lake | Minnesota | 27075 | 1 | 0 |
164600 | 164600 | 2020-05-21 | Lake | Minnesota | 27075 | 1 | 0 |
161571 | 161571 | 2020-05-20 | Lake | Minnesota | 27075 | 1 | 0 |
158545 | 158545 | 2020-05-19 | Lake | Minnesota | 27075 | 1 | 0 |
155527 | 155527 | 2020-05-18 | Lake | Minnesota | 27075 | 1 | 0 |
152513 | 152513 | 2020-05-17 | Lake | Minnesota | 27075 | 1 | 0 |
149502 | 149502 | 2020-05-16 | Lake | Minnesota | 27075 | 1 | 0 |
146497 | 146497 | 2020-05-15 | Lake | Minnesota | 27075 | 1 | 0 |
143497 | 143497 | 2020-05-14 | Lake | Minnesota | 27075 | 1 | 0 |
140502 | 140502 | 2020-05-13 | Lake | Minnesota | 27075 | 1 | 0 |
137508 | 137508 | 2020-05-12 | Lake | Minnesota | 27075 | 1 | 0 |
134518 | 134518 | 2020-05-11 | Lake | Minnesota | 27075 | 1 | 0 |
131527 | 131527 | 2020-05-10 | Lake | Minnesota | 27075 | 1 | 0 |
128537 | 128537 | 2020-05-09 | Lake | Minnesota | 27075 | 1 | 0 |
125550 | 125550 | 2020-05-08 | Lake | Minnesota | 27075 | 1 | 0 |
122568 | 122568 | 2020-05-07 | Lake | Minnesota | 27075 | 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);