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
- 📝 Were ancient ships named?
- 📝 How was food produced in Europe/Germany prior to the industrial revolution?
- 📝 What was Cemetery ridge named for?
- 📝 Which prayer did sailors in Russian America expect to hear?
- 📝 Are empires inherently stable over time?
- 📝 What were Aurangzeb Alamgir's motives for reversing much of the religious tolerance in the Mughal Empire?
- 📝 What caused medieval England to be freer than other countries at the time?
- 📝 What were the causes of decline of Babylonian numeric system?
- 📝 How old is the practice of a woman accompanying another woman to the ladies restroom?
- 📝 Who was the American settler Tolman of Kamchatka?
- 📝 What led the U.S. to standardize option contracts to 100 shares per lot?
- 📝 How did Edgar Allan Poe get promoted to Sergeant Major from Private in just 2 years?
- 📝 Where did Roman senators mostly live in the time of Tiberius or Caligula?
- 📝 Was it illegal in 18th century France or Spain to use false titles of nobility?
- 📝 "Peace, land, and bread!" Or not?
- 📝 How were the Big Four compensated when British Rail was formed?
- 📝 How did the Romans discover dry cleaning?
- 📝 Is there still controversy among historians and archaeologists about the exact date of the Eruption of Mount Vesuvius in 79AD?
- 📝 Why were the Yellow River dyke repairs delayed?
- 📝 Identification of a badge with Russian text
- 📝 In 2018 US Dollars, how much was Picasso's painting sold for in 1912?
- 📝 What was the composition of a US Half-Track Unit during the Korean War?
- 📝 Why did no other empire contest Russia's colonization of North-Asia?
- 📝 Works of "Longue Durée" history in English
- 📝 Did a ritual of pushing 60-year-olds off a bridge really exist in Archaic Rome?
- 📝 Who were the candidates in the consular elections for 80 BC in Rome?
- 📝 Surrender Ceremonies at the End of WW2: What happened after documents signed?
- 📝 Transatlantic Zeppelin trips usually took > 100 hours. How did they stock enough food, and where did they sleep?
- 📝 How did lecturers magnify their voice in the days before amplification?
- 📝 What is the history of the tradition of the out-going president attending the inauguration of 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?