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-29 sorted by day descending

✎ View and edit SQL

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

Suggested facets: last_update (date)

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
23987 23987 2021-05-28 Ukraine Cherkasy Oblast     80424 1229 73509 5686 49.4444 32.0598 2021-05-29 04:20:41 Cherkasy Oblast, Ukraine
23988 23988 2021-05-28 Ukraine Chernihiv Oblast     56559 1300 53176 2083 51.4982 31.2893 2021-05-29 04:20:41 Chernihiv Oblast, Ukraine
23989 23989 2021-05-28 Ukraine Chernivtsi Oblast     79119 1761 76023 1335 48.2917 25.9352 2021-05-29 04:20:41 Chernivtsi Oblast, Ukraine
23990 23990 2021-05-28 Ukraine Crimea Republic*     43191 1341 40319 1531 45.2835 34.2008 2021-05-29 04:20:41 Crimea Republic*, Ukraine
23991 23991 2021-05-28 Ukraine Dnipropetrovsk Oblast     132862 4082 120014 8766 48.4647 35.0462 2021-05-29 04:20:41 Dnipropetrovsk Oblast, Ukraine
23992 23992 2021-05-28 Ukraine Donetsk Oblast     89026 2220 82675 4131 48.0159 37.8028 2021-05-29 04:20:41 Donetsk Oblast, Ukraine
23993 23993 2021-05-28 Ukraine Ivano-Frankivsk Oblast     86071 2053 82588 1430 48.9226 24.7111 2021-05-29 04:20:41 Ivano-Frankivsk Oblast, Ukraine
23994 23994 2021-05-28 Ukraine Kharkiv Oblast     146435 3245 132647 10543 49.9935 36.2304 2021-05-29 04:20:41 Kharkiv Oblast, Ukraine
23995 23995 2021-05-28 Ukraine Kherson Oblast     34623 1056 30761 2806 46.6354 32.6169 2021-05-29 04:20:41 Kherson Oblast, Ukraine
23996 23996 2021-05-28 Ukraine Khmelnytskyi Oblast     87825 1794 82573 3458 49.423 26.9871 2021-05-29 04:20:41 Khmelnytskyi Oblast, Ukraine
23997 23997 2021-05-28 Ukraine Kiev     205901 5070 161908 38923 50.4501 30.5234 2021-05-29 04:20:41 Kiev, Ukraine
23998 23998 2021-05-28 Ukraine Kiev Oblast     124799 2670 117862 4267 50.053 30.7667 2021-05-29 04:20:41 Kiev Oblast, Ukraine
23999 23999 2021-05-28 Ukraine Kirovohrad Oblast     20235 790 16753 2692 48.5079 32.2623 2021-05-29 04:20:41 Kirovohrad Oblast, Ukraine
24000 24000 2021-05-28 Ukraine Luhansk Oblast     26029 881 23681 1467 48.574 39.3078 2021-05-29 04:20:41 Luhansk Oblast, Ukraine
24001 24001 2021-05-28 Ukraine Lviv Oblast     135580 3553 128284 3743 49.8397 24.0297 2021-05-29 04:20:41 Lviv Oblast, Ukraine
24002 24002 2021-05-28 Ukraine Mykolaiv Oblast     68229 1792 64802 1635 46.975 31.9946 2021-05-29 04:20:41 Mykolaiv Oblast, Ukraine
24003 24003 2021-05-28 Ukraine Odessa Oblast     139242 2885 127317 9040 46.4846 30.7326 2021-05-29 04:20:41 Odessa Oblast, Ukraine
24004 24004 2021-05-28 Ukraine Poltava Oblast     76767 1782 73244 1741 49.5883 34.5514 2021-05-29 04:20:41 Poltava Oblast, Ukraine
24005 24005 2021-05-28 Ukraine Rivne Oblast     77912 1167 74575 2170 50.6199 26.2516 2021-05-29 04:20:41 Rivne Oblast, Ukraine
24006 24006 2021-05-28 Ukraine Sevastopol*     14810 679 13639 492 44.6054 33.522 2021-05-29 04:20:41 Sevastopol*, Ukraine
24007 24007 2021-05-28 Ukraine Sumy Oblast     76708 1288 73213 2207 50.9077 34.7981 2021-05-29 04:20:41 Sumy Oblast, Ukraine
24008 24008 2021-05-28 Ukraine Ternopil Oblast     69318 1171 65360 2787 49.5535 25.5948 2021-05-29 04:20:41 Ternopil Oblast, Ukraine
24009 24009 2021-05-28 Ukraine Vinnytsia Oblast     70416 1660 65167 3589 49.2331 28.4682 2021-05-29 04:20:41 Vinnytsia Oblast, Ukraine
24010 24010 2021-05-28 Ukraine Volyn Oblast     61100 1142 56920 3038 50.7472 25.3254 2021-05-29 04:20:41 Volyn Oblast, Ukraine
24011 24011 2021-05-28 Ukraine Zakarpattia Oblast     61549 1584 58859 1106 48.6208 22.2879 2021-05-29 04:20:41 Zakarpattia Oblast, Ukraine
24012 24012 2021-05-28 Ukraine Zaporizhia Oblast     102471 2323 94730 5418 47.8388 35.1396 2021-05-29 04:20:41 Zaporizhia Oblast, Ukraine
24013 24013 2021-05-28 Ukraine Zhytomyr Oblast     87473 1734 83575 2164 50.2547 28.6587 2021-05-29 04:20:41 Zhytomyr Oblast, Ukraine
24066 24066 2021-05-28 Ukraine Unknown     0 0 0 0     2021-05-29 04:20:41 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]);