Please upgrade to a more up-to-date browser to explore the datasets on this website.


User menu

Cambridgeshire Insight OpenData

Welcome to Cambridgeshire Insight Open Data
Funded by the LGA Open data Breakthrough Fund

Other stories

07/20/2017 - 11:32

Not all housing is the traditional "bricks and mortar" we tend to think of. There are lots of less permanent housing types, including houseboats, park homes and caravans.

Across our local area, a number of individuals and families live in "non traditional" accommodation.

This story brings together some brief data and identifies links to find out more about the types, scale and occupation of "non-traditional" housing in our area.

01/18/2017 - 15:08

“Data is the new oil…” is a phrase often used by those in the industry to describe the vast, valuable and extremely powerful resource available to us. We generate an astronomical amount of data, in fact 90% of the data in the world today has been created in the last two years alone according to IBM.

12/08/2016 - 15:11

Forecasting pupil rolls can be tricky business but getting it right can be sweet.

10/14/2016 - 17:50

It has been estimated that there were 257 deaths attributable to particulate air pollution in Cambridgeshire in 2010 and that over 5% of Cambridgeshire’s population mortality is attributed to air pollution (based on ambient levels of PM2.5). The percentage in Cambridge is 5.8% which equates to 47 deaths attributable to air pollution (

10/06/2016 - 15:00

What is Hate Crime? A hate crime is one which is “committed against someone because of their disability, gender-identity, race, religion or belief, or sexual orientation” (1). It covers a wide range of crime types including assault, harassment, and inciting others to commit hate crimes. Following the EU referendum on 23rd June, the Police experienced a 57% increase in national reporting of hate crime to their online reporting site between 23rd and 26th June compared to the same time 4 weeks before (2).

08/16/2016 - 11:09

Why is understanding fuel poverty important?

Every year, fuel poverty in the UK makes headlines, for example:

Cold homes caused 9,000 deaths last winter, study suggests

Number of households in fuel poverty rises to 2.38m

Fuel poverty is caused by a combination of fuel costs, poverty and inefficient housing stock, and can have a range of effects including:

Forecasting Cambridgeshire’s future: Using school census data to help predict future demand on education provision in Cambridgeshire

‘effective pupil place planning is a fundamental element of the local authority’s role as strategic commissioner of good school places.’1

Calculating the number of bums on seats or the number of classrooms needed now and in the future! These issues can only be addressed if you know how many pupils there are going to be.

This data story is the first in a series of posts that we will be publishing which look to breakdown the process of pupil forecasting in Cambridgeshire and highlighting the key datasets used throughout.

Why produce schools forecasts?

Local authorities are required to plan for school places. According to the government guidelines, ‘effective pupil place planning is a fundamental element of the local authority’s role as strategic commissioner of good school places.’1 It is under-pinned by strong use of relevant data drawn from a wide variety of sources that provide local pictures of increases in population due to births, expansions due to housing development, as well as changes resulting from people moving into and out of areas. Without the insight delivered by these forecasts into future demand on education within the county and where pinch-points on capacity may lie, Cambridgeshire County Council would be unable to effectively deliver their statutory duty to assess the local need for school places to ensure that every child can be provided with a place within a state-funded school.

What types of forecasts?

However, whilst there is general agreement that there is a requirement to forecast the need, there are a variety of methods available for doing this. The Cambridgeshire Research Group is commissioned to produce two types of forecasts:

Pupil forecasts (school-based) are produced to show the numbers of pupils expected to enrol for individual schools and are based on historic enrolments and administrative data that helps predict the numbers of births and moves into school catchment areas. These forecasts provide insight into demands on schools and therefore are invaluable for future planning.

Catchment area forecasts are produced to show the numbers of pupils expected to be living within each school catchment area irrespective of school attended. These forecasts are therefore not limited by school capacity and reflect how the pupil population is growing across the county, from a geographical perspective.

Below we see Cambridgeshire divided by secondary school catchment area. The catchment forecast essentially provided population insight into the number of secondary pupils living within each of these areas. A similar model is applied at primary catchment level for primary aged pupils too. These are generally geographically smaller areas than secondary catchments.

Cambridgeshire Secondary Catchments

Local authorities are expected to demonstrate they have an effective method of forecasting pupil numbers, considering changes in local circumstances, to ensure that there is the right number of schools in the right places for the number of pupils expected in the future. A key dataset in driving these forecasts is the School Census.

The Schools Census data – An invaluable resource

The pupil and catchment forecasts use pupil counts from the January-based School Census, which is a survey of pupils that access education via one of the below:

all local-authority-maintained schools

some schools not maintained by the local authority, including: academies.

The School Census collects information about individual pupils and information about the schools themselves, such as their educational provision. The individual pupil information collected includes free school meal eligibility, ethnicity, special educational needs, attendance and exclusions.2 A wide range of aggregated outputs from the Schools Census data are published by the Department for Education, but individual pupil-level data is not as it contains data defined as personal and sensitive by the Data Protection Act 1998.

The Secretary of State can share pupil-level data from National Pupil Database under strict terms and conditions with named bodies and third parties, who for the purpose of promoting the education or well-being of children in England, through the: conduct of research and analysis; production of statistics; or provision of information advice and guidance. The Schools Census therefore provides an invaluable source of evidence on those accessing education to inform independent research, as well as studies and reports commissioned by government departments, and plan for future provision of pupil places .

What wouldn’t we know without the Schools Census?

Without the school census, it would be difficult to forecast future demand on school capacity as we would not know exactly how many pupils attend each school, both currently and historically. The school census tells us exactly how many pupils are on roll within a school, by age group. We are able to use schools rolls to predict the number of year 7’s (age 11 pupils) arriving at each secondary school based on the historic rate of transfer between primary aged 10 year olds and secondary 11 year olds. We are also able to use the historic school census rolls to also identify trends in the movement of individual year groups within a school to identify whether year groups historically increase or decrease and cohorts move through the school. This can help to forecast whether future year groups will increase, or decrease, as they age through the school system.

Importantly, the school census also offers us key insight about where in and at times, out of the county that pupils on roll at our school are living.

Key stats from the latest school census

Annual school census data, taken in January 2016, shows:

• 98% of primary aged pupils on roll at a Cambridgeshire school are currently living in the county, while 0.7% come from Suffolk, 0.7% from Norfolk and 0.3% from Peterborough.

• Primary numbers have increased from 42,653 in 2006/07 to 48,816 in 2015/16.

• The 2015/16 reception intake was around 7,473 and is the highest since the early 1990s. The reception intake at the same point in 2014/15 was around 7,257.

• The January 2016 School Census shows that 97% of the 32,285 secondary aged pupils (11 to 18 year olds) on roll at a Cambridgeshire school currently live in Cambridgeshire.

• Of the remaining secondary aged pupils, 1% are from Suffolk, 0.5% from Hertfordshire, 0.4% from Central Bedfordshire and 0.3% from Peterborough.

Our next data story will highlight what the forecast numbers for school rolls in the county are expected to look like from a county wide perspective between now and 2020/21.


The Cambridgeshire Research Group (CRG) produce a county wide forecast report that provides a local view of the forecast scenario for the future. This report is also broken down to show projections at individual district level. This report can be accessed by clicking here


If you have suggestions to make or want to find out more, please contact


School capacity (SCAP) survey: Guide to forecasting pupil numbers in school place planning,

School Census,