FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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

9 rows where Country/Location_Represented = "FRANCE" and State = "VA" sorted by Zip

✎ View and edit SQL

This data as json, CSV (advanced)

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

State

Country/Location_Represented

  • FRANCE · 9 ✖

City

  • - 9
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 ▼
2473 2473 1996-02-16 Thomson-CSF, Inc. 1995-06-08 FRANCE 3700 3700 1985-07-09 Gold & Liebengood, Inc. Alexandria     VA  
2862 2862 1995-02-28 Thomson-CSF, Inc. 1989-02-27 FRANCE 3700 3700 1985-07-09 Gold & Liebengood, Inc. Arlington     VA  
6526 6526 1993-05-24 Thomson-CSF, Inc. 1988-10-05 FRANCE 2469 2469 1973-10-23 Burson-Marsteller Arlington     VA  
7457 7457 1994-06-10 Matra Aerospace, Inc. 1989-06-09 FRANCE 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Arlington     VA  
7881 7881 1990-06-29 Matra Aerospace, Inc. 1990-01-10 FRANCE 3958 3958 1987-04-09 Edwards, Jack Arlington     VA  
9151 9151 1994-07-25 Thomson CSF, Inc. 1992-04-30 FRANCE 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Arlington     VA  
11654 11654 1991-09-30 Matra Aerospace, Inc. 1990-06-29 FRANCE 4396 4396 1990-06-29 Hand, Arendall, Bedsole, Greaves & Johnson Arlington     VA  
13548 13548 1993-11-15 Matra Aerospace, Inc. 1989-05-25 FRANCE 3712 3712 1985-08-05 DLA Piper US LLP Arlington     VA  
15763 15763 1992-12-31 Thomson-CSF, Inc. 1992-05-11 FRANCE 4663 4663 1992-05-11 Mitchell, Williams, Selig, Gates & Woodyard 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])
);