On this page:

Competitive Scottish Cities? Placing Scotland’s cities in the UK and European context

« Previous | Contents | Next »

Listen

Competitive Scottish Cities? Placing Scotland's cities in the UK and European context

Employment

4.43 Data detailing the number of people employed in each city is available for most of the study cities, although the basis on which it is collected varies by city. Data given here is for total employees (part time and full time added together) rather than full time equivalents. Munich, Frankfurt and Stockholm are the major employment centres closely followed by Birmingham. UK cities dominated the lower end of the table.

Figure 4.7: Total employees 2001

Figure 4.7: Total employees 2001

Source: UK Cities ONS/NOMIS Annual Business Inquiry 2001; various city sources

4.44 There is significant variation in the industrial mix of the study cities. Manufacturing still plays a significant role in some cities, accounting for 15% or more of total employment in Dortmund, Munich, Birmingham, Dundee and Sheffield. Table 4.2 shows the proportion of employees working in each sector of the local economy. This data does not show the contribution of each of these sectors to the overall productivity of each city.

Table 4.2: Employment by sector

Agriculture and mining (A+B+C)

Manufacturing (D+E)

Building (F)

Commerce (G)

Hotels and catering (H)

Transport and communication (I)

Banking and insurance (J)

Property, rental and leasing,
business services (K)

Public authorities (L)

Education (M)

Health care and welfare (N)

Public private service
industries (O)

Copenhagen

0.2

7.2

2.7

16.1

9

24.1 (I &J)

10.4

6.6

5.3

8.7

9.2

Dortmund

0.8

17.7

7.3

15.6

2.6

7.5

6.1

15.9

5.3

4.2

12.1

4.8

Frankfurt

0.2

11.4

3.1

10.5

3.6

14.8

15.8

23.5

17.1 (L, M, N & O)

Munich

0.3

21.8

3.3

13.4

3.8

4.7

9

19.2

4.9

3.3

9.2

6.8

Lyon

1.2

9.5

3.7

13.8 (G & H)

4.7

6.8

4.7

6

12.7 (M & N)

8.8

Helsinki

0

10

4.4

17 (G & H)

9.5

5

18

34.8 (L, M, N & O)

Amsterdam

0.1

5.9

3

13.3

5.6

8.1

10.6

21.3

7.1

5.8

12.7

6.4

Rotterdam

0.2

10.4

5.3

13.5

2.9

12.7

6.2

19.2

5

6.7

13.5

4.3

Stockholm

0.2

7.7

3.7

19.5 (G & I)

28.2 (J & K)

6.3

7.9

14.6

11.5
(H & O)

Barcelona

0.1

14.5

5.4

15.9

5.2

6.1

5.4

20.6

7.2

5.2

6.9

7.5

Birmingham

0

17.5

3.6

14.2

4.8

6.3

5.4

16.2

5.1

9.7

11.4

5.8

Bristol

0.1

11.6

4.8

16.1

4.6

5.2

8.4

19.8

5.3

10.1

9.1

4.9

Leeds

0.2

14.5

4.8

17.6

4.6

6.9

5.4

16.8

4.6

8.6

10.7

5.4

Liverpool

0

8.7

2.9

16.7

6.9

7.2

6.3

11.5

9.1

9.7

15.1

6

Manchester

0

7.4

2.7

14.2

6.3

9.6

7.2

19.4

5.6

11.6

11.2

4.7

Newcastle

0

7

3.9

12.8

6.1

4.5

3.9

17.1

13.4

10.2

15

5.8

Nottingham

0.2

12.1

3.1

19

5.8

4.4

2.9

19

5.5

9.8

14

4.7

Sheffield

0

15.8

4.6

18.8

5.1

4.5

5.1

11.8

5.1

9.6

13.8

5.7

Aberdeen

10.7

9.2

5.4

14.5

6.3

7.1

1.5

19.6

3.8

6.7

11

4.2

Dundee

0.6

15.3

4.1

19.1

6.4

4

2.4

8

7

12.5

15

5.6

Edinburgh

1.3

6

2.5

13.2

7.5

4.8

14

18.7

6.7

8.5

11.3

5.4

Glasgow

1.2

7.8

4.5

