⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

26,778 rows where state = "Ohio" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Ohio · 26,778
Link rowid date ▲ county state fips cases deaths
955031 2021-01-22 Adams Ohio 39001 1730 15
955032 2021-01-22 Allen Ohio 39003 9826 126
955033 2021-01-22 Ashland Ohio 39005 3428 38
955034 2021-01-22 Ashtabula Ohio 39007 4510 73
955035 2021-01-22 Athens Ohio 39009 3766 9
955036 2021-01-22 Auglaize Ohio 39011 4211 64
955037 2021-01-22 Belmont Ohio 39013 4127 40
955038 2021-01-22 Brown Ohio 39015 3091 21
955039 2021-01-22 Butler Ohio 39017 30735 231
955040 2021-01-22 Carroll Ohio 39019 1542 16
955041 2021-01-22 Champaign Ohio 39021 2497 28
955042 2021-01-22 Clark Ohio 39023 10867 265
955043 2021-01-22 Clermont Ohio 39025 15800 111
955044 2021-01-22 Clinton Ohio 39027 2879 43
955045 2021-01-22 Columbiana Ohio 39029 7286 124
955046 2021-01-22 Coshocton Ohio 39031 2045 21
955047 2021-01-22 Crawford Ohio 39033 3205 73
955048 2021-01-22 Cuyahoga Ohio 39035 84960 1082
955049 2021-01-22 Darke Ohio 39037 4678 92
955050 2021-01-22 Defiance Ohio 39039 3282 82
955051 2021-01-22 Delaware Ohio 39041 14305 78
955052 2021-01-22 Erie Ohio 39043 6113 127
955053 2021-01-22 Fairfield Ohio 39045 12691 81
955054 2021-01-22 Fayette Ohio 39047 2351 30
955055 2021-01-22 Franklin Ohio 39049 100550 707
955056 2021-01-22 Fulton Ohio 39051 3365 43
955057 2021-01-22 Gallia Ohio 39053 1954 26
955058 2021-01-22 Geauga Ohio 39055 5038 55
955059 2021-01-22 Greene Ohio 39057 11975 136
955060 2021-01-22 Guernsey Ohio 39059 2513 25
955061 2021-01-22 Hamilton Ohio 39061 63509 448
955062 2021-01-22 Hancock Ohio 39063 5490 90
955063 2021-01-22 Hardin Ohio 39065 2113 33
955064 2021-01-22 Harrison Ohio 39067 884 21
955065 2021-01-22 Henry Ohio 39069 2173 49
955066 2021-01-22 Highland Ohio 39071 2737 18
955067 2021-01-22 Hocking Ohio 39073 1710 24
955068 2021-01-22 Holmes Ohio 39075 2238 74
955069 2021-01-22 Huron Ohio 39077 4254 41
955070 2021-01-22 Jackson Ohio 39079 2624 45
955071 2021-01-22 Jefferson Ohio 39081 4167 69
955072 2021-01-22 Knox Ohio 39083 3502 22
955073 2021-01-22 Lake Ohio 39085 15967 154
955074 2021-01-22 Lawrence Ohio 39087 4501 54
955075 2021-01-22 Licking Ohio 39089 13130 137
955076 2021-01-22 Logan Ohio 39091 3055 32
955077 2021-01-22 Lorain Ohio 39093 18847 223
955078 2021-01-22 Lucas Ohio 39095 31151 616
955079 2021-01-22 Madison Ohio 39097 3521 29
955080 2021-01-22 Mahoning Ohio 39099 17215 337
955081 2021-01-22 Marion Ohio 39101 7437 113
955082 2021-01-22 Medina Ohio 39103 11504 168
955083 2021-01-22 Meigs Ohio 39105 1080 24
955084 2021-01-22 Mercer Ohio 39107 4324 88
955085 2021-01-22 Miami Ohio 39109 9113 73
955086 2021-01-22 Monroe Ohio 39111 1006 31
955087 2021-01-22 Montgomery Ohio 39113 42863 417
955088 2021-01-22 Morgan Ohio 39115 826 29
955089 2021-01-22 Morrow Ohio 39117 2312 4
955090 2021-01-22 Muskingum Ohio 39119 6939 41
955091 2021-01-22 Noble Ohio 39121 1203 40
955092 2021-01-22 Ottawa Ohio 39123 2901 43
955093 2021-01-22 Paulding Ohio 39125 1434 21
955094 2021-01-22 Perry Ohio 39127 2287 18
955095 2021-01-22 Pickaway Ohio 39129 7217 50
955096 2021-01-22 Pike Ohio 39131 1739 17
955097 2021-01-22 Portage Ohio 39133 9213 108
955098 2021-01-22 Preble Ohio 39135 3191 37
955099 2021-01-22 Putnam Ohio 39137 3735 75
955100 2021-01-22 Richland Ohio 39139 9085 117
955101 2021-01-22 Ross Ohio 39141 5460 98
955102 2021-01-22 Sandusky Ohio 39143 4347 62
955103 2021-01-22 Scioto Ohio 39145 5363 64
955104 2021-01-22 Seneca Ohio 39147 4248 65
955105 2021-01-22 Shelby Ohio 39149 4205 22
955106 2021-01-22 Stark Ohio 39151 25598 430
955107 2021-01-22 Summit Ohio 39153 34586 759
955108 2021-01-22 Trumbull Ohio 39155 12739 313
955109 2021-01-22 Tuscarawas Ohio 39157 7339 181
955110 2021-01-22 Union Ohio 39159 4477 28
955111 2021-01-22 Van Wert Ohio 39161 2011 45
955112 2021-01-22 Vinton Ohio 39163 695 13
955113 2021-01-22 Warren Ohio 39165 19552 140
955114 2021-01-22 Washington Ohio 39167 3852 40
955115 2021-01-22 Wayne Ohio 39169 6987 171
955116 2021-01-22 Williams Ohio 39171 2771 67
955117 2021-01-22 Wood Ohio 39173 10289 158
955118 2021-01-22 Wyandot Ohio 39175 1946 51
951786 2021-01-21 Adams Ohio 39001 1720 15
951787 2021-01-21 Allen Ohio 39003 9774 126
951788 2021-01-21 Ashland Ohio 39005 3425 38
951789 2021-01-21 Ashtabula Ohio 39007 4493 73
951790 2021-01-21 Athens Ohio 39009 3737 9
951791 2021-01-21 Auglaize Ohio 39011 4196 62
951792 2021-01-21 Belmont Ohio 39013 4112 40
951793 2021-01-21 Brown Ohio 39015 3071 21
951794 2021-01-21 Butler Ohio 39017 30546 229
951795 2021-01-21 Carroll Ohio 39019 1532 16
951796 2021-01-21 Champaign Ohio 39021 2493 28
951797 2021-01-21 Clark Ohio 39023 10802 265

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);