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-12-11 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
1603831 1603831 2020-12-10 Ukraine Cherkasy Oblast     29449 247 12485 16717 49.4444 32.0598 2020-12-11 05:26:59 Cherkasy Oblast, Ukraine
1603832 1603832 2020-12-10 Ukraine Chernihiv Oblast     22616 147 7454 15015 51.4982 31.2893 2020-12-11 05:26:59 Chernihiv Oblast, Ukraine
1603833 1603833 2020-12-10 Ukraine Chernivtsi Oblast     36044 691 19607 15746 48.2917 25.9352 2020-12-11 05:26:59 Chernivtsi Oblast, Ukraine
1603834 1603834 2020-12-10 Ukraine Crimea Republic*     17950 353 13918 3679 45.2835 34.2008 2020-12-11 05:26:59 Crimea Republic*, Ukraine
1603835 1603835 2020-12-10 Ukraine Dnipropetrovsk Oblast     46891 1096 31134 14661 48.4647 35.0462 2020-12-11 05:26:59 Dnipropetrovsk Oblast, Ukraine
1603836 1603836 2020-12-10 Ukraine Donetsk Oblast     27678 541 18025 9112 48.0159 37.8028 2020-12-11 05:26:59 Donetsk Oblast, Ukraine
1603837 1603837 2020-12-10 Ukraine Ivano-Frankivsk Oblast     40007 711 15763 23533 48.9226 24.7111 2020-12-11 05:26:59 Ivano-Frankivsk Oblast, Ukraine
1603838 1603838 2020-12-10 Ukraine Kharkiv Oblast     60992 850 42376 17766 49.9935 36.2304 2020-12-11 05:26:59 Kharkiv Oblast, Ukraine
1603839 1603839 2020-12-10 Ukraine Kherson Oblast     13039 291 6060 6688 46.6354 32.6169 2020-12-11 05:26:59 Kherson Oblast, Ukraine
1603840 1603840 2020-12-10 Ukraine Khmelnytskyi Oblast     33426 506 23636 9284 49.423 26.9871 2020-12-11 05:26:59 Khmelnytskyi Oblast, Ukraine
1603841 1603841 2020-12-10 Ukraine Kiev     86437 1525 26847 58065 50.4501 30.5234 2020-12-11 05:26:59 Kiev, Ukraine
1603842 1603842 2020-12-10 Ukraine Kiev Oblast     46211 789 18270 27152 50.053 30.7667 2020-12-11 05:26:59 Kiev Oblast, Ukraine
1603843 1603843 2020-12-10 Ukraine Kirovohrad Oblast     6744 187 2733 3824 48.5079 32.2623 2020-12-11 05:26:59 Kirovohrad Oblast, Ukraine
1603844 1603844 2020-12-10 Ukraine Luhansk Oblast     7436 197 5492 1747 48.574 39.3078 2020-12-11 05:26:59 Luhansk Oblast, Ukraine
1603845 1603845 2020-12-10 Ukraine Lviv Oblast     51915 1427 35755 14733 49.8397 24.0297 2020-12-11 05:26:59 Lviv Oblast, Ukraine
1603846 1603846 2020-12-10 Ukraine Mykolaiv Oblast     22621 364 10158 12099 46.975 31.9946 2020-12-11 05:26:59 Mykolaiv Oblast, Ukraine
1603847 1603847 2020-12-10 Ukraine Odessa Oblast     54840 730 16767 37343 46.4846 30.7326 2020-12-11 05:26:59 Odessa Oblast, Ukraine
1603848 1603848 2020-12-10 Ukraine Poltava Oblast     27772 587 18016 9169 49.5883 34.5514 2020-12-11 05:26:59 Poltava Oblast, Ukraine
1603849 1603849 2020-12-10 Ukraine Rivne Oblast     35034 439 28855 5740 50.6199 26.2516 2020-12-11 05:26:59 Rivne Oblast, Ukraine
1603850 1603850 2020-12-10 Ukraine Sevastopol*     5063 158 4614 291 44.6054 33.522 2020-12-11 05:26:59 Sevastopol*, Ukraine
1603851 1603851 2020-12-10 Ukraine Sumy Oblast     34611 442 20814 13355 50.9077 34.7981 2020-12-11 05:26:59 Sumy Oblast, Ukraine
1603852 1603852 2020-12-10 Ukraine Ternopil Oblast     30462 416 24755 5291 49.5535 25.5948 2020-12-11 05:26:59 Ternopil Oblast, Ukraine
1603853 1603853 2020-12-10 Ukraine Vinnytsia Oblast     19206 329 11256 7621 49.2331 28.4682 2020-12-11 05:26:59 Vinnytsia Oblast, Ukraine
1603854 1603854 2020-12-10 Ukraine Volyn Oblast     27194 462 20023 6709 50.7472 25.3254 2020-12-11 05:26:59 Volyn Oblast, Ukraine
1603855 1603855 2020-12-10 Ukraine Zakarpattia Oblast     25344 570 16943 7831 48.6208 22.2879 2020-12-11 05:26:59 Zakarpattia Oblast, Ukraine
1603856 1603856 2020-12-10 Ukraine Zaporizhia Oblast     39758 372 7956 31430 47.8388 35.1396 2020-12-11 05:26:59 Zaporizhia Oblast, Ukraine
1603857 1603857 2020-12-10 Ukraine Zhytomyr Oblast     32987 554 23841 8592 50.2547 28.6587 2020-12-11 05:26:59 Zhytomyr Oblast, Ukraine
1603914 1603914 2020-12-10 Ukraine Unknown     0 0 0 0     2020-12-11 05:26:59 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]);