GDELT events between pairs of countries, daily

Daily GDELT event totals for each pair of countries — the initiating actor's and the target's — with summed Goldstein scale (how cooperative or conflictual) and tone.

Table: demo.geopolitics.gdelt_daily_actor_pair
Source: The GDELT Project
Rows
Updated

Query it in Studio Use the OData API

Preview

The first ten rows

Live from the table, no sign-in needed.

SELECT day, actor1_country_code, actor2_country_code, event_count, goldstein_sum, tone_sum
  FROM demo.geopolitics.gdelt_daily_actor_pair
 LIMIT 10

Example questions

Ask it something

Run any of these here, or open it in Studio to change the SQL. Studio is free to start: 100 queries a day.

Which pairs of countries interact most often?

SELECT actor1_country_code, actor2_country_code, SUM(event_count) AS events
  FROM demo.geopolitics.gdelt_daily_actor_pair
 WHERE actor1_country_code <> actor2_country_code
 GROUP BY actor1_country_code, actor2_country_code
 ORDER BY events DESC
 LIMIT 10

Edit in Studio

What has happened between Russia and Ukraine most recently?

SELECT day, actor1_country_code, actor2_country_code, event_count, goldstein_sum
  FROM demo.geopolitics.gdelt_daily_actor_pair
 WHERE actor1_country_code IN ('RUS', 'UKR') AND actor2_country_code IN ('RUS', 'UKR')
   AND actor1_country_code <> actor2_country_code
 ORDER BY day DESC, actor1_country_code
 LIMIT 10

Edit in Studio

Schema

Columns

Column	Type
day	TIMESTAMP
event_date	DATE
actor1_country_code	VARCHAR
actor2_country_code	VARCHAR
goldstein_sum	FLOAT64
tone_sum	FLOAT64
event_count	INT64