ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69,101 rows where state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 39035 222
- 39151 220
- 39155 219
- 39013 217
- 39017 217
- 39049 217
- 39093 217
- 39153 217
- 39157 217
- 39095 216
- 39103 216
- 39055 215
- 39031 214
- 39037 214
- 39085 214
- 39099 214
- 39005 213
- 39023 213
- 39041 213
- 39077 213
- 39109 213
- 39061 212
- 39113 212
- 39139 212
- 39007 211
- 39029 211
- 39101 211
- 39159 211
- 39165 211
- 39025 210
- …
county >30
- Cuyahoga 222
- Stark 220
- Trumbull 219
- Belmont 217
- Butler 217
- Franklin 217
- Lorain 217
- Summit 217
- Tuscarawas 217
- Lucas 216
- Medina 216
- Geauga 215
- Coshocton 214
- Darke 214
- Lake 214
- Mahoning 214
- Ashland 213
- Clark 213
- Delaware 213
- Huron 213
- Miami 213
- Hamilton 212
- Montgomery 212
- Richland 212
- Ashtabula 211
- Columbiana 211
- Marion 211
- Union 211
- Warren 211
- Clermont 210
- …
state 1
- Ohio · 18,154 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636944 | 636944 | 2020-10-16 | Adams | Ohio | 39001 | 187 | 6 |
636945 | 636945 | 2020-10-16 | Allen | Ohio | 39003 | 1891 | 73 |
636946 | 636946 | 2020-10-16 | Ashland | Ohio | 39005 | 361 | 5 |
636947 | 636947 | 2020-10-16 | Ashtabula | Ohio | 39007 | 698 | 48 |
636948 | 636948 | 2020-10-16 | Athens | Ohio | 39009 | 1121 | 2 |
636949 | 636949 | 2020-10-16 | Auglaize | Ohio | 39011 | 882 | 16 |
636950 | 636950 | 2020-10-16 | Belmont | Ohio | 39013 | 760 | 27 |
636951 | 636951 | 2020-10-16 | Brown | Ohio | 39015 | 342 | 3 |
636952 | 636952 | 2020-10-16 | Butler | Ohio | 39017 | 7654 | 119 |
636953 | 636953 | 2020-10-16 | Carroll | Ohio | 39019 | 179 | 7 |
636954 | 636954 | 2020-10-16 | Champaign | Ohio | 39021 | 373 | 3 |
636955 | 636955 | 2020-10-16 | Clark | Ohio | 39023 | 2279 | 53 |
636956 | 636956 | 2020-10-16 | Clermont | Ohio | 39025 | 2198 | 36 |
636957 | 636957 | 2020-10-16 | Clinton | Ohio | 39027 | 398 | 13 |
636958 | 636958 | 2020-10-16 | Columbiana | Ohio | 39029 | 2062 | 87 |
636959 | 636959 | 2020-10-16 | Coshocton | Ohio | 39031 | 282 | 12 |
636960 | 636960 | 2020-10-16 | Crawford | Ohio | 39033 | 376 | 8 |
636961 | 636961 | 2020-10-16 | Cuyahoga | Ohio | 39035 | 18951 | 671 |
636962 | 636962 | 2020-10-16 | Darke | Ohio | 39037 | 1063 | 50 |
636963 | 636963 | 2020-10-16 | Defiance | Ohio | 39039 | 425 | 13 |
636964 | 636964 | 2020-10-16 | Delaware | Ohio | 39041 | 2723 | 26 |
636965 | 636965 | 2020-10-16 | Erie | Ohio | 39043 | 1092 | 53 |
636966 | 636966 | 2020-10-16 | Fairfield | Ohio | 39045 | 2476 | 56 |
636967 | 636967 | 2020-10-16 | Fayette | Ohio | 39047 | 407 | 8 |
636968 | 636968 | 2020-10-16 | Franklin | Ohio | 39049 | 30157 | 635 |
636969 | 636969 | 2020-10-16 | Fulton | Ohio | 39051 | 451 | 4 |
636970 | 636970 | 2020-10-16 | Gallia | Ohio | 39053 | 269 | 13 |
636971 | 636971 | 2020-10-16 | Geauga | Ohio | 39055 | 804 | 50 |
636972 | 636972 | 2020-10-16 | Greene | Ohio | 39057 | 2037 | 40 |
636973 | 636973 | 2020-10-16 | Guernsey | Ohio | 39059 | 243 | 8 |
636974 | 636974 | 2020-10-16 | Hamilton | Ohio | 39061 | 15544 | 338 |
636975 | 636975 | 2020-10-16 | Hancock | Ohio | 39063 | 951 | 19 |
636976 | 636976 | 2020-10-16 | Hardin | Ohio | 39065 | 305 | 13 |
636977 | 636977 | 2020-10-16 | Harrison | Ohio | 39067 | 73 | 3 |
636978 | 636978 | 2020-10-16 | Henry | Ohio | 39069 | 426 | 17 |
636979 | 636979 | 2020-10-16 | Highland | Ohio | 39071 | 356 | 4 |
636980 | 636980 | 2020-10-16 | Hocking | Ohio | 39073 | 188 | 9 |
636981 | 636981 | 2020-10-16 | Holmes | Ohio | 39075 | 517 | 10 |
636982 | 636982 | 2020-10-16 | Huron | Ohio | 39077 | 682 | 9 |
636983 | 636983 | 2020-10-16 | Jackson | Ohio | 39079 | 388 | 7 |
636984 | 636984 | 2020-10-16 | Jefferson | Ohio | 39081 | 432 | 4 |
636985 | 636985 | 2020-10-16 | Knox | Ohio | 39083 | 336 | 15 |
636986 | 636986 | 2020-10-16 | Lake | Ohio | 39085 | 1811 | 57 |
636987 | 636987 | 2020-10-16 | Lawrence | Ohio | 39087 | 859 | 24 |
636988 | 636988 | 2020-10-16 | Licking | Ohio | 39089 | 2333 | 65 |
636989 | 636989 | 2020-10-16 | Logan | Ohio | 39091 | 376 | 3 |
636990 | 636990 | 2020-10-16 | Lorain | Ohio | 39093 | 2569 | 89 |
636991 | 636991 | 2020-10-16 | Lucas | Ohio | 39095 | 7979 | 370 |
636992 | 636992 | 2020-10-16 | Madison | Ohio | 39097 | 1000 | 14 |
636993 | 636993 | 2020-10-16 | Mahoning | Ohio | 39099 | 3515 | 283 |
636994 | 636994 | 2020-10-16 | Marion | Ohio | 39101 | 3300 | 48 |
636995 | 636995 | 2020-10-16 | Medina | Ohio | 39103 | 1714 | 42 |
636996 | 636996 | 2020-10-16 | Meigs | Ohio | 39105 | 199 | 12 |
636997 | 636997 | 2020-10-16 | Mercer | Ohio | 39107 | 1400 | 27 |
636998 | 636998 | 2020-10-16 | Miami | Ohio | 39109 | 1879 | 56 |
636999 | 636999 | 2020-10-16 | Monroe | Ohio | 39111 | 129 | 18 |
637000 | 637000 | 2020-10-16 | Montgomery | Ohio | 39113 | 9675 | 183 |
637001 | 637001 | 2020-10-16 | Morgan | Ohio | 39115 | 65 | 0 |
637002 | 637002 | 2020-10-16 | Morrow | Ohio | 39117 | 313 | 2 |
637003 | 637003 | 2020-10-16 | Muskingum | Ohio | 39119 | 743 | 4 |
637004 | 637004 | 2020-10-16 | Noble | Ohio | 39121 | 105 | 0 |
637005 | 637005 | 2020-10-16 | Ottawa | Ohio | 39123 | 548 | 30 |
637006 | 637006 | 2020-10-16 | Paulding | Ohio | 39125 | 172 | 1 |
637007 | 637007 | 2020-10-16 | Perry | Ohio | 39127 | 343 | 11 |
637008 | 637008 | 2020-10-16 | Pickaway | Ohio | 39129 | 2921 | 46 |
637009 | 637009 | 2020-10-16 | Pike | Ohio | 39131 | 271 | 0 |
637010 | 637010 | 2020-10-16 | Portage | Ohio | 39133 | 1497 | 67 |
637011 | 637011 | 2020-10-16 | Preble | Ohio | 39135 | 555 | 17 |
637012 | 637012 | 2020-10-16 | Putnam | Ohio | 39137 | 821 | 27 |
637013 | 637013 | 2020-10-16 | Richland | Ohio | 39139 | 1220 | 24 |
637014 | 637014 | 2020-10-16 | Ross | Ohio | 39141 | 1266 | 33 |
637015 | 637015 | 2020-10-16 | Sandusky | Ohio | 39143 | 677 | 22 |
637016 | 637016 | 2020-10-16 | Scioto | Ohio | 39145 | 751 | 8 |
637017 | 637017 | 2020-10-16 | Seneca | Ohio | 39147 | 558 | 14 |
637018 | 637018 | 2020-10-16 | Shelby | Ohio | 39149 | 835 | 14 |
637019 | 637019 | 2020-10-16 | Stark | Ohio | 39151 | 3532 | 178 |
637020 | 637020 | 2020-10-16 | Summit | Ohio | 39153 | 6242 | 259 |
637021 | 637021 | 2020-10-16 | Trumbull | Ohio | 39155 | 2141 | 134 |
637022 | 637022 | 2020-10-16 | Tuscarawas | Ohio | 39157 | 1142 | 21 |
637023 | 637023 | 2020-10-16 | Union | Ohio | 39159 | 700 | 3 |
637024 | 637024 | 2020-10-16 | Van Wert | Ohio | 39161 | 197 | 3 |
637025 | 637025 | 2020-10-16 | Vinton | Ohio | 39163 | 83 | 3 |
637026 | 637026 | 2020-10-16 | Warren | Ohio | 39165 | 3799 | 60 |
637027 | 637027 | 2020-10-16 | Washington | Ohio | 39167 | 316 | 23 |
637028 | 637028 | 2020-10-16 | Wayne | Ohio | 39169 | 1202 | 68 |
637029 | 637029 | 2020-10-16 | Williams | Ohio | 39171 | 292 | 4 |
637030 | 637030 | 2020-10-16 | Wood | Ohio | 39173 | 2331 | 81 |
637031 | 637031 | 2020-10-16 | Wyandot | Ohio | 39175 | 276 | 13 |
633698 | 633698 | 2020-10-15 | Adams | Ohio | 39001 | 183 | 6 |
633699 | 633699 | 2020-10-15 | Allen | Ohio | 39003 | 1871 | 73 |
633700 | 633700 | 2020-10-15 | Ashland | Ohio | 39005 | 357 | 5 |
633701 | 633701 | 2020-10-15 | Ashtabula | Ohio | 39007 | 693 | 48 |
633702 | 633702 | 2020-10-15 | Athens | Ohio | 39009 | 1102 | 2 |
633703 | 633703 | 2020-10-15 | Auglaize | Ohio | 39011 | 856 | 16 |
633704 | 633704 | 2020-10-15 | Belmont | Ohio | 39013 | 756 | 27 |
633705 | 633705 | 2020-10-15 | Brown | Ohio | 39015 | 337 | 3 |
633706 | 633706 | 2020-10-15 | Butler | Ohio | 39017 | 7549 | 118 |
633707 | 633707 | 2020-10-15 | Carroll | Ohio | 39019 | 179 | 7 |
633708 | 633708 | 2020-10-15 | Champaign | Ohio | 39021 | 366 | 3 |
633709 | 633709 | 2020-10-15 | Clark | Ohio | 39023 | 2246 | 52 |
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);