A extract from EduBase by Department for Education was taken on Nov-14.
The IPv6 scores was based on the IPv6 health check by Mythic Beasts.
Domain registration look up was performed by using WHOIS tool by Nominet.
- Microsoft Excel
- Microsoft SQL Server
- PowerShell
- Visual Studio (C#)
| Column | Type | Data Source |
|---|---|---|
| School_ID | integer | Script |
| LaNumber | integer | EduBase |
| EstablishmentNumber | integer | EduBase |
| LA | string | EduBase |
| Establishment | string | EduBase |
| WebSiteAddress | string | EduBase |
| TypeOfEstablishment | string | EduBase |
| PhaseOfEducation | string | EduBase |
| OfstedSpecialMeasures | string | EduBase |
| InvestorInPeople | string | EduBase |
| NumberOfPupils | integer | EduBase |
| ReligiousCharacter | string | EduBase |
| Gender | string | EduBase |
| Boarders | string | EduBase |
| Size | integer | HTML request |
| GoogleAnalytics | boolean | HTML request |
| IE6Support | boolean | HTML request |
| DomainName | string | EduBase |
| RegisteredOwner | string | Nominet |
| RegisteredOwnerType | string | Nominet |
| Registrar | string | Nominet |
| GoldenRegistrar | boolean | Script |
| RegistrarSchoolCount | integer | Nominet |
| CMS | string | HTML request |
| HTMLtype | string | HTML request |
| IPv6Score | integer | Mythic Beasts IPv6 Health checker |
| UKDomain | boolean | Script |
| PostCode | string | EduBase |
| Easting | integer | EduBase |
| Northing | integer | EduBase |
| HeadName | string | EduBase |
Surrogate key.
3 digit Local Authority number.
4 digit Establishment (school) number.
Local Authority name.
Establishment (school) name.
Establishment (school) website url (including protocol).
Notes: Minor data cleansing
Type of Establishment (Community School\Academy Converter\etc)
Establishment (school) Phase of Education (Primary \ Secondary)
Has Ofsted put the establishment (school) in Special Measures
Is the establishment (school) commited to Investor In People
Number of Pupils enrol at the establishment (school)
Religious Character
What gender does the establishment (school) accept onroll (boys\girls only or mixed)
Does the establishment (school) accept boarders who live onsite
Disc size of raw HTML code for Establishment (school) website homepage in bytes.
If the raw HTML code for Establishment (school) website homepage contains the Google Analytics javascript.
If the raw HTML code for Establishment (school) website homepage appears to contains a specific Internet Explorer 6.0 workaround.
Establishment (school) domain based on the website address.
The registered owner of the domain.
Notes: Only .UK domains.
The Nominet defined domain owner type - UK School \ UK Individual \ etc.
Notes: Only .UK domains.
The registrar who the establishment (school) has registered the domain via.
Notes: Only .UK domains.
If the registrar has 100% success rate at correctly registering all domains. The registered owner type must be UK School.
Notes: Only .UK domains.
The number of schools the registrator has registered (in this extract).
Notes: Only .UK domains.
Uses the meta tag generator from the raw HTML code for Establishment (school) website homepage to determine the CMS used (if any).
Uses the HTML type from the raw HTML code for Establishment (school) website homepage.
Uses the Mythic Beasts IPv6 Health checker scoring out of 9.
If the establishment (school) website is a .UK domain.
Establishment (school) post code.
Establishment (school) easting.
Establishment (school) northing.
Establishment (school) HeadTeacher name.
Notes: concatenate from Head's title, first letter of the forename and surname.