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 recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, active, latitude, 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 | ||||
16638 | 16638 | 2021-09-18 | Somalia | 19004 | 1063 | 0 | 5.152149 | 46.199616 | 2021-09-19 04:21:34 | 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 | ||||
43992 | 43992 | 2021-11-02 | Somalia | 21998 | 1208 | 0 | 5.152149 | 46.199616 | 2021-11-03 06:22:09 | 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 | ||||
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 | ||||
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 | ||||
115037 | 115037 | 2022-09-06 | Somalia | 27020 | 1361 | 0 | 5.152149 | 46.199616 | 2022-09-07 04:20:59 | 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 | ||||
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 | ||||
150268 | 150268 | 2021-11-29 | Somalia | 23016 | 1327 | 0 | 5.152149 | 46.199616 | 2021-11-30 04:22:53 | 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 | ||||
178309 | 178309 | 2021-09-02 | Somalia | 17630 | 992 | 0 | 5.152149 | 46.199616 | 2021-09-03 04:21:20 | Somalia | ||||
186355 | 186355 | 2022-02-13 | Somalia | 26203 | 1340 | 0 | 5.152149 | 46.199616 | 2022-02-14 04:20:51 | Somalia | ||||
198546 | 198546 | 2022-10-19 | Somalia | 27223 | 1361 | 0 | 5.152149 | 46.199616 | 2022-10-20 04:22:59 | 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 | ||||
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 | ||||
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 | ||||
276467 | 276467 | 2021-11-03 | Somalia | 21998 | 1208 | 0 | 5.152149 | 46.199616 | 2021-11-04 04:22:20 | 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 | ||||
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 | ||||
328194 | 328194 | 2022-12-27 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-28 04:21:04 | 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 | |||||
348584 | 348584 | 2022-12-14 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-15 04:20:58 | 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 | ||||
372484 | 372484 | 2022-09-13 | Somalia | 27197 | 1361 | 0 | 5.152149 | 46.199616 | 2022-09-14 04:20:44 | Somalia | ||||
384511 | 384511 | 2022-09-23 | Somalia | 27207 | 1361 | 0 | 5.152149 | 46.199616 | 2022-09-24 04:21:40 | Somalia | ||||
396552 | 396552 | 2022-10-07 | Somalia | 27216 | 1361 | 0 | 5.152149 | 46.199616 | 2022-10-08 04:22:56 | Somalia | ||||
404578 | 404578 | 2021-12-07 | Somalia | 23051 | 1331 | 0 | 5.152149 | 46.199616 | 2021-12-08 04:22:46 | Somalia | ||||
419623 | 419623 | 2022-09-18 | Somalia | 27197 | 1361 | 0 | 5.152149 | 46.199616 | 2022-09-19 04:21:49 | Somalia | ||||
423635 | 423635 | 2021-10-10 | Somalia | 21269 | 1180 | 0 | 5.152149 | 46.199616 | 2021-10-11 04:21:31 | Somalia | ||||
431645 | 431645 | 2022-11-03 | Somalia | 27243 | 1361 | 0 | 5.152149 | 46.199616 | 2022-11-04 04:22:11 | Somalia | ||||
443639 | 443639 | 2021-10-20 | Somalia | 21269 | 1180 | 0 | 5.152149 | 46.199616 | 2021-10-21 04:21:18 | Somalia | ||||
447655 | 447655 | 2021-11-17 | Somalia | 22837 | 1313 | 0 | 5.152149 | 46.199616 | 2021-11-18 04:21:33 | Somalia | ||||
451675 | 451675 | 2022-12-21 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-22 04:20:56 | Somalia | ||||
459664 | 459664 | 2022-02-02 | Somalia | 26067 | 1335 | 0 | 5.152149 | 46.199616 | 2022-02-03 04:21:21 | Somalia | ||||
463681 | 463681 | 2022-05-02 | Somalia | 26485 | 1361 | 0 | 5.152149 | 46.199616 | 2022-05-03 04:21:00 | Somalia | ||||
467696 | 467696 | 2021-10-07 | Somalia | 20900 | 1152 | 0 | 5.152149 | 46.199616 | 2021-10-08 04:21:25 | Somalia | ||||
475728 | 475728 | 2022-06-26 | Somalia | 26748 | 1361 | 0 | 5.152149 | 46.199616 | 2022-06-27 04:21:00 | Somalia | ||||
479878 | 479878 | 2022-11-08 | Somalia | 27254 | 1361 | 0 | 5.152149 | 46.199616 | 2022-11-09 04:21:22 | Somalia | ||||
487908 | 487908 | 2022-11-25 | Somalia | 27286 | 1361 | 0 | 5.152149 | 46.199616 | 2022-11-26 04:21:11 | Somalia | ||||
491920 | 491920 | 2021-10-14 | Somalia | 21269 | 1180 | 0 | 5.152149 | 46.199616 | 2021-10-15 04:21:26 | Somalia | ||||
495936 | 495936 | 2021-11-06 | Somalia | 22693 | 1294 | 0 | 5.152149 | 46.199616 | 2021-11-07 04:21:53 | Somalia | ||||
499953 | 499953 | 2022-04-02 | Somalia | 26410 | 1361 | 0 | 5.152149 | 46.199616 | 2022-04-03 04:20:48 | Somalia | ||||
503972 | 503972 | 2022-12-17 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-18 04:21:03 | Somalia | ||||
507967 | 507967 | 2021-08-14 | Somalia | 16265 | 878 | 0 | 5.152149 | 46.199616 | 2021-08-15 04:21:41 | Somalia | ||||
511981 | 511981 | 2021-08-19 | Somalia | 16535 | 897 | 0 | 5.152149 | 46.199616 | 2021-08-20 04:21:33 | Somalia | ||||
516016 | 516016 | 2022-10-15 | Somalia | 27223 | 1361 | 0 | 5.152149 | 46.199616 | 2022-10-16 04:22:39 | Somalia | ||||
535020 | 535020 | 2021-10-27 | Somalia | 21998 | 1208 | 0 | 5.152149 | 46.199616 | 2021-10-28 04:22:08 | Somalia | ||||
539040 | 539040 | 2022-10-26 | Somalia | 27237 | 1361 | 0 | 5.152149 | 46.199616 | 2022-10-27 04:22:01 | Somalia | ||||
543056 | 543056 | 2022-12-15 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-16 04:21:01 | Somalia | ||||
551058 | 551058 | 2021-12-08 | Somalia | 23051 | 1331 | 0 | 5.152149 | 46.199616 | 2021-12-09 04:22:49 | Somalia | ||||
555074 | 555074 | 2022-01-16 | Somalia | 24261 | 1335 | 0 | 5.152149 | 46.199616 | 2022-01-17 04:21:08 | Somalia | ||||
559092 | 559092 | 2022-06-16 | Somalia | 26675 | 1361 | 0 | 5.152149 | 46.199616 | 2022-06-17 04:20:56 | Somalia | ||||
567388 | 567388 | 2021-10-29 | Somalia | 21998 | 1208 | 0 | 5.152149 | 46.199616 | 2021-10-30 04:22:03 | Somalia | ||||
575117 | 575117 | 2022-02-25 | Somalia | 26313 | 1348 | 0 | 5.152149 | 46.199616 | 2022-02-26 04:21:12 | Somalia | ||||
589911 | 589911 | 2021-08-08 | Somalia | 15865 | 850 | 0 | 5.152149 | 46.199616 | 2021-08-09 04:21:24 | Somalia | ||||
593944 | 593944 | 2022-07-01 | Somalia | 26803 | 1361 | 0 | 5.152149 | 46.199616 | 2022-07-02 04:21:16 | Somalia | ||||
597958 | 597958 | 2021-10-19 | Somalia | 21269 | 1180 | 0 | 5.152149 | 46.199616 | 2021-10-20 04:21:00 | Somalia | ||||
601974 | 601974 | 2021-09-23 | Somalia | 19583 | 1099 | 0 | 5.152149 | 46.199616 | 2021-09-24 04:21:44 | Somalia | ||||
618150 | 618150 | 2022-11-05 | Somalia | 27243 | 1361 | 0 | 5.152149 | 46.199616 | 2022-11-06 04:21:24 | Somalia | ||||
622164 | 622164 | 2022-05-22 | Somalia | 26535 | 1361 | 0 | 5.152149 | 46.199616 | 2022-05-26 04:20:50 | Somalia | ||||
630194 | 630194 | 2022-07-12 | Somalia | 26900 | 1361 | 0 | 5.152149 | 46.199616 | 2022-07-13 04:20:58 | Somalia | ||||
634208 | 634208 | 2021-10-13 | Somalia | 21269 | 1180 | 0 | 5.152149 | 46.199616 | 2021-10-14 04:21:29 | Somalia | ||||
642221 | 642221 | 2021-09-07 | Somalia | 17947 | 1005 | 0 | 5.152149 | 46.199616 | 2021-09-08 04:21:31 | Somalia | ||||
650249 | 650249 | 2021-08-09 | Somalia | 15929 | 858 | 0 | 5.152149 | 46.199616 | 2021-08-10 04:21:27 | Somalia | ||||
654280 | 654280 | 2021-10-22 | Somalia | 21269 | 1180 | 0 | 5.152149 | 46.199616 | 2021-10-23 04:21:32 | Somalia | ||||
658599 | 658599 | 2022-05-13 | Somalia | 26518 | 1361 | 0 | 5.152149 | 46.199616 | 2022-05-14 04:20:48 | Somalia | ||||
670585 | 670585 | 2022-07-21 | Somalia | 26912 | 1361 | 0 | 5.152149 | 46.199616 | 2022-07-22 04:21:15 | Somalia | ||||
674601 | 674601 | 2022-07-30 | Somalia | 26957 | 1361 | 0 | 5.152149 | 46.199616 | 2022-07-31 04:21:02 | Somalia | ||||
682625 | 682625 | 2021-10-24 | Somalia | 21269 | 1180 | 0 | 5.152149 | 46.199616 | 2021-10-25 04:22:31 | Somalia | ||||
686641 | 686641 | 2021-11-13 | Somalia | 22837 | 1313 | 0 | 5.152149 | 46.199616 | 2021-11-14 04:21:31 | Somalia | ||||
690661 | 690661 | 2022-12-23 | Somalia | 27300 | 1361 | 0 | 5.152149 | 46.199616 | 2022-12-24 04:21:02 | Somalia | ||||
694674 | 694674 | 2022-03-17 | Somalia | 26410 | 1361 | 0 | 5.152149 | 46.199616 | 2022-03-18 04:20:55 | Somalia | ||||
698689 | 698689 | 2021-11-04 | Somalia | 21998 | 1208 | 0 | 5.152149 | 46.199616 | 2021-11-05 04:21:54 | Somalia | ||||
706719 | 706719 | 2021-09-29 | Somalia | 19980 | 1111 | 0 | 5.152149 | 46.199616 | 2021-09-30 04:21:20 | 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]);