Resources for check-in #1 - Finding Data


#1

Previous week: Resources for workshop #1
Next week: Resources for check-in #2 - Checking Data

Homework

Resources

Asking for data

Finding data

Useful repositories

  • MapIt - matches geographic points with areas
  • Open Data Communities - The official UK Ministry of Housing, Communities and Local Government linked data platform.

Sources of Data

English Indices of multiple deprivation

What is it?: Statistics on relative deprivation in small areas in England - significant research into poverty in England (Wales and Scotland have their own indices)

Who produces it?: Ministry of Housing, Communities & Local Government - formerly Department for Communities and Local Government (DCLG)

Where can I find it?: Collection from 2000 - 2015 on gov.uk

Other useful links

Devolved Nations - Indices of multiple deprivation

Financial Sustainability of Local Authorities 2018

What is it?: Report on sustainability, financial pressure, and non-financial challenges faced by local authorities - mentioned by Tracey Gyateng of DataKind UK in her session on statutory funding

Who produces it?: The National Audit Office (NAO)

Where can I find it?: Financial sustainability of local authorities 2018

Local Government Transparency Code 2015

What is it?: Document setting out the minimum data that local authorities should be publishing

Who produces it?: Ministry of Housing, Communities & Local Government

Where can I find it?: Guidance: Local government transparency code 2015

Excerpt:

Grants to voluntary, community and social enterprise organisations

Local authorities must publish details of all grants to voluntary, community and social enterprise organisations. This can be achieved by either:

  • tagging and hence specifically identifying transactions which relate to voluntary, community and social enterprise organisations within published data on expenditure over £500 or published procurement information, or
  • by publishing a separate list or register.

For each identified grant, the following information must be published as a minimum:

  • date the grant was awarded
  • time period for which the grant has been given
  • local authority department which awarded the grant
  • beneficiary
  • beneficiary’s registration number
  • summary of the purpose of the grant, and
  • amount.

NCVO Almanac

What is it?: Annual reference publication for UK voluntary and civil society. More resources are available for NCVO members.

Who produces it?: The National Council for Voluntary Organisations (NCVO)

Where can I find it?: 2018 Almanac

Other useful links

Towns and Cities Analysis

What is it?: Statistics on towns and cities in England and Wales with a focus on housing and deprivation. Mentioned in a BBC news article “Most deprived town in England is Oldham, ONS study finds, 18 March 2016”

Who produces it?: The Office for National Statistics (ONS)

Where can I find it?: Towns and Cities Analysis

Other useful links


Resources for workshop #1
Resources for workshop #1
Resources for workshop #1
Resources for workshop #1
Resources for workshop #1
Resources for workshop #1
Resources for workshop #1
Resources for workshop #1
Resources for workshop #1
Resources for workshop #1
Resources for workshop #1
Resources for workshop #1
#2

Hi Edafe,

Thanks for your help!

My question(s) is about Early Childhood Development - what type of ECD services have been most impacted by stat funding cuts and who is working on/funding ECD in the UK.

My reflection:

I will work on refining my question - will probably take out the part about reduction of statutory funding and focus on 360 Giving data; or perhaps the 360 Giving data can help (be a proxy?) identify statutory funding gaps? Will see what comes out as I look through the data!

ECD context:

Here’s an interesting blog from Nesta with links to other resources

360 Giving data:

And here’s the link to the results of my GrantNav search using ‘early AND childhood’ (the other searches I’ve run are ‘early AND years’ and ‘infant*’) - it would be great if you could help me:

  • exclude The Wellcome Trust (although I will look through the research in case there’s something useful as you suggest);
  • understand why some grants that don’t contain the search words are on the list (e.g.360G-EssexF-A436397)

Thanks and have a lovely weekend!
Anna


#3

Where are the poverty related gaps in Trafford due to reduced availability of statutory funding?

Trafford MBC Grant Nav

Number of children in out of work benefit households by local authority (Trafford) / constituency (Altrincham and Sale West, Stretford and Urmston, Wythenshawe and Sale East) / ward: https://www.gov.uk/government/statistics/children-in-out-of-work-benefit-households-31-may-2016

