ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where "date" is on date 2021-01-06 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 · 88 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
903026 | 903026 | 2021-01-06 | Adams | Ohio | 39001 | 1466 | 14 |
903027 | 903027 | 2021-01-06 | Allen | Ohio | 39003 | 8707 | 118 |
903028 | 903028 | 2021-01-06 | Ashland | Ohio | 39005 | 2927 | 38 |
903029 | 903029 | 2021-01-06 | Ashtabula | Ohio | 39007 | 4037 | 66 |
903030 | 903030 | 2021-01-06 | Athens | Ohio | 39009 | 3263 | 9 |
903031 | 903031 | 2021-01-06 | Auglaize | Ohio | 39011 | 3807 | 55 |
903032 | 903032 | 2021-01-06 | Belmont | Ohio | 39013 | 3406 | 38 |
903033 | 903033 | 2021-01-06 | Brown | Ohio | 39015 | 2600 | 15 |
903034 | 903034 | 2021-01-06 | Butler | Ohio | 39017 | 27064 | 211 |
903035 | 903035 | 2021-01-06 | Carroll | Ohio | 39019 | 1226 | 13 |
903036 | 903036 | 2021-01-06 | Champaign | Ohio | 39021 | 2072 | 23 |
903037 | 903037 | 2021-01-06 | Clark | Ohio | 39023 | 9494 | 240 |
903038 | 903038 | 2021-01-06 | Clermont | Ohio | 39025 | 13152 | 86 |
903039 | 903039 | 2021-01-06 | Clinton | Ohio | 39027 | 2506 | 41 |
903040 | 903040 | 2021-01-06 | Columbiana | Ohio | 39029 | 6430 | 120 |
903041 | 903041 | 2021-01-06 | Coshocton | Ohio | 39031 | 1808 | 17 |
903042 | 903042 | 2021-01-06 | Crawford | Ohio | 39033 | 2789 | 63 |
903043 | 903043 | 2021-01-06 | Cuyahoga | Ohio | 39035 | 74199 | 931 |
903044 | 903044 | 2021-01-06 | Darke | Ohio | 39037 | 4279 | 86 |
903045 | 903045 | 2021-01-06 | Defiance | Ohio | 39039 | 2860 | 68 |
903046 | 903046 | 2021-01-06 | Delaware | Ohio | 39041 | 12262 | 69 |
903047 | 903047 | 2021-01-06 | Erie | Ohio | 39043 | 5226 | 111 |
903048 | 903048 | 2021-01-06 | Fairfield | Ohio | 39045 | 10679 | 77 |
903049 | 903049 | 2021-01-06 | Fayette | Ohio | 39047 | 1973 | 29 |
903050 | 903050 | 2021-01-06 | Franklin | Ohio | 39049 | 88447 | 700 |
903051 | 903051 | 2021-01-06 | Fulton | Ohio | 39051 | 2894 | 39 |
903052 | 903052 | 2021-01-06 | Gallia | Ohio | 39053 | 1781 | 24 |
903053 | 903053 | 2021-01-06 | Geauga | Ohio | 39055 | 4291 | 54 |
903054 | 903054 | 2021-01-06 | Greene | Ohio | 39057 | 10336 | 126 |
903055 | 903055 | 2021-01-06 | Guernsey | Ohio | 39059 | 2158 | 23 |
903056 | 903056 | 2021-01-06 | Hamilton | Ohio | 39061 | 54992 | 423 |
903057 | 903057 | 2021-01-06 | Hancock | Ohio | 39063 | 4918 | 82 |
903058 | 903058 | 2021-01-06 | Hardin | Ohio | 39065 | 1855 | 32 |
903059 | 903059 | 2021-01-06 | Harrison | Ohio | 39067 | 755 | 3 |
903060 | 903060 | 2021-01-06 | Henry | Ohio | 39069 | 1889 | 45 |
903061 | 903061 | 2021-01-06 | Highland | Ohio | 39071 | 2270 | 18 |
903062 | 903062 | 2021-01-06 | Hocking | Ohio | 39073 | 1456 | 22 |
903063 | 903063 | 2021-01-06 | Holmes | Ohio | 39075 | 2048 | 62 |
903064 | 903064 | 2021-01-06 | Huron | Ohio | 39077 | 3582 | 37 |
903065 | 903065 | 2021-01-06 | Jackson | Ohio | 39079 | 2284 | 35 |
903066 | 903066 | 2021-01-06 | Jefferson | Ohio | 39081 | 3604 | 60 |
903067 | 903067 | 2021-01-06 | Knox | Ohio | 39083 | 2993 | 22 |
903068 | 903068 | 2021-01-06 | Lake | Ohio | 39085 | 13670 | 123 |
903069 | 903069 | 2021-01-06 | Lawrence | Ohio | 39087 | 3818 | 48 |
903070 | 903070 | 2021-01-06 | Licking | Ohio | 39089 | 11212 | 121 |
903071 | 903071 | 2021-01-06 | Logan | Ohio | 39091 | 2564 | 24 |
903072 | 903072 | 2021-01-06 | Lorain | Ohio | 39093 | 15924 | 188 |
903073 | 903073 | 2021-01-06 | Lucas | Ohio | 39095 | 27228 | 553 |
903074 | 903074 | 2021-01-06 | Madison | Ohio | 39097 | 3088 | 26 |
903075 | 903075 | 2021-01-06 | Mahoning | Ohio | 39099 | 15529 | 315 |
903076 | 903076 | 2021-01-06 | Marion | Ohio | 39101 | 6938 | 106 |
903077 | 903077 | 2021-01-06 | Medina | Ohio | 39103 | 9930 | 117 |
903078 | 903078 | 2021-01-06 | Meigs | Ohio | 39105 | 912 | 14 |
903079 | 903079 | 2021-01-06 | Mercer | Ohio | 39107 | 4033 | 82 |
903080 | 903080 | 2021-01-06 | Miami | Ohio | 39109 | 8016 | 73 |
903081 | 903081 | 2021-01-06 | Monroe | Ohio | 39111 | 836 | 26 |
903082 | 903082 | 2021-01-06 | Montgomery | Ohio | 39113 | 37737 | 365 |
903083 | 903083 | 2021-01-06 | Morgan | Ohio | 39115 | 690 | 26 |
903084 | 903084 | 2021-01-06 | Morrow | Ohio | 39117 | 1957 | 4 |
903085 | 903085 | 2021-01-06 | Muskingum | Ohio | 39119 | 5827 | 38 |
903086 | 903086 | 2021-01-06 | Noble | Ohio | 39121 | 1080 | 33 |
903087 | 903087 | 2021-01-06 | Ottawa | Ohio | 39123 | 2525 | 34 |
903088 | 903088 | 2021-01-06 | Paulding | Ohio | 39125 | 1260 | 20 |
903089 | 903089 | 2021-01-06 | Perry | Ohio | 39127 | 1986 | 17 |
903090 | 903090 | 2021-01-06 | Pickaway | Ohio | 39129 | 6444 | 50 |
903091 | 903091 | 2021-01-06 | Pike | Ohio | 39131 | 1480 | 5 |
903092 | 903092 | 2021-01-06 | Portage | Ohio | 39133 | 7797 | 101 |
903093 | 903093 | 2021-01-06 | Preble | Ohio | 39135 | 2855 | 31 |
903094 | 903094 | 2021-01-06 | Putnam | Ohio | 39137 | 3399 | 67 |
903095 | 903095 | 2021-01-06 | Richland | Ohio | 39139 | 7939 | 101 |
903096 | 903096 | 2021-01-06 | Ross | Ohio | 39141 | 4748 | 87 |
903097 | 903097 | 2021-01-06 | Sandusky | Ohio | 39143 | 3770 | 59 |
903098 | 903098 | 2021-01-06 | Scioto | Ohio | 39145 | 4606 | 48 |
903099 | 903099 | 2021-01-06 | Seneca | Ohio | 39147 | 3697 | 44 |
903100 | 903100 | 2021-01-06 | Shelby | Ohio | 39149 | 3727 | 20 |
903101 | 903101 | 2021-01-06 | Stark | Ohio | 39151 | 21744 | 362 |
903102 | 903102 | 2021-01-06 | Summit | Ohio | 39153 | 29645 | 627 |
903103 | 903103 | 2021-01-06 | Trumbull | Ohio | 39155 | 11353 | 278 |
903104 | 903104 | 2021-01-06 | Tuscarawas | Ohio | 39157 | 6470 | 156 |
903105 | 903105 | 2021-01-06 | Union | Ohio | 39159 | 3843 | 21 |
903106 | 903106 | 2021-01-06 | Van Wert | Ohio | 39161 | 1827 | 37 |
903107 | 903107 | 2021-01-06 | Vinton | Ohio | 39163 | 559 | 13 |
903108 | 903108 | 2021-01-06 | Warren | Ohio | 39165 | 16873 | 124 |
903109 | 903109 | 2021-01-06 | Washington | Ohio | 39167 | 3218 | 39 |
903110 | 903110 | 2021-01-06 | Wayne | Ohio | 39169 | 6167 | 154 |
903111 | 903111 | 2021-01-06 | Williams | Ohio | 39171 | 2445 | 51 |
903112 | 903112 | 2021-01-06 | Wood | Ohio | 39173 | 8923 | 149 |
903113 | 903113 | 2021-01-06 | Wyandot | Ohio | 39175 | 1743 | 46 |
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);