FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where "Foreign_Principal_Termination_Date" is on date 1990-07-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Registrant_Date (date)
Registrant_Name 16
- IPG DXTRA, Inc 2
- Baron/Canning & Company, Inc. 1
- Brownstein, Zeidman & Lore 1
- China Media Services, Inc. 1
- Daniel J. Edelman, Inc. 1
- David D. O'Brien & Associates 1
- Levine & Company 1
- Maloney, Valerie Pease 1
- Martin, Dennis G. 1
- Miluski, Krystine R.L. 1
- O'Brien, David D. 1
- Paul, Weiss, Rifkind, Wharton & Garrison 1
- Phoenix, Paul J. 1
- Wagner, Hines & Avary, Inc. 1
- Wilson, H. Graham 1
- van Kloberg & Associates, Ltd. 1
Foreign_Principal 14
- Dofasco, Inc. 3
- Jovian Publishing Group 2
- Alliance of Yemeni Opposition Groups 1
- China Tourism Audio-Visual Publication Company 1
- Conservatives Abroad 1
- Electronic Industries Association of Japan 1
- Embassy of the Republic of Benin 1
- Friends of Democracy in Pakistan, Ltd. 1
- Government of the Philippines 1
- Islami Jamhoori Ittehad of America (IJI of America")" 1
- Italian Trade Commission 1
- Mirabella 1
- NEC Corporation (Tokyo) NEC America, Inc. (U.S. subsidiary of NEC Corporation) 1
- Universal Furniture, Ltd. 1
Country/Location_Represented 11
City 1
- - 17
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9766 | 9766 | 1990-07-31 | Alliance of Yemeni Opposition Groups | 1990-02-08 | YEMEN | Wagner, Hines & Avary, Inc. 3845 | 1986-06-18 | Wagner, Hines & Avary, Inc. | Washington | DC | |||
9767 | 9767 | 1990-07-31 | China Tourism Audio-Visual Publication Company | 1986-03-11 | CHINA | China Media Services, Inc. 3793 | 1986-03-11 | China Media Services, Inc. | Biejing | ||||
9768 | 9768 | 1990-07-31 | Conservatives Abroad | 1990-01-09 | GREAT BRITAIN | Maloney, Valerie Pease 4329 | 1990-01-09 | Maloney, Valerie Pease | London | ||||
9769 | 9769 | 1990-07-31 | Dofasco, Inc. | 1984-02-07 | CANADA | Wilson, H. Graham 3559 | 1984-02-07 | Wilson, H. Graham | Ontario | ||||
9770 | 9770 | 1990-07-31 | Dofasco, Inc. | 1987-02-11 | CANADA | Martin, Dennis G. 3937 | 1987-02-11 | Martin, Dennis G. | Ontario | ||||
9771 | 9771 | 1990-07-31 | Dofasco, Inc. | 1984-08-02 | CANADA | Phoenix, Paul J. 3607 | 1984-08-02 | Phoenix, Paul J. | Ontario | ||||
9772 | 9772 | 1990-07-31 | Electronic Industries Association of Japan | 1972-06-14 | JAPAN | Baron/Canning & Company, Inc. 2270 | 1971-07-23 | Baron/Canning & Company, Inc. | Tokyo | ||||
9773 | 9773 | 1990-07-31 | Embassy of the Republic of Benin | 1990-06-22 | BENIN | van Kloberg & Associates, Ltd. 3466 | 1983-05-09 | van Kloberg & Associates, Ltd. | Washington | DC | |||
9774 | 9774 | 1990-07-31 | Friends of Democracy in Pakistan, Ltd. | 1989-09-07 | PAKISTAN | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Charlestown | ||||
9775 | 9775 | 1990-07-31 | Government of the Philippines | 1990-03-29 | PHILIPPINES | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Manila | ||||
9776 | 9776 | 1990-07-31 | Islami Jamhoori Ittehad of America (IJI of America")" | 1989-09-11 | PAKISTAN | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | New York | NY | |||
9777 | 9777 | 1990-07-31 | Italian Trade Commission | 1985-04-08 | ITALY | Miluski, Krystine R.L. 3668 | 1985-04-08 | Miluski, Krystine R.L. | West Dundee | IL | |||
9778 | 9778 | 1990-07-31 | Jovian Publishing Group | 1990-03-21 | TAIWAN | David D. O'Brien & Associates 4165 | 1988-08-04 | David D. O'Brien & Associates | Taiwan | ||||
9779 | 9779 | 1990-07-31 | Jovian Publishing Group | 1990-03-21 | TAIWAN | O'Brien, David D. 4355 | 1990-03-21 | O'Brien, David D. | Taipei | ||||
9780 | 9780 | 1990-07-31 | Mirabella | 1989-12-01 | ITALY | Levine & Company 3971 | 1987-04-29 | Levine & Company | Caserta | ||||
9781 | 9781 | 1990-07-31 | NEC Corporation (Tokyo) NEC America, Inc. (U.S. subsidiary of NEC Corporation) | 1985-05-10 | JAPAN | Paul, Weiss, Rifkind, Wharton & Garrison 3647 | 1985-02-04 | Paul, Weiss, Rifkind, Wharton & Garrison | Tokyo | ||||
9782 | 9782 | 1990-07-31 | Universal Furniture, Ltd. | 1988-08-15 | HONG KONG | Brownstein, Zeidman & Lore 3744 | 1985-10-03 | Brownstein, Zeidman & Lore |
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]) );