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

28 rows where country_or_region = "Ukraine" and "last_update" is on date 2020-08-12 sorted by day descending

✎ View and edit SQL

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

country_or_region 1

  • Ukraine · 28 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
662634 662634 2020-08-11 Ukraine Cherkasy Oblast     1039 37 779 223 49.4444 32.0598 2020-08-12 04:27:29 Cherkasy Oblast, Ukraine
662635 662635 2020-08-11 Ukraine Chernihiv Oblast     1038 18 564 456 51.4982 31.2893 2020-08-12 04:27:29 Chernihiv Oblast, Ukraine
662636 662636 2020-08-11 Ukraine Chernivtsi Oblast     6867 230 5266 1371 48.2917 25.9352 2020-08-12 04:27:29 Chernivtsi Oblast, Ukraine
662637 662637 2020-08-11 Ukraine Crimea Republic*     1517 17 1063 437 45.2835 34.2008 2020-08-12 04:27:29 Crimea Republic*, Ukraine
662638 662638 2020-08-11 Ukraine Dnipropetrovsk Oblast     1571 35 1146 390 48.4647 35.0462 2020-08-12 04:27:29 Dnipropetrovsk Oblast, Ukraine
662639 662639 2020-08-11 Ukraine Donetsk Oblast     982 13 763 206 48.0159 37.8028 2020-08-12 04:27:29 Donetsk Oblast, Ukraine
662640 662640 2020-08-11 Ukraine Ivano-Frankivsk Oblast     5911 158 2286 3467 48.9226 24.7111 2020-08-12 04:27:29 Ivano-Frankivsk Oblast, Ukraine
662641 662641 2020-08-11 Ukraine Kharkiv Oblast     5030 146 2532 2352 49.9935 36.2304 2020-08-12 04:27:29 Kharkiv Oblast, Ukraine
662642 662642 2020-08-11 Ukraine Kherson Oblast     271 5 213 53 46.6354 32.6169 2020-08-12 04:27:29 Kherson Oblast, Ukraine
662643 662643 2020-08-11 Ukraine Khmelnytskyi Oblast     1376 30 1045 301 49.423 26.9871 2020-08-12 04:27:29 Khmelnytskyi Oblast, Ukraine
662644 662644 2020-08-11 Ukraine Kiev     9687 147 3247 6293 50.4501 30.5234 2020-08-12 04:27:29 Kiev, Ukraine
662645 662645 2020-08-11 Ukraine Kiev Oblast     4239 70 2970 1199 50.053 30.7667 2020-08-12 04:27:29 Kiev Oblast, Ukraine
662646 662646 2020-08-11 Ukraine Kirovohrad Oblast     725 39 653 33 48.5079 32.2623 2020-08-12 04:27:29 Kirovohrad Oblast, Ukraine
662647 662647 2020-08-11 Ukraine Luhansk Oblast     157 1 116 40 48.574 39.3078 2020-08-12 04:27:29 Luhansk Oblast, Ukraine
662648 662648 2020-08-11 Ukraine Lviv Oblast     11142 309 2949 7884 49.8397 24.0297 2020-08-12 04:27:29 Lviv Oblast, Ukraine
662649 662649 2020-08-11 Ukraine Mykolaiv Oblast     729 18 489 222 46.975 31.9946 2020-08-12 04:27:29 Mykolaiv Oblast, Ukraine
662650 662650 2020-08-11 Ukraine Odessa Oblast     4364 73 1442 2849 46.4846 30.7326 2020-08-12 04:27:29 Odessa Oblast, Ukraine
662651 662651 2020-08-11 Ukraine Poltava Oblast     503 15 358 130 49.5883 34.5514 2020-08-12 04:27:29 Poltava Oblast, Ukraine
662652 662652 2020-08-11 Ukraine Rivne Oblast     7018 105 5352 1561 50.6199 26.2516 2020-08-12 04:27:29 Rivne Oblast, Ukraine
662653 662653 2020-08-11 Ukraine Sevastopol*     391 11 316 64 44.6054 33.522 2020-08-12 04:27:29 Sevastopol*, Ukraine
662654 662654 2020-08-11 Ukraine Sumy Oblast     702 10 417 275 50.9077 34.7981 2020-08-12 04:27:29 Sumy Oblast, Ukraine
662655 662655 2020-08-11 Ukraine Ternopil Oblast     3375 44 2168 1163 49.5535 25.5948 2020-08-12 04:27:29 Ternopil Oblast, Ukraine
662656 662656 2020-08-11 Ukraine Vinnytsia Oblast     3002 63 2263 676 49.2331 28.4682 2020-08-12 04:27:29 Vinnytsia Oblast, Ukraine
662657 662657 2020-08-11 Ukraine Volyn Oblast     4375 94 3196 1085 50.7472 25.3254 2020-08-12 04:27:29 Volyn Oblast, Ukraine
662658 662658 2020-08-11 Ukraine Zakarpattia Oblast     5875 223 2508 3144 48.6208 22.2879 2020-08-12 04:27:29 Zakarpattia Oblast, Ukraine
662659 662659 2020-08-11 Ukraine Zaporizhia Oblast     959 22 659 278 47.8388 35.1396 2020-08-12 04:27:29 Zaporizhia Oblast, Ukraine
662660 662660 2020-08-11 Ukraine Zhytomyr Oblast     2178 46 1553 579 50.2547 28.6587 2020-08-12 04:27:29 Zhytomyr Oblast, Ukraine
665975 665975 2020-08-11 Ukraine Unknown     0 0 0 0     2020-08-12 04:27:29 Unknown, Ukraine

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