Software East

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?



Views: 261

Reply to This

Replies to This Discussion

Hi all, 

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. 

Recently I've been doing some work with OSM data for routing and transport. I'm also keen on d3 and a number of javascript based visualisation tools. I've also got experience with hacking a variety of scripting languages (ruby, javascript, a little python, php) and some R. They seem a bit heavy for a day event, but if anyone is working in Java or Scala, I may also be able to chip in with something useful.

Looking forward to hearing what people want to do, and how I can help. 


Hi all,

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  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: 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 below 
ESRI 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 decile
So (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.

Best regards,

Denis Parfenov
Director of NGO "Active Citizen"
twitter: @parfenov_

Open Knowledge Foundation data sets available here:



First Time Visitors

First time here? Read about this network.

Created by Mark Dalgarno Nov 6, 2009 at 3:52pm. Last updated by Mark Dalgarno Nov 6, 2009.


Upload a photo to your profile, so we can get to know one another.

Created by Mark Dalgarno Nov 6, 2009 at 3:55pm. Last updated by Ryan Haney Apr 26, 2013.

© 2018   Created by Mark Dalgarno.   Powered by

Badges  |  Report an Issue  |  Terms of Service