FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Foreign_Principal_Termination_Date" is on date 2019-03-31 sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 10
Foreign_Principal 9
- Embassy of Mexico through Kuykendall & Associates 2
- Embassy of Japan 1
- Federal Government of Somalia 1
- Government of Ontario, Canada 1
- Hong Kong Trade Development Council 1
- Huawei Technologies Co. Ltd. (via BCW Asia Pacific) 1
- Professor Tryphon Kin Kiey Mulumba 1
- Royal Thai Embassy, Office of Commercial Affairs 1
- VTA Telecom Corp, Viettel Group 1
Country/Location_Represented 9
- MEXICO 2
- CANADA 1
- CHINA 1
- CONGO, REPUBLIC OF THE 1
- HONG KONG 1
- JAPAN 1
- SOMALI DEMOCRATIC REPUBLIC 1
- THAILAND 1
- VIETNAM 1
City 4
- - 5
- Washington 3
- Milpitas 1
- New York 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4778 | 4778 | 2019-03-31 | Embassy of Japan | 2012-04-25 | JAPAN | Friedlander Group 6097 | 2012-04-25 | Friedlander Group | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
4779 | 4779 | 2019-03-31 | Embassy of Mexico through Kuykendall & Associates | 2009-02-02 | MEXICO | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 1911 Pennsylvania Avenue, NW | Washington | DC | 20006 | |
4780 | 4780 | 2019-03-31 | Embassy of Mexico through Kuykendall & Associates | 2009-04-24 | MEXICO | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | |||||
4781 | 4781 | 2019-03-31 | Federal Government of Somalia | 2018-08-10 | SOMALI DEMOCRATIC REPUBLIC | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 6399 | 2016-12-11 | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy | 425 East 61st Street, Suite 702 | New York | NY | 10065 | |
4783 | 4783 | 2019-03-31 | Hong Kong Trade Development Council | 2002-10-15 | HONG KONG | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1520 18th Street, N.W. 20036 | DC | |||
4785 | 4785 | 2019-03-31 | Professor Tryphon Kin Kiey Mulumba | 2018-08-06 | CONGO, REPUBLIC OF THE | McMark, LLC 6359 | 2016-06-13 | McMark, LLC | Avenue du General Mika, Binza-UPN Telecoms, Kinshasa/Ngaliema | ||||
4786 | 4786 | 2019-03-31 | Royal Thai Embassy, Office of Commercial Affairs | 2013-08-12 | THAILAND | Sandler Trade, LLC 6180 | 2013-08-12 | Sandler Trade, LLC | Office of Commercial Affairs Royal Thai Embassy | 1024 Wisconsin Avenue | Washington | DC | 20007 |
4784 | 4784 | 2019-03-31 | Huawei Technologies Co. Ltd. (via BCW Asia Pacific) | 2019-03-20 | CHINA | BCW LLC 6227 | 2014-06-18 | BCW LLC | Bantian Huawei Base, Longgang District | Shenzhen, 518129 | |||
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 |
4782 | 4782 | 2019-03-31 | Government of Ontario, Canada | 2017-12-21 | CANADA | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 10 Dundas Street East, Suite 900 | Toronto, Ontario Canada M7A 2A1 |
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]) );