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 487
- 39151 485
- 39155 484
- 39013 482
- 39017 482
- 39049 482
- 39093 482
- 39153 482
- 39157 482
- 39095 481
- 39103 481
- 39055 480
- 39031 479
- 39037 479
- 39085 479
- 39099 479
- 39005 478
- 39023 478
- 39041 478
- 39077 478
- 39109 478
- 39061 477
- 39113 477
- 39139 477
- 39007 476
- 39029 476
- 39101 476
- 39159 476
- 39165 476
- 39025 475
- …
county >30
- Cuyahoga 487
- Stark 485
- Trumbull 484
- Belmont 482
- Butler 482
- Franklin 482
- Lorain 482
- Summit 482
- Tuscarawas 482
- Lucas 481
- Medina 481
- Geauga 480
- Coshocton 479
- Darke 479
- Lake 479
- Mahoning 479
- Ashland 478
- Clark 478
- Delaware 478
- Huron 478
- Miami 478
- Hamilton 477
- Montgomery 477
- Richland 477
- Ashtabula 476
- Columbiana 476
- Marion 476
- Union 476
- Warren 476
- Clermont 475
- …
state 1
- Ohio · 41,600 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1497090 | 1497090 | 2021-07-08 | Adams | Ohio | 39001 | 2441 | 56 |
1497091 | 1497091 | 2021-07-08 | Allen | Ohio | 39003 | 11955 | 245 |
1497092 | 1497092 | 2021-07-08 | Ashland | Ohio | 39005 | 4370 | 98 |
1497093 | 1497093 | 2021-07-08 | Ashtabula | Ohio | 39007 | 7226 | 179 |
1497094 | 1497094 | 2021-07-08 | Athens | Ohio | 39009 | 5249 | 60 |
1497095 | 1497095 | 2021-07-08 | Auglaize | Ohio | 39011 | 5047 | 87 |
1497096 | 1497096 | 2021-07-08 | Belmont | Ohio | 39013 | 6182 | 177 |
1497097 | 1497097 | 2021-07-08 | Brown | Ohio | 39015 | 4039 | 61 |
1497098 | 1497098 | 2021-07-08 | Butler | Ohio | 39017 | 39570 | 611 |
1497099 | 1497099 | 2021-07-08 | Carroll | Ohio | 39019 | 1983 | 48 |
1497100 | 1497100 | 2021-07-08 | Champaign | Ohio | 39021 | 3459 | 60 |
1497101 | 1497101 | 2021-07-08 | Clark | Ohio | 39023 | 14268 | 306 |
1497102 | 1497102 | 2021-07-08 | Clermont | Ohio | 39025 | 20209 | 257 |
1497103 | 1497103 | 2021-07-08 | Clinton | Ohio | 39027 | 3831 | 66 |
1497104 | 1497104 | 2021-07-08 | Columbiana | Ohio | 39029 | 9058 | 235 |
1497105 | 1497105 | 2021-07-08 | Coshocton | Ohio | 39031 | 2707 | 60 |
1497106 | 1497106 | 2021-07-08 | Crawford | Ohio | 39033 | 4066 | 111 |
1497107 | 1497107 | 2021-07-08 | Cuyahoga | Ohio | 39035 | 116238 | 2240 |
1497108 | 1497108 | 2021-07-08 | Darke | Ohio | 39037 | 5431 | 129 |
1497109 | 1497109 | 2021-07-08 | Defiance | Ohio | 39039 | 4330 | 99 |
1497110 | 1497110 | 2021-07-08 | Delaware | Ohio | 39041 | 18952 | 137 |
1497111 | 1497111 | 2021-07-08 | Erie | Ohio | 39043 | 8074 | 166 |
1497112 | 1497112 | 2021-07-08 | Fairfield | Ohio | 39045 | 16624 | 206 |
1497113 | 1497113 | 2021-07-08 | Fayette | Ohio | 39047 | 2865 | 50 |
1497114 | 1497114 | 2021-07-08 | Franklin | Ohio | 39049 | 129352 | 1487 |
1497115 | 1497115 | 2021-07-08 | Fulton | Ohio | 39051 | 4331 | 75 |
1497116 | 1497116 | 2021-07-08 | Gallia | Ohio | 39053 | 2416 | 50 |
1497117 | 1497117 | 2021-07-08 | Geauga | Ohio | 39055 | 6882 | 153 |
1497118 | 1497118 | 2021-07-08 | Greene | Ohio | 39057 | 15334 | 250 |
1497119 | 1497119 | 2021-07-08 | Guernsey | Ohio | 39059 | 3272 | 54 |
1497120 | 1497120 | 2021-07-08 | Hamilton | Ohio | 39061 | 81633 | 1254 |
1497121 | 1497121 | 2021-07-08 | Hancock | Ohio | 39063 | 7012 | 134 |
1497122 | 1497122 | 2021-07-08 | Hardin | Ohio | 39065 | 2773 | 65 |
1497123 | 1497123 | 2021-07-08 | Harrison | Ohio | 39067 | 1145 | 38 |
1497124 | 1497124 | 2021-07-08 | Henry | Ohio | 39069 | 2750 | 67 |
1497125 | 1497125 | 2021-07-08 | Highland | Ohio | 39071 | 3612 | 67 |
1497126 | 1497126 | 2021-07-08 | Hocking | Ohio | 39073 | 2207 | 63 |
1497127 | 1497127 | 2021-07-08 | Holmes | Ohio | 39075 | 2718 | 102 |
1497128 | 1497128 | 2021-07-08 | Huron | Ohio | 39077 | 5580 | 122 |
1497129 | 1497129 | 2021-07-08 | Jackson | Ohio | 39079 | 3195 | 54 |
1497130 | 1497130 | 2021-07-08 | Jefferson | Ohio | 39081 | 5695 | 160 |
1497131 | 1497131 | 2021-07-08 | Knox | Ohio | 39083 | 4582 | 112 |
1497132 | 1497132 | 2021-07-08 | Lake | Ohio | 39085 | 21277 | 391 |
1497133 | 1497133 | 2021-07-08 | Lawrence | Ohio | 39087 | 5776 | 103 |
1497134 | 1497134 | 2021-07-08 | Licking | Ohio | 39089 | 16711 | 225 |
1497135 | 1497135 | 2021-07-08 | Logan | Ohio | 39091 | 3895 | 79 |
1497136 | 1497136 | 2021-07-08 | Lorain | Ohio | 39093 | 25754 | 507 |
1497137 | 1497137 | 2021-07-08 | Lucas | Ohio | 39095 | 43476 | 829 |
1497138 | 1497138 | 2021-07-08 | Madison | Ohio | 39097 | 4453 | 66 |
1497139 | 1497139 | 2021-07-08 | Mahoning | Ohio | 39099 | 22453 | 611 |
1497140 | 1497140 | 2021-07-08 | Marion | Ohio | 39101 | 8659 | 140 |
1497141 | 1497141 | 2021-07-08 | Medina | Ohio | 39103 | 15680 | 275 |
1497142 | 1497142 | 2021-07-08 | Meigs | Ohio | 39105 | 1492 | 40 |
1497143 | 1497143 | 2021-07-08 | Mercer | Ohio | 39107 | 4884 | 85 |
1497144 | 1497144 | 2021-07-08 | Miami | Ohio | 39109 | 10885 | 226 |
1497145 | 1497145 | 2021-07-08 | Monroe | Ohio | 39111 | 1372 | 45 |
1497146 | 1497146 | 2021-07-08 | Montgomery | Ohio | 39113 | 52735 | 1056 |
1497147 | 1497147 | 2021-07-08 | Morgan | Ohio | 39115 | 1104 | 24 |
1497148 | 1497148 | 2021-07-08 | Morrow | Ohio | 39117 | 2928 | 42 |
1497149 | 1497149 | 2021-07-08 | Muskingum | Ohio | 39119 | 8986 | 137 |
1497150 | 1497150 | 2021-07-08 | Noble | Ohio | 39121 | 1365 | 39 |
1497151 | 1497151 | 2021-07-08 | Ottawa | Ohio | 39123 | 3738 | 81 |
1497152 | 1497152 | 2021-07-08 | Paulding | Ohio | 39125 | 1779 | 42 |
1497153 | 1497153 | 2021-07-08 | Perry | Ohio | 39127 | 2975 | 50 |
1497154 | 1497154 | 2021-07-08 | Pickaway | Ohio | 39129 | 8685 | 122 |
1497155 | 1497155 | 2021-07-08 | Pike | Ohio | 39131 | 2430 | 37 |
1497156 | 1497156 | 2021-07-08 | Portage | Ohio | 39133 | 13279 | 216 |
1497157 | 1497157 | 2021-07-08 | Preble | Ohio | 39135 | 3888 | 106 |
1497158 | 1497158 | 2021-07-08 | Putnam | Ohio | 39137 | 4337 | 104 |
1497159 | 1497159 | 2021-07-08 | Richland | Ohio | 39139 | 11638 | 212 |
1497160 | 1497160 | 2021-07-08 | Ross | Ohio | 39141 | 6965 | 164 |
1497161 | 1497161 | 2021-07-08 | Sandusky | Ohio | 39143 | 5454 | 129 |
1497162 | 1497162 | 2021-07-08 | Scioto | Ohio | 39145 | 6575 | 108 |
1497163 | 1497163 | 2021-07-08 | Seneca | Ohio | 39147 | 5356 | 128 |
1497164 | 1497164 | 2021-07-08 | Shelby | Ohio | 39149 | 4786 | 97 |
1497165 | 1497165 | 2021-07-08 | Stark | Ohio | 39151 | 33498 | 936 |
1497166 | 1497166 | 2021-07-08 | Summit | Ohio | 39153 | 48573 | 1011 |
1497167 | 1497167 | 2021-07-08 | Trumbull | Ohio | 39155 | 16616 | 486 |
1497168 | 1497168 | 2021-07-08 | Tuscarawas | Ohio | 39157 | 8676 | 254 |
1497169 | 1497169 | 2021-07-08 | Union | Ohio | 39159 | 5866 | 49 |
1497170 | 1497170 | 2021-07-08 | Unknown | Ohio | 0 | 3 | |
1497171 | 1497171 | 2021-07-08 | Van Wert | Ohio | 39161 | 2484 | 65 |
1497172 | 1497172 | 2021-07-08 | Vinton | Ohio | 39163 | 865 | 17 |
1497173 | 1497173 | 2021-07-08 | Warren | Ohio | 39165 | 24671 | 307 |
1497174 | 1497174 | 2021-07-08 | Washington | Ohio | 39167 | 5332 | 110 |
1497175 | 1497175 | 2021-07-08 | Wayne | Ohio | 39169 | 9190 | 226 |
1497176 | 1497176 | 2021-07-08 | Williams | Ohio | 39171 | 3521 | 78 |
1497177 | 1497177 | 2021-07-08 | Wood | Ohio | 39173 | 13308 | 200 |
1497178 | 1497178 | 2021-07-08 | Wyandot | Ohio | 39175 | 2350 | 57 |
1493843 | 1493843 | 2021-07-07 | Adams | Ohio | 39001 | 2441 | 56 |
1493844 | 1493844 | 2021-07-07 | Allen | Ohio | 39003 | 11954 | 245 |
1493845 | 1493845 | 2021-07-07 | Ashland | Ohio | 39005 | 4370 | 98 |
1493846 | 1493846 | 2021-07-07 | Ashtabula | Ohio | 39007 | 7220 | 179 |
1493847 | 1493847 | 2021-07-07 | Athens | Ohio | 39009 | 5250 | 60 |
1493848 | 1493848 | 2021-07-07 | Auglaize | Ohio | 39011 | 5045 | 87 |
1493849 | 1493849 | 2021-07-07 | Belmont | Ohio | 39013 | 6180 | 177 |
1493850 | 1493850 | 2021-07-07 | Brown | Ohio | 39015 | 4035 | 61 |
1493851 | 1493851 | 2021-07-07 | Butler | Ohio | 39017 | 39547 | 611 |
1493852 | 1493852 | 2021-07-07 | Carroll | Ohio | 39019 | 1981 | 48 |
1493853 | 1493853 | 2021-07-07 | Champaign | Ohio | 39021 | 3456 | 60 |
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);