FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
216 rows where State = "CA" sorted by Foreign_Principal
This data as json, CSV (advanced)
Registrant_Name 15
- Australian-American Public Relations, Inc. 2
- Association Films, Inc. 1
- BCW LLC 1
- Bond Donatelli, Inc. 1
- Charles von Loewenfeldt, Inc. 1
- Dowell Pham Harrison, LLP 1
- EDI Media, Inc. 1
- Gottshall, Ronald Burton 1
- JWI, LLC 1
- Keating Group, Inc. 1
- MK Technology Associates, Ltd. 1
- N.W. Ayer & Son, Inc. 1
- O'Connor & Hannan, L.L.P. 1
- Schrier, Elliot 1
- Sher & Blackwell 1
Foreign_Principal 15
- Transpacific Westbound Rate Agreement (TWRA) 2
- Toyota Motor Sales U.S.A., Inc. 1
- Transpacific Westbound Rate Agreement 1
- U.T.A. French Airlines 1
- UTA French Airlines 1
- United Arab Republic State Tourist Administration 1
- VTA Telecom Corp, Viettel Group 1
- Victorian Tourism Commission 1
- Victorian Tourist Commission 1
- Voice of Democracy 1
- Western Australian Tourism Commission 1
- Wyse Technology 1
- XinMin International, Inc. 1
- Yin Choy Oen 1
- Hikvision USA Inc. as an agent of Hikvision 1
Country/Location_Represented 10
- AUSTRALIA 3
- INTERNATIONAL 3
- CHINA 2
- FRANCE 2
- EQUATORIAL GUINEA 1
- HONG KONG 1
- JAPAN 1
- TAIWAN 1
- UNITED ARAB EMIRATES 1
- VIETNAM 1
City 5
- - 12
- City of Industry 1
- Los Angeles 1
- Milpitas 1
- Temple City 1
State 1
- CA · 16 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
15414 | 15414 | 1994-12-27 | Transpacific Westbound Rate Agreement | 1993-09-30 | INTERNATIONAL | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | San Francisco | CA | |||
10532 | 10532 | 1994-08-15 | Transpacific Westbound Rate Agreement (TWRA) | 1993-09-30 | INTERNATIONAL | Schrier, Elliot 4854 | 1993-09-30 | Schrier, Elliot | San Francisco | CA | |||
11650 | 11650 | 1994-09-15 | Transpacific Westbound Rate Agreement (TWRA) | 1993-09-30 | INTERNATIONAL | Gottshall, Ronald Burton 4853 | 1993-09-30 | Gottshall, Ronald Burton | San Francisco | CA | |||
14352 | 14352 | 1977-11-30 | U.T.A. French Airlines | 1970-04-27 | FRANCE | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Los Angeles | CA | |||
3631 | 3631 | 1993-03-11 | UTA French Airlines | 1989-12-28 | FRANCE | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | San Francisco | CA | |||
5014 | 5014 | 1963-04-04 | United Arab Republic State Tourist Administration | 1961-02-03 | UNITED ARAB EMIRATES | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | San Francisco | CA | |||
4787 | 4787 | 2019-03-31 | VTA Telecom Corp, Viettel Group | 2017-09-11 | VIETNAM | Dowell Pham Harrison, LLP 6461 | 2017-09-11 | Dowell Pham Harrison, LLP | 1441 McCarthy Blvd. | Suite 210 | Milpitas | CA | 95935 |
9365 | 9365 | 1994-07-19 | Victorian Tourism Commission | 1988-04-04 | AUSTRALIA | Australian-American Public Relations, Inc. 4113 | 1988-04-04 | Australian-American Public Relations, Inc. | Los Angeles | CA | |||
8433 | 8433 | 1988-06-30 | Victorian Tourist Commission | 1987-02-10 | AUSTRALIA | N.W. Ayer & Son, Inc. 3411 | 1982-09-27 | N.W. Ayer & Son, Inc. | Los Angeles | CA | |||
10608 | 10608 | 2005-08-18 | Voice of Democracy | 2005-07-08 | EQUATORIAL GUINEA | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | 1185 South Keniston Avenue | Los Angeles | CA | 90019-1710 | |
9366 | 9366 | 1994-07-19 | Western Australian Tourism Commission | 1988-04-04 | AUSTRALIA | Australian-American Public Relations, Inc. 4113 | 1988-04-04 | Australian-American Public Relations, Inc. | Los Angeles | CA | |||
8178 | 8178 | 1994-06-29 | Wyse Technology | 1993-03-22 | TAIWAN | MK Technology Associates, Ltd. 4781 | 1993-03-22 | MK Technology Associates, Ltd. | San Jose | CA | |||
3384 | 3384 | 2022-03-02 | XinMin International, Inc. | 2022-03-02 | CHINA | EDI Media, Inc. 7086 | 2022-03-02 | EDI Media, Inc. | 5250 Sereno Dr. | Temple City | CA | 91780 | |
13269 | 13269 | 1989-10-31 | Yin Choy Oen | 1989-02-14 | HONG KONG | Bond Donatelli, Inc. 4215 | 1989-02-14 | Bond Donatelli, Inc. | San Francisco | CA | |||
765 | 765 | Hikvision USA Inc. as an agent of Hikvision | 2018-08-01 | CHINA | BCW LLC 6227 | 2014-06-18 | BCW LLC | 18639 Railroad Street | City of Industry | CA | 91748 |
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]) );