FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where "Foreign_Principal_Termination_Date" is on date 2003-03-31 sorted by Country/Location_Represented
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Foreign_Principal_Registration_Date (date)
Foreign_Principal 18
- ASEAN (Association of Southeast Asian Nations) 1
- Economic Development Authority of Nordrhein-Westfalen 1
- Government of Bolivia, Embassy 1
- Government of Mexico (President Fox Office of Public Opinion, Parametro Consultores S.C., Redes) 1
- Government of Romania, Embassy 1
- I.I.S. Intelligent Information Systems 1
- Japan External Trade Organization 1
- Japan International Agricultural Council 1
- KYOTO Prefectural Government 1
- Kanagawa Prefectural Government 1
- Khalifa Group 1
- Ministry of Foreign Trade and Investment, Government of Bolivia 1
- Port Autonome du Havre 1
- Principality of Liechtenstein 1
- Province of British Columbia Ministry of Energy and Mines 1
- Qualiflyer Group (formerly) Austrian Airlines/Sabena & Swissair 1
- Republic of Singapore, Embassy 1
- Shizuoka Prefectural Government 1
Registrant_Name 13
- APCO Worldwide, Inc. 5
- JETRO, Los Angeles 2
- Barbara Burns & Associates, Inc. 1
- Burhop, William J. 1
- Foster Garvey PC 1
- GPC International 1
- Global Communicators/ Harff Communications, Inc. 1
- InterVISTAS-ga2 Consulting, Inc. 1
- JETRO, New York 1
- MS Research, Inc. 1
- Medley Global Advisors 1
- Ruder Finn, Inc. 1
- Winstead Consulting Group LLC 1
Country/Location_Represented 12
City 1
- - 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4622 | 4622 | 2003-03-31 | Khalifa Group | 2002-06-27 | ALGERIA | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | ATTN: Mr. Rafik A. Khalifa, President Petite provence No. 45 Sidi Yahia Road 16035 Hydra, Algier | ||||
4614 | 4614 | 2003-03-31 | Government of Bolivia, Embassy | 2002-07-03 | BOLIVIA | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | Embassy of the Republic of Bolivia 3014 Massachusetts Avenue, N.W. 20008 | DC | |||
4623 | 4623 | 2003-03-31 | Ministry of Foreign Trade and Investment, Government of Bolivia | 2002-07-30 | BOLIVIA | Global Communicators/ Harff Communications, Inc. 5241 | 1998-03-05 | Global Communicators/ Harff Communications, Inc. | La Paz | ||||
4626 | 4626 | 2003-03-31 | Province of British Columbia Ministry of Energy and Mines | 2003-08-07 | CANADA | Winstead Consulting Group LLC 5573 | 2003-08-07 | Winstead Consulting Group LLC | Resource Development Division External Relations Branch 999 Canada Place, Suite 730 Vancouver, Br | ||||
4624 | 4624 | 2003-03-31 | Port Autonome du Havre | 1991-12-06 | FRANCE | Barbara Burns & Associates, Inc. 4600 | 1991-12-06 | Barbara Burns & Associates, Inc. | Le Havre | ||||
4613 | 4613 | 2003-03-31 | Economic Development Authority of Nordrhein-Westfalen | 2001-03-23 | GERMANY | GPC International 5421 | 2001-03-23 | GPC International | Karalleriestrasse 8-10 D-40213 Dusseldorf | ||||
4612 | 4612 | 2003-03-31 | ASEAN (Association of Southeast Asian Nations) | 2002-10-31 | INTERNATIONAL | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 70A Jalan Sisingamangaraja Jakarta 12110 | ||||
4627 | 4627 | 2003-03-31 | Qualiflyer Group (formerly) Austrian Airlines/Sabena & Swissair | 1994-03-14 | INTERNATIONAL | InterVISTAS-ga2 Consulting, Inc. 4902 | 1994-03-14 | InterVISTAS-ga2 Consulting, Inc. | Vienna | ||||
4617 | 4617 | 2003-03-31 | I.I.S. Intelligent Information Systems | 2002-10-29 | ISRAEL | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Twins One Building 33 Jabotinsky Street Ramat Gan 52511 | ||||
4618 | 4618 | 2003-03-31 | Japan External Trade Organization | 1992-08-10 | JAPAN | MS Research, Inc. 4697 | 1992-08-10 | MS Research, Inc. | Los Angeles | CA | |||
4619 | 4619 | 2003-03-31 | Japan International Agricultural Council | 1999-08-16 | JAPAN | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | Chiyoda-ku Ichiban-cho 19 Tokyo, 102-0082 | ||||
4620 | 4620 | 2003-03-31 | KYOTO Prefectural Government | 1989-05-09 | JAPAN | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | Kyoto City | ||||
4621 | 4621 | 2003-03-31 | Kanagawa Prefectural Government | 1974-05-28 | JAPAN | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | Yokohama | ||||
4629 | 4629 | 2003-03-31 | Shizuoka Prefectural Government | 1974-05-28 | JAPAN | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | Shizuoka | ||||
4625 | 4625 | 2003-03-31 | Principality of Liechtenstein | 2000-09-01 | LIECHTENSTEIN | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 633 Third Avenue, 27th Floor | NY | |||
4615 | 4615 | 2003-03-31 | Government of Mexico (President Fox Office of Public Opinion, Parametro Consultores S.C., Redes) | 2002-03-11 | MEXICO | Medley Global Advisors 5484 | 2002-03-11 | Medley Global Advisors | 27 E. 39th Street New York 10016 | NY | |||
4616 | 4616 | 2003-03-31 | Government of Romania, Embassy | 2002-03-04 | ROMANIA | Burhop, William J. 5479 | 2002-03-04 | Burhop, William J. | 1607 23rd Street, N.W. 20008 | DC | |||
4628 | 4628 | 2003-03-31 | Republic of Singapore, Embassy | 1996-04-26 | SINGAPORE | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | Washington | DC |
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]) );