3  Voyage tables

Show the code 
source(here::here("scripts/setup.R"))

source(here("scripts/load-voyages.R"))

source(here("scripts/plot-voyages-functions.R"))

Below are selected data tables corresponding to some of the maps plotted earlier.

3.1 Hampton Roads

Voyages to/from Hampton Roads (“hampton road”) in table form. Column names are a subset of the variables in the data frame I used for plotting. Ones with capital letters were in the original data set; I added the ones in lower case.


Show the code 
voyage_list <- df_voyages %>% 
               filter(port_from == "hampton road" | port_to == "hampton road")

summarize_voyages(ships = voyage_list$ShipName,
                  from = "hampton road",
                  to = "hampton road"
)
Table 3.1: Voyages to or from Hampton Roads, Virginia
ShipName VoyageIni VoyageFrom port_from country_from VoyageTo port_to country_to Nationality Company date_first date_last n_days n_obs
TRITON 1750-01-01 GIBRALTAR gibraltar uk VIRGINIA hampton road united states BRITISH RN 1750-01-01 1750-01-28 27 28
TRITON 1753-01-01 VIRGINIA hampton road united states CADIZ cádiz spain BRITISH RN 1753-01-01 1753-02-15 45 40
SHOREHAM 1754-06-03 CHARLESTOWN charlestown united states HAMPTON ROAD (VIRGINIA) hampton road united states BRITISH RN 1754-06-04 1754-06-08 4 5
SHOREHAM 1754-06-24 HAMPTON ROAD (VIRGINIA) hampton road united states CHIBUCTO HARBOUR (HALIFAX) chibucto harbour canada BRITISH RN 1754-07-01 1754-07-04 3 4
SHOREHAM 1754-06-24 HAMPTON ROAD (VIRGINIA) hampton road united states HALIFAX (CHIBUCTO HARBOUR) halifax canada BRITISH RN 1754-06-25 1754-06-30 5 6
SHOREHAM 1754-10-12 SANDY HOOK (NEW YORK) sandy hook united states YORK IN VIRGINIA hampton road united states BRITISH RN 1754-10-13 1754-10-15 2 3
SHOREHAM 1754-11-15 YORK IN VIRGINIA hampton road united states CHARLESTOWN charlestown united states BRITISH RN 1754-11-17 1754-11-30 13 14
SYREN 1755-01-15 FUNCHAL ROAD (MADEIRA) madiera portugal VIRGINIA hampton road united states BRITISH RN 1755-01-15 1755-02-18 34 35
SEAHORSE 1755-02-06 MADEIRA madiera portugal VIRGINIA hampton road united states BRITISH RN 1755-02-06 1755-03-02 24 25
SEAHORSE 1755-07-27 VIRGINIA hampton road united states SPITHEAD spithead uk BRITISH RN 1755-07-27 1755-08-20 24 25
BEAVER 1758-01-22 MADEIRA madiera portugal HAMPTON ROAD VIRGINIA hampton road united states BRITISH RN 1758-01-24 1758-03-08 43 43
LOWESTOFT 1759-02-10 PLYMOUTH plymouth uk HAMPTON ROAD VIRGINIA hampton road united states BRITISH RN 1759-02-10 1759-02-20 10 11
ASSISTANCE 1761-04-29 SPITHEAD spithead uk HAMPTON ROAD VIRGINIA hampton road united states BRITISH RN 1761-04-29 1761-05-15 16 16
ASSISTANCE 1761-10-17 VIRGINIA hampton road united states PORTSMOUTH portsmouth uk BRITISH RN 1761-10-17 1761-11-26 40 40
CHESTERFIELD 1761-12-13 SPITHEAD spithead uk HAMPTON ROAD VIRGINIA hampton road united states BRITISH RN 1761-12-13 1762-02-06 55 56
ARUNDEL 1761-12-25 TORBAY torquay uk HAMPTON ROAD hampton road united states BRITISH RN 1761-12-25 1762-03-12 77 78
DILIGENCE 1763-09-08 PLYMOUTH plymouth uk HAMPTON ROAD VIRGINIA hampton road united states BRITISH RN 1763-09-08 1763-11-08 61 28
RAINBOW 1766-08-14 HAMPTON hampton road united states MARGRET ROAD (UK) lizard uk BRITISH RN 1766-08-14 1766-09-08 25 25
SQUIRREL 1766-11-19 VIRGINIA hampton road united states SPITHEAD spithead uk BRITISH RN 1766-11-20 1766-12-17 27 28
RIPPON 1768-09-12 SPITHEAD spithead uk HAMPTON ROAD hampton road united states BRITISH RN 1768-09-12 1768-09-18 6 7
BOSTON 1770-01-20 MADEIRA madiera portugal HAMPTON ROAD hampton road united states BRITISH RN 1770-01-20 1770-03-06 45 46
BOSTON 1770-09-01 HAMPTON ROAD hampton road united states HAILFAX hailfax canada BRITISH RN 1770-09-01 1770-09-09 8 9
FOWEY 1771-01-23 CHARLESTOWN charlestown united states NORFOLK VIRGINIA hampton road united states BRITISH RN 1771-01-23 1771-01-31 8 9
FOWEY 1771-04-12 HAMPTON ROAD VIRGINIA hampton road united states BOSTON boston united states BRITISH RN 1771-04-12 1771-04-21 9 10
GLASGOW 1772-04-26 BOSTON boston united states HAMPTON ROAD VIRGINIA hampton road united states BRITISH RN 1772-04-26 1772-05-05 9 10
CRUIZER 1773-10-06 RHODE ISLAND rhode island united states VIRGINIA hampton road united states BRITISH RN 1773-10-06 1773-10-12 6 6
LIVERPOOL 1775-09-16 SPITHEAD spithead uk NORFOLK, VIRGINIA hampton road united states BRITISH RN 1775-09-16 1775-11-25 70 30
ANDROMEDA 1797-02-16 BERMUDA bermuda bermuda HAMPTON ROAD hampton road united states BRITISH RN 1797-02-16 1797-03-07 19 20
ST ALBANS 1797-02-24 LISBON lisbon portugal HAMPTON ROAD, VIRGINIA hampton road united states BRITISH RN 1797-02-24 1797-04-14 49 46
ST ALBANS 1799-02-25 HAMPTON ROAD hampton road united states HALIFAX halifax canada BRITISH RN 1799-02-25 1799-05-20 84 51
SWAN 1800-05-30 MONA ISLAND mona island puerto rico HAMPTON ROAD VIRGINIA hampton road united states BRITISH RN 1800-05-31 1800-06-09 9 9
LILLY 1800-12-15 BERMUDA bermuda bermuda CHESAPEAKE hampton road united states BRITISH RN 1800-12-15 1800-12-25 10 11
LILLY 1801-01-13 VIRGINIA hampton road united states NEW PROVIDENCE new providence united states BRITISH RN 1801-01-13 1801-01-21 8 9
LILLY 1801-02-03 NEW PROVIDENCE new providence united states HAMPTON ROAD hampton road united states BRITISH RN 1801-02-03 1801-03-04 29 30
LILLY 1801-03-13 HAMPTON ROAD hampton road united states HALIFAX halifax canada BRITISH RN 1801-03-13 1801-04-02 20 21
BRUTUS 1802-02-12 BREST brest france HAMPTON hampton road united states DUTCH MAR 1802-02-12 1802-05-08 85 64
JOAN DE WITT 1802-04-17 CAAP FRANCAIS cap-haitien haiti HAMPTON hampton road united states DUTCH MAR 1802-04-17 1802-05-11 24 23
BRUTUS 1802-06-29 HAMPTON hampton road united states TEXEL texel netherlands DUTCH MAR 1802-06-29 1802-08-01 33 34
JOAN DE WITT 1802-06-29 HAMPTON hampton road united states NEDERLAND den helder netherlands DUTCH MAR 1802-06-29 1802-08-10 42 40
LILLY 1803-05-04 BERMUDA bermuda bermuda HAMPTON ROAD hampton road united states BRITISH RN 1803-05-04 1803-05-10 6 7
LILLY 1803-05-19 HAMPTON ROAD hampton road united states HALIFAX halifax canada BRITISH RN 1803-05-19 1803-05-31 12 13
PHAETON 1804-01-29 HAMPTON ROAD, VIRGINIA hampton road united states MADRAS madras india BRITISH RN 1804-01-29 1804-05-22 114 115
PHAETON 1804-09-01 SPITHEAD spithead uk HAMPTON ROAD, VIRGINIA hampton road united states BRITISH RN 1804-09-01 1804-09-30 29 27
AMAZON 1806-08-10 NEWFOUNDLAND newfoundland canada VIRGINIA hampton road united states BRITISH RN 1806-08-10 1806-09-22 43 44
REGULUS 1814-12-19 TANGIER BAY, CHESAPEAKE hampton road united states CUMBERLAND ISLAND, FLORIDA florida united states BRITISH RN 1814-12-19 1815-01-07 19 20
27 ships and 45 voyages; ships from 2 nationalities


