FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where "Registrant_Date" is on date 1988-02-19
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number
Foreign_Principal 7
Address_1 5 ✖
- Washington 3
- - 1
- Edmonton, Alberta 1
- Helsinki 1
- Warsaw 1
Registrant_Name 2
City 1
- - 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2984 | 2984 | 1992-02-28 | Government of Poland, Ministry of Privatization | 1992-03-20 | POLAND | Henry J. Kaufman & Associates, Inc. 4093 | 1988-02-19 | Henry J. Kaufman & Associates, Inc. | Warsaw | ||||
5842 | 5842 | 1989-04-30 | Alberta Public Affairs Bureau | 1989-01-27 | CANADA | Henry J. Kaufman & Associates, Inc. 4093 | 1988-02-19 | Henry J. Kaufman & Associates, Inc. | Edmonton, Alberta | ||||
7924 | 7924 | 1991-06-18 | People's Democratic Republic of Ethiopia Embassy of Ethiopia | 1990-08-08 | ETHIOPIA | Henry J. Kaufman & Associates, Inc. 4093 | 1988-02-19 | Henry J. Kaufman & Associates, Inc. | Washington | DC | |||
11686 | 11686 | 1993-09-17 | Negara Brunei Darussalam | 1988-02-19 | BRUNEI | Henry J. Kaufman & Associates, Inc. 4093 | 1988-02-19 | Henry J. Kaufman & Associates, Inc. | |||||
12471 | 12471 | 1994-10-04 | Turkish Ministry of Tourism | 1992-06-08 | TURKEY | Henry J. Kaufman & Associates, Inc. 4093 | 1988-02-19 | Henry J. Kaufman & Associates, Inc. | Washington | DC | |||
13847 | 13847 | 1990-11-09 | Republic of Rwanda | 1990-09-28 | RWANDA | Henry J. Kaufman & Associates, Inc. 4093 | 1988-02-19 | Henry J. Kaufman & Associates, Inc. | Washington | DC | |||
16129 | 16129 | 1989-12-31 | Ministry for Foreign Affairs, Finland | 1988-02-19 | FINLAND | Haworth, James David Stewart 4090 | 1988-02-19 | Haworth, James David Stewart | Helsinki |
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]) );