Statistics on towns and cities in England and Wales with a focus on housing and deprivation (Manchester): https://www.ons.gov.uk/peoplepopulationandcommunity/housing/datasets/townsandcitiesanalysis

Financial Sustainability of local authorities: https://www.nao.org.uk/report/financial-sustainability-of-local-authorities-2018/

Trafford Data Lab: https://www.trafforddatalab.io/info.html
Unemployment
**Health life expectancy
violent crime:
Indices of Multiple Deprivation: http://dclgapps.communities.gov.uk/imd/idmap.html

A list of commissioned services overview in Trafford (pdf).

REFLECTION:
There are some good resources for the demographics of Trafford. Trafford is part of Greater Manchester so I had to be careful when considering ‘Manchester’ labelled data, as Trafford is one of the Greater Manchester boroughs, and is different to the area Manchester City Council cover. Our funding pot is for activity in Trafford only so it was important to keep the focus on Trafford and not Manchester.

I would like to find data on the types of things that have stopped being funded/commissioned by Trafford Council. And would like to focus more on getting data to answer the ‘reduced statutory funding’ part of my question.

Side note: the forum has said new users can only put 5 links in a post so I have removed some. Sorry!


#4

My question is - Where are the funding gaps in areas of deprivation?
By ‘where’ I mean geographically and by cause/programme area.
I’m going to use grantnav to search for the areas that are in the bottom 10% at least to start with.

I’ll use the IMD data. And I’ve found this Guardian Datablog (although it’s a few years old) - https://www.theguardian.com/society/patrick-butler-cuts-blog/2013/jan/11/council-cuts-north-loses-out-to-the-south-newcastle#data

I now need to consider how to categorise grants into programme areas.


#5

Thanks so much for posting the resources Anna!

Here’s the search to exclude Wellcome Trust:

early AND childhood AND NOT (fundingOrganization.id:GB-CHC-210183)

The grant that shouldn’t be in the result, is it this one? Covering the tapered grant from Essex County for the Recovery and Therapeutic Support Worker

I think the reason it’s coming up is the Recipient Org: Description - it contains the words in the search. One way to make sure this doesn’t happen, is to only search the grant Title and Description, like so:

(title:early OR description:early) AND (title:childhood OR description:childhood) AND NOT (fundingOrganization.id:GB-CHC-210183)

This gives very few results, so I also tried using a wildcard with child which gives 728 results:

(title:early OR description:early) AND (title:child* OR description:child*) AND NOT (fundingOrganization.id:GB-CHC-210183)

Hope this helps and let me know if you need anything else.


#6

Thanks Bethan. Great reflection and I’m so pleased you’re finding a focus for your question.

You’ve brought up a useful point about geographic areas where the political place may be different from the socio-economic place. Something for everyone looking at places to be aware of.

Thanks for letting me know about the limitation on links. I’ll check with Mor if we can remove those.

All the best


#7

Thanks Abi for sharing your reflection. I’ll check with Mor on work they’ve done in categorising grants. You might have noticed above I posted two links to the most deprived areas - one focused on towns and the other on Local Authorities. The IMD data is by LSOA. Have you considered which of these three ‘places’ you want to focus on?


#8

FYI: The limit of 5 links has been removed - it’s now 20. Thanks again for posting your reflections!


#9

Hi Edafe,

My question is: what and where are the funding gaps in support and care for older people due to reduced availability or termination of statutory funding?

I have found a great data set from NHS Digital called Adult Social Care Activity and Finance, England 2016-17: https://digital.nhs.uk/data-and-information/publications/statistical/adult-social-care-activity-and-finance-report/adult-social-care-activity-and-finance-report-england-2016-17

The CSV data pack has lots of useful data incl. gross current expenditure for clients aged 65+ by care type, primary support reason per region. The only issue with the data set is that it only covers England as opposed to the UK.

