Focus on London 2009 Data Store

The underlying data for the 2009 report can be downloaded below.

We‘ve posted the data sets through Google Docs so that everyone can access the data quickly and easily, regardless of whether or not you have the right software installed.

The other advantage of Google Docs is the developer API which enables developers to plug straight into the data … if you build a visualisation from our data then let us know, webteam@london.gov.uk, and we’ll look at posting it on this site.

Top 10s

Download entire Top 10s, or by individual table:

Table Title
1 Population of urban agglomerations in EU, 2007
2 Population by nationality, London, 2007/08
3 Population by country of birth, London, 2007/08
4 National Insurance Number registrations of non-UK nationals by country of origin, London, 2007/08
5 Overseas visitors to London, 2007
6 Tourist spending by borough, 2006
7 Leading tourist attractions, London, 2008
8 Oldest Underground lines
9 Passengers carried by Underground line, 2008
10 Tallest high-rise buildings, London, 2009
11 Commercial and industrial floor space by borough, 2007
12 Income of tax-payers, by borough 2006-07
13 World’s busiest airports by passenger traffic, 2008
14 Longest rivers in London
15 Numbers of properties with significant chance of flooding or in a floodplain by borough, 2006
16 Most expensive average house prices, by borough March 2009
17 Cheapest average house prices, by borough March 2009
18 Offences by type, 2007-08
19 Causes of mortality, London, 2007
20 Football stadium attendances, London, 2008/09

Top of page

Chapter 1: Population and Migration

Download entire chapter 1, or by individual table:

Table Title
1.1 Population density at mid-2007
1.2 Annual population change analysis 2001-07, London and England & Wales
1.3 Age structure of London and United Kingdom at mid-2007
1.4 Age-specific birth rates, 1981-2007
1.5 Regional migration flows for selected years
1.6 Inter-regional migration, London 2002-2008
1.7 Inter-regional migration movements within the UK, in the year ending June 2008
1.8 Migration between London and the rest of the UK by age groups, 2006-07
1.9 Average population turnover rates 2001-07
1.10 Households by type: London and England, 2001 and 2007
1.11 GLA 2008 round demographic projections for London: key results from low projection
1.12 GLA 2008 round low projection: borough summary
1.13 Resident population, 1991-2007
1.14 Resident population at mid-2007 by age groups, persons, males, females
1.15 Population change analysis 2006-07, London boroughs
1.16 2001-07 average turnover rates

Top of page

Chapter 2: Diversity

Download entire chapter 2, or by individual table:

Table Title
2.1 Ethnic group population estimates 2001 and 2007
2.2 Ethnic group population estimates by age, London, 2007
2.3 Population by country of birth, 2004 and 2007/08
2.4 Population by nationality, 2004 and 2007/08
2.5 Births by Birthplace of Mother, 2007
2.6 Primary school pupils by ethnic group, January 2008
2.7 Secondary school pupils by ethnic group, January 2008
2.8 Primary school pupils by ethnic group, January 2008, London boroughs
2.9 Secondary school pupils by ethnic group, January 2008, London boroughs

Top of page

Chapter 3: Labour Market

Download entire chapter 3, or by individual table:

Table Title
3.1 Unemployment rates, working-age, July 2007 to December 2008
3.2 Employment rates (working-age) by gender and region, 2007
3.3 Reasons given for working part-time second quarter 2007
3.4 Employment by occupation, working-age residents, 2007
3.5 Occupational composition of employee jobs, 2001 and 2007
3.6 Employment rates, persons working-age, for London boroughs, 2007
3.7 Employment rates by gender, working-age, 1997-2008
3.8 Employment rates of working-age persons, by parenthood, 2007
3.9 Employment rates for London’s twenty largest working-age populations by nationality, 2007
3.10 Model based unemployment rates for London boroughs, 2007
3.11 Median gross weekly resident-based earnings, by region 2008
3.12 Gross weekly earnings, 2008
3.13 Gap between median full-time earnings of males and females, 1968-2008
3.14 Year on year increase in earnings 1968-2008 (five year intervals)
3.15 Trends in median full-time gross weekly earnings of employees by gender, 1966-2008
3.16 Median weekly earnings - All employee jobs by occupation: UK and London, 2008
3.17 Employment and unemployment rates by gender, October to December 2008
3.18 Employment rates by region, lowest and highest local authority rates, working-age persons, 2007
3.19 Employment rates (working-age) by gender, for London boroughs, including self-employed, part-time and unemployment rates, 2007
3.20 Employment rates, working-age, 2007
3.21 Projected resident labour force in 2016 (PLP Low): borough summary
3.22 Number of people in work by place of residence and work (main job), 2007/08

Top of page

Chapter 4: Skills

