Giovanni d'Andrea - Mapping Law in Medieval Spain Project

Giovanni d'Andrea - Mapping Law in Medieval Spain - DH at HMML

Giovanni d'Andrea


Goal Demonstrate the use of the HMML Data Portal for creating digital humanities projects based on metadata found in HMML Reading Room. The pilot project records were derived from microfilm projects completed in Spain during the 1970s and include selected manuscripts to demonstrate how basic Geocharting can be used to visualize the location of and size of current collections.

Timeframe 2018

People Project developed by HMML staff, including Dr. Daniel K. Gullo, Joseph S. Micallef Director of the Malta Study Center; and Eileen L. Smith, Metadata Librarian

Partners Malta Study Center


Used the HMML Data Portal to create two visualization of the Giovanni d'Andrea's manuscripts: a catalog to provide easy access to HMML Reading Room and a map to view locations of these manuscripts in their current libraries. JSON data was first converted into a CSV file using Konbert and then imported into Google Sheets. Then, using Awesome Table it was rendered on a page using JavaScript.

Andrea JSON
Andrea Google

The data used to create the map was harvested and converted using the same procedures. However, unlike the manuscript catalog database, data for longitude and latitude had to be manually entered in order to Geochart the collection using the JAVA script tool in Awesome Table. This data also required the use of an array to properly select a color code for each library, which too involved manual input of the code.

Andrea Map

With the data prepared for Awesome Table, the file was exported from Google Sheets as a .CSV and imported into With Datawrapper, some custom HTML style codes were added within the application to stylize the format.

Andrea DataWrapper


  • 1


    Metadata was corrected and prepared by Gullo. From the corrected records, Smith prepared the authority files for authors and titles for importing into HMML Reading Room.

  • 2

    Import of metadata

    Metadata was imported into HMML Reading Room and checked for errors.

  • 3

    Curated search in HMML Data Portal

    Each archive was searched by country of origin and name. The full metadata was exported in JSON. This initial dataset became the master dataset for both the catalog and the map.

  • 4

    Konbert conversion of JSON and upload into Google Sheets

    Used Konbert to convert the JSON into .CSV files, selected only those fields from the schema needed for the project. These .CSV files were then uploaded into two Google Sheets, with the map Google Sheet having manual location data added.

  • 5

    Modify Google Sheets and Link to Awesome Table

    Using Awesome Table two projects were created: one as a catalog, and the other as a timeline. Parameters were set within the application and copied to the final website as iframe JavaScript.

  • 6

    Data Imported into Datawrapper

    Using the data prepared for Awesome Tables, a file was downloaded from Google Sheets as .CSV and imported into Data was organized and modified to fit the application and custom HTML was used to stylize the tooltips.