ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-08-08" 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 |
---|---|---|---|---|---|---|---|
413719 | 413719 | 2020-08-08 | Adams | Ohio | 39001 | 59 | 2 |
413720 | 413720 | 2020-08-08 | Allen | Ohio | 39003 | 732 | 44 |
413721 | 413721 | 2020-08-08 | Ashland | Ohio | 39005 | 143 | 3 |
413722 | 413722 | 2020-08-08 | Ashtabula | Ohio | 39007 | 562 | 46 |
413723 | 413723 | 2020-08-08 | Athens | Ohio | 39009 | 356 | 1 |
413724 | 413724 | 2020-08-08 | Auglaize | Ohio | 39011 | 250 | 6 |
413725 | 413725 | 2020-08-08 | Belmont | Ohio | 39013 | 621 | 26 |
413726 | 413726 | 2020-08-08 | Brown | Ohio | 39015 | 127 | 2 |
413727 | 413727 | 2020-08-08 | Butler | Ohio | 39017 | 2891 | 63 |
413728 | 413728 | 2020-08-08 | Carroll | Ohio | 39019 | 111 | 5 |
413729 | 413729 | 2020-08-08 | Champaign | Ohio | 39021 | 173 | 2 |
413730 | 413730 | 2020-08-08 | Clark | Ohio | 39023 | 1142 | 14 |
413731 | 413731 | 2020-08-08 | Clermont | Ohio | 39025 | 921 | 11 |
413732 | 413732 | 2020-08-08 | Clinton | Ohio | 39027 | 162 | 6 |
413733 | 413733 | 2020-08-08 | Columbiana | Ohio | 39029 | 1656 | 60 |
413734 | 413734 | 2020-08-08 | Coshocton | Ohio | 39031 | 192 | 6 |
413735 | 413735 | 2020-08-08 | Crawford | Ohio | 39033 | 174 | 5 |
413736 | 413736 | 2020-08-08 | Cuyahoga | Ohio | 39035 | 13414 | 499 |
413737 | 413737 | 2020-08-08 | Darke | Ohio | 39037 | 393 | 29 |
413738 | 413738 | 2020-08-08 | Defiance | Ohio | 39039 | 142 | 4 |
413739 | 413739 | 2020-08-08 | Delaware | Ohio | 39041 | 1292 | 19 |
413740 | 413740 | 2020-08-08 | Erie | Ohio | 39043 | 570 | 27 |
413741 | 413741 | 2020-08-08 | Fairfield | Ohio | 39045 | 1367 | 32 |
413742 | 413742 | 2020-08-08 | Fayette | Ohio | 39047 | 112 | 0 |
413743 | 413743 | 2020-08-08 | Franklin | Ohio | 39049 | 18182 | 523 |
413744 | 413744 | 2020-08-08 | Fulton | Ohio | 39051 | 147 | 1 |
413745 | 413745 | 2020-08-08 | Gallia | Ohio | 39053 | 65 | 1 |
413746 | 413746 | 2020-08-08 | Geauga | Ohio | 39055 | 554 | 44 |
413747 | 413747 | 2020-08-08 | Greene | Ohio | 39057 | 684 | 12 |
413748 | 413748 | 2020-08-08 | Guernsey | Ohio | 39059 | 116 | 7 |
413749 | 413749 | 2020-08-08 | Hamilton | Ohio | 39061 | 9583 | 255 |
413750 | 413750 | 2020-08-08 | Hancock | Ohio | 39063 | 372 | 3 |
413751 | 413751 | 2020-08-08 | Hardin | Ohio | 39065 | 164 | 12 |
413752 | 413752 | 2020-08-08 | Harrison | Ohio | 39067 | 26 | 1 |
413753 | 413753 | 2020-08-08 | Henry | Ohio | 39069 | 116 | 2 |
413754 | 413754 | 2020-08-08 | Highland | Ohio | 39071 | 156 | 1 |
413755 | 413755 | 2020-08-08 | Hocking | Ohio | 39073 | 116 | 9 |
413756 | 413756 | 2020-08-08 | Holmes | Ohio | 39075 | 327 | 6 |
413757 | 413757 | 2020-08-08 | Huron | Ohio | 39077 | 395 | 5 |
413758 | 413758 | 2020-08-08 | Jackson | Ohio | 39079 | 74 | 0 |
413759 | 413759 | 2020-08-08 | Jefferson | Ohio | 39081 | 224 | 2 |
413760 | 413760 | 2020-08-08 | Knox | Ohio | 39083 | 203 | 7 |
413761 | 413761 | 2020-08-08 | Lake | Ohio | 39085 | 1111 | 38 |
413762 | 413762 | 2020-08-08 | Lawrence | Ohio | 39087 | 279 | 0 |
413763 | 413763 | 2020-08-08 | Licking | Ohio | 39089 | 1260 | 49 |
413764 | 413764 | 2020-08-08 | Logan | Ohio | 39091 | 152 | 2 |
413765 | 413765 | 2020-08-08 | Lorain | Ohio | 39093 | 1736 | 78 |
413766 | 413766 | 2020-08-08 | Lucas | Ohio | 39095 | 5288 | 323 |
413767 | 413767 | 2020-08-08 | Madison | Ohio | 39097 | 355 | 10 |
413768 | 413768 | 2020-08-08 | Mahoning | Ohio | 39099 | 2532 | 255 |
413769 | 413769 | 2020-08-08 | Marion | Ohio | 39101 | 2922 | 45 |
413770 | 413770 | 2020-08-08 | Medina | Ohio | 39103 | 914 | 35 |
413771 | 413771 | 2020-08-08 | Meigs | Ohio | 39105 | 38 | 0 |
413772 | 413772 | 2020-08-08 | Mercer | Ohio | 39107 | 605 | 13 |
413773 | 413773 | 2020-08-08 | Miami | Ohio | 39109 | 832 | 38 |
413774 | 413774 | 2020-08-08 | Monroe | Ohio | 39111 | 91 | 18 |
413775 | 413775 | 2020-08-08 | Montgomery | Ohio | 39113 | 4318 | 94 |
413776 | 413776 | 2020-08-08 | Morgan | Ohio | 39115 | 25 | 0 |
413777 | 413777 | 2020-08-08 | Morrow | Ohio | 39117 | 168 | 2 |
413778 | 413778 | 2020-08-08 | Muskingum | Ohio | 39119 | 225 | 1 |
413779 | 413779 | 2020-08-08 | Noble | Ohio | 39121 | 17 | 0 |
413780 | 413780 | 2020-08-08 | Ottawa | Ohio | 39123 | 377 | 26 |
413781 | 413781 | 2020-08-08 | Paulding | Ohio | 39125 | 67 | 0 |
413782 | 413782 | 2020-08-08 | Perry | Ohio | 39127 | 123 | 3 |
413783 | 413783 | 2020-08-08 | Pickaway | Ohio | 39129 | 2383 | 42 |
413784 | 413784 | 2020-08-08 | Pike | Ohio | 39131 | 76 | 0 |
413785 | 413785 | 2020-08-08 | Portage | Ohio | 39133 | 754 | 61 |
413786 | 413786 | 2020-08-08 | Preble | Ohio | 39135 | 201 | 2 |
413787 | 413787 | 2020-08-08 | Putnam | Ohio | 39137 | 205 | 17 |
413788 | 413788 | 2020-08-08 | Richland | Ohio | 39139 | 600 | 12 |
413789 | 413789 | 2020-08-08 | Ross | Ohio | 39141 | 468 | 4 |
413790 | 413790 | 2020-08-08 | Sandusky | Ohio | 39143 | 373 | 16 |
413791 | 413791 | 2020-08-08 | Scioto | Ohio | 39145 | 224 | 1 |
413792 | 413792 | 2020-08-08 | Seneca | Ohio | 39147 | 204 | 3 |
413793 | 413793 | 2020-08-08 | Shelby | Ohio | 39149 | 190 | 4 |
413794 | 413794 | 2020-08-08 | Stark | Ohio | 39151 | 1813 | 139 |
413795 | 413795 | 2020-08-08 | Summit | Ohio | 39153 | 3523 | 222 |
413796 | 413796 | 2020-08-08 | Trumbull | Ohio | 39155 | 1518 | 106 |
413797 | 413797 | 2020-08-08 | Tuscarawas | Ohio | 39157 | 781 | 14 |
413798 | 413798 | 2020-08-08 | Union | Ohio | 39159 | 246 | 1 |
413799 | 413799 | 2020-08-08 | Van Wert | Ohio | 39161 | 71 | 1 |
413800 | 413800 | 2020-08-08 | Vinton | Ohio | 39163 | 31 | 2 |
413801 | 413801 | 2020-08-08 | Warren | Ohio | 39165 | 1767 | 39 |
413802 | 413802 | 2020-08-08 | Washington | Ohio | 39167 | 202 | 22 |
413803 | 413803 | 2020-08-08 | Wayne | Ohio | 39169 | 529 | 58 |
413804 | 413804 | 2020-08-08 | Williams | Ohio | 39171 | 134 | 3 |
413805 | 413805 | 2020-08-08 | Wood | Ohio | 39173 | 1030 | 58 |
413806 | 413806 | 2020-08-08 | Wyandot | Ohio | 39175 | 145 | 8 |
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);