Bringing the best software speakers to the East of England
If you're coming to this Saturday's Open Data Hack Day then we'd be grateful if you could say a little more about your intertest in the event below.
You'll be free to self-organise into groups on Saturday and the information below should help you do this effectively.
You'll also be able to send each other messages through the Network for advance preparation and group-formation.
1) What skills and experience can you bring to a team?
2) What open data have you worked with, if any? Are you particularly keen to work with specific open data or on a specific problem?
3) What data visualization tools are you familiar with if any?
I am primarily a developer looking to help out, find out about the tools and data sets that are out there, and experiment with them.
Looking forward to hearing what people want to do, and how I can help.
I work on development of "Active Citizen", politically-neutral citizen-centered non-profit in Ireland. We advocate the Irish govt for release of information as open data, so we can build / re-deploy data-driven civic apps.
At the moment we are looking at possibility of replicating www.wheredoesmymoneygo.org for Ireland.
I would be grateful if we can find an opportunity on Sat to look into a list of possible data sources listed bellow and see what can be done.
OK, so to replicate this: http://www.wheredoesmymoneygo.org/dailybread.html for Ireland.Data Sources are:SILC - Survey on Income and Living Conditions 2010:HBS - Household Budget Survey 2009-2010 (published March 2012. so the most uptodate figures we have):(There is the an issue that the HBS is over 2009/2010 and the VAT rate changed in January 2010. I don't think that would matter, but you'd want to get the opinion of an economist.)Now, I added the bold text to this excerpt from Steve's blogpost:# Row 1 is average gross income per decile - including benefits, pensions etc (SILC table 1.5 )
# Row 2 is average direct taxation - income tax, employee NI and council tax (SILC table 1.5 )
# Row 3 is average total indirect taxation MINUS VAT, tobacco, alcohol, & car costs
-- Table I in the HBS gives Tobacco, Alcohol and Transport. (VAT is the next thing on this list)
# Row 4 is average total VAT paid-- See belowESRI did some work on VAT per income decile but based on the 2004/2005 HBS. See Figure 1 (page 220) here:I can't find anything more up to date than that. So we would have to(a) find a source of VAT by decile for 2010 somewhere else (I've looked around and can't find one)(b) use the HBS and SILC from 2004/5 and use the VAT deciles from ESRI's old report. This would mean the Where Does My Money Go would be out of date. (This is probably a goer.)(c) find an economist to redo ESRI's work on the latest HBR. (This is probably not going to happen, unless you can talk Gurdgiev into it ;-) or maybe the Irish Times can do it?) The methodology is explained well, but you'd need an economic data researcher really (see page 217):The data used is the anonymised data file for the 2004/2005 HBS (CSO,
2007a). This is a survey of a representative random sample of all private
households in Ireland. The main aim of the HBS is to determine household
expenditure in order to update the weightings used for the Consumer Price
Index. Detailed information is also provided on income, household
characteristics and household facilities. In 2004/2005, 6,884 private house -
holds participated in the survey.
Respondents are asked to fill out an expenditure diary in which they list
all items bought and the relevant amount spent in the previous week.
Expenditure on items such as domestic fuels is recorded over a longer period.
In order to estimate the amount that each household pays in VAT per week,
we assign the appropriate VAT rate (exempt, 0 per cent, 4.8 per cent, 13.5 per
cent or 21 per cent) to 1,469 expenditure items recorded in the survey. The
website of the Office of the Revenue Commissioners (2010) provided
information on the appropriate rates for each item in both 2009 and 2010. The
HBS provides a household equivalisation factor based on a Eurostat
definition. This scale counts the first adult in the household as one, other
adults are given a value of 0.7 and children are given a value of 0.5. We can
thus assess the proportion of weekly disposable income spent in VAT by
equivalised income decileSo (b) above is probably doable though the world has changed a lot since 2005. I haven't looked for the SILC and HBR for 2005 but I'm sure the CSO would have them if they're not on the web.So onto expenditure. We'd need the government expenditure ratios for whatever year. There is no Irish data worth talking about on OpenSpending, so we'd have to dig those out as well.
they are improving their formatting
Aiden Kane and Hugh Sheehy had already been doing some work here
My personal technical skills are rather limited.
I am looking forward meeting you this Saturday in Cambridge.
Director of NGO "Active Citizen"
Open Knowledge Foundation data sets available here: http://datahub.io/