ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "McHenry" 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 |
---|---|---|---|---|---|---|---|
1948626 | 1948626 | 2021-11-24 | McHenry | North Dakota | 38049 | 999 | 27 |
1945375 | 1945375 | 2021-11-23 | McHenry | North Dakota | 38049 | 996 | 26 |
1942124 | 1942124 | 2021-11-22 | McHenry | North Dakota | 38049 | 992 | 26 |
1938874 | 1938874 | 2021-11-21 | McHenry | North Dakota | 38049 | 992 | 26 |
1935624 | 1935624 | 2021-11-20 | McHenry | North Dakota | 38049 | 991 | 26 |
1932374 | 1932374 | 2021-11-19 | McHenry | North Dakota | 38049 | 991 | 26 |
1929123 | 1929123 | 2021-11-18 | McHenry | North Dakota | 38049 | 990 | 25 |
1925873 | 1925873 | 2021-11-17 | McHenry | North Dakota | 38049 | 988 | 24 |
1922624 | 1922624 | 2021-11-16 | McHenry | North Dakota | 38049 | 985 | 24 |
1919374 | 1919374 | 2021-11-15 | McHenry | North Dakota | 38049 | 981 | 24 |
1916124 | 1916124 | 2021-11-14 | McHenry | North Dakota | 38049 | 981 | 24 |
1912874 | 1912874 | 2021-11-13 | McHenry | North Dakota | 38049 | 979 | 24 |
1909624 | 1909624 | 2021-11-12 | McHenry | North Dakota | 38049 | 974 | 23 |
1906375 | 1906375 | 2021-11-11 | McHenry | North Dakota | 38049 | 971 | 23 |
1903126 | 1903126 | 2021-11-10 | McHenry | North Dakota | 38049 | 964 | 23 |
1899876 | 1899876 | 2021-11-09 | McHenry | North Dakota | 38049 | 959 | 23 |
1896626 | 1896626 | 2021-11-08 | McHenry | North Dakota | 38049 | 952 | 23 |
1893376 | 1893376 | 2021-11-07 | McHenry | North Dakota | 38049 | 951 | 23 |
1890126 | 1890126 | 2021-11-06 | McHenry | North Dakota | 38049 | 950 | 23 |
1886876 | 1886876 | 2021-11-05 | McHenry | North Dakota | 38049 | 941 | 23 |
1883627 | 1883627 | 2021-11-04 | McHenry | North Dakota | 38049 | 939 | 23 |
1880378 | 1880378 | 2021-11-03 | McHenry | North Dakota | 38049 | 932 | 23 |
1877129 | 1877129 | 2021-11-02 | McHenry | North Dakota | 38049 | 925 | 23 |
1873880 | 1873880 | 2021-11-01 | McHenry | North Dakota | 38049 | 919 | 23 |
1870631 | 1870631 | 2021-10-31 | McHenry | North Dakota | 38049 | 917 | 23 |
1867382 | 1867382 | 2021-10-30 | McHenry | North Dakota | 38049 | 915 | 23 |
1864133 | 1864133 | 2021-10-29 | McHenry | North Dakota | 38049 | 914 | 23 |
1860884 | 1860884 | 2021-10-28 | McHenry | North Dakota | 38049 | 912 | 23 |
1857635 | 1857635 | 2021-10-27 | McHenry | North Dakota | 38049 | 906 | 23 |
1854386 | 1854386 | 2021-10-26 | McHenry | North Dakota | 38049 | 901 | 23 |
1851137 | 1851137 | 2021-10-25 | McHenry | North Dakota | 38049 | 889 | 23 |
1847887 | 1847887 | 2021-10-24 | McHenry | North Dakota | 38049 | 885 | 23 |
1844637 | 1844637 | 2021-10-23 | McHenry | North Dakota | 38049 | 875 | 23 |
1841387 | 1841387 | 2021-10-22 | McHenry | North Dakota | 38049 | 871 | 23 |
1838138 | 1838138 | 2021-10-21 | McHenry | North Dakota | 38049 | 866 | 23 |
1834889 | 1834889 | 2021-10-20 | McHenry | North Dakota | 38049 | 860 | 23 |
1831640 | 1831640 | 2021-10-19 | McHenry | North Dakota | 38049 | 857 | 23 |
1828391 | 1828391 | 2021-10-18 | McHenry | North Dakota | 38049 | 847 | 23 |
1825142 | 1825142 | 2021-10-17 | McHenry | North Dakota | 38049 | 846 | 23 |
1821893 | 1821893 | 2021-10-16 | McHenry | North Dakota | 38049 | 842 | 23 |
1818644 | 1818644 | 2021-10-15 | McHenry | North Dakota | 38049 | 840 | 23 |
1815395 | 1815395 | 2021-10-14 | McHenry | North Dakota | 38049 | 831 | 23 |
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 |
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);