123000

41 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Sender, Receiver, Date, Keywords

Link rowid ▼ subject_id priority Page Sender Receiver Date Keywords
1 1 102039006 1 SAA.565A_1286.02-p1 Johan Ludwig Runckel Committee for Foreign Need November 15, 1710; November 26, 1710 Heads of state; International migration
2 2 102039021 2 SAA.565A_1286.02-p2 Johan Ludwig Runckel Committee for Foreign Need November 15, 1710; November 26, 1710 Heads of state; International migration
3 3 102039024 3 SAA.565A_1286.02-p3 Johan Ludwig Runckel Committee for Foreign Need November 15, 1710; November 26, 1710 Heads of state; International migration
4 4 102039026 4 SAA.565A_1308.01-p1 Frederick, King of Prussia Wolfgang von Schmettau February 9, 1711 Negotiation; Governance; Heads of state; Imperial interactions; Migration; Poverty
5 5 102039029 5 SAA.565A_1308.01-p2 Frederick, King of Prussia Wolfgang von Schmettau February 9, 1711 Negotiation; Governance; Heads of state; Imperial interactions; Migration; Poverty
6 6 102039031 6 SAA.565A_1746.01-p1 Government of Rotterdam Bern February 14, 1660 Heads of state; Communication network; Intermediary
7 7 102039034 7 SAA.565A_1746.01-p2 Government of Rotterdam Bern February 14, 1660 Heads of state; Communication network; Intermediary
8 8 102039037 8 SAA.565A_1746.01-p3 Government of Rotterdam Bern February 14, 1660 Heads of state; Communication network; Intermediary
9 9 102039039 9 SAA.565A_1747.01-p1 Congregation of the Lamb Government of Amsterdam September 23, 1687 Communication network; Governance; Heads of state; International movement
10 10 102039042 10 SAA.565A_1747.01-p2 Congregation of the Lamb Government of Amsterdam September 23, 1687 Communication network; Governance; Heads of state; International movement
11 11 102039044 11 SAA.565A_1747.01-p3 Congregation of the Lamb Government of Amsterdam September 23, 1687 Communication network; Governance; Heads of state; International movement
12 12 102039047 12 SAA.565A_1747.02-p1 J. Spronsen on behalf of the States of Holland Cities of Bern and Zurich September 23, 1688 Negotiation; Governance; Heads of state; Persecution
13 13 102039049 13 SAA.565A_1747.02-p2 J. Spronsen on behalf of the States of Holland Cities of Bern and Zurich September 23, 1688 Negotiation; Governance; Heads of state; Persecution
14 14 102039052 14 SAA.565A_1747.02-p3 J. Spronsen on behalf of the States of Holland Cities of Bern and Zurich September 23, 1688 Negotiation; Governance; Heads of state; Persecution
15 15 102039054 15 SAA.565A_1747.03-p1 Johan Baron van Reede from Renswouden; J. Spronsen Adolf de Vreede, serving as an envoy to Switzerland September 23, 1689 Communication network; Governance; Heads of state; International movement
16 16 102039057 16 SAA.565A_1747.03-p2 Johan Baron van Reede from Renswouden; J. Spronsen Adolf de Vreede, serving as an envoy to Switzerland September 23, 1689 Communication network; Governance; Heads of state; International movement
17 17 102039059 17 SAA.565A_1747.04-p1 Rotterdam; W: van der Aa Bern September 23, 1690 Governance; Diplomatic relations
18 18 102039062 18 SAA.565A_1747.04-p2 Rotterdam; W: van der Aa Bern September 23, 1690 Governance; Diplomatic relations
19 19 102039065 19 SAA.565A_1747.04-p3 Rotterdam; W: van der Aa Bern September 23, 1690 Governance; Diplomatic relations
20 20 102039068 20 SAA.565A_1747.04-p4 Rotterdam; W: van der Aa Bern September 23, 1690 Governance; Diplomatic relations
21 21 102039070 21 SAA.565A_1747.04-p5 Rotterdam; W: van der Aa Bern September 23, 1690 Governance; Diplomatic relations
22 22 102039073 22 SAA.565A_1750.01-p1 Isaak Kopps; 27 Mennonites States General; van Beaumont, Simon January 22, 1695 Heads of state; persecution
23 23 102039077 23 SAA.565A_1750.01-p2 Isaak Kopps; 27 Mennonites States General; van Beaumont, Simon January 22, 1695 Heads of state; persecution
24 24 102039080 24 SAA.565A_1750.01-p3 Isaak Kopps; 27 Mennonites States General; van Beaumont, Simon January 22, 1695 Heads of state; persecution
25 25 102039082 25 SAA.565A_1751.01-p1 States General; Francois Fagel Johann Wilhelm Churfurst March 24, 1695 Governance; Negotiation; Persecution; Heads of state
26 26 102039085 26 SAA.565A_1751.01-p2 States General; Francois Fagel Johann Wilhelm Churfurst March 24, 1695 Governance; Negotiation; Persecution; Heads of state
27 27 102039088 27 SAA.565A_1752.01-p1 Francois Fagel; Adriaen van Diephout; Coenraad van Acken Johann Wilhelm Churfurst; States General June 24, 1695; June 22, 1695; April 12, 1695 Governance; Diplomatic relations; Legal concerns; Persecution; Political network
28 28 102039091 28 SAA.565A_1752.01-p2 Francois Fagel; Adriaen van Diephout; Coenraad van Acken Johann Wilhelm Churfurst; States General June 24, 1695; June 22, 1695; April 12, 1695 Governance; Diplomatic relations; Legal concerns; Persecution; Political network
29 29 102039093 29 SAA.565A_1752.01-p3 Francois Fagel; Adriaen van Diephout; Coenraad van Acken Johann Wilhelm Churfurst; States General June 24, 1695; June 22, 1695; April 12, 1695 Governance; Diplomatic relations; Legal concerns; Persecution; Political network
30 30 102039096 30 SAA.565A_1752.01-p4 Francois Fagel; Adriaen van Diephout; Coenraad van Acken Johann Wilhelm Churfurst; States General June 24, 1695; June 22, 1695; April 12, 1695 Governance; Diplomatic relations; Legal concerns; Persecution; Political network
31 31 102039099 31 SAA.565A_1752.01-p5 Francois Fagel; Adriaen van Diephout; Coenraad van Acken Johann Wilhelm Churfurst; States General June 24, 1695; June 22, 1695; April 12, 1695 Governance; Diplomatic relations; Legal concerns; Persecution; Political network
32 32 102039101 32 SAA.565A_1752.01-p6 Francois Fagel; Adriaen van Diephout; Coenraad van Acken Johann Wilhelm Churfurst; States General June 24, 1695; June 22, 1695; April 12, 1695 Governance; Diplomatic relations; Legal concerns; Persecution; Political network
33 33 102039104 33 SAA.565A_1780.01-p1 States General Canton of Bern January 22, 1715 Negotiation; Communication network; Intermediary; Governance; Heads of state
34 34 102039107 34 SAA.565A_1780.01-p2 States General Canton of Bern January 22, 1715 Negotiation; Communication network; Intermediary; Governance; Heads of state
35 35 102039110 35 SAA.565A_1784.01-p1 Leiden Congregation States General April 15, 1732 Governance; Heads of state
36 36 102039113 36 SAA.565A_1784.01-p2 Leiden Congregation States General April 15, 1732 Governance; Heads of state
37 37 102039116 37 SAA.565A_1784.01-p3 Leiden Congregation States General April 15, 1732 Governance; Heads of state
38 38 102039118 38 SAA.565A_1784.01-p4 Leiden Congregation States General April 15, 1732 Governance; Heads of state
39 39 102039121 39 SAA.565A_1785.01-p1 Isaak Francken Herman ten Kate; L. Bescheiden April 16, 1732 Administration; Regional movement; Heads of state; Travel network
40 40 102039123 40 SAA.565A_1785.01-p2 Isaak Francken Herman ten Kate; L. Bescheiden April 16, 1732 Administration; Regional movement; Heads of state; Travel network
41 41 102039126 41 SAA.565A_1785.01-p3 Isaak Francken Herman ten Kate; L. Bescheiden April 16, 1732 Administration; Regional movement; Heads of state; Travel network

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "123000" (
   [subject_id] INTEGER,
   [priority] INTEGER,
   [Page] TEXT,
   [Sender] TEXT,
   [Receiver] TEXT,
   [Date] TEXT,
   [Keywords] TEXT
);