Would you like to download public spending data from ukpublicspending.co.uk, spending data that covers central government and local authority spending? No problem. We have four ways you can download spending data. And more to come.

Fast Lane

Here is how you can get your public spending data for Fiscal Year 2008. You can download it:

As a simple text table. Click here.
As a tab-delimited table you can cut and paste into a spreadsheet. Click here.
As a simple html <table> without styling. Click here.
As a fully styled html <table> with all the styles included. Click here.

Slow Lane

Here is how to develop your own custom set of UK public spending data. You can use controls on the table below to change the data, including:

The fiscal year
The view including the UN-sponsored COFOG spending classifications.
The level of spending detail
The spending units, including billions and millions of pounds, percent of GDP, and percent of overall spending

To get what you want, just follow the easy steps outlined below.

Step 1: Select the data set you want

In the table below, click the controls to get the data you want.

Click the “-1yr” and “+1yr” text-links or the “FY 2008” drop-down to change the year from 2008 to the year you want.
Click the “Change View” controls to change the data labels to the view you want.
Click the expander [+] controls to add more detail.
Click the “£ billion” drop-down to change the units.

Go ahead and use the controls on the table below to get the particular spending information you want to download.

smaller text bigger text

General Help: You can use controls on the spending table below to change the following variables: spending units—e.g. percent of GDP, etc.— and year.

FAQ

Help Topics: Use this Help Topic dropdown control to find out how you can use this table of public spending for your own needs.

Spending Units: By default, public spending is displayed in billions of pounds. By using a dropdown control in the table heading you can select millions of pounds, percent of GDP, percent of central government spending, and percent of total spending.

Fiscal Year: The default year displayed is the current HM Treasury fiscal year. But you can select any year you want using the dropdown control in the table heading. You can increase or decrease the year using the “yr” text links in the table heading. At the top and bottom of the dropdown only years ending in “0” are shown. Select a year to get close, then select the year you want.

United Kingdom Central Government
and Local Authority Spending
-5yr -1yr Fiscal Year 2008 +1yr +3yr
Amounts in £ billion

GDP: £1,405.0 billion(1)

Change View:	default COFOG	Central (2)	General Gov.(2)	Local (2)	Total	clk Bar Chart: Click on a chart icon to display a bar chart. There are chart icons along the base of the table; they create charts to depict the numbers in the chart columns. There are also chart icons along the right edge of the table; they create charts to depict the numbers in the table rows. [+] Drill-down: Click on the [+] to drill down to more detailed numbers on public spending.
[+] Pensions		99.8	0.0	0.0	99.8
[+] Health Care		102.2	0.0	0.4	102.6
[+] Education		26.8	0.0	49.8	76.7
[+] Defence		38.4	0.0	0.1	38.5
[+] Welfare		49.0	0.0	41.2	90.2
[+] Protection		16.2	0.0	16.2	32.4
[+] Transport		10.7	0.0	9.1	19.8
[+] General Government		13.2	0.0	12.3	25.5
[+] Other Spending		42.7	0.0	32.3	75.0
[+] Interest		29.9	0.0	0.8	30.7
[+] Balance		1.1	0.0	-6.4	-5.3
[+] Total Spending		430.1	0.0	155.7	585.9
[+] Public Net Debt		0.0	0.0	0.0	729.0
	Click for Bar Chart or Pie Chart ->	Pie Chart: Click on a pie icon to display a pie chart. You can create a pie chart for federal, state and local, and overall spending/revenue.
Key: est. outturn plan HM Treasury PESA Year: By default, the table displays planned and outturn public spending in the current HM Treasury PESA. But you can look at previous planned numbers using the dropdown control at the bottom of the table. — using HM Treasury PESA (1) Measuring Worth - U.K. GDP (2) Public Expenditure Statistical Analysis 2008

back to table | back to top

OK. Now you are ready to download your data.

Step 2: Copy Your Data

We offer four ways of downloading your data:

A simple text table with the top-line numbers for total spending across all governments.
A tab-delimited table that you can cut and paste into your spreadsheet program.
A simple table using html <table> tags without styling.
A fully styled html <table> with all the styles included.

Top-line numbers

If you want just the top-line total numbers for overall public spending, federal, state, and local, then here they are:

Use your cursor to copy and paste the following lines into your own content:

United Kingdom Central Government
and Local Authority Spending
Fiscal Year 2008
Amounts in £ billion

Pensions: £99.8
Health Care: £102.6
Education: £76.7
Defence: £38.5
Welfare: £90.2
Protection: £32.4
Transport: £19.8
General Government: £25.5
Other Spending: £75.0
Interest: £30.7
Balance: £-5.3
Total Spending: £585.9
Public Net Debt: £729.0

source: ukpublicspending.co.uk

back to table | back to top

Here is a bar chart of the top-line numbers. Right click the cursor to copy or save the image:

Tab-delimited Table

