Education Term Codes Database

We have created a database of school term dates for schools in England which builds on the Edubase open data released in 2014 and links it to transport data. The database is in final review and will soon be available under an Open Government License and without charge to download from this page in csv format.

The data that we are supplied with to build the Traveline National Dataset (TNDS) each week doesn’t always have school dates in but instead shows school services as footnotes typically with the codes Sch or Nsch.

This new database will not only be an important reference for those creating the timetable and route data at source but it will also be a useful tool for developers using the TNDS to determine the dates of operation of bus journeys. It will also have many applications outside of transport.

This work has been supported by the Cabinet Office through The Open Data User Group Data Release Fund.

The funding limited this first piece of work to English schools but we hope to be able to work with our colleagues in Scotland and Wales to extend the database