The Clearing vacancies won't be released until A-level results day on the 16th August, but you can do a UCAS course search to give you an idea of what's available, then check whether they were in Extra this year (they will have an x next to them) and whether they were in Clearing last year (there's a thread in this subforum somewhere, probably sticked) to see how likely it is that they still have places.
You can do a social sciences foundation year. Have a run through the university list in UCAS to see which had Extra vacancies as presumably there might still be places in clearing. Since its social science and its Durham, they might have been much harsher towards you than perhaps a lot of universities wont be, so match your grades with the range that most universities ask for to see if there are ways you could get in.
Impossible to say what the grade requirements (I think that's what you mean) might be without knowing which course and which uni we are talking about. What subjects and grades have you actually got?