FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
4 rows where "Foreign_Principal_Termination_Date" is on date 2015-11-30
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Registrant_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14555 | 14555 | 2015-11-30 | Consulate General of Israel to the Mid-Atlantic Region | 2014-12-19 | ISRAEL | Ceisler Media & Issue Advocacy, LLC 6266 | 2014-12-19 | Ceisler Media & Issue Advocacy, LLC | 1880 JFK Blvd. Suite 1818 | Philadelphia | PA | 19103 | |
14556 | 14556 | 2015-11-30 | Ministry of Economy and Finance of the Republic of Haiti | 2014-10-06 | HAITI | Sorini, Samet & Associates, LLC 5839 | 2007-11-12 | Sorini, Samet & Associates, LLC | 5 Ave. Charles Summer | ||||
14557 | 14557 | 2015-11-30 | Ministry of Trade and Tourism of Peru/Embassy of Peru | 2015-06-19 | PERU | Paz-Soldan, Carlos Mateo 6301 | 2015-06-19 | Paz-Soldan, Carlos Mateo | Calle Uno Oeste 50, Urb. Corpac, San Isidro, Lima 27 | ||||
14558 | 14558 | 2015-11-30 | Turkish Republic of Northern Cyprus (T.R.N.C.")" | 2013-09-09 | CYPRUS | Herrick, Feinstein LLP 6185 | 2013-09-09 | Herrick, Feinstein LLP | Office of the Representative T.R.N.C. | 1667 K Street, NW., Suite 690 | Washington | DC | 20006 |
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]) );