Open data on public expenditure — datasets, categories and a SPARQL endpoint for research and analysis

Mapping the UK's Regional Spend on Pothole Repair and Road Upkeep

The United Kingdom publishes more granular government payment data than almost any other country on earth, and few datasets are quite as immediately relatable to ordinary citizens as the figures for road maintenance and pothole repair. Every year the Department for Transport channels billions of pounds through local authorities and national agencies to keep motorways, A-roads, and suburban streets driveable. For anyone who has ever winced at the suspension-shudder of a freshly patched crater, the regional breakdown of this expenditure offers a rare quantitative window onto a politically charged area of public spending.

For an Australian reader the relevance is sharper than it might first appear. Australia spends tens of billions of dollars a year on its road network, and the way funding flows from Canberra to state agencies and local councils shapes outcomes in places as varied as the Pacific Highway north of Coffs Harbour and the backstreets of regional Queensland. Studying how the United Kingdom records and publishes its own road maintenance outlays gives analysts in Sydney, Melbourne, or Tamworth a benchmark for what good regional transparency looks like.

How the Department for Transport Distributes Road Maintenance Funding Across the Regions

The Department for Transport does not repair roads itself. Instead it provides formula-based grants to Transport for London, National Highways, and the highway authorities of Scotland, Wales, and Northern Ireland, which in turn pass money down to county councils, unitary authorities, and metropolitan boroughs. The largest single pot is the Local Highways Maintenance block, distributed using a needs-based formula that weighs road length, traffic volumes, and deprivation indicators.

Within England, Integrated Transport Block funding sits alongside the highways maintenance pot and lets local authorities mix and match capital works. A council in Cumbria can fund a major resurfacing project in the same financial year that it patches dozens of potholes on rural lanes. Regional offices of the Department, historically based in Birmingham, Leeds, and Bristol, monitor compliance but do not dictate which streets get treated first.

Because allocations are published by recipient authority, the dataset is essentially a ledger of payments to named bodies. The money can be tracked all the way from Westminster to the contractor laying tarmac in a village outside Inverness, a level of traceability that would be the envy of many Australian state treasuries.

Reading the Regional Expenditure Tables

Publicspending.net organises the UK payment records into tables that slice maintenance spending by region, financial year, and recipient authority. Headline figures are reported as total maintenance expenditure per head of population, which neutralises the distortion caused by London's outsized network and gives smaller regions like the North East or Wales a fair hearing.

Per-capita spending varies enormously. Rural authorities in Cornwall or Northumberland often spend more per resident than dense urban boroughs, reflecting both the sheer length of road each council maintains and the higher cost of mobilising crews to remote sites. The pattern will feel familiar to anyone who has driven the Barrier Highway through South Australia or the Mitchell Highway deep into western Queensland, where distance inflates the price of every patch.

The site also separates capital expenditure, which creates new assets or extends the life of existing ones, from revenue expenditure, which covers routine repairs. Pothole filling generally appears in the revenue column, while full resurfacing shows up as capital. Distinguishing the two matters because a council can post impressive pothole numbers while letting its underlying road condition deteriorate, a tension that recurs in Australian Local Government Area reports as well.

Comparing Allocations Across the Four Nations

Spending per kilometre of road diverges sharply once England, Scotland, Wales, and Northern Ireland are compared on their own terms. Scotland's trunk road network is managed centrally by Transport Scotland, which removes the variability seen between English local authorities. Wales has progressively brought more roads under the South Wales Trunk Road Agent and the North and Mid Wales Trunk Road Agent, while local county borough councils handle the rest.

Northern Ireland's network, administered through the Department for Infrastructure, is the smallest by length but carries traffic intensities comparable to parts of north-west England. The published records show consistently high per-kilometre outlays, partly because of the smaller denominator and partly because the region has invested heavily in schemes like the A5 Western Transport Corridor. Australian readers might draw a parallel with the Northern Territory, where the Stuart Highway corridor demands similar concentrated investment relative to its modest traffic count.

Within England itself, the gap between London boroughs and authorities like Herefordshire or Lincolnshire is one of the most commented-on features of the dataset. Transport for London receives substantial direct grants for its road network, separate from the Department for Transport's allocations to other English authorities. That structural difference explains why a simple cross-tabulation of total spending can mislead without a clear understanding of which tier of government holds responsibility for which road.

Pothole Repair Spending as a Political Barometer

