狠狠撸

狠狠撸Share a Scribd company logo

360 Giving open data

?
?
Superhighways
Superhighways

360 Giving encourages grantmakers to publish their grants data openly, to understand their data and to use the data as part of a more innovative and informed approach to grantmaking. This deck was presented at the Kingston Data Hack day in Kingston on the 12th June 2018.

1 of 24
Download to read offline
360Giving Open data for more effective grantmaking @360Givin g
What we do We support grantmakers to publish their grants data openly, to understand their data and to use the data as part of a more innovative and informed approach to grantmaking.
UK grantmaking in numbers 2015/6 166k = UK charities 390k = Civil society organisations ?3.3bn = Government grants to voluntary sector ?2.9bn = Grants awarded by Top 300 foundations Sources: NCVO Almanac 2018, ACF Foundation Giving Trends 2017
Data to help answer questions Who else is funding these organisations/sectors? I care about x region - is enough funding going there? How can I make my applications more targeted? Am I duplicating work that others are doing?
Imagine if it was as easy as this Coastal communities?
Publishing data to the 360 Standard
360Giving Standard: What do we mean? “Open data and content can be freely used, modified, and shared by anyone for any purpose” http://opendefinition.org/
Simple standardisation - thousands of uses
10 items… or more Answering the key questions: who, what, when and how much? And if possible; You (Funder) Who? (Recipient) When? (Dates) Where? (Location) What? (Purpose) Amount? (?)
The more you add the more powerful it is Publish what you can, adding more at your own pace Beneficiary location Grant programme Categories Website addresses
Publishing via a spreadsheet
Publishers own their data Data files are made available via publisher website. https://www.lovekingston.org.uk/creating-change/open-data/
Using the data http://grantnav.threesixtygiving.org
Supporting grantseekers https://www.beehivegiving.org/
Analysing the data Credit: OCSI Local Insight tool http://ocsi.uk/2017/06/14/find-out-how-much-big- lottery-funding-is-spent-in-your-local-areas/ Credit: Austin Rodriguez, Birmingham City Council “It’s about having the conversations we’ve never been able to have before…we literally used to say that we can’t discuss these questions because we don’t know anything”. Dipali Chandra from Charitable Trusts West Midlands
Visualisation tools Credit: Mor Rubinstein using https://onodo.org/ https://onodo.org/visualizations/32366
Credit: Mor Rubinstein using https://infogram.com https://infogram.com/localcharitiesday-1h0r6rvo7rww2ek
Taking a data expedition
https://challenge.threesixtygiving.org/
Exploring the data with GrantNav - http://grantnav.threesixtygiving.org
GrantNav filters GrantNav filter 360Giving Standard field Amount Awarded Amount Awarded Award Year The year from Award Date field Recipient Region Derived from 360Giving data (Postcode or Geocodes) Recipient District Derived from 360Giving data (Postcode or Geocodes) Funding Organisations Funding Org:Name Recipient Organisations Recipient Org:Name
Keyword searching Simple ways to target your free text searches: ● A single word: e.g. people ● Multiple words: e.g. young people gardens (each word does not necessarily have to be present) ● Require each word to be found: e.g. young AND people ● An exact phrase by enclosing it in quotes: e.g. "young people"
Advanced keyword searches Search words and phrases limited to a specific field, for example: ● description:homelessness will search the "description" field for the word "homelessness" ● recipientOrganization.postalCode:KT1 will search the for recipients within the “KT1" postcode district (where the field is populated) ● fundingOrganization.name:"London Councils" will search the "Funding Organisation:Name" field for "London Councils" NB: The field names used must match the machine-readable field names. You can find these listed on GrantNav: http://grantnav.threesixtygiving.org/stats
● Discuss with colleagues - come and speak to us ● Check out our tools and platforms ● Hold a Data Expedition ● Tell us what would be useful for you www.threesixtygiving.org info@threesixtygiving.org @360Giving Next steps

More Related Content

360 Giving open data

  • 1. 360Giving Open data for more effective grantmaking @360Givin g
  • 2. What we do We support grantmakers to publish their grants data openly, to understand their data and to use the data as part of a more innovative and informed approach to grantmaking.
  • 3. UK grantmaking in numbers 2015/6 166k = UK charities 390k = Civil society organisations ?3.3bn = Government grants to voluntary sector ?2.9bn = Grants awarded by Top 300 foundations Sources: NCVO Almanac 2018, ACF Foundation Giving Trends 2017
  • 4. Data to help answer questions Who else is funding these organisations/sectors? I care about x region - is enough funding going there? How can I make my applications more targeted? Am I duplicating work that others are doing?
  • 5. Imagine if it was as easy as this Coastal communities?
  • 6. Publishing data to the 360 Standard
  • 7. 360Giving Standard: What do we mean? “Open data and content can be freely used, modified, and shared by anyone for any purpose” http://opendefinition.org/
  • 9. 10 items… or more Answering the key questions: who, what, when and how much? And if possible; You (Funder) Who? (Recipient) When? (Dates) Where? (Location) What? (Purpose) Amount? (?)
  • 10. The more you add the more powerful it is Publish what you can, adding more at your own pace Beneficiary location Grant programme Categories Website addresses
  • 11. Publishing via a spreadsheet
  • 12. Publishers own their data Data files are made available via publisher website. https://www.lovekingston.org.uk/creating-change/open-data/
  • 15. Analysing the data Credit: OCSI Local Insight tool http://ocsi.uk/2017/06/14/find-out-how-much-big- lottery-funding-is-spent-in-your-local-areas/ Credit: Austin Rodriguez, Birmingham City Council “It’s about having the conversations we’ve never been able to have before…we literally used to say that we can’t discuss these questions because we don’t know anything”. Dipali Chandra from Charitable Trusts West Midlands
  • 16. Visualisation tools Credit: Mor Rubinstein using https://onodo.org/ https://onodo.org/visualizations/32366
  • 17. Credit: Mor Rubinstein using https://infogram.com https://infogram.com/localcharitiesday-1h0r6rvo7rww2ek
  • 18. Taking a data expedition
  • 20. Exploring the data with GrantNav - http://grantnav.threesixtygiving.org
  • 21. GrantNav filters GrantNav filter 360Giving Standard field Amount Awarded Amount Awarded Award Year The year from Award Date field Recipient Region Derived from 360Giving data (Postcode or Geocodes) Recipient District Derived from 360Giving data (Postcode or Geocodes) Funding Organisations Funding Org:Name Recipient Organisations Recipient Org:Name
  • 22. Keyword searching Simple ways to target your free text searches: ● A single word: e.g. people ● Multiple words: e.g. young people gardens (each word does not necessarily have to be present) ● Require each word to be found: e.g. young AND people ● An exact phrase by enclosing it in quotes: e.g. "young people"
  • 23. Advanced keyword searches Search words and phrases limited to a specific field, for example: ● description:homelessness will search the "description" field for the word "homelessness" ● recipientOrganization.postalCode:KT1 will search the for recipients within the “KT1" postcode district (where the field is populated) ● fundingOrganization.name:"London Councils" will search the "Funding Organisation:Name" field for "London Councils" NB: The field names used must match the machine-readable field names. You can find these listed on GrantNav: http://grantnav.threesixtygiving.org/stats
  • 24. ● Discuss with colleagues - come and speak to us ● Check out our tools and platforms ● Hold a Data Expedition ● Tell us what would be useful for you www.threesixtygiving.org info@threesixtygiving.org @360Giving Next steps