GDELT events by cooperation and conflict, daily

Daily GDELT event totals by CAMEO quad class — 1 verbal cooperation, 2 material cooperation, 3 verbal conflict, 4 material conflict — with articles and summed Goldstein scale.

Table
demo.geopolitics.gdelt_daily_quad_class
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, quad_class, event_count, articles, goldstein_sum
  FROM demo.geopolitics.gdelt_daily_quad_class
 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.

How do events split between cooperation and conflict?

SELECT quad_class, SUM(event_count) AS events
  FROM demo.geopolitics.gdelt_daily_quad_class
 GROUP BY quad_class
 ORDER BY quad_class
Edit in Studio

How much material conflict was reported each day this week?

SELECT day, event_count, articles
  FROM demo.geopolitics.gdelt_daily_quad_class
 WHERE quad_class = 4
 ORDER BY day DESC
 LIMIT 7
Edit in Studio
Schema

Columns

ColumnType
dayTIMESTAMP
quad_classINT64
articlesINT64
goldstein_sumFLOAT64
event_countINT64