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 admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, active, latitude, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
614 | 614 | 2021-12-02 | Somalia | 23016 | 1327 | 0 | 5.152149 | 46.199616 | 2021-12-03 04:23:05 | Somalia | ||||
4630 | 4630 | 2021-10-28 | Somalia | 21998 | 1208 | 0 | 5.152149 | 46.199616 | 2021-10-29 04:22:03 | Somalia | ||||
8609 | 8609 | 2020-10-25 | Somalia | 3941 | 104 | 3185 | 652 | 5.152149 | 46.199616 | 2020-10-26 04:25:02 | Somalia | |||
12620 | 12620 | 2021-01-26 | Somalia | 4754 | 130 | 3666 | 958 | 5.152149 | 46.199616 | 2021-01-27 05:23:41 | Somalia | |||
16638 | 16638 | 2021-09-18 | Somalia | 19004 | 1063 | 0 | 5.152149 | 46.199616 | 2021-09-19 04:21:34 | Somalia | ||||
20651 | 20651 | 2021-05-28 | Somalia | 14647 | 768 | 6717 | 7162 | 5.152149 | 46.199616 | 2021-05-29 04:20:41 | Somalia | |||
24685 | 24685 | 2022-03-20 | Somalia | 26410 | 1361 | 0 | 5.152149 | 46.199616 | 2022-03-21 04:20:50 | Somalia | ||||
28700 | 28700 | 2021-11-11 | Somalia | 22837 | 1313 | 0 | 5.152149 | 46.199616 | 2021-11-12 04:22:01 | Somalia | ||||
32699 | 32699 | 2021-08-25 | Somalia | 17016 | 938 | 0 | 5.152149 | 46.199616 | 2021-08-26 04:21:28 | Somalia | ||||
36710 | 36710 | 2021-04-12 | Somalia | 12566 | 618 | 5270 | 6678 | 5.152149 | 46.199616 | 2021-04-13 04:20:37 | Somalia | |||
43312 | 43312 | 2020-04-13 | Somalia | 60 | 2 | 2 | 56 | 5.152149 | 46.199616 | 2020-04-13 23:07:34 | Somalia | |||
43992 | 43992 | 2021-11-02 | Somalia | 21998 | 1208 | 0 | 5.152149 | 46.199616 | 2021-11-03 06:22:09 | Somalia | ||||
50411 | 50411 | 2020-04-17 | Somalia | 116 | 6 | 2 | 108 | 5.152149 | 46.199616 | 2020-04-17 23:30:32 | Somalia | |||
51072 | 51072 | 2021-05-29 | Somalia | 14653 | 768 | 6726 | 7159 | 5.152149 | 46.199616 | 2021-05-30 04:20:55 | Somalia | |||
55085 | 55085 | 2021-03-07 | Somalia | 8321 | 302 | 3932 | 4087 | 5.152149 | 46.199616 | 2021-03-08 05:24:48 | Somalia | |||
62370 | 62370 | 2020-07-23 | Somalia | 3171 | 93 | 1499 | 1579 | 5.152149 | 46.199616 | 2020-07-24 05:30:40 | Somalia | |||
63349 | 63349 | 2022-11-12 | Somalia | 27254 | 1361 | 0 | 5.152149 | 46.199616 | 2022-11-13 04:21:14 | Somalia | ||||
67344 | 67344 | 2021-09-01 | Somalia | 17466 | 977 | 0 | 5.152149 | 46.199616 | 2021-09-02 04:21:15 | Somalia | ||||
71375 | 71375 | 2022-02-07 | Somalia | 26203 | 1340 | 0 | 5.152149 | 46.199616 | 2022-02-08 04:21:15 | Somalia | ||||
75368 | 75368 | 2020-12-03 | Somalia | 4525 | 121 | 3480 | 924 | 5.152149 | 46.199616 | 2020-12-04 05:27:27 | Somalia | |||
79365 | 79365 | 2020-10-14 | Somalia | 3864 | 99 | 3089 | 676 | 5.152149 | 46.199616 | 2020-10-15 04:24:28 | Somalia | |||
83375 | 83375 | 2021-05-25 | Somalia | 14632 | 767 | 6685 | 7180 | 5.152149 | 46.199616 | 2021-05-26 04:20:35 | Somalia | |||
87409 | 87409 | 2021-11-09 | Somalia | 22693 | 1294 | 0 | 5.152149 | 46.199616 | 2021-11-10 04:21:38 | Somalia | ||||
91427 | 91427 | 2022-07-23 | Somalia | 26912 | 1361 | 0 | 5.152149 | 46.199616 | 2022-07-24 04:20:47 | Somalia | ||||
98734 | 98734 | 2020-08-04 | Somalia | 3220 | 93 | 1598 | 1529 | 5.152149 | 46.199616 | 2020-08-05 04:34:43 | Somalia | |||
99610 | 99610 | 2022-01-14 | Somalia | 24261 | 1335 | 0 | 5.152149 | 46.199616 | 2022-01-15 04:21:07 | Somalia | ||||
103609 | 103609 | 2021-08-15 | Somalia | 16319 | 883 | 0 | 5.152149 | 46.199616 | 2021-08-16 04:21:31 | Somalia | ||||
107734 | 107734 | 2021-06-19 | Somalia | 14852 | 775 | 7150 | 6927 | 5.152149 | 46.199616 | 2021-06-20 04:21:48 | Somalia | |||
114352 | 114352 | 2020-05-08 | Somalia | 928 | 44 | 106 | 778 | 5.152149 | 46.199616 | 2020-05-09 02:32:35 | Somalia | |||
115037 | 115037 | 2022-09-06 | Somalia | 27020 | 1361 | 0 | 5.152149 | 46.199616 | 2022-09-07 04:20:59 | Somalia | ||||
122325 | 122325 | 2020-07-19 | Somalia | 3119 | 93 | 1457 | 1569 | 5.152149 | 46.199616 | 2020-07-20 05:34:40 | Somalia | |||
122983 | 122983 | 2020-11-18 | Somalia | 4382 | 108 | 3384 | 890 | 5.152149 | 46.199616 | 2020-11-19 05:25:23 | Somalia | |||
127017 | 127017 | 2022-01-09 | Somalia | 24261 | 1335 | 0 | 5.152149 | 46.199616 | 2022-01-10 04:22:07 | Somalia | ||||
131037 | 131037 | 2022-10-04 | Somalia | 27216 | 1361 | 0 | 5.152149 | 46.199616 | 2022-10-05 04:23:06 | Somalia | ||||
137575 | 137575 | 2020-04-29 | Somalia | 582 | 28 | 20 | 534 | 5.152149 | 46.199616 | 2020-04-30 02:32:27 | Somalia | |||
138255 | 138255 | 2021-12-04 | Somalia | 23051 | 1331 | 0 | 5.152149 | 46.199616 | 2021-12-05 04:22:25 | Somalia | ||||
142273 | 142273 | 2022-07-09 | Somalia | 26865 | 1361 | 0 | 5.152149 | 46.199616 | 2022-07-10 04:20:54 | Somalia | ||||
146248 | 146248 | 2020-08-15 | Somalia | 3250 | 93 | 2268 | 889 | 5.152149 | 46.199616 | 2020-08-16 04:27:42 | Somalia | |||
150268 | 150268 | 2021-11-29 | Somalia | 23016 | 1327 | 0 | 5.152149 | 46.199616 | 2021-11-30 04:22:53 | Somalia | ||||
154262 | 154262 | 2021-01-08 | Somalia | 4726 | 130 | 3639 | 957 | 5.152149 | 46.199616 | 2021-01-09 05:22:18 | Somalia | |||
158297 | 158297 | 2022-03-29 | Somalia | 26410 | 1361 | 0 | 5.152149 | 46.199616 | 2022-03-30 04:20:45 | Somalia | ||||
162312 | 162312 | 2021-11-19 | Somalia | 22969 | 1324 | 0 | 5.152149 | 46.199616 | 2021-11-20 04:22:17 | Somalia | ||||
166330 | 166330 | 2022-06-21 | Somalia | 26748 | 1361 | 0 | 5.152149 | 46.199616 | 2022-06-22 04:20:54 | Somalia | ||||
170324 | 170324 | 2021-04-16 | Somalia | 12837 | 656 | 5346 | 6835 | 5.152149 | 46.199616 | 2021-04-17 04:20:40 | Somalia | |||
177643 | 177643 | 2020-07-27 | Somalia | 3196 | 93 | 1543 | 1560 | 5.152149 | 46.199616 | 2020-07-28 04:58:43 | Somalia | |||
178309 | 178309 | 2021-09-02 | Somalia | 17630 | 992 | 0 | 5.152149 | 46.199616 | 2021-09-03 04:21:20 | Somalia | ||||
182320 | 182320 | 2021-02-21 | Somalia | 6017 | 202 | 3764 | 2051 | 5.152149 | 46.199616 | 2021-02-22 05:24:21 | Somalia | |||
186355 | 186355 | 2022-02-13 | Somalia | 26203 | 1340 | 0 | 5.152149 | 46.199616 | 2022-02-14 04:20:51 | Somalia | ||||
190348 | 190348 | 2021-01-11 | Somalia | 4726 | 130 | 3639 | 957 | 5.152149 | 46.199616 | 2021-01-12 05:22:15 | Somalia | |||
194343 | 194343 | 2020-08-31 | Somalia | 3310 | 98 | 2481 | 731 | 5.152149 | 46.199616 | 2020-09-01 04:28:31 | Somalia | |||
198546 | 198546 | 2022-10-19 | Somalia | 27223 | 1361 | 0 | 5.152149 | 46.199616 | 2022-10-20 04:22:59 | Somalia | ||||
202535 | 202535 | 2020-12-25 | Somalia | 4690 | 127 | 3605 | 958 | 5.152149 | 46.199616 | 2020-12-26 05:22:28 | Somalia | |||
206530 | 206530 | 2020-08-19 | Somalia | 3265 | 93 | 2396 | 776 | 5.152149 | 46.199616 | 2020-08-20 04:27:43 | Somalia | |||
210518 | 210518 | 2020-10-29 | Somalia | 3941 | 104 | 3185 | 652 | 5.152149 | 46.199616 | 2020-10-30 04:24:49 | Somalia | |||
217583 | 217583 | 2020-06-08 | Somalia | 2368 | 84 | 470 | 1814 | 5.152149 | 46.199616 | 2020-06-09 03:33:03 | Somalia | |||
218267 | 218267 | 2022-12-26 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-27 04:21:07 | Somalia | ||||
222280 | 222280 | 2022-05-09 | Somalia | 26485 | 1361 | 0 | 5.152149 | 46.199616 | 2022-05-10 04:20:50 | Somalia | ||||
228829 | 228829 | 2020-04-30 | Somalia | 601 | 28 | 31 | 542 | 5.152149 | 46.199616 | 2020-05-01 02:32:28 | Somalia | |||
229512 | 229512 | 2022-05-31 | Somalia | 26565 | 1361 | 0 | 5.152149 | 46.199616 | 2022-06-01 04:20:55 | Somalia | ||||
233527 | 233527 | 2022-02-11 | Somalia | 26203 | 1340 | 0 | 5.152149 | 46.199616 | 2022-02-12 04:21:06 | Somalia | ||||
237520 | 237520 | 2021-01-18 | Somalia | 4744 | 130 | 3666 | 948 | 5.152149 | 46.199616 | 2021-01-19 05:22:15 | Somalia | |||
241535 | 241535 | 2021-04-02 | Somalia | 11499 | 537 | 4861 | 6101 | 5.152149 | 46.199616 | 2021-04-03 04:20:44 | Somalia | |||
245552 | 245552 | 2021-08-17 | Somalia | 16399 | 892 | 0 | 5.152149 | 46.199616 | 2021-08-18 04:21:35 | Somalia | ||||
249566 | 249566 | 2021-09-04 | Somalia | 17726 | 997 | 0 | 5.152149 | 46.199616 | 2021-09-05 04:21:33 | Somalia | ||||
253599 | 253599 | 2022-09-08 | Somalia | 27020 | 1361 | 0 | 5.152149 | 46.199616 | 2022-09-09 04:21:11 | Somalia | ||||
257617 | 257617 | 2022-12-10 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-11 04:20:50 | Somalia | ||||
261817 | 261817 | 2022-03-15 | Somalia | 26410 | 1361 | 0 | 5.152149 | 46.199616 | 2022-03-16 04:20:50 | Somalia | ||||
268586 | 268586 | 2020-05-21 | Somalia | 1594 | 61 | 204 | 1329 | 5.152149 | 46.199616 | 2020-05-22 02:36:51 | Somalia | |||
271789 | 271789 | 2020-04-28 | Somalia | 528 | 28 | 19 | 481 | 5.152149 | 46.199616 | 2020-04-29 02:32:29 | Somalia | |||
272433 | 272433 | 2020-11-10 | Somalia | 4301 | 107 | 3247 | 947 | 5.152149 | 46.199616 | 2020-11-11 05:25:30 | Somalia | |||
276467 | 276467 | 2021-11-03 | Somalia | 21998 | 1208 | 0 | 5.152149 | 46.199616 | 2021-11-04 04:22:20 | Somalia | ||||
280463 | 280463 | 2021-02-24 | Somalia | 6549 | 218 | 3783 | 2548 | 5.152149 | 46.199616 | 2021-02-25 05:24:57 | Somalia | |||
287605 | 287605 | 2020-06-15 | Somalia | 2642 | 88 | 622 | 1932 | 5.152149 | 46.199616 | 2020-06-16 04:33:09 | Somalia | |||
288280 | 288280 | 2021-10-31 | Somalia | 21998 | 1208 | 0 | 5.152149 | 46.199616 | 2021-11-01 04:22:01 | Somalia | ||||
292300 | 292300 | 2022-11-15 | Somalia | 27254 | 1361 | 0 | 5.152149 | 46.199616 | 2022-11-16 04:21:09 | Somalia | ||||
296295 | 296295 | 2021-07-15 | Somalia | 15081 | 781 | 7268 | 7032 | 5.152149 | 46.199616 | 2021-07-16 04:21:22 | Somalia | |||
303477 | 303477 | 2020-07-01 | Somalia | 2924 | 90 | 932 | 1902 | 5.152149 | 46.199616 | 2020-07-02 04:33:46 | Somalia | |||
304153 | 304153 | 2022-04-16 | Somalia | 26471 | 1361 | 0 | 5.152149 | 46.199616 | 2022-04-17 04:20:59 | Somalia | ||||
308172 | 308172 | 2022-12-13 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-14 04:21:04 | Somalia | ||||
312188 | 312188 | 2022-11-13 | Somalia | 27254 | 1361 | 0 | 5.152149 | 46.199616 | 2022-11-14 04:21:09 | Somalia | ||||
316201 | 316201 | 2022-02-12 | Somalia | 26203 | 1340 | 0 | 5.152149 | 46.199616 | 2022-02-13 04:21:00 | Somalia | ||||
320220 | 320220 | 2022-10-30 | Somalia | 27237 | 1361 | 0 | 5.152149 | 46.199616 | 2022-10-31 04:21:36 | Somalia | ||||
327420 | 327420 | 2020-07-20 | Somalia | 3130 | 93 | 1462 | 1575 | 5.152149 | 46.199616 | 2020-07-21 04:38:46 | Somalia | |||
328194 | 328194 | 2022-12-27 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-28 04:21:04 | Somalia | ||||
332189 | 332189 | 2021-08-04 | Somalia | 15658 | 832 | 7661 | 7165 | 5.152149 | 46.199616 | 2021-08-05 04:21:51 | Somalia | |||
336221 | 336221 | 2022-03-18 | Somalia | 26410 | 1361 | 0 | 5.152149 | 46.199616 | 2022-03-19 04:20:47 | Somalia | ||||
339908 | 339908 | 2020-03-21 | Somalia | 1 | 0 | 0 | 5.1521 | 46.1996 | 2020-03-18T00:53:03 | |||||
340555 | 340555 | 2021-02-03 | Somalia | 4814 | 132 | 3720 | 962 | 5.152149 | 46.199616 | 2021-02-04 05:22:26 | Somalia | |||
344551 | 344551 | 2020-09-14 | Somalia | 3389 | 98 | 2803 | 488 | 5.152149 | 46.199616 | 2020-09-15 03:22:50 | Somalia | |||
348584 | 348584 | 2022-12-14 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-15 04:20:58 | Somalia | ||||
352576 | 352576 | 2021-03-11 | Somalia | 8820 | 338 | 4079 | 4403 | 5.152149 | 46.199616 | 2021-03-12 05:26:50 | Somalia | |||
356611 | 356611 | 2022-03-11 | Somalia | 26400 | 1359 | 0 | 5.152149 | 46.199616 | 2022-03-12 04:20:50 | Somalia | ||||
360627 | 360627 | 2022-05-07 | Somalia | 26485 | 1361 | 0 | 5.152149 | 46.199616 | 2022-05-08 04:20:49 | Somalia | ||||
367825 | 367825 | 2020-07-16 | Somalia | 3106 | 93 | 1444 | 1569 | 5.152149 | 46.199616 | 2020-07-17 04:34:50 | Somalia | |||
371799 | 371799 | 2020-08-08 | Somalia | 3227 | 93 | 1728 | 1406 | 5.152149 | 46.199616 | 2020-08-09 04:34:54 | Somalia | |||
372484 | 372484 | 2022-09-13 | Somalia | 27197 | 1361 | 0 | 5.152149 | 46.199616 | 2022-09-14 04:20:44 | Somalia | ||||
376460 | 376460 | 2020-11-06 | Somalia | 4229 | 107 | 3247 | 875 | 5.152149 | 46.199616 | 2020-11-07 05:24:52 | Somalia | |||
380473 | 380473 | 2021-04-30 | Somalia | 13915 | 713 | 5847 | 7355 | 5.152149 | 46.199616 | 2021-05-01 04:20:47 | Somalia | |||
384511 | 384511 | 2022-09-23 | Somalia | 27207 | 1361 | 0 | 5.152149 | 46.199616 | 2022-09-24 04:21:40 | Somalia | ||||
388503 | 388503 | 2021-04-04 | Somalia | 11783 | 557 | 4967 | 6259 | 5.152149 | 46.199616 | 2021-04-05 04:20:35 | 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]);