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 2022-01-15 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
102950 102950 2022-01-14 Ukraine Cherkasy Oblast     131221 2701 0   49.4444 32.0598 2022-01-15 04:21:07 Cherkasy Oblast, Ukraine
102951 102951 2022-01-14 Ukraine Chernihiv Oblast     96594 2523 0   51.4982 31.2893 2022-01-15 04:21:07 Chernihiv Oblast, Ukraine
102952 102952 2022-01-14 Ukraine Chernivtsi Oblast     121396 3044 0   48.2917 25.9352 2022-01-15 04:21:07 Chernivtsi Oblast, Ukraine
102953 102953 2022-01-14 Ukraine Crimea Republic*     128019 4557 0   45.2835 34.2008 2022-01-15 04:21:07 Crimea Republic*, Ukraine
102954 102954 2022-01-14 Ukraine Dnipropetrovsk Oblast     244598 9008 0   48.4647 35.0462 2022-01-15 04:21:07 Dnipropetrovsk Oblast, Ukraine
102955 102955 2022-01-14 Ukraine Donetsk Oblast     170252 5210 0   48.0159 37.8028 2022-01-15 04:21:07 Donetsk Oblast, Ukraine
102956 102956 2022-01-14 Ukraine Ivano-Frankivsk Oblast     131722 3158 0   48.9226 24.7111 2022-01-15 04:21:07 Ivano-Frankivsk Oblast, Ukraine
102957 102957 2022-01-14 Ukraine Kharkiv Oblast     247455 6458 0   49.9935 36.2304 2022-01-15 04:21:07 Kharkiv Oblast, Ukraine
102958 102958 2022-01-14 Ukraine Kherson Oblast     79742 2719 0   46.6354 32.6169 2022-01-15 04:21:07 Kherson Oblast, Ukraine
102959 102959 2022-01-14 Ukraine Khmelnytskyi Oblast     149518 3406 0   49.423 26.9871 2022-01-15 04:21:07 Khmelnytskyi Oblast, Ukraine
102960 102960 2022-01-14 Ukraine Kiev     343165 8345 0   50.4501 30.5234 2022-01-15 04:21:07 Kiev, Ukraine
102961 102961 2022-01-14 Ukraine Kiev Oblast     188475 4764 0   50.053000000000004 30.7667 2022-01-15 04:21:07 Kiev Oblast, Ukraine
102962 102962 2022-01-14 Ukraine Kirovohrad Oblast     33812 1583 0   48.5079 32.2623 2022-01-15 04:21:07 Kirovohrad Oblast, Ukraine
102963 102963 2022-01-14 Ukraine Luhansk Oblast     60637 2230 0   48.574 39.3078 2022-01-15 04:21:07 Luhansk Oblast, Ukraine
102964 102964 2022-01-14 Ukraine Lviv Oblast     225081 6093 0   49.8397 24.0297 2022-01-15 04:21:07 Lviv Oblast, Ukraine
102965 102965 2022-01-14 Ukraine Mykolaiv Oblast     116770 3347 0   46.975 31.9946 2022-01-15 04:21:07 Mykolaiv Oblast, Ukraine
102966 102966 2022-01-14 Ukraine Odessa Oblast     243511 5631 0   46.4846 30.7326 2022-01-15 04:21:07 Odessa Oblast, Ukraine
102967 102967 2022-01-14 Ukraine Poltava Oblast     143617 3855 0   49.5883 34.5514 2022-01-15 04:21:07 Poltava Oblast, Ukraine
102968 102968 2022-01-14 Ukraine Rivne Oblast     129359 2309 0   50.6199 26.2516 2022-01-15 04:21:07 Rivne Oblast, Ukraine
102969 102969 2022-01-14 Ukraine Sevastopol*     53622 1896 0   44.6054 33.522 2022-01-15 04:21:07 Sevastopol*, Ukraine
102970 102970 2022-01-14 Ukraine Sumy Oblast     134086 2893 0   50.9077 34.7981 2022-01-15 04:21:07 Sumy Oblast, Ukraine
102971 102971 2022-01-14 Ukraine Ternopil Oblast     109905 2169 0   49.5535 25.5948 2022-01-15 04:21:07 Ternopil Oblast, Ukraine
102972 102972 2022-01-14 Ukraine Vinnytsia Oblast     115673 3228 0   49.2331 28.4682 2022-01-15 04:21:07 Vinnytsia Oblast, Ukraine
102973 102973 2022-01-14 Ukraine Volyn Oblast     104690 2215 0   50.7472 25.3254 2022-01-15 04:21:07 Volyn Oblast, Ukraine
102974 102974 2022-01-14 Ukraine Zakarpattia Oblast     90045 2463 0   48.6208 22.2879 2022-01-15 04:21:07 Zakarpattia Oblast, Ukraine
102975 102975 2022-01-14 Ukraine Zaporizhia Oblast     183674 5421 0   47.8388 35.1396 2022-01-15 04:21:07 Zaporizhia Oblast, Ukraine
102976 102976 2022-01-14 Ukraine Zhytomyr Oblast     142512 3295 0   50.2547 28.6587 2022-01-15 04:21:07 Zhytomyr Oblast, Ukraine
103008 103008 2022-01-14 Ukraine Unknown     0 0 0 0     2022-01-15 04:21:07 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]);