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

89 rows where "last_update" is on date 2021-11-01 and province_or_state = "Ohio" sorted by day descending

✎ View and edit SQL

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

province_or_state 1

  • Ohio · 89 ✖

country_or_region 1

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
290435 290435 2021-10-31 US Ohio Adams 39001 4237 107 0   38.84541072 -83.4718964 2021-11-01 04:22:01 Adams, Ohio, US
290436 290436 2021-10-31 US Ohio Allen 39003 16394 316 0   40.77285242 -84.10802343 2021-11-01 04:22:01 Allen, Ohio, US
290437 290437 2021-10-31 US Ohio Ashland 39005 7122 148 0   40.84772277 -82.27280781 2021-11-01 04:22:01 Ashland, Ohio, US
290438 290438 2021-10-31 US Ohio Ashtabula 39007 10121 224 0   41.70860332 -80.74830218 2021-11-01 04:22:01 Ashtabula, Ohio, US
290439 290439 2021-10-31 US Ohio Athens 39009 7882 94 0   39.33425634 -82.04278644 2021-11-01 04:22:01 Athens, Ohio, US
290440 290440 2021-10-31 US Ohio Auglaize 39011 6940 110 0   40.55998859 -84.22421429999999 2021-11-01 04:22:01 Auglaize, Ohio, US
290441 290441 2021-10-31 US Ohio Belmont 39013 9442 234 0   40.01625942 -80.9924051 2021-11-01 04:22:01 Belmont, Ohio, US
290442 290442 2021-10-31 US Ohio Brown 39015 6503 107 0   38.93416837 -83.86788395 2021-11-01 04:22:01 Brown, Ohio, US
290443 290443 2021-10-31 US Ohio Butler 39017 52295 790 0   39.44012838 -84.57388716 2021-11-01 04:22:01 Butler, Ohio, US
290444 290444 2021-10-31 US Ohio Carroll 39019 3099 75 0   40.578968599999996 -81.09178213 2021-11-01 04:22:01 Carroll, Ohio, US
290445 290445 2021-10-31 US Ohio Champaign 39021 5236 83 0   40.13923427 -83.76875242 2021-11-01 04:22:01 Champaign, Ohio, US
290446 290446 2021-10-31 US Ohio Clark 39023 20185 376 0   39.91592258 -83.78498252 2021-11-01 04:22:01 Clark, Ohio, US
290447 290447 2021-10-31 US Ohio Clermont 39025 28547 350 0   39.04847534 -84.15375786 2021-11-01 04:22:01 Clermont, Ohio, US
290448 290448 2021-10-31 US Ohio Clinton 39027 5916 109 0   39.41485808 -83.80852286 2021-11-01 04:22:01 Clinton, Ohio, US
290449 290449 2021-10-31 US Ohio Columbiana 39029 14492 321 0   40.76932373 -80.78094576 2021-11-01 04:22:01 Columbiana, Ohio, US
290450 290450 2021-10-31 US Ohio Coshocton 39031 4986 100 0   40.30096166 -81.91729018 2021-11-01 04:22:01 Coshocton, Ohio, US
290451 290451 2021-10-31 US Ohio Crawford 39033 6399 146 0   40.85065156 -82.91989099 2021-11-01 04:22:01 Crawford, Ohio, US
290452 290452 2021-10-31 US Ohio Cuyahoga 39035 148751 2623 0   41.424119 -81.65918339 2021-11-01 04:22:01 Cuyahoga, Ohio, US
290453 290453 2021-10-31 US Ohio Darke 39037 7784 174 0   40.13412966 -84.6194517 2021-11-01 04:22:01 Darke, Ohio, US
290454 290454 2021-10-31 US Ohio Defiance 39039 6379 113 0   41.32398837 -84.49076944 2021-11-01 04:22:01 Defiance, Ohio, US
290455 290455 2021-10-31 US Ohio Delaware 39041 24542 180 0   40.27942393 -83.00457058 2021-11-01 04:22:01 Delaware, Ohio, US
290456 290456 2021-10-31 US Ohio Erie 39043 11195 194 0   41.36796058 -82.62904521 2021-11-01 04:22:01 Erie, Ohio, US
290457 290457 2021-10-31 US Ohio Fairfield 39045 22682 282 0   39.75107189 -82.63088163 2021-11-01 04:22:01 Fairfield, Ohio, US
290458 290458 2021-10-31 US Ohio Fayette 39047 4362 69 0   39.56021306 -83.4562016 2021-11-01 04:22:01 Fayette, Ohio, US
290459 290459 2021-10-31 US Ohio Franklin 39049 166294 1833 0   39.96995815 -83.01115755 2021-11-01 04:22:01 Franklin, Ohio, US
290460 290460 2021-10-31 US Ohio Fulton 39051 6150 108 0   41.60213491 -84.12571393 2021-11-01 04:22:01 Fulton, Ohio, US
290461 290461 2021-10-31 US Ohio Gallia 39053 4274 78 0   38.82708533 -82.31647569 2021-11-01 04:22:01 Gallia, Ohio, US
290462 290462 2021-10-31 US Ohio Geauga 39055 9179 171 0   41.49952319 -81.17935342 2021-11-01 04:22:01 Geauga, Ohio, US
290463 290463 2021-10-31 US Ohio Greene 39057 22688 359 0   39.69116283 -83.89032084 2021-11-01 04:22:01 Greene, Ohio, US
290464 290464 2021-10-31 US Ohio Guernsey 39059 6154 81 0   40.05026529 -81.49248905 2021-11-01 04:22:01 Guernsey, Ohio, US
290465 290465 2021-10-31 US Ohio Hamilton 39061 106518 1524 0   39.19673558 -84.54502924 2021-11-01 04:22:01 Hamilton, Ohio, US
290466 290466 2021-10-31 US Ohio Hancock 39063 9915 169 0   41.00250487 -83.66838948 2021-11-01 04:22:01 Hancock, Ohio, US
290467 290467 2021-10-31 US Ohio Hardin 39065 4285 96 0   40.66015414 -83.65929931 2021-11-01 04:22:01 Hardin, Ohio, US
290468 290468 2021-10-31 US Ohio Harrison 39067 1855 52 0   40.29380509 -81.09068544 2021-11-01 04:22:01 Harrison, Ohio, US
290469 290469 2021-10-31 US Ohio Henry 39069 3751 75 0   41.333964200000004 -84.06830637 2021-11-01 04:22:01 Henry, Ohio, US
290470 290470 2021-10-31 US Ohio Highland 39071 6114 114 0   39.1839264 -83.60331456 2021-11-01 04:22:01 Highland, Ohio, US
290471 290471 2021-10-31 US Ohio Hocking 39073 3623 91 0   39.49537927 -82.47991446 2021-11-01 04:22:01 Hocking, Ohio, US
290472 290472 2021-10-31 US Ohio Holmes 39075 3711 137 0   40.56163713 -81.92635677 2021-11-01 04:22:01 Holmes, Ohio, US
290473 290473 2021-10-31 US Ohio Huron 39077 8633 152 0   41.14651175 -82.59867951 2021-11-01 04:22:01 Huron, Ohio, US
290474 290474 2021-10-31 US Ohio Jackson 39079 5238 93 0   39.01914254 -82.61818559999998 2021-11-01 04:22:01 Jackson, Ohio, US
290475 290475 2021-10-31 US Ohio Jefferson 39081 8760 225 0   40.38614126 -80.76259514 2021-11-01 04:22:01 Jefferson, Ohio, US
290476 290476 2021-10-31 US Ohio Knox 39083 7932 163 0   40.39830217 -82.42027563 2021-11-01 04:22:01 Knox, Ohio, US
290477 290477 2021-10-31 US Ohio Lake 39085 27647 477 0   41.69710807 -81.23676539 2021-11-01 04:22:01 Lake, Ohio, US
290478 290478 2021-10-31 US Ohio Lawrence 39087 9904 177 0   38.59743452 -82.53466552 2021-11-01 04:22:01 Lawrence, Ohio, US
290479 290479 2021-10-31 US Ohio Licking 39089 24398 317 0   40.09136236 -82.48185785 2021-11-01 04:22:01 Licking, Ohio, US
290480 290480 2021-10-31 US Ohio Logan 39091 6091 107 0   40.38996525 -83.76784341 2021-11-01 04:22:01 Logan, Ohio, US
290481 290481 2021-10-31 US Ohio Lorain 39093 36386 629 0   41.29553751 -82.15083537 2021-11-01 04:22:01 Lorain, Ohio, US
290482 290482 2021-10-31 US Ohio Lucas 39095 57283 1010 0   41.62101218 -83.65468618 2021-11-01 04:22:01 Lucas, Ohio, US
290483 290483 2021-10-31 US Ohio Madison 39097 6016 86 0   39.89381073 -83.40178317 2021-11-01 04:22:01 Madison, Ohio, US
290484 290484 2021-10-31 US Ohio Mahoning 39099 31383 757 0   41.01631101 -80.77287029 2021-11-01 04:22:01 Mahoning, Ohio, US
290485 290485 2021-10-31 US Ohio Marion 39101 12165 190 0   40.58610662 -83.15736305 2021-11-01 04:22:01 Marion, Ohio, US
290486 290486 2021-10-31 US Ohio Medina 39103 22497 340 0   41.11770589 -81.89986209999998 2021-11-01 04:22:01 Medina, Ohio, US
290487 290487 2021-10-31 US Ohio Meigs 39105 2729 58 0   39.09224872 -82.0305041 2021-11-01 04:22:01 Meigs, Ohio, US
290488 290488 2021-10-31 US Ohio Mercer 39107 6256 98 0   40.54043046 -84.62912742 2021-11-01 04:22:01 Mercer, Ohio, US
290489 290489 2021-10-31 US Ohio Miami 39109 15887 332 0   40.0543329 -84.22871271 2021-11-01 04:22:01 Miami, Ohio, US
290490 290490 2021-10-31 US Ohio Monroe 39111 2186 60 0   39.72984936 -81.08464734 2021-11-01 04:22:01 Monroe, Ohio, US
290491 290491 2021-10-31 US Ohio Montgomery 39113 75145 1362 0   39.75394919 -84.29050975 2021-11-01 04:22:01 Montgomery, Ohio, US
290492 290492 2021-10-31 US Ohio Morgan 39115 1957 37 0   39.62081738 -81.85308173 2021-11-01 04:22:01 Morgan, Ohio, US
290493 290493 2021-10-31 US Ohio Morrow 39117 4691 61 0   40.52363560000001 -82.7892599 2021-11-01 04:22:01 Morrow, Ohio, US
290494 290494 2021-10-31 US Ohio Muskingum 39119 15182 199 0   39.96575964 -81.94363275 2021-11-01 04:22:01 Muskingum, Ohio, US
290495 290495 2021-10-31 US Ohio Noble 39121 2043 47 0   39.76818851 -81.45937183 2021-11-01 04:22:01 Noble, Ohio, US
290496 290496 2021-10-31 US Ohio Ottawa 39123 4996 97 0   41.53781826 -83.0940185 2021-11-01 04:22:01 Ottawa, Ohio, US
290497 290497 2021-10-31 US Ohio Paulding 39125 2869 48 0   41.11676341 -84.5801017 2021-11-01 04:22:01 Paulding, Ohio, US
290498 290498 2021-10-31 US Ohio Perry 39127 5267 80 0   39.73508655 -82.23804971 2021-11-01 04:22:01 Perry, Ohio, US
290499 290499 2021-10-31 US Ohio Pickaway 39129 11465 152 0   39.64170392 -83.0243386 2021-11-01 04:22:01 Pickaway, Ohio, US
290500 290500 2021-10-31 US Ohio Pike 39131 4389 77 0   39.07634001 -83.06769584 2021-11-01 04:22:01 Pike, Ohio, US
290501 290501 2021-10-31 US Ohio Portage 39133 18382 280 0   41.16793482 -81.19735782 2021-11-01 04:22:01 Portage, Ohio, US
290502 290502 2021-10-31 US Ohio Preble 39135 5804 138 0   39.7420247 -84.64787018 2021-11-01 04:22:01 Preble, Ohio, US
290503 290503 2021-10-31 US Ohio Putnam 39137 5445 116 0   41.02094889 -84.1336111 2021-11-01 04:22:01 Putnam, Ohio, US
290504 290504 2021-10-31 US Ohio Richland 39139 18935 325 0   40.77180308 -82.53799609999999 2021-11-01 04:22:01 Richland, Ohio, US
290505 290505 2021-10-31 US Ohio Ross 39141 10742 220 0   39.33705391 -83.06000914 2021-11-01 04:22:01 Ross, Ohio, US
290506 290506 2021-10-31 US Ohio Sandusky 39143 8025 166 0   41.35624126 -83.137872 2021-11-01 04:22:01 Sandusky, Ohio, US
290507 290507 2021-10-31 US Ohio Scioto 39145 11608 182 0   38.80270163 -82.98907345 2021-11-01 04:22:01 Scioto, Ohio, US
290508 290508 2021-10-31 US Ohio Seneca 39147 7611 154 0   41.12351311 -83.12783209 2021-11-01 04:22:01 Seneca, Ohio, US
290509 290509 2021-10-31 US Ohio Shelby 39149 6657 130 0   40.33163494 -84.20258189 2021-11-01 04:22:01 Shelby, Ohio, US
290510 290510 2021-10-31 US Ohio Stark 39151 47531 1156 0   40.81482476 -81.36437305 2021-11-01 04:22:01 Stark, Ohio, US
290511 290511 2021-10-31 US Ohio Summit 39153 62887 1181 0   41.12464734 -81.53123079 2021-11-01 04:22:01 Summit, Ohio, US
290512 290512 2021-10-31 US Ohio Trumbull 39155 23454 605 0   41.31735028 -80.76109643 2021-11-01 04:22:01 Trumbull, Ohio, US
290513 290513 2021-10-31 US Ohio Tuscarawas 39157 12971 345 0   40.44214695 -81.47226262 2021-11-01 04:22:01 Tuscarawas, Ohio, US
290514 290514 2021-10-31 US Ohio Unassigned 90039 0 3 0   41.70860332 -84.64787018 2021-11-01 04:22:01 Unassigned, Ohio, US
290515 290515 2021-10-31 US Ohio Union 39159 8374 68 0   40.30016061 -83.37239023 2021-11-01 04:22:01 Union, Ohio, US
290516 290516 2021-10-31 US Ohio Van Wert 39161 3866 89 0   40.8554138 -84.59111700000003 2021-11-01 04:22:01 Van Wert, Ohio, US
290517 290517 2021-10-31 US Ohio Vinton 39163 1691 31 0   39.25208988 -82.4831444 2021-11-01 04:22:01 Vinton, Ohio, US
290518 290518 2021-10-31 US Ohio Warren 39165 33209 405 0   39.42581994 -84.16557457 2021-11-01 04:22:01 Warren, Ohio, US
290519 290519 2021-10-31 US Ohio Washington 39167 8182 158 0   39.45690571 -81.49121382 2021-11-01 04:22:01 Washington, Ohio, US
290520 290520 2021-10-31 US Ohio Wayne 39169 14048 297 0   40.82925852 -81.88844833 2021-11-01 04:22:01 Wayne, Ohio, US
290521 290521 2021-10-31 US Ohio Williams 39171 5431 96 0   41.56052014 -84.58429552 2021-11-01 04:22:01 Williams, Ohio, US
290522 290522 2021-10-31 US Ohio Wood 39173 17774 240 0   41.36224827 -83.62285108 2021-11-01 04:22:01 Wood, Ohio, US
290523 290523 2021-10-31 US Ohio Wyandot 39175 3303 71 0   40.84339621 -83.30734173 2021-11-01 04:22:01 Wyandot, Ohio, US

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]);