FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
32 rows where "Foreign_Principal_Termination_Date" is on date 1990-11-30 sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal >30
- 3i Group, PLC 1
- Agensia Telegrafika (ATA) 1
- Agerpress 1
- Bell Trust Company Kazuyoshi Suzumori, President 1
- Camara Nacional de la Industria del Vestido 1
- Centralna Agenja Fotograficzna 1
- Continental Manufacturing Corporation, Government of the Philippines 1
- Copyright Agency of the U.S.S.R. (VAAP) 1
- Czechopress 1
- Education Committee of the Volkskammer (East German Parliment), German Democratic Republic (GDR) 1
- Fang Brothers Knitting, Ltd. 1
- Fotokhronika Tass 1
- Government of Mexico, Ministry of Commerce 1
- Government of the Arab Republic of Egypt 1
- Hong Kong Trade Development Council 1
- Instituto Libertad y Democracia 1
- Interfoto MTI 1
- Invesco MIM, PLC 1
- Korea National Tourism Corporation 1
- Laurel Steel Products, Ltd. 1
- Laurel Steel Products, Ltd. Harris Steel Group 1
- Lembaga Bantuan Pemasaran & Management 1
- Netherlands/Antilles Government 1
- New China Pictures Company 1
- Novosti Press Agency 1
- Scottish Development Agency 1
- Society Francaise Machine de Materiels d' Armenent (SAFMA) 1
- Soviet Life 1
- Turkish Apparel Exporters' Association 1
- Yugofoto 1
- …
Country/Location_Represented 24
- USSR 4
- CANADA 2
- GERMAN DEMOCRATIC REPUBLIC 2
- GREAT BRITAIN 2
- HONG KONG 2
- MEXICO 2
- ALBANIA 1
- BULGARIA 1
- CHINA 1
- CZECHOSLOVAKIA 1
- EGYPT 1
- FRANCE 1
- HUNGARY 1
- INDONESIA 1
- JAPAN 1
- KOREA, SOUTH 1
- NETHERLANDS ANTILLES 1
- PERU 1
- PHILIPPINES 1
- POLAND 1
- ROMANIA 1
- SCOTLAND 1
- TURKEY 1
- YUGOSLAVIA 1
Registration_Number 14 ✖
- Siegel, Leah 13
- World Trade Link 5
- Jefferson Group, Inc. 2
- Ropes & Gray 2
- Ruder Finn, Inc. 1
- Modern Education Services, Inc. 1
- Cole Corette & Abrutyn, P.C. 1
- MacFarlane & Company, Inc. 1
- Dow, Lohnes & Albertson, L.L.P. 1
- Fleishman-Hillard, Inc. 1
- Riddell, Glenn Wadsworth 1
- Interlocke Associates 1
- Enquiries Associates 1
- Shearson Lehman Brothers, Inc. 1
Registrant_Name 14
- Siegel, Leah 13
- World Trade Link 5
- Jefferson Group, Inc. 2
- Ropes & Gray 2
- Cole Corette & Abrutyn, P.C. 1
- Dow, Lohnes & Albertson, L.L.P. 1
- Enquiries Associates 1
- Fleishman-Hillard, Inc. 1
- Interlocke Associates 1
- MacFarlane & Company, Inc. 1
- Modern Education Services, Inc. 1
- Riddell, Glenn Wadsworth 1
- Ruder Finn, Inc. 1
- Shearson Lehman Brothers, Inc. 1
City 1
- - 32
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14402 | 14402 | 1990-11-30 | Agensia Telegrafika (ATA) | 1974-01-21 | ALBANIA | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | Tirane | ||||
14403 | 14403 | 1990-11-30 | Agerpress | 1974-01-21 | ROMANIA | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | Bucharest | ||||
14406 | 14406 | 1990-11-30 | Centralna Agenja Fotograficzna | 1974-01-21 | POLAND | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | Warsaw | ||||
14409 | 14409 | 1990-11-30 | Czechopress | 1974-01-21 | CZECHOSLOVAKIA | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | |||||
14412 | 14412 | 1990-11-30 | Fotokhronika Tass | 1974-01-21 | USSR | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | Moscow | ||||
14417 | 14417 | 1990-11-30 | Interfoto MTI | 1974-01-21 | HUNGARY | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | Budapest | ||||
14425 | 14425 | 1990-11-30 | Novosti Press Agency | 1974-01-21 | USSR | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | Moscow | ||||
14427 | 14427 | 1990-11-30 | Soviet Life | 1974-01-21 | USSR | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | Washington | DC | |||
14428 | 14428 | 1990-11-30 | Yugofoto | 1974-01-21 | YUGOSLAVIA | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | Belgrad | ||||
14429 | 14429 | 1990-11-30 | Zentrale Bildstelle Allgemeiner Deutscher Nachrichtendienst | 1974-01-21 | GERMAN DEMOCRATIC REPUBLIC | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | Berlin | ||||
14430 | 14430 | 1990-11-30 | Zentralfoto | 1974-01-21 | BULGARIA | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | Sofia | ||||
14408 | 14408 | 1990-11-30 | Copyright Agency of the U.S.S.R. (VAAP) | 1979-05-11 | USSR | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | Moscow | ||||
14426 | 14426 | 1990-11-30 | Scottish Development Agency | 1979-08-22 | SCOTLAND | MacFarlane & Company, Inc. 3051 | 1979-08-22 | MacFarlane & Company, Inc. | |||||
14424 | 14424 | 1990-11-30 | New China Pictures Company | 1980-04-18 | CHINA | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | Beijing | ||||
14423 | 14423 | 1990-11-30 | Netherlands/Antilles Government | 1981-08-04 | NETHERLANDS ANTILLES | Cole Corette & Abrutyn, P.C. 2968 | 1978-10-18 | Cole Corette & Abrutyn, P.C. | Curacao | ||||
14421 | 14421 | 1990-11-30 | Laurel Steel Products, Ltd. | 1984-06-05 | CANADA | Dow, Lohnes & Albertson, L.L.P. 3452 | 1983-03-17 | Dow, Lohnes & Albertson, L.L.P. | Ontario | ||||
14420 | 14420 | 1990-11-30 | Laurel Steel Products, Ltd. Harris Steel Group | 1986-02-20 | CANADA | Riddell, Glenn Wadsworth 3781 | 1986-02-20 | Riddell, Glenn Wadsworth | Ontario | ||||
14399 | 14399 | 1990-11-30 | Society Francaise Machine de Materiels d' Armenent (SAFMA) | 1987-03-25 | FRANCE | Interlocke Associates 3954 | 1987-03-25 | Interlocke Associates | Paris | ||||
14415 | 14415 | 1990-11-30 | Hong Kong Trade Development Council | 1987-09-29 | HONG KONG | Enquiries Associates 4045 | 1987-09-29 | Enquiries Associates | Hong Kong | ||||
14414 | 14414 | 1990-11-30 | Government of the Arab Republic of Egypt | 1988-03-02 | EGYPT | Shearson Lehman Brothers, Inc. 4097 | 1988-03-02 | Shearson Lehman Brothers, Inc. | Embassy | ||||
14413 | 14413 | 1990-11-30 | Government of Mexico, Ministry of Commerce | 1989-09-05 | MEXICO | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | |||||
14407 | 14407 | 1990-11-30 | Continental Manufacturing Corporation, Government of the Philippines | 1989-11-22 | PHILIPPINES | World Trade Link 4317 | 1989-11-22 | World Trade Link | Manila | ||||
14422 | 14422 | 1990-11-30 | Lembaga Bantuan Pemasaran & Management | 1989-11-22 | INDONESIA | World Trade Link 4317 | 1989-11-22 | World Trade Link | Jakarta | ||||
14405 | 14405 | 1990-11-30 | Camara Nacional de la Industria del Vestido | 1990-01-17 | MEXICO | World Trade Link 4317 | 1989-11-22 | World Trade Link | |||||
14411 | 14411 | 1990-11-30 | Fang Brothers Knitting, Ltd. | 1990-01-17 | HONG KONG | World Trade Link 4317 | 1989-11-22 | World Trade Link | Kowloon | ||||
14400 | 14400 | 1990-11-30 | Turkish Apparel Exporters' Association | 1990-01-31 | TURKEY | World Trade Link 4317 | 1989-11-22 | World Trade Link | Istanbul | ||||
14404 | 14404 | 1990-11-30 | Bell Trust Company Kazuyoshi Suzumori, President | 1990-04-27 | JAPAN | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Tokyo | ||||
14410 | 14410 | 1990-11-30 | Education Committee of the Volkskammer (East German Parliment), German Democratic Republic (GDR) | 1990-07-24 | GERMAN DEMOCRATIC REPUBLIC | Jefferson Group, Inc. 4139 | 1988-05-11 | Jefferson Group, Inc. | Berlin | ||||
14401 | 14401 | 1990-11-30 | 3i Group, PLC | 1990-09-14 | GREAT BRITAIN | Ropes & Gray 4251 | 1989-05-12 | Ropes & Gray | London | ||||
14418 | 14418 | 1990-11-30 | Invesco MIM, PLC | 1990-09-21 | GREAT BRITAIN | Ropes & Gray 4251 | 1989-05-12 | Ropes & Gray | London | ||||
14416 | 14416 | 1990-11-30 | Instituto Libertad y Democracia | 1990-11-21 | PERU | Jefferson Group, Inc. 4139 | 1988-05-11 | Jefferson Group, Inc. | Lima | ||||
14419 | 14419 | 1990-11-30 | Korea National Tourism Corporation | 1990-11-26 | KOREA, SOUTH | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | Seoul |
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]) );