johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32,189 rows where country_or_region = "Colombia" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Amazonas 946
- Antioquia 946
- Arauca 946
- Atlantico 946
- Bolivar 946
- Boyaca 946
- Caldas 946
- Capital District 946
- Caqueta 946
- Casanare 946
- Cauca 946
- Cesar 946
- Choco 946
- Cordoba 946
- Cundinamarca 946
- Huila 946
- La Guajira 946
- Magdalena 946
- Meta 946
- Narino 946
- Norte de Santander 946
- Putumayo 946
- Quindio 946
- Risaralda 946
- San Andres y Providencia 946
- Santander 946
- Sucre 946
- Tolima 946
- Valle del Cauca 946
- Vaupes 946
- …
country_or_region 1
- Colombia · 32,089 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
487467 | 487467 | 2022-11-25 | Colombia | Unknown | 0 | 286 | 0 | 2022-11-26 04:21:11 | Unknown, Colombia | |||||
491482 | 491482 | 2021-10-14 | Colombia | Unknown | 0 | 296 | 0 | 2021-10-15 04:21:26 | Unknown, Colombia | |||||
495498 | 495498 | 2021-11-06 | Colombia | Unknown | 0 | 296 | 0 | 2021-11-07 04:21:53 | Unknown, Colombia | |||||
499515 | 499515 | 2022-04-02 | Colombia | Unknown | 0 | 300 | 0 | 2022-04-03 04:20:48 | Unknown, Colombia | |||||
503531 | 503531 | 2022-12-17 | Colombia | Unknown | 0 | 185 | 0 | 2022-12-18 04:21:03 | Unknown, Colombia | |||||
507546 | 507546 | 2021-08-14 | Colombia | Unknown | 0 | 296 | 0 | 2021-08-15 04:21:41 | Unknown, Colombia | |||||
511560 | 511560 | 2021-08-19 | Colombia | Unknown | 0 | 296 | 0 | 2021-08-20 04:21:33 | Unknown, Colombia | |||||
515575 | 515575 | 2022-10-15 | Colombia | Unknown | 0 | 300 | 0 | 2022-10-16 04:22:39 | Unknown, Colombia | |||||
522719 | 522719 | 2021-06-09 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-06-10 04:23:17 | Unknown, Colombia | ||||
530568 | 530568 | 2021-02-22 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-02-23 05:23:41 | Unknown, Colombia | ||||
534582 | 534582 | 2021-10-27 | Colombia | Unknown | 0 | 296 | 0 | 2021-10-28 04:22:08 | Unknown, Colombia | |||||
538599 | 538599 | 2022-10-26 | Colombia | Unknown | 0 | 300 | 0 | 2022-10-27 04:22:01 | Unknown, Colombia | |||||
542615 | 542615 | 2022-12-15 | Colombia | Unknown | 0 | 185 | 0 | 2022-12-16 04:21:01 | Unknown, Colombia | |||||
550620 | 550620 | 2021-12-08 | Colombia | Unknown | 0 | 296 | 0 | 2021-12-09 04:22:49 | Unknown, Colombia | |||||
554636 | 554636 | 2022-01-16 | Colombia | Unknown | 0 | 296 | 0 | 2022-01-17 04:21:08 | Unknown, Colombia | |||||
558653 | 558653 | 2022-06-16 | Colombia | Unknown | 0 | 300 | 0 | 2022-06-17 04:20:56 | Unknown, Colombia | |||||
562829 | 562829 | 2021-06-22 | Colombia | Unknown | 0 | 0 | 1 | 0 | 2021-06-23 04:21:46 | Unknown, Colombia | ||||
566950 | 566950 | 2021-10-29 | Colombia | Unknown | 0 | 296 | 0 | 2021-10-30 04:22:03 | Unknown, Colombia | |||||
574679 | 574679 | 2022-02-25 | Colombia | Unknown | 0 | 298 | 0 | 2022-02-26 04:21:12 | Unknown, Colombia | |||||
578694 | 578694 | 2021-07-13 | Colombia | Unknown | 0 | 296 | 1 | 0 | 2021-07-14 04:21:35 | Unknown, Colombia | ||||
589490 | 589490 | 2021-08-08 | Colombia | Unknown | 0 | 296 | 0 | 2021-08-09 04:21:24 | Unknown, Colombia | |||||
593505 | 593505 | 2022-07-01 | Colombia | Unknown | 0 | 300 | 0 | 2022-07-02 04:21:16 | Unknown, Colombia | |||||
597520 | 597520 | 2021-10-19 | Colombia | Unknown | 0 | 320 | 0 | 2021-10-20 04:21:00 | Unknown, Colombia | |||||
601536 | 601536 | 2021-09-23 | Colombia | Unknown | 0 | 296 | 0 | 2021-09-24 04:21:44 | Unknown, Colombia | |||||
605551 | 605551 | 2021-04-09 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-10 04:20:59 | Unknown, Colombia | ||||
613550 | 613550 | 2021-02-08 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-02-09 05:23:30 | Unknown, Colombia | ||||
617709 | 617709 | 2022-11-05 | Colombia | Unknown | 0 | 313 | 0 | 2022-11-06 04:21:24 | Unknown, Colombia | |||||
621725 | 621725 | 2022-05-22 | Colombia | Unknown | 0 | 300 | 0 | 2022-05-26 04:20:50 | Unknown, Colombia | |||||
625740 | 625740 | 2021-07-10 | Colombia | Unknown | 0 | 567 | 28972 | 0 | 2021-07-11 04:21:43 | Unknown, Colombia | ||||
629755 | 629755 | 2022-07-12 | Colombia | Unknown | 0 | 300 | 0 | 2022-07-13 04:20:58 | Unknown, Colombia | |||||
633770 | 633770 | 2021-10-13 | Colombia | Unknown | 0 | 296 | 0 | 2021-10-14 04:21:29 | Unknown, Colombia | |||||
637786 | 637786 | 2021-03-31 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-01 04:27:05 | Unknown, Colombia | ||||
641800 | 641800 | 2021-09-07 | Colombia | Unknown | 0 | 296 | 0 | 2021-09-08 04:21:31 | Unknown, Colombia | |||||
645814 | 645814 | 2021-05-05 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-06 04:20:38 | Unknown, Colombia | ||||
649828 | 649828 | 2021-08-09 | Colombia | Unknown | 0 | 296 | 0 | 2021-08-10 04:21:27 | Unknown, Colombia | |||||
653842 | 653842 | 2021-10-22 | Colombia | Unknown | 0 | 296 | 0 | 2021-10-23 04:21:32 | Unknown, Colombia | |||||
658161 | 658161 | 2022-05-13 | Colombia | Unknown | 0 | 300 | 0 | 2022-05-14 04:20:48 | Unknown, Colombia | |||||
674162 | 674162 | 2022-07-30 | Colombia | Unknown | 0 | 300 | 0 | 2022-07-31 04:21:02 | Unknown, Colombia | |||||
678175 | 678175 | 2020-11-23 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-11-24 05:27:31 | Unknown, Colombia | ||||
682187 | 682187 | 2021-10-24 | Colombia | Unknown | 0 | 296 | 0 | 2021-10-25 04:22:31 | Unknown, Colombia | |||||
686203 | 686203 | 2021-11-13 | Colombia | Unknown | 0 | 296 | 0 | 2021-11-14 04:21:31 | Unknown, Colombia | |||||
690220 | 690220 | 2022-12-23 | Colombia | Unknown | 0 | 105 | 0 | 2022-12-24 04:21:02 | Unknown, Colombia | |||||
694236 | 694236 | 2022-03-17 | Colombia | Unknown | 0 | 300 | 0 | 2022-03-18 04:20:55 | Unknown, Colombia | |||||
698251 | 698251 | 2021-11-04 | Colombia | Unknown | 0 | 296 | 0 | 2021-11-05 04:21:54 | Unknown, Colombia | |||||
702267 | 702267 | 2021-03-16 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-03-17 05:25:07 | Unknown, Colombia | ||||
706281 | 706281 | 2021-09-29 | Colombia | Unknown | 0 | 296 | 0 | 2021-09-30 04:21:20 | Unknown, Colombia | |||||
710297 | 710297 | 2022-11-01 | Colombia | Unknown | 0 | 300 | 0 | 2022-11-02 04:22:09 | Unknown, Colombia | |||||
714312 | 714312 | 2021-11-12 | Colombia | Unknown | 0 | 296 | 0 | 2021-11-13 04:21:38 | Unknown, Colombia | |||||
718329 | 718329 | 2022-12-04 | Colombia | Unknown | 0 | 270 | 0 | 2022-12-05 04:20:58 | Unknown, Colombia | |||||
722344 | 722344 | 2021-11-20 | Colombia | Unknown | 0 | 337 | 0 | 2021-11-21 04:22:13 | Unknown, Colombia | |||||
726360 | 726360 | 2021-05-22 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-23 04:20:51 | Unknown, Colombia | ||||
730374 | 730374 | 2021-12-27 | Colombia | Unknown | 0 | 333 | 0 | 2021-12-28 04:21:47 | Unknown, Colombia | |||||
738164 | 738164 | 2020-12-02 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-12-03 05:28:22 | Unknown, Colombia | ||||
742176 | 742176 | 2021-02-20 | Colombia | Unknown | 0 | 142 | 0 | 0 | 2021-02-21 05:24:33 | Unknown, Colombia | ||||
746191 | 746191 | 2022-04-23 | Colombia | Unknown | 0 | 300 | 0 | 2022-04-24 04:20:56 | Unknown, Colombia | |||||
753964 | 753964 | 2020-08-01 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-17 22:34:48 | Unknown, Colombia | ||||
754165 | 754165 | 2020-10-28 | Colombia | Unknown | 0 | 0 | 0 | 2020-10-29 04:24:49 | Unknown, Colombia | |||||
758174 | 758174 | 2021-11-26 | Colombia | Unknown | 0 | 296 | 0 | 2021-11-27 04:22:45 | Unknown, Colombia | |||||
762177 | 762177 | 2020-10-18 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-10-19 04:24:16 | Unknown, Colombia | ||||
766183 | 766183 | 2020-12-29 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-12-30 05:22:34 | Unknown, Colombia | ||||
770195 | 770195 | 2021-10-23 | Colombia | Unknown | 0 | 296 | 0 | 2021-10-24 04:21:22 | Unknown, Colombia | |||||
774210 | 774210 | 2021-01-12 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-01-13 05:22:15 | Unknown, Colombia | ||||
778223 | 778223 | 2021-07-08 | Colombia | Unknown | 0 | 0 | 1 | 0 | 2021-07-09 04:21:21 | Unknown, Colombia | ||||
782237 | 782237 | 2021-12-13 | Colombia | Unknown | 0 | 296 | 0 | 2021-12-14 04:22:38 | Unknown, Colombia | |||||
786240 | 786240 | 2020-10-15 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-10-16 04:24:01 | Unknown, Colombia | ||||
790245 | 790245 | 2021-02-04 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-02-05 05:22:38 | Unknown, Colombia | ||||
794261 | 794261 | 2022-10-24 | Colombia | Unknown | 0 | 300 | 0 | 2022-10-25 04:21:53 | Unknown, Colombia | |||||
798276 | 798276 | 2021-12-22 | Colombia | Unknown | 0 | 296 | 0 | 2021-12-23 04:21:21 | Unknown, Colombia | |||||
809438 | 809438 | 2021-09-20 | Colombia | Unknown | 0 | 296 | 0 | 2021-09-21 04:21:26 | Unknown, Colombia | |||||
817430 | 817430 | 2020-10-09 | Colombia | Unknown | 0 | 164 | 2889 | 0 | 2020-10-10 04:23:57 | Unknown, Colombia | ||||
821433 | 821433 | 2020-11-19 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-11-20 05:26:28 | Unknown, Colombia | ||||
825445 | 825445 | 2021-06-06 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-06-07 04:22:51 | Unknown, Colombia | ||||
829459 | 829459 | 2021-07-09 | Colombia | Unknown | 0 | 0 | 27210 | 0 | 2021-07-10 04:21:25 | Unknown, Colombia | ||||
833474 | 833474 | 2022-12-02 | Colombia | Unknown | 0 | 270 | 0 | 2022-12-03 04:21:02 | Unknown, Colombia | |||||
845219 | 845219 | 2020-07-22 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-17 22:34:48 | Unknown, Colombia | ||||
845433 | 845433 | 2020-12-12 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-12-13 05:27:20 | Unknown, Colombia | ||||
849446 | 849446 | 2022-11-02 | Colombia | Unknown | 0 | 300 | 0 | 2022-11-03 04:22:05 | Unknown, Colombia | |||||
860540 | 860540 | 2020-12-11 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-12-12 05:26:19 | Unknown, Colombia | ||||
864421 | 864421 | 2020-01-23 | Colombia | 0 | 0 | 0 | 1/23/20 17:00 | |||||||
864633 | 864633 | 2020-11-12 | Colombia | Unknown | 0 | 0 | 1 | 0 | 2020-11-13 05:25:30 | Unknown, Colombia | ||||
868646 | 868646 | 2022-12-11 | Colombia | Unknown | 0 | 238 | 0 | 2022-12-12 04:21:01 | Unknown, Colombia | |||||
876111 | 876111 | 2022-03-27 | Colombia | Unknown | 0 | 300 | 0 | 2022-03-28 04:20:33 | Unknown, Colombia | |||||
880127 | 880127 | 2022-08-05 | Colombia | Unknown | 0 | 300 | 0 | 2022-08-06 04:20:56 | Unknown, Colombia | |||||
887553 | 887553 | 2020-07-07 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-08 05:33:48 | Unknown, Colombia | ||||
887982 | 887982 | 2021-04-26 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-27 04:20:52 | Unknown, Colombia | ||||
891983 | 891983 | 2020-11-05 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-11-06 05:24:55 | Unknown, Colombia | ||||
904025 | 904025 | 2021-11-24 | Colombia | Unknown | 0 | 296 | 0 | 2021-11-25 04:22:33 | Unknown, Colombia | |||||
908040 | 908040 | 2021-01-19 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-01-20 05:21:54 | Unknown, Colombia | ||||
912055 | 912055 | 2022-10-29 | Colombia | Unknown | 0 | 300 | 0 | 2022-10-30 04:22:14 | Unknown, Colombia | |||||
919531 | 919531 | 2022-03-08 | Colombia | Unknown | 0 | 300 | 0 | 2022-03-09 04:20:59 | Unknown, Colombia | |||||
923545 | 923545 | 2020-11-26 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-11-27 05:26:53 | Unknown, Colombia | ||||
927556 | 927556 | 2020-12-21 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-12-22 05:22:33 | Unknown, Colombia | ||||
934647 | 934647 | 2021-10-16 | Colombia | Unknown | 0 | 296 | 0 | 2021-10-17 04:21:29 | Unknown, Colombia | |||||
938664 | 938664 | 2022-06-25 | Colombia | Unknown | 0 | 300 | 0 | 2022-06-26 04:21:02 | Unknown, Colombia | |||||
942680 | 942680 | 2022-02-28 | Colombia | Unknown | 0 | 298 | 0 | 2022-03-01 04:21:09 | Unknown, Colombia | |||||
954727 | 954727 | 2021-04-25 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-26 04:21:04 | Unknown, Colombia | ||||
962758 | 962758 | 2022-09-09 | Colombia | Unknown | 0 | 362 | 0 | 2022-09-10 04:21:10 | Unknown, Colombia | |||||
966760 | 966760 | 2020-09-29 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-09-30 04:23:33 | Unknown, Colombia | ||||
970766 | 970766 | 2022-06-01 | Colombia | Unknown | 0 | 300 | 0 | 2022-06-02 05:20:39 | Unknown, Colombia | |||||
974780 | 974780 | 2021-02-06 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-02-07 05:23:00 | Unknown, 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]);