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-09 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
2363081 2363081 2021-03-08 Ukraine Cherkasy Oblast     49697 655 46244 2798 49.4444 32.0598 2021-03-09 05:28:19 Cherkasy Oblast, Ukraine
2363082 2363082 2021-03-08 Ukraine Chernihiv Oblast     36662 769 31500 4393 51.4982 31.2893 2021-03-09 05:28:19 Chernihiv Oblast, Ukraine
2363083 2363083 2021-03-08 Ukraine Chernivtsi Oblast     58725 1089 46156 11480 48.2917 25.9352 2021-03-09 05:28:19 Chernivtsi Oblast, Ukraine
2363084 2363084 2021-03-08 Ukraine Crimea Republic*     36249 970 32579 2700 45.2835 34.2008 2021-03-09 05:28:19 Crimea Republic*, Ukraine
2363085 2363085 2021-03-08 Ukraine Dnipropetrovsk Oblast     76238 2033 69190 5015 48.4647 35.0462 2021-03-09 05:28:19 Dnipropetrovsk Oblast, Ukraine
2363086 2363086 2021-03-08 Ukraine Donetsk Oblast     48814 1076 44787 2951 48.0159 37.8028 2021-03-09 05:28:19 Donetsk Oblast, Ukraine
2363087 2363087 2021-03-08 Ukraine Ivano-Frankivsk Oblast     69488 1276 51159 17053 48.9226 24.7111 2021-03-09 05:28:19 Ivano-Frankivsk Oblast, Ukraine
2363088 2363088 2021-03-08 Ukraine Kharkiv Oblast     86673 1648 77960 7065 49.9935 36.2304 2021-03-09 05:28:19 Kharkiv Oblast, Ukraine
2363089 2363089 2021-03-08 Ukraine Kherson Oblast     22008 653 20457 898 46.6354 32.6169 2021-03-09 05:28:19 Kherson Oblast, Ukraine
2363090 2363090 2021-03-08 Ukraine Khmelnytskyi Oblast     50235 920 45528 3787 49.423 26.9871 2021-03-09 05:28:19 Khmelnytskyi Oblast, Ukraine
2363091 2363091 2021-03-08 Ukraine Kiev     142316 2785 96330 43201 50.4501 30.5234 2021-03-09 05:28:19 Kiev, Ukraine
2363092 2363092 2021-03-08 Ukraine Kiev Oblast     78980 1291 70546 7143 50.053 30.7667 2021-03-09 05:28:19 Kiev Oblast, Ukraine
2363093 2363093 2021-03-08 Ukraine Kirovohrad Oblast     11001 388 8223 2390 48.5079 32.2623 2021-03-09 05:28:19 Kirovohrad Oblast, Ukraine
2363094 2363094 2021-03-08 Ukraine Luhansk Oblast     15232 478 14120 634 48.574 39.3078 2021-03-09 05:28:19 Luhansk Oblast, Ukraine
2363095 2363095 2021-03-08 Ukraine Lviv Oblast     82860 2329 71188 9343 49.8397 24.0297 2021-03-09 05:28:19 Lviv Oblast, Ukraine
2363096 2363096 2021-03-08 Ukraine Mykolaiv Oblast     43889 819 38357 4713 46.975 31.9946 2021-03-09 05:28:19 Mykolaiv Oblast, Ukraine
2363097 2363097 2021-03-08 Ukraine Odessa Oblast     88611 1471 79882 7258 46.4846 30.7326 2021-03-09 05:28:19 Odessa Oblast, Ukraine
2363098 2363098 2021-03-08 Ukraine Poltava Oblast     47252 1004 42935 3313 49.5883 34.5514 2021-03-09 05:28:19 Poltava Oblast, Ukraine
2363099 2363099 2021-03-08 Ukraine Rivne Oblast     50031 638 47336 2057 50.6199 26.2516 2021-03-09 05:28:19 Rivne Oblast, Ukraine
2363100 2363100 2021-03-08 Ukraine Sevastopol*     12372 518 11478 376 44.6054 33.522 2021-03-09 05:28:19 Sevastopol*, Ukraine
2363101 2363101 2021-03-08 Ukraine Sumy Oblast     49850 696 46532 2622 50.9077 34.7981 2021-03-09 05:28:19 Sumy Oblast, Ukraine
2363102 2363102 2021-03-08 Ukraine Ternopil Oblast     44466 623 39594 4249 49.5535 25.5948 2021-03-09 05:28:19 Ternopil Oblast, Ukraine
2363103 2363103 2021-03-08 Ukraine Vinnytsia Oblast     41762 728 28770 12264 49.2331 28.4682 2021-03-09 05:28:19 Vinnytsia Oblast, Ukraine
2363104 2363104 2021-03-08 Ukraine Volyn Oblast     41343 657 37633 3053 50.7472 25.3254 2021-03-09 05:28:19 Volyn Oblast, Ukraine
2363105 2363105 2021-03-08 Ukraine Zakarpattia Oblast     44314 1000 32535 10779 48.6208 22.2879 2021-03-09 05:28:19 Zakarpattia Oblast, Ukraine
2363106 2363106 2021-03-08 Ukraine Zaporizhia Oblast     70738 1216 65976 3546 47.8388 35.1396 2021-03-09 05:28:19 Zaporizhia Oblast, Ukraine
2363107 2363107 2021-03-08 Ukraine Zhytomyr Oblast     55615 886 45316 9413 50.2547 28.6587 2021-03-09 05:28:19 Zhytomyr Oblast, Ukraine
2363163 2363163 2021-03-08 Ukraine Unknown     0 0 0 0     2021-03-09 05:28:19 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]);