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-05-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 |
---|---|---|---|---|---|---|---|
1360769 | 1360769 | 2021-05-27 | Adams | Ohio | 39001 | 2407 | 54 |
1360770 | 1360770 | 2021-05-27 | Allen | Ohio | 39003 | 11817 | 234 |
1360771 | 1360771 | 2021-05-27 | Ashland | Ohio | 39005 | 4322 | 92 |
1360772 | 1360772 | 2021-05-27 | Ashtabula | Ohio | 39007 | 7028 | 176 |
1360773 | 1360773 | 2021-05-27 | Athens | Ohio | 39009 | 5215 | 59 |
1360774 | 1360774 | 2021-05-27 | Auglaize | Ohio | 39011 | 4983 | 87 |
1360775 | 1360775 | 2021-05-27 | Belmont | Ohio | 39013 | 6088 | 171 |
1360776 | 1360776 | 2021-05-27 | Brown | Ohio | 39015 | 3997 | 59 |
1360777 | 1360777 | 2021-05-27 | Butler | Ohio | 39017 | 38728 | 591 |
1360778 | 1360778 | 2021-05-27 | Carroll | Ohio | 39019 | 1938 | 48 |
1360779 | 1360779 | 2021-05-27 | Champaign | Ohio | 39021 | 3405 | 58 |
1360780 | 1360780 | 2021-05-27 | Clark | Ohio | 39023 | 14188 | 302 |
1360781 | 1360781 | 2021-05-27 | Clermont | Ohio | 39025 | 19997 | 247 |
1360782 | 1360782 | 2021-05-27 | Clinton | Ohio | 39027 | 3766 | 64 |
1360783 | 1360783 | 2021-05-27 | Columbiana | Ohio | 39029 | 8959 | 229 |
1360784 | 1360784 | 2021-05-27 | Coshocton | Ohio | 39031 | 2673 | 58 |
1360785 | 1360785 | 2021-05-27 | Crawford | Ohio | 39033 | 4012 | 110 |
1360786 | 1360786 | 2021-05-27 | Cuyahoga | Ohio | 39035 | 114615 | 2158 |
1360787 | 1360787 | 2021-05-27 | Darke | Ohio | 39037 | 5397 | 126 |
1360788 | 1360788 | 2021-05-27 | Defiance | Ohio | 39039 | 4293 | 97 |
1360789 | 1360789 | 2021-05-27 | Delaware | Ohio | 39041 | 18708 | 133 |
1360790 | 1360790 | 2021-05-27 | Erie | Ohio | 39043 | 8021 | 158 |
1360791 | 1360791 | 2021-05-27 | Fairfield | Ohio | 39045 | 16436 | 202 |
1360792 | 1360792 | 2021-05-27 | Fayette | Ohio | 39047 | 2846 | 50 |
1360793 | 1360793 | 2021-05-27 | Franklin | Ohio | 39049 | 127698 | 1425 |
1360794 | 1360794 | 2021-05-27 | Fulton | Ohio | 39051 | 4302 | 71 |
1360795 | 1360795 | 2021-05-27 | Gallia | Ohio | 39053 | 2388 | 50 |
1360796 | 1360796 | 2021-05-27 | Geauga | Ohio | 39055 | 6799 | 149 |
1360797 | 1360797 | 2021-05-27 | Greene | Ohio | 39057 | 15205 | 246 |
1360798 | 1360798 | 2021-05-27 | Guernsey | Ohio | 39059 | 3211 | 53 |
1360799 | 1360799 | 2021-05-27 | Hamilton | Ohio | 39061 | 80850 | 1228 |
1360800 | 1360800 | 2021-05-27 | Hancock | Ohio | 39063 | 6988 | 131 |
1360801 | 1360801 | 2021-05-27 | Hardin | Ohio | 39065 | 2737 | 64 |
1360802 | 1360802 | 2021-05-27 | Harrison | Ohio | 39067 | 1129 | 37 |
1360803 | 1360803 | 2021-05-27 | Henry | Ohio | 39069 | 2720 | 67 |
1360804 | 1360804 | 2021-05-27 | Highland | Ohio | 39071 | 3575 | 62 |
1360805 | 1360805 | 2021-05-27 | Hocking | Ohio | 39073 | 2186 | 62 |
1360806 | 1360806 | 2021-05-27 | Holmes | Ohio | 39075 | 2660 | 101 |
1360807 | 1360807 | 2021-05-27 | Huron | Ohio | 39077 | 5494 | 120 |
1360808 | 1360808 | 2021-05-27 | Jackson | Ohio | 39079 | 3157 | 53 |
1360809 | 1360809 | 2021-05-27 | Jefferson | Ohio | 39081 | 5634 | 155 |
1360810 | 1360810 | 2021-05-27 | Knox | Ohio | 39083 | 4548 | 111 |
1360811 | 1360811 | 2021-05-27 | Lake | Ohio | 39085 | 21023 | 374 |
1360812 | 1360812 | 2021-05-27 | Lawrence | Ohio | 39087 | 5660 | 102 |
1360813 | 1360813 | 2021-05-27 | Licking | Ohio | 39089 | 16574 | 214 |
1360814 | 1360814 | 2021-05-27 | Logan | Ohio | 39091 | 3861 | 76 |
1360815 | 1360815 | 2021-05-27 | Lorain | Ohio | 39093 | 25462 | 490 |
1360816 | 1360816 | 2021-05-27 | Lucas | Ohio | 39095 | 43018 | 794 |
1360817 | 1360817 | 2021-05-27 | Madison | Ohio | 39097 | 4417 | 63 |
1360818 | 1360818 | 2021-05-27 | Mahoning | Ohio | 39099 | 22112 | 592 |
1360819 | 1360819 | 2021-05-27 | Marion | Ohio | 39101 | 8609 | 137 |
1360820 | 1360820 | 2021-05-27 | Medina | Ohio | 39103 | 15508 | 268 |
1360821 | 1360821 | 2021-05-27 | Meigs | Ohio | 39105 | 1473 | 40 |
1360822 | 1360822 | 2021-05-27 | Mercer | Ohio | 39107 | 4841 | 85 |
1360823 | 1360823 | 2021-05-27 | Miami | Ohio | 39109 | 10779 | 221 |
1360824 | 1360824 | 2021-05-27 | Monroe | Ohio | 39111 | 1342 | 43 |
1360825 | 1360825 | 2021-05-27 | Montgomery | Ohio | 39113 | 52168 | 1025 |
1360826 | 1360826 | 2021-05-27 | Morgan | Ohio | 39115 | 1091 | 24 |
1360827 | 1360827 | 2021-05-27 | Morrow | Ohio | 39117 | 2901 | 39 |
1360828 | 1360828 | 2021-05-27 | Muskingum | Ohio | 39119 | 8866 | 134 |
1360829 | 1360829 | 2021-05-27 | Noble | Ohio | 39121 | 1349 | 38 |
1360830 | 1360830 | 2021-05-27 | Ottawa | Ohio | 39123 | 3715 | 81 |
1360831 | 1360831 | 2021-05-27 | Paulding | Ohio | 39125 | 1755 | 41 |
1360832 | 1360832 | 2021-05-27 | Perry | Ohio | 39127 | 2964 | 50 |
1360833 | 1360833 | 2021-05-27 | Pickaway | Ohio | 39129 | 8622 | 121 |
1360834 | 1360834 | 2021-05-27 | Pike | Ohio | 39131 | 2409 | 34 |
1360835 | 1360835 | 2021-05-27 | Portage | Ohio | 39133 | 13124 | 211 |
1360836 | 1360836 | 2021-05-27 | Preble | Ohio | 39135 | 3833 | 101 |
1360837 | 1360837 | 2021-05-27 | Putnam | Ohio | 39137 | 4326 | 102 |
1360838 | 1360838 | 2021-05-27 | Richland | Ohio | 39139 | 11528 | 208 |
1360839 | 1360839 | 2021-05-27 | Ross | Ohio | 39141 | 6903 | 158 |
1360840 | 1360840 | 2021-05-27 | Sandusky | Ohio | 39143 | 5425 | 123 |
1360841 | 1360841 | 2021-05-27 | Scioto | Ohio | 39145 | 6494 | 103 |
1360842 | 1360842 | 2021-05-27 | Seneca | Ohio | 39147 | 5333 | 123 |
1360843 | 1360843 | 2021-05-27 | Shelby | Ohio | 39149 | 4725 | 93 |
1360844 | 1360844 | 2021-05-27 | Stark | Ohio | 39151 | 33037 | 915 |
1360845 | 1360845 | 2021-05-27 | Summit | Ohio | 39153 | 48037 | 979 |
1360846 | 1360846 | 2021-05-27 | Trumbull | Ohio | 39155 | 16371 | 473 |
1360847 | 1360847 | 2021-05-27 | Tuscarawas | Ohio | 39157 | 8564 | 245 |
1360848 | 1360848 | 2021-05-27 | Union | Ohio | 39159 | 5810 | 49 |
1360849 | 1360849 | 2021-05-27 | Unknown | Ohio | 0 | 2 | |
1360850 | 1360850 | 2021-05-27 | Van Wert | Ohio | 39161 | 2461 | 64 |
1360851 | 1360851 | 2021-05-27 | Vinton | Ohio | 39163 | 851 | 16 |
1360852 | 1360852 | 2021-05-27 | Warren | Ohio | 39165 | 24506 | 303 |
1360853 | 1360853 | 2021-05-27 | Washington | Ohio | 39167 | 5270 | 109 |
1360854 | 1360854 | 2021-05-27 | Wayne | Ohio | 39169 | 9042 | 217 |
1360855 | 1360855 | 2021-05-27 | Williams | Ohio | 39171 | 3452 | 77 |
1360856 | 1360856 | 2021-05-27 | Wood | Ohio | 39173 | 13243 | 192 |
1360857 | 1360857 | 2021-05-27 | Wyandot | Ohio | 39175 | 2338 | 56 |
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);