Baselight
Sign In

Supply And Transformation Of Solid Fossil Fuels - Monthly Data

Eurostat code: nrg_cb_sffm ยท (2008-01 - 2025-02)

@eurostat.nrg_cb_sffm

Supply And Transformation Of Solid Fossil Fuels - Monthly Data - Unpivoted
@eurostat.nrg_cb_sffm.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.

  • 596.67 KB
  • 290296 rows
  • 7 columns
freq

Freq

nrg_bal

Nrg Bal

siec

Siec

unit

Unit

geo

Geo

time_period

Time Period

value

Value

MonthlyExportsHard coalThousand tonnesAustria2008-01
MonthlyExportsHard coalThousand tonnesBelgium2008-01105
MonthlyExportsHard coalThousand tonnesBulgaria2008-01
MonthlyExportsHard coalThousand tonnesCyprus2008-01
MonthlyExportsHard coalThousand tonnesCzechia2008-01526
MonthlyExportsHard coalThousand tonnesGermany2008-0110
MonthlyExportsHard coalThousand tonnesDenmark2008-0135
MonthlyExportsHard coalThousand tonnesEstonia2008-01
MonthlyExportsHard coalThousand tonnesGreece2008-011
MonthlyExportsHard coalThousand tonnesSpain2008-01154

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

Share link

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