ny_times_us_counties

Table actions
⚠️ 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

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

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