ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Morton" 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 |
---|---|---|---|---|---|---|---|
2176231 | 2176231 | 2022-02-02 | Morton | North Dakota | 38059 | 10625 | 138 |
2172978 | 2172978 | 2022-02-01 | Morton | North Dakota | 38059 | 10565 | 137 |
2169725 | 2169725 | 2022-01-31 | Morton | North Dakota | 38059 | 10510 | 137 |
2166470 | 2166470 | 2022-01-30 | Morton | North Dakota | 38059 | 10492 | 137 |
2163215 | 2163215 | 2022-01-29 | Morton | North Dakota | 38059 | 10460 | 137 |
2159960 | 2159960 | 2022-01-28 | Morton | North Dakota | 38059 | 10394 | 137 |
2156705 | 2156705 | 2022-01-27 | Morton | North Dakota | 38059 | 10307 | 136 |
2153452 | 2153452 | 2022-01-26 | Morton | North Dakota | 38059 | 10232 | 136 |
2150200 | 2150200 | 2022-01-25 | Morton | North Dakota | 38059 | 10148 | 136 |
2146948 | 2146948 | 2022-01-24 | Morton | North Dakota | 38059 | 10019 | 136 |
2143694 | 2143694 | 2022-01-23 | Morton | North Dakota | 38059 | 10019 | 136 |
2140439 | 2140439 | 2022-01-22 | Morton | North Dakota | 38059 | 10009 | 136 |
2137183 | 2137183 | 2022-01-21 | Morton | North Dakota | 38059 | 9946 | 136 |
2133930 | 2133930 | 2022-01-20 | Morton | North Dakota | 38059 | 9793 | 136 |
2130678 | 2130678 | 2022-01-19 | Morton | North Dakota | 38059 | 9690 | 135 |
2127424 | 2127424 | 2022-01-18 | Morton | North Dakota | 38059 | 9567 | 134 |
2124172 | 2124172 | 2022-01-17 | Morton | North Dakota | 38059 | 9482 | 134 |
2120920 | 2120920 | 2022-01-16 | Morton | North Dakota | 38059 | 9445 | 134 |
2117668 | 2117668 | 2022-01-15 | Morton | North Dakota | 38059 | 9385 | 134 |
2114417 | 2114417 | 2022-01-14 | Morton | North Dakota | 38059 | 9302 | 134 |
2111165 | 2111165 | 2022-01-13 | Morton | North Dakota | 38059 | 9207 | 133 |
2107913 | 2107913 | 2022-01-12 | Morton | North Dakota | 38059 | 9103 | 133 |
2104662 | 2104662 | 2022-01-11 | Morton | North Dakota | 38059 | 8990 | 132 |
2101411 | 2101411 | 2022-01-10 | Morton | North Dakota | 38059 | 8952 | 131 |
2098160 | 2098160 | 2022-01-09 | Morton | North Dakota | 38059 | 8914 | 131 |
2094908 | 2094908 | 2022-01-08 | Morton | North Dakota | 38059 | 8863 | 131 |
2091656 | 2091656 | 2022-01-07 | Morton | North Dakota | 38059 | 8841 | 131 |
2088405 | 2088405 | 2022-01-06 | Morton | North Dakota | 38059 | 8788 | 131 |
2085153 | 2085153 | 2022-01-05 | Morton | North Dakota | 38059 | 8744 | 131 |
2081901 | 2081901 | 2022-01-04 | Morton | North Dakota | 38059 | 8688 | 131 |
2078649 | 2078649 | 2022-01-03 | Morton | North Dakota | 38059 | 8622 | 131 |
2075398 | 2075398 | 2022-01-02 | Morton | North Dakota | 38059 | 8594 | 131 |
2072147 | 2072147 | 2022-01-01 | Morton | North Dakota | 38059 | 8589 | 131 |
2068896 | 2068896 | 2021-12-31 | Morton | North Dakota | 38059 | 8566 | 131 |
2065645 | 2065645 | 2021-12-30 | Morton | North Dakota | 38059 | 8536 | 131 |
2062395 | 2062395 | 2021-12-29 | Morton | North Dakota | 38059 | 8498 | 131 |
2059146 | 2059146 | 2021-12-28 | Morton | North Dakota | 38059 | 8467 | 131 |
2055897 | 2055897 | 2021-12-27 | Morton | North Dakota | 38059 | 8438 | 130 |
2052647 | 2052647 | 2021-12-26 | Morton | North Dakota | 38059 | 8429 | 130 |
2049397 | 2049397 | 2021-12-25 | Morton | North Dakota | 38059 | 8427 | 130 |
2046147 | 2046147 | 2021-12-24 | Morton | North Dakota | 38059 | 8420 | 130 |
2042897 | 2042897 | 2021-12-23 | Morton | North Dakota | 38059 | 8397 | 129 |
2039648 | 2039648 | 2021-12-22 | Morton | North Dakota | 38059 | 8377 | 129 |
2036398 | 2036398 | 2021-12-21 | Morton | North Dakota | 38059 | 8355 | 128 |
2033148 | 2033148 | 2021-12-20 | Morton | North Dakota | 38059 | 8341 | 127 |
2029898 | 2029898 | 2021-12-19 | Morton | North Dakota | 38059 | 8335 | 127 |
2026647 | 2026647 | 2021-12-18 | Morton | North Dakota | 38059 | 8323 | 127 |
2023396 | 2023396 | 2021-12-17 | Morton | North Dakota | 38059 | 8319 | 127 |
2020145 | 2020145 | 2021-12-16 | Morton | North Dakota | 38059 | 8309 | 127 |
2016894 | 2016894 | 2021-12-15 | Morton | North Dakota | 38059 | 8306 | 127 |
2013644 | 2013644 | 2021-12-14 | Morton | North Dakota | 38059 | 8297 | 127 |
2010393 | 2010393 | 2021-12-13 | Morton | North Dakota | 38059 | 8284 | 127 |
2007142 | 2007142 | 2021-12-12 | Morton | North Dakota | 38059 | 8273 | 127 |
2003891 | 2003891 | 2021-12-11 | Morton | North Dakota | 38059 | 8266 | 127 |
2000640 | 2000640 | 2021-12-10 | Morton | North Dakota | 38059 | 8248 | 127 |
1997390 | 1997390 | 2021-12-09 | Morton | North Dakota | 38059 | 8236 | 127 |
1994139 | 1994139 | 2021-12-08 | Morton | North Dakota | 38059 | 8216 | 126 |
1990888 | 1990888 | 2021-12-07 | Morton | North Dakota | 38059 | 8203 | 126 |
1987637 | 1987637 | 2021-12-06 | Morton | North Dakota | 38059 | 8179 | 126 |
1984387 | 1984387 | 2021-12-05 | Morton | North Dakota | 38059 | 8179 | 126 |
1981137 | 1981137 | 2021-12-04 | Morton | North Dakota | 38059 | 8174 | 126 |
1977887 | 1977887 | 2021-12-03 | Morton | North Dakota | 38059 | 8152 | 126 |
1974637 | 1974637 | 2021-12-02 | Morton | North Dakota | 38059 | 8148 | 126 |
1971388 | 1971388 | 2021-12-01 | Morton | North Dakota | 38059 | 8125 | 126 |
1968138 | 1968138 | 2021-11-30 | Morton | North Dakota | 38059 | 8098 | 126 |
1964887 | 1964887 | 2021-11-29 | Morton | North Dakota | 38059 | 8065 | 125 |
1961635 | 1961635 | 2021-11-28 | Morton | North Dakota | 38059 | 8053 | 125 |
1958384 | 1958384 | 2021-11-27 | Morton | North Dakota | 38059 | 8039 | 125 |
1955133 | 1955133 | 2021-11-26 | Morton | North Dakota | 38059 | 8027 | 125 |
1951882 | 1951882 | 2021-11-25 | Morton | North Dakota | 38059 | 8017 | 125 |
1948631 | 1948631 | 2021-11-24 | Morton | North Dakota | 38059 | 7981 | 124 |
1945380 | 1945380 | 2021-11-23 | Morton | North Dakota | 38059 | 7953 | 124 |
1942129 | 1942129 | 2021-11-22 | Morton | North Dakota | 38059 | 7931 | 124 |
1938879 | 1938879 | 2021-11-21 | Morton | North Dakota | 38059 | 7917 | 124 |
1935629 | 1935629 | 2021-11-20 | Morton | North Dakota | 38059 | 7910 | 124 |
1932379 | 1932379 | 2021-11-19 | Morton | North Dakota | 38059 | 7898 | 124 |
1929128 | 1929128 | 2021-11-18 | Morton | North Dakota | 38059 | 7881 | 123 |
1925878 | 1925878 | 2021-11-17 | Morton | North Dakota | 38059 | 7855 | 123 |
1922629 | 1922629 | 2021-11-16 | Morton | North Dakota | 38059 | 7830 | 122 |
1919379 | 1919379 | 2021-11-15 | Morton | North Dakota | 38059 | 7806 | 122 |
1916129 | 1916129 | 2021-11-14 | Morton | North Dakota | 38059 | 7795 | 122 |
1912879 | 1912879 | 2021-11-13 | Morton | North Dakota | 38059 | 7786 | 122 |
1909629 | 1909629 | 2021-11-12 | Morton | North Dakota | 38059 | 7772 | 120 |
1906380 | 1906380 | 2021-11-11 | Morton | North Dakota | 38059 | 7756 | 120 |
1903131 | 1903131 | 2021-11-10 | Morton | North Dakota | 38059 | 7728 | 120 |
1899881 | 1899881 | 2021-11-09 | Morton | North Dakota | 38059 | 7697 | 120 |
1896631 | 1896631 | 2021-11-08 | Morton | North Dakota | 38059 | 7664 | 119 |
1893381 | 1893381 | 2021-11-07 | Morton | North Dakota | 38059 | 7653 | 119 |
1890131 | 1890131 | 2021-11-06 | Morton | North Dakota | 38059 | 7640 | 119 |
1886881 | 1886881 | 2021-11-05 | Morton | North Dakota | 38059 | 7603 | 119 |
1883632 | 1883632 | 2021-11-04 | Morton | North Dakota | 38059 | 7580 | 119 |
1880383 | 1880383 | 2021-11-03 | Morton | North Dakota | 38059 | 7557 | 118 |
1877134 | 1877134 | 2021-11-02 | Morton | North Dakota | 38059 | 7523 | 117 |
1873885 | 1873885 | 2021-11-01 | Morton | North Dakota | 38059 | 7498 | 115 |
1870636 | 1870636 | 2021-10-31 | Morton | North Dakota | 38059 | 7488 | 115 |
1867387 | 1867387 | 2021-10-30 | Morton | North Dakota | 38059 | 7469 | 115 |
1864138 | 1864138 | 2021-10-29 | Morton | North Dakota | 38059 | 7452 | 115 |
1860889 | 1860889 | 2021-10-28 | Morton | North Dakota | 38059 | 7427 | 115 |
1857640 | 1857640 | 2021-10-27 | Morton | North Dakota | 38059 | 7391 | 115 |
1854391 | 1854391 | 2021-10-26 | Morton | North Dakota | 38059 | 7353 | 115 |
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);