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

10 rows where Country/Location_Represented = "FINLAND" and State = "NY"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Country/Location_Represented 1

  • FINLAND · 10 ✖

City 1

  • - 10
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
790 790 1963-01-01 Finnair 1961-08-01 FINLAND Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. New York     NY  
2422 2422 1996-02-12 Consulate General of Finland 1976-06-30 FINLAND 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  
4404 4404 1983-03-31 Finnish National Tourist Office 1974-08-13 FINLAND Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners New York     NY  
6154 6154 1973-05-01 Consulate General of Finland 1967-08-11 FINLAND Freed, William Herzl 735 1952-07-22 Freed, William Herzl New York     NY  
9114 9114 1943-07-09 Finnish-American Trading Corporation 1942-07-09 FINLAND Jarvinen, Vilho Olavi 24 1942-07-09 Jarvinen, Vilho Olavi New York     NY  
9803 9803 1994-07-31 Finnish Tourist Board 1988-11-23 FINLAND West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
10760 10760 1976-08-26 Finnish National Tourist Office 1972-10-04 FINLAND Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
11226 11226 1975-09-01 Finnish National Tourist Office 1970-06-10 FINLAND M. Silver Associates, Inc. 2200 1970-06-10 M. Silver Associates, Inc. New York     NY  
12595 12595 1984-10-11 Finnair 1982-12-01 FINLAND North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
15405 15405 1985-12-27 Finland National Tourist Office 1976-06-18 FINLAND Patricof, Pat E. 2700 1976-06-18 Patricof, Pat E. 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])
);