Difference between revisions of "Users Guide to SOLM-2024 database"

From MarineLives
Jump to: navigation, search
m (Scoping of the textual and numerical resources in the database)
Line 232: Line 232:
 
[[File:SOLM-2024 SEMINAR DATABASE Ver.14.1 13042024 NUMERICAL ONE.JPG]]
 
[[File:SOLM-2024 SEMINAR DATABASE Ver.14.1 13042024 NUMERICAL ONE.JPG]]
  
[[File:SOLM-2024 SEMINAR DATABASE Ver.14.1 13042024 NUMERICAL TWO.JPG]]
+
[[File:SOLM-2024 SEMINAR DATABASE Ver.14.1 13042024 NUMERICAL TWO B.JPG]]
  
 
[[File:SOLM-2024 SEMINAR DATABASE Ver.14.1 13042024 NUMERICAL THREE.JPG]]
 
[[File:SOLM-2024 SEMINAR DATABASE Ver.14.1 13042024 NUMERICAL THREE.JPG]]

Revision as of 10:26, April 12, 2024

This is the start of the Users Guide to the SOLM-2024 database

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


- The primary dimension is formed by the personal depositions of PEOPLE

- There are six secondary dimensions, of which the SHIP secondary dimension is the dominant one. This is formed by the named ships with which most of the personal depositions of people are associated.

- The five additional secondary dimensions are MATERIALS; INFORMATION; FINANCING; LABOUR; and LEGAL

- The primary and secondary dimensions have sub-groupings of related characteristics, which are descibed belowd


People


PEOPLE: BASIC
-- Name [Forname; Surname] [TEXT]
-- Age [Years; Estimated birth year] [NUMBER]
-- Gender [Male/Female] [TAB]
-- Marital status [Bachelor; Spinster; Married; Widowed] [TAB; TEXT]
-- Relationships with other people [Father/Son/Daughter; Husband/Wife; Uncle/Nephew; Cousins] [TEXT]
-- Age married [NUMBER]
-- Religion [TEXT]

PEOPLE: GEOGRAPHY
-- Current residence [Street/Hamlet; Parish; Town; County/Province] [TEXT]
-- Current state [e.g. England; e.g. France] [TEXT]

PEOPLE: GEOGRAPHY ADVANCED
-- Place of birth [Parish; County; Province; State] [TEXT]
-- Length of time in current residence [NUMBER; TEXT]
-- Approximate age when moved to current residential area [YEARS]

PEOPLE: IN PLACE
-- Activities at the Exchange, London; Exchanges outside London overseas [TEXT]
-- Activities at Customs houses [London; Boulogne; Saphia; Scanderoon; Cyprus; Messina; Barbados; elsewhere] [TEXT]
-- Activities at taverns, inns and victualling houses, cook shops [TEXT]
-- Activities at private homes [TEXT]
-- Activities at warehouses; cellars [TEXT]
-- Activities at wharves and keys [TEXT]
-- Activities at shops [TEXT]
-- Activities in prisons [TEXT]

PEOPLE: OCCUPATION
-- Main self-described occupation [TEXT]
-- Further more detailed self-described occupations [TEXT]
-- Additional work related activities described in text [TEXT]
-- Detailed self-described occupations normalized [TAB]
-- Years in occupation [NUMBER]
-- Age started occupation [NUMBER]

PEOPLE: OCCUPATION: APPRENTICES AND SERVANTS
-- Apprenticeship/Servant status [TAB]
-- Age became apprentice [NUMBER]
-- Years as apprentice [NUMBER]
-- Age became servant [NUMBER]
-- Years as servant [NUMBER]

PEOPLE: OCCUPATION: MARITIME
-- Years at sea [NUMBER]
-- Approximate age first went to sea [Years] [NUMBER]
-- Approximate years at sea before made master [NUMBER]
-- Approximate years master of ships [NUMBER]
-- Approximate age first master of ships [NUMBER]
-- Months master of most recent ship [NUMBER]
-- Months in company of most recent ship [NUMBER]
-- Length of most recent voyage in which deponent present [NUMBER]
-- Number of known voyages by deponent in named ship

