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 2014-09-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 7
Foreign_Principal 7
Country/Location_Represented 5
- SRI LANKA 3
- AFGHANISTAN 1
- AZERBAIJAN 1
- BANGLADESH 1
- ROMANIA 1
City 3
- - 4
- Colombo 2
- Staten Island 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12219 | 12219 | 2014-09-30 | Azerbaijan Consul General, Western US | 2013-05-28 | AZERBAIJAN | Potomac Square Group 6096 | 2012-03-27 | Potomac Square Group | |||||
12220 | 12220 | 2014-09-30 | Democratic Socialist Republic of Sri Lanka | 2014-06-02 | SRI LANKA | Beltway Government Strategies Inc. 6225 | 2014-06-02 | Beltway Government Strategies Inc. | No. 9/2 Dudley Senanayake Mawatha Colombo 08 | ||||
12223 | 12223 | 2014-09-30 | Grigoruta, Roxana | 2013-11-06 | ROMANIA | Shulman, Rogers, Gandal, Pordy & Ecker, P.A. 5976 | 2010-03-03 | Shulman, Rogers, Gandal, Pordy & Ecker, P.A. | 14, Jandarmeriei Street, BI. 8C Apt 11 | Bucharest, 013896 | |||
12225 | 12225 | 2014-09-30 | Transformation and Continuity, Ajmal Ghani | 2014-05-05 | AFGHANISTAN | Fenton Communications 6245 | 2014-05-05 | Fenton Communications | House #3 MRRD Road | Darul Aman Kabul | |||
12221 | 12221 | 2014-09-30 | Government of Sri Lanka via Central Bank of Sri Lanka | 2015-09-15 | SRI LANKA | WR Group, LLC 6319 | 2015-09-15 | WR Group, LLC | Colombo | ||||
12222 | 12222 | 2014-09-30 | Government of Sri Lanka | 2015-09-09 | SRI LANKA | Zuberi, Imaad 6316 | 2015-09-09 | Zuberi, Imaad | Colombo | ||||
12224 | 12224 | 2014-09-30 | Organization for Peace and Justice, Inc. | 2014-04-15 | BANGLADESH | Cassidy & Associates, Inc. 6214 | 2014-04-15 | Cassidy & Associates, Inc. | 252A Lake Avenue | Staten Island | NY | 10303 |
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]) );