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 "day" is on date 2021-04-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
1412659 1412659 2021-04-23 Ukraine Cherkasy Oblast     71653 945 56900 13808 49.4444 32.0598 2021-04-24 04:20:38 Cherkasy Oblast, Ukraine
1412660 1412660 2021-04-23 Ukraine Chernihiv Oblast     51703 1062 39466 11175 51.4982 31.2893 2021-04-24 04:20:38 Chernihiv Oblast, Ukraine
1412661 1412661 2021-04-23 Ukraine Chernivtsi Oblast     76257 1601 58257 16399 48.2917 25.9352 2021-04-24 04:20:38 Chernivtsi Oblast, Ukraine
1412662 1412662 2021-04-23 Ukraine Crimea Republic*     39764 1180 36978 1606 45.2835 34.2008 2021-04-24 04:20:38 Crimea Republic*, Ukraine
1412663 1412663 2021-04-23 Ukraine Dnipropetrovsk Oblast     115198 3090 91150 20958 48.4647 35.0462 2021-04-24 04:20:38 Dnipropetrovsk Oblast, Ukraine
1412664 1412664 2021-04-23 Ukraine Donetsk Oblast     75257 1626 57290 16341 48.0159 37.8028 2021-04-24 04:20:38 Donetsk Oblast, Ukraine
1412665 1412665 2021-04-23 Ukraine Ivano-Frankivsk Oblast     83178 1919 75168 6091 48.9226 24.7111 2021-04-24 04:20:38 Ivano-Frankivsk Oblast, Ukraine
1412666 1412666 2021-04-23 Ukraine Kharkiv Oblast     130273 2528 100490 27255 49.9935 36.2304 2021-04-24 04:20:38 Kharkiv Oblast, Ukraine
1412667 1412667 2021-04-23 Ukraine Kherson Oblast     29855 865 23851 5139 46.6354 32.6169 2021-04-24 04:20:38 Kherson Oblast, Ukraine
1412668 1412668 2021-04-23 Ukraine Khmelnytskyi Oblast     81081 1526 64216 15339 49.423 26.9871 2021-04-24 04:20:38 Khmelnytskyi Oblast, Ukraine
1412669 1412669 2021-04-23 Ukraine Kiev     190138 4386 119101 66651 50.4501 30.5234 2021-04-24 04:20:38 Kiev, Ukraine
1412670 1412670 2021-04-23 Ukraine Kiev Oblast     115462 2213 92111 21138 50.053 30.7667 2021-04-24 04:20:38 Kiev Oblast, Ukraine
1412671 1412671 2021-04-23 Ukraine Kirovohrad Oblast     16945 597 10379 5969 48.5079 32.2623 2021-04-24 04:20:38 Kirovohrad Oblast, Ukraine
1412672 1412672 2021-04-23 Ukraine Luhansk Oblast     22127 669 17393 4065 48.574 39.3078 2021-04-24 04:20:38 Luhansk Oblast, Ukraine
1412673 1412673 2021-04-23 Ukraine Lviv Oblast     126096 3135 94544 28417 49.8397 24.0297 2021-04-24 04:20:38 Lviv Oblast, Ukraine
1412674 1412674 2021-04-23 Ukraine Mykolaiv Oblast     60918 1514 48513 10891 46.975 31.9946 2021-04-24 04:20:38 Mykolaiv Oblast, Ukraine
1412675 1412675 2021-04-23 Ukraine Odessa Oblast     129790 2371 92580 34839 46.4846 30.7326 2021-04-24 04:20:38 Odessa Oblast, Ukraine
1412676 1412676 2021-04-23 Ukraine Poltava Oblast     68488 1448 57539 9501 49.5883 34.5514 2021-04-24 04:20:38 Poltava Oblast, Ukraine
1412677 1412677 2021-04-23 Ukraine Rivne Oblast     68939 967 58607 9365 50.6199 26.2516 2021-04-24 04:20:38 Rivne Oblast, Ukraine
1412678 1412678 2021-04-23 Ukraine Sevastopol*     13907 603 12759 545 44.6054 33.522 2021-04-24 04:20:38 Sevastopol*, Ukraine
1412679 1412679 2021-04-23 Ukraine Sumy Oblast     70586 1054 59134 10398 50.9077 34.7981 2021-04-24 04:20:38 Sumy Oblast, Ukraine
1412680 1412680 2021-04-23 Ukraine Ternopil Oblast     64396 1011 54389 8996 49.5535 25.5948 2021-04-24 04:20:38 Ternopil Oblast, Ukraine
1412681 1412681 2021-04-23 Ukraine Vinnytsia Oblast     66463 1440 47412 17611 49.2331 28.4682 2021-04-24 04:20:38 Vinnytsia Oblast, Ukraine
1412682 1412682 2021-04-23 Ukraine Volyn Oblast     55246 944 46264 8038 50.7472 25.3254 2021-04-24 04:20:38 Volyn Oblast, Ukraine
1412683 1412683 2021-04-23 Ukraine Zakarpattia Oblast     59284 1493 50781 7010 48.6208 22.2879 2021-04-24 04:20:38 Zakarpattia Oblast, Ukraine
1412684 1412684 2021-04-23 Ukraine Zaporizhia Oblast     92815 1777 73424 17614 47.8388 35.1396 2021-04-24 04:20:38 Zaporizhia Oblast, Ukraine
1412685 1412685 2021-04-23 Ukraine Zhytomyr Oblast     82482 1519 63308 17655 50.2547 28.6587 2021-04-24 04:20:38 Zhytomyr Oblast, Ukraine
1412739 1412739 2021-04-23 Ukraine Unknown     0 0 0 0     2021-04-24 04:20:38 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]);