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 Foreign_Principal
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Registration_Date (date)
Foreign_Principal 9
Registrant_Name 8
Registrant_Date (date) 8 ✖
- 1964-11-06 2
- 2013-05-14 2
- 1969-07-11 1
- 2014-06-18 1
- 2020-06-22 1
- 2022-03-02 1
- 2022-10-14 1
- 2023-04-21 1
City 6
- - 3
- City of Industry 3
- Fremont 1
- San Francisco 1
- Santa Clara 1
- Temple City 1
Foreign_Principal_Termination_Date (date) 3 ✖
- 1981-08-31 2
- 1969-07-30 1
- 2022-03-02 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | ||
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 | |
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 | |||
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 | |
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]) );