Information is available on numbers of households rather than people. The number of households registered on local authority housing waiting lists in each local authority, as at 1 April each year from 1997 to 2008, is published on the Communities and Local Government website in Table 600. The link for this table is as follows:
http://www.communities.gov.uk/documents/housing/xls/table600.xls