The GDELT Project

VGKG 2.0 Now Available In Partitioned BigQuery Table

As the GDELT Visual Global Knowledge Graph (VGKG) has grown to just over 287 million images totaling 3.2TB of JSON data, BigQuery is one of the few ways of working with the full dataset, but you can quickly exceed your monthly BigQuery quota due to the table's immense size. To address this, we have rolled out a new partitioned version of the table, meaning you can now BigQuery's partitioning operators to query individual days or day ranges and examine only the data from those days.