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
- 📝 How much did Didius Julianus pay to become emperor of Rome?
- 📝 Are there any important biographies of nobodies?
- 📝 What are the scholarly opinions on the idea of the "European Civil War"?
- 📝 How much more productive was Aegyptus in comparison to Africa Proconsularis in classical antiquity?
- 📝 Why didn't King Ferdinand take over Portugal during the Spanish Reconquista?
- 📝 Who are the three men standing and what are they holding at this University of Paris Doctors' Meeting?
- 📝 When the national leader is a foreigner
- 📝 What were the plans to use the atomic bomb if it had been in time for the war in Europe?
- 📝 Why did the number of Nazis in the Bundestag increase significantly in 1953?
- 📝 When did *wooden* 'nails' (pegs) for clay roof tiles go out of fashion?
- 📝 Was the Waffen-SS an elite force?
- 📝 What is the origin of the crest on this coat of arms found in a graveyard in the north of England?
- 📝 Has the United States ever had a non-Christian President?
- 📝 Was the N.E.P. of Russia successful in terms of economics?
- 📝 Before television sets became commonplace, did people generally watch movies only once?
- 📝 Why was Johannes Blaskowitz indicted at the Nuremberg High Command Trial
- 📝 How were USSR oblasts and cities governed?
- 📝 Was lighter or darker skin pigment valued higher in ancient Greek civilization?
- 📝 Was Karst (Kras) first region that was man-made reforested?
- 📝 Can anyone verify this story about the President's driver?
- 📝 How was a line looped under a sailing vessel for keelhauling?
- 📝 When were the first heating apparatus used for bathing?
- 📝 What are the reasons for the failure of Soviet Union at agriculture?
- 📝 How well can cavalry fight infantry?
- 📝 Was it militarily possible to "island hop" the Philippines if not for MacArthur?
- 📝 History of monogamy
- 📝 What is known about the origins of the "western given-name-first-surname-last system"?
- 📝 Is there an instance where Rome adopted a weapon to win a war?
- 📝 Were Napoleon's chances of being caught after Waterloo high or low?
- 📝 Did the "unexpectedness" of key events argue against a "third strike" at Pearl Harbor?
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?