Baselight
Sign In

Annual Detailed Enterprise Statistics On Trade (NACE Rev. 1.1 G) (1990-2008)

Eurostat code: sbs_na_3b_tr ยท (1990 - 2008)

@eurostat.sbs_na_3b_tr

Annual Detailed Enterprise Statistics On Trade (NACE Rev. 1.1 G) (1990-2008) - Unpivoted
@eurostat.sbs_na_3b_tr.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.

  • 3.52 MB
  • 1147278 rows
  • 6 columns
freq

Freq

nace_r1

Nace R1

indic_sb

Indic Sb

geo

Geo

time_period

Time Period

value

Value

AnnualSale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuelEnterprises - numberFrance199074773
AnnualSale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuelEnterprises - numberItaly1990172582
AnnualSale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuelEnterprises - numberNetherlands199019294
AnnualSale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuelEnterprises - numberPortugal199020991
AnnualSale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuelEnterprises - numberSweden19909923
AnnualSale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuelTurnover or gross premiums written - million euroFrance199072530.8
AnnualSale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuelTurnover or gross premiums written - million euroItaly199093238.4
AnnualSale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuelTurnover or gross premiums written - million euroNetherlands199031571
AnnualSale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuelTurnover or gross premiums written - million euroPortugal19909458.6
AnnualSale, maintenance and repair of motor vehicles and motorcycles; retail sale of automotive fuelTurnover or gross premiums written - million euroSweden199019077.2

CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r1" VARCHAR,
  "indic_sb" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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