ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
231 rows where deaths = 4 and fips = 27011 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1850440 | 1850440 | 2021-10-25 | Big Stone | Minnesota | 27011 | 798 | 4 |
1847190 | 1847190 | 2021-10-24 | Big Stone | Minnesota | 27011 | 797 | 4 |
1843940 | 1843940 | 2021-10-23 | Big Stone | Minnesota | 27011 | 797 | 4 |
1840690 | 1840690 | 2021-10-22 | Big Stone | Minnesota | 27011 | 797 | 4 |
1837441 | 1837441 | 2021-10-21 | Big Stone | Minnesota | 27011 | 797 | 4 |
1834192 | 1834192 | 2021-10-20 | Big Stone | Minnesota | 27011 | 795 | 4 |
1830943 | 1830943 | 2021-10-19 | Big Stone | Minnesota | 27011 | 793 | 4 |
1827694 | 1827694 | 2021-10-18 | Big Stone | Minnesota | 27011 | 789 | 4 |
1824445 | 1824445 | 2021-10-17 | Big Stone | Minnesota | 27011 | 787 | 4 |
1821196 | 1821196 | 2021-10-16 | Big Stone | Minnesota | 27011 | 787 | 4 |
1817947 | 1817947 | 2021-10-15 | Big Stone | Minnesota | 27011 | 787 | 4 |
1814698 | 1814698 | 2021-10-14 | Big Stone | Minnesota | 27011 | 783 | 4 |
1811450 | 1811450 | 2021-10-13 | Big Stone | Minnesota | 27011 | 776 | 4 |
1808201 | 1808201 | 2021-10-12 | Big Stone | Minnesota | 27011 | 771 | 4 |
1804950 | 1804950 | 2021-10-11 | Big Stone | Minnesota | 27011 | 762 | 4 |
1801701 | 1801701 | 2021-10-10 | Big Stone | Minnesota | 27011 | 754 | 4 |
1798452 | 1798452 | 2021-10-09 | Big Stone | Minnesota | 27011 | 754 | 4 |
1795203 | 1795203 | 2021-10-08 | Big Stone | Minnesota | 27011 | 754 | 4 |
1791954 | 1791954 | 2021-10-07 | Big Stone | Minnesota | 27011 | 750 | 4 |
1788705 | 1788705 | 2021-10-06 | Big Stone | Minnesota | 27011 | 746 | 4 |
1785457 | 1785457 | 2021-10-05 | Big Stone | Minnesota | 27011 | 740 | 4 |
1782208 | 1782208 | 2021-10-04 | Big Stone | Minnesota | 27011 | 729 | 4 |
1778958 | 1778958 | 2021-10-03 | Big Stone | Minnesota | 27011 | 721 | 4 |
1775708 | 1775708 | 2021-10-02 | Big Stone | Minnesota | 27011 | 721 | 4 |
1772458 | 1772458 | 2021-10-01 | Big Stone | Minnesota | 27011 | 721 | 4 |
1769209 | 1769209 | 2021-09-30 | Big Stone | Minnesota | 27011 | 720 | 4 |
1765960 | 1765960 | 2021-09-29 | Big Stone | Minnesota | 27011 | 714 | 4 |
1762711 | 1762711 | 2021-09-28 | Big Stone | Minnesota | 27011 | 714 | 4 |
1759462 | 1759462 | 2021-09-27 | Big Stone | Minnesota | 27011 | 704 | 4 |
1756214 | 1756214 | 2021-09-26 | Big Stone | Minnesota | 27011 | 702 | 4 |
1752966 | 1752966 | 2021-09-25 | Big Stone | Minnesota | 27011 | 702 | 4 |
1749718 | 1749718 | 2021-09-24 | Big Stone | Minnesota | 27011 | 702 | 4 |
1746468 | 1746468 | 2021-09-23 | Big Stone | Minnesota | 27011 | 703 | 4 |
1743219 | 1743219 | 2021-09-22 | Big Stone | Minnesota | 27011 | 701 | 4 |
1739970 | 1739970 | 2021-09-21 | Big Stone | Minnesota | 27011 | 696 | 4 |
1736721 | 1736721 | 2021-09-20 | Big Stone | Minnesota | 27011 | 685 | 4 |
1733471 | 1733471 | 2021-09-19 | Big Stone | Minnesota | 27011 | 681 | 4 |
1730221 | 1730221 | 2021-09-18 | Big Stone | Minnesota | 27011 | 681 | 4 |
1726971 | 1726971 | 2021-09-17 | Big Stone | Minnesota | 27011 | 681 | 4 |
1723722 | 1723722 | 2021-09-16 | Big Stone | Minnesota | 27011 | 678 | 4 |
1720473 | 1720473 | 2021-09-15 | Big Stone | Minnesota | 27011 | 672 | 4 |
1717225 | 1717225 | 2021-09-14 | Big Stone | Minnesota | 27011 | 670 | 4 |
1713977 | 1713977 | 2021-09-13 | Big Stone | Minnesota | 27011 | 666 | 4 |
1710731 | 1710731 | 2021-09-12 | Big Stone | Minnesota | 27011 | 663 | 4 |
1707484 | 1707484 | 2021-09-11 | Big Stone | Minnesota | 27011 | 663 | 4 |
1704237 | 1704237 | 2021-09-10 | Big Stone | Minnesota | 27011 | 663 | 4 |
1700987 | 1700987 | 2021-09-09 | Big Stone | Minnesota | 27011 | 658 | 4 |
1697738 | 1697738 | 2021-09-08 | Big Stone | Minnesota | 27011 | 656 | 4 |
1694490 | 1694490 | 2021-09-07 | Big Stone | Minnesota | 27011 | 646 | 4 |
1691241 | 1691241 | 2021-09-06 | Big Stone | Minnesota | 27011 | 644 | 4 |
1687991 | 1687991 | 2021-09-05 | Big Stone | Minnesota | 27011 | 644 | 4 |
1684741 | 1684741 | 2021-09-04 | Big Stone | Minnesota | 27011 | 644 | 4 |
1681490 | 1681490 | 2021-09-03 | Big Stone | Minnesota | 27011 | 644 | 4 |
1678242 | 1678242 | 2021-09-02 | Big Stone | Minnesota | 27011 | 640 | 4 |
1674994 | 1674994 | 2021-09-01 | Big Stone | Minnesota | 27011 | 634 | 4 |
1671746 | 1671746 | 2021-08-31 | Big Stone | Minnesota | 27011 | 632 | 4 |
1668499 | 1668499 | 2021-08-30 | Big Stone | Minnesota | 27011 | 629 | 4 |
1665252 | 1665252 | 2021-08-29 | Big Stone | Minnesota | 27011 | 627 | 4 |
1662004 | 1662004 | 2021-08-28 | Big Stone | Minnesota | 27011 | 627 | 4 |
1658756 | 1658756 | 2021-08-27 | Big Stone | Minnesota | 27011 | 627 | 4 |
1655507 | 1655507 | 2021-08-26 | Big Stone | Minnesota | 27011 | 625 | 4 |
1652260 | 1652260 | 2021-08-25 | Big Stone | Minnesota | 27011 | 620 | 4 |
1649012 | 1649012 | 2021-08-24 | Big Stone | Minnesota | 27011 | 620 | 4 |
1645763 | 1645763 | 2021-08-23 | Big Stone | Minnesota | 27011 | 620 | 4 |
1642514 | 1642514 | 2021-08-22 | Big Stone | Minnesota | 27011 | 620 | 4 |
1639264 | 1639264 | 2021-08-21 | Big Stone | Minnesota | 27011 | 620 | 4 |
1636014 | 1636014 | 2021-08-20 | Big Stone | Minnesota | 27011 | 620 | 4 |
1632764 | 1632764 | 2021-08-19 | Big Stone | Minnesota | 27011 | 619 | 4 |
1629517 | 1629517 | 2021-08-18 | Big Stone | Minnesota | 27011 | 619 | 4 |
1626270 | 1626270 | 2021-08-17 | Big Stone | Minnesota | 27011 | 619 | 4 |
1623023 | 1623023 | 2021-08-16 | Big Stone | Minnesota | 27011 | 618 | 4 |
1619776 | 1619776 | 2021-08-15 | Big Stone | Minnesota | 27011 | 617 | 4 |
1616528 | 1616528 | 2021-08-14 | Big Stone | Minnesota | 27011 | 617 | 4 |
1613280 | 1613280 | 2021-08-13 | Big Stone | Minnesota | 27011 | 617 | 4 |
1610031 | 1610031 | 2021-08-12 | Big Stone | Minnesota | 27011 | 617 | 4 |
1606783 | 1606783 | 2021-08-11 | Big Stone | Minnesota | 27011 | 618 | 4 |
1603534 | 1603534 | 2021-08-10 | Big Stone | Minnesota | 27011 | 618 | 4 |
1600285 | 1600285 | 2021-08-09 | Big Stone | Minnesota | 27011 | 615 | 4 |
1597037 | 1597037 | 2021-08-08 | Big Stone | Minnesota | 27011 | 615 | 4 |
1593788 | 1593788 | 2021-08-07 | Big Stone | Minnesota | 27011 | 615 | 4 |
1590539 | 1590539 | 2021-08-06 | Big Stone | Minnesota | 27011 | 615 | 4 |
1587290 | 1587290 | 2021-08-05 | Big Stone | Minnesota | 27011 | 615 | 4 |
1584039 | 1584039 | 2021-08-04 | Big Stone | Minnesota | 27011 | 614 | 4 |
1580790 | 1580790 | 2021-08-03 | Big Stone | Minnesota | 27011 | 613 | 4 |
1577541 | 1577541 | 2021-08-02 | Big Stone | Minnesota | 27011 | 613 | 4 |
1574293 | 1574293 | 2021-08-01 | Big Stone | Minnesota | 27011 | 613 | 4 |
1571045 | 1571045 | 2021-07-31 | Big Stone | Minnesota | 27011 | 613 | 4 |
1567797 | 1567797 | 2021-07-30 | Big Stone | Minnesota | 27011 | 613 | 4 |
1564549 | 1564549 | 2021-07-29 | Big Stone | Minnesota | 27011 | 611 | 4 |
1561301 | 1561301 | 2021-07-28 | Big Stone | Minnesota | 27011 | 609 | 4 |
1558053 | 1558053 | 2021-07-27 | Big Stone | Minnesota | 27011 | 609 | 4 |
1554806 | 1554806 | 2021-07-26 | Big Stone | Minnesota | 27011 | 609 | 4 |
1551559 | 1551559 | 2021-07-25 | Big Stone | Minnesota | 27011 | 609 | 4 |
1548312 | 1548312 | 2021-07-24 | Big Stone | Minnesota | 27011 | 609 | 4 |
1545065 | 1545065 | 2021-07-23 | Big Stone | Minnesota | 27011 | 609 | 4 |
1541817 | 1541817 | 2021-07-22 | Big Stone | Minnesota | 27011 | 609 | 4 |
1538570 | 1538570 | 2021-07-21 | Big Stone | Minnesota | 27011 | 609 | 4 |
1535323 | 1535323 | 2021-07-20 | Big Stone | Minnesota | 27011 | 609 | 4 |
1532075 | 1532075 | 2021-07-19 | Big Stone | Minnesota | 27011 | 609 | 4 |
1528828 | 1528828 | 2021-07-18 | Big Stone | Minnesota | 27011 | 607 | 4 |
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);