Guide to using MAIDeN data

Shared by: guy23
-
Stats
views:
12
posted:
1/10/2009
language:
English
pages:
18
Document Sample
scope of work template
							Guide to Using MAIDeN Data


Contents

1.     General features of MAIDeN Information
       Confidentiality
       Accuracy
       Quality Control

2.     Data held by MAIDeN

          a)     Populations and households
          b)     Ethnicity
          c)     Benefits and Income
                      National and local benefits
          d)     Childcare
          e)     Community Safety
                      Including crime, young offenders and road safety
          f)     Education
          g)     Build Environment and Housing
          h)     Health
          i)     Social Services
          j)     Indices of Deprivation


3.     Making Comparisons
       Percentages, Ranks and Rates

4.     Matrices
       Understanding colour coding




Data Guide May 2005                         www.maiden.gov.uk info@maiden.gov.uk
1.     General features of MAIDeN Information

       Confidentiality of MAIDeN Information

       Access to the MAIDeN Website is restricted to local public sector and
       community organisations. MAIDeN information can be made available to other
       organisations working for to improve community services in Gloucestershire.
       MAIDeN data is designed to support public sector partnership development,
       integrated service planning and bidding activity. Information available from
       MAIDeN is not intended to be public information.

       Partners who contribute information to MAIDeN do so on the understanding
       that people will work with that information in a sensitive and professional
       manner.

       Information will be not be supplied that allows individuals to be identified.
       Where information has been supplied by partners and is not generally in the
       public domain, data will not be released for areas smaller than the smallest
       ward in Gloucestershire (1500 people).

       Accuracy

       MAIDeN has been designed to provide information for small geographic areas,
       where previously data was only available at district or county level. We don‟t
       hold any personal or real-time information. We tend to take snapshots of data
       e.g. a count of home care users on the 31st March. Allocation of users to small
       areas is also subject to the accuracy of postcode and location recording in the
       original datasets, which may lead small area figures being less than district or
       county totals.

       Therefore our figures are estimates not absolute counts, but will give an
       indication of need or service use, and allow comparisons to be made between
       areas.

       MAIDeN Quality Control

       We try to ensure that when we analyse data. we count the right things in the
       right places. When you look at MAIDeN information for your particular patch, if
       you find that the numbers look wrong, or don‟t fit with your experience please
       get in touch with us so we can investigate.




Data Guide May 2005                            www.maiden.gov.uk info@maiden.gov.uk
2)     Data held by MAIDeN

       The data on the website is the most commonly requested items, shown at
       ward level. Other information listed below or other geographies, is available by
       contacting us. This allows us to ensure that data released does not risk
       identifying individuals.


       a) Populations and households

       Population estimates
       Source: 2001 Census
       Source: Gloucestershire County Council

       Most of the population data on the website is from the 2001 Census.

       We can also help you get hold of the latest Population estimates (mid 2005).
       These are available from the Corporate Research Team at Gloucestershire
       County Council. This team produces annual population estimates for
       Gloucestershire wards and parishes, based on the most recent official
       estimates of population for Local Authority Districts (published annually by the
       Office of National Statistics). The electoral registers, and records of GP
       registrations, are used to model District level population estimates down to
       local areas. For more details contact the county council research team on
       01452 425551, research@gloucestershire.gov.uk. This information is also
       available from the website www.gloucestershire.gov.uk. Follow the links to
       “About Gloucestershire” and then “Facts and Figures”.

       We show populations in age bands but single years or other bands are
       available on request.


       Households
       Source: 2001 Census
       We have counts of households and the characteristics of households.


       Births
       Source: Public Health Information Unit – Cheltenham and Tewkesbury PCT

       We have a count of births in the five years 1999 to 2003.




Data Guide May 2005                             www.maiden.gov.uk info@maiden.gov.uk
       b) Ethnicity and language

       Ethnicity
       Source: 2001 Census
       We have data on the ethnicity of the population using the standard census
       classifications.

       White (British, Irish, other); Mixed (White and Black Caribbean, White and
       Black African, White and Asian, Other); Asian (Indian, Pakistani, Bangladeshi,
       other); Black (Caribbean, African, other); Chinese; and Other.

       On request we can provide age breakdowns.


       Children with English as an Additional Language
       Source: GCC Education, Research and Monitoring

       This is from the 2004 Pupil Level Annual School Census

       List of languages spoken in Gloucestershire
       Source: GCC Social Services Circle

       This is only available for the whole county.




