Download UK Public Spending Data Series 1692-2028
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 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, 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) P1 Gross Domestic Product (2 series) Q1 Inflation (2 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 GDD Inflation GDP Gross Domestic Product (current $) 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 2025 Budget 2024 Budget 2023 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 (LKPSI) Public sector debt interest (current) 1868 0.9884 5 1869 1.0142 5 1870 1.0838 5 1871 1.1637 6 1872 1.2285 7 1873 1.2853 7 1874 1.2821 8 1875 1.2523 9 1876 1.2359 9 1877 1.2199 9 1878 1.1967 9 1879 1.1501 10 1880 1.2357 10 1881 1.2555 11 1882 1.2935 14 1883 1.301 11 1884 1.2636 10 1885 1.2365 10 1886 1.246 10 1887 1.2965 11 1888 1.3451 11 1889 1.4176 11 1890 1.4517 11 1891 1.4517 11 1892 1.4186 11 1893 1.4187 14 1894 1.496 14 1895 1.5303 15 1896 1.5817 15 1897 1.6212 16 1898 1.7111 16 1899 1.8149 17 1900 1.8855 19 1901 1.9006 20 1902 1.9104 22 1903 1.8848 24 1904 1.8872 26 1905 1.9559 29 1906 2.0344 31 1907 2.1077 32 1908 2.0081 34 1909 2.0511 35 1910 2.1379 36 1911 2.2243 37 1912 2.319 39 1913 2.4173 41 1914 2.445 40 1915 2.9285 41 1916 3.3933 42 1917 4.1975 43 1918 4.9809 43 1919 5.347 43 1920 5.923 43 1921 4.864 47 1922 4.419 59 1923 4.217 66 1924 4.328 69 1925 4.469 71 1926 4.311 78 1927 4.559 85 1928 4.559 95 1929 4.651 102 1930 4.575 106 1931 4.279 113 1932 4.186 116 1933 4.261 121 1934 4.478 132 1935 4.679 123 1936 4.944 123 1937 5.288 125 1938 5.454 129 1939 5.8514 133 1940 7.0835 135 1941 8.512 137 1942 9.3023 138 1943 9.875 137 1944 9.9346 138 1945 9.6429 137 1946 9.6769 129 1947 10.4317 127 1948 11.429 134 1949 12.172 118 1950 12.742 127 1993 769.855 3864 1995 851.845 3470 1996 909.993 3656 1997 953.405 3568 1998 998.501 357 1999 1043.25 541 2000 1100.75 313 2001 1146.14 385 2002 1191.44 304 2003 1258.33 266 2004 1322.64 236 2005 1398.75 385 2006 1472.04 440 2007 1544.64 518 2008 1593.6 700 2009 1592.3 451 2010 1567.8 179 2011 1634.2 600 2012 1680.1 561 2013 1735.1 515 2014 1809.7 547 2015 1892.4 706 2016 1942.6 776 2017 2029.4 844 2018 2115.1 831 2019 2190.4 850 2020 2258.3 667 2021 2110.5 739 2022 2400.6 802 2023 2637.1 870 2024 2779 1105 2025 2933.2 1098 2026 3062.6 1132 2027 3164.2 1167 2028 3277.1 1203
