ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where county = "Sargent" 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 |
---|---|---|---|---|---|---|---|
2111176 | 2111176 | 2022-01-13 | Sargent | North Dakota | 38081 | 826 | 9 |
2107924 | 2107924 | 2022-01-12 | Sargent | North Dakota | 38081 | 816 | 9 |
2104673 | 2104673 | 2022-01-11 | Sargent | North Dakota | 38081 | 811 | 9 |
2101422 | 2101422 | 2022-01-10 | Sargent | North Dakota | 38081 | 805 | 9 |
2098171 | 2098171 | 2022-01-09 | Sargent | North Dakota | 38081 | 805 | 9 |
2094919 | 2094919 | 2022-01-08 | Sargent | North Dakota | 38081 | 802 | 9 |
2091667 | 2091667 | 2022-01-07 | Sargent | North Dakota | 38081 | 801 | 9 |
2088416 | 2088416 | 2022-01-06 | Sargent | North Dakota | 38081 | 797 | 9 |
2085164 | 2085164 | 2022-01-05 | Sargent | North Dakota | 38081 | 792 | 9 |
2081912 | 2081912 | 2022-01-04 | Sargent | North Dakota | 38081 | 786 | 9 |
2078660 | 2078660 | 2022-01-03 | Sargent | North Dakota | 38081 | 784 | 9 |
2075409 | 2075409 | 2022-01-02 | Sargent | North Dakota | 38081 | 784 | 9 |
2072158 | 2072158 | 2022-01-01 | Sargent | North Dakota | 38081 | 784 | 9 |
2068907 | 2068907 | 2021-12-31 | Sargent | North Dakota | 38081 | 784 | 9 |
2065656 | 2065656 | 2021-12-30 | Sargent | North Dakota | 38081 | 781 | 9 |
2062406 | 2062406 | 2021-12-29 | Sargent | North Dakota | 38081 | 778 | 9 |
2059157 | 2059157 | 2021-12-28 | Sargent | North Dakota | 38081 | 772 | 9 |
2055908 | 2055908 | 2021-12-27 | Sargent | North Dakota | 38081 | 771 | 9 |
2052658 | 2052658 | 2021-12-26 | Sargent | North Dakota | 38081 | 771 | 9 |
2049408 | 2049408 | 2021-12-25 | Sargent | North Dakota | 38081 | 771 | 9 |
2046158 | 2046158 | 2021-12-24 | Sargent | North Dakota | 38081 | 771 | 9 |
2042908 | 2042908 | 2021-12-23 | Sargent | North Dakota | 38081 | 770 | 9 |
2039659 | 2039659 | 2021-12-22 | Sargent | North Dakota | 38081 | 771 | 9 |
2036409 | 2036409 | 2021-12-21 | Sargent | North Dakota | 38081 | 771 | 9 |
2033159 | 2033159 | 2021-12-20 | Sargent | North Dakota | 38081 | 768 | 9 |
2029909 | 2029909 | 2021-12-19 | Sargent | North Dakota | 38081 | 768 | 9 |
2026658 | 2026658 | 2021-12-18 | Sargent | North Dakota | 38081 | 766 | 9 |
2023407 | 2023407 | 2021-12-17 | Sargent | North Dakota | 38081 | 766 | 9 |
2020156 | 2020156 | 2021-12-16 | Sargent | North Dakota | 38081 | 764 | 9 |
2016905 | 2016905 | 2021-12-15 | Sargent | North Dakota | 38081 | 758 | 9 |
2013655 | 2013655 | 2021-12-14 | Sargent | North Dakota | 38081 | 755 | 9 |
2010404 | 2010404 | 2021-12-13 | Sargent | North Dakota | 38081 | 750 | 9 |
2007153 | 2007153 | 2021-12-12 | Sargent | North Dakota | 38081 | 750 | 9 |
2003902 | 2003902 | 2021-12-11 | Sargent | North Dakota | 38081 | 750 | 9 |
2000651 | 2000651 | 2021-12-10 | Sargent | North Dakota | 38081 | 746 | 9 |
1997401 | 1997401 | 2021-12-09 | Sargent | North Dakota | 38081 | 743 | 9 |
1994150 | 1994150 | 2021-12-08 | Sargent | North Dakota | 38081 | 742 | 9 |
1990899 | 1990899 | 2021-12-07 | Sargent | North Dakota | 38081 | 734 | 9 |
1987648 | 1987648 | 2021-12-06 | Sargent | North Dakota | 38081 | 724 | 9 |
1984398 | 1984398 | 2021-12-05 | Sargent | North Dakota | 38081 | 724 | 9 |
1981148 | 1981148 | 2021-12-04 | Sargent | North Dakota | 38081 | 724 | 9 |
1977898 | 1977898 | 2021-12-03 | Sargent | North Dakota | 38081 | 723 | 9 |
1974648 | 1974648 | 2021-12-02 | Sargent | North Dakota | 38081 | 718 | 9 |
1971399 | 1971399 | 2021-12-01 | Sargent | North Dakota | 38081 | 711 | 9 |
1968149 | 1968149 | 2021-11-30 | Sargent | North Dakota | 38081 | 703 | 9 |
1964898 | 1964898 | 2021-11-29 | Sargent | North Dakota | 38081 | 697 | 9 |
1961646 | 1961646 | 2021-11-28 | Sargent | North Dakota | 38081 | 697 | 9 |
1958395 | 1958395 | 2021-11-27 | Sargent | North Dakota | 38081 | 697 | 9 |
1955144 | 1955144 | 2021-11-26 | Sargent | North Dakota | 38081 | 694 | 9 |
1951893 | 1951893 | 2021-11-25 | Sargent | North Dakota | 38081 | 694 | 9 |
1948642 | 1948642 | 2021-11-24 | Sargent | North Dakota | 38081 | 689 | 9 |
1945391 | 1945391 | 2021-11-23 | Sargent | North Dakota | 38081 | 682 | 9 |
1942140 | 1942140 | 2021-11-22 | Sargent | North Dakota | 38081 | 676 | 8 |
1938890 | 1938890 | 2021-11-21 | Sargent | North Dakota | 38081 | 676 | 8 |
1935640 | 1935640 | 2021-11-20 | Sargent | North Dakota | 38081 | 676 | 8 |
1932390 | 1932390 | 2021-11-19 | Sargent | North Dakota | 38081 | 672 | 8 |
1929139 | 1929139 | 2021-11-18 | Sargent | North Dakota | 38081 | 670 | 8 |
1925889 | 1925889 | 2021-11-17 | Sargent | North Dakota | 38081 | 668 | 8 |
1922640 | 1922640 | 2021-11-16 | Sargent | North Dakota | 38081 | 665 | 8 |
1919390 | 1919390 | 2021-11-15 | Sargent | North Dakota | 38081 | 657 | 8 |
1916140 | 1916140 | 2021-11-14 | Sargent | North Dakota | 38081 | 656 | 8 |
1912890 | 1912890 | 2021-11-13 | Sargent | North Dakota | 38081 | 656 | 8 |
1909640 | 1909640 | 2021-11-12 | Sargent | North Dakota | 38081 | 655 | 8 |
1906391 | 1906391 | 2021-11-11 | Sargent | North Dakota | 38081 | 652 | 8 |
1903142 | 1903142 | 2021-11-10 | Sargent | North Dakota | 38081 | 651 | 8 |
1899892 | 1899892 | 2021-11-09 | Sargent | North Dakota | 38081 | 647 | 8 |
1896642 | 1896642 | 2021-11-08 | Sargent | North Dakota | 38081 | 638 | 8 |
1893392 | 1893392 | 2021-11-07 | Sargent | North Dakota | 38081 | 637 | 8 |
1890142 | 1890142 | 2021-11-06 | Sargent | North Dakota | 38081 | 637 | 8 |
1886892 | 1886892 | 2021-11-05 | Sargent | North Dakota | 38081 | 634 | 8 |
1883643 | 1883643 | 2021-11-04 | Sargent | North Dakota | 38081 | 627 | 8 |
1880394 | 1880394 | 2021-11-03 | Sargent | North Dakota | 38081 | 627 | 8 |
1877145 | 1877145 | 2021-11-02 | Sargent | North Dakota | 38081 | 624 | 8 |
1873896 | 1873896 | 2021-11-01 | Sargent | North Dakota | 38081 | 620 | 8 |
1870647 | 1870647 | 2021-10-31 | Sargent | North Dakota | 38081 | 619 | 8 |
1867398 | 1867398 | 2021-10-30 | Sargent | North Dakota | 38081 | 619 | 8 |
1864149 | 1864149 | 2021-10-29 | Sargent | North Dakota | 38081 | 618 | 8 |
1860900 | 1860900 | 2021-10-28 | Sargent | North Dakota | 38081 | 615 | 8 |
1857651 | 1857651 | 2021-10-27 | Sargent | North Dakota | 38081 | 612 | 8 |
1854402 | 1854402 | 2021-10-26 | Sargent | North Dakota | 38081 | 611 | 8 |
1851153 | 1851153 | 2021-10-25 | Sargent | North Dakota | 38081 | 607 | 8 |
1847903 | 1847903 | 2021-10-24 | Sargent | North Dakota | 38081 | 607 | 8 |
1844653 | 1844653 | 2021-10-23 | Sargent | North Dakota | 38081 | 607 | 8 |
1841403 | 1841403 | 2021-10-22 | Sargent | North Dakota | 38081 | 604 | 8 |
1838154 | 1838154 | 2021-10-21 | Sargent | North Dakota | 38081 | 601 | 7 |
1834905 | 1834905 | 2021-10-20 | Sargent | North Dakota | 38081 | 599 | 7 |
1831656 | 1831656 | 2021-10-19 | Sargent | North Dakota | 38081 | 597 | 7 |
1828407 | 1828407 | 2021-10-18 | Sargent | North Dakota | 38081 | 594 | 7 |
1825158 | 1825158 | 2021-10-17 | Sargent | North Dakota | 38081 | 594 | 7 |
1821909 | 1821909 | 2021-10-16 | Sargent | North Dakota | 38081 | 594 | 7 |
1818660 | 1818660 | 2021-10-15 | Sargent | North Dakota | 38081 | 588 | 7 |
1815411 | 1815411 | 2021-10-14 | Sargent | North Dakota | 38081 | 584 | 7 |
1812163 | 1812163 | 2021-10-13 | Sargent | North Dakota | 38081 | 579 | 7 |
1808914 | 1808914 | 2021-10-12 | Sargent | North Dakota | 38081 | 579 | 7 |
1805663 | 1805663 | 2021-10-11 | Sargent | North Dakota | 38081 | 575 | 7 |
1802414 | 1802414 | 2021-10-10 | Sargent | North Dakota | 38081 | 578 | 7 |
1799165 | 1799165 | 2021-10-09 | Sargent | North Dakota | 38081 | 577 | 7 |
1795916 | 1795916 | 2021-10-08 | Sargent | North Dakota | 38081 | 577 | 7 |
1792667 | 1792667 | 2021-10-07 | Sargent | North Dakota | 38081 | 570 | 7 |
1789418 | 1789418 | 2021-10-06 | Sargent | North Dakota | 38081 | 571 | 7 |
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);