ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 39055 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948686 | 1948686 | 2021-11-24 | Geauga | Ohio | 39055 | 10434 | 171 |
1945435 | 1945435 | 2021-11-23 | Geauga | Ohio | 39055 | 10365 | 171 |
1942184 | 1942184 | 2021-11-22 | Geauga | Ohio | 39055 | 10317 | 171 |
1938934 | 1938934 | 2021-11-21 | Geauga | Ohio | 39055 | 10265 | 171 |
1935684 | 1935684 | 2021-11-20 | Geauga | Ohio | 39055 | 10198 | 171 |
1932434 | 1932434 | 2021-11-19 | Geauga | Ohio | 39055 | 10129 | 171 |
1929183 | 1929183 | 2021-11-18 | Geauga | Ohio | 39055 | 10061 | 169 |
1925933 | 1925933 | 2021-11-17 | Geauga | Ohio | 39055 | 9995 | 169 |
1922683 | 1922683 | 2021-11-16 | Geauga | Ohio | 39055 | 9921 | 169 |
1919434 | 1919434 | 2021-11-15 | Geauga | Ohio | 39055 | 9861 | 168 |
1916184 | 1916184 | 2021-11-14 | Geauga | Ohio | 39055 | 9809 | 168 |
1912934 | 1912934 | 2021-11-13 | Geauga | Ohio | 39055 | 9756 | 168 |
1909684 | 1909684 | 2021-11-12 | Geauga | Ohio | 39055 | 9701 | 168 |
1906435 | 1906435 | 2021-11-11 | Geauga | Ohio | 39055 | 9635 | 165 |
1903186 | 1903186 | 2021-11-10 | Geauga | Ohio | 39055 | 9587 | 165 |
1899936 | 1899936 | 2021-11-09 | Geauga | Ohio | 39055 | 9543 | 165 |
1896686 | 1896686 | 2021-11-08 | Geauga | Ohio | 39055 | 9492 | 162 |
1893436 | 1893436 | 2021-11-07 | Geauga | Ohio | 39055 | 9445 | 162 |
1890186 | 1890186 | 2021-11-06 | Geauga | Ohio | 39055 | 9395 | 162 |
1886936 | 1886936 | 2021-11-05 | Geauga | Ohio | 39055 | 9357 | 162 |
1883686 | 1883686 | 2021-11-04 | Geauga | Ohio | 39055 | 9326 | 159 |
1880437 | 1880437 | 2021-11-03 | Geauga | Ohio | 39055 | 9280 | 159 |
1877188 | 1877188 | 2021-11-02 | Geauga | Ohio | 39055 | 9239 | 159 |
1873939 | 1873939 | 2021-11-01 | Geauga | Ohio | 39055 | 9207 | 159 |
1870690 | 1870690 | 2021-10-31 | Geauga | Ohio | 39055 | 9179 | 159 |
1867441 | 1867441 | 2021-10-30 | Geauga | Ohio | 39055 | 9152 | 159 |
1864192 | 1864192 | 2021-10-29 | Geauga | Ohio | 39055 | 9121 | 159 |
1860943 | 1860943 | 2021-10-28 | Geauga | Ohio | 39055 | 9095 | 158 |
1857694 | 1857694 | 2021-10-27 | Geauga | Ohio | 39055 | 9062 | 158 |
1854445 | 1854445 | 2021-10-26 | Geauga | Ohio | 39055 | 9042 | 158 |
1851196 | 1851196 | 2021-10-25 | Geauga | Ohio | 39055 | 9008 | 158 |
1847946 | 1847946 | 2021-10-24 | Geauga | Ohio | 39055 | 8987 | 158 |
1844696 | 1844696 | 2021-10-23 | Geauga | Ohio | 39055 | 8965 | 158 |
1841446 | 1841446 | 2021-10-22 | Geauga | Ohio | 39055 | 8933 | 158 |
1838197 | 1838197 | 2021-10-21 | Geauga | Ohio | 39055 | 8906 | 158 |
1834948 | 1834948 | 2021-10-20 | Geauga | Ohio | 39055 | 8879 | 158 |
1831699 | 1831699 | 2021-10-19 | Geauga | Ohio | 39055 | 8848 | 158 |
1828450 | 1828450 | 2021-10-18 | Geauga | Ohio | 39055 | 8829 | 158 |
1825201 | 1825201 | 2021-10-17 | Geauga | Ohio | 39055 | 8813 | 158 |
1821952 | 1821952 | 2021-10-16 | Geauga | Ohio | 39055 | 8795 | 158 |
1818703 | 1818703 | 2021-10-15 | Geauga | Ohio | 39055 | 8766 | 158 |
1815454 | 1815454 | 2021-10-14 | Geauga | Ohio | 39055 | 8725 | 158 |
1812206 | 1812206 | 2021-10-13 | Geauga | Ohio | 39055 | 8699 | 158 |
1808957 | 1808957 | 2021-10-12 | Geauga | Ohio | 39055 | 8656 | 158 |
1805707 | 1805707 | 2021-10-11 | Geauga | Ohio | 39055 | 8631 | 158 |
1802457 | 1802457 | 2021-10-10 | Geauga | Ohio | 39055 | 8610 | 158 |
1799208 | 1799208 | 2021-10-09 | Geauga | Ohio | 39055 | 8582 | 158 |
1795959 | 1795959 | 2021-10-08 | Geauga | Ohio | 39055 | 8560 | 158 |
1792710 | 1792710 | 2021-10-07 | Geauga | Ohio | 39055 | 8535 | 158 |
1789461 | 1789461 | 2021-10-06 | Geauga | Ohio | 39055 | 8505 | 158 |
1786213 | 1786213 | 2021-10-05 | Geauga | Ohio | 39055 | 8487 | 158 |
1782964 | 1782964 | 2021-10-04 | Geauga | Ohio | 39055 | 8461 | 158 |
1779715 | 1779715 | 2021-10-03 | Geauga | Ohio | 39055 | 8440 | 158 |
1776465 | 1776465 | 2021-10-02 | Geauga | Ohio | 39055 | 8421 | 158 |
1773215 | 1773215 | 2021-10-01 | Geauga | Ohio | 39055 | 8402 | 158 |
1769965 | 1769965 | 2021-09-30 | Geauga | Ohio | 39055 | 8365 | 157 |
1766716 | 1766716 | 2021-09-29 | Geauga | Ohio | 39055 | 8339 | 157 |
1763467 | 1763467 | 2021-09-28 | Geauga | Ohio | 39055 | 8312 | 157 |
1760218 | 1760218 | 2021-09-27 | Geauga | Ohio | 39055 | 8294 | 156 |
1756970 | 1756970 | 2021-09-26 | Geauga | Ohio | 39055 | 8272 | 156 |
1753722 | 1753722 | 2021-09-25 | Geauga | Ohio | 39055 | 8251 | 156 |
1750474 | 1750474 | 2021-09-24 | Geauga | Ohio | 39055 | 8226 | 156 |
1747224 | 1747224 | 2021-09-23 | Geauga | Ohio | 39055 | 8196 | 156 |
1743975 | 1743975 | 2021-09-22 | Geauga | Ohio | 39055 | 8173 | 156 |
1740726 | 1740726 | 2021-09-21 | Geauga | Ohio | 39055 | 8148 | 156 |
1737477 | 1737477 | 2021-09-20 | Geauga | Ohio | 39055 | 8116 | 155 |
1734227 | 1734227 | 2021-09-19 | Geauga | Ohio | 39055 | 8100 | 155 |
1730977 | 1730977 | 2021-09-18 | Geauga | Ohio | 39055 | 8066 | 155 |
1727727 | 1727727 | 2021-09-17 | Geauga | Ohio | 39055 | 8041 | 155 |
1724478 | 1724478 | 2021-09-16 | Geauga | Ohio | 39055 | 8012 | 155 |
1721229 | 1721229 | 2021-09-15 | Geauga | Ohio | 39055 | 7976 | 155 |
1717981 | 1717981 | 2021-09-14 | Geauga | Ohio | 39055 | 7942 | 155 |
1714733 | 1714733 | 2021-09-13 | Geauga | Ohio | 39055 | 7887 | 155 |
1711487 | 1711487 | 2021-09-12 | Geauga | Ohio | 39055 | 7858 | 155 |
1708240 | 1708240 | 2021-09-11 | Geauga | Ohio | 39055 | 7836 | 155 |
1704993 | 1704993 | 2021-09-10 | Geauga | Ohio | 39055 | 7800 | 155 |
1701743 | 1701743 | 2021-09-09 | Geauga | Ohio | 39055 | 7768 | 155 |
1698494 | 1698494 | 2021-09-08 | Geauga | Ohio | 39055 | 7746 | 155 |
1695246 | 1695246 | 2021-09-07 | Geauga | Ohio | 39055 | 7717 | 155 |
1691998 | 1691998 | 2021-09-06 | Geauga | Ohio | 39055 | 7680 | 155 |
1688749 | 1688749 | 2021-09-05 | Geauga | Ohio | 39055 | 7666 | 155 |
1685499 | 1685499 | 2021-09-04 | Geauga | Ohio | 39055 | 7636 | 155 |
1682248 | 1682248 | 2021-09-03 | Geauga | Ohio | 39055 | 7608 | 155 |
1678998 | 1678998 | 2021-09-02 | Geauga | Ohio | 39055 | 7583 | 155 |
1675750 | 1675750 | 2021-09-01 | Geauga | Ohio | 39055 | 7548 | 155 |
1672503 | 1672503 | 2021-08-31 | Geauga | Ohio | 39055 | 7525 | 155 |
1669255 | 1669255 | 2021-08-30 | Geauga | Ohio | 39055 | 7492 | 155 |
1666008 | 1666008 | 2021-08-29 | Geauga | Ohio | 39055 | 7465 | 155 |
1662760 | 1662760 | 2021-08-28 | Geauga | Ohio | 39055 | 7441 | 155 |
1659512 | 1659512 | 2021-08-27 | Geauga | Ohio | 39055 | 7409 | 155 |
1656263 | 1656263 | 2021-08-26 | Geauga | Ohio | 39055 | 7386 | 155 |
1653016 | 1653016 | 2021-08-25 | Geauga | Ohio | 39055 | 7364 | 155 |
1649769 | 1649769 | 2021-08-24 | Geauga | Ohio | 39055 | 7336 | 155 |
1646520 | 1646520 | 2021-08-23 | Geauga | Ohio | 39055 | 7318 | 153 |
1643271 | 1643271 | 2021-08-22 | Geauga | Ohio | 39055 | 7299 | 153 |
1640021 | 1640021 | 2021-08-21 | Geauga | Ohio | 39055 | 7287 | 153 |
1636771 | 1636771 | 2021-08-20 | Geauga | Ohio | 39055 | 7270 | 153 |
1633521 | 1633521 | 2021-08-19 | Geauga | Ohio | 39055 | 7251 | 153 |
1630274 | 1630274 | 2021-08-18 | Geauga | Ohio | 39055 | 7240 | 153 |
1627027 | 1627027 | 2021-08-17 | Geauga | Ohio | 39055 | 7221 | 153 |
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);