johns_hopkins_csse_daily_reports

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 source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

90,027 rows where province_or_state = "Ohio" sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

province_or_state 1

  • Ohio · 90,027 ✖

country_or_region 1

  • US 90,027
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2755348 2755348 2022-12-29 US Ohio Adams 39001 8628 161 0   38.84541072 -83.4718964 2022-12-30 04:21:04 Adams, Ohio, US
2755349 2755349 2022-12-29 US Ohio Allen 39003 32974 502 0   40.77285242 -84.10802343 2022-12-30 04:21:04 Allen, Ohio, US
2755350 2755350 2022-12-29 US Ohio Ashland 39005 14591 234 0   40.84772277 -82.27280781 2022-12-30 04:21:04 Ashland, Ohio, US
2755351 2755351 2022-12-29 US Ohio Ashtabula 39007 25185 462 0   41.70860332 -80.74830218 2022-12-30 04:21:04 Ashtabula, Ohio, US
2755352 2755352 2022-12-29 US Ohio Athens 39009 19255 155 0   39.33425634 -82.04278644 2022-12-30 04:21:04 Athens, Ohio, US
2755353 2755353 2022-12-29 US Ohio Auglaize 39011 13831 195 0   40.55998859 -84.2242143 2022-12-30 04:21:04 Auglaize, Ohio, US
2755354 2755354 2022-12-29 US Ohio Belmont 39013 18762 326 0   40.01625942 -80.9924051 2022-12-30 04:21:04 Belmont, Ohio, US
2755355 2755355 2022-12-29 US Ohio Brown 39015 13715 195 0   38.93416837 -83.86788395 2022-12-30 04:21:04 Brown, Ohio, US
2755356 2755356 2022-12-29 US Ohio Butler 39017 113510 1225 0   39.44012838 -84.57388716 2022-12-30 04:21:04 Butler, Ohio, US
2755357 2755357 2022-12-29 US Ohio Carroll 39019 6224 134 0   40.5789686 -81.09178213 2022-12-30 04:21:04 Carroll, Ohio, US
2755358 2755358 2022-12-29 US Ohio Champaign 39021 10541 159 0   40.13923427 -83.76875242 2022-12-30 04:21:04 Champaign, Ohio, US
2755359 2755359 2022-12-29 US Ohio Clark 39023 42493 613 0   39.91592258 -83.78498252 2022-12-30 04:21:04 Clark, Ohio, US
2755360 2755360 2022-12-29 US Ohio Clermont 39025 63670 604 0   39.04847534 -84.15375786 2022-12-30 04:21:04 Clermont, Ohio, US
2755361 2755361 2022-12-29 US Ohio Clinton 39027 12525 179 0   39.41485808 -83.80852286 2022-12-30 04:21:04 Clinton, Ohio, US
2755362 2755362 2022-12-29 US Ohio Columbiana 39029 29150 503 0   40.76932373 -80.78094576 2022-12-30 04:21:04 Columbiana, Ohio, US
2755363 2755363 2022-12-29 US Ohio Coshocton 39031 9840 167 0   40.30096166 -81.91729018 2022-12-30 04:21:04 Coshocton, Ohio, US
2755364 2755364 2022-12-29 US Ohio Crawford 39033 13888 224 0   40.85065156 -82.91989099 2022-12-30 04:21:04 Crawford, Ohio, US
2755365 2755365 2022-12-29 US Ohio Cuyahoga 39035 339677 4039 0   41.424119 -81.65918339 2022-12-30 04:21:04 Cuyahoga, Ohio, US
2755366 2755366 2022-12-29 US Ohio Darke 39037 14746 246 0   40.13412966 -84.6194517 2022-12-30 04:21:04 Darke, Ohio, US
2755367 2755367 2022-12-29 US Ohio Defiance 39039 12158 172 0   41.32398837 -84.49076944 2022-12-30 04:21:04 Defiance, Ohio, US
2755368 2755368 2022-12-29 US Ohio Delaware 39041 54803 291 0   40.27942393 -83.00457058 2022-12-30 04:21:04 Delaware, Ohio, US
2755369 2755369 2022-12-29 US Ohio Erie 39043 24372 283 0   41.36796058 -82.62904521 2022-12-30 04:21:04 Erie, Ohio, US
2755370 2755370 2022-12-29 US Ohio Fairfield 39045 46398 455 0   39.75107189 -82.63088163 2022-12-30 04:21:04 Fairfield, Ohio, US
2755371 2755371 2022-12-29 US Ohio Fayette 39047 9179 134 0   39.56021306 -83.4562016 2022-12-30 04:21:04 Fayette, Ohio, US
2755372 2755372 2022-12-29 US Ohio Franklin 39049 357732 2769 0   39.96995815 -83.01115755 2022-12-30 04:21:04 Franklin, Ohio, US
2755373 2755373 2022-12-29 US Ohio Fulton 39051 12230 185 0   41.60213491 -84.12571393 2022-12-30 04:21:04 Fulton, Ohio, US
2755374 2755374 2022-12-29 US Ohio Gallia 39053 10024 136 0   38.82708533 -82.31647569 2022-12-30 04:21:04 Gallia, Ohio, US
2755375 2755375 2022-12-29 US Ohio Geauga 39055 19886 288 0   41.49952319 -81.17935342 2022-12-30 04:21:04 Geauga, Ohio, US
2755376 2755376 2022-12-29 US Ohio Greene 39057 47035 537 0   39.69116283 -83.89032084 2022-12-30 04:21:04 Greene, Ohio, US
2755377 2755377 2022-12-29 US Ohio Guernsey 39059 13307 163 0   40.05026529 -81.49248905 2022-12-30 04:21:04 Guernsey, Ohio, US
2755378 2755378 2022-12-29 US Ohio Hamilton 39061 231926 2189 0   39.19673558 -84.54502924 2022-12-30 04:21:04 Hamilton, Ohio, US
2755379 2755379 2022-12-29 US Ohio Hancock 39063 20786 291 0   41.00250487 -83.66838948 2022-12-30 04:21:04 Hancock, Ohio, US
2755380 2755380 2022-12-29 US Ohio Hardin 39065 8562 167 0   40.66015414 -83.65929931 2022-12-30 04:21:04 Hardin, Ohio, US
2755381 2755381 2022-12-29 US Ohio Harrison 39067 4056 81 0   40.29380509 -81.09068544 2022-12-30 04:21:04 Harrison, Ohio, US
2755382 2755382 2022-12-29 US Ohio Henry 39069 7637 113 0   41.3339642 -84.06830637 2022-12-30 04:21:04 Henry, Ohio, US
2755383 2755383 2022-12-29 US Ohio Highland 39071 13087 189 0   39.1839264 -83.60331456 2022-12-30 04:21:04 Highland, Ohio, US
2755384 2755384 2022-12-29 US Ohio Hocking 39073 8424 130 0   39.49537927 -82.47991446 2022-12-30 04:21:04 Hocking, Ohio, US
2755385 2755385 2022-12-29 US Ohio Holmes 39075 5742 191 0   40.56163713 -81.92635677 2022-12-30 04:21:04 Holmes, Ohio, US
2755386 2755386 2022-12-29 US Ohio Huron 39077 17669 231 0   41.14651175 -82.59867951 2022-12-30 04:21:04 Huron, Ohio, US
2755387 2755387 2022-12-29 US Ohio Jackson 39079 11410 147 0   39.01914254 -82.6181856 2022-12-30 04:21:04 Jackson, Ohio, US
2755388 2755388 2022-12-29 US Ohio Jefferson 39081 18360 339 0   40.38614126 -80.76259514 2022-12-30 04:21:04 Jefferson, Ohio, US
2755389 2755389 2022-12-29 US Ohio Knox 39083 16237 247 0   40.39830217 -82.42027563 2022-12-30 04:21:04 Knox, Ohio, US
2755390 2755390 2022-12-29 US Ohio Lake 39085 60243 795 0   41.69710807 -81.23676539 2022-12-30 04:21:04 Lake, Ohio, US
2755391 2755391 2022-12-29 US Ohio Lawrence 39087 23261 284 0   38.59743452 -82.53466552 2022-12-30 04:21:04 Lawrence, Ohio, US
2755392 2755392 2022-12-29 US Ohio Licking 39089 51525 505 0   40.09136236 -82.48185785 2022-12-30 04:21:04 Licking, Ohio, US
2755393 2755393 2022-12-29 US Ohio Logan 39091 12490 178 0   40.38996525 -83.76784341 2022-12-30 04:21:04 Logan, Ohio, US
2755394 2755394 2022-12-29 US Ohio Lorain 39093 86698 1039 0   41.29553751 -82.15083537 2022-12-30 04:21:04 Lorain, Ohio, US
2755395 2755395 2022-12-29 US Ohio Lucas 39095 123198 1492 0   41.62101218 -83.65468618 2022-12-30 04:21:04 Lucas, Ohio, US
2755396 2755396 2022-12-29 US Ohio Madison 39097 11360 144 0   39.89381073 -83.40178317 2022-12-30 04:21:04 Madison, Ohio, US
2755397 2755397 2022-12-29 US Ohio Mahoning 39099 65651 1162 0   41.01631101 -80.77287029 2022-12-30 04:21:04 Mahoning, Ohio, US
2755398 2755398 2022-12-29 US Ohio Marion 39101 23956 285 0   40.58610662 -83.15736305 2022-12-30 04:21:04 Marion, Ohio, US
2755399 2755399 2022-12-29 US Ohio Medina 39103 49470 534 0   41.11770589 -81.8998621 2022-12-30 04:21:04 Medina, Ohio, US
2755400 2755400 2022-12-29 US Ohio Meigs 39105 6122 102 0   39.09224872 -82.0305041 2022-12-30 04:21:04 Meigs, Ohio, US
2755401 2755401 2022-12-29 US Ohio Mercer 39107 11149 146 0   40.54043046 -84.62912742 2022-12-30 04:21:04 Mercer, Ohio, US
2755402 2755402 2022-12-29 US Ohio Miami 39109 31066 503 0   40.0543329 -84.22871271 2022-12-30 04:21:04 Miami, Ohio, US
2755403 2755403 2022-12-29 US Ohio Monroe 39111 4103 83 0   39.72984936 -81.08464734 2022-12-30 04:21:04 Monroe, Ohio, US
2755404 2755404 2022-12-29 US Ohio Montgomery 39113 157494 2171 0   39.75394919 -84.29050975 2022-12-30 04:21:04 Montgomery, Ohio, US
2755405 2755405 2022-12-29 US Ohio Morgan 39115 4053 62 0   39.62081738 -81.85308173 2022-12-30 04:21:04 Morgan, Ohio, US
2755406 2755406 2022-12-29 US Ohio Morrow 39117 9245 112 0   40.5236356 -82.7892599 2022-12-30 04:21:04 Morrow, Ohio, US
2755407 2755407 2022-12-29 US Ohio Muskingum 39119 30837 315 0   39.96575964 -81.94363275 2022-12-30 04:21:04 Muskingum, Ohio, US
2755408 2755408 2022-12-29 US Ohio Noble 39121 3834 61 0   39.76818851 -81.45937183 2022-12-30 04:21:04 Noble, Ohio, US
2755409 2755409 2022-12-29 US Ohio Ottawa 39123 10574 150 0   41.53781826 -83.0940185 2022-12-30 04:21:04 Ottawa, Ohio, US
2755410 2755410 2022-12-29 US Ohio Paulding 39125 5479 76 0   41.11676341 -84.5801017 2022-12-30 04:21:04 Paulding, Ohio, US
2755411 2755411 2022-12-29 US Ohio Perry 39127 10165 133 0   39.73508655 -82.23804971 2022-12-30 04:21:04 Perry, Ohio, US
2755412 2755412 2022-12-29 US Ohio Pickaway 39129 20825 238 0   39.64170392 -83.0243386 2022-12-30 04:21:04 Pickaway, Ohio, US
2755413 2755413 2022-12-29 US Ohio Pike 39131 9714 134 0   39.07634001 -83.06769584 2022-12-30 04:21:04 Pike, Ohio, US
2755414 2755414 2022-12-29 US Ohio Portage 39133 42858 478 0   41.16793482 -81.19735782 2022-12-30 04:21:04 Portage, Ohio, US
2755415 2755415 2022-12-29 US Ohio Preble 39135 11298 204 0   39.7420247 -84.64787018 2022-12-30 04:21:04 Preble, Ohio, US
2755416 2755416 2022-12-29 US Ohio Putnam 39137 9623 163 0   41.02094889 -84.1336111 2022-12-30 04:21:04 Putnam, Ohio, US
2755417 2755417 2022-12-29 US Ohio Richland 39139 38528 537 0   40.77180308 -82.5379961 2022-12-30 04:21:04 Richland, Ohio, US
2755418 2755418 2022-12-29 US Ohio Ross 39141 24323 320 0   39.33705391 -83.06000914 2022-12-30 04:21:04 Ross, Ohio, US
2755419 2755419 2022-12-29 US Ohio Sandusky 39143 17074 257 0   41.35624126 -83.137872 2022-12-30 04:21:04 Sandusky, Ohio, US
2755420 2755420 2022-12-29 US Ohio Scioto 39145 26814 276 0   38.80270163 -82.98907345 2022-12-30 04:21:04 Scioto, Ohio, US
2755421 2755421 2022-12-29 US Ohio Seneca 39147 15394 242 0   41.12351311 -83.12783209 2022-12-30 04:21:04 Seneca, Ohio, US
2755422 2755422 2022-12-29 US Ohio Shelby 39149 13082 199 0   40.33163494 -84.20258189 2022-12-30 04:21:04 Shelby, Ohio, US
2755423 2755423 2022-12-29 US Ohio Stark 39151 95595 1801 0   40.81482476 -81.36437305 2022-12-30 04:21:04 Stark, Ohio, US
2755424 2755424 2022-12-29 US Ohio Summit 39153 139176 1820 0   41.12464734 -81.53123079 2022-12-30 04:21:04 Summit, Ohio, US
2755425 2755425 2022-12-29 US Ohio Trumbull 39155 51477 1000 0   41.31735028 -80.76109643 2022-12-30 04:21:04 Trumbull, Ohio, US
2755426 2755426 2022-12-29 US Ohio Tuscarawas 39157 24795 530 0   40.44214695 -81.47226262 2022-12-30 04:21:04 Tuscarawas, Ohio, US
2755427 2755427 2022-12-29 US Ohio Unassigned 90039 0 5 0   41.70860332 -84.64787018 2022-12-30 04:21:04 Unassigned, Ohio, US
2755428 2755428 2022-12-29 US Ohio Union 39159 19436 113 0   40.30016061 -83.37239023 2022-12-30 04:21:04 Union, Ohio, US
2755429 2755429 2022-12-29 US Ohio Van Wert 39161 8025 158 0   40.8554138 -84.591117 2022-12-30 04:21:04 Van Wert, Ohio, US
2755430 2755430 2022-12-29 US Ohio Vinton 39163 3594 59 0   39.25208988 -82.4831444 2022-12-30 04:21:04 Vinton, Ohio, US
2755431 2755431 2022-12-29 US Ohio Warren 39165 70843 637 0   39.42581994 -84.16557457 2022-12-30 04:21:04 Warren, Ohio, US
2755432 2755432 2022-12-29 US Ohio Washington 39167 15018 241 0   39.45690571 -81.49121382 2022-12-30 04:21:04 Washington, Ohio, US
2755433 2755433 2022-12-29 US Ohio Wayne 39169 28024 466 0   40.82925852 -81.88844833 2022-12-30 04:21:04 Wayne, Ohio, US
2755434 2755434 2022-12-29 US Ohio Williams 39171 11574 170 0   41.56052014 -84.58429552 2022-12-30 04:21:04 Williams, Ohio, US
2755435 2755435 2022-12-29 US Ohio Wood 39173 37796 388 0   41.36224827 -83.62285108 2022-12-30 04:21:04 Wood, Ohio, US
2755436 2755436 2022-12-29 US Ohio Wyandot 39175 6484 109 0   40.84339621 -83.30734173 2022-12-30 04:21:04 Wyandot, Ohio, US
1076354 1076354 2022-12-28 US Ohio Adams 39001 8588 161 0   38.84541072 -83.4718964 2022-12-29 04:21:01 Adams, Ohio, US
1076355 1076355 2022-12-28 US Ohio Allen 39003 32819 502 0   40.77285242 -84.10802343 2022-12-29 04:21:01 Allen, Ohio, US
1076356 1076356 2022-12-28 US Ohio Ashland 39005 14543 234 0   40.84772277 -82.27280781 2022-12-29 04:21:01 Ashland, Ohio, US
1076357 1076357 2022-12-28 US Ohio Ashtabula 39007 25105 462 0   41.70860332 -80.74830218 2022-12-29 04:21:01 Ashtabula, Ohio, US
1076358 1076358 2022-12-28 US Ohio Athens 39009 19182 155 0   39.33425634 -82.04278644 2022-12-29 04:21:01 Athens, Ohio, US
1076359 1076359 2022-12-28 US Ohio Auglaize 39011 13782 195 0   40.55998859 -84.2242143 2022-12-29 04:21:01 Auglaize, Ohio, US
1076360 1076360 2022-12-28 US Ohio Belmont 39013 18692 326 0   40.01625942 -80.9924051 2022-12-29 04:21:01 Belmont, Ohio, US
1076361 1076361 2022-12-28 US Ohio Brown 39015 13663 195 0   38.93416837 -83.86788395 2022-12-29 04:21:01 Brown, Ohio, US
1076362 1076362 2022-12-28 US Ohio Butler 39017 113087 1225 0   39.44012838 -84.57388716 2022-12-29 04:21:01 Butler, Ohio, US
1076363 1076363 2022-12-28 US Ohio Carroll 39019 6212 134 0   40.5789686 -81.09178213 2022-12-29 04:21:01 Carroll, Ohio, US
1076364 1076364 2022-12-28 US Ohio Champaign 39021 10507 159 0   40.13923427 -83.76875242 2022-12-29 04:21:01 Champaign, Ohio, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] TEXT,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);