Gdelt GKG 2.1 Cheat Sheet

I copy a part of the gdelt dataset to a local mysql database. The field definition is the same as in the original dataset. Below a short field description of the Gdelt table gkg v 2.1 (taken from the original paper). Not every column is copied in the local mysql table, note field InDatacoll: 1 = yes, 0 = no. Currently i have no regular updates for this table. I plan to have the last 3 weeks accessible.

GKGRECORDID used as primary key and for monthly partitioning.

The original Categogy List .

About ralf

I studied Geology at University Erlangen and got my PhD (bio-nanotechnology) at TU Dresden. In my spare time i program simulations and tinker around with data prediction methods. Frisbee is my favorite sport and i play guitar when my friends and i meet to make some music.
This entry was posted in database, gdelt. Bookmark the permalink.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.