Here is the spending table with columns tab-delimited. You can cut and paste directly into a spreadsheet:

You can copy all the text in the textbox by clicking your cursor in the box. Then press Ctrl-A and Ctrl-C and paste the text into your spreadsheet.

United Kingdom Central Government and Local Authority Spending Fiscal Year 2008 GDP: £1,405.0 billion(1) Amounts in £ billion Fed Gov. Xfer State Local Total Pensions 99.8 0.0 0.0 0.0 99.8 Health Care 102.2 0.0 0.0 0.0 102.6 Education 26.8 0.0 0.0 0.0 76.7 Defence 38.4 0.0 0.0 0.0 38.5 Welfare 49.0 0.0 0.0 0.0 90.2 Protection 16.2 0.0 0.0 0.0 32.4 Transport 10.7 0.0 0.0 0.0 19.8 General Government 13.2 0.0 0.0 0.0 25.5 Other Spending 42.7 0.0 0.0 0.0 75.0 Interest 29.9 0.0 0.0 0.0 30.7 Balance 1.1 0.0 0.0 0.0 -5.3 Total Spending 430.1 0.0 0.0 0.0 585.9 Public Net Debt 0.0 0.0 0.0 0.0 729.0 source: ukpublicspending.co.uk

back to table | back to top

Simple html <table>

Maybe you want to get the data formatted in html for insertion into your content as a table. Here is the data in html with a simple table setup. There are no fancy tags or styles. Just a straight table with <table>, <tr>, and <td> tags.

You can copy all the text in the textbox by clicking your cursor in the box. Then press Ctrl-A and Ctrl-C and paste the html into your content.

<table><caption>United Kingdom Central Government<br>and Local Authority Spending<br>Fiscal Year 2008<br>Amounts in £ billion<tr><td> <td>Fed<td>General<br>Gov<td>State<td>Local<td>Total<tr><td>Pensions<td>99.8<td>0.0<td>0.0<td>0.0<td>99.8<tr><td>Health Care<td>102.2<td>0.0<td>0.0<td>0.0<td>102.6<tr><td>Education<td>26.8<td>0.0<td>0.0<td>0.0<td>76.7<tr><td>Defence<td>38.4<td>0.0<td>0.0<td>0.0<td>38.5<tr><td>Welfare<td>49.0<td>0.0<td>0.0<td>0.0<td>90.2<tr><td>Protection<td>16.2<td>0.0<td>0.0<td>0.0<td>32.4<tr><td>Transport<td>10.7<td>0.0<td>0.0<td>0.0<td>19.8<tr><td>General Government<td>13.2<td>0.0<td>0.0<td>0.0<td>25.5<tr><td>Other Spending<td>42.7<td>0.0<td>0.0<td>0.0<td>75.0<tr><td>Interest<td>29.9<td>0.0<td>0.0<td>0.0<td>30.7<tr><td>Balance<td>1.1<td>0.0<td>0.0<td>0.0<td>-5.3<tr><td>Total Spending<td>430.1<td>0.0<td>0.0<td>0.0<td>585.9<tr><td>Public Net Debt<td>0.0<td>0.0<td>0.0<td>0.0<td>729.0<tr><td colspan=6>source: <a href="http://www.ukpublicspending.co.uk">ukpublicspending.co.uk</a></table>

back to table | back to top

Fully styled table

Here in the textbox is the full table with styles but without controls. The styles are built around an id called “ukgs342”. It shouldn’t interfere with your styles.

You can copy all the text in the textbox by clicking your cursor in the box. Then press Ctrl-A and Ctrl-C and paste into your content.

back to table | back to top

More Download Methods to Come

That’s all the download methods for now. But we are planning more.

Perhaps we will even let you load Javascript into your content and allow you to manipulate the controls on the table to allow your visitors to use the full functionality available to users here on ukpublicspending.co.uk.

You Can Help!

What do you want from ukpublicspending.co.uk? Email us at chrischantrill@gmail.com

Best wishes from all of us at the ukpublicspending.co.uk team.

back to table | back to top

Democratic Capitalism

Three dynamic and converging systems functioning as one: a democratic polity, an economy based on markets and incentives, and a moral-cultural system which is plural and, in the largest sense, liberal.
Michael Novak, The Spirit of Democratic Capitalism

Education

“We have met with families in which for weeks together, not an article of sustenance but potatoes had been used; yet for every child the hard-earned sum was provided to send them to school.”
E. G. West, Education and the State

Government Expenditure

The Union publishes an exact return of the amount of its taxes; I can get copies of the budgets of the four and twenty component states; but who can tell me what the citizens spend in the administration of county and township?
Alexis de Tocqueville, Democracy in America

Mutual Aid

In 1911... at least nine million of the 12 million covered by national insurance were already members of voluntary sick pay schemes. A similar proportion were also eligible for medical care.
Green, Reinventing Civil Society