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 = "1995-03-31" and "Foreign_Principal_Termination_Date" is on date 1995-03-31
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 12
- Cologne International Trade Fairs Formerly: Messe - und Ausstellungs GmbH 1
- Deutscher Industrie - und Handelstag (DIHT) 1
- Dominicana de Aviacion 1
- Finnish Tourist Board (Through the Finnish Tourist Board in New York) 1
- Government of Abu Dhabi 1
- Hong Kong Trade Development Council 1
- Japan National Tourist Organization 1
- Oman Oil Company, Ltd. 1
- Representative of the Patriotic Union of Kurdistan Barham Salih 1
- Republic of Ecuador 1
- Soda Ash Botswana (Pty), Ltd. 1
- West Cumbria Development Agency 1
Registrant_Name 11
- German-American Chamber of Commerce of Chicago 2
- Baker Botts L.L.P. 1
- Finnish Tourist Board, Los Angeles 1
- Greenberg, Traurig, Hoffman, Lipoff, Rosen & Quentel, P.A. 1
- Hill and Knowlton Strategies, LLC 1
- Japan National Tourist Organization, Dallas 1
- Knorr, D. James 1
- Korn, David A. 1
- Paul, Weiss, Rifkind, Wharton & Garrison 1
- Williams & Jensen, P.C. 1
- Winston & Strawn 1
Country/Location_Represented 11
- GERMANY 2
- BOTSWANA 1
- DOMINICAN REPUBLIC 1
- ECUADOR 1
- FINLAND 1
- GREAT BRITAIN 1
- HONG KONG 1
- IRAN 1
- JAPAN 1
- OMAN 1
- UNITED ARAB EMIRATES 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4535 | 4535 | 1995-03-31 | Cologne International Trade Fairs Formerly: Messe - und Ausstellungs GmbH | 1972-12-21 | GERMANY | German-American Chamber of Commerce of Chicago 1878 | 1965-04-06 | German-American Chamber of Commerce of Chicago | Cologne | ||||
4536 | 4536 | 1995-03-31 | Deutscher Industrie - und Handelstag (DIHT) | 1965-06-03 | GERMANY | German-American Chamber of Commerce of Chicago 1878 | 1965-04-06 | German-American Chamber of Commerce of Chicago | Bonn | ||||
4537 | 4537 | 1995-03-31 | Dominicana de Aviacion | 1994-02-18 | DOMINICAN REPUBLIC | Greenberg, Traurig, Hoffman, Lipoff, Rosen & Quentel, P.A. 4817 | 1993-06-14 | Greenberg, Traurig, Hoffman, Lipoff, Rosen & Quentel, P.A. | Santo Domingo | ||||
4538 | 4538 | 1995-03-31 | Finnish Tourist Board (Through the Finnish Tourist Board in New York) | 1987-08-25 | FINLAND | Finnish Tourist Board, Los Angeles 4030 | 1987-08-25 | Finnish Tourist Board, Los Angeles | Helsinki | ||||
4539 | 4539 | 1995-03-31 | Government of Abu Dhabi | 1992-07-29 | UNITED ARAB EMIRATES | Baker Botts L.L.P. 4293 | 1989-09-15 | Baker Botts L.L.P. | |||||
4540 | 4540 | 1995-03-31 | Hong Kong Trade Development Council | 1994-02-09 | HONG KONG | Winston & Strawn 3869 | 1986-08-13 | Winston & Strawn | |||||
4541 | 4541 | 1995-03-31 | Japan National Tourist Organization | 1972-07-03 | JAPAN | Japan National Tourist Organization, Dallas 2348 | 1972-07-03 | Japan National Tourist Organization, Dallas | Tokyo | ||||
4542 | 4542 | 1995-03-31 | Oman Oil Company, Ltd. | 1995-02-03 | OMAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Hamilton | ||||
4543 | 4543 | 1995-03-31 | Representative of the Patriotic Union of Kurdistan Barham Salih | 1993-03-03 | IRAN | Korn, David A. 4773 | 1993-03-03 | Korn, David A. | Annandale | VA | |||
4544 | 4544 | 1995-03-31 | Republic of Ecuador | 1994-10-20 | ECUADOR | Williams & Jensen, P.C. 4858 | 1993-10-07 | Williams & Jensen, P.C. | Washington | DC | |||
4545 | 4545 | 1995-03-31 | Soda Ash Botswana (Pty), Ltd. | 1994-01-28 | BOTSWANA | Paul, Weiss, Rifkind, Wharton & Garrison 4539 | 1991-07-09 | Paul, Weiss, Rifkind, Wharton & Garrison | Francistown | ||||
4546 | 4546 | 1995-03-31 | West Cumbria Development Agency | 1992-04-03 | GREAT BRITAIN | Knorr, D. James 4642 | 1992-04-03 | Knorr, D. James | Cumbria |
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]) );