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
Start End Format Description
ID 1 4 A4 Ship/logbook identifier
ShipName
5 34 A30 Name of the ship
LogbookIdent
35 64 A30 Identification code of the original ships’ logbook
Duplicate
65 65 A1 Code, indicating whether the logbook was the original or a duplicate/extract; 0=original, 1=1st duplicate, 2=2nd duplicate, etc..