A blog about things that interest me, politics, news, media, architecture, development, environment, local history, secularism, web, dublin ireland, tara

Contact me at expectationlost@gmail.com
Showing posts with label visualisation. Show all posts
Showing posts with label visualisation. Show all posts

Tuesday, 20 July 2010

Irish Political Parties numbers of TDs in Dail Tableau Public Stack Chart Dashboard Style with Days in Gov by Party

View it better wide at Tableau public

Data Spreadsheet at Google Docs.
Source from Wikipedia

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.

Tuesday, 6 July 2010

Irish Political Parties numbers of TDs in Dail Google Fusion Time Series

View it better wider at Google Fusion Tables

Select the handles at either end of the bottom bar to zoom into a particular time period. Full Names for initialed parties below.

Luckily all the data I needed was presented in this wikipedia table, h/t to whoever contributed that info, User:Phil_Nolte? and User:Snappy.

This time series is much Better then ManyEyes Stack chart I blogged last night.

It positions the years properly,shows you the party numbers at the key points, you can select the governments, I like it Shows CnaG trailing off and then Fine Gael picking up the line a few years later. Like to have it shaded in and with percentages, I now have all the info and will make that later along with making a timeplot for more customization.

Fianna FáilFF
Fine GaelFG
Labour Party (Ireland)Lab
Sinn Féin (Pro-Treaty)" SF (Pro)
Sinn Féin (Anti-Treaty)" SF (Anti)
Cumann na nGaedhaelCnaG
Farmers' Party (Ireland)FP
Sinn FéinSF
Business and Professional GroupBPG
National League PartyNL
Irish Worker LeagueIWL
National Centre Party (Ireland)NCP
Clann na TalmhanCnaT
National Labour Party (Ireland)NLP
Clann na PoblachtaCnaP
National Progressive DemocratsNPD
Workers' Party of IrelandWP
Anti H-BlockAHB
Socialist Labour Party (Ireland)SLP
Progressive DemocratsPD
Green Party (Ireland)GP
Democratic Socialist Party (Ireland)DSP
Democratic Left (Ireland)DL
Socialist Party (Ireland)SP
People Before Profit AlliancePBP

Ok now check out my TD Exhibit which I blogged about here.

Monday, 5 July 2010

Irish Political Parties numbers of TDs in Dail stack chart

View it full/wide screen View large static image

Data Spreadsheet

Updated this with 1922 to 2007 figures. Made this to see if politics was diversifying or FF stranglehold on the country continues.

If you want to add the numbers for earlier years you can go ahead and enter them here
Info Government of Ireland

Oh heres the complete data I need, Dail Eireann election summary.

As always constantly trying to see which service does it better. That stack chart isn't very good, it doesn't display the years right,ie the length of the governments...,which mirror its makeup. Although i like that its shaded in and you can show percentage to keep the shape even as Dail numbers change. Im going to make Google Fusion Time Series, a Timeplot and Tableau Public version. I think Timeplot will do the job best but take longer. Come back later.

In response to my tweets was pointed to two other similar Dail Charts.

House A very well made java applet(made in 2006) which shows the make up of Dail since 1918, its shows a colored bar chart, government parties, majorities and seats loses and gains, which you can play in a slideshow.

and

guthanphobail.net An Irish language page with stats and charts back to 1982 and the latest referendums. Very detailed java charts showing counts and transfer of the all the candidates not just the winners.

Next the rate of change of tds over the years, that'll take some work...

Ok now check out my TD Exhibit which I blogged about here.

Sunday, 21 March 2010

Howth Malahide Election spending Scatter plot Tableau

Continuing to try out Tableau Public

This is the Howth Malahide 2009 local election spending, spend per vote.

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.

Manyeyes Election spending scatter plot

Manyeyes Election spending Bubble Chart

Obviously Tableau has more options, was particular looking for trend line and winner and losers lines, would like winners trend line.

Also the Howth and Malahide elections areas were merged at this election. see election history at electionsireland.org

Thursday, 4 March 2010

Tableau Public, Visualisation Dashboard

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.

Obligatory Haiti Dashboard Olympic Medals Dashboard

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.

Data at TD google spreadsheet
Constituency editable spreadsheet.
Party editable spreadsheet.

Download these files as xls, strip the { and } from the headers and think of ways of displaying the data.

Need to think of ways to use data to fully utilize this. Figure out how to make the difference in size of icons logarithmic.

Tuesday, 10 June 2008

Many Eyes Visualisations of Ireland

I've been looking for ways to display Ireland election or referendum results dynamically live interested in visualisations and mapping of info and web 2.0 here are the two combined, Many Eyes an Visual Communication Lab IBM research project.

Anybody can upload data sets from various sources and use the visualisation models to visualise the date in various ways from graph to word clouds to heat maps.

Somebody called Colm has upload and visualised many interesting data about population, houses, politics and GAA.

The Shifting of Ireland's Population to Dublin

A Data Set of Population by County

Compare Bertie election 2007 acceptance speech and his resignation speech a year later (switch between 1 or 2 words on the Many Eyes sites).

Its a pity it doesn't have Irish electoral constituencies of other administrative districts if any has the shapefiles for them please add them.

Google had visualisation API for heat maps now to but only maps and recognises individual countries or administrative areas at the moment as far as I can see.

Im going to see if i find or add Ireland administrative boundary geonames.