Baselight
Sign In

Spain Nowcasting

Joint Research Centre

@ecjrc.n_390f8ebe_83ef_4d64_a86b_c01501a55597

Loading...
Loading...

About this Dataset

Spain Nowcasting

Monthly data set of conventional and uncoventional variables for economic nowcasting in Spain. The variables are aggregated monthly by averaging the latest available value at the time of the data update. The data set gathers country-specific traditional macro-economic series from statistical agencies, as well as big data alternative variables that can provide timely signals of economic developments. Examples of big data variables are text-based sentiment measures, indicators of media attention on economic topics or air quality indicators. For details on the application of the data set for economic nowcasting, check out the work by Barbaglia et al., “Testing Big Data in a Big Crisis: Nowcasting under COVID-19” (2022), International Journal of Forecasting.
Publisher name: Joint Research Centre
Publisher URL: https://commission.europa.eu/about/departments-and-executive-agencies/joint-research-centre
Last updated: 2024-10-09T19:52:35Z

Tables

Vintages

@ecjrc.n_390f8ebe_83ef_4d64_a86b_c01501a55597.vintages
  • 653.49 KB
  • 331 rows
  • 299 columns
Loading... 

CREATE TABLE vintages (
  "date" TIMESTAMP,
  "airqua_co" VARCHAR,
  "airqua_pm10" VARCHAR,
  "airqua_pm25" VARCHAR,
  "cas2dn_economy" VARCHAR,
  "cas2dn_finsector" VARCHAR,
  "cas2dn_indp" VARCHAR,
  "cas2dn_inflation" VARCHAR,
  "cas2dn_monpol" VARCHAR,
  "cas2dn_unemployment" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_anx_norm_all" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_anx_norm_sel" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_hedon_norm_sel" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_mcd_n_norm_all" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_mcd_n_norm_sel" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_mcd_p_norm_all" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_mcd_p_norm_sel" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_mcd_u_norm_all" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_mcd_u_norm_sel" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_tone_norm_all" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_tone_norm_sel" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_volume" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_anger_norm_all" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_anger_norm_sel" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_contempt_norm_all" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_contempt_norm_sel" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_disgust_norm_all" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_disgust_norm_sel" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_fear_norm_all" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_fear_norm_sel" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_happiness_norm_all" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_happiness_norm_sel" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_sadness_norm_all" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_sadness_norm_sel" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_surprise_norm_all" VARCHAR,
  "cas2gd_wb1104_macrovulnerability_wna_surprise_norm_sel" VARCHAR,
  "cas2gd_wb1406disease_anx_norm_all" VARCHAR,
  "cas2gd_wb1406disease_anx_norm_sel" VARCHAR,
  "cas2gd_wb1406disease_hedon_norm_sel" VARCHAR,
  "cas2gd_wb1406disease_mcd_n_norm_all" VARCHAR,
  "cas2gd_wb1406disease_mcd_n_norm_sel" VARCHAR,
  "cas2gd_wb1406disease_mcd_p_norm_all" VARCHAR,
  "cas2gd_wb1406disease_mcd_p_norm_sel" VARCHAR,
  "cas2gd_wb1406disease_mcd_u_norm_all" VARCHAR,
  "cas2gd_wb1406disease_mcd_u_norm_sel" VARCHAR,
  "cas2gd_wb1406disease_tone_norm_all" VARCHAR,
  "cas2gd_wb1406disease_tone_norm_sel" VARCHAR,
  "cas2gd_wb1406disease_volume" VARCHAR,
  "cas2gd_wb1406disease_wna_anger_norm_all" VARCHAR,
  "cas2gd_wb1406disease_wna_anger_norm_sel" VARCHAR,
  "cas2gd_wb1406disease_wna_contempt_norm_all" VARCHAR,
  "cas2gd_wb1406disease_wna_contempt_norm_sel" VARCHAR,
  "cas2gd_wb1406disease_wna_disgust_norm_all" VARCHAR,
  "cas2gd_wb1406disease_wna_disgust_norm_sel" VARCHAR,
  "cas2gd_wb1406disease_wna_fear_norm_all" VARCHAR,
  "cas2gd_wb1406disease_wna_fear_norm_sel" VARCHAR,
  "cas2gd_wb1406disease_wna_happiness_norm_all" VARCHAR,
  "cas2gd_wb1406disease_wna_happiness_norm_sel" VARCHAR,
  "cas2gd_wb1406disease_wna_sadness_norm_all" VARCHAR,
  "cas2gd_wb1406disease_wna_sadness_norm_sel" VARCHAR,
  "cas2gd_wb1406disease_wna_surprise_norm_all" VARCHAR,
  "cas2gd_wb1406disease_wna_surprise_norm_sel" VARCHAR,
  "cas2gd_wb2432conflict_anx_norm_all" VARCHAR,
  "cas2gd_wb2432conflict_anx_norm_sel" VARCHAR,
  "cas2gd_wb2432conflict_hedon_norm_sel" VARCHAR,
  "cas2gd_wb2432conflict_mcd_n_norm_all" VARCHAR,
  "cas2gd_wb2432conflict_mcd_n_norm_sel" VARCHAR,
  "cas2gd_wb2432conflict_mcd_p_norm_all" VARCHAR,
  "cas2gd_wb2432conflict_mcd_p_norm_sel" VARCHAR,
  "cas2gd_wb2432conflict_mcd_u_norm_all" VARCHAR,
  "cas2gd_wb2432conflict_mcd_u_norm_sel" VARCHAR,
  "cas2gd_wb2432conflict_tone_norm_all" VARCHAR,
  "cas2gd_wb2432conflict_tone_norm_sel" VARCHAR,
  "cas2gd_wb2432conflict_volume" VARCHAR,
  "cas2gd_wb2432conflict_wna_anger_norm_all" VARCHAR,
  "cas2gd_wb2432conflict_wna_anger_norm_sel" VARCHAR,
  "cas2gd_wb2432conflict_wna_contempt_norm_all" VARCHAR,
  "cas2gd_wb2432conflict_wna_contempt_norm_sel" VARCHAR,
  "cas2gd_wb2432conflict_wna_disgust_norm_all" VARCHAR,
  "cas2gd_wb2432conflict_wna_disgust_norm_sel" VARCHAR,
  "cas2gd_wb2432conflict_wna_fear_norm_all" VARCHAR,
  "cas2gd_wb2432conflict_wna_fear_norm_sel" VARCHAR,
  "cas2gd_wb2432conflict_wna_happiness_norm_all" VARCHAR,
  "cas2gd_wb2432conflict_wna_happiness_norm_sel" VARCHAR,
  "cas2gd_wb2432conflict_wna_sadness_norm_all" VARCHAR,
  "cas2gd_wb2432conflict_wna_sadness_norm_sel" VARCHAR,
  "cas2gd_wb2432conflict_wna_surprise_norm_all" VARCHAR,
  "cas2gd_wb2432conflict_wna_surprise_norm_sel" VARCHAR,
  "cas2gd_wb439macro_anx_norm_all" VARCHAR,
  "cas2gd_wb439macro_anx_norm_sel" VARCHAR,
  "cas2gd_wb439macro_hedon_norm_sel" VARCHAR,
  "cas2gd_wb439macro_mcd_n_norm_all" VARCHAR,
  "cas2gd_wb439macro_mcd_n_norm_sel" VARCHAR,
  "cas2gd_wb439macro_mcd_p_norm_all" VARCHAR,
  "cas2gd_wb439macro_mcd_p_norm_sel" VARCHAR,
  "cas2gd_wb439macro_mcd_u_norm_all" VARCHAR,
  "cas2gd_wb439macro_mcd_u_norm_sel" VARCHAR,
  "cas2gd_wb439macro_tone_norm_all" VARCHAR,
  "cas2gd_wb439macro_tone_norm_sel" VARCHAR,
  "cas2gd_wb439macro_volume" VARCHAR
);

