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-10-23 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
1181103 1181103 2020-10-22 Ukraine Cherkasy Oblast     7541 76 3058 4407 49.4444 32.0598 2020-10-23 04:24:46 Cherkasy Oblast, Ukraine
1181104 1181104 2020-10-22 Ukraine Chernihiv Oblast     7367 87 1308 5972 51.4982 31.2893 2020-10-23 04:24:46 Chernihiv Oblast, Ukraine
1181105 1181105 2020-10-22 Ukraine Chernivtsi Oblast     18562 419 9688 8455 48.2917 25.9352 2020-10-23 04:24:46 Chernivtsi Oblast, Ukraine
1181106 1181106 2020-10-22 Ukraine Crimea Republic*     7585 115 4232 3238 45.2835 34.2008 2020-10-23 04:24:46 Crimea Republic*, Ukraine
1181107 1181107 2020-10-22 Ukraine Dnipropetrovsk Oblast     12068 285 5277 6506 48.4647 35.0462 2020-10-23 04:24:46 Dnipropetrovsk Oblast, Ukraine
1181108 1181108 2020-10-22 Ukraine Donetsk Oblast     7896 84 1314 6498 48.0159 37.8028 2020-10-23 04:24:46 Donetsk Oblast, Ukraine
1181109 1181109 2020-10-22 Ukraine Ivano-Frankivsk Oblast     17447 399 8907 8141 48.9226 24.7111 2020-10-23 04:24:46 Ivano-Frankivsk Oblast, Ukraine
1181110 1181110 2020-10-22 Ukraine Kharkiv Oblast     30899 472 5989 24438 49.9935 36.2304 2020-10-23 04:24:46 Kharkiv Oblast, Ukraine
1181111 1181111 2020-10-22 Ukraine Kherson Oblast     2844 60 1236 1548 46.6354 32.6169 2020-10-23 04:24:46 Kherson Oblast, Ukraine
1181112 1181112 2020-10-22 Ukraine Khmelnytskyi Oblast     11942 191 5218 6533 49.423 26.9871 2020-10-23 04:24:46 Khmelnytskyi Oblast, Ukraine
1181113 1181113 2020-10-22 Ukraine Kiev     32500 642 11304 20554 50.4501 30.5234 2020-10-23 04:24:46 Kiev, Ukraine
1181114 1181114 2020-10-22 Ukraine Kiev Oblast     13688 303 7498 5887 50.053 30.7667 2020-10-23 04:24:46 Kiev Oblast, Ukraine
1181115 1181115 2020-10-22 Ukraine Kirovohrad Oblast     1786 75 1063 648 48.5079 32.2623 2020-10-23 04:24:46 Kirovohrad Oblast, Ukraine
1181116 1181116 2020-10-22 Ukraine Luhansk Oblast     2841 53 945 1843 48.574 39.3078 2020-10-23 04:24:46 Luhansk Oblast, Ukraine
1181117 1181117 2020-10-22 Ukraine Lviv Oblast     26021 740 10248 15033 49.8397 24.0297 2020-10-23 04:24:46 Lviv Oblast, Ukraine
1181118 1181118 2020-10-22 Ukraine Mykolaiv Oblast     6428 121 1581 4726 46.975 31.9946 2020-10-23 04:24:46 Mykolaiv Oblast, Ukraine
1181119 1181119 2020-10-22 Ukraine Odessa Oblast     20557 311 3270 16976 46.4846 30.7326 2020-10-23 04:24:46 Odessa Oblast, Ukraine
1181120 1181120 2020-10-22 Ukraine Poltava Oblast     7216 134 2354 4728 49.5883 34.5514 2020-10-23 04:24:46 Poltava Oblast, Ukraine
1181121 1181121 2020-10-22 Ukraine Rivne Oblast     16691 206 12881 3604 50.6199 26.2516 2020-10-23 04:24:46 Rivne Oblast, Ukraine
1181122 1181122 2020-10-22 Ukraine Sevastopol*     1798 55 1192 551 44.6054 33.522 2020-10-23 04:24:46 Sevastopol*, Ukraine
1181123 1181123 2020-10-22 Ukraine Sumy Oblast     9730 142 2882 6706 50.9077 34.7981 2020-10-23 04:24:46 Sumy Oblast, Ukraine
1181124 1181124 2020-10-22 Ukraine Ternopil Oblast     18283 234 13205 4844 49.5535 25.5948 2020-10-23 04:24:46 Ternopil Oblast, Ukraine
1181125 1181125 2020-10-22 Ukraine Vinnytsia Oblast     8782 153 5394 3235 49.2331 28.4682 2020-10-23 04:24:46 Vinnytsia Oblast, Ukraine
1181126 1181126 2020-10-22 Ukraine Volyn Oblast     11574 233 6670 4671 50.7472 25.3254 2020-10-23 04:24:46 Volyn Oblast, Ukraine
1181127 1181127 2020-10-22 Ukraine Zakarpattia Oblast     12285 343 5732 6210 48.6208 22.2879 2020-10-23 04:24:46 Zakarpattia Oblast, Ukraine
1181128 1181128 2020-10-22 Ukraine Zaporizhia Oblast     7093 97 1867 5129 47.8388 35.1396 2020-10-23 04:24:46 Zaporizhia Oblast, Ukraine
1181129 1181129 2020-10-22 Ukraine Zhytomyr Oblast     10838 183 6009 4646 50.2547 28.6587 2020-10-23 04:24:46 Zhytomyr Oblast, Ukraine
1181185 1181185 2020-10-22 Ukraine Unknown     0 0 0 0     2020-10-23 04:24:46 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]);