FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Country/Location_Represented = "CHINA" and State = "CA" sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_1, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 9
Registrant_Name 8
City 6
- - 3
- City of Industry 3
- Fremont 1
- San Francisco 1
- Santa Clara 1
- Temple City 1
Address_2 2 ✖
- - 9
- Suite 2200 1
State 1
- CA · 10 ✖
Country/Location_Represented 1
- CHINA · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
258 | 258 | Futurewei Technologies, Inc. | 2023-01-09 | CHINA | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 2220 Central Expressway | Santa Clara | CA | 95050 | ||
269 | 269 | Gotion, Inc. | 2023-04-21 | CHINA | Warner Norcross + Judd 7261 | 2023-04-21 | Warner Norcross + Judd | 48660 Kato Rd. | Fremont | CA | 94538 | ||
326 | 326 | Hikvision USA Inc. | 2018-08-16 | CHINA | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 18639 Railroad Street | City of Industry | CA | 91748 | ||
328 | 328 | Hikvision USA, Inc. | 2022-10-14 | CHINA | The Elevation Association, LLC 7187 | 2022-10-14 | The Elevation Association, LLC | 18639 Railroad Street | City of Industry | CA | 91748 | ||
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 | ||
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 | |
9607 | 9607 | 1969-07-30 | Chinese Information Service | 1969-07-11 | CHINA | Curtis, Claude H. 2151 | 1969-07-11 | Curtis, Claude H. | San Francisco | CA | |||
10910 | 10910 | 1981-08-31 | Chinese Information Service | 1973-07-24 | CHINA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Los Angeles | CA | |||
10963 | 10963 | 1981-08-31 | Tourism Council of the Republic of China | 1971-02-14 | CHINA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
382 | 382 | JinkoSolar (U.S.) Inc. | 2020-12-12 | CHINA | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 595 Market Street | Suite 2200 | San Francisco | CA | 94105 |
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]) );