Macro-economic Nowcasting Data Spain

@ecjrc.n_390f8ebe_83ef_4d64_a86b_c01501a55597.macro_economic_nowcasting_data_spain
  • 681.65 KB
  • 364 rows
  • 282 columns
Loading... 

CREATE TABLE macro_economic_nowcasting_data_spain (
  "date" TIMESTAMP,
  "airqua_co" VARCHAR,
  "airqua_pm10" VARCHAR,
  "airqua_pm25" VARCHAR,
  "newsin_economy" VARCHAR,
  "newsin_finsector" VARCHAR,
  "newsin_indp" VARCHAR,
  "newsin_inflation" VARCHAR,
  "newsin_monpol" VARCHAR,
  "newsin_unemployment" VARCHAR,
  "gdelts_wb1104_macrovulnerability_anx_norm_all" VARCHAR,
  "gdelts_wb1104_macrovulnerability_anx_norm_sel" VARCHAR,
  "gdelts_wb1104_macrovulnerability_hedon_norm_sel" VARCHAR,
  "gdelts_wb1104_macrovulnerability_mcd_n_norm_all" VARCHAR,
  "gdelts_wb1104_macrovulnerability_mcd_n_norm_sel" VARCHAR,
  "gdelts_wb1104_macrovulnerability_mcd_p_norm_all" VARCHAR,
  "gdelts_wb1104_macrovulnerability_mcd_p_norm_sel" VARCHAR,
  "gdelts_wb1104_macrovulnerability_mcd_u_norm_all" VARCHAR,
  "gdelts_wb1104_macrovulnerability_mcd_u_norm_sel" VARCHAR,
  "gdelts_wb1104_macrovulnerability_tone_norm_sel" VARCHAR,
  "gdelts_wb1104_macrovulnerability_volume" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_anger_norm_all" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_anger_norm_sel" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_contempt_norm_all" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_contempt_norm_sel" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_disgust_norm_all" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_disgust_norm_sel" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_fear_norm_all" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_fear_norm_sel" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_happiness_norm_all" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_happiness_norm_sel" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_sadness_norm_all" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_sadness_norm_sel" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_surprise_norm_all" VARCHAR,
  "gdelts_wb1104_macrovulnerability_wna_surprise_norm_sel" VARCHAR,
  "gdelts_wb1406disease_anx_norm_all" VARCHAR,
  "gdelts_wb1406disease_anx_norm_sel" VARCHAR,
  "gdelts_wb1406disease_hedon_norm_sel" VARCHAR,
  "gdelts_wb1406disease_mcd_n_norm_all" VARCHAR,
  "gdelts_wb1406disease_mcd_n_norm_sel" VARCHAR,
  "gdelts_wb1406disease_mcd_p_norm_all" VARCHAR,
  "gdelts_wb1406disease_mcd_p_norm_sel" VARCHAR,
  "gdelts_wb1406disease_mcd_u_norm_all" VARCHAR,
  "gdelts_wb1406disease_mcd_u_norm_sel" VARCHAR,
  "gdelts_wb1406disease_tone_norm_sel" VARCHAR,
  "gdelts_wb1406disease_volume" VARCHAR,
  "gdelts_wb1406disease_wna_anger_norm_all" VARCHAR,
  "gdelts_wb1406disease_wna_anger_norm_sel" VARCHAR,
  "gdelts_wb1406disease_wna_contempt_norm_all" VARCHAR,
  "gdelts_wb1406disease_wna_contempt_norm_sel" VARCHAR,
  "gdelts_wb1406disease_wna_disgust_norm_all" VARCHAR,
  "gdelts_wb1406disease_wna_disgust_norm_sel" VARCHAR,
  "gdelts_wb1406disease_wna_fear_norm_all" VARCHAR,
  "gdelts_wb1406disease_wna_fear_norm_sel" VARCHAR,
  "gdelts_wb1406disease_wna_happiness_norm_all" VARCHAR,
  "gdelts_wb1406disease_wna_happiness_norm_sel" VARCHAR,
  "gdelts_wb1406disease_wna_sadness_norm_all" VARCHAR,
  "gdelts_wb1406disease_wna_sadness_norm_sel" VARCHAR,
  "gdelts_wb1406disease_wna_surprise_norm_all" VARCHAR,
  "gdelts_wb1406disease_wna_surprise_norm_sel" VARCHAR,
  "gdelts_wb2432conflict_anx_norm_all" VARCHAR,
  "gdelts_wb2432conflict_anx_norm_sel" VARCHAR,
  "gdelts_wb2432conflict_hedon_norm_sel" VARCHAR,
  "gdelts_wb2432conflict_mcd_n_norm_all" VARCHAR,
  "gdelts_wb2432conflict_mcd_n_norm_sel" VARCHAR,
  "gdelts_wb2432conflict_mcd_p_norm_all" VARCHAR,
  "gdelts_wb2432conflict_mcd_p_norm_sel" VARCHAR,
  "gdelts_wb2432conflict_mcd_u_norm_all" VARCHAR,
  "gdelts_wb2432conflict_mcd_u_norm_sel" VARCHAR,
  "gdelts_wb2432conflict_tone_norm_sel" VARCHAR,
  "gdelts_wb2432conflict_volume" VARCHAR,
  "gdelts_wb2432conflict_wna_anger_norm_all" VARCHAR,
  "gdelts_wb2432conflict_wna_anger_norm_sel" VARCHAR,
  "gdelts_wb2432conflict_wna_contempt_norm_all" VARCHAR,
  "gdelts_wb2432conflict_wna_contempt_norm_sel" VARCHAR,
  "gdelts_wb2432conflict_wna_disgust_norm_all" VARCHAR,
  "gdelts_wb2432conflict_wna_disgust_norm_sel" VARCHAR,
  "gdelts_wb2432conflict_wna_fear_norm_all" VARCHAR,
  "gdelts_wb2432conflict_wna_fear_norm_sel" VARCHAR,
  "gdelts_wb2432conflict_wna_happiness_norm_all" VARCHAR,
  "gdelts_wb2432conflict_wna_happiness_norm_sel" VARCHAR,
  "gdelts_wb2432conflict_wna_sadness_norm_all" VARCHAR,
  "gdelts_wb2432conflict_wna_sadness_norm_sel" VARCHAR,
  "gdelts_wb2432conflict_wna_surprise_norm_all" VARCHAR,
  "gdelts_wb2432conflict_wna_surprise_norm_sel" VARCHAR,
  "gdelts_wb439macro_anx_norm_all" VARCHAR,
  "gdelts_wb439macro_anx_norm_sel" VARCHAR,
  "gdelts_wb439macro_hedon_norm_sel" VARCHAR,
  "gdelts_wb439macro_mcd_n_norm_all" VARCHAR,
  "gdelts_wb439macro_mcd_n_norm_sel" VARCHAR,
  "gdelts_wb439macro_mcd_p_norm_all" VARCHAR,
  "gdelts_wb439macro_mcd_p_norm_sel" VARCHAR,
  "gdelts_wb439macro_mcd_u_norm_all" VARCHAR,
  "gdelts_wb439macro_mcd_u_norm_sel" VARCHAR,
  "gdelts_wb439macro_tone_norm_sel" VARCHAR,
  "gdelts_wb439macro_volume" VARCHAR,
  "gdelts_wb439macro_wna_anger_norm_all" VARCHAR,
  "gdelts_wb439macro_wna_anger_norm_sel" VARCHAR,
  "gdelts_wb439macro_wna_contempt_norm_all" VARCHAR,
  "gdelts_wb439macro_wna_contempt_norm_sel" VARCHAR
);

Share link

Anyone who has the link will be able to view this.