daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Sucre" sorted by last_update
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-05 | Colombia | Sucre | 12181 | 521 | 9964 | 1696 | 8.814 | -74.7233 | 2020-09-06 04:28:33 | Sucre, Colombia | ||
2020-09-06 | Colombia | Sucre | 12492 | 533 | 10734 | 1225 | 8.814 | -74.7233 | 2020-09-07 04:28:30 | Sucre, Colombia | ||
2020-09-07 | Colombia | Sucre | 12492 | 533 | 10734 | 1225 | 8.814 | -74.7233 | 2020-09-08 04:28:25 | Sucre, Colombia | ||
2020-09-08 | Colombia | Sucre | 12543 | 533 | 10895 | 1115 | 8.814 | -74.7233 | 2020-09-09 04:28:48 | Sucre, Colombia | ||
2020-09-09 | Colombia | Sucre | 12797 | 537 | 11136 | 1124 | 8.814 | -74.7233 | 2020-09-10 04:29:01 | Sucre, Colombia | ||
2020-09-10 | Colombia | Sucre | 12824 | 538 | 11324 | 962 | 8.814 | -74.7233 | 2020-09-11 04:46:23 | Sucre, Colombia | ||
2020-09-11 | Colombia | Sucre | 12985 | 540 | 11479 | 966 | 8.814 | -74.7233 | 2020-09-12 04:25:05 | Sucre, Colombia | ||
2020-09-12 | Colombia | Sucre | 13078 | 542 | 11620 | 916 | 8.814 | -74.7233 | 2020-09-13 04:30:52 | Sucre, Colombia | ||
2020-09-13 | Colombia | Sucre | 13217 | 543 | 11727 | 947 | 8.814 | -74.7233 | 2020-09-14 04:26:00 | Sucre, Colombia | ||
2020-09-14 | Colombia | Sucre | 13242 | 544 | 11789 | 909 | 8.814 | -74.7233 | 2020-09-15 03:22:50 | Sucre, Colombia | ||
2020-09-15 | Colombia | Sucre | 13293 | 546 | 11801 | 946 | 8.814 | -74.7233 | 2020-09-16 04:22:53 | Sucre, Colombia | ||
2020-09-16 | Colombia | Sucre | 13349 | 548 | 11819 | 982 | 8.814 | -74.7233 | 2020-09-17 04:22:00 | Sucre, Colombia | ||
2020-09-17 | Colombia | Sucre | 13417 | 549 | 11898 | 970 | 8.814 | -74.7233 | 2020-09-18 05:05:00 | Sucre, Colombia | ||
2020-09-18 | Colombia | Sucre | 13444 | 549 | 11898 | 997 | 8.814 | -74.7233 | 2020-09-19 04:22:00 | Sucre, Colombia | ||
2020-09-19 | Colombia | Sucre | 13512 | 559 | 11964 | 989 | 8.814 | -74.7233 | 2020-09-20 04:22:00 | Sucre, Colombia | ||
2020-09-20 | Colombia | Sucre | 13545 | 565 | 12140 | 840 | 8.814 | -74.7233 | 2020-09-21 04:23:00 | Sucre, Colombia | ||
2020-09-21 | Colombia | Sucre | 13619 | 565 | 12254 | 800 | 8.814 | -74.7233 | 2020-09-22 04:23:00 | Sucre, Colombia | ||
2020-09-22 | Colombia | Sucre | 13767 | 565 | 12254 | 948 | 8.814 | -74.7233 | 2020-09-23 04:23:00 | Sucre, Colombia | ||
2020-09-23 | Colombia | Sucre | 13785 | 570 | 12468 | 747 | 8.814 | -74.7233 | 2020-09-24 04:23:00 | Sucre, Colombia | ||
2020-09-24 | Colombia | Sucre | 13867 | 570 | 12566 | 731 | 8.814 | -74.7233 | 2020-09-25 04:23:00 | Sucre, Colombia | ||
2020-09-25 | Colombia | Sucre | 13907 | 570 | 12658 | 679 | 8.814 | -74.7233 | 2020-09-26 04:23:00 | Sucre, Colombia | ||
2020-09-26 | Colombia | Sucre | 13972 | 572 | 12748 | 652 | 8.814 | -74.7233 | 2020-09-27 04:23:00 | Sucre, Colombia | ||
2020-09-27 | Colombia | Sucre | 13999 | 575 | 12864 | 560 | 8.814 | -74.7233 | 2020-09-28 04:23:00 | Sucre, Colombia | ||
2020-09-28 | Colombia | Sucre | 14011 | 575 | 12976 | 460 | 8.814 | -74.7233 | 2020-09-29 04:23:42 | Sucre, Colombia | ||
2020-09-29 | Colombia | Sucre | 14072 | 577 | 13044 | 451 | 8.814 | -74.7233 | 2020-09-30 04:23:33 | Sucre, Colombia | ||
2020-09-30 | Colombia | Sucre | 14081 | 582 | 13100 | 399 | 8.814 | -74.7233 | 2020-10-01 04:23:42 | Sucre, Colombia | ||
2020-10-01 | Colombia | Sucre | 14115 | 582 | 13151 | 382 | 8.814 | -74.7233 | 2020-10-02 04:23:51 | Sucre, Colombia | ||
2020-10-02 | Colombia | Sucre | 14127 | 584 | 13168 | 375 | 8.814 | -74.7233 | 2020-10-03 04:23:40 | Sucre, Colombia | ||
2020-10-03 | Colombia | Sucre | 14158 | 584 | 13185 | 389 | 8.814 | -74.7233 | 2020-10-04 04:23:44 | Sucre, Colombia | ||
2020-10-04 | Colombia | Sucre | 14197 | 584 | 13201 | 412 | 8.814 | -74.7233 | 2020-10-05 04:23:33 | Sucre, Colombia | ||
2020-10-05 | Colombia | Sucre | 14256 | 584 | 13201 | 471 | 8.814 | -74.7233 | 2020-10-06 04:23:33 | Sucre, Colombia | ||
2020-10-06 | Colombia | Sucre | 14272 | 586 | 13211 | 475 | 8.814 | -74.7233 | 2020-10-07 04:23:40 | Sucre, Colombia | ||
2020-10-07 | Colombia | Sucre | 14396 | 586 | 13218 | 592 | 8.814 | -74.7233 | 2020-10-08 04:23:56 | Sucre, Colombia | ||
2020-10-08 | Colombia | Sucre | 14484 | 586 | 13218 | 680 | 8.814 | -74.7233 | 2020-10-09 04:23:59 | Sucre, Colombia | ||
2020-10-09 | Colombia | Sucre | 14531 | 590 | 13267 | 674 | 8.814 | -74.7233 | 2020-10-10 04:23:57 | Sucre, Colombia | ||
2020-10-10 | Colombia | Sucre | 14571 | 593 | 13274 | 704 | 8.814 | -74.7233 | 2020-10-11 04:23:46 | Sucre, Colombia | ||
2020-10-11 | Colombia | Sucre | 14721 | 593 | 13274 | 854 | 8.814 | -74.7233 | 2020-10-12 04:23:45 | Sucre, Colombia | ||
2020-10-12 | Colombia | Sucre | 14750 | 596 | 13492 | 662 | 8.814 | -74.7233 | 2020-10-13 04:24:02 | Sucre, Colombia | ||
2020-10-13 | Colombia | Sucre | 14762 | 597 | 13531 | 634 | 8.814 | -74.7233 | 2020-10-14 04:24:05 | Sucre, Colombia | ||
2020-10-14 | Colombia | Sucre | 14813 | 597 | 13642 | 574 | 8.814 | -74.7233 | 2020-10-15 04:24:28 | Sucre, Colombia | ||
2020-10-15 | Colombia | Sucre | 14887 | 599 | 13714 | 574 | 8.814 | -74.7233 | 2020-10-16 04:24:01 | Sucre, Colombia | ||
2020-10-16 | Colombia | Sucre | 14952 | 599 | 13714 | 639 | 8.814 | -74.7233 | 2020-10-17 04:24:12 | Sucre, Colombia | ||
2020-10-17 | Colombia | Sucre | 15002 | 600 | 13843 | 559 | 8.814 | -74.7233 | 2020-10-18 04:24:25 | Sucre, Colombia | ||
2020-10-18 | Colombia | Sucre | 15071 | 602 | 13926 | 543 | 8.814 | -74.7233 | 2020-10-19 04:24:16 | Sucre, Colombia | ||
2020-10-19 | Colombia | Sucre | 15121 | 604 | 14011 | 506 | 8.814 | -74.7233 | 2020-10-20 04:24:22 | Sucre, Colombia | ||
2020-10-20 | Colombia | Sucre | 15188 | 606 | 14071 | 511 | 8.814 | -74.7233 | 2020-10-21 04:24:14 | Sucre, Colombia | ||
2020-10-21 | Colombia | Sucre | 15205 | 606 | 14125 | 474 | 8.814 | -74.7233 | 2020-10-22 04:24:27 | Sucre, Colombia | ||
2020-10-22 | Colombia | Sucre | 15205 | 606 | 14125 | 474 | 8.814 | -74.7233 | 2020-10-23 04:24:46 | Sucre, Colombia | ||
2020-10-23 | Colombia | Sucre | 15131 | 607 | 14085 | 439 | 8.814 | -74.7233 | 2020-10-24 04:24:46 | Sucre, Colombia | ||
2020-10-24 | Colombia | Sucre | 15188 | 607 | 14114 | 467 | 8.814 | -74.7233 | 2020-10-25 04:24:36 | Sucre, Colombia | ||
2020-10-25 | Colombia | Sucre | 15230 | 608 | 14148 | 474 | 8.814 | -74.7233 | 2020-10-26 04:25:02 | Sucre, Colombia | ||
2020-10-26 | Colombia | Sucre | 15295 | 609 | 14177 | 509 | 8.814 | -74.7233 | 2020-10-27 04:24:45 | Sucre, Colombia | ||
2020-10-27 | Colombia | Sucre | 15319 | 613 | 14232 | 474 | 8.814 | -74.7233 | 2020-10-28 04:24:39 | Sucre, Colombia | ||
2020-10-28 | Colombia | Sucre | 15324 | 614 | 14261 | 449 | 8.814 | -74.7233 | 2020-10-29 04:24:49 | Sucre, Colombia | ||
2020-10-29 | Colombia | Sucre | 15354 | 614 | 14261 | 479 | 8.814 | -74.7233 | 2020-10-30 04:24:49 | Sucre, Colombia | ||
2020-10-30 | Colombia | Sucre | 15354 | 614 | 14292 | 448 | 8.814 | -74.7233 | 2020-10-31 04:24:44 | Sucre, Colombia | ||
2020-10-31 | Colombia | Sucre | 15433 | 614 | 14352 | 467 | 8.814 | -74.7233 | 2020-11-01 04:36:19 | Sucre, Colombia | ||
2020-11-01 | Colombia | Sucre | 15484 | 615 | 14395 | 474 | 8.814 | -74.7233 | 2020-11-02 05:25:04 | Sucre, Colombia | ||
2020-11-02 | Colombia | Sucre | 18017 | 616 | 14415 | 2986 | 8.814 | -74.7233 | 2020-11-03 06:00:16 | Sucre, Colombia | ||
2020-11-03 | Colombia | Sucre | 15530 | 618 | 14428 | 484 | 8.814 | -74.7233 | 2020-11-04 05:25:09 | Sucre, Colombia | ||
2020-11-04 | Colombia | Sucre | 15559 | 619 | 14479 | 461 | 8.814 | -74.7233 | 2020-11-05 06:05:03 | Sucre, Colombia | ||
2020-11-05 | Colombia | Sucre | 15576 | 619 | 14499 | 458 | 8.814 | -74.7233 | 2020-11-06 05:24:55 | Sucre, Colombia | ||
2020-11-06 | Colombia | Sucre | 15828 | 619 | 14535 | 674 | 8.814 | -74.7233 | 2020-11-07 05:24:52 | Sucre, Colombia | ||
2020-11-07 | Colombia | Sucre | 15853 | 619 | 14561 | 673 | 8.814 | -74.7233 | 2020-11-08 05:24:56 | Sucre, Colombia | ||
2020-11-08 | Colombia | Sucre | 15869 | 621 | 14801 | 447 | 8.814 | -74.7233 | 2020-11-09 05:25:45 | Sucre, Colombia | ||
2020-11-09 | Colombia | Sucre | 15925 | 624 | 14842 | 459 | 8.814 | -74.7233 | 2020-11-10 05:40:07 | Sucre, Colombia | ||
2020-11-10 | Colombia | Sucre | 15961 | 624 | 14884 | 453 | 8.814 | -74.7233 | 2020-11-11 05:25:30 | Sucre, Colombia | ||
2020-11-11 | Colombia | Sucre | 15975 | 626 | 14907 | 442 | 8.814 | -74.7233 | 2020-11-12 05:25:55 | Sucre, Colombia | ||
2020-11-12 | Colombia | Sucre | 15999 | 628 | 14962 | 409 | 8.814 | -74.7233 | 2020-11-13 05:25:30 | Sucre, Colombia | ||
2020-11-13 | Colombia | Sucre | 16039 | 628 | 14962 | 449 | 8.814 | -74.7233 | 2020-11-14 05:25:37 | Sucre, Colombia | ||
2020-11-14 | Colombia | Sucre | 16073 | 629 | 14998 | 446 | 8.814 | -74.7233 | 2020-11-15 05:26:53 | Sucre, Colombia | ||
2020-11-15 | Colombia | Sucre | 16103 | 632 | 15055 | 416 | 8.814 | -74.7233 | 2020-11-16 05:25:57 | Sucre, Colombia | ||
2020-11-16 | Colombia | Sucre | 16123 | 632 | 15084 | 407 | 8.814 | -74.7233 | 2020-11-17 05:25:54 | Sucre, Colombia | ||
2020-11-17 | Colombia | Sucre | 16143 | 632 | 15103 | 408 | 8.814 | -74.7233 | 2020-11-18 05:40:31 | Sucre, Colombia | ||
2020-11-18 | Colombia | Sucre | 16154 | 632 | 15123 | 399 | 8.814 | -74.7233 | 2020-11-19 05:25:23 | Sucre, Colombia | ||
2020-11-19 | Colombia | Sucre | 16168 | 634 | 15151 | 383 | 8.814 | -74.7233 | 2020-11-20 05:26:28 | Sucre, Colombia | ||
2020-11-20 | Colombia | Sucre | 16184 | 635 | 15172 | 377 | 8.814 | -74.7233 | 2020-11-21 05:25:51 | Sucre, Colombia | ||
2020-11-21 | Colombia | Sucre | 16262 | 635 | 15184 | 443 | 8.814 | -74.7233 | 2020-11-22 05:25:45 | Sucre, Colombia | ||
2020-11-22 | Colombia | Sucre | 16276 | 635 | 15255 | 386 | 8.814 | -74.7233 | 2020-11-23 05:25:26 | Sucre, Colombia | ||
2020-11-23 | Colombia | Sucre | 16305 | 637 | 15274 | 394 | 8.814 | -74.7233 | 2020-11-24 05:27:31 | Sucre, Colombia | ||
2020-11-24 | Colombia | Sucre | 16355 | 638 | 15294 | 423 | 8.814 | -74.7233 | 2020-11-25 05:27:20 | Sucre, Colombia | ||
2020-11-25 | Colombia | Sucre | 16369 | 642 | 15309 | 418 | 8.814 | -74.7233 | 2020-11-26 05:27:44 | Sucre, Colombia | ||
2020-11-26 | Colombia | Sucre | 16405 | 642 | 15331 | 432 | 8.814 | -74.7233 | 2020-11-27 05:26:53 | Sucre, Colombia | ||
2020-11-27 | Colombia | Sucre | 16413 | 643 | 15347 | 423 | 8.814 | -74.7233 | 2020-11-28 05:25:50 | Sucre, Colombia | ||
2020-11-28 | Colombia | Sucre | 16438 | 645 | 15368 | 425 | 8.814 | -74.7233 | 2020-11-29 05:25:55 | Sucre, Colombia | ||
2020-11-29 | Colombia | Sucre | 16465 | 646 | 15392 | 427 | 8.814 | -74.7233 | 2020-11-30 05:26:13 | Sucre, Colombia | ||
2020-11-30 | Colombia | Sucre | 16511 | 650 | 15401 | 460 | 8.814 | -74.7233 | 2020-12-01 05:26:18 | Sucre, Colombia | ||
2020-12-01 | Colombia | Sucre | 16558 | 650 | 15440 | 468 | 8.814 | -74.7233 | 2020-12-02 05:27:41 | Sucre, Colombia | ||
2020-12-02 | Colombia | Sucre | 16579 | 651 | 15481 | 447 | 8.814 | -74.7233 | 2020-12-03 05:28:22 | Sucre, Colombia | ||
2020-12-03 | Colombia | Sucre | 16653 | 653 | 15500 | 500 | 8.814 | -74.7233 | 2020-12-04 05:27:27 | Sucre, Colombia | ||
2020-12-04 | Colombia | Sucre | 16682 | 656 | 15571 | 455 | 8.814 | -74.7233 | 2020-12-05 05:27:36 | Sucre, Colombia | ||
2020-12-05 | Colombia | Sucre | 16714 | 657 | 15596 | 461 | 8.814 | -74.7233 | 2020-12-06 05:26:18 | Sucre, Colombia | ||
2020-12-06 | Colombia | Sucre | 16741 | 657 | 15627 | 457 | 8.814 | -74.7233 | 2020-12-07 05:26:14 | Sucre, Colombia | ||
2020-12-07 | Colombia | Sucre | 16769 | 658 | 15646 | 465 | 8.814 | -74.7233 | 2020-12-08 05:27:42 | Sucre, Colombia | ||
2020-12-08 | Colombia | Sucre | 16788 | 659 | 15688 | 441 | 8.814 | -74.7233 | 2020-12-09 05:28:01 | Sucre, Colombia | ||
2020-12-09 | Colombia | Sucre | 16814 | 661 | 15705 | 448 | 8.814 | -74.7233 | 2020-12-10 05:26:19 | Sucre, Colombia | ||
2020-12-10 | Colombia | Sucre | 16829 | 661 | 15735 | 433 | 8.814 | -74.7233 | 2020-12-11 05:26:59 | Sucre, Colombia | ||
2020-12-11 | Colombia | Sucre | 16858 | 661 | 15754 | 443 | 8.814 | -74.7233 | 2020-12-12 05:26:19 | Sucre, Colombia | ||
2020-12-12 | Colombia | Sucre | 16873 | 664 | 15768 | 441 | 8.814 | -74.7233 | 2020-12-13 05:27:20 | Sucre, Colombia | ||
2020-12-13 | Colombia | Sucre | 16898 | 665 | 15766 | 467 | 8.814 | -74.7233 | 2020-12-14 05:26:27 | Sucre, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;