ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Emmons" 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 |
---|---|---|---|---|---|---|---|
1948616 | 1948616 | 2021-11-24 | Emmons | North Dakota | 38029 | 581 | 16 |
1945365 | 1945365 | 2021-11-23 | Emmons | North Dakota | 38029 | 582 | 16 |
1942114 | 1942114 | 2021-11-22 | Emmons | North Dakota | 38029 | 580 | 16 |
1938864 | 1938864 | 2021-11-21 | Emmons | North Dakota | 38029 | 577 | 16 |
1935614 | 1935614 | 2021-11-20 | Emmons | North Dakota | 38029 | 577 | 16 |
1932364 | 1932364 | 2021-11-19 | Emmons | North Dakota | 38029 | 572 | 16 |
1929113 | 1929113 | 2021-11-18 | Emmons | North Dakota | 38029 | 571 | 16 |
1925863 | 1925863 | 2021-11-17 | Emmons | North Dakota | 38029 | 570 | 16 |
1922614 | 1922614 | 2021-11-16 | Emmons | North Dakota | 38029 | 568 | 16 |
1919364 | 1919364 | 2021-11-15 | Emmons | North Dakota | 38029 | 567 | 16 |
1916114 | 1916114 | 2021-11-14 | Emmons | North Dakota | 38029 | 567 | 16 |
1912864 | 1912864 | 2021-11-13 | Emmons | North Dakota | 38029 | 567 | 16 |
1909614 | 1909614 | 2021-11-12 | Emmons | North Dakota | 38029 | 566 | 16 |
1906365 | 1906365 | 2021-11-11 | Emmons | North Dakota | 38029 | 566 | 16 |
1903116 | 1903116 | 2021-11-10 | Emmons | North Dakota | 38029 | 563 | 16 |
1899866 | 1899866 | 2021-11-09 | Emmons | North Dakota | 38029 | 562 | 16 |
1896616 | 1896616 | 2021-11-08 | Emmons | North Dakota | 38029 | 559 | 16 |
1893366 | 1893366 | 2021-11-07 | Emmons | North Dakota | 38029 | 558 | 16 |
1890116 | 1890116 | 2021-11-06 | Emmons | North Dakota | 38029 | 556 | 16 |
1886866 | 1886866 | 2021-11-05 | Emmons | North Dakota | 38029 | 554 | 16 |
1883617 | 1883617 | 2021-11-04 | Emmons | North Dakota | 38029 | 552 | 16 |
1880368 | 1880368 | 2021-11-03 | Emmons | North Dakota | 38029 | 552 | 15 |
1877119 | 1877119 | 2021-11-02 | Emmons | North Dakota | 38029 | 550 | 15 |
1873870 | 1873870 | 2021-11-01 | Emmons | North Dakota | 38029 | 550 | 15 |
1870621 | 1870621 | 2021-10-31 | Emmons | North Dakota | 38029 | 550 | 15 |
1867372 | 1867372 | 2021-10-30 | Emmons | North Dakota | 38029 | 550 | 15 |
1864123 | 1864123 | 2021-10-29 | Emmons | North Dakota | 38029 | 548 | 15 |
1860874 | 1860874 | 2021-10-28 | Emmons | North Dakota | 38029 | 545 | 15 |
1857625 | 1857625 | 2021-10-27 | Emmons | North Dakota | 38029 | 544 | 15 |
1854376 | 1854376 | 2021-10-26 | Emmons | North Dakota | 38029 | 544 | 15 |
1851127 | 1851127 | 2021-10-25 | Emmons | North Dakota | 38029 | 542 | 15 |
1847877 | 1847877 | 2021-10-24 | Emmons | North Dakota | 38029 | 540 | 15 |
1844627 | 1844627 | 2021-10-23 | Emmons | North Dakota | 38029 | 540 | 15 |
1841377 | 1841377 | 2021-10-22 | Emmons | North Dakota | 38029 | 539 | 15 |
1838128 | 1838128 | 2021-10-21 | Emmons | North Dakota | 38029 | 539 | 15 |
1834879 | 1834879 | 2021-10-20 | Emmons | North Dakota | 38029 | 538 | 15 |
1831630 | 1831630 | 2021-10-19 | Emmons | North Dakota | 38029 | 538 | 15 |
1828381 | 1828381 | 2021-10-18 | Emmons | North Dakota | 38029 | 539 | 15 |
1825132 | 1825132 | 2021-10-17 | Emmons | North Dakota | 38029 | 538 | 15 |
1821883 | 1821883 | 2021-10-16 | Emmons | North Dakota | 38029 | 538 | 15 |
1818634 | 1818634 | 2021-10-15 | Emmons | North Dakota | 38029 | 535 | 15 |
1815385 | 1815385 | 2021-10-14 | Emmons | North Dakota | 38029 | 532 | 15 |
1812137 | 1812137 | 2021-10-13 | Emmons | North Dakota | 38029 | 532 | 15 |
1808888 | 1808888 | 2021-10-12 | Emmons | North Dakota | 38029 | 531 | 14 |
1805637 | 1805637 | 2021-10-11 | Emmons | North Dakota | 38029 | 531 | 14 |
1802388 | 1802388 | 2021-10-10 | Emmons | North Dakota | 38029 | 531 | 14 |
1799139 | 1799139 | 2021-10-09 | Emmons | North Dakota | 38029 | 531 | 14 |
1795890 | 1795890 | 2021-10-08 | Emmons | North Dakota | 38029 | 531 | 14 |
1792641 | 1792641 | 2021-10-07 | Emmons | North Dakota | 38029 | 531 | 14 |
1789392 | 1789392 | 2021-10-06 | Emmons | North Dakota | 38029 | 530 | 14 |
1786144 | 1786144 | 2021-10-05 | Emmons | North Dakota | 38029 | 530 | 14 |
1782895 | 1782895 | 2021-10-04 | Emmons | North Dakota | 38029 | 530 | 14 |
1779646 | 1779646 | 2021-10-03 | Emmons | North Dakota | 38029 | 530 | 14 |
1776396 | 1776396 | 2021-10-02 | Emmons | North Dakota | 38029 | 530 | 14 |
1773146 | 1773146 | 2021-10-01 | Emmons | North Dakota | 38029 | 528 | 14 |
1769896 | 1769896 | 2021-09-30 | Emmons | North Dakota | 38029 | 528 | 14 |
1766647 | 1766647 | 2021-09-29 | Emmons | North Dakota | 38029 | 523 | 14 |
1763398 | 1763398 | 2021-09-28 | Emmons | North Dakota | 38029 | 523 | 14 |
1760149 | 1760149 | 2021-09-27 | Emmons | North Dakota | 38029 | 522 | 14 |
1756901 | 1756901 | 2021-09-26 | Emmons | North Dakota | 38029 | 521 | 14 |
1753653 | 1753653 | 2021-09-25 | Emmons | North Dakota | 38029 | 521 | 14 |
1750405 | 1750405 | 2021-09-24 | Emmons | North Dakota | 38029 | 521 | 14 |
1747155 | 1747155 | 2021-09-23 | Emmons | North Dakota | 38029 | 513 | 14 |
1743906 | 1743906 | 2021-09-22 | Emmons | North Dakota | 38029 | 513 | 14 |
1740657 | 1740657 | 2021-09-21 | Emmons | North Dakota | 38029 | 513 | 14 |
1737408 | 1737408 | 2021-09-20 | Emmons | North Dakota | 38029 | 512 | 14 |
1734158 | 1734158 | 2021-09-19 | Emmons | North Dakota | 38029 | 511 | 14 |
1730908 | 1730908 | 2021-09-18 | Emmons | North Dakota | 38029 | 511 | 14 |
1727658 | 1727658 | 2021-09-17 | Emmons | North Dakota | 38029 | 511 | 14 |
1724409 | 1724409 | 2021-09-16 | Emmons | North Dakota | 38029 | 510 | 14 |
1721160 | 1721160 | 2021-09-15 | Emmons | North Dakota | 38029 | 507 | 14 |
1717912 | 1717912 | 2021-09-14 | Emmons | North Dakota | 38029 | 503 | 14 |
1714664 | 1714664 | 2021-09-13 | Emmons | North Dakota | 38029 | 503 | 14 |
1711418 | 1711418 | 2021-09-12 | Emmons | North Dakota | 38029 | 503 | 14 |
1708171 | 1708171 | 2021-09-11 | Emmons | North Dakota | 38029 | 502 | 14 |
1704924 | 1704924 | 2021-09-10 | Emmons | North Dakota | 38029 | 500 | 14 |
1701674 | 1701674 | 2021-09-09 | Emmons | North Dakota | 38029 | 494 | 14 |
1698425 | 1698425 | 2021-09-08 | Emmons | North Dakota | 38029 | 490 | 14 |
1695177 | 1695177 | 2021-09-07 | Emmons | North Dakota | 38029 | 488 | 14 |
1691929 | 1691929 | 2021-09-06 | Emmons | North Dakota | 38029 | 488 | 14 |
1688679 | 1688679 | 2021-09-05 | Emmons | North Dakota | 38029 | 487 | 14 |
1685429 | 1685429 | 2021-09-04 | Emmons | North Dakota | 38029 | 485 | 14 |
1682178 | 1682178 | 2021-09-03 | Emmons | North Dakota | 38029 | 485 | 14 |
1678929 | 1678929 | 2021-09-02 | Emmons | North Dakota | 38029 | 485 | 14 |
1675681 | 1675681 | 2021-09-01 | Emmons | North Dakota | 38029 | 484 | 14 |
1672434 | 1672434 | 2021-08-31 | Emmons | North Dakota | 38029 | 482 | 14 |
1669186 | 1669186 | 2021-08-30 | Emmons | North Dakota | 38029 | 479 | 14 |
1665939 | 1665939 | 2021-08-29 | Emmons | North Dakota | 38029 | 479 | 14 |
1662691 | 1662691 | 2021-08-28 | Emmons | North Dakota | 38029 | 476 | 14 |
1659443 | 1659443 | 2021-08-27 | Emmons | North Dakota | 38029 | 473 | 14 |
1656194 | 1656194 | 2021-08-26 | Emmons | North Dakota | 38029 | 470 | 13 |
1652947 | 1652947 | 2021-08-25 | Emmons | North Dakota | 38029 | 467 | 13 |
1649699 | 1649699 | 2021-08-24 | Emmons | North Dakota | 38029 | 463 | 13 |
1646450 | 1646450 | 2021-08-23 | Emmons | North Dakota | 38029 | 462 | 13 |
1643201 | 1643201 | 2021-08-22 | Emmons | North Dakota | 38029 | 460 | 13 |
1639951 | 1639951 | 2021-08-21 | Emmons | North Dakota | 38029 | 459 | 13 |
1636701 | 1636701 | 2021-08-20 | Emmons | North Dakota | 38029 | 455 | 13 |
1633451 | 1633451 | 2021-08-19 | Emmons | North Dakota | 38029 | 453 | 13 |
1630204 | 1630204 | 2021-08-18 | Emmons | North Dakota | 38029 | 447 | 13 |
1626957 | 1626957 | 2021-08-17 | Emmons | North Dakota | 38029 | 445 | 13 |
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);