johns_hopkins_csse_daily_reports

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

12,686 rows where province_or_state = "Ohio" sorted by day descending

View and edit SQL

province_or_state

  • Ohio · 12,686

country_or_region

  • US 12,686
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
136468 2020-08-12 US Ohio Adams 39001 64 2 0 62 38.84541072 -83.4718964 2020-08-13 04:29:15 Adams, Ohio, US
136469 2020-08-12 US Ohio Allen 39003 794 46 0 748 40.77285242 -84.10802343 2020-08-13 04:29:15 Allen, Ohio, US
136470 2020-08-12 US Ohio Ashland 39005 155 3 0 152 40.84772277 -82.27280781 2020-08-13 04:29:15 Ashland, Ohio, US
136471 2020-08-12 US Ohio Ashtabula 39007 577 46 0 531 41.70860332 -80.74830218 2020-08-13 04:29:15 Ashtabula, Ohio, US
136472 2020-08-12 US Ohio Athens 39009 361 2 0 359 39.33425634 -82.04278644 2020-08-13 04:29:15 Athens, Ohio, US
136473 2020-08-12 US Ohio Auglaize 39011 275 6 0 269 40.55998859 -84.22421429999999 2020-08-13 04:29:15 Auglaize, Ohio, US
136474 2020-08-12 US Ohio Belmont 39013 627 26 0 601 40.01625942 -80.9924051 2020-08-13 04:29:15 Belmont, Ohio, US
136475 2020-08-12 US Ohio Brown 39015 150 2 0 148 38.93416837 -83.86788395 2020-08-13 04:29:15 Brown, Ohio, US
136476 2020-08-12 US Ohio Butler 39017 3033 64 0 2969 39.44012838 -84.57388716 2020-08-13 04:29:15 Butler, Ohio, US
136477 2020-08-12 US Ohio Carroll 39019 113 5 0 108 40.5789686 -81.09178213 2020-08-13 04:29:15 Carroll, Ohio, US
136478 2020-08-12 US Ohio Champaign 39021 188 2 0 186 40.13923427 -83.76875242 2020-08-13 04:29:15 Champaign, Ohio, US
136479 2020-08-12 US Ohio Clark 39023 1213 15 0 1198 39.91592258 -83.78498252 2020-08-13 04:29:15 Clark, Ohio, US
136480 2020-08-12 US Ohio Clermont 39025 962 11 0 951 39.04847534 -84.15375786 2020-08-13 04:29:15 Clermont, Ohio, US
136481 2020-08-12 US Ohio Clinton 39027 171 6 0 165 39.41485808 -83.80852286 2020-08-13 04:29:15 Clinton, Ohio, US
136482 2020-08-12 US Ohio Columbiana 39029 1683 60 0 1623 40.76932373 -80.78094576 2020-08-13 04:29:15 Columbiana, Ohio, US
136483 2020-08-12 US Ohio Coshocton 39031 196 7 0 189 40.30096166 -81.91729018 2020-08-13 04:29:15 Coshocton, Ohio, US
136484 2020-08-12 US Ohio Crawford 39033 177 5 0 172 40.85065156 -82.91989099 2020-08-13 04:29:15 Crawford, Ohio, US
136485 2020-08-12 US Ohio Cuyahoga 39035 13869 512 0 13357 41.424119 -81.65918339 2020-08-13 04:29:15 Cuyahoga, Ohio, US
136486 2020-08-12 US Ohio Darke 39037 414 29 0 385 40.13412966 -84.6194517 2020-08-13 04:29:15 Darke, Ohio, US
136487 2020-08-12 US Ohio Defiance 39039 154 4 0 150 41.32398837 -84.49076944 2020-08-13 04:29:15 Defiance, Ohio, US
136488 2020-08-12 US Ohio Delaware 39041 1365 19 0 1346 40.27942393 -83.00457058 2020-08-13 04:29:15 Delaware, Ohio, US
136489 2020-08-12 US Ohio Erie 39043 610 28 0 582 41.36796058 -82.62904521 2020-08-13 04:29:15 Erie, Ohio, US
136490 2020-08-12 US Ohio Fairfield 39045 1432 32 0 1400 39.75107189 -82.63088163 2020-08-13 04:29:15 Fairfield, Ohio, US
136491 2020-08-12 US Ohio Fayette 39047 124 0 0 124 39.56021306 -83.4562016 2020-08-13 04:29:15 Fayette, Ohio, US
136492 2020-08-12 US Ohio Franklin 39049 18965 531 0 18434 39.96995815 -83.01115755 2020-08-13 04:29:15 Franklin, Ohio, US
136493 2020-08-12 US Ohio Fulton 39051 155 1 0 154 41.60213491 -84.12571393 2020-08-13 04:29:15 Fulton, Ohio, US
136494 2020-08-12 US Ohio Gallia 39053 74 1 0 73 38.82708533 -82.31647569 2020-08-13 04:29:15 Gallia, Ohio, US
136495 2020-08-12 US Ohio Geauga 39055 561 44 0 517 41.49952319 -81.17935342 2020-08-13 04:29:15 Geauga, Ohio, US
136496 2020-08-12 US Ohio Greene 39057 730 12 0 718 39.69116283 -83.89032084 2020-08-13 04:29:15 Greene, Ohio, US
136497 2020-08-12 US Ohio Guernsey 39059 119 7 0 112 40.05026529 -81.49248905 2020-08-13 04:29:15 Guernsey, Ohio, US
136498 2020-08-12 US Ohio Hamilton 39061 9844 259 0 9585 39.19673558 -84.54502924 2020-08-13 04:29:15 Hamilton, Ohio, US
136499 2020-08-12 US Ohio Hancock 39063 397 3 0 394 41.00250487 -83.66838948 2020-08-13 04:29:15 Hancock, Ohio, US
136500 2020-08-12 US Ohio Hardin 39065 175 12 0 163 40.66015414 -83.65929931 2020-08-13 04:29:15 Hardin, Ohio, US
136501 2020-08-12 US Ohio Harrison 39067 26 1 0 25 40.29380509 -81.09068544 2020-08-13 04:29:15 Harrison, Ohio, US
136502 2020-08-12 US Ohio Henry 39069 122 2 0 120 41.3339642 -84.06830637 2020-08-13 04:29:15 Henry, Ohio, US
136503 2020-08-12 US Ohio Highland 39071 169 2 0 167 39.1839264 -83.60331456 2020-08-13 04:29:15 Highland, Ohio, US
136504 2020-08-12 US Ohio Hocking 39073 122 9 0 113 39.49537927 -82.47991446 2020-08-13 04:29:15 Hocking, Ohio, US
136505 2020-08-12 US Ohio Holmes 39075 331 6 0 325 40.56163713 -81.92635677 2020-08-13 04:29:15 Holmes, Ohio, US
136506 2020-08-12 US Ohio Huron 39077 411 5 0 406 41.14651175 -82.59867951 2020-08-13 04:29:15 Huron, Ohio, US
136507 2020-08-12 US Ohio Jackson 39079 77 0 0 77 39.01914254 -82.61818559999998 2020-08-13 04:29:15 Jackson, Ohio, US
136508 2020-08-12 US Ohio Jefferson 39081 240 3 0 237 40.38614126 -80.76259514 2020-08-13 04:29:15 Jefferson, Ohio, US
136509 2020-08-12 US Ohio Knox 39083 214 7 0 207 40.39830217 -82.42027563 2020-08-13 04:29:15 Knox, Ohio, US
136510 2020-08-12 US Ohio Lake 39085 1146 42 0 1104 41.69710807 -81.23676539 2020-08-13 04:29:15 Lake, Ohio, US
136511 2020-08-12 US Ohio Lawrence 39087 318 0 0 318 38.59743452 -82.53466552 2020-08-13 04:29:15 Lawrence, Ohio, US
136512 2020-08-12 US Ohio Licking 39089 1345 51 0 1294 40.09136236 -82.48185785 2020-08-13 04:29:15 Licking, Ohio, US
136513 2020-08-12 US Ohio Logan 39091 167 2 0 165 40.38996525 -83.76784341 2020-08-13 04:29:15 Logan, Ohio, US
136514 2020-08-12 US Ohio Lorain 39093 1831 77 0 1754 41.29553751 -82.15083537 2020-08-13 04:29:15 Lorain, Ohio, US
136515 2020-08-12 US Ohio Lucas 39095 5512 326 0 5186 41.62101218 -83.65468618 2020-08-13 04:29:15 Lucas, Ohio, US
136516 2020-08-12 US Ohio Madison 39097 503 10 0 493 39.89381073 -83.40178317 2020-08-13 04:29:15 Madison, Ohio, US
136517 2020-08-12 US Ohio Mahoning 39099 2623 256 0 2367 41.01631101 -80.77287029 2020-08-13 04:29:15 Mahoning, Ohio, US
136518 2020-08-12 US Ohio Marion 39101 2942 45 0 2897 40.58610662 -83.15736305 2020-08-13 04:29:15 Marion, Ohio, US
136519 2020-08-12 US Ohio Medina 39103 959 36 0 923 41.11770589 -81.89986209999998 2020-08-13 04:29:15 Medina, Ohio, US
136520 2020-08-12 US Ohio Meigs 39105 58 0 0 58 39.09224872 -82.0305041 2020-08-13 04:29:15 Meigs, Ohio, US
136521 2020-08-12 US Ohio Mercer 39107 641 13 0 628 40.54043046 -84.62912742 2020-08-13 04:29:15 Mercer, Ohio, US
136522 2020-08-12 US Ohio Miami 39109 868 39 0 829 40.0543329 -84.22871271 2020-08-13 04:29:15 Miami, Ohio, US
136523 2020-08-12 US Ohio Monroe 39111 94 18 0 76 39.72984936 -81.08464734 2020-08-13 04:29:15 Monroe, Ohio, US
136524 2020-08-12 US Ohio Montgomery 39113 4489 98 0 4391 39.75394919 -84.29050975 2020-08-13 04:29:15 Montgomery, Ohio, US
136525 2020-08-12 US Ohio Morgan 39115 30 0 0 30 39.62081738 -81.85308173 2020-08-13 04:29:15 Morgan, Ohio, US
136526 2020-08-12 US Ohio Morrow 39117 179 2 0 177 40.52363560000001 -82.7892599 2020-08-13 04:29:15 Morrow, Ohio, US
136527 2020-08-12 US Ohio Muskingum 39119 248 1 0 247 39.96575964 -81.94363275 2020-08-13 04:29:15 Muskingum, Ohio, US
136528 2020-08-12 US Ohio Noble 39121 17 0 0 17 39.76818851 -81.45937183 2020-08-13 04:29:15 Noble, Ohio, US
136529 2020-08-12 US Ohio Ottawa 39123 404 26 0 378 41.53781826 -83.0940185 2020-08-13 04:29:15 Ottawa, Ohio, US
136530 2020-08-12 US Ohio Paulding 39125 70 0 0 70 41.11676341 -84.5801017 2020-08-13 04:29:15 Paulding, Ohio, US
136531 2020-08-12 US Ohio Perry 39127 148 3 0 145 39.73508655 -82.23804971 2020-08-13 04:29:15 Perry, Ohio, US
136532 2020-08-12 US Ohio Pickaway 39129 2400 42 0 2358 39.64170392 -83.0243386 2020-08-13 04:29:15 Pickaway, Ohio, US
136533 2020-08-12 US Ohio Pike 39131 80 0 0 80 39.07634001 -83.06769584 2020-08-13 04:29:15 Pike, Ohio, US
136534 2020-08-12 US Ohio Portage 39133 776 64 0 712 41.16793482 -81.19735782 2020-08-13 04:29:15 Portage, Ohio, US
136535 2020-08-12 US Ohio Preble 39135 212 2 0 210 39.7420247 -84.64787018 2020-08-13 04:29:15 Preble, Ohio, US
136536 2020-08-12 US Ohio Putnam 39137 212 17 0 195 41.02094889 -84.1336111 2020-08-13 04:29:15 Putnam, Ohio, US
136537 2020-08-12 US Ohio Richland 39139 619 12 0 607 40.77180308 -82.53799609999999 2020-08-13 04:29:15 Richland, Ohio, US
136538 2020-08-12 US Ohio Ross 39141 509 4 0 505 39.33705391 -83.06000914 2020-08-13 04:29:15 Ross, Ohio, US
136539 2020-08-12 US Ohio Sandusky 39143 399 17 0 382 41.35624126 -83.137872 2020-08-13 04:29:15 Sandusky, Ohio, US
136540 2020-08-12 US Ohio Scioto 39145 259 1 0 258 38.80270163 -82.98907345 2020-08-13 04:29:15 Scioto, Ohio, US
136541 2020-08-12 US Ohio Seneca 39147 234 4 0 230 41.12351311 -83.12783209 2020-08-13 04:29:15 Seneca, Ohio, US
136542 2020-08-12 US Ohio Shelby 39149 215 4 0 211 40.33163494 -84.20258189 2020-08-13 04:29:15 Shelby, Ohio, US
136543 2020-08-12 US Ohio Stark 39151 1904 142 0 1762 40.81482476 -81.36437305 2020-08-13 04:29:15 Stark, Ohio, US
136544 2020-08-12 US Ohio Summit 39153 3667 224 0 3443 41.12464734 -81.53123079 2020-08-13 04:29:15 Summit, Ohio, US
136545 2020-08-12 US Ohio Trumbull 39155 1563 110 0 1453 41.31735028 -80.76109643 2020-08-13 04:29:15 Trumbull, Ohio, US
136546 2020-08-12 US Ohio Tuscarawas 39157 797 14 0 783 40.44214695 -81.47226262 2020-08-13 04:29:15 Tuscarawas, Ohio, US
136547 2020-08-12 US Ohio Unassigned 90039 0 0 0 0 41.70860332 -84.64787018 2020-08-13 04:29:15 Unassigned, Ohio, US
136548 2020-08-12 US Ohio Union 39159 273 1 0 272 40.30016061 -83.37239023 2020-08-13 04:29:15 Union, Ohio, US
136549 2020-08-12 US Ohio Van Wert 39161 73 2 0 71 40.8554138 -84.59111700000003 2020-08-13 04:29:15 Van Wert, Ohio, US
136550 2020-08-12 US Ohio Vinton 39163 32 2 0 30 39.25208988 -82.4831444 2020-08-13 04:29:15 Vinton, Ohio, US
136551 2020-08-12 US Ohio Warren 39165 1850 39 0 1811 39.42581994 -84.16557457 2020-08-13 04:29:15 Warren, Ohio, US
136552 2020-08-12 US Ohio Washington 39167 211 22 0 189 39.45690571 -81.49121382 2020-08-13 04:29:15 Washington, Ohio, US
136553 2020-08-12 US Ohio Wayne 39169 554 59 0 495 40.82925852 -81.88844833 2020-08-13 04:29:15 Wayne, Ohio, US
136554 2020-08-12 US Ohio Williams 39171 137 3 0 134 41.56052014 -84.58429552 2020-08-13 04:29:15 Williams, Ohio, US
136555 2020-08-12 US Ohio Wood 39173 1090 58 0 1032 41.36224827 -83.62285108 2020-08-13 04:29:15 Wood, Ohio, US
136556 2020-08-12 US Ohio Wyandot 39175 151 9 0 142 40.84339621 -83.30734173 2020-08-13 04:29:15 Wyandot, Ohio, US
502838 2020-08-11 US Ohio Adams 39001 61 2 0 59 38.84541072 -83.4718964 2020-08-12 04:27:29 Adams, Ohio, US
502839 2020-08-11 US Ohio Allen 39003 769 46 0 723 40.77285242 -84.10802343 2020-08-12 04:27:29 Allen, Ohio, US
502840 2020-08-11 US Ohio Ashland 39005 154 3 0 151 40.84772277 -82.27280781 2020-08-12 04:27:29 Ashland, Ohio, US
502841 2020-08-11 US Ohio Ashtabula 39007 576 46 0 530 41.70860332 -80.74830218 2020-08-12 04:27:29 Ashtabula, Ohio, US
502842 2020-08-11 US Ohio Athens 39009 360 2 0 358 39.33425634 -82.04278644 2020-08-12 04:27:29 Athens, Ohio, US
502843 2020-08-11 US Ohio Auglaize 39011 263 6 0 257 40.55998859 -84.22421429999999 2020-08-12 04:27:29 Auglaize, Ohio, US
502844 2020-08-11 US Ohio Belmont 39013 623 26 0 597 40.01625942 -80.9924051 2020-08-12 04:27:29 Belmont, Ohio, US
502845 2020-08-11 US Ohio Brown 39015 146 2 0 144 38.93416837 -83.86788395 2020-08-12 04:27:29 Brown, Ohio, US
502846 2020-08-11 US Ohio Butler 39017 2976 63 0 2913 39.44012838 -84.57388716 2020-08-12 04:27:29 Butler, Ohio, US
502847 2020-08-11 US Ohio Carroll 39019 113 5 0 108 40.5789686 -81.09178213 2020-08-12 04:27:29 Carroll, Ohio, US
502848 2020-08-11 US Ohio Champaign 39021 181 2 0 179 40.13923427 -83.76875242 2020-08-12 04:27:29 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] INTEGER,
   [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]);
Powered by Datasette · Query took 2105.295ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette