• home
• numbers
• charts
• budget
• briefing
• download
• tour
• blog/faq
• ink
• about

• Old Age
• Sickness and Disability
• Medical Services
• Education: Children
• Armed Forces
• Police and Law Enforcement

SITE
NAVIGATION

Home

Numbers

Breakdown

UK Budget

Budget Pie Chart

Charts

Spending Brief

Debt Brief

Download Year

Download Multi

Download Raw

Tour

Blog/faqs

Ink

About

SPENDING

Old Age

Sickness and Disability

Families and Children

Medical Services

Health Research

Education: Primary

Education: Secondary

Education: Tertiary

Education: Other

Employment

Armed Forces

Civil Defense

Foreign Aid

Law and Justice

Police and Law Enforcement

Fire

Prisons

Airports Highways Transport

General Government

Interest

Total Spending

SOURCES

HM Treasury Budget

HM Treasury Statistics

UK Statistics

Download UK Public Spending Data Series 1692-2011

You can download any of the raw data series used to compile the public spending data in ukpublicspending.co.uk. You select the data series you want and then copy-paste the tab delimited data from a textbox on this page into your spreadsheet.

Download Instructions:

Prepare a suite of data for download by making a selection from one of the dropdown menus below. You can select:

1. A group of functionally related spending data series
2. An individual spending data series

Select Functional Data Series Group: Select a group of data series to download (you can add individual data series later):

<select functional data series group>11 Executive and legislative organs, (5 series)12 Foreign economic aid (6 series)13 General services (10 series)14 Basic research (2 series)15 R&D General public services (2 series)16 General public services n.e.c. (3 series)17 Public debt transactions (4 series)18 Transfers of a general character (1 series)21 Military defence (8 series)22 Civil defence (3 series)23 Foreign military aid (2 series)24 R&D Defence (2 series)25 Defence n.e.c. (3 series)31 Police services (3 series)32 Fire-protection services (4 series)33 Law courts (4 series)34 Prisons (2 series)35 R&D Public order and safety (2 series)36 Public order and safety n.e.c. (8 series)41 General economic, commercial and (6 series)42 Agriculture, forestry, fishing an (5 series)43 Fuel and energy (4 series)44 Mining, manufacturing and constru (4 series)45 Transport (25 series)46 Communication (3 series)47 Other industries (11 series)48 R&D Economic affairs (3 series)49 Economic affairs n.e.c. (3 series)51 Waste management (4 series)52 Waste water management (3 series)53 Pollution abatement (2 series)54 Protection of biodiversity and la (3 series)55 R&D Environmental protection (2 series)56 Environmental protection n.e.c. (7 series)61 Housing development (2 series)62 Community development (3 series)63 Water supply (5 series)64 Street lighting (3 series)65 R&D Housing and community ameniti (2 series)66 Housing and community amenities n (6 series)73 Medical service (3 series)74 Public health services (3 series)75 R&D Health (2 series)76 Health n.e.c. (8 series)81 Recreational and sporting service (4 series)82 Cultural services (7 series)83 Broadcasting and publishing servi (2 series)84 Religious and other community ser (2 series)85 R&D Recreation, culture and relig (2 series)86 Recreation, culture and religion (7 series)91 Pre-primary and primary education (2 series)92 Secondary education (2 series)93 Post-secondary non-tertiary educa (2 series)94 Tertiary education (4 series)95 Education not definable by level (12 series)96 Subsidiary services to education (4 series)97 R&D Education (2 series)98 Education n.e.c. (2 series)A1 Sickness and disability (2 series)A2 Old age (4 series)A3 Survivors (2 series)A4 Family and children (2 series)A5 Unemployment (6 series)A6 Housing (8 series)A7 Social exclusion n.e.c. (4 series)A8 R&D Social protection (2 series)A9 Social protection n.e.c. (9 series)B1 Other Spending (7 series)F1 Total (6 series)G1 Public Net Debt (1 series)

Add Individual Data Series: Select Spending Data Series to add to download (you can add more later):

