FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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

20 rows where Country/Location_Represented = "YUGOSLAVIA" and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 1

Country/Location_Represented 1

  • YUGOSLAVIA · 20 ✖

City 1

  • - 20
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
2138 2138 1961-02-03 Yugoslav State Tourist Office 1953-02-10 YUGOSLAVIA Caples Company 34 1943-03-03 Caples Company New York     NY  
2896 2896 1955-02-28 Valko Vinterbalter, Director, Yugoslav Information Center 1955-01-04 YUGOSLAVIA Margold, Stella K. 864 1955-01-04 Margold, Stella K. New York     NY  
3417 3417 1966-03-04 Yugoslav State Tourist Office 1961-11-29 YUGOSLAVIA F. Gene Gaynor Advertising 1494 1961-11-29 F. Gene Gaynor Advertising New York     NY  
5004 5004 1985-04-03 Yugoslav National Tourist Office 1982-10-08 YUGOSLAVIA A.W.W. Advertising 3416 1982-10-08 A.W.W. Advertising New York     NY  
5053 5053 1977-04-06 Impol Aluminum Corporation 1976-12-27 YUGOSLAVIA Bowman & Conner 2741 1976-12-27 Bowman & Conner New York     NY  
6793 6793 1954-05-25 Yugoslav Information Service 1954-05-12 YUGOSLAVIA Edward L. Greenfield & Company 829 1954-05-12 Edward L. Greenfield & Company New York     NY  
7312 7312 1944-06-01 Yugoslav Information Center 1943-12-01 YUGOSLAVIA Derso & Kelen 222 1943-12-01 Derso & Kelen New York     NY  
8492 8492 1991-06-30 Tourist Assn. of Yugoslavia (Turisticki Savez Jugoslavije) 1955-10-10 YUGOSLAVIA Yugoslav National Tourist Office 915 1955-10-10 Yugoslav National Tourist Office New York     NY  
8850 8850 1978-07-01 Yugoslav Press & Cultural Center 1978-02-17 YUGOSLAVIA Edelman International Corporation 2548 1974-11-29 Edelman International Corporation New York     NY  
9241 9241 1987-07-14 Yugoslav National Tourist Office 1975-04-22 YUGOSLAVIA Herman Associates, Inc. 2578 1975-04-22 Herman Associates, Inc. New York     NY  
9242 9242 1987-07-14 Yugoslav National Tourist Office 1989-05-31 YUGOSLAVIA Herman Associates, Inc. 2578 1975-04-22 Herman Associates, Inc. New York     NY  
10966 10966 1981-08-31 Yugoslav Airlines 1977-01-03 YUGOSLAVIA Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York     NY  
11225 11225 1973-09-01 Yugoslav Steamship (Yadrolina Steamship) 1969-09-22 YUGOSLAVIA Cannon Advertising Associates, Inc. 1945 1965-12-14 Cannon Advertising Associates, Inc. New York     NY  
11422 11422 1953-09-08 Permanent Mission of the Federal People's Republic of Yugoslavia to the U.N. 1950-03-08 YUGOSLAVIA Rogge, Fabricant & Gordon 618 1950-03-08 Rogge, Fabricant & Gordon New York     NY  
11423 11423 1953-09-08 Yugoslav Commercial Attache' Office 1952-09-15 YUGOSLAVIA Rogge, Fabricant & Gordon 618 1950-03-08 Rogge, Fabricant & Gordon New York     NY  
11424 11424 1953-09-08 Yugoslav Information Center 1950-03-08 YUGOSLAVIA Rogge, Fabricant & Gordon 618 1950-03-08 Rogge, Fabricant & Gordon New York     NY  
12601 12601 1984-10-11 Yugoslav National Tourist Office 1983-05-04 YUGOSLAVIA North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
13544 13544 1973-11-01 Yugosalv Airlines (JAT) 1972-02-22 YUGOSLAVIA Cannon Advertising Associates, Inc. 1945 1965-12-14 Cannon Advertising Associates, Inc. New York     NY  
14643 14643 1973-12-01 Yugoslav State Tourist Office 1967-07-19 YUGOSLAVIA Cannon Advertising Associates, Inc. 1945 1965-12-14 Cannon Advertising Associates, Inc. New York     NY  
15734 15734 1974-12-31 Yugoslavian State Tourist Office 1974-06-24 YUGOSLAVIA Bozell & Jacobs Public Relations, Inc. 2522 1974-06-24 Bozell & Jacobs Public Relations, Inc. New York     NY  

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])
);