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-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
1345910 1345910 2021-08-11 Ukraine Cherkasy Oblast     82407 1327 0   49.4444 32.0598 2021-08-12 04:21:25 Cherkasy Oblast, Ukraine
1345911 1345911 2021-08-11 Ukraine Chernihiv Oblast     57937 1354 0   51.4982 31.2893 2021-08-12 04:21:25 Chernihiv Oblast, Ukraine
1345912 1345912 2021-08-11 Ukraine Chernivtsi Oblast     80385 1802 0   48.2917 25.9352 2021-08-12 04:21:25 Chernivtsi Oblast, Ukraine
1345913 1345913 2021-08-11 Ukraine Crimea Republic*     64015 1906 0   45.2835 34.2008 2021-08-12 04:21:25 Crimea Republic*, Ukraine
1345914 1345914 2021-08-11 Ukraine Dnipropetrovsk Oblast     137015 4542 0   48.4647 35.0462 2021-08-12 04:21:25 Dnipropetrovsk Oblast, Ukraine
1345915 1345915 2021-08-11 Ukraine Donetsk Oblast     92192 2416 0   48.0159 37.8028 2021-08-12 04:21:25 Donetsk Oblast, Ukraine
1345916 1345916 2021-08-11 Ukraine Ivano-Frankivsk Oblast     87036 2109 0   48.9226 24.7111 2021-08-12 04:21:25 Ivano-Frankivsk Oblast, Ukraine
1345917 1345917 2021-08-11 Ukraine Kharkiv Oblast     150071 3621 0   49.9935 36.2304 2021-08-12 04:21:25 Kharkiv Oblast, Ukraine
1345918 1345918 2021-08-11 Ukraine Kherson Oblast     36930 1187 0   46.6354 32.6169 2021-08-12 04:21:25 Kherson Oblast, Ukraine
1345919 1345919 2021-08-11 Ukraine Khmelnytskyi Oblast     89530 1896 0   49.423 26.9871 2021-08-12 04:21:25 Khmelnytskyi Oblast, Ukraine
1345920 1345920 2021-08-11 Ukraine Kiev     220560 5250 0   50.4501 30.5234 2021-08-12 04:21:25 Kiev, Ukraine
1345921 1345921 2021-08-11 Ukraine Kiev Oblast     128498 2779 0   50.053000000000004 30.7667 2021-08-12 04:21:25 Kiev Oblast, Ukraine
1345922 1345922 2021-08-11 Ukraine Kirovohrad Oblast     20796 862 0   48.5079 32.2623 2021-08-12 04:21:25 Kirovohrad Oblast, Ukraine
1345923 1345923 2021-08-11 Ukraine Luhansk Oblast     27472 981 0   48.574 39.3078 2021-08-12 04:21:25 Luhansk Oblast, Ukraine
1345924 1345924 2021-08-11 Ukraine Lviv Oblast     138536 3701 0   49.8397 24.0297 2021-08-12 04:21:25 Lviv Oblast, Ukraine
1345925 1345925 2021-08-11 Ukraine Mykolaiv Oblast     70566 1869 0   46.975 31.9946 2021-08-12 04:21:25 Mykolaiv Oblast, Ukraine
1345926 1345926 2021-08-11 Ukraine Odessa Oblast     142614 3026 0   46.4846 30.7326 2021-08-12 04:21:25 Odessa Oblast, Ukraine
1345927 1345927 2021-08-11 Ukraine Poltava Oblast     78504 1874 0   49.5883 34.5514 2021-08-12 04:21:25 Poltava Oblast, Ukraine
1345928 1345928 2021-08-11 Ukraine Rivne Oblast     79853 1208 0   50.6199 26.2516 2021-08-12 04:21:25 Rivne Oblast, Ukraine
1345929 1345929 2021-08-11 Ukraine Sevastopol*     22926 922 0   44.6054 33.522 2021-08-12 04:21:25 Sevastopol*, Ukraine
1345930 1345930 2021-08-11 Ukraine Sumy Oblast     78722 1346 0   50.9077 34.7981 2021-08-12 04:21:25 Sumy Oblast, Ukraine
1345931 1345931 2021-08-11 Ukraine Ternopil Oblast     70513 1205 0   49.5535 25.5948 2021-08-12 04:21:25 Ternopil Oblast, Ukraine
1345932 1345932 2021-08-11 Ukraine Vinnytsia Oblast     71811 1709 0   49.2331 28.4682 2021-08-12 04:21:25 Vinnytsia Oblast, Ukraine
1345933 1345933 2021-08-11 Ukraine Volyn Oblast     62350 1205 0   50.7472 25.3254 2021-08-12 04:21:25 Volyn Oblast, Ukraine
1345934 1345934 2021-08-11 Ukraine Zakarpattia Oblast     62334 1611 0   48.6208 22.2879 2021-08-12 04:21:25 Zakarpattia Oblast, Ukraine
1345935 1345935 2021-08-11 Ukraine Zaporizhia Oblast     105678 2458 0   47.8388 35.1396 2021-08-12 04:21:25 Zaporizhia Oblast, Ukraine
1345936 1345936 2021-08-11 Ukraine Zhytomyr Oblast     89044 1811 0   50.2547 28.6587 2021-08-12 04:21:25 Zhytomyr Oblast, Ukraine
1345986 1345986 2021-08-11 Ukraine Unknown     0 0 0 0     2021-08-12 04:21:25 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]);