PEOPLE: SKILLS
-- Literate - Signature [TAB]
-- Illiterate - Initial(s) [TAB]
-- Illiterate - Marke(s) [TAB]
-- Language, reading & writing skills, quantitative skills; weighing; navigation skills; mapping skills; schools [TEXT]

PEOPLE: HEALTH
-- Medical; Sickness; Injury; Disability; Health; Surgeon's expenses [TEXT]
-- Prisons; Imprisonment; Punishment; Torture; Galleys [TEXT]

PEOPLE: FINANCE: WAGES
-- Wages (£) [per day] [CURRENCY]
-- Wages (£) per week [CURRENCY]
-- Wages (£) [per month] [CURRENCY]
-- Wages (£) per voyage [CURRENCY]
-- Wages (£) per year [CURRENCY]
-- Wages and/or Profits [TEXT]

PEOPLE: FINANCE: TAXES
-- Subsidy assessment (£) [CURRENCY]
-- Subsidy assessment [TEXT]

PEOPLE: FINANCE: INVESTMENT
-- Private adventures + clothes, instruments and other personal items [£] [CURRENCY]
-- Private adventures + money + clothes, instruments and other personal items [TEXT]
-- Small loans and debts between mariners and mariners and passengers [TEXT]
-- Worth (debts paid) (£) [CURRENCY]
-- Worth (debts paid) [TEXT]

PEOPLE: RELATIONSHIPS
-- Relationships [TEXT]

PEOPLE: CATCHALL CATEGORY
-- Seafaring record or other commercial record [TEXT]

Ships


SHIPS: BASIC
-- Name of ship [TEXT]
-- Place of affiliation of ship [e.g. the Seaventure of Yarmouth] [TEXT]
-- Name of master of ship [TEXT]
-- Man of war voyage [TAB; TEXT]
-- Ship type [Frigate; Brighantine; Galleon; Carvell; Pinnace; Pink; Flute; Galliott; Flyboat; Ketch; Bark; Smack; Patash/Potash; Hoy; Barge; Billander; Lighter; Gaber; Packet boat; Tide boat; Ferry; Wherry; Lighthorseman; Sculler; Crayer; Cock boat; Pete boat; Trink boat; Trawler; Hebber; Stowe boat; Oyster dredger;Dogger boat; Herring busse; Busse; Fishing boat] [TAB]

SHIPS: VOYAGES
-- Extent of voyage knowledge [None; Partal; Full] [TAB]
-- Voyage nodal points [Named nodes in route order, if known] [TEXT]

SHIPS: PHYSICAL
-- Ship burthen [Tons] [NUMBER]
-- Ship ordnance [Guns] [NUMBER]
-- Ship decks [NUMBER]
-- Ship age [YEARS; TEXT]
-- Ship length [NUMBER]
-- Ship breadth [NUMBER]
-- Ship depth [NUMBER]
-- Height between decks [NUMBER]
-- Where ship built [TEXT]
-- Where ship bought [TEXT]

SHIPS: PEOPLE
-- Name of master of ship [TEXT]
-- Ship company size [including master and boys] [NUMBER]

SHIP: OTHER CHARACTERISTICS
-- Ship details [burthen; manning; ordnance]; Furniture; Apparrell; Sails; Rigging; Hull; Anchors; Value of ship; Freight rates; Demurrage; Size of ship's company; Owners of ship [TEXT]
-- Damage to ship; Repairs to ship; Ship building; Leakiness; Pumping of ship; Weighing of ship [TEXT]
-- Ships provisions [Food; Drink; Iron work; Ropes; Sails etc.] [TEXT]
-- Passengers [TEXT]
-- Weather [hurricanes; monsoons; tempests, gale; storms; frost; ice; tropical heat; wind; fog; tide]; Severity of weather [stress; distress; extremity; (very) foul; thick; contrary; bad; wet]; Impact of weather on ship [leakage; steering errors; casting away; running ashore; driven ashore]; Seasonality [TEXT]
-- Planned and/or actual voyage details and key voyage dates [TEXT]

