What are the primary ways to access Open Government, Colombia data programmatically?

The primary ways are through officially recommended libraries like sodapy (Python) and RSocrata (R), or by directly accessing dataset endpoints (often JSON or CSV) using standard HTTP requests.

Do I need an API key to access Open Government, Colombia datasets?

Generally, no API key is required for accessing public datasets on datos.gov.co. Some Socrata platforms allow for an optional application token to manage rate limits, but it's not mandatory for basic public data access.

What programming languages are officially supported for Open Government, Colombia data access?

Python (via `sodapy`) and R (via `RSocrata`) are the primary languages with officially recognized or recommended libraries for interacting with the underlying Socrata platform used by datos.gov.co.

Where can I find the dataset identifiers for use with SDKs?

Dataset identifiers are typically found on the specific dataset's page on datos.gov.co. They are often part of the dataset's URL or listed in the 'API' section of the dataset details.

Are there community-developed SDKs for other languages?

Yes, while not officially endorsed, the community may develop libraries or scripts for other languages. These often use general HTTP client libraries to interact with the Socrata API endpoints. It is recommended to check their maintenance status and community support.

Is there a cost associated with using Open Government, Colombia SDKs or accessing the data?

No, access to Open Government, Colombia's public datasets and the use of the recommended SDKs/libraries for data retrieval is free of charge.

How can I contribute to the Open Government, Colombia SDK ecosystem?

Developers can contribute by building new libraries, improving existing community tools, creating documentation or tutorials, and sharing examples on platforms like GitHub. Engaging with the open data community can also identify needs for new tools.

Open Government, Colombia SDKs & Libraries (2026)

SDKs overview

Open Government, Colombia provides access to a wide range of public datasets through its national open data portal, datos.gov.co. While not a traditional API provider in the sense of a service like Stripe's API documentation or Google Maps Platform, the platform offers programmatic methods for data retrieval. These methods often involve direct downloads, CSV/JSON endpoint access, or specialized libraries built by the community to interact with the data portal's structure. The primary goal of these tools is to enable developers, researchers, and data analysts to integrate public information into their applications, analyses, and visualizations efficiently.

The datasets hosted on datos.gov.co cover diverse sectors, including economy, health, education, and environment. Access to these datasets is generally unrestricted and does not require API keys or authentication for public information. However, users are encouraged to review the specific terms of use for individual datasets as defined by the data providers. The ecosystem of tools supporting Open Government, Colombia data access includes officially recognized libraries and a growing collection of community-contributed packages that simplify data ingestion and manipulation.

Official SDKs by language

Open Government, Colombia primarily supports programmatic access through data endpoints and provides guidance for common data science languages. While a formal, universally branded "SDK" might not be present in the same way as commercial API platforms, specific libraries are endorsed or maintained to facilitate interaction with the datasets available on datos.gov.co.

Python

The sodapy library is widely used for interacting with Socrata Open Data APIs, which is the underlying platform for datos.gov.co. It simplifies querying and retrieving data from datasets exposed through Socrata endpoints.

R

For R users, the RSocrata package provides similar functionality to sodapy, allowing R programmers to access and manipulate data directly from Socrata-powered open data portals, including Colombia's.

The following table summarizes the officially supported or recommended libraries:

Language	Package Name	Description	Maturity
Python	`sodapy`	Client for Socrata Open Data APIs, facilitating data queries and retrieval.	Stable, actively maintained
R	`RSocrata`	R client for Socrata Open Data APIs, supporting data access and manipulation.	Stable, community-supported

Installation

Installation of these libraries typically follows standard package management procedures for their respective languages.

Python (sodapy)

To install sodapy, use pip, the Python package installer. Ensure you have Python and pip installed on your system. For more details on Python installation, consult the official Python documentation.

pip install sodapy

R (RSocrata)

To install RSocrata, use the install.packages() function within your R environment. For guidance on setting up R, refer to the CRAN project documentation.

install.packages("RSocrata")

