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 |
---|---|---|---|---|---|---|---|
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 |
1623721 | 1623721 | 2021-08-16 | McIntosh | North Dakota | 38051 | 356 | 7 |
1620474 | 1620474 | 2021-08-15 | McIntosh | North Dakota | 38051 | 356 | 7 |
1617226 | 1617226 | 2021-08-14 | McIntosh | North Dakota | 38051 | 356 | 7 |
1613978 | 1613978 | 2021-08-13 | McIntosh | North Dakota | 38051 | 356 | 7 |
1610729 | 1610729 | 2021-08-12 | McIntosh | North Dakota | 38051 | 355 | 7 |
1607481 | 1607481 | 2021-08-11 | McIntosh | North Dakota | 38051 | 354 | 7 |
1604232 | 1604232 | 2021-08-10 | McIntosh | North Dakota | 38051 | 354 | 7 |
1600983 | 1600983 | 2021-08-09 | McIntosh | North Dakota | 38051 | 354 | 7 |
1597735 | 1597735 | 2021-08-08 | McIntosh | North Dakota | 38051 | 354 | 7 |
1594486 | 1594486 | 2021-08-07 | McIntosh | North Dakota | 38051 | 354 | 7 |
1591237 | 1591237 | 2021-08-06 | McIntosh | North Dakota | 38051 | 353 | 7 |
1587988 | 1587988 | 2021-08-05 | McIntosh | North Dakota | 38051 | 353 | 7 |
1584738 | 1584738 | 2021-08-04 | McIntosh | North Dakota | 38051 | 353 | 7 |
1581488 | 1581488 | 2021-08-03 | McIntosh | North Dakota | 38051 | 353 | 7 |
1578239 | 1578239 | 2021-08-02 | McIntosh | North Dakota | 38051 | 353 | 7 |
1574991 | 1574991 | 2021-08-01 | McIntosh | North Dakota | 38051 | 353 | 7 |
1571743 | 1571743 | 2021-07-31 | McIntosh | North Dakota | 38051 | 353 | 7 |
1568495 | 1568495 | 2021-07-30 | McIntosh | North Dakota | 38051 | 353 | 7 |
1565247 | 1565247 | 2021-07-29 | McIntosh | North Dakota | 38051 | 353 | 7 |
1561999 | 1561999 | 2021-07-28 | McIntosh | North Dakota | 38051 | 353 | 7 |
1558751 | 1558751 | 2021-07-27 | McIntosh | North Dakota | 38051 | 353 | 7 |
1555504 | 1555504 | 2021-07-26 | McIntosh | North Dakota | 38051 | 353 | 7 |
1552257 | 1552257 | 2021-07-25 | McIntosh | North Dakota | 38051 | 353 | 7 |
1549010 | 1549010 | 2021-07-24 | McIntosh | North Dakota | 38051 | 353 | 7 |
1545763 | 1545763 | 2021-07-23 | McIntosh | North Dakota | 38051 | 353 | 7 |
1542516 | 1542516 | 2021-07-22 | McIntosh | North Dakota | 38051 | 353 | 7 |
1539268 | 1539268 | 2021-07-21 | McIntosh | North Dakota | 38051 | 353 | 7 |
1536021 | 1536021 | 2021-07-20 | McIntosh | North Dakota | 38051 | 353 | 7 |
1532773 | 1532773 | 2021-07-19 | McIntosh | North Dakota | 38051 | 353 | 7 |
1529526 | 1529526 | 2021-07-18 | McIntosh | North Dakota | 38051 | 353 | 7 |
1526279 | 1526279 | 2021-07-17 | McIntosh | North Dakota | 38051 | 353 | 7 |
1523032 | 1523032 | 2021-07-16 | McIntosh | North Dakota | 38051 | 353 | 7 |
1519784 | 1519784 | 2021-07-15 | McIntosh | North Dakota | 38051 | 353 | 7 |
1516536 | 1516536 | 2021-07-14 | McIntosh | North Dakota | 38051 | 353 | 7 |
1513289 | 1513289 | 2021-07-13 | McIntosh | North Dakota | 38051 | 354 | 7 |
1510043 | 1510043 | 2021-07-12 | McIntosh | North Dakota | 38051 | 354 | 7 |
1506796 | 1506796 | 2021-07-11 | McIntosh | North Dakota | 38051 | 354 | 7 |
1503550 | 1503550 | 2021-07-10 | McIntosh | North Dakota | 38051 | 354 | 7 |
1500304 | 1500304 | 2021-07-09 | McIntosh | North Dakota | 38051 | 354 | 7 |
1497058 | 1497058 | 2021-07-08 | McIntosh | North Dakota | 38051 | 354 | 7 |
1493811 | 1493811 | 2021-07-07 | McIntosh | North Dakota | 38051 | 354 | 7 |
1490564 | 1490564 | 2021-07-06 | McIntosh | North Dakota | 38051 | 354 | 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);