Search Results for: bigquery
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…
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…
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…
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…
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!
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…
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…
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…
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…
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…
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…
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,…
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…
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…
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…
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…
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…
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:…
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
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…
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…
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)…
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…
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…