Baselight
Sign In

Business Demography And High Growth Enterprise By NACE Rev. 2 Activity And Metropolitan Region (2008-2020)

Eurostat code: met_bd_hgn2 ยท (2008 - 2020)

@eurostat.met_bd_hgn2

Business Demography And High Growth Enterprise By NACE Rev. 2 Activity And Metropolitan Region (2008-2020) - Unpivoted
@eurostat.met_bd_hgn2.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.73 MB
  • 563565 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)Austria200837455
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Wien20087558
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Graz20082466
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Linz20083324
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Salzburg20081850
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Innsbruck20081216
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Non-metropolitan regions in Austria200821041
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Sofia20086271
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Plovdiv20083665
AnnualNumberPopulation of active enterprises in t - numberIndustry (except construction)Varna20082087

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.