How to Query GDELT's Dataset Using Google BigQuery
Part II: Set Up BigQuery, Run Your First GDELT Query, and Visualise the Results
Welcome back, the OSINT Jobs Team here.
This is the second in a series on GDELT.
Last issue we covered the API access. This issue we go into Google BigQuery. We’ll show you how to access GDELT’s full dataset for free, query it using SQL, and apply a structured analytical framework to a real-world case study.
As always, the latest tradecraft tips and industry news. Nothing older than seven days. Practical and ready to use today.
Missed last week’s newsletter?
From the OSINT Jobs Team
1. Our Assessment Platform
Hiring for OSINT roles? Reach out: contact@osint-jobs.com. We'll walk you through our assessment platform and advertise your role — all at no cost.
2. Our OSINT Careers Taxonomy is live
Built on five years of in-house research and thousands of real job descriptions, our career taxonomy maps the industry and helps you find your path. Check it out: https://www.osint-jobs.com/osint-careers
3. OSMOSISCon 2026
For those in the US, the OSMOSISCon Career Fair on 31 May 2026 in Bonita Springs, Florida connects sponsors and exhibitors directly with OSINT professionals across corporate, government, law enforcement, and military sectors.
Set Up BigQuery, Query GDELT, and Start Analysing Global Media Coverage in Minutes
This is the second in a series on The GDELT Project. Supported by Google Jigsaw, GDELT monitors broadcast, print, and web news in over 100 languages from nearly every country in the world.
This issue goes further. We set up Google BigQuery, explore GDELT's two core datasets, and run our first SQL query against real data. We use US-Iran media coverage as a live use case and build a visualisation from the results.
As our ongoing research into open source intelligence job descriptions confirms, data analysis is one of the most in-demand skills in the field. This issue shows you what that looks like in practice.
