johns_hopkins_csse_daily_reports
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-19 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 28
- Cherkasy Oblast 1
- Chernihiv Oblast 1
- Chernivtsi Oblast 1
- Crimea Republic* 1
- Dnipropetrovsk Oblast 1
- Donetsk Oblast 1
- Ivano-Frankivsk Oblast 1
- Kharkiv Oblast 1
- Kherson Oblast 1
- Khmelnytskyi Oblast 1
- Kiev 1
- Kiev Oblast 1
- Kirovohrad Oblast 1
- Luhansk Oblast 1
- Lviv Oblast 1
- Mykolaiv Oblast 1
- Odessa Oblast 1
- Poltava Oblast 1
- Rivne Oblast 1
- Sevastopol* 1
- Sumy Oblast 1
- Ternopil Oblast 1
- Unknown 1
- Vinnytsia Oblast 1
- Volyn Oblast 1
- Zakarpattia Oblast 1
- Zaporizhia Oblast 1
- Zhytomyr Oblast 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19976 | 19976 | 2021-09-18 | Ukraine | Cherkasy Oblast | 84523 | 1338 | 0 | 49.4444 | 32.0598 | 2021-09-19 04:21:34 | Cherkasy Oblast, Ukraine | |||
19977 | 19977 | 2021-09-18 | Ukraine | Chernihiv Oblast | 59723 | 1395 | 0 | 51.4982 | 31.2893 | 2021-09-19 04:21:34 | Chernihiv Oblast, Ukraine | |||
19978 | 19978 | 2021-09-18 | Ukraine | Chernivtsi Oblast | 85060 | 1914 | 0 | 48.2917 | 25.9352 | 2021-09-19 04:21:34 | Chernivtsi Oblast, Ukraine | |||
19979 | 19979 | 2021-09-18 | Ukraine | Crimea Republic* | 75437 | 2442 | 0 | 45.2835 | 34.2008 | 2021-09-19 04:21:34 | Crimea Republic*, Ukraine | |||
19980 | 19980 | 2021-09-18 | Ukraine | Dnipropetrovsk Oblast | 142273 | 4761 | 0 | 48.4647 | 35.0462 | 2021-09-19 04:21:34 | Dnipropetrovsk Oblast, Ukraine | |||
19981 | 19981 | 2021-09-18 | Ukraine | Donetsk Oblast | 96369 | 2532 | 0 | 48.0159 | 37.8028 | 2021-09-19 04:21:34 | Donetsk Oblast, Ukraine | |||
19982 | 19982 | 2021-09-18 | Ukraine | Ivano-Frankivsk Oblast | 89539 | 2149 | 0 | 48.9226 | 24.7111 | 2021-09-19 04:21:34 | Ivano-Frankivsk Oblast, Ukraine | |||
19983 | 19983 | 2021-09-18 | Ukraine | Kharkiv Oblast | 157205 | 3795 | 0 | 49.9935 | 36.2304 | 2021-09-19 04:21:34 | Kharkiv Oblast, Ukraine | |||
19984 | 19984 | 2021-09-18 | Ukraine | Kherson Oblast | 39664 | 1280 | 0 | 46.6354 | 32.6169 | 2021-09-19 04:21:34 | Kherson Oblast, Ukraine | |||
19985 | 19985 | 2021-09-18 | Ukraine | Khmelnytskyi Oblast | 92513 | 1965 | 0 | 49.423 | 26.9871 | 2021-09-19 04:21:34 | Khmelnytskyi Oblast, Ukraine | |||
19986 | 19986 | 2021-09-18 | Ukraine | Kiev | 229918 | 5330 | 0 | 50.4501 | 30.5234 | 2021-09-19 04:21:34 | Kiev, Ukraine | |||
19987 | 19987 | 2021-09-18 | Ukraine | Kiev Oblast | 131446 | 2831 | 0 | 50.053000000000004 | 30.7667 | 2021-09-19 04:21:34 | Kiev Oblast, Ukraine | |||
19988 | 19988 | 2021-09-18 | Ukraine | Kirovohrad Oblast | 21321 | 878 | 0 | 48.5079 | 32.2623 | 2021-09-19 04:21:34 | Kirovohrad Oblast, Ukraine | |||
19989 | 19989 | 2021-09-18 | Ukraine | Luhansk Oblast | 30775 | 1040 | 0 | 48.574 | 39.3078 | 2021-09-19 04:21:34 | Luhansk Oblast, Ukraine | |||
19990 | 19990 | 2021-09-18 | Ukraine | Lviv Oblast | 144380 | 3775 | 0 | 49.8397 | 24.0297 | 2021-09-19 04:21:34 | Lviv Oblast, Ukraine | |||
19991 | 19991 | 2021-09-18 | Ukraine | Mykolaiv Oblast | 71983 | 1904 | 0 | 46.975 | 31.9946 | 2021-09-19 04:21:34 | Mykolaiv Oblast, Ukraine | |||
19992 | 19992 | 2021-09-18 | Ukraine | Odessa Oblast | 148412 | 3154 | 0 | 46.4846 | 30.7326 | 2021-09-19 04:21:34 | Odessa Oblast, Ukraine | |||
19993 | 19993 | 2021-09-18 | Ukraine | Poltava Oblast | 80383 | 1914 | 0 | 49.5883 | 34.5514 | 2021-09-19 04:21:34 | Poltava Oblast, Ukraine | |||
19994 | 19994 | 2021-09-18 | Ukraine | Rivne Oblast | 82182 | 1235 | 0 | 50.6199 | 26.2516 | 2021-09-19 04:21:34 | Rivne Oblast, Ukraine | |||
19995 | 19995 | 2021-09-18 | Ukraine | Sevastopol* | 29073 | 1092 | 0 | 44.6054 | 33.522 | 2021-09-19 04:21:34 | Sevastopol*, Ukraine | |||
19996 | 19996 | 2021-09-18 | Ukraine | Sumy Oblast | 80849 | 1386 | 0 | 50.9077 | 34.7981 | 2021-09-19 04:21:34 | Sumy Oblast, Ukraine | |||
19997 | 19997 | 2021-09-18 | Ukraine | Ternopil Oblast | 73721 | 1255 | 0 | 49.5535 | 25.5948 | 2021-09-19 04:21:34 | Ternopil Oblast, Ukraine | |||
19998 | 19998 | 2021-09-18 | Ukraine | Vinnytsia Oblast | 74047 | 1746 | 0 | 49.2331 | 28.4682 | 2021-09-19 04:21:34 | Vinnytsia Oblast, Ukraine | |||
19999 | 19999 | 2021-09-18 | Ukraine | Volyn Oblast | 63984 | 1218 | 0 | 50.7472 | 25.3254 | 2021-09-19 04:21:34 | Volyn Oblast, Ukraine | |||
20000 | 20000 | 2021-09-18 | Ukraine | Zakarpattia Oblast | 63056 | 1621 | 0 | 48.6208 | 22.2879 | 2021-09-19 04:21:34 | Zakarpattia Oblast, Ukraine | |||
20001 | 20001 | 2021-09-18 | Ukraine | Zaporizhia Oblast | 109322 | 2555 | 0 | 47.8388 | 35.1396 | 2021-09-19 04:21:34 | Zaporizhia Oblast, Ukraine | |||
20002 | 20002 | 2021-09-18 | Ukraine | Zhytomyr Oblast | 91750 | 1858 | 0 | 50.2547 | 28.6587 | 2021-09-19 04:21:34 | Zhytomyr Oblast, Ukraine | |||
20052 | 20052 | 2021-09-18 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-09-19 04:21:34 | Unknown, Ukraine |
Advanced export
JSON shape: default, array, newline-delimited
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]);