I copy parts of the original mentions dataset from the gdelt project into a mysql database for further evaluations. Below my table definition. The definition of the fields is of cause identical. Please also read the original paper: THE … Continue reading
Tag Archives: datasource
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
What did people search in Google? You can get the answer in google trends. If you want to compare your own data a little more advanced with the google trands data, you need an archive with a certain time and … Continue reading
Newspaper (or TV program or events from a city) are often published as rss feeds and are dumped in the rss_posts table. You can ask simple question like “Was my Organization mentioned reasonly?” or “How often is the keyword used”. … Continue reading