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 2020-04-30 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 |
---|---|---|---|---|---|---|---|
102863 | 102863 | 2020-04-30 | Adams | Ohio | 39001 | 4 | 0 |
102864 | 102864 | 2020-04-30 | Allen | Ohio | 39003 | 121 | 23 |
102865 | 102865 | 2020-04-30 | Ashland | Ohio | 39005 | 7 | 0 |
102866 | 102866 | 2020-04-30 | Ashtabula | Ohio | 39007 | 126 | 15 |
102867 | 102867 | 2020-04-30 | Athens | Ohio | 39009 | 3 | 1 |
102868 | 102868 | 2020-04-30 | Auglaize | Ohio | 39011 | 32 | 3 |
102869 | 102869 | 2020-04-30 | Belmont | Ohio | 39013 | 144 | 7 |
102870 | 102870 | 2020-04-30 | Brown | Ohio | 39015 | 11 | 1 |
102871 | 102871 | 2020-04-30 | Butler | Ohio | 39017 | 281 | 7 |
102872 | 102872 | 2020-04-30 | Carroll | Ohio | 39019 | 21 | 1 |
102873 | 102873 | 2020-04-30 | Champaign | Ohio | 39021 | 14 | 1 |
102874 | 102874 | 2020-04-30 | Clark | Ohio | 39023 | 57 | 2 |
102875 | 102875 | 2020-04-30 | Clermont | Ohio | 39025 | 88 | 3 |
102876 | 102876 | 2020-04-30 | Clinton | Ohio | 39027 | 29 | 0 |
102877 | 102877 | 2020-04-30 | Columbiana | Ohio | 39029 | 253 | 23 |
102878 | 102878 | 2020-04-30 | Coshocton | Ohio | 39031 | 17 | 0 |
102879 | 102879 | 2020-04-30 | Crawford | Ohio | 39033 | 45 | 0 |
102880 | 102880 | 2020-04-30 | Cuyahoga | Ohio | 39035 | 2126 | 112 |
102881 | 102881 | 2020-04-30 | Darke | Ohio | 39037 | 76 | 14 |
102882 | 102882 | 2020-04-30 | Defiance | Ohio | 39039 | 20 | 1 |
102883 | 102883 | 2020-04-30 | Delaware | Ohio | 39041 | 160 | 4 |
102884 | 102884 | 2020-04-30 | Erie | Ohio | 39043 | 56 | 3 |
102885 | 102885 | 2020-04-30 | Fairfield | Ohio | 39045 | 137 | 2 |
102886 | 102886 | 2020-04-30 | Fayette | Ohio | 39047 | 15 | 0 |
102887 | 102887 | 2020-04-30 | Franklin | Ohio | 39049 | 2441 | 73 |
102888 | 102888 | 2020-04-30 | Fulton | Ohio | 39051 | 22 | 0 |
102889 | 102889 | 2020-04-30 | Gallia | Ohio | 39053 | 6 | 1 |
102890 | 102890 | 2020-04-30 | Geauga | Ohio | 39055 | 154 | 13 |
102891 | 102891 | 2020-04-30 | Greene | Ohio | 39057 | 46 | 4 |
102892 | 102892 | 2020-04-30 | Guernsey | Ohio | 39059 | 15 | 0 |
102893 | 102893 | 2020-04-30 | Hamilton | Ohio | 39061 | 1218 | 71 |
102894 | 102894 | 2020-04-30 | Hancock | Ohio | 39063 | 37 | 1 |
102895 | 102895 | 2020-04-30 | Hardin | Ohio | 39065 | 25 | 0 |
102896 | 102896 | 2020-04-30 | Harrison | Ohio | 39067 | 4 | 0 |
102897 | 102897 | 2020-04-30 | Henry | Ohio | 39069 | 5 | 0 |
102898 | 102898 | 2020-04-30 | Highland | Ohio | 39071 | 11 | 0 |
102899 | 102899 | 2020-04-30 | Hocking | Ohio | 39073 | 18 | 1 |
102900 | 102900 | 2020-04-30 | Holmes | Ohio | 39075 | 6 | 1 |
102901 | 102901 | 2020-04-30 | Huron | Ohio | 39077 | 29 | 1 |
102902 | 102902 | 2020-04-30 | Jackson | Ohio | 39079 | 4 | 0 |
102903 | 102903 | 2020-04-30 | Jefferson | Ohio | 39081 | 43 | 1 |
102904 | 102904 | 2020-04-30 | Knox | Ohio | 39083 | 16 | 1 |
102905 | 102905 | 2020-04-30 | Lake | Ohio | 39085 | 168 | 7 |
102906 | 102906 | 2020-04-30 | Lawrence | Ohio | 39087 | 24 | 0 |
102907 | 102907 | 2020-04-30 | Licking | Ohio | 39089 | 118 | 5 |
102908 | 102908 | 2020-04-30 | Logan | Ohio | 39091 | 18 | 0 |
102909 | 102909 | 2020-04-30 | Lorain | Ohio | 39093 | 452 | 30 |
102910 | 102910 | 2020-04-30 | Lucas | Ohio | 39095 | 1251 | 117 |
102911 | 102911 | 2020-04-30 | Madison | Ohio | 39097 | 63 | 3 |
102912 | 102912 | 2020-04-30 | Mahoning | Ohio | 39099 | 828 | 80 |
102913 | 102913 | 2020-04-30 | Marion | Ohio | 39101 | 2196 | 4 |
102914 | 102914 | 2020-04-30 | Medina | Ohio | 39103 | 167 | 15 |
102915 | 102915 | 2020-04-30 | Meigs | Ohio | 39105 | 2 | 0 |
102916 | 102916 | 2020-04-30 | Mercer | Ohio | 39107 | 21 | 1 |
102917 | 102917 | 2020-04-30 | Miami | Ohio | 39109 | 139 | 27 |
102918 | 102918 | 2020-04-30 | Monroe | Ohio | 39111 | 3 | 0 |
102919 | 102919 | 2020-04-30 | Montgomery | Ohio | 39113 | 285 | 10 |
102920 | 102920 | 2020-04-30 | Morgan | Ohio | 39115 | 4 | 0 |
102921 | 102921 | 2020-04-30 | Morrow | Ohio | 39117 | 42 | 1 |
102922 | 102922 | 2020-04-30 | Muskingum | Ohio | 39119 | 12 | 0 |
102923 | 102923 | 2020-04-30 | Noble | Ohio | 39121 | 5 | 0 |
102924 | 102924 | 2020-04-30 | Ottawa | Ohio | 39123 | 38 | 0 |
102925 | 102925 | 2020-04-30 | Paulding | Ohio | 39125 | 8 | 0 |
102926 | 102926 | 2020-04-30 | Perry | Ohio | 39127 | 12 | 0 |
102927 | 102927 | 2020-04-30 | Pickaway | Ohio | 39129 | 1732 | 21 |
102928 | 102928 | 2020-04-30 | Pike | Ohio | 39131 | 3 | 0 |
102929 | 102929 | 2020-04-30 | Portage | Ohio | 39133 | 236 | 40 |
102930 | 102930 | 2020-04-30 | Preble | Ohio | 39135 | 27 | 1 |
102931 | 102931 | 2020-04-30 | Putnam | Ohio | 39137 | 67 | 8 |
102932 | 102932 | 2020-04-30 | Richland | Ohio | 39139 | 81 | 2 |
102933 | 102933 | 2020-04-30 | Ross | Ohio | 39141 | 39 | 1 |
102934 | 102934 | 2020-04-30 | Sandusky | Ohio | 39143 | 27 | 5 |
102935 | 102935 | 2020-04-30 | Scioto | Ohio | 39145 | 10 | 0 |
102936 | 102936 | 2020-04-30 | Seneca | Ohio | 39147 | 14 | 1 |
102937 | 102937 | 2020-04-30 | Shelby | Ohio | 39149 | 30 | 1 |
102938 | 102938 | 2020-04-30 | Stark | Ohio | 39151 | 347 | 50 |
102939 | 102939 | 2020-04-30 | Summit | Ohio | 39153 | 608 | 49 |
102940 | 102940 | 2020-04-30 | Trumbull | Ohio | 39155 | 308 | 31 |
102941 | 102941 | 2020-04-30 | Tuscarawas | Ohio | 39157 | 74 | 0 |
102942 | 102942 | 2020-04-30 | Union | Ohio | 39159 | 22 | 0 |
102943 | 102943 | 2020-04-30 | Van Wert | Ohio | 39161 | 3 | 0 |
102944 | 102944 | 2020-04-30 | Vinton | Ohio | 39163 | 6 | 0 |
102945 | 102945 | 2020-04-30 | Warren | Ohio | 39165 | 146 | 11 |
102946 | 102946 | 2020-04-30 | Washington | Ohio | 39167 | 98 | 12 |
102947 | 102947 | 2020-04-30 | Wayne | Ohio | 39169 | 128 | 28 |
102948 | 102948 | 2020-04-30 | Williams | Ohio | 39171 | 34 | 1 |
102949 | 102949 | 2020-04-30 | Wood | Ohio | 39173 | 164 | 20 |
102950 | 102950 | 2020-04-30 | Wyandot | Ohio | 39175 | 24 | 2 |
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);