Few line items attract as much public attention as pothole repair, and the data reflects this through a surge in spending that follows severe winters. The cold snaps of 2017-18 and 2022-23 produced visible spikes in patching expenditure across northern and central English authorities, with the records showing clearly how reactive spending displaces planned maintenance when budgets are tight.

The Department for Transport publishes a separate Pothole Action Fund, ring-fenced for filling and prevention, which has grown from modest beginnings in the mid-2010s to several hundred million pounds per year. Tracking allocations from this fund across regions offers a near-real-time read on which councils are getting central government support and which are expected to fund repairs from their own balances. The transparency is unusual internationally and has been cited in Australian parliamentary inquiries as a model worth considering.

The figures also show a steady migration of spending away from reactive patching toward surface dressing and preventative treatments. This shift, often promoted by groups like the Asphalt Industry Alliance, mirrors advice given to Australian councils by Austroads and state roading agencies. When prevention is well funded, the dataset shows fewer emergency interventions in subsequent years, a virtuous cycle that becomes visible only when numbers are tracked over multiple financial cycles.

Trends Over Time and the Squeeze of Real-Terms Budgets

Headline maintenance allocations have crept upward in nominal terms, but once inflation and construction cost indices are applied, the real purchasing power of the road maintenance budget has been broadly flat for much of the past decade. The payment records make this compression visible because they expose the same line item across successive financial years, allowing analysts to deflate consistently.

Construction cost inflation in the UK, much like in Australia, has been driven by rising bitumen prices, energy costs for asphalt plants, and labour shortages. The price of a tonne of hot mix asphalt in 2024 was substantially higher than in 2019, and the records show that councils have responded by treating fewer kilometres each year even when nominal budgets rose. This trade-off is openly debated in Australian state parliaments, particularly in New South Wales and Victoria, where rural shires warn that their roads are entering a deficit cycle.

The data also captures one-off interventions such as the Levelling Up Fund and the Bus Service Improvement Plan, which sometimes included elements of highways renewal. Parsing these from the core maintenance pot requires care, and the site's standardised coding makes it possible to filter them out or include them depending on the question being asked.

Querying the Data Through SPARQL and Ontology Tools

For researchers who prefer not to rely on pre-built tables, publicspending.net exposes the same underlying records through a SPARQL endpoint and an ontology that classifies payments by sector, function, and geography. A researcher in Brisbane or Perth can write a single query that returns every pothole repair payment recorded by a named English local authority across a chosen range of financial years, then pivot the results by region or recipient type.

The ontology links each payment to administrative geographies that nest neatly inside one another, from region down to local authority district and, where the records permit, down to individual wards. This structure is far richer than most Australian open data portals, which tend to publish road expenditure aggregated at state or local government area level. The UK approach allows a more granular look at how spending patterns shift across a single metropolitan area, something that would require freedom of information requests in most Australian jurisdictions.

Bulk downloads are available for analysts who prefer to work in R or Python, and the site maintains stable identifiers for each paying and receiving entity. That stability means historical comparisons remain valid even when authorities merge, are abolished, or change names, a feature that Australian users will recognise as solving one of the more frustrating problems in their own longitudinal data.

What the UK Picture Means for Australian Road Funding Debates

Australian state road authorities publish their own expenditure statements, but rarely at the same level of regional granularity as the UK's local authority returns. The contrast raises a practical question for policy analysts in places like Dubbo, Burnie, or Bundaberg: would Australian commuters benefit from a standardised, comparable record of every dollar spent on the road beneath their tyres?

Studying the UK dataset suggests three lessons worth weighing. First, ring-fenced funds like the Pothole Action Fund produce data that is both more useful and more politically salient than general maintenance grants. Second, per-capita and per-kilometre metrics tell different stories, and both need to be reported alongside raw totals. Third, the ability to query payment-level data through semantic web tools transforms a static spreadsheet into a research instrument that can answer new questions long after the original budget cycle closes.

Anyone who has listened to Australian drivers complain that the roads are shocking after a wet winter will recognise the political pressure that drives these debates. A drive from Bourke to Cunnamulla, or from Cairns to Cooktown, surfaces the same frustrations that British motorists voice about the A82 along Loch Lomond or the A591 through the Lake District. Open data on who spends what, where, and when is the first step toward holding decision-makers to account.

The site invites researchers, journalists, and curious citizens to explore the UK Department for Transport's regional road maintenance and pothole repair expenditure through its tables, bulk downloads, and SPARQL endpoint. Whether the goal is to benchmark Australian practice, sharpen a local story, or satisfy a stubborn curiosity about how the British fill their craters, the data is open, standardised, and waiting to be queried.