Baselight
Sign In

Germany Nowcasting

Joint Research Centre

@ecjrc.n_08d7791f_ab85_4f5e_8b55_e768e7c0514a

Loading...
Loading...

About this Dataset

Germany Nowcasting

Monthly data set of conventional and uncoventional variables for economic nowcasting in Germany. 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:54Z

Tables

Vintages

@ecjrc.n_08d7791f_ab85_4f5e_8b55_e768e7c0514a.vintages
  • 624.3 KB
  • 331 rows
  • 286 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 Germany

@ecjrc.n_08d7791f_ab85_4f5e_8b55_e768e7c0514a.macro_economic_nowcasting_data_germany
  • 611.76 KB
  • 364 rows
  • 246 columns
Loading... 

CREATE TABLE macro_economic_nowcasting_data_germany (
  "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.