FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
216 rows where State = "CA"
This data as json, CSV (advanced)
Foreign_Principal 20
- American Honda Motor Company, Inc. 1
- Asahi Homecast Corporation 1
- Australian Tourist Commission 1
- British Travel Association 1
- California Steel Industries, Inc. 1
- Consul General of Belgium (Francis G. Lockem) 1
- Consul General of Sweden, Per Anger 1
- Fujitsu America, Inc. 1
- IR&D, Inc. 1
- JETRO Japanese External Trade Organization 1
- Korea National Tourism Corporation, Los Angeles 1
- New California Life Holdings, Inc. 1
- Republic of the Philippines 1
- Royal Danish Consulate General 1
- Scandinavian National Travel Offices 1
- Tokyo T.V. Broadcasting Corporation 1
- Tourism Australia 1
- Tourist Development Corporation of Malaysia 1
- Tourist Office of Spain 1
- Transpacific Westbound Rate Agreement 1
Registrant_Name 16
- Association Films, Inc. 3
- Myriad International Marketing, LLC 2
- NHK Cosmomedia America, Inc. 2
- Cassidy & Associates, Inc. 1
- Daniel J. Edelman, Inc. - San Francisco 1
- Davis Wright Tremaine 1
- Latta & Company 1
- Lou Hammond & Associates, Inc. 1
- Lowe Marschalk, Inc. 1
- Orrick, Herrington & Sutcliffe 1
- Public Relations Counselors, Inc. 1
- Public Service Audience Planners 1
- Sher & Blackwell 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Steptoe & Johnson, L.L.P. 1
- Victor Atiyeh & Company 1
Country/Location_Represented 12
- JAPAN 6
- INTERNATIONAL 3
- AUSTRALIA 2
- BELGIUM 1
- DENMARK 1
- FRANCE 1
- GREAT BRITAIN 1
- KOREA, SOUTH 1
- MALAYSIA 1
- PHILIPPINES 1
- SPAIN 1
- SWEDEN 1
City 3
- - 18
- Beverly Hills 1
- Los Angeles 1
State 1
- CA · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14918 | 14918 | 1993-12-09 | Fujitsu America, Inc. | 1988-04-22 | JAPAN | Victor Atiyeh & Company 4125 | 1988-04-22 | Victor Atiyeh & Company | San Jose | CA | |||
14953 | 14953 | 1993-12-10 | Asahi Homecast Corporation | 1991-11-26 | JAPAN | NHK Cosmomedia America, Inc. 4490 | 1991-03-26 | NHK Cosmomedia America, Inc. | San Gabriel | CA | |||
14996 | 14996 | 1993-12-10 | Tokyo T.V. Broadcasting Corporation | 1991-11-26 | JAPAN | NHK Cosmomedia America, Inc. 4490 | 1991-03-26 | NHK Cosmomedia America, Inc. | Brisbane | CA | |||
15105 | 15105 | 1992-12-14 | IR&D, Inc. | 1991-05-28 | JAPAN | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | Los Angeles | CA | |||
15118 | 15118 | 1950-12-15 | Consul General of Belgium (Francis G. Lockem) | 1950-11-01 | BELGIUM | Latta & Company 647 | 1950-11-01 | Latta & Company | San Francisco | CA | |||
15123 | 15123 | 1971-12-15 | Scandinavian National Travel Offices | 1970-04-27 | INTERNATIONAL | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Los Angeles | CA | |||
15256 | 15256 | 1993-12-20 | New California Life Holdings, Inc. | 1991-08-09 | FRANCE | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | Los Angeles | CA | |||
15414 | 15414 | 1994-12-27 | Transpacific Westbound Rate Agreement | 1993-09-30 | INTERNATIONAL | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | San Francisco | CA | |||
15639 | 15639 | 1965-12-31 | Consul General of Sweden, Per Anger | 1963-05-24 | SWEDEN | Public Relations Counselors, Inc. 1632 | 1963-05-24 | Public Relations Counselors, Inc. | San Francisco | CA | |||
15675 | 15675 | 1970-12-31 | British Travel Association | 1970-05-18 | GREAT BRITAIN | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Los Angeles | CA | |||
15715 | 15715 | 1973-12-31 | Royal Danish Consulate General | 1967-10-03 | DENMARK | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
15936 | 15936 | 1985-12-31 | Korea National Tourism Corporation, Los Angeles | 1976-09-27 | KOREA, SOUTH | Public Service Audience Planners 2452 | 1979-08-23 | Public Service Audience Planners | Los Angeles | CA | |||
15944 | 15944 | 1985-12-31 | Tourist Development Corporation of Malaysia | 1985-03-29 | MALAYSIA | Lowe Marschalk, Inc. 3670 | 1985-03-29 | Lowe Marschalk, Inc. | San Franciso | CA | |||
16100 | 16100 | 1989-12-31 | California Steel Industries, Inc. | 1989-09-07 | INTERNATIONAL | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | Fontana | CA | |||
16141 | 16141 | 1990-12-31 | American Honda Motor Company, Inc. | 1990-06-05 | JAPAN | Davis Wright Tremaine 4382 | 1990-06-05 | Davis Wright Tremaine | Gardena | CA | |||
16174 | 16174 | 1990-12-31 | Republic of the Philippines | 1990-02-09 | PHILIPPINES | Orrick, Herrington & Sutcliffe 4266 | 1989-06-12 | Orrick, Herrington & Sutcliffe | San Francisco | CA | |||
16410 | 16410 | 1997-12-31 | Australian Tourist Commission | 1995-06-23 | AUSTRALIA | Lou Hammond & Associates, Inc. 3682 | 1985-05-23 | Lou Hammond & Associates, Inc. | Los Angeles | CA | |||
16594 | 16594 | 2005-12-31 | JETRO Japanese External Trade Organization | 2004-12-28 | JAPAN | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 235 Pine Street, Suite 1700 San Francisco | CA | |||
16819 | 16819 | 2017-12-31 | Tourist Office of Spain | 2018-06-01 | SPAIN | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 8383 Wilshire Blvd. Suite 960 | Beverly Hills | CA | 90211 | |
16889 | 16889 | 2020-12-31 | Tourism Australia | 2018-04-30 | AUSTRALIA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 2029 Century Park E Ste 3150 | Los Angeles | CA | 90067 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );