ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "McIntosh" 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 |
---|---|---|---|---|---|---|---|
1948627 | 1948627 | 2021-11-24 | McIntosh | North Dakota | 38051 | 508 | 9 |
1945376 | 1945376 | 2021-11-23 | McIntosh | North Dakota | 38051 | 506 | 9 |
1942125 | 1942125 | 2021-11-22 | McIntosh | North Dakota | 38051 | 505 | 9 |
1938875 | 1938875 | 2021-11-21 | McIntosh | North Dakota | 38051 | 504 | 9 |
1935625 | 1935625 | 2021-11-20 | McIntosh | North Dakota | 38051 | 504 | 9 |
1932375 | 1932375 | 2021-11-19 | McIntosh | North Dakota | 38051 | 502 | 8 |
1929124 | 1929124 | 2021-11-18 | McIntosh | North Dakota | 38051 | 500 | 8 |
1925874 | 1925874 | 2021-11-17 | McIntosh | North Dakota | 38051 | 498 | 8 |
1922625 | 1922625 | 2021-11-16 | McIntosh | North Dakota | 38051 | 496 | 8 |
1919375 | 1919375 | 2021-11-15 | McIntosh | North Dakota | 38051 | 496 | 8 |
1916125 | 1916125 | 2021-11-14 | McIntosh | North Dakota | 38051 | 496 | 8 |
1912875 | 1912875 | 2021-11-13 | McIntosh | North Dakota | 38051 | 496 | 8 |
1909625 | 1909625 | 2021-11-12 | McIntosh | North Dakota | 38051 | 495 | 8 |
1906376 | 1906376 | 2021-11-11 | McIntosh | North Dakota | 38051 | 490 | 8 |
1903127 | 1903127 | 2021-11-10 | McIntosh | North Dakota | 38051 | 487 | 8 |
1899877 | 1899877 | 2021-11-09 | McIntosh | North Dakota | 38051 | 484 | 8 |
1896627 | 1896627 | 2021-11-08 | McIntosh | North Dakota | 38051 | 483 | 8 |
1893377 | 1893377 | 2021-11-07 | McIntosh | North Dakota | 38051 | 483 | 8 |
1890127 | 1890127 | 2021-11-06 | McIntosh | North Dakota | 38051 | 482 | 8 |
1886877 | 1886877 | 2021-11-05 | McIntosh | North Dakota | 38051 | 480 | 8 |
1883628 | 1883628 | 2021-11-04 | McIntosh | North Dakota | 38051 | 474 | 8 |
1880379 | 1880379 | 2021-11-03 | McIntosh | North Dakota | 38051 | 474 | 8 |
1877130 | 1877130 | 2021-11-02 | McIntosh | North Dakota | 38051 | 469 | 8 |
1873881 | 1873881 | 2021-11-01 | McIntosh | North Dakota | 38051 | 465 | 8 |
1870632 | 1870632 | 2021-10-31 | McIntosh | North Dakota | 38051 | 464 | 8 |
1867383 | 1867383 | 2021-10-30 | McIntosh | North Dakota | 38051 | 457 | 8 |
1864134 | 1864134 | 2021-10-29 | McIntosh | North Dakota | 38051 | 457 | 8 |
1860885 | 1860885 | 2021-10-28 | McIntosh | North Dakota | 38051 | 457 | 8 |
1857636 | 1857636 | 2021-10-27 | McIntosh | North Dakota | 38051 | 456 | 8 |
1854387 | 1854387 | 2021-10-26 | McIntosh | North Dakota | 38051 | 456 | 8 |
1851138 | 1851138 | 2021-10-25 | McIntosh | North Dakota | 38051 | 455 | 8 |
1847888 | 1847888 | 2021-10-24 | McIntosh | North Dakota | 38051 | 454 | 8 |
1844638 | 1844638 | 2021-10-23 | McIntosh | North Dakota | 38051 | 454 | 8 |
1841388 | 1841388 | 2021-10-22 | McIntosh | North Dakota | 38051 | 453 | 8 |
1838139 | 1838139 | 2021-10-21 | McIntosh | North Dakota | 38051 | 452 | 8 |
1834890 | 1834890 | 2021-10-20 | McIntosh | North Dakota | 38051 | 450 | 8 |
1831641 | 1831641 | 2021-10-19 | McIntosh | North Dakota | 38051 | 448 | 8 |
1828392 | 1828392 | 2021-10-18 | McIntosh | North Dakota | 38051 | 446 | 8 |
1825143 | 1825143 | 2021-10-17 | McIntosh | North Dakota | 38051 | 445 | 8 |
1821894 | 1821894 | 2021-10-16 | McIntosh | North Dakota | 38051 | 445 | 8 |
1818645 | 1818645 | 2021-10-15 | McIntosh | North Dakota | 38051 | 445 | 8 |
1815396 | 1815396 | 2021-10-14 | McIntosh | North Dakota | 38051 | 443 | 8 |
1812148 | 1812148 | 2021-10-13 | McIntosh | North Dakota | 38051 | 442 | 8 |
1808899 | 1808899 | 2021-10-12 | McIntosh | North Dakota | 38051 | 441 | 8 |
1805648 | 1805648 | 2021-10-11 | McIntosh | North Dakota | 38051 | 438 | 8 |
1802399 | 1802399 | 2021-10-10 | McIntosh | North Dakota | 38051 | 438 | 8 |
1799150 | 1799150 | 2021-10-09 | McIntosh | North Dakota | 38051 | 438 | 8 |
1795901 | 1795901 | 2021-10-08 | McIntosh | North Dakota | 38051 | 438 | 8 |
1792652 | 1792652 | 2021-10-07 | McIntosh | North Dakota | 38051 | 435 | 8 |
1789403 | 1789403 | 2021-10-06 | McIntosh | North Dakota | 38051 | 432 | 8 |
1786155 | 1786155 | 2021-10-05 | McIntosh | North Dakota | 38051 | 430 | 8 |
1782906 | 1782906 | 2021-10-04 | McIntosh | North Dakota | 38051 | 429 | 8 |
1779657 | 1779657 | 2021-10-03 | McIntosh | North Dakota | 38051 | 429 | 8 |
1776407 | 1776407 | 2021-10-02 | McIntosh | North Dakota | 38051 | 429 | 8 |
1773157 | 1773157 | 2021-10-01 | McIntosh | North Dakota | 38051 | 428 | 8 |
1769907 | 1769907 | 2021-09-30 | McIntosh | North Dakota | 38051 | 426 | 8 |
1766658 | 1766658 | 2021-09-29 | McIntosh | North Dakota | 38051 | 425 | 7 |
1763409 | 1763409 | 2021-09-28 | McIntosh | North Dakota | 38051 | 425 | 7 |
1760160 | 1760160 | 2021-09-27 | McIntosh | North Dakota | 38051 | 423 | 7 |
1756912 | 1756912 | 2021-09-26 | McIntosh | North Dakota | 38051 | 423 | 7 |
1753664 | 1753664 | 2021-09-25 | McIntosh | North Dakota | 38051 | 423 | 7 |
1750416 | 1750416 | 2021-09-24 | McIntosh | North Dakota | 38051 | 421 | 7 |
1747166 | 1747166 | 2021-09-23 | McIntosh | North Dakota | 38051 | 420 | 7 |
1743917 | 1743917 | 2021-09-22 | McIntosh | North Dakota | 38051 | 413 | 7 |
1740668 | 1740668 | 2021-09-21 | McIntosh | North Dakota | 38051 | 411 | 7 |
1737419 | 1737419 | 2021-09-20 | McIntosh | North Dakota | 38051 | 408 | 7 |
1734169 | 1734169 | 2021-09-19 | McIntosh | North Dakota | 38051 | 408 | 7 |
1730919 | 1730919 | 2021-09-18 | McIntosh | North Dakota | 38051 | 410 | 7 |
1727669 | 1727669 | 2021-09-17 | McIntosh | North Dakota | 38051 | 407 | 7 |
1724420 | 1724420 | 2021-09-16 | McIntosh | North Dakota | 38051 | 401 | 7 |
1721171 | 1721171 | 2021-09-15 | McIntosh | North Dakota | 38051 | 398 | 7 |
1717923 | 1717923 | 2021-09-14 | McIntosh | North Dakota | 38051 | 392 | 7 |
1714675 | 1714675 | 2021-09-13 | McIntosh | North Dakota | 38051 | 391 | 7 |
1711429 | 1711429 | 2021-09-12 | McIntosh | North Dakota | 38051 | 391 | 7 |
1708182 | 1708182 | 2021-09-11 | McIntosh | North Dakota | 38051 | 390 | 7 |
1704935 | 1704935 | 2021-09-10 | McIntosh | North Dakota | 38051 | 382 | 7 |
1701685 | 1701685 | 2021-09-09 | McIntosh | North Dakota | 38051 | 376 | 7 |
1698436 | 1698436 | 2021-09-08 | McIntosh | North Dakota | 38051 | 372 | 7 |
1695188 | 1695188 | 2021-09-07 | McIntosh | North Dakota | 38051 | 368 | 7 |
1691940 | 1691940 | 2021-09-06 | McIntosh | North Dakota | 38051 | 368 | 7 |
1688690 | 1688690 | 2021-09-05 | McIntosh | North Dakota | 38051 | 368 | 7 |
1685440 | 1685440 | 2021-09-04 | McIntosh | North Dakota | 38051 | 365 | 7 |
1682189 | 1682189 | 2021-09-03 | McIntosh | North Dakota | 38051 | 364 | 7 |
1678940 | 1678940 | 2021-09-02 | McIntosh | North Dakota | 38051 | 364 | 7 |
1675692 | 1675692 | 2021-09-01 | McIntosh | North Dakota | 38051 | 360 | 7 |
1672445 | 1672445 | 2021-08-31 | McIntosh | North Dakota | 38051 | 359 | 7 |
1669197 | 1669197 | 2021-08-30 | McIntosh | North Dakota | 38051 | 360 | 7 |
1665950 | 1665950 | 2021-08-29 | McIntosh | North Dakota | 38051 | 360 | 7 |
1662702 | 1662702 | 2021-08-28 | McIntosh | North Dakota | 38051 | 359 | 7 |
1659454 | 1659454 | 2021-08-27 | McIntosh | North Dakota | 38051 | 359 | 7 |
1656205 | 1656205 | 2021-08-26 | McIntosh | North Dakota | 38051 | 358 | 7 |
1652958 | 1652958 | 2021-08-25 | McIntosh | North Dakota | 38051 | 356 | 7 |
1649710 | 1649710 | 2021-08-24 | McIntosh | North Dakota | 38051 | 356 | 7 |
1646461 | 1646461 | 2021-08-23 | McIntosh | North Dakota | 38051 | 356 | 7 |
1643212 | 1643212 | 2021-08-22 | McIntosh | North Dakota | 38051 | 356 | 7 |
1639962 | 1639962 | 2021-08-21 | McIntosh | North Dakota | 38051 | 356 | 7 |
1636712 | 1636712 | 2021-08-20 | McIntosh | North Dakota | 38051 | 356 | 7 |
1633462 | 1633462 | 2021-08-19 | McIntosh | North Dakota | 38051 | 356 | 7 |
1630215 | 1630215 | 2021-08-18 | McIntosh | North Dakota | 38051 | 356 | 7 |
1626968 | 1626968 | 2021-08-17 | McIntosh | North Dakota | 38051 | 356 | 7 |
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);