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

30,931 rows where province_or_state = "Ohio" sorted by day descending

✎ View and edit SQL

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

province_or_state

  • Ohio · 30,931 ✖

country_or_region

  • US 30,931
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
955753 955753 2021-03-05 US Ohio Adams 39001 2181 39 0 2142 38.84541072 -83.4718964 2021-03-06 04:23:41 Adams, Ohio, US
955754 955754 2021-03-05 US Ohio Allen 39003 10815 216 0 10599 40.77285242 -84.10802343 2021-03-06 04:23:41 Allen, Ohio, US
955755 955755 2021-03-05 US Ohio Ashland 39005 3819 83 0 3736 40.84772277 -82.27280781 2021-03-06 04:23:41 Ashland, Ohio, US
955756 955756 2021-03-05 US Ohio Ashtabula 39007 5998 154 0 5844 41.70860332 -80.74830218 2021-03-06 04:23:41 Ashtabula, Ohio, US
955757 955757 2021-03-05 US Ohio Athens 39009 4658 49 0 4609 39.33425634 -82.04278644 2021-03-06 04:23:41 Athens, Ohio, US
955758 955758 2021-03-05 US Ohio Auglaize 39011 4566 82 0 4484 40.55998859 -84.22421429999999 2021-03-06 04:23:41 Auglaize, Ohio, US
955759 955759 2021-03-05 US Ohio Belmont 39013 4990 137 0 4853 40.01625942 -80.9924051 2021-03-06 04:23:41 Belmont, Ohio, US
955760 955760 2021-03-05 US Ohio Brown 39015 3743 52 0 3691 38.93416837 -83.86788395 2021-03-06 04:23:41 Brown, Ohio, US
955761 955761 2021-03-05 US Ohio Butler 39017 35750 531 0 35219 39.44012838 -84.57388716 2021-03-06 04:23:41 Butler, Ohio, US
955762 955762 2021-03-05 US Ohio Carroll 39019 1817 43 0 1774 40.5789686 -81.09178213 2021-03-06 04:23:41 Carroll, Ohio, US
955763 955763 2021-03-05 US Ohio Champaign 39021 2901 49 0 2852 40.13923427 -83.76875242 2021-03-06 04:23:41 Champaign, Ohio, US
955764 955764 2021-03-05 US Ohio Clark 39023 12352 256 0 12096 39.91592258 -83.78498252 2021-03-06 04:23:41 Clark, Ohio, US
955765 955765 2021-03-05 US Ohio Clermont 39025 18484 205 0 18279 39.04847534 -84.15375786 2021-03-06 04:23:41 Clermont, Ohio, US
955766 955766 2021-03-05 US Ohio Clinton 39027 3420 55 0 3365 39.41485808 -83.80852286 2021-03-06 04:23:41 Clinton, Ohio, US
955767 955767 2021-03-05 US Ohio Columbiana 39029 8165 210 0 7955 40.76932373 -80.78094576 2021-03-06 04:23:41 Columbiana, Ohio, US
955768 955768 2021-03-05 US Ohio Coshocton 39031 2400 56 0 2344 40.30096166 -81.91729018 2021-03-06 04:23:41 Coshocton, Ohio, US
955769 955769 2021-03-05 US Ohio Crawford 39033 3595 98 0 3497 40.85065156 -82.91989099 2021-03-06 04:23:41 Crawford, Ohio, US
955770 955770 2021-03-05 US Ohio Cuyahoga 39035 96670 1881 0 94789 41.424119 -81.65918339 2021-03-06 04:23:41 Cuyahoga, Ohio, US
955771 955771 2021-03-05 US Ohio Darke 39037 5046 116 0 4930 40.13412966 -84.6194517 2021-03-06 04:23:41 Darke, Ohio, US
955772 955772 2021-03-05 US Ohio Defiance 39039 3735 88 0 3647 41.32398837 -84.49076944 2021-03-06 04:23:41 Defiance, Ohio, US
955773 955773 2021-03-05 US Ohio Delaware 39041 16576 121 0 16455 40.27942393 -83.00457058 2021-03-06 04:23:41 Delaware, Ohio, US
955774 955774 2021-03-05 US Ohio Erie 39043 6948 146 0 6802 41.36796058 -82.62904521 2021-03-06 04:23:41 Erie, Ohio, US
955775 955775 2021-03-05 US Ohio Fairfield 39045 14622 188 0 14434 39.75107189 -82.63088163 2021-03-06 04:23:41 Fairfield, Ohio, US
955776 955776 2021-03-05 US Ohio Fayette 39047 2698 43 0 2655 39.56021306 -83.4562016 2021-03-06 04:23:41 Fayette, Ohio, US
955777 955777 2021-03-05 US Ohio Franklin 39049 112797 1251 0 111546 39.96995815 -83.01115755 2021-03-06 04:23:41 Franklin, Ohio, US
955778 955778 2021-03-05 US Ohio Fulton 39051 3825 61 0 3764 41.60213491 -84.12571393 2021-03-06 04:23:41 Fulton, Ohio, US
955779 955779 2021-03-05 US Ohio Gallia 39053 2235 38 0 2197 38.82708533 -82.31647569 2021-03-06 04:23:41 Gallia, Ohio, US
955780 955780 2021-03-05 US Ohio Geauga 39055 6105 142 0 5963 41.49952319 -81.17935342 2021-03-06 04:23:41 Geauga, Ohio, US
955781 955781 2021-03-05 US Ohio Greene 39057 13636 221 0 13415 39.69116283 -83.89032084 2021-03-06 04:23:41 Greene, Ohio, US
955782 955782 2021-03-05 US Ohio Guernsey 39059 2887 45 0 2842 40.05026529 -81.49248905 2021-03-06 04:23:41 Guernsey, Ohio, US
955783 955783 2021-03-05 US Ohio Hamilton 39061 73798 1067 0 72731 39.19673558 -84.54502924 2021-03-06 04:23:41 Hamilton, Ohio, US
955784 955784 2021-03-05 US Ohio Hancock 39063 6021 121 0 5900 41.00250487 -83.66838948 2021-03-06 04:23:41 Hancock, Ohio, US
955785 955785 2021-03-05 US Ohio Hardin 39065 2468 59 0 2409 40.66015414 -83.65929931 2021-03-06 04:23:41 Hardin, Ohio, US
955786 955786 2021-03-05 US Ohio Harrison 39067 1007 31 0 976 40.29380509 -81.09068544 2021-03-06 04:23:41 Harrison, Ohio, US
955787 955787 2021-03-05 US Ohio Henry 39069 2473 61 0 2412 41.3339642 -84.06830637 2021-03-06 04:23:41 Henry, Ohio, US
955788 955788 2021-03-05 US Ohio Highland 39071 3284 51 0 3233 39.1839264 -83.60331456 2021-03-06 04:23:41 Highland, Ohio, US
955789 955789 2021-03-05 US Ohio Hocking 39073 1949 54 0 1895 39.49537927 -82.47991446 2021-03-06 04:23:41 Hocking, Ohio, US
955790 955790 2021-03-05 US Ohio Holmes 39075 2440 97 0 2343 40.56163713 -81.92635677 2021-03-06 04:23:41 Holmes, Ohio, US
955791 955791 2021-03-05 US Ohio Huron 39077 4848 108 0 4740 41.14651175 -82.59867951 2021-03-06 04:23:41 Huron, Ohio, US
955792 955792 2021-03-05 US Ohio Jackson 39079 2912 46 0 2866 39.01914254 -82.61818559999998 2021-03-06 04:23:41 Jackson, Ohio, US
955793 955793 2021-03-05 US Ohio Jefferson 39081 4831 137 0 4694 40.38614126 -80.76259514 2021-03-06 04:23:41 Jefferson, Ohio, US
955794 955794 2021-03-05 US Ohio Knox 39083 4053 105 0 3948 40.39830217 -82.42027563 2021-03-06 04:23:41 Knox, Ohio, US
955795 955795 2021-03-05 US Ohio Lake 39085 18509 332 0 18177 41.69710807 -81.23676539 2021-03-06 04:23:41 Lake, Ohio, US
955796 955796 2021-03-05 US Ohio Lawrence 39087 5271 86 0 5185 38.59743452 -82.53466552 2021-03-06 04:23:41 Lawrence, Ohio, US
955797 955797 2021-03-05 US Ohio Licking 39089 15063 194 0 14869 40.09136236 -82.48185785 2021-03-06 04:23:41 Licking, Ohio, US
955798 955798 2021-03-05 US Ohio Logan 39091 3569 73 0 3496 40.38996525 -83.76784341 2021-03-06 04:23:41 Logan, Ohio, US
955799 955799 2021-03-05 US Ohio Lorain 39093 22149 424 0 21725 41.29553751 -82.15083537 2021-03-06 04:23:41 Lorain, Ohio, US
955800 955800 2021-03-05 US Ohio Lucas 39095 35685 720 0 34965 41.62101218 -83.65468618 2021-03-06 04:23:41 Lucas, Ohio, US
955801 955801 2021-03-05 US Ohio Madison 39097 3947 55 0 3892 39.89381073 -83.40178317 2021-03-06 04:23:41 Madison, Ohio, US
955802 955802 2021-03-05 US Ohio Mahoning 39099 19556 551 0 19005 41.01631101 -80.77287029 2021-03-06 04:23:41 Mahoning, Ohio, US
955803 955803 2021-03-05 US Ohio Marion 39101 8015 127 0 7888 40.58610662 -83.15736305 2021-03-06 04:23:41 Marion, Ohio, US
955804 955804 2021-03-05 US Ohio Medina 39103 13484 237 0 13247 41.11770589 -81.89986209999998 2021-03-06 04:23:41 Medina, Ohio, US
955805 955805 2021-03-05 US Ohio Meigs 39105 1360 31 0 1329 39.09224872 -82.0305041 2021-03-06 04:23:41 Meigs, Ohio, US
955806 955806 2021-03-05 US Ohio Mercer 39107 4591 81 0 4510 40.54043046 -84.62912742 2021-03-06 04:23:41 Mercer, Ohio, US
955807 955807 2021-03-05 US Ohio Miami 39109 10055 194 0 9861 40.0543329 -84.22871271 2021-03-06 04:23:41 Miami, Ohio, US
955808 955808 2021-03-05 US Ohio Monroe 39111 1171 37 0 1134 39.72984936 -81.08464734 2021-03-06 04:23:41 Monroe, Ohio, US
955809 955809 2021-03-05 US Ohio Montgomery 39113 47453 923 0 46530 39.75394919 -84.29050975 2021-03-06 04:23:41 Montgomery, Ohio, US
955810 955810 2021-03-05 US Ohio Morgan 39115 1016 20 0 996 39.62081738 -81.85308173 2021-03-06 04:23:41 Morgan, Ohio, US
955811 955811 2021-03-05 US Ohio Morrow 39117 2611 37 0 2574 40.52363560000001 -82.7892599 2021-03-06 04:23:41 Morrow, Ohio, US
955812 955812 2021-03-05 US Ohio Muskingum 39119 8224 117 0 8107 39.96575964 -81.94363275 2021-03-06 04:23:41 Muskingum, Ohio, US
955813 955813 2021-03-05 US Ohio Noble 39121 1292 33 0 1259 39.76818851 -81.45937183 2021-03-06 04:23:41 Noble, Ohio, US
955814 955814 2021-03-05 US Ohio Ottawa 39123 3251 71 0 3180 41.53781826 -83.0940185 2021-03-06 04:23:41 Ottawa, Ohio, US
955815 955815 2021-03-05 US Ohio Paulding 39125 1608 34 0 1574 41.11676341 -84.5801017 2021-03-06 04:23:41 Paulding, Ohio, US
955816 955816 2021-03-05 US Ohio Perry 39127 2707 48 0 2659 39.73508655 -82.23804971 2021-03-06 04:23:41 Perry, Ohio, US
955817 955817 2021-03-05 US Ohio Pickaway 39129 8085 111 0 7974 39.64170392 -83.0243386 2021-03-06 04:23:41 Pickaway, Ohio, US
955818 955818 2021-03-05 US Ohio Pike 39131 2167 28 0 2139 39.07634001 -83.06769584 2021-03-06 04:23:41 Pike, Ohio, US
955819 955819 2021-03-05 US Ohio Portage 39133 11104 172 0 10932 41.16793482 -81.19735782 2021-03-06 04:23:41 Portage, Ohio, US
955820 955820 2021-03-05 US Ohio Preble 39135 3538 87 0 3451 39.7420247 -84.64787018 2021-03-06 04:23:41 Preble, Ohio, US
955821 955821 2021-03-05 US Ohio Putnam 39137 4003 93 0 3910 41.02094889 -84.1336111 2021-03-06 04:23:41 Putnam, Ohio, US
955822 955822 2021-03-05 US Ohio Richland 39139 10360 188 0 10172 40.77180308 -82.53799609999999 2021-03-06 04:23:41 Richland, Ohio, US
955823 955823 2021-03-05 US Ohio Ross 39141 6170 132 0 6038 39.33705391 -83.06000914 2021-03-06 04:23:41 Ross, Ohio, US
955824 955824 2021-03-05 US Ohio Sandusky 39143 4791 112 0 4679 41.35624126 -83.137872 2021-03-06 04:23:41 Sandusky, Ohio, US
955825 955825 2021-03-05 US Ohio Scioto 39145 5991 88 0 5903 38.80270163 -82.98907345 2021-03-06 04:23:41 Scioto, Ohio, US
955826 955826 2021-03-05 US Ohio Seneca 39147 4720 111 0 4609 41.12351311 -83.12783209 2021-03-06 04:23:41 Seneca, Ohio, US
955827 955827 2021-03-05 US Ohio Shelby 39149 4425 79 0 4346 40.33163494 -84.20258189 2021-03-06 04:23:41 Shelby, Ohio, US
955828 955828 2021-03-05 US Ohio Stark 39151 29548 826 0 28722 40.81482476 -81.36437305 2021-03-06 04:23:41 Stark, Ohio, US
955829 955829 2021-03-05 US Ohio Summit 39153 40562 831 0 39731 41.12464734 -81.53123079 2021-03-06 04:23:41 Summit, Ohio, US
955830 955830 2021-03-05 US Ohio Trumbull 39155 14397 424 0 13973 41.31735028 -80.76109643 2021-03-06 04:23:41 Trumbull, Ohio, US
955831 955831 2021-03-05 US Ohio Tuscarawas 39157 8065 232 0 7833 40.44214695 -81.47226262 2021-03-06 04:23:41 Tuscarawas, Ohio, US
955832 955832 2021-03-05 US Ohio Unassigned 90039 0 0 0 0 41.70860332 -84.64787018 2021-03-06 04:23:41 Unassigned, Ohio, US
955833 955833 2021-03-05 US Ohio Union 39159 5156 41 0 5115 40.30016061 -83.37239023 2021-03-06 04:23:41 Union, Ohio, US
955834 955834 2021-03-05 US Ohio Van Wert 39161 2302 57 0 2245 40.8554138 -84.59111700000003 2021-03-06 04:23:41 Van Wert, Ohio, US
955835 955835 2021-03-05 US Ohio Vinton 39163 766 13 0 753 39.25208988 -82.4831444 2021-03-06 04:23:41 Vinton, Ohio, US
955836 955836 2021-03-05 US Ohio Warren 39165 22539 275 0 22264 39.42581994 -84.16557457 2021-03-06 04:23:41 Warren, Ohio, US
955837 955837 2021-03-05 US Ohio Washington 39167 4736 96 0 4640 39.45690571 -81.49121382 2021-03-06 04:23:41 Washington, Ohio, US
955838 955838 2021-03-05 US Ohio Wayne 39169 7915 199 0 7716 40.82925852 -81.88844833 2021-03-06 04:23:41 Wayne, Ohio, US
955839 955839 2021-03-05 US Ohio Williams 39171 3032 68 0 2964 41.56052014 -84.58429552 2021-03-06 04:23:41 Williams, Ohio, US
955840 955840 2021-03-05 US Ohio Wood 39173 11633 170 0 11463 41.36224827 -83.62285108 2021-03-06 04:23:41 Wood, Ohio, US
955841 955841 2021-03-05 US Ohio Wyandot 39175 2120 50 0 2070 40.84339621 -83.30734173 2021-03-06 04:23:41 Wyandot, Ohio, US
903113 903113 2021-03-04 US Ohio Adams 39001 2174 36 0 2138 38.84541072 -83.4718964 2021-03-05 05:26:29 Adams, Ohio, US
903114 903114 2021-03-04 US Ohio Allen 39003 10804 216 0 10588 40.77285242 -84.10802343 2021-03-05 05:26:29 Allen, Ohio, US
903115 903115 2021-03-04 US Ohio Ashland 39005 3813 81 0 3732 40.84772277 -82.27280781 2021-03-05 05:26:29 Ashland, Ohio, US
903116 903116 2021-03-04 US Ohio Ashtabula 39007 5993 152 0 5841 41.70860332 -80.74830218 2021-03-05 05:26:29 Ashtabula, Ohio, US
903117 903117 2021-03-04 US Ohio Athens 39009 4654 47 0 4607 39.33425634 -82.04278644 2021-03-05 05:26:29 Athens, Ohio, US
903118 903118 2021-03-04 US Ohio Auglaize 39011 4564 80 0 4484 40.55998859 -84.22421429999999 2021-03-05 05:26:29 Auglaize, Ohio, US
903119 903119 2021-03-04 US Ohio Belmont 39013 4976 59 0 4917 40.01625942 -80.9924051 2021-03-05 05:26:29 Belmont, Ohio, US
903120 903120 2021-03-04 US Ohio Brown 39015 3722 44 0 3678 38.93416837 -83.86788395 2021-03-05 05:26:29 Brown, Ohio, US
903121 903121 2021-03-04 US Ohio Butler 39017 35678 505 0 35173 39.44012838 -84.57388716 2021-03-05 05:26:29 Butler, Ohio, US
903122 903122 2021-03-04 US Ohio Carroll 39019 1816 41 0 1775 40.5789686 -81.09178213 2021-03-05 05:26:29 Carroll, Ohio, US
903123 903123 2021-03-04 US Ohio Champaign 39021 2892 49 0 2843 40.13923427 -83.76875242 2021-03-05 05:26: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]);