Data Guide May 2005                            www.maiden.gov.uk info@maiden.gov.uk
       c) Benefits and Income

       National Benefits
       Source: Department of Work and Pensions 2005
       This data is for 2005 and has been released for the first time below ward level.
       Data is now available down to Lower Super Output Area level. Detailed
       descriptions of people eligible to claim each benefit is available from
       www.dwp.gov.uk/lifeevent/benefits

       Attendance Allowance
       This is for people over 65 requiring help with personal care. We have figures
       for claims at the both the higher and lower rates.

       Disability Living Allowance
       This is for people disabled before the age of 65, including children. There are
       two components, mobility and care, depending on need.

       Incapacity Benefit and Severe Disablement Allowance
       These are for people of working age, who are not able to work. Data is
       available for people aged under 50, 50 and over, claiming for 24 months or
       more, and male/female.

       Income Support
       This is for people aged 16 to 60, who are not required to work or work less
       than 16 hours a week, and have insufficient income to live on. Other benefits
       apply to people over 60.
       Data is available for all claimants and for lone parents.

       Pension Credit
       This is for people aged over 60 and replaces the Minimum Income Guarantee.
       We can also provide counts of people over 75.

       State Pension
       This available by gender and for 65-74, and 75+ age bands.

       Job Seekers Allowance
       We have this by age 16-24 24-49 and 50+, and gender.

       Other breakdowns of the data e.g. more detailed age bands, are available at
       the higher levels of geography – district or middle super output areas.




Data Guide May 2005                            www.maiden.gov.uk info@maiden.gov.uk
       Local Benefits
       Source: District Councils in Gloucestershire

       Housing Benefit
       We have counts of household claiming housing benefit at 1st October 2004.

       Council Tax Benefit
       We have counts of households claiming council tax at 1st October 2004.


       Income
       Source: CACI 2005
       This is private sector data based on self-reporting.

       Household Income
       We have Household Income under £5,000; Household Income over £100,000
       per year in 2002; and average household income.

       Retirement Provision
       We have counts of people “not confident of provision for retirement”.

       Internet Access
       We have details of people with access to the internet at home and of people
       using the internet for home shopping.




Data Guide May 2005                            www.maiden.gov.uk info@maiden.gov.uk
       d) Childcare
       Source: Early Years and Childcare Development Partnership

       These are counts of all registered childcare places in February 2004. They are
       counts of maximum places but capacity may be lower depending on the age of
       children using the facility. Details are available for:

       Full Daycare;
       Sessional Daycare;
       Childminder place;
       Crèche Places; and
       Out of School Care.




Data Guide May 2005                           www.maiden.gov.uk info@maiden.gov.uk
       e) Community Safety

       Crime
       Source: Gloucestershire Police
       Data is available for the financial years 2001/2, 2002/3 and 2003/4.

       The following key crimes are available:

       Violent Crime
       All recorded crimes under the Home Office categories of Sexual Offences,
       Robbery and Violence against the person.

       Domestic Burglary
       All recorded burglaries of people's homes (i.e. excludes burglaries of non-
       dwellings and commercial premises).

       Theft of Vehicle
       All recorded crimes of theft or unauthorised taking of a motor vehicle and
       aggravated vehicle taking.

       Theft from Vehicle
       All recorded crimes of theft from a motor or other vehicle.

       Contact our Community Safety Analyst for more recent and detailed figures.


       Young Offenders
       Source: Gloucestershire Youth Offending Service
       Data available for financial year 2003-4

       This is a count of young people aged 10 to 19 on the caseload of the Youth
       Offending Service.



       Road Traffic Accidents
       Source: Gloucestershire County Council
       Data available for the three financial years from 2001 to 2004.

       We have counts of all serious and fatal Road Traffic Accidents.

       The severity of a Road Traffic Accident is assessed by Police Officers attending
       the scene, who work to national guidelines. Fatal injury includes only those
       cases where death occurs in less than 30 days as a result of the accident.
       Examples of „serious‟ injury are: fracture; internal injury; severe cuts;
       crushing; burns (excluding friction burns); concussion; severe general shock
       requiring hospital treatment; detention in hospital as an in-patient, either




Data Guide May 2005                               www.maiden.gov.uk info@maiden.gov.uk
       immediately or later; injuries to casualties who die 30 or more days after the
       accident from injuries sustained in that accident.




