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-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
2693288 2693288 2020-10-08 Ukraine Cherkasy Oblast     5153 60 2083 3010 49.4444 32.0598 2020-10-09 04:23:59 Cherkasy Oblast, Ukraine
2693289 2693289 2020-10-08 Ukraine Chernihiv Oblast     5066 87 1126 3853 51.4982 31.2893 2020-10-09 04:23:59 Chernihiv Oblast, Ukraine
2693290 2693290 2020-10-08 Ukraine Chernivtsi Oblast     15757 379 8526 6852 48.2917 25.9352 2020-10-09 04:23:59 Chernivtsi Oblast, Ukraine
2693291 2693291 2020-10-08 Ukraine Crimea Republic*     5288 82 3357 1849 45.2835 34.2008 2020-10-09 04:23:59 Crimea Republic*, Ukraine
2693292 2693292 2020-10-08 Ukraine Dnipropetrovsk Oblast     7994 142 3686 4166 48.4647 35.0462 2020-10-09 04:23:59 Dnipropetrovsk Oblast, Ukraine
2693293 2693293 2020-10-08 Ukraine Donetsk Oblast     5118 66 1157 3895 48.0159 37.8028 2020-10-09 04:23:59 Donetsk Oblast, Ukraine
2693294 2693294 2020-10-08 Ukraine Ivano-Frankivsk Oblast     14693 346 7280 7067 48.9226 24.7111 2020-10-09 04:23:59 Ivano-Frankivsk Oblast, Ukraine
2693295 2693295 2020-10-08 Ukraine Kharkiv Oblast     22712 396 4709 17607 49.9935 36.2304 2020-10-09 04:23:59 Kharkiv Oblast, Ukraine
2693296 2693296 2020-10-08 Ukraine Kherson Oblast     1636 30 741 865 46.6354 32.6169 2020-10-09 04:23:59 Kherson Oblast, Ukraine
2693297 2693297 2020-10-08 Ukraine Khmelnytskyi Oblast     7732 144 3479 4109 49.423 26.9871 2020-10-09 04:23:59 Khmelnytskyi Oblast, Ukraine
2693298 2693298 2020-10-08 Ukraine Kiev     25896 453 9116 16327 50.4501 30.5234 2020-10-09 04:23:59 Kiev, Ukraine
2693299 2693299 2020-10-08 Ukraine Kiev Oblast     10490 213 6220 4057 50.053 30.7667 2020-10-09 04:23:59 Kiev Oblast, Ukraine
2693300 2693300 2020-10-08 Ukraine Kirovohrad Oblast     1234 62 933 239 48.5079 32.2623 2020-10-09 04:23:59 Kirovohrad Oblast, Ukraine
2693301 2693301 2020-10-08 Ukraine Luhansk Oblast     1480 19 676 785 48.574 39.3078 2020-10-09 04:23:59 Luhansk Oblast, Ukraine
2693302 2693302 2020-10-08 Ukraine Lviv Oblast     21923 600 8396 12927 49.8397 24.0297 2020-10-09 04:23:59 Lviv Oblast, Ukraine
2693303 2693303 2020-10-08 Ukraine Mykolaiv Oblast     4154 99 1253 2802 46.975 31.9946 2020-10-09 04:23:59 Mykolaiv Oblast, Ukraine
2693304 2693304 2020-10-08 Ukraine Odessa Oblast     15704 239 2561 12904 46.4846 30.7326 2020-10-09 04:23:59 Odessa Oblast, Ukraine
2693305 2693305 2020-10-08 Ukraine Poltava Oblast     3685 58 1383 2244 49.5883 34.5514 2020-10-09 04:23:59 Poltava Oblast, Ukraine
2693306 2693306 2020-10-08 Ukraine Rivne Oblast     13798 180 11007 2611 50.6199 26.2516 2020-10-09 04:23:59 Rivne Oblast, Ukraine
2693307 2693307 2020-10-08 Ukraine Sevastopol*     1221 35 775 411 44.6054 33.522 2020-10-09 04:23:59 Sevastopol*, Ukraine
2693308 2693308 2020-10-08 Ukraine Sumy Oblast     6197 88 2134 3975 50.9077 34.7981 2020-10-09 04:23:59 Sumy Oblast, Ukraine
2693309 2693309 2020-10-08 Ukraine Ternopil Oblast     14979 187 10369 4423 49.5535 25.5948 2020-10-09 04:23:59 Ternopil Oblast, Ukraine
2693310 2693310 2020-10-08 Ukraine Vinnytsia Oblast     7197 126 4366 2705 49.2331 28.4682 2020-10-09 04:23:59 Vinnytsia Oblast, Ukraine
2693311 2693311 2020-10-08 Ukraine Volyn Oblast     9199 190 5538 3471 50.7472 25.3254 2020-10-09 04:23:59 Volyn Oblast, Ukraine
2693312 2693312 2020-10-08 Ukraine Zakarpattia Oblast     10473 315 5515 4643 48.6208 22.2879 2020-10-09 04:23:59 Zakarpattia Oblast, Ukraine
2693313 2693313 2020-10-08 Ukraine Zaporizhia Oblast     5007 80 1594 3333 47.8388 35.1396 2020-10-09 04:23:59 Zaporizhia Oblast, Ukraine
2693314 2693314 2020-10-08 Ukraine Zhytomyr Oblast     7457 131 4385 2941 50.2547 28.6587 2020-10-09 04:23:59 Zhytomyr Oblast, Ukraine
2693370 2693370 2020-10-08 Ukraine Unknown     0 0 0 0     2020-10-09 04:23:59 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]);