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-06-14 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
3384992 3384992 2021-06-13 Ukraine Cherkasy Oblast     81334 1281 77837 2216 49.4444 32.0598 2021-06-14 04:22:46 Cherkasy Oblast, Ukraine
3384993 3384993 2021-06-13 Ukraine Chernihiv Oblast     57336 1327 55103 906 51.4982 31.2893 2021-06-14 04:22:46 Chernihiv Oblast, Ukraine
3384994 3384994 2021-06-13 Ukraine Chernivtsi Oblast     79690 1785 77142 763 48.2917 25.9352 2021-06-14 04:22:46 Chernivtsi Oblast, Ukraine
3384995 3384995 2021-06-13 Ukraine Crimea Republic*     44905 1415 41630 1860 45.2835 34.2008 2021-06-14 04:22:46 Crimea Republic*, Ukraine
3384996 3384996 2021-06-13 Ukraine Dnipropetrovsk Oblast     134912 4366 127347 3199 48.4647 35.0462 2021-06-14 04:22:46 Dnipropetrovsk Oblast, Ukraine
3384997 3384997 2021-06-13 Ukraine Donetsk Oblast     90129 2310 86535 1284 48.0159 37.8028 2021-06-14 04:22:46 Donetsk Oblast, Ukraine
3384998 3384998 2021-06-13 Ukraine Ivano-Frankivsk Oblast     86543 2082 83370 1091 48.9226 24.7111 2021-06-14 04:22:46 Ivano-Frankivsk Oblast, Ukraine
3384999 3384999 2021-06-13 Ukraine Kharkiv Oblast     147896 3428 140968 3500 49.9935 36.2304 2021-06-14 04:22:46 Kharkiv Oblast, Ukraine
3385000 3385000 2021-06-13 Ukraine Kherson Oblast     35418 1109 32974 1335 46.6354 32.6169 2021-06-14 04:22:46 Kherson Oblast, Ukraine
3385001 3385001 2021-06-13 Ukraine Khmelnytskyi Oblast     88530 1845 85571 1114 49.423 26.9871 2021-06-14 04:22:46 Khmelnytskyi Oblast, Ukraine
3385002 3385002 2021-06-13 Ukraine Kiev     210849 5152 195089 10608 50.4501 30.5234 2021-06-14 04:22:46 Kiev, Ukraine
3385003 3385003 2021-06-13 Ukraine Kiev Oblast     126673 2720 121798 2155 50.053 30.7667 2021-06-14 04:22:46 Kiev Oblast, Ukraine
3385004 3385004 2021-06-13 Ukraine Kirovohrad Oblast     20491 827 18440 1224 48.5079 32.2623 2021-06-14 04:22:46 Kirovohrad Oblast, Ukraine
3385005 3385005 2021-06-13 Ukraine Luhansk Oblast     26386 919 24753 714 48.574 39.3078 2021-06-14 04:22:46 Luhansk Oblast, Ukraine
3385006 3385006 2021-06-13 Ukraine Lviv Oblast     136952 3618 131181 2153 49.8397 24.0297 2021-06-14 04:22:46 Lviv Oblast, Ukraine
3385007 3385007 2021-06-13 Ukraine Mykolaiv Oblast     69441 1822 66894 725 46.975 31.9946 2021-06-14 04:22:46 Mykolaiv Oblast, Ukraine
3385008 3385008 2021-06-13 Ukraine Odessa Oblast     140133 2940 134493 2700 46.4846 30.7326 2021-06-14 04:22:46 Odessa Oblast, Ukraine
3385009 3385009 2021-06-13 Ukraine Poltava Oblast     77476 1830 74680 966 49.5883 34.5514 2021-06-14 04:22:46 Poltava Oblast, Ukraine
3385010 3385010 2021-06-13 Ukraine Rivne Oblast     79161 1196 76851 1114 50.6199 26.2516 2021-06-14 04:22:46 Rivne Oblast, Ukraine
3385011 3385011 2021-06-13 Ukraine Sevastopol*     15283 701 13949 633 44.6054 33.522 2021-06-14 04:22:46 Sevastopol*, Ukraine
3385012 3385012 2021-06-13 Ukraine Sumy Oblast     77511 1301 74972 1238 50.9077 34.7981 2021-06-14 04:22:46 Sumy Oblast, Ukraine
3385013 3385013 2021-06-13 Ukraine Ternopil Oblast     69882 1189 67650 1043 49.5535 25.5948 2021-06-14 04:22:46 Ternopil Oblast, Ukraine
3385014 3385014 2021-06-13 Ukraine Vinnytsia Oblast     70868 1683 68579 606 49.2331 28.4682 2021-06-14 04:22:46 Vinnytsia Oblast, Ukraine
3385015 3385015 2021-06-13 Ukraine Volyn Oblast     61865 1177 59714 974 50.7472 25.3254 2021-06-14 04:22:46 Volyn Oblast, Ukraine
3385016 3385016 2021-06-13 Ukraine Zakarpattia Oblast     61937 1599 59574 764 48.6208 22.2879 2021-06-14 04:22:46 Zakarpattia Oblast, Ukraine
3385017 3385017 2021-06-13 Ukraine Zaporizhia Oblast     104002 2400 100373 1229 47.8388 35.1396 2021-06-14 04:22:46 Zaporizhia Oblast, Ukraine
3385018 3385018 2021-06-13 Ukraine Zhytomyr Oblast     88143 1773 85449 921 50.2547 28.6587 2021-06-14 04:22:46 Zhytomyr Oblast, Ukraine
3385071 3385071 2021-06-13 Ukraine Unknown     0 0 0 0     2021-06-14 04:22:46 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]);