For my data search on Grantnav I used a number of key terms which are relevant and my final search was: older people; elderly; “over 50”; almshouse; dementia; arthritis; mobility; “sheltered housing”; “extra care”; “care home”; “social isolation”; “befriending”; “social presc”; “stroke”; “older age”; “old age”; “pensioner”; NOT “Young People”; NOT Youth
And filtered by 2017.
This resulted in grant data for 6,502 grants.

My next step will be looking at how I can combine the data sets to glean useful insights!


#10

Hi Edafe,

I did some background reading into people with no recourse to public funds (NRPF) to help refine my question. This clarified for me that ideally I’m looking to find figures for people who are NRPF and applied to a London council for social services support, but were turned down. So far I’ve found a London Councils report which estimates that 17 London councils are supporting a total of 1,511 NRPF households in London - but the data isn’t broken down by borough. Also, it doesn’t tell me about the people who approached a London council for support but were turned away. This is the report: https://www.londoncouncils.gov.uk/node/23563 I’m thinking I could do an FOI request to ask them for a break-down.

This report mentions that a stronger evidence base is needed. I’m starting to think it might be too difficult to get data on NRPF and I should instead be looking for another indicator of destitution in London, such as homelessness, and look to map my grant-making against this instead.

Alison


#11

Hi Alison

Thanks so much for the link. The report is a very useful summary and leads to interesting information, for example,

  • What are ‘public funds’? Services considered public funds for immigration purposes include:

    • specified welfare benefits
    • specified public housing
  • What aren’t ‘public funds’? Services not considered public funds for immigration purposes
    include:

    • social services care and support
    • compulsory school age state education
    • student grants or loans
    • NHS treatment
    • Certain work-related welfare benefits (e.g. incapacity benefit)

As you’ve discovered, there “no single data source, which provides a comprehensive national view of
local government expenditure (or activity) on NRPF clients” and the report analyses the NRPF Connect database used by “Home Office and local authorities work together to identify and resolve supported cases through the secure exchange of information”. It’s unlikely you’ll get access to this database but you may be able to ask for statistics / data per borough through an FOI request at a later date.

I think it’s a great idea to look at other figures, especially in the light of this quote from ‘Social services support for people with NRPF’:

Assistance provided by social services is not a public fund, so a person with NRPF is not prevented from getting help from their local authority’s social services department, and should not be refused support because they have NRPF.

If you’ll be using a proxy indicator, would ‘rough sleeping’ work? The Rough sleeping in London (CHAIN reports) breakdown rough sleeping population by nationality. Could the count of non-European countries be used as a proxy for NRPF?

  • Other Europe
  • Africa
  • Asia
  • Americas
  • Australasia

The 2017/18 quarter 1 reports included the following London areas, do they work for your needs?:

  • Brent
  • Camden
  • City
  • Ealing
  • Greater London
  • H&F
  • Islington
  • K&C
  • Lambeth
  • Newham
  • Outer
  • Southwark
  • Tower Hamlets
  • Westminster

#12

Hi Ethny

This is a great find! Excellent data sleuthing on GrantNav too and thanks so much for including your search terms and the final count of results. My initial thoughts are you can combine by region to start with. This won’t give you the breakdown by care type which will require a bit more work.

I’ll take a look and see if there’s a better way to do this.

The England-only coverage is a quirk of devolution in the UK. So to find similar figures for Wales, Scotland, and Northern Ireland, you’d have to look at the NHS England equivalents.

Let’s start with England and extend to other countries at a later date.


#13

Hi Edafe,

Great, thank you. I think it’s a good plan to start with England and see how it goes.


#14

Hi Edafe,

I have slightly altered the search terms to “older people”; elderly; “over 50”; almshouse; dementia; arthritis; mobility; “sheltered housing”; “extra care”; “care home”; “social isolation”; “befriending”; “social presc”; “stroke”; “older age”; “old age”; “pensioner”; NOT “Young People”; NOT Youth
and filtered by 2017 to get 2283 results.

This was because a lot of the results weren’t relevant and I realised the first search terms was the issue.

Best wishes,

Ethny


#15

Thanks for the update Ethny, that looks very sensible. Do you need any help combining the data?


#16

Hi Edafe,