3.2 US and Netherlands

Show the code 
ship_list <- 
  c(df_voyages %>% 
      filter(country_from == "united states" & country_to == "netherlands") %>%
      pull(ShipName),
    df_voyages %>%
      filter(country_from == "netherlands" & country_to == "united states") %>%
      pull(ShipName)
  )

summarize_voyages(ships = ship_list)
Table 3.2: Voyages between the USA and Netherlands
ShipName VoyageIni VoyageFrom port_from country_from VoyageTo port_to country_to Nationality Company date_first date_last n_days n_obs
JASON 1752-06-08 PLYMOUTH SOUND plymouth uk MADERIA ROAD madiera portugal BRITISH RN 1752-06-08 1752-06-30 22 15
JASON 1752-07-01 MADERIA ROAD madiera portugal CHEBUTO chebuto uk BRITISH RN 1752-07-01 1752-07-25 24 25
JASON 1753-08-15 SPECTACLE ISLAND (BOSTON) boston united states SHEERNESS sheerness uk BRITISH RN 1753-08-15 1753-09-06 22 23
JASON 1754-03-12 PLYMOUTH plymouth uk MADEIRA madiera portugal BRITISH RN 1754-03-12 1754-03-19 7 8
JASON 1755-03-01 CROOKED ISLAND (BAHAMAS) bahamas bahamas SPITHEAD spithead uk BRITISH RN 1755-03-01 1755-03-31 30 31
JASON 1768-07-25 PLYMOUTH plymouth uk MADEIRA madiera portugal BRITISH RN 1768-07-26 1768-08-04 9 10
JASON 1771-08-16 MONSERRAT little bay lesser antilles SPITHEAD spithead uk BRITISH RN 1771-08-16 1771-09-20 35 36
JASON 1777-12-31 ROTTERDAM rotterdam netherlands ST CHRISTOFFEL st christopher united states DUTCH ADM 1778-01-05 1778-02-18 44 45
JASON 1778-03-28 ST CHRISTOFFEL st christopher united states SURINAME paramaribo suriname DUTCH ADM 1778-03-28 1778-04-28 31 32
JASON 1778-11-20 SURINAME paramaribo suriname ST EUSTACIUS st eustatius lesser antilles DUTCH ADM 1778-11-20 1778-11-28 8 5
JASON 1779-07-15 ST EUSTACIUS st eustatius lesser antilles TEXEL texel netherlands DUTCH ADM 1779-07-15 1779-09-02 49 50
JASON 1780-01-09 HELLEVOETSLUIS hellevoetsluis netherlands ST EUSTACIUS st eustatius lesser antilles DUTCH ADM 1780-01-13 1780-03-20 67 60
JASON 1780-07-07 ST EUSTACIUS st eustatius lesser antilles HELLEVOETSLUIS hellevoetsluis netherlands DUTCH ADM 1780-07-07 1780-09-16 71 65
WINDHOND 1783-07-01 HELLEVOETSLUIS hellevoetsluis netherlands PHILADELPHIA philadelphia united states DUTCH ADM 1783-07-09 1783-09-23 76 71
WINDHOND 1783-12-05 PHILADELPHIA philadelphia united states TERVEUR terveur azores DUTCH ADM 1783-12-07 1784-01-09 33 34
JOAN DE WITT 1802-01-05 NEDERLAND den helder netherlands ST CRUZ santa cruz de tenerife spain DUTCH MAR 1802-02-13 1802-02-25 12 13
BRUTUS 1802-02-12 BREST brest france HAMPTON hampton road united states DUTCH MAR 1802-02-12 1802-05-08 85 64
JOAN DE WITT 1802-03-01 ST CRUZ santa cruz de tenerife spain CAAP FRANCAIS cap-haitien haiti DUTCH MAR 1802-03-01 1802-04-02 32 33
JOAN DE WITT 1802-04-17 CAAP FRANCAIS cap-haitien haiti HAMPTON hampton road united states DUTCH MAR 1802-04-17 1802-05-11 24 23
BRUTUS 1802-06-29 HAMPTON hampton road united states TEXEL texel netherlands DUTCH MAR 1802-06-29 1802-08-01 33 34
JOAN DE WITT 1802-06-29 HAMPTON hampton road united states NEDERLAND den helder netherlands DUTCH MAR 1802-06-29 1802-08-10 42 40
HANNACH 1807-07-07 TEXEL texel netherlands NEW YORK new york united states AMERICAN NA 1807-07-07 1807-09-05 60 59
AJAX 1814-06-06 HELLEVOETSLUIS hellevoetsluis netherlands BOSTON boston united states DUTCH MAR 1814-06-06 1814-07-27 51 52
AJAX 1814-10-19 BOSTON boston united states TEXEL texel netherlands DUTCH MAR 1814-10-19 1814-11-21 33 34
ATTELANTE 1815-07-03 NEDERLAND den helder netherlands NEW YORK new york united states DUTCH THOMAS BROUW EN ZN 1815-07-03 1815-09-05 64 64
ATTELANTE 1815-10-19 NEW YORK new york united states SCHIEDAM rotterdam netherlands DUTCH THOMAS BROUW EN ZN 1815-10-21 1815-11-17 27 28
7 ships and 26 voyages; ships from 3 nationalities


