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 2022-01-23 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
2836455 2836455 2022-01-22 Ukraine Cherkasy Oblast     133299 2743 0   49.4444 32.0598 2022-01-23 04:21:13 Cherkasy Oblast, Ukraine
2836456 2836456 2022-01-22 Ukraine Chernihiv Oblast     98564 2561 0   51.4982 31.2893 2022-01-23 04:21:13 Chernihiv Oblast, Ukraine
2836457 2836457 2022-01-22 Ukraine Chernivtsi Oblast     125859 3080 0   48.2917 25.9352 2022-01-23 04:21:13 Chernivtsi Oblast, Ukraine
2836458 2836458 2022-01-22 Ukraine Crimea Republic*     129515 4637 0   45.2835 34.2008 2022-01-23 04:21:13 Crimea Republic*, Ukraine
2836459 2836459 2022-01-22 Ukraine Dnipropetrovsk Oblast     248003 9087 0   48.4647 35.0462 2022-01-23 04:21:13 Dnipropetrovsk Oblast, Ukraine
2836460 2836460 2022-01-22 Ukraine Donetsk Oblast     173470 5261 0   48.0159 37.8028 2022-01-23 04:21:13 Donetsk Oblast, Ukraine
2836461 2836461 2022-01-22 Ukraine Ivano-Frankivsk Oblast     143998 3190 0   48.9226 24.7111 2022-01-23 04:21:13 Ivano-Frankivsk Oblast, Ukraine
2836462 2836462 2022-01-22 Ukraine Kharkiv Oblast     253880 6538 0   49.9935 36.2304 2022-01-23 04:21:13 Kharkiv Oblast, Ukraine
2836463 2836463 2022-01-22 Ukraine Kherson Oblast     81188 2740 0   46.6354 32.6169 2022-01-23 04:21:13 Kherson Oblast, Ukraine
2836464 2836464 2022-01-22 Ukraine Khmelnytskyi Oblast     154030 3442 0   49.423 26.9871 2022-01-23 04:21:13 Khmelnytskyi Oblast, Ukraine
2836465 2836465 2022-01-22 Ukraine Kiev     352201 8426 0   50.4501 30.5234 2022-01-23 04:21:13 Kiev, Ukraine
2836466 2836466 2022-01-22 Ukraine Kiev Oblast     192021 4799 0   50.053000000000004 30.7667 2022-01-23 04:21:13 Kiev Oblast, Ukraine
2836467 2836467 2022-01-22 Ukraine Kirovohrad Oblast     34503 1622 0   48.5079 32.2623 2022-01-23 04:21:13 Kirovohrad Oblast, Ukraine
2836468 2836468 2022-01-22 Ukraine Luhansk Oblast     61952 2253 0   48.574 39.3078 2022-01-23 04:21:13 Luhansk Oblast, Ukraine
2836469 2836469 2022-01-22 Ukraine Lviv Oblast     236286 6142 0   49.8397 24.0297 2022-01-23 04:21:13 Lviv Oblast, Ukraine
2836470 2836470 2022-01-22 Ukraine Mykolaiv Oblast     118259 3373 0   46.975 31.9946 2022-01-23 04:21:13 Mykolaiv Oblast, Ukraine
2836471 2836471 2022-01-22 Ukraine Odessa Oblast     248344 5681 0   46.4846 30.7326 2022-01-23 04:21:13 Odessa Oblast, Ukraine
2836472 2836472 2022-01-22 Ukraine Poltava Oblast     146978 3916 0   49.5883 34.5514 2022-01-23 04:21:13 Poltava Oblast, Ukraine
2836473 2836473 2022-01-22 Ukraine Rivne Oblast     133089 2337 0   50.6199 26.2516 2022-01-23 04:21:13 Rivne Oblast, Ukraine
2836474 2836474 2022-01-22 Ukraine Sevastopol*     54672 1927 0   44.6054 33.522 2022-01-23 04:21:13 Sevastopol*, Ukraine
2836475 2836475 2022-01-22 Ukraine Sumy Oblast     140186 2934 0   50.9077 34.7981 2022-01-23 04:21:13 Sumy Oblast, Ukraine
2836476 2836476 2022-01-22 Ukraine Ternopil Oblast     115000 2197 0   49.5535 25.5948 2022-01-23 04:21:13 Ternopil Oblast, Ukraine
2836477 2836477 2022-01-22 Ukraine Vinnytsia Oblast     120610 3287 0   49.2331 28.4682 2022-01-23 04:21:13 Vinnytsia Oblast, Ukraine
2836478 2836478 2022-01-22 Ukraine Volyn Oblast     106510 2231 0   50.7472 25.3254 2022-01-23 04:21:13 Volyn Oblast, Ukraine
2836479 2836479 2022-01-22 Ukraine Zakarpattia Oblast     92743 2510 0   48.6208 22.2879 2022-01-23 04:21:13 Zakarpattia Oblast, Ukraine
2836480 2836480 2022-01-22 Ukraine Zaporizhia Oblast     185106 5457 0   47.8388 35.1396 2022-01-23 04:21:13 Zaporizhia Oblast, Ukraine
2836481 2836481 2022-01-22 Ukraine Zhytomyr Oblast     145932 3322 0   50.2547 28.6587 2022-01-23 04:21:13 Zhytomyr Oblast, Ukraine
2836513 2836513 2022-01-22 Ukraine Unknown     0 0 0 0     2022-01-23 04:21:13 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]);