ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 38025 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 |
---|---|---|---|---|---|---|---|
2176214 | 2176214 | 2022-02-02 | Dunn | North Dakota | 38025 | 979 | 8 |
2172961 | 2172961 | 2022-02-01 | Dunn | North Dakota | 38025 | 976 | 8 |
2169708 | 2169708 | 2022-01-31 | Dunn | North Dakota | 38025 | 965 | 8 |
2166453 | 2166453 | 2022-01-30 | Dunn | North Dakota | 38025 | 962 | 8 |
2163198 | 2163198 | 2022-01-29 | Dunn | North Dakota | 38025 | 961 | 8 |
2159943 | 2159943 | 2022-01-28 | Dunn | North Dakota | 38025 | 958 | 8 |
2156688 | 2156688 | 2022-01-27 | Dunn | North Dakota | 38025 | 956 | 8 |
2153435 | 2153435 | 2022-01-26 | Dunn | North Dakota | 38025 | 950 | 8 |
2150183 | 2150183 | 2022-01-25 | Dunn | North Dakota | 38025 | 945 | 8 |
2146931 | 2146931 | 2022-01-24 | Dunn | North Dakota | 38025 | 938 | 8 |
2143677 | 2143677 | 2022-01-23 | Dunn | North Dakota | 38025 | 938 | 8 |
2140422 | 2140422 | 2022-01-22 | Dunn | North Dakota | 38025 | 938 | 8 |
2137166 | 2137166 | 2022-01-21 | Dunn | North Dakota | 38025 | 933 | 8 |
2133913 | 2133913 | 2022-01-20 | Dunn | North Dakota | 38025 | 927 | 8 |
2130661 | 2130661 | 2022-01-19 | Dunn | North Dakota | 38025 | 916 | 8 |
2127407 | 2127407 | 2022-01-18 | Dunn | North Dakota | 38025 | 911 | 8 |
2124155 | 2124155 | 2022-01-17 | Dunn | North Dakota | 38025 | 908 | 8 |
2120903 | 2120903 | 2022-01-16 | Dunn | North Dakota | 38025 | 907 | 8 |
2117651 | 2117651 | 2022-01-15 | Dunn | North Dakota | 38025 | 905 | 8 |
2114400 | 2114400 | 2022-01-14 | Dunn | North Dakota | 38025 | 895 | 8 |
2111148 | 2111148 | 2022-01-13 | Dunn | North Dakota | 38025 | 893 | 8 |
2107896 | 2107896 | 2022-01-12 | Dunn | North Dakota | 38025 | 887 | 8 |
2104645 | 2104645 | 2022-01-11 | Dunn | North Dakota | 38025 | 886 | 7 |
2101394 | 2101394 | 2022-01-10 | Dunn | North Dakota | 38025 | 883 | 7 |
2098143 | 2098143 | 2022-01-09 | Dunn | North Dakota | 38025 | 883 | 7 |
2094891 | 2094891 | 2022-01-08 | Dunn | North Dakota | 38025 | 883 | 7 |
2091639 | 2091639 | 2022-01-07 | Dunn | North Dakota | 38025 | 881 | 7 |
2088388 | 2088388 | 2022-01-06 | Dunn | North Dakota | 38025 | 878 | 7 |
2085136 | 2085136 | 2022-01-05 | Dunn | North Dakota | 38025 | 877 | 7 |
2081884 | 2081884 | 2022-01-04 | Dunn | North Dakota | 38025 | 875 | 7 |
2078632 | 2078632 | 2022-01-03 | Dunn | North Dakota | 38025 | 873 | 7 |
2075381 | 2075381 | 2022-01-02 | Dunn | North Dakota | 38025 | 872 | 7 |
2072130 | 2072130 | 2022-01-01 | Dunn | North Dakota | 38025 | 872 | 7 |
2068879 | 2068879 | 2021-12-31 | Dunn | North Dakota | 38025 | 872 | 7 |
2065628 | 2065628 | 2021-12-30 | Dunn | North Dakota | 38025 | 872 | 7 |
2062378 | 2062378 | 2021-12-29 | Dunn | North Dakota | 38025 | 870 | 7 |
2059129 | 2059129 | 2021-12-28 | Dunn | North Dakota | 38025 | 867 | 7 |
2055880 | 2055880 | 2021-12-27 | Dunn | North Dakota | 38025 | 865 | 7 |
2052630 | 2052630 | 2021-12-26 | Dunn | North Dakota | 38025 | 865 | 7 |
2049380 | 2049380 | 2021-12-25 | Dunn | North Dakota | 38025 | 863 | 7 |
2046130 | 2046130 | 2021-12-24 | Dunn | North Dakota | 38025 | 863 | 7 |
2042880 | 2042880 | 2021-12-23 | Dunn | North Dakota | 38025 | 859 | 7 |
2039631 | 2039631 | 2021-12-22 | Dunn | North Dakota | 38025 | 856 | 7 |
2036381 | 2036381 | 2021-12-21 | Dunn | North Dakota | 38025 | 854 | 7 |
2033131 | 2033131 | 2021-12-20 | Dunn | North Dakota | 38025 | 852 | 7 |
2029881 | 2029881 | 2021-12-19 | Dunn | North Dakota | 38025 | 851 | 7 |
2026630 | 2026630 | 2021-12-18 | Dunn | North Dakota | 38025 | 848 | 7 |
2023379 | 2023379 | 2021-12-17 | Dunn | North Dakota | 38025 | 848 | 7 |
2020128 | 2020128 | 2021-12-16 | Dunn | North Dakota | 38025 | 847 | 7 |
2016877 | 2016877 | 2021-12-15 | Dunn | North Dakota | 38025 | 845 | 7 |
2013627 | 2013627 | 2021-12-14 | Dunn | North Dakota | 38025 | 845 | 7 |
2010376 | 2010376 | 2021-12-13 | Dunn | North Dakota | 38025 | 845 | 7 |
2007125 | 2007125 | 2021-12-12 | Dunn | North Dakota | 38025 | 845 | 7 |
2003874 | 2003874 | 2021-12-11 | Dunn | North Dakota | 38025 | 842 | 7 |
2000623 | 2000623 | 2021-12-10 | Dunn | North Dakota | 38025 | 842 | 7 |
1997373 | 1997373 | 2021-12-09 | Dunn | North Dakota | 38025 | 839 | 7 |
1994122 | 1994122 | 2021-12-08 | Dunn | North Dakota | 38025 | 838 | 7 |
1990871 | 1990871 | 2021-12-07 | Dunn | North Dakota | 38025 | 834 | 7 |
1987620 | 1987620 | 2021-12-06 | Dunn | North Dakota | 38025 | 830 | 7 |
1984370 | 1984370 | 2021-12-05 | Dunn | North Dakota | 38025 | 829 | 7 |
1981120 | 1981120 | 2021-12-04 | Dunn | North Dakota | 38025 | 829 | 7 |
1977870 | 1977870 | 2021-12-03 | Dunn | North Dakota | 38025 | 825 | 7 |
1974620 | 1974620 | 2021-12-02 | Dunn | North Dakota | 38025 | 824 | 7 |
1971371 | 1971371 | 2021-12-01 | Dunn | North Dakota | 38025 | 821 | 7 |
1968121 | 1968121 | 2021-11-30 | Dunn | North Dakota | 38025 | 814 | 7 |
1964870 | 1964870 | 2021-11-29 | Dunn | North Dakota | 38025 | 808 | 7 |
1961618 | 1961618 | 2021-11-28 | Dunn | North Dakota | 38025 | 808 | 7 |
1958367 | 1958367 | 2021-11-27 | Dunn | North Dakota | 38025 | 806 | 7 |
1955116 | 1955116 | 2021-11-26 | Dunn | North Dakota | 38025 | 804 | 7 |
1951865 | 1951865 | 2021-11-25 | Dunn | North Dakota | 38025 | 804 | 7 |
1948614 | 1948614 | 2021-11-24 | Dunn | North Dakota | 38025 | 797 | 7 |
1945363 | 1945363 | 2021-11-23 | Dunn | North Dakota | 38025 | 796 | 7 |
1942112 | 1942112 | 2021-11-22 | Dunn | North Dakota | 38025 | 795 | 7 |
1938862 | 1938862 | 2021-11-21 | Dunn | North Dakota | 38025 | 795 | 7 |
1935612 | 1935612 | 2021-11-20 | Dunn | North Dakota | 38025 | 795 | 7 |
1932362 | 1932362 | 2021-11-19 | Dunn | North Dakota | 38025 | 790 | 7 |
1929111 | 1929111 | 2021-11-18 | Dunn | North Dakota | 38025 | 786 | 7 |
1925861 | 1925861 | 2021-11-17 | Dunn | North Dakota | 38025 | 781 | 7 |
1922612 | 1922612 | 2021-11-16 | Dunn | North Dakota | 38025 | 779 | 7 |
1919362 | 1919362 | 2021-11-15 | Dunn | North Dakota | 38025 | 778 | 7 |
1916112 | 1916112 | 2021-11-14 | Dunn | North Dakota | 38025 | 777 | 7 |
1912862 | 1912862 | 2021-11-13 | Dunn | North Dakota | 38025 | 777 | 7 |
1909612 | 1909612 | 2021-11-12 | Dunn | North Dakota | 38025 | 774 | 7 |
1906363 | 1906363 | 2021-11-11 | Dunn | North Dakota | 38025 | 774 | 7 |
1903114 | 1903114 | 2021-11-10 | Dunn | North Dakota | 38025 | 766 | 7 |
1899864 | 1899864 | 2021-11-09 | Dunn | North Dakota | 38025 | 764 | 7 |
1896614 | 1896614 | 2021-11-08 | Dunn | North Dakota | 38025 | 759 | 7 |
1893364 | 1893364 | 2021-11-07 | Dunn | North Dakota | 38025 | 759 | 7 |
1890114 | 1890114 | 2021-11-06 | Dunn | North Dakota | 38025 | 758 | 7 |
1886864 | 1886864 | 2021-11-05 | Dunn | North Dakota | 38025 | 755 | 7 |
1883615 | 1883615 | 2021-11-04 | Dunn | North Dakota | 38025 | 751 | 7 |
1880366 | 1880366 | 2021-11-03 | Dunn | North Dakota | 38025 | 748 | 7 |
1877117 | 1877117 | 2021-11-02 | Dunn | North Dakota | 38025 | 747 | 7 |
1873868 | 1873868 | 2021-11-01 | Dunn | North Dakota | 38025 | 742 | 7 |
1870619 | 1870619 | 2021-10-31 | Dunn | North Dakota | 38025 | 742 | 7 |
1867370 | 1867370 | 2021-10-30 | Dunn | North Dakota | 38025 | 742 | 7 |
1864121 | 1864121 | 2021-10-29 | Dunn | North Dakota | 38025 | 737 | 7 |
1860872 | 1860872 | 2021-10-28 | Dunn | North Dakota | 38025 | 736 | 7 |
1857623 | 1857623 | 2021-10-27 | Dunn | North Dakota | 38025 | 731 | 7 |
1854374 | 1854374 | 2021-10-26 | Dunn | North Dakota | 38025 | 722 | 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);