ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69,101 rows where state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 39035 409
- 39151 407
- 39155 406
- 39013 404
- 39017 404
- 39049 404
- 39093 404
- 39153 404
- 39157 404
- 39095 403
- 39103 403
- 39055 402
- 39031 401
- 39037 401
- 39085 401
- 39099 401
- 39005 400
- 39023 400
- 39041 400
- 39077 400
- 39109 400
- 39061 399
- 39113 399
- 39139 399
- 39007 398
- 39029 398
- 39101 398
- 39159 398
- 39165 398
- 39025 397
- …
county >30
- Cuyahoga 409
- Stark 407
- Trumbull 406
- Belmont 404
- Butler 404
- Franklin 404
- Lorain 404
- Summit 404
- Tuscarawas 404
- Lucas 403
- Medina 403
- Geauga 402
- Coshocton 401
- Darke 401
- Lake 401
- Mahoning 401
- Ashland 400
- Clark 400
- Delaware 400
- Huron 400
- Miami 400
- Hamilton 399
- Montgomery 399
- Richland 399
- Ashtabula 398
- Columbiana 398
- Marion 398
- Union 398
- Warren 398
- Clermont 397
- …
state 1
- Ohio · 34,658 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1243887 | 1243887 | 2021-04-21 | Adams | Ohio | 39001 | 2302 | 52 |
1243888 | 1243888 | 2021-04-21 | Allen | Ohio | 39003 | 11374 | 229 |
1243889 | 1243889 | 2021-04-21 | Ashland | Ohio | 39005 | 4144 | 88 |
1243890 | 1243890 | 2021-04-21 | Ashtabula | Ohio | 39007 | 6563 | 166 |
1243891 | 1243891 | 2021-04-21 | Athens | Ohio | 39009 | 5092 | 56 |
1243892 | 1243892 | 2021-04-21 | Auglaize | Ohio | 39011 | 4776 | 83 |
1243893 | 1243893 | 2021-04-21 | Belmont | Ohio | 39013 | 5657 | 159 |
1243894 | 1243894 | 2021-04-21 | Brown | Ohio | 39015 | 3877 | 55 |
1243895 | 1243895 | 2021-04-21 | Butler | Ohio | 39017 | 37858 | 572 |
1243896 | 1243896 | 2021-04-21 | Carroll | Ohio | 39019 | 1897 | 47 |
1243897 | 1243897 | 2021-04-21 | Champaign | Ohio | 39021 | 3223 | 57 |
1243898 | 1243898 | 2021-04-21 | Clark | Ohio | 39023 | 13697 | 293 |
1243899 | 1243899 | 2021-04-21 | Clermont | Ohio | 39025 | 19480 | 229 |
1243900 | 1243900 | 2021-04-21 | Clinton | Ohio | 39027 | 3640 | 60 |
1243901 | 1243901 | 2021-04-21 | Columbiana | Ohio | 39029 | 8589 | 226 |
1243902 | 1243902 | 2021-04-21 | Coshocton | Ohio | 39031 | 2610 | 58 |
1243903 | 1243903 | 2021-04-21 | Crawford | Ohio | 39033 | 3894 | 102 |
1243904 | 1243904 | 2021-04-21 | Cuyahoga | Ohio | 39035 | 108004 | 2072 |
1243905 | 1243905 | 2021-04-21 | Darke | Ohio | 39037 | 5285 | 121 |
1243906 | 1243906 | 2021-04-21 | Defiance | Ohio | 39039 | 4055 | 96 |
1243907 | 1243907 | 2021-04-21 | Delaware | Ohio | 39041 | 18162 | 130 |
1243908 | 1243908 | 2021-04-21 | Erie | Ohio | 39043 | 7644 | 154 |
1243909 | 1243909 | 2021-04-21 | Fairfield | Ohio | 39045 | 15796 | 197 |
1243910 | 1243910 | 2021-04-21 | Fayette | Ohio | 39047 | 2784 | 48 |
1243911 | 1243911 | 2021-04-21 | Franklin | Ohio | 39049 | 122998 | 1360 |
1243912 | 1243912 | 2021-04-21 | Fulton | Ohio | 39051 | 4116 | 67 |
1243913 | 1243913 | 2021-04-21 | Gallia | Ohio | 39053 | 2333 | 46 |
1243914 | 1243914 | 2021-04-21 | Geauga | Ohio | 39055 | 6563 | 146 |
1243915 | 1243915 | 2021-04-21 | Greene | Ohio | 39057 | 14765 | 236 |
1243916 | 1243916 | 2021-04-21 | Guernsey | Ohio | 39059 | 3087 | 49 |
1243917 | 1243917 | 2021-04-21 | Hamilton | Ohio | 39061 | 78503 | 1170 |
1243918 | 1243918 | 2021-04-21 | Hancock | Ohio | 39063 | 6746 | 124 |
1243919 | 1243919 | 2021-04-21 | Hardin | Ohio | 39065 | 2659 | 64 |
1243920 | 1243920 | 2021-04-21 | Harrison | Ohio | 39067 | 1059 | 36 |
1243921 | 1243921 | 2021-04-21 | Henry | Ohio | 39069 | 2650 | 66 |
1243922 | 1243922 | 2021-04-21 | Highland | Ohio | 39071 | 3484 | 60 |
1243923 | 1243923 | 2021-04-21 | Hocking | Ohio | 39073 | 2107 | 59 |
1243924 | 1243924 | 2021-04-21 | Holmes | Ohio | 39075 | 2551 | 99 |
1243925 | 1243925 | 2021-04-21 | Huron | Ohio | 39077 | 5333 | 114 |
1243926 | 1243926 | 2021-04-21 | Jackson | Ohio | 39079 | 3093 | 51 |
1243927 | 1243927 | 2021-04-21 | Jefferson | Ohio | 39081 | 5372 | 149 |
1243928 | 1243928 | 2021-04-21 | Knox | Ohio | 39083 | 4418 | 108 |
1243929 | 1243929 | 2021-04-21 | Lake | Ohio | 39085 | 20143 | 365 |
1243930 | 1243930 | 2021-04-21 | Lawrence | Ohio | 39087 | 5483 | 102 |
1243931 | 1243931 | 2021-04-21 | Licking | Ohio | 39089 | 16185 | 207 |
1243932 | 1243932 | 2021-04-21 | Logan | Ohio | 39091 | 3751 | 76 |
1243933 | 1243933 | 2021-04-21 | Lorain | Ohio | 39093 | 24333 | 473 |
1243934 | 1243934 | 2021-04-21 | Lucas | Ohio | 39095 | 40568 | 768 |
1243935 | 1243935 | 2021-04-21 | Madison | Ohio | 39097 | 4265 | 59 |
1243936 | 1243936 | 2021-04-21 | Mahoning | Ohio | 39099 | 21029 | 584 |
1243937 | 1243937 | 2021-04-21 | Marion | Ohio | 39101 | 8409 | 135 |
1243938 | 1243938 | 2021-04-21 | Medina | Ohio | 39103 | 14961 | 259 |
1243939 | 1243939 | 2021-04-21 | Meigs | Ohio | 39105 | 1417 | 38 |
1243940 | 1243940 | 2021-04-21 | Mercer | Ohio | 39107 | 4737 | 85 |
1243941 | 1243941 | 2021-04-21 | Miami | Ohio | 39109 | 10568 | 214 |
1243942 | 1243942 | 2021-04-21 | Monroe | Ohio | 39111 | 1290 | 41 |
1243943 | 1243943 | 2021-04-21 | Montgomery | Ohio | 39113 | 50326 | 998 |
1243944 | 1243944 | 2021-04-21 | Morgan | Ohio | 39115 | 1077 | 23 |
1243945 | 1243945 | 2021-04-21 | Morrow | Ohio | 39117 | 2772 | 39 |
1243946 | 1243946 | 2021-04-21 | Muskingum | Ohio | 39119 | 8729 | 127 |
1243947 | 1243947 | 2021-04-21 | Noble | Ohio | 39121 | 1330 | 37 |
1243948 | 1243948 | 2021-04-21 | Ottawa | Ohio | 39123 | 3595 | 78 |
1243949 | 1243949 | 2021-04-21 | Paulding | Ohio | 39125 | 1692 | 39 |
1243950 | 1243950 | 2021-04-21 | Perry | Ohio | 39127 | 2909 | 49 |
1243951 | 1243951 | 2021-04-21 | Pickaway | Ohio | 39129 | 8454 | 121 |
1243952 | 1243952 | 2021-04-21 | Pike | Ohio | 39131 | 2342 | 31 |
1243953 | 1243953 | 2021-04-21 | Portage | Ohio | 39133 | 12481 | 196 |
1243954 | 1243954 | 2021-04-21 | Preble | Ohio | 39135 | 3724 | 98 |
1243955 | 1243955 | 2021-04-21 | Putnam | Ohio | 39137 | 4231 | 99 |
1243956 | 1243956 | 2021-04-21 | Richland | Ohio | 39139 | 11102 | 198 |
1243957 | 1243957 | 2021-04-21 | Ross | Ohio | 39141 | 6727 | 146 |
1243958 | 1243958 | 2021-04-21 | Sandusky | Ohio | 39143 | 5208 | 120 |
1243959 | 1243959 | 2021-04-21 | Scioto | Ohio | 39145 | 6314 | 101 |
1243960 | 1243960 | 2021-04-21 | Seneca | Ohio | 39147 | 5163 | 120 |
1243961 | 1243961 | 2021-04-21 | Shelby | Ohio | 39149 | 4580 | 92 |
1243962 | 1243962 | 2021-04-21 | Stark | Ohio | 39151 | 31586 | 896 |
1243963 | 1243963 | 2021-04-21 | Summit | Ohio | 39153 | 45710 | 915 |
1243964 | 1243964 | 2021-04-21 | Trumbull | Ohio | 39155 | 15666 | 461 |
1243965 | 1243965 | 2021-04-21 | Tuscarawas | Ohio | 39157 | 8393 | 240 |
1243966 | 1243966 | 2021-04-21 | Union | Ohio | 39159 | 5602 | 47 |
1243967 | 1243967 | 2021-04-21 | Unknown | Ohio | 0 | 2 | |
1243968 | 1243968 | 2021-04-21 | Van Wert | Ohio | 39161 | 2398 | 63 |
1243969 | 1243969 | 2021-04-21 | Vinton | Ohio | 39163 | 816 | 14 |
1243970 | 1243970 | 2021-04-21 | Warren | Ohio | 39165 | 23964 | 293 |
1243971 | 1243971 | 2021-04-21 | Washington | Ohio | 39167 | 5095 | 108 |
1243972 | 1243972 | 2021-04-21 | Wayne | Ohio | 39169 | 8619 | 209 |
1243973 | 1243973 | 2021-04-21 | Williams | Ohio | 39171 | 3300 | 74 |
1243974 | 1243974 | 2021-04-21 | Wood | Ohio | 39173 | 12828 | 185 |
1243975 | 1243975 | 2021-04-21 | Wyandot | Ohio | 39175 | 2283 | 54 |
1240640 | 1240640 | 2021-04-20 | Adams | Ohio | 39001 | 2295 | 52 |
1240641 | 1240641 | 2021-04-20 | Allen | Ohio | 39003 | 11362 | 229 |
1240642 | 1240642 | 2021-04-20 | Ashland | Ohio | 39005 | 4141 | 88 |
1240643 | 1240643 | 2021-04-20 | Ashtabula | Ohio | 39007 | 6544 | 166 |
1240644 | 1240644 | 2021-04-20 | Athens | Ohio | 39009 | 5070 | 56 |
1240645 | 1240645 | 2021-04-20 | Auglaize | Ohio | 39011 | 4768 | 83 |
1240646 | 1240646 | 2021-04-20 | Belmont | Ohio | 39013 | 5649 | 159 |
1240647 | 1240647 | 2021-04-20 | Brown | Ohio | 39015 | 3873 | 55 |
1240648 | 1240648 | 2021-04-20 | Butler | Ohio | 39017 | 37809 | 572 |
1240649 | 1240649 | 2021-04-20 | Carroll | Ohio | 39019 | 1896 | 47 |
1240650 | 1240650 | 2021-04-20 | Champaign | Ohio | 39021 | 3220 | 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);