FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Foreign_Principal_Termination_Date = "2002-06-30"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 12
- American Worldwide, Inc./Government of the Republic of Angola 1
- Development Economic Western Switzerland 1
- General Wiranto (Retired) 1
- Georgia Railway, Ltd. 1
- Government of Egypt, Embassy 1
- Government of Jordan 1
- Government of Panama 1
- Government of the Republic of Angola, Embassy 1
- Grand Council of the Crees (of Quebec) 1
- Hong Kong Trade Development Council 1
- Museum of World Religions 1
- South Australia 1
Registrant_Name 11
- Squire Patton Boggs, LLP 2
- Alcalde & Fay, Inc. 1
- Cohen & Woods International, Inc. 1
- Daniel J. Edelman, Inc. 1
- Development Counsellors International 1
- Global Communicators/ Harff Communications, Inc. 1
- Law Office of James A. Dumont, P.C. 1
- Ruder Finn, Inc. 1
- Swidler Berlin Shereff Friedman, LLP 1
- Trans Pacific Partners, LLC 1
- Van Scoyoc Associates, Inc. 1
Country/Location_Represented 11
City 1
- - 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8615 | 8615 | 2002-06-30 | American Worldwide, Inc./Government of the Republic of Angola | 2001-02-14 | ANGOLA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 3 Bethesda Metro Center Suite 600 Bethesda 20814 | MD | |||
8616 | 8616 | 2002-06-30 | Development Economic Western Switzerland | 1998-03-05 | SWITZERLAND | Global Communicators/ Harff Communications, Inc. 5241 | 1998-03-05 | Global Communicators/ Harff Communications, Inc. | Lausanne | ||||
8617 | 8617 | 2002-06-30 | General Wiranto (Retired) | 2001-07-09 | INDONESIA | Trans Pacific Partners, LLC 5445 | 2001-07-09 | Trans Pacific Partners, LLC | Jalan Teluk Betung #42 Jakarta Pusat 10230 | ||||
8618 | 8618 | 2002-06-30 | Georgia Railway, Ltd. | 2002-01-28 | GEORGIA | Swidler Berlin Shereff Friedman, LLP 5469 | 2002-01-28 | Swidler Berlin Shereff Friedman, LLP | 15 Queen Tamara Avenue 380012 Tbilishi | ||||
8619 | 8619 | 2002-06-30 | Government of Egypt, Embassy | 2001-08-10 | EGYPT | Van Scoyoc Associates, Inc. 5401 | 2000-12-14 | Van Scoyoc Associates, Inc. | Egyptian Embassy | DC | |||
8620 | 8620 | 2002-06-30 | Government of Jordan | 2001-04-17 | JORDAN | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Amman | ||||
8621 | 8621 | 2002-06-30 | Government of Panama | 2000-11-02 | PANAMA | Alcalde & Fay, Inc. 5394 | 2000-11-02 | Alcalde & Fay, Inc. | Quarry Height Zone for Panama Republic of Panama | ||||
8622 | 8622 | 2002-06-30 | Government of the Republic of Angola, Embassy | 2001-04-13 | ANGOLA | Cohen & Woods International, Inc. 5003 | 1995-03-10 | Cohen & Woods International, Inc. | Embassy of the Republic of Angola 2100-2108 16th Street, N.W. 20009 | DC | |||
8623 | 8623 | 2002-06-30 | Grand Council of the Crees (of Quebec) | 1989-06-19 | CANADA | Law Office of James A. Dumont, P.C. 4265 | 1989-06-19 | Law Office of James A. Dumont, P.C. | Ottawa, Ontario | ||||
8624 | 8624 | 2002-06-30 | Hong Kong Trade Development Council | 2001-08-10 | HONG KONG | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 36-69 Office Tower Convention Plaza 1 Harbour Road | ||||
8625 | 8625 | 2002-06-30 | Museum of World Religions | 2000-04-27 | INTERNATIONAL | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 11F, No 92, Nanking E. Rd., Sec. 5 Taipei, ROC | ||||
8626 | 8626 | 2002-06-30 | South Australia | 2002-04-29 | AUSTRALIA | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | Regus Tysons Corner 4th Floor 1750 Tysons Boulevard McLean 22102 | VA |
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]) );