If possible, I am having problems as I’m not sure exactly how to combine because it seems that the Grantnav data has different geographic coding to the NHS digital data (and there is a lot missing from the 360 Giving).

Any suggestions?

Thanks,
Ethny


#17

No problem, please forward me the GrantNav data or send me a link to your search (I’m getting more results than you) and let me know which csv files from the NHS digital data you’re looking at (I’m guessing long term support?)

All the best

Edafe


#18

Thank you! Here is the link to my search: http://grantnav.threesixtygiving.org/search?json_query=%7B%22query%22%3A+%7B%22bool%22%3A+%7B%22filter%22%3A+%5B%7B%22bool%22%3A+%7B%22should%22%3A+%5B%5D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%5B%5D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%5B%5D%2C+%22must%22%3A+%7B%7D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%7B%22range%22%3A+%7B%22amountAwarded%22%3A+%7B%7D%7D%7D%2C+%22must%22%3A+%7B%7D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%5B%7B%22range%22%3A+%7B%22awardDate%22%3A+%7B%22format%22%3A+%22year%22%2C+%22gte%22%3A+%222017%7C%7C%2Fy%22%2C+%22lte%22%3A+%222017%7C%7C%2Fy%22%7D%7D%7D%5D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%5B%5D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%5B%5D%7D%7D%2C+%7B%22bool%22%3A+%7B%22should%22%3A+%5B%5D%7D%7D%5D%2C+%22must%22%3A+%7B%22query_string%22%3A+%7B%22query%22%3A+%22%5C%22older+people%5C%22+OR+elderly+OR+%5C%22over+50%5C%22+OR+almshouse+OR+dementia+OR+arthritis+OR+%5C%22sheltered+housing%5C%22+OR+%5C%22extra+care%5C%22+OR+%5C%22care+home%5C%22+OR+%5C%22social+isolation%5C%22++OR+%5C%22social+presc%5C%22+OR+%5C%22stroke%5C%22+OR+%5C%22older+age%5C%22+OR+%5C%22old+age%5C%22+OR+%5C%22pensioner%5C%22+NOT+%5C%22Young+People%5C%22+NOT+Youth%22%2C+%22default_field%22%3A+%22_all%22%7D%7D%7D%7D%2C+%22sort%22%3A+%7B%22_score%22%3A+%7B%22order%22%3A+%22desc%22%7D%7D%2C+%22aggs%22%3A+%7B%22currency%22%3A+%7B%22terms%22%3A+%7B%22field%22%3A+%22currency%22%2C+%22size%22%3A+3%7D%7D%2C+%22recipientRegionName%22%3A+%7B%22terms%22%3A+%7B%22field%22%3A+%22recipientRegionName%22%2C+%22size%22%3A+3%7D%7D%2C+%22recipientDistrictName%22%3A+%7B%22terms%22%3A+%7B%22field%22%3A+%22recipientDistrictName%22%2C+%22size%22%3A+3%7D%7D%2C+%22fundingOrganization%22%3A+%7B%22terms%22%3A+%7B%22field%22%3A+%22fundingOrganization.id_and_name%22%2C+%22size%22%3A+3%7D%7D%2C+%22recipientOrganization%22%3A+%7B%22terms%22%3A+%7B%22field%22%3A+%22recipientOrganization.id_and_name%22%2C+%22size%22%3A+3%7D%7D%7D%2C+%22extra_context%22%3A+%7B%22awardYear_facet_size%22%3A+3%2C+%22amountAwardedFixed_facet_size%22%3A+3%7D%7D

In terms of the NHS digital data I think the expenditure is actually the more useful data set. But I only need the data for age band 2.

I hope this makes sense.

Ethny


#19

Thanks Ethny, you’ll find the combined data in Adult Social Care Activity and Finance Report, England 2016-17 Data. The Adult Social Care and GrantNav file combines NHS expenditure and grants from the GrantNav download.

As NHS digital is England-only, you’ll find other rows at the bottom for Scotland, Wales and Northern Ireland that don’t have any expenditure.

See you tomorrow!


#20

Thank you!! That’s so helpful