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-08 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
1393285 1393285 2022-01-07 Ukraine Cherkasy Oblast     130005 2667 0   49.4444 32.0598 2022-01-08 04:21:53 Cherkasy Oblast, Ukraine
1393286 1393286 2022-01-07 Ukraine Chernihiv Oblast     95624 2480 0   51.4982 31.2893 2022-01-08 04:21:53 Chernihiv Oblast, Ukraine
1393287 1393287 2022-01-07 Ukraine Chernivtsi Oblast     120027 3029 0   48.2917 25.9352 2022-01-08 04:21:53 Chernivtsi Oblast, Ukraine
1393288 1393288 2022-01-07 Ukraine Crimea Republic*     127466 4487 0   45.2835 34.2008 2022-01-08 04:21:53 Crimea Republic*, Ukraine
1393289 1393289 2022-01-07 Ukraine Dnipropetrovsk Oblast     243188 8922 0   48.4647 35.0462 2022-01-08 04:21:53 Dnipropetrovsk Oblast, Ukraine
1393290 1393290 2022-01-07 Ukraine Donetsk Oblast     168917 5171 0   48.0159 37.8028 2022-01-08 04:21:53 Donetsk Oblast, Ukraine
1393291 1393291 2022-01-07 Ukraine Ivano-Frankivsk Oblast     128728 3122 0   48.9226 24.7111 2022-01-08 04:21:53 Ivano-Frankivsk Oblast, Ukraine
1393292 1393292 2022-01-07 Ukraine Kharkiv Oblast     244877 6412 0   49.9935 36.2304 2022-01-08 04:21:53 Kharkiv Oblast, Ukraine
1393293 1393293 2022-01-07 Ukraine Kherson Oblast     79241 2703 0   46.6354 32.6169 2022-01-08 04:21:53 Kherson Oblast, Ukraine
1393294 1393294 2022-01-07 Ukraine Khmelnytskyi Oblast     147886 3366 0   49.423 26.9871 2022-01-08 04:21:53 Khmelnytskyi Oblast, Ukraine
1393295 1393295 2022-01-07 Ukraine Kiev     337506 8277 0   50.4501 30.5234 2022-01-08 04:21:53 Kiev, Ukraine
1393296 1393296 2022-01-07 Ukraine Kiev Oblast     186709 4716 0   50.053000000000004 30.7667 2022-01-08 04:21:53 Kiev Oblast, Ukraine
1393297 1393297 2022-01-07 Ukraine Kirovohrad Oblast     33405 1549 0   48.5079 32.2623 2022-01-08 04:21:53 Kirovohrad Oblast, Ukraine
1393298 1393298 2022-01-07 Ukraine Luhansk Oblast     60143 2222 0   48.574 39.3078 2022-01-08 04:21:53 Luhansk Oblast, Ukraine
1393299 1393299 2022-01-07 Ukraine Lviv Oblast     221867 6047 0   49.8397 24.0297 2022-01-08 04:21:53 Lviv Oblast, Ukraine
1393300 1393300 2022-01-07 Ukraine Mykolaiv Oblast     115972 3314 0   46.975 31.9946 2022-01-08 04:21:53 Mykolaiv Oblast, Ukraine
1393301 1393301 2022-01-07 Ukraine Odessa Oblast     241468 5605 0   46.4846 30.7326 2022-01-08 04:21:53 Odessa Oblast, Ukraine
1393302 1393302 2022-01-07 Ukraine Poltava Oblast     141565 3793 0   49.5883 34.5514 2022-01-08 04:21:53 Poltava Oblast, Ukraine
1393303 1393303 2022-01-07 Ukraine Rivne Oblast     128190 2290 0   50.6199 26.2516 2022-01-08 04:21:53 Rivne Oblast, Ukraine
1393304 1393304 2022-01-07 Ukraine Sevastopol*     53098 1859 0   44.6054 33.522 2022-01-08 04:21:53 Sevastopol*, Ukraine
1393305 1393305 2022-01-07 Ukraine Sumy Oblast     132027 2854 0   50.9077 34.7981 2022-01-08 04:21:53 Sumy Oblast, Ukraine
1393306 1393306 2022-01-07 Ukraine Ternopil Oblast     108474 2143 0   49.5535 25.5948 2022-01-08 04:21:53 Ternopil Oblast, Ukraine
1393307 1393307 2022-01-07 Ukraine Vinnytsia Oblast     113434 3165 0   49.2331 28.4682 2022-01-08 04:21:53 Vinnytsia Oblast, Ukraine
1393308 1393308 2022-01-07 Ukraine Volyn Oblast     104102 2199 0   50.7472 25.3254 2022-01-08 04:21:53 Volyn Oblast, Ukraine
1393309 1393309 2022-01-07 Ukraine Zakarpattia Oblast     88815 2421 0   48.6208 22.2879 2022-01-08 04:21:53 Zakarpattia Oblast, Ukraine
1393310 1393310 2022-01-07 Ukraine Zaporizhia Oblast     182923 5344 0   47.8388 35.1396 2022-01-08 04:21:53 Zaporizhia Oblast, Ukraine
1393311 1393311 2022-01-07 Ukraine Zhytomyr Oblast     141375 3277 0   50.2547 28.6587 2022-01-08 04:21:53 Zhytomyr Oblast, Ukraine
1393343 1393343 2022-01-07 Ukraine Unknown     0 0 0 0     2022-01-08 04:21:53 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]);