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

19 rows where confirmed = 334, country_or_region = "US" 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 · 19 ✖

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
3411895 3411895 2020-11-01 US Ohio Gallia 39053 334 11 0 323 38.82708533 -82.31647569 2020-11-02 05:25:04 Gallia, Ohio, US
2082384 2082384 2020-10-31 US Ohio Gallia 39053 334 11 0 323 38.82708533 -82.31647569 2020-11-01 04:36:19 Gallia, Ohio, US
3482801 3482801 2020-10-26 US Ohio Pike 39131 334 2 0 332 39.07634001 -83.06769584 2020-10-27 04:24:45 Pike, Ohio, US
81518 81518 2020-10-14 US Ohio Brown 39015 334 4 0 330 38.93416837 -83.86788395 2020-10-15 04:24:28 Brown, Ohio, US
2293929 2293929 2020-10-12 US Ohio Perry 39127 334 12 0 322 39.73508655 -82.23804971 2020-10-13 04:24:02 Perry, Ohio, US
819991 819991 2020-10-09 US Ohio Ashland 39005 334 5 0 329 40.84772277 -82.27280781 2020-10-10 04:23:57 Ashland, Ohio, US
820012 820012 2020-10-09 US Ohio Fayette 39047 334 4 0 330 39.56021306 -83.4562016 2020-10-10 04:23:57 Fayette, Ohio, US
1048257 1048257 2020-09-30 US Ohio Defiance 39039 334 10 0 324 41.32398837 -84.49076944 2020-10-01 04:23:42 Defiance, Ohio, US
1517850 1517850 2020-09-28 US Ohio Henry 39069 334 18 0 316 41.3339642 -84.06830637 2020-09-29 04:23:42 Henry, Ohio, US
1525673 1525673 2020-08-28 US Ohio Seneca 39147 334 13 0 321 41.12351311 -83.12783209 2020-08-29 04:28:19 Seneca, Ohio, US
1614702 1614702 2020-08-14 US Ohio Lawrence 39087 334 2 0 332 38.59743452 -82.53466552 2020-08-15 04:27:31 Lawrence, Ohio, US
1925012 1925012 2020-07-30 US Ohio Athens 39009 334 2 0 332 39.33425634 -82.04278644 2020-07-31 04:35:18 Athens, Ohio, US
175092 175092 2020-07-27 US Ohio Huron 39077 334 6 0 328 41.14651175 -82.59867951 2020-07-28 04:58:43 Huron, Ohio, US
3203745 3203745 2020-07-18 US Ohio Mercer 39107 334 11 0 323 40.54043046 -84.62912742 2020-07-19 04:34:58 Mercer, Ohio, US
3249051 3249051 2020-06-21 US Ohio Wood 39173 334 37 0 297 41.36224827 -83.62285108 2020-06-22 04:33:20 Wood, Ohio, US
1834823 1834823 2020-06-14 US Ohio Geauga 39055 334 34 0 300 41.49952319 -81.17935342 2020-06-15 03:33:14 Geauga, Ohio, US
215419 215419 2020-06-08 US Ohio Lake 39085 334 17 0 317 41.69710807 -81.23676539 2020-06-09 03:33:03 Lake, Ohio, US
3082044 3082044 2020-05-04 US Ohio Butler 39017 334 12 0 322 39.44012838 -84.57388716 2020-05-05 02:32:34 Butler, Ohio, US
3948678 3948678 2020-04-09 US Ohio Mahoning 39099 334 34 0 300 41.01631101 -80.77287029 2020-04-09 23:02:37 Mahoning, 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]);