ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where date = "2021-07-16" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
1523064 | 1523064 | 2021-07-16 | Adams | Ohio | 39001 | 2453 | 57 |
1523065 | 1523065 | 2021-07-16 | Allen | Ohio | 39003 | 11992 | 246 |
1523066 | 1523066 | 2021-07-16 | Ashland | Ohio | 39005 | 4386 | 98 |
1523067 | 1523067 | 2021-07-16 | Ashtabula | Ohio | 39007 | 7238 | 179 |
1523068 | 1523068 | 2021-07-16 | Athens | Ohio | 39009 | 5254 | 60 |
1523069 | 1523069 | 2021-07-16 | Auglaize | Ohio | 39011 | 5056 | 87 |
1523070 | 1523070 | 2021-07-16 | Belmont | Ohio | 39013 | 6188 | 178 |
1523071 | 1523071 | 2021-07-16 | Brown | Ohio | 39015 | 4056 | 62 |
1523072 | 1523072 | 2021-07-16 | Butler | Ohio | 39017 | 39699 | 613 |
1523073 | 1523073 | 2021-07-16 | Carroll | Ohio | 39019 | 1994 | 49 |
1523074 | 1523074 | 2021-07-16 | Champaign | Ohio | 39021 | 3468 | 60 |
1523075 | 1523075 | 2021-07-16 | Clark | Ohio | 39023 | 14292 | 307 |
1523076 | 1523076 | 2021-07-16 | Clermont | Ohio | 39025 | 20254 | 259 |
1523077 | 1523077 | 2021-07-16 | Clinton | Ohio | 39027 | 3857 | 66 |
1523078 | 1523078 | 2021-07-16 | Columbiana | Ohio | 39029 | 9078 | 236 |
1523079 | 1523079 | 2021-07-16 | Coshocton | Ohio | 39031 | 2714 | 61 |
1523080 | 1523080 | 2021-07-16 | Crawford | Ohio | 39033 | 4078 | 111 |
1523081 | 1523081 | 2021-07-16 | Cuyahoga | Ohio | 39035 | 116538 | 2255 |
1523082 | 1523082 | 2021-07-16 | Darke | Ohio | 39037 | 5434 | 129 |
1523083 | 1523083 | 2021-07-16 | Defiance | Ohio | 39039 | 4357 | 99 |
1523084 | 1523084 | 2021-07-16 | Delaware | Ohio | 39041 | 19006 | 137 |
1523085 | 1523085 | 2021-07-16 | Erie | Ohio | 39043 | 8087 | 166 |
1523086 | 1523086 | 2021-07-16 | Fairfield | Ohio | 39045 | 16673 | 207 |
1523087 | 1523087 | 2021-07-16 | Fayette | Ohio | 39047 | 2870 | 50 |
1523088 | 1523088 | 2021-07-16 | Franklin | Ohio | 39049 | 129657 | 1491 |
1523089 | 1523089 | 2021-07-16 | Fulton | Ohio | 39051 | 4337 | 75 |
1523090 | 1523090 | 2021-07-16 | Gallia | Ohio | 39053 | 2446 | 50 |
1523091 | 1523091 | 2021-07-16 | Geauga | Ohio | 39055 | 6894 | 153 |
1523092 | 1523092 | 2021-07-16 | Greene | Ohio | 39057 | 15384 | 253 |
1523093 | 1523093 | 2021-07-16 | Guernsey | Ohio | 39059 | 3279 | 54 |
1523094 | 1523094 | 2021-07-16 | Hamilton | Ohio | 39061 | 81861 | 1259 |
1523095 | 1523095 | 2021-07-16 | Hancock | Ohio | 39063 | 7026 | 134 |
1523096 | 1523096 | 2021-07-16 | Hardin | Ohio | 39065 | 2781 | 65 |
1523097 | 1523097 | 2021-07-16 | Harrison | Ohio | 39067 | 1148 | 38 |
1523098 | 1523098 | 2021-07-16 | Henry | Ohio | 39069 | 2754 | 67 |
1523099 | 1523099 | 2021-07-16 | Highland | Ohio | 39071 | 3626 | 68 |
1523100 | 1523100 | 2021-07-16 | Hocking | Ohio | 39073 | 2212 | 63 |
1523101 | 1523101 | 2021-07-16 | Holmes | Ohio | 39075 | 2721 | 102 |
1523102 | 1523102 | 2021-07-16 | Huron | Ohio | 39077 | 5600 | 122 |
1523103 | 1523103 | 2021-07-16 | Jackson | Ohio | 39079 | 3204 | 54 |
1523104 | 1523104 | 2021-07-16 | Jefferson | Ohio | 39081 | 5708 | 162 |
1523105 | 1523105 | 2021-07-16 | Knox | Ohio | 39083 | 4590 | 112 |
1523106 | 1523106 | 2021-07-16 | Lake | Ohio | 39085 | 21351 | 394 |
1523107 | 1523107 | 2021-07-16 | Lawrence | Ohio | 39087 | 5844 | 104 |
1523108 | 1523108 | 2021-07-16 | Licking | Ohio | 39089 | 16749 | 226 |
1523109 | 1523109 | 2021-07-16 | Logan | Ohio | 39091 | 3904 | 79 |
1523110 | 1523110 | 2021-07-16 | Lorain | Ohio | 39093 | 25806 | 508 |
1523111 | 1523111 | 2021-07-16 | Lucas | Ohio | 39095 | 43545 | 830 |
1523112 | 1523112 | 2021-07-16 | Madison | Ohio | 39097 | 4462 | 66 |
1523113 | 1523113 | 2021-07-16 | Mahoning | Ohio | 39099 | 22484 | 612 |
1523114 | 1523114 | 2021-07-16 | Marion | Ohio | 39101 | 8669 | 140 |
1523115 | 1523115 | 2021-07-16 | Medina | Ohio | 39103 | 15727 | 276 |
1523116 | 1523116 | 2021-07-16 | Meigs | Ohio | 39105 | 1496 | 40 |
1523117 | 1523117 | 2021-07-16 | Mercer | Ohio | 39107 | 4892 | 85 |
1523118 | 1523118 | 2021-07-16 | Miami | Ohio | 39109 | 10915 | 228 |
1523119 | 1523119 | 2021-07-16 | Monroe | Ohio | 39111 | 1373 | 45 |
1523120 | 1523120 | 2021-07-16 | Montgomery | Ohio | 39113 | 52965 | 1059 |
1523121 | 1523121 | 2021-07-16 | Morgan | Ohio | 39115 | 1110 | 24 |
1523122 | 1523122 | 2021-07-16 | Morrow | Ohio | 39117 | 2939 | 43 |
1523123 | 1523123 | 2021-07-16 | Muskingum | Ohio | 39119 | 9051 | 137 |
1523124 | 1523124 | 2021-07-16 | Noble | Ohio | 39121 | 1367 | 39 |
1523125 | 1523125 | 2021-07-16 | Ottawa | Ohio | 39123 | 3739 | 81 |
1523126 | 1523126 | 2021-07-16 | Paulding | Ohio | 39125 | 1789 | 42 |
1523127 | 1523127 | 2021-07-16 | Perry | Ohio | 39127 | 2976 | 50 |
1523128 | 1523128 | 2021-07-16 | Pickaway | Ohio | 39129 | 8700 | 122 |
1523129 | 1523129 | 2021-07-16 | Pike | Ohio | 39131 | 2437 | 37 |
1523130 | 1523130 | 2021-07-16 | Portage | Ohio | 39133 | 13331 | 217 |
1523131 | 1523131 | 2021-07-16 | Preble | Ohio | 39135 | 3910 | 106 |
1523132 | 1523132 | 2021-07-16 | Putnam | Ohio | 39137 | 4339 | 104 |
1523133 | 1523133 | 2021-07-16 | Richland | Ohio | 39139 | 11659 | 213 |
1523134 | 1523134 | 2021-07-16 | Ross | Ohio | 39141 | 6982 | 165 |
1523135 | 1523135 | 2021-07-16 | Sandusky | Ohio | 39143 | 5457 | 130 |
1523136 | 1523136 | 2021-07-16 | Scioto | Ohio | 39145 | 6592 | 108 |
1523137 | 1523137 | 2021-07-16 | Seneca | Ohio | 39147 | 5368 | 128 |
1523138 | 1523138 | 2021-07-16 | Shelby | Ohio | 39149 | 4794 | 97 |
1523139 | 1523139 | 2021-07-16 | Stark | Ohio | 39151 | 33594 | 937 |
1523140 | 1523140 | 2021-07-16 | Summit | Ohio | 39153 | 48679 | 1013 |
1523141 | 1523141 | 2021-07-16 | Trumbull | Ohio | 39155 | 16640 | 487 |
1523142 | 1523142 | 2021-07-16 | Tuscarawas | Ohio | 39157 | 8690 | 254 |
1523143 | 1523143 | 2021-07-16 | Union | Ohio | 39159 | 5880 | 49 |
1523144 | 1523144 | 2021-07-16 | Unknown | Ohio | 0 | 3 | |
1523145 | 1523145 | 2021-07-16 | Van Wert | Ohio | 39161 | 2503 | 65 |
1523146 | 1523146 | 2021-07-16 | Vinton | Ohio | 39163 | 870 | 17 |
1523147 | 1523147 | 2021-07-16 | Warren | Ohio | 39165 | 24752 | 310 |
1523148 | 1523148 | 2021-07-16 | Washington | Ohio | 39167 | 5336 | 111 |
1523149 | 1523149 | 2021-07-16 | Wayne | Ohio | 39169 | 9207 | 226 |
1523150 | 1523150 | 2021-07-16 | Williams | Ohio | 39171 | 3536 | 78 |
1523151 | 1523151 | 2021-07-16 | Wood | Ohio | 39173 | 13312 | 201 |
1523152 | 1523152 | 2021-07-16 | Wyandot | Ohio | 39175 | 2351 | 57 |
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);