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 spreadsheets. Show all posts
Showing posts with label spreadsheets. Show all posts

Tuesday, 23 March 2010

Irish Parliament Reshuffle, Ministers, Party Issue Spokespersons, and Committee positions

Reshuffle
Brian Cowen's Reshuffle Speech - Irish Times

Spokespeople
Just putting up my spokespersons spreadsheets making them more visible, if you see any mistakes, you can go straight the docs and edit them yourself, or leave a comment below.

irish political party issue spokespersons

Ministers
Minister full web page

Spokespeople

Spokesperson full web page

TD data
I have the spokespeople in this spreadsheet to run my TD exhibit off.Mininsters Location after reshuffle

TD database webpage

If TDs are to be seen as national politicians, then you should contact them on national issues, I know that you should also contact your local TD on national issues so the party can get an idea of where the issue is being raised, but usually the TD just says they'll pass it on to their issues spokesperson, so if you want a quicker response you can should email the spokesperson directly on your topic of interest as well.

shadow spokespeople
shadow spokespeople
There's less of clear showing of cabinet positions in Ireland, but I think I have most of them right,(actually i made this 6months ago and its probably in need of an update) if it open the spreadsheets and change em.

Sources

Fianna Failhttp://oireachtas.ie/members-hist/default.asp?housetype=0&HouseNum=30&PartyId=41
Fianna Fail http://www.fiannafail.ie/people/listing/
Fine Gael http://www.finegael.org/people/
Sinn Fein http://www.sinnfein.ie/dail-members
Green http://www.greenparty.ie/en/people
Labour/spokespersons.html"> http://www.labour.ie/peopleandplaces/spokespersons.html

I've been wanting to make a contact form site like contact.ie

Been meaning to try to make my own, probably with civcrm, I surprisingly hard to find a simple module to do this, plus I have found Drupal's backend horrible to use and all over the place.

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.