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-06-13 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 |
---|---|---|---|---|---|---|---|
1415943 | 1415943 | 2021-06-13 | Adams | Ohio | 39001 | 2428 | 56 |
1415944 | 1415944 | 2021-06-13 | Allen | Ohio | 39003 | 11905 | 239 |
1415945 | 1415945 | 2021-06-13 | Ashland | Ohio | 39005 | 4351 | 97 |
1415946 | 1415946 | 2021-06-13 | Ashtabula | Ohio | 39007 | 7137 | 179 |
1415947 | 1415947 | 2021-06-13 | Athens | Ohio | 39009 | 5233 | 60 |
1415948 | 1415948 | 2021-06-13 | Auglaize | Ohio | 39011 | 5015 | 87 |
1415949 | 1415949 | 2021-06-13 | Belmont | Ohio | 39013 | 6149 | 174 |
1415950 | 1415950 | 2021-06-13 | Brown | Ohio | 39015 | 4019 | 61 |
1415951 | 1415951 | 2021-06-13 | Butler | Ohio | 39017 | 38901 | 603 |
1415952 | 1415952 | 2021-06-13 | Carroll | Ohio | 39019 | 1967 | 48 |
1415953 | 1415953 | 2021-06-13 | Champaign | Ohio | 39021 | 3436 | 58 |
1415954 | 1415954 | 2021-06-13 | Clark | Ohio | 39023 | 14219 | 306 |
1415955 | 1415955 | 2021-06-13 | Clermont | Ohio | 39025 | 20097 | 252 |
1415956 | 1415956 | 2021-06-13 | Clinton | Ohio | 39027 | 3784 | 66 |
1415957 | 1415957 | 2021-06-13 | Columbiana | Ohio | 39029 | 9020 | 230 |
1415958 | 1415958 | 2021-06-13 | Coshocton | Ohio | 39031 | 2683 | 59 |
1415959 | 1415959 | 2021-06-13 | Crawford | Ohio | 39033 | 4033 | 110 |
1415960 | 1415960 | 2021-06-13 | Cuyahoga | Ohio | 39035 | 115597 | 2204 |
1415961 | 1415961 | 2021-06-13 | Darke | Ohio | 39037 | 5415 | 129 |
1415962 | 1415962 | 2021-06-13 | Defiance | Ohio | 39039 | 4317 | 98 |
1415963 | 1415963 | 2021-06-13 | Delaware | Ohio | 39041 | 18817 | 135 |
1415964 | 1415964 | 2021-06-13 | Erie | Ohio | 39043 | 8052 | 164 |
1415965 | 1415965 | 2021-06-13 | Fairfield | Ohio | 39045 | 16561 | 204 |
1415966 | 1415966 | 2021-06-13 | Fayette | Ohio | 39047 | 2854 | 50 |
1415967 | 1415967 | 2021-06-13 | Franklin | Ohio | 39049 | 128492 | 1459 |
1415968 | 1415968 | 2021-06-13 | Fulton | Ohio | 39051 | 4318 | 71 |
1415969 | 1415969 | 2021-06-13 | Gallia | Ohio | 39053 | 2404 | 50 |
1415970 | 1415970 | 2021-06-13 | Geauga | Ohio | 39055 | 6832 | 150 |
1415971 | 1415971 | 2021-06-13 | Greene | Ohio | 39057 | 15252 | 246 |
1415972 | 1415972 | 2021-06-13 | Guernsey | Ohio | 39059 | 3241 | 53 |
1415973 | 1415973 | 2021-06-13 | Hamilton | Ohio | 39061 | 81299 | 1245 |
1415974 | 1415974 | 2021-06-13 | Hancock | Ohio | 39063 | 6996 | 131 |
1415975 | 1415975 | 2021-06-13 | Hardin | Ohio | 39065 | 2748 | 65 |
1415976 | 1415976 | 2021-06-13 | Harrison | Ohio | 39067 | 1136 | 38 |
1415977 | 1415977 | 2021-06-13 | Henry | Ohio | 39069 | 2732 | 67 |
1415978 | 1415978 | 2021-06-13 | Highland | Ohio | 39071 | 3592 | 65 |
1415979 | 1415979 | 2021-06-13 | Hocking | Ohio | 39073 | 2201 | 62 |
1415980 | 1415980 | 2021-06-13 | Holmes | Ohio | 39075 | 2698 | 101 |
1415981 | 1415981 | 2021-06-13 | Huron | Ohio | 39077 | 5539 | 122 |
1415982 | 1415982 | 2021-06-13 | Jackson | Ohio | 39079 | 3173 | 54 |
1415983 | 1415983 | 2021-06-13 | Jefferson | Ohio | 39081 | 5669 | 158 |
1415984 | 1415984 | 2021-06-13 | Knox | Ohio | 39083 | 4567 | 112 |
1415985 | 1415985 | 2021-06-13 | Lake | Ohio | 39085 | 21135 | 385 |
1415986 | 1415986 | 2021-06-13 | Lawrence | Ohio | 39087 | 5722 | 102 |
1415987 | 1415987 | 2021-06-13 | Licking | Ohio | 39089 | 16645 | 222 |
1415988 | 1415988 | 2021-06-13 | Logan | Ohio | 39091 | 3872 | 77 |
1415989 | 1415989 | 2021-06-13 | Lorain | Ohio | 39093 | 25641 | 502 |
1415990 | 1415990 | 2021-06-13 | Lucas | Ohio | 39095 | 43303 | 817 |
1415991 | 1415991 | 2021-06-13 | Madison | Ohio | 39097 | 4437 | 65 |
1415992 | 1415992 | 2021-06-13 | Mahoning | Ohio | 39099 | 22330 | 601 |
1415993 | 1415993 | 2021-06-13 | Marion | Ohio | 39101 | 8635 | 138 |
1415994 | 1415994 | 2021-06-13 | Medina | Ohio | 39103 | 15593 | 270 |
1415995 | 1415995 | 2021-06-13 | Meigs | Ohio | 39105 | 1482 | 40 |
1415996 | 1415996 | 2021-06-13 | Mercer | Ohio | 39107 | 4873 | 85 |
1415997 | 1415997 | 2021-06-13 | Miami | Ohio | 39109 | 10835 | 223 |
1415998 | 1415998 | 2021-06-13 | Monroe | Ohio | 39111 | 1361 | 44 |
1415999 | 1415999 | 2021-06-13 | Montgomery | Ohio | 39113 | 52482 | 1040 |
1416000 | 1416000 | 2021-06-13 | Morgan | Ohio | 39115 | 1096 | 24 |
1416001 | 1416001 | 2021-06-13 | Morrow | Ohio | 39117 | 2913 | 40 |
1416002 | 1416002 | 2021-06-13 | Muskingum | Ohio | 39119 | 8889 | 135 |
1416003 | 1416003 | 2021-06-13 | Noble | Ohio | 39121 | 1358 | 39 |
1416004 | 1416004 | 2021-06-13 | Ottawa | Ohio | 39123 | 3726 | 81 |
1416005 | 1416005 | 2021-06-13 | Paulding | Ohio | 39125 | 1763 | 42 |
1416006 | 1416006 | 2021-06-13 | Perry | Ohio | 39127 | 2971 | 50 |
1416007 | 1416007 | 2021-06-13 | Pickaway | Ohio | 39129 | 8649 | 122 |
1416008 | 1416008 | 2021-06-13 | Pike | Ohio | 39131 | 2427 | 35 |
1416009 | 1416009 | 2021-06-13 | Portage | Ohio | 39133 | 13226 | 214 |
1416010 | 1416010 | 2021-06-13 | Preble | Ohio | 39135 | 3847 | 103 |
1416011 | 1416011 | 2021-06-13 | Putnam | Ohio | 39137 | 4333 | 103 |
1416012 | 1416012 | 2021-06-13 | Richland | Ohio | 39139 | 11598 | 211 |
1416013 | 1416013 | 2021-06-13 | Ross | Ohio | 39141 | 6933 | 161 |
1416014 | 1416014 | 2021-06-13 | Sandusky | Ohio | 39143 | 5436 | 125 |
1416015 | 1416015 | 2021-06-13 | Scioto | Ohio | 39145 | 6528 | 104 |
1416016 | 1416016 | 2021-06-13 | Seneca | Ohio | 39147 | 5343 | 126 |
1416017 | 1416017 | 2021-06-13 | Shelby | Ohio | 39149 | 4761 | 95 |
1416018 | 1416018 | 2021-06-13 | Stark | Ohio | 39151 | 33286 | 929 |
1416019 | 1416019 | 2021-06-13 | Summit | Ohio | 39153 | 48339 | 999 |
1416020 | 1416020 | 2021-06-13 | Trumbull | Ohio | 39155 | 16522 | 479 |
1416021 | 1416021 | 2021-06-13 | Tuscarawas | Ohio | 39157 | 8633 | 247 |
1416022 | 1416022 | 2021-06-13 | Union | Ohio | 39159 | 5838 | 49 |
1416023 | 1416023 | 2021-06-13 | Unknown | Ohio | 0 | 3 | |
1416024 | 1416024 | 2021-06-13 | Van Wert | Ohio | 39161 | 2472 | 64 |
1416025 | 1416025 | 2021-06-13 | Vinton | Ohio | 39163 | 854 | 17 |
1416026 | 1416026 | 2021-06-13 | Warren | Ohio | 39165 | 24557 | 303 |
1416027 | 1416027 | 2021-06-13 | Washington | Ohio | 39167 | 5308 | 109 |
1416028 | 1416028 | 2021-06-13 | Wayne | Ohio | 39169 | 9116 | 222 |
1416029 | 1416029 | 2021-06-13 | Williams | Ohio | 39171 | 3475 | 78 |
1416030 | 1416030 | 2021-06-13 | Wood | Ohio | 39173 | 13280 | 197 |
1416031 | 1416031 | 2021-06-13 | Wyandot | Ohio | 39175 | 2345 | 56 |
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);