Download entire chapter 4, or by individual table:

Table Title
4.1 Highest qualification held, London and UK, working-age, 2007
4.2 Working-age London residents by qualifications and age group, 2007
4.3 Highest qualification of London residents born overseas, by year of arrival to UK, working-age, 1946-2007
4.4 Highest qualification of the working-age population by ethnicity, London, 2007
4.5 People employed in London by highest qualification held, 2007
4.6 Highest qualifications of people in employment, by job location, 2007
4.7 Age profile of residents in employment, 2007
4.8 Percentage of residents in employment with Level 4 and above qualifications by age, 2007
4.9 Qualifications of the London workforce - commuters and resident workers, 2007
4.10 London workforce by occupation and qualification level, 2007
4.11 London workforce by industrial sector and qualification level, 2007
4.12 Employment rates of working-age Londoners, excluding students, by qualification level, 2007
4.13 Pupils obtaining five GCSE’s A*-C, 2000-2008
4.14 Pupils with five A*-C GCSEs including English and Mathematics, 2007/08
4.15 Percentage of young people with level 3+ qualifications, 2005-08
4.16 UCAS accepted applicants by London residents, 2003-2008

Top of page

Chapter 5: Economy

Download entire chapter 5, or by individual table:

Table Title
5.1 Workplace GVA in current basic prices: by region, 2007
5.2 Gross value added (GVA) at current basic prices, 2004-2007
5.3 Growth of headline Workplace-based GVA at current basic prices: by region, 2006/07
5.4 GVA by broad industry group, 2006
5.5 UK, London share of GVA by industry groups at current basic prices, 2006
5.6 London GVA: Business Services & Finance: NUTS3, 1995 to 2006
5.7 Regional percentage differences in GVA per person from the UK average, 2007
5.8 Components of GDHI: London, 2007
5.9 Headline gross disposable household income per person, 2007
5.10 Growth headline GDHI per person at current basic prices, 2006/07
5.11 Headline gross disposable household income per person and components, 2007
5.12 Index GVA per hour worked, 2007
5.13 Comparison of regional economic indicators: by region, 2007
5.14 GVA generated by different industry groups, 2006
5.15 London GVA per employee job, by industry groups, 2006
5.16 EDI Income score data by region, 1999-2005
5.17 (map) Rank of overall Economic Deprivation Index score 2005
5.18 Population weighted average rank overall Economic Deprivation Index 2005
5.19 Rates of employment and income deprivation by region, 2005
5.20 Workplace-based gross value added (GVA) at current basic prices, 1992 to 2007
5.21 Gross disposable household income, 2000 to 2007
5.22 Gross disposable household income, 2004 to 2007
5.23 Labour Productivity, 2000 to 2007

Top of page

Chapter 6: Business

Download entire chapter 6, or by individual table:

Table Title
6.1 Enterprise counts and enterprises per 10,000 residents: by region, 2007
6.2 Share of total UK registered enterprises, by location and industrial sector, 2008
6.3 Share of total UK registered enterprises, by location and employment size band, 2008
6.4 Share of total UK registered enterprises, by turnover size band, 2008
6.5 Workforce jobs in London 1996 Q1 - 2008 Q3
6.6 Employee jobs, by sector London 2007
6.7 London share of GB employee jobs, by sector, 2007
6.8 Employee jobs, by ward, 2007
6.9 Private sector London employment, by size of firm, 2007
6.10 Stock of VAT-registered enterprises per 10,000 resident adult population, 1998-2008
6.11 Business start-up and closure rates, 1995-2007
6.12 Percentage of enterprises surviving three years: by year of birth and region, 2003, 2004, 2005
6.13 Share of total UK registered enterprises, by age of business, 2008
6.14 Number of VAT and/or PAYE based enterprises in London by industrial sector, 2008
6.15 Employee jobs in London, by industrial sector, 2007
6.16 Employee jobs in London in Business Services, by sector, 2007
6.17 Self-employment in London by industrial sector, 2007

Top of page

Chapter 7: Income and Lifestyles

Download entire chapter 7, or by individual table:

Table Title
7.1 Households with high and low weekly incomes, 2006/07
7.2 Distribution of income liable to tax, 2006/07
7.3 Households by type of savings and assets 2005/06-2006/07
7.4 Households by state support receipt and region, 2006/07
7.5 Average household expenditure on Health and Education in relation to the UK 2005/06-2006/07
7.6 Expenditure on household food & drink, 2005/06-2006/07
7.7 Household purchases for consumption outside of the home 2004/05-2006
7.8 Percentage of households with selected durable goods, 2005/06-2006/07
7.9 Households with Internet access, 2005/06-2006/07
7.10 Households with Internet access 2000-2007 (Three-year rolling averages)
7.11 Number of new vehicle registrations per 1,000 population 1996-2007
7.12 Cinema admissions by television region, 2007
7.13 Household weekly spending on package holidays in the UK and overseas, 2005/06-2006/07
7.14 Tourism spend of UK and overseas visitors, 2007
7.15 Number of overseas tourist visits, 2003-2007
7.16 Expenditure from overseas tourists, 2003-2007
7.17 Tourism by residents, 2007
7.18 Households by total weekly household income, 2006/07
7.19 Household income: by source, 2006/07
7.20 Household expenditure: by commodity and service, 2005/06-2006/07
7.21 Expenditure on household and eating out food & drink, 2005/06-2006/07

