Download UK Public Spending Data Series 1692-2025
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.
Warning: Be careful about using raw data.
The raw data series are not “curated,” meaning that you cannot be sure if the data
series applies for a specific year and a specific function.
A data series typically does not extend the whole length of UK history.
Check out
multiyear download if you want full-length curated data series.
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 dont 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, finan (5 series) 12 Foreign economic aid (7 series) 13 General services (10 series) 14 Basic research (3 series) 15 R&D General public services (2 series) 16 General public services n.e.c. (2 series) 17 Public debt transactions (4 series) 21 Military defence (9 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 labour (7 series) 42 Agriculture, forestry, fishing and hunt (7 series) 43 Fuel and energy (5 series) 44 Mining, manufacturing and construction (4 series) 45 Transport (30 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 (4 series) 53 Pollution abatement (2 series) 54 Protection of biodiversity and landscap (3 series) 55 R&D Environmental protection (2 series) 56 Environmental protection n.e.c. (8 series) 61 Housing development (3 series) 62 Community development (3 series) 63 Water supply (6 series) 64 Street lighting (3 series) 65 R&D Housing and community amenities (2 series) 66 Housing and community amenities n.e.c. (8 series) 73 Medical service (3 series) 74 Public health services (3 series) 75 R&D Health (2 series) 76 Health n.e.c. (10 series) 81 Recreational and sporting services (4 series) 82 Cultural services (7 series) 83 Broadcasting and publishing services (2 series) 84 Religious and other community services (2 series) 85 R&D Recreation, culture and religion (2 series) 86 Recreation, culture and religion n.e.c. (9 series) 91 Pre-primary and primary education (3 series) 92 Secondary education (2 series) 93 Post-secondary non-tertiary education (2 series) 94 Tertiary education (4 series) 95 Education not definable by level (13 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 (7 series) A7 Social exclusion n.e.c. (4 series) A8 R&D Social protection (2 series) A9 Social protection n.e.c. (12 series) AA Pensions n.e.c. (4 series) B1 Other Spending (14 series) F1 Total (6 series) G1 Public Net Debt (1 series) H1 Current Budget Deficit (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 CKCVL Civil List CKDCD Civil defence CKDFA Foreign military aid CKDMA Army CKDMD Military defence CKDMF Royal Air Force CKDMN Royal 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 CKECG Marine coastguard shipping civil aviation CKECM Communication CKEDL Driver and vehicle licensing and testing CKEDN Education n.e.c CKEDT Education (includes training) CKEEC General economic, commercial and labour affairs CKEEN CKEEN CKEER R&D environment protection CKEFE Further Education CKEHE Higher Education CKEMA UK Maritime Agency CKEMC Mining, manufacturing and construction CKEMP Employment policies CKEND Education not definable by level CKEOI Other industries CKEOT Other transport CKEPA Pollution abatement CKEPE Primary education CKEPP Pre-primary education CKEPS Post-secondary non-tertiary education CKEPT Ports 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 CKEUT EU transactions 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 CKHEA Health 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 CKHSH Other social housing CKHSL Street lighting CKHWS Water supply CKLOT National Lottery CKONE Other spending CKPEN Pensions CKPFI Fire-protection services CKPGP Government pensions 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 CKSBU Support for business CKSCT Science and technology CKSFC Family and children CKSFM Supply, Food, Misc CKSHO Housing CKSII Industrial injury benefits CKSIS Income support CKSNE Social protection n.e.c. CKSOA Old age CKSOP Social protection 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 CKTRA Transport CKWEL Public assistance 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 GJW2T Current budget deficit 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 GKONE Other spending GKPDN Pensions n.e.c. GKPEN Pensions 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 GKWEL Public assistance LCAAJ Accounting adjustments (capital) LCAFF agriculture, fisheries and forestry (capital) LCCOI Harbours (capital) LCEDE education (capital) LCEDT training (capital) LCEDU Education (includes training) (capital) LCEED enterprise and economic development (capital) LCEEN Fuel and Energy (capital) LCEEP employment policies (capital) LCENV Environment protection (capital) LCEPK Parks, pleasure grounds (capital) LCETR LCETR LCEWW Waste water management (capital) LCGPS General public services (capital) LCHEA Health (capital) LCHIB Highways and Bridges (capital) LCHOU Housing and community amenities (capital) LCHWS Water supply (capital) LCONE Other spending (capital) LCPCS public and common services (capital) LCPOS Public order and safety (capital) LCREC Recreation, culture and religion (capital) LCSHO Housing (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 (current) LKENV Environment protection (current) LKEOI Other industries LKEPK Parks, pleasure grounds LKETR LKETR LKEWW Waste water management LKGPS General public services (current) LKHEA Health (current) LKHIB Highways and Bridges (current) LKHOU Housing and community amenities (current) LKHSL LKHSL LKHWS Water supply LKONE Other spending (current) 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 Public Debt 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 PCFTO Total Foreign and Commonwealth Office 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 PCNHS Northern Ireland HSS Trusts 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 2022 Budget 2021 Budget 2020 Budget 2019 Budget 2018 Budget 2017 Budget 2016 Budget 2015 Budget 2014 Budget 2013 Budget 2012 Budget 2011 Budget 2010 Budget 2009 Budget 2008
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.
Year GDP (LKSOP) Social protection (current) 1868 0.988 7 1869 1.014 7 1870 1.084 7 1871 1.164 7 1872 1.229 7 1873 1.285 7 1874 1.282 7 1875 1.252 7 1876 1.236 7 1877 1.22 7 1878 1.197 7 1879 1.15 7 1880 1.236 7 1881 1.256 7 1882 1.293 7 1883 1.301 7 1884 1.264 7 1885 1.236 7 1886 1.246 7 1887 1.297 7 1888 1.345 7 1889 1.418 7 1890 1.452 7 1891 1.452 7 1892 1.419 7 1893 1.419 8 1894 1.496 8 1895 1.53 9 1896 1.582 9 1897 1.621 9 1898 1.711 9 1899 1.815 10 1900 1.885 10 1901 1.901 10 1902 1.91 10 1903 1.885 12 1904 1.887 12 1905 1.956 13 1906 2.034 13 1907 2.108 13 1908 2.008 13 1909 2.051 14 1910 2.138 14 1911 2.224 14 1912 2.319 13 1913 2.417 14 1914 2.445 14 1915 2.929 14 1916 3.393 14 1917 4.198 14 1918 4.981 15 1919 5.347 17 1920 5.923 21 1921 4.864 28 1922 4.419 39 1923 4.217 40 1924 4.328 34 1925 4.469 36 1926 4.311 39 1927 4.559 50 1928 4.559 39 1929 4.651 38 1930 4.575 39 1931 4.279 36 1932 4.186 35 1933 4.261 38 1934 4.478 40 1935 4.679 44 1936 4.944 46 1937 5.288 45 1938 5.454 40 1939 5.851 41 1940 7.083 41 1941 8.512 36 1942 9.302 33 1943 9.875 32 1944 9.935 33 1945 9.643 35 1946 9.677 38 1947 10.432 43 1948 11.425 49 1949 12.168 31 1950 12.737 28 1993 769.159 14903 1994 809.486 17158 1995 850.181 19283 1996 907.265 20987 1997 951.75 22292 1998 997.247 21231 1999 1039.75 21935 2000 1095.9 23361 2001 1138.38 24660 2002 1187.67 26337 2003 1256.19 29544 2004 1317.46 32730 2005 1393.04 35390 2006 1470.72 37615 2007 1546.08 39519 2008 1589.26 41620 2009 1584.5 44697 2010 1561.9 49418 2011 1630.7 50980 2012 1672.5 52383 2013 1727.5 53294 2014 1803.1 54188 2015 1879.8 55639 2016 1937.6 55510 2017 2021.7 55250 2018 2102.3 54918 2019 2176.7 54860 2020 2247.1 54165 2021 2087.6 56139 2022 2337.9 56197 2023 2504 56397 2024 2573.2 56598 2025 2668.7 56799