ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Johnson" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840905 | 1840905 | 2021-10-22 | Johnson | Missouri | 29101 | 7145 | 73 |
1837656 | 1837656 | 2021-10-21 | Johnson | Missouri | 29101 | 7123 | 73 |
1834407 | 1834407 | 2021-10-20 | Johnson | Missouri | 29101 | 7100 | 73 |
1831158 | 1831158 | 2021-10-19 | Johnson | Missouri | 29101 | 7080 | 73 |
1827909 | 1827909 | 2021-10-18 | Johnson | Missouri | 29101 | 7062 | 72 |
1824660 | 1824660 | 2021-10-17 | Johnson | Missouri | 29101 | 7055 | 72 |
1821411 | 1821411 | 2021-10-16 | Johnson | Missouri | 29101 | 7054 | 72 |
1818162 | 1818162 | 2021-10-15 | Johnson | Missouri | 29101 | 7035 | 72 |
1814913 | 1814913 | 2021-10-14 | Johnson | Missouri | 29101 | 6979 | 72 |
1811665 | 1811665 | 2021-10-13 | Johnson | Missouri | 29101 | 6970 | 72 |
1808416 | 1808416 | 2021-10-12 | Johnson | Missouri | 29101 | 6964 | 70 |
1805165 | 1805165 | 2021-10-11 | Johnson | Missouri | 29101 | 6953 | 70 |
1801916 | 1801916 | 2021-10-10 | Johnson | Missouri | 29101 | 6950 | 70 |
1798667 | 1798667 | 2021-10-09 | Johnson | Missouri | 29101 | 6942 | 70 |
1795418 | 1795418 | 2021-10-08 | Johnson | Missouri | 29101 | 6935 | 70 |
1792169 | 1792169 | 2021-10-07 | Johnson | Missouri | 29101 | 6929 | 70 |
1788920 | 1788920 | 2021-10-06 | Johnson | Missouri | 29101 | 6916 | 70 |
1785672 | 1785672 | 2021-10-05 | Johnson | Missouri | 29101 | 6902 | 70 |
1782423 | 1782423 | 2021-10-04 | Johnson | Missouri | 29101 | 6881 | 69 |
1779173 | 1779173 | 2021-10-03 | Johnson | Missouri | 29101 | 6871 | 69 |
1775923 | 1775923 | 2021-10-02 | Johnson | Missouri | 29101 | 6871 | 69 |
1772673 | 1772673 | 2021-10-01 | Johnson | Missouri | 29101 | 6843 | 69 |
1769424 | 1769424 | 2021-09-30 | Johnson | Missouri | 29101 | 6816 | 69 |
1766175 | 1766175 | 2021-09-29 | Johnson | Missouri | 29101 | 6790 | 69 |
1762926 | 1762926 | 2021-09-28 | Johnson | Missouri | 29101 | 6767 | 69 |
1759677 | 1759677 | 2021-09-27 | Johnson | Missouri | 29101 | 6749 | 68 |
1756429 | 1756429 | 2021-09-26 | Johnson | Missouri | 29101 | 6734 | 68 |
1753181 | 1753181 | 2021-09-25 | Johnson | Missouri | 29101 | 6727 | 68 |
1749933 | 1749933 | 2021-09-24 | Johnson | Missouri | 29101 | 6691 | 68 |
1746683 | 1746683 | 2021-09-23 | Johnson | Missouri | 29101 | 6659 | 68 |
1743434 | 1743434 | 2021-09-22 | Johnson | Missouri | 29101 | 6640 | 68 |
1740185 | 1740185 | 2021-09-21 | Johnson | Missouri | 29101 | 6612 | 68 |
1736936 | 1736936 | 2021-09-20 | Johnson | Missouri | 29101 | 6599 | 67 |
1733686 | 1733686 | 2021-09-19 | Johnson | Missouri | 29101 | 6581 | 67 |
1730436 | 1730436 | 2021-09-18 | Johnson | Missouri | 29101 | 6559 | 67 |
1727186 | 1727186 | 2021-09-17 | Johnson | Missouri | 29101 | 6526 | 67 |
1723937 | 1723937 | 2021-09-16 | Johnson | Missouri | 29101 | 6495 | 67 |
1720688 | 1720688 | 2021-09-15 | Johnson | Missouri | 29101 | 6458 | 67 |
1717440 | 1717440 | 2021-09-14 | Johnson | Missouri | 29101 | 6431 | 67 |
1714192 | 1714192 | 2021-09-13 | Johnson | Missouri | 29101 | 6404 | 66 |
1710946 | 1710946 | 2021-09-12 | Johnson | Missouri | 29101 | 6385 | 66 |
1707699 | 1707699 | 2021-09-11 | Johnson | Missouri | 29101 | 6361 | 66 |
1704452 | 1704452 | 2021-09-10 | Johnson | Missouri | 29101 | 6335 | 66 |
1701202 | 1701202 | 2021-09-09 | Johnson | Missouri | 29101 | 6307 | 66 |
1697953 | 1697953 | 2021-09-08 | Johnson | Missouri | 29101 | 6281 | 65 |
1694705 | 1694705 | 2021-09-07 | Johnson | Missouri | 29101 | 6263 | 64 |
1691456 | 1691456 | 2021-09-06 | Johnson | Missouri | 29101 | 6245 | 64 |
1688206 | 1688206 | 2021-09-05 | Johnson | Missouri | 29101 | 6232 | 64 |
1684956 | 1684956 | 2021-09-04 | Johnson | Missouri | 29101 | 6217 | 64 |
1681705 | 1681705 | 2021-09-03 | Johnson | Missouri | 29101 | 6184 | 64 |
1678457 | 1678457 | 2021-09-02 | Johnson | Missouri | 29101 | 6151 | 64 |
1675209 | 1675209 | 2021-09-01 | Johnson | Missouri | 29101 | 6115 | 64 |
1671961 | 1671961 | 2021-08-31 | Johnson | Missouri | 29101 | 6087 | 64 |
1668714 | 1668714 | 2021-08-30 | Johnson | Missouri | 29101 | 6082 | 62 |
1665467 | 1665467 | 2021-08-29 | Johnson | Missouri | 29101 | 6052 | 62 |
1662219 | 1662219 | 2021-08-28 | Johnson | Missouri | 29101 | 6034 | 62 |
1658971 | 1658971 | 2021-08-27 | Johnson | Missouri | 29101 | 6017 | 62 |
1655722 | 1655722 | 2021-08-26 | Johnson | Missouri | 29101 | 5986 | 62 |
1652475 | 1652475 | 2021-08-25 | Johnson | Missouri | 29101 | 5947 | 62 |
1649227 | 1649227 | 2021-08-24 | Johnson | Missouri | 29101 | 5924 | 62 |
1645978 | 1645978 | 2021-08-23 | Johnson | Missouri | 29101 | 5906 | 62 |
1642729 | 1642729 | 2021-08-22 | Johnson | Missouri | 29101 | 5892 | 62 |
1639479 | 1639479 | 2021-08-21 | Johnson | Missouri | 29101 | 5868 | 62 |
1636229 | 1636229 | 2021-08-20 | Johnson | Missouri | 29101 | 5837 | 62 |
1632979 | 1632979 | 2021-08-19 | Johnson | Missouri | 29101 | 5825 | 61 |
1629732 | 1629732 | 2021-08-18 | Johnson | Missouri | 29101 | 5780 | 61 |
1626485 | 1626485 | 2021-08-17 | Johnson | Missouri | 29101 | 5761 | 61 |
1623238 | 1623238 | 2021-08-16 | Johnson | Missouri | 29101 | 5750 | 61 |
1619991 | 1619991 | 2021-08-15 | Johnson | Missouri | 29101 | 5732 | 61 |
1616743 | 1616743 | 2021-08-14 | Johnson | Missouri | 29101 | 5710 | 61 |
1613495 | 1613495 | 2021-08-13 | Johnson | Missouri | 29101 | 5675 | 61 |
1610246 | 1610246 | 2021-08-12 | Johnson | Missouri | 29101 | 5645 | 61 |
1606998 | 1606998 | 2021-08-11 | Johnson | Missouri | 29101 | 5615 | 61 |
1603749 | 1603749 | 2021-08-10 | Johnson | Missouri | 29101 | 5579 | 61 |
1600500 | 1600500 | 2021-08-09 | Johnson | Missouri | 29101 | 5548 | 60 |
1597252 | 1597252 | 2021-08-08 | Johnson | Missouri | 29101 | 5536 | 60 |
1594003 | 1594003 | 2021-08-07 | Johnson | Missouri | 29101 | 5518 | 60 |
1590754 | 1590754 | 2021-08-06 | Johnson | Missouri | 29101 | 5495 | 60 |
1587505 | 1587505 | 2021-08-05 | Johnson | Missouri | 29101 | 5466 | 60 |
1584254 | 1584254 | 2021-08-04 | Johnson | Missouri | 29101 | 5433 | 60 |
1581005 | 1581005 | 2021-08-03 | Johnson | Missouri | 29101 | 5399 | 60 |
1577756 | 1577756 | 2021-08-02 | Johnson | Missouri | 29101 | 5373 | 59 |
1574508 | 1574508 | 2021-08-01 | Johnson | Missouri | 29101 | 5359 | 59 |
1571260 | 1571260 | 2021-07-31 | Johnson | Missouri | 29101 | 5335 | 59 |
1568012 | 1568012 | 2021-07-30 | Johnson | Missouri | 29101 | 5307 | 59 |
1564764 | 1564764 | 2021-07-29 | Johnson | Missouri | 29101 | 5284 | 59 |
1561516 | 1561516 | 2021-07-28 | Johnson | Missouri | 29101 | 5267 | 59 |
1558268 | 1558268 | 2021-07-27 | Johnson | Missouri | 29101 | 5251 | 59 |
1555021 | 1555021 | 2021-07-26 | Johnson | Missouri | 29101 | 5224 | 59 |
1551774 | 1551774 | 2021-07-25 | Johnson | Missouri | 29101 | 5208 | 59 |
1548527 | 1548527 | 2021-07-24 | Johnson | Missouri | 29101 | 5188 | 59 |
1545280 | 1545280 | 2021-07-23 | Johnson | Missouri | 29101 | 5157 | 59 |
1542032 | 1542032 | 2021-07-22 | Johnson | Missouri | 29101 | 5131 | 59 |
1538785 | 1538785 | 2021-07-21 | Johnson | Missouri | 29101 | 5094 | 59 |
1535538 | 1535538 | 2021-07-20 | Johnson | Missouri | 29101 | 5058 | 59 |
1532290 | 1532290 | 2021-07-19 | Johnson | Missouri | 29101 | 5050 | 59 |
1529043 | 1529043 | 2021-07-18 | Johnson | Missouri | 29101 | 5043 | 59 |
1525796 | 1525796 | 2021-07-17 | Johnson | Missouri | 29101 | 5028 | 59 |
1522549 | 1522549 | 2021-07-16 | Johnson | Missouri | 29101 | 5016 | 59 |
1519300 | 1519300 | 2021-07-15 | Johnson | Missouri | 29101 | 5003 | 59 |
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);