FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where City = "" and "Foreign_Principal_Termination_Date" is on date 1973-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Address_1
Foreign_Principal 27
- Agensia Telegrafika (ATA) 1
- Agerpres 1
- Bulgarska Photographia 1
- Centralna Agenja Fotograficzna 1
- China Photo Service 1
- Committee of European Shipowners 1
- Czechopress 1
- Fotokhronika Tass 1
- German Federal Railroad 1
- Government of Venezuela 1
- Hashemite Kingdom of the Jordan 1
- Interfoto MTI 1
- Kingdom of Iraq 1
- Kingdom of Saudi Arabia 1
- Kuwait Airways Corporation 1
- Mezhdunarodnaya Kniga 1
- Moroccan National Tourist Office 1
- Mutawakilite Kingdom of Yemen 1
- Novosti Press Agency 1
- Republic of Egypt 1
- Republic of Lebanon 1
- Republic of Syria 1
- Royal Danish Consulate General 1
- USSR Illustrated Monthly 1
- United Kingdom of Libya 1
- Yugofoto 1
- Zentrale Bildstelle 1
Country/Location_Represented 23
- USSR 4
- GERMANY, FEDERAL REPUBLIC OF 2
- ALBANIA 1
- BULGARIA 1
- CHINA 1
- CZECHOSLOVAKIA 1
- DENMARK 1
- EGYPT 1
- GREAT BRITAIN 1
- HUNGARY 1
- IRAQ 1
- JORDAN 1
- KUWAIT 1
- LEBANON 1
- LIBYA 1
- MOROCCO 1
- POLAND 1
- ROMANIA 1
- SAUDI ARABIA 1
- SYRIA 1
- VENEZUELA 1
- YEMEN 1
- YUGOSLAVIA 1
Registrant_Name 8
City 1
- - · 27 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15693 | 15693 | 1973-12-31 | Agensia Telegrafika (ATA) | 1964-06-26 | ALBANIA | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | Tirane | ||||
15694 | 15694 | 1973-12-31 | Agerpres | 1964-06-26 | ROMANIA | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | Bucharest | ||||
15695 | 15695 | 1973-12-31 | Bulgarska Photographia | 1964-06-29 | BULGARIA | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | Sofia | ||||
15696 | 15696 | 1973-12-31 | Centralna Agenja Fotograficzna | 1964-06-29 | POLAND | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | Warsaw | ||||
15697 | 15697 | 1973-12-31 | China Photo Service | 1964-06-29 | CHINA | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | Peking | ||||
15698 | 15698 | 1973-12-31 | Committee of European Shipowners | 1963-07-02 | GREAT BRITAIN | Capone, Ronald A. 1620 | 1963-04-19 | Capone, Ronald A. | London | ||||
15699 | 15699 | 1973-12-31 | Czechopress | 1964-06-29 | CZECHOSLOVAKIA | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | Prague | ||||
15700 | 15700 | 1973-12-31 | Fotokhronika Tass | 1964-06-29 | USSR | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | Moscow | ||||
15701 | 15701 | 1973-12-31 | German Federal Railroad | 1964-01-14 | GERMANY, FEDERAL REPUBLIC OF | Albert Woodley Company, Inc. 1679 | 1964-01-14 | Albert Woodley Company, Inc. | New York | NY | |||
15702 | 15702 | 1973-12-31 | Government of Venezuela | 1965-08-31 | VENEZUELA | Lara, Francisco J. 1920 | 1965-08-31 | Lara, Francisco J. | Caracas | ||||
15703 | 15703 | 1973-12-31 | Hashemite Kingdom of the Jordan | 1955-03-03 | JORDAN | Arab Information Center 876 | 1955-03-03 | Arab Information Center | Amman | ||||
15704 | 15704 | 1973-12-31 | Interfoto MTI | 1964-06-26 | HUNGARY | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | Budapest | ||||
15705 | 15705 | 1973-12-31 | Kingdom of Iraq | 1955-03-03 | IRAQ | Arab Information Center 876 | 1955-03-03 | Arab Information Center | Baghdad | ||||
15706 | 15706 | 1973-12-31 | Kingdom of Saudi Arabia | 1955-03-03 | SAUDI ARABIA | Arab Information Center 876 | 1955-03-03 | Arab Information Center | Riyadh | ||||
15707 | 15707 | 1973-12-31 | Kuwait Airways Corporation | 1973-10-18 | KUWAIT | Barkett, Mitchell 2436 | 1973-06-18 | Barkett, Mitchell | New York | NY | |||
15708 | 15708 | 1973-12-31 | Mezhdunarodnaya Kniga | 1964-06-29 | USSR | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | Moscow | ||||
15709 | 15709 | 1973-12-31 | Moroccan National Tourist Office | 1973-01-09 | MOROCCO | Tromson Monroe Advertising, Inc. 2403 | 1973-01-09 | Tromson Monroe Advertising, Inc. | |||||
15710 | 15710 | 1973-12-31 | Mutawakilite Kingdom of Yemen | 1955-03-03 | YEMEN | Arab Information Center 876 | 1955-03-03 | Arab Information Center | San'aa | ||||
15711 | 15711 | 1973-12-31 | Novosti Press Agency | 1964-06-29 | USSR | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | Moscow | ||||
15712 | 15712 | 1973-12-31 | Republic of Egypt | 1955-03-03 | EGYPT | Arab Information Center 876 | 1955-03-03 | Arab Information Center | Cairo | ||||
15713 | 15713 | 1973-12-31 | Republic of Lebanon | 1955-03-03 | LEBANON | Arab Information Center 876 | 1955-03-03 | Arab Information Center | Beirut | ||||
15714 | 15714 | 1973-12-31 | Republic of Syria | 1955-03-03 | SYRIA | Arab Information Center 876 | 1955-03-03 | Arab Information Center | Damascus | ||||
15715 | 15715 | 1973-12-31 | Royal Danish Consulate General | 1967-10-03 | DENMARK | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
15716 | 15716 | 1973-12-31 | USSR Illustrated Monthly | 1964-06-26 | USSR | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | Washington | DC | |||
15717 | 15717 | 1973-12-31 | United Kingdom of Libya | 1955-03-03 | LIBYA | Arab Information Center 876 | 1955-03-03 | Arab Information Center | Tripoli | ||||
15718 | 15718 | 1973-12-31 | Yugofoto | 1964-06-29 | YUGOSLAVIA | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | Belgrage | ||||
15719 | 15719 | 1973-12-31 | Zentrale Bildstelle | 1964-06-26 | GERMANY, FEDERAL REPUBLIC OF | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | Berlin |
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]) );