richardj14 / edubase2


Retrieves entirety of Edubase2 database

Every school is identified by a Unique Reference Number (URN). The table ‘edubase2’ contains only this number and is populated by doing a search for all establishments (open/closed/whatever type). The original design had all data in one table, but ScraperWiki’s JSON interface threw a hissy fit. It is now divided up into separate tables, all using the URN as a primary key. This URN relates to other data, e.g. Ofsted, performance tables.

You may find that some places use a “DfE number” or an “LAESTAB”. This is either a 3 digit, 4 digit or 7 digit number, depending what you’re looking at. The 7 digit number is a concatenation of the 3 digit local authority (LA/LEA) number and a 4 digit establishment (ESTAB) number. The 3 digit LA number relates to the LA number in and in theory is being replaced by a GSS number (see that scraper for details). In theory the LAESTAB number is unique, but I suspect there may be some reassigning going on.

Forked from ScraperWiki

Contributors richardj14

Last run failed with status code 1.

Console output of last run

Scraper state is Start (0) Traceback (most recent call last): File "/repo/", line 89, in <module> br.form['changes.townLocalityPostcode.value'] = '' File "/usr/local/lib/python2.7/dist-packages/mechanize/", line 2780, in __setitem__ control = self.find_control(name) File "/usr/local/lib/python2.7/dist-packages/mechanize/", line 3101, in find_control return self._find_control(name, type, kind, id, label, predicate, nr) File "/usr/local/lib/python2.7/dist-packages/mechanize/", line 3185, in _find_control raise ControlNotFoundError("no control matching "+description) mechanize._form.ControlNotFoundError: no control matching name 'changes.townLocalityPostcode.value'


Downloaded 3 times by praveenpgoswami MikeRalphson

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (5 KB) Use the API

rows 1 / 1

value_blob type name


Average successful run time: less than 5 seconds

Total run time: less than 10 seconds

Total cpu time used: less than 5 seconds

Total disk space used: 30 KB


  • Manually ran revision 86a2df94 and failed .
    1 record added in the database
  • Manually ran revision 86a2df94 and completed successfully .
    3 records added, 3 records removed in the database
  • Forked from ScraperWiki

Scraper code


edubase2 /