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 = "2019-04-01"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4966 | 4966 | 2019-04-01 | Foreign Affairs Office of Yancheng Municipal People's Government | 2018-03-05 | CHINA | Baker, Donelson, Bearman, Caldwell & Berkowitz, P.C. 6535 | 2018-03-05 | Baker, Donelson, Bearman, Caldwell & Berkowitz, P.C. | Room 1308, No. 19, Shiji Avenue, Yancheng City | Jiangsu Province, China | |||
4967 | 4967 | 2019-04-01 | Japan Automobile Manufacturers' Association, Inc. | 1992-05-05 | JAPAN | Maseng Communications 4660 | 1992-05-05 | Maseng Communications | Tokyo | ||||
4968 | 4968 | 2019-04-01 | Ambassador Serge Mombouli | 2018-11-05 | CONGO, DEMOCRATIC REPUBLIC OF THE | Courville Consultants, LLC 6606 | 2018-11-05 | Courville Consultants, LLC | 1720 16th Street, NW | Washington | DC | 20009 | |
4969 | 4969 | 2019-04-01 | Democratic Party of Moldova | 2018-01-09 | MOLDOVA | Cogent Strategies LLC 6502 | 2017-12-21 | Cogent Strategies LLC | 32 Tighina Street, MD -2001 | Chisinau | |||
4970 | 4970 | 2019-04-01 | Embassy of Hungary | 2018-12-31 | HUNGARY | Capitol Financial Strategies, LLC 6624 | 2018-12-31 | Capitol Financial Strategies, LLC | 3910 Shoemaker Street, NW | Washington | DC | 20008 | |
4971 | 4971 | 2019-04-01 | Felix Tshisekedi | 2018-03-29 | CONGO, REPUBLIC OF THE | Caroline Law Corporation 6536 | 2018-03-29 | Caroline Law Corporation | 2600, Bldv. Lumumba Q/Residentiel 11 eme Rue Limete | Kinshasa | |||
4972 | 4972 | 2019-04-01 | Turismo Chile | 2014-10-30 | CHILE | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | Av. Providencia 2088, Oficinia 20 Santiago |
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]) );