Category Archives: Spreadsheets

CAP distribution map

Geographic.ie have kindly mapped CAP 2009 payments on a per farmer basis by county, based on 2006 census data and the farmsubsidy.org dataset of 137k+ payments totaling €1.9bn. The spreadsheet used to produce the map is here.

Carlow CAP recipients

Over the coming days we will start publishing recipients of CAP subsidies, as made available by the work of farmsubsidy.org. Here are the top 200 recipients of CAP payments in County Carlow for 2009:

More CAP stats

I’ve taken all 137k (€1.9bn) of CAP payments from 2009 and placed them into a pivot table. (Data thanks to farmsubsidy.org) Here are the stats: I’ve added in both county population counts and county size by square kilometre. Here is a graphic of county distribution: Would anyone like to run analyses of per head distribution,… Read More »

Allowances for local council chairs' expenses

The expense allowances available to cathaoirleachs and leas cathaoirleachs (chair/mayor and deputy chair/mayor) of local councils are interesting to examine. Or at least would be if we could see them all in the one dataset. Under the provisions of Section 143 the Local Government Act 2001 a local authority may pay an allowance to its… Read More »

Export subsidy payments

This dataset contains €457 million of export milk subsidy payments made between January 2001 and December 2009. It was requested from the Department of Agriculture. The dataset contains the name of the country to which it was exported, the date of export, the weight and the amount claimed. I also sought the names of all… Read More »

Eurostat

So it emerged total that thanks to the injection of €4bn into Anglo, our actual deficit is 14.3%, the highest in Europe. I had a poke around Eurostat’s website and had a look at this document, dated March 31, 2010. These documents are I think issued every three or six months, and are based on… Read More »

Enterprise Ireland – two more data sets

Following on from my earlier post on the raw data related to company totals and the raw combined spreadsheet, I am publishing two further data sets. Last month I attended the ScraperWiki Hacks and Hackers event. During the day, and with the sterling efforts of two Python developers, a scraper was written. This scraper does… Read More »