Quickstart example

These examples demonstrate how to connect to a public dataset on datos.gov.co and retrieve initial records using the recommended libraries.

Python Quickstart (sodapy)

This Python example uses sodapy to fetch the first few records from a sample dataset. Replace the placeholder DOMAIN and DATASET_IDENTIFIER with actual values from datos.gov.co. The APP_TOKEN is optional for public datasets but can be used for rate limiting or tracking API usage if provided by Socrata.

from sodapy import Socrata

# Unauthenticated client (no app token, public data can be accessed this way)
# Replace 'www.datos.gov.co' with the actual domain if different
domain = "www.datos.gov.co"
dataset_identifier = "YOUR_DATASET_IDENTIFIER_HERE" # e.g., "y29x-9p8r"

# Example: Client reads by default the environment variable APP_TOKEN
# client = Socrata(domain, None)

# Or provide it directly:
# client = Socrata(domain, app_token="YOUR_APP_TOKEN")

# To access public data, an app token is often not necessary.
client = Socrata(domain, None)

# Fetch first 2000 results, or set a lower limit for testing
results = client.get(dataset_identifier, limit=10)

# Convert to pandas DataFrame for easier manipulation (optional)
import pandas as pd
results_df = pd.DataFrame.from_records(results)

print(f"Retrieved {len(results_df)} records:")
print(results_df.head())

# Close the client session
client.close()

To find a DATASET_IDENTIFIER, navigate to a dataset's page on datos.gov.co. The identifier is typically part of the URL (e.g., https://www.datos.gov.co/resource/y29x-9p8r.json) or listed in the API documentation section of the dataset page.

R Quickstart (RSocrata)

This R example uses RSocrata to retrieve data from a dataset on datos.gov.co. Similar to the Python example, replace the placeholder URL with the actual Socrata endpoint for your chosen dataset.

# Install RSocrata if you haven't already
# install.packages("RSocrata")

library(RSocrata)

# Replace with the actual URL of the dataset's Socrata API endpoint
# You can find this by clicking 'API' on a dataset page on datos.gov.co
dataset_url <- "https://www.datos.gov.co/resource/YOUR_DATASET_IDENTIFIER_HERE.json"

# Example: for dataset 'y29x-9p8r'
# dataset_url <- "https://www.datos.gov.co/resource/y29x-9p8r.json"

# Fetch data
data <- read.socrata(dataset_url, num_results = 10)

# Display the first few rows of the data
print(head(data))

# Get the number of rows retrieved
cat(paste0("Retrieved ", nrow(data), " records.
"))

Community libraries

Beyond the officially recommended tools, the open-source community often develops libraries and wrappers that cater to specific needs or integrate with other data analysis ecosystems. These libraries might offer specialized parsing, visualization components, or convenience functions tailored for Colombian public data.

Data Connectors for BI Tools: While not strictly programming libraries, various community-driven connectors and templates exist to link tools like Power BI, Tableau, or Google Data Studio directly to Socrata-powered portals, allowing for visual exploration of the data without extensive coding.
Language-Specific Wrappers: Developers in languages like JavaScript, Java, or Go might create their own clients to interact with the Socrata API endpoints, leveraging general-purpose HTTP client libraries rather than specialized SDKs. For instance, a JavaScript developer might use Fetch API to retrieve JSON data from a dataset endpoint.
Specialized Data Cleaning/Transformation: Some community projects focus on cleaning, transforming, or enriching specific datasets from datos.gov.co, addressing common data quality issues or integrating with other data sources. These are often shared as scripts or notebooks on platforms like GitHub or Kaggle.

When using community-contributed libraries, it is advisable to check their maintenance status, documentation, and community support. These resources can provide valuable functionality but may not always align with the latest platform changes or official support channels. Users are encouraged to explore repositories on platforms like GitHub by searching for keywords such as "Colombia open data," "datos.gov.co," or "Socrata API" alongside their preferred programming language to discover relevant community projects.