A blog about things that interest me, politics, news, media, architecture, development, environment, local history, secularism, web, dublin ireland, tara
Displayed as percentage of spending limit and percentage of vote to normalize for the different sized constituencies.
* 3 seat constituency - €30,150.00
* 4 seat constituency - €37,650.00
* 5 seat constituency - €45,200.00
In the spreadsheet I have the data on the public and party funding, and the percentage that makes up of the candidates expenses just looking for a good way to show that.
Also need a better way to show the average e16,790 spend by candidates. A 2011 candidates donations and costs
In the spreadsheet I have the data on the public and party funding, and the percentage that makes up of the candidates expenses just looking for a good way to show that.
Difficult to give proper account of the governments make up and the independents/others opposition or government TDs.
Still have to try this with percentages.
Data in google spreadsheet form
I'm not sure of all this correct is based on figures I found searching through Fingal Independent articles from.
Not sure if it works either whether you immediately get who was most got most bang for their buck.
Of course the number of terms a councillor has already served, how well they're known (Peter Coyle), local political history and unpopularity of government parties all play a role, I wonder if I should weight for terms served.
I post on Politics.ie some graphs I did Manyeyes, but wasn't happy with them.
Via readwriteweb a top notch blog about web tech, I read about Tableau Public Software Which provide you with free* interactive graphs, maps and dashboards for the web.
This video example about taking public data about graffiti in New York, graphing it, mapping it, finding trends in the data and then showing those trends on the Dashboard. If only we had access to this kind of data in Ireland.
The free service which you download to you desktop gives you 100,000 rows of data, or 50mb which you can upload to its site to view and share.
This is the new manyeyes for me, particularly because it can do maps of Ireland and you can upload and manipulated large tables of data at once.
Im not sure of its geocoding will be useful for Ireland but can use the updgraded batchgeocode.com to get the lat lng and input them directly. Batchgeocode now specifically geocodes for and within Ireland.
Desktop program
You can use excel or csv files. You can make a graph, from one sheet a map from another, then put them together on dashboard, making the filters for them global to get a fuller nuanced picture.
I've tried a few here myself using the data from my TD's Exhibit. It nearly makes it my use of Exhibit defunct. It seems like it had more ways to total, average and display data automatically.
