About this Dataset

Cambridgeshire Railway Usage Estimates

A selection of csv files breaking down rail usage estimates across Cambridgeshire and Peterborough. The Office of Rail and Road (ORR) produces yearly (April-March) estimates of the total number of entries, exits and interchanges at rail stations in Great Britain. The estimates are based on ticket sales data recorded in rail industry systems. The complete dataset covers the period 1997-2018.

For subsequent years of railway usage data, you can explore the full national dataset directly from the Office of Rail and Road (ORR) by clicking this link (updated with 2021/22 data on November 24th 2022).:
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:15Z

Tables

Cambridgeshire Rail Usage Estimates 2017/18 - District Totals

@ukgov.cambridgeshire_railway_usage_estimates1.cambridgeshire_rail_usage_estimates_2017_18_district_totals

16.27 kB
6 rows
22 columns

CREATE TABLE cambridgeshire_rail_usage_estimates_2017_18_district_totals (
  "district" VARCHAR,
  "n_1997_98" BIGINT  -- 1997-98,
  "n_1998_99" BIGINT  -- 1998-99,
  "n_1999_00" BIGINT  -- 1999-00,
  "n_2000_01" BIGINT  -- 2000-01,
  "n_2001_02" BIGINT  -- 2001-02,
  "n_2002_03" BIGINT  -- 2002-03,
  "n_2003_04" VARCHAR  -- 2003-04,
  "n_2004_05" BIGINT  -- 2004-05,
  "n_2005_06" BIGINT  -- 2005-06,
  "n_2006_07" BIGINT  -- 2006-07,
  "n_2007_08" BIGINT  -- 2007-08,
  "n_2008_09" BIGINT  -- 2008-09,
  "n_2009_10" BIGINT  -- 2009-10,
  "n_2010_11" BIGINT  -- 2010-11,
  "n_2011_12" BIGINT  -- 2011-12,
  "n_2012_13" BIGINT  -- 2012-13,
  "n_2013_14" BIGINT  -- 2013-14,
  "n_2014_15" BIGINT  -- 2014-15,
  "n_2015_16" BIGINT  -- 2015-16,
  "n_2016_17" BIGINT  -- 2016-17,
  "n_2017_18" BIGINT  -- 2017-18
);

Cambridgeshire Rail Usage Estimates 2018/19 - District Totals

@ukgov.cambridgeshire_railway_usage_estimates1.cambridgeshire_rail_usage_estimates_2018_19_district_totals

12.47 kB
6 rows
16 columns

CREATE TABLE cambridgeshire_rail_usage_estimates_2018_19_district_totals (
  "district" VARCHAR,
  "n_2004_2005" BIGINT  -- 2004-2005,
  "n_2005_2006" BIGINT  -- 2005-2006,
  "n_2006_2007" BIGINT  -- 2006-2007,
  "n_2007_2008" BIGINT  -- 2007-2008,
  "n_2008_2009" BIGINT  -- 2008-2009,
  "n_2009_2010" BIGINT  -- 2009-2010,
  "n_2010_2011" BIGINT  -- 2010-2011,
  "n_2011_2012" BIGINT  -- 2011-2012,
  "n_2012_2013" BIGINT  -- 2012-2013,
  "n_2013_2014" BIGINT  -- 2013-2014,
  "n_2014_2015" BIGINT  -- 2014-2015,
  "n_2015_2016" BIGINT  -- 2015-2016,
  "n_2016_2017" BIGINT  -- 2016-2017,
  "n_2017_2018" BIGINT  -- 2017-2018,
  "n_2018_2019" BIGINT  -- 2018-2019
);

Cambridgeshire Railway Station Usage Estimates 2018/19

@ukgov.cambridgeshire_railway_usage_estimates1.cambridgeshire_railway_station_usage_estimates_2018_19

21.27 kB
20 rows
26 columns

CREATE TABLE cambridgeshire_railway_station_usage_estimates_2018_19 (
  "station_name" VARCHAR,
  "district" VARCHAR,
  "region" VARCHAR,
  "local_authority" VARCHAR,
  "n_1997_98" DOUBLE  -- 1997-98,
  "n_1998_99" DOUBLE  -- 1998-99,
  "n_1999_00" DOUBLE  -- 1999-00,
  "n_2000_01" DOUBLE  -- 2000-01,
  "n_2001_02" DOUBLE  -- 2001-02,
  "n_2002_03" DOUBLE  -- 2002-03,
  "n_2003_04" VARCHAR  -- 2003-04,
  "n_2004_05" DOUBLE  -- 2004-05,
  "n_2005_06" DOUBLE  -- 2005-06,
  "n_2006_07" DOUBLE  -- 2006-07,
  "n_2007_08" DOUBLE  -- 2007-08,
  "n_2008_09" DOUBLE  -- 2008-09,
  "n_2009_10" DOUBLE  -- 2009-10,
  "n_2010_11" DOUBLE  -- 2010-11,
  "n_2011_12" DOUBLE  -- 2011-12,
  "n_2012_13" DOUBLE  -- 2012-13,
  "n_2013_14" DOUBLE  -- 2013-14,
  "n_2014_15" DOUBLE  -- 2014-15,
  "n_2015_16" DOUBLE  -- 2015-16,
  "n_2016_17" DOUBLE  -- 2016-17,
  "n_2017_18" BIGINT  -- 2017-18,
  "n_2018_19" BIGINT  -- 2018-19
);

Table 5

@ukgov.cambridgeshire_railway_usage_estimates1.table_5

3.52 kB
20 rows
3 columns

CREATE TABLE table_5 (
  "station_name" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);