Tuesday, 20 March 2012

Presentation

These are different ways of providing a tabular summary of data

Updated Stats

Another version

What I like about them is that the appearance is clear and uncluttered, even on the second version where the additional data floats above the table.  But you still have to click to remove the additional information, and there is that annoying extra message about multiple tables.  More work needed!

Wednesday, 14 March 2012

March 2012 Stats


The latest information on claimant count unemployment was released earlier today by the Office for National Statistics.  For Glasgow, the details are that 25,540 persons received JSA in February 2012, equivalent to 6.2% of the working age population.  For persons aged 18-24 6,865 claims were made, giving a rate of 9.8% for that particular age group.

Between January and February the total claimant count in Glasgow increased by 680, or by 2.7%; and the increase for the 18-24 age group was 5.0%.  In Scotland the total increased by 2.5%, and for the UK by 2.2%; for the 18-24 group the changes were 4.5% and 3.5% respectively.

On the other hand, between February 2011 and February 2012 the total claimant count in Glasgow fell by 1.1% (from 25,835 to 25,540) whereas in Scotland it increased by 3.1%, and by 9.7% in the UK.  And while claims to the 18-24 age group increased by 5.0% in Glasgow (from 6,535 to 6,865), they went up by 5.9% in Scotland, and by 14.0% across the UK.

The unemployment rate in Glasgow (6.2%) is higher than in Scotland (4.4%) and the UK (4.2%); but is lower than in Manchester, Liverpool and Birmingham.  The rate for the 18-24 age group in Glasgow (9.8%) is higher than in Scotland (8.9%) and in the UK (8.4%).

(For additional information, click on the hyperlinks to get visualisations produced using Google Charts, which open in a separate browser.  Scan the cursor over the columns to get the exact details.  The links can also be opened if you read the email on a Blackberry, i-Phone 4 and Android 3.0 and above.)

Wednesday, 15 February 2012

Glasgow Unemployment

Unemployment in Glasgow can be measured in various ways.  The claimant count measure includes all people that receive Job Seekers Allowance (unemployment benefit) and is produced by the Office for National Statistics each month.  Its main drawback is that it is based on a definition that can be changed through amendments to the welfare benefit system.

An alternative is the estimate of unemployment that comes from the Annual Population Survey (which was the Labour Force Survey), also produced by the ONS.  This is based on a household survey and has the advantage of including people that are unemployed but not eligible for JSA.  It is produced every three months, but around nine months in arrears.

A third option is unemployment according to the Census and which has been produced every ten years: useful for long term longitudinal work, but not for measuring short-term change.

These measures are all counts and have to be set against an appropriate denominator to get a rate.  What age group?: the working-age population has been affected by changes to the retirement age.  As a compromise the male and female 16-64 age group is probably the most suitable, as 16 marks the end of primary and secondary education, although the 64 cut-off for retirement is also under discussion.  The ONS produces an estimate of the 16-64 population as a mid-year estimate and is the best available.  This is not an esoteric discussion, as the ONS itself uses a range of denominators, and the 2001 Census results were based on a 16-74 definition of the working age population, coming as a surprise to many.

Based on this, the most recent estimate of the unemployment rate in Glasgow  is
  • 6.0%, based on a January 2012 claimant count of 24,860 as a percentage of a 16-64 2010 mid-year estimate of 414,700, the most recent available;
  • 8.5%, based on a July 2010-June 2011 Annual Population Survey estimate of 35,400 set against the 16-64 2010 mye (note that the ONS output uses a denominator of 289,900, which makes no sense at all).
A similar approach can be taken to estimating youth unemployment.  JSA is normally only available to people aged 18 and above, and the reporting system uses the 18-24 age group as a template to estimate youth unemployment.  This gives a rate of 9.3%,  based on a January 2012 claimant count of 6,535 as a percentage of a 18-24 2010 mid-year estimate of 69,900.  

The APS for July 2010-June 2011 gives a count of 11,800, but this is based on a larger age group (5,500 aged 16-19; 6,300 aged 20-24) for which an exact denominator is not available (the closest is 35,600 aged 15-19, and 53,300 aged 20-24).  But if you use the 2010 mye, make a pro-rata reduction in the 15-19 age group and add it to the 20-24 total to estimate the 16-24 age group, you get a total of 81,780 and a rate of 14.4%.

Tuesday, 14 February 2012

Glasgow SIMD: Overall Position

Over the three waves of the Scottish Index of Multiple Deprivation between 2004, 2006 and 2009 Glasgow has reduced the number of datazones in the bottom 15% although there has not been a commensurate increase in the number in the top 15%.


The following maps show the of the city in the bottom 15% (in red) and in the top 15% (in blue) in 2004






in 2006




and in 2009






The main change over the decade has been to reduce the amount of the city classified as multiply deprived.  However, and over the same time period, Glasgow's share of Scotland's least deprived areas has not substantially increased.


This video shows the reduction in areas in Glasgow in the bottom 15% from 2004, through 2006 to 2009.



a short test

Test to see if this is accessible.
http://savedbythegoog.appspot.com/?id=289544792a5974e18949c657ddb1bf53bd30892a

also if this works.




While OK in the desktop version, the video is very blurred on the phone.


SIMD version.










insert an image: Jena architecture


Scottish Highlands architecture




Glasgow: Scottish Index of Multiple Deprivation in 2004 ...






... and in 2009






Demographics: proportion of an area aged between 25 and 44 in 1996 ... 




... in 2001 ...



... and in 2010 ...