johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,019 rows where country_or_region = "Somalia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, recovered, active, longitude, day (date), last_update (date)
country_or_region 1
- Somalia · 1,019 ✖
province_or_state 0
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
339908 | 339908 | 2020-03-21 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-18T00:53:03 | |||||
589248 | 589248 | 2020-04-05 | Somalia | 7 | 0 | 1 | 6 | 5.152149 | 46.199616 | 2020-04-05 23:06:26 | Somalia | |||
809198 | 809198 | 2020-03-27 | Somalia | 3 | 0 | 0 | 3 | 5.152149 | 46.199616 | 2020-03-27 23:23:03 | Somalia | |||
919290 | 919290 | 2020-03-26 | Somalia | 2 | 0 | 0 | 2 | 5.152149 | 46.199616 | 2020-03-26 23:48:18 | Somalia | |||
1132690 | 1132690 | 2020-03-25 | Somalia | 1 | 0 | 0 | 1 | 5.152149 | 46.199616 | 2020-03-25 23:33:04 | Somalia | |||
1177139 | 1177139 | 2020-03-18 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-18T00:53:03 | |||||
1479194 | 1479194 | 2020-03-24 | Somalia | 1 | 0 | 0 | 1 | 5.152149 | 46.199616 | 2020-03-24 23:37:15 | Somalia | |||
1527144 | 1527144 | 2020-03-19 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-18T00:53:03 | |||||
1750891 | 1750891 | 2020-04-04 | Somalia | 7 | 0 | 1 | 6 | 5.152149 | 46.199616 | 4/4/20 23:34 | Somalia | |||
1872578 | 1872578 | 2020-03-30 | Somalia | 3 | 0 | 0 | 3 | 5.152149 | 46.199616 | 3/30/20 22:52 | Somalia | |||
2147248 | 2147248 | 2020-03-23 | Somalia | 1 | 0 | 0 | 1 | 5.152149 | 46.199616 | 2020-03-23 23:19:21 | Somalia | |||
2255369 | 2255369 | 2020-03-16 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-16T14:38:46 | |||||
2875814 | 2875814 | 2020-03-29 | Somalia | 3 | 0 | 0 | 3 | 5.152149 | 46.199616 | 3/29/20 23:08 | Somalia | |||
2910816 | 2910816 | 2020-03-22 | Somalia | 1 | 0 | 0 | 1 | 5.152149 | 46.199616 | 3/22/20 23:45 | Somalia | |||
3021879 | 3021879 | 2020-04-07 | Somalia | 8 | 0 | 1 | 7 | 5.152149 | 46.199616 | 2020-04-07 23:04:29 | Somalia | |||
3364935 | 3364935 | 2020-04-01 | Somalia | 5 | 0 | 1 | 4 | 5.152149 | 46.199616 | 2020-04-01 21:58:34 | Somalia | |||
3627561 | 3627561 | 2020-04-06 | Somalia | 7 | 0 | 1 | 6 | 5.152149 | 46.199616 | 4/6/20 23:21 | Somalia | |||
3701732 | 3701732 | 2020-04-02 | Somalia | 5 | 0 | 1 | 4 | 5.152149 | 46.199616 | 4/2/20 23:25 | Somalia | |||
3734200 | 3734200 | 2020-03-20 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-18T00:53:03 | |||||
3740702 | 3740702 | 2020-04-03 | Somalia | 7 | 0 | 1 | 6 | 5.152149 | 46.199616 | 2020-04-03 22:46:20 | Somalia | |||
3816028 | 3816028 | 2020-03-31 | Somalia | 5 | 0 | 1 | 4 | 5.152149 | 46.199616 | 2020-03-31 23:43:43 | Somalia | |||
3891566 | 3891566 | 2020-03-17 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-16T14:38:46 | |||||
3947150 | 3947150 | 2020-03-28 | Somalia | 3 | 0 | 0 | 3 | 5.152149 | 46.199616 | 3/28/20 23:05 | Somalia | |||
1250360 | 1250360 | 2020-04-10 | Somalia | 21 | 1 | 1 | 19 | 5.152149 | 46.199616 | 2020-04-10 22:53:48 | Somalia | |||
2567175 | 2567175 | 2020-04-11 | Somalia | 21 | 1 | 1 | 19 | 5.152149 | 46.199616 | 2020-04-11 22:45:13 | Somalia | |||
2578338 | 2578338 | 2020-04-12 | Somalia | 25 | 1 | 2 | 22 | 5.152149 | 46.199616 | 2020-04-12 23:17:00 | Somalia | |||
3562204 | 3562204 | 2020-04-08 | Somalia | 12 | 1 | 1 | 10 | 5.152149 | 46.199616 | 2020-04-08 22:51:39 | Somalia | |||
3950097 | 3950097 | 2020-04-09 | Somalia | 12 | 1 | 1 | 10 | 5.152149 | 46.199616 | 2020-04-09 23:02:19 | Somalia | |||
43312 | 43312 | 2020-04-13 | Somalia | 60 | 2 | 2 | 56 | 5.152149 | 46.199616 | 2020-04-13 23:07:34 | Somalia | |||
3338215 | 3338215 | 2020-04-14 | Somalia | 60 | 2 | 2 | 56 | 5.152149 | 46.199616 | 2020-04-14 23:33:12 | Somalia | |||
860299 | 860299 | 2020-04-15 | Somalia | 80 | 5 | 2 | 73 | 5.152149 | 46.199616 | 2020-04-15 22:56:32 | Somalia | |||
934405 | 934405 | 2020-04-16 | Somalia | 80 | 5 | 2 | 73 | 5.152149 | 46.199616 | 2020-04-16 23:30:31 | Somalia | |||
50411 | 50411 | 2020-04-17 | Somalia | 116 | 6 | 2 | 108 | 5.152149 | 46.199616 | 2020-04-17 23:30:32 | Somalia | |||
418939 | 418939 | 2020-04-18 | Somalia | 135 | 7 | 2 | 126 | 5.152149 | 46.199616 | 2020-04-18 22:32:28 | Somalia | |||
1385251 | 1385251 | 2020-04-19 | Somalia | 164 | 7 | 3 | 154 | 5.152149 | 46.199616 | 2020-04-19 23:40:41 | Somalia | |||
522477 | 522477 | 2020-04-21 | Somalia | 286 | 8 | 4 | 274 | 5.152149 | 46.199616 | 2020-04-21 23:30:30 | Somalia | |||
1199411 | 1199411 | 2020-04-22 | Somalia | 286 | 8 | 4 | 274 | 5.152149 | 46.199616 | 2020-04-22 23:30:32 | Somalia | |||
2473559 | 2473559 | 2020-04-20 | Somalia | 237 | 8 | 4 | 225 | 5.152149 | 46.199616 | 2020-04-20 23:36:27 | Somalia | |||
1459372 | 1459372 | 2020-04-24 | Somalia | 328 | 16 | 8 | 304 | 5.152149 | 46.199616 | 2020-04-25 06:30:33 | Somalia | |||
2524961 | 2524961 | 2020-04-23 | Somalia | 328 | 16 | 8 | 304 | 5.152149 | 46.199616 | 2020-04-24 03:30:31 | Somalia | |||
3502971 | 3502971 | 2020-04-25 | Somalia | 390 | 18 | 8 | 364 | 5.152149 | 46.199616 | 2020-04-26 02:30:31 | Somalia | |||
3592622 | 3592622 | 2020-04-26 | Somalia | 436 | 23 | 10 | 403 | 5.152149 | 46.199616 | 2020-04-27 02:30:33 | Somalia | |||
3589444 | 3589444 | 2020-04-27 | Somalia | 480 | 26 | 10 | 444 | 5.152149 | 46.199616 | 2020-04-28 02:30:32 | Somalia | |||
137575 | 137575 | 2020-04-29 | Somalia | 582 | 28 | 20 | 534 | 5.152149 | 46.199616 | 2020-04-30 02:32:27 | Somalia | |||
228829 | 228829 | 2020-04-30 | Somalia | 601 | 28 | 31 | 542 | 5.152149 | 46.199616 | 2020-05-01 02:32:28 | Somalia | |||
271789 | 271789 | 2020-04-28 | Somalia | 528 | 28 | 19 | 481 | 5.152149 | 46.199616 | 2020-04-29 02:32:29 | Somalia | |||
1184348 | 1184348 | 2020-05-01 | Somalia | 601 | 28 | 31 | 542 | 5.152149 | 46.199616 | 2020-05-02 02:32:27 | Somalia | |||
2043454 | 2043454 | 2020-05-02 | Somalia | 671 | 31 | 34 | 606 | 5.152149 | 46.199616 | 2020-05-03 02:32:28 | Somalia | |||
2278778 | 2278778 | 2020-05-03 | Somalia | 722 | 32 | 44 | 646 | 5.152149 | 46.199616 | 2020-05-04 02:32:28 | Somalia | |||
3084919 | 3084919 | 2020-05-04 | Somalia | 756 | 35 | 61 | 660 | 5.152149 | 46.199616 | 2020-05-05 02:32:34 | Somalia | |||
1932056 | 1932056 | 2020-05-05 | Somalia | 835 | 38 | 75 | 722 | 5.152149 | 46.199616 | 2020-05-06 02:32:31 | Somalia | |||
2111016 | 2111016 | 2020-05-06 | Somalia | 873 | 39 | 87 | 747 | 5.152149 | 46.199616 | 2020-05-07 02:32:28 | Somalia | |||
114352 | 114352 | 2020-05-08 | Somalia | 928 | 44 | 106 | 778 | 5.152149 | 46.199616 | 2020-05-09 02:32:35 | Somalia | |||
3295795 | 3295795 | 2020-05-07 | Somalia | 928 | 44 | 106 | 778 | 5.152149 | 46.199616 | 2020-05-08 02:32:32 | Somalia | |||
2899303 | 2899303 | 2020-05-09 | Somalia | 997 | 48 | 110 | 839 | 5.152149 | 46.199616 | 2020-05-10 02:32:30 | Somalia | |||
3459762 | 3459762 | 2020-05-10 | Somalia | 1054 | 51 | 118 | 885 | 5.152149 | 46.199616 | 2020-05-11 02:32:30 | Somalia | |||
2581613 | 2581613 | 2020-05-12 | Somalia | 1170 | 52 | 126 | 992 | 5.152149 | 46.199616 | 2020-05-13 03:32:26 | Somalia | |||
3331147 | 3331147 | 2020-05-11 | Somalia | 1089 | 52 | 121 | 916 | 5.152149 | 46.199616 | 2020-05-12 03:32:27 | Somalia | |||
3847407 | 3847407 | 2020-05-13 | Somalia | 1219 | 52 | 130 | 1037 | 5.152149 | 46.199616 | 2020-05-14 03:32:28 | Somalia | |||
1404645 | 1404645 | 2020-05-14 | Somalia | 1284 | 53 | 135 | 1096 | 5.152149 | 46.199616 | 2020-05-15 02:33:02 | Somalia | |||
3276471 | 3276471 | 2020-05-15 | Somalia | 1284 | 53 | 135 | 1096 | 5.152149 | 46.199616 | 2020-05-16 02:32:19 | Somalia | |||
1829755 | 1829755 | 2020-05-16 | Somalia | 1357 | 55 | 148 | 1154 | 5.152149 | 46.199616 | 2020-05-17 02:32:32 | Somalia | |||
3416521 | 3416521 | 2020-05-17 | Somalia | 1421 | 56 | 152 | 1213 | 5.152149 | 46.199616 | 2020-05-18 02:32:21 | Somalia | |||
3261127 | 3261127 | 2020-05-18 | Somalia | 1455 | 57 | 163 | 1235 | 5.152149 | 46.199616 | 2020-05-19 02:32:18 | Somalia | |||
2390389 | 2390389 | 2020-05-19 | Somalia | 1502 | 59 | 178 | 1265 | 5.152149 | 46.199616 | 2020-05-20 02:32:19 | Somalia | |||
268586 | 268586 | 2020-05-21 | Somalia | 1594 | 61 | 204 | 1329 | 5.152149 | 46.199616 | 2020-05-22 02:36:51 | Somalia | |||
875866 | 875866 | 2020-05-24 | Somalia | 1594 | 61 | 204 | 1329 | 5.152149 | 46.199616 | 2020-05-25 02:32:44 | Somalia | |||
998057 | 998057 | 2020-05-23 | Somalia | 1594 | 61 | 204 | 1329 | 5.152149 | 46.199616 | 2020-05-24 02:32:43 | Somalia | |||
1432169 | 1432169 | 2020-05-20 | Somalia | 1573 | 61 | 188 | 1324 | 5.152149 | 46.199616 | 2020-05-21 02:32:48 | Somalia | |||
1865080 | 1865080 | 2020-05-22 | Somalia | 1594 | 61 | 204 | 1329 | 5.152149 | 46.199616 | 2020-05-23 02:32:42 | Somalia | |||
1105186 | 1105186 | 2020-05-25 | Somalia | 1689 | 66 | 235 | 1388 | 5.152149 | 46.199616 | 2020-05-26 02:32:35 | Somalia | |||
1041456 | 1041456 | 2020-05-26 | Somalia | 1711 | 67 | 253 | 1391 | 5.152149 | 46.199616 | 2020-05-27 02:32:31 | Somalia | |||
2548493 | 2548493 | 2020-05-27 | Somalia | 1731 | 67 | 265 | 1399 | 5.152149 | 46.199616 | 2020-05-28 02:32:31 | Somalia | |||
1790695 | 1790695 | 2020-05-29 | Somalia | 1828 | 72 | 310 | 1446 | 5.152149 | 46.199616 | 2020-05-30 02:32:48 | Somalia | |||
2712574 | 2712574 | 2020-05-28 | Somalia | 1828 | 72 | 310 | 1446 | 5.152149 | 46.199616 | 2020-05-29 02:32:50 | Somalia | |||
3639155 | 3639155 | 2020-05-30 | Somalia | 1916 | 73 | 327 | 1516 | 5.152149 | 46.199616 | 2020-05-31 02:32:45 | Somalia | |||
1794262 | 1794262 | 2020-05-31 | Somalia | 1976 | 78 | 348 | 1550 | 5.152149 | 46.199616 | 2020-06-01 02:32:46 | Somalia | |||
805727 | 805727 | 2020-06-01 | Somalia | 2023 | 79 | 361 | 1583 | 5.152149 | 46.199616 | 2020-06-02 02:33:08 | Somalia | |||
1270133 | 1270133 | 2020-06-05 | Somalia | 2204 | 79 | 418 | 1707 | 5.152149 | 46.199616 | 2020-06-06 02:33:00 | Somalia | |||
1281593 | 1281593 | 2020-06-04 | Somalia | 2204 | 79 | 418 | 1707 | 5.152149 | 46.199616 | 2020-06-05 02:33:06 | Somalia | |||
2556190 | 2556190 | 2020-06-02 | Somalia | 2089 | 79 | 361 | 1649 | 5.152149 | 46.199616 | 2020-06-03 02:33:13 | Somalia | |||
3867148 | 3867148 | 2020-06-03 | Somalia | 2146 | 79 | 406 | 1661 | 5.152149 | 46.199616 | 2020-06-04 02:33:14 | Somalia | |||
574436 | 574436 | 2020-06-06 | Somalia | 2289 | 82 | 431 | 1776 | 5.152149 | 46.199616 | 2020-06-07 03:53:30 | Somalia | |||
2800380 | 2800380 | 2020-06-07 | Somalia | 2334 | 83 | 441 | 1810 | 5.152149 | 46.199616 | 2020-06-08 03:33:22 | Somalia | |||
217583 | 217583 | 2020-06-08 | Somalia | 2368 | 84 | 470 | 1814 | 5.152149 | 46.199616 | 2020-06-09 03:33:03 | Somalia | |||
737928 | 737928 | 2020-06-12 | Somalia | 2513 | 85 | 532 | 1896 | 5.152149 | 46.199616 | 2020-06-13 03:33:14 | Somalia | |||
1211156 | 1211156 | 2020-06-09 | Somalia | 2416 | 85 | 489 | 1842 | 5.152149 | 46.199616 | 2020-06-10 04:07:00 | Somalia | |||
1273898 | 1273898 | 2020-06-11 | Somalia | 2513 | 85 | 532 | 1896 | 5.152149 | 46.199616 | 2020-06-12 05:09:52 | Somalia | |||
2864337 | 2864337 | 2020-06-10 | Somalia | 2452 | 85 | 506 | 1861 | 5.152149 | 46.199616 | 2020-06-11 03:33:41 | Somalia | |||
3061608 | 3061608 | 2020-06-13 | Somalia | 2579 | 87 | 559 | 1933 | 5.152149 | 46.199616 | 2020-06-14 03:33:15 | Somalia | |||
287605 | 287605 | 2020-06-15 | Somalia | 2642 | 88 | 622 | 1932 | 5.152149 | 46.199616 | 2020-06-16 04:33:09 | Somalia | |||
1196279 | 1196279 | 2020-06-17 | Somalia | 2696 | 88 | 685 | 1923 | 5.152149 | 46.199616 | 2020-06-18 04:33:18 | Somalia | |||
1691927 | 1691927 | 2020-06-19 | Somalia | 2719 | 88 | 724 | 1907 | 5.152149 | 46.199616 | 2020-06-20 04:33:19 | Somalia | |||
1837556 | 1837556 | 2020-06-14 | Somalia | 2618 | 88 | 577 | 1953 | 5.152149 | 46.199616 | 2020-06-15 03:33:14 | Somalia | |||
2387042 | 2387042 | 2020-06-16 | Somalia | 2658 | 88 | 649 | 1921 | 5.152149 | 46.199616 | 2020-06-17 04:33:21 | Somalia | |||
2438349 | 2438349 | 2020-06-20 | Somalia | 2755 | 88 | 751 | 1916 | 5.152149 | 46.199616 | 2020-06-21 04:33:19 | Somalia | |||
3683076 | 3683076 | 2020-06-18 | Somalia | 2719 | 88 | 724 | 1907 | 5.152149 | 46.199616 | 2020-06-19 04:33:17 | Somalia | |||
303477 | 303477 | 2020-07-01 | Somalia | 2924 | 90 | 932 | 1902 | 5.152149 | 46.199616 | 2020-07-02 04:33:46 | Somalia | |||
1136511 | 1136511 | 2020-06-26 | Somalia | 2878 | 90 | 868 | 1920 | 5.152149 | 46.199616 | 2020-06-27 04:33:35 | Somalia | |||
1511017 | 1511017 | 2020-06-22 | Somalia | 2812 | 90 | 818 | 1904 | 5.152149 | 46.199616 | 2020-06-23 04:33:22 | Somalia |
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]);