Socioeconomic Tracker Using Unconventional Data

Joint Research Centre

@ecjrc.f7be47f7_49a2_44e8_9dc8_043735af4139

Newspaper Sentiment

@ecjrc.f7be47f7_49a2_44e8_9dc8_043735af4139.newspaper_sentiment

date Date	topic Topic	country Country	volume Volume	sentiment Sentiment
Thu Nov 26 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	capital market	AT	3	0.2
Wed Nov 18 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	capital market	AT	3	0.12
Tue Nov 10 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	capital market	AT	2	0.1
Fri Nov 20 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	capital market	AT	1
Sun Nov 22 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	capital market	AT	1	-0.4
Wed Nov 11 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	capital market	AT	4	0.25
Thu Nov 19 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	capital market	AT	2	0.43
Wed Nov 25 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	capital market	AT	2	0.24
Tue Nov 03 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	capital market	AT	1	-0.5
Mon Nov 09 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	capital market	AT	1


CREATE TABLE newspaper_sentiment (
  "date" TIMESTAMP,
  "topic" VARCHAR,
  "country" VARCHAR,
  "volume" BIGINT,
  "sentiment" DOUBLE
);