Baselight

Cambridgeshire Historic Population 1801-2011

Cambridgeshire Insight

@ukgov.cambridgeshire_historic_population_1801_20111

Loading...
Loading...

About this Dataset

Cambridgeshire Historic Population 1801-2011

The Census in the UK has been conducted every 10 years since 1801. Over this time there have been numerous changes to the administrative boundaries, such as the amalgamation and deletion of wards and parishes, or the creation of new ones. These occur for a range of reasons, but usually to better distribute the population for administrative purposes.

Without knowledge about boundary changes it can be difficult to understand changes observed in populations, or make comparisons of areas over time. For example, moving a parish boundary may cause a population to increase on paper, within a given parish, but only because part of the population of a neighbouring parish has been incorporated, and not because a sudden influx of new residents.

The Research and Performance team have tried to keep a record of the changes to parishes over time, and the estimated populations as published by each Census, since 1801. This way we are better able to explain apparent changes to the populations estimated by each Census. You will find the most up to date versions of these records on our Open Data portal.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-11T00:13:33Z

Tables

Fenland Historic Population

@ukgov.cambridgeshire_historic_population_1801_20111.fenland_historic_population
  • 17.1 KB
  • 21 rows
  • 22 columns
Loading...

CREATE TABLE fenland_historic_population (
  "area" VARCHAR,
  "n_1801" DOUBLE,
  "n_1811" DOUBLE,
  "n_1821" DOUBLE,
  "n_1831" DOUBLE,
  "n_1841" DOUBLE,
  "n_1851" DOUBLE,
  "n_1861" DOUBLE,
  "n_1871" DOUBLE,
  "n_1881" DOUBLE,
  "n_1891" DOUBLE,
  "n_1901" DOUBLE,
  "n_1911" DOUBLE,
  "n_1921" DOUBLE,
  "n_1931" DOUBLE,
  "n_1951" DOUBLE,
  "n_1961" DOUBLE,
  "n_1971" DOUBLE,
  "n_1981" DOUBLE,
  "n_1991" DOUBLE,
  "n_2001" DOUBLE,
  "n_2011" DOUBLE
);

Cambridge City Historic Population

@ukgov.cambridgeshire_historic_population_1801_20111.cambridge_city_historic_population
  • 16.34 KB
  • 5 rows
  • 24 columns
Loading...

CREATE TABLE cambridge_city_historic_population (
  "area" VARCHAR,
  "n_1801" BIGINT,
  "n_1811" BIGINT,
  "n_1821" BIGINT,
  "n_1831" BIGINT,
  "n_1841" BIGINT,
  "n_1851" BIGINT,
  "n_1861" BIGINT,
  "n_1871" BIGINT,
  "n_1881" BIGINT,
  "n_1891" BIGINT,
  "n_1901" BIGINT,
  "n_1911" BIGINT,
  "n_1921" DOUBLE,
  "n_1931" DOUBLE,
  "n_1951" DOUBLE,
  "n_1961" DOUBLE,
  "n_1971" DOUBLE,
  "n_1981" DOUBLE,
  "n_1991" DOUBLE,
  "n_2001" DOUBLE,
  "n_2011" DOUBLE,
  "n_1801_1" BIGINT,
  "n_2011_1" DOUBLE
);

East Cambridgeshire Historic Population

@ukgov.cambridgeshire_historic_population_1801_20111.east_cambridgeshire_historic_population
  • 19.88 KB
  • 47 rows
  • 22 columns
Loading...

CREATE TABLE east_cambridgeshire_historic_population (
  "area" VARCHAR,
  "n_1801" DOUBLE,
  "n_1811" DOUBLE,
  "n_1821" DOUBLE,
  "n_1831" DOUBLE,
  "n_1841" DOUBLE,
  "n_1851" DOUBLE,
  "n_1861" DOUBLE,
  "n_1871" DOUBLE,
  "n_1881" DOUBLE,
  "n_1891" DOUBLE,
  "n_1901" DOUBLE,
  "n_1911" DOUBLE,
  "n_1921" DOUBLE,
  "n_1931" DOUBLE,
  "n_1951" DOUBLE,
  "n_1961" DOUBLE,
  "n_1971" DOUBLE,
  "n_1981" DOUBLE,
  "n_1991" DOUBLE,
  "n_2001" DOUBLE,
  "n_2011" DOUBLE
);

Huntingdonshire Historic Population

@ukgov.cambridgeshire_historic_population_1801_20111.huntingdonshire_historic_population
  • 33.48 KB
  • 217 rows
  • 32 columns
Loading...

CREATE TABLE huntingdonshire_historic_population (
  "area" VARCHAR,
  "n_1801" DOUBLE,
  "n_1811" DOUBLE,
  "n_1821" DOUBLE,
  "n_1831" DOUBLE,
  "n_1841" DOUBLE,
  "n_1851" DOUBLE,
  "n_1861" DOUBLE,
  "n_1871" DOUBLE,
  "n_1881" DOUBLE,
  "n_1891" DOUBLE,
  "n_1901" DOUBLE,
  "n_1911" DOUBLE,
  "n_1921" DOUBLE,
  "n_1931" DOUBLE,
  "n_1951" DOUBLE,
  "n_1961" DOUBLE,
  "n_1971" DOUBLE,
  "n_1981" DOUBLE,
  "n_1991" DOUBLE,
  "n_2001" DOUBLE,
  "n_2011" DOUBLE,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR
);

Share link

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