Data Guide May 2005                            www.maiden.gov.uk info@maiden.gov.uk
       f) Education

       School age learning
       Source: Gloucestershire County Council, Education Department, Research and
       Monitoring Unit

       Key Stage results
       We have counts of pupils not meeting the target level in Key Stage 1,2, and 3
       tests in 2003.

       GCSE
       Pupils obtaining 5 or more GCSE passes A* to C in 2002 and Pupils obtaining 1
       or more GCSE passes.

       Free School Meals
       We have counts of primary school pupils eligible for free school meals in
       January 2004.


       Adult learning

       Further Education
       Source: Learning and Skills Council –Individual Student Records
       We have counts, for the academic year 2001/2, of all students registered for
       Further Education (FE), of the total number of FE Guided Learning Hours
       delivered to residents, of Full-time, full year FE students, of FE students at
       evening classes, of FE Students aged under 20.

       Not in Education, Employment or Training (NEET)
       Source: Connexions
       Counts of people aged 16 to 18 not falling into one of the above categories.

       Basic Skills
       Source: DFES Skills for Life Survey 2003
       This covers numeracy, literacy, IT skills and ESOL.
       This is at district and ward level and estimates the number of people with
       entry level, level one and level 2 skills.

       Libraries
       Source: Gloucestershire Library Service
       We have counts of the number of people borrowing children’s books from
       libraries in August 2005. We have counts of the number of people
       borrowing books from libraries in August 2005.




Data Guide May 2005                              www.maiden.gov.uk info@maiden.gov.uk
       g) Built Environment

       Domestic Building Control Applications
       Source: District Councils
       Counts of applications for Building Regulation Approval between April and
       September 2004. This does not include new builds.

       Planning Applications
       Source: Gloucestershire County Council Land Use Monitoring
       Counts for 2004.

       Fuel Poverty
       Source: Severn Wye Energy Agency
       Data available for 1998 wards. Counts of households in fuel poverty. This is
       usually defined as people needing to spend more than 10% of their income to
       keep warm. It is a combination of low income and poor energy efficiency.

       Housing
       Source: 2001 Census
       The census records various characteristics of houses including, type (e.g. flat,
       detached etc), central heating, overcrowding, shared facilities, tenancy or
       ownership, lowest floor level.




Data Guide May 2005                            www.maiden.gov.uk info@maiden.gov.uk
       h) Health Information
       Source: Public Health Information Unit, Cheltenham and Tewkesbury Primary
       Care Trust

       Hospital Admissions
       This is for the 5 year period 2000 to 2004. We have counts of Emergency
       Admissions and Admissions Following and Accident. We can also provide some
       age breakdowns e.g. children or older people.

       Deaths
       This is for the 10 year period 1995 to 2004. We have counts of all people
       dying before the age of 75. More details are available for deaths from cancer,
       respiratory disease and circulatory disorders before age 75.

       Low Birth Weight
       This defined as under 2500g. This is for the 5 years 1999 to 2003.




Data Guide May 2005                           www.maiden.gov.uk info@maiden.gov.uk
       i) Social Services
       Source: Gloucestershire Social Services STAR system

       Adults
       Open and active cases
       This is a snapshot of cases at 31st March 2006 for adults and 2003 for
       children.
       Counts of all cases and of under 16s and older people.

       Referrals 2005/6
       These are counts for the whole financial year.

       Home Care
       This is a snapshot of cases at 31st March 2006.
       Counts of adults and/or older people receiving a home care service.

       Category
       We can also provide details of service received e.g. learning difficulties, mental
       health etc.


       Children
       We have the results from the Children in Need Census 2005.




Data Guide May 2005                             www.maiden.gov.uk info@maiden.gov.uk
       j) Indices of Deprivation
       Source: Office of the Deputy Prime Minister

       The latest indices are the Indices of Deprivation 2004 (IoD2004). For more
       information see www.communities.gov.uk/indices. The scores were
       calculated at Oxford University, using data provided by national agencies.
       These are national measures and are therefore powerful evidence to use in
       bids to central government or for European funding.

       The data is available at Lower Super Output Area (SOA) level for over 32,000.
       areas across England. Previous indices used wards, but due to boundary
       changes and changes in the items measured the indices are not directly
       comparable.

       These indices are usually expressed as a ranking or a percentage. There are
       32482 SOAs in England, (e.g. an SOA ranking 3200 would be in the top 10%
       and would be assessed as having a high level of deprivation). We also show
       the actual score.

       A detailed description of what each domain measures is available at
       www.maiden.gov.uk/Documents/GuidetoIoDDomains.doc

       Index of Multiple Deprivation
       This is the headline figure and combines the scores of the other domains.

       Income Domain
       Also Income Deprivation affecting Children
            Income Deprivation affecting Older People

       Employment Domain

       Health Deprivation and Disability Domain

       Education, Skills and Training Domain

       Barriers to Housing and Services Domain
       This can be further broken down into:

              Wider Barriers – affordability of housing, homelessness, housing in
              poor condition; and

              Physical Barriers – road distance to a GP, Post Office and Food store.
              This is an area where the rural parts of Gloucestershire score very
              poorly.

       Crime Domain

       Living Environment



