Thanks to James and to the others who have already replied – I’d downloaded EduBase data but, as you mention, I’d got stuck where I needed
U codes/historic D codes as well.
I’ve followed up on one of the replies I received which pointed me to Tim Hall at UCAS. UCAS provide to members, via their website, a
list of institutions with UCAS code, DfE code, School name, school type, status and postcode. There is also a non-members version of this file, but
it does not contain all the schools on their system, just those that do not have a DFES code. It also doesn’t have the Status or Type fields.
You can find both files here:
http://www.ucas.com/he_staff/hesareturn/ucasdata/ (right at the bottom of the page)
or contact Tim for more information.
Best wishes,
Elaine
From: Academic, financial or space planning in UK universities [mailto:[log in to unmask]]
On Behalf Of James McLaren
Sent: 25 April 2013 11:54
To: [log in to unmask]
Subject: Re: Previous Institutions - consistent set of data
Hi all,
Just wanted to check you were aware of the EDUBASE public portal which enables you to drill down to the details on any of the current ‘D’ codes from the PREVINST field. This can be found here:
http://www.education.gov.uk/edubase/home.xhtml
There is only basic information on this page but you can subscribe for free and get a much richer source of data.
Unfortunately, this is only available for current ‘D’ codes so historic ‘D’ codes or any ‘U’ codes will still require a more google based approach.
Hope that proves useful!
James
James McLaren
Information Services Manager
Higher Education Statistics Agency (HESA)
95 Promenade, Cheltenham, Gloucestershire GL50 1HZ
T 01242 211164 F 01242 211122 W www.hesa.ac.uk
From: Academic, financial or space planning
in UK universities [mailto:[log in to unmask]]
On Behalf Of Gary Colin Tindell
Sent: 25 April 2013 11:41
To: [log in to unmask]
Subject: Re: Previous Institutions - consistent set of data
Hi Elaine,
I’m struggling with this very issue currently. There isn’t a quick way of doing this unfortunately. We’ve recently purchased a large dataset from HESA with previous institution and
what we’ve done is to concentrate on this institutions for which data relates to. In this case, we’re looking only at London-domiciled students and it’s reduced the list from 18k to almost 7k. To obtain the correct institution name, we’ve separated the code
and mapped it against a reference table extracted from a DfES file, which contains the correct name but also classifies the institution in terms of FE college, 6th form college, community school, etc. This has probably reduced the 7k by more than
a half and the rest entails endless Google searches! The issue is that the advent of academies means that a large number of institutions have recently changed their name, some of which bear no relation to the name of the previous institution!!
Hope this helps
Regards
Gary
Gary Tindell
Information Improvement Manager
University of East London
IT Services
Docklands Campus
University Way
London
E16 2RD
Tel: 0208 223 2065
Email:
[log in to unmask]
From: Academic, financial or space planning
in UK universities [mailto:[log in to unmask]]
On Behalf Of Mallion E.L.
Sent: 25 April 2013 10:14
To: [log in to unmask]
Subject: Previous Institutions - consistent set of data
Dear All,
Do you know of anyone within your organisation who has successfully come up with a consistent list of previous institution data that they’d be happy to share?
I’ve spent several days on this but am struggling to come up with a way without manually trawling through around 19,000 records!
You’ll see the problem if I highlight a small subset, showing the PREVINST code as held by HESA and the provided establishment name;
D3306092 |
Abbey College (this one’s in Birmingham) |
D2136048 |
Abbey College (this one’s the same as Abbey College, London) |
D8856026 |
Abbey College (this one and the next are in Worcestershire) |
D9186103 |
Abbey College |
D8736049 |
Abbey College Cambridge (this is the same as U16664 but was supplied without the comma) |
D3526044 |
Abbey College |
U16664 |
Abbey College, Cambridge |
U11733 |
Abbey College, London |
U15779 |
Abbey College, Malvern |
U16307 |
Abbey College, Manchester |
U11214 |
Abbey College, Ramsey |
D8734603 |
Abbey College, Ramsey |
U89420 |
Abbey Community College, Co Roscommon
|
U89146 |
Abbey Community College, Waterford
|
U89213 |
Abbey Community College, Wicklow
|
D9066018 |
Abbey Gate College |
U10291 |
Abbey Gate College |
D8756060 |
Abbey Gate College (this one and the one below are the same place but have different D codes) |
D8966018 |
Abbey Gate College |
I’d like to be able to have a list that has a consistent establishment name or some way of identifying each establishment uniquely, to identify where our students come from.
With best wishes,
Elaine Mallion
Planning & Performance Reporting Analyst
Working hours: Tuesdays, Wednesdays + Thursday mornings
Strategy & Planning
Room 4007, George Thomas Building
University of Southampton
Highfield
Southampton
SO17 1BJ
Tel: 023 8059 4751 (internal ext. 24751)
Email: [log in to unmask]
This message has been scanned by the UEL anti-spam filters hosted by
Websense
Report this email as spam.
Try our free UK HE Stats iPhone app - http://www.hesa.ac.uk/iapp1
No iPhone? Use our mobile website - http://m.hesa.ac.uk/
Higher Education Statistics Agency Ltd (HESA) is a company limited by guarantee, registered in England at 95 Promenade Cheltenham GL50 1HZ. Registered No. 2766993. The members are Universities UK and GuildHE. Registered Charity No. 1039709. Certified to
ISO 9001 and ISO 27001.
HESA Services Ltd (HSL) is a wholly owned subsidiary of HESA, registered in England at the same address. Registered No. 3109219.
This email is private and confidential. If you have reason to believe that you have received this message in error, please contact the sender immediately and remove it from your system.
No employee or agent is authorised to conclude any agreement binding on HESA/HSL without express written confirmation by the Chief Executive or an employee of HESA/HSL with director in their title.