ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
655 rows where county = "Adams" 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 |
---|---|---|---|---|---|---|---|
2176202 | 2176202 | 2022-02-02 | Adams | North Dakota | 38001 | 555 | 9 |
2172949 | 2172949 | 2022-02-01 | Adams | North Dakota | 38001 | 555 | 9 |
2169696 | 2169696 | 2022-01-31 | Adams | North Dakota | 38001 | 552 | 9 |
2166441 | 2166441 | 2022-01-30 | Adams | North Dakota | 38001 | 551 | 9 |
2163186 | 2163186 | 2022-01-29 | Adams | North Dakota | 38001 | 549 | 9 |
2159931 | 2159931 | 2022-01-28 | Adams | North Dakota | 38001 | 540 | 9 |
2156676 | 2156676 | 2022-01-27 | Adams | North Dakota | 38001 | 536 | 9 |
2153423 | 2153423 | 2022-01-26 | Adams | North Dakota | 38001 | 531 | 9 |
2150171 | 2150171 | 2022-01-25 | Adams | North Dakota | 38001 | 525 | 9 |
2146919 | 2146919 | 2022-01-24 | Adams | North Dakota | 38001 | 520 | 9 |
2143665 | 2143665 | 2022-01-23 | Adams | North Dakota | 38001 | 520 | 9 |
2140410 | 2140410 | 2022-01-22 | Adams | North Dakota | 38001 | 519 | 9 |
2137154 | 2137154 | 2022-01-21 | Adams | North Dakota | 38001 | 513 | 9 |
2133901 | 2133901 | 2022-01-20 | Adams | North Dakota | 38001 | 512 | 9 |
2130649 | 2130649 | 2022-01-19 | Adams | North Dakota | 38001 | 504 | 9 |
2127395 | 2127395 | 2022-01-18 | Adams | North Dakota | 38001 | 499 | 9 |
2124143 | 2124143 | 2022-01-17 | Adams | North Dakota | 38001 | 494 | 9 |
2120891 | 2120891 | 2022-01-16 | Adams | North Dakota | 38001 | 493 | 9 |
2117639 | 2117639 | 2022-01-15 | Adams | North Dakota | 38001 | 489 | 9 |
2114388 | 2114388 | 2022-01-14 | Adams | North Dakota | 38001 | 486 | 9 |
2111136 | 2111136 | 2022-01-13 | Adams | North Dakota | 38001 | 483 | 9 |
2107884 | 2107884 | 2022-01-12 | Adams | North Dakota | 38001 | 482 | 9 |
2104633 | 2104633 | 2022-01-11 | Adams | North Dakota | 38001 | 481 | 9 |
2101382 | 2101382 | 2022-01-10 | Adams | North Dakota | 38001 | 481 | 9 |
2098131 | 2098131 | 2022-01-09 | Adams | North Dakota | 38001 | 480 | 9 |
2094879 | 2094879 | 2022-01-08 | Adams | North Dakota | 38001 | 480 | 9 |
2091627 | 2091627 | 2022-01-07 | Adams | North Dakota | 38001 | 480 | 9 |
2088376 | 2088376 | 2022-01-06 | Adams | North Dakota | 38001 | 477 | 9 |
2085124 | 2085124 | 2022-01-05 | Adams | North Dakota | 38001 | 475 | 9 |
2081872 | 2081872 | 2022-01-04 | Adams | North Dakota | 38001 | 474 | 8 |
2078620 | 2078620 | 2022-01-03 | Adams | North Dakota | 38001 | 473 | 8 |
2075369 | 2075369 | 2022-01-02 | Adams | North Dakota | 38001 | 473 | 8 |
2072118 | 2072118 | 2022-01-01 | Adams | North Dakota | 38001 | 473 | 8 |
2068867 | 2068867 | 2021-12-31 | Adams | North Dakota | 38001 | 472 | 8 |
2065616 | 2065616 | 2021-12-30 | Adams | North Dakota | 38001 | 469 | 8 |
2062366 | 2062366 | 2021-12-29 | Adams | North Dakota | 38001 | 469 | 8 |
2059117 | 2059117 | 2021-12-28 | Adams | North Dakota | 38001 | 467 | 8 |
2055868 | 2055868 | 2021-12-27 | Adams | North Dakota | 38001 | 468 | 8 |
2052618 | 2052618 | 2021-12-26 | Adams | North Dakota | 38001 | 468 | 8 |
2049368 | 2049368 | 2021-12-25 | Adams | North Dakota | 38001 | 468 | 8 |
2046118 | 2046118 | 2021-12-24 | Adams | North Dakota | 38001 | 467 | 8 |
2042868 | 2042868 | 2021-12-23 | Adams | North Dakota | 38001 | 467 | 8 |
2039619 | 2039619 | 2021-12-22 | Adams | North Dakota | 38001 | 467 | 8 |
2036369 | 2036369 | 2021-12-21 | Adams | North Dakota | 38001 | 464 | 8 |
2033119 | 2033119 | 2021-12-20 | Adams | North Dakota | 38001 | 463 | 8 |
2029869 | 2029869 | 2021-12-19 | Adams | North Dakota | 38001 | 463 | 8 |
2026618 | 2026618 | 2021-12-18 | Adams | North Dakota | 38001 | 461 | 8 |
2023367 | 2023367 | 2021-12-17 | Adams | North Dakota | 38001 | 461 | 8 |
2020116 | 2020116 | 2021-12-16 | Adams | North Dakota | 38001 | 459 | 8 |
2016865 | 2016865 | 2021-12-15 | Adams | North Dakota | 38001 | 458 | 8 |
2013615 | 2013615 | 2021-12-14 | Adams | North Dakota | 38001 | 456 | 8 |
2010364 | 2010364 | 2021-12-13 | Adams | North Dakota | 38001 | 456 | 6 |
2007113 | 2007113 | 2021-12-12 | Adams | North Dakota | 38001 | 456 | 6 |
2003862 | 2003862 | 2021-12-11 | Adams | North Dakota | 38001 | 456 | 6 |
2000611 | 2000611 | 2021-12-10 | Adams | North Dakota | 38001 | 454 | 6 |
1997361 | 1997361 | 2021-12-09 | Adams | North Dakota | 38001 | 453 | 6 |
1994110 | 1994110 | 2021-12-08 | Adams | North Dakota | 38001 | 452 | 6 |
1990859 | 1990859 | 2021-12-07 | Adams | North Dakota | 38001 | 452 | 6 |
1987608 | 1987608 | 2021-12-06 | Adams | North Dakota | 38001 | 451 | 6 |
1984358 | 1984358 | 2021-12-05 | Adams | North Dakota | 38001 | 451 | 6 |
1981108 | 1981108 | 2021-12-04 | Adams | North Dakota | 38001 | 451 | 6 |
1977858 | 1977858 | 2021-12-03 | Adams | North Dakota | 38001 | 447 | 6 |
1974608 | 1974608 | 2021-12-02 | Adams | North Dakota | 38001 | 444 | 6 |
1971359 | 1971359 | 2021-12-01 | Adams | North Dakota | 38001 | 442 | 6 |
1968109 | 1968109 | 2021-11-30 | Adams | North Dakota | 38001 | 441 | 6 |
1964858 | 1964858 | 2021-11-29 | Adams | North Dakota | 38001 | 440 | 5 |
1961606 | 1961606 | 2021-11-28 | Adams | North Dakota | 38001 | 440 | 5 |
1958355 | 1958355 | 2021-11-27 | Adams | North Dakota | 38001 | 439 | 5 |
1955104 | 1955104 | 2021-11-26 | Adams | North Dakota | 38001 | 439 | 5 |
1951853 | 1951853 | 2021-11-25 | Adams | North Dakota | 38001 | 439 | 5 |
1948602 | 1948602 | 2021-11-24 | Adams | North Dakota | 38001 | 437 | 5 |
1945351 | 1945351 | 2021-11-23 | Adams | North Dakota | 38001 | 434 | 5 |
1942100 | 1942100 | 2021-11-22 | Adams | North Dakota | 38001 | 432 | 5 |
1938850 | 1938850 | 2021-11-21 | Adams | North Dakota | 38001 | 431 | 5 |
1935600 | 1935600 | 2021-11-20 | Adams | North Dakota | 38001 | 431 | 5 |
1932350 | 1932350 | 2021-11-19 | Adams | North Dakota | 38001 | 429 | 5 |
1929099 | 1929099 | 2021-11-18 | Adams | North Dakota | 38001 | 424 | 5 |
1925849 | 1925849 | 2021-11-17 | Adams | North Dakota | 38001 | 421 | 5 |
1922600 | 1922600 | 2021-11-16 | Adams | North Dakota | 38001 | 419 | 5 |
1919350 | 1919350 | 2021-11-15 | Adams | North Dakota | 38001 | 415 | 5 |
1916100 | 1916100 | 2021-11-14 | Adams | North Dakota | 38001 | 415 | 5 |
1912850 | 1912850 | 2021-11-13 | Adams | North Dakota | 38001 | 415 | 5 |
1909600 | 1909600 | 2021-11-12 | Adams | North Dakota | 38001 | 412 | 5 |
1906351 | 1906351 | 2021-11-11 | Adams | North Dakota | 38001 | 412 | 5 |
1903102 | 1903102 | 2021-11-10 | Adams | North Dakota | 38001 | 409 | 5 |
1899852 | 1899852 | 2021-11-09 | Adams | North Dakota | 38001 | 402 | 5 |
1896602 | 1896602 | 2021-11-08 | Adams | North Dakota | 38001 | 399 | 5 |
1893352 | 1893352 | 2021-11-07 | Adams | North Dakota | 38001 | 399 | 5 |
1890102 | 1890102 | 2021-11-06 | Adams | North Dakota | 38001 | 398 | 5 |
1886852 | 1886852 | 2021-11-05 | Adams | North Dakota | 38001 | 395 | 4 |
1883603 | 1883603 | 2021-11-04 | Adams | North Dakota | 38001 | 394 | 4 |
1880354 | 1880354 | 2021-11-03 | Adams | North Dakota | 38001 | 392 | 4 |
1877105 | 1877105 | 2021-11-02 | Adams | North Dakota | 38001 | 392 | 4 |
1873856 | 1873856 | 2021-11-01 | Adams | North Dakota | 38001 | 391 | 4 |
1870607 | 1870607 | 2021-10-31 | Adams | North Dakota | 38001 | 391 | 4 |
1867358 | 1867358 | 2021-10-30 | Adams | North Dakota | 38001 | 390 | 4 |
1864109 | 1864109 | 2021-10-29 | Adams | North Dakota | 38001 | 389 | 4 |
1860860 | 1860860 | 2021-10-28 | Adams | North Dakota | 38001 | 388 | 4 |
1857611 | 1857611 | 2021-10-27 | Adams | North Dakota | 38001 | 384 | 4 |
1854362 | 1854362 | 2021-10-26 | Adams | North Dakota | 38001 | 384 | 4 |
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);