daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,019 rows where country_or_region = "Somalia" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, active, latitude, longitude, day (date), last_update (date)
deaths 187 ✖
- 1361 291
- 93 44
- 130 35
- 1335 33
- 775 26
- 1333 26
- 99 24
- 0 23
- 98 20
- 121 15
- 1180 15
- 107 14
- 1348 14
- 90 13
- 781 11
- 1208 11
- 113 10
- 104 9
- 92 8
- 97 8
- 127 8
- 1313 8
- 1327 8
- 1340 8
- 88 7
- 713 7
- 753 7
- 767 7
- 1331 7
- 1359 7
- 774 6
- 1111 6
- 1294 6
- 1324 6
- 1345 6
- 1 5
- 61 5
- 79 5
- 108 5
- 124 5
- 28 4
- 85 4
- 95 4
- 134 4
- 656 4
- 689 4
- 773 4
- 897 4
- 1152 4
- 8 3
- 52 3
- 102 3
- 132 3
- 537 3
- 605 3
- 618 3
- 747 3
- 768 3
- 769 3
- 938 3
- 1005 3
- 1041 3
- 1079 3
- 1137 3
- 2 2
- 5 2
- 7 2
- 16 2
- 44 2
- 53 2
- 67 2
- 72 2
- 101 2
- 179 2
- 208 2
- 223 2
- 274 2
- 338 2
- 392 2
- 453 2
- 471 2
- 576 2
- 678 2
- 721 2
- 745 2
- 762 2
- 771 2
- 809 2
- 837 2
- 870 2
- 892 2
- 927 2
- 977 2
- 992 2
- 1017 2
- 1023 2
- 1032 2
- 1063 2
- 1099 2
- 1103 2
- 6 1
- 18 1
- 23 1
- 26 1
- 31 1
- 32 1
- 35 1
- 38 1
- 39 1
- 48 1
- 51 1
- 55 1
- 56 1
- 57 1
- 59 1
- 66 1
- 73 1
- 78 1
- 82 1
- 83 1
- 84 1
- 87 1
- 139 1
- 144 1
- 146 1
- 148 1
- 152 1
- 154 1
- 163 1
- 172 1
- 194 1
- 202 1
- 218 1
- 231 1
- 239 1
- 243 1
- 249 1
- 260 1
- 294 1
- 302 1
- 307 1
- 319 1
- 327 1
- 349 1
- 367 1
- 379 1
- 385 1
- 414 1
- 419 1
- 429 1
- 441 1
- 488 1
- 496 1
- 510 1
- 521 1
- 529 1
- 557 1
- 568 1
- 670 1
- 698 1
- 702 1
- 770 1
- 777 1
- 779 1
- 789 1
- 796 1
- 797 1
- 798 1
- 804 1
- 811 1
- 813 1
- 819 1
- 828 1
- 832 1
- 847 1
- 850 1
- 858 1
- 863 1
- 864 1
- 878 1
- 883 1
- 918 1
- 953 1
- 963 1
- 969 1
- 997 1
- 1002 1
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-21 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-18T00:53:03 | |||||
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-16 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-16T14:38:46 | |||||
2020-03-20 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-18T00:53:03 | |||||
2020-03-17 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-16T14:38:46 | |||||
2021-12-02 | Somalia | 23016 | 1327 | 0 | 5.152149 | 46.199616 | 2021-12-03 04:23:05 | Somalia | ||||
2021-10-28 | Somalia | 21998 | 1208 | 0 | 5.152149 | 46.199616 | 2021-10-29 04:22:03 | Somalia | ||||
2020-10-25 | Somalia | 3941 | 104 | 3185 | 652 | 5.152149 | 46.199616 | 2020-10-26 04:25:02 | Somalia | |||
2021-01-26 | Somalia | 4754 | 130 | 3666 | 958 | 5.152149 | 46.199616 | 2021-01-27 05:23:41 | Somalia | |||
2021-09-18 | Somalia | 19004 | 1063 | 0 | 5.152149 | 46.199616 | 2021-09-19 04:21:34 | Somalia | ||||
2021-05-28 | Somalia | 14647 | 768 | 6717 | 7162 | 5.152149 | 46.199616 | 2021-05-29 04:20:41 | Somalia | |||
2022-03-20 | Somalia | 26410 | 1361 | 0 | 5.152149 | 46.199616 | 2022-03-21 04:20:50 | Somalia | ||||
2021-11-11 | Somalia | 22837 | 1313 | 0 | 5.152149 | 46.199616 | 2021-11-12 04:22:01 | Somalia | ||||
2021-08-25 | Somalia | 17016 | 938 | 0 | 5.152149 | 46.199616 | 2021-08-26 04:21:28 | Somalia | ||||
2021-04-12 | Somalia | 12566 | 618 | 5270 | 6678 | 5.152149 | 46.199616 | 2021-04-13 04:20:37 | Somalia | |||
2020-04-13 | Somalia | 60 | 2 | 2 | 56 | 5.152149 | 46.199616 | 2020-04-13 23:07:34 | Somalia | |||
2021-11-02 | Somalia | 21998 | 1208 | 0 | 5.152149 | 46.199616 | 2021-11-03 06:22:09 | Somalia | ||||
2020-04-17 | Somalia | 116 | 6 | 2 | 108 | 5.152149 | 46.199616 | 2020-04-17 23:30:32 | Somalia | |||
2021-05-29 | Somalia | 14653 | 768 | 6726 | 7159 | 5.152149 | 46.199616 | 2021-05-30 04:20:55 | Somalia | |||
2021-03-07 | Somalia | 8321 | 302 | 3932 | 4087 | 5.152149 | 46.199616 | 2021-03-08 05:24:48 | Somalia | |||
2020-07-23 | Somalia | 3171 | 93 | 1499 | 1579 | 5.152149 | 46.199616 | 2020-07-24 05:30:40 | Somalia | |||
2022-11-12 | Somalia | 27254 | 1361 | 0 | 5.152149 | 46.199616 | 2022-11-13 04:21:14 | Somalia | ||||
2021-09-01 | Somalia | 17466 | 977 | 0 | 5.152149 | 46.199616 | 2021-09-02 04:21:15 | Somalia | ||||
2022-02-07 | Somalia | 26203 | 1340 | 0 | 5.152149 | 46.199616 | 2022-02-08 04:21:15 | Somalia | ||||
2020-12-03 | Somalia | 4525 | 121 | 3480 | 924 | 5.152149 | 46.199616 | 2020-12-04 05:27:27 | Somalia | |||
2020-10-14 | Somalia | 3864 | 99 | 3089 | 676 | 5.152149 | 46.199616 | 2020-10-15 04:24:28 | Somalia | |||
2021-05-25 | Somalia | 14632 | 767 | 6685 | 7180 | 5.152149 | 46.199616 | 2021-05-26 04:20:35 | Somalia | |||
2021-11-09 | Somalia | 22693 | 1294 | 0 | 5.152149 | 46.199616 | 2021-11-10 04:21:38 | Somalia | ||||
2022-07-23 | Somalia | 26912 | 1361 | 0 | 5.152149 | 46.199616 | 2022-07-24 04:20:47 | Somalia | ||||
2020-08-04 | Somalia | 3220 | 93 | 1598 | 1529 | 5.152149 | 46.199616 | 2020-08-05 04:34:43 | Somalia | |||
2022-01-14 | Somalia | 24261 | 1335 | 0 | 5.152149 | 46.199616 | 2022-01-15 04:21:07 | Somalia | ||||
2021-08-15 | Somalia | 16319 | 883 | 0 | 5.152149 | 46.199616 | 2021-08-16 04:21:31 | Somalia | ||||
2021-06-19 | Somalia | 14852 | 775 | 7150 | 6927 | 5.152149 | 46.199616 | 2021-06-20 04:21:48 | Somalia | |||
2020-05-08 | Somalia | 928 | 44 | 106 | 778 | 5.152149 | 46.199616 | 2020-05-09 02:32:35 | Somalia | |||
2022-09-06 | Somalia | 27020 | 1361 | 0 | 5.152149 | 46.199616 | 2022-09-07 04:20:59 | Somalia | ||||
2020-07-19 | Somalia | 3119 | 93 | 1457 | 1569 | 5.152149 | 46.199616 | 2020-07-20 05:34:40 | Somalia | |||
2020-11-18 | Somalia | 4382 | 108 | 3384 | 890 | 5.152149 | 46.199616 | 2020-11-19 05:25:23 | Somalia | |||
2022-01-09 | Somalia | 24261 | 1335 | 0 | 5.152149 | 46.199616 | 2022-01-10 04:22:07 | Somalia | ||||
2022-10-04 | Somalia | 27216 | 1361 | 0 | 5.152149 | 46.199616 | 2022-10-05 04:23:06 | Somalia | ||||
2020-04-29 | Somalia | 582 | 28 | 20 | 534 | 5.152149 | 46.199616 | 2020-04-30 02:32:27 | Somalia | |||
2021-12-04 | Somalia | 23051 | 1331 | 0 | 5.152149 | 46.199616 | 2021-12-05 04:22:25 | Somalia | ||||
2022-07-09 | Somalia | 26865 | 1361 | 0 | 5.152149 | 46.199616 | 2022-07-10 04:20:54 | Somalia | ||||
2020-08-15 | Somalia | 3250 | 93 | 2268 | 889 | 5.152149 | 46.199616 | 2020-08-16 04:27:42 | Somalia | |||
2021-11-29 | Somalia | 23016 | 1327 | 0 | 5.152149 | 46.199616 | 2021-11-30 04:22:53 | Somalia | ||||
2021-01-08 | Somalia | 4726 | 130 | 3639 | 957 | 5.152149 | 46.199616 | 2021-01-09 05:22:18 | Somalia | |||
2022-03-29 | Somalia | 26410 | 1361 | 0 | 5.152149 | 46.199616 | 2022-03-30 04:20:45 | Somalia | ||||
2021-11-19 | Somalia | 22969 | 1324 | 0 | 5.152149 | 46.199616 | 2021-11-20 04:22:17 | Somalia | ||||
2022-06-21 | Somalia | 26748 | 1361 | 0 | 5.152149 | 46.199616 | 2022-06-22 04:20:54 | Somalia | ||||
2021-04-16 | Somalia | 12837 | 656 | 5346 | 6835 | 5.152149 | 46.199616 | 2021-04-17 04:20:40 | Somalia | |||
2020-07-27 | Somalia | 3196 | 93 | 1543 | 1560 | 5.152149 | 46.199616 | 2020-07-28 04:58:43 | Somalia | |||
2021-09-02 | Somalia | 17630 | 992 | 0 | 5.152149 | 46.199616 | 2021-09-03 04:21:20 | Somalia | ||||
2021-02-21 | Somalia | 6017 | 202 | 3764 | 2051 | 5.152149 | 46.199616 | 2021-02-22 05:24:21 | Somalia | |||
2022-02-13 | Somalia | 26203 | 1340 | 0 | 5.152149 | 46.199616 | 2022-02-14 04:20:51 | Somalia | ||||
2021-01-11 | Somalia | 4726 | 130 | 3639 | 957 | 5.152149 | 46.199616 | 2021-01-12 05:22:15 | Somalia | |||
2020-08-31 | Somalia | 3310 | 98 | 2481 | 731 | 5.152149 | 46.199616 | 2020-09-01 04:28:31 | Somalia | |||
2022-10-19 | Somalia | 27223 | 1361 | 0 | 5.152149 | 46.199616 | 2022-10-20 04:22:59 | Somalia | ||||
2020-12-25 | Somalia | 4690 | 127 | 3605 | 958 | 5.152149 | 46.199616 | 2020-12-26 05:22:28 | Somalia | |||
2020-08-19 | Somalia | 3265 | 93 | 2396 | 776 | 5.152149 | 46.199616 | 2020-08-20 04:27:43 | Somalia | |||
2020-10-29 | Somalia | 3941 | 104 | 3185 | 652 | 5.152149 | 46.199616 | 2020-10-30 04:24:49 | Somalia | |||
2020-06-08 | Somalia | 2368 | 84 | 470 | 1814 | 5.152149 | 46.199616 | 2020-06-09 03:33:03 | Somalia | |||
2022-12-26 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-27 04:21:07 | Somalia | ||||
2022-05-09 | Somalia | 26485 | 1361 | 0 | 5.152149 | 46.199616 | 2022-05-10 04:20:50 | Somalia | ||||
2020-04-30 | Somalia | 601 | 28 | 31 | 542 | 5.152149 | 46.199616 | 2020-05-01 02:32:28 | Somalia | |||
2022-05-31 | Somalia | 26565 | 1361 | 0 | 5.152149 | 46.199616 | 2022-06-01 04:20:55 | Somalia | ||||
2022-02-11 | Somalia | 26203 | 1340 | 0 | 5.152149 | 46.199616 | 2022-02-12 04:21:06 | Somalia | ||||
2021-01-18 | Somalia | 4744 | 130 | 3666 | 948 | 5.152149 | 46.199616 | 2021-01-19 05:22:15 | Somalia | |||
2021-04-02 | Somalia | 11499 | 537 | 4861 | 6101 | 5.152149 | 46.199616 | 2021-04-03 04:20:44 | Somalia | |||
2021-08-17 | Somalia | 16399 | 892 | 0 | 5.152149 | 46.199616 | 2021-08-18 04:21:35 | Somalia | ||||
2021-09-04 | Somalia | 17726 | 997 | 0 | 5.152149 | 46.199616 | 2021-09-05 04:21:33 | Somalia | ||||
2022-09-08 | Somalia | 27020 | 1361 | 0 | 5.152149 | 46.199616 | 2022-09-09 04:21:11 | Somalia | ||||
2022-12-10 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-11 04:20:50 | Somalia | ||||
2022-03-15 | Somalia | 26410 | 1361 | 0 | 5.152149 | 46.199616 | 2022-03-16 04:20:50 | Somalia | ||||
2020-05-21 | Somalia | 1594 | 61 | 204 | 1329 | 5.152149 | 46.199616 | 2020-05-22 02:36:51 | Somalia | |||
2020-04-28 | Somalia | 528 | 28 | 19 | 481 | 5.152149 | 46.199616 | 2020-04-29 02:32:29 | Somalia | |||
2020-11-10 | Somalia | 4301 | 107 | 3247 | 947 | 5.152149 | 46.199616 | 2020-11-11 05:25:30 | Somalia | |||
2021-11-03 | Somalia | 21998 | 1208 | 0 | 5.152149 | 46.199616 | 2021-11-04 04:22:20 | Somalia | ||||
2021-02-24 | Somalia | 6549 | 218 | 3783 | 2548 | 5.152149 | 46.199616 | 2021-02-25 05:24:57 | Somalia | |||
2020-06-15 | Somalia | 2642 | 88 | 622 | 1932 | 5.152149 | 46.199616 | 2020-06-16 04:33:09 | Somalia | |||
2021-10-31 | Somalia | 21998 | 1208 | 0 | 5.152149 | 46.199616 | 2021-11-01 04:22:01 | Somalia | ||||
2022-11-15 | Somalia | 27254 | 1361 | 0 | 5.152149 | 46.199616 | 2022-11-16 04:21:09 | Somalia | ||||
2021-07-15 | Somalia | 15081 | 781 | 7268 | 7032 | 5.152149 | 46.199616 | 2021-07-16 04:21:22 | Somalia | |||
2020-07-01 | Somalia | 2924 | 90 | 932 | 1902 | 5.152149 | 46.199616 | 2020-07-02 04:33:46 | Somalia | |||
2022-04-16 | Somalia | 26471 | 1361 | 0 | 5.152149 | 46.199616 | 2022-04-17 04:20:59 | Somalia | ||||
2022-12-13 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-14 04:21:04 | Somalia | ||||
2022-11-13 | Somalia | 27254 | 1361 | 0 | 5.152149 | 46.199616 | 2022-11-14 04:21:09 | Somalia | ||||
2022-02-12 | Somalia | 26203 | 1340 | 0 | 5.152149 | 46.199616 | 2022-02-13 04:21:00 | Somalia | ||||
2022-10-30 | Somalia | 27237 | 1361 | 0 | 5.152149 | 46.199616 | 2022-10-31 04:21:36 | Somalia | ||||
2020-07-20 | Somalia | 3130 | 93 | 1462 | 1575 | 5.152149 | 46.199616 | 2020-07-21 04:38:46 | Somalia | |||
2022-12-27 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-28 04:21:04 | Somalia | ||||
2021-08-04 | Somalia | 15658 | 832 | 7661 | 7165 | 5.152149 | 46.199616 | 2021-08-05 04:21:51 | Somalia | |||
2022-03-18 | Somalia | 26410 | 1361 | 0 | 5.152149 | 46.199616 | 2022-03-19 04:20:47 | Somalia | ||||
2021-02-03 | Somalia | 4814 | 132 | 3720 | 962 | 5.152149 | 46.199616 | 2021-02-04 05:22:26 | Somalia | |||
2020-09-14 | Somalia | 3389 | 98 | 2803 | 488 | 5.152149 | 46.199616 | 2020-09-15 03:22:50 | Somalia | |||
2022-12-14 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-15 04:20:58 | Somalia | ||||
2021-03-11 | Somalia | 8820 | 338 | 4079 | 4403 | 5.152149 | 46.199616 | 2021-03-12 05:26:50 | Somalia | |||
2022-03-11 | Somalia | 26400 | 1359 | 0 | 5.152149 | 46.199616 | 2022-03-12 04:20:50 | Somalia | ||||
2022-05-07 | Somalia | 26485 | 1361 | 0 | 5.152149 | 46.199616 | 2022-05-08 04:20:49 | Somalia | ||||
2020-07-16 | Somalia | 3106 | 93 | 1444 | 1569 | 5.152149 | 46.199616 | 2020-07-17 04:34:50 | Somalia | |||
2020-08-08 | Somalia | 3227 | 93 | 1728 | 1406 | 5.152149 | 46.199616 | 2020-08-09 04:34:54 | Somalia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;