GDELT events by target country, daily

Daily GDELT event totals by the country of the actor on the receiving end of each event (Actor2): events, articles and summed tone. Country codes are CAMEO three-letter codes such as USA and GBR.

Table: demo.geopolitics.gdelt_daily_actor2
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, actor_country_code, event_count, articles, tone_sum
  FROM demo.geopolitics.gdelt_daily_actor2
 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 countries are most often on the receiving end?

SELECT actor_country_code, SUM(event_count) AS events
  FROM demo.geopolitics.gdelt_daily_actor2
 WHERE actor_country_code IS NOT NULL
 GROUP BY actor_country_code
 ORDER BY events DESC
 LIMIT 10

Edit in Studio

Which target countries were busiest on the latest day?

SELECT day, actor_country_code, event_count, articles
  FROM demo.geopolitics.gdelt_daily_actor2
 ORDER BY day DESC, event_count DESC
 LIMIT 10

Edit in Studio

Schema

Columns

Column	Type
day	TIMESTAMP
actor_country_code	VARCHAR
tone_sum	FLOAT64
articles	INT64
event_count	INT64