University ranking fields in every export
The ranking record covers ranking family, edition year, institution name, country, overall rank as published including banded ranks, overall score, and each pillar score the methodology reports.
Banded ranks need explicit handling and most naive collectors get this wrong. Beyond a certain position, institutions are published in bands rather than as single numbers, and storing a band as a single integer invents precision that does not exist. We keep the band as published alongside a numeric lower and upper bound, so any chart drawn from it can be honest about the uncertainty.
Institution identity is normalised across families and years. The same university appears with different name renderings between tables and over time, and without normalisation a trend line breaks silently in the year a name was rendered differently. We resolve them to one identifier and keep every surface form.
Profile fields are joined where published: country, student numbers, staff to student ratio, international student proportion and subject areas.
Change fields are computed rather than left to the client: position change against the previous edition, score change per pillar, and entry or exit from the table. Every row carries the edition year and the collection timestamp.