Continue Reading

Google Cloud & Elastic: BigQuery And Elasticsearch – Insights At Scale

This fantastic talk by Elastic's Adam Quan, Principal Solutions Architect and Google's Matt Lescohier, Strategic Partner Manager, Databases, Global Partner…

Continue Reading

Flattening TV News NGrams Using BigQuery

The Television News NGrams 2.0 dataset records how many times a given word was spoken in a given 10 minute…

Continue Reading

TFIDF Using BigQuery + Radio News NGrams To Chart The Most Significant Phrases Per Day On BBC World Service In 2020

Earlier today we showed how TFIDF calculation over the Radio News NGrams dataset could be used to surface the most…

Continue Reading

TFIDF Using BigQuery + Radio News NGrams To Chart The Most Significant Words Per Day On BBC World Service In 2020

How might we use the new Radio News NGrams dataset to examine the Internet Archive's Radio News Archive's ASR of…

Continue Reading

Carto Blog: Google BigQuery Visualization: Mapping Big Spatial Data

Carto republished our new BigQuery+Carto tutorial and video on their blog! Read The Full Post.

Continue Reading

GDELT Tutorial: Using Carto's BigQuery Connector To Seamlessly Map Covid-19 News

The third in our GDELT Tutorial series, this video walks through our blog post from earlier this week, Using Carto's…

Continue Reading

Using Carto's BigQuery Connector To Seamlessly Map The Global Geographic Graph

The Global Geographic Graph now spans more than 1.7 billion location mentions in worldwide English language news coverage back to…

Continue Reading

Measuring Shot-Level Visual Similarity Of TV News Using The Video AI API & BigQuery

As we continue in our efforts to automatically segment television news broadcasts into their component stories, we've looked at shot-level…

Continue Reading

Advanced OCR Similarity Metrics Using BigQuery + Video AI To Segment Television Evening News

Yesterday we showed how a single SQL query in BigQuery can be used to segment a television news show by…

Continue Reading

Using BigQuery To Segment A Television Evening News Show Using Shot Changes + OCR Similarity

As we continue to look at new ways to segment television shows into their component stories, its worth noting the…

Continue Reading

GDELT Tutorials: Interactive Sentiment Mining With BigQuery!

The second in our new GDELT Tutorial series, this 6-minute video walks through sentiment mining using BigQuery!

Continue Reading

Using BigQuery DML & External Temporary Tables To Perform Realtime Reformatting Inserts For Television News Ngrams

As we prepare to release the 2.0 release of our television news ngrams dataset, a guiding design goal has been…

Continue Reading

BigQuery Turns 10!

Google's BigQuery platform, which underlies so much of GDELT's work on understanding the world around us, turned 10 today! As…

Continue Reading

Using BigQuery To Compile A Decade-Long Chronology Of Dr.'s On Television News

Yesterday we showed how a single SQL query in BigQuery could be used to compile a list of all of…

Continue Reading

Using BigQuery + Regex's On OCR'd Chyrons From The Cloud Video API To Compile A List Of "Dr."'s On TV News

Between an hour and a third of the airtime on CNN each day since Feb. 26th has mentioned "Dr." somewhere…

Continue Reading

Using BigQuery UDFs To Perform On-The-Fly NLP On OCR'd Chyrons From The Cloud Video API

Last year Felipe Hoffa demonstrated the use of the "compromise" JavaScript NLP library as a BigQuery UDF, applying it to…

Continue Reading

TFIDF Using BigQuery + Cloud Video AI To Chronicle Visual Trends In CNN Coverage In Covid-19

How has CNN's visual narrative changed over the course of the Covid-19 pandemic? One of the metrics we track in…

Continue Reading

Graphing Covid-19 Geographic News Timelines Using BigQuery

Using our massive new Covid-19 Geographic News Database, its possible with a simple SQL query to visualize geographic timelines. For example,…

Continue Reading

An Animated Map Of Global Covid-19 News Coverage With BigQuery + Carto

How did news coverage of Covid-19 spread across the world? Using our massive new Covid-19 Geographic News Database, it takes…

Continue Reading

One-Click Mapping Of Covid-19 News Coverage With BigQuery + Carto

How can you use the new Covid-19 Geographic News Database to map the locations mentioned in Covid-19 news coverage? With…

Continue Reading

Using BigQuery's New Limit-Free DML To Create Our Covid 19 Snippet Datasets

Over the past week and a half we've released two massive new datasets of news snippets (television news and online…

Continue Reading

Covid-19 Television And Online News Snippet Datasets Available In BigQuery

To help researchers explore the media narratives around the Covid-19 pandemic, we've produced two datasets consisting of brief snippets of…

Continue Reading

Using BigQuery To Surface The Dyadic Country Interactions Defining The Last 40 Years

What if, with a single SQL query, we could surface the most common dyadic relationships defining each year of the…

Continue Reading

Modernizing The 'Top Relationships By Year' And 'Protest Intensity' Queries From Legacy To Standard BigQuery SQL

In our original Google Cloud Platform blog post about GDELT, we offered two example SQL queries to get users started:…