FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Foreign_Principal_Termination_Date = "2017-10-31"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 12
- Myriad International Marketing, LLC 2
- Barnes & Thornburg, LLP 1
- Daniel J. Edelman, Inc. 1
- Gabriel Company, LLC 1
- Geoffrey Weill Associates 1
- Gonzalez, Jason Brent 1
- Gray Global Advisors, LLC 1
- Hills Stern & Morley, LLP 1
- LB International Solutions, LLC 1
- Moroccan-American Center for Policy, Inc. 1
- Nurnberger & Associates, Inc. 1
- Vision Americas, LLC 1
Foreign_Principal 12
- Moroccan American Center for Policy 2
- Bombardier Inc. 1
- Democratic Party of Albania 1
- Government of Aruba 1
- Government of Morocco 1
- Government of the Kingdom of Morocco 1
- Moroccan American Center for Policy through the Amani Group, LLC 1
- Portuguese National Tourist Office 1
- Republic of Turkey through Amsterdam & Partners, LLP 1
- Riad Fareed Alhijab Alhausen (of the High Negotiations Committee) 1
- Tourism Fiji 1
- Visit Denmark 1
Country/Location_Represented 9
City 6
- - 5
- Washington 4
- Los Angeles 1
- New York 1
- New York 1
- Oranjestad 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13476 | 13476 | 2017-10-31 | Bombardier Inc. | 2010-06-10 | CANADA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 800 Rene-Levesque Blvd. West | Montreal, Quebec H3B 1Y8 | |||
13477 | 13477 | 2017-10-31 | Democratic Party of Albania | 2017-04-14 | ALBANIA | Barnes & Thornburg, LLP 6417 | 2017-04-14 | Barnes & Thornburg, LLP | Bulevardi Zhan'dark 11 1000, Tirana | ||||
13478 | 13478 | 2017-10-31 | Government of Aruba | 2009-12-15 | ARUBA | Hills Stern & Morley, LLP 5965 | 2009-12-15 | Hills Stern & Morley, LLP | L.G. Smith Blvd. 76 | Oranjestad | |||
13479 | 13479 | 2017-10-31 | Government of Morocco | 2004-10-01 | MOROCCO | Moroccan-American Center for Policy, Inc. 5648 | 2004-10-01 | Moroccan-American Center for Policy, Inc. | Rabat | ||||
13480 | 13480 | 2017-10-31 | Government of the Kingdom of Morocco | 2002-10-11 | MOROCCO | Gabriel Company, LLC 5523 | 2002-10-11 | Gabriel Company, LLC | Rabat | ||||
13481 | 13481 | 2017-10-31 | Moroccan American Center for Policy through the Amani Group, LLC | 2009-03-06 | MOROCCO | Nurnberger & Associates, Inc. 5809 | 2007-05-11 | Nurnberger & Associates, Inc. | 1220 L Street, NW | Suite 411 | Washington | DC | 20005 |
13482 | 13482 | 2017-10-31 | Moroccan American Center for Policy | 2009-02-19 | MOROCCO | Vision Americas, LLC 5907 | 2009-02-19 | Vision Americas, LLC | 1220 L Street, NW | Suite 411 | Washington | DC | 20005 |
13483 | 13483 | 2017-10-31 | Moroccan American Center for Policy | 2014-02-26 | MOROCCO | Gray Global Advisors, LLC 5806 | 2007-05-07 | Gray Global Advisors, LLC | 1220 L Street, NW | Suite 411 | Washington | DC | 20005 |
13484 | 13484 | 2017-10-31 | Portuguese National Tourist Office | 2018-06-01 | PORTUGAL | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 866 Second Avenue, 8th Floor | New York | NY | 10017 | |
13485 | 13485 | 2017-10-31 | Republic of Turkey through Amsterdam & Partners, LLP | 2017-04-28 | TURKEY | Gonzalez, Jason Brent 6424 | 2017-04-28 | Gonzalez, Jason Brent | The Homer Building | 601 13th Street, NW 11th Floor South | Washington | DC | 20005 |
13486 | 13486 | 2017-10-31 | Riad Fareed Alhijab Alhausen (of the High Negotiations Committee) | 2017-12-21 | QATAR | LB International Solutions, LLC 6210 | 2014-03-03 | LB International Solutions, LLC | P.O. Box 91544 | ||||
13487 | 13487 | 2017-10-31 | Tourism Fiji | 2018-04-30 | FIJI | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 5777 Century Blvd, #220 | Los Angeles | CA | 90045 | |
13488 | 13488 | 2017-10-31 | Visit Denmark | 2017-04-21 | DENMARK | Geoffrey Weill Associates 6421 | 2017-04-21 | Geoffrey Weill Associates | 655 Third Avenue | Suite 810 | New York | NY | 10017 |
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]) );