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" is on date 2002-09-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date (date)
Registrant_Name 11
Foreign_Principal 11
- BIZINFO, Ltd. 1
- General Rashid Dostum, Commander & President, Afghanistan Northern Alliance Junbish Party 1
- Government of Argentina - Ministry of Finance 1
- Government of Zimbabwe, Embassy 1
- Government of the Republic of Macedonia (F.Y.R.O.M.) Transit Corridor Commission 1
- Instituto Latinoamericano del Fierro y el Acero 1
- Northern Ireland Women's Coalition 1
- Office of the Nagorno Karabakh Republic 1
- Republic of Haiti 1
- Secretary of State for Foreign and Commonwealth Affairs, London, England 1
- West Midlands Development Agency 1
Country/Location_Represented 10
- GREAT BRITAIN 2
- AFGHANISTAN 1
- ARGENTINA 1
- CHILE 1
- HAITI 1
- MACEDONIA 1
- MALAWI 1
- NAGORNO KARABAKH 1
- NORTHERN IRELAND 1
- ZIMBABWE 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12131 | 12131 | 2002-09-30 | Northern Ireland Women's Coalition | 1999-03-12 | NORTHERN IRELAND | Rhoney, Colette T. 5305 | 1999-03-12 | Rhoney, Colette T. | 52 Elmwood Avenue, Belfast | ||||
12132 | 12132 | 2002-09-30 | BIZINFO, Ltd. | 2001-10-30 | MALAWI | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | Monex International Trade Center, Suite 306 Baja Toiruu - 35 Ulaanbaatar CPO Box 1001 | ||||
12133 | 12133 | 2002-09-30 | General Rashid Dostum, Commander & President, Afghanistan Northern Alliance Junbish Party | 2002-02-11 | AFGHANISTAN | Philip S. Smith & Associates, Inc. 5471 | 2002-02-11 | Philip S. Smith & Associates, Inc. | Military Headquarters, Mazar-e-Sharif | ||||
12134 | 12134 | 2002-09-30 | Government of Argentina - Ministry of Finance | 2002-03-11 | ARGENTINA | Medley Global Advisors 5484 | 2002-03-11 | Medley Global Advisors | 1901 L Street Office 606 20036 | DC | |||
12135 | 12135 | 2002-09-30 | Government of Zimbabwe, Embassy | 2000-09-13 | ZIMBABWE | Cohen & Woods International, Inc. 5003 | 1995-03-10 | Cohen & Woods International, Inc. | 1608 New Hampshire Avenue, N.W. | DC | |||
12136 | 12136 | 2002-09-30 | Government of the Republic of Macedonia (F.Y.R.O.M.) Transit Corridor Commission | 2001-03-21 | MACEDONIA | Bakalov, Stoyan I. 5417 | 2001-03-21 | Bakalov, Stoyan I. | Ilindenska bb 91000 Skopje | ||||
12137 | 12137 | 2002-09-30 | Instituto Latinoamericano del Fierro y el Acero | 2002-02-14 | CHILE | Public Strategies, Inc. 5472 | 2002-02-14 | Public Strategies, Inc. | Benjamin 2944 5 Piso, Las Condes Casilla 160656 Santiago 9 | ||||
12138 | 12138 | 2002-09-30 | Office of the Nagorno Karabakh Republic | 2002-07-02 | NAGORNO KARABAKH | Williams, Paul R. 5507 | 2002-07-02 | Williams, Paul R. | 122 C Street, N.W. Suite 360 20001 | DC | |||
12139 | 12139 | 2002-09-30 | Republic of Haiti | 2002-02-25 | HAITI | Global Market Solutions 5475 | 2002-02-25 | Global Market Solutions | Port-au-Prince | ||||
12140 | 12140 | 2002-09-30 | Secretary of State for Foreign and Commonwealth Affairs, London, England | 2000-09-05 | GREAT BRITAIN | Medialink Worldwide Inc. 5382 | 2000-09-05 | Medialink Worldwide Inc. | Foreign and Commonwealth Office Room WH553 King Charles Street Whitehall - London SWIA 2AH | ||||
12141 | 12141 | 2002-09-30 | West Midlands Development Agency | 1992-10-20 | GREAT BRITAIN | Tripp, Umbach & Associates, Inc. 4724 | 1992-10-20 | Tripp, Umbach & Associates, Inc. | Birmingham |
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]) );