14.3

6.6

6.1

7.7

16.6

8.4

8.4

12.8

5.6

Stirling (LA)

1.6

7.1

4.3

21.0

10.4

3.3

8.9

8.9

6.7

10.5

12.2

5.1

Source: ONS/NOMIS Annual Business Inquiry 2001; various city sources

4.45 The employment data present here is limited, the data in table 4.2 gives the 'total' number of employees; it would be preferable to use 'Full Time Equivalents' but this was not readily available at city level. 'Total number of employees' does not provide an indication of the number of city residents employed in the city and many of these jobs could be taken by in-commuters. Data relating to the economic activity rates - the proportion of working age residents who are in employment - are explored for UK cities in section 2.11 and at a regional (NUTS 2) level in section 3.21 of the main report.

Human Capital

4.46 The OECD's International Standard Classification of Education (ISCED) can be used to convert national qualifications to a standardised scale, making it possible to compare local qualifications on a trans-national basis. ISCED levels 5 and 6 relate to tertiary education and advanced research programmes - degree level or above.

4.47 Where data is available for 1996 and 2001/2 it shows that the proportion of working age residents qualified to degree level has increased in all cities with the exception of Sheffield where the rate has remained static.

4.48 In terms of a highly qualified workforce the Scottish cities appear to be performing particularly well, with 37% of Edinburgh's working age population qualified to degree level or above.

Figure 4.8: Percentage of workforce qualified to degree level or equivalent 2001

Figure 4.8: Percentage of workforce qualified to degree level or equivalent 2001

Source: UK cities ONS/NOMIS Labour Force Survey Annual Database 2001; various city sources
* Data from Urban Audit 2004. This gives the proportion of population qualified to this level rather than just working age population.

Deprivation

4.49 Unemployment has been used here as an indicator of deprivation and as a measure of unused potential. Systems of defining and measuring unemployment vary by country and nationally compiled data in not automatically comparable on a trans-national basis. However, all EU countries use the International Labour Organisation measure of unemployment in their Labour Force Survey:

"Individuals who are out of work but would like a job and are actively seeking and available for employment, or who are out of work and have found a job and are waiting to start In the next two weeks."

4.50 Unfortunately Labour Force Survey results are not available at the local level in all countries and for some cities the regional unemployment rates have been used here.

4.51 In terms of unemployment the UK performs well with some of the lowest unemployment rates across the study cities. The only cities to experience an increase in unemployment between 1996 and 2001 are Frankfurt, Munich, Lyon and Aberdeen.

Table 4.3: ILO unemployment rates 1996-2001

1996

2001

% change

Copenhagen

10.3

7.5

-27.2

Dortmund

14.7

13.5

-8.2

Frankfurt

6.2

7.2

16.1

Munich

4.7

5.0

6.4

Stuttgart

5.8

5.6

-3.4

Lille*

11.0

8.4

-23.6

Lyon*

8.0

12.5

56.3

Toulouse*

10.5

10.2

-2.9

Helsinki

9.0

5.7

-36.7

Milan

6.0

n/a

n/a

Turin

15.3

n/a

n/a

Amsterdam

7.5

6.3

-16.0

Rotterdam

7.2

7.0

-2.8

Stockholm

5.5

3.3

-40.0

Barcelona

10.5

6.5

-38.1

Birmingham

12.3

8.5

-30.9

Bristol

7.6

3.3

-56.6

Leeds

8.5

3.6

-57.6

Liverpool

14.3

10.9

-23.8

Manchester

11.6

9.2

-20.7

Newcastle

8.9

8.4

-5.6

Nottingham

8.8

7.9

-10.2

Sheffield

10.1

5.3

-47.5

Aberdeen

5.0

6.1

22.0

Dundee

14.5

9.4

-35.2

Edinburgh

6.9

3.8

-44.9

Glasgow

15.2

11.3

-25.7

Highland

9.4

5.6

-40.4

Inverness

n/a

n/a

n/a

Stirling

n/a

n/a

n/a

Source: UK cities ONS/NOMIS Labour Force Survey Annual Database 2001; various city sources; Urban Audit 2004
Note: *Regional rates given for French cities

Figure 4.9: ILO unemployment rates 2001

