Baselight
Sign In

International Transport Of Passengers From The Country Of Embarkation To The Reporting Country

Eurostat code: rail_pa_intcmng ยท (2004 - 2024)

@eurostat.rail_pa_intcmng

International Transport Of Passengers From The Country Of Embarkation To The Reporting Country - Unpivoted
@eurostat.rail_pa_intcmng.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.

  • 26.7 KB
  • 7920 rows
  • 7 columns
freq

Freq

unit

Unit

train

Train

partner

Partner

geo

Geo

time_period

Time Period

value

Value

AnnualThousand passengersTotalAlbaniaRomania2004
AnnualThousand passengersTotalAustriaBelgium20041
AnnualThousand passengersTotalAustriaCzechia200438
AnnualThousand passengersTotalAustriaGermany2004975
AnnualThousand passengersTotalAustriaDenmark20043
AnnualThousand passengersTotalAustriaFrance20047
AnnualThousand passengersTotalAustriaCroatia200428
AnnualThousand passengersTotalAustriaHungary2004174
AnnualThousand passengersTotalAustriaItaly2004195
AnnualThousand passengersTotalAustriaLithuania2004

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