FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Registrant_Name = "Venable, LLP" and State = ""
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registrant_Date, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 10
- Fernando Poe through Horacio Morales, Puwersa ng Masang Pilipino 1
- Gazprom Export through Ketchum, Inc. 1
- Hong Kong Trade Development Council 1
- Kili/Bikini/Ejit Local Government Council 1
- Malaysian Palm Oil Council 1
- Republic of the Philippines 1
- Rodina Political Party 1
- Serbian National Council of Kosovo and Metohija 1
- Sheikh Khalid Bin Saqr Al Qasimi, Crown Prince and Deputy Ruler, Ras Al Khaimah, United Arab Emirates 1
- Viktor Yanukovych, Prime Minister of Ukraine - Eduard Prutnik, Advisor to the Prime Minister 1
Country/Location_Represented 8
- PHILIPPINES 2
- RUSSIA 2
- HONG KONG 1
- MALAYSIA 1
- MARSHALL ISLANDS 1
- SERBIA 1
- UKRAINE 1
- UNITED ARAB EMIRATES 1
City 4
- - 7
- Moscow 1
- Quezon City 1
- Wanchai 1
State 1
- - · 10 ✖
Registrant_Name 1
- Venable, LLP · 10 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
335 | 335 | Hong Kong Trade Development Council | 2009-06-02 | HONG KONG | Venable, LLP 5931 | 2009-04-17 | Venable, LLP | 36-39/F, Office Tower, Convention Plaza | 1 Harbour Road | Wanchai | |||
394 | 394 | Kili/Bikini/Ejit Local Government Council | 2018-02-02 | MARSHALL ISLANDS | Venable, LLP 5931 | 2009-04-17 | Venable, LLP | Post Office Box 1096 | Majuro, MH 96960 | ||||
1869 | 1869 | 2007-01-31 | Republic of the Philippines | 2005-08-02 | PHILIPPINES | Venable, LLP 5435 | 2001-05-29 | Venable, LLP | #5 V. Luna Road, Diliman | Quezon City | |||
1870 | 1870 | 2007-01-31 | Rodina Political Party | 2005-09-22 | RUSSIA | Venable, LLP 5435 | 2001-05-29 | Venable, LLP | ul. Vozdvizhenka, 7/6 | 119019 Moscow | |||
1871 | 1871 | 2007-01-31 | Serbian National Council of Kosovo and Metohija | 2006-04-04 | SERBIA | Venable, LLP 5435 | 2001-05-29 | Venable, LLP | c/o Abbot Simeon (Vilovski) Banjska Monastery | 38216 Banjska Kosovo and Metobiia | |||
4741 | 4741 | 2014-03-31 | Gazprom Export through Ketchum, Inc. | 2010-06-21 | RUSSIA | Venable, LLP 5931 | 2009-04-17 | Venable, LLP | Nametkina Street, V-420, GSP-7 | Moscow | |||
6993 | 6993 | 2004-05-30 | Fernando Poe through Horacio Morales, Puwersa ng Masang Pilipino | 2004-04-13 | PHILIPPINES | Venable, LLP 5435 | 2001-05-29 | Venable, LLP | 409 Shaw Boulevard Mandaluyong City Metro Manila | ||||
14296 | 14296 | 2017-11-28 | Malaysian Palm Oil Council | 2016-04-05 | MALAYSIA | Venable, LLP 5931 | 2009-04-17 | Venable, LLP | 2nd Floor, Wisma Sawit, Lot 6, SS6, Jalan Perbandaran | 47301 Kelana Jaya, Selangor Darul Ehsan | |||
14520 | 14520 | 2005-11-30 | Viktor Yanukovych, Prime Minister of Ukraine - Eduard Prutnik, Advisor to the Prime Minister | 2003-08-01 | UKRAINE | Venable, LLP 5435 | 2001-05-29 | Venable, LLP | 123 Independence Avenue, Kiev | ||||
14545 | 14545 | 2012-11-30 | Sheikh Khalid Bin Saqr Al Qasimi, Crown Prince and Deputy Ruler, Ras Al Khaimah, United Arab Emirates | 2010-05-28 | UNITED ARAB EMIRATES | Venable, LLP 5931 | 2009-04-17 | Venable, LLP |
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]) );