Working with the Voyages database

The American Offshore Whaling Voyages database uses the same interactive viewer as the other databases. Start with: The Data Interface.  Then come back here for tips and techniques for exploring the Voyages data.

Voyage details

Click on any row to display voyage details below the data table. This will display all columns of data for that one voyage in three blocks on a single page, making it easy to print, save or take a screenshot.

Crew list links

If a voyage has information in the Crew list database, it will have an entry in the “Crew list” column. Click on the row and a link to the Crew list database will display in the Voyage detail. (Search tip: to search for all voyages that have crew list information, search the Crew list column for “AV”.)

Voyage maps

If a voyage has track information in the Logbook (AOWL) database, it will have an entry in the “Log data” column. Click on the row—a link to the voyage map will display in the Voyage detail. (Search tip: to search for all voyages that have voyage maps, search the Log data column for “AV”.)

Limit to one row per voyage

When a voyage had more than one master, the Voyages database will have one row for each. The voyage and vessel information will be identical, but the master information will be different for each row.  The “Order” column indicates whether a row is the first, second, etc. row for the voyage. The master “Fate” column contains a code to indicate what happened to each master (see Column Definitions for details.)

Limit to one row per voyage. (Click to enlarge.)

When you are trying to find an exact count of voyages (for instance, how many whaling voyages sailed from Fall River?) the extra rows for multiple masters interfere with your count. Use the “Limit to one row per voyage” check box to hide the extra rows and only show the first row for each voyage. Then the count shown above the datatable will be the correct count of voyages matching your search (“Showing x to y of 66 entries“).

Show/Hide columns

Many of the available data columns are not displayed in the data viewer by default, although they will all appear in the voyage detail blocks below when you select a single voyage row. To make different columns appear in the data viewer, use the Show/Hide columns button to toggle columns on and off. Click outside the Show/Hide box to return to the data viewer.

Selecting voyage rows for printing, copying and exporting data

Selecting voyage rows. (Click to enlarge.)

Click on a voyage row in the data viewer to select it. Its background will turn blue to indicate that it is selected. Shift-click on another row and all the intervening rows will also be selected. This makes it easy to select, for instance, all of the voyages of a single vessel.

Or, search in one or more columns. Then use the “Select all search results” button. For instance, if you wanted information about whaling masters who sailed from Bristol, RI, search for “Bristol, RI” in the Port column, then click on “Select all search results” to select the 97 voyage rows.

Once you have selected a set of rows, you can use the Print, Copy and Export buttons. The data columns that are showing in the data viewer are the data columns that will be printed, copied to your Clipboard or exported, so you can use the Show/Hide button to limit the data to just the columns you want.