FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Foreign_Principal_Termination_Date = "1995-05-31"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date)
Foreign_Principal 10
- Fondo Nacional de Fomento al Turismo (FONATUR) 2
- Agusta Group 1
- Fernando Marin Radical Party of Argentina 1
- Government of Quebec 1
- Government of Ukraine 1
- Government of Ukraine, Office of the President 1
- Government of the State of Quintana Roo Through Banco Nacional de Mexico, S.N.C., as Trustee (Cancun Trust) 1
- Korean Overseas Information Service 1
- M.K.O. Abiola (Nigerian President - Elect) 1
- Mexican Tourism Council (CONATUR) 1
Registrant_Name 8
Country/Location_Represented 7
City 1
- - 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7138 | 7138 | 1995-05-31 | Agusta Group | 1993-09-02 | ITALY | Capitoline/MS&L 4529 | 1991-06-20 | Capitoline/MS&L | Milano | ||||
7139 | 7139 | 1995-05-31 | Fernando Marin Radical Party of Argentina | 1995-05-12 | ARGENTINA | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Buenos Aires | ||||
7140 | 7140 | 1995-05-31 | Fondo Nacional de Fomento al Turismo (FONATUR) | 1990-02-01 | MEXICO | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | |||||
7141 | 7141 | 1995-05-31 | Fondo Nacional de Fomento al Turismo (FONATUR) | 1984-07-24 | MEXICO | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | |||||
7142 | 7142 | 1995-05-31 | Government of Quebec | 1995-03-15 | CANADA | Bergner Bockorny, Inc. 3801 | 1986-03-20 | Bergner Bockorny, Inc. | Quebec | ||||
7143 | 7143 | 1995-05-31 | Government of Ukraine | 1993-05-17 | UKRAINE | Morin, Robert E. 4803 | 1993-05-17 | Morin, Robert E. | Washington | DC | |||
7144 | 7144 | 1995-05-31 | Government of Ukraine, Office of the President | 1992-04-27 | UKRAINE | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Kiev | ||||
7145 | 7145 | 1995-05-31 | Government of the State of Quintana Roo Through Banco Nacional de Mexico, S.N.C., as Trustee (Cancun Trust) | 1989-08-16 | MEXICO | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | |||||
7146 | 7146 | 1995-05-31 | Korean Overseas Information Service | 1994-07-29 | KOREA, SOUTH | Strategic Communications & Information Services, Inc. 4934 | 1994-07-29 | Strategic Communications & Information Services, Inc. | Seoul | ||||
7147 | 7147 | 1995-05-31 | M.K.O. Abiola (Nigerian President - Elect) | 1993-12-08 | NIGERIA | Echols, Randall Edwin, Sr. 4873 | 1993-12-08 | Echols, Randall Edwin, Sr. | London | ||||
7148 | 7148 | 1995-05-31 | Mexican Tourism Council (CONATUR) | 1984-07-24 | MEXICO | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. |
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]) );