Continue Reading

Using BigQuery To Explore Large Log Files: Exploring the Wayback Machine

Kalev's latest Forbes piece explores what is really in the Internet Archive's Wayback Machine and the nuance and biases of…

Continue Reading

One-Click Network Visualization With BigQuery+Gephi

For his latest Forbes piece, Kalev took a network visualization developed by the BBVA Research Emerging Markets Unit of how…

Continue Reading

Mapping at Infinite Scale: Terascale and Petascale Cartography and Big Data in the BigQuery Era

This past Saturday, on Halloween, the GDELT 2.0 Global Knowledge Graph reached 150 million articles in 65 languages from just…

Continue Reading

New One Minute Maps: BigQuery UDF + CartoDB

We're incredibly excited to announce today the ability to generate rich interactive geographic maps in less than 60 seconds from…

Continue Reading

Google BigQuery + 3.5M Books: Sample Queries

To help you get started with the latest GDELT collection of 3.5 million digitized historical English language books published from…

Continue Reading

3.5 Million Books 1800-2015: GDELT Processes Internet Archive and HathiTrust Book Archives and Available In Google BigQuery

Today we are enormously excited to announce that more than 3.5 million digitized books stretching back two centuries, encompassing the…

Continue Reading

Advanced Mapping with the GDELT API + BigQuery

Today we feature the second half of the announcement of our incredible new collaboration with online mapping platform CartoDB to make…

Continue Reading

Understanding Global Conflict And Disasters Through BigQuery: Advanced Examples

BigQuery makes it possible to explore data at scales limited really only by your imagination and to help get you…

Continue Reading

Google BigQuery + GKG 2.0: Sample Queries

Making the GDELT Global Knowledge Graph available in Google BigQuery has been one of the most-requested features since the debut…

Continue Reading

GDELT+BigQuery: Understanding the World with SQL

Check out this amazing video created by Felipe Hoffa, Developer Advocate on big data at Google, that showcases how GDELT is…

Continue Reading

GDELT and Google BigQuery: Understanding the World

Take a look at this incredible teaser video Google put together showcasing how GDELT makes use of the enormous power…

Continue Reading

Exploring GDELT Using Tableau and BigQuery

The latest version of Tableau offers direct integration with Google BigQuery, meaning you can leverage Tableau's incredibly powerful point-and-click visual analytics…

Continue Reading

Towards Psychohistory: Uncovering the Patterns of World History with Google BigQuery

Two months ago we unveiled in Google BigQuery access to the entire quarter-billion-record GDELT Event Database, which monitors the world’s…

Continue Reading

Visualizing GDELT In Tableau Using BigQuery

Julius Concepion shows off a screen capture visualizing the entire quarter-billion-record GDELT event database in realtime using Tableau and Google's…

Continue Reading

GDELT: World's largest event dataset now publicly available in Google BigQuery

We are phenomenally excited to announce that the entire quarter-billion-record GDELT Event Database is now available as a public dataset…

Continue Reading

Video: Planetary Scale AI: Watching, Visualizing And Forecasting The Entire World In Realtime

The video of my talk at the Americas Google Developer Experts (GDE) Summit following Google I/O 2025 is now available!…

Continue Reading

A First Glimpse Of Using Language Detection To Identify Language Examples From The TV News Archive

A year ago we explored applying language detection to selections from the Chirp-generated ASR transcripts of the TV News Archive,…

Continue Reading

Planetary Scale AI: Watching, Visualizing And Forecasting The Entire World In Realtime

It was a tremendous honor to speak at the Americas Google Developer Experts (GDE) Summit last week to my fellow…

Continue Reading

Behind The Scenes: A Look At 16 Years Of Advertising Density On Television News

We are tremendously excited to announce today the completion of our analysis of captioning mode information across the totality of…

Continue Reading

Behind The Scenes: Identifying Mismatches Between Expected And Real Video File Durations & Single Version Of The Truth (SVOT)

One of the most complex and time-consuming aspects of working with vast historical archives is diagnosing and addressing the myriad…

Continue Reading

A Digital Twin Glimpse At The Internet Archive's TV News Archive: 27 Billion Seconds Over 10.9 Million Broadcasts From 327 Channels In 50+ Countries & 150+ Languages Over A Quarter-Century

Using our new BigQuery + Bigtable GCS digital twin, we can look across the entire Internet Archive's TV News Archive…

Continue Reading

Compiling A List Of All Non-News Broadcasts In The TV News Archive From Business Channels Over The Past Decade: Part 2

Last month we compiled a list of distinct show names marked as non-news from each of the three business news…

Continue Reading

Leveraging Bigtable's Versioning To Visualize An Evolving Video Archive Over Time & Prioritize Reprocessing

Yesterday we examined how we use BigQuery to perform archive-scale operational summaries of our Bigtable-based digital twin to visualize the…

Continue Reading

A Timeline Of The TV News Archive: 214 Channels Over A Quarter Century

Earlier this week we made a table tallying the total number of broadcasts and seconds of airtime preserved by the…