Note: This is an early draft I wanted to put online, so I can talk with colleagues about it. I will refine it in the next weeks. Summary: Based on the events data from gdelt a graph can be plotted … Continue reading
Tag Archives: gdelt
Please also read the original paper: THE GDELT EVENT DATABASE DATA FORMAT CODEBOOK V2.0 From the paper: ” … Mentions table that records all mentions of each event. As an event is mentioned across multiple news reports, each of … Continue reading
When i first wanted to apply the LOAD DATA INFILE, my server said:
Error Code: 1290.
The MySQL server is running with the --secure-file-priv option
so it cannot execute this statement
His is a summary of GDELT Event Codebook V2.0, make sure you read this original paper. I partitioned on MonthYear.