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 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-08-17 | Colombia | Sucre | 8797 | 422 | 6005 | 2370 | 8.814 | -74.7233 | 2020-08-18 04:27:56 | Sucre, Colombia | ||
2020-07-22 | Colombia | Sucre | 4726 | 258 | 1492 | 2976 | 8.814 | -74.7233 | 2020-07-23 05:15:04 | Sucre, Colombia | ||
2020-12-12 | Colombia | Sucre | 16873 | 664 | 15768 | 441 | 8.814 | -74.7233 | 2020-12-13 05:27:20 | Sucre, Colombia | ||
2022-11-02 | Colombia | Sucre | 66917 | 1741 | 0 | 8.814 | -74.7233 | 2022-11-03 04:22:05 | Sucre, Colombia | |||
2022-09-30 | Colombia | Sucre | 66912 | 1740 | 0 | 8.814 | -74.7233 | 2022-10-01 04:23:01 | Sucre, Colombia | |||
2020-12-11 | Colombia | Sucre | 16858 | 661 | 15754 | 443 | 8.814 | -74.7233 | 2020-12-12 05:26:19 | Sucre, Colombia | ||
2020-11-12 | Colombia | Sucre | 15999 | 628 | 14962 | 409 | 8.814 | -74.7233 | 2020-11-13 05:25:30 | Sucre, Colombia | ||
2022-12-11 | Colombia | Sucre | 67008 | 1743 | 0 | 8.814 | -74.7233 | 2022-12-12 04:21:01 | Sucre, Colombia | |||
2022-03-27 | Colombia | Sucre | 65644 | 1714 | 0 | 8.814 | -74.7233 | 2022-03-28 04:20:33 | Sucre, Colombia | |||
2022-08-05 | Colombia | Sucre | 66829 | 1736 | 0 | 8.814 | -74.7233 | 2022-08-06 04:20:56 | Sucre, Colombia | |||
2020-07-07 | Colombia | Sucre | 1892 | 106 | 227 | 1559 | 8.814 | -74.7233 | 2020-07-08 05:33:48 | Sucre, Colombia | ||
2021-04-26 | Colombia | Sucre | 26943 | 958 | 25061 | 924 | 8.814 | -74.7233 | 2021-04-27 04:20:52 | Sucre, Colombia | ||
2020-11-05 | Colombia | Sucre | 15576 | 619 | 14499 | 458 | 8.814 | -74.7233 | 2020-11-06 05:24:55 | Sucre, Colombia | ||
2022-07-24 | Colombia | Sucre | 66646 | 1735 | 0 | 8.814 | -74.7233 | 2022-07-25 04:20:51 | Sucre, Colombia | |||
2022-07-22 | Colombia | Sucre | 66646 | 1735 | 0 | 8.814 | -74.7233 | 2022-07-23 04:20:53 | Sucre, Colombia | |||
2021-11-24 | Colombia | Sucre | 59626 | 1627 | 0 | 8.814 | -74.7233 | 2021-11-25 04:22:33 | Sucre, Colombia | |||
2021-01-19 | Colombia | Sucre | 18409 | 692 | 17258 | 459 | 8.814 | -74.7233 | 2021-01-20 05:21:54 | Sucre, Colombia | ||
2022-10-29 | Colombia | Sucre | 66917 | 1741 | 0 | 8.814 | -74.7233 | 2022-10-30 04:22:14 | Sucre, Colombia | |||
2022-03-08 | Colombia | Sucre | 65602 | 1712 | 0 | 8.814 | -74.7233 | 2022-03-09 04:20:59 | Sucre, Colombia | |||
2020-11-26 | Colombia | Sucre | 16405 | 642 | 15331 | 432 | 8.814 | -74.7233 | 2020-11-27 05:26:53 | Sucre, Colombia | ||
2020-12-21 | Colombia | Sucre | 17169 | 670 | 15979 | 520 | 8.814 | -74.7233 | 2020-12-22 05:22:33 | Sucre, Colombia | ||
2021-10-16 | Colombia | Sucre | 59154 | 1623 | 0 | 8.814 | -74.7233 | 2021-10-17 04:21:29 | Sucre, Colombia | |||
2022-06-25 | Colombia | Sucre | 66068 | 1717 | 0 | 8.814 | -74.7233 | 2022-06-26 04:21:02 | Sucre, Colombia | |||
2022-02-28 | Colombia | Sucre | 65569 | 1710 | 0 | 8.814 | -74.7233 | 2022-03-01 04:21:09 | Sucre, Colombia | |||
2022-06-14 | Colombia | Sucre | 65747 | 1715 | 0 | 8.814 | -74.7233 | 2022-06-15 04:20:54 | Sucre, Colombia | |||
2022-03-12 | Colombia | Sucre | 65604 | 1713 | 0 | 8.814 | -74.7233 | 2022-03-13 04:20:49 | Sucre, Colombia | |||
2021-04-25 | Colombia | Sucre | 26785 | 951 | 24944 | 890 | 8.814 | -74.7233 | 2021-04-26 04:21:04 | Sucre, Colombia | ||
2022-07-19 | Colombia | Sucre | 66551 | 1729 | 0 | 8.814 | -74.7233 | 2022-07-20 04:20:59 | Sucre, Colombia | |||
2022-09-09 | Colombia | Sucre | 66906 | 1738 | 0 | 8.814 | -74.7233 | 2022-09-10 04:21:10 | Sucre, Colombia | |||
2020-09-29 | Colombia | Sucre | 14072 | 577 | 13044 | 451 | 8.814 | -74.7233 | 2020-09-30 04:23:33 | Sucre, Colombia | ||
2022-06-01 | Colombia | Sucre | 65731 | 1715 | 0 | 8.814 | -74.7233 | 2022-06-02 05:20:39 | Sucre, Colombia | |||
2021-02-06 | Colombia | Sucre | 19668 | 727 | 18484 | 457 | 8.814 | -74.7233 | 2021-02-07 05:23:00 | Sucre, Colombia | ||
2022-02-01 | Colombia | Sucre | 64486 | 1655 | 0 | 8.814 | -74.7233 | 2022-02-02 04:21:09 | Sucre, Colombia | |||
2021-04-17 | Colombia | Sucre | 25069 | 914 | 23219 | 936 | 8.814 | -74.7233 | 2021-04-18 04:20:41 | Sucre, Colombia | ||
2021-10-04 | Colombia | Sucre | 59078 | 1623 | 0 | 8.814 | -74.7233 | 2021-10-05 04:21:27 | Sucre, Colombia | |||
2022-08-16 | Colombia | Sucre | 66841 | 1738 | 0 | 8.814 | -74.7233 | 2022-08-17 04:20:59 | Sucre, Colombia | |||
2021-03-01 | Colombia | Sucre | 20613 | 783 | 19317 | 513 | 8.814 | -74.7233 | 2021-03-02 05:23:30 | Sucre, Colombia | ||
2020-07-09 | Colombia | Sucre | 2139 | 125 | 285 | 1729 | 8.814 | -74.7233 | 2020-07-10 04:34:24 | 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-30 | Colombia | Sucre | 17438 | 677 | 16335 | 426 | 8.814 | -74.7233 | 2020-12-31 05:22:49 | Sucre, Colombia | ||
2021-11-21 | Colombia | Sucre | 59612 | 1627 | 0 | 8.814 | -74.7233 | 2021-11-22 04:22:20 | Sucre, Colombia | |||
2022-12-24 | Colombia | Sucre | 67067 | 1744 | 0 | 8.814 | -74.7233 | 2022-12-25 04:21:04 | Sucre, Colombia | |||
2022-11-04 | Colombia | Sucre | 66917 | 1741 | 0 | 8.814 | -74.7233 | 2022-11-05 04:21:52 | Sucre, Colombia | |||
2020-10-17 | Colombia | Sucre | 15002 | 600 | 13843 | 559 | 8.814 | -74.7233 | 2020-10-18 04:24:25 | Sucre, Colombia | ||
2021-12-06 | Colombia | Sucre | 59680 | 1627 | 0 | 8.814 | -74.7233 | 2021-12-07 04:22:34 | Sucre, Colombia | |||
2020-12-15 | Colombia | Sucre | 16939 | 665 | 15799 | 475 | 8.814 | -74.7233 | 2020-12-16 05:28:04 | Sucre, Colombia | ||
2020-10-07 | Colombia | Sucre | 14396 | 586 | 13218 | 592 | 8.814 | -74.7233 | 2020-10-08 04:23:56 | Sucre, Colombia | ||
2020-09-30 | Colombia | Sucre | 14081 | 582 | 13100 | 399 | 8.814 | -74.7233 | 2020-10-01 04:23:42 | Sucre, Colombia | ||
2022-11-06 | Colombia | Sucre | 66917 | 1741 | 0 | 8.814 | -74.7233 | 2022-11-07 04:21:26 | Sucre, Colombia | |||
2020-10-23 | Colombia | Sucre | 15131 | 607 | 14085 | 439 | 8.814 | -74.7233 | 2020-10-24 04:24:46 | Sucre, Colombia | ||
2022-02-23 | Colombia | Sucre | 65551 | 1708 | 0 | 8.814 | -74.7233 | 2022-02-24 04:21:14 | Sucre, Colombia | |||
2021-01-04 | Colombia | Sucre | 17603 | 681 | 16496 | 426 | 8.814 | -74.7233 | 2021-01-05 05:21:49 | Sucre, Colombia | ||
2022-07-28 | Colombia | Sucre | 66802 | 1735 | 0 | 8.814 | -74.7233 | 2022-07-29 04:20:45 | Sucre, Colombia | |||
2022-08-07 | Colombia | Sucre | 66829 | 1736 | 0 | 8.814 | -74.7233 | 2022-08-08 04:21:08 | Sucre, Colombia | |||
2022-12-28 | Colombia | Sucre | 67067 | 1744 | 0 | 8.814 | -74.7233 | 2022-12-29 04:21:01 | Sucre, Colombia | |||
2021-12-09 | Colombia | Sucre | 59693 | 1627 | 0 | 8.814 | -74.7233 | 2021-12-10 04:22:28 | Sucre, Colombia | |||
2021-05-14 | Colombia | Sucre | 30946 | 1061 | 28923 | 962 | 8.814 | -74.7233 | 2021-05-15 04:20:58 | Sucre, Colombia | ||
2022-08-09 | Colombia | Sucre | 66829 | 1736 | 0 | 8.814 | -74.7233 | 2022-08-10 04:20:57 | Sucre, Colombia | |||
2021-03-03 | Colombia | Sucre | 20668 | 784 | 19460 | 424 | 8.814 | -74.7233 | 2021-03-04 05:24:24 | Sucre, Colombia | ||
2021-01-20 | Colombia | Sucre | 18468 | 693 | 17300 | 475 | 8.814 | -74.7233 | 2021-01-21 05:22:01 | Sucre, Colombia | ||
2022-08-03 | Colombia | Sucre | 66802 | 1736 | 0 | 8.814 | -74.7233 | 2022-08-04 04:20:58 | Sucre, Colombia | |||
2020-09-02 | Colombia | Sucre | 11939 | 503 | 9600 | 1836 | 8.814 | -74.7233 | 2020-09-03 04:28:22 | Sucre, Colombia | ||
2022-05-21 | Colombia | Sucre | 65726 | 1715 | 0 | 8.814 | -74.7233 | 2022-05-22 04:20:52 | Sucre, Colombia | |||
2022-01-11 | Colombia | Sucre | 60558 | 1629 | 0 | 8.814 | -74.7233 | 2022-01-12 04:21:44 | Sucre, Colombia | |||
2021-08-06 | Colombia | Sucre | 57967 | 1572 | 0 | 8.814 | -74.7233 | 2021-08-07 04:21:30 | Sucre, Colombia | |||
2020-09-17 | Colombia | Sucre | 13417 | 549 | 11898 | 970 | 8.814 | -74.7233 | 2020-09-18 05:05:00 | Sucre, Colombia | ||
2021-06-18 | Colombia | Sucre | 42914 | 1278 | 40017 | 1619 | 8.814 | -74.7233 | 2021-06-19 04:22:33 | Sucre, Colombia | ||
2020-06-26 | Colombia | Sucre | 847 | 31 | 65 | 751 | 8.814 | -74.7233 | 2020-06-27 04:33:35 | Sucre, Colombia | ||
2021-01-01 | Colombia | Sucre | 17477 | 679 | 16392 | 406 | 8.814 | -74.7233 | 2021-01-02 05:22:33 | Sucre, Colombia | ||
2022-01-23 | Colombia | Sucre | 63031 | 1636 | 0 | 8.814 | -74.7233 | 2022-01-24 04:21:12 | Sucre, Colombia | |||
2021-12-01 | Colombia | Sucre | 59652 | 1627 | 0 | 8.814 | -74.7233 | 2021-12-02 04:22:37 | Sucre, Colombia | |||
2022-12-12 | Colombia | Sucre | 67008 | 1743 | 0 | 8.814 | -74.7233 | 2022-12-13 04:21:01 | Sucre, Colombia | |||
2021-02-18 | Colombia | Sucre | 20163 | 757 | 19039 | 367 | 8.814 | -74.7233 | 2021-02-19 05:24:16 | Sucre, Colombia | ||
2022-04-29 | Colombia | Sucre | 65701 | 1715 | 0 | 8.814 | -74.7233 | 2022-04-30 04:21:05 | Sucre, Colombia | |||
2022-08-18 | Colombia | Sucre | 66854 | 1738 | 0 | 8.814 | -74.7233 | 2022-08-19 04:20:54 | Sucre, Colombia | |||
2021-07-04 | Colombia | Sucre | 50864 | 1412 | 47061 | 2391 | 8.814 | -74.7233 | 2021-07-05 04:21:28 | Sucre, Colombia | ||
2022-05-20 | Colombia | Sucre | 65726 | 1715 | 0 | 8.814 | -74.7233 | 2022-05-21 04:20:58 | Sucre, Colombia | |||
2020-09-10 | Colombia | Sucre | 12824 | 538 | 11324 | 962 | 8.814 | -74.7233 | 2020-09-11 04:46:23 | Sucre, Colombia | ||
2020-10-22 | Colombia | Sucre | 15205 | 606 | 14125 | 474 | 8.814 | -74.7233 | 2020-10-23 04:24:46 | Sucre, Colombia | ||
2022-05-18 | Colombia | Sucre | 65716 | 1715 | 0 | 8.814 | -74.7233 | 2022-05-19 04:20:54 | Sucre, Colombia | |||
2021-05-31 | Colombia | Sucre | 35992 | 1159 | 32606 | 2227 | 8.814 | -74.7233 | 2021-06-01 04:23:09 | Sucre, Colombia | ||
2020-06-17 | Colombia | Sucre | 272 | 12 | 16 | 244 | 8.814 | -74.7233 | 2020-06-18 04:33:18 | Sucre, Colombia | ||
2022-07-06 | Colombia | Sucre | 66292 | 1718 | 0 | 8.814 | -74.7233 | 2022-07-07 04:20:55 | Sucre, Colombia | |||
2021-03-22 | Colombia | Sucre | 21938 | 826 | 20591 | 521 | 8.814 | -74.7233 | 2021-03-23 05:26:18 | Sucre, Colombia | ||
2020-06-09 | Colombia | Sucre | 131 | 2 | 5 | 124 | 8.814 | -74.7233 | 2020-06-10 04:07:00 | Sucre, Colombia | ||
2022-07-11 | Colombia | Sucre | 66551 | 1718 | 0 | 8.814 | -74.7233 | 2022-07-12 04:20:51 | Sucre, Colombia | |||
2022-01-08 | Colombia | Sucre | 60232 | 1628 | 0 | 8.814 | -74.7233 | 2022-01-09 04:21:46 | Sucre, Colombia | |||
2021-03-27 | Colombia | Sucre | 22546 | 838 | 21036 | 672 | 8.814 | -74.7233 | 2021-03-28 05:28:10 | Sucre, Colombia | ||
2022-04-14 | Colombia | Sucre | 65682 | 1714 | 0 | 8.814 | -74.7233 | 2022-04-15 04:20:57 | Sucre, Colombia | |||
2022-01-24 | Colombia | Sucre | 63193 | 1636 | 0 | 8.814 | -74.7233 | 2022-01-25 04:21:05 | Sucre, Colombia | |||
2021-11-28 | Colombia | Sucre | 59642 | 1627 | 0 | 8.814 | -74.7233 | 2021-11-29 04:22:30 | Sucre, Colombia | |||
2021-09-27 | Colombia | Sucre | 58993 | 1620 | 0 | 8.814 | -74.7233 | 2021-09-28 04:21:28 | Sucre, Colombia | |||
2022-11-28 | Colombia | Sucre | 66944 | 1741 | 0 | 8.814 | -74.7233 | 2022-11-29 04:21:05 | Sucre, Colombia | |||
2020-09-08 | Colombia | Sucre | 12543 | 533 | 10895 | 1115 | 8.814 | -74.7233 | 2020-09-09 04:28:48 | Sucre, Colombia | ||
2022-08-23 | Colombia | Sucre | 66854 | 1738 | 0 | 8.814 | -74.7233 | 2022-08-24 04:20:46 | Sucre, Colombia | |||
2021-12-20 | Colombia | Sucre | 59735 | 1627 | 0 | 8.814 | -74.7233 | 2021-12-21 03:21:27 | Sucre, Colombia | |||
2021-12-18 | Colombia | Sucre | 59733 | 1627 | 0 | 8.814 | -74.7233 | 2021-12-19 04:21:11 | Sucre, Colombia | |||
2021-09-09 | Colombia | Sucre | 58836 | 1613 | 0 | 8.814 | -74.7233 | 2021-09-10 04:21:20 | Sucre, Colombia | |||
2020-06-05 | Colombia | Sucre | 81 | 0 | 5 | 76 | 8.814 | -74.7233 | 2020-06-06 02:33:00 | Sucre, Colombia | ||
2020-06-11 | Colombia | Sucre | 166 | 3 | 5 | 158 | 8.814 | -74.7233 | 2020-06-12 05:09:52 | Sucre, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;