List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

39 rows where City = "" and State = "VA"

View and edit SQL

Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State

City

Link rowid ▼ Foreign_Principal_Termination_Date Foreign_Principal Foreign_Principal_Registration_Date Country/Location_Represented Registration_Number Registrant_Date Registrant_Name Address_1 Address_2 City State Zip
2147 1995-02-07 Festival Shipping & Tourist Enterprises, Ltd. 1991-12-13 CYPRUS 4198 4198 1988-12-16 Eckert International, Inc. Oakton     VA  
2198 1983-02-09 International Reporting Information Systems (IRIS) 1982-12-30 INTERNATIONAL 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Arlington     VA  
2227 1981-02-10 Government of the Republic of Korea 1980-03-06 KOREA, SOUTH 3093 3093 1980-03-06 Chestnut Valley Consultants, Inc. Arlington     VA  
2297 1996-02-12 British Aerospace, PLC 1994-06-07 GREAT BRITAIN 3660 3660 1985-03-19 Hyjek & Fix, Inc. Arlington     VA  
2304 1996-02-12 Pilkington Optronics, U.K. (formerly: Thorn/EMI) 1995-04-20 GREAT BRITAIN 3660 3660 1985-03-19 Hyjek & Fix, Inc. Alexandria     VA  
2327 1996-02-13 British Aerospace 1994-06-07 GREAT BRITAIN 4918 4918 1994-06-07 Richard B. Ray, Inc. Arlington     VA  
2479 1996-02-16 Thomson-CSF, Inc. 1995-06-08 FRANCE 3700 3700 1985-07-09 Gold & Liebengood, Inc. Alexandria     VA  
2868 1995-02-28 Thomson-CSF, Inc. 1989-02-27 FRANCE 3700 3700 1985-07-09 Gold & Liebengood, Inc. Arlington     VA  
2896 1999-02-28 New Zealand Meat Board, Washington Office 1998-11-18 NEW ZEALAND 5289 5289 1998-11-18 Witeck-Combs Communications 8000 Towers Crescent Drive, Suite 240, Vienna     VA  
4246 1986-03-31 Italian Advanced Industries, Inc. (I.A.I.) 1985-10-08 ITALY 3655 3655 1985-03-08 Snyder, Ball, Kriser & Associates, Inc. Arlington     VA  
4360 1995-03-31 Representative of the Patriotic Union of Kurdistan Barham Salih 1993-03-03 IRAN 4773 4773 1993-03-03 Korn, David A. Annandale     VA  
4848 1993-04-06 Heckler & Koch, Inc. 1992-10-21 GREAT BRITAIN 3950 3950 1987-03-20 Robison International, Inc. Sterling     VA  
5214 1992-04-20 Royal Ordnance, Inc. 1987-03-20 GREAT BRITAIN 3950 3950 1987-03-20 Robison International, Inc. Arlington     VA  
6520 1993-05-24 Thomson-CSF, Inc. 1988-10-05 FRANCE 2469 2469 1973-10-23 Burson-Marsteller Arlington     VA  
7121 1986-06-01 Princess Haifa bint Faisal 1985-06-29 SAUDI ARABIA 3707 3707 1985-07-29 Rogers & Cowan, Inc., Washington Office McLean     VA  
7356 1991-06-06 Ceres Enterprises, Inc. 1991-03-08 GREECE 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Reston     VA  
7372 1994-06-07 Dowty Electronic Systems Division (a Subsidiary of Dowty Group, PLC) 1992-05-12 GREAT BRITAIN 3660 3660 1985-03-19 Hyjek & Fix, Inc. Arlington     VA  
7450 1994-06-10 Matra Aerospace, Inc. 1989-06-09 FRANCE 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Arlington     VA  
7461 1986-06-11 Babak Farzaneh 1985-04-10 IRAN 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC McLean     VA  
7605 1993-06-17 Cable & Wireless North America 1991-05-24 GREAT BRITAIN 4095 4095 1988-03-03 Murphy & Demory, Ltd. Vienna     VA  
7873 1990-06-29 Matra Aerospace, Inc. 1990-01-10 FRANCE 3958 3958 1987-04-09 Edwards, Jack Arlington     VA  
8275 1998-06-30 Konimklijke Luchtvaart Maatschappij, N.V. (KLM) 1995-05-08 NETHERLANDS 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Reston     VA  
8329 2002-06-30 South Australia 2002-04-29 AUSTRALIA 4777 4777 1993-03-12 Development Counsellors International Regus Tysons Corner 4th Floor 1750 Tysons Boulevard McLean 22102     VA  
8586 1994-07-01 Jetstream Aircraft, Inc. a wholly-owned subsidiary of British Aerospace Inc. 1994-02-01 GREAT BRITAIN 4710 4710 1992-09-28 Wood, John H. Sterling     VA  
9140 1994-07-25 Thomson CSF, Inc. 1992-04-30 FRANCE 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Arlington     VA  
10694 1997-08-31 Ukrainian United Energy Systems 1997-02-20 UKRAINE 3634 3634 1984-11-15 Daniel J. Edelman, Inc. Alexandria     VA  
10895 1987-09-01 Royal Ordnance, U.S.A. 1989-02-16 GREAT BRITAIN 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Alexandria     VA  
11643 1991-09-30 Matra Aerospace, Inc. 1990-06-29 FRANCE 4396 4396 1990-06-29 Hand, Arendall, Bedsole, Greaves & Johnson Arlington     VA  
11698 1997-09-30 NABO Traders 1997-08-01 SIERRA LEONE 5148 5148 1996-12-30 Powell Tate, Inc. Arlington     VA  
12219 1989-10-13 CASA Aircraft U.S.A., Inc. 1988-03-17 SPAIN 4106 4106 1988-03-17 Bronheim, David Chantilly     VA  
12500 1986-10-22 Royal Ordnance, U.S.A. 1986-05-30 UNITED KINGDOM 2740 2740 1976-12-17 Hill & Knowlton, Inc. Alexandria     VA  
12809 1988-10-31 ADIG-Investment GmbH 1989-05-31 LIBERIA 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Reston     VA  
13174 1999-11-01 Republic of Liberia, Embassy 1997-11-24 LIBERIA 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Reston     VA  
13535 1993-11-15 Matra Aerospace, Inc. 1989-05-25 FRANCE 3712 3712 1985-08-05 DLA Piper US LLP Arlington     VA  
13901 1981-11-30 Italian Aerospace Industries, Inc., a Subsidiary of Aeritalia, S.A.I.P.A. 1981-11-24 ITALY 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Arlington     VA  
14053 2003-11-30 Royal Embassy of Saudi Arabia - through Qorvis Communications, LLC 2003-11-04 SAUDI ARABIA 5585 5585 2003-11-04 Cambridge Associates, Ltd. 8484 Westpark Drive Suite 800 McLean 22102     VA  
15597 1989-12-31 People's Committee for Libyan Students 1989-12-07 LIBYA 4323 4323 1989-12-07 Beveridge & Diamond, P.C. Falls Church     VA  
15749 1992-12-31 Thomson-CSF, Inc. 1992-05-11 FRANCE 4663 4663 1992-05-11 Mitchell, Williams, Selig, Gates & Woodyard Arlington     VA  
15876 1995-12-31 Short Brothers 1995-06-02 NORTHERN IRELAND 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Arlington     VA  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_ForeignPrincipals] (
   [Foreign_Principal_Termination_Date] TEXT,
   [Foreign_Principal] TEXT,
   [Foreign_Principal_Registration_Date] TEXT,
   [Country/Location_Represented] TEXT,
   [Registration_Number] INTEGER,
   [Registrant_Date] TEXT,
   [Registrant_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);