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" is on date 1998-04-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_1, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 12
- Center for Democracy in Angola, Inc. 1
- Democratic League of Kosova (formerly: Republic of Kosova) 1
- Furness Enterprise, Ltd. 1
- Government of British Columbia, Ministry of Development, Trade & Tourism 1
- Government of Canada 1
- Israel Land Development Company 1
- Meat Industry Council 1
- Nissan Motor Company, Ltd. 1
- Pascal Lissouba 1
- Ranbaxy Laboratories, Ltd. 1
- Trade Representation of the Russian Federation to the United States 1
- Yorkshire & Humberside Development Association 1
Registrant_Name 10
Country/Location_Represented 10
- CANADA 2
- GREAT BRITAIN 2
- ANGOLA 1
- AUSTRALIA 1
- CONGO, DEMOCRATIC REPUBLIC OF THE 1
- INDIA 1
- ISRAEL 1
- JAPAN 1
- KOSOVA 1
- RUSSIA 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5962 | 5962 | 1998-04-30 | Center for Democracy in Angola, Inc. | 1987-08-27 | ANGOLA | Schochet, Kenneth Barry 4033 | 1987-08-27 | Schochet, Kenneth Barry | |||||
5963 | 5963 | 1998-04-30 | Democratic League of Kosova (formerly: Republic of Kosova) | 1993-04-09 | KOSOVA | Shafiq, Nuri 4798 | 1993-04-09 | Shafiq, Nuri | Prishtine | ||||
5964 | 5964 | 1998-04-30 | Furness Enterprise, Ltd. | 1995-10-30 | GREAT BRITAIN | Knorr, D. James 4642 | 1992-04-03 | Knorr, D. James | Cumbria | ||||
5965 | 5965 | 1998-04-30 | Government of British Columbia, Ministry of Development, Trade & Tourism | 1991-09-27 | CANADA | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | British Columbia | ||||
5966 | 5966 | 1998-04-30 | Government of Canada | 1987-03-23 | CANADA | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | |||||
5967 | 5967 | 1998-04-30 | Israel Land Development Company | 1994-04-29 | ISRAEL | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Tel Aviv | ||||
5968 | 5968 | 1998-04-30 | Meat Industry Council | 1997-04-21 | AUSTRALIA | Olsson, Frank & Weeda, P.C. 5175 | 1997-04-21 | Olsson, Frank & Weeda, P.C. | Sydney | ||||
5969 | 5969 | 1998-04-30 | Nissan Motor Company, Ltd. | 1991-02-05 | JAPAN | Policy Consulting Services, Inc. 4471 | 1991-02-05 | Policy Consulting Services, Inc. | Tokyo | ||||
5970 | 5970 | 1998-04-30 | Pascal Lissouba | 1997-12-09 | CONGO, DEMOCRATIC REPUBLIC OF THE | Barron-Birrell, Inc. 5363 | 1997-12-09 | Barron-Birrell, Inc. | Brazzaville | ||||
5971 | 5971 | 1998-04-30 | Ranbaxy Laboratories, Ltd. | 1994-10-28 | INDIA | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | New Delhi | ||||
5972 | 5972 | 1998-04-30 | Trade Representation of the Russian Federation to the United States | 1997-07-22 | RUSSIA | Samuels International Associates, Inc. 4848 | 1993-08-26 | Samuels International Associates, Inc. | Washington | DC | |||
5973 | 5973 | 1998-04-30 | Yorkshire & Humberside Development Association | 1990-10-12 | GREAT BRITAIN | YHDA International 4421 | 1990-10-12 | YHDA International | Leeds |
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]) );