GDELT events by country, daily

Daily totals from the GDELT event stream by the country where events took place: number of events, the articles reporting them, and summed tone. Country codes are FIPS 10-4 (UK is the United Kingdom, CH is China).

Table
demo.geopolitics.gdelt_daily_country
Source
The GDELT Project
Query it in Studio Use the OData API
Preview

The first ten rows

Live from the table, no sign-in needed.

SELECT day, action_geo_country_code, event_count, articles, tone_sum
  FROM demo.geopolitics.gdelt_daily_country
 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.

Where do the most reported events happen?

SELECT action_geo_country_code, SUM(event_count) AS events
  FROM demo.geopolitics.gdelt_daily_country
 WHERE action_geo_country_code IS NOT NULL
 GROUP BY action_geo_country_code
 ORDER BY events DESC
 LIMIT 10
Edit in Studio

How many events were recorded on each of the last seven days?

SELECT day, SUM(event_count) AS events, SUM(articles) AS articles
  FROM demo.geopolitics.gdelt_daily_country
 GROUP BY day
 ORDER BY day DESC
 LIMIT 7
Edit in Studio
Schema

Columns

ColumnType
dayTIMESTAMP
action_geo_country_codeVARCHAR
tone_sumFLOAT64
articlesINT64
event_countINT64