Sign in

Philip Brien

@statisticalphil.bsky.social
127 followers 41 following 84 posts

Researcher at the Commons Library. Public spending, local government, anything else that looks interesting.

PostsRepliesMedia
Philip Brien @statisticalphil.bsky.social · 06/10/2026
I quite like the hypothesis that the actual word used meant something like "rope" (apparently the words in Aramaic are similar, in the same way as our camel/cable), which would be equally literally impossible but fits the metaphor better. (Alternatively Jesus just liked a good pun.)
110
Philip Brien @statisticalphil.bsky.social · 25/08/2026
One more safeguard: large parts of the Armed Forces become illegal if Parliament doesn't approve them annually. www.legislation.gov.uk/ukpga/2006/5...
legislation.gov.uk
Armed Forces Act 2006
An Act to make provision with respect to the armed forces; and for connected purposes.
020
Philip Brien @statisticalphil.bsky.social · 03/06/2026
Not to mention that white English people were eating curry at the very height of Empire. It's a plot point in one of the Sherlock Holmes stories that a rural white family happens to be eating curry one evening.
010
Philip Brien @statisticalphil.bsky.social · 29/04/2026
Could be the personal/institutional distinction. There's a big difference between "my representative's faith tells me a lot about their principles and they should act in accordance with those" and "the Pope should tell them how to vote".
000
Philip Brien @statisticalphil.bsky.social · 20/04/2026
Very small population and very remote (so high cost of services) means that it breaks every single calculation on a per-person basis. As a result it gets its own funding allocations and frequently gets listed separately in legislation (e.g. Local Government Finance Act 1988 s111).
030
Philip Brien @statisticalphil.bsky.social · 20/04/2026
Glad to see that you included the standard "except the City of London and Isles of Scilly" which must, by law, be in every article about local government. (Not that I'm bitter about having to cope with them in every single dataset or anything.)
110
Philip Brien @statisticalphil.bsky.social · 16/04/2026
I don't know why Triceratops fanciers aren't more into Styracosaurus. It's like Triceratops...but _more_ Triceratops.
020
Philip Brien @statisticalphil.bsky.social · 25/09/2025
Experimenting with 3D datavis in QGIS (this is using the Qgis2threejs plugin). The data shows railway station entries/exits for 2023/24. I'm enjoying the fact that this turns London into a horrifying gothic spire.
020
Philip Brien @statisticalphil.bsky.social · 28/07/2025
We're using a new version of Excel at work. Good things: - The formula bar is finally in monospace font by default! No more pixel hunting! - The colour picker is huge and clear and includes high-contrast filtering Less good: - The chart "Select Data" dialog remains exactly as buggy as ever.
000
Philip Brien @statisticalphil.bsky.social · 16/07/2025
Interesting phrasing on today's Commons order paper. I haven't seen "the matter of" used for a general debate before - maybe it looked bad to say that the House "has considered giving every child the best start in life" as if it might say "nah, won't bother".
5. General Debate on giving every child the best start in life

Until 7.00pm (Standing Order No. 9(3))

The Prime Minister

That this House has considered the matter of giving every child the best start in life.
010
Philip Brien @statisticalphil.bsky.social · 27/06/2025
Well, this is exciting - I've been grumbling for *years* about how figures at Budgets and Spending Reviews are only given to the nearest £100 million, which makes data analysis needlessly difficult. And the Treasury have just gone ahead and published the unrounded data! www.gov.uk/government/p...
gov.uk
Supporting documents for Spending Review 2025
Supporting documents alongside the main Spending Review 2025 document: distributional analysis, policy costings and data sources.
012
Philip Brien @statisticalphil.bsky.social · 12/06/2025
On the investment side, defence is getting a larger increase than in recent years, but several departments will see fairly large decreases relative to existing budgets.
Chart showing the largest increases and decreases in annual average real terms growth in investment spending across the 2025 Spending Review period.
000
Philip Brien @statisticalphil.bsky.social · 12/06/2025
Here's a couple more charts to go with it. Relative to existing budgets, DSIT and the Single Intelligence Account are doing pretty well out of this; the FCDO is decidedly not (because of aid cuts).
Chart showing the five biggest increases and decreases in annual average real terms growth for day-to-day spending across the 2025 Spending Review period.
100
Philip Brien @statisticalphil.bsky.social · 12/06/2025
Summary briefing on the Spending Review is out! commonslibrary.parliament.uk/research-bri...
commonslibrary.parliament.uk
Spending Review 2025: A summary
A summary of the departmental spending limits and other announcements in the 2025 Spending Review.
110
Philip Brien @statisticalphil.bsky.social · 11/06/2025
On the investment spending side, it's the MOD that takes the lion's share, followed by Transport.
Chart showing that half of the increase in investment funding over the SR2025 period is going to defence.
011
Philip Brien @statisticalphil.bsky.social · 11/06/2025
Time for some initial Spending Review analysis! As expected, this is a very health-centric Spending Review - most of the day-to-day spending increase goes there. Depending how you count it, 20 or so departments will have to share about £5 billion of the remaining increases.
Chart showing day-to-day spending increases in the 2025 Spending Review. Over half of the increase is going to health.
141
Philip Brien @statisticalphil.bsky.social · 05/06/2025
Your post was a very useful resource! Publicly available descriptions of how the process actually works are annoyingly hard to come by, so I was glad to have something like that to cite.
180
Philip Brien @statisticalphil.bsky.social · 04/06/2025
It's out! Everything* you ever wanted to know about next week's Spending Review. *probably not everything commonslibrary.parliament.uk/research-bri...
commonslibrary.parliament.uk
Spending Review 2025: Background briefing
Ahead of the Spending Review on 11 June 2025, this briefing looks at the process, the public spending context, and the factors affecting the government’s plans.
001
Philip Brien @statisticalphil.bsky.social · 09/05/2025
A little pope data for you all this fine morning. I like any dataset that goes back 2,000 years (although the chart only goes back to 1404). (Source: www.theguardian.com/news/datablo...)
Chart showing the ages at start and end of pontificate for all popes since Innocent VII. In general, papal reigns are getting longer and beginning later in life, although there's plenty of exceptions.
020
Philip Brien @statisticalphil.bsky.social · 30/04/2025
That would be the so-called "Pole of Inaccessibility", which I reckon is just to the north-east of Birmingham (it's the blue flag on this map). There's not a lot in it, but Towcester (green star) is marginally closer to the Wash than the Pole is to any coastline.
110
Philip Brien @statisticalphil.bsky.social · 11/04/2025
Today in Baffling Web Design Decisions: what on earth is going on with Glasgow City Council's year selection for their council meetings calendar?
A calendar of meetings for Glasgow City Council, from the council website. The year selection at the top is in no obvious order (the first four are 1998, 2004, 2010 and 2024).
110
Philip Brien @statisticalphil.bsky.social · 26/02/2025
We've published a new short article on the aid cut (and defence spending increase) announced by the PM yesterday. commonslibrary.parliament.uk/uk-to-reduce...
commonslibrary.parliament.uk
UK to reduce aid to 0.3% of gross national income from 2027
The UK will reduce aid spending to 0.3% of gross national income in 2027 (the lowest level since 1999) to fund higher defence spending.
001
Philip Brien @statisticalphil.bsky.social · 21/01/2025
Behold, a 91% rural local authority! (Why? Because the ONS defines "urban" as "within a built-up area which has a population of 10,000 or more", and "rural" as everything else. And in the 2021 Census, the City of London built-up area had a population of about 7,500.)
Skyline of the City of London. Source: GJMarshy, via Wikimedia Commons, CC-BY-SA.
010
Philip Brien @statisticalphil.bsky.social · 23/12/2024
The big news from 2024 that I missed at the time: HM Treasury have finally changed the font in their "official forecasts for the UK economy" document so that capital letters no longer have little "horns". (First image from March this year, second one from December.)
Screenshot from HM Treasury's "Forecasts for the UK economy: March 2024", showing odd visual artefacts on capital letters.Screenshot from HM Treasury's "Forecasts for the UK economy: December 2024", showing no visual artefacts on capital letters.
000
Philip Brien @statisticalphil.bsky.social · 17/12/2024
FACT 4 (last one, thankfully): The boundaries of the Norfolk Broads National Park are pleasingly bonkers because water and reclaimed land don't play by your rules.
Map showing the boundaries of the Norfolk Broads National Park
120
Philip Brien @statisticalphil.bsky.social · 17/12/2024
FACT 3: The point on the British mainland where you are furthest from any National park is a field just north of Towcester (see red star on this map).
Map showing Towcester, with a small red star just off Watling Street to the north of the town
220
Philip Brien @statisticalphil.bsky.social · 17/12/2024
FACT 2: Eryri National Park (Snowdonia, as was) is the only one with a hole in it, because Blaenau Ffestiniog isn't part of the Park.
Map showing the boundaries of Eryri National Park
110
Philip Brien @statisticalphil.bsky.social · 17/12/2024
Here are some National Park Facts (TM), occasioned by my having to look at the boundaries for something for work: FACT 1: The only non-contiguous National Park in Great Britain is Pembrokeshire Coast, which is divided into four main chunks and a few islands.
Map showing boundaries of Pembrokeshire Coast National Park
121
Philip Brien @statisticalphil.bsky.social · 14/10/2024
Quick chart showing just how extraordinary last week's Test was. There have only been six occasions - ever - where a Test side scored as many runs in their first innings as Pakistan did and then went on to lose the match.
Scatter plot showing every time a Test side has scored at least 500 runs in their first innings since 1900. On most occasions, the team scoring this many goes on to win the match; on slightly fewer occasions the match is drawn; in a handful of cases they lose.
010
Philip Brien @statisticalphil.bsky.social · 11/10/2024
In short, this overview is actively unhelpful, because it's not just wrong, but breezily confident in its wrongness. Please don't trust them for anything that even vaguely matters. (5/5)
010
Philip Brien @statisticalphil.bsky.social · 11/10/2024
Issue #3: No, the memorandum is not "a document that provides parliamentary authority". The Estimate itself is part of the process to do that - the memorandum just provides further context but has no authority in its own right. If you based anything important on this you'd look like an idiot. (4/n)
100
Philip Brien @statisticalphil.bsky.social · 11/10/2024
Issue #2: because Google doesn't understand the contents of these documents, it can happily talk about the "Scotland Senedd". This doesn't exist. (It has, of course, conflated the Senedd - that is, the Welsh Parliament - and the Scottish Parliament.) (3/n)
100
Philip Brien @statisticalphil.bsky.social · 11/10/2024
The first and biggest issue: so far as I can tell, the document I'm looking for isn't actually published online. Doesn't stop Google from confidently asserting things about its contents. As annotation #1 shows, it's basing this on memoranda for two totally different departments. (2/n)
100
Philip Brien @statisticalphil.bsky.social · 11/10/2024
Shall we explore together why Google's "AI Overviews" are, um, somewhat less than helpful when you're looking for something specific? 🧵 (1/n)
Screenshot of a Google AI Overview for the search term "scotland office estimates memorandum 2024/25". Described in detail in later posts in the thread.
100
Philip Brien @statisticalphil.bsky.social · 03/10/2024
As best as I can tell, it is literally just showing the website inside an app container. I uninstalled within minutes of trying it out. (Tried replacing it with Ontime, which seems to be working OK for me so far.)
010
Reposted by Philip Brien
Tim Hitchcock @timhitchcock.bsky.social · 02/10/2024
Really pleased to announce the launch of a thoroughly updated version of Locating London's Past: locatinglondon.org - new functionality, better mapping, cleaner data. @ihr.bsky.social @long18thsem.bsky.social @ihrhistorylab.bsky.social
The home page of the Locating London's Past website, including a map illustrating thefts 1674-1819, and a panel on the right with information about the site and links.
3195107
Philip Brien @statisticalphil.bsky.social · 01/10/2024
...and THAT was entirely because Henry VIII was uncomfortable with the idea of having to listen to Parliament talking about Catherine Howard's alleged adultery in the bill that led to her execution. en.wikipedia.org/wiki/Royal_A...
en.wikipedia.org
Royal Assent by Commission Act 1541 - Wikipedia
000
Philip Brien @statisticalphil.bsky.social · 01/10/2024
Related procedural note: the Royal Assent Act repealed the Royal Assent by Commission Act 1541, which first introduced the idea that the monarch didn't have to be there in person to pass an Act of Parliament...
110
Philip Brien @statisticalphil.bsky.social · 01/10/2024
Going through old Commons Journals for something, and this keeps popping up: before the Royal Assent Act 1967, the Commons had to go and physically attend in the Lords for any bill to be passed. As this entry from November 1921 shows, this was often right in the middle of other business.
Screenshot from the Commons Journal. Key part of the text reads:

And a Motion being made, and the Question being proposed, That this House doth agree with the Committee in the said Resolution ;
Royal Assent. A Message was delivered by Lieutenant-General Sir William Pulteney, K.C.B., K.C.M.G., D.S.O., Gentleman Usher of the Black Rod :
Mr. Speaker,
The Lords authorised by virtue of His Majesty's Commission, for declaring His Royal Assent to several Acts agreed upon by both
Houses, desire the immediate attendance of this Honourable House in the House of Peers, to hear the Commission read.
Accordingly Mr. Speaker, with the House, went up to the House of Peers:- And having returned;
120
Philip Brien @statisticalphil.bsky.social · 01/10/2024
RIP to the National Rail app, which has gone from a functional (if slightly clunky) experience to...literally just running the website inside an app container. Why, precisely, would anyone bother?
000
Philip Brien @statisticalphil.bsky.social · 27/09/2024
(We do, of course, have a briefing on this, which we'll likely update in the next few weeks to include the new stats: commonslibrary.parliament.uk/research-bri...)
commonslibrary.parliament.uk
The UK aid budget and support for refugees in the UK in 2022/23
The UK spent £3.7 billion, or 29% of its aid budget, supporting refugees in the UK in 2022. This drew criticism from aid groups. What is the government response?
000
Philip Brien @statisticalphil.bsky.social · 27/09/2024
Two things to note from the FCDO's latest aid stats: 1) In cash terms, the UK's aid budget in 2023 was the largest it's ever been; 2) If spending on refugees within the UK didn't count under OECD rules, aid spending would be below 2013 levels. (Source: FCDO, www.gov.uk/government/c...)
Line chart from 2009 to 2023, showing that UK aid spending went up to about £15 billion in 2019, fell after that, but as of 2023 is higher than ever in cash terms. A second line shows aid spending excluding spending within the UK on refugees - these lines are almost on top of each other for most of the period, but diverge sharply after 2021, and as of 2023 there's a gap of over £4 billion between them.
100
Philip Brien @statisticalphil.bsky.social · 26/09/2024
In an interesting but otherwise fairly unremarkable article about the North Korean women's football team, this sentence just comes out of nowhere. (article for the curious: www.theguardian.com/football/202...)
Screenshot of a paragraph from a Guardian article. Text is as follows:
Then came the great interruption. In 2011 five national‑team players tested positive for a rare steroid. [Highlight begins] The excuse offered was the use of a traditional medicine made from the glands of a musk deer, applied after the players were struck by lightning. [Highlight ends] Oddly enough, Fifa didn’t buy this and North Korea were banned from the 2015 World Cup, lost their ranking position, failed to qualify in 2019 partly as a result, then went into major isolation during the pandemic, re-emerging only towards the end of 2023.
020
Philip Brien @statisticalphil.bsky.social · 12/09/2024
If you had somehow invested in stamps in 1989, that investment would now be worth more than if you had invested in housing across the UK. (Sources: ONS series D7BT, HM Land Registry, priceofastamp.co.uk)
Line chart showing changes in price since January 1989 for houses in the UK, and first and second class stamps, compared to CPI inflation. Houses outpaced stamps until the global financial crisis, when second-class stamps caught up; as of 2023, first-class stamps are also above houses.
001
Philip Brien @statisticalphil.bsky.social · 06/09/2024
Just found this gloriously 90s cover on an old NAO report. I miss when the internet was this fresh and exciting thing. (Report comes from here, for reference: www.nao.org.uk/reports/gove...)
A beautifully 90s-styled cover of a National Audit Office report titled "Government on the Web" from 1999. A globe in the background is drawn in neon blue outlines; in the foreground there is a desktop PC with a chunky CRT monitor and a woman in a business suit with a no-nonsense short haircut, all composited onto each other with airbrushed outlines.
020
Philip Brien @statisticalphil.bsky.social · 27/08/2024
Almost every paragraph of this gets more and more bonkers. Excellent article.
theguardian.com
The cocaine kingpin’s wildest legacy: what can be done with Pablo Escobar’s marauding hippos?
The long read: The Colombian drug lord’s exotic menagerie fell apart after his death, and now wild hippos are breeding out of control
000
Philip Brien @statisticalphil.bsky.social · 14/08/2024
Great example of the counterintuitive nature of inflation stats in this morning's release. The main rate is largely up because of gas prices, but not because they've gone up - they haven't! It's because they haven't gone down as fast as they did a year ago.
Line chart showing changes in energy prices (gas and electricity) since March 2021. Both peaked in the winter of 2022 and have since partly fallen back, but as of July 2024 they remain 68% (gas) and 45% (electricity) above their March 2021 levels.
010
Philip Brien @statisticalphil.bsky.social · 02/08/2024
Shooters go to extreme lengths to stay relaxed. I knew of someone who would nestle into a comfy armchair and practice lifting up mocked-up pistol sights, to mentally associate shooting with relaxation. All of which to say: no surprise that shooters look cool. It literally helps them shoot better!
010
Philip Brien @statisticalphil.bsky.social · 02/08/2024
Hand in the pocket? That's because you want to remove tension in your non-shooting arm, so it has to rest somewhere. Putting it on your belt buckle is also popular.
100
Philip Brien @statisticalphil.bsky.social · 02/08/2024
Same goes for eyewear. Blocking off your non-dominant eye might help your aim, but it might also induce tension in your face. So if you can aim properly with nothing else resting on your face, that's an advantage.
100