ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where fips = 38077 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 |
---|---|---|---|---|---|---|---|
1948640 | 1948640 | 2021-11-24 | Richland | North Dakota | 38077 | 2793 | 21 |
1945389 | 1945389 | 2021-11-23 | Richland | North Dakota | 38077 | 2783 | 21 |
1942138 | 1942138 | 2021-11-22 | Richland | North Dakota | 38077 | 2774 | 21 |
1938888 | 1938888 | 2021-11-21 | Richland | North Dakota | 38077 | 2770 | 21 |
1935638 | 1935638 | 2021-11-20 | Richland | North Dakota | 38077 | 2770 | 21 |
1932388 | 1932388 | 2021-11-19 | Richland | North Dakota | 38077 | 2765 | 21 |
1929137 | 1929137 | 2021-11-18 | Richland | North Dakota | 38077 | 2758 | 21 |
1925887 | 1925887 | 2021-11-17 | Richland | North Dakota | 38077 | 2750 | 21 |
1922638 | 1922638 | 2021-11-16 | Richland | North Dakota | 38077 | 2744 | 21 |
1919388 | 1919388 | 2021-11-15 | Richland | North Dakota | 38077 | 2735 | 21 |
1916138 | 1916138 | 2021-11-14 | Richland | North Dakota | 38077 | 2735 | 21 |
1912888 | 1912888 | 2021-11-13 | Richland | North Dakota | 38077 | 2734 | 21 |
1909638 | 1909638 | 2021-11-12 | Richland | North Dakota | 38077 | 2725 | 21 |
1906389 | 1906389 | 2021-11-11 | Richland | North Dakota | 38077 | 2717 | 21 |
1903140 | 1903140 | 2021-11-10 | Richland | North Dakota | 38077 | 2703 | 21 |
1899890 | 1899890 | 2021-11-09 | Richland | North Dakota | 38077 | 2688 | 21 |
1896640 | 1896640 | 2021-11-08 | Richland | North Dakota | 38077 | 2666 | 20 |
1893390 | 1893390 | 2021-11-07 | Richland | North Dakota | 38077 | 2666 | 20 |
1890140 | 1890140 | 2021-11-06 | Richland | North Dakota | 38077 | 2663 | 20 |
1886890 | 1886890 | 2021-11-05 | Richland | North Dakota | 38077 | 2654 | 20 |
1883641 | 1883641 | 2021-11-04 | Richland | North Dakota | 38077 | 2638 | 20 |
1880392 | 1880392 | 2021-11-03 | Richland | North Dakota | 38077 | 2624 | 20 |
1877143 | 1877143 | 2021-11-02 | Richland | North Dakota | 38077 | 2609 | 20 |
1873894 | 1873894 | 2021-11-01 | Richland | North Dakota | 38077 | 2595 | 20 |
1870645 | 1870645 | 2021-10-31 | Richland | North Dakota | 38077 | 2593 | 20 |
1867396 | 1867396 | 2021-10-30 | Richland | North Dakota | 38077 | 2590 | 20 |
1864147 | 1864147 | 2021-10-29 | Richland | North Dakota | 38077 | 2583 | 20 |
1860898 | 1860898 | 2021-10-28 | Richland | North Dakota | 38077 | 2575 | 20 |
1857649 | 1857649 | 2021-10-27 | Richland | North Dakota | 38077 | 2564 | 20 |
1854400 | 1854400 | 2021-10-26 | Richland | North Dakota | 38077 | 2554 | 19 |
1851151 | 1851151 | 2021-10-25 | Richland | North Dakota | 38077 | 2531 | 19 |
1847901 | 1847901 | 2021-10-24 | Richland | North Dakota | 38077 | 2529 | 19 |
1844651 | 1844651 | 2021-10-23 | Richland | North Dakota | 38077 | 2526 | 19 |
1841401 | 1841401 | 2021-10-22 | Richland | North Dakota | 38077 | 2517 | 19 |
1838152 | 1838152 | 2021-10-21 | Richland | North Dakota | 38077 | 2509 | 19 |
1834903 | 1834903 | 2021-10-20 | Richland | North Dakota | 38077 | 2488 | 19 |
1831654 | 1831654 | 2021-10-19 | Richland | North Dakota | 38077 | 2481 | 19 |
1828405 | 1828405 | 2021-10-18 | Richland | North Dakota | 38077 | 2452 | 19 |
1825156 | 1825156 | 2021-10-17 | Richland | North Dakota | 38077 | 2449 | 19 |
1821907 | 1821907 | 2021-10-16 | Richland | North Dakota | 38077 | 2448 | 19 |
1818658 | 1818658 | 2021-10-15 | Richland | North Dakota | 38077 | 2439 | 19 |
1815409 | 1815409 | 2021-10-14 | Richland | North Dakota | 38077 | 2430 | 19 |
1812161 | 1812161 | 2021-10-13 | Richland | North Dakota | 38077 | 2415 | 19 |
1808912 | 1808912 | 2021-10-12 | Richland | North Dakota | 38077 | 2410 | 19 |
1805661 | 1805661 | 2021-10-11 | Richland | North Dakota | 38077 | 2393 | 19 |
1802412 | 1802412 | 2021-10-10 | Richland | North Dakota | 38077 | 2389 | 19 |
1799163 | 1799163 | 2021-10-09 | Richland | North Dakota | 38077 | 2388 | 19 |
1795914 | 1795914 | 2021-10-08 | Richland | North Dakota | 38077 | 2373 | 19 |
1792665 | 1792665 | 2021-10-07 | Richland | North Dakota | 38077 | 2365 | 19 |
1789416 | 1789416 | 2021-10-06 | Richland | North Dakota | 38077 | 2349 | 19 |
1786168 | 1786168 | 2021-10-05 | Richland | North Dakota | 38077 | 2335 | 19 |
1782919 | 1782919 | 2021-10-04 | Richland | North Dakota | 38077 | 2315 | 19 |
1779670 | 1779670 | 2021-10-03 | Richland | North Dakota | 38077 | 2315 | 19 |
1776420 | 1776420 | 2021-10-02 | Richland | North Dakota | 38077 | 2312 | 19 |
1773170 | 1773170 | 2021-10-01 | Richland | North Dakota | 38077 | 2302 | 19 |
1769920 | 1769920 | 2021-09-30 | Richland | North Dakota | 38077 | 2288 | 19 |
1766671 | 1766671 | 2021-09-29 | Richland | North Dakota | 38077 | 2274 | 19 |
1763422 | 1763422 | 2021-09-28 | Richland | North Dakota | 38077 | 2258 | 19 |
1760173 | 1760173 | 2021-09-27 | Richland | North Dakota | 38077 | 2246 | 19 |
1756925 | 1756925 | 2021-09-26 | Richland | North Dakota | 38077 | 2243 | 19 |
1753677 | 1753677 | 2021-09-25 | Richland | North Dakota | 38077 | 2243 | 19 |
1750429 | 1750429 | 2021-09-24 | Richland | North Dakota | 38077 | 2236 | 19 |
1747179 | 1747179 | 2021-09-23 | Richland | North Dakota | 38077 | 2233 | 19 |
1743930 | 1743930 | 2021-09-22 | Richland | North Dakota | 38077 | 2226 | 19 |
1740681 | 1740681 | 2021-09-21 | Richland | North Dakota | 38077 | 2222 | 19 |
1737432 | 1737432 | 2021-09-20 | Richland | North Dakota | 38077 | 2217 | 19 |
1734182 | 1734182 | 2021-09-19 | Richland | North Dakota | 38077 | 2217 | 19 |
1730932 | 1730932 | 2021-09-18 | Richland | North Dakota | 38077 | 2216 | 19 |
1727682 | 1727682 | 2021-09-17 | Richland | North Dakota | 38077 | 2213 | 19 |
1724433 | 1724433 | 2021-09-16 | Richland | North Dakota | 38077 | 2212 | 19 |
1721184 | 1721184 | 2021-09-15 | Richland | North Dakota | 38077 | 2202 | 19 |
1717936 | 1717936 | 2021-09-14 | Richland | North Dakota | 38077 | 2197 | 19 |
1714688 | 1714688 | 2021-09-13 | Richland | North Dakota | 38077 | 2196 | 19 |
1711442 | 1711442 | 2021-09-12 | Richland | North Dakota | 38077 | 2196 | 19 |
1708195 | 1708195 | 2021-09-11 | Richland | North Dakota | 38077 | 2193 | 19 |
1704948 | 1704948 | 2021-09-10 | Richland | North Dakota | 38077 | 2190 | 19 |
1701698 | 1701698 | 2021-09-09 | Richland | North Dakota | 38077 | 2179 | 19 |
1698449 | 1698449 | 2021-09-08 | Richland | North Dakota | 38077 | 2166 | 19 |
1695201 | 1695201 | 2021-09-07 | Richland | North Dakota | 38077 | 2158 | 19 |
1691953 | 1691953 | 2021-09-06 | Richland | North Dakota | 38077 | 2147 | 19 |
1688703 | 1688703 | 2021-09-05 | Richland | North Dakota | 38077 | 2144 | 19 |
1685453 | 1685453 | 2021-09-04 | Richland | North Dakota | 38077 | 2141 | 19 |
1682202 | 1682202 | 2021-09-03 | Richland | North Dakota | 38077 | 2134 | 19 |
1678953 | 1678953 | 2021-09-02 | Richland | North Dakota | 38077 | 2128 | 19 |
1675705 | 1675705 | 2021-09-01 | Richland | North Dakota | 38077 | 2119 | 19 |
1672458 | 1672458 | 2021-08-31 | Richland | North Dakota | 38077 | 2109 | 18 |
1669210 | 1669210 | 2021-08-30 | Richland | North Dakota | 38077 | 2099 | 18 |
1665963 | 1665963 | 2021-08-29 | Richland | North Dakota | 38077 | 2095 | 18 |
1662715 | 1662715 | 2021-08-28 | Richland | North Dakota | 38077 | 2095 | 18 |
1659467 | 1659467 | 2021-08-27 | Richland | North Dakota | 38077 | 2091 | 18 |
1656218 | 1656218 | 2021-08-26 | Richland | North Dakota | 38077 | 2085 | 17 |
1652971 | 1652971 | 2021-08-25 | Richland | North Dakota | 38077 | 2084 | 17 |
1649723 | 1649723 | 2021-08-24 | Richland | North Dakota | 38077 | 2086 | 17 |
1646474 | 1646474 | 2021-08-23 | Richland | North Dakota | 38077 | 2078 | 17 |
1643225 | 1643225 | 2021-08-22 | Richland | North Dakota | 38077 | 2078 | 17 |
1639975 | 1639975 | 2021-08-21 | Richland | North Dakota | 38077 | 2078 | 17 |
1636725 | 1636725 | 2021-08-20 | Richland | North Dakota | 38077 | 2071 | 17 |
1633475 | 1633475 | 2021-08-19 | Richland | North Dakota | 38077 | 2067 | 17 |
1630228 | 1630228 | 2021-08-18 | Richland | North Dakota | 38077 | 2060 | 17 |
1626981 | 1626981 | 2021-08-17 | Richland | North Dakota | 38077 | 2053 | 17 |
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);