ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 38023 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 |
---|---|---|---|---|---|---|---|
2176213 | 2176213 | 2022-02-02 | Divide | North Dakota | 38023 | 443 | 4 |
2172960 | 2172960 | 2022-02-01 | Divide | North Dakota | 38023 | 442 | 4 |
2169707 | 2169707 | 2022-01-31 | Divide | North Dakota | 38023 | 439 | 4 |
2166452 | 2166452 | 2022-01-30 | Divide | North Dakota | 38023 | 439 | 4 |
2163197 | 2163197 | 2022-01-29 | Divide | North Dakota | 38023 | 439 | 4 |
2159942 | 2159942 | 2022-01-28 | Divide | North Dakota | 38023 | 436 | 4 |
2156687 | 2156687 | 2022-01-27 | Divide | North Dakota | 38023 | 425 | 4 |
2153434 | 2153434 | 2022-01-26 | Divide | North Dakota | 38023 | 420 | 4 |
2150182 | 2150182 | 2022-01-25 | Divide | North Dakota | 38023 | 413 | 4 |
2146930 | 2146930 | 2022-01-24 | Divide | North Dakota | 38023 | 408 | 4 |
2143676 | 2143676 | 2022-01-23 | Divide | North Dakota | 38023 | 408 | 4 |
2140421 | 2140421 | 2022-01-22 | Divide | North Dakota | 38023 | 408 | 4 |
2137165 | 2137165 | 2022-01-21 | Divide | North Dakota | 38023 | 401 | 3 |
2133912 | 2133912 | 2022-01-20 | Divide | North Dakota | 38023 | 396 | 3 |
2130660 | 2130660 | 2022-01-19 | Divide | North Dakota | 38023 | 387 | 3 |
2127406 | 2127406 | 2022-01-18 | Divide | North Dakota | 38023 | 374 | 3 |
2124154 | 2124154 | 2022-01-17 | Divide | North Dakota | 38023 | 370 | 3 |
2120902 | 2120902 | 2022-01-16 | Divide | North Dakota | 38023 | 370 | 3 |
2117650 | 2117650 | 2022-01-15 | Divide | North Dakota | 38023 | 370 | 3 |
2114399 | 2114399 | 2022-01-14 | Divide | North Dakota | 38023 | 365 | 3 |
2111147 | 2111147 | 2022-01-13 | Divide | North Dakota | 38023 | 360 | 3 |
2107895 | 2107895 | 2022-01-12 | Divide | North Dakota | 38023 | 355 | 3 |
2104644 | 2104644 | 2022-01-11 | Divide | North Dakota | 38023 | 351 | 3 |
2101393 | 2101393 | 2022-01-10 | Divide | North Dakota | 38023 | 349 | 3 |
2098142 | 2098142 | 2022-01-09 | Divide | North Dakota | 38023 | 349 | 3 |
2094890 | 2094890 | 2022-01-08 | Divide | North Dakota | 38023 | 349 | 3 |
2091638 | 2091638 | 2022-01-07 | Divide | North Dakota | 38023 | 349 | 3 |
2088387 | 2088387 | 2022-01-06 | Divide | North Dakota | 38023 | 349 | 3 |
2085135 | 2085135 | 2022-01-05 | Divide | North Dakota | 38023 | 344 | 3 |
2081883 | 2081883 | 2022-01-04 | Divide | North Dakota | 38023 | 342 | 3 |
2078631 | 2078631 | 2022-01-03 | Divide | North Dakota | 38023 | 340 | 3 |
2075380 | 2075380 | 2022-01-02 | Divide | North Dakota | 38023 | 339 | 3 |
2072129 | 2072129 | 2022-01-01 | Divide | North Dakota | 38023 | 339 | 3 |
2068878 | 2068878 | 2021-12-31 | Divide | North Dakota | 38023 | 338 | 3 |
2065627 | 2065627 | 2021-12-30 | Divide | North Dakota | 38023 | 338 | 3 |
2062377 | 2062377 | 2021-12-29 | Divide | North Dakota | 38023 | 335 | 3 |
2059128 | 2059128 | 2021-12-28 | Divide | North Dakota | 38023 | 335 | 3 |
2055879 | 2055879 | 2021-12-27 | Divide | North Dakota | 38023 | 333 | 3 |
2052629 | 2052629 | 2021-12-26 | Divide | North Dakota | 38023 | 333 | 3 |
2049379 | 2049379 | 2021-12-25 | Divide | North Dakota | 38023 | 333 | 3 |
2046129 | 2046129 | 2021-12-24 | Divide | North Dakota | 38023 | 333 | 3 |
2042879 | 2042879 | 2021-12-23 | Divide | North Dakota | 38023 | 333 | 3 |
2039630 | 2039630 | 2021-12-22 | Divide | North Dakota | 38023 | 332 | 3 |
2036380 | 2036380 | 2021-12-21 | Divide | North Dakota | 38023 | 332 | 3 |
2033130 | 2033130 | 2021-12-20 | Divide | North Dakota | 38023 | 331 | 3 |
2029880 | 2029880 | 2021-12-19 | Divide | North Dakota | 38023 | 331 | 3 |
2026629 | 2026629 | 2021-12-18 | Divide | North Dakota | 38023 | 331 | 3 |
2023378 | 2023378 | 2021-12-17 | Divide | North Dakota | 38023 | 330 | 3 |
2020127 | 2020127 | 2021-12-16 | Divide | North Dakota | 38023 | 330 | 3 |
2016876 | 2016876 | 2021-12-15 | Divide | North Dakota | 38023 | 329 | 3 |
2013626 | 2013626 | 2021-12-14 | Divide | North Dakota | 38023 | 328 | 3 |
2010375 | 2010375 | 2021-12-13 | Divide | North Dakota | 38023 | 327 | 3 |
2007124 | 2007124 | 2021-12-12 | Divide | North Dakota | 38023 | 327 | 3 |
2003873 | 2003873 | 2021-12-11 | Divide | North Dakota | 38023 | 327 | 3 |
2000622 | 2000622 | 2021-12-10 | Divide | North Dakota | 38023 | 326 | 3 |
1997372 | 1997372 | 2021-12-09 | Divide | North Dakota | 38023 | 326 | 3 |
1994121 | 1994121 | 2021-12-08 | Divide | North Dakota | 38023 | 326 | 3 |
1990870 | 1990870 | 2021-12-07 | Divide | North Dakota | 38023 | 325 | 3 |
1987619 | 1987619 | 2021-12-06 | Divide | North Dakota | 38023 | 323 | 3 |
1984369 | 1984369 | 2021-12-05 | Divide | North Dakota | 38023 | 323 | 3 |
1981119 | 1981119 | 2021-12-04 | Divide | North Dakota | 38023 | 322 | 3 |
1977869 | 1977869 | 2021-12-03 | Divide | North Dakota | 38023 | 322 | 3 |
1974619 | 1974619 | 2021-12-02 | Divide | North Dakota | 38023 | 321 | 3 |
1971370 | 1971370 | 2021-12-01 | Divide | North Dakota | 38023 | 319 | 3 |
1968120 | 1968120 | 2021-11-30 | Divide | North Dakota | 38023 | 318 | 3 |
1964869 | 1964869 | 2021-11-29 | Divide | North Dakota | 38023 | 317 | 3 |
1961617 | 1961617 | 2021-11-28 | Divide | North Dakota | 38023 | 316 | 3 |
1958366 | 1958366 | 2021-11-27 | Divide | North Dakota | 38023 | 316 | 3 |
1955115 | 1955115 | 2021-11-26 | Divide | North Dakota | 38023 | 314 | 3 |
1951864 | 1951864 | 2021-11-25 | Divide | North Dakota | 38023 | 314 | 3 |
1948613 | 1948613 | 2021-11-24 | Divide | North Dakota | 38023 | 313 | 3 |
1945362 | 1945362 | 2021-11-23 | Divide | North Dakota | 38023 | 312 | 3 |
1942111 | 1942111 | 2021-11-22 | Divide | North Dakota | 38023 | 308 | 3 |
1938861 | 1938861 | 2021-11-21 | Divide | North Dakota | 38023 | 308 | 3 |
1935611 | 1935611 | 2021-11-20 | Divide | North Dakota | 38023 | 306 | 3 |
1932361 | 1932361 | 2021-11-19 | Divide | North Dakota | 38023 | 304 | 3 |
1929110 | 1929110 | 2021-11-18 | Divide | North Dakota | 38023 | 301 | 3 |
1925860 | 1925860 | 2021-11-17 | Divide | North Dakota | 38023 | 301 | 3 |
1922611 | 1922611 | 2021-11-16 | Divide | North Dakota | 38023 | 301 | 3 |
1919361 | 1919361 | 2021-11-15 | Divide | North Dakota | 38023 | 297 | 3 |
1916111 | 1916111 | 2021-11-14 | Divide | North Dakota | 38023 | 295 | 3 |
1912861 | 1912861 | 2021-11-13 | Divide | North Dakota | 38023 | 295 | 3 |
1909611 | 1909611 | 2021-11-12 | Divide | North Dakota | 38023 | 295 | 3 |
1906362 | 1906362 | 2021-11-11 | Divide | North Dakota | 38023 | 295 | 3 |
1903113 | 1903113 | 2021-11-10 | Divide | North Dakota | 38023 | 290 | 3 |
1899863 | 1899863 | 2021-11-09 | Divide | North Dakota | 38023 | 285 | 3 |
1896613 | 1896613 | 2021-11-08 | Divide | North Dakota | 38023 | 280 | 3 |
1893363 | 1893363 | 2021-11-07 | Divide | North Dakota | 38023 | 279 | 3 |
1890113 | 1890113 | 2021-11-06 | Divide | North Dakota | 38023 | 278 | 3 |
1886863 | 1886863 | 2021-11-05 | Divide | North Dakota | 38023 | 277 | 3 |
1883614 | 1883614 | 2021-11-04 | Divide | North Dakota | 38023 | 277 | 3 |
1880365 | 1880365 | 2021-11-03 | Divide | North Dakota | 38023 | 273 | 3 |
1877116 | 1877116 | 2021-11-02 | Divide | North Dakota | 38023 | 272 | 3 |
1873867 | 1873867 | 2021-11-01 | Divide | North Dakota | 38023 | 272 | 3 |
1870618 | 1870618 | 2021-10-31 | Divide | North Dakota | 38023 | 272 | 3 |
1867369 | 1867369 | 2021-10-30 | Divide | North Dakota | 38023 | 270 | 3 |
1864120 | 1864120 | 2021-10-29 | Divide | North Dakota | 38023 | 269 | 3 |
1860871 | 1860871 | 2021-10-28 | Divide | North Dakota | 38023 | 269 | 2 |
1857622 | 1857622 | 2021-10-27 | Divide | North Dakota | 38023 | 269 | 2 |
1854373 | 1854373 | 2021-10-26 | Divide | North Dakota | 38023 | 265 | 2 |
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);