GDELT events by type, daily

Daily GDELT event totals by CAMEO root event code — the top-level kind of event, from 01 (make public statement) to 20 (use unconventional mass violence) — with the number of articles reporting them.

Table
demo.geopolitics.gdelt_daily_topic
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, event_root_code, event_count, articles
  FROM demo.geopolitics.gdelt_daily_topic
 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 kinds of event are reported most?

SELECT event_root_code, SUM(event_count) AS events
  FROM demo.geopolitics.gdelt_daily_topic
 GROUP BY event_root_code
 ORDER BY events DESC
 LIMIT 10
Edit in Studio

How many threats (root code 13) were reported each day?

SELECT day, event_count, articles
  FROM demo.geopolitics.gdelt_daily_topic
 WHERE event_root_code = '13'
 ORDER BY day DESC
 LIMIT 7
Edit in Studio
Schema

Columns

ColumnType
dayTIMESTAMP
event_root_codeVARCHAR
articlesINT64
event_countINT64