FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where "Foreign_Principal_Termination_Date" is on date 2021-11-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 7
Foreign_Principal 7
Country/Location_Represented 7
- CHINA 1
- GUATEMALA 1
- HAITI 1
- KOREA, SOUTH 1
- LESOTHO 1
- POLAND 1
- SAUDI ARABIA 1
City 5
- - 3
- Guatemala Ciudad 1
- Maseru 1
- Port-au-Prince 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14591 | 14591 | 2021-11-30 | Alibaba.com | 2021-07-29 | CHINA | Racepoint Global, Inc. 6650 | 2019-03-15 | Racepoint Global, Inc. | 699 Wangshang Rd, Binjiang Qu, | Peoples Republic of China | |||
14595 | 14595 | 2021-11-30 | NEOM Company | 2020-06-22 | SAUDI ARABIA | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | |||||
14596 | 14596 | 2021-11-30 | Polish Space Agency | 2018-04-10 | POLAND | Hall Jr., John F. 6555 | 2018-05-02 | Hall Jr., John F. | |||||
14597 | 14597 | 2021-11-30 | Zury Mayte Rios de Smith | 2021-09-08 | GUATEMALA | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 6399 | 2016-12-11 | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy | 18 Calle 24-69, Zona 10 | Empresarial zone Prader Torres 2, Nivel 11 oficina 1108 | Guatemala Ciudad | ||
14594 | 14594 | 2021-11-30 | Lesotho Textile Exporters Association | 2021-09-17 | LESOTHO | Ryberg and Smith, LLC 7015 | 2021-09-17 | Ryberg and Smith, LLC | Suite 009 Thetsame Industrial | Maseru | |||
14592 | 14592 | 2021-11-30 | Dr. Reginald Boulos | 2021-05-26 | HAITI | Novitas Communication Inc. 6965 | 2021-05-26 | Novitas Communication Inc. | 20, Blvd Toussaint Louverture Boulevard Toussain | 6120 | Port-au-Prince | ||
14593 | 14593 | 2021-11-30 | Korea Ministry of Trade, Industry and Energy through K&L Gates, LLP | 2019-06-25 | KOREA, SOUTH | Bluetext, LLC 6693 | 2019-06-25 | Bluetext, LLC | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 |
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]) );