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-11-05 sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), 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
1025995 1025995 2022-11-04 Ukraine Cherkasy Oblast     163768 2973 0   49.4444 32.0598 2022-11-05 04:21:52 Cherkasy Oblast, Ukraine
1025996 1025996 2022-11-04 Ukraine Chernihiv Oblast     126202 2751 0   51.4982 31.2893 2022-11-05 04:21:52 Chernihiv Oblast, Ukraine
1025997 1025997 2022-11-04 Ukraine Chernivtsi Oblast     150465 3290 0   48.2917 25.9352 2022-11-05 04:21:52 Chernivtsi Oblast, Ukraine
1025998 1025998 2022-11-04 Ukraine Crimea Republic*     209066 5404 0   45.2835 34.2008 2022-11-05 04:21:52 Crimea Republic*, Ukraine
1025999 1025999 2022-11-04 Ukraine Dnipropetrovsk Oblast     303551 9454 0   48.4647 35.0462 2022-11-05 04:21:52 Dnipropetrovsk Oblast, Ukraine
1026000 1026000 2022-11-04 Ukraine Donetsk Oblast     216052 5607 0   48.0159 37.8028 2022-11-05 04:21:52 Donetsk Oblast, Ukraine
1026001 1026001 2022-11-04 Ukraine Ivano-Frankivsk Oblast     181629 3476 0   48.9226 24.7111 2022-11-05 04:21:52 Ivano-Frankivsk Oblast, Ukraine
1026002 1026002 2022-11-04 Ukraine Kharkiv Oblast     305661 6858 0   49.9935 36.2304 2022-11-05 04:21:52 Kharkiv Oblast, Ukraine
1026003 1026003 2022-11-04 Ukraine Kherson Oblast     107686 2881 0   46.6354 32.6169 2022-11-05 04:21:52 Kherson Oblast, Ukraine
1026004 1026004 2022-11-04 Ukraine Khmelnytskyi Oblast     201270 3703 0   49.423 26.9871 2022-11-05 04:21:52 Khmelnytskyi Oblast, Ukraine
1026005 1026005 2022-11-04 Ukraine Kiev     445098 8966 0   50.4501 30.5234 2022-11-05 04:21:52 Kiev, Ukraine
1026006 1026006 2022-11-04 Ukraine Kiev Oblast     226220 5019 0   50.053 30.7667 2022-11-05 04:21:52 Kiev Oblast, Ukraine
1026007 1026007 2022-11-04 Ukraine Kirovohrad Oblast     45117 1741 0   48.5079 32.2623 2022-11-05 04:21:52 Kirovohrad Oblast, Ukraine
1026008 1026008 2022-11-04 Ukraine Luhansk Oblast     80033 2392 0   48.574 39.3078 2022-11-05 04:21:52 Luhansk Oblast, Ukraine
1026009 1026009 2022-11-04 Ukraine Lviv Oblast     303357 6569 0   49.8397 24.0297 2022-11-05 04:21:52 Lviv Oblast, Ukraine
1026010 1026010 2022-11-04 Ukraine Mykolaiv Oblast     146174 3530 0   46.975 31.9946 2022-11-05 04:21:52 Mykolaiv Oblast, Ukraine
1026011 1026011 2022-11-04 Ukraine Odessa Oblast     325462 5917 0   46.4846 30.7326 2022-11-05 04:21:52 Odessa Oblast, Ukraine
1026012 1026012 2022-11-04 Ukraine Poltava Oblast     179994 4181 0   49.5883 34.5514 2022-11-05 04:21:52 Poltava Oblast, Ukraine
1026013 1026013 2022-11-04 Ukraine Rivne Oblast     171031 2530 0   50.6199 26.2516 2022-11-05 04:21:52 Rivne Oblast, Ukraine
1026014 1026014 2022-11-04 Ukraine Sevastopol*     96003 2477 0   44.6054 33.522 2022-11-05 04:21:52 Sevastopol*, Ukraine
1026015 1026015 2022-11-04 Ukraine Sumy Oblast     182268 3208 0   50.9077 34.7981 2022-11-05 04:21:52 Sumy Oblast, Ukraine
1026016 1026016 2022-11-04 Ukraine Ternopil Oblast     146363 2391 0   49.5535 25.5948 2022-11-05 04:21:52 Ternopil Oblast, Ukraine
1026017 1026017 2022-11-04 Ukraine Unknown     503008 4681 0       2022-11-05 04:21:52 Unknown, Ukraine
1026018 1026018 2022-11-04 Ukraine Vinnytsia Oblast     149845 3546 0   49.2331 28.4682 2022-11-05 04:21:52 Vinnytsia Oblast, Ukraine
1026019 1026019 2022-11-04 Ukraine Volyn Oblast     132045 2394 0   50.7472 25.3254 2022-11-05 04:21:52 Volyn Oblast, Ukraine
1026020 1026020 2022-11-04 Ukraine Zakarpattia Oblast     112462 2724 0   48.6208 22.2879 2022-11-05 04:21:52 Zakarpattia Oblast, Ukraine
1026021 1026021 2022-11-04 Ukraine Zaporizhia Oblast     215070 5866 0   47.8388 35.1396 2022-11-05 04:21:52 Zaporizhia Oblast, Ukraine
1026022 1026022 2022-11-04 Ukraine Zhytomyr Oblast     192801 3538 0   50.2547 28.6587 2022-11-05 04:21:52 Zhytomyr Oblast, 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]);