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-03-15 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
1736109 1736109 2021-03-14 Ukraine Cherkasy Oblast     50923 673 46787 3463 49.4444 32.0598 2021-03-15 05:25:51 Cherkasy Oblast, Ukraine
1736110 1736110 2021-03-14 Ukraine Chernihiv Oblast     37623 791 31932 4900 51.4982 31.2893 2021-03-15 05:25:51 Chernihiv Oblast, Ukraine
1736111 1736111 2021-03-14 Ukraine Chernivtsi Oblast     62014 1156 46903 13955 48.2917 25.9352 2021-03-15 05:25:51 Chernivtsi Oblast, Ukraine
1736112 1736112 2021-03-14 Ukraine Crimea Republic*     36619 999 33564 2056 45.2835 34.2008 2021-03-15 05:25:51 Crimea Republic*, Ukraine
1736113 1736113 2021-03-14 Ukraine Dnipropetrovsk Oblast     78972 2107 70104 6761 48.4647 35.0462 2021-03-15 05:25:51 Dnipropetrovsk Oblast, Ukraine
1736114 1736114 2021-03-14 Ukraine Donetsk Oblast     50540 1107 45366 4067 48.0159 37.8028 2021-03-15 05:25:51 Donetsk Oblast, Ukraine
1736115 1736115 2021-03-14 Ukraine Ivano-Frankivsk Oblast     72831 1397 52979 18455 48.9226 24.7111 2021-03-15 05:25:51 Ivano-Frankivsk Oblast, Ukraine
1736116 1736116 2021-03-14 Ukraine Kharkiv Oblast     89791 1715 79392 8684 49.9935 36.2304 2021-03-15 05:25:51 Kharkiv Oblast, Ukraine
1736117 1736117 2021-03-14 Ukraine Kherson Oblast     22302 663 20614 1025 46.6354 32.6169 2021-03-15 05:25:51 Kherson Oblast, Ukraine
1736118 1736118 2021-03-14 Ukraine Khmelnytskyi Oblast     52531 962 46474 5095 49.423 26.9871 2021-03-15 05:25:51 Khmelnytskyi Oblast, Ukraine
1736119 1736119 2021-03-14 Ukraine Kiev     146398 2897 98365 45136 50.4501 30.5234 2021-03-15 05:25:51 Kiev, Ukraine
1736120 1736120 2021-03-14 Ukraine Kiev Oblast     82134 1355 72297 8482 50.053 30.7667 2021-03-15 05:25:51 Kiev Oblast, Ukraine
1736121 1736121 2021-03-14 Ukraine Kirovohrad Oblast     11323 407 8415 2501 48.5079 32.2623 2021-03-15 05:25:51 Kirovohrad Oblast, Ukraine
1736122 1736122 2021-03-14 Ukraine Luhansk Oblast     15616 489 14333 794 48.574 39.3078 2021-03-15 05:25:51 Luhansk Oblast, Ukraine
1736123 1736123 2021-03-14 Ukraine Lviv Oblast     86507 2387 72602 11518 49.8397 24.0297 2021-03-15 05:25:51 Lviv Oblast, Ukraine
1736124 1736124 2021-03-14 Ukraine Mykolaiv Oblast     45492 857 39250 5385 46.975 31.9946 2021-03-15 05:25:51 Mykolaiv Oblast, Ukraine
1736125 1736125 2021-03-14 Ukraine Odessa Oblast     91857 1535 81100 9222 46.4846 30.7326 2021-03-15 05:25:51 Odessa Oblast, Ukraine
1736126 1736126 2021-03-14 Ukraine Poltava Oblast     48423 1034 43457 3932 49.5883 34.5514 2021-03-15 05:25:51 Poltava Oblast, Ukraine
1736127 1736127 2021-03-14 Ukraine Rivne Oblast     51328 651 48168 2509 50.6199 26.2516 2021-03-15 05:25:51 Rivne Oblast, Ukraine
1736128 1736128 2021-03-14 Ukraine Sevastopol*     12608 533 11674 401 44.6054 33.522 2021-03-15 05:25:51 Sevastopol*, Ukraine
1736129 1736129 2021-03-14 Ukraine Sumy Oblast     51169 731 47185 3253 50.9077 34.7981 2021-03-15 05:25:51 Sumy Oblast, Ukraine
1736130 1736130 2021-03-14 Ukraine Ternopil Oblast     46396 646 40651 5099 49.5535 25.5948 2021-03-15 05:25:51 Ternopil Oblast, Ukraine
1736131 1736131 2021-03-14 Ukraine Vinnytsia Oblast     45963 773 30216 14974 49.2331 28.4682 2021-03-15 05:25:51 Vinnytsia Oblast, Ukraine
1736132 1736132 2021-03-14 Ukraine Volyn Oblast     42384 672 38512 3200 50.7472 25.3254 2021-03-15 05:25:51 Volyn Oblast, Ukraine
1736133 1736133 2021-03-14 Ukraine Zakarpattia Oblast     46875 1091 34099 11685 48.6208 22.2879 2021-03-15 05:25:51 Zakarpattia Oblast, Ukraine
1736134 1736134 2021-03-14 Ukraine Zaporizhia Oblast     71949 1255 66777 3917 47.8388 35.1396 2021-03-15 05:25:51 Zaporizhia Oblast, Ukraine
1736135 1736135 2021-03-14 Ukraine Zhytomyr Oblast     59415 952 46538 11925 50.2547 28.6587 2021-03-15 05:25:51 Zhytomyr Oblast, Ukraine
1736191 1736191 2021-03-14 Ukraine Unknown     0 0 0 0     2021-03-15 05:25:51 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]);