Search Results for: bigquery
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…
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…
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…
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…
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….
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…
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…
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…
The Top Entities By Day Using BigQuery And The Cloud Natural Language API Through The GEG
The GDELT Global Entity Graph (GEG) dataset of 11 billion entities extracted by Google's Cloud Natural Language API from 103…
Querying The New Global Entity Graph (GEG) Datasets In BigQuery: Example Queries
Both the neural GEG (based on Google's Cloud Natural Language API) and classical GEG (based on a traditional HMM POS…
Charting Global English-Language Media Anxiety Through The News: BigQuery + WEB NGrams
Using the new Web News Ngram (WEB-NGRAM) dataset, it takes just a single line of SQL and Google BigQuery to…
Web News Ngram Datasets (WEB-NGRAM) Now Available In BigQuery
The new Web News Ngram datasets are now available in Google's BigQuery platform, updated every 15 minutes and stretching back…
Daily Updates To 'Master List Of Social Media In The News' In CSV And BigQuery
We are excited to announce that the 2016-2019 social media outlink dataset is now being updated daily! Every morning just…
Television News Ngram Datasets (TV-NGRAM) Now Available In BigQuery
The Television News Ngram datasets are now available in Google's BigQuery platform, updated every morning, making it possible to perform…
Television News Inventory Files Now Available In BigQuery
The Television News inventory files are now available in Google's BigQuery platform, updated every morning, making it possible to perform…
Charting The Emotions Of Television News: BigQuery + TV NGrams
The new Television News Ngram Datasets make an incredible range of new analyses possible. With just a single line of…
The Top Daily Terms By Station On American Television 2009-2019 Using BigQuery And TV Ngrams
Converting piles of unstructured text into structured tables like ngrams opens the door to all kinds of powerful new analyses…
Computing TF-IDF Scores From The TV Ngram Dataset In BigQuery
The ever-amazing Felipe Hoffa came up with the following BigQuery query that computes the TF-IDF scores for the new Television…
Google's AutoML And BigQuery ML: The Rise Of One-Click Hyperscale Machine Learning
The cloud is no longer just a place where AI experts go to pioneer the future or scarce deep learning…
Using BigQuery As A Lens To Explore Large Datasets
One of the most incredible aspects of the modern cloud is the way in which it accelerates massive adhoc data…
Google's BigQuery Brings GIS Into The Petascale Era
BigQuery’s unique ability to couple petascale query infrastructure with thousands or even tens of thousands of cores and apply it…
Merging Billions of URLS Using BigQuery
One of the most amazing things about Google's BigQuery service is its nearly infinite scalability and the sheer speed at…
Using BigQuery To Make A 38 Year Timeline Of World Conflict From Half A Billion Records In 3 Seconds
Three years ago we showed off the results of a singularly incredible BigQuery query, courtesy of the one and only…
A First Look At Three Weeks Of The Global Frontpage Graph (GFG) Through BigQuery
The newest addition to the GDELT family, the GDELT 3.0 Global Frontpage Graph (GFG) has been running every hour for…