ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 38011 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 |
---|---|---|---|---|---|---|---|
1948607 | 1948607 | 2021-11-24 | Bowman | North Dakota | 38011 | 652 | 8 |
1945356 | 1945356 | 2021-11-23 | Bowman | North Dakota | 38011 | 648 | 8 |
1942105 | 1942105 | 2021-11-22 | Bowman | North Dakota | 38011 | 645 | 8 |
1938855 | 1938855 | 2021-11-21 | Bowman | North Dakota | 38011 | 645 | 8 |
1935605 | 1935605 | 2021-11-20 | Bowman | North Dakota | 38011 | 644 | 8 |
1932355 | 1932355 | 2021-11-19 | Bowman | North Dakota | 38011 | 641 | 8 |
1929104 | 1929104 | 2021-11-18 | Bowman | North Dakota | 38011 | 639 | 8 |
1925854 | 1925854 | 2021-11-17 | Bowman | North Dakota | 38011 | 637 | 8 |
1922605 | 1922605 | 2021-11-16 | Bowman | North Dakota | 38011 | 636 | 8 |
1919355 | 1919355 | 2021-11-15 | Bowman | North Dakota | 38011 | 634 | 8 |
1916105 | 1916105 | 2021-11-14 | Bowman | North Dakota | 38011 | 634 | 8 |
1912855 | 1912855 | 2021-11-13 | Bowman | North Dakota | 38011 | 633 | 8 |
1909605 | 1909605 | 2021-11-12 | Bowman | North Dakota | 38011 | 633 | 8 |
1906356 | 1906356 | 2021-11-11 | Bowman | North Dakota | 38011 | 633 | 8 |
1903107 | 1903107 | 2021-11-10 | Bowman | North Dakota | 38011 | 630 | 8 |
1899857 | 1899857 | 2021-11-09 | Bowman | North Dakota | 38011 | 629 | 8 |
1896607 | 1896607 | 2021-11-08 | Bowman | North Dakota | 38011 | 627 | 8 |
1893357 | 1893357 | 2021-11-07 | Bowman | North Dakota | 38011 | 625 | 8 |
1890107 | 1890107 | 2021-11-06 | Bowman | North Dakota | 38011 | 625 | 8 |
1886857 | 1886857 | 2021-11-05 | Bowman | North Dakota | 38011 | 617 | 8 |
1883608 | 1883608 | 2021-11-04 | Bowman | North Dakota | 38011 | 614 | 8 |
1880359 | 1880359 | 2021-11-03 | Bowman | North Dakota | 38011 | 610 | 8 |
1877110 | 1877110 | 2021-11-02 | Bowman | North Dakota | 38011 | 608 | 7 |
1873861 | 1873861 | 2021-11-01 | Bowman | North Dakota | 38011 | 605 | 7 |
1870612 | 1870612 | 2021-10-31 | Bowman | North Dakota | 38011 | 605 | 7 |
1867363 | 1867363 | 2021-10-30 | Bowman | North Dakota | 38011 | 601 | 7 |
1864114 | 1864114 | 2021-10-29 | Bowman | North Dakota | 38011 | 600 | 7 |
1860865 | 1860865 | 2021-10-28 | Bowman | North Dakota | 38011 | 598 | 7 |
1857616 | 1857616 | 2021-10-27 | Bowman | North Dakota | 38011 | 592 | 7 |
1854367 | 1854367 | 2021-10-26 | Bowman | North Dakota | 38011 | 590 | 7 |
1851118 | 1851118 | 2021-10-25 | Bowman | North Dakota | 38011 | 585 | 7 |
1847868 | 1847868 | 2021-10-24 | Bowman | North Dakota | 38011 | 583 | 7 |
1844618 | 1844618 | 2021-10-23 | Bowman | North Dakota | 38011 | 580 | 7 |
1841368 | 1841368 | 2021-10-22 | Bowman | North Dakota | 38011 | 578 | 7 |
1838119 | 1838119 | 2021-10-21 | Bowman | North Dakota | 38011 | 569 | 7 |
1834870 | 1834870 | 2021-10-20 | Bowman | North Dakota | 38011 | 560 | 7 |
1831621 | 1831621 | 2021-10-19 | Bowman | North Dakota | 38011 | 557 | 7 |
1828372 | 1828372 | 2021-10-18 | Bowman | North Dakota | 38011 | 552 | 7 |
1825123 | 1825123 | 2021-10-17 | Bowman | North Dakota | 38011 | 551 | 7 |
1821874 | 1821874 | 2021-10-16 | Bowman | North Dakota | 38011 | 549 | 7 |
1818625 | 1818625 | 2021-10-15 | Bowman | North Dakota | 38011 | 546 | 7 |
1815376 | 1815376 | 2021-10-14 | Bowman | North Dakota | 38011 | 541 | 7 |
1812128 | 1812128 | 2021-10-13 | Bowman | North Dakota | 38011 | 538 | 7 |
1808879 | 1808879 | 2021-10-12 | Bowman | North Dakota | 38011 | 530 | 7 |
1805628 | 1805628 | 2021-10-11 | Bowman | North Dakota | 38011 | 525 | 7 |
1802379 | 1802379 | 2021-10-10 | Bowman | North Dakota | 38011 | 525 | 7 |
1799130 | 1799130 | 2021-10-09 | Bowman | North Dakota | 38011 | 522 | 7 |
1795881 | 1795881 | 2021-10-08 | Bowman | North Dakota | 38011 | 518 | 7 |
1792632 | 1792632 | 2021-10-07 | Bowman | North Dakota | 38011 | 514 | 7 |
1789383 | 1789383 | 2021-10-06 | Bowman | North Dakota | 38011 | 506 | 7 |
1786135 | 1786135 | 2021-10-05 | Bowman | North Dakota | 38011 | 503 | 7 |
1782886 | 1782886 | 2021-10-04 | Bowman | North Dakota | 38011 | 500 | 7 |
1779637 | 1779637 | 2021-10-03 | Bowman | North Dakota | 38011 | 499 | 7 |
1776387 | 1776387 | 2021-10-02 | Bowman | North Dakota | 38011 | 496 | 7 |
1773137 | 1773137 | 2021-10-01 | Bowman | North Dakota | 38011 | 492 | 6 |
1769887 | 1769887 | 2021-09-30 | Bowman | North Dakota | 38011 | 489 | 6 |
1766638 | 1766638 | 2021-09-29 | Bowman | North Dakota | 38011 | 488 | 6 |
1763389 | 1763389 | 2021-09-28 | Bowman | North Dakota | 38011 | 486 | 6 |
1760140 | 1760140 | 2021-09-27 | Bowman | North Dakota | 38011 | 483 | 6 |
1756892 | 1756892 | 2021-09-26 | Bowman | North Dakota | 38011 | 483 | 6 |
1753644 | 1753644 | 2021-09-25 | Bowman | North Dakota | 38011 | 483 | 6 |
1750396 | 1750396 | 2021-09-24 | Bowman | North Dakota | 38011 | 481 | 6 |
1747146 | 1747146 | 2021-09-23 | Bowman | North Dakota | 38011 | 479 | 6 |
1743897 | 1743897 | 2021-09-22 | Bowman | North Dakota | 38011 | 477 | 6 |
1740648 | 1740648 | 2021-09-21 | Bowman | North Dakota | 38011 | 477 | 6 |
1737399 | 1737399 | 2021-09-20 | Bowman | North Dakota | 38011 | 475 | 6 |
1734149 | 1734149 | 2021-09-19 | Bowman | North Dakota | 38011 | 475 | 6 |
1730899 | 1730899 | 2021-09-18 | Bowman | North Dakota | 38011 | 475 | 6 |
1727649 | 1727649 | 2021-09-17 | Bowman | North Dakota | 38011 | 474 | 6 |
1724400 | 1724400 | 2021-09-16 | Bowman | North Dakota | 38011 | 473 | 6 |
1721151 | 1721151 | 2021-09-15 | Bowman | North Dakota | 38011 | 470 | 6 |
1717903 | 1717903 | 2021-09-14 | Bowman | North Dakota | 38011 | 468 | 6 |
1714655 | 1714655 | 2021-09-13 | Bowman | North Dakota | 38011 | 468 | 5 |
1711409 | 1711409 | 2021-09-12 | Bowman | North Dakota | 38011 | 468 | 5 |
1708162 | 1708162 | 2021-09-11 | Bowman | North Dakota | 38011 | 465 | 5 |
1704915 | 1704915 | 2021-09-10 | Bowman | North Dakota | 38011 | 462 | 5 |
1701665 | 1701665 | 2021-09-09 | Bowman | North Dakota | 38011 | 457 | 5 |
1698416 | 1698416 | 2021-09-08 | Bowman | North Dakota | 38011 | 453 | 5 |
1695168 | 1695168 | 2021-09-07 | Bowman | North Dakota | 38011 | 447 | 5 |
1691920 | 1691920 | 2021-09-06 | Bowman | North Dakota | 38011 | 444 | 5 |
1688670 | 1688670 | 2021-09-05 | Bowman | North Dakota | 38011 | 444 | 5 |
1685420 | 1685420 | 2021-09-04 | Bowman | North Dakota | 38011 | 443 | 5 |
1682169 | 1682169 | 2021-09-03 | Bowman | North Dakota | 38011 | 441 | 5 |
1678920 | 1678920 | 2021-09-02 | Bowman | North Dakota | 38011 | 438 | 5 |
1675672 | 1675672 | 2021-09-01 | Bowman | North Dakota | 38011 | 433 | 5 |
1672425 | 1672425 | 2021-08-31 | Bowman | North Dakota | 38011 | 432 | 5 |
1669177 | 1669177 | 2021-08-30 | Bowman | North Dakota | 38011 | 426 | 5 |
1665930 | 1665930 | 2021-08-29 | Bowman | North Dakota | 38011 | 426 | 5 |
1662682 | 1662682 | 2021-08-28 | Bowman | North Dakota | 38011 | 426 | 5 |
1659434 | 1659434 | 2021-08-27 | Bowman | North Dakota | 38011 | 424 | 5 |
1656185 | 1656185 | 2021-08-26 | Bowman | North Dakota | 38011 | 423 | 5 |
1652938 | 1652938 | 2021-08-25 | Bowman | North Dakota | 38011 | 420 | 5 |
1649690 | 1649690 | 2021-08-24 | Bowman | North Dakota | 38011 | 418 | 5 |
1646441 | 1646441 | 2021-08-23 | Bowman | North Dakota | 38011 | 418 | 5 |
1643192 | 1643192 | 2021-08-22 | Bowman | North Dakota | 38011 | 418 | 5 |
1639942 | 1639942 | 2021-08-21 | Bowman | North Dakota | 38011 | 418 | 5 |
1636692 | 1636692 | 2021-08-20 | Bowman | North Dakota | 38011 | 418 | 5 |
1633442 | 1633442 | 2021-08-19 | Bowman | North Dakota | 38011 | 418 | 5 |
1630195 | 1630195 | 2021-08-18 | Bowman | North Dakota | 38011 | 418 | 5 |
1626948 | 1626948 | 2021-08-17 | Bowman | North Dakota | 38011 | 416 | 5 |
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);