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
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:
|
1 2 3 |
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.