Services

Data-capture

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

Data-cleaning

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.

Algorithms

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.

Andrea Cervera

Journalist responsible for writing articles, provide investigative support and community manager.

Mariana Villamizar

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

Contact

Oil Rivers

March 08, 2019

In Colombia, 3,7 million barrels of oil have been spilled, it would be enough to contaminate the Magdalena River for a year.

The design of the "Oil Rivers" t-shirt represents the 3.7 million barrels of oil that have been spilled in Colombia for more than 38 years that makes an equivalence with the amount of water that runs through the Magdalena River in a whole year.

 

An oil spill in which more than 1 barrel is spilled, impacts environmentally. A single barrel can contaminate 79.5 million liters of water. If we take the 3.7 million barrels that have been spilled in the last 38 years, the contaminated water is roughly equivalent to the water that passes through the Magdalena River for a year.

 

Oil production in Colombia began in 1921, 67 years later, in 1988, more than 73 wells had been drilled and oil spills have been present in Colombia since then.

 

“Not all registered spills reach bodies of water, some only affect soils” says Ecopetrol in response to a request of information we made on Datasketch. (Click here to read the full answer)

 

The causes of oil spills can, according to Ecopetrol, be the following:

  1. “Oil spills generated by acts of third party, among which are those generated by attacks on the oil infrastructure, the theft of refined or crude oil”.

  2. “Spills generated by operational cause, which as its name says, its cause is operational”.

  3. “Spills generated by acts of nature”

 

Since 1980, 3,7 million of barrels of oil spilled in Colombia have been registered by acts of third party and this is one of the few data that is being talked about.

 

“In 2017, environmental authorities and entities of the National Disaster Risk Management System were notified of 129 events with loss of product containment, associated with the transportation infrastructure of the CENIT (Company of transport of hydrocarbons, pipelines, polioducts and gas pipelines). Of these incidents: 119 were due to third party events, 8 of them due to operational causes and 2 due to fortuitous events.” (Sustainability Report, Ecopetrol, 2017)

 

In 63 of this spills, 29,723 barrels of oil were spilled, affected natural or artificial water bodies. That’s why, from Datasketch we say: we do not want rivers of oil! we want our water bodies and clean floors.

 

Napking calculation

Datasketch

Data team

Little Mothers in Colombia

March 04, 2019
Little Mothers in Colombia

7 legal

March 09, 2019
7 legal

5XX NOT FOUND en

March 03, 2019
5XX NOT FOUND en

8m en

March 09, 2019
8m en

1025 Stains

March 10, 2019
1025 Stains

It doesn’t make sense

March 08, 2019
It doesn’t make sense

Banana plantations

March 07, 2019
Banana plantations