ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Grand Forks" 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 |
---|---|---|---|---|---|---|---|
2176219 | 2176219 | 2022-02-02 | Grand Forks | North Dakota | 38035 | 20751 | 112 |
2172966 | 2172966 | 2022-02-01 | Grand Forks | North Dakota | 38035 | 20622 | 111 |
2169713 | 2169713 | 2022-01-31 | Grand Forks | North Dakota | 38035 | 20389 | 111 |
2166458 | 2166458 | 2022-01-30 | Grand Forks | North Dakota | 38035 | 20365 | 111 |
2163203 | 2163203 | 2022-01-29 | Grand Forks | North Dakota | 38035 | 20314 | 111 |
2159948 | 2159948 | 2022-01-28 | Grand Forks | North Dakota | 38035 | 20143 | 111 |
2156693 | 2156693 | 2022-01-27 | Grand Forks | North Dakota | 38035 | 19938 | 111 |
2153440 | 2153440 | 2022-01-26 | Grand Forks | North Dakota | 38035 | 19695 | 111 |
2150188 | 2150188 | 2022-01-25 | Grand Forks | North Dakota | 38035 | 19444 | 110 |
2146936 | 2146936 | 2022-01-24 | Grand Forks | North Dakota | 38035 | 19022 | 110 |
2143682 | 2143682 | 2022-01-23 | Grand Forks | North Dakota | 38035 | 19022 | 110 |
2140427 | 2140427 | 2022-01-22 | Grand Forks | North Dakota | 38035 | 18968 | 110 |
2137171 | 2137171 | 2022-01-21 | Grand Forks | North Dakota | 38035 | 18753 | 110 |
2133918 | 2133918 | 2022-01-20 | Grand Forks | North Dakota | 38035 | 18488 | 110 |
2130666 | 2130666 | 2022-01-19 | Grand Forks | North Dakota | 38035 | 18124 | 108 |
2127412 | 2127412 | 2022-01-18 | Grand Forks | North Dakota | 38035 | 17799 | 106 |
2124160 | 2124160 | 2022-01-17 | Grand Forks | North Dakota | 38035 | 17431 | 106 |
2120908 | 2120908 | 2022-01-16 | Grand Forks | North Dakota | 38035 | 17348 | 106 |
2117656 | 2117656 | 2022-01-15 | Grand Forks | North Dakota | 38035 | 17230 | 106 |
2114405 | 2114405 | 2022-01-14 | Grand Forks | North Dakota | 38035 | 16967 | 106 |
2111153 | 2111153 | 2022-01-13 | Grand Forks | North Dakota | 38035 | 16714 | 106 |
2107901 | 2107901 | 2022-01-12 | Grand Forks | North Dakota | 38035 | 16446 | 106 |
2104650 | 2104650 | 2022-01-11 | Grand Forks | North Dakota | 38035 | 16147 | 105 |
2101399 | 2101399 | 2022-01-10 | Grand Forks | North Dakota | 38035 | 15993 | 105 |
2098148 | 2098148 | 2022-01-09 | Grand Forks | North Dakota | 38035 | 15958 | 105 |
2094896 | 2094896 | 2022-01-08 | Grand Forks | North Dakota | 38035 | 15851 | 105 |
2091644 | 2091644 | 2022-01-07 | Grand Forks | North Dakota | 38035 | 15760 | 105 |
2088393 | 2088393 | 2022-01-06 | Grand Forks | North Dakota | 38035 | 15586 | 105 |
2085141 | 2085141 | 2022-01-05 | Grand Forks | North Dakota | 38035 | 15494 | 105 |
2081889 | 2081889 | 2022-01-04 | Grand Forks | North Dakota | 38035 | 15327 | 104 |
2078637 | 2078637 | 2022-01-03 | Grand Forks | North Dakota | 38035 | 15206 | 104 |
2075386 | 2075386 | 2022-01-02 | Grand Forks | North Dakota | 38035 | 15164 | 104 |
2072135 | 2072135 | 2022-01-01 | Grand Forks | North Dakota | 38035 | 15146 | 104 |
2068884 | 2068884 | 2021-12-31 | Grand Forks | North Dakota | 38035 | 15090 | 104 |
2065633 | 2065633 | 2021-12-30 | Grand Forks | North Dakota | 38035 | 15012 | 103 |
2062383 | 2062383 | 2021-12-29 | Grand Forks | North Dakota | 38035 | 14931 | 103 |
2059134 | 2059134 | 2021-12-28 | Grand Forks | North Dakota | 38035 | 14880 | 103 |
2055885 | 2055885 | 2021-12-27 | Grand Forks | North Dakota | 38035 | 14834 | 102 |
2052635 | 2052635 | 2021-12-26 | Grand Forks | North Dakota | 38035 | 14818 | 102 |
2049385 | 2049385 | 2021-12-25 | Grand Forks | North Dakota | 38035 | 14805 | 102 |
2046135 | 2046135 | 2021-12-24 | Grand Forks | North Dakota | 38035 | 14786 | 102 |
2042885 | 2042885 | 2021-12-23 | Grand Forks | North Dakota | 38035 | 14753 | 102 |
2039636 | 2039636 | 2021-12-22 | Grand Forks | North Dakota | 38035 | 14711 | 102 |
2036386 | 2036386 | 2021-12-21 | Grand Forks | North Dakota | 38035 | 14680 | 102 |
2033136 | 2033136 | 2021-12-20 | Grand Forks | North Dakota | 38035 | 14636 | 102 |
2029886 | 2029886 | 2021-12-19 | Grand Forks | North Dakota | 38035 | 14620 | 102 |
2026635 | 2026635 | 2021-12-18 | Grand Forks | North Dakota | 38035 | 14598 | 102 |
2023384 | 2023384 | 2021-12-17 | Grand Forks | North Dakota | 38035 | 14587 | 101 |
2020133 | 2020133 | 2021-12-16 | Grand Forks | North Dakota | 38035 | 14551 | 101 |
2016882 | 2016882 | 2021-12-15 | Grand Forks | North Dakota | 38035 | 14507 | 101 |
2013632 | 2013632 | 2021-12-14 | Grand Forks | North Dakota | 38035 | 14477 | 101 |
2010381 | 2010381 | 2021-12-13 | Grand Forks | North Dakota | 38035 | 14444 | 100 |
2007130 | 2007130 | 2021-12-12 | Grand Forks | North Dakota | 38035 | 14435 | 100 |
2003879 | 2003879 | 2021-12-11 | Grand Forks | North Dakota | 38035 | 14432 | 100 |
2000628 | 2000628 | 2021-12-10 | Grand Forks | North Dakota | 38035 | 14383 | 100 |
1997378 | 1997378 | 2021-12-09 | Grand Forks | North Dakota | 38035 | 14352 | 100 |
1994127 | 1994127 | 2021-12-08 | Grand Forks | North Dakota | 38035 | 14328 | 100 |
1990876 | 1990876 | 2021-12-07 | Grand Forks | North Dakota | 38035 | 14287 | 100 |
1987625 | 1987625 | 2021-12-06 | Grand Forks | North Dakota | 38035 | 14262 | 98 |
1984375 | 1984375 | 2021-12-05 | Grand Forks | North Dakota | 38035 | 14252 | 98 |
1981125 | 1981125 | 2021-12-04 | Grand Forks | North Dakota | 38035 | 14242 | 98 |
1977875 | 1977875 | 2021-12-03 | Grand Forks | North Dakota | 38035 | 14190 | 98 |
1974625 | 1974625 | 2021-12-02 | Grand Forks | North Dakota | 38035 | 14140 | 97 |
1971376 | 1971376 | 2021-12-01 | Grand Forks | North Dakota | 38035 | 14089 | 97 |
1968126 | 1968126 | 2021-11-30 | Grand Forks | North Dakota | 38035 | 14015 | 97 |
1964875 | 1964875 | 2021-11-29 | Grand Forks | North Dakota | 38035 | 13945 | 96 |
1961623 | 1961623 | 2021-11-28 | Grand Forks | North Dakota | 38035 | 13942 | 96 |
1958372 | 1958372 | 2021-11-27 | Grand Forks | North Dakota | 38035 | 13934 | 96 |
1955121 | 1955121 | 2021-11-26 | Grand Forks | North Dakota | 38035 | 13903 | 95 |
1951870 | 1951870 | 2021-11-25 | Grand Forks | North Dakota | 38035 | 13898 | 95 |
1948619 | 1948619 | 2021-11-24 | Grand Forks | North Dakota | 38035 | 13846 | 95 |
1945368 | 1945368 | 2021-11-23 | Grand Forks | North Dakota | 38035 | 13831 | 95 |
1942117 | 1942117 | 2021-11-22 | Grand Forks | North Dakota | 38035 | 13782 | 94 |
1938867 | 1938867 | 2021-11-21 | Grand Forks | North Dakota | 38035 | 13759 | 94 |
1935617 | 1935617 | 2021-11-20 | Grand Forks | North Dakota | 38035 | 13755 | 94 |
1932367 | 1932367 | 2021-11-19 | Grand Forks | North Dakota | 38035 | 13717 | 94 |
1929116 | 1929116 | 2021-11-18 | Grand Forks | North Dakota | 38035 | 13682 | 94 |
1925866 | 1925866 | 2021-11-17 | Grand Forks | North Dakota | 38035 | 13651 | 93 |
1922617 | 1922617 | 2021-11-16 | Grand Forks | North Dakota | 38035 | 13600 | 93 |
1919367 | 1919367 | 2021-11-15 | Grand Forks | North Dakota | 38035 | 13540 | 93 |
1916117 | 1916117 | 2021-11-14 | Grand Forks | North Dakota | 38035 | 13524 | 93 |
1912867 | 1912867 | 2021-11-13 | Grand Forks | North Dakota | 38035 | 13510 | 93 |
1909617 | 1909617 | 2021-11-12 | Grand Forks | North Dakota | 38035 | 13468 | 92 |
1906368 | 1906368 | 2021-11-11 | Grand Forks | North Dakota | 38035 | 13434 | 92 |
1903119 | 1903119 | 2021-11-10 | Grand Forks | North Dakota | 38035 | 13388 | 92 |
1899869 | 1899869 | 2021-11-09 | Grand Forks | North Dakota | 38035 | 13345 | 90 |
1896619 | 1896619 | 2021-11-08 | Grand Forks | North Dakota | 38035 | 13273 | 90 |
1893369 | 1893369 | 2021-11-07 | Grand Forks | North Dakota | 38035 | 13260 | 90 |
1890119 | 1890119 | 2021-11-06 | Grand Forks | North Dakota | 38035 | 13254 | 90 |
1886869 | 1886869 | 2021-11-05 | Grand Forks | North Dakota | 38035 | 13216 | 89 |
1883620 | 1883620 | 2021-11-04 | Grand Forks | North Dakota | 38035 | 13173 | 89 |
1880371 | 1880371 | 2021-11-03 | Grand Forks | North Dakota | 38035 | 13121 | 89 |
1877122 | 1877122 | 2021-11-02 | Grand Forks | North Dakota | 38035 | 13086 | 89 |
1873873 | 1873873 | 2021-11-01 | Grand Forks | North Dakota | 38035 | 13033 | 88 |
1870624 | 1870624 | 2021-10-31 | Grand Forks | North Dakota | 38035 | 13016 | 88 |
1867375 | 1867375 | 2021-10-30 | Grand Forks | North Dakota | 38035 | 13006 | 88 |
1864126 | 1864126 | 2021-10-29 | Grand Forks | North Dakota | 38035 | 12972 | 88 |
1860877 | 1860877 | 2021-10-28 | Grand Forks | North Dakota | 38035 | 12942 | 88 |
1857628 | 1857628 | 2021-10-27 | Grand Forks | North Dakota | 38035 | 12919 | 88 |
1854379 | 1854379 | 2021-10-26 | Grand Forks | North Dakota | 38035 | 12893 | 86 |
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);