Archive for August, 2010

Keeping track of the spending cuts

August 17, 2010

I’ve changed the way you can let the ‘Where Does My Money Go?’ team know about a spending cut.

It’s really easy now, you just need to paste in the url of a place the cut is reported … and that’s it!

You can add more details about the cut on the next page of the form, but it is not required as we will do the rest.

Also I made a spreadsheet of all the Tax Payers Allience proposed £50 billion spending cuts.

Would be really interested to see how these suggested cuts compare with what’s happening in reality, and also the suggested cuts of, say, the IFS.

Contact me if you want to help with those comparisons.

Where, in the country, is our tax money used?

August 15, 2010

The point of this blog is to follow the path of our money from the point it is handed to the government as tax, to the point it leaves their hands to give benefit to somewhere.

It is that ‘somewhere’ I have recently been looking into — I’ve been investigating the stage where the money leaves the government hands. Who benefits and in what way?

The Treasury devoted some resource to answering this exact question.

The Treasury Data

The data set has a name, it is the Country Regional Analysis (CRA). I’ve collected all years of this report back to 2005 in a CKAN package.

How the data is gathered

Every year the Treasury gather the CRA data by giving each central government department a spreadsheet. There is an example CRA spreadsheet on the CRA page.

You can see that the Treasury fill the spreadsheet with the department’s spending codes (programme object group) from COINS. The department is then asked to work out which regions, in the country, benefited from each of their spending codes.

The regions are quite crude, the whole of England is split into 9 regions and then there is the option of Northern Ireland, Scotland and Wales.


There is also an option for everyone in the world befits.

Some of the ways of tracing the funds are easy, say, if there is a spending code for a local initiative that people from only one region are entitled.

A more complex analysis would be something like if there is a spending code for a museum that people travel from all over the country to see, then a statistician is called upon, and they will determine which parts of the country benefit from this service probably based on visitor surveys etc.

How to get something useful out of the CRA

The 2009 CRA data had lots of inconsistent use of classification of the spending. We wrote scripts to fix many of these problems.
The 2010 CRA is much better but still requires some work.
The 2010 CRA comes in two sets. Both sets describe the same spending, it is just one (called table 9) describes the *areas* the money was spent in more detail, and the other data set (called table 10) describes the *type* of spending in more detail.

Table 9 and 10 have to following fields in common:

  • Department code
  • Department name
  • COFOG level 1
  • HMT Functional Classification
  • Programme Object Groups
  • Programme Object Group alias
  • ID and non ID
  • CAP or CUR
  • spending for dates 2004-05 to 2009-10

when we find a match between table 9 data and table 10 data for the fields above then we need to give it the NUTS 1 region code and spending for 2010-11 from table 9 and the ‘CG LG or PC’, COFOG 2 and HMT subfunction class from value from table 10

Then the full detail of the spending in one line.

When this join is done, there is one more problem to fix with the data.
This issue all stems from the fact that local authorities do not have programme object groups.

We think the best solution is to replace the ‘dummy sprog …’ programme object group that is used in the CRA for local authority spending, with something like ‘Local Authority Spending’ rather than using ‘Unknown’.

What we have done with the CRA

We, at ‘Where Does My Money Go?’ have used the Treasury’s data for this display:

But I’m sure there are many more uses to be had.

Speaking at OpenTech 2010

August 15, 2010

I’m speaking at this Opentech this year.
I’m showing the results of my work on COINS for the first time.
Should be good.

A post on the cost of UK energy and cost of mitigating climate change

August 11, 2010

Just a quick post to say that I’ve added a new post on the cost of UK energy to the Where Does My Money Go? blog:

http://www.wheredoesmymoneygo.org/2010/08/04/how-much-does-our-energy-cost/

I am doing more detailed analysis to follow up the ball park figures I present.