Difference between revisions of "Users Guide to SOLM-2024 database"
Line 22: | Line 22: | ||
e.g. The dimension of people has the following sub-dimensions, some of which are textual and some of which are numerical | e.g. The dimension of people has the following sub-dimensions, some of which are textual and some of which are numerical | ||
− | ==People== | + | ===People=== |
PEOPLE: BASICS | PEOPLE: BASICS | ||
Line 36: | Line 36: | ||
-- Length of time in current residence [Years; textual comment] | -- Length of time in current residence [Years; textual comment] | ||
− | ==Ships== | + | ===Ships=== |
SHIPS: BASICS | SHIPS: BASICS | ||
Line 65: | Line 65: | ||
- Use of F5 function | - Use of F5 function | ||
− | + | [THIS SECTION IS UNDER DEVELOPMENT] | |
+ | ==Exercises== | ||
− | + | '''1. Using the SOLM-2024 database to analyse trade flows''' | |
+ | - Example: Brazilian/Portuguese/Mediterranean | ||
+ | - Example: Hamburg/Lisbon-Cadiz/Mediterranean | ||
+ | - Example: English East Mediterranean | ||
− | ==Providing feedback | + | '''2. Using the SOLM-2024 database to compare and contrast shipping size and types in different geographies''' |
+ | |||
+ | - Question: Size and character of English East Mediterranean English shipping versus English Atlantic shipping | ||
+ | - Question: Size and character of English Atlantic shipping on Newfoundland versus Virginia versus Barbados routes | ||
+ | |||
+ | '''3. Using the SOLM-2024 database to study the roles, duties, and tasks of different occupations''' | ||
+ | |||
+ | - Question: How did people in specific mariner sub-occupations self-describe their office, places, tasks? | ||
+ | - Question: How did people evaluate the performance of others in specific mariner sub-occupations? | ||
+ | - Question: What can be quantified in terms of skill levels and wage levels for different mariner sub-occupations? | ||
+ | |||
+ | '''4. Using the SOLM-2024 database to study predation by galleys in the Mediterranean and the Atlantic in the 1H C17th''' | ||
+ | |||
+ | - Question: Where do you find galleys and war ships geographically active in seizing commercial shipping in the 1H C17th [Turkish galleys; galleys of Argiers; galleys of Tunis; galleys of Sally; Spanish galleys; French galleys] | ||
+ | |||
+ | '''5. Using the SOLM-2024 database to look at the use by English mariners of international legal jurisdictions''' | ||
+ | |||
+ | - Question: How can we use the data within SOLM-2024 to identify legal cases in non-English legal jurisdictions invollving English commercial shipping? | ||
+ | - Question: How can we systematically examine the strategies used by mariners and factors to access legal systems and arbitration in non-English jurisdictions? | ||
+ | - Question: What was the role of Consuls and Consular assistance outside England and how did mariners interact with Consuls? | ||
+ | |||
+ | ==Providing feedback== | ||
+ | |||
+ | - '''We encourage all our users to provide feedback and to make special requests to us''' | ||
+ | |||
+ | - '''The SOLM-2024 database can improve by being used as much as possible for a wide range of research tasks''' |
Revision as of 10:54, April 9, 2024
This is the start of the Users Guide to the SOLM-2024 database
Contents
Overview of the database
- Technology: Excel Workbook
- Size: 22 MB
- Dimensions: 23,715 rows; 320 columns
- Sheets: One
- Conceptual structure: Flat semi-structured database
- Author: Colin Greenstreet
- Date started: 2017
- Latest version: SOLM-2024 Ver.13.2 08/04/2024
Conceptual structure
- Primary dimension is formed by the personal depositions of people
- Secondary dimension is formed by the named ships with which most of the personal depositions of people are associated
- Each of the primary dimensions is characterized in multiple ways, which can be grouped into sub-categores
e.g. The dimension of people has the following sub-dimensions, some of which are textual and some of which are numerical
People
PEOPLE: BASICS
-- Name [Forname; Surname]
-- Age [Years; Estimated birth year]
PEOPLE: GEOGRAPHY
-- Current residence [Street/Hamlet; Parish; Town; County/Province]
-- Current state [e.g. England; e,g. France]
PEOPLE: GEOGRAPHY ADVANCED
-- Place of birth [Parish; county; Province; State]
-- Length of time in current residence [Years; textual comment]
Ships
SHIPS: BASICS
-- Name of ship
-- Place of affiliation of ship [e.g. the Seaventure of Yarmouth]
-- Name of master of ship
SHIPS: VOYAGES
-- Extent of voyage knowledge [None; Partal; Full]
-- Voyage nodes [Named nodes in route order, if known]
SHIPS: PHYSICAL
-- Shp burthen [Tons]
-- Ship company size [including master and boys] [Number]
-- Ship ordnance [Guns]
SHIPS: PEOPLE
-- Name of master of ship
-- Ship company size [including master and boys] [Number]
Sorting the database
- Use of filters
- Use of sort buttons
- Use of F5 function
[THIS SECTION IS UNDER DEVELOPMENT]
Exercises
1. Using the SOLM-2024 database to analyse trade flows
- Example: Brazilian/Portuguese/Mediterranean
- Example: Hamburg/Lisbon-Cadiz/Mediterranean
- Example: English East Mediterranean
2. Using the SOLM-2024 database to compare and contrast shipping size and types in different geographies
- Question: Size and character of English East Mediterranean English shipping versus English Atlantic shipping
- Question: Size and character of English Atlantic shipping on Newfoundland versus Virginia versus Barbados routes
3. Using the SOLM-2024 database to study the roles, duties, and tasks of different occupations
- Question: How did people in specific mariner sub-occupations self-describe their office, places, tasks?
- Question: How did people evaluate the performance of others in specific mariner sub-occupations?
- Question: What can be quantified in terms of skill levels and wage levels for different mariner sub-occupations?
4. Using the SOLM-2024 database to study predation by galleys in the Mediterranean and the Atlantic in the 1H C17th
- Question: Where do you find galleys and war ships geographically active in seizing commercial shipping in the 1H C17th [Turkish galleys; galleys of Argiers; galleys of Tunis; galleys of Sally; Spanish galleys; French galleys]
5. Using the SOLM-2024 database to look at the use by English mariners of international legal jurisdictions
- Question: How can we use the data within SOLM-2024 to identify legal cases in non-English legal jurisdictions invollving English commercial shipping?
- Question: How can we systematically examine the strategies used by mariners and factors to access legal systems and arbitration in non-English jurisdictions?
- Question: What was the role of Consuls and Consular assistance outside England and how did mariners interact with Consuls?
Providing feedback
- We encourage all our users to provide feedback and to make special requests to us
- The SOLM-2024 database can improve by being used as much as possible for a wide range of research tasks