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-04 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
3471797 3471797 2021-08-03 Ukraine Cherkasy Oblast     82260 1322 80492 446 49.4444 32.0598 2021-08-04 04:21:25 Cherkasy Oblast, Ukraine
3471798 3471798 2021-08-03 Ukraine Chernihiv Oblast     57804 1353 56045 406 51.4982 31.2893 2021-08-04 04:21:25 Chernihiv Oblast, Ukraine
3471799 3471799 2021-08-03 Ukraine Chernivtsi Oblast     80212 1798 78223 191 48.2917 25.9352 2021-08-04 04:21:25 Chernivtsi Oblast, Ukraine
3471800 3471800 2021-08-03 Ukraine Crimea Republic*     60945 1793 51107 8045 45.2835 34.2008 2021-08-04 04:21:25 Crimea Republic*, Ukraine
3471801 3471801 2021-08-03 Ukraine Dnipropetrovsk Oblast     136600 4517 131397 686 48.4647 35.0462 2021-08-04 04:21:25 Dnipropetrovsk Oblast, Ukraine
3471802 3471802 2021-08-03 Ukraine Donetsk Oblast     91748 2392 88712 644 48.0159 37.8028 2021-08-04 04:21:25 Donetsk Oblast, Ukraine
3471803 3471803 2021-08-03 Ukraine Ivano-Frankivsk Oblast     86895 2108 84654 133 48.9226 24.7111 2021-08-04 04:21:25 Ivano-Frankivsk Oblast, Ukraine
3471804 3471804 2021-08-03 Ukraine Kharkiv Oblast     149562 3606 145158 798 49.9935 36.2304 2021-08-04 04:21:25 Kharkiv Oblast, Ukraine
3471805 3471805 2021-08-03 Ukraine Kherson Oblast     36463 1163 34793 507 46.6354 32.6169 2021-08-04 04:21:25 Kherson Oblast, Ukraine
3471806 3471806 2021-08-03 Ukraine Khmelnytskyi Oblast     89289 1895 87148 246 49.423 26.9871 2021-08-04 04:21:25 Khmelnytskyi Oblast, Ukraine
3471807 3471807 2021-08-03 Ukraine Kiev     219340 5235 209591 4514 50.4501 30.5234 2021-08-04 04:21:25 Kiev, Ukraine
3471808 3471808 2021-08-03 Ukraine Kiev Oblast     128239 2773 124928 538 50.053 30.7667 2021-08-04 04:21:25 Kiev Oblast, Ukraine
3471809 3471809 2021-08-03 Ukraine Kirovohrad Oblast     20753 860 19752 141 48.5079 32.2623 2021-08-04 04:21:25 Kirovohrad Oblast, Ukraine
3471810 3471810 2021-08-03 Ukraine Luhansk Oblast     27217 973 25828 416 48.574 39.3078 2021-08-04 04:21:25 Luhansk Oblast, Ukraine
3471811 3471811 2021-08-03 Ukraine Lviv Oblast     138236 3690 133959 587 49.8397 24.0297 2021-08-04 04:21:25 Lviv Oblast, Ukraine
3471812 3471812 2021-08-03 Ukraine Mykolaiv Oblast     70447 1867 68336 244 46.975 31.9946 2021-08-04 04:21:25 Mykolaiv Oblast, Ukraine
3471813 3471813 2021-08-03 Ukraine Odessa Oblast     142111 3017 137930 1164 46.4846 30.7326 2021-08-04 04:21:25 Odessa Oblast, Ukraine
3471814 3471814 2021-08-03 Ukraine Poltava Oblast     78331 1874 76184 273 49.5883 34.5514 2021-08-04 04:21:25 Poltava Oblast, Ukraine
3471815 3471815 2021-08-03 Ukraine Rivne Oblast     79722 1208 78411 103 50.6199 26.2516 2021-08-04 04:21:25 Rivne Oblast, Ukraine
3471816 3471816 2021-08-03 Ukraine Sevastopol*     21297 869 18502 1926 44.6054 33.522 2021-08-04 04:21:25 Sevastopol*, Ukraine
3471817 3471817 2021-08-03 Ukraine Sumy Oblast     78532 1344 76824 364 50.9077 34.7981 2021-08-04 04:21:25 Sumy Oblast, Ukraine
3471818 3471818 2021-08-03 Ukraine Ternopil Oblast     70265 1205 68921 139 49.5535 25.5948 2021-08-04 04:21:25 Ternopil Oblast, Ukraine
3471819 3471819 2021-08-03 Ukraine Vinnytsia Oblast     71569 1704 69585 280 49.2331 28.4682 2021-08-04 04:21:25 Vinnytsia Oblast, Ukraine
3471820 3471820 2021-08-03 Ukraine Volyn Oblast     62308 1205 61053 50 50.7472 25.3254 2021-08-04 04:21:25 Volyn Oblast, Ukraine
3471821 3471821 2021-08-03 Ukraine Zakarpattia Oblast     62259 1609 60537 113 48.6208 22.2879 2021-08-04 04:21:25 Zakarpattia Oblast, Ukraine
3471822 3471822 2021-08-03 Ukraine Zaporizhia Oblast     105319 2457 102409 453 47.8388 35.1396 2021-08-04 04:21:25 Zaporizhia Oblast, Ukraine
3471823 3471823 2021-08-03 Ukraine Zhytomyr Oblast     88880 1806 86833 241 50.2547 28.6587 2021-08-04 04:21:25 Zhytomyr Oblast, Ukraine
3471873 3471873 2021-08-03 Ukraine Unknown     0 0 0 0     2021-08-04 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]);