ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where deaths = 146 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472405 | 2472405 | 2022-05-04 | Van Wert | Ohio | 39161 | 6720 | 146 |
2469149 | 2469149 | 2022-05-03 | Van Wert | Ohio | 39161 | 6720 | 146 |
2465893 | 2465893 | 2022-05-02 | Van Wert | Ohio | 39161 | 6720 | 146 |
2462638 | 2462638 | 2022-05-01 | Van Wert | Ohio | 39161 | 6720 | 146 |
2459382 | 2459382 | 2022-04-30 | Van Wert | Ohio | 39161 | 6720 | 146 |
2456126 | 2456126 | 2022-04-29 | Van Wert | Ohio | 39161 | 6720 | 146 |
2452870 | 2452870 | 2022-04-28 | Van Wert | Ohio | 39161 | 6720 | 146 |
2403949 | 2403949 | 2022-04-13 | Adams | Ohio | 39001 | 6966 | 146 |
2400694 | 2400694 | 2022-04-12 | Adams | Ohio | 39001 | 6966 | 146 |
2397439 | 2397439 | 2022-04-11 | Adams | Ohio | 39001 | 6966 | 146 |
2394184 | 2394184 | 2022-04-10 | Adams | Ohio | 39001 | 6966 | 146 |
2390928 | 2390928 | 2022-04-09 | Adams | Ohio | 39001 | 6966 | 146 |
2387672 | 2387672 | 2022-04-08 | Adams | Ohio | 39001 | 6966 | 146 |
2384417 | 2384417 | 2022-04-07 | Adams | Ohio | 39001 | 6966 | 146 |
2358398 | 2358398 | 2022-03-30 | Champaign | Ohio | 39021 | 8701 | 146 |
2355144 | 2355144 | 2022-03-29 | Champaign | Ohio | 39021 | 8701 | 146 |
2351891 | 2351891 | 2022-03-28 | Champaign | Ohio | 39021 | 8701 | 146 |
2348639 | 2348639 | 2022-03-27 | Champaign | Ohio | 39021 | 8701 | 146 |
2345386 | 2345386 | 2022-03-26 | Champaign | Ohio | 39021 | 8701 | 146 |
2342133 | 2342133 | 2022-03-25 | Champaign | Ohio | 39021 | 8701 | 146 |
2338880 | 2338880 | 2022-03-24 | Champaign | Ohio | 39021 | 8701 | 146 |
2260840 | 2260840 | 2022-02-28 | Hardin | Ohio | 39065 | 7032 | 146 |
2257589 | 2257589 | 2022-02-27 | Hardin | Ohio | 39065 | 7030 | 146 |
2254338 | 2254338 | 2022-02-26 | Hardin | Ohio | 39065 | 7030 | 146 |
2251087 | 2251087 | 2022-02-25 | Hardin | Ohio | 39065 | 7028 | 146 |
2202297 | 2202297 | 2022-02-10 | Clinton | Ohio | 39027 | 10133 | 146 |
2199043 | 2199043 | 2022-02-09 | Clinton | Ohio | 39027 | 10115 | 146 |
2195789 | 2195789 | 2022-02-08 | Clinton | Ohio | 39027 | 10096 | 146 |
2179530 | 2179530 | 2022-02-03 | Defiance | Ohio | 39039 | 9950 | 146 |
2176279 | 2176279 | 2022-02-02 | Defiance | Ohio | 39039 | 9937 | 146 |
2173025 | 2173025 | 2022-02-01 | Defiance | Ohio | 39039 | 9894 | 146 |
2169840 | 2169840 | 2022-01-31 | Williams | Ohio | 39171 | 8649 | 146 |
2166585 | 2166585 | 2022-01-30 | Williams | Ohio | 39171 | 8625 | 146 |
2163330 | 2163330 | 2022-01-29 | Williams | Ohio | 39171 | 8609 | 146 |
2160075 | 2160075 | 2022-01-28 | Williams | Ohio | 39171 | 8574 | 146 |
2156741 | 2156741 | 2022-01-27 | Brown | Ohio | 39015 | 10447 | 146 |
2153488 | 2153488 | 2022-01-26 | Brown | Ohio | 39015 | 10360 | 146 |
2150236 | 2150236 | 2022-01-25 | Brown | Ohio | 39015 | 10137 | 146 |
2055991 | 2055991 | 2021-12-27 | Preble | Ohio | 39135 | 6899 | 146 |
2052742 | 2052742 | 2021-12-26 | Preble | Ohio | 39135 | 6887 | 146 |
2049492 | 2049492 | 2021-12-25 | Preble | Ohio | 39135 | 6861 | 146 |
2046242 | 2046242 | 2021-12-24 | Preble | Ohio | 39135 | 6861 | 146 |
2033213 | 2033213 | 2021-12-20 | Holmes | Ohio | 39075 | 4176 | 146 |
2029963 | 2029963 | 2021-12-19 | Holmes | Ohio | 39075 | 4167 | 146 |
2026712 | 2026712 | 2021-12-18 | Holmes | Ohio | 39075 | 4164 | 146 |
2023461 | 2023461 | 2021-12-17 | Holmes | Ohio | 39075 | 4155 | 146 |
1951912 | 1951912 | 2021-11-25 | Ashland | Ohio | 39005 | 7710 | 146 |
1948661 | 1948661 | 2021-11-24 | Ashland | Ohio | 39005 | 7710 | 146 |
1945410 | 1945410 | 2021-11-23 | Ashland | Ohio | 39005 | 7677 | 146 |
1942159 | 1942159 | 2021-11-22 | Ashland | Ohio | 39005 | 7632 | 146 |
1938909 | 1938909 | 2021-11-21 | Ashland | Ohio | 39005 | 7607 | 146 |
1935659 | 1935659 | 2021-11-20 | Ashland | Ohio | 39005 | 7595 | 146 |
1932409 | 1932409 | 2021-11-19 | Ashland | Ohio | 39005 | 7561 | 146 |
1929158 | 1929158 | 2021-11-18 | Ashland | Ohio | 39005 | 7526 | 146 |
1925908 | 1925908 | 2021-11-17 | Ashland | Ohio | 39005 | 7472 | 146 |
1922658 | 1922658 | 2021-11-16 | Ashland | Ohio | 39005 | 7438 | 146 |
1919409 | 1919409 | 2021-11-15 | Ashland | Ohio | 39005 | 7413 | 146 |
1916159 | 1916159 | 2021-11-14 | Ashland | Ohio | 39005 | 7393 | 146 |
1912909 | 1912909 | 2021-11-13 | Ashland | Ohio | 39005 | 7377 | 146 |
1909659 | 1909659 | 2021-11-12 | Ashland | Ohio | 39005 | 7361 | 146 |
1883697 | 1883697 | 2021-11-04 | Huron | Ohio | 39077 | 8748 | 146 |
1880448 | 1880448 | 2021-11-03 | Huron | Ohio | 39077 | 8720 | 146 |
1877199 | 1877199 | 2021-11-02 | Huron | Ohio | 39077 | 8684 | 146 |
1860957 | 1860957 | 2021-10-28 | Knox | Ohio | 39083 | 7870 | 146 |
1860989 | 1860989 | 2021-10-28 | Seneca | Ohio | 39147 | 7519 | 146 |
1857708 | 1857708 | 2021-10-27 | Knox | Ohio | 39083 | 7837 | 146 |
1857740 | 1857740 | 2021-10-27 | Seneca | Ohio | 39147 | 7481 | 146 |
1854459 | 1854459 | 2021-10-26 | Knox | Ohio | 39083 | 7798 | 146 |
1854491 | 1854491 | 2021-10-26 | Seneca | Ohio | 39147 | 7446 | 146 |
1260149 | 1260149 | 2021-04-26 | Geauga | Ohio | 39055 | 6590 | 146 |
1256902 | 1256902 | 2021-04-25 | Geauga | Ohio | 39055 | 6586 | 146 |
1253655 | 1253655 | 2021-04-24 | Geauga | Ohio | 39055 | 6579 | 146 |
1250408 | 1250408 | 2021-04-23 | Geauga | Ohio | 39055 | 6574 | 146 |
1247161 | 1247161 | 2021-04-22 | Geauga | Ohio | 39055 | 6568 | 146 |
1247204 | 1247204 | 2021-04-22 | Ross | Ohio | 39141 | 6734 | 146 |
1243914 | 1243914 | 2021-04-21 | Geauga | Ohio | 39055 | 6563 | 146 |
1243957 | 1243957 | 2021-04-21 | Ross | Ohio | 39141 | 6727 | 146 |
1240667 | 1240667 | 2021-04-20 | Geauga | Ohio | 39055 | 6558 | 146 |
1240710 | 1240710 | 2021-04-20 | Ross | Ohio | 39141 | 6716 | 146 |
1237420 | 1237420 | 2021-04-19 | Geauga | Ohio | 39055 | 6553 | 146 |
1237463 | 1237463 | 2021-04-19 | Ross | Ohio | 39141 | 6707 | 146 |
1234173 | 1234173 | 2021-04-18 | Geauga | Ohio | 39055 | 6547 | 146 |
1234216 | 1234216 | 2021-04-18 | Ross | Ohio | 39141 | 6702 | 146 |
1230925 | 1230925 | 2021-04-17 | Geauga | Ohio | 39055 | 6537 | 146 |
1230968 | 1230968 | 2021-04-17 | Ross | Ohio | 39141 | 6699 | 146 |
1227677 | 1227677 | 2021-04-16 | Geauga | Ohio | 39055 | 6532 | 146 |
1227720 | 1227720 | 2021-04-16 | Ross | Ohio | 39141 | 6693 | 146 |
1224429 | 1224429 | 2021-04-15 | Geauga | Ohio | 39055 | 6527 | 146 |
1221182 | 1221182 | 2021-04-14 | Geauga | Ohio | 39055 | 6520 | 146 |
1217934 | 1217934 | 2021-04-13 | Geauga | Ohio | 39055 | 6497 | 146 |
1214686 | 1214686 | 2021-04-12 | Geauga | Ohio | 39055 | 6476 | 146 |
1211439 | 1211439 | 2021-04-11 | Geauga | Ohio | 39055 | 6462 | 146 |
1208190 | 1208190 | 2021-04-10 | Geauga | Ohio | 39055 | 6449 | 146 |
1204942 | 1204942 | 2021-04-09 | Geauga | Ohio | 39055 | 6435 | 146 |
1201707 | 1201707 | 2021-04-08 | Jefferson | Ohio | 39081 | 5184 | 146 |
1198458 | 1198458 | 2021-04-07 | Jefferson | Ohio | 39081 | 5160 | 146 |
1195209 | 1195209 | 2021-04-06 | Jefferson | Ohio | 39081 | 5141 | 146 |
1133477 | 1133477 | 2021-03-18 | Belmont | Ohio | 39013 | 5166 | 146 |
1130229 | 1130229 | 2021-03-17 | Belmont | Ohio | 39013 | 5152 | 146 |
1126982 | 1126982 | 2021-03-16 | Belmont | Ohio | 39013 | 5133 | 146 |
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);