In Sheffield just 1.4% of homes approved by planners met the government’s affordable definition, while in Nottingham the figure was 3.8%, a Guardian Cities investigation has shown