Archive

Posts Tagged ‘politics’

Politicans per capita in EU member states

December 8, 2010 3 comments

I was looking for an interesting query to use as the basis for a quick SPARQL in Drupal7 page, and given Ireland’s “austerity” (aka hairshirt) budget yesterday and our glorious IMF bailout,  I was minded to create a query ranking number of members of houses of legislature in each country against population.

The query took a long time because its very difficult to ascertain the field names from the dbpedia infobox fields, the dbpedia properties and ontology, and the variations in field usage per country, the apparent disconnect (for a human) between a topic and what might be exected as property. I for instance was expecting to be able see a reference to the house of parliament on each country’s page, but its in fact a little more organised than that 🙂

In the end the easiest way to do this is to open up the SPARQL endpoint [1], for example a wiki page about a country, then find an URI for a dbpedia resource for a country. I ended up using the Czech Republic URI [2].

After much tooing-and-froing the query I came up with the query below. Strangely, some countries have recorded populations that this query doesnt find (eg Germany – simplify the query and take a look).  It’s a bit rough around the edges but the evidence is clear [1] : Ireland is over-represented in legislature.

  • Anyone have any opinions why Ireland is over-represented ?
  • Is the situation similar at local level ?
  • Why doe the query not pick up dbpprop:populationEstimate for Germany ?
SELECT ?s ?t ?estPop ?estPopYear ?cenPop ?cenPopYear ?house ?n (?estPop/?n) as ?estPerCapita (?cenPop/?n) as ?cenPerCapita
WHERE { 
?s ?p <http://dbpedia.org/resource/Category:European_Union_member_states> .
?t skos:subject ?s .
?t rdf:type dbpedia-owl:Country .

optional{
?b skos:broader ?s .
?house skos:subject ?b .
?house dbpedia-owl:numberOfMembers ?n .

?t dbpprop:populationEstimate ?estPop .
?t dbpprop:populationCensus ?cenPop .
?t dbpprop:populationEstimateYear ?estPopYear .
?t dbpprop:populationCensusYear ?cenPopYear .
}

}
order by ?t

[1] http://dbpedia.org/sparql

[2] http://dbpedia.org/resource/Czech_Republic

[3] http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&should-sponge=soft&query=SELECT+%3Fs+%3Ft+%3FestPop+%3FestPopYear+%3FcenPop+%3FcenPopYear+%3Fhouse+%3Fn+%28%3FestPop%2F%3Fn%29+as+%3FestPerCapita+%28%3FcenPop%2F%3Fn%29+as+%3FcenPerCapitaWHERE+{+%0D%0A%3Fs+%3Fp+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FCategory%3AEuropean_Union_member_states%3E+.%0D%0A%3Ft+skos%3Asubject+%3Fs+.%0D%0A%3Ft+rdf%3Atype+dbpedia-owl%3ACountry+.%0D%0A%0D%0Aoptional{%0D%0A%3Fb+skos%3Abroader+%3Fs+.%0D%0A%3Fhouse+skos%3Asubject+%3Fb+.%0D%0A%3Fhouse+dbpedia-owl%3AnumberOfMembers+%3Fn+.%0D%0A%0D%0A%3Ft+dbpprop%3ApopulationEstimate+%3FestPop+.%0D%0A%3Ft+dbpprop%3ApopulationCensus+%3FcenPop+.%0D%0A%3Ft+dbpprop%3ApopulationEstimateYear+%3FestPopYear+.%0D%0A%3Ft+dbpprop%3ApopulationCensusYear+%3FcenPopYear+.%0D%0A}%0D%0A%0D%0A}%0D%0Aorder+by+%3Ft%0D%0A&debug=on&timeout=&format=text%2Fhtml&save=display&fname=fname=

North Korean news web site

June 28, 2010 Comments off

Just came across a website called NKNews.org about North Korea. Looks good and seems well put together. We need more sites like this to spread the word.

Time to defect ?

April 23, 2010 Comments off

Now that Ireland is officially a financial basketcase, I thought again about emigrating like I did in the 80’s when Charlie Haughey had the country in a midden. But where to go, and how to register dissatisfaction ?  Could I change my emigrate and change my nationality ? Or perhaps a more headline grabbing, petulant and downright in-your-face solution would be to defect. Where to ?


How unpatriotic is it to leave a county thats been murdered by politicians,  greed and “I’m alright jack” ? Would I be better to stay and fix it, even when my taxes go to bail out the criminals who got us into the mess, and who by connection to the government are acting treasonably ? Is this seditious ?

Categories: history, politics Tags: , ,

All change

September 16, 2009 Comments off

New boss at work ? Changes in the corp ? What does it all mean ?
Meanwhile, the dog at home stays in for hours, and accomplishes a clean sheet, literally. Other homies getting to grips with change too. NAMA sucks us dry for generations. We need a revolution. 6m people in Birmingham. 6 MPs. Ireland has 166 representatives and several multipliers more of local councillors. If only Ireland wasnt Neutral, we could have a military coup. But then we’d end up with Wiley O’Dee as leader. Fabulous radio coverage this AM. Willy vs Georgie Lee. Why dont RTE do more of that instead of the staged sequence of interviews ? Suppose they’d have to rip more Radio4 off, jingles and ideas too.

More interesting text than this in the historical section of this site.