Dataset: National Transport (Directive 80/1177/EEC) (monthly Data) (1982-2002)

About this Dataset

National Transport (Directive 80/1177/EEC) (monthly Data) (1982-2002)

This Eurostat dataset contains data on national transport (directive 80/1177/eec) (monthly data) (1982-2002), as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2009-03-27T23:00:00+0100

Tables

National Transport (Directive 80/1177/EEC) (monthly Data) (1982-2002) - Raw

@eurostat.rail_go_natmnth.raw

200.44 KB
34 rows
276 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1982" DOUBLE,
  "n_1982_01" DOUBLE,
  "n_1982_02" DOUBLE,
  "n_1982_03" DOUBLE,
  "n_1982_04" DOUBLE,
  "n_1982_05" DOUBLE,
  "n_1982_06" DOUBLE,
  "n_1982_07" DOUBLE,
  "n_1982_08" DOUBLE,
  "n_1982_09" DOUBLE,
  "n_1982_10" DOUBLE,
  "n_1982_11" DOUBLE,
  "n_1982_12" DOUBLE,
  "n_1983" DOUBLE,
  "n_1983_01" DOUBLE,
  "n_1983_02" DOUBLE,
  "n_1983_03" DOUBLE,
  "n_1983_04" DOUBLE,
  "n_1983_05" DOUBLE,
  "n_1983_06" DOUBLE,
  "n_1983_07" DOUBLE,
  "n_1983_08" DOUBLE,
  "n_1983_09" DOUBLE,
  "n_1983_10" DOUBLE,
  "n_1983_11" DOUBLE,
  "n_1983_12" DOUBLE,
  "n_1984" DOUBLE,
  "n_1984_01" DOUBLE,
  "n_1984_02" DOUBLE,
  "n_1984_03" DOUBLE,
  "n_1984_04" DOUBLE,
  "n_1984_05" DOUBLE,
  "n_1984_06" DOUBLE,
  "n_1984_07" DOUBLE,
  "n_1984_08" DOUBLE,
  "n_1984_09" DOUBLE,
  "n_1984_10" DOUBLE,
  "n_1984_11" DOUBLE,
  "n_1984_12" DOUBLE,
  "n_1985" DOUBLE,
  "n_1985_01" DOUBLE,
  "n_1985_02" DOUBLE,
  "n_1985_03" DOUBLE,
  "n_1985_04" DOUBLE,
  "n_1985_05" DOUBLE,
  "n_1985_06" DOUBLE,
  "n_1985_07" DOUBLE,
  "n_1985_08" DOUBLE,
  "n_1985_09" DOUBLE,
  "n_1985_10" DOUBLE,
  "n_1985_11" DOUBLE,
  "n_1985_12" DOUBLE,
  "n_1986" DOUBLE,
  "n_1986_01" DOUBLE,
  "n_1986_02" DOUBLE,
  "n_1986_03" DOUBLE,
  "n_1986_04" DOUBLE,
  "n_1986_05" DOUBLE,
  "n_1986_06" DOUBLE,
  "n_1986_07" DOUBLE,
  "n_1986_08" DOUBLE,
  "n_1986_09" DOUBLE,
  "n_1986_10" DOUBLE,
  "n_1986_11" DOUBLE,
  "n_1986_12" DOUBLE,
  "n_1987" DOUBLE,
  "n_1987_01" DOUBLE,
  "n_1987_02" DOUBLE,
  "n_1987_03" DOUBLE,
  "n_1987_04" DOUBLE,
  "n_1987_05" DOUBLE,
  "n_1987_06" DOUBLE,
  "n_1987_07" DOUBLE,
  "n_1987_08" DOUBLE,
  "n_1987_09" DOUBLE,
  "n_1987_10" DOUBLE,
  "n_1987_11" DOUBLE,
  "n_1987_12" DOUBLE,
  "n_1988" DOUBLE,
  "n_1988_01" DOUBLE,
  "n_1988_02" DOUBLE,
  "n_1988_03" DOUBLE,
  "n_1988_04" DOUBLE,
  "n_1988_05" DOUBLE,
  "n_1988_06" DOUBLE,
  "n_1988_07" DOUBLE,
  "n_1988_08" DOUBLE,
  "n_1988_09" DOUBLE,
  "n_1988_10" DOUBLE,
  "n_1988_11" DOUBLE,
  "n_1988_12" DOUBLE,
  "n_1989" DOUBLE,
  "n_1989_01" DOUBLE,
  "n_1989_02" DOUBLE,
  "n_1989_03" DOUBLE,
  "n_1989_04" DOUBLE,
  "n_1989_05" DOUBLE
);

National Transport (Directive 80/1177/EEC) (monthly Data) (1982-2002) - Unpivoted

@eurostat.rail_go_natmnth.tidy

21.35 KB
3198 rows
5 columns


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