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-04 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
1357921 1357921 2020-09-03 Ukraine Cherkasy Oblast     1670 39 1003 628 49.4444 32.0598 2020-09-04 04:28:26 Cherkasy Oblast, Ukraine
1357922 1357922 2020-09-03 Ukraine Chernihiv Oblast     2050 22 607 1421 51.4982 31.2893 2020-09-04 04:28:26 Chernihiv Oblast, Ukraine
1357923 1357923 2020-09-03 Ukraine Chernivtsi Oblast     10624 289 6394 3941 48.2917 25.9352 2020-09-04 04:28:26 Chernivtsi Oblast, Ukraine
1357924 1357924 2020-09-03 Ukraine Crimea Republic*     2542 31 1744 767 45.2835 34.2008 2020-09-04 04:28:26 Crimea Republic*, Ukraine
1357925 1357925 2020-09-03 Ukraine Dnipropetrovsk Oblast     2518 52 1227 1239 48.4647 35.0462 2020-09-04 04:28:26 Dnipropetrovsk Oblast, Ukraine
1357926 1357926 2020-09-03 Ukraine Donetsk Oblast     1549 23 892 634 48.0159 37.8028 2020-09-04 04:28:26 Donetsk Oblast, Ukraine
1357927 1357927 2020-09-03 Ukraine Ivano-Frankivsk Oblast     9685 227 3547 5911 48.9226 24.7111 2020-09-04 04:28:26 Ivano-Frankivsk Oblast, Ukraine
1357928 1357928 2020-09-03 Ukraine Kharkiv Oblast     9941 218 3273 6450 49.9935 36.2304 2020-09-04 04:28:26 Kharkiv Oblast, Ukraine
1357929 1357929 2020-09-03 Ukraine Kherson Oblast     435 13 286 136 46.6354 32.6169 2020-09-04 04:28:26 Kherson Oblast, Ukraine
1357930 1357930 2020-09-03 Ukraine Khmelnytskyi Oblast     2740 52 1402 1286 49.423 26.9871 2020-09-04 04:28:26 Khmelnytskyi Oblast, Ukraine
1357931 1357931 2020-09-03 Ukraine Kiev     14158 222 4548 9388 50.4501 30.5234 2020-09-04 04:28:26 Kiev, Ukraine
1357932 1357932 2020-09-03 Ukraine Kiev Oblast     5931 102 3825 2004 50.053 30.7667 2020-09-04 04:28:26 Kiev Oblast, Ukraine
1357933 1357933 2020-09-03 Ukraine Kirovohrad Oblast     833 47 701 85 48.5079 32.2623 2020-09-04 04:28:26 Kirovohrad Oblast, Ukraine
1357934 1357934 2020-09-03 Ukraine Luhansk Oblast     373 3 202 168 48.574 39.3078 2020-09-04 04:28:26 Luhansk Oblast, Ukraine
1357935 1357935 2020-09-03 Ukraine Lviv Oblast     15116 423 4640 10053 49.8397 24.0297 2020-09-04 04:28:26 Lviv Oblast, Ukraine
1357936 1357936 2020-09-03 Ukraine Mykolaiv Oblast     1372 34 602 736 46.975 31.9946 2020-09-04 04:28:26 Mykolaiv Oblast, Ukraine
1357937 1357937 2020-09-03 Ukraine Odessa Oblast     7813 113 1902 5798 46.4846 30.7326 2020-09-04 04:28:26 Odessa Oblast, Ukraine
1357938 1357938 2020-09-03 Ukraine Poltava Oblast     855 22 541 292 49.5883 34.5514 2020-09-04 04:28:26 Poltava Oblast, Ukraine
1357939 1357939 2020-09-03 Ukraine Rivne Oblast     9476 134 6873 2469 50.6199 26.2516 2020-09-04 04:28:26 Rivne Oblast, Ukraine
1357940 1357940 2020-09-03 Ukraine Sevastopol*     530 18 408 104 44.6054 33.522 2020-09-04 04:28:26 Sevastopol*, Ukraine
1357941 1357941 2020-09-03 Ukraine Sumy Oblast     1629 27 769 833 50.9077 34.7981 2020-09-04 04:28:26 Sumy Oblast, Ukraine
1357942 1357942 2020-09-03 Ukraine Ternopil Oblast     6637 79 3184 3374 49.5535 25.5948 2020-09-04 04:28:26 Ternopil Oblast, Ukraine
1357943 1357943 2020-09-03 Ukraine Vinnytsia Oblast     4194 85 2873 1236 49.2331 28.4682 2020-09-04 04:28:26 Vinnytsia Oblast, Ukraine
1357944 1357944 2020-09-03 Ukraine Volyn Oblast     5662 123 4031 1508 50.7472 25.3254 2020-09-04 04:28:26 Volyn Oblast, Ukraine
1357945 1357945 2020-09-03 Ukraine Zakarpattia Oblast     7788 267 3389 4132 48.6208 22.2879 2020-09-04 04:28:26 Zakarpattia Oblast, Ukraine
1357946 1357946 2020-09-03 Ukraine Zaporizhia Oblast     1708 25 981 702 47.8388 35.1396 2020-09-04 04:28:26 Zaporizhia Oblast, Ukraine
1357947 1357947 2020-09-03 Ukraine Zhytomyr Oblast     3471 69 1984 1418 50.2547 28.6587 2020-09-04 04:28:26 Zhytomyr Oblast, Ukraine
1358003 1358003 2020-09-03 Ukraine Unknown     0 0 0 0     2020-09-04 04:28:26 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]);