Baselight
Sign In

Statistical Transfers, Joint Projects And Joint Support Schemes

Eurostat code: nrg_ind_stjpjss ยท (2004 - 2023)

@eurostat.nrg_ind_stjpjss

Statistical Transfers, Joint Projects And Joint Support Schemes - Unpivoted
@eurostat.nrg_ind_stjpjss.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.

  • 8.2 KB
  • 16257 rows
  • 6 columns
freq

Freq

nrg_bal

Nrg Bal

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualJoint projects between Member States - electricityThousand tonnes of oil equivalentAlbania2004
AnnualJoint projects between Member States - electricityThousand tonnes of oil equivalentAustria2004
AnnualJoint projects between Member States - electricityThousand tonnes of oil equivalentBosnia and Herzegovina2004
AnnualJoint projects between Member States - electricityThousand tonnes of oil equivalentBelgium2004
AnnualJoint projects between Member States - electricityThousand tonnes of oil equivalentBulgaria2004
AnnualJoint projects between Member States - electricityThousand tonnes of oil equivalentCyprus2004
AnnualJoint projects between Member States - electricityThousand tonnes of oil equivalentCzechia2004
AnnualJoint projects between Member States - electricityThousand tonnes of oil equivalentGermany2004
AnnualJoint projects between Member States - electricityThousand tonnes of oil equivalentDenmark2004
AnnualJoint projects between Member States - electricityThousand tonnes of oil equivalentEstonia2004

CREATE TABLE tidy (
  "freq" VARCHAR,
  "nrg_bal" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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