3.3 Canada and France

Show the code 
ship_list <- 
  c(df_voyages %>% 
      filter(country_from == "canada" & country_to == "france") %>%
      pull(ShipName),
    df_voyages %>%
      filter(country_from == "france" & country_to == "canada") %>%
      pull(ShipName)
  )

summarize_voyages(ships = ship_list)
Table 3.3: Voyages between Canada and France
ShipName VoyageIni VoyageFrom port_from country_from VoyageTo port_to country_to Nationality Company date_first date_last n_days n_obs
LE PROTHÉE 1750-05-18 BREST brest france LOUISBOURG louisbourg canada FRENCH NA 1750-05-18 1750-07-03 46 47
LE PROTHÉE 1750-08-01 LOUISBOURG louisbourg canada CADIX cádiz spain FRENCH NA 1750-08-01 1750-08-24 23 24
LE PROTHÉE 1750-10-31 CADIX cádiz spain BREST brest france FRENCH NA 1750-11-01 1750-11-30 29 30
LE TRITON 1751-05-23 MALAGA málaga spain LOUISBOURG louisbourg canada FRENCH NA 1751-05-26 1751-06-16 21 21
L'HEUREUX 1751-06-15 ROCHEFORT rochefort france LOUISBOURG louisbourg canada FRENCH NA 1751-06-15 1751-08-04 50 50
LE CHARIOT ROYAL 1751-06-27 ROCHEFORT rochefort france QUÉBEC québec city canada FRENCH NA 1751-07-05 1751-08-25 51 52
LE TRITON 1751-07-28 LOUISBOURG louisbourg canada LOUISBOURG louisbourg canada FRENCH NA 1751-08-04 1751-08-12 8 3
LA SEINE 1751-09-03 ROCHEFORT rochefort france LOUISBOURG louisbourg canada FRENCH NA 1751-09-03 1751-10-07 34 35
L'HEUREUX 1751-09-13 LOUISBOURG louisbourg canada ROCHEFORT rochefort france FRENCH NA 1751-09-13 1751-10-06 23 24
LE TRITON 1751-09-14 LOUISBOURG louisbourg canada TOULON toulon france FRENCH NA 1751-09-15 1751-10-22 37 28
LE CHARIOT ROYAL 1751-10-27 QUÉBEC québec city canada ROCHEFORT rochefort france FRENCH NA 1751-11-07 1751-11-26 19 20
LA SEINE 1751-11-27 LOUISBOURG louisbourg canada ROCHEFORT rochefort france FRENCH NA 1751-11-27 1752-01-02 36 37
LE CHARIOT ROYAL 1752-04-13 ROCHEFORT rochefort france ILES ST PIERRE, TERRE NEUVE, ILE ROYALE ET RETOUR NA NA FRENCH NA 1752-04-14 1752-05-06 22 22
LA SEINE 1752-05-27 ROCHEFORT rochefort france QUEBEC québec city canada FRENCH NA 1752-05-27 1752-07-14 48 49
LE CHARIOT ROYAL 1752-06-28 ROCHEFORT rochefort france ILES ST PIERRE, TERRE NEUVE, ILE ROYALE ET RETOUR NA NA FRENCH NA 1752-06-28 1752-07-13 15 16
LA SEINE 1752-08-21 QUÉBEC québec city canada ROCHEFORT rochefort france FRENCH NA 1752-08-26 1752-09-17 22 23
LE RHINOCEROS 1753-05-01 ROCHEFORT rochefort france LOUISBOURG louisbourg canada FRENCH NA 1753-05-03 1753-06-09 37 38
LE BIZARRE 1753-05-04 BREST brest france LOUISBOURG louisbourg canada FRENCH NA 1753-05-04 1753-06-14 41 42
LA SEINE 1753-06-26 ROCHEFORT rochefort france QUÉBEC québec city canada FRENCH NA 1753-06-27 1753-08-22 56 57
LE RHINOCEROS 1753-07-06 LOUISBOURG louisbourg canada ROCHEFORT rochefort france FRENCH NA 1753-07-06 1753-08-02 27 27
LE PARHAM 1753-07-29 ILE D'AIX ile d'aix france LOUISBOURG ET RTOUR A ROCHEFORT louisbourg canada FRENCH NA 1753-07-30 1753-09-10 42 43
LA SEINE 1753-10-07 QUÉBEC québec city canada ISLE D'AIX ile d'aix france FRENCH NA 1753-10-30 1753-11-23 24 25
LE BIZARRE 1753-10-14 LOUISBOURG louisbourg canada BREST brest france FRENCH NA 1753-10-14 1753-11-11 28 29
LE PARHAM 1753-12-02 ILE D'AIX ile d'aix france LOUISBOURG ET RTOUR A ROCHEFORT louisbourg canada FRENCH NA 1753-12-02 1753-12-25 23 24
LE PARHAM 1754-05-06 ROCHEFORT rochefort france LOUISBOURG ET RETOUR A ROCHEFORT louisbourg canada FRENCH NA 1754-05-19 1754-07-17 59 59
LE AIGLE 1754-05-20 L'ISLE D'AIX ile d'aix france LOUISBOURG ET RETOUR A L'ISLE D'AIX louisbourg canada FRENCH NA 1754-06-21 1754-08-14 54 50
LE PARHAM 1754-09-02 ROCHEFORT rochefort france LOUISBOURG ET RETOUR A ROCHEFORT louisbourg canada FRENCH NA 1754-09-02 1754-10-07 35 36
LE AIGLE 1754-10-11 L'ISLE D'AIX ile d'aix france LOUISBOURG ET RETOUR A L'ISLE D'AIX louisbourg canada FRENCH NA 1754-10-12 1754-11-03 22 23
LA DIANE 1755-03-09 ISLE D'AIX ile d'aix france LOUISBOURG louisbourg canada FRENCH NA 1755-03-15 1755-04-30 46 47
L'ACTIF 1755-05-03 BREST brest france QUÉBEC québec city canada FRENCH NA 1755-05-04 1755-06-14 41 42
LA DIANE 1755-08-05 QUEBEC québec city canada ROCHEFORT rochefort france FRENCH NA 1755-08-20 1755-09-10 21 22
L'ACTIF 1755-08-25 QUÉBEC québec city canada BREST brest france FRENCH NA 1755-09-02 1755-09-20 18 19
LE VALEUR 1755-09-14 L'ILE D'AIX ile d'aix france LOUISBOURG ET RETOUR A ROCHEFORT louisbourg canada FRENCH NA 1755-09-15 1755-10-28 43 44
LE RHINOCEROS 1755-10-17 ROCHEFORT rochefort france LOUISBOURG louisbourg canada FRENCH NA 1755-10-26 1755-11-16 21 22
LE RHINOCEROS 1755-12-20 LOUISBOURG louisbourg canada ROCHEFORT rochefort france FRENCH NA 1755-12-20 1756-01-06 17 18
LE RHINOCEROS 1756-02-23 ROCHEFORT rochefort france LOUISBOURG louisbourg canada FRENCH NA 1756-02-24 1756-03-25 30 31
LE RHINOCEROS 1756-04-21 LOUISBOURG louisbourg canada ROCHEFORT rochefort france FRENCH NA 1756-04-22 1756-05-26 34 35
LE VALEUR 1756-06-28 L'ILE D'AIX ile d'aix france LOUISBOURG ET RETOUR A ROCHEFORT louisbourg canada FRENCH NA 1756-06-28 1756-07-16 18 19
LA SEINE 1768-08-28 LE HABRE le havre france ST MARTIN DE RHÉ la rochelle france FRENCH NA 1768-08-28 1768-11-21 85 12
LA SEINE 1768-12-09 ST MARTIN DE RHÉ la rochelle france MARTINIQUE martinique lesser antilles FRENCH NA 1768-12-09 1769-01-13 35 36
LA SEINE 1769-03-31 DOMINIQUE dominica lesser antilles BREST brest france FRENCH NA 1769-04-01 1769-04-30 29 30
LA SEINE 1769-10-11 BREST brest france FORT ROYAL jamaica jamaica FRENCH NA 1769-10-13 1769-11-25 43 44
LA SEINE 1770-07-02 DOMINIQUE dominica lesser antilles BREST brest france FRENCH NA 1770-07-04 1770-08-01 28 29
LA BELETTE 1784-04-20 TOULON toulon france ALMERIE AUX L'ILLE DE TERRE NEUVE ET RETOUR A BRES newfoundland canada FRENCH NA 1784-05-07 1784-10-16 162 65
L'EXPERIMENT 1788-04-30 BREST brest france TERRE NEUVE newfoundland canada FRENCH NA 1788-05-01 1788-09-04 126 57
LA GRACIENSE 1788-05-18 ROCHEFORT rochefort france MEDITERRANEAN mediterranean mediterranean FRENCH NA 1788-06-01 1788-09-03 94 63
L'EXPERIMENT 1788-09-22 TERRE NEUVE newfoundland canada BREST brest france FRENCH NA 1788-09-22 1788-10-05 13 13
LA GRACIENSE 1788-09-24 COULON la rochelle france MARTINIQUE martinique lesser antilles FRENCH NA 1788-11-15 1788-12-02 17 18
LA GRACIENSE 1788-10-30 COULON la rochelle france MARTINIQUE martinique lesser antilles FRENCH NA 1788-10-31 1788-11-14 14 10
LA GRACIENSE 1789-04-19 MARTINIQUE martinique lesser antilles ST PIERRE saint-pierre france FRENCH NA 1789-04-19 1789-05-21 32 17
LA GRACIENSE 1789-09-09 LE BAYE DU CROC newfoundland canada ST PIERRE saint-pierre france FRENCH NA 1789-09-10 1789-09-14 4 5
LA GRACIENSE 1789-10-08 ST PIERRE saint-pierre france MARTINIQUE martinique lesser antilles FRENCH NA 1789-10-08 1789-10-30 22 23
LA GRACIENSE 1790-04-06 MARTINIQUE martinique lesser antilles ROCHEFORT rochefort france FRENCH NA 1790-04-08 1790-05-05 27 27
15 ships and 53 voyages; ships from 1 nationalities

