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 2020-11-26 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 |
---|---|---|---|---|---|---|---|
769967 | 769967 | 2020-11-26 | Adams | Ohio | 39001 | 803 | 13 |
769968 | 769968 | 2020-11-26 | Allen | Ohio | 39003 | 4949 | 89 |
769969 | 769969 | 2020-11-26 | Ashland | Ohio | 39005 | 1078 | 25 |
769970 | 769970 | 2020-11-26 | Ashtabula | Ohio | 39007 | 2283 | 54 |
769971 | 769971 | 2020-11-26 | Athens | Ohio | 39009 | 1913 | 4 |
769972 | 769972 | 2020-11-26 | Auglaize | Ohio | 39011 | 2364 | 35 |
769973 | 769973 | 2020-11-26 | Belmont | Ohio | 39013 | 1702 | 29 |
769974 | 769974 | 2020-11-26 | Brown | Ohio | 39015 | 1013 | 5 |
769975 | 769975 | 2020-11-26 | Butler | Ohio | 39017 | 15199 | 148 |
769976 | 769976 | 2020-11-26 | Carroll | Ohio | 39019 | 488 | 10 |
769977 | 769977 | 2020-11-26 | Champaign | Ohio | 39021 | 982 | 5 |
769978 | 769978 | 2020-11-26 | Clark | Ohio | 39023 | 5218 | 101 |
769979 | 769979 | 2020-11-26 | Clermont | Ohio | 39025 | 5936 | 51 |
769980 | 769980 | 2020-11-26 | Clinton | Ohio | 39027 | 1091 | 15 |
769981 | 769981 | 2020-11-26 | Columbiana | Ohio | 39029 | 3576 | 98 |
769982 | 769982 | 2020-11-26 | Coshocton | Ohio | 39031 | 852 | 15 |
769983 | 769983 | 2020-11-26 | Crawford | Ohio | 39033 | 1268 | 17 |
769984 | 769984 | 2020-11-26 | Cuyahoga | Ohio | 39035 | 37222 | 743 |
769985 | 769985 | 2020-11-26 | Darke | Ohio | 39037 | 2325 | 60 |
769986 | 769986 | 2020-11-26 | Defiance | Ohio | 39039 | 1448 | 23 |
769987 | 769987 | 2020-11-26 | Delaware | Ohio | 39041 | 5725 | 37 |
769988 | 769988 | 2020-11-26 | Erie | Ohio | 39043 | 2302 | 68 |
769989 | 769989 | 2020-11-26 | Fairfield | Ohio | 39045 | 5544 | 64 |
769990 | 769990 | 2020-11-26 | Fayette | Ohio | 39047 | 927 | 17 |
769991 | 769991 | 2020-11-26 | Franklin | Ohio | 39049 | 51161 | 671 |
769992 | 769992 | 2020-11-26 | Fulton | Ohio | 39051 | 1287 | 26 |
769993 | 769993 | 2020-11-26 | Gallia | Ohio | 39053 | 765 | 13 |
769994 | 769994 | 2020-11-26 | Geauga | Ohio | 39055 | 2118 | 51 |
769995 | 769995 | 2020-11-26 | Greene | Ohio | 39057 | 5380 | 66 |
769996 | 769996 | 2020-11-26 | Guernsey | Ohio | 39059 | 893 | 14 |
769997 | 769997 | 2020-11-26 | Hamilton | Ohio | 39061 | 30493 | 372 |
769998 | 769998 | 2020-11-26 | Hancock | Ohio | 39063 | 2459 | 40 |
769999 | 769999 | 2020-11-26 | Hardin | Ohio | 39065 | 997 | 19 |
770000 | 770000 | 2020-11-26 | Harrison | Ohio | 39067 | 219 | 3 |
770001 | 770001 | 2020-11-26 | Henry | Ohio | 39069 | 1013 | 23 |
770002 | 770002 | 2020-11-26 | Highland | Ohio | 39071 | 1037 | 18 |
770003 | 770003 | 2020-11-26 | Hocking | Ohio | 39073 | 645 | 16 |
770004 | 770004 | 2020-11-26 | Holmes | Ohio | 39075 | 1404 | 39 |
770005 | 770005 | 2020-11-26 | Huron | Ohio | 39077 | 1555 | 19 |
770006 | 770006 | 2020-11-26 | Jackson | Ohio | 39079 | 962 | 12 |
770007 | 770007 | 2020-11-26 | Jefferson | Ohio | 39081 | 1286 | 13 |
770008 | 770008 | 2020-11-26 | Knox | Ohio | 39083 | 1317 | 18 |
770009 | 770009 | 2020-11-26 | Lake | Ohio | 39085 | 7100 | 67 |
770010 | 770010 | 2020-11-26 | Lawrence | Ohio | 39087 | 1930 | 39 |
770011 | 770011 | 2020-11-26 | Licking | Ohio | 39089 | 5645 | 77 |
770012 | 770012 | 2020-11-26 | Logan | Ohio | 39091 | 1335 | 17 |
770013 | 770013 | 2020-11-26 | Lorain | Ohio | 39093 | 6690 | 106 |
770014 | 770014 | 2020-11-26 | Lucas | Ohio | 39095 | 14566 | 417 |
770015 | 770015 | 2020-11-26 | Madison | Ohio | 39097 | 1631 | 19 |
770016 | 770016 | 2020-11-26 | Mahoning | Ohio | 39099 | 7530 | 300 |
770017 | 770017 | 2020-11-26 | Marion | Ohio | 39101 | 4767 | 59 |
770018 | 770018 | 2020-11-26 | Medina | Ohio | 39103 | 4716 | 57 |
770019 | 770019 | 2020-11-26 | Meigs | Ohio | 39105 | 396 | 12 |
770020 | 770020 | 2020-11-26 | Mercer | Ohio | 39107 | 2960 | 47 |
770021 | 770021 | 2020-11-26 | Miami | Ohio | 39109 | 4375 | 68 |
770022 | 770022 | 2020-11-26 | Monroe | Ohio | 39111 | 323 | 21 |
770023 | 770023 | 2020-11-26 | Montgomery | Ohio | 39113 | 20518 | 236 |
770024 | 770024 | 2020-11-26 | Morgan | Ohio | 39115 | 268 | 5 |
770025 | 770025 | 2020-11-26 | Morrow | Ohio | 39117 | 920 | 2 |
770026 | 770026 | 2020-11-26 | Muskingum | Ohio | 39119 | 2525 | 10 |
770027 | 770027 | 2020-11-26 | Noble | Ohio | 39121 | 622 | 24 |
770028 | 770028 | 2020-11-26 | Ottawa | Ohio | 39123 | 1245 | 30 |
770029 | 770029 | 2020-11-26 | Paulding | Ohio | 39125 | 665 | 11 |
770030 | 770030 | 2020-11-26 | Perry | Ohio | 39127 | 829 | 12 |
770031 | 770031 | 2020-11-26 | Pickaway | Ohio | 39129 | 4040 | 48 |
770032 | 770032 | 2020-11-26 | Pike | Ohio | 39131 | 766 | 1 |
770033 | 770033 | 2020-11-26 | Portage | Ohio | 39133 | 3589 | 72 |
770034 | 770034 | 2020-11-26 | Preble | Ohio | 39135 | 1565 | 21 |
770035 | 770035 | 2020-11-26 | Putnam | Ohio | 39137 | 2294 | 49 |
770036 | 770036 | 2020-11-26 | Richland | Ohio | 39139 | 3285 | 39 |
770037 | 770037 | 2020-11-26 | Ross | Ohio | 39141 | 2445 | 59 |
770038 | 770038 | 2020-11-26 | Sandusky | Ohio | 39143 | 1577 | 29 |
770039 | 770039 | 2020-11-26 | Scioto | Ohio | 39145 | 2006 | 16 |
770040 | 770040 | 2020-11-26 | Seneca | Ohio | 39147 | 1829 | 19 |
770041 | 770041 | 2020-11-26 | Shelby | Ohio | 39149 | 1940 | 17 |
770042 | 770042 | 2020-11-26 | Stark | Ohio | 39151 | 9193 | 206 |
770043 | 770043 | 2020-11-26 | Summit | Ohio | 39153 | 13933 | 327 |
770044 | 770044 | 2020-11-26 | Trumbull | Ohio | 39155 | 5584 | 147 |
770045 | 770045 | 2020-11-26 | Tuscarawas | Ohio | 39157 | 3426 | 67 |
770046 | 770046 | 2020-11-26 | Union | Ohio | 39159 | 1966 | 8 |
770047 | 770047 | 2020-11-26 | Van Wert | Ohio | 39161 | 973 | 18 |
770048 | 770048 | 2020-11-26 | Vinton | Ohio | 39163 | 224 | 6 |
770049 | 770049 | 2020-11-26 | Warren | Ohio | 39165 | 8419 | 76 |
770050 | 770050 | 2020-11-26 | Washington | Ohio | 39167 | 1252 | 27 |
770051 | 770051 | 2020-11-26 | Wayne | Ohio | 39169 | 3273 | 94 |
770052 | 770052 | 2020-11-26 | Williams | Ohio | 39171 | 1079 | 9 |
770053 | 770053 | 2020-11-26 | Wood | Ohio | 39173 | 4598 | 107 |
770054 | 770054 | 2020-11-26 | Wyandot | Ohio | 39175 | 732 | 17 |
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);