Baselight
Sign In

Business Demography By Size Class And Other Typologies (2008-2020)

Eurostat code: urt_bd_size ยท (2008 - 2020)

@eurostat.urt_bd_size

Business Demography By Size Class And Other Typologies (2008-2020) - Unpivoted
@eurostat.urt_bd_size.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.

  • 818.48 KB
  • 192510 rows
  • 9 columns
freq

Freq

unit

Unit

sizeclas

Sizeclas

terrtypo

Terrtypo

indic_sb

Indic Sb

nace_r2

Nace R2

geo

Geo

time_period

Time Period

value

Value

AnnualNumberZeroBorder regionsPopulation of active enterprises in t - numberIndustry, construction and services except activities of holding companiesAustria2008249432
AnnualNumberZeroBorder regionsPopulation of active enterprises in t - numberIndustry, construction and services except activities of holding companiesBulgaria200857659
AnnualNumberZeroBorder regionsPopulation of active enterprises in t - numberIndustry, construction and services except activities of holding companiesDenmark200869880
AnnualNumberZeroBorder regionsPopulation of active enterprises in t - numberIndustry, construction and services except activities of holding companiesEstonia20083571
AnnualNumberZeroBorder regionsPopulation of active enterprises in t - numberIndustry, construction and services except activities of holding companiesSpain2008585682
AnnualNumberZeroBorder regionsPopulation of active enterprises in t - numberIndustry, construction and services except activities of holding companiesFinland200837885
AnnualNumberZeroBorder regionsPopulation of active enterprises in t - numberIndustry, construction and services except activities of holding companiesHungary2008216446
AnnualNumberZeroBorder regionsPopulation of active enterprises in t - numberIndustry, construction and services except activities of holding companiesItaly2008848843
AnnualNumberZeroBorder regionsPopulation of active enterprises in t - numberIndustry, construction and services except activities of holding companiesNetherlands2008290632
AnnualNumberZeroBorder regionsPopulation of active enterprises in t - numberIndustry, construction and services except activities of holding companiesPortugal2008190953

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

Share link

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