Socioeconomic Tracker Using Unconventional Data

Joint Research Centre

@ecjrc.f7be47f7_49a2_44e8_9dc8_043735af4139

Table List

3 tables(54.24 MB)

News Data From GDELT

Web Searches Data

Newspaper Sentiment

News Data From GDELT

@ecjrc.f7be47f7_49a2_44e8_9dc8_043735af4139.news_data_from_gdelt

49.35 MB
813422 rows
14 columns

date Date	year Year	month Month	day Day	tone_doc_count Tone Doc Count	popularity_rate Popularity Rate	tone_avg Tone Avg	tone_w_avg Tone W Avg	tone_cum Tone Cum	amd1code AMD1CODE	country COUNTRY	area Area	ref_time Ref Time	topic Topic
Fri Jan 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	1	1	330.0	0.69096216860465	1.439456047068876	1.0573038180326526	1.2222667178340014	UK	United Kingdom	GB	day	housing
Sat Jan 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	1	2	196.0	0.319209011040419	-0.14357063094632	0.1302245168746134	0.9226730160070834	UK	United Kingdom	GB	day	housing
Sun Jan 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	1	3	479.0	0.8549583959173732	-0.1110186186521699	-1.316658749511952	0.3670309136022216	UK	United Kingdom	GB	day	housing
Mon Jan 04 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	1	4	655.0	0.4601582447904763	0.4614284410898405	0.2772550507315058	0.4267984386755716	UK	United Kingdom	GB	day	housing
Tue Jan 05 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	1	5	494.0	0.4171515163452817	-0.1763422157706366	-0.1702927113589216	0.3019534638223213	UK	United Kingdom	GB	day	housing
Wed Jan 06 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	1	6	389.0	0.518802395899938	-0.0677738338770614	-0.3524535844520089	0.5643331439976312	UK	United Kingdom	GB	day	housing
Thu Jan 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	1	7	798.0	0.4657097835810365	-1.1614790002198714	-1.196465760925274	-1.1830143298851543	UK	United Kingdom	GB	day	housing
Fri Jan 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	1	8	375.0	0.3190285786804949	-0.3421217940106571	-0.0044066563866812	0.4791002989372539	UK	United Kingdom	GB	day	housing
Sat Jan 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	1	9	383.0	0.622725360894315	-2.2802989155184066	-3.149071498046053	-0.3498602070505784	UK	United Kingdom	GB	day	housing
Sun Jan 10 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	1	10	341.0	0.4124644669650694	-2.306500836560255	-1.906707562860283	-0.1765812904174052	UK	United Kingdom	GB	day	housing


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
);