home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

64 rows where "Foreign_Principal_Termination_Date" is on date 1992-04-30

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Number, Address_1, Foreign_Principal_Termination_Date (date)

Foreign_Principal >30

  • Aer Lingus 1
  • All-Union Research Institute for Organic Synthesis 1
  • Austrian Press & Information Service 1
  • Chernovtsy Rubber Shoesfactory"" 1
  • Civic Democratic Party of Czechoslovakia 1
  • Committee to Establish City of America 1
  • Cooperative Concord"" 1
  • Corporate Enterprise FEMEX"" 1
  • Embassy of Guinea 1
  • Eurailpass 1
  • FINVEST"" 1
  • Family & Health Association 1
  • French Government Tourist Office 1
  • GCI Group for the Quincentennial Foundation of Istanbul 1
  • Hong Kong Tourist Organization 1
  • Khmer People's National Liberation Front 1
  • MC Shipping, Inc. 1
  • MSTA CRIMEAMEDELECTRO"" 1
  • Malaysian Palm Oil Promotion Council 1
  • Moscovsky Vertolyetny Zavod im. M.L. Milya"" 1
  • Moscow Fat Processing Plant 1
  • Moscow Industrial Union for Diamond Tools Production 1
  • Multibranch Business Association ELEM"" 1
  • NPO TRANSPROGRESS"" 1
  • P/A SAJANMRAMOR"" 1
  • P/O TERMINAL"" 1
  • POLJOT"" 1
  • Paton Welding Institute"" 1
  • Production Association Izhevskei Mekhanicheskei Zavod"" 1
  • RPAO Armniasomolprom" of Gosagroprom of Armenian SSR" 1
  • …

Country/Location_Represented 18

  • RUSSIA 47
  • ARMENIA 1
  • AUSTRIA 1
  • CAMBODIA 1
  • CZECHOSLOVAKIA 1
  • ESTONIA 1
  • FRANCE 1
  • GREAT BRITAIN 1
  • GUINEA 1
  • HONG KONG 1
  • INTERNATIONAL 1
  • IRELAND 1
  • JAPAN 1
  • LATVIA 1
  • MALAYSIA 1
  • MONACO 1
  • SWITZERLAND 1
  • TURKEY 1

Registrant_Name 8

  • Amtorg Trading Corporation 49
  • North American Precis Syndicate 9
  • Committee to Support-Civic Democratic Pty. of Czechoslovakia 1
  • Donovan, Leisure, Newton & Irvine 1
  • GCI Group, Inc. 1
  • Miller & Chevalier, Chartered 1
  • Perkins Coie 1
  • Sak, Sutsakhan 1

State 4

  • - 53
  • NY 7
  • DC 3
  • MD 1

