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 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)
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 (CKDMN) Royal Navy 1692 0.0588 1 1693 0.0591 2 1694 0.0593 2 1695 0.0595 2 1696 0.0597 2 1697 0.0599 3 1698 0.0601 1 1699 0.0604 1 1700 0.0606 1 1701 0.08437 1 1702 0.08206 2 1703 0.076 2 1704 0.092 2 1705 0.086 2 1706 0.071 2 1707 0.078 2 1708 0.086 2 1709 0.081 2 1710 0.076 2 1711 0.077 7 1712 0.075 2 1713 0.074 1 1714 0.082 1 1715 0.077 1 1716 0.08 1 1717 0.086 0 1718 0.09 1 1719 0.087 1 1720 0.096 1 1721 0.088 1 1722 0.087 2 1723 0.087 1 1724 0.086 1 1725 0.09 1 1726 0.089 1 1727 0.087 1 1728 0.095 2 1729 0.088 1 1730 0.084 1 1731 0.082 1 1732 0.085 1 1733 0.087 1 1734 0.087 2 1735 0.087 2 1736 0.092 1 1737 0.086 1 1738 0.087 1 1739 0.087 1 1740 0.092 2 1741 0.096 5 1742 0.096 3 1743 0.092 3 1744 0.09 3 1745 0.089 3 1746 0.095 2 1747 0.098 3 1748 0.098 3 1749 0.099 6 1750 0.1 1 1751 0.098 1 1752 0.106 2 1753 0.105 1 1754 0.101 1 1755 0.102 2 1756 0.105 3 1757 0.119 4 1758 0.12 4 1759 0.114 5 1760 0.118 5 1761 0.12 5 1762 0.119 5 1763 0.125 7 1764 0.126 2 1765 0.126 3 1766 0.129 2 1767 0.134 2 1768 0.131 1 1769 0.133 2 1770 0.13 2 1771 0.139 2 1772 0.14 3 1773 0.142 2 1774 0.141 2 1775 0.147 2 1776 0.149 3 1777 0.157 4 1778 0.156 5 1779 0.151 4 1780 0.157 6 1781 0.182 7 1782 0.181 11 1783 0.176 7 1784 0.17 9 1785 0.17 12 1786 0.182 3 1787 0.178 2 1788 0.172 2 1789 0.173 2 1790 0.191 2 1791 0.193 3 1792 0.212 3 1793 0.207 2 1794 0.202 6 1795 0.246 10 1796 0.258 12 1797 0.259 24 1798 0.273 13 1799 0.302 12 1800 0.345 15 1801 0.367 15 1802 0.318 17 1803 0.314 12 1804 0.334 8 1805 0.365 12 1806 0.369 14 1807 0.395 16 1808 0.386 17 1809 0.422 18 1810 0.465 19 1811 0.445 20 1812 0.452 20 1813 0.486 21 1814 0.465 23 1815 0.479 23 1816 0.426 17 1817 0.442 10 1818 0.459 7 1819 0.429 7 1820 0.435 6 1821 0.417 7 1822 0.397 6 1823 0.415 5 1824 0.446 6 1825 0.493 6 1826 0.432 6 1827 0.45 7 1828 0.45 6 1829 0.435 6 1830 0.451 6 1831 0.444 5 1832 0.443 6 1833 0.434 5 1834 0.461 4 1835 0.487 5 1836 0.528 4 1837 0.514 4 1838 0.541 5 1839 0.563 4 1840 0.542 5 1841 0.519 5 1842 0.492 6 1843 0.493 6 1844 0.533 6 1845 0.568 5 1846 0.585 6 1847 0.614 7 1848 0.583 8 1849 0.591 7 1850 0.544 6 1851 0.562 6 1852 0.583 5 1853 0.658 6 1854 0.716 8 1855 0.718 14 1856 0.757 19 1857 0.749 13 1858 0.711 10 1859 0.764 8 1860 0.781 11 1861 0.815 13 1862 0.817 13 1863 0.891 11 1864 0.94 11 1865 0.957 11 1866 0.989 10 1867 0.977 11 1868 0.988 11 1869 1.014 11 1870 1.084 9 1871 1.164 9 1872 1.229 10 1873 1.285 9 1874 1.282 10 1875 1.252 11 1876 1.236 11 1877 1.22 11 1878 1.197 11 1879 1.15 12 1880 1.236 10 1881 1.256 11 1882 1.293 11 1883 1.301 10 1884 1.264 11 1885 1.236 11 1886 1.246 13 1887 1.297 13 1888 1.345 12 1889 1.418 13 1890 1.452 15 1891 1.452 16 1892 1.419 16 1893 1.419 16 1894 1.496 16 1895 1.53 18 1896 1.582 20 1897 1.621 22 1898 1.711 21 1899 1.815 24 1900 1.885 26 1901 1.901 30 1902 1.91 31 1903 1.885 31 1904 1.887 36 1905 1.956 37 1906 2.034 33 1907 2.108 31 1908 2.008 31 1909 2.051 32 1910 2.138 36 1911 2.224 40 1912 2.319 43 1913 2.417 44 1914 2.445 49 1915 2.929 52 1920 5.923 157 1921 4.864 88 1922 4.419 81 1923 4.217 56 1924 4.328 53 1925 4.469 54 1926 4.311 60 1927 4.559 58 1928 4.559 58 1929 4.651 57 1930 4.575 56 1931 4.279 53 1932 4.186 51 1933 4.261 50 1934 4.478 54 1935 4.679 57 1936 4.944 65 1937 5.288 81 1938 5.454 78 1939 5.851 96 1940 7.083 69 1947 10.432 267 1948 11.425 194 1949 12.168 163 1950 12.737 186
