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-10-28 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
538359 538359 2021-10-27 Ukraine Cherkasy Oblast     98798 1575 0   49.4444 32.0598 2021-10-28 04:22:08 Cherkasy Oblast, Ukraine
538360 538360 2021-10-27 Ukraine Chernihiv Oblast     70475 1625 0   51.4982 31.2893 2021-10-28 04:22:08 Chernihiv Oblast, Ukraine
538361 538361 2021-10-27 Ukraine Chernivtsi Oblast     103856 2362 0   48.2917 25.9352 2021-10-28 04:22:08 Chernivtsi Oblast, Ukraine
538362 538362 2021-10-27 Ukraine Crimea Republic*     93984 2927 0   45.2835 34.2008 2021-10-28 04:22:08 Crimea Republic*, Ukraine
538363 538363 2021-10-27 Ukraine Dnipropetrovsk Oblast     180265 5653 0   48.4647 35.0462 2021-10-28 04:22:08 Dnipropetrovsk Oblast, Ukraine
538364 538364 2021-10-27 Ukraine Donetsk Oblast     123702 3223 0   48.0159 37.8028 2021-10-28 04:22:08 Donetsk Oblast, Ukraine
538365 538365 2021-10-27 Ukraine Ivano-Frankivsk Oblast     100674 2390 0   48.9226 24.7111 2021-10-28 04:22:08 Ivano-Frankivsk Oblast, Ukraine
538366 538366 2021-10-27 Ukraine Kharkiv Oblast     200012 4601 0   49.9935 36.2304 2021-10-28 04:22:08 Kharkiv Oblast, Ukraine
538367 538367 2021-10-27 Ukraine Kherson Oblast     61150 1772 0   46.6354 32.6169 2021-10-28 04:22:08 Kherson Oblast, Ukraine
538368 538368 2021-10-27 Ukraine Khmelnytskyi Oblast     111673 2321 0   49.423 26.9871 2021-10-28 04:22:08 Khmelnytskyi Oblast, Ukraine
538369 538369 2021-10-27 Ukraine Kiev     254337 5991 0   50.4501 30.5234 2021-10-28 04:22:08 Kiev, Ukraine
538370 538370 2021-10-27 Ukraine Kiev Oblast     147562 3186 0   50.053000000000004 30.7667 2021-10-28 04:22:08 Kiev Oblast, Ukraine
538371 538371 2021-10-27 Ukraine Kirovohrad Oblast     24113 957 0   48.5079 32.2623 2021-10-28 04:22:08 Kirovohrad Oblast, Ukraine
538372 538372 2021-10-27 Ukraine Luhansk Oblast     46378 1482 0   48.574 39.3078 2021-10-28 04:22:08 Luhansk Oblast, Ukraine
538373 538373 2021-10-27 Ukraine Lviv Oblast     175890 4446 0   49.8397 24.0297 2021-10-28 04:22:08 Lviv Oblast, Ukraine
538374 538374 2021-10-27 Ukraine Mykolaiv Oblast     82753 2262 0   46.975 31.9946 2021-10-28 04:22:08 Mykolaiv Oblast, Ukraine
538375 538375 2021-10-27 Ukraine Odessa Oblast     184894 3906 0   46.4846 30.7326 2021-10-28 04:22:08 Odessa Oblast, Ukraine
538376 538376 2021-10-27 Ukraine Poltava Oblast     95760 2230 0   49.5883 34.5514 2021-10-28 04:22:08 Poltava Oblast, Ukraine
538377 538377 2021-10-27 Ukraine Rivne Oblast     98056 1531 0   50.6199 26.2516 2021-10-28 04:22:08 Rivne Oblast, Ukraine
538378 538378 2021-10-27 Ukraine Sevastopol*     37642 1299 0   44.6054 33.522 2021-10-28 04:22:08 Sevastopol*, Ukraine
538379 538379 2021-10-27 Ukraine Sumy Oblast     102078 1803 0   50.9077 34.7981 2021-10-28 04:22:08 Sumy Oblast, Ukraine
538380 538380 2021-10-27 Ukraine Ternopil Oblast     87973 1560 0   49.5535 25.5948 2021-10-28 04:22:08 Ternopil Oblast, Ukraine
538381 538381 2021-10-27 Ukraine Vinnytsia Oblast     83024 2001 0   49.2331 28.4682 2021-10-28 04:22:08 Vinnytsia Oblast, Ukraine
538382 538382 2021-10-27 Ukraine Volyn Oblast     75635 1458 0   50.7472 25.3254 2021-10-28 04:22:08 Volyn Oblast, Ukraine
538383 538383 2021-10-27 Ukraine Zakarpattia Oblast     67929 1730 0   48.6208 22.2879 2021-10-28 04:22:08 Zakarpattia Oblast, Ukraine
538384 538384 2021-10-27 Ukraine Zaporizhia Oblast     137454 3224 0   47.8388 35.1396 2021-10-28 04:22:08 Zaporizhia Oblast, Ukraine
538385 538385 2021-10-27 Ukraine Zhytomyr Oblast     111292 2339 0   50.2547 28.6587 2021-10-28 04:22:08 Zhytomyr Oblast, Ukraine
538418 538418 2021-10-27 Ukraine Unknown     0 0 0 0     2021-10-28 04:22:08 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]);