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-09-19 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
2852445 2852445 2020-09-18 Ukraine Cherkasy Oblast     2891 47 1308 1536 49.4444 32.0598 2020-09-19 04:22:00 Cherkasy Oblast, Ukraine
2852446 2852446 2020-09-18 Ukraine Chernihiv Oblast     3133 46 738 2349 51.4982 31.2893 2020-09-19 04:22:00 Chernihiv Oblast, Ukraine
2852447 2852447 2020-09-18 Ukraine Chernivtsi Oblast     12793 328 7468 4997 48.2917 25.9352 2020-09-19 04:22:00 Chernivtsi Oblast, Ukraine
2852448 2852448 2020-09-18 Ukraine Crimea Republic*     3494 46 2284 1164 45.2835 34.2008 2020-09-19 04:22:00 Crimea Republic*, Ukraine
2852449 2852449 2020-09-18 Ukraine Dnipropetrovsk Oblast     3765 86 1777 1902 48.4647 35.0462 2020-09-19 04:22:00 Dnipropetrovsk Oblast, Ukraine
2852450 2852450 2020-09-18 Ukraine Donetsk Oblast     2313 35 974 1304 48.0159 37.8028 2020-09-19 04:22:00 Donetsk Oblast, Ukraine
2852451 2852451 2020-09-18 Ukraine Ivano-Frankivsk Oblast     12031 274 5219 6538 48.9226 24.7111 2020-09-19 04:22:00 Ivano-Frankivsk Oblast, Ukraine
2852452 2852452 2020-09-18 Ukraine Kharkiv Oblast     14264 291 4102 9871 49.9935 36.2304 2020-09-19 04:22:00 Kharkiv Oblast, Ukraine
2852453 2852453 2020-09-18 Ukraine Kherson Oblast     766 20 411 335 46.6354 32.6169 2020-09-19 04:22:00 Kherson Oblast, Ukraine
2852454 2852454 2020-09-18 Ukraine Khmelnytskyi Oblast     4339 89 2010 2240 49.423 26.9871 2020-09-19 04:22:00 Khmelnytskyi Oblast, Ukraine
2852455 2852455 2020-09-18 Ukraine Kiev     18740 304 5742 12694 50.4501 30.5234 2020-09-19 04:22:00 Kiev, Ukraine
2852456 2852456 2020-09-18 Ukraine Kiev Oblast     7476 150 4889 2437 50.053 30.7667 2020-09-19 04:22:00 Kiev Oblast, Ukraine
2852457 2852457 2020-09-18 Ukraine Kirovohrad Oblast     967 52 772 143 48.5079 32.2623 2020-09-19 04:22:00 Kirovohrad Oblast, Ukraine
2852458 2852458 2020-09-18 Ukraine Luhansk Oblast     706 5 365 336 48.574 39.3078 2020-09-19 04:22:00 Luhansk Oblast, Ukraine
2852459 2852459 2020-09-18 Ukraine Lviv Oblast     17869 507 5901 11461 49.8397 24.0297 2020-09-19 04:22:00 Lviv Oblast, Ukraine
2852460 2852460 2020-09-18 Ukraine Mykolaiv Oblast     2320 56 777 1487 46.975 31.9946 2020-09-19 04:22:00 Mykolaiv Oblast, Ukraine
2852461 2852461 2020-09-18 Ukraine Odessa Oblast     10924 158 2424 8342 46.4846 30.7326 2020-09-19 04:22:00 Odessa Oblast, Ukraine
2852462 2852462 2020-09-18 Ukraine Poltava Oblast     1390 33 687 670 49.5883 34.5514 2020-09-19 04:22:00 Poltava Oblast, Ukraine
2852463 2852463 2020-09-18 Ukraine Rivne Oblast     10917 149 8388 2380 50.6199 26.2516 2020-09-19 04:22:00 Rivne Oblast, Ukraine
2852464 2852464 2020-09-18 Ukraine Sevastopol*     737 21 503 213 44.6054 33.522 2020-09-19 04:22:00 Sevastopol*, Ukraine
2852465 2852465 2020-09-18 Ukraine Sumy Oblast     2807 49 1256 1502 50.9077 34.7981 2020-09-19 04:22:00 Sumy Oblast, Ukraine
2852466 2852466 2020-09-18 Ukraine Ternopil Oblast     10705 128 4663 5914 49.5535 25.5948 2020-09-19 04:22:00 Ternopil Oblast, Ukraine
2852467 2852467 2020-09-18 Ukraine Vinnytsia Oblast     5114 98 3413 1603 49.2331 28.4682 2020-09-19 04:22:00 Vinnytsia Oblast, Ukraine
2852468 2852468 2020-09-18 Ukraine Volyn Oblast     6689 143 4736 1810 50.7472 25.3254 2020-09-19 04:22:00 Volyn Oblast, Ukraine
2852469 2852469 2020-09-18 Ukraine Zakarpattia Oblast     9031 289 4012 4730 48.6208 22.2879 2020-09-19 04:22:00 Zakarpattia Oblast, Ukraine
2852470 2852470 2020-09-18 Ukraine Zaporizhia Oblast     2748 42 1075 1631 47.8388 35.1396 2020-09-19 04:22:00 Zaporizhia Oblast, Ukraine
2852471 2852471 2020-09-18 Ukraine Zhytomyr Oblast     4774 89 2379 2306 50.2547 28.6587 2020-09-19 04:22:00 Zhytomyr Oblast, Ukraine
2852527 2852527 2020-09-18 Ukraine Unknown     0 0 0 0     2020-09-19 04:22:00 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]);