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-02-01 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
2661415 2661415 2022-01-31 Ukraine Cherkasy Oblast     138257 2780 0   49.4444 32.0598 2022-02-01 04:21:11 Cherkasy Oblast, Ukraine
2661416 2661416 2022-01-31 Ukraine Chernihiv Oblast     103672 2593 0   51.4982 31.2893 2022-02-01 04:21:11 Chernihiv Oblast, Ukraine
2661417 2661417 2022-01-31 Ukraine Chernivtsi Oblast     134578 3130 0   48.2917 25.9352 2022-02-01 04:21:11 Chernivtsi Oblast, Ukraine
2661418 2661418 2022-01-31 Ukraine Crimea Republic*     133142 4715 0   45.2835 34.2008 2022-02-01 04:21:11 Crimea Republic*, Ukraine
2661419 2661419 2022-01-31 Ukraine Dnipropetrovsk Oblast     256225 9142 0   48.4647 35.0462 2022-02-01 04:21:11 Dnipropetrovsk Oblast, Ukraine
2661420 2661420 2022-01-31 Ukraine Donetsk Oblast     181101 5307 0   48.0159 37.8028 2022-02-01 04:21:11 Donetsk Oblast, Ukraine
2661421 2661421 2022-01-31 Ukraine Ivano-Frankivsk Oblast     161737 3249 0   48.9226 24.7111 2022-02-01 04:21:11 Ivano-Frankivsk Oblast, Ukraine
2661422 2661422 2022-01-31 Ukraine Kharkiv Oblast     265881 6582 0   49.9935 36.2304 2022-02-01 04:21:11 Kharkiv Oblast, Ukraine
2661423 2661423 2022-01-31 Ukraine Kherson Oblast     85338 2767 0   46.6354 32.6169 2022-02-01 04:21:11 Kherson Oblast, Ukraine
2661424 2661424 2022-01-31 Ukraine Khmelnytskyi Oblast     166991 3483 0   49.423 26.9871 2022-02-01 04:21:11 Khmelnytskyi Oblast, Ukraine
2661425 2661425 2022-01-31 Ukraine Kiev     365630 8505 0   50.4501 30.5234 2022-02-01 04:21:11 Kiev, Ukraine
2661426 2661426 2022-01-31 Ukraine Kiev Oblast     198900 4831 0   50.053000000000004 30.7667 2022-02-01 04:21:11 Kiev Oblast, Ukraine
2661427 2661427 2022-01-31 Ukraine Kirovohrad Oblast     35934 1649 0   48.5079 32.2623 2022-02-01 04:21:11 Kirovohrad Oblast, Ukraine
2661428 2661428 2022-01-31 Ukraine Luhansk Oblast     64934 2271 0   48.574 39.3078 2022-02-01 04:21:11 Luhansk Oblast, Ukraine
2661429 2661429 2022-01-31 Ukraine Lviv Oblast     259934 6218 0   49.8397 24.0297 2022-02-01 04:21:11 Lviv Oblast, Ukraine
2661430 2661430 2022-01-31 Ukraine Mykolaiv Oblast     122360 3395 0   46.975 31.9946 2022-02-01 04:21:11 Mykolaiv Oblast, Ukraine
2661431 2661431 2022-01-31 Ukraine Odessa Oblast     261581 5718 0   46.4846 30.7326 2022-02-01 04:21:11 Odessa Oblast, Ukraine
2661432 2661432 2022-01-31 Ukraine Poltava Oblast     152250 3954 0   49.5883 34.5514 2022-02-01 04:21:11 Poltava Oblast, Ukraine
2661433 2661433 2022-01-31 Ukraine Rivne Oblast     143023 2383 0   50.6199 26.2516 2022-02-01 04:21:11 Rivne Oblast, Ukraine
2661434 2661434 2022-01-31 Ukraine Sevastopol*     57569 1962 0   44.6054 33.522 2022-02-01 04:21:11 Sevastopol*, Ukraine
2661435 2661435 2022-01-31 Ukraine Sumy Oblast     152514 2986 0   50.9077 34.7981 2022-02-01 04:21:11 Sumy Oblast, Ukraine
2661436 2661436 2022-01-31 Ukraine Ternopil Oblast     125332 2231 0   49.5535 25.5948 2022-02-01 04:21:11 Ternopil Oblast, Ukraine
2661437 2661437 2022-01-31 Ukraine Vinnytsia Oblast     131297 3353 0   49.2331 28.4682 2022-02-01 04:21:11 Vinnytsia Oblast, Ukraine
2661438 2661438 2022-01-31 Ukraine Volyn Oblast     110818 2256 0   50.7472 25.3254 2022-02-01 04:21:11 Volyn Oblast, Ukraine
2661439 2661439 2022-01-31 Ukraine Zakarpattia Oblast     98574 2557 0   48.6208 22.2879 2022-02-01 04:21:11 Zakarpattia Oblast, Ukraine
2661440 2661440 2022-01-31 Ukraine Zaporizhia Oblast     188601 5507 0   47.8388 35.1396 2022-02-01 04:21:11 Zaporizhia Oblast, Ukraine
2661441 2661441 2022-01-31 Ukraine Zhytomyr Oblast     159033 3356 0   50.2547 28.6587 2022-02-01 04:21:11 Zhytomyr Oblast, Ukraine
2661473 2661473 2022-01-31 Ukraine Unknown     0 0 0 0     2022-02-01 04:21:11 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]);