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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Amazonas 946
- Antioquia 946
- Atlantico 946
- Bolivar 946
- Boyaca 946
- Caldas 946
- Capital District 946
- Caqueta 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
- Santander 946
- Sucre 946
- Tolima 946
- Valle del Cauca 946
- Guainia 944
- Vaupes 943
- Casanare 942
- Arauca 939
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
522719 | 522719 | 2021-06-09 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-06-10 04:23:17 | Unknown, Colombia | ||||
529705 | 529705 | 2020-07-04 | Colombia | Arauca | 82 | 0 | 7 | 75 | 7.0762 | -70.7105 | 2020-07-05 04:33:46 | Arauca, Colombia | ||
529757 | 529757 | 2020-07-04 | Colombia | Casanare | 85 | 0 | 48 | 37 | 5.7589 | -71.5724 | 2020-07-05 04:33:46 | Casanare, Colombia | ||
529832 | 529832 | 2020-07-04 | Colombia | Guaviare | 39 | 0 | 7 | 32 | 1.0654 | -73.2603 | 2020-07-05 04:33:46 | Guaviare, Colombia | ||
530140 | 530140 | 2020-07-04 | Colombia | Unknown | 144 | 0 | 0 | 144 | 2020-07-05 04:33:46 | Unknown, Colombia | ||||
530161 | 530161 | 2020-07-04 | Colombia | Vichada | 1 | 0 | 1 | 0 | 4.4234 | -69.2878 | 2020-07-05 04:33:46 | Vichada, Colombia | ||
530568 | 530568 | 2021-02-22 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-02-23 05:23:41 | Unknown, Colombia | ||||
562829 | 562829 | 2021-06-22 | Colombia | Unknown | 0 | 0 | 1 | 0 | 2021-06-23 04:21:46 | Unknown, Colombia | ||||
573854 | 573854 | 2020-06-06 | Colombia | Arauca | 2 | 0 | 1 | 1 | 7.0762 | -70.7105 | 2020-06-07 03:53:30 | Arauca, Colombia | ||
573901 | 573901 | 2020-06-06 | Colombia | Casanare | 36 | 0 | 26 | 10 | 5.7589 | -71.5724 | 2020-06-07 03:53:30 | Casanare, Colombia | ||
573964 | 573964 | 2020-06-06 | Colombia | Guainia | 6 | 0 | 0 | 6 | 2.5854 | -68.5247 | 2020-06-07 03:53:30 | Guainia, Colombia | ||
574183 | 574183 | 2020-06-06 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-07 03:53:30 | San Andres y Providencia, Colombia | ||
574214 | 574214 | 2020-06-06 | Colombia | Sucre | 81 | 0 | 5 | 76 | 8.814 | -74.7233 | 2020-06-07 03:53:30 | Sucre, Colombia | ||
574250 | 574250 | 2020-06-06 | Colombia | Unknown | 62 | 0 | 0 | 62 | 2020-06-07 03:53:30 | Unknown, Colombia | ||||
574264 | 574264 | 2020-06-06 | Colombia | Vaupes | 11 | 0 | 11 | 0 | 0.8554 | -70.812 | 2020-06-07 03:53:30 | Vaupes, Colombia | ||
574267 | 574267 | 2020-06-06 | Colombia | Vichada | 1 | 0 | 0 | 1 | 4.4234 | -69.2878 | 2020-06-07 03:53:30 | Vichada, Colombia | ||
582681 | 582681 | 2020-08-13 | Colombia | Guaviare | 176 | 0 | 70 | 106 | 1.0654 | -73.2603 | 2020-08-14 04:51:19 | Guaviare, Colombia | ||
582691 | 582691 | 2020-08-13 | Colombia | San Andres y Providencia | 63 | 0 | 34 | 29 | 12.5567 | -81.7185 | 2020-08-14 04:51:19 | San Andres y Providencia, Colombia | ||
582697 | 582697 | 2020-08-13 | Colombia | Vichada | 6 | 0 | 2 | 4 | 4.4234 | -69.2878 | 2020-08-14 04:51:19 | Vichada, 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 | ||||
637786 | 637786 | 2021-03-31 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-01 04:27:05 | Unknown, Colombia | ||||
645814 | 645814 | 2021-05-05 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-06 04:20:38 | Unknown, Colombia | ||||
657871 | 657871 | 2020-03-09 | Colombia | 1 | 0 | 0 | 4.5709 | -74.2973 | 2020-03-07T00:43:02 | |||||
662149 | 662149 | 2020-08-11 | Colombia | Guaviare | 170 | 0 | 68 | 102 | 1.0654 | -73.2603 | 2020-08-12 04:27:29 | Guaviare, Colombia | ||
662159 | 662159 | 2020-08-11 | Colombia | San Andres y Providencia | 55 | 0 | 33 | 22 | 12.5567 | -81.7185 | 2020-08-12 04:27:29 | San Andres y Providencia, Colombia | ||
662165 | 662165 | 2020-08-11 | Colombia | Vichada | 5 | 0 | 2 | 3 | 4.4234 | -69.2878 | 2020-08-12 04:27:29 | Vichada, Colombia | ||
678175 | 678175 | 2020-11-23 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-11-24 05:27:31 | Unknown, Colombia | ||||
702267 | 702267 | 2021-03-16 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-03-17 05:25:07 | Unknown, Colombia | ||||
726360 | 726360 | 2021-05-22 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-23 04:20:51 | Unknown, Colombia | ||||
737302 | 737302 | 2020-06-12 | Colombia | Arauca | 2 | 0 | 1 | 1 | 7.0762 | -70.7105 | 2020-06-13 03:33:14 | Arauca, Colombia | ||
737354 | 737354 | 2020-06-12 | Colombia | Casanare | 36 | 0 | 32 | 4 | 5.7589 | -71.5724 | 2020-06-13 03:33:14 | Casanare, Colombia | ||
737429 | 737429 | 2020-06-12 | Colombia | Guaviare | 2 | 0 | 0 | 2 | 1.0654 | -73.2603 | 2020-06-13 03:33:14 | Guaviare, Colombia | ||
737666 | 737666 | 2020-06-12 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-13 03:33:14 | San Andres y Providencia, Colombia | ||
737738 | 737738 | 2020-06-12 | Colombia | Unknown | 66 | 0 | 0 | 66 | 2020-06-13 03:33:14 | Unknown, Colombia | ||||
737756 | 737756 | 2020-06-12 | Colombia | Vaupes | 11 | 0 | 11 | 0 | 0.8554 | -70.812 | 2020-06-13 03:33:14 | Vaupes, Colombia | ||
737759 | 737759 | 2020-06-12 | Colombia | Vichada | 1 | 0 | 0 | 1 | 4.4234 | -69.2878 | 2020-06-13 03:33:14 | Vichada, Colombia | ||
738164 | 738164 | 2020-12-02 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-12-03 05:28:22 | Unknown, Colombia | ||||
753431 | 753431 | 2020-08-01 | Colombia | Guaviare | 99 | 0 | 49 | 50 | 1.0654 | -73.2603 | 2020-08-02 04:34:47 | Guaviare, Colombia | ||
753673 | 753673 | 2020-08-01 | Colombia | San Andres y Providencia | 38 | 0 | 29 | 9 | 12.5567 | -81.7185 | 2020-08-02 04:34:47 | San Andres y Providencia, Colombia | ||
753767 | 753767 | 2020-08-01 | Colombia | Vichada | 2 | 0 | 1 | 1 | 4.4234 | -69.2878 | 2020-08-02 04:34:47 | Vichada, 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 | |||||
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 | ||||
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 | ||||
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 | ||||
805166 | 805166 | 2020-06-01 | Colombia | Arauca | 1 | 0 | 1 | 0 | 7.0762 | -70.7105 | 2020-06-02 02:33:08 | Arauca, Colombia | ||
805212 | 805212 | 2020-06-01 | Colombia | Casanare | 35 | 0 | 24 | 11 | 5.7589 | -71.5724 | 2020-06-02 02:33:08 | Casanare, Colombia | ||
805272 | 805272 | 2020-06-01 | Colombia | Guainia | 6 | 0 | 0 | 6 | 2.5854 | -68.5247 | 2020-06-02 02:33:08 | Guainia, Colombia | ||
805483 | 805483 | 2020-06-01 | Colombia | San Andres y Providencia | 17 | 0 | 11 | 6 | 12.5567 | -81.7185 | 2020-06-02 02:33:08 | San Andres y Providencia, Colombia | ||
805511 | 805511 | 2020-06-01 | Colombia | Sucre | 21 | 0 | 4 | 17 | 8.814 | -74.7233 | 2020-06-02 02:33:08 | Sucre, Colombia | ||
805547 | 805547 | 2020-06-01 | Colombia | Unknown | 1087 | 0 | 0 | 1087 | 2020-06-02 02:33:08 | Unknown, Colombia | ||||
805555 | 805555 | 2020-06-01 | Colombia | Vaupes | 11 | 0 | 0 | 11 | 0.8554 | -70.812 | 2020-06-02 02:33:08 | Vaupes, Colombia | ||
805558 | 805558 | 2020-06-01 | Colombia | Vichada | 1 | 0 | 0 | 1 | 4.4234 | -69.2878 | 2020-06-02 02:33:08 | Vichada, 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 | ||||
837462 | 837462 | 2020-08-17 | Colombia | Guaviare | 197 | 0 | 126 | 71 | 1.0654 | -73.2603 | 2020-08-18 04:27:56 | Guaviare, Colombia | ||
837472 | 837472 | 2020-08-17 | Colombia | San Andres y Providencia | 109 | 0 | 41 | 68 | 12.5567 | -81.7185 | 2020-08-18 04:27:56 | San Andres y Providencia, Colombia | ||
837478 | 837478 | 2020-08-17 | Colombia | Vichada | 12 | 0 | 5 | 7 | 4.4234 | -69.2878 | 2020-08-18 04:27:56 | Vichada, Colombia | ||
844686 | 844686 | 2020-07-22 | Colombia | Guaviare | 51 | 0 | 39 | 12 | 1.0654 | -73.2603 | 2020-07-23 05:15:04 | Guaviare, Colombia | ||
844927 | 844927 | 2020-07-22 | Colombia | San Andres y Providencia | 31 | 0 | 23 | 8 | 12.5567 | -81.7185 | 2020-07-23 05:15:04 | San Andres y Providencia, Colombia | ||
845020 | 845020 | 2020-07-22 | Colombia | Vichada | 2 | 0 | 1 | 1 | 4.4234 | -69.2878 | 2020-07-23 05:15:04 | Vichada, 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 | ||||
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 | ||||
887118 | 887118 | 2020-07-07 | Colombia | Arauca | 96 | 0 | 8 | 88 | 7.0762 | -70.7105 | 2020-07-08 05:33:48 | Arauca, Colombia | ||
887170 | 887170 | 2020-07-07 | Colombia | Casanare | 88 | 0 | 49 | 39 | 5.7589 | -71.5724 | 2020-07-08 05:33:48 | Casanare, Colombia | ||
887245 | 887245 | 2020-07-07 | Colombia | Guaviare | 39 | 0 | 8 | 31 | 1.0654 | -73.2603 | 2020-07-08 05:33:48 | Guaviare, Colombia | ||
887553 | 887553 | 2020-07-07 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-08 05:33:48 | Unknown, Colombia | ||||
887574 | 887574 | 2020-07-07 | Colombia | Vichada | 1 | 0 | 1 | 0 | 4.4234 | -69.2878 | 2020-07-08 05:33:48 | Vichada, 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 | ||||
908040 | 908040 | 2021-01-19 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-01-20 05:21:54 | 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 | ||||
954727 | 954727 | 2021-04-25 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-26 04:21:04 | Unknown, Colombia | ||||
966760 | 966760 | 2020-09-29 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-09-30 04:23:33 | Unknown, Colombia | ||||
974780 | 974780 | 2021-02-06 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-02-07 05:23:00 | Unknown, Colombia | ||||
982811 | 982811 | 2021-04-17 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-18 04:20:41 | Unknown, Colombia | ||||
998301 | 998301 | 2021-03-01 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-03-02 05:23:30 | Unknown, Colombia | ||||
1005293 | 1005293 | 2020-07-09 | Colombia | Arauca | 121 | 0 | 8 | 113 | 7.0762 | -70.7105 | 2020-07-10 04:34:24 | Arauca, Colombia | ||
1005345 | 1005345 | 2020-07-09 | Colombia | Casanare | 91 | 0 | 49 | 42 | 5.7589 | -71.5724 | 2020-07-10 04:34:24 | Casanare, Colombia | ||
1005420 | 1005420 | 2020-07-09 | Colombia | Guaviare | 39 | 0 | 11 | 28 | 1.0654 | -73.2603 | 2020-07-10 04:34:24 | Guaviare, Colombia | ||
1005729 | 1005729 | 2020-07-09 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-10 04:34:24 | Unknown, Colombia | ||||
1005750 | 1005750 | 2020-07-09 | Colombia | Vichada | 1 | 0 | 1 | 0 | 4.4234 | -69.2878 | 2020-07-10 04:34:24 | Vichada, Colombia | ||
1006157 | 1006157 | 2020-12-06 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-12-07 05:26:14 | Unknown, Colombia | ||||
1026215 | 1026215 | 2020-10-17 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-10-18 04:24:25 | Unknown, Colombia | ||||
1034237 | 1034237 | 2020-12-15 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-12-16 05:28:04 | Unknown, Colombia | ||||
1041687 | 1041687 | 2020-10-07 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-10-08 04:23:56 | Unknown, Colombia | ||||
1045679 | 1045679 | 2020-09-30 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-10-01 04:23:42 | Unknown, Colombia | ||||
1053687 | 1053687 | 2020-10-23 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-10-24 04:24:46 | Unknown, Colombia | ||||
1081787 | 1081787 | 2021-05-14 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-15 04:20:58 | Unknown, Colombia | ||||
1089937 | 1089937 | 2021-03-03 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-03-04 05:24:24 | Unknown, Colombia | ||||
1093950 | 1093950 | 2021-01-20 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-01-21 05:22:01 | 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]);