Changeset: 5c6c57c9923a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5c6c57c9923a Modified Files: sql/benchmarks/VOC/voc_dump.sql sql/benchmarks/moa/load1.sql sql/test/ADT2006/benesamo.sql sql/test/BugDay_2005-10-06_2.9.3/Tests/UNION_JOIN_vs_plain_set_UNION-2.SF-920585.sql sql/test/BugTracker-2010/Tests/multiple-common-table-expressions.Bug-2664.sql sql/test/BugTracker-2012/Tests/strange_escaping_in_csv.Bug-2133.sql sql/test/BugTracker-2012/Tests/strange_escaping_in_csv.Bug-2133.stable.out sql/test/BugTracker-2012/Tests/time-export-bug.Bug-2963.sql sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.sql sql/test/BugTracker-2013/Tests/median-null.Bug-3280.sql sql/test/BugTracker-2014/Tests/null_in_string.Bug-2014.sql sql/test/BugTracker-2015/Tests/is_null_limit.Bug-3684.sql sql/test/BugTracker-2017/Tests/semijoinunion.Bug-6150.sql sql/test/VOC/VOCinsert.sql sql/test/bugs/escape_quote-bug-sf-1006469.sql sql/test/copy/Tests/int_parse.sql sql/test/copy/Tests/int_parse.stable.err sql/test/copy/Tests/int_parse_best.sql sql/test/copy/Tests/key_copy.sql sql/test/copy/Tests/key_copy.stable.err sql/test/sql_xml/load.sql Branch: default Log Message:
Use '' to get a single ' into a '-delimited string. Do not use \' for that. diffs (truncated from 5049 to 300 lines): diff --git a/sql/benchmarks/VOC/voc_dump.sql b/sql/benchmarks/VOC/voc_dump.sql --- a/sql/benchmarks/VOC/voc_dump.sql +++ b/sql/benchmarks/VOC/voc_dump.sql @@ -78,7 +78,7 @@ INSERT INTO "voyages" VALUES (66, '', 1, INSERT INTO "voyages" VALUES (67, '', 1, '', 'TER GOES', 'Marten Jelisz. Spanjaard', 240, NULL, NULL, NULL, NULL, NULL, 'Z', '1602-03-31', 'Wielingen', NULL, NULL, true, '1602-11-28', 'Ceylon', 5059, 'fleet of Van Warwyck. The three ships of Zeeland preceded the rest of the fleet. Took on provisions in the Bay of Antongil.'); INSERT INTO "voyages" VALUES (68, '', 1, '', 'VLISSINGEN', 'Laurens Fransz. van Vlissingen', 400, NULL, NULL, NULL, NULL, NULL, 'Z', '1602-03-31', 'Wielingen', NULL, NULL, true, '1602-11-28', 'Ceylon', 5070, NULL); INSERT INTO "voyages" VALUES (69, '', 1, '', 'ZIERIKZEE', 'Govert Jansz.', 760, NULL, NULL, NULL, NULL, NULL, 'Z', '1602-03-31', 'Wielingen', NULL, NULL, true, '1602-11-28', 'Ceylon', 5061, NULL); -INSERT INTO "voyages" VALUES (70, '', 1, '', 'MAAGD VAN ENKHUIZEN', 'Kornelis Pietersz.', 320, NULL, NULL, NULL, NULL, NULL, 'E', '1602-06-17', 'Texel', NULL, NULL, true, '1603-04-29', 'Bantam', 5047, 'The equipment (0070-0081) of the `Fourteen ships\' (without the jacht PAPEGAAITJE) under admiraal Wybrand van Warwyck on the MAURITIUS.From June 24th till July 10th the fleet lay off Plymouth; from October 11th till 21th off Annabon; and was on December 12th near the Cape. December 14th the HOLLAND, the HOLLANDSE TUIN and the STER left the main fleet, and set sail for Atjeh, the remainder sailed for Bantam.'); +INSERT INTO "voyages" VALUES (70, '', 1, '', 'MAAGD VAN ENKHUIZEN', 'Kornelis Pietersz.', 320, NULL, NULL, NULL, NULL, NULL, 'E', '1602-06-17', 'Texel', NULL, NULL, true, '1603-04-29', 'Bantam', 5047, 'The equipment (0070-0081) of the `Fourteen ships'' (without the jacht PAPEGAAITJE) under admiraal Wybrand van Warwyck on the MAURITIUS.From June 24th till July 10th the fleet lay off Plymouth; from October 11th till 21th off Annabon; and was on December 12th near the Cape. December 14th the HOLLAND, the HOLLANDSE TUIN and the STER left the main fleet, and set sail for Atjeh, the remainder sailed for Bantam.'); INSERT INTO "voyages" VALUES (71, '', 1, '', 'HOLLANDIA', 'Dirk Gerritsz. van Hoorn', 600, NULL, NULL, NULL, NULL, 'A', 'A', '1602-06-17', 'Texel', NULL, NULL, true, '1603-03-10', 'Atjeh', 5069, NULL); INSERT INTO "voyages" VALUES (72, '', 1, '', 'MAAN', 'Jan Kornelisz. Melknap', 500, NULL, NULL, NULL, NULL, NULL, 'A', '1602-06-17', 'Texel', NULL, NULL, true, '1603-04-29', 'Bantam', NULL, NULL); INSERT INTO "voyages" VALUES (73, '', 1, '', 'MAURITIUS', 'Pieter Kornelisz. van Petten', 700, NULL, NULL, NULL, NULL, NULL, 'A', '1602-06-17', 'Texel', NULL, NULL, true, '1603-04-29', 'Bantam', 5052, NULL); @@ -132,7 +132,7 @@ INSERT INTO "voyages" VALUES (120, '', 2 INSERT INTO "voyages" VALUES (121, '', 2, '', 'AMSTERDAM', 'Pieter Gerritsz.', 700, NULL, NULL, NULL, NULL, 'A', 'A', '1607-12-22', 'Texel', NULL, NULL, true, '1608-09-18', 'Goa', NULL, 'Captured by the Spaniards off Manilla, 25-04-1610.'); INSERT INTO "voyages" VALUES (122, '', 1, '', 'AREND', 'Rutger Thomasz.', 140, 'jacht', NULL, NULL, NULL, 'A', 'A', '1607-12-22', 'Texel', NULL, NULL, true, '1608-09-18', 'Goa', NULL, 'Captured and burnt by the Spaniards off Manilla 25-04-1610.'); INSERT INTO "voyages" VALUES (123, '', 1, '', 'DELFT', 'Simon Maartensz. (Zwarte Simon)', 800, NULL, NULL, NULL, NULL, 'D', 'D', '1607-12-22', 'Goeree', NULL, NULL, true, '1608-09-18', 'Goa', 5094, NULL); -INSERT INTO "voyages" VALUES (124, '', 1, '', 'GRIFFIOEN', 'Kornelis Kornelisz. \'t Hert', 140, 'jacht', NULL, NULL, NULL, 'R', 'R', '1607-12-22', 'Goeree', NULL, NULL, true, '1608-09-18', 'Goa', NULL, 'The ship stayed in the Indies.'); +INSERT INTO "voyages" VALUES (124, '', 1, '', 'GRIFFIOEN', 'Kornelis Kornelisz. ''t Hert', 140, 'jacht', NULL, NULL, NULL, 'R', 'R', '1607-12-22', 'Goeree', NULL, NULL, true, '1608-09-18', 'Goa', NULL, 'The ship stayed in the Indies.'); INSERT INTO "voyages" VALUES (125, '', 2, '', 'HOLLANDIA', 'Simon Jansz. Hoen', 800, NULL, NULL, NULL, NULL, 'A', 'A', '1607-12-22', 'Texel', NULL, NULL, true, '1608-09-18', 'Goa', 5097, 'illemsz. Verhoeff aboard the GEUNIEERDE PROVINCIEN and vice-adm. Frans Hendriksz. Wittert aboard the MIDDELBURG. The 3 Zeeland ships and the mainfleet met at Maio I. February 1608; from 15-05 till 02-06 at St. Helena; 28-06 somewhere in the regions off the Cape; from 28-06 till 23-08 the fleet started operations against the Portuguese at Mozambique; from 18-09 till 02-10 off Goa.'); INSERT INTO "voyages" VALUES (126, '', 2, '', 'HOORN', 'Maarten Jansz. Kloot', 700, NULL, NULL, NULL, NULL, 'H', 'H', '1607-12-22', 'Texel', NULL, NULL, true, '1608-09-18', 'Goa', 5091, NULL); INSERT INTO "voyages" VALUES (127, '', 1, '', 'RODE LEEUW MET PIJLEN', 'Jan Walijchsz.', 400, NULL, NULL, NULL, NULL, 'A', 'A', '1607-12-22', 'Texel', NULL, NULL, true, '1608-09-18', 'Goa', 5089, NULL); @@ -140,20 +140,20 @@ INSERT INTO "voyages" VALUES (128, '', 1 INSERT INTO "voyages" VALUES (129, '', 2, '', 'GEUNIEERDE PROVINCIEN', 'Frans Jakobsz. de Vries', 700, NULL, NULL, NULL, NULL, 'A', 'A', '1607-12-22', 'Texel', NULL, NULL, true, '1608-09-19', 'Goa', 5092, 'May 22th 1609 Frans Jakobsz. de Vries was murdered by the inhabitants of Banda.'); INSERT INTO "voyages" VALUES (130, '', 2, '', 'ROTTERDAM', 'Jan Kornelisz. de Wit', 800, NULL, NULL, NULL, NULL, 'R', 'R', '1607-12-22', 'Goeree', NULL, NULL, true, '1608-09-19', 'Goa', 5090, NULL); -INSERT INTO "voyages" VALUES (131, '', 2, '', 'MEDEMBLIK', 'Jacques l\'Hermite', 250, 'jacht', NULL, NULL, NULL, NULL, 'A', '1608-01-01', 'Texel', NULL, NULL, true, NULL, 'Bantam', NULL, 'The ship was despatched to bring news of the forthcoming Twelve Years\' Truce; stayed in the Indies and was wrecked near the Maledive Islands.'); +INSERT INTO "voyages" VALUES (131, '', 2, '', 'MEDEMBLIK', 'Jacques l''Hermite', 250, 'jacht', NULL, NULL, NULL, NULL, 'A', '1608-01-01', 'Texel', NULL, NULL, true, NULL, 'Bantam', NULL, 'The ship was despatched to bring news of the forthcoming Twelve Years'' Truce; stayed in the Indies and was wrecked near the Maledive Islands.'); INSERT INTO "voyages" VALUES (132, '', 1, '', 'HOOP', 'Pieter Heeresz.', 80, 'jacht', NULL, NULL, NULL, 'A', 'A', '1608-04-15', 'Texel', NULL, NULL, true, '1608-12-26', 'Bantam', NULL, 'Captured by the Spaniards near Manila, 15-07-1610.'); -INSERT INTO "voyages" VALUES (133, '', 1, '', 'HALVE MAAN', 'Henry Hudson', 80, 'jacht', NULL, NULL, NULL, 'A', 'A', '1609-04-06', 'Texel', NULL, NULL, true, NULL, NULL, NULL, 'Destined to explore the North-East passage to the Indies; discovered Hudson Bay and returned 07-12 in Dartmouth. Further information see I\'Honore Naber.'); +INSERT INTO "voyages" VALUES (133, '', 1, '', 'HALVE MAAN', 'Henry Hudson', 80, 'jacht', NULL, NULL, NULL, 'A', 'A', '1609-04-06', 'Texel', NULL, NULL, true, NULL, NULL, NULL, 'Destined to explore the North-East passage to the Indies; discovered Hudson Bay and returned 07-12 in Dartmouth. Further information see I''Honore Naber.'); INSERT INTO "voyages" VALUES (134, '', 1, '', 'HAZEWIND', 'Wemmer van Berchem', 120, 'jacht', NULL, NULL, NULL, 'E', 'E', '1609-08-01', 'Texel', NULL, NULL, true, '1610-10-01', 'Bantam', NULL, 'left Lissabon 05-02-1610, rounded the Cape 04-05, took on provisions from 25-06 till 06-07 at Madagascar. It stayed in the Indies.'); INSERT INTO "voyages" VALUES (135, '', 1, '', 'WAPEN VAN AMSTERDAM', 'Dirk Pietersz. Kalf', 800, NULL, NULL, NULL, NULL, 'A', 'A', '1610-01-30', 'Texel', '1610-06-28', '1610-08-10', true, '1610-12-19', 'Bantam', 5099, 'scattered the fleet; from 19-09 till 16-10 the WAPEN VAN AMSTERDAM took on provisions at Mauritius.'); INSERT INTO "voyages" VALUES (136, '', 1, '', 'BRAK', 'Jakob IJsbrandsz.', 100, 'jacht', NULL, NULL, NULL, NULL, 'E', '1610-01-30', 'Texel', NULL, NULL, true, NULL, 'Bantam', NULL, 'The BRAK lost sight of the fleet at 23-06; 03-08 at Mauritius. At 07-08-1613 the ship sailed aground near Macassar and was lost.'); INSERT INTO "voyages" VALUES (137, '', 2, '', 'CEYLON', 'Dirk Gerritsz. Smient', 340, NULL, NULL, NULL, NULL, 'A', 'A', '1610-01-30', 'Texel', NULL, NULL, true, '1610-08-08', 'Mauritius', 5093, 'The CEYLON lost sight of the fleet 03-07.'); INSERT INTO "voyages" VALUES (138, '', 2, '', 'TER GOES', 'Kornelis Reiniersz.', 240, NULL, NULL, NULL, NULL, 'Z', 'Z', '1610-01-30', 'Wielingen', NULL, NULL, true, '1610-12-10', 'Bantam', NULL, 'Lost sight of the fleet; from 30-07 till 02-08 at the Bay of Antipara; 02-08 in the St. Lucia Bay, where it took over the remaining cargo of the MAURITIUS (5077); 21-08 departure from Madagascar via the Bay of Antongil; from 27-10 till 08-12 at Mauritius.'); -INSERT INTO "voyages" VALUES (139, '', 3, '', 'WITTE LEEUW', 'Klaas Rutgersz. Smit', 540, 'jacht', NULL, NULL, NULL, 'A', 'A', '1610-01-30', 'Texel', NULL, NULL, true, '1610-11-16', 'Bantam', 5100, 'Lost sight of the fleet; from 24-07 till 03-08 in the `Verhagensbaai\'; from 29-08 till 27-09 at Mayotte.'); +INSERT INTO "voyages" VALUES (139, '', 3, '', 'WITTE LEEUW', 'Klaas Rutgersz. Smit', 540, 'jacht', NULL, NULL, NULL, 'A', 'A', '1610-01-30', 'Texel', NULL, NULL, true, '1610-11-16', 'Bantam', 5100, 'Lost sight of the fleet; from 24-07 till 03-08 in the `Verhagensbaai''; from 29-08 till 27-09 at Mayotte.'); INSERT INTO "voyages" VALUES (140, '', 2, '', 'ZWARTE LEEUW', 'Kornelis Dirksz. Worst', 600, NULL, NULL, NULL, NULL, 'A', 'A', '1610-01-30', 'Texel', NULL, NULL, true, '1610-11-16', 'Bantam', 5102, 'See 0139.'); INSERT INTO "voyages" VALUES (141, '', 2, '', 'ORANJE', 'Kornelis Riemland', 700, NULL, NULL, NULL, NULL, 'A', 'Z', '1610-01-30', 'Wielingen', NULL, NULL, true, '1610-11-16', 'Bantam', 5095, 'See 0139.'); -INSERT INTO "voyages" VALUES (142, '', 1, '', 'VLISSINGEN', 'Jan Kornelisz. \'t Hert', 600, NULL, NULL, NULL, NULL, 'Z', 'Z', '1610-01-30', 'Wielingen', NULL, NULL, true, '1610-11-16', 'Bantam', 5101, 'See 0139.'); -INSERT INTO "voyages" VALUES (143, '', 3, '', 'GOUDA', 'Albert Hermansz.', 260, NULL, NULL, NULL, NULL, 'A', 'A', '1610-12-28', 'Texel', '1611-06-04', NULL, true, '1611-08-24', 'Bantam', NULL, 'Fleet (0143-0144) under the command of Hendrik Brouwer aboard the RODE LEEUW MET PIJLEN sailed the southern passage for the first time (latitude ca. 36\' south), which was made obligatory in 1616. The GOUDA was captured by the Spaniards near Tidore, 04-05-1612.'); -INSERT INTO "voyages" VALUES (144, '', 2, '', 'RODE LEEUW MET PULEN', 'Kornelis Maartensz. \'t Kind', 400, NULL, NULL, NULL, NULL, 'A', 'A', '1610-12-28', 'Texel', '1611-06-04', NULL, true, '1611-08-18', 'Bantam', NULL, 'unseaworthiness, abandoned by its crew and set on fire, August 1615.'); +INSERT INTO "voyages" VALUES (142, '', 1, '', 'VLISSINGEN', 'Jan Kornelisz. ''t Hert', 600, NULL, NULL, NULL, NULL, 'Z', 'Z', '1610-01-30', 'Wielingen', NULL, NULL, true, '1610-11-16', 'Bantam', 5101, 'See 0139.'); +INSERT INTO "voyages" VALUES (143, '', 3, '', 'GOUDA', 'Albert Hermansz.', 260, NULL, NULL, NULL, NULL, 'A', 'A', '1610-12-28', 'Texel', '1611-06-04', NULL, true, '1611-08-24', 'Bantam', NULL, 'Fleet (0143-0144) under the command of Hendrik Brouwer aboard the RODE LEEUW MET PIJLEN sailed the southern passage for the first time (latitude ca. 36'' south), which was made obligatory in 1616. The GOUDA was captured by the Spaniards near Tidore, 04-05-1612.'); +INSERT INTO "voyages" VALUES (144, '', 2, '', 'RODE LEEUW MET PULEN', 'Kornelis Maartensz. ''t Kind', 400, NULL, NULL, NULL, NULL, 'A', 'A', '1610-12-28', 'Texel', '1611-06-04', NULL, true, '1611-08-18', 'Bantam', NULL, 'unseaworthiness, abandoned by its crew and set on fire, August 1615.'); INSERT INTO "voyages" VALUES (145, '', 2, '', 'TER VEERE', 'Willem Jakobsz. van Arnemuiden', 700, NULL, NULL, NULL, NULL, 'Z', 'Z', '1610-12-28', 'Wielingen', NULL, NULL, true, '1611-09-05', 'Bantam', 5103, NULL); INSERT INTO "voyages" VALUES (146, '', 2, '', 'BANDA', 'Roelof Thijsz.', 800, NULL, NULL, NULL, NULL, NULL, 'A', '1611-03-16', 'Texel', NULL, NULL, true, '1612-02-02', 'Bantam', 5105, 'in St. Lucia Bay; from 15-12 till 23-12 at Mauritius. According to Commelin the master of the BANDA was Roelof Harmensz.'); INSERT INTO "voyages" VALUES (147, '', 2, '', 'BANTAM', 'Kornelis Arendse', 900, NULL, NULL, NULL, NULL, NULL, 'E', '1611-05-02', 'Texel', NULL, NULL, true, '1612-03-02', 'Bantam', 5098, NULL); @@ -211,9 +211,9 @@ INSERT INTO "voyages" VALUES (197, '', 1 INSERT INTO "voyages" VALUES (198, '', 1, '', 'GOUDEN LEEUW', 'Gheen Huigen Schapenham', 550, NULL, NULL, NULL, NULL, 'R', 'R', '1616-01-21', 'Maas', '1616-09-09', '1616-09-18', true, '1616-11-14', 'Bantam', 5134, 'Maio Island; 28-03 departure from Cabo de Lopez Gonsalvez; from 19-06 till 09-07 at Annabon.'); INSERT INTO "voyages" VALUES (199, '', 1, '', 'WESTFRIESLAND', 'Kornelis Fransz. van der Beets', 800, NULL, '1615', NULL, NULL, 'H', 'H', '1616-01-22', 'Texel', '1616-09-09', '1616-09-18', true, '1616-11-14', 'Bantam', 5119, 'From 21-02 till 04-03 Maio Island; 28-03-1616 departure from Cabo de Lopez Gonsalvez; from 19-06 till 09-07 at Annabon.'); INSERT INTO "voyages" VALUES (200, '', 1, '', 'BANTAM', 'Douwe Anthonisz.', 800, NULL, NULL, NULL, NULL, NULL, 'E', '1616-01-23', 'Texel', NULL, NULL, true, '1616-10-24', 'Bantam', NULL, 'Island; from 27-03 till 11-06 at Cabo de Lopez Gonsalvez; from 18-06 till 29-06 at Annabon. Burnt at Batavia 24-03-1627.'); -INSERT INTO "voyages" VALUES (201, '', 1, '', 'EENDRACHT', 'Dirk Hartogs van Amsterdam', 700, NULL, NULL, NULL, NULL, 'A', 'A', '1616-01-23', 'Texel', '1616-08-05', '1616-08-27', true, '1616-12-14', 'Macassar', 5122, 'From 21-02 till 04-03 at Maio Island; from 27-03 till 11-05 at Cape Lopez; landed on the West Coast of Australia (27\' South), October 25th.'); +INSERT INTO "voyages" VALUES (201, '', 1, '', 'EENDRACHT', 'Dirk Hartogs van Amsterdam', 700, NULL, NULL, NULL, NULL, 'A', 'A', '1616-01-23', 'Texel', '1616-08-05', '1616-08-27', true, '1616-12-14', 'Macassar', 5122, 'From 21-02 till 04-03 at Maio Island; from 27-03 till 11-05 at Cape Lopez; landed on the West Coast of Australia (27'' South), October 25th.'); INSERT INTO "voyages" VALUES (202, '', 1, '', 'TROUW', 'Gerrit Douwesz. van Medemblik', 500, NULL, NULL, NULL, NULL, 'A', 'A', '1616-01-23', 'Texel', NULL, NULL, true, '1616-10-19', 'Bantam', NULL, 'Like EENDRACHT at Maio Island and Cape Lopez; from 18-05 till 29-05 at Annabon; August 14th somewhere off the Cape, took Southern passage. The ship stayed in the Indies and was thrown on the beach near Kalongan, 31-12-1624.'); -INSERT INTO "voyages" VALUES (203, '', 1, '', 'WAPEN VAN ZEELAND', 'Jakob Pankras van Vlissingen', 700, NULL, NULL, NULL, NULL, 'Z', 'Z', '1616-02-07', 'Wielingen', NULL, NULL, true, '1617-04-09', 'Bantam', 5126, 'Reprovisioned at Annabon; via `Verhagensbaai\' to the Primeira Islands, and back to the `Verhagensbaai.\''); +INSERT INTO "voyages" VALUES (203, '', 1, '', 'WAPEN VAN ZEELAND', 'Jakob Pankras van Vlissingen', 700, NULL, NULL, NULL, NULL, 'Z', 'Z', '1616-02-07', 'Wielingen', NULL, NULL, true, '1617-04-09', 'Bantam', 5126, 'Reprovisioned at Annabon; via `Verhagensbaai'' to the Primeira Islands, and back to the `Verhagensbaai.'''); INSERT INTO "voyages" VALUES (204, '', 2, '', 'HERT', 'Jan Kornelisz. Kunst', 280, 'jacht', NULL, NULL, NULL, 'R', 'D', '1616-03-19', 'Goeree', '1616-06-10', '1616-07-03', true, '1616-08-27', 'Bantam', 5116, 'Reprovisioned at the Cape.'); INSERT INTO "voyages" VALUES (205, '', 2, '', 'ORANJEBOOM', 'Pieter Barendsz. van Hoorn', 360, 'jacht', NULL, NULL, NULL, 'H', 'H', '1616-04-23', 'Texel', '1616-10-20', '1616-11-01', true, '1617-04-09', 'Bantam', 5120, 'Mauritius.'); INSERT INTO "voyages" VALUES (206, '', 1, '', 'EENHOORN', NULL, 300, 'jacht', NULL, NULL, NULL, 'A', 'A', '1617-02-26', 'Texel', '1617-07-05', '1617-07-18', true, '1617-10-23', 'Bantam', 5125, NULL); @@ -228,24 +228,24 @@ INSERT INTO "voyages" VALUES (214, '', 2 INSERT INTO "voyages" VALUES (215, '', 2, '', 'DOLFIJN', 'Bruin Anthonisz.', 260, 'jacht', NULL, NULL, NULL, 'Z', 'Z', '1617-11-07', 'Wielingen', NULL, NULL, true, '1618-09-20', 'Masulipatna', NULL, 'Stayed in the Indies and, laid up between 1620-1621.'); INSERT INTO "voyages" VALUES (216, '', 1, '', 'TER THOLEN', 'Adriaan de Walle', 400, 'jacht', NULL, NULL, NULL, 'Z', 'Z', '1617-11-07', 'Wielingen', NULL, NULL, true, '1618-04-30', 'Bantam', 5129, 'Amsterdam Isl. sighted by the Dutch for the first time.'); INSERT INTO "voyages" VALUES (217, '', 1, '', 'ZEEWOLF', 'Havik Klaasz. van Hillegom', 360, 'jacht', NULL, NULL, NULL, 'A', 'A', '1617-12-02', 'Texel', '1618-03-08', '1618-03-24', true, '1618-07-01', 'Jacatra', NULL, 'April 19th St. Paul sighted by the Dutch for the first time. May 11th on the west coast of Australia. The ship stayed in the Indies.'); -INSERT INTO "voyages" VALUES (218, '', 2, '', 'MAURITIUS', 'Leendert Jakobsz.', 800, NULL, '1612', NULL, NULL, 'A', 'A', '1618-01-04', 'Texel', NULL, NULL, true, '1618-08-22', 'Bantam', 5131, 'July 1618 on the west coast of Australia (Eendrachtsland, 22\' South).'); +INSERT INTO "voyages" VALUES (218, '', 2, '', 'MAURITIUS', 'Leendert Jakobsz.', 800, NULL, '1612', NULL, NULL, 'A', 'A', '1618-01-04', 'Texel', NULL, NULL, true, '1618-08-22', 'Bantam', 5131, 'July 1618 on the west coast of Australia (Eendrachtsland, 22'' South).'); INSERT INTO "voyages" VALUES (219, '', 3, '', 'DELFT', 'Jan Kornelisz. Kunst', 800, NULL, NULL, NULL, NULL, 'D', 'D', '1618-04-01', 'Goeree', NULL, NULL, true, '1618-10-13', 'Bantam', 5132, NULL); INSERT INTO "voyages" VALUES (220, '', 1, '', 'WAPEN VAN HAARLEM', 'Willem Jansz. van Amersfoort', 360, 'jacht', NULL, NULL, NULL, NULL, 'A', '1618-05-04', 'Texel', NULL, NULL, true, NULL, 'Bantam', NULL, 'the KLEIN AMSTER-DAM. The ship stayed in the Indies and was laid up between 31-10-1627 and 31-10-1628.'); INSERT INTO "voyages" VALUES (221, '', 3, '', 'HERT', 'Quinten Pietersz. Wiltvank', 280, 'jacht', NULL, NULL, NULL, 'R', 'R', '1618-06-01', 'Goeree', NULL, NULL, true, '1619-01-16', 'Bantam', NULL, 'Stayed in the Indies; wrecked on the African coast 21-06-1622.'); INSERT INTO "voyages" VALUES (222, '', 2, '', 'WESTFRIESLAND', 'Abbe Willemsz.', 800, NULL, '1615', NULL, NULL, 'H', 'Z', '1618-12-05', 'Wielingen', NULL, NULL, true, '1619-09-13', 'Jacatra', 5138, 'it NASSAU.'); INSERT INTO "voyages" VALUES (223, '', 1, '', 'DORDRECHT', 'Reinier Jansz.', 800, NULL, NULL, NULL, NULL, NULL, 'A', '1618-12-28', 'Texel', '1619-05-17', '1619-06-08', true, '1619-09-03', 'Bantam', 5136, 'Fleet (0223-0232) under command of Frederik de Houtman aboard the DORDRECHT and Jakob Dedel. T otal number of those on board: seamen 1725; soldiers 675.'); -INSERT INTO "voyages" VALUES (224, '', 2, '', 'EENHOORN', 'Klaas Egbertsz.', 300, 'jacht', NULL, NULL, NULL, 'A', 'A', '1618-12-28', 'Texel', '1619-04-01', '1619-04-30', true, '1619-07-06', 'Bantam', 5133, '19th, the DORDRECHT struck upon the west coast of Australia (32\'20\' South).'); +INSERT INTO "voyages" VALUES (224, '', 2, '', 'EENHOORN', 'Klaas Egbertsz.', 300, 'jacht', NULL, NULL, NULL, 'A', 'A', '1618-12-28', 'Texel', '1619-04-01', '1619-04-30', true, '1619-07-06', 'Bantam', 5133, '19th, the DORDRECHT struck upon the west coast of Australia (32''20'' South).'); INSERT INTO "voyages" VALUES (225, '', 2, '', 'ENKHUIZEN', NULL, 500, NULL, NULL, NULL, NULL, NULL, 'E', '1618-12-28', 'Texel', NULL, NULL, false, NULL, 'Coromandel', NULL, 'From 25-02 till 02-03 at Brava Island. The ship stayed in the Indies.'); INSERT INTO "voyages" VALUES (226, '', 1, '', 'HOORN', 'Willem Usbrand Bontekoe', 700, NULL, NULL, NULL, NULL, 'H', 'H', '1618-12-28', 'Texel', NULL, NULL, false, NULL, NULL, NULL, 'west of Sumatra the ship caught fire and was blown up; on 14-12-1619 the sloop of the HOORN arrived with the survivors at Bantam.'); INSERT INTO "voyages" VALUES (227, '', 1, '', 'GOEDE HOOP', 'Jan van der Venne', 600, 'jacht', NULL, NULL, NULL, 'A', 'A', '1618-12-28', 'Texel', '1619-11-19', '1619-11-26', true, '1620-02-09', 'Jacatra', NULL, 'Forced by heavy weather in the Bay of Biscay the GOEDE HOOP returned to Zeeland and departed again 13-05-1619; from 14-08 till 21-08 at Cape Lopez.'); INSERT INTO "voyages" VALUES (228, '', 2, '', 'POSTPAARD', 'Jan Jansz. Rood', 300, 'jacht', NULL, NULL, NULL, 'E', 'A', '1618-12-28', 'Texel', NULL, NULL, true, '1619-09-19', 'Jacatra', NULL, 'Stayed in the Indies and laid up in 1623.'); INSERT INTO "voyages" VALUES (229, '', 2, '', 'ZEELANDIA', 'Jan van Meldert', 800, NULL, NULL, NULL, NULL, 'Z', 'A', '1618-12-28', 'Wielingen', NULL, NULL, false, '1619-09-16', 'Jacatra', NULL, 'From 07-01 till 26-01 at Plymouth, where 3 man deserted; from 25-02 till 02-03 at Bravo Island; from 03-07 till 17-07 near St. Maria (Madagascar). The ship stayed in the Indies and was wrecked on the Westcoast of Sumatra. Also mentioned as NIEUW ZEELAND.'); INSERT INTO "voyages" VALUES (230, '', 3, '', 'ORANJEBOOM', NULL, 360, 'jacht', NULL, NULL, NULL, 'H', 'R', '1619-01-25', 'Goeree', '1619-04-01', '1619-04-30', true, '1619-08-07', 'Jacatra', 5137, NULL); -INSERT INTO "voyages" VALUES (231, '', 1, '', 'AMSTERDAM', 'Maarten Kornelisz.', 800, NULL, NULL, NULL, NULL, 'A', 'A', '1619-01-27', 'Texel', '1619-05-20', '1619-06-08', true, '1619-09-03', 'Bantam', NULL, 'June 19th on the west coast of Australia (37\'20\' South); the ship stayed in the Indies.'); +INSERT INTO "voyages" VALUES (231, '', 1, '', 'AMSTERDAM', 'Maarten Kornelisz.', 800, NULL, NULL, NULL, NULL, 'A', 'A', '1619-01-27', 'Texel', '1619-05-20', '1619-06-08', true, '1619-09-03', 'Bantam', NULL, 'June 19th on the west coast of Australia (37''20'' South); the ship stayed in the Indies.'); INSERT INTO "voyages" VALUES (232, '', 2, '', 'WAPEN VAN ZEELAND', 'Pieter Barendsz.', 700, NULL, NULL, NULL, NULL, 'Z', 'Z', '1619-01-27', 'Wielingen', NULL, NULL, true, '1619-08-07', 'Bantam', NULL, 'Stayed in the Indies and laid up in Surat 1626/1627.'); INSERT INTO "voyages" VALUES (233, '', 3, '', 'WITTE BEER', 'Klaas Warebouts', 300, 'jacht', '1614', NULL, NULL, 'A', 'A', '1619-05-13', 'Texel', NULL, NULL, true, '1620-01-28', 'Bantam', 5139, 'From 20-08 till 01-09 at Cape Lopez; from 08-02 till 11-02 at Annabon.'); INSERT INTO "voyages" VALUES (234, '', 2, '', 'EENDRACHT', NULL, 700, NULL, NULL, NULL, NULL, 'A', 'A', '1619-05-13', 'Texel', '1619-11-19', '1619-11-26', true, '1620-03-22', 'Jacatra', NULL, 'From 14-08 till 21-08 at Cape Lopez. The ship stayed in the Indies and was wrecked on the west coast of Ambon, 13-05-1622.'); -INSERT INTO "voyages" VALUES (235, '', 2, '', 'GOEDE FORTUIN', 'Jan Gijsbertsz. Booneter', 700, NULL, NULL, NULL, NULL, 'A', 'A', '1619-05-13', 'Texel', '1620-01-05', '1620-02-25', true, '1620-07-27', 'Jacatra', NULL, 'From 02-10 till 11-10 at Cape Lopez; February 5th with the GOUDEN LEEUW to the `Dasseneiland\' and St. Helena; from 15-02 till 25-02 at St. Helena. The ship stayed in the Indies and was lost near Sucatara; crew and cargo were saved.'); +INSERT INTO "voyages" VALUES (235, '', 2, '', 'GOEDE FORTUIN', 'Jan Gijsbertsz. Booneter', 700, NULL, NULL, NULL, NULL, 'A', 'A', '1619-05-13', 'Texel', '1620-01-05', '1620-02-25', true, '1620-07-27', 'Jacatra', NULL, 'From 02-10 till 11-10 at Cape Lopez; February 5th with the GOUDEN LEEUW to the `Dasseneiland'' and St. Helena; from 15-02 till 25-02 at St. Helena. The ship stayed in the Indies and was lost near Sucatara; crew and cargo were saved.'); INSERT INTO "voyages" VALUES (236, '', 2, '', 'TER THOLEN', 'Adriaan de Walle', 400, 'jacht', NULL, NULL, NULL, 'Z', 'Z', '1619-05-16', 'Wielingen', NULL, NULL, true, '1619-11-20', 'Bantam', 5166, NULL); INSERT INTO "voyages" VALUES (237, '', 2, '', 'WALCHEREN', 'Adriaan Boei', 500, NULL, '1612', NULL, NULL, 'Z', 'Z', '1619-05-16', 'Wielingen', NULL, NULL, true, '1619-12-01', 'Bantam', 5141, 'Forced to return to Zeeland, 11 -06-1619, but sailed again shortly afterwards.'); INSERT INTO "voyages" VALUES (238, '', 1, '', 'VREDE', NULL, 340, 'jacht', NULL, NULL, NULL, 'A', 'A', '1619-09-14', 'Texel', NULL, NULL, true, '1620-06-03', 'Bantam', 5140, NULL); @@ -301,7 +301,7 @@ INSERT INTO "voyages" VALUES (287, '', 1 INSERT INTO "voyages" VALUES (288, '', 1, '', 'KLEINE ERASMUS', NULL, 240, NULL, NULL, NULL, NULL, NULL, 'R', '1622-04-22', 'Goeree', '1622-11-01', NULL, true, '1623-01-20', 'Batavia', NULL, 'Stayed in the Indies and lost in Japan, 1634.'); INSERT INTO "voyages" VALUES (289, '', 1, '', 'MAKREEL', NULL, 300, 'fluit', NULL, NULL, NULL, 'E', 'E', '1622-12-17', 'Texel', NULL, NULL, true, '1623-06-20', 'Batavia', NULL, 'Batavia between 31-10-1627 and 31-10 1628.'); INSERT INTO "voyages" VALUES (290, '', 2, '', 'MIDDELBURG', 'Jan Willemsz. Dik', 700, NULL, '1619', NULL, NULL, 'Z', 'Z', '1622-12-17', 'Wielingen', NULL, NULL, true, '1623-08-16', 'Batavia', 5170, NULL); -INSERT INTO "voyages" VALUES (291, '', 2, '', 'WAPEN VAN ENKHUIZEN', NULL, 700, NULL, '1619', NULL, NULL, 'E', 'E', '1623-01-20', 'Texel', '1623-05-04', NULL, true, '1623-08-16', 'Batavia', 5181, '21-07 on the west coast of Australia (27\').'); +INSERT INTO "voyages" VALUES (291, '', 2, '', 'WAPEN VAN ENKHUIZEN', NULL, 700, NULL, '1619', NULL, NULL, 'E', 'E', '1623-01-20', 'Texel', '1623-05-04', NULL, true, '1623-08-16', 'Batavia', 5181, '21-07 on the west coast of Australia (27'').'); INSERT INTO "voyages" VALUES (292, '', 2, '', 'LEIDEN', 'Klaas Hermansz.', 700, NULL, NULL, NULL, NULL, NULL, 'A', '1623-01-20', 'Texel', '1623-04-27', '1623-05-21', true, '1623-08-25', 'Batavia', NULL, 'Stayed in the Indies.'); INSERT INTO "voyages" VALUES (293, '', 2, '', 'MEDEMBLIK', NULL, 300, 'jacht', NULL, NULL, NULL, NULL, 'H', '1623-01-20', 'Texel', '1623-04-28', NULL, true, '1623-09-19', 'Coromandel', NULL, 'Stayed in the Indies.'); INSERT INTO "voyages" VALUES (294, '', 2, '', 'NAARDEN', NULL, 180, 'jacht', NULL, NULL, NULL, 'A', NULL, '1623-01-20', 'Texel', NULL, NULL, true, NULL, NULL, NULL, 'Wrecked near Boa Vista, 1623. Its destination was Surat.'); @@ -326,7 +326,7 @@ INSERT INTO "voyages" VALUES (312, '', 2 INSERT INTO "voyages" VALUES (313, '', 2, '', 'HAAS', NULL, 120, 'jacht', NULL, NULL, NULL, 'A', 'A', '1624-12-10', 'Texel', NULL, NULL, true, '1625-06-06', 'Batavia', NULL, 'The ship stayed in the Indies. According to Daghregister departure from the Maas, 31-12-1624.'); INSERT INTO "voyages" VALUES (314, '', 2, '', 'DELFSHAVEN', 'Jakob Pietersz. Hein', 400, 'jacht', '1621', NULL, NULL, 'D', 'D', '1625-01-04', 'Goeree', '1625-07-05', NULL, true, '1625-09-09', 'Pulicat', 5179, 'From 05-01 till 17-03-1625 in Vlissingen. T otal number of deaths: 3.'); INSERT INTO "voyages" VALUES (315, '', 2, '', 'HEUSDEN', NULL, 250, 'jacht', NULL, NULL, NULL, 'A', 'A', '1625-01-04', 'Texel', NULL, NULL, true, '1625-10-02', 'Surat', NULL, 'Stayed in the Indies.'); -INSERT INTO "voyages" VALUES (316, '', 1, '', 'KAMEEL', 'Reinier Saecq', 500, NULL, NULL, NULL, NULL, 'A', 'A', '1625-01-04', 'Texel', '1625-06-01', '1625-07-10', true, '1625-09-19', 'Batavia', NULL, 'Stayed in the Indies and was lost on `Boompjes-eiland\', 17-02-1630.'); +INSERT INTO "voyages" VALUES (316, '', 1, '', 'KAMEEL', 'Reinier Saecq', 500, NULL, NULL, NULL, NULL, 'A', 'A', '1625-01-04', 'Texel', '1625-06-01', '1625-07-10', true, '1625-09-19', 'Batavia', NULL, 'Stayed in the Indies and was lost on `Boompjes-eiland'', 17-02-1630.'); INSERT INTO "voyages" VALUES (317, '', 3, '', 'GOUDEN LEEUW', NULL, 550, NULL, NULL, NULL, NULL, 'R', 'A', '1625-01-04', 'Texel', NULL, NULL, true, '1625-10-02', 'Surat', 5184, NULL); INSERT INTO "voyages" VALUES (318, '', 5, '', 'MAURITIUS', 'Reinier Pels', 800, NULL, '1612', NULL, NULL, 'A', 'Z', '1625-01-04', 'Wielingen', '1625-06-01', '1625-07-10', true, '1625-10-03', 'Batavia', NULL, 'Stayed in the Indies.'); INSERT INTO "voyages" VALUES (319, '', 4, '', 'WALCHEREN', 'Pankras Anthonisz.', 500, NULL, '1612', NULL, NULL, 'Z', 'Z', '1625-01-04', 'Wielingen', NULL, NULL, true, '1625-10-03', 'Surat', 5186, NULL); @@ -371,7 +371,7 @@ INSERT INTO "voyages" VALUES (357, '', 3 INSERT INTO "voyages" VALUES (358, '', 1, '', 'TER VEERE', 'Denijs Anthonisz.', 350, NULL, NULL, NULL, NULL, 'Z', 'Z', '1627-11-18', 'Wielingen', '1628-03-01', '1628-06-01', true, '1628-07-28', 'Batavia', 5197, 'Reprovisioned at St. Lucia Bay.'); INSERT INTO "voyages" VALUES (359, '', 1, '', 'VLISSINGEN', 'Jakob Jansz. de Gans', 350, NULL, NULL, NULL, NULL, 'Z', 'Z', '1627-11-18', 'Wielingen', '1628-04-01', '1628-05-15', true, '1628-08-01', 'Batavia', 5198, NULL); INSERT INTO "voyages" VALUES (360, '', 1, '', 'ZEEBURG', 'Hendrik de Ruiter', 120, 'jacht', NULL, NULL, NULL, 'Z', 'Z', '1627-11-18', 'Wielingen', '1628-03-01', '1628-04-01', true, '1628-08-04', 'Batavia', NULL, 'Via Australia; stayed in the Indies and probably laid up,'); -INSERT INTO "voyages" VALUES (361, '', 3, '', 'SCHIEDAM', NULL, 360, NULL, NULL, NULL, NULL, 'D', 'A', '1628-01-24', 'Texel', '1628-05-24', '1628-06-07', true, '1628-08-30', 'Coromandel', NULL, 'Stayed in the Indies and lost on `Boompjes-eiland\', February 1633.'); +INSERT INTO "voyages" VALUES (361, '', 3, '', 'SCHIEDAM', NULL, 360, NULL, NULL, NULL, NULL, 'D', 'A', '1628-01-24', 'Texel', '1628-05-24', '1628-06-07', true, '1628-08-30', 'Coromandel', NULL, 'Stayed in the Indies and lost on `Boompjes-eiland'', February 1633.'); INSERT INTO "voyages" VALUES (362, '', 4, '', 'TER THOLEN', 'Mathijs Jansz. van Vlissingen', 400, 'jacht', NULL, NULL, NULL, 'Z', 'Z', '1628-05-01', 'Wielingen', NULL, NULL, true, '1629-02-06', 'Batavia', NULL, 'Indies.'); INSERT INTO "voyages" VALUES (363, '', 3, '', 'WAPEN VAN ENKHUIZEN', NULL, 700, NULL, '1619', NULL, NULL, 'E', 'E', '1628-05-12', 'Texel', NULL, NULL, true, NULL, NULL, NULL, 'Blown up off Sierra Leone, 18-10-1628.'); INSERT INTO "voyages" VALUES (364, '', 4, '', 'LEIDEN', NULL, 700, NULL, NULL, NULL, NULL, NULL, 'A', '1628-05-12', 'Texel', '1629-02-04', '1629-02-20', true, '1629-07-17', 'Batavia', 5207, 'Departure from Sierra Leone, 07-10-1628.'); @@ -380,7 +380,7 @@ INSERT INTO "voyages" VALUES (366, '', 1 INSERT INTO "voyages" VALUES (367, '', 1, '', 'BUREN', NULL, 200, NULL, NULL, NULL, NULL, 'E', 'E', '1628-10-28', 'Texel', NULL, NULL, true, '1629-07-10', 'Batavia', NULL, 'Stayed in the Indies.'); INSERT INTO "voyages" VALUES (368, '', 1, '', 'KLEINE DAVID', 'Kornelis Fransz.', 100, 'jacht', NULL, NULL, NULL, 'H', 'H', '1628-10-28', 'Texel', NULL, NULL, true, '1629-07-13', 'Pulicat', NULL, 'Destroyed by fire on the coast of the Coromandel, 11-02-1630.'); INSERT INTO "voyages" VALUES (369, '', 5, '', 'DORDRECHT', NULL, 500, NULL, NULL, NULL, NULL, NULL, 'A', '1628-10-28', 'Texel', NULL, NULL, true, '1629-07-10', 'Batavia', 5203, NULL); -INSERT INTO "voyages" VALUES (370, '', 1, '', '\'S GRAVENHAGE', NULL, 300, NULL, NULL, NULL, NULL, 'A', 'A', '1628-10-28', 'Texel', '1629-09-12', NULL, true, '1629-11-19', 'Batavia', 5223, 'From 03-11-1628 till 04-05-1629 in Zeeland.'); +INSERT INTO "voyages" VALUES (370, '', 1, '', '''S GRAVENHAGE', NULL, 300, NULL, NULL, NULL, NULL, 'A', 'A', '1628-10-28', 'Texel', '1629-09-12', NULL, true, '1629-11-19', 'Batavia', 5223, 'From 03-11-1628 till 04-05-1629 in Zeeland.'); INSERT INTO "voyages" VALUES (371, '', 1, '', 'ZAANDAM', NULL, 500, 'fluit', NULL, NULL, NULL, 'A', 'A', '1628-10-28', 'Texel', NULL, NULL, true, '1629-07-07', 'Batavia', NULL, 'Stayed in the Indies.'); INSERT INTO "voyages" VALUES (372, '', 1, '', 'BATAVIA', 'Adriaan Jakobsz.', 600, NULL, NULL, NULL, NULL, NULL, 'A', '1628-10-29', 'Texel', '1629-04-14', '1629-04-22', true, NULL, NULL, NULL, 'Wrecked on the Wallabi Group, 04-06-1629. Wreck has been discovered (see H. Edwards).'); INSERT INTO "voyages" VALUES (373, '', 2, '', 'GALIASSE', NULL, 300, NULL, NULL, NULL, NULL, 'H', 'H', '1628-12-28', 'Texel', NULL, NULL, true, '1629-07-13', 'Pulicat', 5204, NULL); @@ -421,7 +421,7 @@ INSERT INTO "voyages" VALUES (407, '', 1 INSERT INTO "voyages" VALUES (408, '', 3, '', 'GALIASSE', NULL, 300, NULL, NULL, NULL, NULL, 'H', 'H', '1630-12-11', 'Texel', '1631-03-06', NULL, true, '1631-05-19', 'Batavia', 5219, NULL); INSERT INTO "voyages" VALUES (409, '', 4, '', 'WAPEN VAN DELFT', 'Pieter Klaasz. Hardloop', 700, NULL, '1620', NULL, NULL, 'D', 'D', '1630-12-16', 'Goeree', NULL, NULL, true, '1631-06-06', 'Batavia', NULL, 'Stayed in the Indies.'); INSERT INTO "voyages" VALUES (410, '', 1, '', 'NOORDWIJK', NULL, 300, 'jacht', NULL, NULL, NULL, 'A', 'A', '1630-12-18', 'Texel', NULL, NULL, true, '1631-09-20', 'Batavia', NULL, 'Stayed in the Indies and was wrecked near the river Patrapa, 19-02-1637.'); -INSERT INTO "voyages" VALUES (411, '', 1, '', 'HUISDUINEN', NULL, 150, 'fluit', NULL, NULL, NULL, 'A', 'A', '1631-03-03', 'Texel', NULL, NULL, true, '1631-11-04', 'Batavia', NULL, 'Sailed `achterom\'; stayed in the Indies.'); +INSERT INTO "voyages" VALUES (411, '', 1, '', 'HUISDUINEN', NULL, 150, 'fluit', NULL, NULL, NULL, 'A', 'A', '1631-03-03', 'Texel', NULL, NULL, true, '1631-11-04', 'Batavia', NULL, 'Sailed `achterom''; stayed in the Indies.'); INSERT INTO "voyages" VALUES (412, '', 3, '', 'FREDERIK HENDRIK', 'Pieter Jansz.', 1100, NULL, '1626', NULL, NULL, 'Z', 'Z', '1631-03-25', 'Wielingen', NULL, NULL, true, '1631-09-15', 'Batavia', 5218, 'No ports of call.'); INSERT INTO "voyages" VALUES (413, '', 2, '', 'GULDEN ZEEPAARD', 'Denijs Anthonisz.', 400, NULL, NULL, NULL, NULL, 'Z', 'Z', '1631-03-25', 'Wielingen', NULL, NULL, true, '1631-09-29', 'Batavia', NULL, 'Indies.'); INSERT INTO "voyages" VALUES (414, '', 3, '', 'WAPEN VAN ROTTERDAM', NULL, 700, NULL, '1621', NULL, NULL, 'R', 'R', '1631-03-25', 'Goeree', NULL, NULL, true, '1631-12-03', 'Batavia', 5228, NULL); @@ -431,7 +431,7 @@ INSERT INTO "voyages" VALUES (417, '', 5 INSERT INTO "voyages" VALUES (418, '', 1, '', 'UTRECHT', 'Kornelis Simonsz. van der Veer', 350, NULL, NULL, NULL, NULL, 'A', 'A', '1631-12-11', 'Texel', NULL, NULL, true, '1632-07-15', 'Batavia', NULL, 'Stayed in the Indies; ran ashore in Strait Doeriam, May 1641 and was burnt.'); INSERT INTO "voyages" VALUES (419, '', 1, '', 'BLEISWIJK', NULL, 100, 'jacht', NULL, NULL, NULL, 'R', 'R', '1632-01-01', 'Maas', '1632-12-01', NULL, true, '1633-06-19', 'Batavia', NULL, 'Stayed in the Indies.'); INSERT INTO "voyages" VALUES (420, '', 1, '', 'HOORN', NULL, 550, NULL, NULL, NULL, NULL, 'H', 'H', '1632-01-11', 'Texel', NULL, NULL, true, '1632-08-03', 'Batavia', 5227, NULL); -INSERT INTO "voyages" VALUES (421, '', 1, '', '\'S HERTOGENBOSCH', 'Jakob Jansz. Koonekraai', 600, NULL, '1631', NULL, NULL, 'D', 'D', '1632-01-18', 'Goeree', NULL, NULL, true, '1632-07-27', 'Batavia', 5244, 'Vincente.'); +INSERT INTO "voyages" VALUES (421, '', 1, '', '''S HERTOGENBOSCH', 'Jakob Jansz. Koonekraai', 600, NULL, '1631', NULL, NULL, 'D', 'D', '1632-01-18', 'Goeree', NULL, NULL, true, '1632-07-27', 'Batavia', 5244, 'Vincente.'); INSERT INTO "voyages" VALUES (422, '', 1, '', 'AEMILIA', 'Gerrit van Hattem', 600, NULL, NULL, NULL, NULL, 'Z', 'Z', '1632-03-03', 'Wielingen', NULL, NULL, true, '1632-08-01', 'Batavia', 5225, 'No ports of call at all. 03-03 is the date of the second departure.'); INSERT INTO "voyages" VALUES (423, '', 5, '', 'DELFSHAVEN', NULL, 400, 'jacht', '1621', NULL, NULL, 'D', 'A', '1632-04-18', 'Texel', NULL, NULL, true, '1632-09-08', 'Batavia', NULL, 'Bursted because of carelessness in Batavia, 12-11-1633.'); INSERT INTO "voyages" VALUES (424, '', 5, '', 'LEEUWIN', NULL, 400, NULL, NULL, NULL, NULL, NULL, 'A', '1632-04-18', 'Texel', NULL, NULL, true, '1632-09-16', 'Batavia', NULL, 'No ports of call at all; stayed in the Indies and was laid up 1640.'); @@ -442,8 +442,8 @@ INSERT INTO "voyages" VALUES (428, '', 1 INSERT INTO "voyages" VALUES (429, '', 1, '', 'VEENHUIZEN', NULL, 100, 'jacht', NULL, NULL, NULL, 'E', 'E', '1632-11-23', 'Texel', NULL, NULL, true, '1633-07-21', 'Batavia', NULL, 'See 0428.'); INSERT INTO "voyages" VALUES (430, '', 1, '', 'IJSSELSTEIN', NULL, 80, 'jacht', NULL, NULL, NULL, 'A', 'A', '1632-11-23', NULL, NULL, NULL, true, NULL, NULL, NULL, 'Captured by a Dunkirk privateer.'); INSERT INTO "voyages" VALUES (431, '', 1, '', 'AMSTERDAM', 'Theunis Willemsz. Harnay', 550, NULL, '1632', NULL, NULL, 'A', 'A', '1632-12-10', 'Texel', NULL, NULL, true, '1633-07-21', 'Batavia', 5237, 'See 0428; the AMSTERDAM did not stay in the Indies.'); -INSERT INTO "voyages" VALUES (432, '', 1, '', 'BREEDAM', 'Michiel Vis', 200, 'jacht', NULL, NULL, NULL, 'Z', 'Z', '1632-12-10', 'Wielingen', NULL, NULL, true, '1633-05-24', 'Batavia', NULL, 'No ports of call; stayed in the Indies and was wrecked near the `Duizend eilanden\'.'); -INSERT INTO "voyages" VALUES (433, '', 2, '', 'MIDDELBURG', 'Willem van Domburg', 550, NULL, NULL, NULL, NULL, NULL, 'Z', '1632-12-10', 'Wielingen', NULL, NULL, true, '1633-05-12', 'Batavia', 5236, 'No ports of call. According to `Memoriael\' the master was Kornelis Kornelisz. Domb.'); +INSERT INTO "voyages" VALUES (432, '', 1, '', 'BREEDAM', 'Michiel Vis', 200, 'jacht', NULL, NULL, NULL, 'Z', 'Z', '1632-12-10', 'Wielingen', NULL, NULL, true, '1633-05-24', 'Batavia', NULL, 'No ports of call; stayed in the Indies and was wrecked near the `Duizend eilanden''.'); +INSERT INTO "voyages" VALUES (433, '', 2, '', 'MIDDELBURG', 'Willem van Domburg', 550, NULL, NULL, NULL, NULL, NULL, 'Z', '1632-12-10', 'Wielingen', NULL, NULL, true, '1633-05-12', 'Batavia', 5236, 'No ports of call. According to `Memoriael'' the master was Kornelis Kornelisz. Domb.'); INSERT INTO "voyages" VALUES (434, '', 1, '', 'VENLO', 'Anthonie Jansz.', 120, 'jacht', NULL, NULL, NULL, 'Z', 'Z', '1632-12-10', 'Wielingen', NULL, NULL, true, '1633-06-03', 'Batavia', NULL, 'No ports of call; stayed in the Indies and was laid up, 1646.'); INSERT INTO "voyages" VALUES (435, '', 3, '', 'NASSAU', NULL, 550, NULL, NULL, NULL, NULL, 'A', 'A', '1633-03-23', 'Texel', NULL, NULL, true, '1633-08-11', 'Batavia', 5234, NULL); INSERT INTO "voyages" VALUES (436, '', 1, '', 'SCHAGEN', NULL, 200, 'fluit', NULL, NULL, NULL, 'A', 'A', '1633-03-23', 'Texel', NULL, NULL, true, '1633-09-11', 'Batavia', NULL, 'Stayed in the Indies and was laid up in Batavia, 1644.'); @@ -463,7 +463,7 @@ INSERT INTO "voyages" VALUES (449, '', 3 INSERT INTO "voyages" VALUES (450, '', 2, '', 'AMBOINA', NULL, 400, NULL, '1629', NULL, NULL, 'A', 'A', '1634-12-26', 'Texel', NULL, NULL, true, '1635-07-17', 'Batavia', 5252, NULL); INSERT INTO "voyages" VALUES (451, '', 2, '', 'AMSTERDAM', 'Pieter Dirksz.', 550, NULL, '1632', NULL, NULL, 'A', 'A', '1634-12-26', 'Texel', '1635-04-08', NULL, true, '1635-06-14', 'Batavia', 5245, NULL); INSERT INTO "voyages" VALUES (452, '', 4, '', 'GALIASSE', NULL, 300, NULL, NULL, NULL, NULL, 'H', 'H', '1634-12-26', 'Texel', NULL, NULL, true, '1635-07-14', 'Batavia', NULL, 'Stayed in the Indies.'); -INSERT INTO "voyages" VALUES (453, '', 2, '', '\'S GRAVENHAGE', NULL, 300, NULL, NULL, NULL, NULL, 'A', 'A', '1634-12-26', 'Texel', '1635-05-01', NULL, true, '1635-07-06', 'Batavia', NULL, 'Stayed in the Indies and was burnt by the Portuguese off Goa, 04-01-1638.'); +INSERT INTO "voyages" VALUES (453, '', 2, '', '''S GRAVENHAGE', NULL, 300, NULL, NULL, NULL, NULL, 'A', 'A', '1634-12-26', 'Texel', '1635-05-01', NULL, true, '1635-07-06', 'Batavia', NULL, 'Stayed in the Indies and was burnt by the Portuguese off Goa, 04-01-1638.'); INSERT INTO "voyages" VALUES (454, '', 3, '', 'LEEUWARDEN', NULL, 550, NULL, '1629', NULL, NULL, 'E', 'E', '1634-12-26', 'Texel', NULL, NULL, true, '1635-08-22', 'Batavia', 5255, NULL); INSERT INTO "voyages" VALUES (455, '', 1, '', 'MAASTRICHT', NULL, 600, NULL, NULL, NULL, NULL, 'R', 'R', '1634-12-26', 'Goeree', '1635-05-01', NULL, true, '1635-07-15', 'Batavia', 5248, NULL); INSERT INTO "voyages" VALUES (456, '', 1, '', 'RAROP', NULL, 200, 'fluit', NULL, NULL, NULL, 'A', 'A', '1634-12-26', 'Texel', '1635-04-29', '1635-05-01', true, '1635-07-14', 'Batavia', NULL, 'Stayed in the Indies and wrecked on a reef between Colombo and Negombo, 01-01-1640.'); @@ -474,10 +474,10 @@ INSERT INTO "voyages" VALUES (460, '', 3 INSERT INTO "voyages" VALUES (461, '', 6, '', 'HOLLANDIA', NULL, 700, NULL, NULL, NULL, NULL, 'A', 'A', '1635-05-02', 'Texel', NULL, NULL, true, '1635-09-21', 'Batavia', 5246, 'Via Cape Verde, departure June 1st.'); INSERT INTO "voyages" VALUES (462, '', 4, '', 'NASSAU', NULL, 550, NULL, NULL, NULL, NULL, 'A', 'A', '1635-05-02', 'Texel', NULL, NULL, true, '1635-09-21', 'Batavia', 5249, 'Via Cape Verde, departure June 1st.'); INSERT INTO "voyages" VALUES (463, '', 3, '', 'WEZEL', NULL, 550, NULL, '1629', NULL, NULL, 'A', 'A', '1635-05-02', 'Texel', NULL, NULL, true, '1635-09-21', 'Batavia', 5250, 'Via Cape Verde, departure June 1st.'); -INSERT INTO "voyages" VALUES (464, '', 2, '', 'BANDA', 'Anthonie Caan', 550, NULL, '1633', NULL, NULL, 'A', 'A', '1636-01-18', 'Texel', '1636-05-19', '1636-06-02', true, '1636-07-25', 'Batavia', 5253, '0464-0479 departed with 2557 men; death-toll 123 (Coolhaas I, 556). From 22-01-1636 till 16-02-1636 in the Wielingen. July 5th on the west coast of Australia, 25\'S.'); +INSERT INTO "voyages" VALUES (464, '', 2, '', 'BANDA', 'Anthonie Caan', 550, NULL, '1633', NULL, NULL, 'A', 'A', '1636-01-18', 'Texel', '1636-05-19', '1636-06-02', true, '1636-07-25', 'Batavia', 5253, '0464-0479 departed with 2557 men; death-toll 123 (Coolhaas I, 556). From 22-01-1636 till 16-02-1636 in the Wielingen. July 5th on the west coast of Australia, 25''S.'); INSERT INTO "voyages" VALUES (465, '', 3, '', 'EGMOND', NULL, 240, 'jacht', NULL, NULL, NULL, NULL, 'A', '1636-01-18', 'Texel', '1636-05-19', '1636-06-02', true, '1636-07-25', 'Batavia', NULL, '16-02-1636 in the Wielingen; the ship stayed in the Indies; laid up 1645.'); INSERT INTO "voyages" VALUES (466, '', 1, '', 'HARDERWIJK', NULL, 400, NULL, NULL, NULL, NULL, 'A', 'A', '1636-01-18', 'Texel', '1636-05-19', '1636-06-02', true, '1636-07-25', 'Batavia', 5278, 'From 22-01 till 16-02-1636 in the Wielingen.'); -INSERT INTO "voyages" VALUES (467, '', 1, '', 'KEIZERIN', NULL, 200, 'fluit', NULL, NULL, NULL, NULL, 'A', '1636-01-18', 'Texel', '1636-05-19', '1636-06-02', true, '1636-07-25', 'Batavia', NULL, 'From 22-01 till 16-02-1636 in the Wielingen; the ship stayed in the Indies and ran ashore, coming from Taiwan on the coast of `Champa\', 1637; according to Mac Leod in the Bay of Padaran, 29-10-1636.'); +INSERT INTO "voyages" VALUES (467, '', 1, '', 'KEIZERIN', NULL, 200, 'fluit', NULL, NULL, NULL, NULL, 'A', '1636-01-18', 'Texel', '1636-05-19', '1636-06-02', true, '1636-07-25', 'Batavia', NULL, 'From 22-01 till 16-02-1636 in the Wielingen; the ship stayed in the Indies and ran ashore, coming from Taiwan on the coast of `Champa'', 1637; according to Mac Leod in the Bay of Padaran, 29-10-1636.'); INSERT INTO "voyages" VALUES (468, '', 1, '', 'OTTER', NULL, 200, 'fluit', NULL, NULL, NULL, NULL, 'A', '1636-01-18', 'Texel', '1636-05-19', '1636-06-02', true, '1636-07-25', 'Batavia', NULL, 'OTTER was wrecked upon a reef south of Buton, 1643; according to Coolhaas the crew was murdered 07-09-1643.'); INSERT INTO "voyages" VALUES (469, '', 1, '', 'ZWOLLE', 'Jan Thijssen', 360, NULL, NULL, NULL, NULL, 'A', 'A', '1636-01-18', 'Texel', '1636-05-19', '1636-06-02', true, '1636-07-21', 'Batavia', 5260, 'From 22-01 till 16-02-1636 in the Wielingen.'); INSERT INTO "voyages" VALUES (470, '', 1, '', 'VOS', NULL, NULL, 'jacht', NULL, NULL, NULL, NULL, 'A', '1636-01-18', 'Texel', NULL, NULL, true, '1636-07-17', 'Batavia', NULL, 'From 22-01 till 16-02-1636 in the Wielingen; the ship stayed in the Indies and was laid up in Batavia, 1644.'); @@ -497,7 +497,7 @@ INSERT INTO "voyages" VALUES (483, '', 4 INSERT INTO "voyages" VALUES (484, '', 1, '', 'AKERSLOOT', NULL, 360, 'jacht', '1636', NULL, NULL, 'A', 'A', '1636-12-03', 'Texel', NULL, NULL, true, '1637-04-28', 'Batavia', 5273, NULL); INSERT INTO "voyages" VALUES (485, '', 3, '', 'AMSTERDAM', NULL, 550, NULL, '1632', NULL, NULL, 'A', 'A', '1636-12-03', 'Texel', NULL, NULL, true, '1637-04-26', 'Batavia', 5267, NULL); INSERT INTO "voyages" VALUES (486, '', 3, '', 'HOORN', NULL, 550, NULL, NULL, NULL, NULL, 'H', 'H', '1637-01-06', 'Texel', NULL, NULL, true, NULL, NULL, NULL, 'Sailed on the shallows off Brouwershaven and was wrecked; crew and cargo were saved.'); -INSERT INTO "voyages" VALUES (487, '', 2, '', '\'S HERTOGENBOSCH', 'Kornelis Leendertsz. Blauw', 600, NULL, '1631', NULL, NULL, 'D', 'D', '1637-01-08', 'Goeree', NULL, NULL, true, '1637-07-20', 'Batavia', 5283, NULL); +INSERT INTO "voyages" VALUES (487, '', 2, '', '''S HERTOGENBOSCH', 'Kornelis Leendertsz. Blauw', 600, NULL, '1631', NULL, NULL, 'D', 'D', '1637-01-08', 'Goeree', NULL, NULL, true, '1637-07-20', 'Batavia', 5283, NULL); INSERT INTO "voyages" VALUES (488, '', 2, '', 'MAASTRICHT', NULL, 600, NULL, NULL, NULL, NULL, 'R', 'R', '1637-01-08', 'Goeree', NULL, NULL, true, '1637-07-25', 'Batavia', 5272, NULL); INSERT INTO "voyages" VALUES (489, '', 1, '', 'GRAFT', NULL, 200, 'fluit', NULL, NULL, NULL, NULL, 'A', '1637-02-15', 'Texel', NULL, NULL, true, '1637-07-24', 'Batavia', NULL, 'Stayed in the Indies and was laid up, probably 1646.'); INSERT INTO "voyages" VALUES (490, '', 1, '', 'RIJP', NULL, 200, 'fluit', NULL, NULL, NULL, NULL, 'A', '1637-02-15', 'Texel', NULL, NULL, true, '1637-07-18', 'Batavia', NULL, 'Stayed in the Indies and was laid up in 1648.'); @@ -576,7 +576,7 @@ INSERT INTO "voyages" VALUES (562, '', 2 INSERT INTO "voyages" VALUES (563, '', 1, '', 'UITGEEST', NULL, 600, 'fluit', NULL, NULL, NULL, 'A', 'A', '1640-12-13', 'Texel', NULL, NULL, true, '1641-05-20', 'Batavia', NULL, 'Stayed in the Indies and was used at Onrust, 1653.'); INSERT INTO "voyages" VALUES (564, '', 2, '', 'BREDA', NULL, 1050, NULL, '1637', NULL, NULL, 'H', 'H', '1640-12-25', 'Texel', NULL, NULL, true, '1641-06-12', 'Batavia', 5296, NULL); INSERT INTO "voyages" VALUES (565, '', 3, '', 'ENKHUIZEN', NULL, 550, NULL, NULL, NULL, NULL, NULL, 'E', '1640-12-25', 'Texel', '1641-02-01', NULL, true, '1641-05-19', 'Batavia', 5305, NULL); -INSERT INTO "voyages" VALUES (566, '', 3, '', '\'S HERTOGENBOSCH', 'Kornelis Leendertsz. Blauw', 600, NULL, '1631', NULL, NULL, 'D', 'D', '1640-12-29', 'Goeree', NULL, NULL, true, '1641-05-12', 'Batavia', 5307, 'No ports of call.'); +INSERT INTO "voyages" VALUES (566, '', 3, '', '''S HERTOGENBOSCH', 'Kornelis Leendertsz. Blauw', 600, NULL, '1631', NULL, NULL, 'D', 'D', '1640-12-29', 'Goeree', NULL, NULL, true, '1641-05-12', 'Batavia', 5307, 'No ports of call.'); INSERT INTO "voyages" VALUES (567, '', 1, '', 'BERGEN OP ZOOM', 'David Dingemans', 300, 'jacht', '1640', NULL, NULL, 'Z', 'Z', '1641-03-07', 'Wielingen', NULL, NULL, true, '1641-08-17', 'Batavia', NULL, 'Stayed in the Indies; was wrecked on a reef south of Celebes, 04-03-1650.'); INSERT INTO "voyages" VALUES (568, '', 2, '', 'HENRIETTE LOUISE', 'Willem van Domburg', 750, NULL, '1635', NULL, NULL, 'Z', 'Z', '1641-03-07', 'Wielingen', NULL, NULL, true, '1641-07-31', 'Batavia', 5306, NULL); INSERT INTO "voyages" VALUES (569, '', 1, '', 'VERENIGDE PROVINCIEN', 'Pieter Jansz.', 1100, NULL, '1640', NULL, NULL, 'Z', 'Z', '1641-03-07', 'Zeeland', NULL, NULL, true, '1641-09-04', 'Batavia', 5298, NULL); @@ -707,7 +707,7 @@ INSERT INTO "voyages" VALUES (693, '', 1 INSERT INTO "voyages" VALUES (694, '', 1, '', 'SPERWER', NULL, 540, 'jacht', NULL, NULL, NULL, 'A', 'A', '1648-04-26', 'Texel', '1648-08-01', NULL, true, '1648-12-28', 'Batavia', NULL, 'Via Sierra Leone. The ship stayed in the Indies and was lost sailing from Taiwan to Japan, 16-08-1653.'); INSERT INTO "voyages" VALUES (695, '', 1, '', 'DIAMANT', NULL, 1100, NULL, '1648', NULL, NULL, 'A', 'A', '1648-10-08', 'Texel', NULL, NULL, true, '1649-05-17', 'Batavia', 5371, 'Via S. Tiago. 0695-0708 arrived with 2729 men, amongst whom 911 soldiers; death-toll 288 (Coolhaas II, 370).'); INSERT INTO "voyages" VALUES (696, '', 4, '', 'SALAMANDER', NULL, 1000, NULL, '1639', NULL, NULL, 'A', 'A', '1648-10-08', 'Texel', NULL, NULL, true, '1649-04-15', 'Batavia', 5377, 'Via S. Tiago.'); -INSERT INTO "voyages" VALUES (697, '', 2, '', 'NOORDMUNSTER', NULL, NULL, 'fluit', NULL, NULL, NULL, 'Z', 'Z', '1648-11-01', 'Wielingen', NULL, NULL, true, NULL, NULL, NULL, 'Wrecked in the `Sluise Gat\', when leaving the Wielingen.'); +INSERT INTO "voyages" VALUES (697, '', 2, '', 'NOORDMUNSTER', NULL, NULL, 'fluit', NULL, NULL, NULL, 'Z', 'Z', '1648-11-01', 'Wielingen', NULL, NULL, true, NULL, NULL, NULL, 'Wrecked in the `Sluise Gat'', when leaving the Wielingen.'); INSERT INTO "voyages" VALUES (698, '', 4, '', 'ROTTERDAM', NULL, 1100, NULL, NULL, NULL, NULL, 'R', 'R', '1649-01-15', 'Goeree', NULL, NULL, true, '1649-07-18', 'Batavia', 5376, 'See the BREDA (0703) for the total number of those on board.'); INSERT INTO "voyages" VALUES (699, '', 7, '', 'LEEUWARDEN', NULL, 550, NULL, '1629', NULL, NULL, 'E', 'E', '1649-01-15', 'Texel', NULL, NULL, true, '1649-07-31', 'Batavia', 5374, 'See the BREDA (0703) for the total number of those on board.'); INSERT INTO "voyages" VALUES (700, '', 1, '', 'LASTDRAGER', NULL, 640, 'fluit', NULL, '1648', NULL, 'A', 'A', '1649-01-17', 'Texel', NULL, NULL, true, '1649-08-21', 'Batavia', 5373, NULL); @@ -793,9 +793,9 @@ INSERT INTO "voyages" VALUES (777, '', 2 INSERT INTO "voyages" VALUES (778, '', 7, '', 'HENRIETTE LOUISE', 'Hendrik van der Putte', 750, NULL, '1635', NULL, NULL, 'Z', 'Z', '1653-08-05', 'Wielingen', '1654-08-16', '1654-09-01', true, '1654-11-26', 'Batavia', 5425, '10-08-1653 in Goeree. The ship left the Wielingen 12-04-1654 for the second time. From 27-05-1654 till 03-06-1654 at S. Vincente.'); INSERT INTO "voyages" VALUES (779, '', 1, '', 'VERGULDE DRAAK', 'Aris Jansz. Dul', NULL, 'jacht', '1653', NULL, NULL, 'A', 'A', '1653-08-23', 'Texel', '1654-02-15', '1554-03-12', true, '1654-05-24', 'Batavia', 5417, 'After departure from the Cape the ship struck on a reef but without serious damage (14-03-1654).'); INSERT INTO "voyages" VALUES (780, '', 1, '', 'KALF', '(WITTE) Kornelis Ewoutsz. Juist', 320, 'pinas', NULL, NULL, NULL, 'A', 'A', '1653-08-23', 'Texel', '1654-02-09', '1654-03-12', true, '1654-05-30', 'Batavia', 5489, 'Via St. Antao, S. Tiago and S. Vincente.'); -INSERT INTO "voyages" VALUES (781, '', 1, '', 'LAM', '(WITTE)', NULL, 'fluit', NULL, NULL, NULL, 'A', 'A', '1653-08-23', 'Texel', '1653-12-22', '1653-12-31', true, '1654-03-22', 'Batavia', NULL, 'On 28-10-1654 wrecked on a reef at Taiwan\'s north coast'); +INSERT INTO "voyages" VALUES (781, '', 1, '', 'LAM', '(WITTE)', NULL, 'fluit', NULL, NULL, NULL, 'A', 'A', '1653-08-23', 'Texel', '1653-12-22', '1653-12-31', true, '1654-03-22', 'Batavia', NULL, 'On 28-10-1654 wrecked on a reef at Taiwan''s north coast'); INSERT INTO "voyages" VALUES (782, '', 1, '', 'NAARDEN', NULL, 400, 'jacht', NULL, NULL, NULL, 'A', 'A', '1653-08-23', 'Texel', '1653-12-22', '1653-12-31', true, '1654-03-14', 'Batavia', 5470, NULL); -INSERT INTO "voyages" VALUES (783, '', 5, '', 'VREDE', 'Kornelis Noordstrand', 800, NULL, '1641', NULL, NULL, 'A', 'A', '1653-08-23', 'Texel', '1654-01-06', '1654-01-24', true, '1654-05-18', 'Batavia', NULL, 'After the Cape Elbert Kornelisz. Kes became master. On 28-10-1654 wrecked on a reef at Taiwan\'s north coast.'); +INSERT INTO "voyages" VALUES (783, '', 5, '', 'VREDE', 'Kornelis Noordstrand', 800, NULL, '1641', NULL, NULL, 'A', 'A', '1653-08-23', 'Texel', '1654-01-06', '1654-01-24', true, '1654-05-18', 'Batavia', NULL, 'After the Cape Elbert Kornelisz. Kes became master. On 28-10-1654 wrecked on a reef at Taiwan''s north coast.'); INSERT INTO "voyages" VALUES (784, '', 7, '', 'BREDA', NULL, 1050, NULL, '1637', NULL, NULL, 'H', 'H', '1653-09-09', 'Texel', '1653-12-22', '1653-12-31', true, '1654-03-22', 'Batavia', 5421, NULL); INSERT INTO "voyages" VALUES (785, '', 1, '', 'TULP', 'Samuel Volkertsz.', NULL, 'galjoot', NULL, NULL, NULL, 'A', 'A', '1653-12-23', 'Texel', NULL, NULL, true, '1654-04-18', 'The Cape', NULL, 'Stayed at the Cape for service; lost off Madagascar 02-12-1656.'); INSERT INTO "voyages" VALUES (786, '', 1, '', 'LELIE', NULL, NULL, 'galjoot', NULL, NULL, NULL, 'A', 'A', '1654-01-12', 'Texel', NULL, NULL, true, NULL, NULL, NULL, 'Riding at anchor off Texel it was wrecked during a storm, but the cargo was saved.'); @@ -890,13 +890,13 @@ INSERT INTO "voyages" VALUES (874, '', 8 INSERT INTO "voyages" VALUES (875, '', 9, '', 'ENKHUIZEN', 'Jan Kornelis Zwart', 700, NULL, NULL, NULL, NULL, NULL, 'E', '1657-04-30', 'Vlie', '1657-08-25', '1657-09-10', true, '1657-11-23', 'Batavia', 5457, 'See the ROTTERDAM (0874).'); INSERT INTO "voyages" VALUES (876, '', 8, '', 'WALVIS', 'Barend Barendsz. Lam van Bunschoten', 1000, NULL, '1639', NULL, NULL, 'A', 'D', '1657-06-27', 'Goeree', '1657-11-02', '1657-11-11', true, '1658-02-01', 'Batavia', 5467, NULL); INSERT INTO "voyages" VALUES (877, '', 1, '', 'MEES', 'Maarten Bastink', 202, 'fluit', '1657', NULL, NULL, 'Z', 'Z', '1657-10-12', 'Wielingen', '1658-04-14', '1658-04-23', true, '1658-07-05', 'Batavia', NULL, 'one man deserted there. Until the Cape the voyage was severely delayed by calm and adverse winds. The ship was sold in 1673.'); -INSERT INTO "voyages" VALUES (878, '', 1, '', 'SPREEUW', NULL, 374, 'fluit', '1657', NULL, NULL, 'Z', 'Z', '1657-10-12', 'Wielingen', '1658-03-27', '1658-04-08', true, NULL, NULL, 5500, 'there by the English. The seven `passengers\' who embarked at the Cape were slaves.'); -INSERT INTO "voyages" VALUES (879, '', 2, '', 'VAN AMSTERDAM', 'Andries Wolf +', 920, NULL, '1653', NULL, NULL, 'A', 'A', '1657-10-13', 'Vlie', '1658-03-26', '1658-04-09', true, '1658-07-04', 'Batavia', 5462, 'succeeded him as master. The 16 `passengers\' who embarked at the Cape were slaves, 12 of them arrived at Batavia.'); +INSERT INTO "voyages" VALUES (878, '', 1, '', 'SPREEUW', NULL, 374, 'fluit', '1657', NULL, NULL, 'Z', 'Z', '1657-10-12', 'Wielingen', '1658-03-27', '1658-04-08', true, NULL, NULL, 5500, 'there by the English. The seven `passengers'' who embarked at the Cape were slaves.'); +INSERT INTO "voyages" VALUES (879, '', 2, '', 'VAN AMSTERDAM', 'Andries Wolf +', 920, NULL, '1653', NULL, NULL, 'A', 'A', '1657-10-13', 'Vlie', '1658-03-26', '1658-04-09', true, '1658-07-04', 'Batavia', 5462, 'succeeded him as master. The 16 `passengers'' who embarked at the Cape were slaves, 12 of them arrived at Batavia.'); INSERT INTO "voyages" VALUES (880, '', 2, '', 'WAPEN VAN HOLLAND', NULL, 920, NULL, '1653', NULL, NULL, 'A', 'A', '1657-10-13', 'Vlie', '1658-03-04', '1658-03-19', true, '1658-06-22', 'Batavia', 5473, NULL); INSERT INTO "voyages" VALUES (881, '', 2, '', 'AMERSFOORT', 'Frederik Eldense', 1000, NULL, '1655', NULL, NULL, 'A', 'A', '1657-10-14', 'Vlie', '1658-03-28', '1658-04-09', true, '1658-07-01', 'Batavia', 5461, 'A Portuguese slave ship carrying 250 slaves was captured off Brazil. At the arrival at the Cape about 80 of them had died and many were ill; some 100 slaves arrived at Batavia.'); INSERT INTO "voyages" VALUES (882, '', 1, '', 'ELBURG', 'Jakob Pietersz. Pereboom', 360, 'fluit', '1657', NULL, NULL, 'A', 'A', '1657-12-14', 'Texel', '1658-04-13', '1658-04-23', true, '1658-07-16', 'Batavia', 5539, 'For four weeks at Tristan da Cunha because of calm. Via Cape Leewin.'); INSERT INTO "voyages" VALUES (883, '', 1, '', 'GEELMUIDEN', NULL, 202, 'fluit', '1657', NULL, NULL, 'A', 'A', '1657-12-14', 'Texel', '1658-05-31', '1658-06-14', true, '1658-08-20', 'Batavia', NULL, 'Sailing to Canton in 1659, the GEELMUIDEN was wrecked.'); -INSERT INTO "voyages" VALUES (884, '', 3, '', 'DORDRECHT', 'Jakob Gerrit de Groot', 920, 'fregat', '1652', NULL, NULL, 'D', 'D', '1657-12-17', 'Goeree', '1658-04-28', '1658-05-13', true, '1658-07-14', 'Batavia', 5472, 'Via S. Vincente: 2 seafarers and 4 soldiers deserted there. The 30 \'passengers\' who embarked at the Cape were slaves; 28 of them arrived at Batavia.'); +INSERT INTO "voyages" VALUES (884, '', 3, '', 'DORDRECHT', 'Jakob Gerrit de Groot', 920, 'fregat', '1652', NULL, NULL, 'D', 'D', '1657-12-17', 'Goeree', '1658-04-28', '1658-05-13', true, '1658-07-14', 'Batavia', 5472, 'Via S. Vincente: 2 seafarers and 4 soldiers deserted there. The 30 ''passengers'' who embarked at the Cape were slaves; 28 of them arrived at Batavia.'); INSERT INTO "voyages" VALUES (885, '', 4, '', 'PRINS WILLEM', NULL, 700, NULL, '1650', NULL, NULL, 'Z', 'Z', '1658-01-25', 'Wielingen', '1658-06-17', '1658-07-05', true, '1658-09-12', 'Batavia', 5478, 'Via S. Vincente: one man deserted there.'); INSERT INTO "voyages" VALUES (886, '', 1, '', 'LEERDAM', NULL, 400, 'fluit', NULL, NULL, NULL, 'A', 'A', '1658-04-16', 'Texel', '1658-08-07', '1658-08-21', true, '1658-12-02', 'Batavia', NULL, 'In 1671 sold for breaking up.'); INSERT INTO "voyages" VALUES (887, '', 1, '', 'NIEUWPOORT', NULL, 400, 'fluit', NULL, NULL, NULL, NULL, 'A', '1658-04-16', 'Texel', '1658-07-25', '1658-08-01', true, '1658-10-15', 'Batavia', 5511, NULL); @@ -924,14 +924,14 @@ INSERT INTO "voyages" VALUES (908, '', 8 INSERT INTO "voyages" VALUES (909, '', 8, '', 'MALAKKA', 'Jan van de Werf', 1100, NULL, NULL, NULL, NULL, 'A', 'A', '1659-05-29', 'Vlie', '1659-10-05', '1659-10-22', true, '1659-12-29', 'Batavia', 5484, NULL); INSERT INTO "voyages" VALUES (910, '', 3, '', 'GEKROONDE LEEUW', 'Frederik Pool', 1200, NULL, NULL, NULL, NULL, 'E', 'E', '1659-06-25', 'Vlie', '1659-12-16', '1659-12-31', true, '1660-04-21', 'Batavia', 5493, 'For two months the ship was delayed by calm at the equator. Via Annabon (departure 26-10).'); INSERT INTO "voyages" VALUES (911, '', 10, '', 'ENKHUIZEN', 'Hendrik Sieuwertsz.', 700, NULL, NULL, NULL, NULL, NULL, 'A', '1659-09-09', 'Vlie', '1660-01-13', '1660-01-25', true, '1660-04-21', 'Batavia', NULL, 'For one month the ship was delayed by calm south of the equator. Laid up and sold 20-11-1665.'); -INSERT INTO "voyages" VALUES (912, '', 1, '', '\'S GRAVELAND', 'Andries Pietersz.', NULL, 'jacht', NULL, NULL, NULL, 'A', 'A', '1659-09-09', 'Vlie', '1660-01-10', '1660-01-22', true, '1660-05-01', 'Batavia', NULL, 'Returning from Nagasaki to Batavia in 1663, the ship was wrecked.'); +INSERT INTO "voyages" VALUES (912, '', 1, '', '''S GRAVELAND', 'Andries Pietersz.', NULL, 'jacht', NULL, NULL, NULL, 'A', 'A', '1659-09-09', 'Vlie', '1660-01-10', '1660-01-22', true, '1660-05-01', 'Batavia', NULL, 'Returning from Nagasaki to Batavia in 1663, the ship was wrecked.'); INSERT INTO "voyages" VALUES (913, '', 3, '', 'AMERSFOORT', 'Jan Munt', 1000, NULL, '1655', NULL, NULL, 'A', 'A', '1659-12-17', 'Vlie', '1660-04-02', '1660-04-16', true, '1660-10-18', 'Batavia', 5482, 'Two of the men who embarked at the Cape were prisoners.'); INSERT INTO "voyages" VALUES (914, '', 3, '', 'WAPEN VAN AMSTERDAM', 'Michiel Engelken', 920, NULL, '1653', NULL, NULL, 'A', 'A', '1659-12-17', 'Vlie', '1660-03-29', '1660-04-09', true, '1660-06-04', 'Batavia', 5483, NULL); INSERT INTO "voyages" VALUES (915, '', 2, '', 'ZIERIKZEE', 'Jut Jakobsz. Buis', 400, 'jacht', '1652', NULL, NULL, 'Z', 'R', '1659-12-17', 'Goeree', '1660-04-03', '1660-04-16', true, '1660-07-02', 'Batavia', NULL, 'Via Maio Island. Sunk off Macassar in 1668.'); INSERT INTO "voyages" VALUES (916, '', 1, '', 'DIEMERMEER', 'Karel Alteras', 505, 'fluit', '1659', NULL, NULL, 'A', 'Z', '1659-12-18', 'Wielingen', '1660-04-10', '1660-04-27', true, '1660-07-08', 'Batavia', 5525, NULL); INSERT INTO "voyages" VALUES (917, '', 2, '', 'VLISSINGEN', 'Reinier Reiniersz.', 400, 'jacht', '1653', NULL, NULL, 'Z', 'Z', '1659-12-18', 'Wielingen', '1660-04-03', '1660-04-16', true, '1660-07-06', 'Batavia', NULL, 'Via Boa Vista Island. Broken up in the Bay of Gale (Ceylon), 1665/1666.'); INSERT INTO "voyages" VALUES (918, '', 2, '', 'NAARDEN', 'Pieter Egbertsz. Groot', 400, 'jacht', NULL, NULL, NULL, 'A', 'E', '1659-12-24', 'Texel', '1660-04-03', '1660-04-14', true, '1660-07-08', 'Batavia', NULL, 'Run ashore off Goa in 1665, and sold to a Portuguese for breaking up in 1666.'); -INSERT INTO "voyages" VALUES (919, '', 9, '', 'WALVIS', 'Albert Bruinvis', 1000, NULL, '1639', NULL, NULL, 'A', 'A', '1659-12-24', 'Vlie', '1660-04-04', '1660-04-16', true, '1660-07-12', 'Batavia', NULL, 'The two `passengers\' who embarked at the Cape were prisoners; one of them died. Wrecked on a reef at Salayar, 07-01-1663.'); +INSERT INTO "voyages" VALUES (919, '', 9, '', 'WALVIS', 'Albert Bruinvis', 1000, NULL, '1639', NULL, NULL, 'A', 'A', '1659-12-24', 'Vlie', '1660-04-04', '1660-04-16', true, '1660-07-12', 'Batavia', NULL, 'The two `passengers'' who embarked at the Cape were prisoners; one of them died. Wrecked on a reef at Salayar, 07-01-1663.'); INSERT INTO "voyages" VALUES (920, '', 1, '', 'MUSKAATBOOM or NOTENBOOM', 'Hermansz.', 600, NULL, NULL, '1659', NULL, NULL, 'A', '1660-03-08', 'Vlie', '1660-07-14', '1660-07-30', true, '1660-12-13', 'Batavia', 5528, NULL); INSERT INTO "voyages" VALUES (921, '', 1, '', 'PARKIET', 'Usbrant van Banke', 80, 'galjoot', '1659', NULL, NULL, 'A', 'A', '1660-03-08', 'Vlie', '1660-07-27', '1661-06-17', true, '1661-08-19', 'Colombo', NULL, '09-11-1665.'); INSERT INTO "voyages" VALUES (922, '', 1, '', 'NAGELBOOM', 'Dirk Kornelis de Beer', 600, NULL, NULL, '1659', NULL, 'H', 'H', '1660-03-10', 'Texel', '1660-06-14', '1660-06-23', true, '1660-10-20', 'Batavia', 5486, 'At the Cape 58 French survivors of the wrecked MARECHAL embarked; three of them died.'); @@ -944,7 +944,7 @@ INSERT INTO "voyages" VALUES (928, '', 9 INSERT INTO "voyages" VALUES (929, '', 2, '', 'HILVERSUM', 'Jakob Bakker', 202, 'fluit', '1656', NULL, NULL, 'A', 'A', '1660-11-17', 'Texel', '1661-03-27', '1661-06-23', true, '1661-09-04', 'Coromandel', NULL, 'Via Brouwershaven where 3 man deserted. The ship was driven out of its course and sailed via Atjeh to Pulicat. The ship was sold in 1673.'); INSERT INTO "voyages" VALUES (930, '', 1, '', 'ANKEVEEN', 'Barend Joachimsz.', 283, 'jacht', '1660', NULL, NULL, 'A', 'A', '1660-11-24', 'Texel', '1661-03-24', '1661-04-02', true, '1661-05-30', 'Batavia', NULL, 'At the arrival at Batavia the crew included 10 stowaways from the return fleet (see 5482), who had come on board at the Cape. On 22-02-1663 wrecked off the coast of China; crew was saved.'); INSERT INTO "voyages" VALUES (931, '', 1, '', 'MAARSSEVEEN', 'Pieter Berkhout +', 1210, NULL, '1660', NULL, NULL, 'A', 'A', '1660-11-24', 'Texel', '1661-05-03', '1661-05-21', true, '1661-07-31', 'Batavia', 5494, 'The ship was delayed by a calm of 54 days south of the equator.'); -INSERT INTO "voyages" VALUES (932, '', 2, '', 'VOGELZANG', 'Thomas Michielsz.', 680, 'fluit', NULL, NULL, NULL, 'A', 'A', '1660-11-24', 'Texel', '1661-04-25', '1661-05-05', true, '1661-07-13', 'Batavia', 5542, 'Via Cape Verde, 14 till 20-01-1661. The two `passengers\' who embarked at the Cape were stowaways.'); +INSERT INTO "voyages" VALUES (932, '', 2, '', 'VOGELZANG', 'Thomas Michielsz.', 680, 'fluit', NULL, NULL, NULL, 'A', 'A', '1660-11-24', 'Texel', '1661-04-25', '1661-05-05', true, '1661-07-13', 'Batavia', 5542, 'Via Cape Verde, 14 till 20-01-1661. The two `passengers'' who embarked at the Cape were stowaways.'); INSERT INTO "voyages" VALUES (933, '', 4, '', 'DORDRECHT', 'Adriaan de Gilde van Schiedam', 920, 'fregat', '1652', NULL, NULL, 'D', 'D', '1660-12-06', 'Goeree', '1661-04-26', '1661-05-05', true, '1661-07-18', 'Batavia', 5513, 'Acc. to Daghregister 1661 the ship departed 16-06-1660 from Texel.'); INSERT INTO "voyages" VALUES (934, '', 2, '', 'ERASMUS', 'Dirk van Duinen', 400, 'jacht', '1652', NULL, NULL, 'R', 'R', '1661-01-07', 'Goeree', '1661-04-25', '1661-05-05', true, '1661-07-14', 'Batavia', NULL, 'Laid up at Batavia, 21-02-1669.'); INSERT INTO "voyages" VALUES (935, '', 1, '', 'MEIBOOM', 'Gijsbert Jansz. Strandwijk', 312, 'jacht', '1660', NULL, NULL, 'R', 'R', '1661-01-07', 'Goeree', '1661-07-28', '1661-08-09', true, '1661-10-07', 'Batavia', 5509, 'On 11-04-1661 for the second time from Goeree.'); @@ -954,7 +954,7 @@ INSERT INTO "voyages" VALUES (938, '', 5 INSERT INTO "voyages" VALUES (939, '', 3, '', 'ARNHEM', 'Rens Jansz. + Dirk Gerritsz. van Norden', 1000, NULL, '1654', NULL, NULL, 'A', 'A', '1661-02-07', 'Texel', '1661-06-16', '1661-07-06', true, '1661-09-12', 'Batavia', 5491, NULL); INSERT INTO "voyages" VALUES (940, '', 3, '', 'WAPEN VAN HOLLAND', 'David de Koning', 920, NULL, '1653', NULL, NULL, 'A', 'A', '1661-02-07', 'Texel', '1661-06-18', '1661-07-06', true, '1661-09-12', 'Batavia', 5492, 'Gerrit van Harn, who was to succeed Jan van Riebeek as commandeur at the Cape, died and was buried at S. Vincente, March 1661.'); INSERT INTO "voyages" VALUES (941, '', 1, '', 'OVERVEEN', 'Hendrik Franken', 448, 'jacht', '1660', NULL, NULL, 'A', 'A', '1661-02-07', 'Texel', '1661-06-18', '1661-07-06', true, '1661-09-25', 'Batavia', NULL, 'One child was born during the voyage.'); -INSERT INTO "voyages" VALUES (942, '', 2, '', 'ZEEPAARD', 'Hendrik Lucifer', 400, 'jacht', NULL, NULL, NULL, 'Z', 'Z', '1661-03-01', 'Wielingen', '1661-06-16', '1661-06-23', true, '1661-08-28', 'Batavia', 5519, 'Ship\'s destination was Ceylon; arrival at Batavia by mistake of the master.'); +INSERT INTO "voyages" VALUES (942, '', 2, '', 'ZEEPAARD', 'Hendrik Lucifer', 400, 'jacht', NULL, NULL, NULL, 'Z', 'Z', '1661-03-01', 'Wielingen', '1661-06-16', '1661-06-23', true, '1661-08-28', 'Batavia', 5519, 'Ship''s destination was Ceylon; arrival at Batavia by mistake of the master.'); INSERT INTO "voyages" VALUES (943, '', 1, '', 'BEURS VAN AMSTERDAM', 'Reier Mauntsz.', 472, 'jacht', NULL, '1660/1', NULL, 'A', 'A', '1661-04-11', 'Texel', '1661-07-25', '1661-08-03', true, '1661-11-01', 'Ceylon', 5521, NULL); INSERT INTO "voyages" VALUES (944, '', 1, '', 'WASSENDE MAAN', 'Hendrik Springer', 400, 'jacht', NULL, '1660/1', NULL, 'A', 'A', '1661-04-11', 'Texel', '1661-08-23', '1661-09-24', true, '1662-06-04', 'Ceylon', 5504, 'Via S. Vincente (16 till 23-05). For five weeks at the equator. At the Cape 23 soldiers from the JONGE PRINS came on board. Searched for the return fleet (see 5491).'); INSERT INTO "voyages" VALUES (945, '', 1, '', 'RAADHUIS', NULL, 360, 'jacht', NULL, '1660/1', NULL, 'A', 'A', '1661-04-11', 'Texel', '1661-07-26', '1661-08-03', true, '1661-11-01', 'Ceylon', NULL, 'Laid up and sold, 24-11-1671.'); @@ -982,7 +982,7 @@ INSERT INTO "voyages" VALUES (966, '', 9 INSERT INTO "voyages" VALUES (967, '', 1, '', 'VLAARDINGEN', 'Bartholomeus Verwey van Rotterdam', 400, 'jacht? pinas?', '1661?', NULL, NULL, 'D', 'D', '1662-04-14', 'Goeree', '1662-08-28', '1662-09-26', true, '1663-03-30', 'Batavia', 5570, 'departure on 23-05-1662. See KENNE-MERLAND (0968).'); INSERT INTO "voyages" VALUES (968, '', 1, '', 'KENNERMERLAND', NULL, 950, NULL, NULL, '1661/2', NULL, 'A', 'A', '1662-04-17', 'Texel', '1662-09-03', '1662-09-26', true, '1663-03-30', 'Batavia', 5514, 'KENNEMERLAND, WAPEN VAN ZEELAND (0973), VLAARDINGEN (0967), RIJNLAND (0969), KOGGE (0971), VELDHOEN (0961), and ZEERIDDER (0854), and on 16-10-1662 the ORANJE (0972) departed from the Cape under command of Huibert de Laresse to attack Mozambique and to look for the missing ships of the return fleet under command of Arnold de Vlaming. The mission failed; the fleet sailed on for Batavia.'); INSERT INTO "voyages" VALUES (969, '', 1, '', 'RIJNLAND', NULL, 795, NULL, '1662', NULL, NULL, 'A', 'A', '1662-04-17', 'Texel', '1662-09-02', '1662-09-26', true, '1663-03-30', 'Batavia', 5518, 'See KENNEMERLAND (0968).'); -INSERT INTO "voyages" VALUES (970, '', 1, '', 'WATERHOEN', 'Pieter Willemsz.', 193, 'galjoot? fluit?', '1661', NULL, NULL, 'A', 'A', '1662-04-17', 'Texel', '1662-10-22', '1664-12-11', true, '1665-02-14', 'Batavia', NULL, 'attack on Mozambique, but fell behind and left the fleet on 29-06-1662 at 5\'N. Stayed at the Cape. Wrecked at Amboina in 1672.'); +INSERT INTO "voyages" VALUES (970, '', 1, '', 'WATERHOEN', 'Pieter Willemsz.', 193, 'galjoot? fluit?', '1661', NULL, NULL, 'A', 'A', '1662-04-17', 'Texel', '1662-10-22', '1664-12-11', true, '1665-02-14', 'Batavia', NULL, 'attack on Mozambique, but fell behind and left the fleet on 29-06-1662 at 5''N. Stayed at the Cape. Wrecked at Amboina in 1672.'); INSERT INTO "voyages" VALUES (971, '', 1, '', 'KOGGE', NULL, 400, 'jacht', NULL, '1662', NULL, 'H', 'H', '1662-04-23', 'Texel', '1662-08-29', '1662-09-26', true, '1663-03-30', 'Batavia', 5534, 'The ship lost its bowsprit, foremast and several topmasts. See also KENNEMERLAND (0968).'); INSERT INTO "voyages" VALUES (972, '', 9, '', 'ORANJE', 'Pieter Kaub', 700, NULL, '1643', NULL, NULL, 'Z', 'Z', '1662-04-23', 'Wielingen', '1662-10-03', '1662-10-16', true, '1663-03-30', 'Batavia', 5517, 'See also KENNEMERLAND (0968).'); INSERT INTO "voyages" VALUES (973, '', 1, '', 'WAPEN VAN ZEELAND', NULL, NULL, NULL, NULL, '1661', NULL, 'Z', 'Z', '1662-04-23', 'Wielingen', '1662-09-07', '1662-09-26', true, '1663-03-30', 'Batavia', NULL, 'KENNEMERLAND (0968). On board: Vice-admiraal Willem Volgers. The ship was wrecked on a voyage to China on 16-09-1663.'); @@ -991,15 +991,15 @@ INSERT INTO "voyages" VALUES (975, '', 1 INSERT INTO "voyages" VALUES (976, '', 1, '', 'NIEUWENDAM', NULL, 210, 'jacht', '1662', NULL, NULL, 'A', 'A', '1662-09-23', 'Texel', '1663-03-12', '1663-03-27', true, '1663-06-18', 'Batavia', NULL, 'Via Goeree, departure on 09-10-1662. The ship was wrecked between Bima and Macassar on 1/2-10-1670.'); INSERT INTO "voyages" VALUES (977, '', 2, '', 'MAARSSEVEEN', 'Barend Barendsz. Lam', 1210, NULL, '1660', NULL, NULL, 'A', 'A', '1662-10-09', 'Texel', '1663-02-04', '1663-02-19', true, '1663-05-11', 'Batavia', 5515, 'The ship discovered two islands S. E. off the Cape which were called Dina and Maarsseveen. (later: Marion I. and Prince Edward I.).'); INSERT INTO "voyages" VALUES (978, '', 1, '', 'VLIEG', NULL, 120, 'galjoot? fluit?', NULL, '1661/2', NULL, 'A', 'A', '1662-10-09', 'Texel', '1663-01-07', '1663-02-14', true, '1663-05-21', 'Batavia', NULL, 'Laid up and sold at Batavia on 05-04-1675.'); -INSERT INTO "voyages" VALUES (979, '', 1, '', 'KANEELBOOM', NULL, 300, 'jacht', '1662', NULL, NULL, 'Z', 'Z', '1662-11-28', 'Wielingen', '1663-04-03', '1663-04-17', true, '1663-07-06', 'Batavia', NULL, 'The \'passengers\' who embarked at the Cape, were Portuguese prisoners. The ship was wrecked on a voyage between Bengal and Batavia on 18-11-1670.'); +INSERT INTO "voyages" VALUES (979, '', 1, '', 'KANEELBOOM', NULL, 300, 'jacht', '1662', NULL, NULL, 'Z', 'Z', '1662-11-28', 'Wielingen', '1663-04-03', '1663-04-17', true, '1663-07-06', 'Batavia', NULL, 'The ''passengers'' who embarked at the Cape, were Portuguese prisoners. The ship was wrecked on a voyage between Bengal and Batavia on 18-11-1670.'); INSERT INTO "voyages" VALUES (980, '', 1, '', 'RAMMEKENS', NULL, 438, 'jacht', '1662', NULL, NULL, 'Z', 'Z', '1662-11-28', 'Wielingen', '1663-03-29', '1663-04-10', true, '1663-06-18', 'Batavia', NULL, 'On the return voyage the ship carried French prisoners-of-war. Departure from Ceylon on 24-09-1674; arrival in Holland on 21-04-1676, when it was restored to the Company, see 1327.'); -INSERT INTO "voyages" VALUES (981, '', 1, '', 'DURGERDAM', NULL, 452, 'jacht', '1662', NULL, NULL, 'A', 'A', '1662-11-29', 'Texel', '1663-04-06', '1663-04-17', true, '1663-09-21', 'Batavia', NULL, 'The \'passengers\' who embarked at the Cape, were 6 Portuguese prisoners and one slave. Laid up at Batavia in 1674.'); -INSERT INTO "voyages" VALUES (982, '', 1, '', 'ELZENBURG', 'Theunis Schuit', 212, 'fluit', '1662', NULL, NULL, 'E', 'E', '1662-11-29', 'Texel', '1663-04-05', '1663-04-17', true, '1663-07-06', 'Batavia', NULL, 'The \'passengers\' who embarked at the Cape, were 4 Portuguese prisoners. The ship was wrecked on 09-11-1665 off Bimelepatnam.'); +INSERT INTO "voyages" VALUES (981, '', 1, '', 'DURGERDAM', NULL, 452, 'jacht', '1662', NULL, NULL, 'A', 'A', '1662-11-29', 'Texel', '1663-04-06', '1663-04-17', true, '1663-09-21', 'Batavia', NULL, 'The ''passengers'' who embarked at the Cape, were 6 Portuguese prisoners and one slave. Laid up at Batavia in 1674.'); +INSERT INTO "voyages" VALUES (982, '', 1, '', 'ELZENBURG', 'Theunis Schuit', 212, 'fluit', '1662', NULL, NULL, 'E', 'E', '1662-11-29', 'Texel', '1663-04-05', '1663-04-17', true, '1663-07-06', 'Batavia', NULL, 'The ''passengers'' who embarked at the Cape, were 4 Portuguese prisoners. The ship was wrecked on 09-11-1665 off Bimelepatnam.'); INSERT INTO "voyages" VALUES (983, '', 1, '', 'HOOGKARSPEL', 'Meindert Roelofsz.', 212, 'fluit', '1662', NULL, NULL, 'E', 'E', '1662-11-29', 'Texel', '1663-04-10', '1663-04-23', true, '1663-07-05', 'Batavia', NULL, 'embarked at the Cape were Portuguese prisoners. The ship was wrecked between Tonkin and Japan in 1670.'); -INSERT INTO "voyages" VALUES (984, '', 2, '', 'OOIEVAAR', NULL, 627, 'fluit', '1656', NULL, NULL, 'Z', 'A', '1662-11-29', 'Texel', '1663-04-10', '1663-04-17', true, '1663-06-21', 'Batavia', 5529, 'The \'passengers\' who embarked at the Cape, were 6 Portuguese prisoners, 1 female slave and 2 children.'); +INSERT INTO "voyages" VALUES (984, '', 2, '', 'OOIEVAAR', NULL, 627, 'fluit', '1656', NULL, NULL, 'Z', 'A', '1662-11-29', 'Texel', '1663-04-10', '1663-04-17', true, '1663-06-21', 'Batavia', 5529, 'The ''passengers'' who embarked at the Cape, were 6 Portuguese prisoners, 1 female slave and 2 children.'); INSERT INTO "voyages" VALUES (985, '', 1, '', 'BLEISWIJK', NULL, 240, 'jacht', '1662', NULL, NULL, 'R', 'R', '1662-12-01', 'Maas', '1663-03-19', '1663-04-08', true, '1663-07-19', 'Batavia', NULL, '1674.'); INSERT INTO "voyages" VALUES (986, '', 8, '', 'PRINSES ROYAAL', NULL, 1100, NULL, NULL, NULL, NULL, 'A', 'Z', '1662-12-28', 'Wielingen', '1663-05-09', '1663-05-23', true, '1663-08-02', 'Batavia', NULL, 'One child was born during the voyage. Laid up and sold in August 1666.'); -INSERT INTO "voyages" VALUES (987, '', 1, '', 'JONKER', NULL, 200, 'fregat', NULL, '1662', NULL, 'Z', 'Z', '1663-01-22', 'Wielingen', NULL, NULL, false, '1663-06-14', 'Batavia', NULL, 'Wrecked on the rocks of the \'Hytanse\' Islands on 17-12-1667; 33 men were drowned; there were about 13 survivors.'); +INSERT INTO "voyages" VALUES (987, '', 1, '', 'JONKER', NULL, 200, 'fregat', NULL, '1662', NULL, 'Z', 'Z', '1663-01-22', 'Wielingen', NULL, NULL, false, '1663-06-14', 'Batavia', NULL, 'Wrecked on the rocks of the ''Hytanse'' Islands on 17-12-1667; 33 men were drowned; there were about 13 survivors.'); INSERT INTO "voyages" VALUES (988, '', 5, '', 'PHOENIX', 'Kornelis Stamper', 900, NULL, NULL, NULL, NULL, 'A', 'D', '1663-04-01', 'Goeree', '1663-07-15', '1663-08-03', true, '1663-10-08', 'Batavia', 5530, 'On board commandeur Johan van der Laan.'); INSERT INTO "voyages" VALUES (989, '', 2, '', 'SPREEUW', NULL, 347, 'fluit', '1657', NULL, NULL, 'Z', 'A', '1663-04-01', 'Goeree', '1663-07-16', '1663-07-25', true, '1663-09-16', 'Batavia', 5567, NULL); INSERT INTO "voyages" VALUES (990, '', 1, '', 'ALPHEN', NULL, 700, 'fluit', '1662', NULL, NULL, 'A', 'A', '1663-04-16', 'Texel', '1663-08-26', '1663-09-09', true, '1663-11-14', 'Batavia', 5555, 'On board P. van Hoorn, extraordinaris Raad van Indie.'); @@ -1120,19 +1120,19 @@ INSERT INTO "voyages" VALUES (1103, '', INSERT INTO "voyages" VALUES (1104, '', 2, '', 'EENDRACHT', 'Jan Pietersz. de Vrije', 670, NULL, '1663', NULL, NULL, 'D', 'R', '1668-07-29', 'Goeree', '1668-12-03', '1668-12-08', true, '1669-02-17', 'Batavia', 5601, 'Via S. Tiago (Aug. 1668). Acc. to K.A. 3981 the ship left the Cape on 13-08-1668.'); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
