Sinclair Library

The data

Everything this site holds, as one file. It is a MySQL dump of 52 tables covering 44,215 entries, the people and companies who made them, and every magazine that covered them.

No dump has been built on this instance yet. Run php artisan zx:dump.

Using it

gunzip -c zx-catalogue.sql.gz | mysql -u root your_database

The licence

This catalogue is derived from ZXDB and goes out under the Open Database License, the same licence it arrived under. You can copy it, change it and build things on it. If you publish something made from it, you have to credit ZXDB and share your version of the database under ODbL too.

The file exists because the licence says it must: section 4.6 requires the whole derived database, machine-readable and free of charge, to anyone who receives a page built from it. There is no account and no rate limit, because section 4.7 forbids putting anything in the way of the rights the licence grants.

What is not in it

The dump carries a revisions table recording every change to every field, which is how you tell this site's corrections from ZXDB's own data. It records what changed and when, but not who did it. Accounts, sessions and anything else belonging to this site rather than to the catalogue are not in the file at all.