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:
A group of functionally related spending data series
An individual spending data series
You can also remove individual data series that you don’t want.
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 adjustments CKCOL Collection Cost CKCOT Civil Government, Other CKCVL Civil List CKDCD Civil defence CKDFA Foreign military aid CKDMA Army CKDMD Military defence CKDMN Navy CKDNE Defence n.e.c CKDRD R&D defence CKEAF Agriculture, forestry, fishing and hunting CKEAN Economic affairs n.e.c CKEAR R&D economic affairs CKEBL Protection of biodiversity and landscape CKEBN Environment protection n.e.c CKECM Communication CKEDN Education n.e.c CKEEC General economic, commercial and labour affairs CKEEN Fuel and Energy CKEER R&D environment protection CKEFE Further Education CKEHE Higher Education CKEMC Mining, manufacturing and construction CKEMP Employment policies CKEND Education not definable by level CKEOI Other industries CKEOT Other transport CKEPA Pollution abatement CKEPE Pre-primary and primary education CKEPS Post-secondary non-tertiary education CKERD R&D education CKERL Railway CKESE Secondary education CKESP Schools (Primary, Secondary) CKESS Subsidiary services to education CKETE Tertiary education CKETL Local roads CKETN National roads CKETP Local public transport CKEWM Waste management CKEWW Waste water management CKGBR Basic research CKGEL Executive and legislative organs, financial and fiscal affairs, external affairs CKGFA Foreign economic aid CKGGS General services CKGNE General public services n.e.c. CKGOI Other international services CKGRD R&D general public services CKHCD Community development CKHHC Central and other health services CKHHD Housing development CKHHR Health research CKHME Medical services CKHNC Health n.e.c CKHNE Housing and community amenities n.e.c CKHRD R&D housing and community amenities CKHSL Street lighting CKHWS Water supply CKPFI Fire-protection services CKPLC Law courts CKPNE Public order and safety n.e.c. CKPOC Post Office Collections CKPPO Police services CKPPR Prisons CKPRD R&D public order and safety CKPSI Public sector debt interest CKRBP Broadcasting and publishing services CKRCS Cultural services CKREG Regional policy CKRFI Films CKRLI Libraries CKRMG Museums and galleries CKRNE Recreation, culture and religion n.e.c CKROA Other arts and heritage CKRRC Religious and other community services CKRRD R&D recreation, culture and religion CKRRS Recreational and sporting services CKRTR Tourism CKSFC Family and children CKSHO Housing CKSII Industrial injury benefits CKSIS Income support CKSNE Social protection n.e.c. CKSOA Old age CKSPP Public sector occupational pensions CKSRD R&D social protection CKSSD Sickness and disability CKSSE Social exclusion n.e.c CKSSF Social Fund CKSSU Survivors CKSUE Unemployment CKSWP War pensions CKTOT Total central government own expenditure GCCFP Fuel and Power fixed capital formation GCCIS Iron and Steel fixed capital formation GCCOT Other Public Corporations fixed capital formation GCDEF 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 formation GKAAJ Other accounting adjustments GKADM Central administration and associated expenditure GKAFF Agriculture, fisheries, food and forestry GKCMS Culture, Media and Sport GKDCD Civil defence GKDEF Defence GKDFA Foreign military aid GKDMD Military defence GKDNE Defence n.e.c GKDRD R&D defence GKDWD War damage compensation, etc. GKEAF Agriculture, forestry, fishing and hunting GKEAN Economic affairs n.e.c GKEAR R&D economic affairs GKEBL Protection of biodiversity and landscape GKEBN Environment protection n.e.c GKECC Child care GKECM Communication GKEDN GKEDN GKEDT Education (incl. training) GKEDU Education GKEEC General economic, commercial and labour affairs GKEEN Fuel and Energy GKEER R&D environment protection GKEIO Other Industry and Trade GKELD Land drainage and coastal protection GKEMC Mining, manufacturing and construction GKEND Education not definable by level GKENV Environment protection GKEOI Other industries GKEOT other transport GKEPA Pollution abatement GKEPE Pre-primary and primary education GKEPK Parks, pleasure grounds GKEPS Post-secondary non-tertiary education GKERD R&D education GKERL railway GKESE Secondary education GKESM School meals, milk and welfare foods GKESS Subsidiary services to education GKETE Tertiary education GKETL local roads GKETN national roads GKETP local public transport GKEWM Waste management GKEWW Waste water management GKGBR Basic research GKGEL Executive and legislative organs, financial and fiscal affairs, external affairs GKGFA Foreign economic aid GKGGS General services GKGNE General public services n.e.c. GKGRD R&D general public services GKHCD Community development GKHEA Health GKHHC Central and other health services GKHHD Housing development GKHHR Health research GKHME Medical services GKHNE Housing and community amenities n.e.c GKHNH National health service GKHOU Housing and community amenities GKHPH Public health services GKHPS Personal social services GKHRD R&D housing and community amenities GKHSL Street lighting GKHWS Water supply GKINR 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 services GKPLC Law courts GKPNE Public order and safety n.e.c. GKPOS Public order and safety GKPPO Police services GKPPR Prisons GKPRD R&D public order and safety GKPRP Privatisation proceeds GKPSI General government net debt interest GKRBP Broadcasting and publishing services GKRCR Recreation, culture and religion GKRCS Cultural services GKRNE Recreation, culture and religion n.e.c GKRRC Religious and other community services GKRRD R&D recreation, culture and religion GKRRS Recreational and sporting services GKSFC Family and children GKSFL Allowance for shortfall GKSHO Housing GKSNE Social protection n.e.c. GKSOA Old age GKSPG Social protection GKSRD R&D social protection GKSSD Sickness and disability GKSSE Social exclusion n.e.c GKSSU Survivors GKSSY Social security GKSUE Unemployment GKTOT Total expenditure GKTRA Transport GKTRL Roads and Public Lighting GKTTC Transport and Communication LCAAJ 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 expenditure LCTRA Transport (capital) LKAAJ Accounting adjustments (current) LKAFF agriculture, fisheries and forestry (current) LKCOI Harbours (current) LKDCD Civil Defence LKDEF Defence (current) LKEDE education (current) LKEDT training (current) LKEDU Education (includes training) (current) LKEED enterprise and economic development (current) LKEEN Fuel and Energy LKEEP employment policies (capital) LKENV Environment protection (current) LKEOI Other industries LKEPK Parks, pleasure grounds LKEWW Waste water management LKGPS General public services (current) LKHEA Health (current) LKHIB Highways and Bridges (current) LKHOU Housing and community amenities (current) LKHSL Street lighting LKHWS Water supply LKPCS Public and common services (current) LKPFI Fire-protection services LKPOS Public order and safety (current) LKPPO Police services LKPSI Public sector debt interest (current) LKRCS Libraries, museums, and arts LKREC Recreation, culture and religion (current) LKSHO Housing LKSOP Social protection (current) LKTOT Total Local Authorities' current expenditure LKTRA transport (current) NDEBT NDEBT PCAAJ Accounting Adjustments PCBTO Total Business, Enterprise and Regulatory Reform PCCCC QEII Conference Centre PCCDT Total Chancellor's Departments PCCFC Fire Service College PCCHR Housing Revenue Account PCCHT Housing Action Trusts PCCLG Total Communities and Local Government PCCMT Total Culture Media and Sport PCCOS Ordnance Survey PCDTO Total Defence PCECC Total Energy and Climate Change PCETO Total Environment Food and Rural Affairs PCHEA Total Health PCHTO Total Home Office PCITO Total International Development PCJLR Land Registry PCLLU London Underground Limited PCNDA Northern Ireland Driver and Vehicle Testing Agency PCNHE Northern Ireland Housing Executive PCNLS Laganside (NI) PCNPA Northern Ireland Public Trust Port Authority PCNTH Northern Ireland Transport Holding Company PCNWA Northern Ireland Water PCSAP Highlands and Islands Airports PCSCM Caledonian MacBrayne PCSFE Forest Enterprise PCSHR Housing Revenue Account PCSHT NHS Trusts (Scotland) PCSWT Scottish Water PCTOT Total public corporations' capital expenditure PCTRA Total Transport PCWDA Welsh Development Agency PCWFE Forest Enterprise (Wales) PCWHR Wales Housing Revenue Account PCWHT 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 2008 Budget 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.
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.
Year GDP (CKPFI) Fire-protection services (GKPFI) Fire-protection services (LKPFI) Fire-protection services (PCCFC) Fire Service College CKPFIkeep out GKPFIkeep out LKPFIkeep out PCCFCkeep out 1951 14.784 0 18 0 0 1952 15.983 0 20 0 0 1953 17.121 0 21 0 0 1954 18.126 0 22 0 0 1955 19.49 0 23 0 0 1956 20.956 0 25 0 0 1957 22.105 0 27 0 0 1958 23.05 0 28 0 0 1959 24.348 0 30 0 0 1960 25.977 0 33 0 0 1961 27.413 0 37 0 0 1962 28.711 0 42 0 0 1963 30.409 0 43 0 0 1964 33.228 0 49 0 0 1965 35.888 0 53 0 0 1966 38.189 0 58 0 0 1967 40.281 0 65 0 0 1968 43.656 0 71 0 0 1969 47.023 0 79 0 0 1970 51.696 0 80 0 0 1971 57.67 0 85 0 0 1972 64.621 0 111 0 0 1973 74.545 0 124 0 0 1974 84.513 0 161 0 0 1975 106.717 0 226 0 0 1976 126.274 0 257 0 0 1977 146.973 0 269 0 0 1978 169.344 0 318 0 0 1979 199.22 0 385 0 0 1980 233.184 0 480 0 0 1981 256.279 0 561 0 0 1982 281.024 0 606 0 0 1999 928.73 0 0 0 0 2000 976.533 0 0 0 1 2001 1021.83 0 0 0 1 2002 1075.56 0 201 0 4 2003 1139.75 0 53 0 2 2004 1202.96 0 234 0 4 2005 1254.06 0 68 0 0 2006 1325.8 0 2186 0 1 2007 1398.88 0 2182 0 1 2008 1448.39 0 167 0 0 2009 1395.87 0 299 0 1 2010 1451.5 0 86 0 1 2011 1520 0 0 0 2