SHIP: SEA BATTLES AND AND PREDATION AT SEA
-- Deposition contains sea battle [YES/NO] [TAB]
-- Length of sea battle [HOURS] [NUMBER]
-- Dead [COUNT]
-- Wounded [COUNT]
-- Sea battles; Rules of war [TEXT]
-- Nature of interaction with Turkish men of war; Barbary; Sally; Argiers; Tunis; Santa Cruz; Marrocoes; Galleys; King of Spain's galleys; Slavery [TEXT]
-- Suprisals and Seizures [TEXT]

Materials


MATERIALS
-- Materials handling [on shore and on ship]; theft; weights & measures standards; rats and cats; damage to goods [TEXT]
-- Theft of goods; Embezlement of goods; Fraud; Evasion of custom and impost; Contraband [TEXT]
-- Seasonality; Vintage; Time to market [TEXT]
-- Details of ship's lading and her laders; including value of lading; and freight charges [TEXT]
-- Textiles (bay(e), callico, cloth, damask(e), diaper, dozens, kersey, lace, silk, taffaty(e); Cambrick stuff(e), Northern kersey, serge, Spanish cloth, tapestry ); Raw materials (cotton wool(l), flax, wool(l)); Dye stuffs: (woad(e); indigo(co); speckled wood; red(d) wood; Yarn; Garments; Household textiles (boulster, napkins, pillow) [TEXT]

Information


INFORMATION
-- Transmission of information between locations [TEXT]
-- Public speaking on ship and in port; Consortships at sea; Consultation with Company and Passengers[TEXT]
-- Documents [letters; books; journals; notes; verbal contracts]; Making & Use of documents [TEXT]

Financing


FINANCING
-- Financial structures [bills of exchange; lending; assurance]; Late payments for freight; Legal agreements; Verbal contracts; Debts; Bankruptcy; Currency exchange; Trading profit calculations [TEXT]

Labour


LABOUR MARKET
-- Labour market; Where hired; Where left ship; Where wages paid; Nationality of ship's company; Men pressed from ship [TEXT]

Legal


LEGAL: BASIC
-- Event triggering legal case in High Court of Admiralty [TEXT]
-- Short form case description [TEXT]
-- Folio mark [TEXT]
-- Date of deposition [Modernized English calendar] [TEXT]

LEGAL: ADVANCED
-- Disputes in English law courts or arbitration; Commissions; Protests; Examinations on ships; Examinations on shore [TEXT]
-- Disputes in non-English law courts or arbitration outside England; Includes Inquisition, Embargos, Sequestration, Consuls; Viceconsuls; Commissions; Foreign Notaries; Protests [TEXT]

LEGAL: CUSTOMARY BEHAVIOUR
-- Customary behaviour in non-English ports [TEXT]
-- Customary behaviour on River Thames [TEXT]
-- Customary behaviour on high seas; Prize law at sea [TEXT]

LEGAL: NORMATIVE BEHAVIOUR
-- Behaviour of mariners on ship; Behaviour of other men and women; Abilities/Skills; Duties; Roles; Consent [TEXT]
-- Reputation and credit worthiness of mariners on ships; tradesmen; merchants [TEXT]

Linkages between dimensions

NOTE: one deponent can have multiple linkages to a ship
-- Deponent sailed in ship as one of company (includes pilots and factors) [TAB]
-- Deponent is passenger in ship [TAB]
-- Deponent is part-owner of ship [TAB]
-- Deponent is freighter of ship [TAB]
-- Deponent had goods in ship [TAB]
-- Deponent is shore based supplier to ship [TAB]

Scoping of the textual and numerical resources in the database


The two primary types of data in the SOLM-20124 database are textual and numerical

Below are tables describing the these data in terms of cell counts as of April 11th 2024:

TEXTUAL

SOLM-2024 SEMINAR DATABASE Ver.14.1 13042024 TEXT ONE.JPG

SOLM-2024 SEMINAR DATABASE Ver.14.1 13042024 TEXT FOUR.JPG

NUMERICAL

SOLM-2024 SEMINAR DATABASE Ver.14.1 13042024 NUMERICAL ONE.JPG

SOLM-2024 SEMINAR DATABASE Ver.14.1 13042024 NUMERICAL TWO B.JPG

SOLM-2024 SEMINAR DATABASE Ver.14.1 13042024 NUMERICAL THREE.JPG

SOLM-2024 SEMINAR DATABASE Ver.14.1 13042024 NUMERICAL FOUR.JPG

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