FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1 row where Country/Location_Represented = "CONGO, REPUBLIC OF THE" and Foreign_Principal = "Mer Security and Communications Systems, Ltd (Mer) on behalf of the Government of the Democratic Republic of the Congo (DRC)" sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date (date)
State 1
- - 1
Registrant_Name 1
Foreign_Principal_Termination_Date (date) 1 ✖
Foreign_Principal 1
- Mer Security and Communications Systems, Ltd (Mer) on behalf of the Government of the Democratic Republic of the Congo (DRC) · 1 ✖
Country/Location_Represented 1
- CONGO, REPUBLIC OF THE · 1 ✖
City 1
- - 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1200 | 1200 | 2019-01-10 | Mer Security and Communications Systems, Ltd (Mer) on behalf of the Government of the Democratic Republic of the Congo (DRC) | 2018-10-17 | CONGO, REPUBLIC OF THE | Sanitas International, Inc. 6530 | 2018-03-07 | Sanitas International, Inc. |
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]) );