daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,019 rows where country_or_region = "Somalia" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, latitude, day (date), last_update (date)
country_or_region 1
- Somalia · 1,019 ✖
province_or_state 0
day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-16 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-16T14:38:46 | |||||
2020-03-17 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-16T14:38:46 | |||||
2020-03-18 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-18T00:53:03 | |||||
2020-03-19 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-18T00:53:03 | |||||
2020-03-20 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-18T00:53:03 | |||||
2020-03-21 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-18T00:53:03 | |||||
2020-03-22 | Somalia | 1 | 0 | 0 | 1 | 5.152149 | 46.199616 | 3/22/20 23:45 | Somalia | |||
2020-03-23 | Somalia | 1 | 0 | 0 | 1 | 5.152149 | 46.199616 | 2020-03-23 23:19:21 | Somalia | |||
2020-03-24 | Somalia | 1 | 0 | 0 | 1 | 5.152149 | 46.199616 | 2020-03-24 23:37:15 | Somalia | |||
2020-03-25 | Somalia | 1 | 0 | 0 | 1 | 5.152149 | 46.199616 | 2020-03-25 23:33:04 | Somalia | |||
2020-03-26 | Somalia | 2 | 0 | 0 | 2 | 5.152149 | 46.199616 | 2020-03-26 23:48:18 | Somalia | |||
2020-03-27 | Somalia | 3 | 0 | 0 | 3 | 5.152149 | 46.199616 | 2020-03-27 23:23:03 | Somalia | |||
2020-03-28 | Somalia | 3 | 0 | 0 | 3 | 5.152149 | 46.199616 | 3/28/20 23:05 | Somalia | |||
2020-03-29 | Somalia | 3 | 0 | 0 | 3 | 5.152149 | 46.199616 | 3/29/20 23:08 | Somalia | |||
2020-03-30 | Somalia | 3 | 0 | 0 | 3 | 5.152149 | 46.199616 | 3/30/20 22:52 | Somalia | |||
2020-03-31 | Somalia | 5 | 0 | 1 | 4 | 5.152149 | 46.199616 | 2020-03-31 23:43:43 | Somalia | |||
2020-04-01 | Somalia | 5 | 0 | 1 | 4 | 5.152149 | 46.199616 | 2020-04-01 21:58:34 | Somalia | |||
2020-04-02 | Somalia | 5 | 0 | 1 | 4 | 5.152149 | 46.199616 | 4/2/20 23:25 | Somalia | |||
2020-04-03 | Somalia | 7 | 0 | 1 | 6 | 5.152149 | 46.199616 | 2020-04-03 22:46:20 | Somalia | |||
2020-04-04 | Somalia | 7 | 0 | 1 | 6 | 5.152149 | 46.199616 | 4/4/20 23:34 | Somalia | |||
2020-04-05 | Somalia | 7 | 0 | 1 | 6 | 5.152149 | 46.199616 | 2020-04-05 23:06:26 | Somalia | |||
2020-04-06 | Somalia | 7 | 0 | 1 | 6 | 5.152149 | 46.199616 | 4/6/20 23:21 | Somalia | |||
2020-04-07 | Somalia | 8 | 0 | 1 | 7 | 5.152149 | 46.199616 | 2020-04-07 23:04:29 | Somalia | |||
2020-04-08 | Somalia | 12 | 1 | 1 | 10 | 5.152149 | 46.199616 | 2020-04-08 22:51:39 | Somalia | |||
2020-04-09 | Somalia | 12 | 1 | 1 | 10 | 5.152149 | 46.199616 | 2020-04-09 23:02:19 | Somalia | |||
2020-04-10 | Somalia | 21 | 1 | 1 | 19 | 5.152149 | 46.199616 | 2020-04-10 22:53:48 | Somalia | |||
2020-04-11 | Somalia | 21 | 1 | 1 | 19 | 5.152149 | 46.199616 | 2020-04-11 22:45:13 | Somalia | |||
2020-04-12 | Somalia | 25 | 1 | 2 | 22 | 5.152149 | 46.199616 | 2020-04-12 23:17:00 | Somalia | |||
2020-04-13 | Somalia | 60 | 2 | 2 | 56 | 5.152149 | 46.199616 | 2020-04-13 23:07:34 | Somalia | |||
2020-04-14 | Somalia | 60 | 2 | 2 | 56 | 5.152149 | 46.199616 | 2020-04-14 23:33:12 | Somalia | |||
2020-04-15 | Somalia | 80 | 5 | 2 | 73 | 5.152149 | 46.199616 | 2020-04-15 22:56:32 | Somalia | |||
2020-04-16 | Somalia | 80 | 5 | 2 | 73 | 5.152149 | 46.199616 | 2020-04-16 23:30:31 | Somalia | |||
2020-04-17 | Somalia | 116 | 6 | 2 | 108 | 5.152149 | 46.199616 | 2020-04-17 23:30:32 | Somalia | |||
2020-04-18 | Somalia | 135 | 7 | 2 | 126 | 5.152149 | 46.199616 | 2020-04-18 22:32:28 | Somalia | |||
2020-04-19 | Somalia | 164 | 7 | 3 | 154 | 5.152149 | 46.199616 | 2020-04-19 23:40:41 | Somalia | |||
2020-04-20 | Somalia | 237 | 8 | 4 | 225 | 5.152149 | 46.199616 | 2020-04-20 23:36:27 | Somalia | |||
2020-04-21 | Somalia | 286 | 8 | 4 | 274 | 5.152149 | 46.199616 | 2020-04-21 23:30:30 | Somalia | |||
2020-04-22 | Somalia | 286 | 8 | 4 | 274 | 5.152149 | 46.199616 | 2020-04-22 23:30:32 | Somalia | |||
2020-04-23 | Somalia | 328 | 16 | 8 | 304 | 5.152149 | 46.199616 | 2020-04-24 03:30:31 | Somalia | |||
2020-04-24 | Somalia | 328 | 16 | 8 | 304 | 5.152149 | 46.199616 | 2020-04-25 06:30:33 | Somalia | |||
2020-04-25 | Somalia | 390 | 18 | 8 | 364 | 5.152149 | 46.199616 | 2020-04-26 02:30:31 | Somalia | |||
2020-04-26 | Somalia | 436 | 23 | 10 | 403 | 5.152149 | 46.199616 | 2020-04-27 02:30:33 | Somalia | |||
2020-04-27 | Somalia | 480 | 26 | 10 | 444 | 5.152149 | 46.199616 | 2020-04-28 02:30:32 | Somalia | |||
2020-04-28 | Somalia | 528 | 28 | 19 | 481 | 5.152149 | 46.199616 | 2020-04-29 02:32:29 | Somalia | |||
2020-04-29 | Somalia | 582 | 28 | 20 | 534 | 5.152149 | 46.199616 | 2020-04-30 02:32:27 | Somalia | |||
2020-04-30 | Somalia | 601 | 28 | 31 | 542 | 5.152149 | 46.199616 | 2020-05-01 02:32:28 | Somalia | |||
2020-05-01 | Somalia | 601 | 28 | 31 | 542 | 5.152149 | 46.199616 | 2020-05-02 02:32:27 | Somalia | |||
2020-05-02 | Somalia | 671 | 31 | 34 | 606 | 5.152149 | 46.199616 | 2020-05-03 02:32:28 | Somalia | |||
2020-05-03 | Somalia | 722 | 32 | 44 | 646 | 5.152149 | 46.199616 | 2020-05-04 02:32:28 | Somalia | |||
2020-05-04 | Somalia | 756 | 35 | 61 | 660 | 5.152149 | 46.199616 | 2020-05-05 02:32:34 | Somalia | |||
2020-05-05 | Somalia | 835 | 38 | 75 | 722 | 5.152149 | 46.199616 | 2020-05-06 02:32:31 | Somalia | |||
2020-05-06 | Somalia | 873 | 39 | 87 | 747 | 5.152149 | 46.199616 | 2020-05-07 02:32:28 | Somalia | |||
2020-05-07 | Somalia | 928 | 44 | 106 | 778 | 5.152149 | 46.199616 | 2020-05-08 02:32:32 | Somalia | |||
2020-05-08 | Somalia | 928 | 44 | 106 | 778 | 5.152149 | 46.199616 | 2020-05-09 02:32:35 | Somalia | |||
2020-05-09 | Somalia | 997 | 48 | 110 | 839 | 5.152149 | 46.199616 | 2020-05-10 02:32:30 | Somalia | |||
2020-05-10 | Somalia | 1054 | 51 | 118 | 885 | 5.152149 | 46.199616 | 2020-05-11 02:32:30 | Somalia | |||
2020-05-11 | Somalia | 1089 | 52 | 121 | 916 | 5.152149 | 46.199616 | 2020-05-12 03:32:27 | Somalia | |||
2020-05-12 | Somalia | 1170 | 52 | 126 | 992 | 5.152149 | 46.199616 | 2020-05-13 03:32:26 | Somalia | |||
2020-05-13 | Somalia | 1219 | 52 | 130 | 1037 | 5.152149 | 46.199616 | 2020-05-14 03:32:28 | Somalia | |||
2020-05-14 | Somalia | 1284 | 53 | 135 | 1096 | 5.152149 | 46.199616 | 2020-05-15 02:33:02 | Somalia | |||
2020-05-15 | Somalia | 1284 | 53 | 135 | 1096 | 5.152149 | 46.199616 | 2020-05-16 02:32:19 | Somalia | |||
2020-05-16 | Somalia | 1357 | 55 | 148 | 1154 | 5.152149 | 46.199616 | 2020-05-17 02:32:32 | Somalia | |||
2020-05-17 | Somalia | 1421 | 56 | 152 | 1213 | 5.152149 | 46.199616 | 2020-05-18 02:32:21 | Somalia | |||
2020-05-18 | Somalia | 1455 | 57 | 163 | 1235 | 5.152149 | 46.199616 | 2020-05-19 02:32:18 | Somalia | |||
2020-05-19 | Somalia | 1502 | 59 | 178 | 1265 | 5.152149 | 46.199616 | 2020-05-20 02:32:19 | Somalia | |||
2020-05-20 | Somalia | 1573 | 61 | 188 | 1324 | 5.152149 | 46.199616 | 2020-05-21 02:32:48 | Somalia | |||
2020-05-21 | Somalia | 1594 | 61 | 204 | 1329 | 5.152149 | 46.199616 | 2020-05-22 02:36:51 | Somalia | |||
2020-05-22 | Somalia | 1594 | 61 | 204 | 1329 | 5.152149 | 46.199616 | 2020-05-23 02:32:42 | Somalia | |||
2020-05-23 | Somalia | 1594 | 61 | 204 | 1329 | 5.152149 | 46.199616 | 2020-05-24 02:32:43 | Somalia | |||
2020-05-24 | Somalia | 1594 | 61 | 204 | 1329 | 5.152149 | 46.199616 | 2020-05-25 02:32:44 | Somalia | |||
2020-05-25 | Somalia | 1689 | 66 | 235 | 1388 | 5.152149 | 46.199616 | 2020-05-26 02:32:35 | Somalia | |||
2020-05-26 | Somalia | 1711 | 67 | 253 | 1391 | 5.152149 | 46.199616 | 2020-05-27 02:32:31 | Somalia | |||
2020-05-27 | Somalia | 1731 | 67 | 265 | 1399 | 5.152149 | 46.199616 | 2020-05-28 02:32:31 | Somalia | |||
2020-05-28 | Somalia | 1828 | 72 | 310 | 1446 | 5.152149 | 46.199616 | 2020-05-29 02:32:50 | Somalia | |||
2020-05-29 | Somalia | 1828 | 72 | 310 | 1446 | 5.152149 | 46.199616 | 2020-05-30 02:32:48 | Somalia | |||
2020-05-30 | Somalia | 1916 | 73 | 327 | 1516 | 5.152149 | 46.199616 | 2020-05-31 02:32:45 | Somalia | |||
2020-05-31 | Somalia | 1976 | 78 | 348 | 1550 | 5.152149 | 46.199616 | 2020-06-01 02:32:46 | Somalia | |||
2020-06-01 | Somalia | 2023 | 79 | 361 | 1583 | 5.152149 | 46.199616 | 2020-06-02 02:33:08 | Somalia | |||
2020-06-02 | Somalia | 2089 | 79 | 361 | 1649 | 5.152149 | 46.199616 | 2020-06-03 02:33:13 | Somalia | |||
2020-06-03 | Somalia | 2146 | 79 | 406 | 1661 | 5.152149 | 46.199616 | 2020-06-04 02:33:14 | Somalia | |||
2020-06-04 | Somalia | 2204 | 79 | 418 | 1707 | 5.152149 | 46.199616 | 2020-06-05 02:33:06 | Somalia | |||
2020-06-05 | Somalia | 2204 | 79 | 418 | 1707 | 5.152149 | 46.199616 | 2020-06-06 02:33:00 | Somalia | |||
2020-06-06 | Somalia | 2289 | 82 | 431 | 1776 | 5.152149 | 46.199616 | 2020-06-07 03:53:30 | Somalia | |||
2020-06-07 | Somalia | 2334 | 83 | 441 | 1810 | 5.152149 | 46.199616 | 2020-06-08 03:33:22 | Somalia | |||
2020-06-08 | Somalia | 2368 | 84 | 470 | 1814 | 5.152149 | 46.199616 | 2020-06-09 03:33:03 | Somalia | |||
2020-06-09 | Somalia | 2416 | 85 | 489 | 1842 | 5.152149 | 46.199616 | 2020-06-10 04:07:00 | Somalia | |||
2020-06-10 | Somalia | 2452 | 85 | 506 | 1861 | 5.152149 | 46.199616 | 2020-06-11 03:33:41 | Somalia | |||
2020-06-11 | Somalia | 2513 | 85 | 532 | 1896 | 5.152149 | 46.199616 | 2020-06-12 05:09:52 | Somalia | |||
2020-06-12 | Somalia | 2513 | 85 | 532 | 1896 | 5.152149 | 46.199616 | 2020-06-13 03:33:14 | Somalia | |||
2020-06-13 | Somalia | 2579 | 87 | 559 | 1933 | 5.152149 | 46.199616 | 2020-06-14 03:33:15 | Somalia | |||
2020-06-14 | Somalia | 2618 | 88 | 577 | 1953 | 5.152149 | 46.199616 | 2020-06-15 03:33:14 | Somalia | |||
2020-06-15 | Somalia | 2642 | 88 | 622 | 1932 | 5.152149 | 46.199616 | 2020-06-16 04:33:09 | Somalia | |||
2020-06-16 | Somalia | 2658 | 88 | 649 | 1921 | 5.152149 | 46.199616 | 2020-06-17 04:33:21 | Somalia | |||
2020-06-17 | Somalia | 2696 | 88 | 685 | 1923 | 5.152149 | 46.199616 | 2020-06-18 04:33:18 | Somalia | |||
2020-06-18 | Somalia | 2719 | 88 | 724 | 1907 | 5.152149 | 46.199616 | 2020-06-19 04:33:17 | Somalia | |||
2020-06-19 | Somalia | 2719 | 88 | 724 | 1907 | 5.152149 | 46.199616 | 2020-06-20 04:33:19 | Somalia | |||
2020-06-20 | Somalia | 2755 | 88 | 751 | 1916 | 5.152149 | 46.199616 | 2020-06-21 04:33:19 | Somalia | |||
2020-06-21 | Somalia | 2779 | 90 | 782 | 1907 | 5.152149 | 46.199616 | 2020-06-22 04:33:20 | Somalia | |||
2020-06-22 | Somalia | 2812 | 90 | 818 | 1904 | 5.152149 | 46.199616 | 2020-06-23 04:33:22 | Somalia | |||
2020-06-23 | Somalia | 2812 | 90 | 818 | 1904 | 5.152149 | 46.199616 | 2020-06-24 04:33:28 | Somalia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;