Search Results for: bigquery
BigQuery + UDF = Identifying The Earliest Glimmers Of Covid-19
The GKG 2.0 is essentially a realtime metadata index over the world's news in 65 languages dating back to 2015….
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…
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…
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…
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…
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.
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…
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…