ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
161 rows where deaths = 150 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2403978 | 2403978 | 2022-04-13 | Guernsey | Ohio | 39059 | 10458 | 150 |
2400723 | 2400723 | 2022-04-12 | Guernsey | Ohio | 39059 | 10458 | 150 |
2397468 | 2397468 | 2022-04-11 | Guernsey | Ohio | 39059 | 10458 | 150 |
2394213 | 2394213 | 2022-04-10 | Guernsey | Ohio | 39059 | 10458 | 150 |
2390957 | 2390957 | 2022-04-09 | Guernsey | Ohio | 39059 | 10458 | 150 |
2387701 | 2387701 | 2022-04-08 | Guernsey | Ohio | 39059 | 10458 | 150 |
2384446 | 2384446 | 2022-04-07 | Guernsey | Ohio | 39059 | 10458 | 150 |
2358417 | 2358417 | 2022-03-30 | Guernsey | Ohio | 39059 | 10445 | 150 |
2355163 | 2355163 | 2022-03-29 | Guernsey | Ohio | 39059 | 10445 | 150 |
2351910 | 2351910 | 2022-03-28 | Guernsey | Ohio | 39059 | 10445 | 150 |
2348658 | 2348658 | 2022-03-27 | Guernsey | Ohio | 39059 | 10445 | 150 |
2345405 | 2345405 | 2022-03-26 | Guernsey | Ohio | 39059 | 10445 | 150 |
2342152 | 2342152 | 2022-03-25 | Guernsey | Ohio | 39059 | 10445 | 150 |
2338899 | 2338899 | 2022-03-24 | Guernsey | Ohio | 39059 | 10445 | 150 |
2335645 | 2335645 | 2022-03-23 | Guernsey | Ohio | 39059 | 10429 | 150 |
2335648 | 2335648 | 2022-03-23 | Hardin | Ohio | 39065 | 7055 | 150 |
2332391 | 2332391 | 2022-03-22 | Guernsey | Ohio | 39059 | 10429 | 150 |
2332394 | 2332394 | 2022-03-22 | Hardin | Ohio | 39065 | 7055 | 150 |
2329138 | 2329138 | 2022-03-21 | Guernsey | Ohio | 39059 | 10429 | 150 |
2329141 | 2329141 | 2022-03-21 | Hardin | Ohio | 39065 | 7055 | 150 |
2325886 | 2325886 | 2022-03-20 | Guernsey | Ohio | 39059 | 10429 | 150 |
2325889 | 2325889 | 2022-03-20 | Hardin | Ohio | 39065 | 7055 | 150 |
2322633 | 2322633 | 2022-03-19 | Guernsey | Ohio | 39059 | 10429 | 150 |
2322636 | 2322636 | 2022-03-19 | Hardin | Ohio | 39065 | 7055 | 150 |
2319379 | 2319379 | 2022-03-18 | Guernsey | Ohio | 39059 | 10429 | 150 |
2319382 | 2319382 | 2022-03-18 | Hardin | Ohio | 39065 | 7055 | 150 |
2316125 | 2316125 | 2022-03-17 | Guernsey | Ohio | 39059 | 10429 | 150 |
2316128 | 2316128 | 2022-03-17 | Hardin | Ohio | 39065 | 7055 | 150 |
2312872 | 2312872 | 2022-03-16 | Guernsey | Ohio | 39059 | 10419 | 150 |
2312875 | 2312875 | 2022-03-16 | Hardin | Ohio | 39065 | 7053 | 150 |
2309619 | 2309619 | 2022-03-15 | Guernsey | Ohio | 39059 | 10419 | 150 |
2309622 | 2309622 | 2022-03-15 | Hardin | Ohio | 39065 | 7053 | 150 |
2306366 | 2306366 | 2022-03-14 | Guernsey | Ohio | 39059 | 10419 | 150 |
2306369 | 2306369 | 2022-03-14 | Hardin | Ohio | 39065 | 7053 | 150 |
2303115 | 2303115 | 2022-03-13 | Guernsey | Ohio | 39059 | 10419 | 150 |
2303118 | 2303118 | 2022-03-13 | Hardin | Ohio | 39065 | 7053 | 150 |
2299863 | 2299863 | 2022-03-12 | Guernsey | Ohio | 39059 | 10418 | 150 |
2299866 | 2299866 | 2022-03-12 | Hardin | Ohio | 39065 | 7051 | 150 |
2296611 | 2296611 | 2022-03-11 | Guernsey | Ohio | 39059 | 10417 | 150 |
2296614 | 2296614 | 2022-03-11 | Hardin | Ohio | 39065 | 7051 | 150 |
2293362 | 2293362 | 2022-03-10 | Hardin | Ohio | 39065 | 7050 | 150 |
2290110 | 2290110 | 2022-03-09 | Hardin | Ohio | 39065 | 7049 | 150 |
2286858 | 2286858 | 2022-03-08 | Hardin | Ohio | 39065 | 7047 | 150 |
2270578 | 2270578 | 2022-03-03 | Coshocton | Ohio | 39031 | 7909 | 150 |
2267326 | 2267326 | 2022-03-02 | Coshocton | Ohio | 39031 | 7906 | 150 |
2264073 | 2264073 | 2022-03-01 | Coshocton | Ohio | 39031 | 7905 | 150 |
2260823 | 2260823 | 2022-02-28 | Coshocton | Ohio | 39031 | 7902 | 150 |
2257572 | 2257572 | 2022-02-27 | Coshocton | Ohio | 39031 | 7899 | 150 |
2254321 | 2254321 | 2022-02-26 | Coshocton | Ohio | 39031 | 7898 | 150 |
2251070 | 2251070 | 2022-02-25 | Coshocton | Ohio | 39031 | 7896 | 150 |
2247819 | 2247819 | 2022-02-24 | Coshocton | Ohio | 39031 | 7891 | 150 |
2247872 | 2247872 | 2022-02-24 | Putnam | Ohio | 39137 | 8410 | 150 |
2244568 | 2244568 | 2022-02-23 | Coshocton | Ohio | 39031 | 7888 | 150 |
2244621 | 2244621 | 2022-02-23 | Putnam | Ohio | 39137 | 8409 | 150 |
2241317 | 2241317 | 2022-02-22 | Coshocton | Ohio | 39031 | 7888 | 150 |
2241370 | 2241370 | 2022-02-22 | Putnam | Ohio | 39137 | 8408 | 150 |
2192608 | 2192608 | 2022-02-07 | Williams | Ohio | 39171 | 8760 | 150 |
2189354 | 2189354 | 2022-02-06 | Williams | Ohio | 39171 | 8758 | 150 |
2186101 | 2186101 | 2022-02-05 | Williams | Ohio | 39171 | 8751 | 150 |
2182849 | 2182849 | 2022-02-04 | Williams | Ohio | 39171 | 8733 | 150 |
2133983 | 2133983 | 2022-01-20 | Fulton | Ohio | 39051 | 9531 | 150 |
2130731 | 2130731 | 2022-01-19 | Fulton | Ohio | 39051 | 9453 | 150 |
2127477 | 2127477 | 2022-01-18 | Fulton | Ohio | 39051 | 9310 | 150 |
2078744 | 2078744 | 2022-01-03 | Preble | Ohio | 39135 | 7169 | 150 |
2075493 | 2075493 | 2022-01-02 | Preble | Ohio | 39135 | 7128 | 150 |
2072242 | 2072242 | 2022-01-01 | Preble | Ohio | 39135 | 7062 | 150 |
2068991 | 2068991 | 2021-12-31 | Preble | Ohio | 39135 | 7062 | 150 |
1987681 | 1987681 | 2021-12-06 | Crawford | Ohio | 39033 | 7376 | 150 |
1984431 | 1984431 | 2021-12-05 | Crawford | Ohio | 39033 | 7356 | 150 |
1981181 | 1981181 | 2021-12-04 | Crawford | Ohio | 39033 | 7327 | 150 |
1977931 | 1977931 | 2021-12-03 | Crawford | Ohio | 39033 | 7281 | 150 |
1974681 | 1974681 | 2021-12-02 | Crawford | Ohio | 39033 | 7233 | 150 |
1971432 | 1971432 | 2021-12-01 | Crawford | Ohio | 39033 | 7175 | 150 |
1968182 | 1968182 | 2021-11-30 | Crawford | Ohio | 39033 | 7129 | 150 |
1964931 | 1964931 | 2021-11-29 | Crawford | Ohio | 39033 | 7082 | 150 |
1961679 | 1961679 | 2021-11-28 | Crawford | Ohio | 39033 | 7034 | 150 |
1958428 | 1958428 | 2021-11-27 | Crawford | Ohio | 39033 | 7010 | 150 |
1955177 | 1955177 | 2021-11-26 | Crawford | Ohio | 39033 | 6995 | 150 |
1896732 | 1896732 | 2021-11-08 | Seneca | Ohio | 39147 | 7901 | 150 |
1893482 | 1893482 | 2021-11-07 | Seneca | Ohio | 39147 | 7854 | 150 |
1890232 | 1890232 | 2021-11-06 | Seneca | Ohio | 39147 | 7823 | 150 |
1886982 | 1886982 | 2021-11-05 | Seneca | Ohio | 39147 | 7804 | 150 |
1883743 | 1883743 | 2021-11-04 | Washington | Ohio | 39167 | 8230 | 150 |
1880494 | 1880494 | 2021-11-03 | Washington | Ohio | 39167 | 8217 | 150 |
1877245 | 1877245 | 2021-11-02 | Washington | Ohio | 39167 | 8209 | 150 |
1838201 | 1838201 | 2021-10-21 | Hancock | Ohio | 39063 | 9649 | 150 |
1834952 | 1834952 | 2021-10-20 | Hancock | Ohio | 39063 | 9618 | 150 |
1831703 | 1831703 | 2021-10-19 | Hancock | Ohio | 39063 | 9579 | 150 |
1815445 | 1815445 | 2021-10-14 | Darke | Ohio | 39037 | 7501 | 150 |
1812197 | 1812197 | 2021-10-13 | Darke | Ohio | 39037 | 7477 | 150 |
1808948 | 1808948 | 2021-10-12 | Darke | Ohio | 39037 | 7423 | 150 |
1782957 | 1782957 | 2021-10-04 | Delaware | Ohio | 39041 | 23156 | 150 |
1779708 | 1779708 | 2021-10-03 | Delaware | Ohio | 39041 | 23105 | 150 |
1776458 | 1776458 | 2021-10-02 | Delaware | Ohio | 39041 | 23059 | 150 |
1773208 | 1773208 | 2021-10-01 | Delaware | Ohio | 39041 | 22997 | 150 |
1760241 | 1760241 | 2021-09-27 | Marion | Ohio | 39101 | 10960 | 150 |
1756993 | 1756993 | 2021-09-26 | Marion | Ohio | 39101 | 10935 | 150 |
1753745 | 1753745 | 2021-09-25 | Marion | Ohio | 39101 | 10908 | 150 |
1750497 | 1750497 | 2021-09-24 | Marion | Ohio | 39101 | 10865 | 150 |
1428953 | 1428953 | 2021-06-17 | Geauga | Ohio | 39055 | 6834 | 150 |
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);