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 2020-08-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_2, Zip, Registrant_Date (date)
Foreign_Principal 7
- Association of Enterprises UKRMETALURGPROM 1
- BNK (UK) Limted (CJSC Belarusian Oil Company &Concern Belneftekhim) 1
- Embassy of the Islamic Republic of Afghanistan 1
- Federal State Unitary Enterprise Rossiya Segodnya International Information Agency 1
- Kingdom of Bahrain 1
- Muttahida Quami Movement 1
- Nihad Poljakovic SH Logistics LLC 1
Country/Location_Represented 7
- AFGHANISTAN 1
- BAHRAIN 1
- BELARUS 1
- BOSNIA & HERZEGOVINA 1
- PAKISTAN 1
- RUSSIA 1
- UKRAINE 1
Registrant_Name 6
City 2
- - 6
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11182 | 11182 | 2020-08-31 | Association of Enterprises UKRMETALURGPROM | 2019-08-29 | UKRAINE | Livingston Group, LLC 6344 | 2016-03-25 | Livingston Group, LLC | Svyatoslav Horobriy str. 11 | 49000 Dnipro, Dnipropetrovsk | |||
11183 | 11183 | 2020-08-31 | BNK (UK) Limted (CJSC Belarusian Oil Company &Concern Belneftekhim) | 2019-08-12 | BELARUS | Gencarelli, David F. 6706 | 2019-08-12 | Gencarelli, David F. | 4a-305 Leshinsky Street 220140 Minsk Belarus | ||||
11185 | 11185 | 2020-08-31 | Federal State Unitary Enterprise Rossiya Segodnya International Information Agency | 2018-02-16 | RUSSIA | RIA Global LLC 6524 | 2018-02-16 | RIA Global LLC | 119034 Moscow, Zubovsky b-rd 4, building 1, 2, 3 | ||||
11186 | 11186 | 2020-08-31 | Kingdom of Bahrain | 2014-05-20 | BAHRAIN | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | Ministry of Foreign Affairs P.O. Box 547 | Government Road Manama | |||
11187 | 11187 | 2020-08-31 | Muttahida Quami Movement | 2017-08-13 | PAKISTAN | MQM International, Inc. (Muttahida Quami Movement) 6454 | 2017-08-13 | MQM International, Inc. (Muttahida Quami Movement) | H #268, P.I. B., GULSHAN TOWN, KARACHI SIND | ||||
11188 | 11188 | 2020-08-31 | Nihad Poljakovic SH Logistics LLC | 2019-08-15 | BOSNIA & HERZEGOVINA | Alexandria Group International LLC 6707 | 2019-08-15 | Alexandria Group International LLC | |||||
11184 | 11184 | 2020-08-31 | Embassy of the Islamic Republic of Afghanistan | 2018-09-20 | AFGHANISTAN | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 2341 Wyoming Avenue | 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]) );