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-09-04 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
3978184 3978184 2021-09-03 Ukraine Cherkasy Oblast     83086 1334 0   49.4444 32.0598 2021-09-04 04:21:28 Cherkasy Oblast, Ukraine
3978185 3978185 2021-09-03 Ukraine Chernihiv Oblast     58685 1369 0   51.4982 31.2893 2021-09-04 04:21:28 Chernihiv Oblast, Ukraine
3978186 3978186 2021-09-03 Ukraine Chernivtsi Oblast     82144 1846 0   48.2917 25.9352 2021-09-04 04:21:28 Chernivtsi Oblast, Ukraine
3978187 3978187 2021-09-03 Ukraine Crimea Republic*     71869 2242 0   45.2835 34.2008 2021-09-04 04:21:28 Crimea Republic*, Ukraine
3978188 3978188 2021-09-03 Ukraine Dnipropetrovsk Oblast     138989 4688 0   48.4647 35.0462 2021-09-04 04:21:28 Dnipropetrovsk Oblast, Ukraine
3978189 3978189 2021-09-03 Ukraine Donetsk Oblast     94084 2481 0   48.0159 37.8028 2021-09-04 04:21:28 Donetsk Oblast, Ukraine
3978190 3978190 2021-09-03 Ukraine Ivano-Frankivsk Oblast     88073 2123 0   48.9226 24.7111 2021-09-04 04:21:28 Ivano-Frankivsk Oblast, Ukraine
3978191 3978191 2021-09-03 Ukraine Kharkiv Oblast     152663 3699 0   49.9935 36.2304 2021-09-04 04:21:28 Kharkiv Oblast, Ukraine
3978192 3978192 2021-09-03 Ukraine Kherson Oblast     38204 1227 0   46.6354 32.6169 2021-09-04 04:21:28 Kherson Oblast, Ukraine
3978193 3978193 2021-09-03 Ukraine Khmelnytskyi Oblast     90596 1928 0   49.423 26.9871 2021-09-04 04:21:28 Khmelnytskyi Oblast, Ukraine
3978194 3978194 2021-09-03 Ukraine Kiev     225122 5285 0   50.4501 30.5234 2021-09-04 04:21:28 Kiev, Ukraine
3978195 3978195 2021-09-03 Ukraine Kiev Oblast     129702 2802 0   50.053000000000004 30.7667 2021-09-04 04:21:28 Kiev Oblast, Ukraine
3978196 3978196 2021-09-03 Ukraine Kirovohrad Oblast     21016 874 0   48.5079 32.2623 2021-09-04 04:21:28 Kirovohrad Oblast, Ukraine
3978197 3978197 2021-09-03 Ukraine Luhansk Oblast     28767 1013 0   48.574 39.3078 2021-09-04 04:21:28 Luhansk Oblast, Ukraine
3978198 3978198 2021-09-03 Ukraine Lviv Oblast     140251 3730 0   49.8397 24.0297 2021-09-04 04:21:28 Lviv Oblast, Ukraine
3978199 3978199 2021-09-03 Ukraine Mykolaiv Oblast     71115 1886 0   46.975 31.9946 2021-09-04 04:21:28 Mykolaiv Oblast, Ukraine
3978200 3978200 2021-09-03 Ukraine Odessa Oblast     144992 3086 0   46.4846 30.7326 2021-09-04 04:21:28 Odessa Oblast, Ukraine
3978201 3978201 2021-09-03 Ukraine Poltava Oblast     79226 1886 0   49.5883 34.5514 2021-09-04 04:21:28 Poltava Oblast, Ukraine
3978202 3978202 2021-09-03 Ukraine Rivne Oblast     80501 1217 0   50.6199 26.2516 2021-09-04 04:21:28 Rivne Oblast, Ukraine
3978203 3978203 2021-09-03 Ukraine Sevastopol*     27592 1028 0   44.6054 33.522 2021-09-04 04:21:28 Sevastopol*, Ukraine
3978204 3978204 2021-09-03 Ukraine Sumy Oblast     79569 1356 0   50.9077 34.7981 2021-09-04 04:21:28 Sumy Oblast, Ukraine
3978205 3978205 2021-09-03 Ukraine Ternopil Oblast     71664 1223 0   49.5535 25.5948 2021-09-04 04:21:28 Ternopil Oblast, Ukraine
3978206 3978206 2021-09-03 Ukraine Vinnytsia Oblast     72655 1731 0   49.2331 28.4682 2021-09-04 04:21:28 Vinnytsia Oblast, Ukraine
3978207 3978207 2021-09-03 Ukraine Volyn Oblast     62744 1206 0   50.7472 25.3254 2021-09-04 04:21:28 Volyn Oblast, Ukraine
3978208 3978208 2021-09-03 Ukraine Zakarpattia Oblast     62639 1612 0   48.6208 22.2879 2021-09-04 04:21:28 Zakarpattia Oblast, Ukraine
3978209 3978209 2021-09-03 Ukraine Zaporizhia Oblast     107111 2491 0   47.8388 35.1396 2021-09-04 04:21:28 Zaporizhia Oblast, Ukraine
3978210 3978210 2021-09-03 Ukraine Zhytomyr Oblast     89943 1829 0   50.2547 28.6587 2021-09-04 04:21:28 Zhytomyr Oblast, Ukraine
3978260 3978260 2021-09-03 Ukraine Unknown     0 0 0 0     2021-09-04 04:21:28 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]);