ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where deaths = 92 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2247883 | 2247883 | 2022-02-24 | Union | Ohio | 39159 | 15456 | 92 |
2244632 | 2244632 | 2022-02-23 | Union | Ohio | 39159 | 15449 | 92 |
2241381 | 2241381 | 2022-02-22 | Union | Ohio | 39159 | 15443 | 92 |
2147000 | 2147000 | 2022-01-24 | Fayette | Ohio | 39047 | 7159 | 92 |
2143746 | 2143746 | 2022-01-23 | Fayette | Ohio | 39047 | 7086 | 92 |
2140491 | 2140491 | 2022-01-22 | Fayette | Ohio | 39047 | 7032 | 92 |
2137235 | 2137235 | 2022-01-21 | Fayette | Ohio | 39047 | 6965 | 92 |
2124234 | 2124234 | 2022-01-17 | Henry | Ohio | 39069 | 5655 | 92 |
2120982 | 2120982 | 2022-01-16 | Henry | Ohio | 39069 | 5611 | 92 |
2117730 | 2117730 | 2022-01-15 | Henry | Ohio | 39069 | 5573 | 92 |
2114479 | 2114479 | 2022-01-14 | Henry | Ohio | 39069 | 5482 | 92 |
2078740 | 2078740 | 2022-01-03 | Perry | Ohio | 39127 | 6363 | 92 |
2075489 | 2075489 | 2022-01-02 | Perry | Ohio | 39127 | 6331 | 92 |
2072238 | 2072238 | 2022-01-01 | Perry | Ohio | 39127 | 6252 | 92 |
2068987 | 2068987 | 2021-12-31 | Perry | Ohio | 39127 | 6252 | 92 |
1942196 | 1942196 | 2021-11-22 | Jackson | Ohio | 39079 | 5622 | 92 |
1938946 | 1938946 | 2021-11-21 | Jackson | Ohio | 39079 | 5597 | 92 |
1935696 | 1935696 | 2021-11-20 | Jackson | Ohio | 39079 | 5594 | 92 |
1932446 | 1932446 | 2021-11-19 | Jackson | Ohio | 39079 | 5580 | 92 |
1906412 | 1906412 | 2021-11-11 | Athens | Ohio | 39009 | 8040 | 92 |
1906494 | 1906494 | 2021-11-11 | Williams | Ohio | 39171 | 5722 | 92 |
1903163 | 1903163 | 2021-11-10 | Athens | Ohio | 39009 | 8026 | 92 |
1903245 | 1903245 | 2021-11-10 | Williams | Ohio | 39171 | 5688 | 92 |
1899913 | 1899913 | 2021-11-09 | Athens | Ohio | 39009 | 8022 | 92 |
1899995 | 1899995 | 2021-11-09 | Williams | Ohio | 39171 | 5657 | 92 |
1896663 | 1896663 | 2021-11-08 | Athens | Ohio | 39009 | 8018 | 92 |
1896745 | 1896745 | 2021-11-08 | Williams | Ohio | 39171 | 5603 | 92 |
1893413 | 1893413 | 2021-11-07 | Athens | Ohio | 39009 | 8014 | 92 |
1893495 | 1893495 | 2021-11-07 | Williams | Ohio | 39171 | 5598 | 92 |
1890163 | 1890163 | 2021-11-06 | Athens | Ohio | 39009 | 8006 | 92 |
1890245 | 1890245 | 2021-11-06 | Williams | Ohio | 39171 | 5568 | 92 |
1886913 | 1886913 | 2021-11-05 | Athens | Ohio | 39009 | 7955 | 92 |
1886995 | 1886995 | 2021-11-05 | Williams | Ohio | 39171 | 5556 | 92 |
1883745 | 1883745 | 2021-11-04 | Williams | Ohio | 39171 | 5537 | 92 |
1880496 | 1880496 | 2021-11-03 | Williams | Ohio | 39171 | 5496 | 92 |
1877247 | 1877247 | 2021-11-02 | Williams | Ohio | 39171 | 5467 | 92 |
1860923 | 1860923 | 2021-10-28 | Brown | Ohio | 39015 | 6461 | 92 |
1857674 | 1857674 | 2021-10-27 | Brown | Ohio | 39015 | 6441 | 92 |
1854425 | 1854425 | 2021-10-26 | Brown | Ohio | 39015 | 6419 | 92 |
1838170 | 1838170 | 2021-10-21 | Adams | Ohio | 39001 | 4153 | 92 |
1834921 | 1834921 | 2021-10-20 | Adams | Ohio | 39001 | 4139 | 92 |
1831672 | 1831672 | 2021-10-19 | Adams | Ohio | 39001 | 4133 | 92 |
1828468 | 1828468 | 2021-10-18 | Logan | Ohio | 39091 | 5746 | 92 |
1825219 | 1825219 | 2021-10-17 | Logan | Ohio | 39091 | 5710 | 92 |
1821970 | 1821970 | 2021-10-16 | Logan | Ohio | 39091 | 5690 | 92 |
1818721 | 1818721 | 2021-10-15 | Logan | Ohio | 39091 | 5662 | 92 |
1815452 | 1815452 | 2021-10-14 | Fulton | Ohio | 39051 | 5866 | 92 |
1815480 | 1815480 | 2021-10-14 | Mercer | Ohio | 39107 | 6034 | 92 |
1812204 | 1812204 | 2021-10-13 | Fulton | Ohio | 39051 | 5844 | 92 |
1812232 | 1812232 | 2021-10-13 | Mercer | Ohio | 39107 | 6012 | 92 |
1808955 | 1808955 | 2021-10-12 | Fulton | Ohio | 39051 | 5813 | 92 |
1808983 | 1808983 | 2021-10-12 | Mercer | Ohio | 39107 | 5994 | 92 |
1782972 | 1782972 | 2021-10-04 | Highland | Ohio | 39071 | 5673 | 92 |
1779723 | 1779723 | 2021-10-03 | Highland | Ohio | 39071 | 5662 | 92 |
1776473 | 1776473 | 2021-10-02 | Highland | Ohio | 39071 | 5646 | 92 |
1773223 | 1773223 | 2021-10-01 | Highland | Ohio | 39071 | 5633 | 92 |
1360771 | 1360771 | 2021-05-27 | Ashland | Ohio | 39005 | 4322 | 92 |
1357525 | 1357525 | 2021-05-26 | Ashland | Ohio | 39005 | 4315 | 92 |
1354279 | 1354279 | 2021-05-25 | Ashland | Ohio | 39005 | 4311 | 92 |
1351033 | 1351033 | 2021-05-24 | Ashland | Ohio | 39005 | 4306 | 92 |
1347787 | 1347787 | 2021-05-23 | Ashland | Ohio | 39005 | 4304 | 92 |
1344539 | 1344539 | 2021-05-22 | Ashland | Ohio | 39005 | 4302 | 92 |
1341291 | 1341291 | 2021-05-21 | Ashland | Ohio | 39005 | 4297 | 92 |
1247208 | 1247208 | 2021-04-22 | Shelby | Ohio | 39149 | 4608 | 92 |
1243961 | 1243961 | 2021-04-21 | Shelby | Ohio | 39149 | 4580 | 92 |
1240714 | 1240714 | 2021-04-20 | Shelby | Ohio | 39149 | 4571 | 92 |
1055637 | 1055637 | 2021-02-22 | Sandusky | Ohio | 39143 | 4714 | 92 |
1052322 | 1052322 | 2021-02-21 | Ashland | Ohio | 39005 | 3733 | 92 |
1052391 | 1052391 | 2021-02-21 | Sandusky | Ohio | 39143 | 4707 | 92 |
1049075 | 1049075 | 2021-02-20 | Ashland | Ohio | 39005 | 3729 | 92 |
1049144 | 1049144 | 2021-02-20 | Sandusky | Ohio | 39143 | 4705 | 92 |
1045828 | 1045828 | 2021-02-19 | Ashland | Ohio | 39005 | 3723 | 92 |
1045890 | 1045890 | 2021-02-19 | Pickaway | Ohio | 39129 | 7911 | 92 |
1045897 | 1045897 | 2021-02-19 | Sandusky | Ohio | 39143 | 4696 | 92 |
1042645 | 1042645 | 2021-02-18 | Pickaway | Ohio | 39129 | 7893 | 92 |
1039400 | 1039400 | 2021-02-17 | Pickaway | Ohio | 39129 | 7877 | 92 |
1036155 | 1036155 | 2021-02-16 | Pickaway | Ohio | 39129 | 7869 | 92 |
1023124 | 1023124 | 2021-02-12 | Crawford | Ohio | 39033 | 3472 | 92 |
1013392 | 1013392 | 2021-02-09 | Defiance | Ohio | 39039 | 3555 | 92 |
1010147 | 1010147 | 2021-02-08 | Defiance | Ohio | 39039 | 3536 | 92 |
987459 | 987459 | 2021-02-01 | Mercer | Ohio | 39107 | 4428 | 92 |
984212 | 984212 | 2021-01-31 | Mercer | Ohio | 39107 | 4422 | 92 |
980965 | 980965 | 2021-01-30 | Mercer | Ohio | 39107 | 4411 | 92 |
977719 | 977719 | 2021-01-29 | Mercer | Ohio | 39107 | 4406 | 92 |
971207 | 971207 | 2021-01-27 | Hancock | Ohio | 39063 | 5591 | 92 |
967962 | 967962 | 2021-01-26 | Hancock | Ohio | 39063 | 5562 | 92 |
964705 | 964705 | 2021-01-25 | Darke | Ohio | 39037 | 4734 | 92 |
964718 | 964718 | 2021-01-25 | Hancock | Ohio | 39063 | 5552 | 92 |
961460 | 961460 | 2021-01-24 | Darke | Ohio | 39037 | 4710 | 92 |
958215 | 958215 | 2021-01-23 | Darke | Ohio | 39037 | 4702 | 92 |
954969 | 954969 | 2021-01-22 | Darke | Ohio | 39037 | 4678 | 92 |
906284 | 906284 | 2021-01-07 | Clermont | Ohio | 39025 | 13398 | 92 |
851123 | 851123 | 2020-12-21 | Erie | Ohio | 39043 | 4256 | 92 |
831657 | 831657 | 2020-12-15 | Greene | Ohio | 39057 | 8031 | 92 |
815475 | 815475 | 2020-12-10 | Tuscarawas | Ohio | 39157 | 4765 | 92 |
815479 | 815479 | 2020-12-10 | Warren | Ohio | 39165 | 11705 | 92 |
812229 | 812229 | 2020-12-09 | Tuscarawas | Ohio | 39157 | 4638 | 92 |
750577 | 750577 | 2020-11-20 | Wayne | Ohio | 39169 | 2933 | 92 |
747331 | 747331 | 2020-11-19 | Wayne | Ohio | 39169 | 2870 | 92 |
737522 | 737522 | 2020-11-16 | Columbiana | Ohio | 39029 | 2859 | 92 |
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);