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

8 rows where Registration_Number = 812

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 2

Country/Location_Represented 2

Registrant_Name 1

City 1

  • - 8
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
1970 1970 1967-02-01 Askania-Werke Aktiengesellschaft 1955-08-22 GERMANY, FEDERAL REPUBLIC OF Boykin & De Francis 812 1954-01-21 Boykin & De Francis Berlin-Friedenan        
1972 1972 1967-02-01 Carl Zeiss 1958-02-17 GERMANY, FEDERAL REPUBLIC OF Boykin & De Francis 812 1954-01-21 Boykin & De Francis          
1974 1974 1967-02-01 Dr. Rolf C. Galler 1957-02-27 GERMANY, FEDERAL REPUBLIC OF Boykin & De Francis 812 1954-01-21 Boykin & De Francis          
1975 1975 1967-02-01 Government of Italy 1959-09-15 ITALY Boykin & De Francis 812 1954-01-21 Boykin & De Francis          
1976 1976 1967-02-01 Mrs. Claire Hugo Stinnes, Sr. 1955-01-12 GERMANY, FEDERAL REPUBLIC OF Boykin & De Francis 812 1954-01-21 Boykin & De Francis Mulheim-Ruhr        
1977 1977 1967-02-01 Studiengesellschaft fur Privatrechtliche Auslandinteressen, e.V. 1955-01-12 GERMANY, FEDERAL REPUBLIC OF Boykin & De Francis 812 1954-01-21 Boykin & De Francis Bremen        
4138 4138 1968-03-29 Diplomatic Mission of the Federal Republic of Germany 1954-01-21 GERMANY, FEDERAL REPUBLIC OF Boykin & De Francis 812 1954-01-21 Boykin & De Francis Washington     DC  
4139 4139 1968-03-29 Embassy of the Federal Republic of Germany 1957-07-09 GERMANY, FEDERAL REPUBLIC OF Boykin & De Francis 812 1954-01-21 Boykin & De Francis Washington     DC  

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])
);