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 |
---|---|---|---|---|---|---|---|
1948195 | 1948195 | 2021-11-24 | St. Francois | Missouri | 29187 | 12580 | 210 |
1944944 | 1944944 | 2021-11-23 | St. Francois | Missouri | 29187 | 12554 | 209 |
1941693 | 1941693 | 2021-11-22 | St. Francois | Missouri | 29187 | 12535 | 208 |
1938443 | 1938443 | 2021-11-21 | St. Francois | Missouri | 29187 | 12522 | 209 |
1935193 | 1935193 | 2021-11-20 | St. Francois | Missouri | 29187 | 12512 | 209 |
1931943 | 1931943 | 2021-11-19 | St. Francois | Missouri | 29187 | 12480 | 209 |
1928692 | 1928692 | 2021-11-18 | St. Francois | Missouri | 29187 | 12458 | 208 |
1925442 | 1925442 | 2021-11-17 | St. Francois | Missouri | 29187 | 12267 | 179 |
1922193 | 1922193 | 2021-11-16 | St. Francois | Missouri | 29187 | 12246 | 179 |
1918943 | 1918943 | 2021-11-15 | St. Francois | Missouri | 29187 | 12238 | 177 |
1915693 | 1915693 | 2021-11-14 | St. Francois | Missouri | 29187 | 12224 | 177 |
1912443 | 1912443 | 2021-11-13 | St. Francois | Missouri | 29187 | 12213 | 177 |
1909193 | 1909193 | 2021-11-12 | St. Francois | Missouri | 29187 | 12196 | 177 |
1905944 | 1905944 | 2021-11-11 | St. Francois | Missouri | 29187 | 12159 | 177 |
1902695 | 1902695 | 2021-11-10 | St. Francois | Missouri | 29187 | 12159 | 177 |
1899445 | 1899445 | 2021-11-09 | St. Francois | Missouri | 29187 | 12131 | 177 |
1896195 | 1896195 | 2021-11-08 | St. Francois | Missouri | 29187 | 12115 | 173 |
1892945 | 1892945 | 2021-11-07 | St. Francois | Missouri | 29187 | 12111 | 173 |
1889695 | 1889695 | 2021-11-06 | St. Francois | Missouri | 29187 | 12103 | 173 |
1886445 | 1886445 | 2021-11-05 | St. Francois | Missouri | 29187 | 12052 | 173 |
1883196 | 1883196 | 2021-11-04 | St. Francois | Missouri | 29187 | 12040 | 173 |
1879947 | 1879947 | 2021-11-03 | St. Francois | Missouri | 29187 | 12035 | 173 |
1876698 | 1876698 | 2021-11-02 | St. Francois | Missouri | 29187 | 12008 | 173 |
1873449 | 1873449 | 2021-11-01 | St. Francois | Missouri | 29187 | 11999 | 166 |
1870200 | 1870200 | 2021-10-31 | St. Francois | Missouri | 29187 | 11996 | 166 |
1866951 | 1866951 | 2021-10-30 | St. Francois | Missouri | 29187 | 11989 | 166 |
1863702 | 1863702 | 2021-10-29 | St. Francois | Missouri | 29187 | 11976 | 166 |
1860453 | 1860453 | 2021-10-28 | St. Francois | Missouri | 29187 | 11969 | 166 |
1857204 | 1857204 | 2021-10-27 | St. Francois | Missouri | 29187 | 11961 | 166 |
1853955 | 1853955 | 2021-10-26 | St. Francois | Missouri | 29187 | 11952 | 166 |
1850706 | 1850706 | 2021-10-25 | St. Francois | Missouri | 29187 | 11944 | 164 |
1847456 | 1847456 | 2021-10-24 | St. Francois | Missouri | 29187 | 11940 | 164 |
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 |
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);