Skip to main content

CharityHack 2012

Last weekend was my fourth Charity Hackathon of the year, CharityHack 2012. The CharityHack series started in 2009 and is sponsored by PayPal, JustGiving, MissionFish (aka PayPal Giving Fund) and PlayMob.Whereas some of the hackathons I've been to this year were actually organised by charities, CharityHack had more a feel of "people who work in the private sector doing a hack for charities". Not that there weren't charity people there, but the general make-up of the crowd was different.

Nick Aldridge of MissionFish had some great slides about the UK Charity sector as a whole. This one shows the various types of entity that qualify for Charity status - The bubble saying 'General Charities' being the ones people normally associate with 'charity':

(graphic originally from NCVO's UK Civil Society Almanac)

From the General Charities, Nick noted that large charities are actually very rare:
  • Only 0.3% have over £10m income per year
  • 15% have annual income between £10m and £100k
  • 31% have annual income between £100k and £10k
  • 54% have annual income below £10k

Being integrated with eBay has allowed MissionFish to gather a lot of data about how people donate online, which allows them to produce some really useful analysis.

All this got my thinking about the charity sector as a whole - why do charities come to exist and how do they continue to exist? Having to come up with a project I could build in 24 hours, led me to this idea:

Charities come into existence where people perceive that there is some unfairness or imbalance that needs to be addressed - but how can we measure whether the most 'important' areas are being adequately tackled? There are a whole bunch of value judgements there, but one important dataset is "what do people think is important?"

There are lots of ways of asking people what issues they think are important, but looking at the data available for the hackathon, I came up with:

Charities have to submit a 'charitable objective' to the UK Charity Commission. If we detatch the actual charity name from those objectives/missions statements, and ask people to rank the objectives by perceived importance, does the ranking bear any correlation to real-world donations?

And so here's the app I built, Philanthropotamus:

There were tons of much better apps built that weekend, but I had fun putting this together. The UK Chariity Commission doesn't really make the raw data easily available, but luckily does. The main page shows two anonymised charity objective statements and asks the user to vote. After voting, the charity names are revealed along with websites and twitter accounts, if known. There's also a link through to JustGiving for donations - I didn't have time to make this as good as it could be, so currently its just a link to the JustGiving search results for the charity number.

The app uses the Chess Elo rating system to award points after a vote, and the current ranking can be seen here. For the voting to work I needed to keep the pool of charities fairly small - from 180,000 on the database I whittled it down to the 3,000 that had the data point I needed and donations over £1m. Obviously, the ratings wont be much use until a lot of votes have been cast.

Hosting is by AppHarbor and the source code is on GitHub.

The winner on the day was OhCharity!, a very clever 'sponsor a hashtag' app. Second place was Charity Wi-Fi, a great hack whereby a Raspberry Pi lets people onto a wifi network if they make a donation. Winner of the Justgiving prize was 'Run With' by @thehodge and his team - a clever app and website to allow supporters to interact with a fun-runner.


Popular posts from this blog

Copying data to Salesforce Sandboxes using TalenD

A common problem with Salesforce Developer Sandboxes is that they are blank. Really you're going to want some data in there, so there are various strategies for copying data from your live instance to the Sandbox. There are some paid-for solutions - SFXOrgData , Salesforce Partial Data Sandboxes - but if you've got a decent ETL tool you can build your own. There are a bunch of free ETL tools for Salesforce: JitterBit Data Loader is good for quick ad-hoc tasks but the free version makes it difficult to manage specific ETL projects or share projects with other users Pentaho Community Edition - an open source edition of the enterprise version Apatar was a free open source Salesforce ETL which still works but development seems to have stopped since 2011 TalenD Open Studio is an open source ETL tool For the task of copying data from live to a Sandbox, either Pentaho or TalenD Open Studio could be used, depending on preference. Here's a good comparison of the dif

SSRS multi-value parameters with less fail

SSRS supports multi-value parameters, which is nice, but there are a few issues with them. This is how I deal with them. Two of the problems with SSRS multi-value parameters are: You have to jump through a few hoops to get them to work with stored procedures The (Select All) option, as shown above The reason the (Select All) option is a problem is that it is a really inelegant way of saying 'this parameter does not matter to me'. If you have a list with hundreds of values, passing all of them as a default option just seems wrong. Also, if your report shows the user which items they selected, printing the whole list when they choose (Select All) is excessive. So in this post I'm going to show my particular way of: Jumping through the hoops to get Multi-Value params in a stored procedure Adding a single '--All--' value that the report interprets as meaning all the options. Getting Multi-Value params to work with Stored Procedures This is

Remote Desktop on High DPI screens

Scott Hanselman wrote a nice blog post back in January about some of the issues you might face running Windows on a High DPI screen like that of a Surface Pro or Lenova Yoga. I'm kindof mystified that he didn't mention Remote Desktop though because thats been the number one problem for me on High DPI screens. That said, if you remote into very recent Server OS's like Windows Server 2012 R2, then apparently Remote Desktop will sort out the DPI scaling automatically. Perhaps Scott hadn't noticed the Remote Desktop issue because he only remotes into Server 2012 R2. Certainly if I was Scott, I wouldn't remote into anything less than that. But, in practice, I regularly have to remote into Server 2008 machines and yes even Server 2003. If you do that from a high DPI screen, the remote desktop is rendered at regular pixel size, which makes everything tiny. Its hard to show screenshots of High DPI screens that correctly convey the pixel size, so I've photoshoppe