FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where "Foreign_Principal_Termination_Date" is on date 2006-07-31
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 8
- Barbados Investment Development Corporation 1
- Ernesto Perez Balladares Gonzalez Revilla 1
- Kashala for President 1
- Korea Trade-Investment Promotion Agency (KOTRA) 1
- Manchester Investment and Development Agency Services (MIDAS) (formerly Trafford Park Development Corporation) 1
- People's Republic of Bangladesh, Embassy 1
- Republic of Ecuador 1
- Republic of Peru 1
Country/Location_Represented 8
- BANGLADESH 1
- BARBADOS 1
- CONGO, REPUBLIC OF THE 1
- ECUADOR 1
- GREAT BRITAIN 1
- KOREA, SOUTH 1
- PANAMA 1
- PERU 1
Registrant_Name 7
City 5
- - 4
- Needham 1
- New York 1
- Quito 1
- Washington 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9862 | 9862 | 2006-07-31 | People's Republic of Bangladesh, Embassy | 2005-09-30 | BANGLADESH | Washington Group 5711 | 2005-09-30 | Washington Group | 3510 International Drive, NW | Washington | DC | 20008 | |
9863 | 9863 | 2006-07-31 | Barbados Investment Development Corporation | 2004-04-26 | BARBADOS | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 800 Second Avenue 2nd Floor New York 10017 | NY | |||
9864 | 9864 | 2006-07-31 | Ernesto Perez Balladares Gonzalez Revilla | 2005-11-23 | PANAMA | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | Eloy Alfaro de Alba | Tapia, Linares Y Alfaro Plaza 2000, Calle 50, Apartado 0816-02984 | |||
9865 | 9865 | 2006-07-31 | Kashala for President | 2006-04-28 | CONGO, REPUBLIC OF THE | Dutko Worldwide, LLC 5693 | 2005-07-01 | Dutko Worldwide, LLC | 687 Highland Avenue | Suite 11 | Needham | MA | 02494 |
9866 | 9866 | 2006-07-31 | Korea Trade-Investment Promotion Agency (KOTRA) | 2006-06-28 | KOREA, SOUTH | KWR International, Inc. 5119 | 1996-07-02 | KWR International, Inc. | 460 Park Avenue | New York | NY | 10022 | |
9867 | 9867 | 2006-07-31 | Manchester Investment and Development Agency Services (MIDAS) (formerly Trafford Park Development Corporation) | 1992-12-17 | GREAT BRITAIN | Oliver A. Dulle, Jr. & Company, Inc. 4739 | 1992-12-17 | Oliver A. Dulle, Jr. & Company, Inc. | Manchester | ||||
9868 | 9868 | 2006-07-31 | Republic of Ecuador | 2006-01-20 | ECUADOR | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | Ministry of Foreign Trade, Industry , Fishing and Competitiveness | Ave. Eloy Alfaro y Amazonas, Edif, MAG-MICIP, 1er Piso, | Quito | ||
9869 | 9869 | 2006-07-31 | Republic of Peru | 2004-06-15 | PERU | Hunton & Williams, LLP 5627 | 2004-06-15 | Hunton & Williams, LLP | Lima |
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]) );