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-01-29 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
2485584 2485584 2021-01-28 Ukraine Cherkasy Oblast     45345 535 39757 5053 49.4444 32.0598 2021-01-29 05:22:23 Cherkasy Oblast, Ukraine
2485585 2485585 2021-01-28 Ukraine Chernihiv Oblast     33469 622 25302 7545 51.4982 31.2893 2021-01-29 05:22:23 Chernihiv Oblast, Ukraine
2485586 2485586 2021-01-28 Ukraine Chernivtsi Oblast     44955 863 37833 6259 48.2917 25.9352 2021-01-29 05:22:23 Chernivtsi Oblast, Ukraine
2485587 2485587 2021-01-28 Ukraine Crimea Republic*     31861 737 25952 5172 45.2835 34.2008 2021-01-29 05:22:23 Crimea Republic*, Ukraine
2485588 2485588 2021-01-28 Ukraine Dnipropetrovsk Oblast     66930 1786 58841 6303 48.4647 35.0462 2021-01-29 05:22:23 Dnipropetrovsk Oblast, Ukraine
2485589 2485589 2021-01-28 Ukraine Donetsk Oblast     43564 848 38924 3792 48.0159 37.8028 2021-01-29 05:22:23 Donetsk Oblast, Ukraine
2485590 2485590 2021-01-28 Ukraine Ivano-Frankivsk Oblast     47501 923 42470 4108 48.9226 24.7111 2021-01-29 05:22:23 Ivano-Frankivsk Oblast, Ukraine
2485591 2485591 2021-01-28 Ukraine Kharkiv Oblast     77222 1349 68100 7773 49.9935 36.2304 2021-01-29 05:22:23 Kharkiv Oblast, Ukraine
2485592 2485592 2021-01-28 Ukraine Kherson Oblast     20551 566 16704 3281 46.6354 32.6169 2021-01-29 05:22:23 Kherson Oblast, Ukraine
2485593 2485593 2021-01-28 Ukraine Khmelnytskyi Oblast     43671 782 40143 2746 49.423 26.9871 2021-01-29 05:22:23 Khmelnytskyi Oblast, Ukraine
2485594 2485594 2021-01-28 Ukraine Kiev     127472 2326 63987 61159 50.4501 30.5234 2021-01-29 05:22:23 Kiev, Ukraine
2485595 2485595 2021-01-28 Ukraine Kiev Oblast     68381 1122 54857 12402 50.053 30.7667 2021-01-29 05:22:23 Kiev Oblast, Ukraine
2485596 2485596 2021-01-28 Ukraine Kirovohrad Oblast     9719 320 6617 2782 48.5079 32.2623 2021-01-29 05:22:23 Kirovohrad Oblast, Ukraine
2485597 2485597 2021-01-28 Ukraine Luhansk Oblast     13745 393 11402 1950 48.574 39.3078 2021-01-29 05:22:23 Luhansk Oblast, Ukraine
2485598 2485598 2021-01-28 Ukraine Lviv Oblast     70245 2059 59448 8738 49.8397 24.0297 2021-01-29 05:22:23 Lviv Oblast, Ukraine
2485599 2485599 2021-01-28 Ukraine Mykolaiv Oblast     38501 657 24431 13413 46.975 31.9946 2021-01-29 05:22:23 Mykolaiv Oblast, Ukraine
2485600 2485600 2021-01-28 Ukraine Odessa Oblast     80787 1306 70830 8651 46.4846 30.7326 2021-01-29 05:22:23 Odessa Oblast, Ukraine
2485601 2485601 2021-01-28 Ukraine Poltava Oblast     42771 875 38665 3231 49.5883 34.5514 2021-01-29 05:22:23 Poltava Oblast, Ukraine
2485602 2485602 2021-01-28 Ukraine Rivne Oblast     45498 565 42513 2420 50.6199 26.2516 2021-01-29 05:22:23 Rivne Oblast, Ukraine
2485603 2485603 2021-01-28 Ukraine Sevastopol*     9401 381 8481 539 44.6054 33.522 2021-01-29 05:22:23 Sevastopol*, Ukraine
2485604 2485604 2021-01-28 Ukraine Sumy Oblast     45537 606 42071 2860 50.9077 34.7981 2021-01-29 05:22:23 Sumy Oblast, Ukraine
2485605 2485605 2021-01-28 Ukraine Ternopil Oblast     37396 521 34368 2507 49.5535 25.5948 2021-01-29 05:22:23 Ternopil Oblast, Ukraine
2485606 2485606 2021-01-28 Ukraine Vinnytsia Oblast     26432 496 22274 3662 49.2331 28.4682 2021-01-29 05:22:23 Vinnytsia Oblast, Ukraine
2485607 2485607 2021-01-28 Ukraine Volyn Oblast     36442 571 33881 1990 50.7472 25.3254 2021-01-29 05:22:23 Volyn Oblast, Ukraine
2485608 2485608 2021-01-28 Ukraine Zakarpattia Oblast     31145 711 27573 2861 48.6208 22.2879 2021-01-29 05:22:23 Zakarpattia Oblast, Ukraine
2485609 2485609 2021-01-28 Ukraine Zaporizhia Oblast     65130 812 50345 13973 47.8388 35.1396 2021-01-29 05:22:23 Zaporizhia Oblast, Ukraine
2485610 2485610 2021-01-28 Ukraine Zhytomyr Oblast     44003 737 40695 2571 50.2547 28.6587 2021-01-29 05:22:23 Zhytomyr Oblast, Ukraine
2485667 2485667 2021-01-28 Ukraine Unknown     0 0 0 0     2021-01-29 05:22:23 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]);