Socioeconomic Tracker Using Unconventional Data
Joint Research Centre
@ecjrc.f7be47f7_49a2_44e8_9dc8_043735af4139
Joint Research Centre
@ecjrc.f7be47f7_49a2_44e8_9dc8_043735af4139
CREATE TABLE news_data_from_gdelt (
"date" TIMESTAMP,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"tone_doc_count" VARCHAR,
"popularity_rate" VARCHAR,
"tone_avg" VARCHAR,
"tone_w_avg" VARCHAR,
"tone_cum" VARCHAR,
"amd1code" VARCHAR,
"country" VARCHAR,
"area" VARCHAR,
"ref_time" VARCHAR,
"topic" VARCHAR
);
CREATE TABLE web_searches_data (
"indicator" VARCHAR,
"category_name" VARCHAR,
"category" BIGINT,
"geo" VARCHAR,
"date" VARCHAR,
"value_cat_sum" DOUBLE,
"value_cat_mean" DOUBLE
);
CREATE TABLE newspaper_sentiment (
"date" TIMESTAMP,
"topic" VARCHAR,
"country" VARCHAR,
"volume" BIGINT,
"sentiment" DOUBLE
);
Anyone who has the link will be able to view this.