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.
Prepare a suite of data for download by making a selection from one of the dropdown menus below. You can select:
Select Functional Data Series Group: Select a group of data series to download (you can add individual data series later):
Add Individual Data Series: Select Spending Data Series to add to download (you can add more later):
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.
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 | (CKTOT) Total central government own expenditure | (GKTOT) Total expenditure | (LKTOT) Total Local Authorities' current expenditure |
| 1692 | 0.05885 | 4 | 0 | 0 |
| 1693 | 0.05906 | 6 | 0 | 0 |
| 1694 | 0.05927 | 6 | 0 | 0 |
| 1695 | 0.05949 | 6 | 0 | 0 |
| 1696 | 0.0597 | 8 | 0 | 0 |
| 1697 | 0.05992 | 8 | 0 | 0 |
| 1698 | 0.06014 | 4 | 0 | 0 |
| 1699 | 0.06036 | 5 | 0 | 0 |
| 1700 | 0.06058 | 3 | 0 | 0 |
| 1701 | 0.0608 | 3 | 0 | 0 |
| 1702 | 0.06102 | 5 | 0 | 0 |
| 1703 | 0.06124 | 5 | 0 | 0 |
| 1704 | 0.06146 | 6 | 0 | 0 |
| 1705 | 0.06168 | 6 | 0 | 0 |
| 1706 | 0.06191 | 7 | 0 | 0 |
| 1707 | 0.06213 | 9 | 0 | 0 |
| 1708 | 0.06236 | 8 | 0 | 0 |
| 1709 | 0.06258 | 9 | 0 | 0 |
| 1710 | 0.06281 | 10 | 0 | 0 |
| 1711 | 0.06304 | 15 | 0 | 0 |
| 1712 | 0.06326 | 8 | 0 | 0 |
| 1713 | 0.06349 | 6 | 0 | 0 |
| 1714 | 0.06372 | 6 | 0 | 0 |
| 1715 | 0.06396 | 6 | 0 | 0 |
| 1716 | 0.06419 | 7 | 0 | 0 |
| 1717 | 0.06442 | 6 | 0 | 0 |
| 1718 | 0.06465 | 6 | 0 | 0 |
| 1719 | 0.06489 | 6 | 0 | 0 |
| 1720 | 0.06512 | 6 | 0 | 0 |
| 1721 | 0.06536 | 6 | 0 | 0 |
| 1722 | 0.0656 | 7 | 0 | 0 |
| 1723 | 0.06584 | 6 | 0 | 0 |
| 1724 | 0.06607 | 5 | 0 | 0 |
| 1725 | 0.06631 | 6 | 0 | 0 |
| 1726 | 0.06655 | 6 | 0 | 0 |
| 1727 | 0.0668 | 6 | 0 | 0 |
| 1728 | 0.06704 | 7 | 0 | 0 |
| 1729 | 0.06728 | 6 | 0 | 0 |
| 1730 | 0.06752 | 6 | 0 | 0 |
| 1731 | 0.06777 | 5 | 0 | 0 |
| 1732 | 0.06802 | 5 | 0 | 0 |
| 1733 | 0.06826 | 5 | 0 | 0 |
| 1734 | 0.06851 | 6 | 0 | 0 |
| 1735 | 0.06876 | 6 | 0 | 0 |
| 1736 | 0.06901 | 6 | 0 | 0 |
| 1737 | 0.06926 | 5 | 0 | 0 |
| 1738 | 0.06951 | 5 | 0 | 0 |
| 1739 | 0.06976 | 5 | 0 | 0 |
| 1740 | 0.07001 | 6 | 0 | 0 |
| 1741 | 0.07027 | 7 | 0 | 0 |
| 1742 | 0.07052 | 9 | 0 | 0 |
| 1743 | 0.07078 | 9 | 0 | 0 |
| 1744 | 0.07104 | 9 | 0 | 0 |
| 1745 | 0.07129 | 9 | 0 | 0 |
| 1746 | 0.07155 | 10 | 0 | 0 |
| 1747 | 0.07181 | 11 | 0 | 0 |
| 1748 | 0.07207 | 11 | 0 | 0 |
| 1749 | 0.07233 | 13 | 0 | 0 |
| 1750 | 0.0726 | 7 | 0 | 0 |
| 1751 | 0.07286 | 6 | 0 | 0 |
| 1752 | 0.07312 | 7 | 0 | 0 |
| 1753 | 0.07339 | 6 | 0 | 0 |
| 1754 | 0.07365 | 3 | 0 | 0 |
| 1755 | 0.07392 | 7 | 0 | 0 |
| 1756 | 0.07419 | 10 | 0 | 0 |
| 1757 | 0.07446 | 11 | 0 | 0 |
| 1758 | 0.07473 | 13 | 0 | 0 |
| 1759 | 0.075 | 15 | 0 | 0 |
| 1760 | 0.07723 | 18 | 0 | 0 |
| 1761 | 0.07953 | 21 | 0 | 0 |
| 1762 | 0.0819 | 20 | 0 | 0 |
| 1763 | 0.08433 | 18 | 0 | 0 |
| 1764 | 0.08684 | 11 | 0 | 0 |
| 1765 | 0.08943 | 12 | 0 | 0 |
| 1766 | 0.09209 | 10 | 0 | 0 |
| 1767 | 0.09483 | 10 | 0 | 0 |
| 1768 | 0.09765 | 9 | 0 | 0 |
| 1769 | 0.10056 | 10 | 0 | 0 |
| 1770 | 0.10355 | 11 | 0 | 0 |
| 1771 | 0.10663 | 10 | 0 | 0 |
| 1772 | 0.1098 | 11 | 0 | 0 |
| 1773 | 0.11307 | 10 | 0 | 0 |
| 1774 | 0.11644 | 10 | 0 | 0 |
| 1775 | 0.1199 | 10 | 0 | 0 |
| 1776 | 0.12347 | 14 | 0 | 0 |
| 1777 | 0.12714 | 15 | 0 | 0 |
| 1778 | 0.13093 | 18 | 0 | 0 |
| 1779 | 0.13482 | 20 | 0 | 0 |
| 1780 | 0.13883 | 23 | 0 | 0 |
| 1781 | 0.14297 | 26 | 0 | 0 |
| 1782 | 0.14722 | 29 | 0 | 0 |
| 1783 | 0.1516 | 24 | 0 | 0 |
| 1784 | 0.15611 | 24 | 0 | 0 |
| 1785 | 0.16076 | 26 | 0 | 0 |
| 1786 | 0.16554 | 17 | 0 | 0 |
| 1787 | 0.17047 | 15 | 0 | 0 |
| 1788 | 0.17554 | 16 | 0 | 0 |
| 1789 | 0.18076 | 16 | 0 | 0 |
| 1790 | 0.18614 | 17 | 0 | 0 |
| 1791 | 0.19168 | 18 | 0 | 0 |
| 1792 | 0.19739 | 17 | 0 | 0 |
| 1793 | 0.20326 | 20 | 0 | 0 |
| 1794 | 0.20931 | 29 | 0 | 0 |
| 1795 | 0.21554 | 39 | 0 | 0 |
| 1796 | 0.22195 | 42 | 0 | 0 |
| 1797 | 0.22856 | 58 | 0 | 0 |
| 1798 | 0.23536 | 47 | 0 | 0 |
| 1799 | 0.24236 | 47 | 0 | 0 |
| 1800 | 0.24957 | 50 | 0 | 0 |
| 1801 | 0.257 | 51 | 0 | 0 |
| 1802 | 0.26382 | 66 | 0 | 0 |
| 1803 | 0.27083 | 55 | 0 | 0 |
| 1804 | 0.27802 | 53 | 0 | 0 |
| 1805 | 0.2854 | 63 | 0 | 0 |
| 1806 | 0.29298 | 71 | 0 | 0 |
| 1807 | 0.30076 | 73 | 0 | 0 |
| 1808 | 0.30875 | 73 | 0 | 0 |
| 1809 | 0.31694 | 78 | 0 | 0 |
| 1810 | 0.32536 | 82 | 0 | 0 |
| 1811 | 0.334 | 82 | 0 | 0 |
| 1812 | 0.33278 | 87 | 0 | 0 |
| 1813 | 0.33156 | 95 | 0 | 0 |
| 1814 | 0.33035 | 111 | 0 | 0 |
| 1815 | 0.32915 | 113 | 0 | 0 |
| 1816 | 0.32795 | 100 | 0 | 0 |
| 1817 | 0.32675 | 71 | 0 | 0 |
| 1818 | 0.32555 | 59 | 0 | 0 |
| 1819 | 0.32437 | 58 | 0 | 0 |
| 1820 | 0.32318 | 58 | 0 | 0 |
| 1821 | 0.322 | 58 | 0 | 0 |
| 1822 | 0.33684 | 56 | 0 | 0 |
| 1823 | 0.35236 | 57 | 0 | 0 |
| 1824 | 0.3686 | 54 | 0 | 0 |
| 1825 | 0.38558 | 56 | 0 | 0 |
| 1826 | 0.40335 | 54 | 0 | 0 |
| 1827 | 0.42194 | 56 | 0 | 0 |
| 1828 | 0.44138 | 56 | 0 | 0 |
| 1829 | 0.46172 | 54 | 0 | 0 |
| 1830 | 0.483 | 54 | 0 | 0 |
| 1831 | 0.48 | 52 | 0 | 0 |
| 1832 | 0.459 | 52 | 0 | 0 |
| 1833 | 0.453 | 51 | 0 | 0 |
| 1834 | 0.481 | 49 | 0 | 0 |
| 1835 | 0.508 | 49 | 0 | 0 |
| 1836 | 0.542 | 65 | 0 | 0 |
| 1837 | 0.521 | 54 | 0 | 0 |
| 1838 | 0.553 | 51 | 0 | 0 |
| 1839 | 0.582 | 52 | 0 | 0 |
| 1840 | 0.546 | 53 | 0 | 0 |
| 1841 | 0.52 | 53 | 0 | 0 |
| 1842 | 0.5 | 54 | 0 | 0 |
| 1843 | 0.498 | 55 | 0 | 0 |
| 1844 | 0.543 | 55 | 0 | 0 |
| 1845 | 0.575 | 55 | 0 | 0 |
| 1846 | 0.614 | 54 | 0 | 0 |
| 1847 | 0.638 | 55 | 0 | 0 |
| 1848 | 0.614 | 59 | 0 | 0 |
| 1849 | 0.625 | 59 | 0 | 0 |
| 1850 | 0.572 | 56 | 0 | 0 |
| 1851 | 0.601 | 55 | 0 | 0 |
| 1852 | 0.607 | 54 | 0 | 0 |
| 1853 | 0.678 | 55 | 0 | 0 |
| 1854 | 0.718 | 56 | 0 | 0 |
| 1855 | 0.739 | 69 | 0 | 0 |
| 1856 | 0.769 | 93 | 0 | 0 |
| 1857 | 0.779 | 76 | 0 | 0 |
| 1858 | 0.752 | 68 | 0 | 0 |
| 1859 | 0.794 | 65 | 0 | 0 |
| 1860 | 0.812 | 70 | 0 | 0 |
| 1861 | 0.847 | 73 | 0 | 0 |
| 1862 | 0.86 | 72 | 0 | 0 |
| 1863 | 0.896 | 70 | 0 | 0 |
| 1864 | 0.945 | 68 | 0 | 0 |
| 1865 | 0.975 | 67 | 0 | 0 |
| 1866 | 1.02 | 67 | 0 | 0 |
| 1867 | 1.002 | 67 | 0 | 0 |
| 1868 | 1.001 | 72 | 0 | 33 |
| 1869 | 1.006 | 76 | 0 | 32 |
| 1870 | 1.064 | 67 | 0 | 30 |
| 1871 | 1.15 | 68 | 0 | 33 |
| 1872 | 1.22 | 70 | 0 | 34 |
| 1873 | 1.28 | 69 | 0 | 36 |
| 1874 | 1.272 | 75 | 0 | 40 |
| 1875 | 1.245 | 73 | 0 | 44 |
| 1876 | 1.229 | 75 | 0 | 47 |
| 1877 | 1.216 | 76 | 0 | 52 |
| 1878 | 1.184 | 80 | 0 | 53 |
| 1879 | 1.142 | 83 | 0 | 56 |
| 1880 | 1.218 | 82 | 0 | 54 |
| 1881 | 1.243 | 81 | 0 | 57 |
| 1882 | 1.283 | 83 | 0 | 60 |
| 1883 | 1.285 | 87 | 0 | 48 |
| 1884 | 1.244 | 85 | 0 | 48 |
| 1885 | 1.217 | 89 | 0 | 48 |
| 1886 | 1.226 | 92 | 0 | 49 |
| 1887 | 1.278 | 90 | 0 | 49 |
| 1888 | 1.333 | 87 | 0 | 50 |
| 1889 | 1.408 | 87 | 0 | 51 |
| 1890 | 1.442 | 91 | 0 | 53 |
| 1891 | 1.444 | 93 | 0 | 55 |
| 1892 | 1.405 | 96 | 0 | 58 |
| 1893 | 1.406 | 96 | 0 | 70 |
| 1894 | 1.484 | 99 | 0 | 71 |
| 1895 | 1.521 | 101 | 0 | 74 |
| 1896 | 1.57 | 105 | 0 | 76 |
| 1897 | 1.616 | 110 | 0 | 79 |
| 1898 | 1.705 | 112 | 0 | 83 |
| 1899 | 1.809 | 118 | 0 | 87 |
| 1900 | 1.885 | 144 | 0 | 93 |
| 1901 | 1.893 | 193 | 0 | 101 |
| 1902 | 1.906 | 205 | 0 | 106 |
| 1903 | 1.881 | 194 | 0 | 112 |
| 1904 | 1.881 | 155 | 0 | 119 |
| 1905 | 1.949 | 150 | 0 | 129 |
| 1906 | 2.033 | 146 | 0 | 134 |
| 1907 | 2.113 | 143 | 0 | 136 |
| 1908 | 2.011 | 132 | 0 | 141 |
| 1909 | 2.052 | 135 | 0 | 145 |
| 1910 | 2.14 | 148 | 0 | 149 |
| 1911 | 2.227 | 158 | 0 | 153 |
| 1912 | 2.327 | 165 | 0 | 159 |
| 1913 | 2.42 | 174 | 0 | 166 |
| 1914 | 2.451 | 183 | 0 | 175 |
| 1915 | 2.943 | 550 | 0 | 181 |
| 1916 | 3.434 | 1549 | 0 | 182 |
| 1917 | 4.276 | 2189 | 0 | 185 |
| 1918 | 5.108 | 2687 | 0 | 202 |
| 1919 | 5.484 | 2570 | 0 | 230 |
| 1920 | 5.975 | 1655 | 0 | 302 |
| 1921 | 4.907 | 1177 | 0 | 388 |
| 1922 | 4.458 | 1058 | 0 | 418 |
| 1923 | 4.254 | 799 | 0 | 398 |
| 1924 | 4.366 | 731 | 0 | 396 |
| 1925 | 4.508 | 733 | 0 | 409 |
| 1926 | 4.349 | 757 | 0 | 429 |
| 1927 | 4.599 | 762 | 0 | 464 |
| 1928 | 4.599 | 753 | 0 | 468 |
| 1929 | 4.692 | 740 | 0 | 466 |
| 1930 | 4.615 | 748 | 0 | 487 |
| 1931 | 4.316 | 763 | 0 | 496 |
| 1932 | 4.223 | 768 | 0 | 499 |
| 1933 | 4.298 | 781 | 0 | 493 |
| 1934 | 4.517 | 719 | 0 | 498 |
| 1935 | 4.72 | 733 | 0 | 522 |
| 1936 | 4.987 | 777 | 0 | 541 |
| 1937 | 5.334 | 836 | 0 | 557 |
| 1938 | 5.502 | 846 | 0 | 580 |
| 1939 | 5.918 | 942 | 0 | 610 |
| 1940 | 7.183 | 1338 | 0 | 661 |
| 1941 | 8.654 | 3891 | 0 | 718 |
| 1942 | 9.482 | 4814 | 0 | 803 |
| 1943 | 10.093 | 5664 | 0 | 790 |
| 1944 | 10.18 | 5837 | 0 | 797 |
| 1945 | 9.908 | 6112 | 0 | 830 |
| 1946 | 9.968 | 5517 | 0 | 888 |
| 1947 | 10.772 | 4106 | 0 | 1292 |
| 1948 | 11.974 | 3263 | 0 | 1091 |
| 1949 | 12.726 | 3215 | 0 | 988 |
| 1950 | 13.308 | 3426 | 0 | 965 |
| 1951 | 14.784 | 0 | 5260 | 0 |
| 1952 | 15.983 | 0 | 5836 | 0 |
| 1953 | 17.121 | 0 | 6099 | 0 |
| 1954 | 18.126 | 0 | 6031 | 0 |
| 1955 | 19.49 | 0 | 6241 | 0 |
| 1956 | 20.956 | 0 | 6763 | 0 |
| 1957 | 22.105 | 0 | 6979 | 0 |
| 1958 | 23.05 | 0 | 7401 | 0 |
| 1959 | 24.348 | 0 | 7816 | 0 |
| 1960 | 25.977 | 0 | 8350 | 0 |
| 1961 | 27.413 | 0 | 10307 | 0 |
| 1962 | 28.711 | 0 | 10999 | 0 |
| 1963 | 30.409 | 0 | 11651 | 0 |
| 1964 | 33.228 | 0 | 12743 | 0 |
| 1965 | 35.888 | 0 | 14122 | 0 |
| 1966 | 38.189 | 0 | 15289 | 0 |
| 1967 | 40.281 | 0 | 17494 | 0 |
| 1968 | 43.656 | 0 | 19092 | 0 |
| 1969 | 47.023 | 0 | 19789 | 0 |
| 1970 | 51.696 | 0 | 21595 | 0 |
| 1971 | 57.67 | 0 | 24240 | 0 |
| 1972 | 64.621 | 0 | 26390 | 0 |
| 1973 | 74.545 | 0 | 30546 | 0 |
| 1974 | 84.513 | 0 | 39218 | 0 |
| 1975 | 106.717 | 0 | 51524 | 0 |
| 1976 | 126.274 | 0 | 58464 | 0 |
| 1977 | 146.973 | 0 | 61867 | 0 |
| 1978 | 169.344 | 0 | 71949 | 0 |
| 1979 | 199.22 | 0 | 85166 | 0 |
| 1980 | 233.184 | 0 | 103858 | 0 |
| 1981 | 256.279 | 0 | 116060 | 0 |
| 1982 | 281.024 | 0 | 128044 | 0 |
| 1983 | 307.207 | 0 | 132700 | 0 |
| 1984 | 329.913 | 0 | 140500 | 0 |
| 1985 | 361.758 | 0 | 150900 | 0 |
| 1986 | 389.149 | 0 | 158600 | 0 |
| 1987 | 428.665 | 0 | 164600 | 0 |
| 1988 | 478.51 | 0 | 173600 | 0 |
| 1989 | 525.274 | 0 | 179900 | 0 |
| 1990 | 570.283 | 0 | 200900 | 0 |
| 1991 | 598.664 | 0 | 218200 | 0 |
| 1992 | 622.08 | 0 | 236200 | 0 |
| 1993 | 654.196 | 191591 | 0 | 61937 |
| 1994 | 692.987 | 203083 | 170116 | 57987 |
| 1995 | 733.266 | 211752 | 8315 | 65651 |
| 1996 | 781.726 | 227675 | 24170 | 69610 |
| 1997 | 830.094 | 235885 | 8995 | 70886 |
| 1998 | 879.102 | 240398 | 9279 | 72204 |
| 1999 | 928.73 | 246386 | 11673 | 75373 |
| 2000 | 976.533 | 251705 | 14741 | 80898 |
| 2001 | 1021.83 | 265932 | 23549 | 85426 |
| 2002 | 1075.56 | 284549 | 36078 | 91267 |
| 2003 | 1139.75 | 304363 | 12618 | 99397 |
| 2004 | 1202.96 | 331923 | 13397 | 107493 |
| 2005 | 1254.06 | 356079 | 14269 | 118624 |
| 2006 | 1325.8 | 361761 | 41913 | 127085 |
| 2007 | 1398.88 | 397780 | 15616 | 132613 |
| 2008 | 1448.39 | 420510 | 40491 | 139796 |
| 2009 | 1439 | 454876 | 59141 | 147455 |
| 2010 | 1453.62 | 487548 | 78957 | 153291 |
| 2011 | 1526.5 | 504426 | 35782 | 158053 |
| 2012 | 1602.8 | 518200 | 0 | 162963 |
| 2013 | 1693.7 | 530600 | 0 | 168025 |
| 2014 | 1789 | 542100 | 0 | 173245 |
| 2015 | 1889.1 | 555400 | 0 | 178627 |
table chart spend/gdp debt/gdp uk gdp uk real gdp 2009 breakdown central+local central local uk budget health education defence 2010
GDP: OBR Economic Outlook
Spending: HM Treasury PESA
> data sources for other years
We have added UK population data to ukpublicspending.co.uk as follows:
Get spending chart.
Download spending table.
Download spending data series.
Review data sources.
ukpublicspending.co.uk was designed and executed by:
Christopher Chantrill.
Report bugs here.

Spending Review 2010: Data Updates
On October 20, 2010, HM Treasury published a Spending Review for UK public spending for fiscal years...
July 7 Update: Country Spending, GDP Update
Country Spending: Starting today ukpublicspending.co.uk is publishing country spending for the UK. ...
July 2 Update: PESA 2010
On July 1, 2010, HM Treasury published its Public Expenditure Statistical Analyses (PESA) for 2010. ...
> blog
Autumn Statement 2011
Chancellor George Osborne introduces six more years of pain.
Budget 2011: George Osborne set for 8bn pound windfall
Treasury revenue up, so no spending cuts in Budget 2011
2011 Budget - HM Treasury
Budget Day is Wednesday 23 March 2011.
> archive
In 1911... at least nine million of the 12 million covered by national insurance were already members of voluntary sick pay schemes. A similar proportion were also eligible for medical care.
Green, Reinventing Civil Society
ukpublicspending.co.uk
presented by Christopher Chantrill
Data Sources
Contact
