ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where fips = 27105 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387311 | 387311 | 2020-07-31 | Nobles | Minnesota | 27105 | 1738 | 6 |
384093 | 384093 | 2020-07-30 | Nobles | Minnesota | 27105 | 1737 | 6 |
380876 | 380876 | 2020-07-29 | Nobles | Minnesota | 27105 | 1734 | 6 |
377659 | 377659 | 2020-07-28 | Nobles | Minnesota | 27105 | 1728 | 6 |
374444 | 374444 | 2020-07-27 | Nobles | Minnesota | 27105 | 1728 | 6 |
371232 | 371232 | 2020-07-26 | Nobles | Minnesota | 27105 | 1727 | 6 |
368022 | 368022 | 2020-07-25 | Nobles | Minnesota | 27105 | 1725 | 6 |
364814 | 364814 | 2020-07-24 | Nobles | Minnesota | 27105 | 1721 | 6 |
361607 | 361607 | 2020-07-23 | Nobles | Minnesota | 27105 | 1714 | 6 |
358402 | 358402 | 2020-07-22 | Nobles | Minnesota | 27105 | 1713 | 6 |
355199 | 355199 | 2020-07-21 | Nobles | Minnesota | 27105 | 1711 | 6 |
351997 | 351997 | 2020-07-20 | Nobles | Minnesota | 27105 | 1706 | 6 |
348797 | 348797 | 2020-07-19 | Nobles | Minnesota | 27105 | 1706 | 6 |
345596 | 345596 | 2020-07-18 | Nobles | Minnesota | 27105 | 1704 | 6 |
342396 | 342396 | 2020-07-17 | Nobles | Minnesota | 27105 | 1702 | 6 |
339200 | 339200 | 2020-07-16 | Nobles | Minnesota | 27105 | 1698 | 6 |
336004 | 336004 | 2020-07-15 | Nobles | Minnesota | 27105 | 1698 | 6 |
332811 | 332811 | 2020-07-14 | Nobles | Minnesota | 27105 | 1697 | 6 |
329624 | 329624 | 2020-07-13 | Nobles | Minnesota | 27105 | 1694 | 6 |
326438 | 326438 | 2020-07-12 | Nobles | Minnesota | 27105 | 1688 | 6 |
323255 | 323255 | 2020-07-11 | Nobles | Minnesota | 27105 | 1684 | 6 |
320076 | 320076 | 2020-07-10 | Nobles | Minnesota | 27105 | 1676 | 6 |
316901 | 316901 | 2020-07-09 | Nobles | Minnesota | 27105 | 1676 | 6 |
313727 | 313727 | 2020-07-08 | Nobles | Minnesota | 27105 | 1672 | 6 |
310557 | 310557 | 2020-07-07 | Nobles | Minnesota | 27105 | 1672 | 6 |
307389 | 307389 | 2020-07-06 | Nobles | Minnesota | 27105 | 1669 | 6 |
304222 | 304222 | 2020-07-05 | Nobles | Minnesota | 27105 | 1668 | 6 |
301058 | 301058 | 2020-07-04 | Nobles | Minnesota | 27105 | 1662 | 6 |
297895 | 297895 | 2020-07-03 | Nobles | Minnesota | 27105 | 1662 | 6 |
294737 | 294737 | 2020-07-02 | Nobles | Minnesota | 27105 | 1661 | 6 |
291583 | 291583 | 2020-07-01 | Nobles | Minnesota | 27105 | 1655 | 6 |
288432 | 288432 | 2020-06-30 | Nobles | Minnesota | 27105 | 1652 | 6 |
285282 | 285282 | 2020-06-29 | Nobles | Minnesota | 27105 | 1651 | 6 |
282137 | 282137 | 2020-06-28 | Nobles | Minnesota | 27105 | 1649 | 6 |
278989 | 278989 | 2020-06-27 | Nobles | Minnesota | 27105 | 1644 | 6 |
275841 | 275841 | 2020-06-26 | Nobles | Minnesota | 27105 | 1643 | 6 |
272698 | 272698 | 2020-06-25 | Nobles | Minnesota | 27105 | 1637 | 6 |
269561 | 269561 | 2020-06-24 | Nobles | Minnesota | 27105 | 1635 | 6 |
266428 | 266428 | 2020-06-23 | Nobles | Minnesota | 27105 | 1634 | 6 |
263302 | 263302 | 2020-06-22 | Nobles | Minnesota | 27105 | 1632 | 6 |
260173 | 260173 | 2020-06-21 | Nobles | Minnesota | 27105 | 1631 | 6 |
257047 | 257047 | 2020-06-20 | Nobles | Minnesota | 27105 | 1630 | 6 |
253927 | 253927 | 2020-06-19 | Nobles | Minnesota | 27105 | 1628 | 6 |
250812 | 250812 | 2020-06-18 | Nobles | Minnesota | 27105 | 1621 | 6 |
247700 | 247700 | 2020-06-17 | Nobles | Minnesota | 27105 | 1620 | 6 |
244587 | 244587 | 2020-06-16 | Nobles | Minnesota | 27105 | 1620 | 6 |
241476 | 241476 | 2020-06-15 | Nobles | Minnesota | 27105 | 1620 | 6 |
238367 | 238367 | 2020-06-14 | Nobles | Minnesota | 27105 | 1620 | 6 |
235260 | 235260 | 2020-06-13 | Nobles | Minnesota | 27105 | 1618 | 6 |
232154 | 232154 | 2020-06-12 | Nobles | Minnesota | 27105 | 1607 | 6 |
229050 | 229050 | 2020-06-11 | Nobles | Minnesota | 27105 | 1602 | 6 |
225948 | 225948 | 2020-06-10 | Nobles | Minnesota | 27105 | 1599 | 6 |
222850 | 222850 | 2020-06-09 | Nobles | Minnesota | 27105 | 1597 | 5 |
219755 | 219755 | 2020-06-08 | Nobles | Minnesota | 27105 | 1597 | 5 |
216663 | 216663 | 2020-06-07 | Nobles | Minnesota | 27105 | 1592 | 5 |
213575 | 213575 | 2020-06-06 | Nobles | Minnesota | 27105 | 1585 | 5 |
210491 | 210491 | 2020-06-05 | Nobles | Minnesota | 27105 | 1577 | 5 |
207410 | 207410 | 2020-06-04 | Nobles | Minnesota | 27105 | 1562 | 5 |
204329 | 204329 | 2020-06-03 | Nobles | Minnesota | 27105 | 1558 | 5 |
201252 | 201252 | 2020-06-02 | Nobles | Minnesota | 27105 | 1552 | 5 |
198179 | 198179 | 2020-06-01 | Nobles | Minnesota | 27105 | 1544 | 5 |
195108 | 195108 | 2020-05-31 | Nobles | Minnesota | 27105 | 1539 | 5 |
192040 | 192040 | 2020-05-30 | Nobles | Minnesota | 27105 | 1512 | 5 |
188976 | 188976 | 2020-05-29 | Nobles | Minnesota | 27105 | 1503 | 4 |
185918 | 185918 | 2020-05-28 | Nobles | Minnesota | 27105 | 1496 | 3 |
182863 | 182863 | 2020-05-27 | Nobles | Minnesota | 27105 | 1488 | 3 |
179817 | 179817 | 2020-05-26 | Nobles | Minnesota | 27105 | 1478 | 2 |
176773 | 176773 | 2020-05-25 | Nobles | Minnesota | 27105 | 1469 | 2 |
173730 | 173730 | 2020-05-24 | Nobles | Minnesota | 27105 | 1457 | 2 |
170688 | 170688 | 2020-05-23 | Nobles | Minnesota | 27105 | 1444 | 2 |
167650 | 167650 | 2020-05-22 | Nobles | Minnesota | 27105 | 1432 | 2 |
164614 | 164614 | 2020-05-21 | Nobles | Minnesota | 27105 | 1414 | 2 |
161585 | 161585 | 2020-05-20 | Nobles | Minnesota | 27105 | 1396 | 2 |
158559 | 158559 | 2020-05-19 | Nobles | Minnesota | 27105 | 1394 | 2 |
155541 | 155541 | 2020-05-18 | Nobles | Minnesota | 27105 | 1387 | 2 |
152527 | 152527 | 2020-05-17 | Nobles | Minnesota | 27105 | 1361 | 2 |
149516 | 149516 | 2020-05-16 | Nobles | Minnesota | 27105 | 1353 | 2 |
146511 | 146511 | 2020-05-15 | Nobles | Minnesota | 27105 | 1342 | 2 |
143511 | 143511 | 2020-05-14 | Nobles | Minnesota | 27105 | 1319 | 2 |
140516 | 140516 | 2020-05-13 | Nobles | Minnesota | 27105 | 1291 | 2 |
137522 | 137522 | 2020-05-12 | Nobles | Minnesota | 27105 | 1291 | 2 |
134532 | 134532 | 2020-05-11 | Nobles | Minnesota | 27105 | 1269 | 2 |
131541 | 131541 | 2020-05-10 | Nobles | Minnesota | 27105 | 1255 | 2 |
128551 | 128551 | 2020-05-09 | Nobles | Minnesota | 27105 | 1230 | 2 |
125564 | 125564 | 2020-05-08 | Nobles | Minnesota | 27105 | 1177 | 2 |
122582 | 122582 | 2020-05-07 | Nobles | Minnesota | 27105 | 1153 | 2 |
119608 | 119608 | 2020-05-06 | Nobles | Minnesota | 27105 | 1082 | 2 |
116648 | 116648 | 2020-05-05 | Nobles | Minnesota | 27105 | 1069 | 1 |
113767 | 113767 | 2020-05-04 | Nobles | Minnesota | 27105 | 1011 | 1 |
110888 | 110888 | 2020-05-03 | Nobles | Minnesota | 27105 | 940 | 1 |
108017 | 108017 | 2020-05-02 | Nobles | Minnesota | 27105 | 899 | 1 |
105152 | 105152 | 2020-05-01 | Nobles | Minnesota | 27105 | 866 | 1 |
102291 | 102291 | 2020-04-30 | Nobles | Minnesota | 27105 | 742 | 1 |
99439 | 99439 | 2020-04-29 | Nobles | Minnesota | 27105 | 615 | 1 |
96593 | 96593 | 2020-04-28 | Nobles | Minnesota | 27105 | 477 | 1 |
93758 | 93758 | 2020-04-27 | Nobles | Minnesota | 27105 | 399 | 1 |
90937 | 90937 | 2020-04-26 | Nobles | Minnesota | 27105 | 352 | 1 |
88121 | 88121 | 2020-04-25 | Nobles | Minnesota | 27105 | 325 | 1 |
85311 | 85311 | 2020-04-24 | Nobles | Minnesota | 27105 | 258 | 1 |
82507 | 82507 | 2020-04-23 | Nobles | Minnesota | 27105 | 196 | 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);