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 last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
last_update (date) >30 ✖
- 2022-04-13 2
- 2022-05-26 2
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- 2020-06-19 1
- 2020-06-20 1
- 2020-06-21 1
- 2020-06-22 1
- 2020-06-23 1
- 2020-06-24 1
- 2020-06-25 1
- …
province_or_state 1
- Magdalena · 946 ✖
country_or_region 1
- Colombia · 946 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-05-28 | Colombia | Magdalena | 548 | 37 | 160 | 351 | 10.4113 | -74.4057 | 2020-05-29 02:32:50 | Magdalena, Colombia | ||
2020-05-29 | Colombia | Magdalena | 556 | 37 | 163 | 356 | 10.4113 | -74.4057 | 2020-05-30 02:32:48 | Magdalena, Colombia | ||
2020-05-30 | Colombia | Magdalena | 568 | 38 | 173 | 357 | 10.4113 | -74.4057 | 2020-05-31 02:32:45 | Magdalena, Colombia | ||
2020-05-31 | Colombia | Magdalena | 594 | 39 | 177 | 378 | 10.4113 | -74.4057 | 2020-06-01 02:32:46 | Magdalena, Colombia | ||
2020-06-01 | Colombia | Magdalena | 610 | 40 | 226 | 344 | 10.4113 | -74.4057 | 2020-06-02 02:33:08 | Magdalena, Colombia | ||
2020-06-02 | Colombia | Magdalena | 635 | 41 | 262 | 332 | 10.4113 | -74.4057 | 2020-06-03 02:33:13 | Magdalena, Colombia | ||
2020-06-03 | Colombia | Magdalena | 653 | 43 | 269 | 341 | 10.4113 | -74.4057 | 2020-06-04 02:33:14 | Magdalena, Colombia | ||
2020-06-04 | Colombia | Magdalena | 706 | 44 | 275 | 387 | 10.4113 | -74.4057 | 2020-06-05 02:33:06 | Magdalena, Colombia | ||
2020-06-05 | Colombia | Magdalena | 735 | 46 | 315 | 374 | 10.4113 | -74.4057 | 2020-06-06 02:33:00 | Magdalena, Colombia | ||
2020-06-06 | Colombia | Magdalena | 735 | 46 | 315 | 374 | 10.4113 | -74.4057 | 2020-06-07 03:53:30 | Magdalena, Colombia | ||
2020-06-07 | Colombia | Magdalena | 750 | 48 | 353 | 349 | 10.4113 | -74.4057 | 2020-06-08 03:33:22 | Magdalena, Colombia | ||
2020-06-08 | Colombia | Magdalena | 780 | 48 | 380 | 352 | 10.4113 | -74.4057 | 2020-06-09 03:33:03 | Magdalena, Colombia | ||
2020-06-09 | Colombia | Magdalena | 780 | 48 | 380 | 352 | 10.4113 | -74.4057 | 2020-06-10 04:07:00 | Magdalena, Colombia | ||
2020-06-10 | Colombia | Magdalena | 799 | 49 | 381 | 369 | 10.4113 | -74.4057 | 2020-06-11 03:33:41 | Magdalena, Colombia | ||
2020-06-11 | Colombia | Magdalena | 819 | 51 | 409 | 359 | 10.4113 | -74.4057 | 2020-06-12 05:09:52 | Magdalena, Colombia | ||
2020-06-12 | Colombia | Magdalena | 833 | 55 | 414 | 364 | 10.4113 | -74.4057 | 2020-06-13 03:33:14 | Magdalena, Colombia | ||
2020-06-13 | Colombia | Magdalena | 850 | 55 | 425 | 370 | 10.4113 | -74.4057 | 2020-06-14 03:33:15 | Magdalena, Colombia | ||
2020-06-14 | Colombia | Magdalena | 920 | 57 | 433 | 430 | 10.4113 | -74.4057 | 2020-06-15 03:33:14 | Magdalena, Colombia | ||
2020-06-15 | Colombia | Magdalena | 973 | 65 | 445 | 463 | 10.4113 | -74.4057 | 2020-06-16 04:33:09 | Magdalena, Colombia | ||
2020-06-16 | Colombia | Magdalena | 973 | 65 | 445 | 463 | 10.4113 | -74.4057 | 2020-06-17 04:33:21 | Magdalena, Colombia | ||
2020-06-17 | Colombia | Magdalena | 996 | 65 | 457 | 474 | 10.4113 | -74.4057 | 2020-06-18 04:33:18 | Magdalena, Colombia | ||
2020-06-18 | Colombia | Magdalena | 1027 | 66 | 490 | 471 | 10.4113 | -74.4057 | 2020-06-19 04:33:17 | Magdalena, Colombia | ||
2020-06-19 | Colombia | Magdalena | 1121 | 69 | 515 | 537 | 10.4113 | -74.4057 | 2020-06-20 04:33:19 | Magdalena, Colombia | ||
2020-06-20 | Colombia | Magdalena | 1150 | 77 | 528 | 545 | 10.4113 | -74.4057 | 2020-06-21 04:33:19 | Magdalena, Colombia | ||
2020-06-21 | Colombia | Magdalena | 1277 | 86 | 568 | 623 | 10.4113 | -74.4057 | 2020-06-22 04:33:20 | Magdalena, Colombia | ||
2020-06-22 | Colombia | Magdalena | 1298 | 88 | 582 | 628 | 10.4113 | -74.4057 | 2020-06-23 04:33:22 | Magdalena, Colombia | ||
2020-06-23 | Colombia | Magdalena | 1325 | 91 | 591 | 643 | 10.4113 | -74.4057 | 2020-06-24 04:33:28 | Magdalena, Colombia | ||
2020-06-24 | Colombia | Magdalena | 1325 | 91 | 591 | 643 | 10.4113 | -74.4057 | 2020-06-25 05:26:54 | Magdalena, Colombia | ||
2020-06-25 | Colombia | Magdalena | 1390 | 91 | 621 | 678 | 10.4113 | -74.4057 | 2020-06-26 04:33:43 | Magdalena, Colombia | ||
2020-06-26 | Colombia | Magdalena | 1488 | 100 | 646 | 742 | 10.4113 | -74.4057 | 2020-06-27 04:33:35 | Magdalena, Colombia | ||
2020-06-27 | Colombia | Magdalena | 1545 | 104 | 658 | 783 | 10.4113 | -74.4057 | 2020-06-28 04:34:04 | Magdalena, Colombia | ||
2020-06-28 | Colombia | Magdalena | 1752 | 111 | 729 | 912 | 10.4113 | -74.4057 | 2020-06-29 04:33:44 | Magdalena, Colombia | ||
2020-06-29 | Colombia | Magdalena | 1752 | 111 | 729 | 912 | 10.4113 | -74.4057 | 2020-06-30 04:33:48 | Magdalena, Colombia | ||
2020-06-30 | Colombia | Magdalena | 1774 | 116 | 747 | 911 | 10.4113 | -74.4057 | 2020-07-01 04:33:52 | Magdalena, Colombia | ||
2020-07-01 | Colombia | Magdalena | 1854 | 121 | 778 | 955 | 10.4113 | -74.4057 | 2020-07-02 04:33:46 | Magdalena, Colombia | ||
2020-07-02 | Colombia | Magdalena | 1903 | 134 | 789 | 980 | 10.4113 | -74.4057 | 2020-07-03 04:33:54 | Magdalena, Colombia | ||
2020-07-03 | Colombia | Magdalena | 1988 | 142 | 793 | 1053 | 10.4113 | -74.4057 | 2020-07-04 04:33:51 | Magdalena, Colombia | ||
2020-07-04 | Colombia | Magdalena | 2017 | 153 | 810 | 1054 | 10.4113 | -74.4057 | 2020-07-05 04:33:46 | Magdalena, Colombia | ||
2020-07-05 | Colombia | Magdalena | 2081 | 156 | 827 | 1098 | 10.4113 | -74.4057 | 2020-07-06 04:33:57 | Magdalena, Colombia | ||
2020-07-06 | Colombia | Magdalena | 2120 | 156 | 835 | 1129 | 10.4113 | -74.4057 | 2020-07-07 04:34:00 | Magdalena, Colombia | ||
2020-07-07 | Colombia | Magdalena | 2182 | 161 | 859 | 1162 | 10.4113 | -74.4057 | 2020-07-08 05:33:48 | Magdalena, Colombia | ||
2020-07-08 | Colombia | Magdalena | 2308 | 166 | 887 | 1255 | 10.4113 | -74.4057 | 2020-07-09 04:34:23 | Magdalena, Colombia | ||
2020-07-09 | Colombia | Magdalena | 2342 | 175 | 910 | 1257 | 10.4113 | -74.4057 | 2020-07-10 04:34:24 | Magdalena, Colombia | ||
2020-07-10 | Colombia | Magdalena | 2543 | 178 | 967 | 1398 | 10.4113 | -74.4057 | 2020-07-11 04:34:26 | Magdalena, Colombia | ||
2020-07-11 | Colombia | Magdalena | 2655 | 204 | 986 | 1465 | 10.4113 | -74.4057 | 2020-07-12 04:34:30 | Magdalena, Colombia | ||
2020-07-12 | Colombia | Magdalena | 2785 | 209 | 1051 | 1525 | 10.4113 | -74.4057 | 2020-07-13 04:43:04 | Magdalena, Colombia | ||
2020-07-13 | Colombia | Magdalena | 2815 | 213 | 1072 | 1530 | 10.4113 | -74.4057 | 2020-07-14 04:34:46 | Magdalena, Colombia | ||
2020-07-14 | Colombia | Magdalena | 2900 | 214 | 1106 | 1580 | 10.4113 | -74.4057 | 2020-07-15 04:34:39 | Magdalena, Colombia | ||
2020-07-15 | Colombia | Magdalena | 3001 | 214 | 1175 | 1612 | 10.4113 | -74.4057 | 2020-07-16 04:44:59 | Magdalena, Colombia | ||
2020-07-16 | Colombia | Magdalena | 3043 | 221 | 1224 | 1598 | 10.4113 | -74.4057 | 2020-07-17 04:34:50 | Magdalena, Colombia | ||
2020-07-17 | Colombia | Magdalena | 3612 | 227 | 1423 | 1962 | 10.4113 | -74.4057 | 2020-07-18 04:34:45 | Magdalena, Colombia | ||
2020-07-18 | Colombia | Magdalena | 3947 | 238 | 1512 | 2197 | 10.4113 | -74.4057 | 2020-07-19 04:34:58 | Magdalena, Colombia | ||
2020-07-19 | Colombia | Magdalena | 4179 | 259 | 1680 | 2240 | 10.4113 | -74.4057 | 2020-07-20 05:34:40 | Magdalena, Colombia | ||
2020-07-20 | Colombia | Magdalena | 4348 | 271 | 1821 | 2256 | 10.4113 | -74.4057 | 2020-07-21 04:38:46 | Magdalena, Colombia | ||
2020-07-21 | Colombia | Magdalena | 4506 | 277 | 1911 | 2318 | 10.4113 | -74.4057 | 2020-07-22 04:34:42 | Magdalena, Colombia | ||
2020-07-22 | Colombia | Magdalena | 4618 | 277 | 1988 | 2353 | 10.4113 | -74.4057 | 2020-07-23 05:15:04 | Magdalena, Colombia | ||
2020-07-23 | Colombia | Magdalena | 4771 | 293 | 2154 | 2324 | 10.4113 | -74.4057 | 2020-07-24 05:30:40 | Magdalena, Colombia | ||
2020-07-24 | Colombia | Magdalena | 4829 | 301 | 2241 | 2287 | 10.4113 | -74.4057 | 2020-07-25 04:47:39 | Magdalena, Colombia | ||
2020-07-25 | Colombia | Magdalena | 4927 | 311 | 2428 | 2188 | 10.4113 | -74.4057 | 2020-07-26 04:35:00 | Magdalena, Colombia | ||
2020-07-26 | Colombia | Magdalena | 4927 | 311 | 2428 | 2188 | 10.4113 | -74.4057 | 2020-07-27 04:35:02 | Magdalena, Colombia | ||
2020-07-27 | Colombia | Magdalena | 5397 | 320 | 2746 | 2331 | 10.4113 | -74.4057 | 2020-07-28 04:58:43 | Magdalena, Colombia | ||
2020-07-28 | Colombia | Magdalena | 5645 | 327 | 2966 | 2352 | 10.4113 | -74.4057 | 2020-07-29 04:35:11 | Magdalena, Colombia | ||
2020-07-29 | Colombia | Magdalena | 5806 | 338 | 3154 | 2314 | 10.4113 | -74.4057 | 2020-07-30 04:35:05 | Magdalena, Colombia | ||
2020-07-30 | Colombia | Magdalena | 6059 | 350 | 3248 | 2461 | 10.4113 | -74.4057 | 2020-07-31 04:35:18 | Magdalena, Colombia | ||
2020-07-31 | Colombia | Magdalena | 6138 | 363 | 3364 | 2411 | 10.4113 | -74.4057 | 2020-08-01 04:36:27 | Magdalena, Colombia | ||
2020-08-01 | Colombia | Magdalena | 6531 | 368 | 3554 | 2609 | 10.4113 | -74.4057 | 2020-08-02 04:34:47 | Magdalena, Colombia | ||
2020-08-02 | Colombia | Magdalena | 6749 | 374 | 3718 | 2657 | 10.4113 | -74.4057 | 2020-08-03 04:34:35 | Magdalena, Colombia | ||
2020-08-03 | Colombia | Magdalena | 7063 | 376 | 3789 | 2898 | 10.4113 | -74.4057 | 2020-08-04 04:41:59 | Magdalena, Colombia | ||
2020-08-04 | Colombia | Magdalena | 7200 | 391 | 3946 | 2863 | 10.4113 | -74.4057 | 2020-08-05 04:34:43 | Magdalena, Colombia | ||
2020-08-05 | Colombia | Magdalena | 7549 | 395 | 4048 | 3106 | 10.4113 | -74.4057 | 2020-08-06 04:35:02 | Magdalena, Colombia | ||
2020-08-06 | Colombia | Magdalena | 7731 | 411 | 4368 | 2952 | 10.4113 | -74.4057 | 2020-08-07 04:35:11 | Magdalena, Colombia | ||
2020-08-07 | Colombia | Magdalena | 7973 | 421 | 4487 | 3065 | 10.4113 | -74.4057 | 2020-08-08 04:34:53 | Magdalena, Colombia | ||
2020-08-08 | Colombia | Magdalena | 8144 | 427 | 4639 | 3078 | 10.4113 | -74.4057 | 2020-08-09 04:34:54 | Magdalena, Colombia | ||
2020-08-09 | Colombia | Magdalena | 8260 | 433 | 4818 | 3009 | 10.4113 | -74.4057 | 2020-08-10 04:34:55 | Magdalena, Colombia | ||
2020-08-10 | Colombia | Magdalena | 8547 | 438 | 5056 | 3053 | 10.4113 | -74.4057 | 2020-08-11 04:35:08 | Magdalena, Colombia | ||
2020-08-11 | Colombia | Magdalena | 8832 | 445 | 5160 | 3227 | 10.4113 | -74.4057 | 2020-08-12 04:27:29 | Magdalena, Colombia | ||
2020-08-12 | Colombia | Magdalena | 9117 | 458 | 5278 | 3381 | 10.4113 | -74.4057 | 2020-08-13 04:29:15 | Magdalena, Colombia | ||
2020-08-13 | Colombia | Magdalena | 9443 | 466 | 5410 | 3567 | 10.4113 | -74.4057 | 2020-08-14 04:51:19 | Magdalena, Colombia | ||
2020-08-14 | Colombia | Magdalena | 9725 | 479 | 5686 | 3560 | 10.4113 | -74.4057 | 2020-08-15 04:27:31 | Magdalena, Colombia | ||
2020-08-15 | Colombia | Magdalena | 9915 | 498 | 6037 | 3380 | 10.4113 | -74.4057 | 2020-08-16 04:27:42 | Magdalena, Colombia | ||
2020-08-16 | Colombia | Magdalena | 10179 | 505 | 6329 | 3345 | 10.4113 | -74.4057 | 2020-08-17 04:27:20 | Magdalena, Colombia | ||
2020-08-17 | Colombia | Magdalena | 10305 | 522 | 6578 | 3205 | 10.4113 | -74.4057 | 2020-08-18 04:27:56 | Magdalena, Colombia | ||
2020-08-18 | Colombia | Magdalena | 10549 | 529 | 6698 | 3322 | 10.4113 | -74.4057 | 2020-08-19 04:27:00 | Magdalena, Colombia | ||
2020-08-19 | Colombia | Magdalena | 10666 | 554 | 7021 | 3091 | 10.4113 | -74.4057 | 2020-08-20 04:27:43 | Magdalena, Colombia | ||
2020-08-20 | Colombia | Magdalena | 10815 | 558 | 7313 | 2944 | 10.4113 | -74.4057 | 2020-08-21 04:27:41 | Magdalena, Colombia | ||
2020-08-21 | Colombia | Magdalena | 10996 | 572 | 7547 | 2877 | 10.4113 | -74.4057 | 2020-08-22 04:27:49 | Magdalena, Colombia | ||
2020-08-22 | Colombia | Magdalena | 10996 | 572 | 7547 | 2877 | 10.4113 | -74.4057 | 2020-08-23 04:27:48 | Magdalena, Colombia | ||
2020-08-23 | Colombia | Magdalena | 11225 | 596 | 8034 | 2595 | 10.4113 | -74.4057 | 2020-08-24 04:27:56 | Magdalena, Colombia | ||
2020-08-24 | Colombia | Magdalena | 11444 | 603 | 8244 | 2597 | 10.4113 | -74.4057 | 2020-08-25 04:28:02 | Magdalena, Colombia | ||
2020-08-25 | Colombia | Magdalena | 11624 | 622 | 8544 | 2458 | 10.4113 | -74.4057 | 2020-08-26 04:28:11 | Magdalena, Colombia | ||
2020-08-26 | Colombia | Magdalena | 11707 | 626 | 8773 | 2308 | 10.4113 | -74.4057 | 2020-08-27 04:28:15 | Magdalena, Colombia | ||
2020-08-27 | Colombia | Magdalena | 11832 | 633 | 8883 | 2316 | 10.4113 | -74.4057 | 2020-08-28 04:28:11 | Magdalena, Colombia | ||
2020-08-28 | Colombia | Magdalena | 11942 | 654 | 9066 | 2222 | 10.4113 | -74.4057 | 2020-08-29 04:28:19 | Magdalena, Colombia | ||
2020-08-29 | Colombia | Magdalena | 12109 | 666 | 9323 | 2120 | 10.4113 | -74.4057 | 2020-08-30 04:28:22 | Magdalena, Colombia | ||
2020-08-30 | Colombia | Magdalena | 12289 | 677 | 9528 | 2084 | 10.4113 | -74.4057 | 2020-08-31 04:28:27 | Magdalena, Colombia | ||
2020-08-31 | Colombia | Magdalena | 12460 | 682 | 9643 | 2135 | 10.4113 | -74.4057 | 2020-09-01 04:28:31 | Magdalena, Colombia | ||
2020-09-01 | Colombia | Magdalena | 12529 | 690 | 9870 | 1969 | 10.4113 | -74.4057 | 2020-09-02 04:28:25 | Magdalena, Colombia | ||
2020-09-02 | Colombia | Magdalena | 12649 | 695 | 9999 | 1955 | 10.4113 | -74.4057 | 2020-09-03 04:28:22 | Magdalena, Colombia | ||
2020-09-03 | Colombia | Magdalena | 12817 | 700 | 10209 | 1908 | 10.4113 | -74.4057 | 2020-09-04 04:28:26 | Magdalena, Colombia | ||
2020-09-04 | Colombia | Magdalena | 12817 | 700 | 10209 | 1908 | 10.4113 | -74.4057 | 2020-09-05 04:28:19 | Magdalena, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;