ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 38049 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 |
---|---|---|---|---|---|---|---|
1812147 | 1812147 | 2021-10-13 | McHenry | North Dakota | 38049 | 824 | 23 |
1808898 | 1808898 | 2021-10-12 | McHenry | North Dakota | 38049 | 820 | 23 |
1805647 | 1805647 | 2021-10-11 | McHenry | North Dakota | 38049 | 813 | 23 |
1802398 | 1802398 | 2021-10-10 | McHenry | North Dakota | 38049 | 813 | 23 |
1799149 | 1799149 | 2021-10-09 | McHenry | North Dakota | 38049 | 810 | 23 |
1795900 | 1795900 | 2021-10-08 | McHenry | North Dakota | 38049 | 806 | 23 |
1792651 | 1792651 | 2021-10-07 | McHenry | North Dakota | 38049 | 803 | 23 |
1789402 | 1789402 | 2021-10-06 | McHenry | North Dakota | 38049 | 797 | 23 |
1786154 | 1786154 | 2021-10-05 | McHenry | North Dakota | 38049 | 790 | 23 |
1782905 | 1782905 | 2021-10-04 | McHenry | North Dakota | 38049 | 785 | 23 |
1779656 | 1779656 | 2021-10-03 | McHenry | North Dakota | 38049 | 781 | 23 |
1776406 | 1776406 | 2021-10-02 | McHenry | North Dakota | 38049 | 780 | 23 |
1773156 | 1773156 | 2021-10-01 | McHenry | North Dakota | 38049 | 776 | 23 |
1769906 | 1769906 | 2021-09-30 | McHenry | North Dakota | 38049 | 773 | 23 |
1766657 | 1766657 | 2021-09-29 | McHenry | North Dakota | 38049 | 770 | 23 |
1763408 | 1763408 | 2021-09-28 | McHenry | North Dakota | 38049 | 770 | 23 |
1760159 | 1760159 | 2021-09-27 | McHenry | North Dakota | 38049 | 764 | 23 |
1756911 | 1756911 | 2021-09-26 | McHenry | North Dakota | 38049 | 764 | 23 |
1753663 | 1753663 | 2021-09-25 | McHenry | North Dakota | 38049 | 760 | 23 |
1750415 | 1750415 | 2021-09-24 | McHenry | North Dakota | 38049 | 757 | 23 |
1747165 | 1747165 | 2021-09-23 | McHenry | North Dakota | 38049 | 756 | 23 |
1743916 | 1743916 | 2021-09-22 | McHenry | North Dakota | 38049 | 752 | 23 |
1740667 | 1740667 | 2021-09-21 | McHenry | North Dakota | 38049 | 744 | 23 |
1737418 | 1737418 | 2021-09-20 | McHenry | North Dakota | 38049 | 739 | 23 |
1734168 | 1734168 | 2021-09-19 | McHenry | North Dakota | 38049 | 737 | 23 |
1730918 | 1730918 | 2021-09-18 | McHenry | North Dakota | 38049 | 737 | 23 |
1727668 | 1727668 | 2021-09-17 | McHenry | North Dakota | 38049 | 735 | 23 |
1724419 | 1724419 | 2021-09-16 | McHenry | North Dakota | 38049 | 733 | 23 |
1721170 | 1721170 | 2021-09-15 | McHenry | North Dakota | 38049 | 728 | 23 |
1717922 | 1717922 | 2021-09-14 | McHenry | North Dakota | 38049 | 724 | 23 |
1714674 | 1714674 | 2021-09-13 | McHenry | North Dakota | 38049 | 721 | 23 |
1711428 | 1711428 | 2021-09-12 | McHenry | North Dakota | 38049 | 721 | 23 |
1708181 | 1708181 | 2021-09-11 | McHenry | North Dakota | 38049 | 721 | 23 |
1704934 | 1704934 | 2021-09-10 | McHenry | North Dakota | 38049 | 719 | 23 |
1701684 | 1701684 | 2021-09-09 | McHenry | North Dakota | 38049 | 714 | 23 |
1698435 | 1698435 | 2021-09-08 | McHenry | North Dakota | 38049 | 710 | 23 |
1695187 | 1695187 | 2021-09-07 | McHenry | North Dakota | 38049 | 709 | 23 |
1691939 | 1691939 | 2021-09-06 | McHenry | North Dakota | 38049 | 709 | 23 |
1688689 | 1688689 | 2021-09-05 | McHenry | North Dakota | 38049 | 708 | 23 |
1685439 | 1685439 | 2021-09-04 | McHenry | North Dakota | 38049 | 706 | 23 |
1682188 | 1682188 | 2021-09-03 | McHenry | North Dakota | 38049 | 705 | 23 |
1678939 | 1678939 | 2021-09-02 | McHenry | North Dakota | 38049 | 699 | 23 |
1675691 | 1675691 | 2021-09-01 | McHenry | North Dakota | 38049 | 698 | 23 |
1672444 | 1672444 | 2021-08-31 | McHenry | North Dakota | 38049 | 695 | 23 |
1669196 | 1669196 | 2021-08-30 | McHenry | North Dakota | 38049 | 695 | 23 |
1665949 | 1665949 | 2021-08-29 | McHenry | North Dakota | 38049 | 695 | 23 |
1662701 | 1662701 | 2021-08-28 | McHenry | North Dakota | 38049 | 692 | 23 |
1659453 | 1659453 | 2021-08-27 | McHenry | North Dakota | 38049 | 691 | 23 |
1656204 | 1656204 | 2021-08-26 | McHenry | North Dakota | 38049 | 689 | 23 |
1652957 | 1652957 | 2021-08-25 | McHenry | North Dakota | 38049 | 689 | 23 |
1649709 | 1649709 | 2021-08-24 | McHenry | North Dakota | 38049 | 685 | 23 |
1646460 | 1646460 | 2021-08-23 | McHenry | North Dakota | 38049 | 684 | 23 |
1643211 | 1643211 | 2021-08-22 | McHenry | North Dakota | 38049 | 684 | 23 |
1639961 | 1639961 | 2021-08-21 | McHenry | North Dakota | 38049 | 684 | 23 |
1636711 | 1636711 | 2021-08-20 | McHenry | North Dakota | 38049 | 682 | 23 |
1633461 | 1633461 | 2021-08-19 | McHenry | North Dakota | 38049 | 678 | 23 |
1630214 | 1630214 | 2021-08-18 | McHenry | North Dakota | 38049 | 677 | 23 |
1626967 | 1626967 | 2021-08-17 | McHenry | North Dakota | 38049 | 675 | 23 |
1623720 | 1623720 | 2021-08-16 | McHenry | North Dakota | 38049 | 675 | 23 |
1620473 | 1620473 | 2021-08-15 | McHenry | North Dakota | 38049 | 675 | 23 |
1617225 | 1617225 | 2021-08-14 | McHenry | North Dakota | 38049 | 674 | 23 |
1613977 | 1613977 | 2021-08-13 | McHenry | North Dakota | 38049 | 674 | 23 |
1610728 | 1610728 | 2021-08-12 | McHenry | North Dakota | 38049 | 674 | 23 |
1607480 | 1607480 | 2021-08-11 | McHenry | North Dakota | 38049 | 675 | 23 |
1604231 | 1604231 | 2021-08-10 | McHenry | North Dakota | 38049 | 672 | 23 |
1600982 | 1600982 | 2021-08-09 | McHenry | North Dakota | 38049 | 672 | 23 |
1597734 | 1597734 | 2021-08-08 | McHenry | North Dakota | 38049 | 672 | 23 |
1594485 | 1594485 | 2021-08-07 | McHenry | North Dakota | 38049 | 672 | 23 |
1591236 | 1591236 | 2021-08-06 | McHenry | North Dakota | 38049 | 672 | 23 |
1587987 | 1587987 | 2021-08-05 | McHenry | North Dakota | 38049 | 672 | 23 |
1584737 | 1584737 | 2021-08-04 | McHenry | North Dakota | 38049 | 671 | 23 |
1581487 | 1581487 | 2021-08-03 | McHenry | North Dakota | 38049 | 669 | 23 |
1578238 | 1578238 | 2021-08-02 | McHenry | North Dakota | 38049 | 669 | 23 |
1574990 | 1574990 | 2021-08-01 | McHenry | North Dakota | 38049 | 669 | 23 |
1571742 | 1571742 | 2021-07-31 | McHenry | North Dakota | 38049 | 669 | 23 |
1568494 | 1568494 | 2021-07-30 | McHenry | North Dakota | 38049 | 669 | 23 |
1565246 | 1565246 | 2021-07-29 | McHenry | North Dakota | 38049 | 669 | 23 |
1561998 | 1561998 | 2021-07-28 | McHenry | North Dakota | 38049 | 666 | 23 |
1558750 | 1558750 | 2021-07-27 | McHenry | North Dakota | 38049 | 666 | 23 |
1555503 | 1555503 | 2021-07-26 | McHenry | North Dakota | 38049 | 666 | 23 |
1552256 | 1552256 | 2021-07-25 | McHenry | North Dakota | 38049 | 664 | 23 |
1549009 | 1549009 | 2021-07-24 | McHenry | North Dakota | 38049 | 664 | 23 |
1545762 | 1545762 | 2021-07-23 | McHenry | North Dakota | 38049 | 664 | 23 |
1542515 | 1542515 | 2021-07-22 | McHenry | North Dakota | 38049 | 663 | 23 |
1539267 | 1539267 | 2021-07-21 | McHenry | North Dakota | 38049 | 662 | 23 |
1536020 | 1536020 | 2021-07-20 | McHenry | North Dakota | 38049 | 662 | 23 |
1532772 | 1532772 | 2021-07-19 | McHenry | North Dakota | 38049 | 662 | 23 |
1529525 | 1529525 | 2021-07-18 | McHenry | North Dakota | 38049 | 662 | 23 |
1526278 | 1526278 | 2021-07-17 | McHenry | North Dakota | 38049 | 662 | 23 |
1523031 | 1523031 | 2021-07-16 | McHenry | North Dakota | 38049 | 662 | 23 |
1519783 | 1519783 | 2021-07-15 | McHenry | North Dakota | 38049 | 662 | 23 |
1516535 | 1516535 | 2021-07-14 | McHenry | North Dakota | 38049 | 662 | 23 |
1513288 | 1513288 | 2021-07-13 | McHenry | North Dakota | 38049 | 661 | 23 |
1510042 | 1510042 | 2021-07-12 | McHenry | North Dakota | 38049 | 661 | 23 |
1506795 | 1506795 | 2021-07-11 | McHenry | North Dakota | 38049 | 661 | 23 |
1503549 | 1503549 | 2021-07-10 | McHenry | North Dakota | 38049 | 659 | 23 |
1500303 | 1500303 | 2021-07-09 | McHenry | North Dakota | 38049 | 659 | 23 |
1497057 | 1497057 | 2021-07-08 | McHenry | North Dakota | 38049 | 659 | 23 |
1493810 | 1493810 | 2021-07-07 | McHenry | North Dakota | 38049 | 659 | 23 |
1490563 | 1490563 | 2021-07-06 | McHenry | North Dakota | 38049 | 658 | 23 |
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);