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

61 rows where Country/Location_Represented = "JAPAN" and State = "CA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

City 3

State 1

Country/Location_Represented 1

  • JAPAN · 61 ✖
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
1334 1334 1990-01-15 NEC Electronics, Inc. 1989-07-28 JAPAN Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe Mountain View     CA  
1435 1435 1992-01-20 MCA, Inc. 1991-01-03 JAPAN Baker, Worthington, Crossley, Stansberry & Woolf 4397 1990-07-12 Baker, Worthington, Crossley, Stansberry & Woolf Universal City     CA  
1688 1688 1969-01-31 Japan Trade Center (JETRO) 1968-01-06 JAPAN Steele, Donald Dickinson 2030 1967-06-20 Steele, Donald Dickinson San Francisco     CA  
1733 1733 1989-01-31 Industrial Bank of Japan, Ltd. Los Angeles Agency 1988-12-28 JAPAN Coudert Brothers 3743 1985-10-02 Coudert Brothers Los Angeles     CA  
1744 1744 1990-01-31 Fujitsu America 1989-07-28 JAPAN Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe San Jose     CA  
1746 1746 1990-01-31 Nisshinbo California, Inc. 1989-07-28 JAPAN Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe Fresno     CA  
1749 1749 1990-01-31 Sumiden Wire Products Corporation 1989-07-28 JAPAN Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe Stockton     CA  
1769 1769 1992-01-31 Sanyo Fisher (U.S.A.) Corporation 1992-01-27 JAPAN Pillsbury, Madison & Sutro 4212 1989-01-27 Pillsbury, Madison & Sutro Chatsworth     CA  
2192 2192 1993-02-04 Japan Airlines Company, Ltd. 1954-01-05 JAPAN Charles von Loewenfeldt, Inc. 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
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  
2738 2738 1976-02-24 Japan External Trade Organization 1974-03-22 JAPAN Whitehouse Associates, Inc. 2190 1970-02-24 Whitehouse Associates, Inc. Los Angeles     CA  
2739 2739 1981-02-24 Japan Trade Center, Agriculture and Fisheries Section 1973-03-06 JAPAN Whitehouse Associates, Inc. 2190 1970-02-24 Whitehouse Associates, Inc. Los Angeles     CA  
2872 2872 1953-02-27 Kazuo Kamogawa, Representative, Council on Tuna Export of Japan 1952-01-25 JAPAN Baar, Bennett & Fullen 712 1952-01-25 Baar, Bennett & Fullen Beverly Hills     CA  
3971 3971 1991-03-22 Government of Japan 1989-06-15 JAPAN Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe San Francisco     CA  
4229 4229 1999-03-30 JETRO, San Francisco 1988-08-26 JAPAN TransPacific Communications & Research Company 4173 1988-08-26 TransPacific Communications & Research Company       CA  
4419 4419 1985-03-31 Consulate General of Japan, San Francisco 1972-03-07 JAPAN Charles von Loewenfeldt, Inc. 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
4420 4420 1985-03-31 Consulate General of Japan, San Francisco 1965-04-09 JAPAN Charles von Loewenfeldt, Inc. 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
4444 4444 1988-03-31 Consulate General of Japan, San Francisco 1986-12-15 JAPAN Charles von Loewenfeldt, Inc. 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
4502 4502 1991-03-31 Fujitsu Microelectronics 1989-03-28 JAPAN Ball, Janik & Novack 4230 1989-03-28 Ball, Janik & Novack San Jose     CA  
4518 4518 1992-03-31 JETRO, Los Angeles (Japan External Trade Organization) 1988-03-08 JAPAN Productions by Hirahara 4099 1988-03-08 Productions by Hirahara Los Angeles     CA  
4618 4618 2003-03-31 Japan External Trade Organization 1992-08-10 JAPAN MS Research, Inc. 4697 1992-08-10 MS Research, Inc. Los Angeles     CA  
4638 4638 2005-03-31 Consulate of Japan at Los Angeles, CA 2002-06-18 JAPAN Policy Development Group, Inc. 5504 2002-06-18 Policy Development Group, Inc. 350 S. Grand Avenue, Suite 1700 Los Angeles     CA  
4788 4788 2020-03-31 Consulate General of Japan in San Francisco 2016-01-20 JAPAN California Strategies, LLC 6337 2016-01-20 California Strategies, LLC Consulate General of Japan in San Francisco 275 Battery Street, #2100 San Francisco CA 94111
4800 4800 2021-03-31 Consulate General for Japan in Los Angeles 2019-04-09 JAPAN Community Partners 6659 2019-04-09 Community Partners 350 S. Grand Avenue   Los Angeles CA 90071
4948 4948 2001-04-01 Consulate General of Japan 1970-02-24 JAPAN Whitehouse Associates, Inc. 2190 1970-02-24 Whitehouse Associates, Inc. Los Angeles     CA  
5424 5424 1987-04-20 Makita U.S.A., Inc. 1987-04-21 JAPAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Cerritos     CA  
6900 6900 1974-05-29 Mazda Motors of America, Inc. 1974-02-19 JAPAN Leva, Hawes, Symington, Martin & Oppenheimer 2490 1974-01-28 Leva, Hawes, Symington, Martin & Oppenheimer Compton     CA  
7118 7118 1991-05-31 Shionogi U.S.A., Inc. 1990-11-29 JAPAN Cosmo Public Relations 4434 1990-11-13 Cosmo Public Relations Torrance     CA  
7403 7403 1989-06-01 Government of Japan 1988-07-29 JAPAN Greve, Clifford, Diepenbrock & Paras 4163 1988-07-29 Greve, Clifford, Diepenbrock & Paras San Francisco     CA  
7528 7528 1966-06-03 Japanese Consulate General at San Francisco (Consul General of Japan) 1964-12-03 JAPAN Graham, James & Rolph 1825 1964-12-03 Graham, James & Rolph San Francisco     CA  
7767 7767 1990-06-12 Seibulite International, Inc. 1988-09-13 JAPAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Rancho Domingues     CA  
7819 7819 1980-06-15 Toyota Motor Sales U.S.A., Inc. 1980-07-08 JAPAN O'Connor & Hannan, L.L.P. 2972 1978-10-25 O'Connor & Hannan, L.L.P. Torrence     CA  
7957 7957 1981-06-20 PL Kyodan - Church of Perfect Liberty/Perfect Liberty Order 1969-04-08 JAPAN Steele, Donald Dickinson 2030 1967-06-20 Steele, Donald Dickinson Glendale     CA  
7958 7958 1981-06-20 Toshiba International Corporation 1968-01-06 JAPAN Steele, Donald Dickinson 2030 1967-06-20 Steele, Donald Dickinson San Francisco     CA  
8008 8008 1990-06-22 Hitachi Sales Corporation of America 1987-04-10 JAPAN Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. Compton     CA  
8031 8031 1988-06-23 JETRO, San Francisco 1986-07-18 JAPAN Potash & Company 3859 1986-07-18 Potash & Company San Francisco     CA  
8076 8076 1996-06-24 Fujitsu America, Inc. 1987-08-07 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP San Jose     CA  
8290 8290 1972-06-30 Japan Trade Center (JETRO) 1967-03-14 JAPAN Neeson Company 2015 1967-03-14 Neeson Company San Francico     CA  
9264 9264 1986-07-15 Japan Trade Center 1984-02-01 JAPAN Productions by Hirahara 3556 1984-02-01 Productions by Hirahara Los Angeles     CA  
9729 9729 1982-07-31 Japan External Trade Organization 1981-08-13 JAPAN Charles von Loewenfeldt, Inc. 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
10086 10086 1956-08-03 Consulate General of Japan, San Francisco 1954-01-05 JAPAN Charles von Loewenfeldt, Inc. 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
10188 10188 1985-08-07 Japan Trade Center, Los Angeles 1975-07-11 JAPAN InfoAid 2594 1975-07-11 InfoAid Los Angeles     CA  
10215 10215 1994-08-08 Industrial Bank of Japan, Ltd. San Francisco Agency 1993-05-19 JAPAN Keene & Associates 4511 1991-05-14 Keene & Associates San Francisco     CA  
10933 10933 1981-08-31 Italian State Tourist Office 1973-04-17 JAPAN Association Films, Inc. 1814 1964-11-06 Association Films, Inc. San Francisco     CA  
11381 11381 1984-09-05 Japan Trade Center (Japan External Trade Organization) San Francisco 1972-08-10 JAPAN Carl Byoir, Arnold, Palmer & Noble 2367 1972-08-10 Carl Byoir, Arnold, Palmer & Noble San Francisco     CA  
11626 11626 1981-09-15 Japan External Trade Organization (JETRO) 1981-03-03 JAPAN Sharp, Hartwig & Vladimir 3210 1981-03-03 Sharp, Hartwig & Vladimir       CA  
11931 11931 1973-09-30 Japan External Trade Organization 1971-10-07 JAPAN Ruder & Finn of California, Inc. 2284 1971-10-07 Ruder & Finn of California, Inc. Los Angeles     CA  
11951 11951 1980-09-30 Japan Trade Center, San Francisco 1955-01-26 JAPAN Charles von Loewenfeldt, Inc. 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
12013 12013 1989-09-30 Suzuki of America Automotive Corporation 1988-03-15 JAPAN IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc Brea     CA  
12027 12027 1990-09-30 Ricoh Electronics, Inc. 1988-09-01 JAPAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Tustin     CA  
12192 12192 2009-09-30 Government of Japan, Consulate 1991-05-14 JAPAN Keene & Associates 4511 1991-05-14 Keene & Associates San Francisco     CA  
12959 12959 1988-10-23 Epson America, Inc. 1987-08-17 JAPAN Burson-Marsteller 2469 1973-10-23 Burson-Marsteller Torrance     CA  
13164 13164 1987-10-30 JETRO, Los Angeles 1986-09-05 JAPAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Los Angeles     CA  
13263 13263 1989-10-31 Suzuki of America Automotive Corporation 1988-02-25 JAPAN Thompson & Company 4094 1988-02-25 Thompson & Company Brea     CA  
13738 13738 1990-11-05 Japan Shipbuilding Industry Foundation 1990-04-17 JAPAN North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate Los Angeles     CA  
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  
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  
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  

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