Download UK Public Spending Data Series 1692-2026
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 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 (CKPSI) Public sector debt interest 1692 0.0588 0 1693 0.0591 0 1694 0.0593 0 1695 0.0595 1 1696 0.0597 1 1697 0.0599 1 1698 0.0601 1 1699 0.0604 1 1700 0.0606 1 1701 0.08437 1 1702 0.08206 1 1703 0.076 1 1704 0.092 1 1705 0.086 1 1706 0.071 1 1707 0.078 2 1708 0.086 2 1709 0.081 2 1710 0.076 2 1711 0.077 2 1712 0.075 2 1713 0.074 3 1714 0.082 3 1715 0.077 6 1716 0.08 3 1717 0.086 3 1718 0.09 3 1719 0.087 3 1720 0.096 3 1721 0.088 3 1722 0.087 3 1723 0.087 4 1724 0.086 3 1725 0.09 3 1726 0.089 3 1727 0.087 3 1728 0.095 2 1729 0.088 2 1730 0.084 2 1731 0.082 2 1732 0.085 2 1733 0.087 2 1734 0.087 2 1735 0.087 2 1736 0.092 2 1737 0.086 2 1738 0.087 2 1739 0.087 2 1740 0.092 2 1741 0.096 2 1742 0.096 2 1743 0.092 2 1744 0.09 2 1745 0.089 2 1746 0.095 2 1747 0.098 3 1748 0.098 3 1749 0.099 3 1750 0.1 3 1751 0.098 3 1752 0.106 3 1753 0.105 3 1754 0.101 3 1755 0.102 3 1756 0.105 3 1757 0.119 3 1758 0.12 3 1759 0.114 3 1760 0.118 3 1761 0.12 4 1762 0.119 4 1763 0.125 5 1764 0.126 5 1765 0.126 5 1766 0.129 5 1767 0.134 5 1768 0.131 5 1769 0.133 5 1770 0.13 5 1771 0.139 5 1772 0.14 5 1773 0.142 5 1774 0.141 5 1775 0.147 5 1776 0.149 5 1777 0.157 5 1778 0.156 5 1779 0.151 6 1780 0.157 6 1781 0.182 7 1782 0.181 7 1783 0.176 8 1784 0.17 9 1785 0.17 9 1786 0.182 9 1787 0.178 9 1788 0.172 9 1789 0.173 9 1790 0.191 9 1791 0.193 9 1792 0.212 9 1793 0.207 9 1794 0.202 10 1795 0.246 10 1796 0.258 12 1797 0.259 14 1798 0.273 16 1799 0.302 14 1800 0.345 14 1801 0.367 17 1802 0.318 20 1803 0.314 20 1804 0.334 21 1805 0.365 21 1806 0.369 22 1807 0.395 23 1808 0.386 24 1809 0.422 23 1810 0.465 24 1811 0.445 24 1812 0.452 25 1813 0.486 26 1814 0.465 27 1815 0.479 30 1816 0.426 32 1817 0.442 33 1818 0.459 32 1819 0.429 31 1820 0.435 31 1821 0.417 32 1822 0.397 32 1823 0.415 31 1824 0.446 30 1825 0.493 30 1826 0.432 29 1827 0.45 29 1828 0.45 29 1829 0.435 29 1830 0.451 29 1831 0.444 29 1832 0.443 28 1833 0.434 28 1834 0.461 29 1835 0.487 29 1836 0.528 29 1837 0.514 29 1838 0.541 30 1839 0.563 29 1840 0.542 30 1841 0.519 30 1842 0.492 30 1843 0.493 30 1844 0.533 29 1845 0.568 31 1846 0.585 29 1847 0.614 28 1848 0.583 28 1849 0.591 29 1850 0.544 29 1851 0.562 28 1852 0.583 28 1853 0.658 28 1854 0.716 28 1855 0.718 28 1856 0.757 28 1857 0.749 29 1858 0.711 29 1859 0.764 29 1860 0.781 29 1861 0.815 26 1862 0.817 26 1863 0.891 26 1864 0.94 26 1865 0.957 26 1866 0.989 26 1867 0.977 26 1868 0.988 27 1869 1.014 27 1870 1.084 27 1871 1.164 27 1872 1.229 27 1873 1.285 27 1874 1.282 27 1875 1.252 27 1876 1.236 27 1877 1.22 27 1878 1.197 28 1879 1.15 28 1880 1.236 28 1881 1.256 29 1882 1.293 29 1883 1.301 30 1884 1.264 29 1885 1.236 29 1886 1.246 24 1887 1.297 28 1888 1.345 26 1889 1.418 25 1890 1.452 25 1891 1.452 24 1892 1.419 24 1893 1.419 24 1894 1.496 23 1895 1.53 23 1896 1.582 23 1897 1.621 24 1898 1.711 24 1899 1.815 24 1900 1.885 23 1901 1.901 20 1902 1.91 22 1903 1.885 27 1904 1.887 26 1905 1.956 25 1906 2.034 25 1907 2.108 23 1908 2.008 21 1909 2.051 22 1910 2.138 21 1911 2.224 20 1912 2.319 20 1913 2.417 20 1914 2.445 19 1915 2.929 22 1916 3.393 60 1917 4.198 127 1918 4.981 190 1919 5.347 270 1920 5.923 332 1921 4.864 342 1922 4.419 323 1923 4.217 324 1924 4.328 307 1925 4.469 312 1926 4.311 308 1927 4.559 319 1928 4.559 314 1929 4.651 312 1930 4.575 307 1931 4.279 293 1932 4.186 290 1933 4.261 282 1934 4.478 216 1935 4.679 212 1936 4.944 212 1937 5.288 211 1938 5.454 216 1939 5.851 219 1940 7.083 229 1941 8.512 234 1942 9.302 278 1943 9.875 332 1944 9.935 385 1945 9.643 435 1946 9.677 475 1947 10.432 502 1948 11.425 511 1949 12.168 497 1950 12.737 500 1993 769.159 17428 1994 809.486 20772 1995 850.181 23522 1996 907.265 26452 1997 951.75 27987 1998 997.247 29307 1999 1039.75 28760 2000 1095.9 25012 2001 1138.38 25995 2002 1187.67 22099 2003 1256.19 20915 2004 1317.46 22280 2005 1393.04 23936 2006 1470.72 25808 2007 1546.08 27581 2008 1589.26 29954 2009 1582.7 30852 2010 1558.1 30479 2011 1627.2 46609 2012 1672.3 49704 2013 1727.5 48982 2014 1800.8 48797 2015 1879.5 45371 2016 1931.5 45127 2017 2015.8 48755 2018 2099.8 55128 2019 2170.2 50368 2020 2240.8 49606 2021 2085.6 41012 2022 2357.8 70892 2023 2583.2 108063 2024 2749 82933 2025 2881.3 84798 2026 2993.9 100443