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 2020-11-20 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
825182 825182 2020-11-19 Ukraine Cherkasy Oblast     15759 154 7683 7922 49.4444 32.0598 2020-11-20 05:26:28 Cherkasy Oblast, Ukraine
825183 825183 2020-11-19 Ukraine Chernihiv Oblast     12656 90 4399 8167 51.4982 31.2893 2020-11-20 05:26:28 Chernihiv Oblast, Ukraine
825184 825184 2020-11-19 Ukraine Chernivtsi Oblast     29612 587 12600 16425 48.2917 25.9352 2020-11-20 05:26:28 Chernivtsi Oblast, Ukraine
825185 825185 2020-11-19 Ukraine Crimea Republic*     12947 226 8673 4048 45.2835 34.2008 2020-11-20 05:26:28 Crimea Republic*, Ukraine
825186 825186 2020-11-19 Ukraine Dnipropetrovsk Oblast     25028 658 10249 14121 48.4647 35.0462 2020-11-20 05:26:28 Dnipropetrovsk Oblast, Ukraine
825187 825187 2020-11-19 Ukraine Donetsk Oblast     18790 296 7965 10529 48.0159 37.8028 2020-11-20 05:26:28 Donetsk Oblast, Ukraine
825188 825188 2020-11-19 Ukraine Ivano-Frankivsk Oblast     30091 544 12352 17195 48.9226 24.7111 2020-11-20 05:26:28 Ivano-Frankivsk Oblast, Ukraine
825189 825189 2020-11-19 Ukraine Kharkiv Oblast     49618 673 17197 31748 49.9935 36.2304 2020-11-20 05:26:28 Kharkiv Oblast, Ukraine
825190 825190 2020-11-19 Ukraine Kherson Oblast     7946 165 3227 4554 46.6354 32.6169 2020-11-20 05:26:28 Kherson Oblast, Ukraine
825191 825191 2020-11-19 Ukraine Khmelnytskyi Oblast     24485 379 13328 10778 49.423 26.9871 2020-11-20 05:26:28 Khmelnytskyi Oblast, Ukraine
825192 825192 2020-11-19 Ukraine Kiev     55203 1047 20012 34144 50.4501 30.5234 2020-11-20 05:26:28 Kiev, Ukraine
825193 825193 2020-11-19 Ukraine Kiev Oblast     27347 600 10623 16124 50.053 30.7667 2020-11-20 05:26:28 Kiev Oblast, Ukraine
825194 825194 2020-11-19 Ukraine Kirovohrad Oblast     3931 129 1974 1828 48.5079 32.2623 2020-11-20 05:26:28 Kirovohrad Oblast, Ukraine
825195 825195 2020-11-19 Ukraine Luhansk Oblast     5385 133 2922 2330 48.574 39.3078 2020-11-20 05:26:28 Luhansk Oblast, Ukraine
825196 825196 2020-11-19 Ukraine Lviv Oblast     39229 1108 25379 12742 49.8397 24.0297 2020-11-20 05:26:28 Lviv Oblast, Ukraine
825197 825197 2020-11-19 Ukraine Mykolaiv Oblast     13769 259 4378 9132 46.975 31.9946 2020-11-20 05:26:28 Mykolaiv Oblast, Ukraine
825198 825198 2020-11-19 Ukraine Odessa Oblast     35440 489 8436 26515 46.4846 30.7326 2020-11-20 05:26:28 Odessa Oblast, Ukraine
825199 825199 2020-11-19 Ukraine Poltava Oblast     16935 356 8128 8451 49.5883 34.5514 2020-11-20 05:26:28 Poltava Oblast, Ukraine
825200 825200 2020-11-19 Ukraine Rivne Oblast     26442 334 19626 6482 50.6199 26.2516 2020-11-20 05:26:28 Rivne Oblast, Ukraine
825201 825201 2020-11-19 Ukraine Sevastopol*     3695 99 3038 558 44.6054 33.522 2020-11-20 05:26:28 Sevastopol*, Ukraine
825202 825202 2020-11-19 Ukraine Sumy Oblast     20124 291 7445 12388 50.9077 34.7981 2020-11-20 05:26:28 Sumy Oblast, Ukraine
825203 825203 2020-11-19 Ukraine Ternopil Oblast     24552 330 19402 4820 49.5535 25.5948 2020-11-20 05:26:28 Ternopil Oblast, Ukraine
825204 825204 2020-11-19 Ukraine Vinnytsia Oblast     14532 251 8346 5935 49.2331 28.4682 2020-11-20 05:26:28 Vinnytsia Oblast, Ukraine
825205 825205 2020-11-19 Ukraine Volyn Oblast     20150 380 13278 6492 50.7472 25.3254 2020-11-20 05:26:28 Volyn Oblast, Ukraine
825206 825206 2020-11-19 Ukraine Zakarpattia Oblast     20463 489 10426 9548 48.6208 22.2879 2020-11-20 05:26:28 Zakarpattia Oblast, Ukraine
825207 825207 2020-11-19 Ukraine Zaporizhia Oblast     21481 208 3436 17837 47.8388 35.1396 2020-11-20 05:26:28 Zaporizhia Oblast, Ukraine
825208 825208 2020-11-19 Ukraine Zhytomyr Oblast     24542 419 13668 10455 50.2547 28.6587 2020-11-20 05:26:28 Zhytomyr Oblast, Ukraine
825265 825265 2020-11-19 Ukraine Unknown     0 0 0 0     2020-11-20 05:26: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]);