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 2000-05-31 sorted by Address_1
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 8
Foreign_Principal 8
- BC Lumber Trade Council aka: Council of Forest Industries of British Columbia 1
- Central Bank of the Republic of Turkey 1
- General Wiranto 1
- Government of the Republic of Suriname 1
- Government of the Republic of Zambia 1
- King Faisal Foundation 1
- Partido de la Liberacion Dominicana 1
- Republic of Kazakhstan 1
Country/Location_Represented 8
- CANADA 1
- DOMINICAN REPUBLIC 1
- INDONESIA 1
- KAZAKHSTAN 1
- SAUDI ARABIA 1
- SURINAME 1
- TURKEY 1
- ZAMBIA 1
State 1
- - 8
City 1
- - 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7175 | 7175 | 2000-05-31 | BC Lumber Trade Council aka: Council of Forest Industries of British Columbia | 1999-08-06 | CANADA | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 1300 Park Place, 666 Burrard Street Vancouver, B.C. V6C 3J8 | ||||
7182 | 7182 | 2000-05-31 | Republic of Kazakhstan | 1999-11-08 | KAZAKHSTAN | Kay Collyer & Boose, LLP 5341 | 1999-11-08 | Kay Collyer & Boose, LLP | Administration of the President 11 Beibitshilik Street Astana | ||||
7176 | 7176 | 2000-05-31 | Central Bank of the Republic of Turkey | 1999-10-29 | TURKEY | Hoffman and Hoffman Public Relations 5338 | 1999-10-29 | Hoffman and Hoffman Public Relations | Ankara | ||||
7181 | 7181 | 2000-05-31 | Partido de la Liberacion Dominicana | 2000-01-10 | DOMINICAN REPUBLIC | Strategy Group International, Inc. 5354 | 2000-01-10 | Strategy Group International, Inc. | Avenida Independencia, Esq. Cervantes Santo Domingo | ||||
7177 | 7177 | 2000-05-31 | General Wiranto | 2000-04-27 | INDONESIA | Ein Communications 5369 | 2000-04-27 | Ein Communications | Jakarta | ||||
7179 | 7179 | 2000-05-31 | Government of the Republic of Zambia | 1998-11-16 | ZAMBIA | Roth, L. James 5288 | 1998-11-16 | Roth, L. James | Lusaka | ||||
7178 | 7178 | 2000-05-31 | Government of the Republic of Suriname | 1997-08-28 | SURINAME | Hemisphere Key Consulting, L.L.C. 5204 | 1997-08-28 | Hemisphere Key Consulting, L.L.C. | Paramaribo | ||||
7180 | 7180 | 2000-05-31 | King Faisal Foundation | 1997-09-05 | SAUDI ARABIA | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Riyadh |
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]) );