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 |
---|---|---|---|---|---|---|---|
2176307 | 2176307 | 2022-02-02 | Lucas | Ohio | 39095 | 96400 | 1218 |
2173053 | 2173053 | 2022-02-01 | Lucas | Ohio | 39095 | 96014 | 1218 |
2169801 | 2169801 | 2022-01-31 | Lucas | Ohio | 39095 | 95798 | 1207 |
2166546 | 2166546 | 2022-01-30 | Lucas | Ohio | 39095 | 95675 | 1207 |
2163291 | 2163291 | 2022-01-29 | Lucas | Ohio | 39095 | 95466 | 1207 |
2160036 | 2160036 | 2022-01-28 | Lucas | Ohio | 39095 | 95192 | 1207 |
2156781 | 2156781 | 2022-01-27 | Lucas | Ohio | 39095 | 94853 | 1197 |
2153528 | 2153528 | 2022-01-26 | Lucas | Ohio | 39095 | 94414 | 1197 |
2150276 | 2150276 | 2022-01-25 | Lucas | Ohio | 39095 | 93610 | 1197 |
2147024 | 2147024 | 2022-01-24 | Lucas | Ohio | 39095 | 93532 | 1193 |
2143770 | 2143770 | 2022-01-23 | Lucas | Ohio | 39095 | 93285 | 1193 |
2140515 | 2140515 | 2022-01-22 | Lucas | Ohio | 39095 | 92912 | 1193 |
2137259 | 2137259 | 2022-01-21 | Lucas | Ohio | 39095 | 92448 | 1193 |
2134005 | 2134005 | 2022-01-20 | Lucas | Ohio | 39095 | 91746 | 1160 |
2130753 | 2130753 | 2022-01-19 | Lucas | Ohio | 39095 | 90937 | 1160 |
2127499 | 2127499 | 2022-01-18 | Lucas | Ohio | 39095 | 89997 | 1160 |
2124247 | 2124247 | 2022-01-17 | Lucas | Ohio | 39095 | 89517 | 1149 |
2120995 | 2120995 | 2022-01-16 | Lucas | Ohio | 39095 | 88471 | 1149 |
2117743 | 2117743 | 2022-01-15 | Lucas | Ohio | 39095 | 87301 | 1149 |
2114492 | 2114492 | 2022-01-14 | Lucas | Ohio | 39095 | 85080 | 1149 |
2111240 | 2111240 | 2022-01-13 | Lucas | Ohio | 39095 | 83088 | 1137 |
2107988 | 2107988 | 2022-01-12 | Lucas | Ohio | 39095 | 82228 | 1137 |
2104737 | 2104737 | 2022-01-11 | Lucas | Ohio | 39095 | 80938 | 1137 |
2101486 | 2101486 | 2022-01-10 | Lucas | Ohio | 39095 | 79644 | 1130 |
2098235 | 2098235 | 2022-01-09 | Lucas | Ohio | 39095 | 79187 | 1130 |
2094983 | 2094983 | 2022-01-08 | Lucas | Ohio | 39095 | 78278 | 1130 |
2091731 | 2091731 | 2022-01-07 | Lucas | Ohio | 39095 | 77324 | 1130 |
2088479 | 2088479 | 2022-01-06 | Lucas | Ohio | 39095 | 76673 | 1114 |
2085228 | 2085228 | 2022-01-05 | Lucas | Ohio | 39095 | 75943 | 1114 |
2081976 | 2081976 | 2022-01-04 | Lucas | Ohio | 39095 | 75121 | 1114 |
2078724 | 2078724 | 2022-01-03 | Lucas | Ohio | 39095 | 74334 | 1087 |
2075473 | 2075473 | 2022-01-02 | Lucas | Ohio | 39095 | 73430 | 1087 |
2072222 | 2072222 | 2022-01-01 | Lucas | Ohio | 39095 | 71957 | 1087 |
2068971 | 2068971 | 2021-12-31 | Lucas | Ohio | 39095 | 71957 | 1087 |
2065720 | 2065720 | 2021-12-30 | Lucas | Ohio | 39095 | 71097 | 1069 |
2062470 | 2062470 | 2021-12-29 | Lucas | Ohio | 39095 | 70517 | 1069 |
2059220 | 2059220 | 2021-12-28 | Lucas | Ohio | 39095 | 69788 | 1069 |
2055971 | 2055971 | 2021-12-27 | Lucas | Ohio | 39095 | 69273 | 1068 |
2052722 | 2052722 | 2021-12-26 | Lucas | Ohio | 39095 | 68958 | 1068 |
2049472 | 2049472 | 2021-12-25 | Lucas | Ohio | 39095 | 68266 | 1068 |
2046222 | 2046222 | 2021-12-24 | Lucas | Ohio | 39095 | 68266 | 1068 |
2042972 | 2042972 | 2021-12-23 | Lucas | Ohio | 39095 | 67958 | 1059 |
2039723 | 2039723 | 2021-12-22 | Lucas | Ohio | 39095 | 67533 | 1059 |
2036473 | 2036473 | 2021-12-21 | Lucas | Ohio | 39095 | 67199 | 1059 |
2033223 | 2033223 | 2021-12-20 | Lucas | Ohio | 39095 | 66935 | 1058 |
2029973 | 2029973 | 2021-12-19 | Lucas | Ohio | 39095 | 66731 | 1058 |
2026722 | 2026722 | 2021-12-18 | Lucas | Ohio | 39095 | 66578 | 1058 |
2023471 | 2023471 | 2021-12-17 | Lucas | Ohio | 39095 | 66348 | 1058 |
2020220 | 2020220 | 2021-12-16 | Lucas | Ohio | 39095 | 66092 | 1045 |
2016969 | 2016969 | 2021-12-15 | Lucas | Ohio | 39095 | 65882 | 1045 |
2013719 | 2013719 | 2021-12-14 | Lucas | Ohio | 39095 | 65575 | 1045 |
2010468 | 2010468 | 2021-12-13 | Lucas | Ohio | 39095 | 65314 | 1044 |
2007217 | 2007217 | 2021-12-12 | Lucas | Ohio | 39095 | 65169 | 1044 |
2003966 | 2003966 | 2021-12-11 | Lucas | Ohio | 39095 | 65001 | 1044 |
2000715 | 2000715 | 2021-12-10 | Lucas | Ohio | 39095 | 64792 | 1044 |
1997465 | 1997465 | 2021-12-09 | Lucas | Ohio | 39095 | 64550 | 1030 |
1994214 | 1994214 | 2021-12-08 | Lucas | Ohio | 39095 | 64256 | 1030 |
1990963 | 1990963 | 2021-12-07 | Lucas | Ohio | 39095 | 64042 | 1030 |
1987712 | 1987712 | 2021-12-06 | Lucas | Ohio | 39095 | 63786 | 1027 |
1984462 | 1984462 | 2021-12-05 | Lucas | Ohio | 39095 | 63614 | 1027 |
1981212 | 1981212 | 2021-12-04 | Lucas | Ohio | 39095 | 63370 | 1027 |
1977962 | 1977962 | 2021-12-03 | Lucas | Ohio | 39095 | 63029 | 1027 |
1974712 | 1974712 | 2021-12-02 | Lucas | Ohio | 39095 | 62708 | 1020 |
1971463 | 1971463 | 2021-12-01 | Lucas | Ohio | 39095 | 62385 | 1020 |
1968213 | 1968213 | 2021-11-30 | Lucas | Ohio | 39095 | 62024 | 1020 |
1964962 | 1964962 | 2021-11-29 | Lucas | Ohio | 39095 | 61843 | 1017 |
1961710 | 1961710 | 2021-11-28 | Lucas | Ohio | 39095 | 61688 | 1017 |
1958459 | 1958459 | 2021-11-27 | Lucas | Ohio | 39095 | 61533 | 1017 |
1955208 | 1955208 | 2021-11-26 | Lucas | Ohio | 39095 | 61399 | 1017 |
1951957 | 1951957 | 2021-11-25 | Lucas | Ohio | 39095 | 61065 | 1011 |
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 |
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);