FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where "Registrant_Date" is on date 1975-10-28
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 15
- Societe Nationale des Poudres et Explosifs 2
- Airbus Industrie 1
- Arianespace, S.A. 1
- Comturist 1
- Directeur des Relations Internationales de la Delegation Generale pour l'Armement 1
- Government of Morocco 1
- Japanese Information Service 1
- Krauss-Maffei, A.G. 1
- Societe MTE 1
- Societe Nationale Industrielle Aerospatiale 1
- Societe Nationale d'Etude et de Construction de Moteurs d'Aviation 1
- Sofreavia 1
- Thomson-CSF, Division Equipements Avioniques et Spatiaux 1
- Thomson-CSF, Division Systems Electronique 1
- Union de Transports Aeriens 1
Country/Location_Represented 5
- FRANCE 12
- GERMANY, FEDERAL REPUBLIC OF 1
- JAPAN 1
- MOROCCO 1
- ROMANIA 1
Registrant_Name 3
City 1
- - 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1371 | 1371 | 1990-01-16 | Societe Nationale des Poudres et Explosifs | 1989-07-03 | FRANCE | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | Paris | ||||
4362 | 4362 | 1977-03-31 | Japanese Information Service | 1975-10-28 | JAPAN | Roger W. Noyes Associates, Inc. 2623 | 1975-10-28 | Roger W. Noyes Associates, Inc. | New York | NY | |||
6327 | 6327 | 1995-05-04 | Societe Nationale d'Etude et de Construction de Moteurs d'Aviation | 1983-06-15 | FRANCE | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | Paris | ||||
7980 | 7980 | 1985-06-21 | Thomson-CSF, Division Systems Electronique | 1984-07-18 | FRANCE | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | Bagneux | ||||
9010 | 9010 | 1979-07-05 | Krauss-Maffei, A.G. | 1976-01-28 | GERMANY, FEDERAL REPUBLIC OF | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | |||||
9398 | 9398 | 1993-07-21 | Directeur des Relations Internationales de la Delegation Generale pour l'Armement | 1982-06-11 | FRANCE | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | Paris | ||||
10299 | 10299 | 1977-08-12 | Societe MTE | 1976-04-22 | FRANCE | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | Puteaux | ||||
12579 | 12579 | 1980-10-10 | Thomson-CSF, Division Equipements Avioniques et Spatiaux | 1977-10-27 | FRANCE | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | Malakoff | ||||
13094 | 13094 | 1981-10-28 | Union de Transports Aeriens | 1979-07-05 | FRANCE | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | Puteaux | ||||
13095 | 13095 | 1985-10-28 | Arianespace, S.A. | 1985-04-23 | FRANCE | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | Evry | ||||
13120 | 13120 | 1988-10-29 | Societe Nationale des Poudres et Explosifs | 1983-02-25 | FRANCE | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | Paris | ||||
13669 | 13669 | 1993-11-02 | Sofreavia | 1979-06-26 | FRANCE | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | Paris | ||||
13937 | 13937 | 1980-11-14 | Government of Morocco | 1978-09-22 | MOROCCO | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | Rabat | ||||
14937 | 14937 | 1981-12-10 | Societe Nationale Industrielle Aerospatiale | 1975-10-28 | FRANCE | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | Paris | ||||
15027 | 15027 | 1983-12-11 | Airbus Industrie | 1977-07-14 | FRANCE | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | |||||
15487 | 15487 | 1988-12-30 | Comturist | 1975-11-28 | ROMANIA | Tompos, Andy 2622 | 1975-10-28 | Tompos, Andy |
Advanced export
JSON shape: default, array, newline-delimited
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]) );