GDELT coverage by update batch

How much each GDELT update batch — published every 15 minutes — added: the number of events and of articles reporting them.

Query it in Studio Use the OData API

Preview

The first ten rows

Live from the table, no sign-in needed.

SELECT date_added, event_count, articles
  FROM demo.geopolitics.gdelt_coverage_by_batch
 LIMIT 10

Example questions

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

SELECT date_added, event_count, articles
  FROM demo.geopolitics.gdelt_coverage_by_batch
 ORDER BY date_added DESC
 LIMIT 10

Edit in Studio

SELECT date_added, event_count, articles
  FROM demo.geopolitics.gdelt_coverage_by_batch
 ORDER BY event_count DESC
 LIMIT 10

Edit in Studio

Schema