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 145
- 39151 143
- 39155 142
- 39013 140
- 39017 140
- 39049 140
- 39093 140
- 39153 140
- 39157 140
- 39095 139
- 39103 139
- 39055 138
- 39031 137
- 39037 137
- 39085 137
- 39099 137
- 39005 136
- 39023 136
- 39041 136
- 39077 136
- 39109 136
- 39061 135
- 39113 135
- 39139 135
- 39007 134
- 39029 134
- 39101 134
- 39159 134
- 39165 134
- 39025 133
- …
county >30
- Cuyahoga 145
- Stark 143
- Trumbull 142
- Belmont 140
- Butler 140
- Franklin 140
- Lorain 140
- Summit 140
- Tuscarawas 140
- Lucas 139
- Medina 139
- Geauga 138
- Coshocton 137
- Darke 137
- Lake 137
- Mahoning 137
- Ashland 136
- Clark 136
- Delaware 136
- Huron 136
- Miami 136
- Hamilton 135
- Montgomery 135
- Richland 135
- Ashtabula 134
- Columbiana 134
- Marion 134
- Union 134
- Warren 134
- Clermont 133
- …
state 1
- Ohio · 11,378 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387977 | 387977 | 2020-07-31 | Adams | Ohio | 39001 | 53 | 2 |
387978 | 387978 | 2020-07-31 | Allen | Ohio | 39003 | 628 | 42 |
387979 | 387979 | 2020-07-31 | Ashland | Ohio | 39005 | 126 | 3 |
387980 | 387980 | 2020-07-31 | Ashtabula | Ohio | 39007 | 534 | 45 |
387981 | 387981 | 2020-07-31 | Athens | Ohio | 39009 | 339 | 1 |
387982 | 387982 | 2020-07-31 | Auglaize | Ohio | 39011 | 200 | 5 |
387983 | 387983 | 2020-07-31 | Belmont | Ohio | 39013 | 589 | 26 |
387984 | 387984 | 2020-07-31 | Brown | Ohio | 39015 | 107 | 1 |
387985 | 387985 | 2020-07-31 | Butler | Ohio | 39017 | 2619 | 59 |
387986 | 387986 | 2020-07-31 | Carroll | Ohio | 39019 | 107 | 5 |
387987 | 387987 | 2020-07-31 | Champaign | Ohio | 39021 | 102 | 1 |
387988 | 387988 | 2020-07-31 | Clark | Ohio | 39023 | 1058 | 13 |
387989 | 387989 | 2020-07-31 | Clermont | Ohio | 39025 | 802 | 10 |
387990 | 387990 | 2020-07-31 | Clinton | Ohio | 39027 | 144 | 6 |
387991 | 387991 | 2020-07-31 | Columbiana | Ohio | 39029 | 1565 | 60 |
387992 | 387992 | 2020-07-31 | Coshocton | Ohio | 39031 | 185 | 6 |
387993 | 387993 | 2020-07-31 | Crawford | Ohio | 39033 | 163 | 5 |
387994 | 387994 | 2020-07-31 | Cuyahoga | Ohio | 39035 | 12399 | 470 |
387995 | 387995 | 2020-07-31 | Darke | Ohio | 39037 | 312 | 27 |
387996 | 387996 | 2020-07-31 | Defiance | Ohio | 39039 | 127 | 4 |
387997 | 387997 | 2020-07-31 | Delaware | Ohio | 39041 | 1168 | 18 |
387998 | 387998 | 2020-07-31 | Erie | Ohio | 39043 | 499 | 26 |
387999 | 387999 | 2020-07-31 | Fairfield | Ohio | 39045 | 1216 | 22 |
388000 | 388000 | 2020-07-31 | Fayette | Ohio | 39047 | 88 | 0 |
388001 | 388001 | 2020-07-31 | Franklin | Ohio | 39049 | 16842 | 511 |
388002 | 388002 | 2020-07-31 | Fulton | Ohio | 39051 | 137 | 1 |
388003 | 388003 | 2020-07-31 | Gallia | Ohio | 39053 | 49 | 1 |
388004 | 388004 | 2020-07-31 | Geauga | Ohio | 39055 | 519 | 43 |
388005 | 388005 | 2020-07-31 | Greene | Ohio | 39057 | 610 | 11 |
388006 | 388006 | 2020-07-31 | Guernsey | Ohio | 39059 | 107 | 6 |
388007 | 388007 | 2020-07-31 | Hamilton | Ohio | 39061 | 8977 | 245 |
388008 | 388008 | 2020-07-31 | Hancock | Ohio | 39063 | 303 | 2 |
388009 | 388009 | 2020-07-31 | Hardin | Ohio | 39065 | 149 | 12 |
388010 | 388010 | 2020-07-31 | Harrison | Ohio | 39067 | 19 | 1 |
388011 | 388011 | 2020-07-31 | Henry | Ohio | 39069 | 101 | 1 |
388012 | 388012 | 2020-07-31 | Highland | Ohio | 39071 | 118 | 1 |
388013 | 388013 | 2020-07-31 | Hocking | Ohio | 39073 | 106 | 9 |
388014 | 388014 | 2020-07-31 | Holmes | Ohio | 39075 | 318 | 6 |
388015 | 388015 | 2020-07-31 | Huron | Ohio | 39077 | 369 | 4 |
388016 | 388016 | 2020-07-31 | Jackson | Ohio | 39079 | 64 | 0 |
388017 | 388017 | 2020-07-31 | Jefferson | Ohio | 39081 | 196 | 3 |
388018 | 388018 | 2020-07-31 | Knox | Ohio | 39083 | 154 | 2 |
388019 | 388019 | 2020-07-31 | Lake | Ohio | 39085 | 1008 | 34 |
388020 | 388020 | 2020-07-31 | Lawrence | Ohio | 39087 | 206 | 0 |
388021 | 388021 | 2020-07-31 | Licking | Ohio | 39089 | 1081 | 40 |
388022 | 388022 | 2020-07-31 | Logan | Ohio | 39091 | 114 | 1 |
388023 | 388023 | 2020-07-31 | Lorain | Ohio | 39093 | 1584 | 76 |
388024 | 388024 | 2020-07-31 | Lucas | Ohio | 39095 | 4658 | 314 |
388025 | 388025 | 2020-07-31 | Madison | Ohio | 39097 | 313 | 10 |
388026 | 388026 | 2020-07-31 | Mahoning | Ohio | 39099 | 2371 | 250 |
388027 | 388027 | 2020-07-31 | Marion | Ohio | 39101 | 2860 | 44 |
388028 | 388028 | 2020-07-31 | Medina | Ohio | 39103 | 812 | 33 |
388029 | 388029 | 2020-07-31 | Meigs | Ohio | 39105 | 23 | 0 |
388030 | 388030 | 2020-07-31 | Mercer | Ohio | 39107 | 498 | 13 |
388031 | 388031 | 2020-07-31 | Miami | Ohio | 39109 | 747 | 36 |
388032 | 388032 | 2020-07-31 | Monroe | Ohio | 39111 | 89 | 18 |
388033 | 388033 | 2020-07-31 | Montgomery | Ohio | 39113 | 3926 | 70 |
388034 | 388034 | 2020-07-31 | Morgan | Ohio | 39115 | 17 | 0 |
388035 | 388035 | 2020-07-31 | Morrow | Ohio | 39117 | 157 | 2 |
388036 | 388036 | 2020-07-31 | Muskingum | Ohio | 39119 | 172 | 1 |
388037 | 388037 | 2020-07-31 | Noble | Ohio | 39121 | 16 | 0 |
388038 | 388038 | 2020-07-31 | Ottawa | Ohio | 39123 | 341 | 25 |
388039 | 388039 | 2020-07-31 | Paulding | Ohio | 39125 | 58 | 0 |
388040 | 388040 | 2020-07-31 | Perry | Ohio | 39127 | 100 | 1 |
388041 | 388041 | 2020-07-31 | Pickaway | Ohio | 39129 | 2345 | 42 |
388042 | 388042 | 2020-07-31 | Pike | Ohio | 39131 | 61 | 0 |
388043 | 388043 | 2020-07-31 | Portage | Ohio | 39133 | 704 | 60 |
388044 | 388044 | 2020-07-31 | Preble | Ohio | 39135 | 154 | 2 |
388045 | 388045 | 2020-07-31 | Putnam | Ohio | 39137 | 188 | 17 |
388046 | 388046 | 2020-07-31 | Richland | Ohio | 39139 | 525 | 10 |
388047 | 388047 | 2020-07-31 | Ross | Ohio | 39141 | 374 | 5 |
388048 | 388048 | 2020-07-31 | Sandusky | Ohio | 39143 | 315 | 17 |
388049 | 388049 | 2020-07-31 | Scioto | Ohio | 39145 | 179 | 1 |
388050 | 388050 | 2020-07-31 | Seneca | Ohio | 39147 | 140 | 3 |
388051 | 388051 | 2020-07-31 | Shelby | Ohio | 39149 | 148 | 4 |
388052 | 388052 | 2020-07-31 | Stark | Ohio | 39151 | 1643 | 131 |
388053 | 388053 | 2020-07-31 | Summit | Ohio | 39153 | 3188 | 216 |
388054 | 388054 | 2020-07-31 | Trumbull | Ohio | 39155 | 1393 | 100 |
388055 | 388055 | 2020-07-31 | Tuscarawas | Ohio | 39157 | 736 | 13 |
388056 | 388056 | 2020-07-31 | Union | Ohio | 39159 | 209 | 1 |
388057 | 388057 | 2020-07-31 | Van Wert | Ohio | 39161 | 65 | 1 |
388058 | 388058 | 2020-07-31 | Vinton | Ohio | 39163 | 29 | 2 |
388059 | 388059 | 2020-07-31 | Warren | Ohio | 39165 | 1551 | 35 |
388060 | 388060 | 2020-07-31 | Washington | Ohio | 39167 | 192 | 21 |
388061 | 388061 | 2020-07-31 | Wayne | Ohio | 39169 | 485 | 58 |
388062 | 388062 | 2020-07-31 | Williams | Ohio | 39171 | 117 | 3 |
388063 | 388063 | 2020-07-31 | Wood | Ohio | 39173 | 880 | 58 |
388064 | 388064 | 2020-07-31 | Wyandot | Ohio | 39175 | 119 | 5 |
384760 | 384760 | 2020-07-30 | Adams | Ohio | 39001 | 53 | 2 |
384761 | 384761 | 2020-07-30 | Allen | Ohio | 39003 | 603 | 42 |
384762 | 384762 | 2020-07-30 | Ashland | Ohio | 39005 | 123 | 3 |
384763 | 384763 | 2020-07-30 | Ashtabula | Ohio | 39007 | 530 | 44 |
384764 | 384764 | 2020-07-30 | Athens | Ohio | 39009 | 334 | 1 |
384765 | 384765 | 2020-07-30 | Auglaize | Ohio | 39011 | 192 | 5 |
384766 | 384766 | 2020-07-30 | Belmont | Ohio | 39013 | 588 | 26 |
384767 | 384767 | 2020-07-30 | Brown | Ohio | 39015 | 99 | 1 |
384768 | 384768 | 2020-07-30 | Butler | Ohio | 39017 | 2605 | 58 |
384769 | 384769 | 2020-07-30 | Carroll | Ohio | 39019 | 104 | 5 |
384770 | 384770 | 2020-07-30 | Champaign | Ohio | 39021 | 95 | 1 |
384771 | 384771 | 2020-07-30 | Clark | Ohio | 39023 | 1046 | 13 |
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);