City 1

  • - 64
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
5868 5868 1992-04-30 Khmer People's National Liberation Front 1990-10-24 CAMBODIA Sak, Sutsakhan 4429 1990-10-24 Sak, Sutsakhan Bangkok        
5869 5869 1992-04-30 Aer Lingus 1992-01-03 IRELAND North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
5870 5870 1992-04-30 All-Union Research Institute for Organic Synthesis 1991-11-15 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5871 5871 1992-04-30 Austrian Press & Information Service 1992-04-03 AUSTRIA North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
5872 5872 1992-04-30 Chernovtsy Rubber Shoesfactory"" 1990-03-30 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Ukraine        
5873 5873 1992-04-30 Civic Democratic Party of Czechoslovakia 1992-04-22 CZECHOSLOVAKIA Committee to Support-Civic Democratic Pty. of Czechoslovakia 4658 1992-04-22 Committee to Support-Civic Democratic Pty. of Czechoslovakia Prague        
5874 5874 1992-04-30 Committee to Establish City of America 1990-12-26 JAPAN Perkins Coie 3753 1985-11-01 Perkins Coie Tokyo        
5875 5875 1992-04-30 Cooperative Concord"" 1990-05-02 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5876 5876 1992-04-30 Corporate Enterprise FEMEX"" 1990-10-11 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5877 5877 1992-04-30 Embassy of Guinea 1992-01-03 GUINEA North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate Washington     DC  
5878 5878 1992-04-30 Eurailpass 1992-01-03 INTERNATIONAL North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
5879 5879 1992-04-30 FINVEST"" 1990-04-18 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5880 5880 1992-04-30 Family & Health Association 1991-06-24 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5881 5881 1992-04-30 French Government Tourist Office 1992-03-27 FRANCE North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
5882 5882 1992-04-30 GCI Group for the Quincentennial Foundation of Istanbul 1992-03-27 TURKEY North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
5883 5883 1992-04-30 Hong Kong Tourist Organization 1992-03-27 HONG KONG North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
5884 5884 1992-04-30 MC Shipping, Inc. 1990-02-12 MONACO GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Monte Carlo        
5885 5885 1992-04-30 MSTA CRIMEAMEDELECTRO"" 1990-10-11 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Yalta        
5886 5886 1992-04-30 Malaysian Palm Oil Promotion Council 1992-01-03 MALAYSIA North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate Washington     DC  
5887 5887 1992-04-30 Moscovsky Vertolyetny Zavod im. M.L. Milya"" 1990-12-27 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5888 5888 1992-04-30 Moscow Fat Processing Plant 1992-02-18 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5889 5889 1992-04-30 Moscow Industrial Union for Diamond Tools Production 1992-02-18 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5890 5890 1992-04-30 Multibranch Business Association ELEM"" 1992-02-18 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Karaganda        
5891 5891 1992-04-30 NPO TRANSPROGRESS"" 1990-10-11 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5892 5892 1992-04-30 P/A SAJANMRAMOR"" 1990-12-27 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Sajanogorsk        
5893 5893 1992-04-30 P/O TERMINAL"" 1990-03-14 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Vinnitsa        
5894 5894 1992-04-30 POLJOT"" 1990-10-11 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5895 5895 1992-04-30 Paton Welding Institute"" 1990-03-14 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Kiev        
5896 5896 1992-04-30 Production Association Izhevskei Mekhanicheskei Zavod"" 1990-05-17 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Izhevsk        
5897 5897 1992-04-30 RPAO Armniasomolprom" of Gosagroprom of Armenian SSR" 1990-12-27 ARMENIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Erevan        
5898 5898 1992-04-30 Range Rover of North America, Inc. 1992-02-27 GREAT BRITAIN Miller & Chevalier, Chartered 3626 1984-10-31 Miller & Chevalier, Chartered Lanham     MD  
5899 5899 1992-04-30 Republic of Estonia 1990-10-12 ESTONIA Donovan, Leisure, Newton & Irvine 4422 1990-10-12 Donovan, Leisure, Newton & Irvine Washington     DC  
5900 5900 1992-04-30 Riga Cardboard Factory 1992-02-18 LATVIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Riga        
5901 5901 1992-04-30 State Don Cossacks Song and Dance Ensemble"" 1990-10-01 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Rostoy/Don        
5902 5902 1992-04-30 Swiss National Tourist Office 1992-03-27 SWITZERLAND North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
5903 5903 1992-04-30 TSNT Cooperative Steamer"" 1990-03-30 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Kharkov        
5904 5904 1992-04-30 Terra Block Soviet Union"" 1990-05-17 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5905 5905 1992-04-30 Uhtomskiy Helicopter Works 1991-03-14 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5906 5906 1992-04-30 V.T.F. INPOLIGRAF"" 1990-10-01 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5907 5907 1992-04-30 V/F VREMEX"" 1990-04-18 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5908 5908 1992-04-30 V/O Avtopromimport 1988-04-29 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5909 5909 1992-04-30 V/O Electronorgtechnica 1971-06-08 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation          
5910 5910 1992-04-30 V/O Energomashexport 1967-07-11 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation          
5911 5911 1992-04-30 V/O Licensintorg 1964-10-29 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5912 5912 1992-04-30 V/O Machinoexport 1960-04-29 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5913 5913 1992-04-30 V/O Mashpriborintorg 1966-05-09 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5914 5914 1992-04-30 V/O Medexport 1961-10-30 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5915 5915 1992-04-30 V/O Prodintorg 1954-04-28 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5916 5916 1992-04-30 V/O Raznoexport 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5917 5917 1992-04-30 V/O Sojuzchimexport 1952-04-28 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5918 5918 1992-04-30 V/O Sojuznefteexport 1974-04-01 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation          
5919 5919 1992-04-30 V/O Sojuzplodoimport 1967-05-02 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5920 5920 1992-04-30 V/O Sojuzvneshstrojimport 1977-03-14 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation          
5921 5921 1992-04-30 V/O Sojuzvneshtrans 1975-08-25 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation          
5922 5922 1992-04-30 V/O Sovintersport"" 1990-03-29 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5923 5923 1992-04-30 V/O Soyuzkarta"" 1990-03-21 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5924 5924 1992-04-30 V/O Stankoimport 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5925 5925 1992-04-30 V/O Strojmaterialintorg 1979-02-15 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation          
5926 5926 1992-04-30 V/O Sudoexport 1990-05-02 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5927 5927 1992-04-30 V/O Sudoimport 1966-08-05 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5928 5928 1992-04-30 V/O Technointorg 1979-10-26 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation          
5929 5929 1992-04-30 V/O Vneshtorgreklama 1967-05-02 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5930 5930 1992-04-30 VPO Sojuzelektrosetisolyatsiya"" 1992-02-18 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5931 5931 1992-04-30 Vneshstroykomplex"" 1992-02-18 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 972.779ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history