FARA_All_ForeignPrincipals

List of all foreign principals (active and terminated)

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

51 rows where State = "VA"

✎ View and edit SQL

This data as json, atom, CSV (advanced)

Suggested facets: Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State

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
97 97   China Telecom (Americas) Corporation 2019-10-18 CHINA 6642 6642 2019-03-06 Levick Strategic Communications, LP 607 Herndon Pkwy #201   Herndon VA 20170
98 98   China Telecom Americas 2019-03-20 CHINA 6585 6585 2018-08-30 Ogilvy Group, LLC 607 Herndon Parkway Suite 201 Herndon VA 20170
410 410   LISCR, LLC 2020-02-14 LIBERIA 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 22980 Indian Creek Drive   Dulles VA 20166
498 498   National Wildlife Federation (under grant from the Norwegian Agency for Development Cooperation) 2019-08-23 NORWAY 6710 6710 2019-08-23 Waxman Consulting, Inc. DBA Waxman Strategies 11100 Wildlife Center Drive   Reston VA 20190
673 673   Transformation and Continuity 2014-07-03 AFGHANISTAN 6065 6065 2011-09-23 Roberti + White, LLC 8105 Ainsworth Avenue   Springfield VA 22152
972 972 2018-01-01 Kurdistan Democratic Party Seventh Branch (USA and Canada) 2017-07-24 IRAQ 6445 6445 2017-07-24 diGenova & Toensing, LLP 3875 B Plaza Drive   Fairfax VA 22030
1955 1955 2013-02-01 Kongsberg Protech Systems 2011-07-22 NORWAY 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 1725 Duke Street, Suite 600   Alexandria VA 22314
2135 2135 1995-02-07 Festival Shipping & Tourist Enterprises, Ltd. 1991-12-13 CYPRUS 4198 4198 1988-12-16 Eckert International, Inc. Oakton     VA  
2185 2185 1983-02-09 International Reporting Information Systems (IRIS) 1982-12-30 INTERNATIONAL 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Arlington     VA  
2214 2214 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  
2281 2281 1996-02-12 British Aerospace, PLC 1994-06-07 GREAT BRITAIN 3660 3660 1985-03-19 Hyjek & Fix, Inc. Arlington     VA  
2288 2288 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  
2311 2311 1996-02-13 British Aerospace 1994-06-07 GREAT BRITAIN 4918 4918 1994-06-07 Richard B. Ray, Inc. Arlington     VA  
2461 2461 1996-02-16 Thomson-CSF, Inc. 1995-06-08 FRANCE 3700 3700 1985-07-09 Gold & Liebengood, Inc. Alexandria     VA  
2842 2842 1995-02-28 Thomson-CSF, Inc. 1989-02-27 FRANCE 3700 3700 1985-07-09 Gold & Liebengood, Inc. Arlington     VA  
2870 2870 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  
2944 2944 2014-02-28 Katrin Michael, Advocate for Iraqi Christians 2010-03-29 IRAQ 3718 3718 1985-08-07 Holland & Knight 6008 B Ellesmere Court   Alexandria VA 22315
4198 4198 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  
4312 4312 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  
4770 4770 1993-04-06 Heckler & Koch, Inc. 1992-10-21 GREAT BRITAIN 3950 3950 1987-03-20 Robison International, Inc. Sterling     VA  
4829 4829 2019-04-09 American-Turkish Council (ATC) 2019-04-03 TURKEY 6170 6170 2013-05-14 Mercury Public Affairs, LLC 1101 Wilson Blvd. 6th Floor Arlington VA 22209
5129 5129 1992-04-20 Royal Ordnance, Inc. 1987-03-20 GREAT BRITAIN 3950 3950 1987-03-20 Robison International, Inc. Arlington     VA  
6412 6412 1993-05-24 Thomson-CSF, Inc. 1988-10-05 FRANCE 2469 2469 1973-10-23 Burson-Marsteller Arlington     VA  
7008 7008 1986-06-01 Princess Haifa bint Faisal 1985-06-29 SAUDI ARABIA 3707 3707 1985-07-29 Rogers & Cowan, Inc., Washington Office McLean     VA  
7234 7234 1991-06-06 Ceres Enterprises, Inc. 1991-03-08 GREECE 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Reston     VA  
7249 7249 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  
7325 7325 1994-06-10 Matra Aerospace, Inc. 1989-06-09 FRANCE 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Arlington     VA  
7336 7336 1986-06-11 Babak Farzaneh 1985-04-10 IRAN 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC McLean     VA  
7479 7479 1993-06-17 Cable & Wireless North America 1991-05-24 GREAT BRITAIN 4095 4095 1988-03-03 Murphy & Demory, Ltd. Vienna     VA  
7744 7744 1990-06-29 Matra Aerospace, Inc. 1990-01-10 FRANCE 3958 3958 1987-04-09 Edwards, Jack Arlington     VA  
8146 8146 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  
8200 8200 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  
8449 8449 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  
8485 8485 2015-07-01 Transformation and Continuity through Roberti White, LLC 2015-02-27 AFGHANISTAN 5926 5926 2009-04-01 Podesta Group, Inc. 8105 Ainsworth Avenue   Springfield VA 22152
8568 8568 2007-07-05 U.S. Awami League 2007-12-31 BANGLADESH 5844 5844 2007-12-31 Alcalde and Fay 3412 Blair Road   Falls Church VA 22041
8996 8996 1994-07-25 Thomson CSF, Inc. 1992-04-30 FRANCE 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Arlington     VA  
10524 10524 1997-08-31 Ukrainian United Energy Systems 1997-02-20 UKRAINE 3634 3634 1984-11-15 Daniel J. Edelman, Inc. Alexandria     VA  
10717 10717 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  
11456 11456 1991-09-30 Matra Aerospace, Inc. 1990-06-29 FRANCE 4396 4396 1990-06-29 Hand, Arendall, Bedsole, Greaves & Johnson Arlington     VA  
11511 11511 1997-09-30 NABO Traders 1997-08-01 SIERRA LEONE 5148 5148 1996-12-30 Powell Tate, Inc. Arlington     VA  
12013 12013 1989-10-13 CASA Aircraft U.S.A., Inc. 1988-03-17 SPAIN 4106 4106 1988-03-17 Bronheim, David Chantilly     VA  
12286 12286 1986-10-22 Royal Ordnance, U.S.A. 1986-05-30 UNITED KINGDOM 2740 2740 1976-12-17 Hill & Knowlton, Inc. Alexandria     VA  
12590 12590 1988-10-31 ADIG-Investment GmbH 1989-05-31 LIBERIA 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Reston     VA  
12784 12784 2007-10-31 Ukraine Parties of Regions thru Davis Manafort International LLC 2008-01-30 UKRAINE 3657 3657 1985-03-12 Daniel J. Edelman, Inc. 211 North Union Street Suite 250 Alexandria VA 22314
12947 12947 1999-11-01 Republic of Liberia, Embassy 1997-11-24 LIBERIA 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Reston     VA  
13298 13298 1993-11-15 Matra Aerospace, Inc. 1989-05-25 FRANCE 3712 3712 1985-08-05 DLA Piper US LLP Arlington     VA  
13660 13660 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  
13812 13812 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  
15331 15331 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  
15483 15483 1992-12-31 Thomson-CSF, Inc. 1992-05-11 FRANCE 4663 4663 1992-05-11 Mitchell, Williams, Selig, Gates & Woodyard Arlington     VA  
15610 15610 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)
);
Powered by Datasette · Query took 148.486ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history