Google BigQuery Visualization: Mapping Big Spatial Data




The Client

GDELT is the largest, most comprehensive, and highest resolution open database of human society ever created. Creating a platform that monitors the world’s news media from nearly every corner of every country in print, broadcast, and web formats, in over 100 languages, every moment of every day and that stretches back to January 1, 1979 through present day.

The Challenge

The Global Geographic Graph now spans more than 1.7 billion location mentions in worldwide English language news coverage back to 2017. GDELT wanted a way to map the geography of the global news narrative.


Using CARTO’s BigQuery connector, The GDELT Project have been able to create interactive maps from their huge dataset, including a focus on news coverage in the context of COVID-19 at different points during the pandemic.


With CARTO you only need to enter a SQL query from BigQuery to connect your data & make it available on the platform—allowing you to easily visualize, perform spatial analyses, & build applications.

For more details on this customer story, read the full blog post.


Want to see how you can build similar maps?

Related content

UNHCR Lebanon: Nimble, Collaborative Rapid Response

The United Nations (UNHCR) employed CARTO to coordinate collaborative response efforts during the Syrian Refugee Crisis. Read the full story to find out more!

Read the story
Visualizing Linguistic Big Data for Deeper Insights

Read how SIL International, the leader in field linguistics, leveraged CARTO to digitally map their data and provide new, critical insights to their clients.

Read the story
Coffee Supply Chain Traceability

Read how Enveritas use CARTO to analyze the traceability & sustainability of coffee supply chains around the world.

Read the story