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

Click to download your public spending data for Fiscal Year 1987

simple text

tab-delimited
text

simple html <table>
without styling

fully styled
html <table>

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 1987” drop-down to change the year from 1987 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

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. UK or Country/Region: By default, the table shows values for all spending in the United Kingdom. But you can select individual countries by selecting the country dropdown control in the table heading. 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.
	United Kingdom Central Government and Local Authority Spending -5yr -1yr Fiscal Year 1987 +1yr +5yr Amounts in £ billion	GDP: £428.7 billion(1)

Change View:	default COFOG	Central (2)	General Gov.(2)	Local (2)	Total	charts
[+] Pensions		0.0	0.0	0.0	0.0
[+] Health Care		0.0	22.1	0.0	22.1
[+] Education		0.0	18.7	0.0	18.7
[+] 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. Defence		0.0	20.4	0.0	20.4
[+] Welfare		0.0	46.5	0.0	46.5
[+] Protection		0.0	7.2	0.0	7.2
[+] Transport		0.0	5.7	0.0	5.7
[+] General Government		0.0	4.4	0.0	4.4
[+] Other Spending		0.0	22.1	0.0	22.1
[+] Interest		0.0	17.6	0.0	17.6
[+] Balance		0.0	-0.1	0.0	-0.1
[+] Total Spending		0.0	164.6	0.0	164.6
[+] Public Net Debt		0.0	0.0	0.0	167.8
	Click for Bar Chart or Pie Chart ->
Key: Pie Chart: Click on a pie icon to display a pie chart. You can create a pie chart for central government, local authority, and overall spending/revenue. outturn (1) Measuring Worth - U.K. GDP (2) Public Expenditure Statistical Analysis 1999

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 1987
Amounts in £ billion

Pensions: £0.0
Health Care: £22.1
Education: £18.7
Defence: £20.4
Welfare: £46.5
Protection: £7.2
Transport: £5.7
General Government: £4.4
Other Spending: £22.1
Interest: £17.6
Balance: £-0.1
Total Spending: £164.6
Public Net Debt: £167.8

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<br>and Local Authority Spending Fiscal Year 1987 Amounts in £ billion Central General Local Total Pensions 0.0 0.0 0.0 0.0 Health Care 0.0 22.1 0.0 22.1 Education 0.0 18.7 0.0 18.7 Defence 0.0 20.4 0.0 20.4 Welfare 0.0 46.5 0.0 46.5 Protection 0.0 7.2 0.0 7.2 Transport 0.0 5.7 0.0 5.7 General Government 0.0 4.4 0.0 4.4 Other Spending 0.0 22.1 0.0 22.1 Interest 0.0 17.6 0.0 17.6 Balance 0.0 -0.1 0.0 -0.1 Total Spending 0.0 164.6 0.0 164.6 Public Net Debt 0.0 0.0 0.0 167.8 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 1987<br>Amounts in £ billion<tr><td> <td>Fed<td>General<br>Gov<td>State<td>Local<td>Total<tr><td>Pensions<td>0.0<td>0.0<td style="text-align:center">0.0<td>0.0<tr><td>Health Care<td>0.0<td>22.1<td style="text-align:center">0.0<td>22.1<tr><td>Education<td>0.0<td>18.7<td style="text-align:center">0.0<td>18.7<tr><td>Defence<td>0.0<td>20.4<td style="text-align:center">0.0<td>20.4<tr><td>Welfare<td>0.0<td>46.5<td style="text-align:center">0.0<td>46.5<tr><td>Protection<td>0.0<td>7.2<td style="text-align:center">0.0<td>7.2<tr><td>Transport<td>0.0<td>5.7<td style="text-align:center">0.0<td>5.7<tr><td>General Government<td>0.0<td>4.4<td style="text-align:center">0.0<td>4.4<tr><td>Other Spending<td>0.0<td>22.1<td style="text-align:center">0.0<td>22.1<tr><td>Interest<td>0.0<td>17.6<td style="text-align:center">0.0<td>17.6<tr><td>Balance<td>0.0<td>-0.1<td style="text-align:center">0.0<td>-0.1<tr><td>Total Spending<td>0.0<td>164.6<td style="text-align:center">0.0<td>164.6<tr><td>Public Net Debt<td>0.0<td>0.0<td style="text-align:center">0.0<td>167.8<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

“The point is to show all public spending in the UK: central government and local authority.”

table • chart • spend/gdp • debt/gdp • uk gdp • uk real gdp • 2009 • breakdown • central+local • central • local • uk budget • health • education • defence • 2010

Headline

PESA 2010 Update

UkPublicSpending.co.uk now shows spending numbers at the subfunction level as released by HM Treasury in its Public Expenditure Statistical Analyses (PESA) 2010.

Spending for 2008-09 is now "outturn"; spending for 2009-10 is now "estimated outturn". Central government spending for 2010-11 is "plans", as estimated by HM Treasury. Local authority spending for 2010-11 is "guesstimated" by UkPublicSpending.co.uk by projecting the change between 2008-09 and 2009-10 forward to 2010-11.

Note: HM Treasury has not released spending estimates at the subfunction level for years after the current fiscal year 2010-11.

News

Budget News

June Budget: VAT rise and benefits cuts
Chancellor Osborne's emergency budget of June 22, 2010.

Millions in the public sector to pay more for pension
Chancellor says "disparity between public and privates sector pensions... 'unsustainable.'"

Announcing £6.2billion savings
Speech by the Chancellor of the Exchequer, Rt Hon George Osborne MP on May 24, 2010

> archive

Quick Links

Get spending chart.

Download spending table.

Download spending data series.

Review data sources.

Masthead

ukpublicspending.co.uk was designed and executed by:

Christopher Chantrill.

Report bugs here.

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