ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
737 rows where fips = 27075 and state = "Minnesota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
122568 | 122568 | 2020-05-07 | Lake | Minnesota | 27075 | 1 | 0 |
125550 | 125550 | 2020-05-08 | Lake | Minnesota | 27075 | 1 | 0 |
128537 | 128537 | 2020-05-09 | Lake | Minnesota | 27075 | 1 | 0 |
131527 | 131527 | 2020-05-10 | Lake | Minnesota | 27075 | 1 | 0 |
134518 | 134518 | 2020-05-11 | Lake | Minnesota | 27075 | 1 | 0 |
137508 | 137508 | 2020-05-12 | Lake | Minnesota | 27075 | 1 | 0 |
140502 | 140502 | 2020-05-13 | Lake | Minnesota | 27075 | 1 | 0 |
143497 | 143497 | 2020-05-14 | Lake | Minnesota | 27075 | 1 | 0 |
146497 | 146497 | 2020-05-15 | Lake | Minnesota | 27075 | 1 | 0 |
149502 | 149502 | 2020-05-16 | Lake | Minnesota | 27075 | 1 | 0 |
152513 | 152513 | 2020-05-17 | Lake | Minnesota | 27075 | 1 | 0 |
155527 | 155527 | 2020-05-18 | Lake | Minnesota | 27075 | 1 | 0 |
158545 | 158545 | 2020-05-19 | Lake | Minnesota | 27075 | 1 | 0 |
161571 | 161571 | 2020-05-20 | Lake | Minnesota | 27075 | 1 | 0 |
164600 | 164600 | 2020-05-21 | Lake | Minnesota | 27075 | 1 | 0 |
167636 | 167636 | 2020-05-22 | Lake | Minnesota | 27075 | 1 | 0 |
170674 | 170674 | 2020-05-23 | Lake | Minnesota | 27075 | 1 | 0 |
173716 | 173716 | 2020-05-24 | Lake | Minnesota | 27075 | 1 | 0 |
176759 | 176759 | 2020-05-25 | Lake | Minnesota | 27075 | 1 | 0 |
179803 | 179803 | 2020-05-26 | Lake | Minnesota | 27075 | 1 | 0 |
182849 | 182849 | 2020-05-27 | Lake | Minnesota | 27075 | 1 | 0 |
185904 | 185904 | 2020-05-28 | Lake | Minnesota | 27075 | 1 | 0 |
188962 | 188962 | 2020-05-29 | Lake | Minnesota | 27075 | 1 | 0 |
192026 | 192026 | 2020-05-30 | Lake | Minnesota | 27075 | 1 | 0 |
195094 | 195094 | 2020-05-31 | Lake | Minnesota | 27075 | 1 | 0 |
198165 | 198165 | 2020-06-01 | Lake | Minnesota | 27075 | 1 | 0 |
201238 | 201238 | 2020-06-02 | Lake | Minnesota | 27075 | 1 | 0 |
204315 | 204315 | 2020-06-03 | Lake | Minnesota | 27075 | 1 | 0 |
207396 | 207396 | 2020-06-04 | Lake | Minnesota | 27075 | 1 | 0 |
210477 | 210477 | 2020-06-05 | Lake | Minnesota | 27075 | 1 | 0 |
213561 | 213561 | 2020-06-06 | Lake | Minnesota | 27075 | 1 | 0 |
216649 | 216649 | 2020-06-07 | Lake | Minnesota | 27075 | 1 | 0 |
219741 | 219741 | 2020-06-08 | Lake | Minnesota | 27075 | 1 | 0 |
222836 | 222836 | 2020-06-09 | Lake | Minnesota | 27075 | 1 | 0 |
225934 | 225934 | 2020-06-10 | Lake | Minnesota | 27075 | 1 | 0 |
229036 | 229036 | 2020-06-11 | Lake | Minnesota | 27075 | 1 | 0 |
232140 | 232140 | 2020-06-12 | Lake | Minnesota | 27075 | 1 | 0 |
235246 | 235246 | 2020-06-13 | Lake | Minnesota | 27075 | 1 | 0 |
238353 | 238353 | 2020-06-14 | Lake | Minnesota | 27075 | 1 | 0 |
241462 | 241462 | 2020-06-15 | Lake | Minnesota | 27075 | 1 | 0 |
244573 | 244573 | 2020-06-16 | Lake | Minnesota | 27075 | 2 | 0 |
247686 | 247686 | 2020-06-17 | Lake | Minnesota | 27075 | 4 | 0 |
250798 | 250798 | 2020-06-18 | Lake | Minnesota | 27075 | 4 | 0 |
253913 | 253913 | 2020-06-19 | Lake | Minnesota | 27075 | 4 | 0 |
257033 | 257033 | 2020-06-20 | Lake | Minnesota | 27075 | 4 | 0 |
260159 | 260159 | 2020-06-21 | Lake | Minnesota | 27075 | 4 | 0 |
263288 | 263288 | 2020-06-22 | Lake | Minnesota | 27075 | 5 | 0 |
266414 | 266414 | 2020-06-23 | Lake | Minnesota | 27075 | 5 | 0 |
269547 | 269547 | 2020-06-24 | Lake | Minnesota | 27075 | 5 | 0 |
272684 | 272684 | 2020-06-25 | Lake | Minnesota | 27075 | 5 | 0 |
275827 | 275827 | 2020-06-26 | Lake | Minnesota | 27075 | 5 | 0 |
278975 | 278975 | 2020-06-27 | Lake | Minnesota | 27075 | 5 | 0 |
282123 | 282123 | 2020-06-28 | Lake | Minnesota | 27075 | 6 | 0 |
285268 | 285268 | 2020-06-29 | Lake | Minnesota | 27075 | 6 | 0 |
288418 | 288418 | 2020-06-30 | Lake | Minnesota | 27075 | 7 | 0 |
291569 | 291569 | 2020-07-01 | Lake | Minnesota | 27075 | 6 | 0 |
294723 | 294723 | 2020-07-02 | Lake | Minnesota | 27075 | 6 | 0 |
297881 | 297881 | 2020-07-03 | Lake | Minnesota | 27075 | 6 | 0 |
301044 | 301044 | 2020-07-04 | Lake | Minnesota | 27075 | 6 | 0 |
304208 | 304208 | 2020-07-05 | Lake | Minnesota | 27075 | 6 | 0 |
307375 | 307375 | 2020-07-06 | Lake | Minnesota | 27075 | 6 | 0 |
310543 | 310543 | 2020-07-07 | Lake | Minnesota | 27075 | 6 | 0 |
313713 | 313713 | 2020-07-08 | Lake | Minnesota | 27075 | 6 | 0 |
316887 | 316887 | 2020-07-09 | Lake | Minnesota | 27075 | 6 | 0 |
320062 | 320062 | 2020-07-10 | Lake | Minnesota | 27075 | 6 | 0 |
323241 | 323241 | 2020-07-11 | Lake | Minnesota | 27075 | 6 | 0 |
326424 | 326424 | 2020-07-12 | Lake | Minnesota | 27075 | 9 | 0 |
329610 | 329610 | 2020-07-13 | Lake | Minnesota | 27075 | 9 | 0 |
332797 | 332797 | 2020-07-14 | Lake | Minnesota | 27075 | 9 | 0 |
335990 | 335990 | 2020-07-15 | Lake | Minnesota | 27075 | 10 | 0 |
339186 | 339186 | 2020-07-16 | Lake | Minnesota | 27075 | 12 | 0 |
342382 | 342382 | 2020-07-17 | Lake | Minnesota | 27075 | 12 | 0 |
345582 | 345582 | 2020-07-18 | Lake | Minnesota | 27075 | 12 | 0 |
348783 | 348783 | 2020-07-19 | Lake | Minnesota | 27075 | 12 | 0 |
351983 | 351983 | 2020-07-20 | Lake | Minnesota | 27075 | 12 | 0 |
355185 | 355185 | 2020-07-21 | Lake | Minnesota | 27075 | 14 | 0 |
358388 | 358388 | 2020-07-22 | Lake | Minnesota | 27075 | 14 | 0 |
361593 | 361593 | 2020-07-23 | Lake | Minnesota | 27075 | 13 | 0 |
364800 | 364800 | 2020-07-24 | Lake | Minnesota | 27075 | 13 | 0 |
368007 | 368007 | 2020-07-25 | Lake | Minnesota | 27075 | 13 | 0 |
371217 | 371217 | 2020-07-26 | Lake | Minnesota | 27075 | 13 | 0 |
374429 | 374429 | 2020-07-27 | Lake | Minnesota | 27075 | 14 | 0 |
377644 | 377644 | 2020-07-28 | Lake | Minnesota | 27075 | 14 | 0 |
380861 | 380861 | 2020-07-29 | Lake | Minnesota | 27075 | 14 | 0 |
384078 | 384078 | 2020-07-30 | Lake | Minnesota | 27075 | 14 | 0 |
387296 | 387296 | 2020-07-31 | Lake | Minnesota | 27075 | 15 | 0 |
390513 | 390513 | 2020-08-01 | Lake | Minnesota | 27075 | 17 | 0 |
393730 | 393730 | 2020-08-02 | Lake | Minnesota | 27075 | 17 | 0 |
396946 | 396946 | 2020-08-03 | Lake | Minnesota | 27075 | 18 | 0 |
400160 | 400160 | 2020-08-04 | Lake | Minnesota | 27075 | 18 | 0 |
403377 | 403377 | 2020-08-05 | Lake | Minnesota | 27075 | 18 | 0 |
406595 | 406595 | 2020-08-06 | Lake | Minnesota | 27075 | 20 | 0 |
409815 | 409815 | 2020-08-07 | Lake | Minnesota | 27075 | 20 | 0 |
413035 | 413035 | 2020-08-08 | Lake | Minnesota | 27075 | 20 | 0 |
416255 | 416255 | 2020-08-09 | Lake | Minnesota | 27075 | 21 | 0 |
419476 | 419476 | 2020-08-10 | Lake | Minnesota | 27075 | 21 | 0 |
422698 | 422698 | 2020-08-11 | Lake | Minnesota | 27075 | 21 | 0 |
425920 | 425920 | 2020-08-12 | Lake | Minnesota | 27075 | 22 | 0 |
429144 | 429144 | 2020-08-13 | Lake | Minnesota | 27075 | 22 | 0 |
432371 | 432371 | 2020-08-14 | Lake | Minnesota | 27075 | 24 | 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);