Top of page

Chapter 8: Poverty

Download entire chapter 8, or by individual table:

Table Title
8.1 Risk of being in income poverty by age, London and UK 2004/05-2006/07
8.2 Risk of children Living in households with low income, 2004/05-2006/07
8.3 Percentage point difference between before and after housing cost risk of children living in poverty, 2004/05-2006/07
8.4 Percentage of working-age adults living in households with low income, 2004/05-2006/07
8.5 Percentage of pensioners living in households with low income 2004-07.
8.6 Percentage of work-rich and workless households: Second quarter 2008
8.7 County Court Judgements, 2004-05
8.8 Value of CCJs per person, 2004-05
8.9 Claimant rates by benefit type - summary, August 2008
8.10 Benefit claimants, 2001-2007
8.11 Housing Benefit and Council Tax Benefit claimant rates, August 2007
8.12 Working-age households by combined economic activity status of household: second quarter 2008
8.13 Income Support claimants: rates and borough rankings, August 2008
8.14 Children in families dependent on benefits: rates and borough rankings, August 2007

Top of page

Chapter 9: Emergency Services

Download entire chapter 9, or by individual table:

Table Title
9.1 Total recorded crime by region, 2007/08
9.2 Recorded crime rates by region, 2007/08
9.3 Crime rates in most similar police force areas, 2007/08
9.4 Recorded crime per borough 2007/08
9.5 Crime rates per 1,000 population, 2007/08
9.6 Top ten recorded crime rates by crime type and police force area, 2007/08
9.7 Crime types as proportions of all recorded offences, 2007/08
9.8 Recorded crime trends in Metropolitan Police area by type, 1998/99-2007/08
9.9 Crime types in London, 2006/07 and 2007/08
9.10 Crime detection rates by region, 2007/08
9.11 Crime detection rates by type and region, 2007/08
9.12 Computer Aided Dispatch (CAD) calls received by borough, 2007/08
9.13 Number of I grade calls to police, by borough, 2007/08
9.14 Numbers of I and S calls, 2001/02-2007/08
9.15 Most common CAD calls by type 2007/08
9.16 CAD calls related to traffic offences in London, 2007/08
9.17 CAD calls for Anti-Social Behaviour in London, 2007/08
9.18 Youth victims by total offences and persons accused that were young people, 2007/08
9.19 Youth Victims by selected category, 1998/99 to 2008/09
9.20 Youth Accused by selected category, 1998/99 to 2008/09
9.21 Youth Victims and Accused by major and minor category, 2008/09
9.22 Number of emergency incidents responded to, 2000/01-2008/09
9.23 Incidents recorded on Triage system, by category, 2008/09
9.24 Chief Complaints, by number and share, 2008/09
9.25 Monthly demand pattern, 2008/09
9.26 Hourly and day of the week demand pattern, 2008/09
9.27 Number of incidents per 100 population, 2008/09
9.28 Age profile of patients, by sex, 2008/09
9.29 Fire Stations in London, 2008/09
9.30 Emergency calls and incidents attended, 2001/02-2008/09
9.31 Incidents attended in 2008/09
9.32 Total incidents attended, 2001/02-2008/09
9.33 Total incidents attended, 2008/09
9.34 Primary fires attended, 2008/09
9.35 Proportion of primary fires by type, 2008/09
9.36 Secondary fires attended, 2008/09
9.37 Special service incidents attended by type, 2008/09
9.38 Incidents of people shut in lifts attended, 2001/02-2008/09
9.39 Special service incidents attended by ward, 2008/09
9.40 False alarms originating in non-domestic buildings, 2001/02-2008/09
9.41 Hoax calls attended and not attended, 2008/09
9.42 Incidents by borough, 2008/09

Top of page

Chapter 10: Health

Download entire chapter 10, or by individual table:

