ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where deaths = 188 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501718 | 2501718 | 2022-05-13 | Shelby | Ohio | 39149 | 11102 | 188 |
2498460 | 2498460 | 2022-05-12 | Shelby | Ohio | 39149 | 11102 | 188 |
2403954 | 2403954 | 2022-04-13 | Auglaize | Ohio | 39011 | 11574 | 188 |
2400699 | 2400699 | 2022-04-12 | Auglaize | Ohio | 39011 | 11574 | 188 |
2397444 | 2397444 | 2022-04-11 | Auglaize | Ohio | 39011 | 11574 | 188 |
2394189 | 2394189 | 2022-04-10 | Auglaize | Ohio | 39011 | 11574 | 188 |
2390933 | 2390933 | 2022-04-09 | Auglaize | Ohio | 39011 | 11574 | 188 |
2387677 | 2387677 | 2022-04-08 | Auglaize | Ohio | 39011 | 11574 | 188 |
2384422 | 2384422 | 2022-04-07 | Auglaize | Ohio | 39011 | 11574 | 188 |
2156736 | 2156736 | 2022-01-27 | Ashland | Ohio | 39005 | 11438 | 188 |
2153483 | 2153483 | 2022-01-26 | Ashland | Ohio | 39005 | 11358 | 188 |
2150231 | 2150231 | 2022-01-25 | Ashland | Ohio | 39005 | 11273 | 188 |
2078750 | 2078750 | 2022-01-03 | Seneca | Ohio | 39147 | 10087 | 188 |
2075499 | 2075499 | 2022-01-02 | Seneca | Ohio | 39147 | 10016 | 188 |
2072248 | 2072248 | 2022-01-01 | Seneca | Ohio | 39147 | 9935 | 188 |
2068997 | 2068997 | 2021-12-31 | Seneca | Ohio | 39147 | 9935 | 188 |
1997490 | 1997490 | 2021-12-09 | Scioto | Ohio | 39145 | 12727 | 188 |
1994239 | 1994239 | 2021-12-08 | Scioto | Ohio | 39145 | 12670 | 188 |
1990988 | 1990988 | 2021-12-07 | Scioto | Ohio | 39145 | 12618 | 188 |
1987737 | 1987737 | 2021-12-06 | Scioto | Ohio | 39145 | 12586 | 188 |
1984487 | 1984487 | 2021-12-05 | Scioto | Ohio | 39145 | 12556 | 188 |
1981237 | 1981237 | 2021-12-04 | Scioto | Ohio | 39145 | 12517 | 188 |
1977987 | 1977987 | 2021-12-03 | Scioto | Ohio | 39145 | 12475 | 188 |
1929206 | 1929206 | 2021-11-18 | Marion | Ohio | 39101 | 12708 | 188 |
1925956 | 1925956 | 2021-11-17 | Marion | Ohio | 39101 | 12662 | 188 |
1922706 | 1922706 | 2021-11-16 | Marion | Ohio | 39101 | 12594 | 188 |
1805750 | 1805750 | 2021-10-11 | Ross | Ohio | 39141 | 10273 | 188 |
1802500 | 1802500 | 2021-10-10 | Ross | Ohio | 39141 | 10255 | 188 |
1799251 | 1799251 | 2021-10-09 | Ross | Ohio | 39141 | 10223 | 188 |
1796002 | 1796002 | 2021-10-08 | Ross | Ohio | 39141 | 10169 | 188 |
1769941 | 1769941 | 2021-09-30 | Ashtabula | Ohio | 39007 | 8682 | 188 |
1766692 | 1766692 | 2021-09-29 | Ashtabula | Ohio | 39007 | 8613 | 188 |
1763443 | 1763443 | 2021-09-28 | Ashtabula | Ohio | 39007 | 8566 | 188 |
1760197 | 1760197 | 2021-09-27 | Belmont | Ohio | 39013 | 8301 | 188 |
1756949 | 1756949 | 2021-09-26 | Belmont | Ohio | 39013 | 8262 | 188 |
1753701 | 1753701 | 2021-09-25 | Belmont | Ohio | 39013 | 8236 | 188 |
1750453 | 1750453 | 2021-09-24 | Belmont | Ohio | 39013 | 8221 | 188 |
1292676 | 1292676 | 2021-05-06 | Wood | Ohio | 39173 | 13056 | 188 |
1289430 | 1289430 | 2021-05-05 | Wood | Ohio | 39173 | 13038 | 188 |
1286184 | 1286184 | 2021-05-04 | Wood | Ohio | 39173 | 13020 | 188 |
1282938 | 1282938 | 2021-05-03 | Wood | Ohio | 39173 | 12997 | 188 |
1279691 | 1279691 | 2021-05-02 | Wood | Ohio | 39173 | 12985 | 188 |
1276444 | 1276444 | 2021-05-01 | Wood | Ohio | 39173 | 12973 | 188 |
1273197 | 1273197 | 2021-04-30 | Wood | Ohio | 39173 | 12962 | 188 |
1110766 | 1110766 | 2021-03-11 | Fairfield | Ohio | 39045 | 14745 | 188 |
1107520 | 1107520 | 2021-03-10 | Fairfield | Ohio | 39045 | 14722 | 188 |
1104274 | 1104274 | 2021-03-09 | Fairfield | Ohio | 39045 | 14697 | 188 |
1101028 | 1101028 | 2021-03-08 | Fairfield | Ohio | 39045 | 14667 | 188 |
1101075 | 1101075 | 2021-03-08 | Richland | Ohio | 39139 | 10384 | 188 |
1097782 | 1097782 | 2021-03-07 | Fairfield | Ohio | 39045 | 14653 | 188 |
1097829 | 1097829 | 2021-03-07 | Richland | Ohio | 39139 | 10376 | 188 |
1094534 | 1094534 | 2021-03-06 | Fairfield | Ohio | 39045 | 14644 | 188 |
1094581 | 1094581 | 2021-03-06 | Richland | Ohio | 39139 | 10372 | 188 |
1091288 | 1091288 | 2021-03-05 | Fairfield | Ohio | 39045 | 14622 | 188 |
1091335 | 1091335 | 2021-03-05 | Richland | Ohio | 39139 | 10360 | 188 |
906318 | 906318 | 2021-01-07 | Lorain | Ohio | 39093 | 16187 | 188 |
903072 | 903072 | 2021-01-06 | Lorain | Ohio | 39093 | 15924 | 188 |
893298 | 893298 | 2021-01-03 | Butler | Ohio | 39017 | 26461 | 188 |
890052 | 890052 | 2021-01-02 | Butler | Ohio | 39017 | 26229 | 188 |
886805 | 886805 | 2021-01-01 | Butler | Ohio | 39017 | 25723 | 188 |
883560 | 883560 | 2020-12-31 | Butler | Ohio | 39017 | 25723 | 188 |
880315 | 880315 | 2020-12-30 | Butler | Ohio | 39017 | 25416 | 188 |
267091 | 267091 | 2020-06-23 | Hamilton | Ohio | 39061 | 4098 | 188 |
229747 | 229747 | 2020-06-11 | Summit | Ohio | 39153 | 1623 | 188 |
204990 | 204990 | 2020-06-03 | Mahoning | Ohio | 39099 | 1463 | 188 |
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);