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
- 📝 What is the most noteworthy defection of a member of the Nazi party to the Allies during WWII?
- 📝 Battle of Queenston Heights, 13 Oct 1812: 23 American soldiers held as British deserters
- 📝 Did the US military just kill more Russians in Syria than they ever did during the Cold War?
- 📝 Was non-interventionism before WWII a principled stand, or was it motivated by pro-Nazi sentiment?
- 📝 How would Eastern European emigres have traveled across Eastern Europe to Warsaw in the early 20thC?
- 📝 What were the sources of Jewish immigration to Israel between 1939-1951?
- 📝 Is there evidence of ancient Chinese exploration of Australia?
- 📝 Can anyone identify this European uniform? Likely Belgian or French
- 📝 What do Florence, Genoa, Milan and Venice have in common?
- 📝 Was "Street" more common than the abbreviated "St." in pre-1910 American newspapers?
- 📝 Were the (early 17th C) arrivers/colonists to North America (USA) outcasts from European societies?
- 📝 How would British counterfeiting efforts in the revolutionary war have inflated the American currency?
- 📝 Are there examples of pre-industrial cruise ship?
- 📝 Why have officers in the U.S. Army tended to "top out" at the level of Major?
- 📝 Why were so few Luftwaffe attacks flown against the Normandy beaches on 6 June 1944?
- 📝 Why did the Soviet Union's economy grow fast in the 1950's-1960's?
- 📝 What is the origin of the first dynasty in Scotland?
- 📝 Has there ever been an instance of a business attempting or succeed a coup?
- 📝 What was the average height of Roman men and women?
- 📝 Roman consuls under Roman rex
- 📝 How did Americans know to use smallpox infected blankets, before germ theory?
- 📝 Why was the Russian Federation Military expenditure cut in 1998-1999?
- 📝 What is the significance of barley as opposed to wheat in Ancient Rome?
- 📝 What words were spoken about oaths by US supreme court justices presiding over previous presidential impeachments?
- 📝 Did countries use insurance to compensate for their economic losses after the Black Death/Spanish flu/Asian flu?
- 📝 What were Greek and Roman sails made from?
- 📝 Why did Ong Khan offer Temujin (young Gengis Khan) a position?
- 📝 Were Hitler's anti-Jewish sentiments known at all to those who voted him to power in 1933?
- 📝 Is there any way to historically consider the cultural severity on a disease or impairment? (specifically during the Roman Empire)
- 📝 When did we start expecting a store to have bags for our purchases?
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?