johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where country_or_region = "Ukraine" and deaths = 72 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 11
country_or_region 1
- Ukraine · 18 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
895750 | 895750 | 2020-11-05 | Ukraine | Sevastopol* | 2799 | 72 | 1873 | 854 | 44.6054 | 33.522 | 2020-11-06 05:24:55 | Sevastopol*, Ukraine | ||
2922812 | 2922812 | 2020-11-04 | Ukraine | Sevastopol* | 2718 | 72 | 1822 | 824 | 44.6054 | 33.522 | 2020-11-05 06:05:03 | Sevastopol*, Ukraine | ||
757920 | 757920 | 2020-10-28 | Ukraine | Kherson Oblast | 3454 | 72 | 1442 | 1940 | 46.6354 | 32.6169 | 2020-10-29 04:24:49 | Kherson Oblast, Ukraine | ||
1456204 | 1456204 | 2020-10-27 | Ukraine | Kherson Oblast | 3344 | 72 | 1404 | 1868 | 46.6354 | 32.6169 | 2020-10-28 04:24:39 | Kherson Oblast, Ukraine | ||
3994231 | 3994231 | 2020-10-20 | Ukraine | Kirovohrad Oblast | 1642 | 72 | 1039 | 531 | 48.5079 | 32.2623 | 2020-10-21 04:24:14 | Kirovohrad Oblast, Ukraine | ||
1798251 | 1798251 | 2020-10-19 | Ukraine | Kirovohrad Oblast | 1591 | 72 | 1031 | 488 | 48.5079 | 32.2623 | 2020-10-20 04:24:22 | Kirovohrad Oblast, Ukraine | ||
2295067 | 2295067 | 2020-10-12 | Ukraine | Poltava Oblast | 4621 | 72 | 1555 | 2994 | 49.5883 | 34.5514 | 2020-10-13 04:24:02 | Poltava Oblast, Ukraine | ||
3789519 | 3789519 | 2020-10-11 | Ukraine | Poltava Oblast | 4377 | 72 | 1553 | 2752 | 49.5883 | 34.5514 | 2020-10-12 04:23:45 | Poltava Oblast, Ukraine | ||
3121094 | 3121094 | 2020-10-06 | Ukraine | Crimea Republic* | 5063 | 72 | 3091 | 1900 | 45.2835 | 34.2008 | 2020-10-07 04:23:40 | Crimea Republic*, Ukraine | ||
1049442 | 1049442 | 2020-09-30 | Ukraine | Sumy Oblast | 4223 | 72 | 1748 | 2403 | 50.9077 | 34.7981 | 2020-10-01 04:23:42 | Sumy Oblast, Ukraine | ||
3165252 | 3165252 | 2020-09-06 | Ukraine | Zhytomyr Oblast | 3678 | 72 | 2089 | 1517 | 50.2547 | 28.6587 | 2020-09-07 04:28:30 | Zhytomyr Oblast, Ukraine | ||
2063508 | 2063508 | 2020-09-01 | Ukraine | Ternopil Oblast | 6194 | 72 | 3088 | 3034 | 49.5535 | 25.5948 | 2020-09-02 04:28:25 | Ternopil Oblast, Ukraine | ||
1483178 | 1483178 | 2020-08-21 | Ukraine | Vinnytsia Oblast | 3478 | 72 | 2565 | 841 | 49.2331 | 28.4682 | 2020-08-22 04:27:49 | Vinnytsia Oblast, Ukraine | ||
3487927 | 3487927 | 2020-08-20 | Ukraine | Vinnytsia Oblast | 3405 | 72 | 2544 | 789 | 49.2331 | 28.4682 | 2020-08-21 04:27:41 | Vinnytsia Oblast, Ukraine | ||
586438 | 586438 | 2020-08-13 | Ukraine | Kiev Oblast | 4377 | 72 | 3044 | 1261 | 50.053 | 30.7667 | 2020-08-14 04:51:19 | Kiev Oblast, Ukraine | ||
3491616 | 3491616 | 2020-07-13 | Ukraine | Volyn Oblast | 3071 | 72 | 1618 | 1381 | 50.7472 | 25.3254 | 2020-07-14 04:34:46 | Volyn Oblast, Ukraine | ||
3737879 | 3737879 | 2020-07-12 | Ukraine | Volyn Oblast | 3042 | 72 | 1618 | 1352 | 50.7472 | 25.3254 | 2020-07-13 04:43:04 | Volyn Oblast, Ukraine | ||
3436274 | 3436274 | 2020-07-11 | Ukraine | Volyn Oblast | 2987 | 72 | 1585 | 1330 | 50.7472 | 25.3254 | 2020-07-12 04:34:30 | Volyn Oblast, 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]);