Ships' logbook identifications

This table is used to identify the source of the observation. On ship voyages there were generally more than one logbook kept by the captain and the officers. In some occasions it seemed appropriate to show both entries as a separate observation, especially where they seemed to be complementary. In other cases abstract (or extract) logbooks were made from the original ones. We decided to keep the abstract and the originals in the database for further study.

Table name: ShipLogbookID

Field name


ShipName Name of the ship
LogbookIdent Identification code of the original ships’ logbook
Duplicate Code, indicating whether the logbook was the original or a duplicate/extract; 0=original, 1=1st duplicate, 2=2nd duplicate, etc..