ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where "date" is on date 2022-01-08 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adams 1
- Allen 1
- Ashland 1
- Ashtabula 1
- Athens 1
- Auglaize 1
- Belmont 1
- Brown 1
- Butler 1
- Carroll 1
- Champaign 1
- Clark 1
- Clermont 1
- Clinton 1
- Columbiana 1
- Coshocton 1
- Crawford 1
- Cuyahoga 1
- Darke 1
- Defiance 1
- Delaware 1
- Erie 1
- Fairfield 1
- Fayette 1
- Franklin 1
- Fulton 1
- Gallia 1
- Geauga 1
- Greene 1
- Guernsey 1
- …
state 1
- Ohio · 89 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2094936 | 2094936 | 2022-01-08 | Adams | Ohio | 39001 | 5227 | 118 |
2094937 | 2094937 | 2022-01-08 | Allen | Ohio | 39003 | 21958 | 384 |
2094938 | 2094938 | 2022-01-08 | Ashland | Ohio | 39005 | 9921 | 168 |
2094939 | 2094939 | 2022-01-08 | Ashtabula | Ohio | 39007 | 16652 | 314 |
2094940 | 2094940 | 2022-01-08 | Athens | Ohio | 39009 | 9668 | 104 |
2094941 | 2094941 | 2022-01-08 | Auglaize | Ohio | 39011 | 9220 | 138 |
2094942 | 2094942 | 2022-01-08 | Belmont | Ohio | 39013 | 12195 | 246 |
2094943 | 2094943 | 2022-01-08 | Brown | Ohio | 39015 | 8473 | 137 |
2094944 | 2094944 | 2022-01-08 | Butler | Ohio | 39017 | 68779 | 909 |
2094945 | 2094945 | 2022-01-08 | Carroll | Ohio | 39019 | 4504 | 98 |
2094946 | 2094946 | 2022-01-08 | Champaign | Ohio | 39021 | 6910 | 105 |
2094947 | 2094947 | 2022-01-08 | Clark | Ohio | 39023 | 26796 | 424 |
2094948 | 2094948 | 2022-01-08 | Clermont | Ohio | 39025 | 38068 | 416 |
2094949 | 2094949 | 2022-01-08 | Clinton | Ohio | 39027 | 7849 | 118 |
2094950 | 2094950 | 2022-01-08 | Columbiana | Ohio | 39029 | 20154 | 385 |
2094951 | 2094951 | 2022-01-08 | Coshocton | Ohio | 39031 | 6404 | 136 |
2094952 | 2094952 | 2022-01-08 | Crawford | Ohio | 39033 | 9002 | 167 |
2094953 | 2094953 | 2022-01-08 | Cuyahoga | Ohio | 39035 | 244036 | 2917 |
2094954 | 2094954 | 2022-01-08 | Darke | Ohio | 39037 | 9719 | 192 |
2094955 | 2094955 | 2022-01-08 | Defiance | Ohio | 39039 | 8376 | 130 |
2094956 | 2094956 | 2022-01-08 | Delaware | Ohio | 39041 | 34241 | 200 |
2094957 | 2094957 | 2022-01-08 | Erie | Ohio | 39043 | 16551 | 219 |
2094958 | 2094958 | 2022-01-08 | Fairfield | Ohio | 39045 | 30260 | 326 |
2094959 | 2094959 | 2022-01-08 | Fayette | Ohio | 39047 | 5935 | 82 |
2094960 | 2094960 | 2022-01-08 | Franklin | Ohio | 39049 | 229808 | 1973 |
2094961 | 2094961 | 2022-01-08 | Fulton | Ohio | 39051 | 8482 | 142 |
2094962 | 2094962 | 2022-01-08 | Gallia | Ohio | 39053 | 5414 | 85 |
2094963 | 2094963 | 2022-01-08 | Geauga | Ohio | 39055 | 14385 | 210 |
2094964 | 2094964 | 2022-01-08 | Greene | Ohio | 39057 | 28499 | 409 |
2094965 | 2094965 | 2022-01-08 | Guernsey | Ohio | 39059 | 8236 | 108 |
2094966 | 2094966 | 2022-01-08 | Hamilton | Ohio | 39061 | 145454 | 1677 |
2094967 | 2094967 | 2022-01-08 | Hancock | Ohio | 39063 | 13688 | 218 |
2094968 | 2094968 | 2022-01-08 | Hardin | Ohio | 39065 | 5672 | 124 |
2094969 | 2094969 | 2022-01-08 | Harrison | Ohio | 39067 | 2573 | 60 |
2094970 | 2094970 | 2022-01-08 | Henry | Ohio | 39069 | 5109 | 90 |
2094971 | 2094971 | 2022-01-08 | Highland | Ohio | 39071 | 8065 | 138 |
2094972 | 2094972 | 2022-01-08 | Hocking | Ohio | 39073 | 5041 | 100 |
2094973 | 2094973 | 2022-01-08 | Holmes | Ohio | 39075 | 4499 | 157 |
2094974 | 2094974 | 2022-01-08 | Huron | Ohio | 39077 | 12217 | 179 |
2094975 | 2094975 | 2022-01-08 | Jackson | Ohio | 39079 | 6713 | 111 |
2094976 | 2094976 | 2022-01-08 | Jefferson | Ohio | 39081 | 11601 | 254 |
2094977 | 2094977 | 2022-01-08 | Knox | Ohio | 39083 | 10463 | 193 |
2094978 | 2094978 | 2022-01-08 | Lake | Ohio | 39085 | 44184 | 565 |
2094979 | 2094979 | 2022-01-08 | Lawrence | Ohio | 39087 | 12491 | 184 |
2094980 | 2094980 | 2022-01-08 | Licking | Ohio | 39089 | 33154 | 385 |
2094981 | 2094981 | 2022-01-08 | Logan | Ohio | 39091 | 8252 | 135 |
2094982 | 2094982 | 2022-01-08 | Lorain | Ohio | 39093 | 58486 | 764 |
2094983 | 2094983 | 2022-01-08 | Lucas | Ohio | 39095 | 78278 | 1130 |
2094984 | 2094984 | 2022-01-08 | Madison | Ohio | 39097 | 7671 | 102 |
2094985 | 2094985 | 2022-01-08 | Mahoning | Ohio | 39099 | 44957 | 877 |
2094986 | 2094986 | 2022-01-08 | Marion | Ohio | 39101 | 15759 | 224 |
2094987 | 2094987 | 2022-01-08 | Medina | Ohio | 39103 | 34717 | 405 |
2094988 | 2094988 | 2022-01-08 | Meigs | Ohio | 39105 | 3437 | 69 |
2094989 | 2094989 | 2022-01-08 | Mercer | Ohio | 39107 | 7825 | 110 |
2094990 | 2094990 | 2022-01-08 | Miami | Ohio | 39109 | 20486 | 379 |
2094991 | 2094991 | 2022-01-08 | Monroe | Ohio | 39111 | 2743 | 67 |
2094992 | 2094992 | 2022-01-08 | Montgomery | Ohio | 39113 | 96386 | 1547 |
2094993 | 2094993 | 2022-01-08 | Morgan | Ohio | 39115 | 2537 | 47 |
2094994 | 2094994 | 2022-01-08 | Morrow | Ohio | 39117 | 6341 | 75 |
2094995 | 2094995 | 2022-01-08 | Muskingum | Ohio | 39119 | 19793 | 233 |
2094996 | 2094996 | 2022-01-08 | Noble | Ohio | 39121 | 2556 | 50 |
2094997 | 2094997 | 2022-01-08 | Ottawa | Ohio | 39123 | 6943 | 116 |
2094998 | 2094998 | 2022-01-08 | Paulding | Ohio | 39125 | 3721 | 62 |
2094999 | 2094999 | 2022-01-08 | Perry | Ohio | 39127 | 6589 | 95 |
2095000 | 2095000 | 2022-01-08 | Pickaway | Ohio | 39129 | 14085 | 170 |
2095001 | 2095001 | 2022-01-08 | Pike | Ohio | 39131 | 5376 | 84 |
2095002 | 2095002 | 2022-01-08 | Portage | Ohio | 39133 | 29286 | 346 |
2095003 | 2095003 | 2022-01-08 | Preble | Ohio | 39135 | 7362 | 155 |
2095004 | 2095004 | 2022-01-08 | Putnam | Ohio | 39137 | 7060 | 133 |
2095005 | 2095005 | 2022-01-08 | Richland | Ohio | 39139 | 25813 | 405 |
2095006 | 2095006 | 2022-01-08 | Ross | Ohio | 39141 | 14114 | 246 |
2095007 | 2095007 | 2022-01-08 | Sandusky | Ohio | 39143 | 11440 | 194 |
2095008 | 2095008 | 2022-01-08 | Scioto | Ohio | 39145 | 14735 | 198 |
2095009 | 2095009 | 2022-01-08 | Seneca | Ohio | 39147 | 10444 | 194 |
2095010 | 2095010 | 2022-01-08 | Shelby | Ohio | 39149 | 8717 | 152 |
2095011 | 2095011 | 2022-01-08 | Stark | Ohio | 39151 | 68338 | 1342 |
2095012 | 2095012 | 2022-01-08 | Summit | Ohio | 39153 | 98890 | 1336 |
2095013 | 2095013 | 2022-01-08 | Trumbull | Ohio | 39155 | 34645 | 710 |
2095014 | 2095014 | 2022-01-08 | Tuscarawas | Ohio | 39157 | 17380 | 414 |
2095015 | 2095015 | 2022-01-08 | Union | Ohio | 39159 | 11678 | 81 |
2095016 | 2095016 | 2022-01-08 | Unknown | Ohio | 0 | 8 | |
2095017 | 2095017 | 2022-01-08 | Van Wert | Ohio | 39161 | 5262 | 115 |
2095018 | 2095018 | 2022-01-08 | Vinton | Ohio | 39163 | 2180 | 44 |
2095019 | 2095019 | 2022-01-08 | Warren | Ohio | 39165 | 43653 | 458 |
2095020 | 2095020 | 2022-01-08 | Washington | Ohio | 39167 | 9764 | 167 |
2095021 | 2095021 | 2022-01-08 | Wayne | Ohio | 39169 | 19483 | 343 |
2095022 | 2095022 | 2022-01-08 | Williams | Ohio | 39171 | 7386 | 128 |
2095023 | 2095023 | 2022-01-08 | Wood | Ohio | 39173 | 24523 | 284 |
2095024 | 2095024 | 2022-01-08 | Wyandot | Ohio | 39175 | 4402 | 83 |
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);