Search Results for: bigquery
A Daily Timeline Of Key Vaccine Topics In 2021 Through A TF-IDF BigQuery Analysis Of The Global Relationship Graph
What are the most significant words and phrases associated with vaccines by day thus far this year? To explore this…
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…