Baselight

Passengers Transported

Eurostat code: rail_pa_total ยท (2004 - 2023)

@eurostat.rail_pa_total

Passengers Transported - Raw
@eurostat.rail_pa_total.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

  • 23.53 KB
  • 69 rows
  • 23 columns
freq

Freq

unit

Unit

geo

Geo

n_2004

2004

n_2005

2005

n_2006

2006

n_2007

2007

n_2008

2008

n_2009

2009

n_2010

2010

n_2011

2011

n_2012

2012

n_2013

2013

n_2014

2014

n_2015

2015

n_2016

2016

n_2017

2017

n_2018

2018

n_2019

2019

n_2020

2020

n_2021

2021

n_2022

2022

n_2023

2023

AnnualMillions of passenger-kilometresAustria8274868589079167103651018410263107781121111804119811210412497125621312213252737584471285514435
AnnualMillions of passenger-kilometresBosnia and Herzegovina35342429395614183134
AnnualMillions of passenger-kilometresBelgium922585108964940310139102371049810669
AnnualMillions of passenger-kilometresBulgaria241124042317213820902059187018211698154914551434147615201118120316001592
AnnualMillions of passenger-kilometresSwitzerland17699184971909319387191801936819934202282065720707204512155913261142231920122093
AnnualMillions of passenger-kilometresCzechia6580666769226898677364726559666971967512764481258738940310220108566623675293949996
AnnualMillions of passenger-kilometresGermany759037494478735790988242881206828378931693918894509097891050954659552998161100252577875751892313101408
AnnualMillions of passenger-kilometresDenmark59215961609761636267616163416605674467856513650763326280618261743940418158226031
AnnualMillions of passenger-kilometresEstonia193248257274274249247243235223280286316366417392263290382408
AnnualMillions of passenger-kilometresGreece166818541811193016571467138395883210561072126311921112110412526406531117673

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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