Ports with ships in the commercial Halifax trade, late 18th Century
Upvote:1
I have now downloaded the CLIWOC15_2000.zip file, unzipped it to CLIWOC15_2000.mdb, and successfully opened it with MS-ACCESS 2016 by holding SHIFT down while doing so (This disables any startup macros.) I then declined the option of enabling active content.
The following query
SELECT
ShipName,
ShipType,
VoyageIni,
VoyageFrom,
VoyageTo,
Company,
Nationality,
Name1, Rank1,
Name2, Rank2
,count(*) as Records
FROM CLIWOC15
WHERE ( VoyageFrom Like "HALIFAX*"
OR VoyageTo Like "HALIFAX*"
)
AND Year BETWEEN 1792 and 1798
GROUP BY
ShipName,
ShipType,
VoyageIni,
VoyageFrom,
VoyageTo,
Company,
Nationality,
Name1, Rank1,
Name2, Rank2
ORDER BY
ShipName,
ShipType,
VoyageIni
;
(where Year is that of the log entry) then returns these five Royal Navy voyages:
More post
- 📝 Did Native-Americans Have Horses?
- 📝 Did the Mapuche conquer other non-Mapuche tribes?
- 📝 Has there been a war in which the South conquered the North?
- 📝 When Napoleonic wars happened?
- 📝 Who was "Lt.-Commander R.T. Chaloner Woods"?
- 📝 Who said "one can be a powerful king with a very small sceptre"?
- 📝 Why wasn't Russia in the Paris Peace Talks?
- 📝 Paradigm change in power: from military to economic in Europe
- 📝 What was Singapore's population in 1290-1396, 1511-1699?
- 📝 Has there ever been a case when a traitorous military commander took command again for the side he betrayed?
- 📝 Age of majority in Washington state in 1945?
- 📝 Why were slave armies used?
- 📝 Did New Mexicans under Spain regard themselves as Mexican?
- 📝 1901 Boxer Protocol settlement to Norway
- 📝 Why did Operation Market Garden go ahead when the allies knew German armor was in the area?
- 📝 Which George V stamp would be used for a letter sent from London to Sweden in 1919/1920?
- 📝 Did migrating people ever maintain contact across the Bering Strait?
- 📝 How secret was the US and British involvement in the 1953 Iranian coup d'état?
- 📝 What is the most widely accepted theory on the ancient "Sea Peoples"?
- 📝 Which floating-point representation did Konrad Zuse's Z1 use?
- 📝 What is the extent to which Malcolm X's activism was influenced by his Muslim beliefs?
- 📝 Were British fears of Russia using Afghanistan as a staging post for an invasion of India unfounded?
- 📝 Napoleon's Height
- 📝 What was the role/duties of a "Constable of the Castle" in 1600?
- 📝 What paintings might these be (2 sketches made in the Tate Britain Gallery)?
- 📝 What is under the Great Sphinx of Giza?
- 📝 When and how did steel supplant iron for artillery?
- 📝 Did land based airpower give the Americans a decisive advantage at the Battle of Midway?
- 📝 Did Marcus Aurelius ever deliberate about his son's succession?
- 📝 Why is it "an interesting commentary on the quality of Jefferson's democracy that he chose Madison as his successor"?
Source: stackoverflow.com
Search Posts
Related post
- 📝 Ports with ships in the commercial Halifax trade, late 18th Century
- 📝 How was the linen weaving trade learnt in 18th century Scotland?
- 📝 What was the typical range of travel of a Pennsylvanian resident for everyday life in the late 18th early 19th Century Pennsylvania?
- 📝 Contracted Trade in the 18th century
- 📝 Was it widespread during the 17th and 18th Century for British country people to be evicted and replaced with more profitable agriculture?
- 📝 What did the word "leisure" mean in late 18th Century usage?
- 📝 Why were British ships not of the same quality as French and Spanish ships until the latter part of the 18th century?
- 📝 Why is the late Russian Empire associated with Byzantium while having little in common with it?
- 📝 Why did piracy thrive in the late 17th and early 18th centuries?
- 📝 What did the top minds of the late 17th century have to say about Salem witch trials?
- 📝 Would a common person in the 18th century have heard Mozart's music during his lifetime?
- 📝 In what ways did the rise of a true middle class in Europe during the late 19th century become apparent?
- 📝 Were the mongol army boots of 13th century lined with fur?
- 📝 What goods did Germany trade during the Weimar Republic, and with whom?
- 📝 Why do some 17th and 18th century maps depict Ottoman sanjaks north of the Danube in Wallachia?
- 📝 In the 18th c., did/would China accept gold from Europe as trade payment? Why / why not?
- 📝 Typical fortifications around major cities in the 18th century
- 📝 What exactly were the dealings of Ea-Nasir ("The Worst Businessman Of The 18th Century BC")?
- 📝 Where and how did scientists of the 18th and 19th century learn foreign languages?
- 📝 Why does the first decade of the 21st century start with 2000?
- 📝 In the 18th century, who built ships built using two-pointed nails?
- 📝 Were sailing ships of the line understaffed with gunnery crews so that there were not enough for 2 broadsides?
- 📝 What is a "Johnsonian world of clubs and coffee houses" in the context of 18th century England?
- 📝 Why is there no Islamic architecture with glass in windows before the 18th century?
- 📝 Were people buried in the 19th century with a cloth around their head if so why?
- 📝 Was the enclosure responsible for the supply of factory workers in 18th and 19th Century England?
- 📝 Time to travel around Europe in the 18th century
- 📝 What is the original source of this 16th century image of a French town holiday with musicians in a tree?
- 📝 What's the difference between Country Born and Mulatto people in the 18th century New England?
- 📝 What uniform is the man in this mid to late 19th century photo wearing?