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

22 rows where Country/Location_Represented = "SWEDEN" 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

  • SWEDEN · 22 ✖

City 1

  • - 22
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
1648 1648 1999-01-30 Swedish Travel & Tourism Council 1993-12-17 SWEDEN Development Counsellors International 4777 1993-03-12 Development Counsellors International New York     NY  
4413 4413 1983-03-31 Swedish National Tourist Office 1974-08-13 SWEDEN Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners New York     NY  
6150 6150 1970-05-01 Swedish Information Service 1969-11-18 SWEDEN Planned Television Arts 2171 1969-11-18 Planned Television Arts New York     NY  
7415 7415 1993-06-01 ASEA Hagglund 1985-03-20 SWEDEN Fierce, Donald L. 3541 1983-12-13 Fierce, Donald L. Yonkers     NY  
7618 7618 1946-06-06 Swedish Travel Information Bureau 1945-06-08 SWEDEN College Film Center 304 1945-06-08 College Film Center New York     NY  
8231 8231 1957-06-30 Swedish Travel Information Bureau, Inc. 1946-04-22 SWEDEN Films of the Nations, Inc. 353 1946-04-22 Films of the Nations, Inc. New York     NY  
8259 8259 1968-06-30 American-Swedish News Exchange, Inc. 1965-08-06 SWEDEN Murden & Company, Inc. 1510 1962-01-17 Murden & Company, Inc. New York     NY  
8312 8312 1976-06-30 Swedish National Travel Office 1968-08-12 SWEDEN Alden Films, Business Education Films, Films of the Nations 2100 1968-08-12 Alden Films, Business Education Films, Films of the Nations New York     NY  
9353 9353 1944-07-19 Swedish Industries Fund 1943-01-19 SWEDEN Franzen, Knut Gosta 174 1943-01-19 Franzen, Knut Gosta New York     NY  
9605 9605 1968-07-30 Swedish National Travel Office 1967-06-07 SWEDEN Films of the Nations Distributors, Inc. 2028 1967-06-07 Films of the Nations Distributors, Inc. New York     NY  
10693 10693 1992-08-23 Swedish Information Service 1977-04-07 SWEDEN Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners New York     NY  
11321 11321 1975-09-02 Swedish-American Line 1967-07-25 SWEDEN International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
11412 11412 1993-09-07 Lehman Brothers/Government of Sweden 1993-03-05 SWEDEN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. New York City     NY  
13026 13026 1989-10-25 Swedish Tourist Board 1983-05-04 SWEDEN North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
13148 13148 1946-10-30 Swedish Travel Information Bureau, Inc. 1945-04-30 SWEDEN Film Preview 303 1945-04-30 Film Preview New York     NY  
13389 13389 1999-10-31 Most in Sweden Agency 1997-10-22 SWEDEN Levin Public Relations & Marketing, Inc. 5217 1997-10-22 Levin Public Relations & Marketing, Inc. New York     NY  
13908 13908 1992-11-12 Swedish Tourist Board 1988-11-23 SWEDEN West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
13972 13972 1984-11-15 Salen Dry Cargo, Inc. 1984-04-17 SWEDEN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
14258 14258 1973-11-26 Swedish National Tourist Office 1973-07-24 SWEDEN Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
15581 15581 1957-12-31 Swedish National Travel Office, Inc. 1950-09-25 SWEDEN Films of the Nations, Inc. 353 1946-04-22 Films of the Nations, Inc. New York     NY  
15582 15582 1957-12-31 Swiss Federal Railroads 1946-04-22 SWEDEN Films of the Nations, Inc. 353 1946-04-22 Films of the Nations, Inc. New York     NY  
15583 15583 1957-12-31 Swiss National Tourist Office 1952-01-30 SWEDEN Films of the Nations, Inc. 353 1946-04-22 Films of the Nations, 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])
);