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 2021-12-15 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 |
---|---|---|---|---|---|---|---|
2016922 | 2016922 | 2021-12-15 | Adams | Ohio | 39001 | 4776 | 112 |
2016923 | 2016923 | 2021-12-15 | Allen | Ohio | 39003 | 19909 | 336 |
2016924 | 2016924 | 2021-12-15 | Ashland | Ohio | 39005 | 8459 | 160 |
2016925 | 2016925 | 2021-12-15 | Ashtabula | Ohio | 39007 | 13820 | 265 |
2016926 | 2016926 | 2021-12-15 | Athens | Ohio | 39009 | 8613 | 99 |
2016927 | 2016927 | 2021-12-15 | Auglaize | Ohio | 39011 | 8312 | 123 |
2016928 | 2016928 | 2021-12-15 | Belmont | Ohio | 39013 | 10844 | 235 |
2016929 | 2016929 | 2021-12-15 | Brown | Ohio | 39015 | 7545 | 121 |
2016930 | 2016930 | 2021-12-15 | Butler | Ohio | 39017 | 59547 | 843 |
2016931 | 2016931 | 2021-12-15 | Carroll | Ohio | 39019 | 3927 | 82 |
2016932 | 2016932 | 2021-12-15 | Champaign | Ohio | 39021 | 6137 | 93 |
2016933 | 2016933 | 2021-12-15 | Clark | Ohio | 39023 | 23439 | 401 |
2016934 | 2016934 | 2021-12-15 | Clermont | Ohio | 39025 | 33032 | 378 |
2016935 | 2016935 | 2021-12-15 | Clinton | Ohio | 39027 | 6813 | 110 |
2016936 | 2016936 | 2021-12-15 | Columbiana | Ohio | 39029 | 17757 | 357 |
2016937 | 2016937 | 2021-12-15 | Coshocton | Ohio | 39031 | 5878 | 115 |
2016938 | 2016938 | 2021-12-15 | Crawford | Ohio | 39033 | 7767 | 156 |
2016939 | 2016939 | 2021-12-15 | Cuyahoga | Ohio | 39035 | 181473 | 2705 |
2016940 | 2016940 | 2021-12-15 | Darke | Ohio | 39037 | 8806 | 182 |
2016941 | 2016941 | 2021-12-15 | Defiance | Ohio | 39039 | 7680 | 118 |
2016942 | 2016942 | 2021-12-15 | Delaware | Ohio | 39041 | 28410 | 189 |
2016943 | 2016943 | 2021-12-15 | Erie | Ohio | 39043 | 13331 | 209 |
2016944 | 2016944 | 2021-12-15 | Fairfield | Ohio | 39045 | 25785 | 296 |
2016945 | 2016945 | 2021-12-15 | Fayette | Ohio | 39047 | 5216 | 72 |
2016946 | 2016946 | 2021-12-15 | Franklin | Ohio | 39049 | 186244 | 1868 |
2016947 | 2016947 | 2021-12-15 | Fulton | Ohio | 39051 | 7589 | 122 |
2016948 | 2016948 | 2021-12-15 | Gallia | Ohio | 39053 | 4917 | 79 |
2016949 | 2016949 | 2021-12-15 | Geauga | Ohio | 39055 | 11592 | 187 |
2016950 | 2016950 | 2021-12-15 | Greene | Ohio | 39057 | 25254 | 385 |
2016951 | 2016951 | 2021-12-15 | Guernsey | Ohio | 39059 | 7363 | 89 |
2016952 | 2016952 | 2021-12-15 | Hamilton | Ohio | 39061 | 118872 | 1573 |
2016953 | 2016953 | 2021-12-15 | Hancock | Ohio | 39063 | 12126 | 178 |
2016954 | 2016954 | 2021-12-15 | Hardin | Ohio | 39065 | 5174 | 109 |
2016955 | 2016955 | 2021-12-15 | Harrison | Ohio | 39067 | 2258 | 54 |
2016956 | 2016956 | 2021-12-15 | Henry | Ohio | 39069 | 4570 | 81 |
2016957 | 2016957 | 2021-12-15 | Highland | Ohio | 39071 | 7050 | 125 |
2016958 | 2016958 | 2021-12-15 | Hocking | Ohio | 39073 | 4344 | 93 |
2016959 | 2016959 | 2021-12-15 | Holmes | Ohio | 39075 | 4133 | 145 |
2016960 | 2016960 | 2021-12-15 | Huron | Ohio | 39077 | 10319 | 166 |
2016961 | 2016961 | 2021-12-15 | Jackson | Ohio | 39079 | 6037 | 105 |
2016962 | 2016962 | 2021-12-15 | Jefferson | Ohio | 39081 | 10076 | 236 |
2016963 | 2016963 | 2021-12-15 | Knox | Ohio | 39083 | 9225 | 179 |
2016964 | 2016964 | 2021-12-15 | Lake | Ohio | 39085 | 34513 | 519 |
2016965 | 2016965 | 2021-12-15 | Lawrence | Ohio | 39087 | 11056 | 173 |
2016966 | 2016966 | 2021-12-15 | Licking | Ohio | 39089 | 28643 | 353 |
2016967 | 2016967 | 2021-12-15 | Logan | Ohio | 39091 | 7392 | 116 |
2016968 | 2016968 | 2021-12-15 | Lorain | Ohio | 39093 | 45100 | 671 |
2016969 | 2016969 | 2021-12-15 | Lucas | Ohio | 39095 | 65882 | 1045 |
2016970 | 2016970 | 2021-12-15 | Madison | Ohio | 39097 | 6739 | 95 |
2016971 | 2016971 | 2021-12-15 | Mahoning | Ohio | 39099 | 37527 | 805 |
2016972 | 2016972 | 2021-12-15 | Marion | Ohio | 39101 | 14014 | 200 |
2016973 | 2016973 | 2021-12-15 | Medina | Ohio | 39103 | 27694 | 362 |
2016974 | 2016974 | 2021-12-15 | Meigs | Ohio | 39105 | 3156 | 62 |
2016975 | 2016975 | 2021-12-15 | Mercer | Ohio | 39107 | 7173 | 100 |
2016976 | 2016976 | 2021-12-15 | Miami | Ohio | 39109 | 18111 | 357 |
2016977 | 2016977 | 2021-12-15 | Monroe | Ohio | 39111 | 2457 | 62 |
2016978 | 2016978 | 2021-12-15 | Montgomery | Ohio | 39113 | 83737 | 1440 |
2016979 | 2016979 | 2021-12-15 | Morgan | Ohio | 39115 | 2270 | 39 |
2016980 | 2016980 | 2021-12-15 | Morrow | Ohio | 39117 | 5437 | 66 |
2016981 | 2016981 | 2021-12-15 | Muskingum | Ohio | 39119 | 17360 | 217 |
2016982 | 2016982 | 2021-12-15 | Noble | Ohio | 39121 | 2276 | 49 |
2016983 | 2016983 | 2021-12-15 | Ottawa | Ohio | 39123 | 5926 | 104 |
2016984 | 2016984 | 2021-12-15 | Paulding | Ohio | 39125 | 3430 | 54 |
2016985 | 2016985 | 2021-12-15 | Perry | Ohio | 39127 | 5894 | 85 |
2016986 | 2016986 | 2021-12-15 | Pickaway | Ohio | 39129 | 12641 | 156 |
2016987 | 2016987 | 2021-12-15 | Pike | Ohio | 39131 | 4798 | 79 |
2016988 | 2016988 | 2021-12-15 | Portage | Ohio | 39133 | 22770 | 302 |
2016989 | 2016989 | 2021-12-15 | Preble | Ohio | 39135 | 6594 | 143 |
2016990 | 2016990 | 2021-12-15 | Putnam | Ohio | 39137 | 6491 | 123 |
2016991 | 2016991 | 2021-12-15 | Richland | Ohio | 39139 | 22195 | 360 |
2016992 | 2016992 | 2021-12-15 | Ross | Ohio | 39141 | 12264 | 231 |
2016993 | 2016993 | 2021-12-15 | Sandusky | Ohio | 39143 | 9868 | 176 |
2016994 | 2016994 | 2021-12-15 | Scioto | Ohio | 39145 | 13033 | 190 |
2016995 | 2016995 | 2021-12-15 | Seneca | Ohio | 39147 | 9361 | 168 |
2016996 | 2016996 | 2021-12-15 | Shelby | Ohio | 39149 | 7848 | 136 |
2016997 | 2016997 | 2021-12-15 | Stark | Ohio | 39151 | 56883 | 1222 |
2016998 | 2016998 | 2021-12-15 | Summit | Ohio | 39153 | 76483 | 1236 |
2016999 | 2016999 | 2021-12-15 | Trumbull | Ohio | 39155 | 28975 | 637 |
2017000 | 2017000 | 2021-12-15 | Tuscarawas | Ohio | 39157 | 15308 | 372 |
2017001 | 2017001 | 2021-12-15 | Union | Ohio | 39159 | 9974 | 75 |
2017002 | 2017002 | 2021-12-15 | Unknown | Ohio | 0 | 6 | |
2017003 | 2017003 | 2021-12-15 | Van Wert | Ohio | 39161 | 4899 | 100 |
2017004 | 2017004 | 2021-12-15 | Vinton | Ohio | 39163 | 1956 | 41 |
2017005 | 2017005 | 2021-12-15 | Warren | Ohio | 39165 | 37703 | 425 |
2017006 | 2017006 | 2021-12-15 | Washington | Ohio | 39167 | 8882 | 160 |
2017007 | 2017007 | 2021-12-15 | Wayne | Ohio | 39169 | 16589 | 312 |
2017008 | 2017008 | 2021-12-15 | Williams | Ohio | 39171 | 6804 | 104 |
2017009 | 2017009 | 2021-12-15 | Wood | Ohio | 39173 | 21033 | 257 |
2017010 | 2017010 | 2021-12-15 | Wyandot | Ohio | 39175 | 3981 | 78 |
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);