ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "St. Francois" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1844206 | 1844206 | 2021-10-23 | St. Francois | Missouri | 29187 | 11930 | 164 |
1840956 | 1840956 | 2021-10-22 | St. Francois | Missouri | 29187 | 11922 | 164 |
1837707 | 1837707 | 2021-10-21 | St. Francois | Missouri | 29187 | 11908 | 164 |
1834458 | 1834458 | 2021-10-20 | St. Francois | Missouri | 29187 | 11896 | 164 |
1831209 | 1831209 | 2021-10-19 | St. Francois | Missouri | 29187 | 11882 | 164 |
1827960 | 1827960 | 2021-10-18 | St. Francois | Missouri | 29187 | 11880 | 161 |
1824711 | 1824711 | 2021-10-17 | St. Francois | Missouri | 29187 | 11878 | 161 |
1821462 | 1821462 | 2021-10-16 | St. Francois | Missouri | 29187 | 11876 | 161 |
1818213 | 1818213 | 2021-10-15 | St. Francois | Missouri | 29187 | 11864 | 161 |
1814964 | 1814964 | 2021-10-14 | St. Francois | Missouri | 29187 | 11851 | 161 |
1811716 | 1811716 | 2021-10-13 | St. Francois | Missouri | 29187 | 11837 | 161 |
1808467 | 1808467 | 2021-10-12 | St. Francois | Missouri | 29187 | 11830 | 158 |
1805216 | 1805216 | 2021-10-11 | St. Francois | Missouri | 29187 | 11825 | 158 |
1801967 | 1801967 | 2021-10-10 | St. Francois | Missouri | 29187 | 11821 | 158 |
1798718 | 1798718 | 2021-10-09 | St. Francois | Missouri | 29187 | 11815 | 158 |
1795469 | 1795469 | 2021-10-08 | St. Francois | Missouri | 29187 | 11799 | 158 |
1792220 | 1792220 | 2021-10-07 | St. Francois | Missouri | 29187 | 11784 | 158 |
1788971 | 1788971 | 2021-10-06 | St. Francois | Missouri | 29187 | 11776 | 158 |
1785723 | 1785723 | 2021-10-05 | St. Francois | Missouri | 29187 | 11745 | 158 |
1782474 | 1782474 | 2021-10-04 | St. Francois | Missouri | 29187 | 11730 | 152 |
1779224 | 1779224 | 2021-10-03 | St. Francois | Missouri | 29187 | 11725 | 152 |
1775974 | 1775974 | 2021-10-02 | St. Francois | Missouri | 29187 | 11714 | 152 |
1772724 | 1772724 | 2021-10-01 | St. Francois | Missouri | 29187 | 11699 | 152 |
1769475 | 1769475 | 2021-09-30 | St. Francois | Missouri | 29187 | 11663 | 152 |
1766226 | 1766226 | 2021-09-29 | St. Francois | Missouri | 29187 | 11632 | 151 |
1762977 | 1762977 | 2021-09-28 | St. Francois | Missouri | 29187 | 11606 | 151 |
1759728 | 1759728 | 2021-09-27 | St. Francois | Missouri | 29187 | 11590 | 144 |
1756480 | 1756480 | 2021-09-26 | St. Francois | Missouri | 29187 | 11572 | 144 |
1753232 | 1753232 | 2021-09-25 | St. Francois | Missouri | 29187 | 11562 | 144 |
1749984 | 1749984 | 2021-09-24 | St. Francois | Missouri | 29187 | 11508 | 144 |
1746734 | 1746734 | 2021-09-23 | St. Francois | Missouri | 29187 | 11485 | 144 |
1743485 | 1743485 | 2021-09-22 | St. Francois | Missouri | 29187 | 11442 | 144 |
1740236 | 1740236 | 2021-09-21 | St. Francois | Missouri | 29187 | 11402 | 144 |
1736987 | 1736987 | 2021-09-20 | St. Francois | Missouri | 29187 | 11353 | 137 |
1733737 | 1733737 | 2021-09-19 | St. Francois | Missouri | 29187 | 11343 | 137 |
1730487 | 1730487 | 2021-09-18 | St. Francois | Missouri | 29187 | 11314 | 137 |
1727237 | 1727237 | 2021-09-17 | St. Francois | Missouri | 29187 | 11270 | 137 |
1723988 | 1723988 | 2021-09-16 | St. Francois | Missouri | 29187 | 11226 | 137 |
1720739 | 1720739 | 2021-09-15 | St. Francois | Missouri | 29187 | 11173 | 137 |
1717491 | 1717491 | 2021-09-14 | St. Francois | Missouri | 29187 | 11114 | 137 |
1714243 | 1714243 | 2021-09-13 | St. Francois | Missouri | 29187 | 11062 | 132 |
1710997 | 1710997 | 2021-09-12 | St. Francois | Missouri | 29187 | 11053 | 132 |
1707750 | 1707750 | 2021-09-11 | St. Francois | Missouri | 29187 | 11007 | 132 |
1704503 | 1704503 | 2021-09-10 | St. Francois | Missouri | 29187 | 10926 | 130 |
1701253 | 1701253 | 2021-09-09 | St. Francois | Missouri | 29187 | 10867 | 130 |
1698004 | 1698004 | 2021-09-08 | St. Francois | Missouri | 29187 | 10811 | 129 |
1694756 | 1694756 | 2021-09-07 | St. Francois | Missouri | 29187 | 10757 | 128 |
1691507 | 1691507 | 2021-09-06 | St. Francois | Missouri | 29187 | 10731 | 128 |
1688257 | 1688257 | 2021-09-05 | St. Francois | Missouri | 29187 | 10701 | 128 |
1685007 | 1685007 | 2021-09-04 | St. Francois | Missouri | 29187 | 10664 | 128 |
1681756 | 1681756 | 2021-09-03 | St. Francois | Missouri | 29187 | 10604 | 128 |
1678508 | 1678508 | 2021-09-02 | St. Francois | Missouri | 29187 | 10541 | 128 |
1675260 | 1675260 | 2021-09-01 | St. Francois | Missouri | 29187 | 10430 | 128 |
1672012 | 1672012 | 2021-08-31 | St. Francois | Missouri | 29187 | 10377 | 128 |
1668765 | 1668765 | 2021-08-30 | St. Francois | Missouri | 29187 | 10357 | 122 |
1665518 | 1665518 | 2021-08-29 | St. Francois | Missouri | 29187 | 10296 | 122 |
1662270 | 1662270 | 2021-08-28 | St. Francois | Missouri | 29187 | 10258 | 122 |
1659022 | 1659022 | 2021-08-27 | St. Francois | Missouri | 29187 | 10203 | 122 |
1655773 | 1655773 | 2021-08-26 | St. Francois | Missouri | 29187 | 10140 | 122 |
1652526 | 1652526 | 2021-08-25 | St. Francois | Missouri | 29187 | 10097 | 122 |
1649278 | 1649278 | 2021-08-24 | St. Francois | Missouri | 29187 | 10052 | 122 |
1646029 | 1646029 | 2021-08-23 | St. Francois | Missouri | 29187 | 10018 | 119 |
1642780 | 1642780 | 2021-08-22 | St. Francois | Missouri | 29187 | 9993 | 119 |
1639530 | 1639530 | 2021-08-21 | St. Francois | Missouri | 29187 | 9963 | 119 |
1636280 | 1636280 | 2021-08-20 | St. Francois | Missouri | 29187 | 9931 | 119 |
1633030 | 1633030 | 2021-08-19 | St. Francois | Missouri | 29187 | 9886 | 119 |
1629783 | 1629783 | 2021-08-18 | St. Francois | Missouri | 29187 | 9842 | 119 |
1626536 | 1626536 | 2021-08-17 | St. Francois | Missouri | 29187 | 9778 | 119 |
1623289 | 1623289 | 2021-08-16 | St. Francois | Missouri | 29187 | 9746 | 118 |
1620042 | 1620042 | 2021-08-15 | St. Francois | Missouri | 29187 | 9726 | 118 |
1616794 | 1616794 | 2021-08-14 | St. Francois | Missouri | 29187 | 9711 | 118 |
1613546 | 1613546 | 2021-08-13 | St. Francois | Missouri | 29187 | 9661 | 118 |
1610297 | 1610297 | 2021-08-12 | St. Francois | Missouri | 29187 | 9612 | 118 |
1607049 | 1607049 | 2021-08-11 | St. Francois | Missouri | 29187 | 9569 | 118 |
1603800 | 1603800 | 2021-08-10 | St. Francois | Missouri | 29187 | 9494 | 118 |
1600551 | 1600551 | 2021-08-09 | St. Francois | Missouri | 29187 | 9477 | 118 |
1597303 | 1597303 | 2021-08-08 | St. Francois | Missouri | 29187 | 9452 | 118 |
1594054 | 1594054 | 2021-08-07 | St. Francois | Missouri | 29187 | 9432 | 118 |
1590805 | 1590805 | 2021-08-06 | St. Francois | Missouri | 29187 | 9412 | 118 |
1587556 | 1587556 | 2021-08-05 | St. Francois | Missouri | 29187 | 9374 | 118 |
1584305 | 1584305 | 2021-08-04 | St. Francois | Missouri | 29187 | 9336 | 118 |
1581056 | 1581056 | 2021-08-03 | St. Francois | Missouri | 29187 | 9308 | 118 |
1577807 | 1577807 | 2021-08-02 | St. Francois | Missouri | 29187 | 9289 | 118 |
1574559 | 1574559 | 2021-08-01 | St. Francois | Missouri | 29187 | 9278 | 118 |
1571311 | 1571311 | 2021-07-31 | St. Francois | Missouri | 29187 | 9260 | 118 |
1568063 | 1568063 | 2021-07-30 | St. Francois | Missouri | 29187 | 9236 | 118 |
1564815 | 1564815 | 2021-07-29 | St. Francois | Missouri | 29187 | 9205 | 118 |
1561567 | 1561567 | 2021-07-28 | St. Francois | Missouri | 29187 | 9181 | 118 |
1558319 | 1558319 | 2021-07-27 | St. Francois | Missouri | 29187 | 9166 | 118 |
1555072 | 1555072 | 2021-07-26 | St. Francois | Missouri | 29187 | 9159 | 117 |
1551825 | 1551825 | 2021-07-25 | St. Francois | Missouri | 29187 | 9152 | 117 |
1548578 | 1548578 | 2021-07-24 | St. Francois | Missouri | 29187 | 9143 | 117 |
1545331 | 1545331 | 2021-07-23 | St. Francois | Missouri | 29187 | 9124 | 117 |
1542083 | 1542083 | 2021-07-22 | St. Francois | Missouri | 29187 | 9113 | 117 |
1538836 | 1538836 | 2021-07-21 | St. Francois | Missouri | 29187 | 9091 | 117 |
1535589 | 1535589 | 2021-07-20 | St. Francois | Missouri | 29187 | 9087 | 117 |
1532341 | 1532341 | 2021-07-19 | St. Francois | Missouri | 29187 | 9083 | 116 |
1529094 | 1529094 | 2021-07-18 | St. Francois | Missouri | 29187 | 9081 | 116 |
1525847 | 1525847 | 2021-07-17 | St. Francois | Missouri | 29187 | 9075 | 116 |
1522600 | 1522600 | 2021-07-16 | St. Francois | Missouri | 29187 | 9067 | 116 |
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);