FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Foreign_Principal_Termination_Date = "1983-12-31"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_1, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Foreign_Principal 13
- Bishop A.T. Muzorewa & United African National Council 1
- Constitutional Commission, Republic of Liberia 1
- Euromissile 1
- Government of France 1
- Greek National Tourist Organization 1
- Guatemala Tourist Commission 1
- Homeland Mission of 1950 of the Republic of South Moluccas in Exile 1
- InfoFilm & Video, A.S. 1
- Khmer People's National Liberation Front 1
- Mozambique United Democratic Front 1
- Portuguese Government Trade Office 1
- TUV Rheinland - Technischer Ueberwachungs - Verein Rheinland 1
- Teddy Kollek 1
Country/Location_Represented 12
- FRANCE 2
- CAMBODIA 1
- GERMANY, FEDERAL REPUBLIC OF 1
- GREECE 1
- GUATEMALA 1
- ISRAEL 1
- LIBERIA 1
- MOZAMBIQUE 1
- NORWAY 1
- PORTUGAL 1
- SOUTH MOLUCCAS, REPUBLIC OF 1
- UNITED STATES 1
Registrant_Name 8
State 1
- - 13
City 1
- - 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15892 | 15892 | 1983-12-31 | Khmer People's National Liberation Front | 1980-11-12 | CAMBODIA | Blaustein Associates, Ltd. 2956 | 1978-09-14 | Blaustein Associates, Ltd. | |||||
15893 | 15893 | 1983-12-31 | Bishop A.T. Muzorewa & United African National Council | 1978-10-25 | UNITED STATES | Blaustein Associates, Ltd. 2956 | 1978-09-14 | Blaustein Associates, Ltd. | Salisbury | ||||
15894 | 15894 | 1983-12-31 | Constitutional Commission, Republic of Liberia | 1981-10-05 | LIBERIA | Blaustein Associates, Ltd. 2956 | 1978-09-14 | Blaustein Associates, Ltd. | Monrovia | ||||
15895 | 15895 | 1983-12-31 | Euromissile | 1981-09-02 | FRANCE | Hyman Fine & Associates, Ltd. 3273 | 1981-09-02 | Hyman Fine & Associates, Ltd. | |||||
15896 | 15896 | 1983-12-31 | Government of France | 1983-10-12 | FRANCE | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
15897 | 15897 | 1983-12-31 | Greek National Tourist Organization | 1976-01-28 | GREECE | Hicks & Griest, Inc. 2656 | 1976-01-28 | Hicks & Griest, Inc. | Athens | ||||
15898 | 15898 | 1983-12-31 | Guatemala Tourist Commission | 1982-11-29 | GUATEMALA | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | |||||
15899 | 15899 | 1983-12-31 | Homeland Mission of 1950 of the Republic of South Moluccas in Exile | 1981-04-08 | SOUTH MOLUCCAS, REPUBLIC OF | Blaustein Associates, Ltd. 2956 | 1978-09-14 | Blaustein Associates, Ltd. | |||||
15900 | 15900 | 1983-12-31 | InfoFilm & Video, A.S. | 1983-01-13 | NORWAY | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
15901 | 15901 | 1983-12-31 | Mozambique United Democratic Front | 1978-09-14 | MOZAMBIQUE | Blaustein Associates, Ltd. 2956 | 1978-09-14 | Blaustein Associates, Ltd. | |||||
15902 | 15902 | 1983-12-31 | Portuguese Government Trade Office | 1982-03-31 | PORTUGAL | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
15903 | 15903 | 1983-12-31 | TUV Rheinland - Technischer Ueberwachungs - Verein Rheinland | 1980-12-03 | GERMANY, FEDERAL REPUBLIC OF | German-American Chamber of Commerce, Inc., New York 1812 | 1964-11-04 | German-American Chamber of Commerce, Inc., New York | Koeln | ||||
15904 | 15904 | 1983-12-31 | Teddy Kollek | 1982-06-02 | ISRAEL | Eliel, Stefan E. 3376 | 1982-06-02 | Eliel, Stefan E. | Jerusalem |
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]) );