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" is on date 2012-09-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1
Foreign_Principal 10
- Tourism Ireland 2
- Bay Gardens Resorts 1
- Government of the Republic of Haiti 1
- Government of the Republic of Malawi through Whitaker Group Inc. 1
- Horizontes, LTDA 1
- Novartis, A.G. 1
- Republic of Kazakhstan through Windrush Ventures No. 3 LP through Windrush Ventures Limited through Portland PR Limited 1
- Republic of Serbia 1
- Society of London Theatre 1
- Stedelijk Museum Amsterdam 1
Country/Location_Represented 10
- IRELAND 2
- BRAZIL 1
- HAITI 1
- KAZAKHSTAN 1
- MALAWI 1
- NETHERLANDS 1
- SAINT LUCIA 1
- SERBIA 1
- SWITZERLAND 1
- UNITED KINGDOM 1
Foreign_Principal_Registration_Date (date) 8 ✖
- 2012-04-26 3
- 2011-12-07 2
- 1997-04-24 1
- 2009-11-05 1
- 2011-09-19 1
- 2011-09-23 1
- 2012-04-11 1
- 2012-05-31 1
Registrant_Name 7
State 1
- - 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12206 | 12206 | 2012-09-30 | Bay Gardens Resorts | 2009-11-05 | SAINT LUCIA | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Reduit Beach, Rodney Bay Village, Gros Islet | P.O. Box 1892 | |||
12207 | 12207 | 2012-09-30 | Government of the Republic of Haiti | 2012-05-31 | HAITI | Corley, Walter 6106 | 2012-05-31 | Corley, Walter | 23 Ave Lamartiniere bois Verna, PAP Haiti | ||||
12209 | 12209 | 2012-09-30 | Horizontes, LTDA | 2012-04-26 | BRAZIL | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
12210 | 12210 | 2012-09-30 | Novartis, A.G. | 1997-04-24 | SWITZERLAND | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
12213 | 12213 | 2012-09-30 | Society of London Theatre | 2012-04-26 | UNITED KINGDOM | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
12214 | 12214 | 2012-09-30 | Stedelijk Museum Amsterdam | 2012-04-26 | NETHERLANDS | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
12215 | 12215 | 2012-09-30 | Tourism Ireland | 2011-12-07 | IRELAND | Squire Sanders Public Advocacy, LLC 6063 | 2011-09-16 | Squire Sanders Public Advocacy, LLC | |||||
12216 | 12216 | 2012-09-30 | Tourism Ireland | 2011-12-07 | IRELAND | Squire Sanders (US) LLP. 6073 | 2011-09-26 | Squire Sanders (US) LLP. | |||||
12212 | 12212 | 2012-09-30 | Republic of Serbia | 2011-09-23 | SERBIA | Roberti + White, LLC 6065 | 2011-09-23 | Roberti + White, LLC | Ministry of Foreign Affairs, Republic of Serbia | 24-26 Kneza Milosa St. | Belgrade | ||
12208 | 12208 | 2012-09-30 | Government of the Republic of Malawi through Whitaker Group Inc. | 2012-04-11 | MALAWI | Moffett Group, LLC 5802 | 2007-04-17 | Moffett Group, LLC | Private Bag 301 | Capital City | Lilongwe | ||
12211 | 12211 | 2012-09-30 | Republic of Kazakhstan through Windrush Ventures No. 3 LP through Windrush Ventures Limited through Portland PR Limited | 2011-09-19 | KAZAKHSTAN | Portland PR Inc. 6064 | 2011-09-19 | Portland PR Inc. | 1 Red Lion Court | London |
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]) );