FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where "Foreign_Principal_Termination_Date" is on date 1997-09-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 6
Foreign_Principal 6
Country/Location_Represented 6
- AUSTRALIA 1
- CANADA 1
- GREAT BRITAIN 1
- NEW ZEALAND 1
- SIERRA LEONE 1
- TURKEY 1
City 1
- - 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12084 | 12084 | 1997-09-30 | Australian Oat Exporters' Group | 1995-07-24 | AUSTRALIA | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | Perth | ||||
12085 | 12085 | 1997-09-30 | British Columbia (Province of) | 1997-06-20 | CANADA | Baker & McKenzie 4591 | 1991-11-12 | Baker & McKenzie | Victoria, BC | ||||
12086 | 12086 | 1997-09-30 | NABO Traders | 1997-08-01 | SIERRA LEONE | Powell Tate, Inc. 5148 | 1996-12-30 | Powell Tate, Inc. | Arlington | VA | |||
12087 | 12087 | 1997-09-30 | New Zealand Dairy Board | 1995-10-12 | NEW ZEALAND | Witeck-Combs Communications 5058 | 1995-10-12 | Witeck-Combs Communications | Wellington | ||||
12088 | 12088 | 1997-09-30 | Office of the Prime Minister, Republic of Turkey | 1994-12-01 | TURKEY | Abernathy/MacGregor Group, Inc. 4834 | 1992-12-11 | Abernathy/MacGregor Group, Inc. | Ankara | ||||
12089 | 12089 | 1997-09-30 | Tower Management, Ltd. | 1997-02-13 | GREAT BRITAIN | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | London |
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]) );