Baselight
Sign In

Employer Business Demography By NACE Rev. 2activity And Metropolitan Region (2008-2020)

Eurostat code: met_bd_en2 ยท (2008 - 2020)

@eurostat.met_bd_en2

Employer Business Demography By NACE Rev. 2activity And Metropolitan Region (2008-2020) - Unpivoted
@eurostat.met_bd_en2.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.

  • 1.46 MB
  • 476204 rows
  • 7 columns
freq

Freq

unit

Unit

indic_sb

Indic Sb

nace_r2

Nace R2

metroreg

Metroreg

time_period

Time Period

value

Value

AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Austria200822336
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Wien20084434
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Graz20081420
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Linz20082069
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Salzburg20081123
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Innsbruck2008674
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Non-metropolitan regions in Austria200812616
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Portugal200845972
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Lisboa20087471
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Porto200810681

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "indic_sb" VARCHAR,
  "nace_r2" VARCHAR,
  "metroreg" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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