<br

3.4 Florida

Show the code 
voyage_list <- df_voyages %>% 
  filter(str_detect(port_to, "florida") | str_detect(port_from, "florida"))

summarize_voyages(ships = voyage_list$ShipName,
                  from = c("florida", "cape florida", "florida bay"),
                  to = c("florida", "cape florida", "florida bay")
)
Table 3.4: Voyages to or from Florida
ShipName VoyageIni VoyageFrom port_from country_from VoyageTo port_to country_to Nationality Company date_first date_last n_days n_obs
GLASGOW 1763-05-07 CAPE FLORIDA cape florida united states SPITHEAD spithead uk BRITISH RN 1763-05-07 1763-06-14 38 39
MARTIN 1783-12-09 FLORIDA florida united states NOVA SCOTIA nova scotia canada BRITISH RN 1783-12-09 1783-12-26 17 18
INTREPID 1796-08-29 CAPE OF FLORIDA cape florida united states DOWNS downs uk BRITISH RN 1796-08-29 1796-10-09 41 42
REGULUS 1814-12-19 TANGIER BAY, CHESAPEAKE hampton road united states CUMBERLAND ISLAND, FLORIDA florida united states BRITISH RN 1814-12-19 1815-01-07 19 20
4 ships and 4 voyages; ships from 1 nationalities