Data Guide May 2005                           www.maiden.gov.uk info@maiden.gov.uk
       These scores come from the Indices of Deprivation 2004, published by the
       Office of the Deputy Prime Minster. For more information see
       www.odpm.gov.uk/indices. The scores were calculated at Oxford University,
       using data provided by national agencies (Benefits Agency for example), and
       published for over 32,000 Super Output Areas (SOA) across England.
       We have provided the deprivation scores for each SOA , and ranks (most
       deprived ward ranked 1) within England and within the County.


       Older Indices
       We also have details of the Indices of Deprivation 2000, and the Index of
       Local Deprivation 1998 which are available on request.




Data Guide May 2005                           www.maiden.gov.uk info@maiden.gov.uk
3.     Making comparisons

       Percentages
       Where a percentage is quoted this will be a comparison of the data to the total
       population that could have been in that category. E.g. the number of young
       offenders will be quoted as a percentage of people aged 10 to 19.

       Ranks
       We often rank data so that you can quickly see how it compares to other
       similar areas. A rank of 1 will always indicate the highest deprivation. The
       ranges commonly used are:

       Wards 1 to 142 in Gloucestershire
       Super Output Areas 1 to 32454 (within England)
       Super Output Areas 1 to 367 (within Gloucestershire)
       Census Output Areas 1 to 1944 in Gloucestershire


       Rates
       These are used in a similar way to percentages, but also allow you to easily
       see if an area is significantly different from the average for the county or
       district. As a quick guide a rate of:

                      1     indicates the area is average
                      1.5   indicates 50% more than average
                      2     indicates double the average
                      0.5   indicates half the average

       Some of the counts we are dealing with here are small numbers. Where small
       numbers are involved you will often find very high or very low rates. If you are
       using the rates in your work, make sure you understand the actual numbers
       behind the rates.




Data Guide May 2005                            www.maiden.gov.uk info@maiden.gov.uk
       Example of calculation of rates
       Rates tell you how big or small your counts are. For example, you might know
       that there were 39 emergency admissions of older people in an area, but not
       know if that was a lot or not very many. Given a particular population of older
       people, how many emergency admissions might you expect?

       The rates compare what‟s happening in the area to what‟s happening across
       the whole county or within a district. We can calculate what percentage of the
       county‟s older people live in any area, and the percentage of emergency
       admissions coming from that area.

       If an area has 2% of the County‟s older people then we might expect it to
       have 2% of the corresponding emergency hospital admissions. If in fact, older
       residents of the area account for 4% of County admissions, it will have a rate
       of 2. In this example the figure of 39 is double what we might expect, given
       the number of older people living in the area.

       You can think of the rate as describing „likelihood‟ – an older person from the
       area is twice as likely than a „random‟ older person selected from the whole
       County, to have experienced an emergency admission to hospital.




Data Guide May 2005                            www.maiden.gov.uk info@maiden.gov.uk
4. Understanding Matrices

MAIDeN produces matrices or toolkits which summarise a lot of data. The matrices
use colours instead of presenting numbers.

Often for reasons of confidentiality we can’t disclose the actual data for small areas.
What we do in the matrices is use colours to indicate high, medium or low scores.

Red           indicates the top 10%
Amber         the next 25% (i.e. in the top 35%)
Green         is the rest


In the example matrix below we have shown 4 wards being rated on 3 different
factors which indicate deprivation for older people.

Ward name             Total Score     Older People       Older People     Older People
                        for Older         Factor 1           Factor 2         Factor 3
                          People
Bridge                        1.0                   1
Farmlands                     0.5                                  0.5
New River                     2.5                    1               1                0.5
Woodley                       1.5                  0.5             0.5                0.5


Where a ward is ranked in the top 10% or red it also scores 1, and where it is in the
next 25% it scores 0.5.

By adding up the scores across all the factors we can get a total “older people” score.
We can then put the wards in order of this score to show the wards with the highest
levels of need for older people.

Ward name             Total Score     Older People       Older People     Older People
                        for Older         Factor 1           Factor 2         Factor 3
                          People
New River                     2.5                    1               1                0.5
Woodley                       1.5                  0.5             0.5                0.5
Bridge                        1.0                    1
Farmlands                     0.5                                  0.5




Data Guide May 2005                             www.maiden.gov.uk info@maiden.gov.uk

						
Related docs