ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
704 rows where fips = 38043 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 |
---|---|---|---|---|---|---|---|
2176223 | 2176223 | 2022-02-02 | Kidder | North Dakota | 38043 | 477 | 13 |
2172970 | 2172970 | 2022-02-01 | Kidder | North Dakota | 38043 | 474 | 13 |
2169717 | 2169717 | 2022-01-31 | Kidder | North Dakota | 38043 | 472 | 13 |
2166462 | 2166462 | 2022-01-30 | Kidder | North Dakota | 38043 | 471 | 13 |
2163207 | 2163207 | 2022-01-29 | Kidder | North Dakota | 38043 | 471 | 13 |
2159952 | 2159952 | 2022-01-28 | Kidder | North Dakota | 38043 | 470 | 13 |
2156697 | 2156697 | 2022-01-27 | Kidder | North Dakota | 38043 | 463 | 13 |
2153444 | 2153444 | 2022-01-26 | Kidder | North Dakota | 38043 | 459 | 13 |
2150192 | 2150192 | 2022-01-25 | Kidder | North Dakota | 38043 | 457 | 13 |
2146940 | 2146940 | 2022-01-24 | Kidder | North Dakota | 38043 | 452 | 13 |
2143686 | 2143686 | 2022-01-23 | Kidder | North Dakota | 38043 | 452 | 13 |
2140431 | 2140431 | 2022-01-22 | Kidder | North Dakota | 38043 | 451 | 13 |
2137175 | 2137175 | 2022-01-21 | Kidder | North Dakota | 38043 | 449 | 13 |
2133922 | 2133922 | 2022-01-20 | Kidder | North Dakota | 38043 | 447 | 13 |
2130670 | 2130670 | 2022-01-19 | Kidder | North Dakota | 38043 | 439 | 13 |
2127416 | 2127416 | 2022-01-18 | Kidder | North Dakota | 38043 | 433 | 13 |
2124164 | 2124164 | 2022-01-17 | Kidder | North Dakota | 38043 | 432 | 13 |
2120912 | 2120912 | 2022-01-16 | Kidder | North Dakota | 38043 | 431 | 13 |
2117660 | 2117660 | 2022-01-15 | Kidder | North Dakota | 38043 | 429 | 13 |
2114409 | 2114409 | 2022-01-14 | Kidder | North Dakota | 38043 | 425 | 13 |
2111157 | 2111157 | 2022-01-13 | Kidder | North Dakota | 38043 | 422 | 13 |
2107905 | 2107905 | 2022-01-12 | Kidder | North Dakota | 38043 | 420 | 13 |
2104654 | 2104654 | 2022-01-11 | Kidder | North Dakota | 38043 | 415 | 13 |
2101403 | 2101403 | 2022-01-10 | Kidder | North Dakota | 38043 | 410 | 13 |
2098152 | 2098152 | 2022-01-09 | Kidder | North Dakota | 38043 | 410 | 13 |
2094900 | 2094900 | 2022-01-08 | Kidder | North Dakota | 38043 | 410 | 13 |
2091648 | 2091648 | 2022-01-07 | Kidder | North Dakota | 38043 | 410 | 13 |
2088397 | 2088397 | 2022-01-06 | Kidder | North Dakota | 38043 | 409 | 13 |
2085145 | 2085145 | 2022-01-05 | Kidder | North Dakota | 38043 | 409 | 13 |
2081893 | 2081893 | 2022-01-04 | Kidder | North Dakota | 38043 | 408 | 13 |
2078641 | 2078641 | 2022-01-03 | Kidder | North Dakota | 38043 | 407 | 13 |
2075390 | 2075390 | 2022-01-02 | Kidder | North Dakota | 38043 | 407 | 13 |
2072139 | 2072139 | 2022-01-01 | Kidder | North Dakota | 38043 | 407 | 13 |
2068888 | 2068888 | 2021-12-31 | Kidder | North Dakota | 38043 | 404 | 13 |
2065637 | 2065637 | 2021-12-30 | Kidder | North Dakota | 38043 | 404 | 13 |
2062387 | 2062387 | 2021-12-29 | Kidder | North Dakota | 38043 | 402 | 13 |
2059138 | 2059138 | 2021-12-28 | Kidder | North Dakota | 38043 | 400 | 13 |
2055889 | 2055889 | 2021-12-27 | Kidder | North Dakota | 38043 | 400 | 13 |
2052639 | 2052639 | 2021-12-26 | Kidder | North Dakota | 38043 | 400 | 13 |
2049389 | 2049389 | 2021-12-25 | Kidder | North Dakota | 38043 | 400 | 13 |
2046139 | 2046139 | 2021-12-24 | Kidder | North Dakota | 38043 | 400 | 13 |
2042889 | 2042889 | 2021-12-23 | Kidder | North Dakota | 38043 | 400 | 13 |
2039640 | 2039640 | 2021-12-22 | Kidder | North Dakota | 38043 | 400 | 13 |
2036390 | 2036390 | 2021-12-21 | Kidder | North Dakota | 38043 | 397 | 13 |
2033140 | 2033140 | 2021-12-20 | Kidder | North Dakota | 38043 | 396 | 13 |
2029890 | 2029890 | 2021-12-19 | Kidder | North Dakota | 38043 | 396 | 13 |
2026639 | 2026639 | 2021-12-18 | Kidder | North Dakota | 38043 | 396 | 13 |
2023388 | 2023388 | 2021-12-17 | Kidder | North Dakota | 38043 | 396 | 13 |
2020137 | 2020137 | 2021-12-16 | Kidder | North Dakota | 38043 | 396 | 13 |
2016886 | 2016886 | 2021-12-15 | Kidder | North Dakota | 38043 | 396 | 13 |
2013636 | 2013636 | 2021-12-14 | Kidder | North Dakota | 38043 | 396 | 13 |
2010385 | 2010385 | 2021-12-13 | Kidder | North Dakota | 38043 | 396 | 13 |
2007134 | 2007134 | 2021-12-12 | Kidder | North Dakota | 38043 | 396 | 13 |
2003883 | 2003883 | 2021-12-11 | Kidder | North Dakota | 38043 | 396 | 13 |
2000632 | 2000632 | 2021-12-10 | Kidder | North Dakota | 38043 | 396 | 13 |
1997382 | 1997382 | 2021-12-09 | Kidder | North Dakota | 38043 | 395 | 13 |
1994131 | 1994131 | 2021-12-08 | Kidder | North Dakota | 38043 | 395 | 13 |
1990880 | 1990880 | 2021-12-07 | Kidder | North Dakota | 38043 | 394 | 13 |
1987629 | 1987629 | 2021-12-06 | Kidder | North Dakota | 38043 | 394 | 13 |
1984379 | 1984379 | 2021-12-05 | Kidder | North Dakota | 38043 | 394 | 13 |
1981129 | 1981129 | 2021-12-04 | Kidder | North Dakota | 38043 | 392 | 13 |
1977879 | 1977879 | 2021-12-03 | Kidder | North Dakota | 38043 | 391 | 13 |
1974629 | 1974629 | 2021-12-02 | Kidder | North Dakota | 38043 | 391 | 13 |
1971380 | 1971380 | 2021-12-01 | Kidder | North Dakota | 38043 | 391 | 13 |
1968130 | 1968130 | 2021-11-30 | Kidder | North Dakota | 38043 | 391 | 13 |
1964879 | 1964879 | 2021-11-29 | Kidder | North Dakota | 38043 | 387 | 13 |
1961627 | 1961627 | 2021-11-28 | Kidder | North Dakota | 38043 | 387 | 13 |
1958376 | 1958376 | 2021-11-27 | Kidder | North Dakota | 38043 | 386 | 13 |
1955125 | 1955125 | 2021-11-26 | Kidder | North Dakota | 38043 | 385 | 13 |
1951874 | 1951874 | 2021-11-25 | Kidder | North Dakota | 38043 | 385 | 13 |
1948623 | 1948623 | 2021-11-24 | Kidder | North Dakota | 38043 | 381 | 13 |
1945372 | 1945372 | 2021-11-23 | Kidder | North Dakota | 38043 | 381 | 13 |
1942121 | 1942121 | 2021-11-22 | Kidder | North Dakota | 38043 | 378 | 12 |
1938871 | 1938871 | 2021-11-21 | Kidder | North Dakota | 38043 | 378 | 12 |
1935621 | 1935621 | 2021-11-20 | Kidder | North Dakota | 38043 | 378 | 12 |
1932371 | 1932371 | 2021-11-19 | Kidder | North Dakota | 38043 | 378 | 12 |
1929120 | 1929120 | 2021-11-18 | Kidder | North Dakota | 38043 | 376 | 12 |
1925870 | 1925870 | 2021-11-17 | Kidder | North Dakota | 38043 | 374 | 12 |
1922621 | 1922621 | 2021-11-16 | Kidder | North Dakota | 38043 | 373 | 12 |
1919371 | 1919371 | 2021-11-15 | Kidder | North Dakota | 38043 | 372 | 11 |
1916121 | 1916121 | 2021-11-14 | Kidder | North Dakota | 38043 | 372 | 11 |
1912871 | 1912871 | 2021-11-13 | Kidder | North Dakota | 38043 | 372 | 11 |
1909621 | 1909621 | 2021-11-12 | Kidder | North Dakota | 38043 | 370 | 11 |
1906372 | 1906372 | 2021-11-11 | Kidder | North Dakota | 38043 | 369 | 11 |
1903123 | 1903123 | 2021-11-10 | Kidder | North Dakota | 38043 | 368 | 11 |
1899873 | 1899873 | 2021-11-09 | Kidder | North Dakota | 38043 | 368 | 11 |
1896623 | 1896623 | 2021-11-08 | Kidder | North Dakota | 38043 | 364 | 11 |
1893373 | 1893373 | 2021-11-07 | Kidder | North Dakota | 38043 | 364 | 11 |
1890123 | 1890123 | 2021-11-06 | Kidder | North Dakota | 38043 | 364 | 11 |
1886873 | 1886873 | 2021-11-05 | Kidder | North Dakota | 38043 | 364 | 11 |
1883624 | 1883624 | 2021-11-04 | Kidder | North Dakota | 38043 | 364 | 11 |
1880375 | 1880375 | 2021-11-03 | Kidder | North Dakota | 38043 | 364 | 11 |
1877126 | 1877126 | 2021-11-02 | Kidder | North Dakota | 38043 | 363 | 11 |
1873877 | 1873877 | 2021-11-01 | Kidder | North Dakota | 38043 | 362 | 11 |
1870628 | 1870628 | 2021-10-31 | Kidder | North Dakota | 38043 | 362 | 11 |
1867379 | 1867379 | 2021-10-30 | Kidder | North Dakota | 38043 | 362 | 11 |
1864130 | 1864130 | 2021-10-29 | Kidder | North Dakota | 38043 | 361 | 11 |
1860881 | 1860881 | 2021-10-28 | Kidder | North Dakota | 38043 | 361 | 11 |
1857632 | 1857632 | 2021-10-27 | Kidder | North Dakota | 38043 | 360 | 11 |
1854383 | 1854383 | 2021-10-26 | Kidder | North Dakota | 38043 | 360 | 11 |
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);