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-02-19 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
1156735 1156735 2021-02-18 Ukraine Cherkasy Oblast     47597 605 43940 3052 49.4444 32.0598 2021-02-19 05:24:16 Cherkasy Oblast, Ukraine
1156736 1156736 2021-02-18 Ukraine Chernihiv Oblast     34942 718 30375 3849 51.4982 31.2893 2021-02-19 05:24:16 Chernihiv Oblast, Ukraine
1156737 1156737 2021-02-18 Ukraine Chernivtsi Oblast     49963 942 43311 5710 48.2917 25.9352 2021-02-19 05:24:16 Chernivtsi Oblast, Ukraine
1156738 1156738 2021-02-18 Ukraine Crimea Republic*     34898 877 30550 3471 45.2835 34.2008 2021-02-19 05:24:16 Crimea Republic*, Ukraine
1156739 1156739 2021-02-18 Ukraine Dnipropetrovsk Oblast     70897 1932 65887 3078 48.4647 35.0462 2021-02-19 05:24:16 Dnipropetrovsk Oblast, Ukraine
1156740 1156740 2021-02-18 Ukraine Donetsk Oblast     46051 1028 43048 1975 48.0159 37.8028 2021-02-19 05:24:16 Donetsk Oblast, Ukraine
1156741 1156741 2021-02-18 Ukraine Ivano-Frankivsk Oblast     57299 1077 46165 10057 48.9226 24.7111 2021-02-19 05:24:16 Ivano-Frankivsk Oblast, Ukraine
1156742 1156742 2021-02-18 Ukraine Kharkiv Oblast     81116 1519 74848 4749 49.9935 36.2304 2021-02-19 05:24:16 Kharkiv Oblast, Ukraine
1156743 1156743 2021-02-18 Ukraine Kherson Oblast     21375 624 19716 1035 46.6354 32.6169 2021-02-19 05:24:16 Kherson Oblast, Ukraine
1156744 1156744 2021-02-18 Ukraine Khmelnytskyi Oblast     46132 859 43201 2072 49.423 26.9871 2021-02-19 05:24:16 Khmelnytskyi Oblast, Ukraine
1156745 1156745 2021-02-18 Ukraine Kiev     133347 2557 90140 40650 50.4501 30.5234 2021-02-19 05:24:16 Kiev, Ukraine
1156746 1156746 2021-02-18 Ukraine Kiev Oblast     72455 1208 66117 5130 50.053 30.7667 2021-02-19 05:24:16 Kiev Oblast, Ukraine
1156747 1156747 2021-02-18 Ukraine Kirovohrad Oblast     10227 359 7689 2179 48.5079 32.2623 2021-02-19 05:24:16 Kirovohrad Oblast, Ukraine
1156748 1156748 2021-02-18 Ukraine Luhansk Oblast     14631 437 13200 994 48.574 39.3078 2021-02-19 05:24:16 Luhansk Oblast, Ukraine
1156749 1156749 2021-02-18 Ukraine Lviv Oblast     75069 2210 66855 6004 49.8397 24.0297 2021-02-19 05:24:16 Lviv Oblast, Ukraine
1156750 1156750 2021-02-18 Ukraine Mykolaiv Oblast     40579 760 34274 5545 46.975 31.9946 2021-02-19 05:24:16 Mykolaiv Oblast, Ukraine
1156751 1156751 2021-02-18 Ukraine Odessa Oblast     83885 1389 77122 5374 46.4846 30.7326 2021-02-19 05:24:16 Odessa Oblast, Ukraine
1156752 1156752 2021-02-18 Ukraine Poltava Oblast     44995 948 41767 2280 49.5883 34.5514 2021-02-19 05:24:16 Poltava Oblast, Ukraine
1156753 1156753 2021-02-18 Ukraine Rivne Oblast     47662 603 45621 1438 50.6199 26.2516 2021-02-19 05:24:16 Rivne Oblast, Ukraine
1156754 1156754 2021-02-18 Ukraine Sevastopol*     11293 462 10211 620 44.6054 33.522 2021-02-19 05:24:16 Sevastopol*, Ukraine
1156755 1156755 2021-02-18 Ukraine Sumy Oblast     47323 651 44741 1931 50.9077 34.7981 2021-02-19 05:24:16 Sumy Oblast, Ukraine
1156756 1156756 2021-02-18 Ukraine Ternopil Oblast     40005 578 37518 1909 49.5535 25.5948 2021-02-19 05:24:16 Ternopil Oblast, Ukraine
1156757 1156757 2021-02-18 Ukraine Vinnytsia Oblast     31194 596 25875 4723 49.2331 28.4682 2021-02-19 05:24:16 Vinnytsia Oblast, Ukraine
1156758 1156758 2021-02-18 Ukraine Volyn Oblast     38522 613 35808 2101 50.7472 25.3254 2021-02-19 05:24:16 Volyn Oblast, Ukraine
1156759 1156759 2021-02-18 Ukraine Zakarpattia Oblast     36102 822 29528 5752 48.6208 22.2879 2021-02-19 05:24:16 Zakarpattia Oblast, Ukraine
1156760 1156760 2021-02-18 Ukraine Zaporizhia Oblast     68373 1025 64127 3221 47.8388 35.1396 2021-02-19 05:24:16 Zaporizhia Oblast, Ukraine
1156761 1156761 2021-02-18 Ukraine Zhytomyr Oblast     47400 792 43247 3361 50.2547 28.6587 2021-02-19 05:24:16 Zhytomyr Oblast, Ukraine
1156818 1156818 2021-02-18 Ukraine Unknown     0 0 0 0     2021-02-19 05:24:16 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]);