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-06-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
3962126 3962126 2021-06-26 Ukraine Cherkasy Oblast     81701 1307 79729 665 49.4444 32.0598 2021-06-27 04:21:39 Cherkasy Oblast, Ukraine
3962127 3962127 2021-06-26 Ukraine Chernihiv Oblast     57511 1344 55728 439 51.4982 31.2893 2021-06-27 04:21:39 Chernihiv Oblast, Ukraine
3962128 3962128 2021-06-26 Ukraine Chernivtsi Oblast     79930 1791 77668 471 48.2917 25.9352 2021-06-27 04:21:39 Chernivtsi Oblast, Ukraine
3962129 3962129 2021-06-26 Ukraine Crimea Republic*     47276 1481 42932 2863 45.2835 34.2008 2021-06-27 04:21:39 Crimea Republic*, Ukraine
3962130 3962130 2021-06-26 Ukraine Dnipropetrovsk Oblast     135485 4419 129358 1708 48.4647 35.0462 2021-06-27 04:21:39 Dnipropetrovsk Oblast, Ukraine
3962131 3962131 2021-06-26 Ukraine Donetsk Oblast     90567 2348 87711 508 48.0159 37.8028 2021-06-27 04:21:39 Donetsk Oblast, Ukraine
3962132 3962132 2021-06-26 Ukraine Ivano-Frankivsk Oblast     86647 2097 84385 165 48.9226 24.7111 2021-06-27 04:21:39 Ivano-Frankivsk Oblast, Ukraine
3962133 3962133 2021-06-26 Ukraine Kharkiv Oblast     148477 3515 143698 1264 49.9935 36.2304 2021-06-27 04:21:39 Kharkiv Oblast, Ukraine
3962134 3962134 2021-06-26 Ukraine Kherson Oblast     35719 1133 34153 433 46.6354 32.6169 2021-06-27 04:21:39 Kherson Oblast, Ukraine
3962135 3962135 2021-06-26 Ukraine Khmelnytskyi Oblast     88882 1859 86291 732 49.423 26.9871 2021-06-27 04:21:39 Khmelnytskyi Oblast, Ukraine
3962136 3962136 2021-06-26 Ukraine Kiev     213235 5187 204144 3904 50.4501 30.5234 2021-06-27 04:21:39 Kiev, Ukraine
3962137 3962137 2021-06-26 Ukraine Kiev Oblast     127229 2742 123518 969 50.053 30.7667 2021-06-27 04:21:39 Kiev Oblast, Ukraine
3962138 3962138 2021-06-26 Ukraine Kirovohrad Oblast     20606 837 19008 761 48.5079 32.2623 2021-06-27 04:21:39 Kirovohrad Oblast, Ukraine
3962139 3962139 2021-06-26 Ukraine Luhansk Oblast     26551 941 25347 263 48.574 39.3078 2021-06-27 04:21:39 Luhansk Oblast, Ukraine
3962140 3962140 2021-06-26 Ukraine Lviv Oblast     137379 3650 132482 1247 49.8397 24.0297 2021-06-27 04:21:39 Lviv Oblast, Ukraine
3962141 3962141 2021-06-26 Ukraine Mykolaiv Oblast     69887 1843 67477 567 46.975 31.9946 2021-06-27 04:21:39 Mykolaiv Oblast, Ukraine
3962142 3962142 2021-06-26 Ukraine Odessa Oblast     140499 2974 135903 1622 46.4846 30.7326 2021-06-27 04:21:39 Odessa Oblast, Ukraine
3962143 3962143 2021-06-26 Ukraine Poltava Oblast     77799 1855 75610 334 49.5883 34.5514 2021-06-27 04:21:39 Poltava Oblast, Ukraine
3962144 3962144 2021-06-26 Ukraine Rivne Oblast     79447 1205 77946 296 50.6199 26.2516 2021-06-27 04:21:39 Rivne Oblast, Ukraine
3962145 3962145 2021-06-26 Ukraine Sevastopol*     16160 723 14504 933 44.6054 33.522 2021-06-27 04:21:39 Sevastopol*, Ukraine
3962146 3962146 2021-06-26 Ukraine Sumy Oblast     77832 1318 75950 564 50.9077 34.7981 2021-06-27 04:21:39 Sumy Oblast, Ukraine
3962147 3962147 2021-06-26 Ukraine Ternopil Oblast     70014 1198 68369 447 49.5535 25.5948 2021-06-27 04:21:39 Ternopil Oblast, Ukraine
3962148 3962148 2021-06-26 Ukraine Vinnytsia Oblast     71057 1690 69099 268 49.2331 28.4682 2021-06-27 04:21:39 Vinnytsia Oblast, Ukraine
3962149 3962149 2021-06-26 Ukraine Volyn Oblast     62112 1194 60449 469 50.7472 25.3254 2021-06-27 04:21:39 Volyn Oblast, Ukraine
3962150 3962150 2021-06-26 Ukraine Zakarpattia Oblast     62079 1603 60172 304 48.6208 22.2879 2021-06-27 04:21:39 Zakarpattia Oblast, Ukraine
3962151 3962151 2021-06-26 Ukraine Zaporizhia Oblast     104523 2434 101551 538 47.8388 35.1396 2021-06-27 04:21:39 Zaporizhia Oblast, Ukraine
3962152 3962152 2021-06-26 Ukraine Zhytomyr Oblast     88378 1785 86226 367 50.2547 28.6587 2021-06-27 04:21:39 Zhytomyr Oblast, Ukraine
3962202 3962202 2021-06-26 Ukraine Unknown     0 0 0 0     2021-06-27 04:21:39 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]);