Baselight
Sign In

Macroeconomic Imbalance Procedure - Statistical Annex Indicators

Eurostat code: mips_sa ยท (2001 - 2023)

@eurostat.mips_sa

Macroeconomic Imbalance Procedure - Statistical Annex Indicators - Unpivoted
@eurostat.mips_sa.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

  • 721.16 KB
  • 371025 rows
  • 7 columns
freq

Freq

indic_ip

Indic Ip

release

Release

indic

Indic

geo

Geo

time_period

Time Period

value

Value

AnnualCurrent account balance - % of GDP, 3 years averageStatistical annex 2012Headline indicatorsAustria2001-1.1
AnnualCurrent account balance - % of GDP, 3 years averageStatistical annex 2012Headline indicatorsBelgium20014.2
AnnualCurrent account balance - % of GDP, 3 years averageStatistical annex 2012Headline indicatorsBulgaria2001-5.2
AnnualCurrent account balance - % of GDP, 3 years averageStatistical annex 2012Headline indicatorsCyprus2001-3.5
AnnualCurrent account balance - % of GDP, 3 years averageStatistical annex 2012Headline indicatorsCzechia2001-4
AnnualCurrent account balance - % of GDP, 3 years averageStatistical annex 2012Headline indicatorsGermany2001-1
AnnualCurrent account balance - % of GDP, 3 years averageStatistical annex 2012Headline indicatorsDenmark20012.2
AnnualCurrent account balance - % of GDP, 3 years averageStatistical annex 2012Headline indicatorsEstonia2001-4.9
AnnualCurrent account balance - % of GDP, 3 years averageStatistical annex 2012Headline indicatorsGreece2001-6.2
AnnualCurrent account balance - % of GDP, 3 years averageStatistical annex 2012Headline indicatorsSpain2001-3.6

CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_ip" VARCHAR,
  "release" VARCHAR,
  "indic" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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