ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Ward" 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 |
---|---|---|---|---|---|---|---|
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 |
1851164 | 1851164 | 2021-10-25 | Ward | North Dakota | 38101 | 12903 | 217 |
1847914 | 1847914 | 2021-10-24 | Ward | North Dakota | 38101 | 12889 | 217 |
1844664 | 1844664 | 2021-10-23 | Ward | North Dakota | 38101 | 12865 | 217 |
1841414 | 1841414 | 2021-10-22 | Ward | North Dakota | 38101 | 12830 | 216 |
1838165 | 1838165 | 2021-10-21 | Ward | North Dakota | 38101 | 12775 | 215 |
1834916 | 1834916 | 2021-10-20 | Ward | North Dakota | 38101 | 12737 | 215 |
1831667 | 1831667 | 2021-10-19 | Ward | North Dakota | 38101 | 12670 | 212 |
1828418 | 1828418 | 2021-10-18 | Ward | North Dakota | 38101 | 12601 | 212 |
1825169 | 1825169 | 2021-10-17 | Ward | North Dakota | 38101 | 12582 | 212 |
1821920 | 1821920 | 2021-10-16 | Ward | North Dakota | 38101 | 12566 | 212 |
1818671 | 1818671 | 2021-10-15 | Ward | North Dakota | 38101 | 12520 | 212 |
1815422 | 1815422 | 2021-10-14 | Ward | North Dakota | 38101 | 12472 | 212 |
1812174 | 1812174 | 2021-10-13 | Ward | North Dakota | 38101 | 12420 | 212 |
1808925 | 1808925 | 2021-10-12 | Ward | North Dakota | 38101 | 12359 | 212 |
1805674 | 1805674 | 2021-10-11 | Ward | North Dakota | 38101 | 12298 | 210 |
1802425 | 1802425 | 2021-10-10 | Ward | North Dakota | 38101 | 12274 | 210 |
1799176 | 1799176 | 2021-10-09 | Ward | North Dakota | 38101 | 12245 | 210 |
1795927 | 1795927 | 2021-10-08 | Ward | North Dakota | 38101 | 12178 | 210 |
1792678 | 1792678 | 2021-10-07 | Ward | North Dakota | 38101 | 12110 | 210 |
1789429 | 1789429 | 2021-10-06 | Ward | North Dakota | 38101 | 12048 | 209 |
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);