README FILE FOR the Dominy Watch Repair Watchmaker Data Set http://digital.library.wisc.edu/1793/75793 Prepared February 22, 2017 Data set is the research of: Charles F. Hummel Curator Emeritus Adjunct Professor, Academic Programs Winterthur Museum, Garden and Library Winterthur, DE 19735 chummel@winterthur.org or robbieriis@comcast.net README compiled by: Jesse Henderson Digital Services Librarian University of Wisconsin Digital Collections University of Wisconsin-Madison 728 State Street Madison, WI 53706 jesse.henderson@wisc.edu with support from: Cameron Cook Digital Curation Resident Librarian University of Wisconsin-Madison 728 State Street Madison, WI 53706 cccook3@wisc.edu Data transcribed by: Andrea Palmentier Graduate Student at the University of Wisconsin-Madison School of Library and Information Studies edited and reviewed by: Jesse Henderson Charlie Hummel Peter Gorman Assistant Director for Digital Library and Preservation Strategy University of Wisconsin-Madison General Library System 728 State Street Madison, WI 53706 peter.gorman@wisc.edu Scope: This dataset describes a number of watchmakers researched by Charles Hummel over the course of 14 years. These watchmakers were active between the years 1767 and 1841-42. This data was derived from the repair logs from Nathaniel Dominy IV and Felix Dominy’s shops where over 2000 watches were repaired. These logs can be found here at this address: http://digital.library.wisc.edu/1711.dl/Dominy. In addition to these logs, Mr. Hummel consulted existing printed book and periodical literature cited in this dataset; conducted research at the Goldsmith's Company, London; conducted research at the libraries of the American Clock and Watch Museum, Bristol, CT and National Association of Watch and Clock Collectors, Columbia , PA. File list: This dataset includes the following tables in .csv files as well as a single .xlsx file which contains the entire dataset as a flat file. ./Watchmakers.csv ./Citations.csv ./OwnerNotations.csv ./Citations_to_Watchmakers.csv ./DominyWatchRepairDataSet_Full.xlsx Each entry for each table (.csv files) has a primary key field (noted with _pkID in the field name) and where it is linked in another table there is a foreign key field (noted with a _fkID in the field name). Fields: The aforementioned tables include the following fields, value type is given in brackets following the field name. Watchmakers: Watchmaker_pkID [Number] Nationality [Text] Lastname [Text] Firstname [Text] Altname [Text] Lastname_additional [Text] Firstname_additional [Text] Altname_additional [Text] AuthorsNotes [Text] TranscribersNotes [Text] CountWatches [Number] Citations: Citation_pkID [Number] Citation [Text] OwnerNotations: OwnerNotation_pkID [Number] Watchmaker_fkID [Number] Notation [Text] WatchSerialNumber [Text] Citations_To_Watchmakers: CitationsToWatchmakers_pkID [Number] Watchmaker_fkID [Number] Citation_fkID [Number] DominyWatchRepairDataSet_Full.xlsx Nationality [Text] Lastname [Text] Firstname [Text] Altname [Text] Lastname_additional [Text] Firstname_additional [Text] Altname_additional [Text] AuthorsNotes [Text] OwnerNotation [Text] WatchSerialNumber [Text] WorksCited [Text] TranscribersNotes [Text] Relationships for .csv files: Watchmaker_pkID in the Watchmakers table corresponds to the Watchmaker_fkID in the OwnerNotation table. This is a one to many relationship (one Watchmaker record may have many Owner Notations). Watchmakers connects to Citations via the Citations_To_Watchmakers table and the foreign keys used in that table. This is a many to many relationship (one Watchmaker record may have many Citations connected to it, and one Citation record may be connected to many Watchmaker records). Description of Fields and Records: Each Watchmaker record has name and nationality, although nationality is noted as ‘Unknown’ in 459 of the records. There may also be birth and death dates in the description. At times there may be an alternate name or an additional name documented for a Watchmaker. The additional name may also have a nationality. Watchmaker records may include a description field which have been transcribed from the notes of Mr. Hummel. Additionally, about 3/4 of the Watchmakers have one Owner Notation record connected to it; the other 1/4 of the records have 2 or more Owner Notations connected to them. Owner notations contain information about owner(s) of a watch, and often the serial number of a watch. The serial number field contains number, letters and other symbols. In a handful of cases there are two serial numbers recorded for one owner. When there was no serial number, the owner notation usually indicates that and the Serial number field is blank. Process: Mr. Hummel’s 347 pages of handwritten research were organized by nationality and listed watchmakers names alphabetically. Mr. Hummel entered books and periodical articles on index cards in preparation of a bibliography. A separate entry sheet was prepared for each watchmaker listed by Nathaniel IV and Felix. On each sheet he entered the name of the owner and the date that it came into their shop for repair. This research took place over 14 years, and Mr. Hummel worked part-time on the project. At University of Wisconsin-Madison Digital Collections Center, the data was transcribed by a UW-Madison SLIS student during the summer of 2016 into a relational FileMaker Pro database. After transcription and edits, there resulted in 1080 Watchmakers documented. Author's Notes: Where “c. c.” or “cc” has been used in the descriptions indicates a watchmaker was a member of the Clockmaker’s Company. Transcription of the Data: Entries in the manuscript had a main entry for a name, sometimes information on alternate names, and notations regarding biography, owners of watches by each maker, if there were any. We divided the information contained in these notations into separate fields, those being: Watchmakers::AuthorsNotes, OwnerNotations::Notation, OwnerNotations::WatchSerialNumber. Additionally we pulled out references to authors’ cited works and linked those via the Citations_to_Watchmakers table. Mr. Hummel provided a list of sources cited and within his notes he often referred to these sources by last name or two-letter initials. In transcribing this dataset we put all publications by the same author into one Citation record and linked that record to the Watchmaker record where it was cited. The one author exception to this is Baillie, G. H. due to the way Mr. Hummel cited this author, we could differentiate between his two publications Mr. Hummel used for research. Diacritics have been removed from the citations table. Names, descriptions and owner’s notations were transcribed to the best of the transcribers’ abilities. All punctuation from the descriptions was transcribed as written in the author’s manuscript of data. In some places a superior letter was used by the author in the manuscript. How it was written by the author has been recorded in the transcriber notes field, or directly in the description or owner notation. Copyright and Licensing Information: This work is licensed under a Creative Commons Attribution 3.0 United States License. https://creativecommons.org/licenses/by/3.0/us/. Limitations of the data: The .xlsx file is the full set of data, with no primary or foreign keys included. The .csv files are most easily searched if ingested into a relational database software, such as FileMaker Pro or Microsoft Access, with the relationships then linked as outlined in this file. Exhaustivity of the data: Future sales of watches or individual articles may identify some of the unknown watchmakers. Any foreign books and articles about watch and clockmakers not translated into English were not consulted for this dataset.