ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
268 rows where deaths = 19 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Washington 22
- Madison 20
- Richland 17
- Auglaize 15
- Delaware 15
- Union 14
- Paulding 13
- Monroe 12
- Tuscarawas 9
- Hardin 7
- Sandusky 7
- Clinton 6
- Geauga 6
- Highland 6
- Lorain 6
- Seneca 6
- Guernsey 5
- Warren 5
- Brown 4
- Medina 4
- Mercer 4
- Muskingum 4
- Ottawa 4
- Vinton 4
- Clark 3
- Hocking 3
- Knox 3
- Morgan 3
- Preble 3
- Ross 3
- …
state 1
- Ohio · 268 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1760273 | 1760273 | 2021-09-27 | Vinton | Ohio | 39163 | 1431 | 19 |
1757025 | 1757025 | 2021-09-26 | Vinton | Ohio | 39163 | 1419 | 19 |
1753777 | 1753777 | 2021-09-25 | Vinton | Ohio | 39163 | 1413 | 19 |
1750529 | 1750529 | 2021-09-24 | Vinton | Ohio | 39163 | 1406 | 19 |
1088078 | 1088078 | 2021-03-04 | Morgan | Ohio | 39115 | 1011 | 19 |
1084833 | 1084833 | 2021-03-03 | Morgan | Ohio | 39115 | 1011 | 19 |
1081587 | 1081587 | 2021-03-02 | Morgan | Ohio | 39115 | 1009 | 19 |
1019872 | 1019872 | 2021-02-11 | Carroll | Ohio | 39019 | 1730 | 19 |
993963 | 993963 | 2021-02-03 | Pike | Ohio | 39131 | 1949 | 19 |
990717 | 990717 | 2021-02-02 | Pike | Ohio | 39131 | 1926 | 19 |
984194 | 984194 | 2021-01-31 | Highland | Ohio | 39071 | 2913 | 19 |
980947 | 980947 | 2021-01-30 | Highland | Ohio | 39071 | 2902 | 19 |
977701 | 977701 | 2021-01-29 | Highland | Ohio | 39071 | 2890 | 19 |
974456 | 974456 | 2021-01-28 | Highland | Ohio | 39071 | 2870 | 19 |
971211 | 971211 | 2021-01-27 | Highland | Ohio | 39071 | 2838 | 19 |
967966 | 967966 | 2021-01-26 | Highland | Ohio | 39071 | 2822 | 19 |
945222 | 945222 | 2021-01-19 | Brown | Ohio | 39015 | 2988 | 19 |
941975 | 941975 | 2021-01-18 | Brown | Ohio | 39015 | 2982 | 19 |
938730 | 938730 | 2021-01-17 | Brown | Ohio | 39015 | 2966 | 19 |
935485 | 935485 | 2021-01-16 | Brown | Ohio | 39015 | 2944 | 19 |
932248 | 932248 | 2021-01-15 | Coshocton | Ohio | 39031 | 1956 | 19 |
896598 | 896598 | 2021-01-04 | Paulding | Ohio | 39125 | 1229 | 19 |
896615 | 896615 | 2021-01-04 | Union | Ohio | 39159 | 3743 | 19 |
893352 | 893352 | 2021-01-03 | Paulding | Ohio | 39125 | 1225 | 19 |
893369 | 893369 | 2021-01-03 | Union | Ohio | 39159 | 3725 | 19 |
890106 | 890106 | 2021-01-02 | Paulding | Ohio | 39125 | 1220 | 19 |
890123 | 890123 | 2021-01-02 | Union | Ohio | 39159 | 3701 | 19 |
886859 | 886859 | 2021-01-01 | Paulding | Ohio | 39125 | 1187 | 19 |
886876 | 886876 | 2021-01-01 | Union | Ohio | 39159 | 3597 | 19 |
883614 | 883614 | 2020-12-31 | Paulding | Ohio | 39125 | 1187 | 19 |
883631 | 883631 | 2020-12-31 | Union | Ohio | 39159 | 3597 | 19 |
880369 | 880369 | 2020-12-30 | Paulding | Ohio | 39125 | 1147 | 19 |
880386 | 880386 | 2020-12-30 | Union | Ohio | 39159 | 3519 | 19 |
877124 | 877124 | 2020-12-29 | Paulding | Ohio | 39125 | 1137 | 19 |
877141 | 877141 | 2020-12-29 | Union | Ohio | 39159 | 3459 | 19 |
873879 | 873879 | 2020-12-28 | Paulding | Ohio | 39125 | 1125 | 19 |
873896 | 873896 | 2020-12-28 | Union | Ohio | 39159 | 3424 | 19 |
870601 | 870601 | 2020-12-27 | Guernsey | Ohio | 39059 | 1909 | 19 |
870634 | 870634 | 2020-12-27 | Paulding | Ohio | 39125 | 1125 | 19 |
870651 | 870651 | 2020-12-27 | Union | Ohio | 39159 | 3404 | 19 |
867356 | 867356 | 2020-12-26 | Guernsey | Ohio | 39059 | 1898 | 19 |
867389 | 867389 | 2020-12-26 | Paulding | Ohio | 39125 | 1121 | 19 |
867406 | 867406 | 2020-12-26 | Union | Ohio | 39159 | 3383 | 19 |
864111 | 864111 | 2020-12-25 | Guernsey | Ohio | 39059 | 1863 | 19 |
864144 | 864144 | 2020-12-25 | Paulding | Ohio | 39125 | 1106 | 19 |
864161 | 864161 | 2020-12-25 | Union | Ohio | 39159 | 3321 | 19 |
860866 | 860866 | 2020-12-24 | Guernsey | Ohio | 39059 | 1863 | 19 |
860899 | 860899 | 2020-12-24 | Paulding | Ohio | 39125 | 1106 | 19 |
860916 | 860916 | 2020-12-24 | Union | Ohio | 39159 | 3321 | 19 |
857621 | 857621 | 2020-12-23 | Guernsey | Ohio | 39059 | 1826 | 19 |
857654 | 857654 | 2020-12-23 | Paulding | Ohio | 39125 | 1092 | 19 |
857671 | 857671 | 2020-12-23 | Union | Ohio | 39159 | 3261 | 19 |
854373 | 854373 | 2020-12-22 | Gallia | Ohio | 39053 | 1494 | 19 |
854426 | 854426 | 2020-12-22 | Union | Ohio | 39159 | 3228 | 19 |
851128 | 851128 | 2020-12-21 | Gallia | Ohio | 39053 | 1467 | 19 |
844651 | 844651 | 2020-12-19 | Jackson | Ohio | 39079 | 1865 | 19 |
834885 | 834885 | 2020-12-16 | Champaign | Ohio | 39021 | 1554 | 19 |
831688 | 831688 | 2020-12-15 | Muskingum | Ohio | 39119 | 4248 | 19 |
831714 | 831714 | 2020-12-15 | Williams | Ohio | 39171 | 1829 | 19 |
828418 | 828418 | 2020-12-14 | Hocking | Ohio | 39073 | 1109 | 19 |
828430 | 828430 | 2020-12-14 | Madison | Ohio | 39097 | 2414 | 19 |
828441 | 828441 | 2020-12-14 | Muskingum | Ohio | 39119 | 4198 | 19 |
828467 | 828467 | 2020-12-14 | Williams | Ohio | 39171 | 1782 | 19 |
825172 | 825172 | 2020-12-13 | Hocking | Ohio | 39073 | 1089 | 19 |
825184 | 825184 | 2020-12-13 | Madison | Ohio | 39097 | 2380 | 19 |
825195 | 825195 | 2020-12-13 | Muskingum | Ohio | 39119 | 4134 | 19 |
825221 | 825221 | 2020-12-13 | Williams | Ohio | 39171 | 1744 | 19 |
821925 | 821925 | 2020-12-12 | Hocking | Ohio | 39073 | 1064 | 19 |
821937 | 821937 | 2020-12-12 | Madison | Ohio | 39097 | 2343 | 19 |
821948 | 821948 | 2020-12-12 | Muskingum | Ohio | 39119 | 4066 | 19 |
818691 | 818691 | 2020-12-11 | Madison | Ohio | 39097 | 2304 | 19 |
815445 | 815445 | 2020-12-10 | Madison | Ohio | 39097 | 2269 | 19 |
812199 | 812199 | 2020-12-09 | Madison | Ohio | 39097 | 2232 | 19 |
808955 | 808955 | 2020-12-08 | Madison | Ohio | 39097 | 2196 | 19 |
805710 | 805710 | 2020-12-07 | Madison | Ohio | 39097 | 2083 | 19 |
802430 | 802430 | 2020-12-06 | Clinton | Ohio | 39027 | 1369 | 19 |
802465 | 802465 | 2020-12-06 | Madison | Ohio | 39097 | 2037 | 19 |
799185 | 799185 | 2020-12-05 | Clinton | Ohio | 39027 | 1324 | 19 |
799220 | 799220 | 2020-12-05 | Madison | Ohio | 39097 | 2007 | 19 |
795940 | 795940 | 2020-12-04 | Clinton | Ohio | 39027 | 1291 | 19 |
795975 | 795975 | 2020-12-04 | Madison | Ohio | 39097 | 1963 | 19 |
792695 | 792695 | 2020-12-03 | Clinton | Ohio | 39027 | 1256 | 19 |
792730 | 792730 | 2020-12-03 | Madison | Ohio | 39097 | 1910 | 19 |
792769 | 792769 | 2020-12-03 | Wyandot | Ohio | 39175 | 880 | 19 |
789450 | 789450 | 2020-12-02 | Clinton | Ohio | 39027 | 1235 | 19 |
789485 | 789485 | 2020-12-02 | Madison | Ohio | 39097 | 1868 | 19 |
786205 | 786205 | 2020-12-01 | Clinton | Ohio | 39027 | 1220 | 19 |
786237 | 786237 | 2020-12-01 | Logan | Ohio | 39091 | 1479 | 19 |
786240 | 786240 | 2020-12-01 | Madison | Ohio | 39097 | 1836 | 19 |
782980 | 782980 | 2020-11-30 | Hardin | Ohio | 39065 | 1134 | 19 |
782996 | 782996 | 2020-11-30 | Madison | Ohio | 39097 | 1792 | 19 |
783021 | 783021 | 2020-11-30 | Seneca | Ohio | 39147 | 1995 | 19 |
779734 | 779734 | 2020-11-29 | Hardin | Ohio | 39065 | 1114 | 19 |
779743 | 779743 | 2020-11-29 | Knox | Ohio | 39083 | 1474 | 19 |
779750 | 779750 | 2020-11-29 | Madison | Ohio | 39097 | 1776 | 19 |
779775 | 779775 | 2020-11-29 | Seneca | Ohio | 39147 | 1981 | 19 |
776489 | 776489 | 2020-11-28 | Hardin | Ohio | 39065 | 1094 | 19 |
776498 | 776498 | 2020-11-28 | Knox | Ohio | 39083 | 1433 | 19 |
776505 | 776505 | 2020-11-28 | Madison | Ohio | 39097 | 1748 | 19 |
776530 | 776530 | 2020-11-28 | Seneca | Ohio | 39147 | 1967 | 19 |
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);