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

12 rows where Country/Location_Represented = "NORWAY" and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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

  • NORWAY · 12 ✖

City 1

  • - 12
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
3542 3542 1984-03-09 Norwegian-American Line 1967-07-25 NORWAY International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
5214 5214 1986-04-12 Norseland Foods, Inc. 1985-06-05 NORWAY North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
7082 7082 1990-05-31 Norwegian Tourist Board 1988-11-23 NORWAY West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
7565 7565 1986-06-04 Barber West Africa Line 1983-06-17 NORWAY Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
7626 7626 1965-06-06 Norwegian Mission to the United Nations 1963-06-06 NORWAY Patton, Blow, Verrill, Brand & Boggs 1636 1963-06-06 Patton, Blow, Verrill, Brand & Boggs New York     NY  
9136 9136 1982-07-09 Norweigian-Swedish National Tourist Office 1980-02-06 NORWAY North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
10686 10686 1992-08-23 Norwegian Information Service 1981-09-29 NORWAY Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners New York     NY  
10748 10748 1945-08-26 No foreign principal listed 1943-08-26 NORWAY Norwegian Masters' Association Overseas Branch 204 1943-08-26 Norwegian Masters' Association Overseas Branch New York     NY  
11244 11244 1983-09-01 Norwegian Information Service 1982-02-02 NORWAY Augay Enterprises, Inc. 3328 1982-02-02 Augay Enterprises, Inc. New York     NY  
13404 13404 2001-10-31 Royal Norwegian Consulate General New York 1997-08-13 NORWAY Burson-Marsteller 2469 1973-10-23 Burson-Marsteller New York     NY  
15577 15577 1957-12-31 Norwegian Travel Information Bureau 1946-04-22 NORWAY Films of the Nations, Inc. 353 1946-04-22 Films of the Nations, Inc. New York     NY  
16180 16180 1990-12-31 Statoil North America, Inc. 1989-09-22 NORWAY Washington Policy & Analysis 4211 1989-01-27 Washington Policy & Analysis 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])
);