| Title: | Access Colombian Data via APIs and Curated Datasets |
|---|---|
| Description: | Provides a comprehensive interface to access diverse public data about Colombia through multiple APIs and curated datasets. The package integrates four different APIs: 'API-Colombia' for Colombian-specific data including geography, culture, tourism, and government information; 'World Bank API' for economic and demographic indicators; 'Nager.Date' for public holidays; and 'REST Countries API' for general country information. The package enables users to explore various aspects of Colombia such as geographic locations, cultural attractions, economic indicators, demographic data, and public holidays. Additionally, 'ColombiAPI' includes curated datasets covering Bogota air stations, business and holiday dates, public schools, Colombian coffee exports, cannabis licenses, Medellin rainfall, malls in Bogota, as well as datasets on indigenous languages, student admissions and school statistics, forest liana mortality, municipal and regional data, connectivity and digital infrastructure, program graduates, vehicle counts, international visitors, and GDP projections. These datasets provide users with a rich and multifaceted view of Colombian social, economic, environmental, and technological information, making 'ColombiAPI' a comprehensive tool for exploring Colombia's diverse data landscape. For more information on the APIs, see: 'API-Colombia' <https://api-colombia.com/>, 'Nager.Date' <https://date.nager.at/Api>, 'World Bank API' <https://datahelpdesk.worldbank.org/knowledgebase/articles/889392>, and 'REST Countries API' <https://restcountries.com/>. |
| Authors: | Renzo Caceres Rossi [aut, cre] (ORCID: <https://orcid.org/0009-0005-0744-854X>) |
| Maintainer: | Renzo Caceres Rossi <[email protected]> |
| License: | GPL-3 |
| Version: | 0.3.2 |
| Built: | 2026-06-05 06:20:10 UTC |
| Source: | https://github.com/lightbluetitan/colombiapi |
This dataset, admitted_students_df, is a data frame containing the admission scores and socio-demographic information of 445 students admitted to the seven careers of the Facultad de Ciencias at the Universidad Nacional de Colombia, Bogotá, for the first semester of 2013. It includes exam component scores, gender, socio-economic background, and other demographic attributes.
data(admitted_students_df)data(admitted_students_df)
A data frame with 445 observations and 15 variables:
Career or program admitted to (factor with 7 levels)
Mathematics exam score (numeric)
Science exam score (numeric)
Social sciences exam score (numeric)
Textual reasoning exam score (numeric)
Abstract/imagery reasoning exam score (numeric)
Total exam score (numeric)
Gender of the student (factor with 2 levels)
Socio-economic stratum (factor with 3 levels)
Origin or background classification (factor with 3 levels)
Age group (factor with 4 levels)
Mother tongue indicator (factor with 2 levels)
Maternal education indicator (factor with 2 levels)
Admission stratum or classification (factor with 7 levels)
Age of the student in years (numeric)
The dataset name has been kept as 'admitted_students_df' to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'df' indicates that the dataset is a data frame object. The original content has not been modified in any way.
Data taken from the FactoClass package version 1.2.9
This dataset, Bogota_airstations_df, is a data frame containing the coordinates of air quality measurement stations in Bogota, Colombia.
data(Bogota_airstations_df)data(Bogota_airstations_df)
A data frame with 10 observations and 3 variables:
Character string representing the name of the station.
Numeric value representing the X coordinate of the station.
Numeric value representing the Y coordinate of the station.
The dataset name has been kept as Bogota_airstations_df to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix '_df' indicates that the dataset is a data frame. The original content has not been modified in any way.
Originally taken from the SpatFD package version 0.0.1
This dataset, Bogota_business_Date, is a Date object containing the business dates for Bogota, Colombia.
data(Bogota_business_Date)data(Bogota_business_Date)
A Date object with 27,173 observations:
Date object representing the business dates in Bogota, Colombia, ranging between "1990-01-02" and "2100-12-31".
The dataset name has been kept as Bogota_business_Date to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix '_Date' indicates that the dataset is an object of the Date class. The original content has not been modified in any way.
Originally taken from the quantdates package version 2.0.4.
This dataset, Bogota_holidays_Date, is a Date object containing the official holidays of Bogota, Colombia.
data(Bogota_holidays_Date)data(Bogota_holidays_Date)
A Date object with 1787 observations:
Date object representing the official holidays in Bogota, Colombia, ranging between "1990-01-01" and "2100-12-08".
The dataset name has been kept as Bogota_holidays_Date to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix '_Date' indicates that the dataset is an object of the Date class. The original content has not been modified in any way.
Originally taken from the quantdates package version 2.0.4.
Holidays were created using the bizdays package.
This dataset, Bogota_malls_tbl_df, is a tibble containing detailed information about shopping malls located in Bogota, Colombia. It includes the mall names, physical addresses, web URLs, geographical coordinates, and the locality to which each mall belongs.
data(Bogota_malls_tbl_df)data(Bogota_malls_tbl_df)
A tibble with 42 observations and 6 variables:
Character string representing the name of the shopping mall.
Character string representing the physical address of the mall.
Character string representing the web URL of the mall.
Numeric value representing the latitude of the mall.
Numeric value representing the longitude of the mall.
Character string representing the locality the mall belongs to.
The dataset name has been kept as Bogota_malls_tbl_df to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'tbl_df' indicates that the dataset is a tibble. The original content has not been modified in any way.
Originally taken from Kaggle, url: https://www.kaggle.com/datasets/erik172/bogota-shopping-malls.
This dataset, Bucaramanga_wifi_tbl_df, is a tibble containing information about community WiFi connection zones in the municipality of Bucaramanga. It includes details such as the zone name, address, neighborhood, commune, urban or rural classification, department, municipality, and geographic coordinates. This dataset was taken from GOV.CO Datos Abiertos, last update on September 20, 2025.
data(Bucaramanga_wifi_tbl_df)data(Bucaramanga_wifi_tbl_df)
A tibble with 82 observations and 9 variables:
Name of the WiFi zone (character)
Address of the WiFi zone (character)
Neighborhood of the WiFi zone (character)
Commune of the WiFi zone (character)
Urban or rural classification (character)
Department where the zone is located (character)
Municipality where the zone is located (character)
Latitude coordinate of the WiFi zone (character)
Longitude coordinate of the WiFi zone (character)
The dataset name has been kept as 'Bucaramanga_wifi_tbl_df' to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'tbl_df' indicates that the dataset is a tibble object. The original content has not been modified in any way.
Data obtained from GOV.CO Datos Abiertos: https://www.datos.gov.co/Ciencia-Tecnolog-a-e-Innovaci-n/SERVICIO-DE-CONECTIVIDAD-ZONAS-WIFI/9n9m-2dqq/about_data
This dataset, Cannabis_Licenses_tbl_df, is a tibble containing detailed information about cannabis-related licenses issued by the Ministry of Justice and Law in Colombia. It includes data on the number of received, denied, archived, modified, and granted licenses for cannabis cultivation, as well as the licenses issued for both psychoactive and non-psychoactive cannabis plants.
data(Cannabis_Licenses_tbl_df)data(Cannabis_Licenses_tbl_df)
A tibble with 92 observations and 10 variables:
Character string representing the month in which the data was recorded.
Numeric value representing the number of license requests received.
Numeric value representing the number of denied license requests.
Numeric value representing the number of archived license requests.
Numeric value representing the number of modified license requests.
Numeric value representing the number of licenses granted.
Numeric value representing the number of seed cultivation licenses issued.
Numeric value representing the number of psychoactive cannabis plant cultivation licenses issued.
Numeric value representing the number of non-psychoactive cannabis plant cultivation licenses issued.
Numeric value representing the year in which the data was recorded.
The dataset name has been kept as Cannabis_Licenses_tbl_df to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'tbl_df' indicates that the dataset is a tibble. The original content has not been modified in any way.
Originally taken from Kaggle, url: https://www.kaggle.com/datasets/josetroyatoscano/licencias-cannabis-colombia-full-dataset-feb-2024
This dataset, Cartagena_wifi_tbl_df, is a tibble containing information about the number of devices connected in the public WiFi zones of the District of Cartagena. It includes the year, month, corregimiento or neighborhood, WiFi zone, and counts of connected devices by type (Other, Smartphone, Tablet, PC). The dataset was obtained from GOV.CO Datos Abiertos, last update on September 23, 2025.
data(Cartagena_wifi_tbl_df)data(Cartagena_wifi_tbl_df)
A tibble with 468 observations and 8 variables:
Year of the record (numeric)
Month of the record (character)
Name of the corregimiento or neighborhood (character)
Name of the WiFi zone (character)
Number of connected devices categorized as 'Other' (numeric)
Number of connected smartphones (numeric)
Number of connected tablets (numeric)
Number of connected PCs (numeric)
The dataset name has been kept as 'Cartagena_wifi_tbl_df' to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'tbl_df' indicates that the dataset is a tibble object. The original content has not been modified in any way.
Data obtained from GOV.CO Datos Abiertos: https://www.datos.gov.co
This dataset, Colombia_coffee_tbl_df, is a tibble containing detailed information about Colombian coffee exports and imports in 2016. It includes data on various factors such as trade flow, commodity codes, trade value, weight in kilograms, and information about the countries involved in the trade. The dataset is sourced from Kaggle and provides a comprehensive analysis of the foreign trade of Colombian coffee.
data(Colombia_coffee_tbl_df)data(Colombia_coffee_tbl_df)
A tibble with 106 observations and 35 variables:
Character string representing the classification of the coffee product.
Numeric value representing the year of the data entry.
Numeric value representing the period of the trade.
Numeric value representing the period description.
Numeric value representing the aggregate level of the trade data.
Numeric value indicating whether the trade involves a leaf product.
Numeric value representing the trade flow code.
Character string representing the flow of the trade, either export or import.
Numeric value representing the code of the reporting country.
Character string representing the reporting country.
Character string representing the ISO code of the reporting country.
Numeric value representing the code of the partner country.
Character string representing the partner country.
Character string representing the ISO code of the partner country.
Logical value indicating if there is a second partner country involved in the trade.
Logical value indicating if there is a second partner country.
Logical value indicating if there is a second partner country's ISO code.
Logical value representing the customs procedure code.
Logical value indicating whether customs procedure information is available.
Logical value representing the mode of transport code.
Logical value indicating the mode of transport used in the trade.
Character string representing the commodity code for coffee.
Character string representing the commodity (coffee).
Numeric value representing the quantity unit code.
Character string representing the unit of quantity for the trade.
Logical value representing the quantity of coffee in the trade.
Logical value representing an alternative quantity unit code.
Numeric value representing an alternative quantity unit for the trade.
Logical value representing an alternative quantity for the trade.
Numeric value representing the net weight of the coffee in kilograms.
Logical value indicating the gross weight of the coffee in kilograms.
Numeric value representing the trade value in US dollars.
Logical value representing the CIF trade value in US dollars.
Logical value representing the FOB trade value in US dollars.
Numeric value representing a flag for the dataset entry.
The dataset name has been kept as Colombia_coffee_tbl_df to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'tbl_df' indicates that the dataset is a tibble. The original content has not been modified in any way.
Originally taken from Kaggle, url: https://www.kaggle.com/datasets/carlosbeltranv/colombian-coffee-2016
This package provides a comprehensive interface to access diverse public data about Colombia through multiple APIs and curated datasets. The package integrates four different APIs: API-Colombia for Colombian-specific data including geography, culture, tourism, and government information; World Bank API for economic and demographic indicators; Nager.Date for public holidays; and REST Countries API for general country information. Additionally, ColombiAPI includes curated datasets covering Bogota air stations, business and holiday dates, public schools, Colombian coffee exports, cannabis licenses, Medellin rainfall, malls in Bogota, as well as datasets on indigenous languages, student admissions and school statistics, forest liana mortality and more.
ColombiAPI: Access Colombian Data via APIs and Curated Datasets
Access Colombian Data via APIs and Curated Datasets.
Maintainer: Renzo Caceres Rossi [email protected]
Useful links:
This dataset, 'dead_lianas_df', is a data frame containing information on the mortality of vascular epiphytes (lianas) in tropical forests of the Colombian Andes. The study is part of the project "Diversity and dynamics of vascular epiphytes in Colombian Andes" supported by COLCIENCIAS (contract 2115-2013). The data corresponds to the first large-scale assessment of vascular epiphyte mortality in the neotropics.
data(dead_lianas_df)data(dead_lianas_df)
A data frame with 4,247 observations and 52 variables:
Plot site identifier (character)
Y coordinate of the plot (numeric)
X coordinate of the plot (numeric)
Phorophyte number (integer)
Epiphyte family (character)
Epiphyte genus (character)
Taxonomic uncertainty or affiliation (character)
Epiphyte species name (character)
Species author (character)
Epiphyte azimuth (character)
Branch azimuth (integer)
Epiphyte distance from trunk (numeric)
Epiphyte size (numeric)
Epiphyte attachment height (numeric)
Initial survey date (Date)
Follow-up survey date (Date)
Location name (character)
Mortality status (factor with 2 levels)
Mortality category (character)
Elevation in meters (integer)
Annual precipitation (integer)
Precipitation of driest month (integer)
Precipitation seasonality (integer)
Mean diurnal temperature range (integer)
Temperature seasonality (integer)
Annual temperature range (integer)
Actual evapotranspiration (integer)
Basal area (numeric)
Basal area of trees 5–10 cm DBH (numeric)
Basal area of trees 10 cm DBH (numeric)
Number of individuals 10 cm DBH (integer)
Number of individuals 5 cm DBH (numeric)
Number of individuals 5–10 cm DBH (numeric)
Number of individuals 10–15 cm DBH (integer)
Number of individuals 15–20 cm DBH (integer)
Number of individuals 20–25 cm DBH (integer)
Number of individuals 25–30 cm DBH (integer)
Number of individuals 30 cm DBH (integer)
Tree height (numeric)
Median tree height (numeric)
Maximum tree height (numeric)
Number of branches (integer)
Mean epiphyte attachment height (numeric)
Standard deviation of mean epiphyte attachment height (numeric)
Mean species per phorophyte (integer)
Standard deviation of mean species per phorophyte (integer)
Mean tree height (numeric)
Standard deviation of mean tree height (numeric)
Mean branch number (numeric)
Standard deviation of branch number (numeric)
Tree identifier (character)
Tree mortality status (factor with 2 levels)
The dataset name has been kept as 'dead_lianas_df' to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'df' indicates that the dataset is a data frame object. The original content has not been modified in any way.
Data taken from the biometrics package version 1.0.2
This dataset, digital_centers_tbl_df, is a tibble containing information about Digital Centers located in the department of Sucre. It includes details such as department name, municipality name, PDET status, name of the populated center, educational center name, start date of operation, end date of initial operation, and current status. The dataset was obtained from GOV.CO Datos Abiertos, last update on April 20, 2024.
data(digital_centers_tbl_df)data(digital_centers_tbl_df)
A tibble with 475 observations and 8 variables:
Name of the department (character)
Name of the municipality (character)
PDET status (character)
Name of the populated center (character)
Name of the educational center (character)
Start date of operation (character)
End date of initial operation (character)
Current status of the center (character)
The dataset name has been kept as 'digital_centers_tbl_df' to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'tbl_df' indicates that the dataset is a tibble object. The original content has not been modified in any way.
Data obtained from GOV.CO Datos Abiertos: https://www.datos.gov.co/Ciencia-Tecnolog-a-e-Innovaci-n/Centros-Digitales-Sucre-/pwyn-md8n/about_data
This dataset, digital_graduates_tbl_df, is a tibble containing information about graduates of the first cohort in the various courses of the "Avanzando en lo Digital" program, an initiative aimed at developing digital skills. It includes data such as year, age, gender, courses enrolled, zone, ethnicity, and socioeconomic stratum. The dataset was obtained from GOV.CO Datos Abiertos, last update on October 3, 2024.
data(digital_graduates_tbl_df)data(digital_graduates_tbl_df)
A tibble with 230 observations and 7 variables:
Year of graduation (numeric)
Age of the graduate (numeric)
Gender of the graduate (character)
Courses in which the graduate was enrolled (character)
Geographical zone of the graduate (character)
Ethnicity of the graduate (character)
Socioeconomic stratum of the graduate (numeric)
The dataset name has been kept as 'digital_graduates_tbl_df' to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'tbl_df' indicates that the dataset is a tibble object. The original content has not been modified in any way.
Data obtained from GOV.CO Datos Abiertos: https://www.datos.gov.co/Ciencia-Tecnolog-a-e-Innovaci-n/GRADUADOS-AVANZANDO-EN-LO-DIGITAL-PRIMERA-PROMOCIO/yfz9-fwqr/about_data
This dataset, foreign_visitors_tbl_df, is a tibble containing information about non-resident foreigners entering Colombia through various migration points. It includes data on the year, month, destination department, destination city, country of residence of the foreign visitor, and the number of non-resident foreigners. The dataset was obtained from GOV.CO Datos Abiertos, last update on September 25, 2025.
data(foreign_visitors_tbl_df)data(foreign_visitors_tbl_df)
A tibble with 466,915 observations and 6 variables:
Year of the record (numeric)
Month of the record (character)
Destination department in Colombia (character)
Destination city in Colombia (character)
Country of residence of the foreign visitor (character)
Number of non-resident foreign visitors (numeric)
The dataset name has been kept as 'foreign_visitors_tbl_df' to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'tbl_df' indicates that the dataset is a tibble object. The original content has not been modified in any way.
Data obtained from GOV.CO Datos Abiertos: https://www.datos.gov.co/Comercio-Industria-y-Turismo/Extranjeros-No-Residentes/7wm8-w5ad/about_data
This dataset, gdp_departments_tbl_df, is a tibble containing the projected Gross Domestic Product (GDP) at constant prices for the departments of Colombia, expressed in 2015 prices. It includes data such as year, economic activity, sector, price type, DIVIPOLA department code, department name, and GDP value in thousands of millions of pesos. The dataset was obtained from GOV.CO Datos Abiertos, last update on November 1, 2024.
data(gdp_departments_tbl_df)data(gdp_departments_tbl_df)
A tibble with 16,302 observations and 7 variables:
Year of the record (numeric)
Economic activity (character)
Sector of the economy (character)
Price type (character)
DIVIPOLA code of the department (numeric)
Name of the department (character)
GDP value in thousands of millions of pesos (numeric)
The dataset name has been kept as 'gdp_departments_tbl_df' to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'tbl_df' indicates that the dataset is a tibble object. The original content has not been modified in any way.
Data obtained from GOV.CO Datos Abiertos: https://www.datos.gov.co/Econom-a-y-Finanzas/PIB-Departamental-con-proyecci-n/kgyi-qc7j/about_data
Retrieves comprehensive information about all Colombian airports from the API Colombia service. This function fetches data including airport names, codes, types, locations, and geographical coordinates for all airports across Colombia's departments.
get_colombia_airports()get_colombia_airports()
This function sends a GET request to the API Colombia service.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
Note: The API returns latitude and longitude values swapped, so this function
corrects the coordinates by swapping them back to their correct positions.
A tibble with the following columns:
id: Airport identifier (integer)
name: Airport name (character)
iata_code: IATA airport code (character)
oaci_code: ICAO airport code (character)
type: Airport type (character)
city: City where airport is located (character)
department: Department where airport is located (character)
latitude: Latitude coordinates (numeric)
longitude: Longitude coordinates (numeric)
Requires internet connection.
API Colombia: https://api-colombia.com/api/v1/Airport
if (interactive()) { get_colombia_airports() }if (interactive()) { get_colombia_airports() }
Retrieves selected information about touristic attractions in Colombia from the API Colombia. This function fetches the attraction ID, name, description, latitude, longitude, and city ID.
get_colombia_attractions()get_colombia_attractions()
This function sends a GET request to the API Colombia service.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
id: Attraction identifier (integer)
name: Attraction name (character)
description: Attraction description (character)
latitude: Latitude coordinates (numeric)
longitude: Longitude coordinates (numeric)
cityId: City identifier (integer)
Returns NULL if the API request fails.
Requires internet connection.
API Colombia: https://api-colombia.com/api/v1/TouristicAttraction
if (interactive()) { get_colombia_attractions() }if (interactive()) { get_colombia_attractions() }
Retrieves Colombia's under-5 mortality rate, measured as the number of deaths
of children under five years of age per 1,000 live births, for the years 2010 to 2022
using the World Bank Open Data API. The indicator used is SH.DYN.MORT.
get_colombia_child_mortality()get_colombia_child_mortality()
This function sends a GET request to the World Bank API.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
indicator: Indicator name (e.g., "Mortality rate, under-5 (per 1,000 live births)")
country: Country name ("Colombia")
year: Year of the data (integer)
value: Mortality rate (per 1,000 live births)
Requires internet connection.
World Bank Open Data API: https://data.worldbank.org/indicator/SH.DYN.MORT
if (interactive()) { get_colombia_child_mortality() }if (interactive()) { get_colombia_child_mortality() }
Retrieves basic information about all cities in Colombia from the API Colombia. This function fetches only the city ID and name to provide a clean and concise dataset.
get_colombia_cities()get_colombia_cities()
This function sends a GET request to the API Colombia service.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
id: City identifier (integer)
name: City name (character)
Returns NULL if the API request fails.
Requires internet connection.
API Colombia: https://api-colombia.com/api/v1/City
if (interactive()) { get_colombia_cities() }if (interactive()) { get_colombia_cities() }
Retrieves Colombia's Consumer Price Index (CPI), with 2010 as the base year (index = 100),
for the years 2010 to 2022 using the World Bank Open Data API.
The indicator used is FP.CPI.TOTL.
get_colombia_cpi()get_colombia_cpi()
This function sends a GET request to the World Bank API.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
indicator: Indicator name (e.g., "Consumer price index (2010 = 100)")
country: Country name ("Colombia")
year: Year of the data (integer)
value: Consumer Price Index (numeric, base year 2010 = 100)
Requires internet connection.
World Bank Open Data API: https://data.worldbank.org/indicator/FP.CPI.TOTL
if (interactive()) { get_colombia_cpi() }if (interactive()) { get_colombia_cpi() }
Retrieves comprehensive information about all Colombian departments from the API Colombia service. This function fetches data including department names, capitals, geographical information, area, population, and administrative details for all 32 departments plus Bogotá D.C.
get_colombia_departments()get_colombia_departments()
This function sends a GET request to the API Colombia service.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
id: Department identifier (integer)
name: Department name (character)
capital: Capital city name (character)
surface: Department area in km² (integer)
population: Department population (integer)
municipalities: Number of municipalities (integer)
phone_prefix: Phone area code (character)
region_id: Geographic region identifier (integer)
Requires internet connection.
API Colombia: https://api-colombia.com/api/v1/Department
if (interactive()) { get_colombia_departments() }if (interactive()) { get_colombia_departments() }
Retrieves Colombia's energy use per capita, measured in kilograms of oil equivalent,
for the years 2010 to 2022 using the World Bank Open Data API.
The indicator used is EG.USE.PCAP.KG.OE.
get_colombia_energy_use()get_colombia_energy_use()
This function sends a GET request to the World Bank API.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
indicator: Indicator name (e.g., "Energy use (kg of oil equivalent per capita)")
country: Country name ("Colombia")
year: Year of the data (integer)
value: Energy use in kilograms of oil equivalent per capita
Requires internet connection.
World Bank Open Data API: https://data.worldbank.org/indicator/EG.USE.PCAP.KG.OE
if (interactive()) { get_colombia_energy_use() }if (interactive()) { get_colombia_energy_use() }
Retrieves Colombia's Gross Domestic Product (GDP) in current US dollars
for the years 2010 to 2022 using the World Bank Open Data API.
The indicator used is NY.GDP.MKTP.CD.
get_colombia_gdp()get_colombia_gdp()
This function sends a GET request to the World Bank API.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
indicator: Indicator name (e.g., "GDP (current US$)")
country: Country name ("Colombia")
year: Year of the data (integer)
value: GDP in current US dollars
value_label: Formatted GDP with commas (e.g., "1,800,000,000,000")
Requires internet connection.
World Bank Open Data API: https://data.worldbank.org/indicator/NY.GDP.MKTP.CD
GET, fromJSON, as_tibble, comma
if (interactive()) { get_colombia_gdp() }if (interactive()) { get_colombia_gdp() }
Retrieves the list of official public holidays in Colombia for a specific year using the Nager.Date public holidays API. This function returns a tibble containing the date of the holiday, the name in the local language (Spanish), and the English name. It is useful for academic, planning, and data analysis purposes. The information is retrieved directly from the Nager.Date API and reflects the current status of holidays for the requested year. The field names returned are consistent with the API structure.
get_colombia_holidays(year)get_colombia_holidays(year)
year |
An integer indicating the year (e.g., 2024 or 2025). |
This function sends a GET request to the Nager.Date API.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
date: Date of the holiday (class Date)
local_name: Holiday name in the local language (Spanish)
name: Holiday name in English
Requires internet connection.
Data obtained from the Nager.Date API: https://date.nager.at/
if (interactive()) { get_colombia_holidays(2024) }if (interactive()) { get_colombia_holidays(2024) }
Retrieves Colombia's number of hospital beds per 1,000 people
for the years 2010 to 2022 using the World Bank Open Data API.
The indicator used is SH.MED.BEDS.ZS.
get_colombia_hospital_beds()get_colombia_hospital_beds()
This function sends a GET request to the World Bank API.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
indicator: Indicator name (e.g., "Hospital beds (per 1,000 people)")
country: Country name ("Colombia")
year: Year of the data (integer)
value: Number of hospital beds per 1,000 people
Requires internet connection.
World Bank Open Data API: https://data.worldbank.org/indicator/SH.MED.BEDS.ZS
if (interactive()) { get_colombia_hospital_beds() }if (interactive()) { get_colombia_hospital_beds() }
Retrieves information about invasive species in Colombia from the API Colombia. This function fetches only selected fields: id, name, scientificName, commonNames, impact, manage, and riskLevel.
get_colombia_invasive_species()get_colombia_invasive_species()
This function sends a GET request to the API Colombia service.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
id: Species identifier (integer)
name: Species common name (character)
scientificName: Scientific name of the species (character)
commonNames: List of common names (list)
impact: Description of ecological impact (character)
manage: Management recommendations (character)
riskLevel: Risk level classification (character)
Returns NULL if the API request fails.
Requires internet connection.
API Colombia: https://api-colombia.com/api/v1/InvasiveSpecie
if (interactive()) { get_colombia_invasive_species() }if (interactive()) { get_colombia_invasive_species() }
Retrieves Colombia's life expectancy at birth (total, years)
for the years 2010 to 2022 using the World Bank Open Data API.
The indicator used is SP.DYN.LE00.IN.
get_colombia_life_expectancy()get_colombia_life_expectancy()
This function sends a GET request to the World Bank API.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
indicator: Indicator name (e.g., "Life expectancy at birth, total (years)")
country: Country name ("Colombia")
year: Year of the data (integer)
value: Life expectancy at birth in years
Requires internet connection.
World Bank Open Data API: https://data.worldbank.org/indicator/SP.DYN.LE00.IN
if (interactive()) { get_colombia_life_expectancy() }if (interactive()) { get_colombia_life_expectancy() }
Retrieves Colombia's adult literacy rate (
for the years 2010 to 2022 using the World Bank Open Data API.
The indicator used is SE.ADT.LITR.ZS.
get_colombia_literacy_rate()get_colombia_literacy_rate()
This function sends a GET request to the World Bank API.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
indicator: Indicator name
country: Country name ("Colombia")
year: Year of the data (integer)
value: Literacy rate as a percentage
Requires internet connection.
World Bank Open Data API: https://data.worldbank.org/indicator/SE.ADT.LITR.ZS
if (interactive()) { get_colombia_literacy_rate() }if (interactive()) { get_colombia_literacy_rate() }
Retrieves information about Colombia's native communities from the API Colombia. This function fetches only selected fields: id, name, description, and languages.
get_colombia_native_communities()get_colombia_native_communities()
This function sends a GET request to the API Colombia service.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
id: Community identifier (integer)
name: Community name (character)
description: Community description (character)
languages: Languages spoken by the community (list)
Returns NULL if the API request fails.
Requires internet connection.
API Colombia: https://api-colombia.com/api/v1/NativeCommunity
if (interactive()) { get_colombia_native_communities() }if (interactive()) { get_colombia_native_communities() }
Retrieves information about natural areas in Colombia from the API Colombia. This function fetches only selected fields: id, areaGroupId, categoryNaturalAreaId, name, departmentId, daneCode, and landArea.
get_colombia_natural_areas()get_colombia_natural_areas()
This function sends a GET request to the API Colombia service.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
id: Natural area identifier (integer)
areaGroupId: Area group identifier (integer)
categoryNaturalAreaId: Category identifier for the natural area (integer)
name: Natural area name (character)
departmentId: Department identifier (integer)
daneCode: DANE statistical code (character)
landArea: Land area in hectares (numeric)
Returns NULL if the API request fails.
Requires internet connection.
API Colombia: https://api-colombia.com/api/v1/NaturalArea
if (interactive()) { get_colombia_natural_areas() }if (interactive()) { get_colombia_natural_areas() }
Retrieves Colombia's total population for the years 2010 to 2022
using the World Bank Open Data API. The indicator used is SP.POP.TOTL.
get_colombia_population()get_colombia_population()
The function sends a GET request to the World Bank API.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
indicator: Indicator name (e.g., "Population, total")
country: Country name ("Colombia")
year: Year of the data (integer)
value: Population as a numeric value
value_label: Formatted population with commas (e.g., "51,000,000")
Requires internet connection. The data is retrieved in real time from the World Bank API.
World Bank Open Data API: https://data.worldbank.org/indicator/SP.POP.TOTL
GET, fromJSON, as_tibble, comma
if (interactive()) { get_colombia_population() }if (interactive()) { get_colombia_population() }
Retrieves comprehensive information about all Colombian presidents from 1886 to present from the API Colombia service. This function fetches data including names, political parties, government periods, descriptions, and biographical information for each president.
get_colombia_presidents()get_colombia_presidents()
This function sends a GET request to the API Colombia service.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
id: President identifier (integer)
name: President's first name(s) (character)
last_name: President's last name(s) (character)
political_party: Political party affiliation (character)
start_period_date: Start date of presidency (character, YYYY-MM-DD format)
end_period_date: End date of presidency (character, YYYY-MM-DD format or NULL for current)
Requires internet connection.
API Colombia: https://api-colombia.com/api/v1/President
if (interactive()) { get_colombia_presidents() }if (interactive()) { get_colombia_presidents() }
Retrieves information about radio stations in Colombia from the API Colombia. This function fetches only the following fields: id, name, frequency, and band.
get_colombia_radios()get_colombia_radios()
This function sends a GET request to the API Colombia service.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
id: Radio station identifier (integer)
name: Radio station name (character)
frequency: Broadcast frequency (numeric)
band: Frequency band (e.g., AM, FM) (character)
Returns NULL if the API request fails.
Requires internet connection.
API Colombia: https://api-colombia.com/api/v1/Radio
if (interactive()) { get_colombia_radios() }if (interactive()) { get_colombia_radios() }
Retrieves comprehensive information about Colombia's six natural regions from the API Colombia service. This function fetches data including region names, descriptions, and identifiers for all Colombian regions: Caribe, Pacífico, Orinoquía, Amazonía, Andina, and Insular.
get_colombia_regions()get_colombia_regions()
This function sends a GET request to the API Colombia service.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
id: Region identifier (integer)
name: Region name (character)
description: Detailed description of the region (character)
Requires internet connection.
API Colombia: https://api-colombia.com/api/v1/Region
if (interactive()) { get_colombia_regions() }if (interactive()) { get_colombia_regions() }
Retrieves information about Colombia's typical dishes from the API Colombia. This function fetches only selected fields: id, name, and description.
get_colombia_typical_dishes()get_colombia_typical_dishes()
This function sends a GET request to the API Colombia service.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
id: Dish identifier (integer)
name: Dish name (character)
description: Dish description (character)
Returns NULL if the API request fails.
Requires internet connection.
API Colombia: https://api-colombia.com/api/v1/TypicalDish
if (interactive()) { get_colombia_typical_dishes() }if (interactive()) { get_colombia_typical_dishes() }
Retrieves Colombia's total unemployment rate, measured as a percentage of the total labor force,
for the years 2010 to 2022 using the World Bank Open Data API.
The indicator used is SL.UEM.TOTL.ZS.
get_colombia_unemployment()get_colombia_unemployment()
This function sends a GET request to the World Bank API.
If the API request fails or returns an error status code,
the function returns NULL with an informative message.
A tibble with the following columns:
indicator: Indicator name (e.g., "Unemployment, total (
country: Country name ("Colombia")
year: Year of the data (integer)
value: Unemployment rate as a numeric value (percentage)
Requires internet connection.
World Bank Open Data API: https://data.worldbank.org/indicator/SL.UEM.TOTL.ZS
if (interactive()) { get_colombia_unemployment() }if (interactive()) { get_colombia_unemployment() }
Retrieves selected, essential information about Colombia using the REST Countries API. The function returns a tibble with core details such as population, area, capital, region, and official language(s).
See the API documentation at https://restcountries.com/. Example API usage: https://restcountries.com/v3.1/name/colombia?fullText=true.
get_country_info_co()get_country_info_co()
The function sends a GET request to the REST Countries API. If the API returns data for Colombia,
the function extracts and returns selected fields as a tibble. If the request fails or
Colombia is not found, it returns NULL and prints a message.
A tibble with the following 8 columns:
name_common: Common name of the country.
name_official: Official name of the country.
region: Geographical region.
subregion: Subregion within the continent.
capital: Capital city.
area: Area in square kilometers.
population: Population of the country.
languages: Languages spoken in the country, as a comma-separated string.
Requires internet connection. The data is retrieved in real time from the REST Countries API.
REST Countries API: https://restcountries.com/
if (interactive()) { get_country_info_co() }if (interactive()) { get_country_info_co() }
This dataset, indigenous_vocabulary_df, is a data frame containing a comparative vocabulary (a "wordlist") for 69 indigenous languages of Colombia, originally compiled by Huber & Reed (1992). The dataset provides lexical correspondences across multiple languages, supporting linguistic, anthropological, and historical research.
data(indigenous_vocabulary_df)data(indigenous_vocabulary_df)
A data frame with 27,521 observations and 4 variables:
Gloss or concept represented in the wordlist (factor with 366 levels)
Word corresponding to the concept in the given language (character)
Name of the language or variety (factor with 71 levels)
Tokenized form of the counterpart (character)
The dataset name has been kept as 'indigenous_vocabulary_df' to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'df' indicates that the dataset is a data frame object. The original content has not been modified in any way.
Data taken from the qlcMatrix package version 0.9.9
This dataset, Medellin_rain_tbl_df, is a tibble containing information about rainfall measurements in Medellin, Colombia, including station identifiers, geographical coordinates, date of observation, and rainfall values.
data(Medellin_rain_tbl_df)data(Medellin_rain_tbl_df)
A tibble with 185,705 observations and 8 variables:
Numeric identifier for the rain observation station.
Numeric value representing the latitude of the station.
Numeric value representing the longitude of the station.
Date of the rainfall observation.
Numeric year of the observation.
Numeric month of the observation.
Numeric day of the observation.
Numeric value representing the amount of rainfall in millimeters.
The dataset name has been kept as Medellin_rain_tbl_df to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'tbl_df' indicates that the dataset is a tibble. The original content has not been modified in any way.
Originally taken from the tidychangepoint package version 0.0.1.
This dataset, municipalities_tbl_df, is a tibble containing the list of municipalities of Colombia and their corresponding departments, ordered alphabetically.
data(municipalities_tbl_df)data(municipalities_tbl_df)
A tibble with 1,141 observations and 2 variables:
Name of the department (character)
Name of the municipality (character)
The dataset name has been kept as 'municipalities_tbl_df' to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'tbl_df' indicates that the dataset is a tibble object. The original content has not been modified in any way.
Data obtained from Kaggle: https://www.kaggle.com/datasets/cavp95/municipios-colombia
This dataset, school_levels_df, is a data frame containing a contingency table that classifies schools in Colombia by department and level of performance of their students. The dataset summarizes counts of schools across different performance categories in three main subjects: communication, mathematics, and science.
data(school_levels_df)data(school_levels_df)
A data frame with 29 observations and 12 variables:
Number of schools with communication results at the inferior level (numeric)
Number of schools with communication results at the low level (numeric)
Number of schools with communication results at the medium level (numeric)
Number of schools with communication results at the high level (numeric)
Number of schools with mathematics results at the inferior level (numeric)
Number of schools with mathematics results at the low level (numeric)
Number of schools with mathematics results at the medium level (numeric)
Number of schools with mathematics results at the high level (numeric)
Number of schools with science results at the inferior level (numeric)
Number of schools with science results at the low level (numeric)
Number of schools with science results at the medium level (numeric)
Number of schools with science results at the high level (numeric)
The dataset name has been kept as 'school_levels_df' to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'df' indicates that the dataset is a data frame object. The original content has not been modified in any way.
Data taken from the FactoClass package version 1.2.9
This dataset, Tulua_Public_Schools_tbl_df, is a tibble containing detailed information about public schools located in the municipality of Tulua, Valle del Cauca, Colombia. It includes the name, location, contact information, and the geographical coordinates of each institution, as well as specific details about each school and its facilities.
data(Tulua_Public_Schools_tbl_df)data(Tulua_Public_Schools_tbl_df)
A tibble with 105 observations and 8 variables:
Numeric code representing the educational institution's DANE code.
Character string representing the name of the public school.
Character string representing the name of the specific school location or branch.
Numeric code representing the DANE code of the specific school branch.
Character string representing the phone number of the school.
Character string representing the email addresses of the school.
Character string representing the physical address of the school.
Character string representing the geographical coordinates of the school.
The dataset name has been kept as Tulua_Public_Schools_tbl_df to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'tbl_df' indicates that the dataset is a tibble. The original content has not been modified in any way.
Originally taken from GOV.CO, url: https://www.datos.gov.co/Educaci-n/Listado-de-colegios-p-blicos-del-municipio-de-Tulu/scz9-f8ud/about_data
This dataset, vehicle_count_tbl_df, is a tibble containing information from a license plate recognition camera system designed to generate trends and metrics for traffic management decision-making. It includes data on the date, sensor name, type of vehicle, and the number of vehicles counted. The dataset was obtained from GOV.CO Datos Abiertos, last update on March 26, 2024.
data(vehicle_count_tbl_df)data(vehicle_count_tbl_df)
A tibble with 262,114 observations and 4 variables:
Date of the record (character)
Name of the sensor capturing the data (character)
Type of vehicle (Cars, Motorcycles, etc.) (character)
Number of vehicles counted (numeric)
The dataset name has been kept as 'vehicle_count_tbl_df' to avoid confusion with other datasets in the R ecosystem. This naming convention helps distinguish this dataset as part of the ColombiAPI package and assists users in identifying its specific characteristics. The suffix 'tbl_df' indicates that the dataset is a tibble object. The original content has not been modified in any way.
Data obtained from GOV.CO Datos Abiertos: https://www.datos.gov.co/Ciencia-Tecnolog-a-e-Innovaci-n/Conteo-de-Autos-y-Motos/s53k-ztax/about_data
This function lists all datasets available in the 'ColombiAPI' package. If the 'ColombiAPI' package is not loaded, it stops and shows an error message. If no datasets are available, it returns a message and an empty vector.
view_datasets_ColombiAPI()view_datasets_ColombiAPI()
A character vector with the names of the available datasets. If no datasets are found, it returns an empty character vector.
if (requireNamespace("ColombiAPI", quietly = TRUE)) { library(ColombiAPI) view_datasets_ColombiAPI() }if (requireNamespace("ColombiAPI", quietly = TRUE)) { library(ColombiAPI) view_datasets_ColombiAPI() }