Table Title
10.1 Smoking prevalence by ethnic group, London, 2006
10.2 Adults who did not drink alcohol in previous week, 2007
10.3 Adults who did not drink alcohol in previous week, by ethnic group in London, 2006
10.4 Children at risk of being obese at Reception and Year 6, English Strategic Health Authorities, 2007/08
10.5 Prevalence of children at risk of being obese at Year 6 by PCT, 2007/08
10.6 Numbers of selected STIs diagnosed in London GUM clinics by year of diagnosis, 1998-2007
10.7 HIV infected persons accessing care, London and the rest of England, 1998-2007
10.8 Under-18 conception rates per 1,000 girls aged 15-17, London boroughs, 2007
10.9 Life expectancy at birth, by sex, London and England, 1995-97 to 2005-07
10.10 Life expectancy at birth, directly age-standardised mortality rates, and infant mortality, England, London and London boroughs, 2005-07

Top of page

Chapter 11: Housing

Download entire chapter 11, or by individual table:

Table Title
11.1 Net conventional housing completions in London, 1998 to 2007/08
11.2 Mix-adjusted average price of new and existing homes in London, 2002 to 2008
11.3 Housing sales by region, third quarters 2007 and 2008
11.4 Affordability of first-time buyer mortgages in London, April 2005 to January 2009
11.5 Index of mortgage possession orders made, 1987 to 2008
11.6 Empty homes in London, 1978 to 2008
11.7 Trend in average weekly rent by property type and size, London, 2002 to 2008
11.8 Overcrowding rates by tenure in London, 1995 to 2007
11.9 Net conversions of houses and flats by London borough, 2004/05 to 2007/08
11.10 Net housing supply by borough 2007/08
11.11 Median and lower quartile house prices and ratios of prices to earnings, by London borough, 2008 Q2
11.12 House purchase loans, all buyers, number, value and affordability, UK standard regions, 2009, Q1
11.13 Homeless households in priority need accepted by local authorities, by region, 2008

Top of page

Chapter 12: Environment

Download entire chapter 12, or by individual table:

Table Title
12.1 Carbon dioxide emissions, 2006
12.2 Ecological Footprint, 2004
12.3 Relative annual mean pollutant concentrations (CO, PM10 and SO2) monitored at several sites in London, 1996-2009
12.4 Relative annual mean pollutant concentrations (NOx, O3, NO2) monitored at several sites in London, 1996-2009
12.5 Average SOA indicator scores for air quality, Indices of Multiple Deprivation, 2007
12.6 Combined Air Quality indicator from the Indices of Multiple Deprivation 2007
12.7 Total Final Energy Consumption by sector, 2006
12.8 Electricity Consumption, 2007
12.9 Gas Consumption, 2007
12.10 Land use, 2005
12.11 Density of new dwellings per hectare, 1989-2007
12.12 Proportion of new dwellings built on previously developed land, 1989-2007
12.13 Proportion of planning applications granted, third quarter 2008
12.14 Proportion of new dwellings built in within areas of high flood risk, 1989-2007
12.15 Properties located within a floodplain, 2006
12.16 Percentage of river length in the Thames region graded good or better for chemical quality, 1993-2007
12.17 Percentage of river length in the Thames region with high levels of selected nutrients, 1990-2007
12.18 Biological river quality, 2007
12.19 Household waste recycled or composted, 2006/07 and 2007/08
12.20 Percentage of municipal solid waste sent to landfill, 2007/08
12.21 Disposal of municipal solid waste by method, 2007/08
12.22 Fly tipping incidents, 2007/08
12.23 Proportion of properties located within a floodplain, 2006
12.24 Local Authority waste statistics, 2007/08

Top of page

Chapter 13: Transport

Download entire chapter 13, or by individual table:

Table Title
13.1 Mean time taken to travel to work, fourth quarter 2008
13.2 Passenger journeys on London Underground 1987/88 to 2007/08
13.3 Passenger kilometres on London Underground 1987/88 to 2007/08
13.4 People entering central London during the morning peak 7-10am, by mode of transport: 1997-2007
13.5 Bus Traffic in London, 1997-2007
13.6 Road Traffic on Major Roads, 2007
13.7 Motor vehicle traffic per household 1993-2006
13.8 Distribution of accidents on major roads, 2007
13.9 Percentage reduction in fatal or serious road accidents, 1994-1998 to 2007
13.10 Casualties by type of road user, 2007
13.11 Households with regular access to cars, 2007
13.12 Air Transport Movements, 1998-2008
13.13 Terminal Passengers, 1998-2008
13.14 Time taken to travel to work by mode of travel, fourth quarter 2008
13.15 Usual method of travel to work, fourth quarter 2008
13.16 Contributory factors attributed to accidents by vehicle type, in London and in the rest of Great Britain: 2007
13.17 Licensed Vehicles per thousand population by type of vehicle, 2007

Top of page

2009 Facts

On average, weekly household expenditure in London was £529.30, 17 per cent more than the UK figure