ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where "date" is on date 2021-07-27 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 · 89 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1558783 | 1558783 | 2021-07-27 | Adams | Ohio | 39001 | 2498 | 58 |
1558784 | 1558784 | 2021-07-27 | Allen | Ohio | 39003 | 12049 | 245 |
1558785 | 1558785 | 2021-07-27 | Ashland | Ohio | 39005 | 4448 | 98 |
1558786 | 1558786 | 2021-07-27 | Ashtabula | Ohio | 39007 | 7281 | 179 |
1558787 | 1558787 | 2021-07-27 | Athens | Ohio | 39009 | 5269 | 60 |
1558788 | 1558788 | 2021-07-27 | Auglaize | Ohio | 39011 | 5074 | 87 |
1558789 | 1558789 | 2021-07-27 | Belmont | Ohio | 39013 | 6222 | 179 |
1558790 | 1558790 | 2021-07-27 | Brown | Ohio | 39015 | 4096 | 62 |
1558791 | 1558791 | 2021-07-27 | Butler | Ohio | 39017 | 40000 | 614 |
1558792 | 1558792 | 2021-07-27 | Carroll | Ohio | 39019 | 2012 | 49 |
1558793 | 1558793 | 2021-07-27 | Champaign | Ohio | 39021 | 3496 | 60 |
1558794 | 1558794 | 2021-07-27 | Clark | Ohio | 39023 | 14352 | 308 |
1558795 | 1558795 | 2021-07-27 | Clermont | Ohio | 39025 | 20391 | 261 |
1558796 | 1558796 | 2021-07-27 | Clinton | Ohio | 39027 | 3907 | 66 |
1558797 | 1558797 | 2021-07-27 | Columbiana | Ohio | 39029 | 9204 | 236 |
1558798 | 1558798 | 2021-07-27 | Coshocton | Ohio | 39031 | 2729 | 61 |
1558799 | 1558799 | 2021-07-27 | Crawford | Ohio | 39033 | 4114 | 111 |
1558800 | 1558800 | 2021-07-27 | Cuyahoga | Ohio | 39035 | 117254 | 2263 |
1558801 | 1558801 | 2021-07-27 | Darke | Ohio | 39037 | 5444 | 131 |
1558802 | 1558802 | 2021-07-27 | Defiance | Ohio | 39039 | 4387 | 99 |
1558803 | 1558803 | 2021-07-27 | Delaware | Ohio | 39041 | 19143 | 138 |
1558804 | 1558804 | 2021-07-27 | Erie | Ohio | 39043 | 8135 | 166 |
1558805 | 1558805 | 2021-07-27 | Fairfield | Ohio | 39045 | 16793 | 207 |
1558806 | 1558806 | 2021-07-27 | Fayette | Ohio | 39047 | 2891 | 50 |
1558807 | 1558807 | 2021-07-27 | Franklin | Ohio | 39049 | 130433 | 1493 |
1558808 | 1558808 | 2021-07-27 | Fulton | Ohio | 39051 | 4363 | 75 |
1558809 | 1558809 | 2021-07-27 | Gallia | Ohio | 39053 | 2498 | 50 |
1558810 | 1558810 | 2021-07-27 | Geauga | Ohio | 39055 | 6962 | 153 |
1558811 | 1558811 | 2021-07-27 | Greene | Ohio | 39057 | 15528 | 254 |
1558812 | 1558812 | 2021-07-27 | Guernsey | Ohio | 39059 | 3305 | 54 |
1558813 | 1558813 | 2021-07-27 | Hamilton | Ohio | 39061 | 82442 | 1261 |
1558814 | 1558814 | 2021-07-27 | Hancock | Ohio | 39063 | 7048 | 135 |
1558815 | 1558815 | 2021-07-27 | Hardin | Ohio | 39065 | 2793 | 65 |
1558816 | 1558816 | 2021-07-27 | Harrison | Ohio | 39067 | 1152 | 38 |
1558817 | 1558817 | 2021-07-27 | Henry | Ohio | 39069 | 2771 | 67 |
1558818 | 1558818 | 2021-07-27 | Highland | Ohio | 39071 | 3660 | 68 |
1558819 | 1558819 | 2021-07-27 | Hocking | Ohio | 39073 | 2229 | 63 |
1558820 | 1558820 | 2021-07-27 | Holmes | Ohio | 39075 | 2725 | 102 |
1558821 | 1558821 | 2021-07-27 | Huron | Ohio | 39077 | 5638 | 122 |
1558822 | 1558822 | 2021-07-27 | Jackson | Ohio | 39079 | 3213 | 54 |
1558823 | 1558823 | 2021-07-27 | Jefferson | Ohio | 39081 | 5725 | 162 |
1558824 | 1558824 | 2021-07-27 | Knox | Ohio | 39083 | 4614 | 113 |
1558825 | 1558825 | 2021-07-27 | Lake | Ohio | 39085 | 21472 | 396 |
1558826 | 1558826 | 2021-07-27 | Lawrence | Ohio | 39087 | 5947 | 104 |
1558827 | 1558827 | 2021-07-27 | Licking | Ohio | 39089 | 16863 | 227 |
1558828 | 1558828 | 2021-07-27 | Logan | Ohio | 39091 | 3921 | 79 |
1558829 | 1558829 | 2021-07-27 | Lorain | Ohio | 39093 | 26029 | 510 |
1558830 | 1558830 | 2021-07-27 | Lucas | Ohio | 39095 | 43747 | 834 |
1558831 | 1558831 | 2021-07-27 | Madison | Ohio | 39097 | 4475 | 66 |
1558832 | 1558832 | 2021-07-27 | Mahoning | Ohio | 39099 | 22710 | 613 |
1558833 | 1558833 | 2021-07-27 | Marion | Ohio | 39101 | 8710 | 140 |
1558834 | 1558834 | 2021-07-27 | Medina | Ohio | 39103 | 15861 | 276 |
1558835 | 1558835 | 2021-07-27 | Meigs | Ohio | 39105 | 1512 | 40 |
1558836 | 1558836 | 2021-07-27 | Mercer | Ohio | 39107 | 4911 | 85 |
1558837 | 1558837 | 2021-07-27 | Miami | Ohio | 39109 | 11019 | 228 |
1558838 | 1558838 | 2021-07-27 | Monroe | Ohio | 39111 | 1379 | 45 |
1558839 | 1558839 | 2021-07-27 | Montgomery | Ohio | 39113 | 53542 | 1062 |
1558840 | 1558840 | 2021-07-27 | Morgan | Ohio | 39115 | 1116 | 24 |
1558841 | 1558841 | 2021-07-27 | Morrow | Ohio | 39117 | 2947 | 43 |
1558842 | 1558842 | 2021-07-27 | Muskingum | Ohio | 39119 | 9133 | 137 |
1558843 | 1558843 | 2021-07-27 | Noble | Ohio | 39121 | 1377 | 39 |
1558844 | 1558844 | 2021-07-27 | Ottawa | Ohio | 39123 | 3758 | 81 |
1558845 | 1558845 | 2021-07-27 | Paulding | Ohio | 39125 | 1799 | 42 |
1558846 | 1558846 | 2021-07-27 | Perry | Ohio | 39127 | 2988 | 50 |
1558847 | 1558847 | 2021-07-27 | Pickaway | Ohio | 39129 | 8750 | 123 |
1558848 | 1558848 | 2021-07-27 | Pike | Ohio | 39131 | 2447 | 37 |
1558849 | 1558849 | 2021-07-27 | Portage | Ohio | 39133 | 13432 | 218 |
1558850 | 1558850 | 2021-07-27 | Preble | Ohio | 39135 | 3949 | 107 |
1558851 | 1558851 | 2021-07-27 | Putnam | Ohio | 39137 | 4354 | 104 |
1558852 | 1558852 | 2021-07-27 | Richland | Ohio | 39139 | 11740 | 213 |
1558853 | 1558853 | 2021-07-27 | Ross | Ohio | 39141 | 7024 | 165 |
1558854 | 1558854 | 2021-07-27 | Sandusky | Ohio | 39143 | 5488 | 130 |
1558855 | 1558855 | 2021-07-27 | Scioto | Ohio | 39145 | 6701 | 108 |
1558856 | 1558856 | 2021-07-27 | Seneca | Ohio | 39147 | 5377 | 128 |
1558857 | 1558857 | 2021-07-27 | Shelby | Ohio | 39149 | 4827 | 97 |
1558858 | 1558858 | 2021-07-27 | Stark | Ohio | 39151 | 33837 | 939 |
1558859 | 1558859 | 2021-07-27 | Summit | Ohio | 39153 | 48902 | 1014 |
1558860 | 1558860 | 2021-07-27 | Trumbull | Ohio | 39155 | 16801 | 492 |
1558861 | 1558861 | 2021-07-27 | Tuscarawas | Ohio | 39157 | 8718 | 255 |
1558862 | 1558862 | 2021-07-27 | Union | Ohio | 39159 | 5909 | 49 |
1558863 | 1558863 | 2021-07-27 | Unknown | Ohio | 0 | 4 | |
1558864 | 1558864 | 2021-07-27 | Van Wert | Ohio | 39161 | 2522 | 65 |
1558865 | 1558865 | 2021-07-27 | Vinton | Ohio | 39163 | 873 | 17 |
1558866 | 1558866 | 2021-07-27 | Warren | Ohio | 39165 | 24919 | 312 |
1558867 | 1558867 | 2021-07-27 | Washington | Ohio | 39167 | 5371 | 111 |
1558868 | 1558868 | 2021-07-27 | Wayne | Ohio | 39169 | 9258 | 228 |
1558869 | 1558869 | 2021-07-27 | Williams | Ohio | 39171 | 3566 | 78 |
1558870 | 1558870 | 2021-07-27 | Wood | Ohio | 39173 | 13343 | 201 |
1558871 | 1558871 | 2021-07-27 | Wyandot | Ohio | 39175 | 2352 | 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);