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 1992-12-31 sorted by Address_1
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 16
- Algoma Steel Corporation, Ltd. 2
- Air India 1
- Bangladesh Garment Manufacturers' & Exporters' Association 1
- Barbados Board of Tourism 1
- Barbados Industrial Development Corporation 1
- Consulate General of Israel, Midwest State of Israel 1
- Corporation of Lloyd's 1
- Fyffes, PLC 1
- Government of Portugal, Ministry for Foreign Affairs 1
- Jiewon Park 1
- Norsk Hydro, A.S. 1
- Quincentennial Foundation of Istanbul 1
- Republic of Slovenia 1
- Thomson-CSF, Inc. 1
- Ukrainian Branch of the World Laboratory (& Ministries) 1
- Underwriters at Lloyd's 1
Registrant_Name 14
- Van Brunt & Company Advertising-Marketing, Inc. 3
- GCI Group, Inc. 2
- Beckett, William C. 1
- David E. Morey 1
- Deborah Gordon Public Relations 1
- Hudson, Gerry B. 1
- Kleban & Samor, P.C. 1
- Lord, Alan 1
- Mitchell, Williams, Selig, Gates & Woodyard 1
- Mudge, Rose, Guthrie, Alexander & Ferdon 1
- Office of the Republic of Slovenia 1
- Portuguese National Tourist Office 1
- Ruder Finn, Inc. 1
- de Korte, Derek M. 1
Country/Location_Represented 14
- BARBADOS 2
- CANADA 2
- GREAT BRITAIN 2
- BANGLADESH 1
- FRANCE 1
- INDIA 1
- IRELAND 1
- ISRAEL 1
- KOREA, SOUTH 1
- NORWAY 1
- PORTUGAL 1
- SLOVENIA 1
- TURKEY 1
- UKRAINE 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16241 | 16241 | 1992-12-31 | Thomson-CSF, Inc. | 1992-05-11 | FRANCE | Mitchell, Williams, Selig, Gates & Woodyard 4663 | 1992-05-11 | Mitchell, Williams, Selig, Gates & Woodyard | Arlington | VA | |||
16229 | 16229 | 1992-12-31 | Air India | 1980-11-20 | INDIA | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | Bombay | ||||
16233 | 16233 | 1992-12-31 | Barbados Industrial Development Corporation | 1964-04-02 | BARBADOS | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | Bridgetown | ||||
16234 | 16234 | 1992-12-31 | Consulate General of Israel, Midwest State of Israel | 1998-02-12 | ISRAEL | Deborah Gordon Public Relations 5229 | 1992-05-22 | Deborah Gordon Public Relations | Chicago | IL | |||
16226 | 16226 | 1992-12-31 | Bangladesh Garment Manufacturers' & Exporters' Association | 1992-07-27 | BANGLADESH | Mudge, Rose, Guthrie, Alexander & Ferdon 3200 | 1981-02-18 | Mudge, Rose, Guthrie, Alexander & Ferdon | Dhaka | ||||
16235 | 16235 | 1992-12-31 | Fyffes, PLC | 1990-09-27 | IRELAND | Ruder Finn, Inc. 4315 | 1989-11-09 | Ruder Finn, Inc. | Dublin | ||||
16239 | 16239 | 1992-12-31 | Quincentennial Foundation of Istanbul | 1990-02-12 | TURKEY | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Istanbul | ||||
16242 | 16242 | 1992-12-31 | Ukrainian Branch of the World Laboratory (& Ministries) | 1992-04-24 | UKRAINE | Kleban & Samor, P.C. 4653 | 1992-04-24 | Kleban & Samor, P.C. | Kiev | ||||
16236 | 16236 | 1992-12-31 | Government of Portugal, Ministry for Foreign Affairs | 1943-01-23 | PORTUGAL | Portuguese National Tourist Office 172 | 1943-01-23 | Portuguese National Tourist Office | Lisbon | ||||
16240 | 16240 | 1992-12-31 | Republic of Slovenia | 1991-11-06 | SLOVENIA | Office of the Republic of Slovenia 4586 | 1991-11-06 | Office of the Republic of Slovenia | Ljubljana | ||||
16227 | 16227 | 1992-12-31 | Corporation of Lloyd's | 1987-12-10 | GREAT BRITAIN | Lord, Alan 4070 | 1987-12-10 | Lord, Alan | London | ||||
16228 | 16228 | 1992-12-31 | Underwriters at Lloyd's | 1988-12-09 | GREAT BRITAIN | Beckett, William C. 4196 | 1988-12-09 | Beckett, William C. | London | ||||
16232 | 16232 | 1992-12-31 | Barbados Board of Tourism | 1987-04-01 | BARBADOS | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | New York | NY | |||
16237 | 16237 | 1992-12-31 | Jiewon Park | 1992-07-09 | KOREA, SOUTH | David E. Morey 4688 | 1992-07-09 | David E. Morey | New York | NY | |||
16230 | 16230 | 1992-12-31 | Algoma Steel Corporation, Ltd. | 1992-05-13 | CANADA | de Korte, Derek M. 4664 | 1992-05-13 | de Korte, Derek M. | Ontario | ||||
16231 | 16231 | 1992-12-31 | Algoma Steel Corporation, Ltd. | 1992-05-13 | CANADA | Hudson, Gerry B. 4665 | 1992-05-13 | Hudson, Gerry B. | Ontario | ||||
16238 | 16238 | 1992-12-31 | Norsk Hydro, A.S. | 1990-02-12 | NORWAY | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Stabekk |
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]) );