3.4.1 American Northwest

Show the code 
nw_explorers <- 
  get_voyage_details(range_lon = c(-170, -100),
                     range_lat = c(15, 90)
                     )

summarize_voyages(ships = nw_explorers$ShipName,
                  range_lon = c(-170, -100),
                  range_lat = c(15, 90),
)
Table 3.5: Voyages to or from the American Northwest
ShipName VoyageIni VoyageFrom port_from country_from VoyageTo port_to country_to Nationality Company date_first date_last n_days n_obs
NA SA DEL ROSARIO 1780-11-23 SISIRÁN sisirán philippines SAN BLAS (NUEVA ESPAÑA) san blas mexico SPANISH NA 1781-08-09 1781-09-26 48 49
QUEEN CHARLOTTE 1786-01-23 PORT EGMONT port egmont falkland islands SANDWICH ISLANDS hawaii united states BRITISH NA 1786-05-07 1786-05-24 17 18
LA BOUSSOLE 1786-04-11 ILE DE PAQUE easter island chile ILE MOWÉE maui united states FRENCH NA 1786-05-13 1786-05-29 16 17
QUEEN CHARLOTTE 1786-05-27 OWHYHEE hawaii united states WOAHOO hawaii united states BRITISH NA 1786-05-30 1786-06-01 2 2
LA BOUSSOLE 1786-05-31 ILE MOWÉE maui united states PORT DES FRANCAIS lituya bay united states FRENCH NA 1786-05-31 1786-07-03 33 34
QUEEN CHARLOTTE 1786-06-14 SANDWICH ISLANDS hawaii united states COAL HARBOUR vancouver canada BRITISH NA 1786-06-14 1786-07-19 35 36
LA BOUSSOLE 1786-08-01 PORT DES FRANCAIS lituya bay united states MONTEREY monterey mexico FRENCH NA 1786-08-01 1786-09-14 44 45
QUEEN CHARLOTTE 1786-08-13 COAL HARBOUR vancouver canada MONTAGUE ISLE montague island united states BRITISH NA 1786-08-14 1786-08-18 4 5
QUEEN CHARLOTTE 1786-08-19 MONTAGUE ISLE montague island united states SANDWICH ISLANDS hawaii united states BRITISH NA 1786-08-21 1786-11-15 86 82
LA BOUSSOLE 1786-09-25 MONTEREY monterey mexico LA CÔTE DE CHINE hong kong china FRENCH NA 1786-09-25 1786-11-08 44 45
QUEEN CHARLOTTE 1787-03-15 SANDWICH ISLANDS hawaii united states PRINCE WILLIAM'S SOUND prince william sound united states BRITISH NA 1787-03-15 1787-04-25 41 42
QUEEN CHARLOTTE 1787-06-04 PORT MULGRAVE port mulgrave alaska NORFOLK SOUND sitka sound united states BRITISH NA 1787-06-06 1787-06-12 6 7
QUEEN CHARLOTTE 1787-06-23 PORT BANKS port banks united states KING GEORGE'S SOUND nootka sound canada BRITISH NA 1787-06-24 1787-08-08 45 27
QUEEN CHARLOTTE 1787-08-09 KING GEORGE'S SOUND nootka sound canada SANDWICH ISLANDS hawaii united states BRITISH NA 1787-08-09 1787-09-10 32 29
QUEEN CHARLOTTE 1787-09-19 SANDWICH ISLANDS hawaii united states MACAO macau china BRITISH NA 1787-09-19 1787-09-23 4 5
LA PRINCESA 1789-02-19 SAN BLAS san blas mexico SAN LORENZO DE NUCA nootka sound canada SPANISH NA 1789-02-20 1789-12-05 288 105
LA ATREVIDA 1791-01-07 ACAPULCO acapulco mexico SAN BLAS san blas mexico SPANISH NA 1791-02-26 1791-03-30 32 20
LA ATREVIDA 1791-01-07 DESCONOCIDO (MARES DE NICARAGUA) unknown norway ACAPULCO acapulco mexico SPANISH NA 1791-01-30 1791-02-01 2 3
LA ATREVIDA 1791-01-07 SAN BLAS san blas mexico ACAPULCO acapulco mexico SPANISH NA 1791-04-13 1791-04-19 6 7
NA SA DE ARANZAZU 1792-03-20 SAN BLAS san blas mexico AMÉRICA SEPTENTRIONAL(NOKA) américa netherlands SPANISH NA 1792-03-24 1792-05-14 51 51
NA SA DE ARANZAZU 1792-06-13 NOKA nootka sound canada BUCARELY bucareli bay united states SPANISH NA 1792-06-13 1792-06-24 11 11
NA SA DE ARANZAZU 1792-07-11 BUCARELY bucareli bay united states NOKA nootka sound canada SPANISH NA 1792-07-11 1792-07-14 3 4
NA SA DE ARANZAZU 1792-07-17 BUCARELY bucareli bay united states FLORIDA BLANCA puerto san julián argentina SPANISH NA 1792-07-17 1792-07-20 3 4
NA SA DE ARANZAZU 1792-07-22 FLORIDA BLANCA puerto san julián argentina SURGIDERO DE SAN ROQUE george island canada SPANISH NA 1792-07-22 1792-07-31 9 10
NA SA DE ARANZAZU 1792-08-30 SURGIDERO DE SAN ROQUE george island canada NOKA nootka sound canada SPANISH NA 1792-08-30 1792-09-07 8 9
NA SA DE ARANZAZU 1792-10-03 NOKA nootka sound canada MONTERREY monterey mexico SPANISH NA 1792-10-03 1792-10-22 19 20
NA SA DE ARANZAZU 1793-01-14 MONTERREY monterey mexico SAN BLAS san blas mexico SPANISH NA 1793-01-14 1793-02-05 22 22
EL ACTIVO 1794-02-13 SAN BLAS san blas mexico REALEJO realejo nicaragua SPANISH NA 1794-02-13 1794-03-15 30 14
MAGALLANES 1797-10-04 ESTRECHO DE SAN BERNARDINO manila philippines ACAPULCO acapulco mexico SPANISH NA 1797-11-24 1798-01-09 46 41
8 ships and 29 voyages; ships from 3 nationalities


