We help you to get and organize information from public data or different websites with scrapping.


We structure databases with information from multiple databases in multiple formats. Organization of information and standardization of variables.

Visualization apps

We create public data visualization applications so that your users can know and explore databases. We use the latest technologies in data visualization to communicate information.


We implement artificial intelligence algorithms to facilitate your work with data, from predictive algorithms to pattern recognition.

Web specials

We develop interactive web specials based on data. The specials have different visual components to guide your readers. See examples of our specials.

About us

Datasketch is a digital platform of investigative and data journalism. Our portal allows journalists, data scientists, social scientists and citizens in general to learn and consult on data visualizations, tools, software and in-depth research on various short-term issues. We have free data tools and different projects to bridge the gap between data and citizenship that facilitates the democratization of knowledge and a critical review of social realities based on information contrasts.

Our team

Juan Pablo Marín

Electronic engineer with a master's degree in computational statistics. Expert in data science with applications in multiple areas such as economics, hydrology and journalism.

Camila Achuri

Statistics and expert in R programming language. She has developed various applications of data visualization in mobility and open data subjects.

Juliana Galvis

Politologist and candidate for a Master in Digital Humanities. She is currently leading the development of the Who Is database, as well as supporting journalistic research and the creation of databases.

David Daza

Bachelor of Electronics. Expert in development of applications and websites with emphasis on data journalism and content management of multiple databases.

Verónica Toro

Anthropologist and researcher. Responsible for the management and organization of the data-community in Colombia and Latin America and provide support in journalistic investigations and the creation of databases.

Mariana Villamizar

Systems engineer and designer. Expert in user experience, data visualization and graphic communication. Feminist.


Banana plantations

March 07, 2019

The massacres occurred in Colombia during the colombian armed conflict left 24,518 victims

According to the Observatory of Memory and Conflict by the National Historical Memory Center, from 1958 to september 2018, there were 24,518 victims of massacres in Colombia.

The Observatory documents acts of violence occurred within the framework of the colombia armed conflict, integrating social and institutional sources and unificating the registration and classification criteria, with the purpose of clarify the history and recognize the plurality of memories.

This information is extracted from a complex exercise of gathering information about the colombian armed conflict, which includes 592 sources and 10,236 databases and documents, which contribute to the clarification of the history and the recognition of plurality of reports on this issue in the country.

This information is derived from five characteristics of the documentation processes on the context of armed conflict in Colombia:

  • High fragmentation of the information registers that have been built from the public policy or from civil society initiatives

  • Absence of official information registers.

  • High information sub-registers that vary according to the modality, the historical moment, region or profile of the victim.

  • The absence of an adequate registration that has led the fragmentation of information, dispersion of efforts and / or keeping records that are not comparable between institutions.

  • Hiding strategies of the armed actors.

The Observatory documents the circumstances of the way, time and place of the events, the perpetrators and the victims of the armed conflict.

In that period of time, more than 4 thousand massacres occurred, that left a total of 23,937 civilians, 480 combatants and 30 victims without information. The years with greater upsurge of these acts were in 1997 with 214 events and 406 events in 2001.

Source: CNMH, Databases, Memory and Conflict Observatory, in

Those responsible for these acts were mostly paramilitary groups (2,113 incidents), followed by guerrillas (757 events) and state agents (296 incidents).

Source: CNMH, Databases, Memory and Conflict Observatory, in


The data can be explored and downloaded here. Also, other types of information can be explored, such as military actions, selective assassinations, kidnappings, forced disappearance, and others.


Data team

7 legal

March 09, 2019
7 legal


March 03, 2019

8m: names of iconic women

March 07, 2019
8m en

1025 Stains

March 10, 2019
1025 Stains

It doesn’t make sense

March 08, 2019
It doesn’t make sense

Oil Rivers

March 08, 2019
Oil Rivers

Little Mothers in Colombia

March 04, 2019
Little Mothers in Colombia