ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lucas" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948706 | 1948706 | 2021-11-24 | Lucas | Ohio | 39095 | 61065 | 1011 |
1945455 | 1945455 | 2021-11-23 | Lucas | Ohio | 39095 | 60844 | 1011 |
1942204 | 1942204 | 2021-11-22 | Lucas | Ohio | 39095 | 60651 | 1005 |
1938954 | 1938954 | 2021-11-21 | Lucas | Ohio | 39095 | 60525 | 1005 |
1935704 | 1935704 | 2021-11-20 | Lucas | Ohio | 39095 | 60382 | 1005 |
1932454 | 1932454 | 2021-11-19 | Lucas | Ohio | 39095 | 60176 | 1005 |
1929203 | 1929203 | 2021-11-18 | Lucas | Ohio | 39095 | 59997 | 997 |
1925953 | 1925953 | 2021-11-17 | Lucas | Ohio | 39095 | 59815 | 997 |
1922703 | 1922703 | 2021-11-16 | Lucas | Ohio | 39095 | 59553 | 997 |
1919454 | 1919454 | 2021-11-15 | Lucas | Ohio | 39095 | 59376 | 992 |
1916204 | 1916204 | 2021-11-14 | Lucas | Ohio | 39095 | 59266 | 992 |
1912954 | 1912954 | 2021-11-13 | Lucas | Ohio | 39095 | 59140 | 992 |
1909704 | 1909704 | 2021-11-12 | Lucas | Ohio | 39095 | 58984 | 992 |
1906455 | 1906455 | 2021-11-11 | Lucas | Ohio | 39095 | 58812 | 976 |
1903206 | 1903206 | 2021-11-10 | Lucas | Ohio | 39095 | 58662 | 976 |
1899956 | 1899956 | 2021-11-09 | Lucas | Ohio | 39095 | 58436 | 976 |
1896706 | 1896706 | 2021-11-08 | Lucas | Ohio | 39095 | 58289 | 966 |
1893456 | 1893456 | 2021-11-07 | Lucas | Ohio | 39095 | 58206 | 966 |
1890206 | 1890206 | 2021-11-06 | Lucas | Ohio | 39095 | 58047 | 966 |
1886956 | 1886956 | 2021-11-05 | Lucas | Ohio | 39095 | 57956 | 966 |
1883706 | 1883706 | 2021-11-04 | Lucas | Ohio | 39095 | 57801 | 948 |
1880457 | 1880457 | 2021-11-03 | Lucas | Ohio | 39095 | 57646 | 948 |
1877208 | 1877208 | 2021-11-02 | Lucas | Ohio | 39095 | 57484 | 948 |
1873959 | 1873959 | 2021-11-01 | Lucas | Ohio | 39095 | 57359 | 936 |
1870710 | 1870710 | 2021-10-31 | Lucas | Ohio | 39095 | 57283 | 936 |
1867461 | 1867461 | 2021-10-30 | Lucas | Ohio | 39095 | 57182 | 936 |
1864212 | 1864212 | 2021-10-29 | Lucas | Ohio | 39095 | 57057 | 936 |
1860963 | 1860963 | 2021-10-28 | Lucas | Ohio | 39095 | 56913 | 923 |
1857714 | 1857714 | 2021-10-27 | Lucas | Ohio | 39095 | 56817 | 923 |
1854465 | 1854465 | 2021-10-26 | Lucas | Ohio | 39095 | 56681 | 923 |
1851216 | 1851216 | 2021-10-25 | Lucas | Ohio | 39095 | 56539 | 917 |
1847966 | 1847966 | 2021-10-24 | Lucas | Ohio | 39095 | 56476 | 917 |
1844716 | 1844716 | 2021-10-23 | Lucas | Ohio | 39095 | 56338 | 917 |
1841466 | 1841466 | 2021-10-22 | Lucas | Ohio | 39095 | 56212 | 917 |
1838217 | 1838217 | 2021-10-21 | Lucas | Ohio | 39095 | 56058 | 912 |
1834968 | 1834968 | 2021-10-20 | Lucas | Ohio | 39095 | 55919 | 912 |
1831719 | 1831719 | 2021-10-19 | Lucas | Ohio | 39095 | 55753 | 912 |
1828470 | 1828470 | 2021-10-18 | Lucas | Ohio | 39095 | 55643 | 904 |
1825221 | 1825221 | 2021-10-17 | Lucas | Ohio | 39095 | 55560 | 904 |
1821972 | 1821972 | 2021-10-16 | Lucas | Ohio | 39095 | 55462 | 904 |
1818723 | 1818723 | 2021-10-15 | Lucas | Ohio | 39095 | 55296 | 904 |
1815474 | 1815474 | 2021-10-14 | Lucas | Ohio | 39095 | 55089 | 894 |
1812226 | 1812226 | 2021-10-13 | Lucas | Ohio | 39095 | 54921 | 894 |
1808977 | 1808977 | 2021-10-12 | Lucas | Ohio | 39095 | 54701 | 894 |
1805727 | 1805727 | 2021-10-11 | Lucas | Ohio | 39095 | 54551 | 886 |
1802477 | 1802477 | 2021-10-10 | Lucas | Ohio | 39095 | 54427 | 886 |
1799228 | 1799228 | 2021-10-09 | Lucas | Ohio | 39095 | 54199 | 886 |
1795979 | 1795979 | 2021-10-08 | Lucas | Ohio | 39095 | 54051 | 886 |
1792730 | 1792730 | 2021-10-07 | Lucas | Ohio | 39095 | 53746 | 883 |
1789481 | 1789481 | 2021-10-06 | Lucas | Ohio | 39095 | 53603 | 883 |
1786233 | 1786233 | 2021-10-05 | Lucas | Ohio | 39095 | 53355 | 883 |
1782984 | 1782984 | 2021-10-04 | Lucas | Ohio | 39095 | 53223 | 877 |
1779735 | 1779735 | 2021-10-03 | Lucas | Ohio | 39095 | 53092 | 877 |
1776485 | 1776485 | 2021-10-02 | Lucas | Ohio | 39095 | 52980 | 877 |
1773235 | 1773235 | 2021-10-01 | Lucas | Ohio | 39095 | 52803 | 877 |
1769985 | 1769985 | 2021-09-30 | Lucas | Ohio | 39095 | 52586 | 872 |
1766736 | 1766736 | 2021-09-29 | Lucas | Ohio | 39095 | 52376 | 872 |
1763487 | 1763487 | 2021-09-28 | Lucas | Ohio | 39095 | 52142 | 872 |
1760238 | 1760238 | 2021-09-27 | Lucas | Ohio | 39095 | 51927 | 869 |
1756990 | 1756990 | 2021-09-26 | Lucas | Ohio | 39095 | 51769 | 869 |
1753742 | 1753742 | 2021-09-25 | Lucas | Ohio | 39095 | 51531 | 869 |
1750494 | 1750494 | 2021-09-24 | Lucas | Ohio | 39095 | 51349 | 869 |
1747244 | 1747244 | 2021-09-23 | Lucas | Ohio | 39095 | 51165 | 863 |
1743995 | 1743995 | 2021-09-22 | Lucas | Ohio | 39095 | 50900 | 863 |
1740746 | 1740746 | 2021-09-21 | Lucas | Ohio | 39095 | 50677 | 863 |
1737497 | 1737497 | 2021-09-20 | Lucas | Ohio | 39095 | 50500 | 862 |
1734247 | 1734247 | 2021-09-19 | Lucas | Ohio | 39095 | 50396 | 862 |
1730997 | 1730997 | 2021-09-18 | Lucas | Ohio | 39095 | 50248 | 862 |
1727747 | 1727747 | 2021-09-17 | Lucas | Ohio | 39095 | 50067 | 862 |
1724498 | 1724498 | 2021-09-16 | Lucas | Ohio | 39095 | 49821 | 853 |
1721249 | 1721249 | 2021-09-15 | Lucas | Ohio | 39095 | 49502 | 853 |
1718001 | 1718001 | 2021-09-14 | Lucas | Ohio | 39095 | 49206 | 853 |
1714753 | 1714753 | 2021-09-13 | Lucas | Ohio | 39095 | 49016 | 851 |
1711507 | 1711507 | 2021-09-12 | Lucas | Ohio | 39095 | 48868 | 851 |
1708260 | 1708260 | 2021-09-11 | Lucas | Ohio | 39095 | 48690 | 851 |
1705013 | 1705013 | 2021-09-10 | Lucas | Ohio | 39095 | 48432 | 851 |
1701763 | 1701763 | 2021-09-09 | Lucas | Ohio | 39095 | 48149 | 849 |
1698514 | 1698514 | 2021-09-08 | Lucas | Ohio | 39095 | 47890 | 849 |
1695266 | 1695266 | 2021-09-07 | Lucas | Ohio | 39095 | 47711 | 849 |
1692018 | 1692018 | 2021-09-06 | Lucas | Ohio | 39095 | 47581 | 848 |
1688769 | 1688769 | 2021-09-05 | Lucas | Ohio | 39095 | 47464 | 848 |
1685519 | 1685519 | 2021-09-04 | Lucas | Ohio | 39095 | 47256 | 848 |
1682268 | 1682268 | 2021-09-03 | Lucas | Ohio | 39095 | 47070 | 848 |
1679018 | 1679018 | 2021-09-02 | Lucas | Ohio | 39095 | 46886 | 844 |
1675770 | 1675770 | 2021-09-01 | Lucas | Ohio | 39095 | 46717 | 844 |
1672523 | 1672523 | 2021-08-31 | Lucas | Ohio | 39095 | 46487 | 844 |
1669275 | 1669275 | 2021-08-30 | Lucas | Ohio | 39095 | 46353 | 841 |
1666028 | 1666028 | 2021-08-29 | Lucas | Ohio | 39095 | 46275 | 841 |
1662780 | 1662780 | 2021-08-28 | Lucas | Ohio | 39095 | 46173 | 841 |
1659532 | 1659532 | 2021-08-27 | Lucas | Ohio | 39095 | 46033 | 841 |
1656283 | 1656283 | 2021-08-26 | Lucas | Ohio | 39095 | 45892 | 839 |
1653036 | 1653036 | 2021-08-25 | Lucas | Ohio | 39095 | 45751 | 839 |
1649789 | 1649789 | 2021-08-24 | Lucas | Ohio | 39095 | 45601 | 839 |
1646540 | 1646540 | 2021-08-23 | Lucas | Ohio | 39095 | 45468 | 839 |
1643291 | 1643291 | 2021-08-22 | Lucas | Ohio | 39095 | 45359 | 839 |
1640041 | 1640041 | 2021-08-21 | Lucas | Ohio | 39095 | 45302 | 839 |
1636791 | 1636791 | 2021-08-20 | Lucas | Ohio | 39095 | 45194 | 839 |
1633541 | 1633541 | 2021-08-19 | Lucas | Ohio | 39095 | 45057 | 838 |
1630294 | 1630294 | 2021-08-18 | Lucas | Ohio | 39095 | 44973 | 838 |
1627047 | 1627047 | 2021-08-17 | Lucas | Ohio | 39095 | 44863 | 838 |
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);