ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
318 rows where deaths = 20 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Delaware 37
- Washington 31
- Tuscarawas 27
- Warren 26
- Sandusky 24
- Ashland 15
- Morgan 14
- Knox 12
- Shelby 10
- Richland 9
- Gallia 7
- Greene 7
- Paulding 7
- Vinton 7
- Crawford 6
- Perry 6
- Clermont 5
- Coshocton 5
- Pike 5
- Champaign 4
- Erie 4
- Monroe 4
- Montgomery 4
- Belmont 3
- Wyandot 3
- Hancock 2
- Henry 2
- Jackson 2
- Lorain 2
- Madison 2
- …
state 1
- Ohio · 318 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1783019 | 1783019 | 2021-10-04 | Vinton | Ohio | 39163 | 1495 | 20 |
1779770 | 1779770 | 2021-10-03 | Vinton | Ohio | 39163 | 1489 | 20 |
1776520 | 1776520 | 2021-10-02 | Vinton | Ohio | 39163 | 1481 | 20 |
1773270 | 1773270 | 2021-10-01 | Vinton | Ohio | 39163 | 1474 | 20 |
1770020 | 1770020 | 2021-09-30 | Vinton | Ohio | 39163 | 1465 | 20 |
1766771 | 1766771 | 2021-09-29 | Vinton | Ohio | 39163 | 1450 | 20 |
1763522 | 1763522 | 2021-09-28 | Vinton | Ohio | 39163 | 1441 | 20 |
1133528 | 1133528 | 2021-03-18 | Morgan | Ohio | 39115 | 1033 | 20 |
1130280 | 1130280 | 2021-03-17 | Morgan | Ohio | 39115 | 1031 | 20 |
1127033 | 1127033 | 2021-03-16 | Morgan | Ohio | 39115 | 1029 | 20 |
1123787 | 1123787 | 2021-03-15 | Morgan | Ohio | 39115 | 1029 | 20 |
1120541 | 1120541 | 2021-03-14 | Morgan | Ohio | 39115 | 1029 | 20 |
1117294 | 1117294 | 2021-03-13 | Morgan | Ohio | 39115 | 1029 | 20 |
1114047 | 1114047 | 2021-03-12 | Morgan | Ohio | 39115 | 1028 | 20 |
1110801 | 1110801 | 2021-03-11 | Morgan | Ohio | 39115 | 1026 | 20 |
1107555 | 1107555 | 2021-03-10 | Morgan | Ohio | 39115 | 1026 | 20 |
1104309 | 1104309 | 2021-03-09 | Morgan | Ohio | 39115 | 1027 | 20 |
1101063 | 1101063 | 2021-03-08 | Morgan | Ohio | 39115 | 1023 | 20 |
1097817 | 1097817 | 2021-03-07 | Morgan | Ohio | 39115 | 1022 | 20 |
1094569 | 1094569 | 2021-03-06 | Morgan | Ohio | 39115 | 1021 | 20 |
1091323 | 1091323 | 2021-03-05 | Morgan | Ohio | 39115 | 1016 | 20 |
1016681 | 1016681 | 2021-02-10 | Perry | Ohio | 39127 | 2558 | 20 |
1013436 | 1013436 | 2021-02-09 | Perry | Ohio | 39127 | 2540 | 20 |
1010191 | 1010191 | 2021-02-08 | Perry | Ohio | 39127 | 2525 | 20 |
1010193 | 1010193 | 2021-02-08 | Pike | Ohio | 39131 | 2006 | 20 |
1006945 | 1006945 | 2021-02-07 | Perry | Ohio | 39127 | 2521 | 20 |
1006947 | 1006947 | 2021-02-07 | Pike | Ohio | 39131 | 2000 | 20 |
1003699 | 1003699 | 2021-02-06 | Perry | Ohio | 39127 | 2514 | 20 |
1003701 | 1003701 | 2021-02-06 | Pike | Ohio | 39131 | 1994 | 20 |
1000453 | 1000453 | 2021-02-05 | Perry | Ohio | 39127 | 2508 | 20 |
1000455 | 1000455 | 2021-02-05 | Pike | Ohio | 39131 | 1990 | 20 |
997209 | 997209 | 2021-02-04 | Pike | Ohio | 39131 | 1968 | 20 |
948476 | 948476 | 2021-01-20 | Coshocton | Ohio | 39031 | 2011 | 20 |
945230 | 945230 | 2021-01-19 | Coshocton | Ohio | 39031 | 1996 | 20 |
941983 | 941983 | 2021-01-18 | Coshocton | Ohio | 39031 | 1989 | 20 |
938738 | 938738 | 2021-01-17 | Coshocton | Ohio | 39031 | 1974 | 20 |
935493 | 935493 | 2021-01-16 | Coshocton | Ohio | 39031 | 1971 | 20 |
925817 | 925817 | 2021-01-13 | Shelby | Ohio | 39149 | 4004 | 20 |
922571 | 922571 | 2021-01-12 | Shelby | Ohio | 39149 | 3971 | 20 |
919314 | 919314 | 2021-01-11 | Paulding | Ohio | 39125 | 1340 | 20 |
919326 | 919326 | 2021-01-11 | Shelby | Ohio | 39149 | 3934 | 20 |
916069 | 916069 | 2021-01-10 | Paulding | Ohio | 39125 | 1326 | 20 |
916081 | 916081 | 2021-01-10 | Shelby | Ohio | 39149 | 3907 | 20 |
912824 | 912824 | 2021-01-09 | Paulding | Ohio | 39125 | 1322 | 20 |
912836 | 912836 | 2021-01-09 | Shelby | Ohio | 39149 | 3881 | 20 |
909579 | 909579 | 2021-01-08 | Paulding | Ohio | 39125 | 1303 | 20 |
909591 | 909591 | 2021-01-08 | Shelby | Ohio | 39149 | 3831 | 20 |
906334 | 906334 | 2021-01-07 | Paulding | Ohio | 39125 | 1278 | 20 |
906346 | 906346 | 2021-01-07 | Shelby | Ohio | 39149 | 3780 | 20 |
903088 | 903088 | 2021-01-06 | Paulding | Ohio | 39125 | 1260 | 20 |
903100 | 903100 | 2021-01-06 | Shelby | Ohio | 39149 | 3727 | 20 |
899843 | 899843 | 2021-01-05 | Paulding | Ohio | 39125 | 1250 | 20 |
899855 | 899855 | 2021-01-05 | Shelby | Ohio | 39149 | 3658 | 20 |
899860 | 899860 | 2021-01-05 | Union | Ohio | 39159 | 3777 | 20 |
896610 | 896610 | 2021-01-04 | Shelby | Ohio | 39149 | 3570 | 20 |
877088 | 877088 | 2020-12-29 | Gallia | Ohio | 39053 | 1613 | 20 |
873843 | 873843 | 2020-12-28 | Gallia | Ohio | 39053 | 1585 | 20 |
870598 | 870598 | 2020-12-27 | Gallia | Ohio | 39053 | 1573 | 20 |
867353 | 867353 | 2020-12-26 | Gallia | Ohio | 39053 | 1570 | 20 |
864108 | 864108 | 2020-12-25 | Gallia | Ohio | 39053 | 1552 | 20 |
860863 | 860863 | 2020-12-24 | Gallia | Ohio | 39053 | 1552 | 20 |
857618 | 857618 | 2020-12-23 | Gallia | Ohio | 39053 | 1522 | 20 |
851141 | 851141 | 2020-12-21 | Jackson | Ohio | 39079 | 1922 | 20 |
847867 | 847867 | 2020-12-20 | Champaign | Ohio | 39021 | 1655 | 20 |
847896 | 847896 | 2020-12-20 | Jackson | Ohio | 39079 | 1907 | 20 |
844622 | 844622 | 2020-12-19 | Champaign | Ohio | 39021 | 1631 | 20 |
841376 | 841376 | 2020-12-18 | Champaign | Ohio | 39021 | 1610 | 20 |
838131 | 838131 | 2020-12-17 | Champaign | Ohio | 39021 | 1589 | 20 |
838180 | 838180 | 2020-12-17 | Muskingum | Ohio | 39119 | 4409 | 20 |
834923 | 834923 | 2020-12-16 | Madison | Ohio | 39097 | 2486 | 20 |
834934 | 834934 | 2020-12-16 | Muskingum | Ohio | 39119 | 4251 | 20 |
831665 | 831665 | 2020-12-15 | Hocking | Ohio | 39073 | 1112 | 20 |
831677 | 831677 | 2020-12-15 | Madison | Ohio | 39097 | 2453 | 20 |
818684 | 818684 | 2020-12-11 | Knox | Ohio | 39083 | 1980 | 20 |
815438 | 815438 | 2020-12-10 | Knox | Ohio | 39083 | 1937 | 20 |
812192 | 812192 | 2020-12-09 | Knox | Ohio | 39083 | 1875 | 20 |
808948 | 808948 | 2020-12-08 | Knox | Ohio | 39083 | 1834 | 20 |
805675 | 805675 | 2020-12-07 | Clinton | Ohio | 39027 | 1388 | 20 |
805678 | 805678 | 2020-12-07 | Crawford | Ohio | 39033 | 1715 | 20 |
805703 | 805703 | 2020-12-07 | Knox | Ohio | 39083 | 1763 | 20 |
802433 | 802433 | 2020-12-06 | Crawford | Ohio | 39033 | 1676 | 20 |
802458 | 802458 | 2020-12-06 | Knox | Ohio | 39083 | 1736 | 20 |
802504 | 802504 | 2020-12-06 | Wyandot | Ohio | 39175 | 946 | 20 |
799188 | 799188 | 2020-12-05 | Crawford | Ohio | 39033 | 1658 | 20 |
799195 | 799195 | 2020-12-05 | Fayette | Ohio | 39047 | 1122 | 20 |
799213 | 799213 | 2020-12-05 | Knox | Ohio | 39083 | 1717 | 20 |
799259 | 799259 | 2020-12-05 | Wyandot | Ohio | 39175 | 929 | 20 |
795943 | 795943 | 2020-12-04 | Crawford | Ohio | 39033 | 1613 | 20 |
795968 | 795968 | 2020-12-04 | Knox | Ohio | 39083 | 1652 | 20 |
796014 | 796014 | 2020-12-04 | Wyandot | Ohio | 39175 | 906 | 20 |
792698 | 792698 | 2020-12-03 | Crawford | Ohio | 39033 | 1586 | 20 |
792723 | 792723 | 2020-12-03 | Knox | Ohio | 39083 | 1595 | 20 |
789453 | 789453 | 2020-12-02 | Crawford | Ohio | 39033 | 1539 | 20 |
789478 | 789478 | 2020-12-02 | Knox | Ohio | 39083 | 1548 | 20 |
789482 | 789482 | 2020-12-02 | Logan | Ohio | 39091 | 1499 | 20 |
789510 | 789510 | 2020-12-02 | Seneca | Ohio | 39147 | 2067 | 20 |
786233 | 786233 | 2020-12-01 | Knox | Ohio | 39083 | 1528 | 20 |
786265 | 786265 | 2020-12-01 | Seneca | Ohio | 39147 | 2032 | 20 |
782989 | 782989 | 2020-11-30 | Knox | Ohio | 39083 | 1494 | 20 |
747302 | 747302 | 2020-11-19 | Monroe | Ohio | 39111 | 271 | 20 |
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);