3.5 James Cook’s journeys

Show the code 
ship_list <- c("ENDEAVOUR", "RESOLUTION")
cooks_journeys <- c("1768-01-01", "1774-12-31")

summarize_voyages(ships = ship_list,
                  range_dates = cooks_journeys
)
Table 3.6: James Cook’s Voyages in the data set
ShipName VoyageIni VoyageFrom port_from country_from VoyageTo port_to country_to Nationality Company date_first date_last n_days n_obs
ENDEAVOUR 1768-08-27 DEPTFORD london uk MADEIRA madiera portugal BRITISH RN 1768-08-27 1768-09-12 16 17
ENDEAVOUR 1768-09-19 MADEIRA madiera portugal RIO DE JANEIRO río de janeiro brazil BRITISH RN 1768-09-20 1768-11-13 54 55
ENDEAVOUR 1768-12-08 RIO DE JANEIRO río de janeiro brazil TIERRA DEL FUEGO tierra del fuego argentina BRITISH RN 1768-12-08 1769-01-26 49 36
ENDEAVOUR 1769-01-27 TIERRA DEL FUEGO tierra del fuego argentina TAHITI papeete french polynesia BRITISH RN 1769-01-27 1769-04-12 75 76
ENDEAVOUR 1769-09-01 TAHITI papeete french polynesia NEW ZEALAND wellington new zealand BRITISH RN 1769-09-01 1769-10-07 36 37
ENDEAVOUR 1771-01-17 JAVA jakarta indonesia CAPE OF GOOD HOPE cape of good hope south africa BRITISH RN 1771-01-17 1771-03-12 54 55
ENDEAVOUR 1771-04-17 CAPE OF GOOD HOPE cape of good hope south africa UK spithead uk BRITISH RN 1771-04-17 1771-07-10 84 81
RESOLUTION 1772-07-13 PLYMOUTH plymouth uk NEW ZEALAND wellington new zealand BRITISH RN 1772-07-14 1773-03-25 254 208
RESOLUTION 1773-06-09 NEW ZEALAND wellington new zealand TAHITI papeete french polynesia BRITISH RN 1773-06-10 1773-08-15 66 67
RESOLUTION 1773-09-18 TAHITI papeete french polynesia TONGA tongatapu tonga BRITISH RN 1773-09-18 1773-09-30 12 13
RESOLUTION 1773-10-08 PYLSTAERT (NR TONGA) tongatapu tonga NEW ZEALAND wellington new zealand BRITISH RN 1773-10-08 1773-10-21 13 14
RESOLUTION 1773-11-27 CAPE PALLISSER NEW ZEALAND wellington new zealand EASTER ISLAND easter island chile BRITISH RN 1773-11-27 1774-03-11 104 105
RESOLUTION 1774-03-18 EASTER ISLAND easter island chile MARQUESAS marquesas french polynesia BRITISH RN 1774-03-18 1774-04-06 19 19
RESOLUTION 1774-04-13 MARQUESAS marquesas french polynesia TAHITI papeete french polynesia BRITISH RN 1774-04-13 1774-04-22 9 10
RESOLUTION 1774-06-05 TAHITI papeete french polynesia TONGA tongatapu tonga BRITISH RN 1774-06-05 1774-06-21 16 17
RESOLUTION 1774-10-12 NEW CALEDONIA new caledonia french polynesia NEW ZEALAND wellington new zealand BRITISH RN 1774-10-12 1774-10-17 5 6
RESOLUTION 1774-11-11 NEW ZEALAND wellington new zealand TOWARDS CAPE HORN strait of magellan chile BRITISH RN 1774-11-12 1774-12-17 35 34
2 ships and 17 voyages; ships from 1 nationalities