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 |
---|---|---|---|---|---|---|---|
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 |
1623701 | 1623701 | 2021-08-16 | Bowman | North Dakota | 38011 | 416 | 5 |
1620454 | 1620454 | 2021-08-15 | Bowman | North Dakota | 38011 | 416 | 5 |
1617206 | 1617206 | 2021-08-14 | Bowman | North Dakota | 38011 | 414 | 5 |
1613958 | 1613958 | 2021-08-13 | Bowman | North Dakota | 38011 | 414 | 5 |
1610709 | 1610709 | 2021-08-12 | Bowman | North Dakota | 38011 | 411 | 5 |
1607461 | 1607461 | 2021-08-11 | Bowman | North Dakota | 38011 | 411 | 5 |
1604212 | 1604212 | 2021-08-10 | Bowman | North Dakota | 38011 | 411 | 5 |
1600963 | 1600963 | 2021-08-09 | Bowman | North Dakota | 38011 | 411 | 5 |
1597715 | 1597715 | 2021-08-08 | Bowman | North Dakota | 38011 | 411 | 5 |
1594466 | 1594466 | 2021-08-07 | Bowman | North Dakota | 38011 | 411 | 5 |
1591217 | 1591217 | 2021-08-06 | Bowman | North Dakota | 38011 | 410 | 5 |
1587968 | 1587968 | 2021-08-05 | Bowman | North Dakota | 38011 | 409 | 5 |
1584718 | 1584718 | 2021-08-04 | Bowman | North Dakota | 38011 | 408 | 5 |
1581468 | 1581468 | 2021-08-03 | Bowman | North Dakota | 38011 | 408 | 5 |
1578219 | 1578219 | 2021-08-02 | Bowman | North Dakota | 38011 | 408 | 5 |
1574971 | 1574971 | 2021-08-01 | Bowman | North Dakota | 38011 | 408 | 5 |
1571723 | 1571723 | 2021-07-31 | Bowman | North Dakota | 38011 | 408 | 5 |
1568475 | 1568475 | 2021-07-30 | Bowman | North Dakota | 38011 | 408 | 5 |
1565227 | 1565227 | 2021-07-29 | Bowman | North Dakota | 38011 | 408 | 5 |
1561979 | 1561979 | 2021-07-28 | Bowman | North Dakota | 38011 | 408 | 5 |
1558731 | 1558731 | 2021-07-27 | Bowman | North Dakota | 38011 | 408 | 5 |
1555484 | 1555484 | 2021-07-26 | Bowman | North Dakota | 38011 | 408 | 5 |
1552237 | 1552237 | 2021-07-25 | Bowman | North Dakota | 38011 | 408 | 5 |
1548990 | 1548990 | 2021-07-24 | Bowman | North Dakota | 38011 | 408 | 5 |
1545743 | 1545743 | 2021-07-23 | Bowman | North Dakota | 38011 | 408 | 5 |
1542496 | 1542496 | 2021-07-22 | Bowman | North Dakota | 38011 | 408 | 5 |
1539248 | 1539248 | 2021-07-21 | Bowman | North Dakota | 38011 | 408 | 5 |
1536001 | 1536001 | 2021-07-20 | Bowman | North Dakota | 38011 | 408 | 5 |
1532753 | 1532753 | 2021-07-19 | Bowman | North Dakota | 38011 | 408 | 5 |
1529506 | 1529506 | 2021-07-18 | Bowman | North Dakota | 38011 | 408 | 5 |
1526259 | 1526259 | 2021-07-17 | Bowman | North Dakota | 38011 | 408 | 5 |
1523012 | 1523012 | 2021-07-16 | Bowman | North Dakota | 38011 | 408 | 5 |
1519764 | 1519764 | 2021-07-15 | Bowman | North Dakota | 38011 | 408 | 5 |
1516516 | 1516516 | 2021-07-14 | Bowman | North Dakota | 38011 | 407 | 5 |
1513269 | 1513269 | 2021-07-13 | Bowman | North Dakota | 38011 | 408 | 5 |
1510023 | 1510023 | 2021-07-12 | Bowman | North Dakota | 38011 | 408 | 5 |
1506776 | 1506776 | 2021-07-11 | Bowman | North Dakota | 38011 | 408 | 5 |
1503530 | 1503530 | 2021-07-10 | Bowman | North Dakota | 38011 | 408 | 5 |
1500284 | 1500284 | 2021-07-09 | Bowman | North Dakota | 38011 | 408 | 5 |
1497038 | 1497038 | 2021-07-08 | Bowman | North Dakota | 38011 | 408 | 5 |
1493791 | 1493791 | 2021-07-07 | Bowman | North Dakota | 38011 | 408 | 5 |
1490544 | 1490544 | 2021-07-06 | Bowman | North Dakota | 38011 | 408 | 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);