the US vs the UK: is population comparable? (edited to fix a unit)
Is headcount seasonally adjusted here?
The
reporting_entity field shows that about 15% of rows have changed their entity code between the first and second half of the year, which is unusual. If the same location can report under different codes, that creates a matching problem in the time series. Should we standardize the entity codes, or should we note the instability?Am I reading the gridlines wrong? Brazil seems inverted to me.
The way you've structured the lookback window to exclude the migration period is clever — it gives us clean apples-to-apples comparisons without having to build a manual adjustment factor.
What is the refresh cadence on this?