daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Magdalena" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-09-07 | Colombia | Magdalena | 13085 | 731 | 10713 | 1641 | 10.4113 | -74.4057 | 2020-09-08 04:28:25 | Magdalena, Colombia | ||
2022-11-03 | Colombia | Magdalena | 117443 | 3644 | 0 | 10.4113 | -74.4057 | 2022-11-04 04:22:11 | Magdalena, Colombia | |||
2021-01-21 | Colombia | Magdalena | 28338 | 1147 | 26063 | 1128 | 10.4113 | -74.4057 | 2021-01-22 05:22:10 | Magdalena, Colombia | ||
2020-07-26 | Colombia | Magdalena | 4927 | 311 | 2428 | 2188 | 10.4113 | -74.4057 | 2020-07-27 04:35:02 | Magdalena, Colombia | ||
2021-10-20 | Colombia | Magdalena | 95600 | 3344 | 0 | 10.4113 | -74.4057 | 2021-10-21 04:21:18 | Magdalena, Colombia | |||
2021-11-17 | Colombia | Magdalena | 98647 | 3408 | 0 | 10.4113 | -74.4057 | 2021-11-18 04:21:33 | Magdalena, Colombia | |||
2022-12-21 | Colombia | Magdalena | 117621 | 3652 | 0 | 10.4113 | -74.4057 | 2022-12-22 04:20:56 | Magdalena, Colombia | |||
2020-08-07 | Colombia | Magdalena | 7973 | 421 | 4487 | 3065 | 10.4113 | -74.4057 | 2020-08-08 04:34:53 | Magdalena, Colombia | ||
2022-02-02 | Colombia | Magdalena | 112479 | 3541 | 0 | 10.4113 | -74.4057 | 2022-02-03 04:21:21 | Magdalena, Colombia | |||
2022-05-02 | Colombia | Magdalena | 114965 | 3624 | 0 | 10.4113 | -74.4057 | 2022-05-03 04:21:00 | Magdalena, Colombia | |||
2021-10-07 | Colombia | Magdalena | 94678 | 3335 | 0 | 10.4113 | -74.4057 | 2021-10-08 04:21:25 | Magdalena, Colombia | |||
2021-02-19 | Colombia | Magdalena | 32342 | 1236 | 30202 | 904 | 10.4113 | -74.4057 | 2021-02-20 05:22:51 | Magdalena, Colombia | ||
2022-06-26 | Colombia | Magdalena | 115958 | 3629 | 0 | 10.4113 | -74.4057 | 2022-06-27 04:21:00 | Magdalena, Colombia | |||
2022-11-08 | Colombia | Magdalena | 117443 | 3645 | 0 | 10.4113 | -74.4057 | 2022-11-09 04:21:22 | Magdalena, Colombia | |||
2021-07-19 | Colombia | Magdalena | 85581 | 3111 | 81241 | 1229 | 10.4113 | -74.4057 | 2021-07-20 04:21:48 | Magdalena, Colombia | ||
2022-11-25 | Colombia | Magdalena | 117551 | 3651 | 0 | 10.4113 | -74.4057 | 2022-11-26 04:21:11 | Magdalena, Colombia | |||
2021-10-14 | Colombia | Magdalena | 95166 | 3339 | 0 | 10.4113 | -74.4057 | 2021-10-15 04:21:26 | Magdalena, Colombia | |||
2021-11-06 | Colombia | Magdalena | 97294 | 3377 | 0 | 10.4113 | -74.4057 | 2021-11-07 04:21:53 | Magdalena, Colombia | |||
2022-04-02 | Colombia | Magdalena | 114801 | 3621 | 0 | 10.4113 | -74.4057 | 2022-04-03 04:20:48 | Magdalena, Colombia | |||
2022-12-17 | Colombia | Magdalena | 117621 | 3652 | 0 | 10.4113 | -74.4057 | 2022-12-18 04:21:03 | Magdalena, Colombia | |||
2021-08-14 | Colombia | Magdalena | 90477 | 3241 | 0 | 10.4113 | -74.4057 | 2021-08-15 04:21:41 | Magdalena, Colombia | |||
2021-08-19 | Colombia | Magdalena | 90924 | 3256 | 0 | 10.4113 | -74.4057 | 2021-08-20 04:21:33 | Magdalena, Colombia | |||
2022-10-15 | Colombia | Magdalena | 117421 | 3643 | 0 | 10.4113 | -74.4057 | 2022-10-16 04:22:39 | Magdalena, Colombia | |||
2021-06-09 | Colombia | Magdalena | 73145 | 2741 | 69117 | 1287 | 10.4113 | -74.4057 | 2021-06-10 04:23:17 | Magdalena, Colombia | ||
2020-07-04 | Colombia | Magdalena | 2017 | 153 | 810 | 1054 | 10.4113 | -74.4057 | 2020-07-05 04:33:46 | Magdalena, Colombia | ||
2021-02-22 | Colombia | Magdalena | 32752 | 1257 | 30677 | 818 | 10.4113 | -74.4057 | 2021-02-23 05:23:41 | Magdalena, Colombia | ||
2021-10-27 | Colombia | Magdalena | 96156 | 3361 | 0 | 10.4113 | -74.4057 | 2021-10-28 04:22:08 | Magdalena, Colombia | |||
2022-10-26 | Colombia | Magdalena | 117424 | 3643 | 0 | 10.4113 | -74.4057 | 2022-10-27 04:22:01 | Magdalena, Colombia | |||
2022-12-15 | Colombia | Magdalena | 117621 | 3652 | 0 | 10.4113 | -74.4057 | 2022-12-16 04:21:01 | Magdalena, Colombia | |||
2020-09-12 | Colombia | Magdalena | 13779 | 759 | 11693 | 1327 | 10.4113 | -74.4057 | 2020-09-13 04:30:52 | Magdalena, Colombia | ||
2021-12-08 | Colombia | Magdalena | 100498 | 3447 | 0 | 10.4113 | -74.4057 | 2021-12-09 04:22:49 | Magdalena, Colombia | |||
2022-01-16 | Colombia | Magdalena | 105870 | 3501 | 0 | 10.4113 | -74.4057 | 2022-01-17 04:21:08 | Magdalena, Colombia | |||
2022-06-16 | Colombia | Magdalena | 115798 | 3625 | 0 | 10.4113 | -74.4057 | 2022-06-17 04:20:56 | Magdalena, Colombia | |||
2021-06-22 | Colombia | Magdalena | 77475 | 2883 | 72612 | 1980 | 10.4113 | -74.4057 | 2021-06-23 04:21:46 | Magdalena, Colombia | ||
2021-10-29 | Colombia | Magdalena | 96354 | 3366 | 0 | 10.4113 | -74.4057 | 2021-10-30 04:22:03 | Magdalena, Colombia | |||
2020-06-06 | Colombia | Magdalena | 735 | 46 | 315 | 374 | 10.4113 | -74.4057 | 2020-06-07 03:53:30 | Magdalena, Colombia | ||
2022-02-25 | Colombia | Magdalena | 114528 | 3609 | 0 | 10.4113 | -74.4057 | 2022-02-26 04:21:12 | Magdalena, Colombia | |||
2021-07-13 | Colombia | Magdalena | 84794 | 3065 | 79895 | 1834 | 10.4113 | -74.4057 | 2021-07-14 04:21:35 | Magdalena, Colombia | ||
2020-08-13 | Colombia | Magdalena | 9443 | 466 | 5410 | 3567 | 10.4113 | -74.4057 | 2020-08-14 04:51:19 | Magdalena, Colombia | ||
2021-08-08 | Colombia | Magdalena | 89772 | 3221 | 0 | 10.4113 | -74.4057 | 2021-08-09 04:21:24 | Magdalena, Colombia | |||
2022-07-01 | Colombia | Magdalena | 116349 | 3632 | 0 | 10.4113 | -74.4057 | 2022-07-02 04:21:16 | Magdalena, Colombia | |||
2021-10-19 | Colombia | Magdalena | 95548 | 3343 | 0 | 10.4113 | -74.4057 | 2021-10-20 04:21:00 | Magdalena, Colombia | |||
2021-09-23 | Colombia | Magdalena | 93576 | 3309 | 0 | 10.4113 | -74.4057 | 2021-09-24 04:21:44 | Magdalena, Colombia | |||
2021-04-09 | Colombia | Magdalena | 48130 | 1763 | 44795 | 1572 | 10.4113 | -74.4057 | 2021-04-10 04:20:59 | Magdalena, Colombia | ||
2020-08-29 | Colombia | Magdalena | 12109 | 666 | 9323 | 2120 | 10.4113 | -74.4057 | 2020-08-30 04:28:22 | Magdalena, Colombia | ||
2021-02-08 | Colombia | Magdalena | 30950 | 1200 | 28925 | 825 | 10.4113 | -74.4057 | 2021-02-09 05:23:30 | Magdalena, Colombia | ||
2022-11-05 | Colombia | Magdalena | 117443 | 3644 | 0 | 10.4113 | -74.4057 | 2022-11-06 04:21:24 | Magdalena, Colombia | |||
2022-05-22 | Colombia | Magdalena | 115093 | 3624 | 0 | 10.4113 | -74.4057 | 2022-05-26 04:20:50 | Magdalena, Colombia | |||
2021-07-10 | Colombia | Magdalena | 83796 | 3047 | 78451 | 2298 | 10.4113 | -74.4057 | 2021-07-11 04:21:43 | Magdalena, Colombia | ||
2022-07-12 | Colombia | Magdalena | 116470 | 3635 | 0 | 10.4113 | -74.4057 | 2022-07-13 04:20:58 | Magdalena, Colombia | |||
2021-10-13 | Colombia | Magdalena | 95069 | 3339 | 0 | 10.4113 | -74.4057 | 2021-10-14 04:21:29 | Magdalena, Colombia | |||
2021-03-31 | Colombia | Magdalena | 43967 | 1618 | 40528 | 1821 | 10.4113 | -74.4057 | 2021-04-01 04:27:05 | Magdalena, Colombia | ||
2021-09-07 | Colombia | Magdalena | 92541 | 3290 | 0 | 10.4113 | -74.4057 | 2021-09-08 04:21:31 | Magdalena, Colombia | |||
2021-05-05 | Colombia | Magdalena | 61101 | 2329 | 57096 | 1676 | 10.4113 | -74.4057 | 2021-05-06 04:20:38 | Magdalena, Colombia | ||
2021-08-09 | Colombia | Magdalena | 89879 | 3223 | 0 | 10.4113 | -74.4057 | 2021-08-10 04:21:27 | Magdalena, Colombia | |||
2021-10-22 | Colombia | Magdalena | 95729 | 3345 | 0 | 10.4113 | -74.4057 | 2021-10-23 04:21:32 | Magdalena, Colombia | |||
2022-05-13 | Colombia | Magdalena | 115012 | 3624 | 0 | 10.4113 | -74.4057 | 2022-05-14 04:20:48 | Magdalena, Colombia | |||
2020-08-11 | Colombia | Magdalena | 8832 | 445 | 5160 | 3227 | 10.4113 | -74.4057 | 2020-08-12 04:27:29 | Magdalena, Colombia | ||
2020-09-16 | Colombia | Magdalena | 14095 | 777 | 11922 | 1396 | 10.4113 | -74.4057 | 2020-09-17 04:22:00 | Magdalena, Colombia | ||
2022-07-21 | Colombia | Magdalena | 116470 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-22 04:21:15 | Magdalena, Colombia | |||
2022-07-30 | Colombia | Magdalena | 117031 | 3641 | 0 | 10.4113 | -74.4057 | 2022-07-31 04:21:02 | Magdalena, Colombia | |||
2020-11-23 | Colombia | Magdalena | 19215 | 956 | 17518 | 741 | 10.4113 | -74.4057 | 2020-11-24 05:27:31 | Magdalena, Colombia | ||
2021-10-24 | Colombia | Magdalena | 95846 | 3351 | 0 | 10.4113 | -74.4057 | 2021-10-25 04:22:31 | Magdalena, Colombia | |||
2021-11-13 | Colombia | Magdalena | 98071 | 3398 | 0 | 10.4113 | -74.4057 | 2021-11-14 04:21:31 | Magdalena, Colombia | |||
2022-12-23 | Colombia | Magdalena | 117660 | 3653 | 0 | 10.4113 | -74.4057 | 2022-12-24 04:21:02 | Magdalena, Colombia | |||
2022-03-17 | Colombia | Magdalena | 114736 | 3620 | 0 | 10.4113 | -74.4057 | 2022-03-18 04:20:55 | Magdalena, Colombia | |||
2021-11-04 | Colombia | Magdalena | 97026 | 3376 | 0 | 10.4113 | -74.4057 | 2021-11-05 04:21:54 | Magdalena, Colombia | |||
2021-03-16 | Colombia | Magdalena | 38127 | 1427 | 35200 | 1500 | 10.4113 | -74.4057 | 2021-03-17 05:25:07 | Magdalena, Colombia | ||
2021-09-29 | Colombia | Magdalena | 94000 | 3320 | 0 | 10.4113 | -74.4057 | 2021-09-30 04:21:20 | Magdalena, Colombia | |||
2022-11-01 | Colombia | Magdalena | 117440 | 3644 | 0 | 10.4113 | -74.4057 | 2022-11-02 04:22:09 | Magdalena, Colombia | |||
2021-11-12 | Colombia | Magdalena | 97957 | 3396 | 0 | 10.4113 | -74.4057 | 2021-11-13 04:21:38 | Magdalena, Colombia | |||
2022-12-04 | Colombia | Magdalena | 117561 | 3651 | 0 | 10.4113 | -74.4057 | 2022-12-05 04:20:58 | Magdalena, Colombia | |||
2021-11-20 | Colombia | Magdalena | 98931 | 3411 | 0 | 10.4113 | -74.4057 | 2021-11-21 04:22:13 | Magdalena, Colombia | |||
2021-05-22 | Colombia | Magdalena | 67160 | 2555 | 62806 | 1799 | 10.4113 | -74.4057 | 2021-05-23 04:20:51 | Magdalena, Colombia | ||
2021-12-27 | Colombia | Magdalena | 101246 | 3481 | 0 | 10.4113 | -74.4057 | 2021-12-28 04:21:47 | Magdalena, Colombia | |||
2020-06-12 | Colombia | Magdalena | 833 | 55 | 414 | 364 | 10.4113 | -74.4057 | 2020-06-13 03:33:14 | Magdalena, Colombia | ||
2020-12-02 | Colombia | Magdalena | 20517 | 984 | 18590 | 943 | 10.4113 | -74.4057 | 2020-12-03 05:28:22 | Magdalena, Colombia | ||
2021-02-20 | Colombia | Magdalena | 32576 | 1236 | 30373 | 967 | 10.4113 | -74.4057 | 2021-02-21 05:24:33 | Magdalena, Colombia | ||
2022-04-23 | Colombia | Magdalena | 114929 | 3621 | 0 | 10.4113 | -74.4057 | 2022-04-24 04:20:56 | Magdalena, Colombia | |||
2020-08-01 | Colombia | Magdalena | 6531 | 368 | 3554 | 2609 | 10.4113 | -74.4057 | 2020-08-02 04:34:47 | Magdalena, Colombia | ||
2020-10-28 | Colombia | Magdalena | 17071 | 896 | 15479 | 696 | 10.4113 | -74.4057 | 2020-10-29 04:24:49 | Magdalena, Colombia | ||
2021-11-26 | Colombia | Magdalena | 99555 | 3429 | 0 | 10.4113 | -74.4057 | 2021-11-27 04:22:45 | Magdalena, Colombia | |||
2020-10-18 | Colombia | Magdalena | 16400 | 869 | 14847 | 684 | 10.4113 | -74.4057 | 2020-10-19 04:24:16 | Magdalena, Colombia | ||
2020-12-29 | Colombia | Magdalena | 24581 | 1059 | 22564 | 958 | 10.4113 | -74.4057 | 2020-12-30 05:22:34 | Magdalena, Colombia | ||
2021-10-23 | Colombia | Magdalena | 95797 | 3347 | 0 | 10.4113 | -74.4057 | 2021-10-24 04:21:22 | Magdalena, Colombia | |||
2021-01-12 | Colombia | Magdalena | 26501 | 1121 | 24303 | 1077 | 10.4113 | -74.4057 | 2021-01-13 05:22:15 | Magdalena, Colombia | ||
2021-07-08 | Colombia | Magdalena | 83162 | 3041 | 78038 | 2083 | 10.4113 | -74.4057 | 2021-07-09 04:21:21 | Magdalena, Colombia | ||
2021-12-13 | Colombia | Magdalena | 100792 | 3459 | 0 | 10.4113 | -74.4057 | 2021-12-14 04:22:38 | Magdalena, Colombia | |||
2020-10-15 | Colombia | Magdalena | 16258 | 866 | 14609 | 783 | 10.4113 | -74.4057 | 2020-10-16 04:24:01 | Magdalena, Colombia | ||
2021-02-04 | Colombia | Magdalena | 30510 | 1191 | 28378 | 941 | 10.4113 | -74.4057 | 2021-02-05 05:22:38 | Magdalena, Colombia | ||
2022-10-24 | Colombia | Magdalena | 117424 | 3643 | 0 | 10.4113 | -74.4057 | 2022-10-25 04:21:53 | Magdalena, Colombia | |||
2021-12-22 | Colombia | Magdalena | 101089 | 3477 | 0 | 10.4113 | -74.4057 | 2021-12-23 04:21:21 | Magdalena, Colombia | |||
2020-06-01 | Colombia | Magdalena | 610 | 40 | 226 | 344 | 10.4113 | -74.4057 | 2020-06-02 02:33:08 | Magdalena, Colombia | ||
2021-09-20 | Colombia | Magdalena | 93310 | 3305 | 0 | 10.4113 | -74.4057 | 2021-09-21 04:21:26 | Magdalena, Colombia | |||
2020-09-05 | Colombia | Magdalena | 12952 | 710 | 10301 | 1941 | 10.4113 | -74.4057 | 2020-09-06 04:28:33 | Magdalena, Colombia | ||
2020-10-09 | Colombia | Magdalena | 15867 | 862 | 14052 | 953 | 10.4113 | -74.4057 | 2020-10-10 04:23:57 | Magdalena, Colombia | ||
2020-11-19 | Colombia | Magdalena | 18812 | 950 | 17188 | 674 | 10.4113 | -74.4057 | 2020-11-20 05:26:28 | Magdalena, Colombia | ||
2021-06-06 | Colombia | Magdalena | 72987 | 2734 | 68474 | 1779 | 10.4113 | -74.4057 | 2021-06-07 04:22:51 | Magdalena, Colombia | ||
2021-07-09 | Colombia | Magdalena | 83474 | 3047 | 78038 | 2389 | 10.4113 | -74.4057 | 2021-07-10 04:21:25 | Magdalena, Colombia | ||
2022-12-02 | Colombia | Magdalena | 117561 | 3651 | 0 | 10.4113 | -74.4057 | 2022-12-03 04:21:02 | Magdalena, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;