FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where "Foreign_Principal_Termination_Date" is on date 1989-03-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_1, Registrant_Date (date)
Foreign_Principal 16
- ASEA, A.B 1
- Asea, A.B. 1
- Bermuda Government 1
- Cook Islands Government 1
- Embassy of Canada (Government of Canada) 1
- Embassy of Japan 1
- Flat Glass Association of Japan 1
- Government of Canada 1
- Haitian Federation of Private Sector Associations 1
- Investment Promotion Council for the Dominican Republic 1
- Japan Iron & Steel Exporters' Association 1
- MLC Funds Management 1
- Minorco Societe Anonyme 1
- National Republican Alliance of El Salvador (ARENA) 1
- Tourism Authority of Thailand 1
- Transcontinental Consultancy (Pty), Ltd. 1
Registrant_Name 14
- APCO Associates 2
- Arnold & Porter Kaye Scholer LLP 2
- Alan M. Porten & Associates, Inc. 1
- Donald G. Lerch, Jr. & Company, Inc. 1
- Hill, Holliday, Connors, Cosmopulos, Inc. 1
- Lou Hammond & Associates, Inc. 1
- Namibia News Bureau 1
- O'Connor & Hannan, L.L.P. 1
- Pacific Islands, Washington Office 1
- Ragan & Mason 1
- Scanlon, Thomas J. 1
- Shearman & Sterling 1
- Tanaka, Michele N. 1
- Whitehouse Associates, Inc. 1
Country/Location_Represented 12
- JAPAN 3
- CANADA 2
- SWEDEN 2
- AUSTRALIA 1
- BERMUDA 1
- COOK ISLANDS 1
- DOMINICAN REPUBLIC 1
- EL SALVADOR 1
- HAITI 1
- LUXEMBOURG 1
- NAMIBIA 1
- THAILAND 1
City 1
- - 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4456 | 4456 | 1989-03-31 | Japan Iron & Steel Exporters' Association | 1986-01-13 | JAPAN | Whitehouse Associates, Inc. 2190 | 1970-02-24 | Whitehouse Associates, Inc. | Tokyo | ||||
4457 | 4457 | 1989-03-31 | ASEA, A.B | 1986-02-10 | SWEDEN | APCO Associates 3597 | 1984-06-20 | APCO Associates | Vasteras | ||||
4458 | 4458 | 1989-03-31 | Asea, A.B. | 1986-02-03 | SWEDEN | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Vasteras | ||||
4459 | 4459 | 1989-03-31 | Bermuda Government | 1978-10-05 | BERMUDA | Ragan & Mason 1678 | 1964-01-03 | Ragan & Mason | Hamilton | ||||
4460 | 4460 | 1989-03-31 | Cook Islands Government | 1986-11-03 | COOK ISLANDS | Pacific Islands, Washington Office 3903 | 1986-11-03 | Pacific Islands, Washington Office | Raotonga | ||||
4461 | 4461 | 1989-03-31 | Embassy of Canada (Government of Canada) | 1985-07-01 | CANADA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Washington | DC | |||
4462 | 4462 | 1989-03-31 | Embassy of Japan | 1970-12-09 | JAPAN | Donald G. Lerch, Jr. & Company, Inc. 2089 | 1968-04-22 | Donald G. Lerch, Jr. & Company, Inc. | DC | ||||
4463 | 4463 | 1989-03-31 | Flat Glass Association of Japan | 1981-07-01 | JAPAN | Tanaka, Michele N. 948 | 1956-04-24 | Tanaka, Michele N. | |||||
4464 | 4464 | 1989-03-31 | Government of Canada | 1987-11-13 | CANADA | APCO Associates 3597 | 1984-06-20 | APCO Associates | Washington | DC | |||
4465 | 4465 | 1989-03-31 | Haitian Federation of Private Sector Associations | 1989-04-11 | HAITI | Scanlon, Thomas J. 3500 | 1983-07-12 | Scanlon, Thomas J. | Port au Prince | ||||
4466 | 4466 | 1989-03-31 | Investment Promotion Council for the Dominican Republic | 1988-05-04 | DOMINICAN REPUBLIC | Alan M. Porten & Associates, Inc. 4136 | 1988-05-04 | Alan M. Porten & Associates, Inc. | |||||
4467 | 4467 | 1989-03-31 | MLC Funds Management | 1988-11-16 | AUSTRALIA | Hill, Holliday, Connors, Cosmopulos, Inc. 3810 | 1986-04-10 | Hill, Holliday, Connors, Cosmopulos, Inc. | Sydney | ||||
4468 | 4468 | 1989-03-31 | Minorco Societe Anonyme | 1989-01-23 | LUXEMBOURG | Shearman & Sterling 4208 | 1989-01-23 | Shearman & Sterling | Luxembourg, Ville RC | ||||
4469 | 4469 | 1989-03-31 | National Republican Alliance of El Salvador (ARENA) | 1988-10-25 | EL SALVADOR | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | San Salvador | ||||
4470 | 4470 | 1989-03-31 | Tourism Authority of Thailand | 1985-05-23 | THAILAND | Lou Hammond & Associates, Inc. 3682 | 1985-05-23 | Lou Hammond & Associates, Inc. | New York | NY | |||
4471 | 4471 | 1989-03-31 | Transcontinental Consultancy (Pty), Ltd. | 1987-06-30 | NAMIBIA | Namibia News Bureau 4005 | 1987-06-30 | Namibia News Bureau | Windhoek |
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]) );