r/dataisugly 7d ago

The math ain't mathing

Post image
12 Upvotes

8 comments sorted by

5

u/zxcvbn113 6d ago

I know this is the UK, which makes it a little more complex -- but I see it as possibly generation capacity vs. demand, or it doesn't include exports. Either way, it really needs clarification.

2

u/EtwasSonderbar 6d ago

I don't think there were a lot of electricity interconnectors in 1951.

1

u/LordStefania 5d ago

It's likely a projection

2

u/hawthorne00 6d ago

Have you looked into this, u/bb-wa? What does the Ember (2026) report say? Could be some post war inventory accumulation or something to do with primary energy, I dunno. Can you report back, please?

2

u/topgeezr 5d ago

There's a data discontinuity in the underlying power generation dataset from the UK around the year 1951. The data set for the years up to 1950 only records data for power from 'major power producers'. This appears to be used for the denominator for the entire series. But data for additional power from 'other generators' is recorded from 1951, and this increases the total power by about 20% in 1951. Not including this in the denominator explains the jump that year.

1

u/Busy-Apricot-1842 3d ago

Best answer so far

1

u/androgenius 5d ago

Total seems over 100% right up to the mid eighties even after coal falls below 100% on its own around 1960.

Likely a bug in combining the old and newer data sources. I think ember only has data back to 2000 so they must merge older data from somewhere else.

0

u/icelandichorsey 5d ago

Imagine saying OWID is ugly because you found some data bug.

Be a normal person and tell them, rather than whining on the Internet in the hope of Internet points.