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-09-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
3452463 3452463 2021-09-10 Ukraine Cherkasy Oblast     83465 1335 0   49.4444 32.0598 2021-09-11 04:21:30 Cherkasy Oblast, Ukraine
3452464 3452464 2021-09-10 Ukraine Chernihiv Oblast     59040 1381 0   51.4982 31.2893 2021-09-11 04:21:30 Chernihiv Oblast, Ukraine
3452465 3452465 2021-09-10 Ukraine Chernivtsi Oblast     83264 1870 0   48.2917 25.9352 2021-09-11 04:21:30 Chernivtsi Oblast, Ukraine
3452466 3452466 2021-09-10 Ukraine Crimea Republic*     73570 2341 0   45.2835 34.2008 2021-09-11 04:21:30 Crimea Republic*, Ukraine
3452467 3452467 2021-09-10 Ukraine Dnipropetrovsk Oblast     140024 4723 0   48.4647 35.0462 2021-09-11 04:21:30 Dnipropetrovsk Oblast, Ukraine
3452468 3452468 2021-09-10 Ukraine Donetsk Oblast     94756 2507 0   48.0159 37.8028 2021-09-11 04:21:30 Donetsk Oblast, Ukraine
3452469 3452469 2021-09-10 Ukraine Ivano-Frankivsk Oblast     88561 2139 0   48.9226 24.7111 2021-09-11 04:21:30 Ivano-Frankivsk Oblast, Ukraine
3452470 3452470 2021-09-10 Ukraine Kharkiv Oblast     154126 3736 0   49.9935 36.2304 2021-09-11 04:21:30 Kharkiv Oblast, Ukraine
3452471 3452471 2021-09-10 Ukraine Kherson Oblast     38702 1246 0   46.6354 32.6169 2021-09-11 04:21:30 Kherson Oblast, Ukraine
3452472 3452472 2021-09-10 Ukraine Khmelnytskyi Oblast     91232 1943 0   49.423 26.9871 2021-09-11 04:21:30 Khmelnytskyi Oblast, Ukraine
3452473 3452473 2021-09-10 Ukraine Kiev     227132 5298 0   50.4501 30.5234 2021-09-11 04:21:30 Kiev, Ukraine
3452474 3452474 2021-09-10 Ukraine Kiev Oblast     130335 2816 0   50.053000000000004 30.7667 2021-09-11 04:21:30 Kiev Oblast, Ukraine
3452475 3452475 2021-09-10 Ukraine Kirovohrad Oblast     21127 876 0   48.5079 32.2623 2021-09-11 04:21:30 Kirovohrad Oblast, Ukraine
3452476 3452476 2021-09-10 Ukraine Luhansk Oblast     29371 1019 0   48.574 39.3078 2021-09-11 04:21:30 Luhansk Oblast, Ukraine
3452477 3452477 2021-09-10 Ukraine Lviv Oblast     141482 3741 0   49.8397 24.0297 2021-09-11 04:21:30 Lviv Oblast, Ukraine
3452478 3452478 2021-09-10 Ukraine Mykolaiv Oblast     71388 1890 0   46.975 31.9946 2021-09-11 04:21:30 Mykolaiv Oblast, Ukraine
3452479 3452479 2021-09-10 Ukraine Odessa Oblast     146100 3105 0   46.4846 30.7326 2021-09-11 04:21:30 Odessa Oblast, Ukraine
3452480 3452480 2021-09-10 Ukraine Poltava Oblast     79616 1892 0   49.5883 34.5514 2021-09-11 04:21:30 Poltava Oblast, Ukraine
3452481 3452481 2021-09-10 Ukraine Rivne Oblast     81056 1226 0   50.6199 26.2516 2021-09-11 04:21:30 Rivne Oblast, Ukraine
3452482 3452482 2021-09-10 Ukraine Sevastopol*     28419 1056 0   44.6054 33.522 2021-09-11 04:21:30 Sevastopol*, Ukraine
3452483 3452483 2021-09-10 Ukraine Sumy Oblast     79943 1363 0   50.9077 34.7981 2021-09-11 04:21:30 Sumy Oblast, Ukraine
3452484 3452484 2021-09-10 Ukraine Ternopil Oblast     72304 1233 0   49.5535 25.5948 2021-09-11 04:21:30 Ternopil Oblast, Ukraine
3452485 3452485 2021-09-10 Ukraine Vinnytsia Oblast     73142 1734 0   49.2331 28.4682 2021-09-11 04:21:30 Vinnytsia Oblast, Ukraine
3452486 3452486 2021-09-10 Ukraine Volyn Oblast     63134 1210 0   50.7472 25.3254 2021-09-11 04:21:30 Volyn Oblast, Ukraine
3452487 3452487 2021-09-10 Ukraine Zakarpattia Oblast     62765 1615 0   48.6208 22.2879 2021-09-11 04:21:30 Zakarpattia Oblast, Ukraine
3452488 3452488 2021-09-10 Ukraine Zaporizhia Oblast     107966 2515 0   47.8388 35.1396 2021-09-11 04:21:30 Zaporizhia Oblast, Ukraine
3452489 3452489 2021-09-10 Ukraine Zhytomyr Oblast     90523 1838 0   50.2547 28.6587 2021-09-11 04:21:30 Zhytomyr Oblast, Ukraine
3452539 3452539 2021-09-10 Ukraine Unknown     0 0 0 0     2021-09-11 04:21:30 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]);