Welcome to the MEDIATE Sandbox database. In this database, you will find data that has been extracted and enriched from a corpus of several hundred catalogues of privately-owned libraries mostly sold at auction in the Dutch Republic, France, British Isles and Italy between 1665 and 1830. The Sandbox focuses on collections numbering 1,000 or fewer books – with exceptions made for catalogues dating from before 1700, or published in Italy. In total, the Sandbox thus includes data from 600 individual, private collections, which together list over half a million individual books.
For a short overview of the MEDIATE project aims, see the project website, here.
You can read more about the database content, as well as some preliminary findings, here.
Other MEDIATE project publications can be found on the project website, here.
The MEDIATE database is currently under construction, and will remain so for some time. This is therefore a dynamic database, which is continually being updated and expanded. Records may contain errors, and data may change over time as it is further enriched and cleaned up. Our aim has not been to provide perfect transcriptions of every word in the catalogues, but to render the data extracted from the catalogues statistically manipulable. Since most catalogue transcriptions have been produced using OCR (optical character recognition) software, with some manual post-correction, a number of common OCR mistakes remain: long ‘s’ transcribed as ‘f’, ‘e’ transcribed as ‘c’, ‘a’ as ‘o’, ‘i’ as ‘t’, ‘l’ as ‘1’, etc.
The process of matching book items to VIAF Authors, Works, and adding language and subject information (Parisian bookseller categories, as determined by ourselves, in addition to subject categories used in the catalogues themselves) is ongoing, and is far from complete. For an overview of the matching and identification work that has been carried out so far, please consult the Database totals page.
For more about the database development process, see here.
If referring to data from this database, please use the following citation form:
Alicia C. Montoya, Micha Hulsbosch, Helwi Blom, Evelien Chayes, Anna de Wilde, Rindert Jagersma, Juliette Reboul, and Joanna Rozendaal, MEDIATE database, 2022 – (ongoing), https://mediate-database.cls.ru.nl/ [date accessed].
The MEDIATE Sandbox dataset is made up of 600 collections. A collection comprises, in theory, all the books owned by a specific library owner over the course of their life – although in practice, the MEDIATE database currently only records items listed in printed catalogues of collections drawn up during or after the owner’s life. A number of catalogues used in creating the database describe more than one collection. Conversely, some collections are spread out over multiple catalogues.
The Sandbox additionally contains 10 Italian collections, dating from 1729 to 1825, and 44 collections owned at least in part by a female collector: 22 French collections, 13 collections from the Dutch Republic, and 9 British collections.
The MEDIATE Sandbox database distinguishes five main fields, displayed on the menu at the top of each page: Persons, Places, Collections, Catalogues, Items, and Works. These fields reflect a basic hierarchy: a Person (role: owner) in a specific Place and time owned a Collection, recorded in one or more sale or auction Catalogues typically drawn up after that Person’s death. Each of these Collections contains a number of book and non-book Items. Each book Item can in turn be linked to a specific VIAF Work, of which the Item is one specific copy.
There are many ways in which you can query the MEDIATE database. Here are some examples:
To view the frequency of books by a specific author, go to Item in the header and use the filter form, above left, to establish the parameters for your query, for example ‘all books by Ovid that appear in French collections recorded in catalogues between 1750 and 1770’. You may then click on ‘Map’ in the right-hand corner to display a map showing the places of publication of these books.
To rank the occurrence of books by a specific author, go to Person in the header, click on ‘Rank by item count’, and use the filter form, above left, to establish the parameters for your query, for example ‘illustrators that appear most frequently in British collections recorded in catalogues between 1690 and 1720’.
To rank the occurrence of specific Works, go to Work in the header, click on ‘Rank by item count’, and use the filter form, above left, to establish the parameters for your query. Please do be warned, however, that given the very low rate of Item-Work matching at present (less than 20%) the ranking displayed will be very incomplete, and is to be used with caution.
To gain an overview of the contents of Collections belonging to specific (groups of) collectors, go to Collection in the header and use the filter form, above left, to establish the parameters for your query, for example ‘Collections belonging to French women collectors’ or ‘Collections belonging to Catholic collectors with catalogues dating from 1800 to 1830’. You can then click on ‘Statistics’ in the right-hand corner to call up pie charts displaying the distribution in these Collections of books by place of publication, subject category (Parisian booksellers categories), format, language, and author gender.