ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-11-10" 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 · 88 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
718044 | 718044 | 2020-11-10 | Adams | Ohio | 39001 | 404 | 6 |
718045 | 718045 | 2020-11-10 | Allen | Ohio | 39003 | 3211 | 80 |
718046 | 718046 | 2020-11-10 | Ashland | Ohio | 39005 | 641 | 20 |
718047 | 718047 | 2020-11-10 | Ashtabula | Ohio | 39007 | 1238 | 48 |
718048 | 718048 | 2020-11-10 | Athens | Ohio | 39009 | 1522 | 4 |
718049 | 718049 | 2020-11-10 | Auglaize | Ohio | 39011 | 1591 | 19 |
718050 | 718050 | 2020-11-10 | Belmont | Ohio | 39013 | 1115 | 27 |
718051 | 718051 | 2020-11-10 | Brown | Ohio | 39015 | 615 | 4 |
718052 | 718052 | 2020-11-10 | Butler | Ohio | 39017 | 11122 | 135 |
718053 | 718053 | 2020-11-10 | Carroll | Ohio | 39019 | 308 | 10 |
718054 | 718054 | 2020-11-10 | Champaign | Ohio | 39021 | 597 | 4 |
718055 | 718055 | 2020-11-10 | Clark | Ohio | 39023 | 3580 | 58 |
718056 | 718056 | 2020-11-10 | Clermont | Ohio | 39025 | 3714 | 41 |
718057 | 718057 | 2020-11-10 | Clinton | Ohio | 39027 | 742 | 14 |
718058 | 718058 | 2020-11-10 | Columbiana | Ohio | 39029 | 2546 | 88 |
718059 | 718059 | 2020-11-10 | Coshocton | Ohio | 39031 | 559 | 13 |
718060 | 718060 | 2020-11-10 | Crawford | Ohio | 39033 | 766 | 9 |
718061 | 718061 | 2020-11-10 | Cuyahoga | Ohio | 39035 | 25511 | 712 |
718062 | 718062 | 2020-11-10 | Darke | Ohio | 39037 | 1522 | 54 |
718063 | 718063 | 2020-11-10 | Defiance | Ohio | 39039 | 869 | 16 |
718064 | 718064 | 2020-11-10 | Delaware | Ohio | 39041 | 3763 | 29 |
718065 | 718065 | 2020-11-10 | Erie | Ohio | 39043 | 1479 | 57 |
718066 | 718066 | 2020-11-10 | Fairfield | Ohio | 39045 | 3698 | 59 |
718067 | 718067 | 2020-11-10 | Fayette | Ohio | 39047 | 634 | 13 |
718068 | 718068 | 2020-11-10 | Franklin | Ohio | 39049 | 39230 | 643 |
718069 | 718069 | 2020-11-10 | Fulton | Ohio | 39051 | 841 | 18 |
718070 | 718070 | 2020-11-10 | Gallia | Ohio | 39053 | 443 | 13 |
718071 | 718071 | 2020-11-10 | Geauga | Ohio | 39055 | 1237 | 51 |
718072 | 718072 | 2020-11-10 | Greene | Ohio | 39057 | 3566 | 51 |
718073 | 718073 | 2020-11-10 | Guernsey | Ohio | 39059 | 566 | 8 |
718074 | 718074 | 2020-11-10 | Hamilton | Ohio | 39061 | 22103 | 353 |
718075 | 718075 | 2020-11-10 | Hancock | Ohio | 39063 | 1622 | 32 |
718076 | 718076 | 2020-11-10 | Hardin | Ohio | 39065 | 539 | 14 |
718077 | 718077 | 2020-11-10 | Harrison | Ohio | 39067 | 123 | 3 |
718078 | 718078 | 2020-11-10 | Henry | Ohio | 39069 | 717 | 18 |
718079 | 718079 | 2020-11-10 | Highland | Ohio | 39071 | 723 | 16 |
718080 | 718080 | 2020-11-10 | Hocking | Ohio | 39073 | 397 | 10 |
718081 | 718081 | 2020-11-10 | Holmes | Ohio | 39075 | 1151 | 26 |
718082 | 718082 | 2020-11-10 | Huron | Ohio | 39077 | 940 | 16 |
718083 | 718083 | 2020-11-10 | Jackson | Ohio | 39079 | 659 | 10 |
718084 | 718084 | 2020-11-10 | Jefferson | Ohio | 39081 | 700 | 4 |
718085 | 718085 | 2020-11-10 | Knox | Ohio | 39083 | 704 | 17 |
718086 | 718086 | 2020-11-10 | Lake | Ohio | 39085 | 3599 | 61 |
718087 | 718087 | 2020-11-10 | Lawrence | Ohio | 39087 | 1324 | 31 |
718088 | 718088 | 2020-11-10 | Licking | Ohio | 39089 | 3694 | 70 |
718089 | 718089 | 2020-11-10 | Logan | Ohio | 39091 | 760 | 6 |
718090 | 718090 | 2020-11-10 | Lorain | Ohio | 39093 | 3866 | 93 |
718091 | 718091 | 2020-11-10 | Lucas | Ohio | 39095 | 10565 | 393 |
718092 | 718092 | 2020-11-10 | Madison | Ohio | 39097 | 1224 | 18 |
718093 | 718093 | 2020-11-10 | Mahoning | Ohio | 39099 | 4834 | 287 |
718094 | 718094 | 2020-11-10 | Marion | Ohio | 39101 | 3844 | 50 |
718095 | 718095 | 2020-11-10 | Medina | Ohio | 39103 | 2859 | 46 |
718096 | 718096 | 2020-11-10 | Meigs | Ohio | 39105 | 271 | 12 |
718097 | 718097 | 2020-11-10 | Mercer | Ohio | 39107 | 2131 | 35 |
718098 | 718098 | 2020-11-10 | Miami | Ohio | 39109 | 2908 | 62 |
718099 | 718099 | 2020-11-10 | Monroe | Ohio | 39111 | 223 | 19 |
718100 | 718100 | 2020-11-10 | Montgomery | Ohio | 39113 | 14491 | 195 |
718101 | 718101 | 2020-11-10 | Morgan | Ohio | 39115 | 136 | 1 |
718102 | 718102 | 2020-11-10 | Morrow | Ohio | 39117 | 598 | 2 |
718103 | 718103 | 2020-11-10 | Muskingum | Ohio | 39119 | 1402 | 6 |
718104 | 718104 | 2020-11-10 | Noble | Ohio | 39121 | 362 | 6 |
718105 | 718105 | 2020-11-10 | Ottawa | Ohio | 39123 | 798 | 30 |
718106 | 718106 | 2020-11-10 | Paulding | Ohio | 39125 | 403 | 7 |
718107 | 718107 | 2020-11-10 | Perry | Ohio | 39127 | 511 | 11 |
718108 | 718108 | 2020-11-10 | Pickaway | Ohio | 39129 | 3507 | 46 |
718109 | 718109 | 2020-11-10 | Pike | Ohio | 39131 | 500 | 1 |
718110 | 718110 | 2020-11-10 | Portage | Ohio | 39133 | 2338 | 68 |
718111 | 718111 | 2020-11-10 | Preble | Ohio | 39135 | 995 | 20 |
718112 | 718112 | 2020-11-10 | Putnam | Ohio | 39137 | 1746 | 33 |
718113 | 718113 | 2020-11-10 | Richland | Ohio | 39139 | 2025 | 26 |
718114 | 718114 | 2020-11-10 | Ross | Ohio | 39141 | 1918 | 53 |
718115 | 718115 | 2020-11-10 | Sandusky | Ohio | 39143 | 1034 | 25 |
718116 | 718116 | 2020-11-10 | Scioto | Ohio | 39145 | 1333 | 10 |
718117 | 718117 | 2020-11-10 | Seneca | Ohio | 39147 | 1055 | 15 |
718118 | 718118 | 2020-11-10 | Shelby | Ohio | 39149 | 1293 | 14 |
718119 | 718119 | 2020-11-10 | Stark | Ohio | 39151 | 5590 | 190 |
718120 | 718120 | 2020-11-10 | Summit | Ohio | 39153 | 9088 | 280 |
718121 | 718121 | 2020-11-10 | Trumbull | Ohio | 39155 | 3234 | 139 |
718122 | 718122 | 2020-11-10 | Tuscarawas | Ohio | 39157 | 2007 | 50 |
718123 | 718123 | 2020-11-10 | Union | Ohio | 39159 | 1223 | 3 |
718124 | 718124 | 2020-11-10 | Van Wert | Ohio | 39161 | 504 | 5 |
718125 | 718125 | 2020-11-10 | Vinton | Ohio | 39163 | 168 | 5 |
718126 | 718126 | 2020-11-10 | Warren | Ohio | 39165 | 5810 | 70 |
718127 | 718127 | 2020-11-10 | Washington | Ohio | 39167 | 650 | 25 |
718128 | 718128 | 2020-11-10 | Wayne | Ohio | 39169 | 2344 | 80 |
718129 | 718129 | 2020-11-10 | Williams | Ohio | 39171 | 633 | 6 |
718130 | 718130 | 2020-11-10 | Wood | Ohio | 39173 | 3264 | 104 |
718131 | 718131 | 2020-11-10 | Wyandot | Ohio | 39175 | 412 | 15 |
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);