<select to add data series>CKAAJ Accounting adjustmentsCKCOL Collection CostCKCOT Civil Government, OtherCKCVL Civil ListCKDCD Civil defenceCKDFA Foreign military aidCKDMA ArmyCKDMD Military defenceCKDMN NavyCKDNE Defence n.e.cCKDRD R&D defenceCKEAF Agriculture, forestry, fishing and huntingCKEAN Economic affairs n.e.cCKEAR R&D economic affairsCKEBL Protection of biodiversity and landscapeCKEBN Environment protection n.e.cCKECM CommunicationCKEDN Education n.e.cCKEEC General economic, commercial and labour affairsCKEEN Fuel and EnergyCKEER R&D environment protectionCKEFE Further EducationCKEHE Higher EducationCKEMC Mining, manufacturing and constructionCKEMP Employment policiesCKEND Education not definable by levelCKEOI Other industriesCKEOT Other transportCKEPA Pollution abatementCKEPE Pre-primary and primary educationCKEPS Post-secondary non-tertiary educationCKERD R&D educationCKERL RailwayCKESE Secondary educationCKESP Schools (Primary, Secondary)CKESS Subsidiary services to educationCKETE Tertiary educationCKETL Local roadsCKETN National roadsCKETP Local public transportCKEWM Waste managementCKEWW Waste water managementCKGBR Basic researchCKGEL Executive and legislative organs, financial and fiscal affairs, external affairsCKGFA Foreign economic aidCKGGS General servicesCKGNE General public services n.e.c.CKGOI Other international servicesCKGRD R&D general public servicesCKHCD Community developmentCKHHC Central and other health servicesCKHHD Housing developmentCKHHR Health researchCKHME Medical servicesCKHNC Health n.e.cCKHNE Housing and community amenities n.e.cCKHRD R&D housing and community amenitiesCKHSL Street lightingCKHWS Water supplyCKPFI Fire-protection servicesCKPLC Law courtsCKPNE Public order and safety n.e.c.CKPOC Post Office CollectionsCKPPO Police servicesCKPPR PrisonsCKPRD R&D public order and safetyCKPSI Public sector debt interestCKRBP Broadcasting and publishing servicesCKRCS Cultural servicesCKREG Regional policyCKRFI FilmsCKRLI LibrariesCKRMG Museums and galleriesCKRNE Recreation, culture and religion n.e.cCKROA Other arts and heritageCKRRC Religious and other community servicesCKRRD R&D recreation, culture and religionCKRRS Recreational and sporting servicesCKRTR TourismCKSFC Family and childrenCKSHO HousingCKSII Industrial injury benefitsCKSIS Income supportCKSNE Social protection n.e.c.CKSOA Old age CKSPP Public sector occupational pensionsCKSRD R&D social protectionCKSSD Sickness and disability CKSSE Social exclusion n.e.c CKSSF Social FundCKSSU Survivors CKSUE UnemploymentCKSWP War pensionsCKTOT Total central government own expenditureGCCFP Fuel and Power fixed capital formationGCCIS Iron and Steel fixed capital formationGCCOT Other Public Corporations fixed capital formationGCDEF Defence (capital)GCEAF Agriculture, forestry, fishing and hunting (capital)GCEAR R&D economic affairs (capital)GCEDT Education (incl. training)(capital)GCEEC General economic, commercial and labour affairs (capital)GCENV Environment protection (capital)GCGFA Foreign economic aid (capital)GCGGS General services (capital)GCHEA Health (capital)GCHOU Housing and community amenities (capital)GCPOS Public order and safety (capital)GCRCR Recreation, culture, religion (capital)GCSPG Social protection (capital)GCTOT Total Spending (capital)GCTRA Transport and Communications fixed capital formationGKAAJ Other accounting adjustmentsGKADM Central administration and associated expenditureGKAFF Agriculture, fisheries, food and forestry GKCMS Culture, Media and Sport GKDCD Civil defenceGKDEF DefenceGKDFA Foreign military aidGKDMD Military defenceGKDNE Defence n.e.cGKDRD R&D defenceGKDWD War damage compensation, etc.GKEAF Agriculture, forestry, fishing and huntingGKEAN Economic affairs n.e.cGKEAR R&D economic affairsGKEBL Protection of biodiversity and landscapeGKEBN Environment protection n.e.cGKECC Child careGKECM CommunicationGKEDN GKEDNGKEDT Education (incl. training)GKEDU EducationGKEEC General economic, commercial and labour affairsGKEEN Fuel and EnergyGKEER R&D environment protectionGKEIO Other Industry and TradeGKELD Land drainage and coastal protectionGKEMC Mining, manufacturing and constructionGKEND Education not definable by levelGKENV Environment protectionGKEOI Other industriesGKEOT other transportGKEPA Pollution abatementGKEPE Pre-primary and primary educationGKEPK Parks, pleasure groundsGKEPS Post-secondary non-tertiary educationGKERD R&D educationGKERL railwayGKESE Secondary educationGKESM School meals, milk and welfare foodsGKESS Subsidiary services to educationGKETE Tertiary educationGKETL local roadsGKETN national roadsGKETP local public transportGKEWM Waste managementGKEWW Waste water managementGKGBR Basic researchGKGEL Executive and legislative organs, financial and fiscal affairs, external affairsGKGFA Foreign economic aidGKGGS General servicesGKGNE General public services n.e.c.GKGRD R&D general public servicesGKHCD Community developmentGKHEA HealthGKHHC Central and other health servicesGKHHD Housing developmentGKHHR Health researchGKHME Medical servicesGKHNE Housing and community amenities n.e.cGKHNH National health serviceGKHOU Housing and community amenitiesGKHPH Public health servicesGKHPS Personal social servicesGKHRD R&D housing and community amenitiesGKHSL Street lightingGKHWS Water supplyGKINR General government interest and dividend receipts GKINT International development assistance and other international services GKLOP Law, order and protective services GKLOT National Lottery GKPFI Fire-protection servicesGKPLC Law courtsGKPNE Public order and safety n.e.c.GKPOS Public order and safetyGKPPO Police servicesGKPPR PrisonsGKPRD R&D public order and safetyGKPRP Privatisation proceeds GKPSI General government net debt interest GKRBP Broadcasting and publishing servicesGKRCR Recreation, culture and religionGKRCS Cultural servicesGKRNE Recreation, culture and religion n.e.cGKRRC Religious and other community servicesGKRRD R&D recreation, culture and religionGKRRS Recreational and sporting servicesGKSFC Family and childrenGKSFL Allowance for shortfallGKSHO HousingGKSNE Social protection n.e.c.GKSOA Old age GKSPG Social protectionGKSRD R&D social protectionGKSSD Sickness and disability GKSSE Social exclusion n.e.c GKSSU Survivors GKSSY Social security GKSUE UnemploymentGKTOT Total expenditureGKTRA TransportGKTRL Roads and Public LightingGKTTC Transport and CommunicationLCAAJ Accounting adjustments (capital)LCCOI Harbours (capital)LCEDE education (capital)LCEDT training (capital)LCEDU Education (includes training) (capital)LCEED enterprise and economic development (capital)LCEEP employment policies (capital)LCENV Environment protection (capital)LCGPS General public services (capital)LCHEA Health (capital)LCHIB Highways and Bridges (capital)LCHOU Housing and community amenities (capital)LCPCS public and common services (capital)LCPOS Public order and safety (capital)LCREC Recreation, culture and religion (capital)LCSOP Social protection (capital)LCTOT Total Local Authorities' capital expenditureLCTRA Transport (capital)LKAAJ Accounting adjustments (current)LKAFF agriculture, fisheries and forestry (current)LKCOI Harbours (current)LKDCD Civil DefenceLKDEF Defence (current)LKEDE education (current)LKEDT training (current)LKEDU Education (includes training) (current)LKEED enterprise and economic development (current)LKEEN Fuel and EnergyLKEEP employment policies (capital)LKENV Environment protection (current)LKEOI Other industriesLKEPK Parks, pleasure groundsLKEWW Waste water managementLKGPS General public services (current)LKHEA Health (current)LKHIB Highways and Bridges (current)LKHOU Housing and community amenities (current)LKHSL Street lightingLKHWS Water supplyLKPCS Public and common services (current)LKPFI Fire-protection servicesLKPOS Public order and safety (current)LKPPO Police servicesLKPSI Public sector debt interest (current)LKRCS Libraries, museums, and artsLKREC Recreation, culture and religion (current)LKSHO HousingLKSOP Social protection (current)LKTOT Total Local Authorities' current expenditureLKTRA transport (current)NDEBT NDEBTPCAAJ Accounting AdjustmentsPCBTO Total Business, Enterprise and Regulatory ReformPCCCC QEII Conference CentrePCCDT Total Chancellor's DepartmentsPCCFC Fire Service CollegePCCHR Housing Revenue AccountPCCHT Housing Action TrustsPCCLG Total Communities and Local GovernmentPCCMT Total Culture Media and SportPCCOS Ordnance SurveyPCDTO Total DefencePCECC Total Energy and Climate ChangePCETO Total Environment Food and Rural AffairsPCHEA Total HealthPCHTO Total Home OfficePCITO Total International DevelopmentPCJLR Land RegistryPCLLU London Underground LimitedPCNDA Northern Ireland Driver and Vehicle Testing AgencyPCNHE Northern Ireland Housing ExecutivePCNLS Laganside (NI)PCNPA Northern Ireland Public Trust Port AuthorityPCNTH Northern Ireland Transport Holding CompanyPCNWA Northern Ireland WaterPCSAP Highlands and Islands AirportsPCSCM Caledonian MacBraynePCSFE Forest EnterprisePCSHR Housing Revenue AccountPCSHT NHS Trusts (Scotland)PCSWT Scottish WaterPCTOT Total public corporations' capital expenditurePCTRA Total TransportPCWDA Welsh Development AgencyPCWFE Forest Enterprise (Wales)PCWHR Wales Housing Revenue AccountPCWHT NHS Trusts (Wales)PCWTO Total Work and Pensions

