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

13 rows where Foreign_Principal = "Japan National Tourist Organization"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 3

Foreign_Principal 1

  • Japan National Tourist Organization · 13 ✖

Country/Location_Represented 1

City 1

  • - 13
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
375 375   Japan National Tourist Organization 1953-05-26 JAPAN Japan National Tourism Organization 769 1953-05-26 Japan National Tourism Organization Tokyo        
376 376   Japan National Tourist Organization 2021-11-29 JAPAN Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC          
1280 1280 1972-01-14 Japan National Tourist Organization 1966-01-14 JAPAN United World Films, Inc. 1952 1966-01-14 United World Films, Inc. New York     NY  
2314 2314 1967-02-09 Japan National Tourist Organization 1966-10-21 JAPAN Charles von Loewenfeldt, Inc. 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
4333 4333 1969-03-31 Japan National Tourist Organization 1967-09-13 JAPAN Sontheimer Hazlett, Ltd. 1648 1963-07-19 Sontheimer Hazlett, Ltd.          
4351 4351 1975-03-31 Japan National Tourist Organization 1969-11-06 JAPAN Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc.          
4541 4541 1995-03-31 Japan National Tourist Organization 1972-07-03 JAPAN Japan National Tourist Organization, Dallas 2348 1972-07-03 Japan National Tourist Organization, Dallas Tokyo        
4654 4654 2006-03-31 Japan National Tourist Organization 1972-07-03 JAPAN Japan National Tourist Organization, San Francisco 2349 1972-07-03 Japan National Tourist Organization, San Francisco Tokyo        
9847 9847 2003-07-31 Japan National Tourist Organization 1972-07-03 JAPAN Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago Tokyo        
10974 10974 1985-08-31 Japan National Tourist Organization 1972-07-03 JAPAN Japan National Tourist Organization, Hawaii 2351 1972-07-03 Japan National Tourist Organization, Hawaii Tokyo        
12978 12978 1968-10-24 Japan National Tourist Organization 1964-10-12 JAPAN Clinton E. Frank, Inc., New York 1601 1963-02-25 Clinton E. Frank, Inc., New York Tokyo        
13022 13022 1989-10-25 Japan National Tourist Organization 1989-09-20 JAPAN North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
14667 14667 1982-12-01 Japan National Tourist Organization 1973-06-12 JAPAN Ketchum Communications Holdings, Inc. 2386 1972-10-17 Ketchum Communications Holdings, Inc.          

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