johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Magdalena" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
714301 | 714301 | 2021-11-12 | Colombia | Magdalena | 97957 | 3396 | 0 | 10.4113 | -74.4057 | 2021-11-13 04:21:38 | Magdalena, Colombia | |||
718318 | 718318 | 2022-12-04 | Colombia | Magdalena | 117561 | 3651 | 0 | 10.4113 | -74.4057 | 2022-12-05 04:20:58 | Magdalena, Colombia | |||
722333 | 722333 | 2021-11-20 | Colombia | Magdalena | 98931 | 3411 | 0 | 10.4113 | -74.4057 | 2021-11-21 04:22:13 | Magdalena, Colombia | |||
730363 | 730363 | 2021-12-27 | Colombia | Magdalena | 101246 | 3481 | 0 | 10.4113 | -74.4057 | 2021-12-28 04:21:47 | Magdalena, Colombia | |||
746180 | 746180 | 2022-04-23 | Colombia | Magdalena | 114929 | 3621 | 0 | 10.4113 | -74.4057 | 2022-04-24 04:20:56 | Magdalena, Colombia | |||
758163 | 758163 | 2021-11-26 | Colombia | Magdalena | 99555 | 3429 | 0 | 10.4113 | -74.4057 | 2021-11-27 04:22:45 | Magdalena, Colombia | |||
770184 | 770184 | 2021-10-23 | Colombia | Magdalena | 95797 | 3347 | 0 | 10.4113 | -74.4057 | 2021-10-24 04:21:22 | Magdalena, Colombia | |||
782226 | 782226 | 2021-12-13 | Colombia | Magdalena | 100792 | 3459 | 0 | 10.4113 | -74.4057 | 2021-12-14 04:22:38 | Magdalena, Colombia | |||
794250 | 794250 | 2022-10-24 | Colombia | Magdalena | 117424 | 3643 | 0 | 10.4113 | -74.4057 | 2022-10-25 04:21:53 | Magdalena, Colombia | |||
798265 | 798265 | 2021-12-22 | Colombia | Magdalena | 101089 | 3477 | 0 | 10.4113 | -74.4057 | 2021-12-23 04:21:21 | Magdalena, Colombia | |||
809427 | 809427 | 2021-09-20 | Colombia | Magdalena | 93310 | 3305 | 0 | 10.4113 | -74.4057 | 2021-09-21 04:21:26 | Magdalena, Colombia | |||
833463 | 833463 | 2022-12-02 | Colombia | Magdalena | 117561 | 3651 | 0 | 10.4113 | -74.4057 | 2022-12-03 04:21:02 | Magdalena, Colombia | |||
849435 | 849435 | 2022-11-02 | Colombia | Magdalena | 117440 | 3644 | 0 | 10.4113 | -74.4057 | 2022-11-03 04:22:05 | Magdalena, Colombia | |||
853451 | 853451 | 2022-09-30 | Colombia | Magdalena | 117397 | 3643 | 0 | 10.4113 | -74.4057 | 2022-10-01 04:23:01 | Magdalena, Colombia | |||
868635 | 868635 | 2022-12-11 | Colombia | Magdalena | 117580 | 3652 | 0 | 10.4113 | -74.4057 | 2022-12-12 04:21:01 | Magdalena, Colombia | |||
876100 | 876100 | 2022-03-27 | Colombia | Magdalena | 114785 | 3620 | 0 | 10.4113 | -74.4057 | 2022-03-28 04:20:33 | Magdalena, Colombia | |||
880116 | 880116 | 2022-08-05 | Colombia | Magdalena | 117116 | 3643 | 0 | 10.4113 | -74.4057 | 2022-08-06 04:20:56 | Magdalena, Colombia | |||
895983 | 895983 | 2022-07-24 | Colombia | Magdalena | 116584 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-25 04:20:51 | Magdalena, Colombia | |||
899999 | 899999 | 2022-07-22 | Colombia | Magdalena | 116584 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-23 04:20:53 | Magdalena, Colombia | |||
904014 | 904014 | 2021-11-24 | Colombia | Magdalena | 99324 | 3424 | 0 | 10.4113 | -74.4057 | 2021-11-25 04:22:33 | Magdalena, Colombia | |||
912044 | 912044 | 2022-10-29 | Colombia | Magdalena | 117440 | 3644 | 0 | 10.4113 | -74.4057 | 2022-10-30 04:22:14 | Magdalena, Colombia | |||
919520 | 919520 | 2022-03-08 | Colombia | Magdalena | 114663 | 3619 | 0 | 10.4113 | -74.4057 | 2022-03-09 04:20:59 | Magdalena, Colombia | |||
934636 | 934636 | 2021-10-16 | Colombia | Magdalena | 95378 | 3342 | 0 | 10.4113 | -74.4057 | 2021-10-17 04:21:29 | Magdalena, Colombia | |||
938653 | 938653 | 2022-06-25 | Colombia | Magdalena | 115958 | 3629 | 0 | 10.4113 | -74.4057 | 2022-06-26 04:21:02 | Magdalena, Colombia | |||
942669 | 942669 | 2022-02-28 | Colombia | Magdalena | 114588 | 3615 | 0 | 10.4113 | -74.4057 | 2022-03-01 04:21:09 | Magdalena, Colombia | |||
946685 | 946685 | 2022-06-14 | Colombia | Magdalena | 115332 | 3625 | 0 | 10.4113 | -74.4057 | 2022-06-15 04:20:54 | Magdalena, Colombia | |||
950701 | 950701 | 2022-03-12 | Colombia | Magdalena | 114686 | 3620 | 0 | 10.4113 | -74.4057 | 2022-03-13 04:20:49 | Magdalena, Colombia | |||
958731 | 958731 | 2022-07-19 | Colombia | Magdalena | 116470 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-20 04:20:59 | Magdalena, Colombia | |||
962747 | 962747 | 2022-09-09 | Colombia | Magdalena | 117366 | 3643 | 0 | 10.4113 | -74.4057 | 2022-09-10 04:21:10 | Magdalena, Colombia | |||
970755 | 970755 | 2022-06-01 | Colombia | Magdalena | 115176 | 3624 | 0 | 10.4113 | -74.4057 | 2022-06-02 05:20:39 | Magdalena, Colombia | |||
978784 | 978784 | 2022-02-01 | Colombia | Magdalena | 112109 | 3540 | 0 | 10.4113 | -74.4057 | 2022-02-02 04:21:09 | Magdalena, Colombia | |||
986814 | 986814 | 2021-10-04 | Colombia | Magdalena | 94366 | 3328 | 0 | 10.4113 | -74.4057 | 2021-10-05 04:21:27 | Magdalena, Colombia | |||
990830 | 990830 | 2022-08-16 | Colombia | Magdalena | 117133 | 3643 | 0 | 10.4113 | -74.4057 | 2022-08-17 04:20:59 | Magdalena, Colombia | |||
1014169 | 1014169 | 2021-11-21 | Colombia | Magdalena | 99047 | 3414 | 0 | 10.4113 | -74.4057 | 2021-11-22 04:22:20 | Magdalena, Colombia | |||
1018186 | 1018186 | 2022-12-24 | Colombia | Magdalena | 117660 | 3653 | 0 | 10.4113 | -74.4057 | 2022-12-25 04:21:04 | Magdalena, Colombia | |||
1022202 | 1022202 | 2022-11-04 | Colombia | Magdalena | 117443 | 3644 | 0 | 10.4113 | -74.4057 | 2022-11-05 04:21:52 | Magdalena, Colombia | |||
1030211 | 1030211 | 2021-12-06 | Colombia | Magdalena | 100421 | 3445 | 0 | 10.4113 | -74.4057 | 2021-12-07 04:22:34 | Magdalena, Colombia | |||
1049674 | 1049674 | 2022-11-06 | Colombia | Magdalena | 117443 | 3645 | 0 | 10.4113 | -74.4057 | 2022-11-07 04:21:26 | Magdalena, Colombia | |||
1057685 | 1057685 | 2022-02-23 | Colombia | Magdalena | 114491 | 3606 | 0 | 10.4113 | -74.4057 | 2022-02-24 04:21:14 | Magdalena, Colombia | |||
1065713 | 1065713 | 2022-07-28 | Colombia | Magdalena | 117031 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-29 04:20:45 | Magdalena, Colombia | |||
1069729 | 1069729 | 2022-08-07 | Colombia | Magdalena | 117116 | 3643 | 0 | 10.4113 | -74.4057 | 2022-08-08 04:21:08 | Magdalena, Colombia | |||
1073745 | 1073745 | 2022-12-28 | Colombia | Magdalena | 117660 | 3653 | 0 | 10.4113 | -74.4057 | 2022-12-29 04:21:01 | Magdalena, Colombia | |||
1077760 | 1077760 | 2021-12-09 | Colombia | Magdalena | 100528 | 3451 | 0 | 10.4113 | -74.4057 | 2021-12-10 04:22:28 | Magdalena, Colombia | |||
1085911 | 1085911 | 2022-08-09 | Colombia | Magdalena | 117116 | 3643 | 0 | 10.4113 | -74.4057 | 2022-08-10 04:20:57 | Magdalena, Colombia | |||
1097954 | 1097954 | 2022-08-03 | Colombia | Magdalena | 117031 | 3641 | 0 | 10.4113 | -74.4057 | 2022-08-04 04:20:58 | Magdalena, Colombia | |||
1109410 | 1109410 | 2022-05-21 | Colombia | Magdalena | 115093 | 3624 | 0 | 10.4113 | -74.4057 | 2022-05-22 04:20:52 | Magdalena, Colombia | |||
1113425 | 1113425 | 2022-01-11 | Colombia | Magdalena | 103452 | 3495 | 0 | 10.4113 | -74.4057 | 2022-01-12 04:21:44 | Magdalena, Colombia | |||
1117441 | 1117441 | 2021-08-06 | Colombia | Magdalena | 89576 | 3212 | 0 | 10.4113 | -74.4057 | 2021-08-07 04:21:30 | Magdalena, Colombia | |||
1140748 | 1140748 | 2022-01-23 | Colombia | Magdalena | 109442 | 3514 | 0 | 10.4113 | -74.4057 | 2022-01-24 04:21:12 | Magdalena, Colombia | |||
1144764 | 1144764 | 2021-12-01 | Colombia | Magdalena | 99995 | 3439 | 0 | 10.4113 | -74.4057 | 2021-12-02 04:22:37 | Magdalena, Colombia | |||
1148781 | 1148781 | 2022-12-12 | Colombia | Magdalena | 117580 | 3652 | 0 | 10.4113 | -74.4057 | 2022-12-13 04:21:01 | Magdalena, Colombia | |||
1156988 | 1156988 | 2022-04-29 | Colombia | Magdalena | 114962 | 3623 | 0 | 10.4113 | -74.4057 | 2022-04-30 04:21:05 | Magdalena, Colombia | |||
1161004 | 1161004 | 2022-08-18 | Colombia | Magdalena | 117231 | 3643 | 0 | 10.4113 | -74.4057 | 2022-08-19 04:20:54 | Magdalena, Colombia | |||
1169034 | 1169034 | 2022-05-20 | Colombia | Magdalena | 115093 | 3624 | 0 | 10.4113 | -74.4057 | 2022-05-21 04:20:58 | Magdalena, Colombia | |||
1184581 | 1184581 | 2022-05-18 | Colombia | Magdalena | 115012 | 3624 | 0 | 10.4113 | -74.4057 | 2022-05-19 04:20:54 | Magdalena, Colombia | |||
1199643 | 1199643 | 2022-07-06 | Colombia | Magdalena | 116349 | 3632 | 0 | 10.4113 | -74.4057 | 2022-07-07 04:20:55 | Magdalena, Colombia | |||
1211388 | 1211388 | 2022-07-11 | Colombia | Magdalena | 116470 | 3635 | 0 | 10.4113 | -74.4057 | 2022-07-12 04:20:51 | Magdalena, Colombia | |||
1215403 | 1215403 | 2022-01-08 | Colombia | Magdalena | 102636 | 3491 | 0 | 10.4113 | -74.4057 | 2022-01-09 04:21:46 | Magdalena, Colombia | |||
1223434 | 1223434 | 2022-04-14 | Colombia | Magdalena | 114898 | 3621 | 0 | 10.4113 | -74.4057 | 2022-04-15 04:20:57 | Magdalena, Colombia | |||
1227449 | 1227449 | 2022-01-24 | Colombia | Magdalena | 109865 | 3514 | 0 | 10.4113 | -74.4057 | 2022-01-25 04:21:05 | Magdalena, Colombia | |||
1231465 | 1231465 | 2021-11-28 | Colombia | Magdalena | 99788 | 3433 | 0 | 10.4113 | -74.4057 | 2021-11-29 04:22:30 | Magdalena, Colombia | |||
1235481 | 1235481 | 2021-09-27 | Colombia | Magdalena | 93761 | 3314 | 0 | 10.4113 | -74.4057 | 2021-09-28 04:21:28 | Magdalena, Colombia | |||
1239497 | 1239497 | 2022-11-28 | Colombia | Magdalena | 117551 | 3651 | 0 | 10.4113 | -74.4057 | 2022-11-29 04:21:05 | Magdalena, Colombia | |||
1250593 | 1250593 | 2022-08-23 | Colombia | Magdalena | 117231 | 3643 | 0 | 10.4113 | -74.4057 | 2022-08-24 04:20:46 | Magdalena, Colombia | |||
1254608 | 1254608 | 2021-12-20 | Colombia | Magdalena | 101028 | 3476 | 0 | 10.4113 | -74.4057 | 2021-12-21 03:21:27 | Magdalena, Colombia | |||
1258624 | 1258624 | 2021-12-18 | Colombia | Magdalena | 100965 | 3471 | 0 | 10.4113 | -74.4057 | 2021-12-19 04:21:11 | Magdalena, Colombia | |||
1262640 | 1262640 | 2021-09-09 | Colombia | Magdalena | 92697 | 3293 | 0 | 10.4113 | -74.4057 | 2021-09-10 04:21:20 | Magdalena, Colombia | |||
1274124 | 1274124 | 2021-10-03 | Colombia | Magdalena | 94344 | 3327 | 0 | 10.4113 | -74.4057 | 2021-10-04 04:21:31 | Magdalena, Colombia | |||
1281825 | 1281825 | 2022-01-05 | Colombia | Magdalena | 102039 | 3491 | 0 | 10.4113 | -74.4057 | 2022-01-06 04:22:09 | Magdalena, Colombia | |||
1285841 | 1285841 | 2022-01-04 | Colombia | Magdalena | 101964 | 3491 | 0 | 10.4113 | -74.4057 | 2022-01-05 04:21:59 | Magdalena, Colombia | |||
1293871 | 1293871 | 2022-02-05 | Colombia | Magdalena | 112852 | 3551 | 0 | 10.4113 | -74.4057 | 2022-02-06 04:21:00 | Magdalena, Colombia | |||
1297888 | 1297888 | 2022-02-17 | Colombia | Magdalena | 114140 | 3591 | 0 | 10.4113 | -74.4057 | 2022-02-18 04:21:04 | Magdalena, Colombia | |||
1314035 | 1314035 | 2022-05-27 | Colombia | Magdalena | 115176 | 3624 | 0 | 10.4113 | -74.4057 | 2022-05-28 04:21:07 | Magdalena, Colombia | |||
1318050 | 1318050 | 2022-01-26 | Colombia | Magdalena | 110419 | 3522 | 0 | 10.4113 | -74.4057 | 2022-01-27 04:21:19 | Magdalena, Colombia | |||
1322066 | 1322066 | 2021-11-14 | Colombia | Magdalena | 98242 | 3401 | 0 | 10.4113 | -74.4057 | 2021-11-15 04:21:36 | Magdalena, Colombia | |||
1326083 | 1326083 | 2022-04-26 | Colombia | Magdalena | 114959 | 3622 | 0 | 10.4113 | -74.4057 | 2022-04-27 04:20:52 | Magdalena, Colombia | |||
1334112 | 1334112 | 2021-09-28 | Colombia | Magdalena | 93931 | 3316 | 0 | 10.4113 | -74.4057 | 2021-09-29 04:21:45 | Magdalena, Colombia | |||
1342141 | 1342141 | 2021-08-11 | Colombia | Magdalena | 90101 | 3232 | 0 | 10.4113 | -74.4057 | 2021-08-12 04:21:25 | Magdalena, Colombia | |||
1346156 | 1346156 | 2022-08-10 | Colombia | Magdalena | 117116 | 3643 | 0 | 10.4113 | -74.4057 | 2022-08-11 04:20:49 | Magdalena, Colombia | |||
1358172 | 1358172 | 2021-11-27 | Colombia | Magdalena | 99723 | 3431 | 0 | 10.4113 | -74.4057 | 2021-11-28 04:22:43 | Magdalena, Colombia | |||
1362188 | 1362188 | 2022-02-08 | Colombia | Magdalena | 113529 | 3561 | 0 | 10.4113 | -74.4057 | 2022-02-09 04:21:04 | Magdalena, Colombia | |||
1366313 | 1366313 | 2022-10-28 | Colombia | Magdalena | 117440 | 3644 | 0 | 10.4113 | -74.4057 | 2022-10-29 04:21:13 | Magdalena, Colombia | |||
1370329 | 1370329 | 2022-09-21 | Colombia | Magdalena | 117386 | 3643 | 0 | 10.4113 | -74.4057 | 2022-09-22 04:22:56 | Magdalena, Colombia | |||
1374344 | 1374344 | 2021-09-15 | Colombia | Magdalena | 92963 | 3300 | 0 | 10.4113 | -74.4057 | 2021-09-16 04:22:19 | Magdalena, Colombia | |||
1385482 | 1385482 | 2021-09-13 | Colombia | Magdalena | 92892 | 3300 | 0 | 10.4113 | -74.4057 | 2021-09-14 04:21:41 | Magdalena, Colombia | |||
1389496 | 1389496 | 2022-01-07 | Colombia | Magdalena | 102372 | 3491 | 0 | 10.4113 | -74.4057 | 2022-01-08 04:21:53 | Magdalena, Colombia | |||
1393513 | 1393513 | 2022-09-02 | Colombia | Magdalena | 117353 | 3643 | 0 | 10.4113 | -74.4057 | 2022-09-03 04:21:04 | Magdalena, Colombia | |||
1397529 | 1397529 | 2022-05-06 | Colombia | Magdalena | 114982 | 3624 | 0 | 10.4113 | -74.4057 | 2022-05-07 04:21:09 | Magdalena, Colombia | |||
1404879 | 1404879 | 2022-08-02 | Colombia | Magdalena | 117031 | 3641 | 0 | 10.4113 | -74.4057 | 2022-08-03 04:20:59 | Magdalena, Colombia | |||
1416923 | 1416923 | 2022-07-08 | Colombia | Magdalena | 116470 | 3635 | 0 | 10.4113 | -74.4057 | 2022-07-09 04:20:59 | Magdalena, Colombia | |||
1420939 | 1420939 | 2022-06-08 | Colombia | Magdalena | 115176 | 3624 | 0 | 10.4113 | -74.4057 | 2022-06-09 04:20:54 | Magdalena, Colombia | |||
1432402 | 1432402 | 2021-12-28 | Colombia | Magdalena | 101283 | 3485 | 0 | 10.4113 | -74.4057 | 2021-12-29 03:21:43 | Magdalena, Colombia | |||
1436419 | 1436419 | 2022-03-28 | Colombia | Magdalena | 114791 | 3620 | 0 | 10.4113 | -74.4057 | 2022-03-29 04:20:46 | Magdalena, Colombia | |||
1463920 | 1463920 | 2022-02-10 | Colombia | Magdalena | 113678 | 3576 | 0 | 10.4113 | -74.4057 | 2022-02-11 04:21:09 | Magdalena, Colombia | |||
1467936 | 1467936 | 2022-03-24 | Colombia | Magdalena | 114780 | 3620 | 0 | 10.4113 | -74.4057 | 2022-03-25 04:20:46 | Magdalena, Colombia | |||
1471951 | 1471951 | 2022-01-17 | Colombia | Magdalena | 106294 | 3503 | 0 | 10.4113 | -74.4057 | 2022-01-18 04:21:04 | Magdalena, Colombia | |||
1483407 | 1483407 | 2021-08-13 | Colombia | Magdalena | 90332 | 3235 | 0 | 10.4113 | -74.4057 | 2021-08-14 04:21:25 | Magdalena, Colombia | |||
1487422 | 1487422 | 2022-07-26 | Colombia | Magdalena | 116584 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-27 04:21:04 | Magdalena, Colombia | |||
1491437 | 1491437 | 2021-10-12 | Colombia | Magdalena | 95034 | 3338 | 0 | 10.4113 | -74.4057 | 2021-10-13 04:20:51 | Magdalena, Colombia | |||
1503435 | 1503435 | 2022-05-16 | Colombia | Magdalena | 115012 | 3624 | 0 | 10.4113 | -74.4057 | 2022-05-17 04:20:59 | Magdalena, Colombia |
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]);