Change Data Units: You can download data in raw format (i.e., in the units used in the database for each item, or in £ billion, £ million, or percent of GDP.

Select Fiscal Year: You can select the budget for which you want to download estimated public spending.

Budget 2008Budget 2009

Copy and Paste: When you have created the dataset you want then just copy the tab-delimited text in the textbox below (click cursor in text box, then press ctrl-A then press ctrl-C) and paste it into your spreadsheet.

Year GDP (CKTOT) Total central government own expenditure (GKTOT) Total expenditure (LKTOT) Total Local Authorities' current expenditure 1692 0 4 0 0 1693 0 6 0 0 1694 0 6 0 0 1695 0 6 0 0 1696 0 8 0 0 1697 0 8 0 0 1698 0 4 0 0 1699 0 5 0 0 1700 0 3 0 0 1701 0 3 0 0 1702 0 5 0 0 1703 0 5 0 0 1704 0 6 0 0 1705 0 6 0 0 1706 0 7 0 0 1707 0 9 0 0 1708 0 8 0 0 1709 0 9 0 0 1710 0 10 0 0 1711 0 15 0 0 1712 0 8 0 0 1713 0 6 0 0 1714 0 6 0 0 1715 0 6 0 0 1716 0 7 0 0 1717 0 6 0 0 1718 0 6 0 0 1719 0 6 0 0 1720 0 6 0 0 1721 0 6 0 0 1722 0 7 0 0 1723 0 6 0 0 1724 0 5 0 0 1725 0 6 0 0 1726 0 6 0 0 1727 0 6 0 0 1728 0 7 0 0 1729 0 6 0 0 1730 0 6 0 0 1731 0 5 0 0 1732 0 5 0 0 1733 0 5 0 0 1734 0 6 0 0 1735 0 6 0 0 1736 0 6 0 0 1737 0 5 0 0 1738 0 5 0 0 1739 0 5 0 0 1740 0 6 0 0 1741 0 7 0 0 1742 0 9 0 0 1743 0 9 0 0 1744 0 9 0 0 1745 0 9 0 0 1746 0 10 0 0 1747 0 11 0 0 1748 0 11 0 0 1749 0 13 0 0 1750 0 7 0 0 1751 0 6 0 0 1752 0 7 0 0 1753 0 6 0 0 1754 0 3 0 0 1755 0 7 0 0 1756 0 10 0 0 1757 0 11 0 0 1758 0 13 0 0 1759 0 15 0 0 1760 0 18 0 0 1761 0 21 0 0 1762 0 20 0 0 1763 0 18 0 0 1764 0 11 0 0 1765 0 12 0 0 1766 0 10 0 0 1767 0 10 0 0 1768 0 9 0 0 1769 0 10 0 0 1770 0 11 0 0 1771 0 10 0 0 1772 0 11 0 0 1773 0 10 0 0 1774 0 10 0 0 1775 0 10 0 0 1776 0 14 0 0 1777 0 15 0 0 1778 0 18 0 0 1779 0 20 0 0 1780 0 23 0 0 1781 0 26 0 0 1782 0 29 0 0 1783 0 24 0 0 1784 0 24 0 0 1785 0 26 0 0 1786 0 17 0 0 1787 0 15 0 0 1788 0 16 0 0 1789 0 16 0 0 1790 0 17 0 0 1791 0 18 0 0 1792 0 17 0 0 1793 0 20 0 0 1794 0 29 0 0 1795 0 39 0 0 1796 0 42 0 0 1797 0 58 0 0 1798 0 47 0 0 1799 0 47 0 0 1800 0 50 0 0 1801 0 51 0 0 1802 0 66 0 0 1803 0 55 0 0 1804 0 53 0 0 1805 0 63 0 0 1806 0 71 0 0 1807 0 73 0 0 1808 0 73 0 0 1809 0 78 0 0 1810 0 82 0 0 1811 0 82 0 0 1812 0 87 0 0 1813 0 95 0 0 1814 0 111 0 0 1815 0 113 0 0 1816 0 100 0 0 1817 0 71 0 0 1818 0 59 0 0 1819 0 58 0 0 1820 0 58 0 0 1821 0 58 0 0 1822 0 56 0 0 1823 0 57 0 0 1824 0 54 0 0 1825 0 56 0 0 1826 0 54 0 0 1827 0 56 0 0 1828 0 56 0 0 1829 0 54 0 0 1830 0 54 0 0 1831 0 52 0 0 1832 0 52 0 0 1833 0 51 0 0 1834 0 49 0 0 1835 1 49 0 0 1836 1 65 0 0 1837 1 54 0 0 1838 1 51 0 0 1839 1 52 0 0 1840 1 53 0 0 1841 1 53 0 0 1842 1 54 0 0 1843 0 55 0 0 1844 1 55 0 0 1845 1 55 0 0 1846 1 54 0 0 1847 1 55 0 0 1848 1 59 0 0 1849 1 59 0 0 1850 1 56 0 0 1851 1 55 0 0 1852 1 54 0 0 1853 1 55 0 0 1854 1 56 0 0 1855 1 69 0 0 1856 1 93 0 0 1857 1 76 0 0 1858 1 68 0 0 1859 1 65 0 0 1860 1 70 0 0 1861 1 73 0 0 1862 1 72 0 0 1863 1 70 0 0 1864 1 68 0 0 1865 1 67 0 0 1866 1 67 0 0 1867 1 67 0 0 1868 1 72 0 30 1869 1 76 0 29 1870 1 67 0 27 1871 1 68 0 30 1872 1 70 0 31 1873 1 69 0 33 1874 1 75 0 36 1875 1 73 0 41 1876 1 75 0 43 1877 1 76 0 48 1878 1 80 0 49 1879 1 83 0 52 1880 1 82 0 50 1881 1 81 0 53 1882 1 83 0 56 1883 1 87 0 44 1884 1 85 0 43 1885 1 89 0 44 1886 1 92 0 45 1887 1 90 0 45 1888 1 87 0 46 1889 1 87 0 47 1890 1 91 0 48 1891 1 93 0 51 1892 1 96 0 53 1893 1 96 0 56 1894 1 99 0 58 1895 2 101 0 60 1896 2 105 0 62 1897 2 110 0 65 1898 2 112 0 68 1899 2 118 0 71 1900 2 182 0 99 1901 2 196 0 103 1902 2 179 0 108 1903 2 146 0 113 1904 2 128 0 118 1905 2 118 0 124 1906 2 119 0 125 1907 2 117 0 126 1908 2 120 0 127 1909 2 133 0 129 1910 2 142 0 130 1911 2 149 0 132 1912 2 159 0 134 1913 2 169 0 137 1914 2 189 0 134 1915 3 827 0 132 1916 3 1059 0 126 1917 4 1394 0 122 1918 5 2288 0 139 1919 5 1673 0 193 1920 6 1275 0 317 1921 5 1029 0 401 1922 4 813 0 364 1923 4 703 0 322 1924 4 690 0 337 1925 5 701 0 371 1926 4 703 0 404 1927 5 692 0 414 1928 5 695 0 399 1929 5 702 0 405 1930 5 725 0 420 1931 4 745 0 429 1932 4 736 0 402 1933 4 676 0 390 1934 5 662 0 399 1935 5 690 0 428 1936 5 726 0 461 1937 5 805 0 498 1938 6 1056 0 531 1939 6 1527 0 551 1940 7 3441 0 538 1941 9 4746 0 558 1942 9 5367 0 537 1943 10 5897 0 506 1944 10 6069 0 505 1945 10 5382 0 544 1946 10 3770 0 693 1947 11 3127 0 907 1948 12 3212 0 987 1949 13 3430 0 1010 1950 13 3479 0 1060 1951 15 0 5260 0 1952 16 0 5836 0 1953 17 0 6099 0 1954 18 0 6031 0 1955 19 0 6241 0 1956 21 0 6763 0 1957 22 0 6979 0 1958 23 0 7401 0 1959 24 0 7816 0 1960 26 0 8350 0 1961 27 0 10307 0 1962 29 0 10999 0 1963 30 0 11651 0 1964 33 0 12743 0 1965 36 0 14122 0 1966 38 0 15289 0 1967 40 0 17494 0 1968 44 0 19092 0 1969 47 0 19789 0 1970 52 0 21595 0 1971 58 0 24240 0 1972 65 0 26390 0 1973 75 0 30546 0 1974 85 0 39218 0 1975 107 0 51524 0 1976 126 0 58464 0 1977 147 0 61867 0 1978 169 0 71949 0 1979 199 0 85166 0 1980 233 0 103858 0 1981 256 0 116060 0 1982 281 0 128044 0 1983 307 0 132700 0 1984 330 0 140500 0 1985 362 0 150900 0 1986 389 0 158600 0 1987 429 0 164600 0 1988 479 0 173600 0 1989 525 0 179900 0 1990 570 0 200900 0 1991 599 0 218200 0 1992 622 0 236200 0 1993 654 0 260600 0 1994 693 0 170116 0 1995 733 224930 8315 73974 1996 782 233251 8644 76118 1997 830 242637 24386 75709 1998 879 249067 193971 75879 1999 929 246386 21191 75373 2000 977 252780 30127 81075 2001 1022 270564 31776 85653 2002 1076 286413 11831 91227 2003 1140 304363 35817 99397 2004 1203 331844 16366 107493 2005 1254 356079 46383 118624 2006 1326 361761 23362 127085 2007 1399 397780 24549 132613 2008 1448 420510 37141 139796 2009 1396 455080 40298 147647 2010 1452 487696 63990 153348 2011 1520 501400 0 159269

Here is a formatted version of the data you have selected.You can remove a data series by selecting “out” in the dropdown for each data series.

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

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.

“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