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 1998-02-28 sorted by Foreign_Principal
This data as json, CSV (advanced)
Suggested facets: Registrant_Date (date)
Registrant_Name 6
Foreign_Principal 6
Country/Location_Represented 6
- AUSTRIA 1
- DENMARK 1
- GREAT BRITAIN 1
- ITALY 1
- MOZAMBIQUE 1
- NEW ZEALAND 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3022 | 3022 | 1998-02-28 | A.P. Moller-Maersk | 1994-11-07 | DENMARK | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | Copenhagen | ||||
3023 | 3023 | 1998-02-28 | Austrian Freedom Party | 1997-01-27 | AUSTRIA | Carmen Group, Inc. & Linton, Mields, Reisler & Cottone, Inc. 4855 | 1993-09-30 | Carmen Group, Inc. & Linton, Mields, Reisler & Cottone, Inc. | Vienna | ||||
3024 | 3024 | 1998-02-28 | David Atkinson, House of Commons | 1998-02-11 | GREAT BRITAIN | Pittaway, George 5233 | 1998-02-11 | Pittaway, George | London | ||||
3025 | 3025 | 1998-02-28 | Government of the Republic of Mozambique, Embassy | 1996-11-25 | MOZAMBIQUE | Cohen & Woods International, Inc. 5003 | 1995-03-10 | Cohen & Woods International, Inc. | Washington | DC | |||
3026 | 3026 | 1998-02-28 | New Zealand Tourism Board | 1998-07-13 | NEW ZEALAND | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | Santa Monica | CA | |||
3027 | 3027 | 1998-02-28 | Trentino Tourist Board (A.P.T.T.) | 1995-04-18 | ITALY | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Trento |
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]) );