ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Sioux" and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812165 | 1812165 | 2021-10-13 | Sioux | North Dakota | 38085 | 843 | 15 |
1808916 | 1808916 | 2021-10-12 | Sioux | North Dakota | 38085 | 841 | 14 |
1805665 | 1805665 | 2021-10-11 | Sioux | North Dakota | 38085 | 837 | 14 |
1802416 | 1802416 | 2021-10-10 | Sioux | North Dakota | 38085 | 835 | 14 |
1799167 | 1799167 | 2021-10-09 | Sioux | North Dakota | 38085 | 834 | 14 |
1795918 | 1795918 | 2021-10-08 | Sioux | North Dakota | 38085 | 834 | 14 |
1792669 | 1792669 | 2021-10-07 | Sioux | North Dakota | 38085 | 831 | 14 |
1789420 | 1789420 | 2021-10-06 | Sioux | North Dakota | 38085 | 832 | 14 |
1786172 | 1786172 | 2021-10-05 | Sioux | North Dakota | 38085 | 827 | 14 |
1782923 | 1782923 | 2021-10-04 | Sioux | North Dakota | 38085 | 823 | 14 |
1779674 | 1779674 | 2021-10-03 | Sioux | North Dakota | 38085 | 816 | 14 |
1776424 | 1776424 | 2021-10-02 | Sioux | North Dakota | 38085 | 815 | 14 |
1773174 | 1773174 | 2021-10-01 | Sioux | North Dakota | 38085 | 812 | 14 |
1769924 | 1769924 | 2021-09-30 | Sioux | North Dakota | 38085 | 811 | 14 |
1766675 | 1766675 | 2021-09-29 | Sioux | North Dakota | 38085 | 790 | 14 |
1763426 | 1763426 | 2021-09-28 | Sioux | North Dakota | 38085 | 789 | 14 |
1760177 | 1760177 | 2021-09-27 | Sioux | North Dakota | 38085 | 770 | 14 |
1756929 | 1756929 | 2021-09-26 | Sioux | North Dakota | 38085 | 770 | 14 |
1753681 | 1753681 | 2021-09-25 | Sioux | North Dakota | 38085 | 769 | 14 |
1750433 | 1750433 | 2021-09-24 | Sioux | North Dakota | 38085 | 767 | 14 |
1747183 | 1747183 | 2021-09-23 | Sioux | North Dakota | 38085 | 761 | 14 |
1743934 | 1743934 | 2021-09-22 | Sioux | North Dakota | 38085 | 759 | 14 |
1740685 | 1740685 | 2021-09-21 | Sioux | North Dakota | 38085 | 753 | 14 |
1737436 | 1737436 | 2021-09-20 | Sioux | North Dakota | 38085 | 752 | 14 |
1734186 | 1734186 | 2021-09-19 | Sioux | North Dakota | 38085 | 751 | 14 |
1730936 | 1730936 | 2021-09-18 | Sioux | North Dakota | 38085 | 747 | 14 |
1727686 | 1727686 | 2021-09-17 | Sioux | North Dakota | 38085 | 743 | 14 |
1724437 | 1724437 | 2021-09-16 | Sioux | North Dakota | 38085 | 742 | 14 |
1721188 | 1721188 | 2021-09-15 | Sioux | North Dakota | 38085 | 737 | 14 |
1717940 | 1717940 | 2021-09-14 | Sioux | North Dakota | 38085 | 730 | 14 |
1714692 | 1714692 | 2021-09-13 | Sioux | North Dakota | 38085 | 728 | 14 |
1711446 | 1711446 | 2021-09-12 | Sioux | North Dakota | 38085 | 727 | 14 |
1708199 | 1708199 | 2021-09-11 | Sioux | North Dakota | 38085 | 726 | 14 |
1704952 | 1704952 | 2021-09-10 | Sioux | North Dakota | 38085 | 724 | 13 |
1701702 | 1701702 | 2021-09-09 | Sioux | North Dakota | 38085 | 719 | 13 |
1698453 | 1698453 | 2021-09-08 | Sioux | North Dakota | 38085 | 713 | 13 |
1695205 | 1695205 | 2021-09-07 | Sioux | North Dakota | 38085 | 704 | 13 |
1691957 | 1691957 | 2021-09-06 | Sioux | North Dakota | 38085 | 704 | 13 |
1688707 | 1688707 | 2021-09-05 | Sioux | North Dakota | 38085 | 704 | 13 |
1685457 | 1685457 | 2021-09-04 | Sioux | North Dakota | 38085 | 704 | 13 |
1682206 | 1682206 | 2021-09-03 | Sioux | North Dakota | 38085 | 702 | 13 |
1678957 | 1678957 | 2021-09-02 | Sioux | North Dakota | 38085 | 699 | 12 |
1675709 | 1675709 | 2021-09-01 | Sioux | North Dakota | 38085 | 698 | 12 |
1672462 | 1672462 | 2021-08-31 | Sioux | North Dakota | 38085 | 697 | 12 |
1669214 | 1669214 | 2021-08-30 | Sioux | North Dakota | 38085 | 695 | 12 |
1665967 | 1665967 | 2021-08-29 | Sioux | North Dakota | 38085 | 694 | 12 |
1662719 | 1662719 | 2021-08-28 | Sioux | North Dakota | 38085 | 687 | 12 |
1659471 | 1659471 | 2021-08-27 | Sioux | North Dakota | 38085 | 684 | 12 |
1656222 | 1656222 | 2021-08-26 | Sioux | North Dakota | 38085 | 682 | 12 |
1652975 | 1652975 | 2021-08-25 | Sioux | North Dakota | 38085 | 685 | 12 |
1649727 | 1649727 | 2021-08-24 | Sioux | North Dakota | 38085 | 686 | 12 |
1646478 | 1646478 | 2021-08-23 | Sioux | North Dakota | 38085 | 687 | 12 |
1643229 | 1643229 | 2021-08-22 | Sioux | North Dakota | 38085 | 687 | 12 |
1639979 | 1639979 | 2021-08-21 | Sioux | North Dakota | 38085 | 687 | 12 |
1636729 | 1636729 | 2021-08-20 | Sioux | North Dakota | 38085 | 687 | 12 |
1633479 | 1633479 | 2021-08-19 | Sioux | North Dakota | 38085 | 684 | 12 |
1630232 | 1630232 | 2021-08-18 | Sioux | North Dakota | 38085 | 680 | 12 |
1626985 | 1626985 | 2021-08-17 | Sioux | North Dakota | 38085 | 679 | 12 |
1623738 | 1623738 | 2021-08-16 | Sioux | North Dakota | 38085 | 676 | 12 |
1620491 | 1620491 | 2021-08-15 | Sioux | North Dakota | 38085 | 675 | 12 |
1617243 | 1617243 | 2021-08-14 | Sioux | North Dakota | 38085 | 675 | 12 |
1613995 | 1613995 | 2021-08-13 | Sioux | North Dakota | 38085 | 674 | 12 |
1610746 | 1610746 | 2021-08-12 | Sioux | North Dakota | 38085 | 673 | 12 |
1607498 | 1607498 | 2021-08-11 | Sioux | North Dakota | 38085 | 673 | 12 |
1604249 | 1604249 | 2021-08-10 | Sioux | North Dakota | 38085 | 671 | 12 |
1601000 | 1601000 | 2021-08-09 | Sioux | North Dakota | 38085 | 670 | 12 |
1597752 | 1597752 | 2021-08-08 | Sioux | North Dakota | 38085 | 670 | 12 |
1594503 | 1594503 | 2021-08-07 | Sioux | North Dakota | 38085 | 670 | 12 |
1591254 | 1591254 | 2021-08-06 | Sioux | North Dakota | 38085 | 668 | 12 |
1588005 | 1588005 | 2021-08-05 | Sioux | North Dakota | 38085 | 668 | 12 |
1584755 | 1584755 | 2021-08-04 | Sioux | North Dakota | 38085 | 668 | 12 |
1581505 | 1581505 | 2021-08-03 | Sioux | North Dakota | 38085 | 666 | 12 |
1578256 | 1578256 | 2021-08-02 | Sioux | North Dakota | 38085 | 666 | 12 |
1575008 | 1575008 | 2021-08-01 | Sioux | North Dakota | 38085 | 666 | 12 |
1571760 | 1571760 | 2021-07-31 | Sioux | North Dakota | 38085 | 666 | 12 |
1568512 | 1568512 | 2021-07-30 | Sioux | North Dakota | 38085 | 666 | 12 |
1565264 | 1565264 | 2021-07-29 | Sioux | North Dakota | 38085 | 666 | 12 |
1562016 | 1562016 | 2021-07-28 | Sioux | North Dakota | 38085 | 666 | 12 |
1558768 | 1558768 | 2021-07-27 | Sioux | North Dakota | 38085 | 666 | 12 |
1555521 | 1555521 | 2021-07-26 | Sioux | North Dakota | 38085 | 666 | 12 |
1552274 | 1552274 | 2021-07-25 | Sioux | North Dakota | 38085 | 665 | 12 |
1549027 | 1549027 | 2021-07-24 | Sioux | North Dakota | 38085 | 665 | 12 |
1545780 | 1545780 | 2021-07-23 | Sioux | North Dakota | 38085 | 665 | 12 |
1542533 | 1542533 | 2021-07-22 | Sioux | North Dakota | 38085 | 665 | 12 |
1539285 | 1539285 | 2021-07-21 | Sioux | North Dakota | 38085 | 665 | 12 |
1536038 | 1536038 | 2021-07-20 | Sioux | North Dakota | 38085 | 665 | 12 |
1532790 | 1532790 | 2021-07-19 | Sioux | North Dakota | 38085 | 665 | 12 |
1529543 | 1529543 | 2021-07-18 | Sioux | North Dakota | 38085 | 665 | 12 |
1526296 | 1526296 | 2021-07-17 | Sioux | North Dakota | 38085 | 665 | 12 |
1523049 | 1523049 | 2021-07-16 | Sioux | North Dakota | 38085 | 665 | 12 |
1519801 | 1519801 | 2021-07-15 | Sioux | North Dakota | 38085 | 665 | 12 |
1516553 | 1516553 | 2021-07-14 | Sioux | North Dakota | 38085 | 665 | 12 |
1513306 | 1513306 | 2021-07-13 | Sioux | North Dakota | 38085 | 665 | 12 |
1510060 | 1510060 | 2021-07-12 | Sioux | North Dakota | 38085 | 665 | 12 |
1506813 | 1506813 | 2021-07-11 | Sioux | North Dakota | 38085 | 665 | 12 |
1503567 | 1503567 | 2021-07-10 | Sioux | North Dakota | 38085 | 665 | 12 |
1500321 | 1500321 | 2021-07-09 | Sioux | North Dakota | 38085 | 665 | 12 |
1497075 | 1497075 | 2021-07-08 | Sioux | North Dakota | 38085 | 665 | 12 |
1493828 | 1493828 | 2021-07-07 | Sioux | North Dakota | 38085 | 665 | 12 |
1490581 | 1490581 | 2021-07-06 | Sioux | North Dakota | 38085 | 665 | 12 |
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);