Complete University Guide fields in every export
The ranking record covers the university name, the table it appears in - overall or a named subject - the edition year, the rank, and the component scores as published such as entry standards, satisfaction, research quality and graduate prospects.
Edition year is mandatory on every row. Without it a ranking dataset cannot be compared across time without quietly assuming the methodology never changed, which is the single most common error made with league table data.
Subject is a first class field rather than a table name embedded in a label, because subject level movement is usually the interesting part and it is invisible when subject tables are merged into one sheet.
Component scores are kept separate from the rank. The rank is the output; the components are what moved, and an analysis that only has the rank cannot say why anything changed.
Every row carries the collection timestamp and the source address, so any figure traces back to the table that produced it.