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

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

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

Bug Hunter in Space

In 1987, Acorn launched the Archimedes home computer. At the time, it was the fastest desktop computer in the world, and at the time, I was fortunate enough to have one to experiment with. The Archimedes was great, but it never really took off commercially. However, it was built around the ARM processor, which Acorn had designed itself when it could not find any existing processors suitable for its 32-bit ambitions. The ARM processor was a masterpiece of simple and intuitive design, and its still around today, with most of the instruction set pretty much unchanged. In fact, you've probably got one in your pocket right now. Its design makes it process very efficiently on low energy intake, and hence it is estimated that about 98% of all mobile phones contain an ARM chip. Over 10 billion ARM chips have been shipped, and they outnumber Intel's long running x86 series of chips by a factor of about 5 to 10. I had learned programming on the BBC Model B , and when we got the A