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:…

Continue Reading

Visual Global Entity Graph 2.0: Now Available In BigQuery

The Visual Global Entity Graph 2.0 dataset is now available in BigQuery, allowing complex at-scale queries in seconds! gdelt-bq.gdeltv2.vgegv2_iatv

Continue Reading

Using BigQuery DML & External Temporary Table Querying For Realtime Updates

Over the coming weeks GDELT's television-related BigQuery tables will begin loading data live as it is processed (as it rolls…

Continue Reading

What Can 101 Billion Words, The NLP API And BigQuery Tell Us About The Part Of Speech Patterns Of The English Language?

The massive new 101-billion-token Web Part of Speech dataset annotated by Google's Cloud Natural Language API released yesterday offers unprecedented…

Continue Reading

Using BigQuery's New ML.NGRAMS() Function To Construct 122 Years Of Book NGrams With One Line Of SQL

Back in 2016 we showed how you could construct ngrams from 122 years of public domain books (1800 to 1922)…

Continue Reading

Chyron Correlation As A Case Study Of BigQuery's Linguistic Analytics Potential

Since August 2017, the Internet Archive's Television News Archive has extracted the chyrons of CNN, MSNBC, Fox News and BBC News by OCR'ing…

Continue Reading

Television News Research Chyrons Datasets Now Available In BigQuery

We're excited to announce that both the original per-minute and new per-second resolution television news research chyron datasets are available…

Continue Reading

A By-Station Visual Chronology Of The Top Visual Themes Of Television Evening News 2010-2019 Using Cloud Video + BigQuery

Using the new visual entity graph constructed by having the Cloud Video API watch a decade of evening news broadcasts on…

Continue Reading

A By-Station Topical Chronology Of A Decade Of Television News Using Cloud Natural Language & BigQuery

Earlier today we showed how the Cloud Natural Language API could read through a decade of television news transcripts to…

Continue Reading

A Topical Chronology Of A Decade Of Television News Using Cloud Natural Language & BigQuery

Last week we unveiled the results of having Google's Cloud Natural Language API non-consumptively read through the transcripts of a…

Continue Reading

Mapping The Global Free Trade Network Through News Coverage Using BigQuery + Gephi

Last year BBVA showcased creating a global network of countries co-occurring in coverage relating to trade wars. Such powerful visualizations…

Continue Reading

Global Entity Graph (GEG) Neural Sentiment Dataset Now Available In BigQuery

UPDATE (1/21/2020): The GEG neural sentiment scores are now integrated into the core GEG dataset instead of a separate dataset….

Continue Reading

Terascale Graph Construction And Analysis In BigQuery

One of the most amazing aspects of BigQuery is not only its incredible speed and scale, but its versatility. Most…

Continue Reading

Constructing Trillion-Cooccurrence Graphs In BigQuery With A Single SQL Query

Earlier today we demonstrated the construction of a semantic graph representing 24.5-billion entity co-occurrences from the 11 billion entity annotations…

Continue Reading

Visualizing Entity Networks Through The GEG: BigQuery, Gephi & Cloud Natural Language API

What would it look like to visualize the co-occurrences of the 11 billion entities from more than 100 million English…