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)
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
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.
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
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)
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!
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 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)
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.
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?
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!
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.
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.
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?:
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.
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.
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).
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?)
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.