Work in progress
List of My regions
Maps of Regions
Eastern River Basin District
Local Health offices
HSE North East
Church of Ireland Diocese
Updated with Tableau Public dashboard below for years 2010/11.
I did get some help from coders, via scraperwiki although the poor formatting on president.ie frustrated the ability to scrape past engagements,.. need a mass geocoder.
Rough presidential engagements data google spreadsheets data garbled after spreadsheet failed
Functions of the President of Ireland - Citizen Information Board of Ireland.
The President is the Irish Head of State, although he or she plays a mainly ceremonial role in the running of the State. The current President of Ireland is Mary McAleese, who commenced serving her second term as President on 11th November, 2004, and which ends in November 2011 with an election campaign beginning in Autumn 2011.
The Government must approve all Presidential communications, messages or addresses, both to the Oireachtas (Irish houses of Parliament) and to the public.
Many of the powers of the President can only be exercised on the advice of the Government. This means that if the President wishes to exercise a power, he or she must first obtain the advice and agreement of the Government.
The President also possesses some powers that he or she cannot exercise without first consulting with the Council of State.
The President's powers include
Appointing members of the Government, judges and other officials
Summoning and dissolving the Dáil
Convening the Oireachtas
Representing the people
Signing Bills and referring Bills to the Supreme Court
Acting as Supreme Commander of the Defence Forces.
Entity extraction still isn't easy or perfect, web services come and go, I have used Alchemy API, using the importxml formula in my google spreadsheet. Have to find someway of using all these API's on my spreadsheets beyond the google import limit of 50.
Word clouds have a bad reputation as anything in chart junk, particularly with word length exaggerating or undermining the importance of a word, but the more I look at the above the more I think it might a useful way to see straight away the keywords of the engagements, school, community centre, Ambassador from Brazil, signed Justice act etc without having to drill down or match colours with issues. I have been looking at the following examples, making it in R or Prefuse seems be the best bet for it, if I can find anyone who done similar.
Displayed as percentage of spending limit and percentage of vote to normalise for the different sized constituencies.
* 3 seat constituency - €30,150.00
* 4 seat constituency - €37,650.00
* 5 seat constituency - €45,200.00
2007 Election guidelines from Standards in Public Office Commission.
|Elected||Not Elected||All||All £||Avg £ of Elected||Avg £ of Not Elected||Avg £ of All|
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
Anyone coming to my blog looking for Dail constituencies, I don't have em.
The official Constituency Commission has images and detailed reports on the boundaries and changes.
Go here for the 2012 boundaries in google-kml http://www.tallyroom.com.au/maps (free if credited to Ben Raue ) or here for more detailed ones with Electoral (sub) Divisions http://icampaigned.com/blog/dail-constituency-maps/ (not free) or go Ordnance Survey Ireland for commercial use files.
Keep meaning to learn R an open source statical graphics language so I copied this example from Drew Conway about building a better word cloud. I took the Fianna Fail leadership contest speeches from the Irish Times as recent examples of comparable speeches. There was a lot of talk of how often the spoke of what was good for the party as opposed to what was good for the country.
As Drew says this only shows common words so here are wordle clouds, of all there words.
Trying to put together something that shows the progress and types of Oireachtas Bills through the Irish parliamentary and see how many they have fulfilled from the Government Legislation Programme, an attempt at a less good IBM Many Bills. It shows details of bills progress through the Dail, Seanad and committees from the life for the government from 2007 to 2011. As always its ugly, heavy and there too much information on screen, but just trying to figure it out, I still love the faceted browsing on timelines made with Smilie Exhibit its allow you drill down through so many options and its so easy to make. It atleast gave me something to find out what other information I would need for a better version later.
My rough Calculations give these totals and averages
254 total bills
105 total enacted
0 total opp enacted
278 avg days everything
104 avg days to enact
149 avg opp bills life days
89 total opp bills
Panels with LEGISLATION • PARTIES • DEPARTMENT • COMMITTEE • DETAILS • ALL DATA
1st First Stage 1st Second Stage 1st Third (Committee) Stage 1st Fourth (Report) Stage 1st Fifth (Final) Stage 2nd First Stage 2nd Second Stage 2nd Third (Committee) Stage 2nd Fourth (Report) Stage 2nd Fifth (Final) Stage Enacted
Bills go through one house then the other.
Displaying progress of bills
Spent ages trying to get a percentage completed bar to show in Smilie Exhibit, I got Timeline percentage extension partly working then broke it, but in the end just used different colours but its hard to have enough spread in the colours. Obviously there problems with contrast and too much text on screen. I just wanted to create a filter every differentiation I could find.
Had to scrape the info from the Oireachtas site.
Used a combination of the previously gathered info from the story, Google docs import html, laborious copy and paste and scraperwiki
Scraped the source code with the help of Alvin who made a ruby scraper and another with help from Julian Todd the creator of scraperwiki.
2010-statutory-instruments-ireland irish-legislation bii-p-url Need to make some auto updating running totals of the various stages which would be more useful for people and look better, using this scraperwiki example, but the Oireachtas sites is very changeable and not easy to pinpoint the stage it is at.
I'll have to make my own version of this, I started the very basic of it on a google doc drawing