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-08-03 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: last_update (date)

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
3687071 3687071 2021-08-02 Ukraine Cherkasy Oblast     82228 1321 80475 432 49.4444 32.0598 2021-08-03 04:21:39 Cherkasy Oblast, Ukraine
3687072 3687072 2021-08-02 Ukraine Chernihiv Oblast     57787 1353 56043 391 51.4982 31.2893 2021-08-03 04:21:39 Chernihiv Oblast, Ukraine
3687073 3687073 2021-08-02 Ukraine Chernivtsi Oblast     80199 1798 78218 183 48.2917 25.9352 2021-08-03 04:21:39 Chernivtsi Oblast, Ukraine
3687074 3687074 2021-08-02 Ukraine Crimea Republic*     60577 1779 50917 7881 45.2835 34.2008 2021-08-03 04:21:39 Crimea Republic*, Ukraine
3687075 3687075 2021-08-02 Ukraine Dnipropetrovsk Oblast     136547 4513 131378 656 48.4647 35.0462 2021-08-03 04:21:39 Dnipropetrovsk Oblast, Ukraine
3687076 3687076 2021-08-02 Ukraine Donetsk Oblast     91683 2391 88663 629 48.0159 37.8028 2021-08-03 04:21:39 Donetsk Oblast, Ukraine
3687077 3687077 2021-08-02 Ukraine Ivano-Frankivsk Oblast     86889 2108 84646 135 48.9226 24.7111 2021-08-03 04:21:39 Ivano-Frankivsk Oblast, Ukraine
3687078 3687078 2021-08-02 Ukraine Kharkiv Oblast     149513 3605 145143 765 49.9935 36.2304 2021-08-03 04:21:39 Kharkiv Oblast, Ukraine
3687079 3687079 2021-08-02 Ukraine Kherson Oblast     36427 1163 34771 493 46.6354 32.6169 2021-08-03 04:21:39 Kherson Oblast, Ukraine
3687080 3687080 2021-08-02 Ukraine Khmelnytskyi Oblast     89271 1893 87136 242 49.423 26.9871 2021-08-03 04:21:39 Khmelnytskyi Oblast, Ukraine
3687081 3687081 2021-08-02 Ukraine Kiev     219142 5235 209427 4480 50.4501 30.5234 2021-08-03 04:21:39 Kiev, Ukraine
3687082 3687082 2021-08-02 Ukraine Kiev Oblast     128220 2768 124902 550 50.053 30.7667 2021-08-03 04:21:39 Kiev Oblast, Ukraine
3687083 3687083 2021-08-02 Ukraine Kirovohrad Oblast     20749 860 19750 139 48.5079 32.2623 2021-08-03 04:21:39 Kirovohrad Oblast, Ukraine
3687084 3687084 2021-08-02 Ukraine Luhansk Oblast     27170 972 25808 390 48.574 39.3078 2021-08-03 04:21:39 Luhansk Oblast, Ukraine
3687085 3687085 2021-08-02 Ukraine Lviv Oblast     138188 3690 133935 563 49.8397 24.0297 2021-08-03 04:21:39 Lviv Oblast, Ukraine
3687086 3687086 2021-08-02 Ukraine Mykolaiv Oblast     70436 1866 68319 251 46.975 31.9946 2021-08-03 04:21:39 Mykolaiv Oblast, Ukraine
3687087 3687087 2021-08-02 Ukraine Odessa Oblast     142049 3015 137921 1113 46.4846 30.7326 2021-08-03 04:21:39 Odessa Oblast, Ukraine
3687088 3687088 2021-08-02 Ukraine Poltava Oblast     78317 1872 76161 284 49.5883 34.5514 2021-08-03 04:21:39 Poltava Oblast, Ukraine
3687089 3687089 2021-08-02 Ukraine Rivne Oblast     79707 1208 78411 88 50.6199 26.2516 2021-08-03 04:21:39 Rivne Oblast, Ukraine
3687090 3687090 2021-08-02 Ukraine Sevastopol*     21126 862 18334 1930 44.6054 33.522 2021-08-03 04:21:39 Sevastopol*, Ukraine
3687091 3687091 2021-08-02 Ukraine Sumy Oblast     78508 1344 76804 360 50.9077 34.7981 2021-08-03 04:21:39 Sumy Oblast, Ukraine
3687092 3687092 2021-08-02 Ukraine Ternopil Oblast     70259 1204 68918 137 49.5535 25.5948 2021-08-03 04:21:39 Ternopil Oblast, Ukraine
3687093 3687093 2021-08-02 Ukraine Vinnytsia Oblast     71537 1701 69572 264 49.2331 28.4682 2021-08-03 04:21:39 Vinnytsia Oblast, Ukraine
3687094 3687094 2021-08-02 Ukraine Volyn Oblast     62306 1204 61051 51 50.7472 25.3254 2021-08-03 04:21:39 Volyn Oblast, Ukraine
3687095 3687095 2021-08-02 Ukraine Zakarpattia Oblast     62254 1609 60531 114 48.6208 22.2879 2021-08-03 04:21:39 Zakarpattia Oblast, Ukraine
3687096 3687096 2021-08-02 Ukraine Zaporizhia Oblast     105282 2457 102371 454 47.8388 35.1396 2021-08-03 04:21:39 Zaporizhia Oblast, Ukraine
3687097 3687097 2021-08-02 Ukraine Zhytomyr Oblast     88866 1805 86816 245 50.2547 28.6587 2021-08-03 04:21:39 Zhytomyr Oblast, Ukraine
3687147 3687147 2021-08-02 Ukraine Unknown     0 0 0 0     2021-08-03 04:21:39 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]);