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

51,579 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

  • Ohio · 51,579 ✖

country_or_region

  • US 51,579
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
34722 34722 2021-10-23 US Ohio Adams 39001 4171 95 0   38.84541072 -83.4718964 2021-10-24 04:21:22 Adams, Ohio, US
34723 34723 2021-10-23 US Ohio Allen 39003 16001 279 0   40.77285242 -84.10802343 2021-10-24 04:21:22 Allen, Ohio, US
34724 34724 2021-10-23 US Ohio Ashland 39005 6967 130 0   40.84772277 -82.27280781 2021-10-24 04:21:22 Ashland, Ohio, US
34725 34725 2021-10-23 US Ohio Ashtabula 39007 9741 204 0   41.70860332 -80.74830218 2021-10-24 04:21:22 Ashtabula, Ohio, US
34726 34726 2021-10-23 US Ohio Athens 39009 7777 79 0   39.33425634 -82.04278644 2021-10-24 04:21:22 Athens, Ohio, US
34727 34727 2021-10-23 US Ohio Auglaize 39011 6797 99 0   40.55998859 -84.22421429999999 2021-10-24 04:21:22 Auglaize, Ohio, US
34728 34728 2021-10-23 US Ohio Belmont 39013 9309 209 0   40.01625942 -80.9924051 2021-10-24 04:21:22 Belmont, Ohio, US
34729 34729 2021-10-23 US Ohio Brown 39015 6364 91 0   38.93416837 -83.86788395 2021-10-24 04:21:22 Brown, Ohio, US
34730 34730 2021-10-23 US Ohio Butler 39017 51580 718 0   39.44012838 -84.57388716 2021-10-24 04:21:22 Butler, Ohio, US
34731 34731 2021-10-23 US Ohio Carroll 39019 3023 65 0   40.578968599999996 -81.09178213 2021-10-24 04:21:22 Carroll, Ohio, US
34732 34732 2021-10-23 US Ohio Champaign 39021 5131 73 0   40.13923427 -83.76875242 2021-10-24 04:21:22 Champaign, Ohio, US
34733 34733 2021-10-23 US Ohio Clark 39023 19863 354 0   39.91592258 -83.78498252 2021-10-24 04:21:22 Clark, Ohio, US
34734 34734 2021-10-23 US Ohio Clermont 39025 28193 330 0   39.04847534 -84.15375786 2021-10-24 04:21:22 Clermont, Ohio, US
34735 34735 2021-10-23 US Ohio Clinton 39027 5837 93 0   39.41485808 -83.80852286 2021-10-24 04:21:22 Clinton, Ohio, US
34736 34736 2021-10-23 US Ohio Columbiana 39029 14080 274 0   40.76932373 -80.78094576 2021-10-24 04:21:22 Columbiana, Ohio, US
34737 34737 2021-10-23 US Ohio Coshocton 39031 4846 83 0   40.30096166 -81.91729018 2021-10-24 04:21:22 Coshocton, Ohio, US
34738 34738 2021-10-23 US Ohio Crawford 39033 6274 130 0   40.85065156 -82.91989099 2021-10-24 04:21:22 Crawford, Ohio, US
34739 34739 2021-10-23 US Ohio Cuyahoga 39035 146407 2459 0   41.424119 -81.65918339 2021-10-24 04:21:22 Cuyahoga, Ohio, US
34740 34740 2021-10-23 US Ohio Darke 39037 7689 158 0   40.13412966 -84.6194517 2021-10-24 04:21:22 Darke, Ohio, US
34741 34741 2021-10-23 US Ohio Defiance 39039 6218 105 0   41.32398837 -84.49076944 2021-10-24 04:21:22 Defiance, Ohio, US
34742 34742 2021-10-23 US Ohio Delaware 39041 24208 164 0   40.27942393 -83.00457058 2021-10-24 04:21:22 Delaware, Ohio, US
34743 34743 2021-10-23 US Ohio Erie 39043 10904 184 0   41.36796058 -82.62904521 2021-10-24 04:21:22 Erie, Ohio, US
34744 34744 2021-10-23 US Ohio Fairfield 39045 22395 247 0   39.75107189 -82.63088163 2021-10-24 04:21:22 Fairfield, Ohio, US
34745 34745 2021-10-23 US Ohio Fayette 39047 4292 63 0   39.56021306 -83.4562016 2021-10-24 04:21:22 Fayette, Ohio, US
34746 34746 2021-10-23 US Ohio Franklin 39049 164265 1696 0   39.96995815 -83.01115755 2021-10-24 04:21:22 Franklin, Ohio, US
34747 34747 2021-10-23 US Ohio Fulton 39051 6028 96 0   41.60213491 -84.12571393 2021-10-24 04:21:22 Fulton, Ohio, US
34748 34748 2021-10-23 US Ohio Gallia 39053 4184 67 0   38.82708533 -82.31647569 2021-10-24 04:21:22 Gallia, Ohio, US
34749 34749 2021-10-23 US Ohio Geauga 39055 8965 157 0   41.49952319 -81.17935342 2021-10-24 04:21:22 Geauga, Ohio, US
34750 34750 2021-10-23 US Ohio Greene 39057 22350 326 0   39.69116283 -83.89032084 2021-10-24 04:21:22 Greene, Ohio, US
34751 34751 2021-10-23 US Ohio Guernsey 39059 5930 71 0   40.05026529 -81.49248905 2021-10-24 04:21:22 Guernsey, Ohio, US
34752 34752 2021-10-23 US Ohio Hamilton 39061 105366 1431 0   39.19673558 -84.54502924 2021-10-24 04:21:22 Hamilton, Ohio, US
34753 34753 2021-10-23 US Ohio Hancock 39063 9707 155 0   41.00250487 -83.66838948 2021-10-24 04:21:22 Hancock, Ohio, US
34754 34754 2021-10-23 US Ohio Hardin 39065 4194 80 0   40.66015414 -83.65929931 2021-10-24 04:21:22 Hardin, Ohio, US
34755 34755 2021-10-23 US Ohio Harrison 39067 1821 46 0   40.29380509 -81.09068544 2021-10-24 04:21:22 Harrison, Ohio, US
34756 34756 2021-10-23 US Ohio Henry 39069 3653 72 0   41.333964200000004 -84.06830637 2021-10-24 04:21:22 Henry, Ohio, US
34757 34757 2021-10-23 US Ohio Highland 39071 6004 99 0   39.1839264 -83.60331456 2021-10-24 04:21:22 Highland, Ohio, US
34758 34758 2021-10-23 US Ohio Hocking 39073 3567 82 0   39.49537927 -82.47991446 2021-10-24 04:21:22 Hocking, Ohio, US
34759 34759 2021-10-23 US Ohio Holmes 39075 3642 125 0   40.56163713 -81.92635677 2021-10-24 04:21:22 Holmes, Ohio, US
34760 34760 2021-10-23 US Ohio Huron 39077 8404 143 0   41.14651175 -82.59867951 2021-10-24 04:21:22 Huron, Ohio, US
34761 34761 2021-10-23 US Ohio Jackson 39079 5102 73 0   39.01914254 -82.61818559999998 2021-10-24 04:21:22 Jackson, Ohio, US
34762 34762 2021-10-23 US Ohio Jefferson 39081 8567 199 0   40.38614126 -80.76259514 2021-10-24 04:21:22 Jefferson, Ohio, US
34763 34763 2021-10-23 US Ohio Knox 39083 7739 144 0   40.39830217 -82.42027563 2021-10-24 04:21:22 Knox, Ohio, US
34764 34764 2021-10-23 US Ohio Lake 39085 27063 448 0   41.69710807 -81.23676539 2021-10-24 04:21:22 Lake, Ohio, US
34765 34765 2021-10-23 US Ohio Lawrence 39087 9759 153 0   38.59743452 -82.53466552 2021-10-24 04:21:22 Lawrence, Ohio, US
34766 34766 2021-10-23 US Ohio Licking 39089 23939 294 0   40.09136236 -82.48185785 2021-10-24 04:21:22 Licking, Ohio, US
34767 34767 2021-10-23 US Ohio Logan 39091 5910 96 0   40.38996525 -83.76784341 2021-10-24 04:21:22 Logan, Ohio, US
34768 34768 2021-10-23 US Ohio Lorain 39093 35628 585 0   41.29553751 -82.15083537 2021-10-24 04:21:22 Lorain, Ohio, US
34769 34769 2021-10-23 US Ohio Lucas 39095 56338 917 0   41.62101218 -83.65468618 2021-10-24 04:21:22 Lucas, Ohio, US
34770 34770 2021-10-23 US Ohio Madison 39097 5945 78 0   39.89381073 -83.40178317 2021-10-24 04:21:22 Madison, Ohio, US
34771 34771 2021-10-23 US Ohio Mahoning 39099 30787 693 0   41.01631101 -80.77287029 2021-10-24 04:21:22 Mahoning, Ohio, US
34772 34772 2021-10-23 US Ohio Marion 39101 11976 180 0   40.58610662 -83.15736305 2021-10-24 04:21:22 Marion, Ohio, US
34773 34773 2021-10-23 US Ohio Medina 39103 22047 313 0   41.11770589 -81.89986209999998 2021-10-24 04:21:22 Medina, Ohio, US
34774 34774 2021-10-23 US Ohio Meigs 39105 2658 51 0   39.09224872 -82.0305041 2021-10-24 04:21:22 Meigs, Ohio, US
34775 34775 2021-10-23 US Ohio Mercer 39107 6164 93 0   40.54043046 -84.62912742 2021-10-24 04:21:22 Mercer, Ohio, US
34776 34776 2021-10-23 US Ohio Miami 39109 15582 306 0   40.0543329 -84.22871271 2021-10-24 04:21:22 Miami, Ohio, US
34777 34777 2021-10-23 US Ohio Monroe 39111 2162 54 0   39.72984936 -81.08464734 2021-10-24 04:21:22 Monroe, Ohio, US
34778 34778 2021-10-23 US Ohio Montgomery 39113 74066 1279 0   39.75394919 -84.29050975 2021-10-24 04:21:22 Montgomery, Ohio, US
34779 34779 2021-10-23 US Ohio Morgan 39115 1940 33 0   39.62081738 -81.85308173 2021-10-24 04:21:22 Morgan, Ohio, US
34780 34780 2021-10-23 US Ohio Morrow 39117 4588 58 0   40.52363560000001 -82.7892599 2021-10-24 04:21:22 Morrow, Ohio, US
34781 34781 2021-10-23 US Ohio Muskingum 39119 14831 185 0   39.96575964 -81.94363275 2021-10-24 04:21:22 Muskingum, Ohio, US
34782 34782 2021-10-23 US Ohio Noble 39121 2003 47 0   39.76818851 -81.45937183 2021-10-24 04:21:22 Noble, Ohio, US
34783 34783 2021-10-23 US Ohio Ottawa 39123 4885 86 0   41.53781826 -83.0940185 2021-10-24 04:21:22 Ottawa, Ohio, US
34784 34784 2021-10-23 US Ohio Paulding 39125 2803 47 0   41.11676341 -84.5801017 2021-10-24 04:21:22 Paulding, Ohio, US
34785 34785 2021-10-23 US Ohio Perry 39127 5183 63 0   39.73508655 -82.23804971 2021-10-24 04:21:22 Perry, Ohio, US
34786 34786 2021-10-23 US Ohio Pickaway 39129 11373 142 0   39.64170392 -83.0243386 2021-10-24 04:21:22 Pickaway, Ohio, US
34787 34787 2021-10-23 US Ohio Pike 39131 4343 67 0   39.07634001 -83.06769584 2021-10-24 04:21:22 Pike, Ohio, US
34788 34788 2021-10-23 US Ohio Portage 39133 17978 252 0   41.16793482 -81.19735782 2021-10-24 04:21:22 Portage, Ohio, US
34789 34789 2021-10-23 US Ohio Preble 39135 5720 125 0   39.7420247 -84.64787018 2021-10-24 04:21:22 Preble, Ohio, US
34790 34790 2021-10-23 US Ohio Putnam 39137 5335 110 0   41.02094889 -84.1336111 2021-10-24 04:21:22 Putnam, Ohio, US
34791 34791 2021-10-23 US Ohio Richland 39139 18586 292 0   40.77180308 -82.53799609999999 2021-10-24 04:21:22 Richland, Ohio, US
34792 34792 2021-10-23 US Ohio Ross 39141 10586 203 0   39.33705391 -83.06000914 2021-10-24 04:21:22 Ross, Ohio, US
34793 34793 2021-10-23 US Ohio Sandusky 39143 7827 151 0   41.35624126 -83.137872 2021-10-24 04:21:22 Sandusky, Ohio, US
34794 34794 2021-10-23 US Ohio Scioto 39145 11469 162 0   38.80270163 -82.98907345 2021-10-24 04:21:22 Scioto, Ohio, US
34795 34795 2021-10-23 US Ohio Seneca 39147 7372 145 0   41.12351311 -83.12783209 2021-10-24 04:21:22 Seneca, Ohio, US
34796 34796 2021-10-23 US Ohio Shelby 39149 6530 115 0   40.33163494 -84.20258189 2021-10-24 04:21:22 Shelby, Ohio, US
34797 34797 2021-10-23 US Ohio Stark 39151 46681 1064 0   40.81482476 -81.36437305 2021-10-24 04:21:22 Stark, Ohio, US
34798 34798 2021-10-23 US Ohio Summit 39153 61784 1111 0   41.12464734 -81.53123079 2021-10-24 04:21:22 Summit, Ohio, US
34799 34799 2021-10-23 US Ohio Trumbull 39155 22885 561 0   41.31735028 -80.76109643 2021-10-24 04:21:22 Trumbull, Ohio, US
34800 34800 2021-10-23 US Ohio Tuscarawas 39157 12724 311 0   40.44214695 -81.47226262 2021-10-24 04:21:22 Tuscarawas, Ohio, US
34801 34801 2021-10-23 US Ohio Unassigned 90039 0 5 0   41.70860332 -84.64787018 2021-10-24 04:21:22 Unassigned, Ohio, US
34802 34802 2021-10-23 US Ohio Union 39159 8198 59 0   40.30016061 -83.37239023 2021-10-24 04:21:22 Union, Ohio, US
34803 34803 2021-10-23 US Ohio Van Wert 39161 3723 82 0   40.8554138 -84.59111700000003 2021-10-24 04:21:22 Van Wert, Ohio, US
34804 34804 2021-10-23 US Ohio Vinton 39163 1666 25 0   39.25208988 -82.4831444 2021-10-24 04:21:22 Vinton, Ohio, US
34805 34805 2021-10-23 US Ohio Warren 39165 32836 377 0   39.42581994 -84.16557457 2021-10-24 04:21:22 Warren, Ohio, US
34806 34806 2021-10-23 US Ohio Washington 39167 8093 144 0   39.45690571 -81.49121382 2021-10-24 04:21:22 Washington, Ohio, US
34807 34807 2021-10-23 US Ohio Wayne 39169 13791 271 0   40.82925852 -81.88844833 2021-10-24 04:21:22 Wayne, Ohio, US
34808 34808 2021-10-23 US Ohio Williams 39171 5292 88 0   41.56052014 -84.58429552 2021-10-24 04:21:22 Williams, Ohio, US
34809 34809 2021-10-23 US Ohio Wood 39173 17454 224 0   41.36224827 -83.62285108 2021-10-24 04:21:22 Wood, Ohio, US
34810 34810 2021-10-23 US Ohio Wyandot 39175 3246 62 0   40.84339621 -83.30734173 2021-10-24 04:21:22 Wyandot, Ohio, US
315206 315206 2021-10-22 US Ohio Adams 39001 4166 95 0   38.84541072 -83.4718964 2021-10-23 04:21:32 Adams, Ohio, US
315207 315207 2021-10-22 US Ohio Allen 39003 15967 279 0   40.77285242 -84.10802343 2021-10-23 04:21:32 Allen, Ohio, US
315208 315208 2021-10-22 US Ohio Ashland 39005 6945 130 0   40.84772277 -82.27280781 2021-10-23 04:21:32 Ashland, Ohio, US
315209 315209 2021-10-22 US Ohio Ashtabula 39007 9701 204 0   41.70860332 -80.74830218 2021-10-23 04:21:32 Ashtabula, Ohio, US
315210 315210 2021-10-22 US Ohio Athens 39009 7761 79 0   39.33425634 -82.04278644 2021-10-23 04:21:32 Athens, Ohio, US
315211 315211 2021-10-22 US Ohio Auglaize 39011 6786 99 0   40.55998859 -84.22421429999999 2021-10-23 04:21:32 Auglaize, Ohio, US
315212 315212 2021-10-22 US Ohio Belmont 39013 9287 209 0   40.01625942 -80.9924051 2021-10-23 04:21:32 Belmont, Ohio, US
315213 315213 2021-10-22 US Ohio Brown 39015 6352 91 0   38.93416837 -83.86788395 2021-10-23 04:21:32 Brown, Ohio, US
315214 315214 2021-10-22 US Ohio Butler 39017 51500 718 0   39.44012838 -84.57388716 2021-10-23 04:21:32 Butler, Ohio, US
315215 315215 2021-10-22 US Ohio Carroll 39019 3017 65 0   40.578968599999996 -81.09178213 2021-10-23 04:21:32 Carroll, Ohio, US
315216 315216 2021-10-22 US Ohio Champaign 39021 5115 73 0   40.13923427 -83.76875242 2021-10-23 04:21:32 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]);