Cambridgeshire Railway Usage Estimates by UK Government | Transportation and Logistics

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 2018/19 - District Totals

@ukgov.cambridgeshire_railway_usage_estimates1.cambridgeshire_rail_usage_estimates_2018_19_district_totals

12.18 KB
6 rows
16 columns


CREATE TABLE cambridgeshire_rail_usage_estimates_2018_19_district_totals (
  "district" VARCHAR,
  "n_2004_2005" BIGINT,
  "n_2005_2006" BIGINT,
  "n_2006_2007" BIGINT,
  "n_2007_2008" BIGINT,
  "n_2008_2009" BIGINT,
  "n_2009_2010" BIGINT,
  "n_2010_2011" BIGINT,
  "n_2011_2012" BIGINT,
  "n_2012_2013" BIGINT,
  "n_2013_2014" BIGINT,
  "n_2014_2015" BIGINT,
  "n_2015_2016" BIGINT,
  "n_2016_2017" BIGINT,
  "n_2017_2018" BIGINT,
  "n_2018_2019" BIGINT
);

Cambridgeshire Railway Station Usage Estimates 2018/19

@ukgov.cambridgeshire_railway_usage_estimates1.cambridgeshire_railway_station_usage_estimates_2018_19

20.78 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,
  "n_1998_99" DOUBLE,
  "n_1999_00" DOUBLE,
  "n_2000_01" DOUBLE,
  "n_2001_02" DOUBLE,
  "n_2002_03" DOUBLE,
  "n_2003_04" VARCHAR,
  "n_2004_05" DOUBLE,
  "n_2005_06" DOUBLE,
  "n_2006_07" DOUBLE,
  "n_2007_08" DOUBLE,
  "n_2008_09" DOUBLE,
  "n_2009_10" DOUBLE,
  "n_2010_11" DOUBLE,
  "n_2011_12" DOUBLE,
  "n_2012_13" DOUBLE,
  "n_2013_14" DOUBLE,
  "n_2014_15" DOUBLE,
  "n_2015_16" DOUBLE,
  "n_2016_17" DOUBLE,
  "n_2017_18" BIGINT,
  "n_2018_19" BIGINT
);

Cambridgeshire Rail Usage Estimates 2017/18 - District Totals

@ukgov.cambridgeshire_railway_usage_estimates1.cambridgeshire_rail_usage_estimates_2017_18_district_totals

15.89 KB
6 rows
22 columns


CREATE TABLE cambridgeshire_rail_usage_estimates_2017_18_district_totals (
  "district" VARCHAR,
  "n_1997_98" BIGINT,
  "n_1998_99" BIGINT,
  "n_1999_00" BIGINT,
  "n_2000_01" BIGINT,
  "n_2001_02" BIGINT,
  "n_2002_03" BIGINT,
  "n_2003_04" VARCHAR,
  "n_2004_05" BIGINT,
  "n_2005_06" BIGINT,
  "n_2006_07" BIGINT,
  "n_2007_08" BIGINT,
  "n_2008_09" BIGINT,
  "n_2009_10" BIGINT,
  "n_2010_11" BIGINT,
  "n_2011_12" BIGINT,
  "n_2012_13" BIGINT,
  "n_2013_14" BIGINT,
  "n_2014_15" BIGINT,
  "n_2015_16" BIGINT,
  "n_2016_17" BIGINT,
  "n_2017_18" BIGINT
);

Table 5

@ukgov.cambridgeshire_railway_usage_estimates1.table_5

3.43 KB
20 rows
3 columns


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