Figure 4.9: ILO unemployment rates 2001

Source: UK cities ONS/NOMIS Labour Force Survey Annual Database 2001; various city sources; Urban Audit 2004
Note: *Regional rates given for French cities

Connectedness

4.52 Airport passenger numbers have been used to provide an indication of a city's connectedness. The data presented here relates to the number of terminal passengers at each airport, these are the passengers who leave the aircraft, and the data includes those passengers who transfer to other flights. Consequently those hub airports such as Frankfurt and Amsterdam where a high proportion of passengers change to onward connections have high passenger number. Data giving the number of passengers leaving the airport and the business/tourist split for each city would provide a more robust indicator of connectedness, however this data in not currently available.

Figure 4.10: Terminal air passengers 2002

Figure 4.10: Terminal air passengers 2002

Source: Airports Council International 2002

Innovation

4.53 Innovation is a particularly difficult concept to quantify. Whilst the importance of innovation to successful competitive cities is widely recognised there is not a simple measure that can be used summarise a city's performance in this area. The patents measure suggested in our list of headline indicators is a proxy measure that has limitations and it has not been possible to collect this data at the city level. The European Union has developed an Innovation Index to track the 'EU's progress towards becoming the most competitive and dynamic knowledge-based economy in the world'. The index includes a Regional dimension and this has been used here to provide a proxy measure of innovation. At the Regional level the index contains a Revealed Regional Summary Innovation Index (RRSII), which is generated from the following indicators:

  • Population with tertiary education
  • Participation in lifelong learning
  • Employment in medium/high-tech manufacturing
  • Employment in high-tech services
  • Public R&D expenditure
  • Business R&D expenditure
  • European Patent Office (EPO) High-tech patent applications
  • All EPO applications
  • Plus five measures from unpublished Community Innovation Survey 2 data.

4.54 In terms of innovation in their regions Stockholm and Uusimaa are the strongest performers in Europe.

Figure 4.11: European Innovation Scoreboard 2003: Revealed Regional Summary Innovation Index (RRSII)

Figure 4.11: European Innovation Scoreboard 2003: Revealed Regional Summary Innovation Index (RRSII)

Source: 2003 European Innovation Scoreboard. Technical paper No. 3. EU Regions Data Sources

4.55 The data sources utilised during this project are detailed below. Some are static, some get updated on a regular basis, and some get updated on different basis so the coverage can vary from year to year, both in terms of the indicators and spatial levels

Table 4.4: UK Datasets

Dataset

Source

Annual Business Inquiry

ONS

Mid Year Population Estimates

ONS

New Earnings Survey

ONS

Labour Force Survey

ONS

NUTS3 (sub-regional) Gross Value Added

ONS

Claimant 5ount unemployment rate

ONS

Census Scotland

General Register Office for Scotland / SCROL

Census England

ONS/Neighbourhood Statistics

House Price data Scotland

Registers of Scotland Executive Agency

House Price data England

HM Land Registry

SQA Examination results in Scottish schools: 2003

Scottish Executive Education Department

Air passenger numbers

Civil Aviation Authority

Train journey times

The Trainline rail inquiry service www.thetrainline.com

Recorded Crime Statistics

Scottish Executive Statistical Bulletin Criminal Justice Series

Benefit Claimants data

DWP

Table 4.5 European Datasets

European Innovation Scoreboard

European Commission

Air passenger data

Airports Council International

Urban Audit 2004

European Commission

Regions Statistical Yearbook

Eurostat

4.56 All the data sources used come with their own health warnings. Some are more robust than others. Some are based on absolute counts, some on surveys and some on modelling. Survey based data such as the New Earnings Survey and the Labour Force Survey can have relatively small samples in smaller Local Authority areas, this can increase the confidence intervals associated with the data.

4.57 The spatial level at which data is available also varies. Much of the UK data is available at Ward or Local Authority level. Data available across Europe tends to be for larger spatial levels - often NUTS 2 and NUTS 3. The Nomenclature of Units for Territorial Statistics (NUTS) is a hierarchical classification of administrative areas, used across the European Union for statistical purposes.

« Previous | Contents | Next »

Page updated: Tuesday, May 16, 2006