Search Results for: bigquery
One-Click Network Visualization With BigQuery+Gephi
For his latest Forbes piece, Kalev took a network visualization developed by the BBVA Research Emerging Markets Unit of how…
Mapping at Infinite Scale: Terascale and Petascale Cartography and Big Data in the BigQuery Era
This past Saturday, on Halloween, the GDELT 2.0 Global Knowledge Graph reached 150 million articles in 65 languages from just…
New One Minute Maps: BigQuery UDF + CartoDB
We're incredibly excited to announce today the ability to generate rich interactive geographic maps in less than 60 seconds from…
Google BigQuery + 3.5M Books: Sample Queries
To help you get started with the latest GDELT collection of 3.5 million digitized historical English language books published from…
3.5 Million Books 1800-2015: GDELT Processes Internet Archive and HathiTrust Book Archives and Available In Google BigQuery
Today we are enormously excited to announce that more than 3.5 million digitized books stretching back two centuries, encompassing the…
Advanced Mapping with the GDELT API + BigQuery
Today we feature the second half of the announcement of our incredible new collaboration with online mapping platform CartoDB to make…
Understanding Global Conflict And Disasters Through BigQuery: Advanced Examples
BigQuery makes it possible to explore data at scales limited really only by your imagination and to help get you…
Google BigQuery + GKG 2.0: Sample Queries
Making the GDELT Global Knowledge Graph available in Google BigQuery has been one of the most-requested features since the debut…
GDELT+BigQuery: Understanding the World with SQL
Check out this amazing video created by Felipe Hoffa, Developer Advocate on big data at Google, that showcases how GDELT is…
GDELT and Google BigQuery: Understanding the World
Take a look at this incredible teaser video Google put together showcasing how GDELT makes use of the enormous power…
Exploring GDELT Using Tableau and BigQuery
The latest version of Tableau offers direct integration with Google BigQuery, meaning you can leverage Tableau's incredibly powerful point-and-click visual analytics…
Towards Psychohistory: Uncovering the Patterns of World History with Google BigQuery
Two months ago we unveiled in Google BigQuery access to the entire quarter-billion-record GDELT Event Database, which monitors the world’s…
Visualizing GDELT In Tableau Using BigQuery
Julius Concepion shows off a screen capture visualizing the entire quarter-billion-record GDELT event database in realtime using Tableau and Google's…
GDELT: World's largest event dataset now publicly available in Google BigQuery
We are phenomenally excited to announce that the entire quarter-billion-record GDELT Event Database is now available as a public dataset…
A Digital Twin Glimpse At The Internet Archive's TV News Archive: 27 Billion Seconds Over 10.9 Million Broadcasts From 327 Channels In 50+ Countries & 150+ Languages Over A Quarter-Century
Using our new BigQuery + Bigtable GCS digital twin, we can look across the entire Internet Archive's TV News Archive…
Compiling A List Of All Non-News Broadcasts In The TV News Archive From Business Channels Over The Past Decade: Part 2
Last month we compiled a list of distinct show names marked as non-news from each of the three business news…
Leveraging Bigtable's Versioning To Visualize An Evolving Video Archive Over Time & Prioritize Reprocessing
Yesterday we examined how we use BigQuery to perform archive-scale operational summaries of our Bigtable-based digital twin to visualize the…
A Timeline Of The TV News Archive: 214 Channels Over A Quarter Century
Earlier this week we made a table tallying the total number of broadcasts and seconds of airtime preserved by the…
Cataloging The TV News Archive By Channel Over The Past Quarter-Century: 8 Million Broadcasts & 5.65M Hours From 214 Channels
As we continue to analyze, explore and examine the Internet Archive's TV News Archive's insights into our global world, we…
Charting The Internet Archive TV News Archive's Collection By Location Over The Past Quarter-Century
The Internet Archive's TV News Archive has preserved television news coverage from more than 50 countries and territories over the…
Charting The TV News Archive's Transition From SD To HD Video Resolution
Earlier this week we examined the storage growth of the Internet Archive's TV News Archive over the past quarter-century, charting…
Charting The TV News Archive's Belarusian, Russian & Ukrainian Archive
Continuing our series using BigQuery to analyze our Bigtable-based GCS digital twin, how can we use this same approach to…
What Using LLMs To Filter Television News EPG Show Names For "News/Not News" Teaches Us About The Severe Limits Of GenAI
One of the most basic and mind-numbing tasks in analyzing global television news coverage involves cataloging each broadcast show as…
Generative AI Experiments: Asking Gemini Ultra To Reformat BigTable's CBT CLI Output Into JSON
GCP has a wealth of data storage offerings, ranging from full-fledged warehouse and database platforms like BigQuery and Spanner to…