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-17 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
706019 706019 2021-03-16 Ukraine Cherkasy Oblast     51310 679 46931 3700 49.4444 32.0598 2021-03-17 05:25:07 Cherkasy Oblast, Ukraine
706020 706020 2021-03-16 Ukraine Chernihiv Oblast     37740 797 31984 4959 51.4982 31.2893 2021-03-17 05:25:07 Chernihiv Oblast, Ukraine
706021 706021 2021-03-16 Ukraine Chernivtsi Oblast     62937 1182 47134 14621 48.2917 25.9352 2021-03-17 05:25:07 Chernivtsi Oblast, Ukraine
706022 706022 2021-03-16 Ukraine Crimea Republic*     36730 1005 33646 2079 45.2835 34.2008 2021-03-17 05:25:07 Crimea Republic*, Ukraine
706023 706023 2021-03-16 Ukraine Dnipropetrovsk Oblast     79680 2128 70690 6862 48.4647 35.0462 2021-03-17 05:25:07 Dnipropetrovsk Oblast, Ukraine
706024 706024 2021-03-16 Ukraine Donetsk Oblast     50911 1115 45483 4313 48.0159 37.8028 2021-03-17 05:25:07 Donetsk Oblast, Ukraine
706025 706025 2021-03-16 Ukraine Ivano-Frankivsk Oblast     73628 1448 54527 17653 48.9226 24.7111 2021-03-17 05:25:07 Ivano-Frankivsk Oblast, Ukraine
706026 706026 2021-03-16 Ukraine Kharkiv Oblast     90760 1733 79872 9155 49.9935 36.2304 2021-03-17 05:25:07 Kharkiv Oblast, Ukraine
706027 706027 2021-03-16 Ukraine Kherson Oblast     22385 669 20689 1027 46.6354 32.6169 2021-03-17 05:25:07 Kherson Oblast, Ukraine
706028 706028 2021-03-16 Ukraine Khmelnytskyi Oblast     53113 976 46762 5375 49.423 26.9871 2021-03-17 05:25:07 Khmelnytskyi Oblast, Ukraine
706029 706029 2021-03-16 Ukraine Kiev     147710 2936 99589 45185 50.4501 30.5234 2021-03-17 05:25:07 Kiev, Ukraine
706030 706030 2021-03-16 Ukraine Kiev Oblast     83110 1364 72666 9080 50.053 30.7667 2021-03-17 05:25:07 Kiev Oblast, Ukraine
706031 706031 2021-03-16 Ukraine Kirovohrad Oblast     11379 420 8511 2448 48.5079 32.2623 2021-03-17 05:25:07 Kirovohrad Oblast, Ukraine
706032 706032 2021-03-16 Ukraine Luhansk Oblast     15736 494 14387 855 48.574 39.3078 2021-03-17 05:25:07 Luhansk Oblast, Ukraine
706033 706033 2021-03-16 Ukraine Lviv Oblast     88124 2413 73325 12386 49.8397 24.0297 2021-03-17 05:25:07 Lviv Oblast, Ukraine
706034 706034 2021-03-16 Ukraine Mykolaiv Oblast     46218 876 39459 5883 46.975 31.9946 2021-03-17 05:25:07 Mykolaiv Oblast, Ukraine
706035 706035 2021-03-16 Ukraine Odessa Oblast     92992 1555 81304 10133 46.4846 30.7326 2021-03-17 05:25:07 Odessa Oblast, Ukraine
706036 706036 2021-03-16 Ukraine Poltava Oblast     48901 1039 43633 4229 49.5883 34.5514 2021-03-17 05:25:07 Poltava Oblast, Ukraine
706037 706037 2021-03-16 Ukraine Rivne Oblast     51674 657 48517 2500 50.6199 26.2516 2021-03-17 05:25:07 Rivne Oblast, Ukraine
706038 706038 2021-03-16 Ukraine Sevastopol*     12675 537 11748 390 44.6054 33.522 2021-03-17 05:25:07 Sevastopol*, Ukraine
706039 706039 2021-03-16 Ukraine Sumy Oblast     51521 735 47514 3272 50.9077 34.7981 2021-03-17 05:25:07 Sumy Oblast, Ukraine
706040 706040 2021-03-16 Ukraine Ternopil Oblast     46957 652 41052 5253 49.5535 25.5948 2021-03-17 05:25:07 Ternopil Oblast, Ukraine
706041 706041 2021-03-16 Ukraine Vinnytsia Oblast     47313 795 30734 15784 49.2331 28.4682 2021-03-17 05:25:07 Vinnytsia Oblast, Ukraine
706042 706042 2021-03-16 Ukraine Volyn Oblast     42689 680 38689 3320 50.7472 25.3254 2021-03-17 05:25:07 Volyn Oblast, Ukraine
706043 706043 2021-03-16 Ukraine Zakarpattia Oblast     47762 1117 34862 11783 48.6208 22.2879 2021-03-17 05:25:07 Zakarpattia Oblast, Ukraine
706044 706044 2021-03-16 Ukraine Zaporizhia Oblast     72317 1255 66952 4110 47.8388 35.1396 2021-03-17 05:25:07 Zaporizhia Oblast, Ukraine
706045 706045 2021-03-16 Ukraine Zhytomyr Oblast     60323 982 46943 12398 50.2547 28.6587 2021-03-17 05:25:07 Zhytomyr Oblast, Ukraine
706101 706101 2021-03-16 Ukraine Unknown     0 0 0 0     2021-03-17 05:25:07 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]);