ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 38101 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 |
---|---|---|---|---|---|---|---|
2176253 | 2176253 | 2022-02-02 | Ward | North Dakota | 38101 | 19590 | 243 |
2173000 | 2173000 | 2022-02-01 | Ward | North Dakota | 38101 | 19500 | 240 |
2169747 | 2169747 | 2022-01-31 | Ward | North Dakota | 38101 | 19386 | 240 |
2166492 | 2166492 | 2022-01-30 | Ward | North Dakota | 38101 | 19361 | 240 |
2163237 | 2163237 | 2022-01-29 | Ward | North Dakota | 38101 | 19278 | 240 |
2159982 | 2159982 | 2022-01-28 | Ward | North Dakota | 38101 | 19130 | 240 |
2156727 | 2156727 | 2022-01-27 | Ward | North Dakota | 38101 | 18965 | 240 |
2153474 | 2153474 | 2022-01-26 | Ward | North Dakota | 38101 | 18656 | 238 |
2150222 | 2150222 | 2022-01-25 | Ward | North Dakota | 38101 | 18480 | 238 |
2146970 | 2146970 | 2022-01-24 | Ward | North Dakota | 38101 | 18250 | 238 |
2143716 | 2143716 | 2022-01-23 | Ward | North Dakota | 38101 | 18250 | 238 |
2140461 | 2140461 | 2022-01-22 | Ward | North Dakota | 38101 | 18140 | 238 |
2137205 | 2137205 | 2022-01-21 | Ward | North Dakota | 38101 | 17932 | 237 |
2133952 | 2133952 | 2022-01-20 | Ward | North Dakota | 38101 | 17664 | 237 |
2130700 | 2130700 | 2022-01-19 | Ward | North Dakota | 38101 | 17427 | 237 |
2127446 | 2127446 | 2022-01-18 | Ward | North Dakota | 38101 | 17180 | 235 |
2124194 | 2124194 | 2022-01-17 | Ward | North Dakota | 38101 | 16966 | 235 |
2120942 | 2120942 | 2022-01-16 | Ward | North Dakota | 38101 | 16888 | 235 |
2117690 | 2117690 | 2022-01-15 | Ward | North Dakota | 38101 | 16726 | 235 |
2114439 | 2114439 | 2022-01-14 | Ward | North Dakota | 38101 | 16478 | 235 |
2111187 | 2111187 | 2022-01-13 | Ward | North Dakota | 38101 | 16339 | 235 |
2107935 | 2107935 | 2022-01-12 | Ward | North Dakota | 38101 | 16167 | 235 |
2104684 | 2104684 | 2022-01-11 | Ward | North Dakota | 38101 | 15983 | 235 |
2101433 | 2101433 | 2022-01-10 | Ward | North Dakota | 38101 | 15919 | 235 |
2098182 | 2098182 | 2022-01-09 | Ward | North Dakota | 38101 | 15868 | 235 |
2094930 | 2094930 | 2022-01-08 | Ward | North Dakota | 38101 | 15788 | 235 |
2091678 | 2091678 | 2022-01-07 | Ward | North Dakota | 38101 | 15718 | 235 |
2088427 | 2088427 | 2022-01-06 | Ward | North Dakota | 38101 | 15610 | 235 |
2085175 | 2085175 | 2022-01-05 | Ward | North Dakota | 38101 | 15471 | 235 |
2081923 | 2081923 | 2022-01-04 | Ward | North Dakota | 38101 | 15371 | 235 |
2078671 | 2078671 | 2022-01-03 | Ward | North Dakota | 38101 | 15295 | 234 |
2075420 | 2075420 | 2022-01-02 | Ward | North Dakota | 38101 | 15269 | 234 |
2072169 | 2072169 | 2022-01-01 | Ward | North Dakota | 38101 | 15258 | 234 |
2068918 | 2068918 | 2021-12-31 | Ward | North Dakota | 38101 | 15233 | 234 |
2065667 | 2065667 | 2021-12-30 | Ward | North Dakota | 38101 | 15183 | 234 |
2062417 | 2062417 | 2021-12-29 | Ward | North Dakota | 38101 | 15123 | 234 |
2059168 | 2059168 | 2021-12-28 | Ward | North Dakota | 38101 | 15081 | 233 |
2055919 | 2055919 | 2021-12-27 | Ward | North Dakota | 38101 | 15058 | 233 |
2052669 | 2052669 | 2021-12-26 | Ward | North Dakota | 38101 | 15054 | 233 |
2049419 | 2049419 | 2021-12-25 | Ward | North Dakota | 38101 | 15048 | 233 |
2046169 | 2046169 | 2021-12-24 | Ward | North Dakota | 38101 | 15035 | 233 |
2042919 | 2042919 | 2021-12-23 | Ward | North Dakota | 38101 | 15005 | 233 |
2039670 | 2039670 | 2021-12-22 | Ward | North Dakota | 38101 | 14979 | 233 |
2036420 | 2036420 | 2021-12-21 | Ward | North Dakota | 38101 | 14954 | 233 |
2033170 | 2033170 | 2021-12-20 | Ward | North Dakota | 38101 | 14929 | 230 |
2029920 | 2029920 | 2021-12-19 | Ward | North Dakota | 38101 | 14921 | 230 |
2026669 | 2026669 | 2021-12-18 | Ward | North Dakota | 38101 | 14907 | 230 |
2023418 | 2023418 | 2021-12-17 | Ward | North Dakota | 38101 | 14900 | 230 |
2020167 | 2020167 | 2021-12-16 | Ward | North Dakota | 38101 | 14873 | 230 |
2016916 | 2016916 | 2021-12-15 | Ward | North Dakota | 38101 | 14838 | 230 |
2013666 | 2013666 | 2021-12-14 | Ward | North Dakota | 38101 | 14807 | 230 |
2010415 | 2010415 | 2021-12-13 | Ward | North Dakota | 38101 | 14782 | 230 |
2007164 | 2007164 | 2021-12-12 | Ward | North Dakota | 38101 | 14774 | 230 |
2003913 | 2003913 | 2021-12-11 | Ward | North Dakota | 38101 | 14762 | 230 |
2000662 | 2000662 | 2021-12-10 | Ward | North Dakota | 38101 | 14733 | 230 |
1997412 | 1997412 | 2021-12-09 | Ward | North Dakota | 38101 | 14718 | 230 |
1994161 | 1994161 | 2021-12-08 | Ward | North Dakota | 38101 | 14690 | 230 |
1990910 | 1990910 | 2021-12-07 | Ward | North Dakota | 38101 | 14655 | 230 |
1987659 | 1987659 | 2021-12-06 | Ward | North Dakota | 38101 | 14632 | 229 |
1984409 | 1984409 | 2021-12-05 | Ward | North Dakota | 38101 | 14620 | 229 |
1981159 | 1981159 | 2021-12-04 | Ward | North Dakota | 38101 | 14609 | 229 |
1977909 | 1977909 | 2021-12-03 | Ward | North Dakota | 38101 | 14579 | 229 |
1974659 | 1974659 | 2021-12-02 | Ward | North Dakota | 38101 | 14541 | 229 |
1971410 | 1971410 | 2021-12-01 | Ward | North Dakota | 38101 | 14499 | 228 |
1968160 | 1968160 | 2021-11-30 | Ward | North Dakota | 38101 | 14462 | 228 |
1964909 | 1964909 | 2021-11-29 | Ward | North Dakota | 38101 | 14408 | 225 |
1961657 | 1961657 | 2021-11-28 | Ward | North Dakota | 38101 | 14401 | 225 |
1958406 | 1958406 | 2021-11-27 | Ward | North Dakota | 38101 | 14371 | 225 |
1955155 | 1955155 | 2021-11-26 | Ward | North Dakota | 38101 | 14342 | 225 |
1951904 | 1951904 | 2021-11-25 | Ward | North Dakota | 38101 | 14320 | 225 |
1948653 | 1948653 | 2021-11-24 | Ward | North Dakota | 38101 | 14268 | 225 |
1945402 | 1945402 | 2021-11-23 | Ward | North Dakota | 38101 | 14218 | 225 |
1942151 | 1942151 | 2021-11-22 | Ward | North Dakota | 38101 | 14185 | 225 |
1938901 | 1938901 | 2021-11-21 | Ward | North Dakota | 38101 | 14169 | 225 |
1935651 | 1935651 | 2021-11-20 | Ward | North Dakota | 38101 | 14158 | 225 |
1932401 | 1932401 | 2021-11-19 | Ward | North Dakota | 38101 | 14113 | 225 |
1929150 | 1929150 | 2021-11-18 | Ward | North Dakota | 38101 | 14071 | 223 |
1925900 | 1925900 | 2021-11-17 | Ward | North Dakota | 38101 | 13957 | 221 |
1922651 | 1922651 | 2021-11-16 | Ward | North Dakota | 38101 | 13898 | 221 |
1919401 | 1919401 | 2021-11-15 | Ward | North Dakota | 38101 | 13828 | 220 |
1916151 | 1916151 | 2021-11-14 | Ward | North Dakota | 38101 | 13811 | 220 |
1912901 | 1912901 | 2021-11-13 | Ward | North Dakota | 38101 | 13788 | 220 |
1909651 | 1909651 | 2021-11-12 | Ward | North Dakota | 38101 | 13748 | 220 |
1906402 | 1906402 | 2021-11-11 | Ward | North Dakota | 38101 | 13732 | 220 |
1903153 | 1903153 | 2021-11-10 | Ward | North Dakota | 38101 | 13688 | 220 |
1899903 | 1899903 | 2021-11-09 | Ward | North Dakota | 38101 | 13628 | 220 |
1896653 | 1896653 | 2021-11-08 | Ward | North Dakota | 38101 | 13574 | 219 |
1893403 | 1893403 | 2021-11-07 | Ward | North Dakota | 38101 | 13549 | 219 |
1890153 | 1890153 | 2021-11-06 | Ward | North Dakota | 38101 | 13528 | 219 |
1886903 | 1886903 | 2021-11-05 | Ward | North Dakota | 38101 | 13459 | 219 |
1883654 | 1883654 | 2021-11-04 | Ward | North Dakota | 38101 | 13404 | 219 |
1880405 | 1880405 | 2021-11-03 | Ward | North Dakota | 38101 | 13342 | 219 |
1877156 | 1877156 | 2021-11-02 | Ward | North Dakota | 38101 | 13273 | 219 |
1873907 | 1873907 | 2021-11-01 | Ward | North Dakota | 38101 | 13217 | 218 |
1870658 | 1870658 | 2021-10-31 | Ward | North Dakota | 38101 | 13200 | 218 |
1867409 | 1867409 | 2021-10-30 | Ward | North Dakota | 38101 | 13165 | 218 |
1864160 | 1864160 | 2021-10-29 | Ward | North Dakota | 38101 | 13107 | 218 |
1860911 | 1860911 | 2021-10-28 | Ward | North Dakota | 38101 | 13063 | 218 |
1857662 | 1857662 | 2021-10-27 | Ward | North Dakota | 38101 | 13014 | 218 |
1854413 | 1854413 | 2021-10-26 | Ward | North Dakota | 38101 | 12952 | 217 |
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);