How to Query GDELT's Dataset Using Google BigQuery

Key Takeaways

• GDELT offers free, global news data via BigQuery.
• SQL query reveals US‑Iran media sentiment trends.
• Visualization built directly from query results.
• Data analysis tops OSINT job skill demand.
• Tutorial lowers entry barrier for open‑source intelligence.

Summary

OSINT Jobs released a tutorial showing how to access GDELT’s comprehensive news archive through Google BigQuery at no cost. The guide walks users through setting up the BigQuery environment, exploring the two core GDELT tables, and running a SQL query on US‑Iran media coverage, culminating in a visualisation of sentiment trends. It highlights the growing demand for data‑analysis skills in open‑source intelligence roles and promotes the OSINT Jobs career taxonomy and upcoming OSMOSISCon fair. The post also invites recruiters to advertise OSINT positions for free.

Pulse Analysis

The Global Database of Events, Language, and Tone (GDELT) now powers open‑source intelligence by cataloguing broadcast, print, and web news in over 100 languages. Its structured archive captures every major event, sentiment shift, and actor interaction, offering a depth that rivals paid news services. Google BigQuery hosts the full GDELT dataset at no cost, letting analysts execute petabyte‑scale SQL queries without managing infrastructure. This cloud‑native accessibility transforms raw global media into actionable intelligence for governments, corporations, and researchers alike.

The OSINT Jobs tutorial walks users through creating a BigQuery project, locating GDELT’s two core tables, and crafting a simple SELECT statement that isolates US‑Iran coverage for a chosen date range. By joining the event and mention tables, the query extracts article counts, tone scores, and source diversity, which the authors then plot in a time‑series chart. The hands‑on example demonstrates how a few lines of SQL can surface sentiment spikes around diplomatic incidents, providing a reproducible workflow that non‑technical analysts can adopt and extend to other geopolitical topics.

Beyond the technical walk‑through, the piece underscores a broader industry shift: data analysis has vaulted to the top of OSINT skill requirements, as reflected in the OSINT Jobs taxonomy and rising demand for analysts who can turn massive text streams into strategic insight. Free access to GDELT via BigQuery lowers the cost barrier for startups, NGOs, and academic teams, democratizing capabilities that once required costly subscriptions. As geopolitical risk intensifies, organizations that embed this workflow into their intelligence pipelines will gain faster situational awareness and a competitive edge.