FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Foreign_Principal_Termination_Date = "2012-03-31"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 11
- BGR Gabara, Ltd. (for Bidzina Ivanishvili) 1
- BGR Gabara, Ltd. (for Bidzina Ivanshvili) 1
- BGR Gabara, Ltd. (for Free Democrats) 1
- BGR Gabara, Ltd. (for the Free Democrats) 1
- CCTV America 1
- Government of the Republic of Singapore Ministry of Finance 1
- Moroccan American Center for Policy 1
- NATS Services 1
- Proexport Colombia 1
- Republic of Senegal 1
- Utrok Atoll Local Government 1
Registrant_Name 9
Country/Location_Represented 8
- GEORGIA 4
- CHINA 1
- COLOMBIA 1
- MARSHALL ISLANDS 1
- MOROCCO 1
- SENEGAL 1
- SINGAPORE 1
- UNITED KINGDOM 1
City 5
- - 6
- Washington 2
- Bogota 1
- London 1
- London 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4717 | 4717 | 2012-03-31 | BGR Gabara, Ltd. (for Bidzina Ivanishvili) | 2011-11-28 | GEORGIA | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 1 Duchess Street | London, WIW 6AN | |||
4718 | 4718 | 2012-03-31 | BGR Gabara, Ltd. (for Bidzina Ivanshvili) | 2011-12-21 | GEORGIA | Office of Sam Patten, LLC 6081 | 2011-12-21 | Office of Sam Patten, LLC | 1 Duchess Street | London | |||
4719 | 4719 | 2012-03-31 | BGR Gabara, Ltd. (for Free Democrats) | 2011-07-22 | GEORGIA | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 1 Duchess Street | London, WIW 6AN | |||
4720 | 4720 | 2012-03-31 | BGR Gabara, Ltd. (for the Free Democrats) | 2011-12-21 | GEORGIA | Office of Sam Patten, LLC 6081 | 2011-12-21 | Office of Sam Patten, LLC | 1 Duchess Street | London | |||
4721 | 4721 | 2012-03-31 | CCTV America | 2012-01-25 | CHINA | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1099 New York Avenue, NW | Suite 430 | Washington | DC | 20001 |
4722 | 4722 | 2012-03-31 | Government of the Republic of Singapore Ministry of Finance | 2009-02-24 | SINGAPORE | Miller & Chevalier, Chartered 5365 | 2000-04-03 | Miller & Chevalier, Chartered | The Treasury 100 High Street #06-03 | Singapore 179434 | |||
4723 | 4723 | 2012-03-31 | Moroccan American Center for Policy | 2011-05-19 | MOROCCO | Dutko Worldwide, LLC 6041 | 2011-05-19 | Dutko Worldwide, LLC | 1220 L Street, NW | #411 | Washington | DC | 20005 |
4724 | 4724 | 2012-03-31 | NATS Services | 2012-06-01 | UNITED KINGDOM | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | Heathrow House, Bath Road Hounslous, Middlesex TW5 9AT | United Kingdom | |||
4725 | 4725 | 2012-03-31 | Proexport Colombia | 2009-10-29 | COLOMBIA | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | Calle 28A No 13A-15 Piso 35 | Bogota | |||
4726 | 4726 | 2012-03-31 | Republic of Senegal | 2011-11-22 | SENEGAL | McKenna Long & Aldridge, LLP 5772 | 2006-10-03 | McKenna Long & Aldridge, LLP | Office of the President | Republic of Senegal Dakar | |||
4727 | 4727 | 2012-03-31 | Utrok Atoll Local Government | 2003-10-20 | MARSHALL ISLANDS | Van Scoyoc Associates, Inc. 5401 | 2000-12-14 | Van Scoyoc Associates, Inc. | Post Office Box 741 Majuro, MAR 96960 |
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]) );