ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where "date" is on date 2021-02-03 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 · 88 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
993898 | 993898 | 2021-02-03 | Adams | Ohio | 39001 | 1990 | 15 |
993899 | 993899 | 2021-02-03 | Allen | Ohio | 39003 | 10348 | 133 |
993900 | 993900 | 2021-02-03 | Ashland | Ohio | 39005 | 3600 | 38 |
993901 | 993901 | 2021-02-03 | Ashtabula | Ohio | 39007 | 4874 | 77 |
993902 | 993902 | 2021-02-03 | Athens | Ohio | 39009 | 4127 | 10 |
993903 | 993903 | 2021-02-03 | Auglaize | Ohio | 39011 | 4365 | 66 |
993904 | 993904 | 2021-02-03 | Belmont | Ohio | 39013 | 4490 | 50 |
993905 | 993905 | 2021-02-03 | Brown | Ohio | 39015 | 3396 | 25 |
993906 | 993906 | 2021-02-03 | Butler | Ohio | 39017 | 32764 | 259 |
993907 | 993907 | 2021-02-03 | Carroll | Ohio | 39019 | 1680 | 18 |
993908 | 993908 | 2021-02-03 | Champaign | Ohio | 39021 | 2654 | 28 |
993909 | 993909 | 2021-02-03 | Clark | Ohio | 39023 | 11552 | 295 |
993910 | 993910 | 2021-02-03 | Clermont | Ohio | 39025 | 17024 | 122 |
993911 | 993911 | 2021-02-03 | Clinton | Ohio | 39027 | 3122 | 46 |
993912 | 993912 | 2021-02-03 | Columbiana | Ohio | 39029 | 7665 | 130 |
993913 | 993913 | 2021-02-03 | Coshocton | Ohio | 39031 | 2174 | 24 |
993914 | 993914 | 2021-02-03 | Crawford | Ohio | 39033 | 3393 | 85 |
993915 | 993915 | 2021-02-03 | Cuyahoga | Ohio | 39035 | 89881 | 1210 |
993916 | 993916 | 2021-02-03 | Darke | Ohio | 39037 | 4850 | 98 |
993917 | 993917 | 2021-02-03 | Defiance | Ohio | 39039 | 3488 | 88 |
993918 | 993918 | 2021-02-03 | Delaware | Ohio | 39041 | 15254 | 84 |
993919 | 993919 | 2021-02-03 | Erie | Ohio | 39043 | 6499 | 135 |
993920 | 993920 | 2021-02-03 | Fairfield | Ohio | 39045 | 13560 | 86 |
993921 | 993921 | 2021-02-03 | Fayette | Ohio | 39047 | 2493 | 30 |
993922 | 993922 | 2021-02-03 | Franklin | Ohio | 39049 | 105796 | 712 |
993923 | 993923 | 2021-02-03 | Fulton | Ohio | 39051 | 3540 | 47 |
993924 | 993924 | 2021-02-03 | Gallia | Ohio | 39053 | 2069 | 31 |
993925 | 993925 | 2021-02-03 | Geauga | Ohio | 39055 | 5541 | 56 |
993926 | 993926 | 2021-02-03 | Greene | Ohio | 39057 | 12724 | 150 |
993927 | 993927 | 2021-02-03 | Guernsey | Ohio | 39059 | 2698 | 27 |
993928 | 993928 | 2021-02-03 | Hamilton | Ohio | 39061 | 68156 | 465 |
993929 | 993929 | 2021-02-03 | Hancock | Ohio | 39063 | 5716 | 94 |
993930 | 993930 | 2021-02-03 | Hardin | Ohio | 39065 | 2293 | 34 |
993931 | 993931 | 2021-02-03 | Harrison | Ohio | 39067 | 923 | 22 |
993932 | 993932 | 2021-02-03 | Henry | Ohio | 39069 | 2311 | 56 |
993933 | 993933 | 2021-02-03 | Highland | Ohio | 39071 | 3005 | 22 |
993934 | 993934 | 2021-02-03 | Hocking | Ohio | 39073 | 1815 | 27 |
993935 | 993935 | 2021-02-03 | Holmes | Ohio | 39075 | 2334 | 76 |
993936 | 993936 | 2021-02-03 | Huron | Ohio | 39077 | 4493 | 76 |
993937 | 993937 | 2021-02-03 | Jackson | Ohio | 39079 | 2742 | 47 |
993938 | 993938 | 2021-02-03 | Jefferson | Ohio | 39081 | 4361 | 84 |
993939 | 993939 | 2021-02-03 | Knox | Ohio | 39083 | 3766 | 25 |
993940 | 993940 | 2021-02-03 | Lake | Ohio | 39085 | 17044 | 169 |
993941 | 993941 | 2021-02-03 | Lawrence | Ohio | 39087 | 4883 | 63 |
993942 | 993942 | 2021-02-03 | Licking | Ohio | 39089 | 14000 | 147 |
993943 | 993943 | 2021-02-03 | Logan | Ohio | 39091 | 3301 | 38 |
993944 | 993944 | 2021-02-03 | Lorain | Ohio | 39093 | 20311 | 248 |
993945 | 993945 | 2021-02-03 | Lucas | Ohio | 39095 | 32974 | 682 |
993946 | 993946 | 2021-02-03 | Madison | Ohio | 39097 | 3711 | 30 |
993947 | 993947 | 2021-02-03 | Mahoning | Ohio | 39099 | 18229 | 339 |
993948 | 993948 | 2021-02-03 | Marion | Ohio | 39101 | 7663 | 113 |
993949 | 993949 | 2021-02-03 | Medina | Ohio | 39103 | 12341 | 177 |
993950 | 993950 | 2021-02-03 | Meigs | Ohio | 39105 | 1203 | 25 |
993951 | 993951 | 2021-02-03 | Mercer | Ohio | 39107 | 4450 | 93 |
993952 | 993952 | 2021-02-03 | Miami | Ohio | 39109 | 9556 | 74 |
993953 | 993953 | 2021-02-03 | Monroe | Ohio | 39111 | 1083 | 35 |
993954 | 993954 | 2021-02-03 | Montgomery | Ohio | 39113 | 44954 | 456 |
993955 | 993955 | 2021-02-03 | Morgan | Ohio | 39115 | 912 | 31 |
993956 | 993956 | 2021-02-03 | Morrow | Ohio | 39117 | 2443 | 5 |
993957 | 993957 | 2021-02-03 | Muskingum | Ohio | 39119 | 7545 | 43 |
993958 | 993958 | 2021-02-03 | Noble | Ohio | 39121 | 1235 | 41 |
993959 | 993959 | 2021-02-03 | Ottawa | Ohio | 39123 | 3068 | 49 |
993960 | 993960 | 2021-02-03 | Paulding | Ohio | 39125 | 1514 | 21 |
993961 | 993961 | 2021-02-03 | Perry | Ohio | 39127 | 2474 | 18 |
993962 | 993962 | 2021-02-03 | Pickaway | Ohio | 39129 | 7606 | 50 |
993963 | 993963 | 2021-02-03 | Pike | Ohio | 39131 | 1949 | 19 |
993964 | 993964 | 2021-02-03 | Portage | Ohio | 39133 | 10036 | 117 |
993965 | 993965 | 2021-02-03 | Preble | Ohio | 39135 | 3336 | 37 |
993966 | 993966 | 2021-02-03 | Putnam | Ohio | 39137 | 3873 | 77 |
993967 | 993967 | 2021-02-03 | Richland | Ohio | 39139 | 9648 | 148 |
993968 | 993968 | 2021-02-03 | Ross | Ohio | 39141 | 5753 | 104 |
993969 | 993969 | 2021-02-03 | Sandusky | Ohio | 39143 | 4522 | 66 |
993970 | 993970 | 2021-02-03 | Scioto | Ohio | 39145 | 5601 | 69 |
993971 | 993971 | 2021-02-03 | Seneca | Ohio | 39147 | 4469 | 69 |
993972 | 993972 | 2021-02-03 | Shelby | Ohio | 39149 | 4295 | 24 |
993973 | 993973 | 2021-02-03 | Stark | Ohio | 39151 | 27331 | 466 |
993974 | 993974 | 2021-02-03 | Summit | Ohio | 39153 | 36929 | 811 |
993975 | 993975 | 2021-02-03 | Trumbull | Ohio | 39155 | 13393 | 325 |
993976 | 993976 | 2021-02-03 | Tuscarawas | Ohio | 39157 | 7686 | 193 |
993977 | 993977 | 2021-02-03 | Union | Ohio | 39159 | 4793 | 33 |
993978 | 993978 | 2021-02-03 | Van Wert | Ohio | 39161 | 2111 | 46 |
993979 | 993979 | 2021-02-03 | Vinton | Ohio | 39163 | 737 | 14 |
993980 | 993980 | 2021-02-03 | Warren | Ohio | 39165 | 20836 | 152 |
993981 | 993981 | 2021-02-03 | Washington | Ohio | 39167 | 4139 | 52 |
993982 | 993982 | 2021-02-03 | Wayne | Ohio | 39169 | 7433 | 175 |
993983 | 993983 | 2021-02-03 | Williams | Ohio | 39171 | 2888 | 73 |
993984 | 993984 | 2021-02-03 | Wood | Ohio | 39173 | 10918 | 160 |
993985 | 993985 | 2021-02-03 | Wyandot | Ohio | 39175 | 2025 | 51 |
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);