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-07-26 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
1382127 1382127 2021-07-25 Ukraine Cherkasy Oblast     82124 1321 80417 386 49.4444 32.0598 2021-07-26 04:21:28 Cherkasy Oblast, Ukraine
1382128 1382128 2021-07-25 Ukraine Chernihiv Oblast     57713 1352 55986 375 51.4982 31.2893 2021-07-26 04:21:28 Chernihiv Oblast, Ukraine
1382129 1382129 2021-07-25 Ukraine Chernivtsi Oblast     80102 1796 78187 119 48.2917 25.9352 2021-07-26 04:21:28 Chernivtsi Oblast, Ukraine
1382130 1382130 2021-07-25 Ukraine Crimea Republic*     57541 1700 48964 6877 45.2835 34.2008 2021-07-26 04:21:28 Crimea Republic*, Ukraine
1382131 1382131 2021-07-25 Ukraine Dnipropetrovsk Oblast     136275 4496 131266 513 48.4647 35.0462 2021-07-26 04:21:28 Dnipropetrovsk Oblast, Ukraine
1382132 1382132 2021-07-25 Ukraine Donetsk Oblast     91324 2380 88482 462 48.0159 37.8028 2021-07-26 04:21:28 Donetsk Oblast, Ukraine
1382133 1382133 2021-07-25 Ukraine Ivano-Frankivsk Oblast     86817 2107 84607 103 48.9226 24.7111 2021-07-26 04:21:28 Ivano-Frankivsk Oblast, Ukraine
1382134 1382134 2021-07-25 Ukraine Kharkiv Oblast     149158 3591 144910 657 49.9935 36.2304 2021-07-26 04:21:28 Kharkiv Oblast, Ukraine
1382135 1382135 2021-07-25 Ukraine Kherson Oblast     36235 1162 34706 367 46.6354 32.6169 2021-07-26 04:21:28 Kherson Oblast, Ukraine
1382136 1382136 2021-07-25 Ukraine Khmelnytskyi Oblast     89148 1889 87106 153 49.423 26.9871 2021-07-26 04:21:28 Khmelnytskyi Oblast, Ukraine
1382137 1382137 2021-07-25 Ukraine Kiev     217942 5228 208563 4151 50.4501 30.5234 2021-07-26 04:21:28 Kiev, Ukraine
1382138 1382138 2021-07-25 Ukraine Kiev Oblast     128062 2767 124834 461 50.053 30.7667 2021-07-26 04:21:28 Kiev Oblast, Ukraine
1382139 1382139 2021-07-25 Ukraine Kirovohrad Oblast     20703 856 19735 112 48.5079 32.2623 2021-07-26 04:21:28 Kirovohrad Oblast, Ukraine
1382140 1382140 2021-07-25 Ukraine Luhansk Oblast     26998 967 25708 323 48.574 39.3078 2021-07-26 04:21:28 Luhansk Oblast, Ukraine
1382141 1382141 2021-07-25 Ukraine Lviv Oblast     137981 3677 133779 525 49.8397 24.0297 2021-07-26 04:21:28 Lviv Oblast, Ukraine
1382142 1382142 2021-07-25 Ukraine Mykolaiv Oblast     70298 1864 68225 209 46.975 31.9946 2021-07-26 04:21:28 Mykolaiv Oblast, Ukraine
1382143 1382143 2021-07-25 Ukraine Odessa Oblast     141592 3005 137680 907 46.4846 30.7326 2021-07-26 04:21:28 Odessa Oblast, Ukraine
1382144 1382144 2021-07-25 Ukraine Poltava Oblast     78212 1872 76099 241 49.5883 34.5514 2021-07-26 04:21:28 Poltava Oblast, Ukraine
1382145 1382145 2021-07-25 Ukraine Rivne Oblast     79647 1207 78367 73 50.6199 26.2516 2021-07-26 04:21:28 Rivne Oblast, Ukraine
1382146 1382146 2021-07-25 Ukraine Sevastopol*     19785 822 17309 1654 44.6054 33.522 2021-07-26 04:21:28 Sevastopol*, Ukraine
1382147 1382147 2021-07-25 Ukraine Sumy Oblast     78338 1342 76683 313 50.9077 34.7981 2021-07-26 04:21:28 Sumy Oblast, Ukraine
1382148 1382148 2021-07-25 Ukraine Ternopil Oblast     70160 1204 68890 66 49.5535 25.5948 2021-07-26 04:21:28 Ternopil Oblast, Ukraine
1382149 1382149 2021-07-25 Ukraine Vinnytsia Oblast     71371 1699 69481 191 49.2331 28.4682 2021-07-26 04:21:28 Vinnytsia Oblast, Ukraine
1382150 1382150 2021-07-25 Ukraine Volyn Oblast     62272 1204 61015 53 50.7472 25.3254 2021-07-26 04:21:28 Volyn Oblast, Ukraine
1382151 1382151 2021-07-25 Ukraine Zakarpattia Oblast     62205 1608 60498 99 48.6208 22.2879 2021-07-26 04:21:28 Zakarpattia Oblast, Ukraine
1382152 1382152 2021-07-25 Ukraine Zaporizhia Oblast     105050 2451 102312 287 47.8388 35.1396 2021-07-26 04:21:28 Zaporizhia Oblast, Ukraine
1382153 1382153 2021-07-25 Ukraine Zhytomyr Oblast     88723 1802 86659 262 50.2547 28.6587 2021-07-26 04:21:28 Zhytomyr Oblast, Ukraine
1382203 1382203 2021-07-25 Ukraine Unknown     0 0 0 0     2021-07-26 04:21:28 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]);