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-07-12 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
3663214 3663214 2021-07-11 Ukraine Cherkasy Oblast     81917 1316 80273 328 49.4444 32.0598 2021-07-12 04:21:34 Cherkasy Oblast, Ukraine
3663215 3663215 2021-07-11 Ukraine Chernihiv Oblast     57607 1350 55912 345 51.4982 31.2893 2021-07-12 04:21:34 Chernihiv Oblast, Ukraine
3663216 3663216 2021-07-11 Ukraine Chernivtsi Oblast     80000 1794 78066 140 48.2917 25.9352 2021-07-12 04:21:34 Chernivtsi Oblast, Ukraine
3663217 3663217 2021-07-11 Ukraine Crimea Republic*     52063 1591 45370 5102 45.2835 34.2008 2021-07-12 04:21:34 Crimea Republic*, Ukraine
3663218 3663218 2021-07-11 Ukraine Dnipropetrovsk Oblast     135871 4459 130791 621 48.4647 35.0462 2021-07-12 04:21:34 Dnipropetrovsk Oblast, Ukraine
3663219 3663219 2021-07-11 Ukraine Donetsk Oblast     90885 2367 88140 378 48.0159 37.8028 2021-07-12 04:21:34 Donetsk Oblast, Ukraine
3663220 3663220 2021-07-11 Ukraine Ivano-Frankivsk Oblast     86729 2103 84537 89 48.9226 24.7111 2021-07-12 04:21:34 Ivano-Frankivsk Oblast, Ukraine
3663221 3663221 2021-07-11 Ukraine Kharkiv Oblast     148795 3560 144562 673 49.9935 36.2304 2021-07-12 04:21:34 Kharkiv Oblast, Ukraine
3663222 3663222 2021-07-11 Ukraine Kherson Oblast     35932 1147 34470 315 46.6354 32.6169 2021-07-12 04:21:34 Kherson Oblast, Ukraine
3663223 3663223 2021-07-11 Ukraine Khmelnytskyi Oblast     89020 1881 86908 231 49.423 26.9871 2021-07-12 04:21:34 Khmelnytskyi Oblast, Ukraine
3663224 3663224 2021-07-11 Ukraine Kiev     215664 5204 206632 3828 50.4501 30.5234 2021-07-12 04:21:34 Kiev, Ukraine
3663225 3663225 2021-07-11 Ukraine Kiev Oblast     127777 2759 124299 719 50.053 30.7667 2021-07-12 04:21:34 Kiev Oblast, Ukraine
3663226 3663226 2021-07-11 Ukraine Kirovohrad Oblast     20665 848 19685 132 48.5079 32.2623 2021-07-12 04:21:34 Kirovohrad Oblast, Ukraine
3663227 3663227 2021-07-11 Ukraine Luhansk Oblast     26730 954 25579 197 48.574 39.3078 2021-07-12 04:21:34 Luhansk Oblast, Ukraine
3663228 3663228 2021-07-11 Ukraine Lviv Oblast     137705 3665 133396 644 49.8397 24.0297 2021-07-12 04:21:34 Lviv Oblast, Ukraine
3663229 3663229 2021-07-11 Ukraine Mykolaiv Oblast     70096 1852 68055 189 46.975 31.9946 2021-07-12 04:21:34 Mykolaiv Oblast, Ukraine
3663230 3663230 2021-07-11 Ukraine Odessa Oblast     141000 2995 137353 652 46.4846 30.7326 2021-07-12 04:21:34 Odessa Oblast, Ukraine
3663231 3663231 2021-07-11 Ukraine Poltava Oblast     78012 1866 75851 295 49.5883 34.5514 2021-07-12 04:21:34 Poltava Oblast, Ukraine
3663232 3663232 2021-07-11 Ukraine Rivne Oblast     79566 1206 78263 97 50.6199 26.2516 2021-07-12 04:21:34 Rivne Oblast, Ukraine
3663233 3663233 2021-07-11 Ukraine Sevastopol*     17919 776 15596 1547 44.6054 33.522 2021-07-12 04:21:34 Sevastopol*, Ukraine
3663234 3663234 2021-07-11 Ukraine Sumy Oblast     78063 1326 76420 317 50.9077 34.7981 2021-07-12 04:21:34 Sumy Oblast, Ukraine
3663235 3663235 2021-07-11 Ukraine Ternopil Oblast     70088 1203 68825 60 49.5535 25.5948 2021-07-12 04:21:34 Ternopil Oblast, Ukraine
3663236 3663236 2021-07-11 Ukraine Vinnytsia Oblast     71206 1695 69333 178 49.2331 28.4682 2021-07-12 04:21:34 Vinnytsia Oblast, Ukraine
3663237 3663237 2021-07-11 Ukraine Volyn Oblast     62224 1201 60893 130 50.7472 25.3254 2021-07-12 04:21:34 Volyn Oblast, Ukraine
3663238 3663238 2021-07-11 Ukraine Zakarpattia Oblast     62145 1605 60473 67 48.6208 22.2879 2021-07-12 04:21:34 Zakarpattia Oblast, Ukraine
3663239 3663239 2021-07-11 Ukraine Zaporizhia Oblast     104781 2447 102100 234 47.8388 35.1396 2021-07-12 04:21:34 Zaporizhia Oblast, Ukraine
3663240 3663240 2021-07-11 Ukraine Zhytomyr Oblast     88565 1794 86477 294 50.2547 28.6587 2021-07-12 04:21:34 Zhytomyr Oblast, Ukraine
3663290 3663290 2021-07-11 Ukraine Unknown     0 0 0 0     2021-07-12 04:21:34 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]);