Baselight

Trams

Eurostat code: road_eqs_trams ยท (1970 - 2023)

@eurostat.road_eqs_trams

Trams - Raw
@eurostat.road_eqs_trams.raw

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

  • 29.14 KB
  • 36 rows
  • 41 columns
freq

Freq

unit

Unit

geo

Geo

n_1970

1970

n_1975

1975

n_1980

1980

n_1985

1985

n_1990

1990

n_1991

1991

n_1992

1992

n_1993

1993

n_1994

1994

n_1995

1995

n_1996

1996

n_1997

1997

n_1998

1998

n_1999

1999

n_2000

2000

n_2001

2001

n_2002

2002

n_2003

2003

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

AnnualNumberAlbania
AnnualNumberAustria123456
AnnualNumberBosnia and Herzegovina6161
AnnualNumberBulgaria332344382395444459449431423416397368366355369365363342336331329304303303305317309280285280280311301313317316301317
AnnualNumberSwitzerland662667719736679659650774771770770760754778
AnnualNumberCyprus
AnnualNumberCzechia179917711908186115991929194719821899188818761865185918611855181818771882186618261828181718351828170417111716169316991665163916011579
AnnualNumberGermany28547706672964176186606356765335
AnnualNumberDenmark62326262642
AnnualNumberEstonia132132132131129131134130129125121116104899596887777777767787272707066656565

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1970" DOUBLE,
  "n_1975" DOUBLE,
  "n_1980" DOUBLE,
  "n_1985" DOUBLE,
  "n_1990" DOUBLE,
  "n_1991" DOUBLE,
  "n_1992" DOUBLE,
  "n_1993" DOUBLE,
  "n_1994" DOUBLE,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "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.