ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where date = "2021-08-24" 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 |
---|---|---|---|---|---|---|---|
1649742 | 1649742 | 2021-08-24 | Adams | Ohio | 39001 | 2748 | 60 |
1649743 | 1649743 | 2021-08-24 | Allen | Ohio | 39003 | 12579 | 245 |
1649744 | 1649744 | 2021-08-24 | Ashland | Ohio | 39005 | 4841 | 103 |
1649745 | 1649745 | 2021-08-24 | Ashtabula | Ohio | 39007 | 7501 | 182 |
1649746 | 1649746 | 2021-08-24 | Athens | Ohio | 39009 | 5515 | 60 |
1649747 | 1649747 | 2021-08-24 | Auglaize | Ohio | 39011 | 5303 | 87 |
1649748 | 1649748 | 2021-08-24 | Belmont | Ohio | 39013 | 6693 | 181 |
1649749 | 1649749 | 2021-08-24 | Brown | Ohio | 39015 | 4460 | 65 |
1649750 | 1649750 | 2021-08-24 | Butler | Ohio | 39017 | 41925 | 625 |
1649751 | 1649751 | 2021-08-24 | Carroll | Ohio | 39019 | 2159 | 49 |
1649752 | 1649752 | 2021-08-24 | Champaign | Ohio | 39021 | 3715 | 60 |
1649753 | 1649753 | 2021-08-24 | Clark | Ohio | 39023 | 15120 | 315 |
1649754 | 1649754 | 2021-08-24 | Clermont | Ohio | 39025 | 21880 | 266 |
1649755 | 1649755 | 2021-08-24 | Clinton | Ohio | 39027 | 4303 | 69 |
1649756 | 1649756 | 2021-08-24 | Columbiana | Ohio | 39029 | 9849 | 236 |
1649757 | 1649757 | 2021-08-24 | Coshocton | Ohio | 39031 | 2900 | 63 |
1649758 | 1649758 | 2021-08-24 | Crawford | Ohio | 39033 | 4476 | 112 |
1649759 | 1649759 | 2021-08-24 | Cuyahoga | Ohio | 39035 | 122407 | 2280 |
1649760 | 1649760 | 2021-08-24 | Darke | Ohio | 39037 | 5702 | 131 |
1649761 | 1649761 | 2021-08-24 | Defiance | Ohio | 39039 | 4728 | 100 |
1649762 | 1649762 | 2021-08-24 | Delaware | Ohio | 39041 | 20088 | 138 |
1649763 | 1649763 | 2021-08-24 | Erie | Ohio | 39043 | 8648 | 168 |
1649764 | 1649764 | 2021-08-24 | Fairfield | Ohio | 39045 | 17692 | 211 |
1649765 | 1649765 | 2021-08-24 | Fayette | Ohio | 39047 | 3057 | 50 |
1649766 | 1649766 | 2021-08-24 | Franklin | Ohio | 39049 | 136889 | 1508 |
1649767 | 1649767 | 2021-08-24 | Fulton | Ohio | 39051 | 4652 | 78 |
1649768 | 1649768 | 2021-08-24 | Gallia | Ohio | 39053 | 2781 | 51 |
1649769 | 1649769 | 2021-08-24 | Geauga | Ohio | 39055 | 7336 | 155 |
1649770 | 1649770 | 2021-08-24 | Greene | Ohio | 39057 | 16879 | 255 |
1649771 | 1649771 | 2021-08-24 | Guernsey | Ohio | 39059 | 3582 | 54 |
1649772 | 1649772 | 2021-08-24 | Hamilton | Ohio | 39061 | 86970 | 1278 |
1649773 | 1649773 | 2021-08-24 | Hancock | Ohio | 39063 | 7339 | 138 |
1649774 | 1649774 | 2021-08-24 | Hardin | Ohio | 39065 | 2931 | 66 |
1649775 | 1649775 | 2021-08-24 | Harrison | Ohio | 39067 | 1226 | 38 |
1649776 | 1649776 | 2021-08-24 | Henry | Ohio | 39069 | 2881 | 67 |
1649777 | 1649777 | 2021-08-24 | Highland | Ohio | 39071 | 4060 | 70 |
1649778 | 1649778 | 2021-08-24 | Hocking | Ohio | 39073 | 2406 | 63 |
1649779 | 1649779 | 2021-08-24 | Holmes | Ohio | 39075 | 2874 | 103 |
1649780 | 1649780 | 2021-08-24 | Huron | Ohio | 39077 | 6102 | 123 |
1649781 | 1649781 | 2021-08-24 | Jackson | Ohio | 39079 | 3413 | 55 |
1649782 | 1649782 | 2021-08-24 | Jefferson | Ohio | 39081 | 6101 | 163 |
1649783 | 1649783 | 2021-08-24 | Knox | Ohio | 39083 | 5142 | 116 |
1649784 | 1649784 | 2021-08-24 | Lake | Ohio | 39085 | 22459 | 401 |
1649785 | 1649785 | 2021-08-24 | Lawrence | Ohio | 39087 | 6579 | 111 |
1649786 | 1649786 | 2021-08-24 | Licking | Ohio | 39089 | 17812 | 228 |
1649787 | 1649787 | 2021-08-24 | Logan | Ohio | 39091 | 4261 | 79 |
1649788 | 1649788 | 2021-08-24 | Lorain | Ohio | 39093 | 27479 | 516 |
1649789 | 1649789 | 2021-08-24 | Lucas | Ohio | 39095 | 45601 | 839 |
1649790 | 1649790 | 2021-08-24 | Madison | Ohio | 39097 | 4703 | 65 |
1649791 | 1649791 | 2021-08-24 | Mahoning | Ohio | 39099 | 23789 | 617 |
1649792 | 1649792 | 2021-08-24 | Marion | Ohio | 39101 | 9248 | 140 |
1649793 | 1649793 | 2021-08-24 | Medina | Ohio | 39103 | 16894 | 280 |
1649794 | 1649794 | 2021-08-24 | Meigs | Ohio | 39105 | 1634 | 40 |
1649795 | 1649795 | 2021-08-24 | Mercer | Ohio | 39107 | 5090 | 86 |
1649796 | 1649796 | 2021-08-24 | Miami | Ohio | 39109 | 11845 | 235 |
1649797 | 1649797 | 2021-08-24 | Monroe | Ohio | 39111 | 1476 | 46 |
1649798 | 1649798 | 2021-08-24 | Montgomery | Ohio | 39113 | 57637 | 1078 |
1649799 | 1649799 | 2021-08-24 | Morgan | Ohio | 39115 | 1185 | 25 |
1649800 | 1649800 | 2021-08-24 | Morrow | Ohio | 39117 | 3165 | 47 |
1649801 | 1649801 | 2021-08-24 | Muskingum | Ohio | 39119 | 9817 | 139 |
1649802 | 1649802 | 2021-08-24 | Noble | Ohio | 39121 | 1432 | 40 |
1649803 | 1649803 | 2021-08-24 | Ottawa | Ohio | 39123 | 3922 | 82 |
1649804 | 1649804 | 2021-08-24 | Paulding | Ohio | 39125 | 1956 | 42 |
1649805 | 1649805 | 2021-08-24 | Perry | Ohio | 39127 | 3209 | 50 |
1649806 | 1649806 | 2021-08-24 | Pickaway | Ohio | 39129 | 9188 | 123 |
1649807 | 1649807 | 2021-08-24 | Pike | Ohio | 39131 | 2705 | 38 |
1649808 | 1649808 | 2021-08-24 | Portage | Ohio | 39133 | 14151 | 219 |
1649809 | 1649809 | 2021-08-24 | Preble | Ohio | 39135 | 4179 | 108 |
1649810 | 1649810 | 2021-08-24 | Putnam | Ohio | 39137 | 4482 | 105 |
1649811 | 1649811 | 2021-08-24 | Richland | Ohio | 39139 | 12887 | 216 |
1649812 | 1649812 | 2021-08-24 | Ross | Ohio | 39141 | 7534 | 166 |
1649813 | 1649813 | 2021-08-24 | Sandusky | Ohio | 39143 | 5874 | 131 |
1649814 | 1649814 | 2021-08-24 | Scioto | Ohio | 39145 | 7839 | 110 |
1649815 | 1649815 | 2021-08-24 | Seneca | Ohio | 39147 | 5563 | 130 |
1649816 | 1649816 | 2021-08-24 | Shelby | Ohio | 39149 | 5122 | 98 |
1649817 | 1649817 | 2021-08-24 | Stark | Ohio | 39151 | 35648 | 948 |
1649818 | 1649818 | 2021-08-24 | Summit | Ohio | 39153 | 51025 | 1027 |
1649819 | 1649819 | 2021-08-24 | Trumbull | Ohio | 39155 | 17635 | 494 |
1649820 | 1649820 | 2021-08-24 | Tuscarawas | Ohio | 39157 | 9141 | 260 |
1649821 | 1649821 | 2021-08-24 | Union | Ohio | 39159 | 6223 | 49 |
1649822 | 1649822 | 2021-08-24 | Unknown | Ohio | 0 | 5 | |
1649823 | 1649823 | 2021-08-24 | Van Wert | Ohio | 39161 | 2706 | 67 |
1649824 | 1649824 | 2021-08-24 | Vinton | Ohio | 39163 | 972 | 17 |
1649825 | 1649825 | 2021-08-24 | Warren | Ohio | 39165 | 26273 | 314 |
1649826 | 1649826 | 2021-08-24 | Washington | Ohio | 39167 | 5631 | 111 |
1649827 | 1649827 | 2021-08-24 | Wayne | Ohio | 39169 | 9935 | 230 |
1649828 | 1649828 | 2021-08-24 | Williams | Ohio | 39171 | 3840 | 79 |
1649829 | 1649829 | 2021-08-24 | Wood | Ohio | 39173 | 13832 | 204 |
1649830 | 1649830 | 2021-08-24 | Wyandot | Ohio | 39175 | 2447 | 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);