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 2020-11-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
927294 927294 2020-11-26 Ukraine Cherkasy Oblast     20668 180 8619 11869 49.4444 32.0598 2020-11-27 05:26:53 Cherkasy Oblast, Ukraine
927295 927295 2020-11-26 Ukraine Chernihiv Oblast     16485 91 5751 10643 51.4982 31.2893 2020-11-27 05:26:53 Chernihiv Oblast, Ukraine
927296 927296 2020-11-26 Ukraine Chernivtsi Oblast     32492 623 14646 17223 48.2917 25.9352 2020-11-27 05:26:53 Chernivtsi Oblast, Ukraine
927297 927297 2020-11-26 Ukraine Crimea Republic*     14468 262 10565 3641 45.2835 34.2008 2020-11-27 05:26:53 Crimea Republic*, Ukraine
927298 927298 2020-11-26 Ukraine Dnipropetrovsk Oblast     33115 823 14276 18016 48.4647 35.0462 2020-11-27 05:26:53 Dnipropetrovsk Oblast, Ukraine
927299 927299 2020-11-26 Ukraine Donetsk Oblast     21344 381 10544 10419 48.0159 37.8028 2020-11-27 05:26:53 Donetsk Oblast, Ukraine
927300 927300 2020-11-26 Ukraine Ivano-Frankivsk Oblast     34045 597 13189 20259 48.9226 24.7111 2020-11-27 05:26:53 Ivano-Frankivsk Oblast, Ukraine
927301 927301 2020-11-26 Ukraine Kharkiv Oblast     53433 730 26921 25782 49.9935 36.2304 2020-11-27 05:26:53 Kharkiv Oblast, Ukraine
927302 927302 2020-11-26 Ukraine Kherson Oblast     9345 187 4089 5069 46.6354 32.6169 2020-11-27 05:26:53 Kherson Oblast, Ukraine
927303 927303 2020-11-26 Ukraine Khmelnytskyi Oblast     27703 421 15848 11434 49.423 26.9871 2020-11-27 05:26:53 Khmelnytskyi Oblast, Ukraine
927304 927304 2020-11-26 Ukraine Kiev     64019 1227 21942 40850 50.4501 30.5234 2020-11-27 05:26:53 Kiev, Ukraine
927305 927305 2020-11-26 Ukraine Kiev Oblast     34241 652 11853 21736 50.053 30.7667 2020-11-27 05:26:53 Kiev Oblast, Ukraine
927306 927306 2020-11-26 Ukraine Kirovohrad Oblast     4706 146 2207 2353 48.5079 32.2623 2020-11-27 05:26:53 Kirovohrad Oblast, Ukraine
927307 927307 2020-11-26 Ukraine Luhansk Oblast     5925 154 3707 2064 48.574 39.3078 2020-11-27 05:26:53 Luhansk Oblast, Ukraine
927308 927308 2020-11-26 Ukraine Lviv Oblast     43611 1195 28062 14354 49.8397 24.0297 2020-11-27 05:26:53 Lviv Oblast, Ukraine
927309 927309 2020-11-26 Ukraine Mykolaiv Oblast     16731 289 5259 11183 46.975 31.9946 2020-11-27 05:26:53 Mykolaiv Oblast, Ukraine
927310 927310 2020-11-26 Ukraine Odessa Oblast     40535 536 8809 31190 46.4846 30.7326 2020-11-27 05:26:53 Odessa Oblast, Ukraine
927311 927311 2020-11-26 Ukraine Poltava Oblast     20204 425 10539 9240 49.5883 34.5514 2020-11-27 05:26:53 Poltava Oblast, Ukraine
927312 927312 2020-11-26 Ukraine Rivne Oblast     29320 369 22008 6943 50.6199 26.2516 2020-11-27 05:26:53 Rivne Oblast, Ukraine
927313 927313 2020-11-26 Ukraine Sevastopol*     4098 112 3578 408 44.6054 33.522 2020-11-27 05:26:53 Sevastopol*, Ukraine
927314 927314 2020-11-26 Ukraine Sumy Oblast     25662 348 9457 15857 50.9077 34.7981 2020-11-27 05:26:53 Sumy Oblast, Ukraine
927315 927315 2020-11-26 Ukraine Ternopil Oblast     26752 368 20850 5534 49.5535 25.5948 2020-11-27 05:26:53 Ternopil Oblast, Ukraine
927316 927316 2020-11-26 Ukraine Vinnytsia Oblast     16370 281 9159 6930 49.2331 28.4682 2020-11-27 05:26:53 Vinnytsia Oblast, Ukraine
927317 927317 2020-11-26 Ukraine Volyn Oblast     22906 418 15248 7240 50.7472 25.3254 2020-11-27 05:26:53 Volyn Oblast, Ukraine
927318 927318 2020-11-26 Ukraine Zakarpattia Oblast     22425 518 12781 9126 48.6208 22.2879 2020-11-27 05:26:53 Zakarpattia Oblast, Ukraine
927319 927319 2020-11-26 Ukraine Zaporizhia Oblast     27226 282 4582 22362 47.8388 35.1396 2020-11-27 05:26:53 Zaporizhia Oblast, Ukraine
927320 927320 2020-11-26 Ukraine Zhytomyr Oblast     27926 476 17049 10401 50.2547 28.6587 2020-11-27 05:26:53 Zhytomyr Oblast, Ukraine
927377 927377 2020-11-26 Ukraine Unknown     0 0 0 0     2020-11-27 05:26:53 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]);