ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
307 rows where deaths = 22 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2309534 | 2309534 | 2022-03-15 | Benson | North Dakota | 38005 | 1963 | 22 |
2306281 | 2306281 | 2022-03-14 | Benson | North Dakota | 38005 | 1963 | 22 |
2303030 | 2303030 | 2022-03-13 | Benson | North Dakota | 38005 | 1963 | 22 |
2299778 | 2299778 | 2022-03-12 | Benson | North Dakota | 38005 | 1963 | 22 |
2296526 | 2296526 | 2022-03-11 | Benson | North Dakota | 38005 | 1963 | 22 |
2293274 | 2293274 | 2022-03-10 | Benson | North Dakota | 38005 | 1958 | 22 |
2290022 | 2290022 | 2022-03-09 | Benson | North Dakota | 38005 | 1958 | 22 |
2286770 | 2286770 | 2022-03-08 | Benson | North Dakota | 38005 | 1958 | 22 |
2283518 | 2283518 | 2022-03-07 | Benson | North Dakota | 38005 | 1958 | 22 |
2280266 | 2280266 | 2022-03-06 | Benson | North Dakota | 38005 | 1958 | 22 |
2277013 | 2277013 | 2022-03-05 | Benson | North Dakota | 38005 | 1957 | 22 |
2273760 | 2273760 | 2022-03-04 | Benson | North Dakota | 38005 | 1958 | 22 |
2273773 | 2273773 | 2022-03-04 | Foster | North Dakota | 38031 | 977 | 22 |
2270507 | 2270507 | 2022-03-03 | Benson | North Dakota | 38005 | 1958 | 22 |
2270520 | 2270520 | 2022-03-03 | Foster | North Dakota | 38031 | 977 | 22 |
2267255 | 2267255 | 2022-03-02 | Benson | North Dakota | 38005 | 1957 | 22 |
2267268 | 2267268 | 2022-03-02 | Foster | North Dakota | 38031 | 976 | 22 |
2264003 | 2264003 | 2022-03-01 | Benson | North Dakota | 38005 | 1955 | 22 |
2264016 | 2264016 | 2022-03-01 | Foster | North Dakota | 38031 | 976 | 22 |
2264039 | 2264039 | 2022-03-01 | Richland | North Dakota | 38077 | 4014 | 22 |
2260752 | 2260752 | 2022-02-28 | Benson | North Dakota | 38005 | 1954 | 22 |
2260765 | 2260765 | 2022-02-28 | Foster | North Dakota | 38031 | 978 | 22 |
2260788 | 2260788 | 2022-02-28 | Richland | North Dakota | 38077 | 4014 | 22 |
2257501 | 2257501 | 2022-02-27 | Benson | North Dakota | 38005 | 1954 | 22 |
2257514 | 2257514 | 2022-02-27 | Foster | North Dakota | 38031 | 978 | 22 |
2257537 | 2257537 | 2022-02-27 | Richland | North Dakota | 38077 | 4013 | 22 |
2254250 | 2254250 | 2022-02-26 | Benson | North Dakota | 38005 | 1953 | 22 |
2254263 | 2254263 | 2022-02-26 | Foster | North Dakota | 38031 | 978 | 22 |
2254286 | 2254286 | 2022-02-26 | Richland | North Dakota | 38077 | 4013 | 22 |
2250999 | 2250999 | 2022-02-25 | Benson | North Dakota | 38005 | 1953 | 22 |
2251012 | 2251012 | 2022-02-25 | Foster | North Dakota | 38031 | 978 | 22 |
2247748 | 2247748 | 2022-02-24 | Benson | North Dakota | 38005 | 1950 | 22 |
2247761 | 2247761 | 2022-02-24 | Foster | North Dakota | 38031 | 978 | 22 |
2244497 | 2244497 | 2022-02-23 | Benson | North Dakota | 38005 | 1944 | 22 |
2244510 | 2244510 | 2022-02-23 | Foster | North Dakota | 38031 | 976 | 22 |
2241246 | 2241246 | 2022-02-22 | Benson | North Dakota | 38005 | 1942 | 22 |
2237995 | 2237995 | 2022-02-21 | Benson | North Dakota | 38005 | 1938 | 22 |
2234744 | 2234744 | 2022-02-20 | Benson | North Dakota | 38005 | 1938 | 22 |
2231493 | 2231493 | 2022-02-19 | Benson | North Dakota | 38005 | 1937 | 22 |
2228242 | 2228242 | 2022-02-18 | Benson | North Dakota | 38005 | 1935 | 22 |
2224991 | 2224991 | 2022-02-17 | Benson | North Dakota | 38005 | 1929 | 22 |
2221740 | 2221740 | 2022-02-16 | Benson | North Dakota | 38005 | 1917 | 22 |
2218489 | 2218489 | 2022-02-15 | Benson | North Dakota | 38005 | 1913 | 22 |
2215238 | 2215238 | 2022-02-14 | Benson | North Dakota | 38005 | 1906 | 22 |
2211987 | 2211987 | 2022-02-13 | Benson | North Dakota | 38005 | 1902 | 22 |
2208734 | 2208734 | 2022-02-12 | Benson | North Dakota | 38005 | 1901 | 22 |
2205481 | 2205481 | 2022-02-11 | Benson | North Dakota | 38005 | 1893 | 22 |
2202228 | 2202228 | 2022-02-10 | Benson | North Dakota | 38005 | 1884 | 22 |
2198974 | 2198974 | 2022-02-09 | Benson | North Dakota | 38005 | 1876 | 22 |
2195720 | 2195720 | 2022-02-08 | Benson | North Dakota | 38005 | 1855 | 22 |
2192466 | 2192466 | 2022-02-07 | Benson | North Dakota | 38005 | 1843 | 22 |
2192512 | 2192512 | 2022-02-07 | Traill | North Dakota | 38097 | 2071 | 22 |
2189212 | 2189212 | 2022-02-06 | Benson | North Dakota | 38005 | 1835 | 22 |
2189258 | 2189258 | 2022-02-06 | Traill | North Dakota | 38097 | 2067 | 22 |
2185959 | 2185959 | 2022-02-05 | Benson | North Dakota | 38005 | 1835 | 22 |
2186005 | 2186005 | 2022-02-05 | Traill | North Dakota | 38097 | 2067 | 22 |
2182707 | 2182707 | 2022-02-04 | Benson | North Dakota | 38005 | 1823 | 22 |
2182753 | 2182753 | 2022-02-04 | Traill | North Dakota | 38097 | 2063 | 22 |
2179455 | 2179455 | 2022-02-03 | Benson | North Dakota | 38005 | 1809 | 22 |
2179501 | 2179501 | 2022-02-03 | Traill | North Dakota | 38097 | 2062 | 22 |
2176204 | 2176204 | 2022-02-02 | Benson | North Dakota | 38005 | 1797 | 22 |
2176250 | 2176250 | 2022-02-02 | Traill | North Dakota | 38097 | 2056 | 22 |
2172951 | 2172951 | 2022-02-01 | Benson | North Dakota | 38005 | 1791 | 22 |
2172997 | 2172997 | 2022-02-01 | Traill | North Dakota | 38097 | 2056 | 22 |
2169698 | 2169698 | 2022-01-31 | Benson | North Dakota | 38005 | 1776 | 22 |
2169744 | 2169744 | 2022-01-31 | Traill | North Dakota | 38097 | 2044 | 22 |
2166443 | 2166443 | 2022-01-30 | Benson | North Dakota | 38005 | 1776 | 22 |
2166489 | 2166489 | 2022-01-30 | Traill | North Dakota | 38097 | 2044 | 22 |
2163188 | 2163188 | 2022-01-29 | Benson | North Dakota | 38005 | 1772 | 22 |
2163234 | 2163234 | 2022-01-29 | Traill | North Dakota | 38097 | 2039 | 22 |
2159933 | 2159933 | 2022-01-28 | Benson | North Dakota | 38005 | 1752 | 22 |
2159979 | 2159979 | 2022-01-28 | Traill | North Dakota | 38097 | 2027 | 22 |
2156678 | 2156678 | 2022-01-27 | Benson | North Dakota | 38005 | 1728 | 22 |
2156724 | 2156724 | 2022-01-27 | Traill | North Dakota | 38097 | 2009 | 22 |
2153425 | 2153425 | 2022-01-26 | Benson | North Dakota | 38005 | 1714 | 22 |
2153471 | 2153471 | 2022-01-26 | Traill | North Dakota | 38097 | 1990 | 22 |
2150173 | 2150173 | 2022-01-25 | Benson | North Dakota | 38005 | 1688 | 22 |
2150199 | 2150199 | 2022-01-25 | Mercer | North Dakota | 38057 | 2310 | 22 |
2150219 | 2150219 | 2022-01-25 | Traill | North Dakota | 38097 | 1978 | 22 |
2146921 | 2146921 | 2022-01-24 | Benson | North Dakota | 38005 | 1667 | 22 |
2146947 | 2146947 | 2022-01-24 | Mercer | North Dakota | 38057 | 2275 | 22 |
2143667 | 2143667 | 2022-01-23 | Benson | North Dakota | 38005 | 1667 | 22 |
2143693 | 2143693 | 2022-01-23 | Mercer | North Dakota | 38057 | 2275 | 22 |
2140412 | 2140412 | 2022-01-22 | Benson | North Dakota | 38005 | 1661 | 22 |
2140438 | 2140438 | 2022-01-22 | Mercer | North Dakota | 38057 | 2272 | 22 |
2137156 | 2137156 | 2022-01-21 | Benson | North Dakota | 38005 | 1651 | 22 |
2137182 | 2137182 | 2022-01-21 | Mercer | North Dakota | 38057 | 2251 | 22 |
2133903 | 2133903 | 2022-01-20 | Benson | North Dakota | 38005 | 1634 | 22 |
2133929 | 2133929 | 2022-01-20 | Mercer | North Dakota | 38057 | 2228 | 22 |
2130651 | 2130651 | 2022-01-19 | Benson | North Dakota | 38005 | 1617 | 22 |
2130677 | 2130677 | 2022-01-19 | Mercer | North Dakota | 38057 | 2192 | 22 |
2127397 | 2127397 | 2022-01-18 | Benson | North Dakota | 38005 | 1597 | 22 |
2127423 | 2127423 | 2022-01-18 | Mercer | North Dakota | 38057 | 2154 | 22 |
2124145 | 2124145 | 2022-01-17 | Benson | North Dakota | 38005 | 1582 | 22 |
2124171 | 2124171 | 2022-01-17 | Mercer | North Dakota | 38057 | 2125 | 22 |
2120893 | 2120893 | 2022-01-16 | Benson | North Dakota | 38005 | 1582 | 22 |
2120919 | 2120919 | 2022-01-16 | Mercer | North Dakota | 38057 | 2120 | 22 |
2117641 | 2117641 | 2022-01-15 | Benson | North Dakota | 38005 | 1580 | 22 |
2117667 | 2117667 | 2022-01-15 | Mercer | North Dakota | 38057 | 2117 | 22 |
2114390 | 2114390 | 2022-01-14 | Benson | North Dakota | 38005 | 1571 | 22 |
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);