FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Foreign_Principal_Registration_Date" is on date 1993-03-03 sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date)
Foreign_Principal 11
- ELTAC 1
- Government of Bolivia 1
- Interim Government of National Unity of the Republic of Liberia 1
- L'Union des Industries Textiles (1'UIT) 1
- Mr. Jean-Pierre Lemboumba 1
- Representative of the Patriotic Union of Kurdistan Barham Salih 1
- Republic of Guyana 1
- Saharawi Arab Democratic Republic 1
- Supreme Court of Justice of the Republic of Guatemala 1
- United Coconut Association of the Philippines 1
- United Front for Multiparty Democracy in Malawi 1
Country/Location_Represented 11
Registrant_Name 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3506 | 3506 | 1995-03-07 | Mr. Jean-Pierre Lemboumba | 1993-03-03 | GABON | David E. Morey 4688 | 1992-07-09 | David E. Morey | Paris | ||||
5019 | 5019 | 1994-04-04 | L'Union des Industries Textiles (1'UIT) | 1993-03-03 | FRANCE | David E. Morey 4688 | 1992-07-09 | David E. Morey | Paris | ||||
5020 | 5020 | 1994-04-04 | ELTAC | 1993-03-03 | INTERNATIONAL | David E. Morey 4688 | 1992-07-09 | David E. Morey | Brussels | ||||
1222 | 1222 | 1994-01-11 | Interim Government of National Unity of the Republic of Liberia | 1993-03-03 | LIBERIA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Monrovia | ||||
1224 | 1224 | 1994-01-11 | United Coconut Association of the Philippines | 1993-03-03 | PHILIPPINES | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Manila | ||||
15324 | 15324 | 1994-12-22 | Saharawi Arab Democratic Republic | 1993-03-03 | ALGERIA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Tindouf | ||||
15325 | 15325 | 1994-12-22 | Supreme Court of Justice of the Republic of Guatemala | 1993-03-03 | GUATEMALA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Guatemala City | ||||
15326 | 15326 | 1994-12-22 | United Front for Multiparty Democracy in Malawi | 1993-03-03 | MALAWI | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Lusaka | ||||
16507 | 16507 | 2001-12-31 | Republic of Guyana | 1993-03-03 | GUYANA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Georgetown | ||||
4543 | 4543 | 1995-03-31 | Representative of the Patriotic Union of Kurdistan Barham Salih | 1993-03-03 | IRAN | Korn, David A. 4773 | 1993-03-03 | Korn, David A. | Annandale | VA | |||
9077 | 9077 | 1994-07-07 | Government of Bolivia | 1993-03-03 | BOLIVIA | Rowles, James P. 4774 | 1993-03-03 | Rowles, James P. | La Paz |
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]) );