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 2021-05-27 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
1313785 1313785 2021-05-26 Ukraine Cherkasy Oblast     80198 1223 72311 6664 49.4444 32.0598 2021-05-27 04:20:59 Cherkasy Oblast, Ukraine
1313786 1313786 2021-05-26 Ukraine Chernihiv Oblast     56343 1296 52567 2480 51.4982 31.2893 2021-05-27 04:20:59 Chernihiv Oblast, Ukraine
1313787 1313787 2021-05-26 Ukraine Chernivtsi Oblast     78962 1754 75578 1630 48.2917 25.9352 2021-05-27 04:20:59 Chernivtsi Oblast, Ukraine
1313788 1313788 2021-05-26 Ukraine Crimea Republic*     43006 1331 40073 1602 45.2835 34.2008 2021-05-27 04:20:59 Crimea Republic*, Ukraine
1313789 1313789 2021-05-26 Ukraine Dnipropetrovsk Oblast     132298 4022 118878 9398 48.4647 35.0462 2021-05-27 04:20:59 Dnipropetrovsk Oblast, Ukraine
1313790 1313790 2021-05-26 Ukraine Donetsk Oblast     88666 2194 81364 5108 48.0159 37.8028 2021-05-27 04:20:59 Donetsk Oblast, Ukraine
1313791 1313791 2021-05-26 Ukraine Ivano-Frankivsk Oblast     85949 2049 82349 1551 48.9226 24.7111 2021-05-27 04:20:59 Ivano-Frankivsk Oblast, Ukraine
1313792 1313792 2021-05-26 Ukraine Kharkiv Oblast     146011 3203 130737 12071 49.9935 36.2304 2021-05-27 04:20:59 Kharkiv Oblast, Ukraine
1313793 1313793 2021-05-26 Ukraine Kherson Oblast     34416 1049 30163 3204 46.6354 32.6169 2021-05-27 04:20:59 Kherson Oblast, Ukraine
1313794 1313794 2021-05-26 Ukraine Khmelnytskyi Oblast     87597 1785 81729 4083 49.423 26.9871 2021-05-27 04:20:59 Khmelnytskyi Oblast, Ukraine
1313795 1313795 2021-05-26 Ukraine Kiev     205063 5044 154532 45487 50.4501 30.5234 2021-05-27 04:20:59 Kiev, Ukraine
1313796 1313796 2021-05-26 Ukraine Kiev Oblast     124384 2659 116579 5146 50.053 30.7667 2021-05-27 04:20:59 Kiev Oblast, Ukraine
1313797 1313797 2021-05-26 Ukraine Kirovohrad Oblast     20155 784 16206 3165 48.5079 32.2623 2021-05-27 04:20:59 Kirovohrad Oblast, Ukraine
1313798 1313798 2021-05-26 Ukraine Luhansk Oblast     25924 875 23317 1732 48.574 39.3078 2021-05-27 04:20:59 Luhansk Oblast, Ukraine
1313799 1313799 2021-05-26 Ukraine Lviv Oblast     135051 3541 126406 5104 49.8397 24.0297 2021-05-27 04:20:59 Lviv Oblast, Ukraine
1313800 1313800 2021-05-26 Ukraine Mykolaiv Oblast     67934 1783 64293 1858 46.975 31.9946 2021-05-27 04:20:59 Mykolaiv Oblast, Ukraine
1313801 1313801 2021-05-26 Ukraine Odessa Oblast     139044 2873 123273 12898 46.4846 30.7326 2021-05-27 04:20:59 Odessa Oblast, Ukraine
1313802 1313802 2021-05-26 Ukraine Poltava Oblast     76578 1768 72830 1980 49.5883 34.5514 2021-05-27 04:20:59 Poltava Oblast, Ukraine
1313803 1313803 2021-05-26 Ukraine Rivne Oblast     77572 1160 73887 2525 50.6199 26.2516 2021-05-27 04:20:59 Rivne Oblast, Ukraine
1313804 1313804 2021-05-26 Ukraine Sevastopol*     14741 674 13596 471 44.6054 33.522 2021-05-27 04:20:59 Sevastopol*, Ukraine
1313805 1313805 2021-05-26 Ukraine Sumy Oblast     76529 1275 72875 2379 50.9077 34.7981 2021-05-27 04:20:59 Sumy Oblast, Ukraine
1313806 1313806 2021-05-26 Ukraine Ternopil Oblast     69162 1162 64872 3128 49.5535 25.5948 2021-05-27 04:20:59 Ternopil Oblast, Ukraine
1313807 1313807 2021-05-26 Ukraine Vinnytsia Oblast     70277 1655 63752 4870 49.2331 28.4682 2021-05-27 04:20:59 Vinnytsia Oblast, Ukraine
1313808 1313808 2021-05-26 Ukraine Volyn Oblast     60896 1137 56348 3411 50.7472 25.3254 2021-05-27 04:20:59 Volyn Oblast, Ukraine
1313809 1313809 2021-05-26 Ukraine Zakarpattia Oblast     61481 1579 58696 1206 48.6208 22.2879 2021-05-27 04:20:59 Zakarpattia Oblast, Ukraine
1313810 1313810 2021-05-26 Ukraine Zaporizhia Oblast     102089 2293 93691 6105 47.8388 35.1396 2021-05-27 04:20:59 Zaporizhia Oblast, Ukraine
1313811 1313811 2021-05-26 Ukraine Zhytomyr Oblast     87279 1730 82818 2731 50.2547 28.6587 2021-05-27 04:20:59 Zhytomyr Oblast, Ukraine
1313865 1313865 2021-05-26 Ukraine Unknown     0 0 0 0     2021-05-27 04:20:59 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]);