FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Foreign_Principal_Termination_Date" is on date 2019-10-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registrant_Date, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 10
Registrant_Name 9
Country/Location_Represented 8
- JAPAN 2
- TUNISIA 2
- AUSTRALIA 1
- CHANNEL ISLANDS 1
- CHINA 1
- FIJI 1
- GERMANY 1
- GREAT BRITAIN 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13496 | 13496 | 2019-10-31 | Goethe-Institut e.V. through APCO Worldwide LLC | 2019-04-09 | GERMANY | Audience Partners Worldwide LLC 6657 | 2019-04-08 | Audience Partners Worldwide LLC | Dachauer Strafie 122 80637 | Munich | |||
13497 | 13497 | 2019-10-31 | Jersey Finance Limited | 2019-07-29 | CHANNEL ISLANDS | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 4th Floor, Sir Walter Raleigh House | 48-50 Esplanade, St. Helier Jersey JE2 3Qb | |||
13498 | 13498 | 2019-10-31 | Kobe Steel, Ltd. | 2017-11-28 | JAPAN | BCW LLC 6227 | 2014-06-18 | BCW LLC | 9-12, Kita - Shinagawa 5-chome | Shinagawa-ku Tokyo 141-8688 | |||
13499 | 13499 | 2019-10-31 | Minderoo Foundation Pty Ltd. | 2019-09-23 | AUSTRALIA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 80 Birdwood Parade | Dalkeith WA 6009 Australia | |||
13500 | 13500 | 2019-10-31 | Nabil Karoui | 2019-09-26 | TUNISIA | Dickens & Madson Canada Inc. 6200 | 2013-12-11 | Dickens & Madson Canada Inc. | |||||
13501 | 13501 | 2019-10-31 | Office of the Prime Minister of Japan | 2017-09-19 | JAPAN | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 2-3-1, Nagata-cho Chiyoda-ku, Tokyo | ||||
13502 | 13502 | 2019-10-31 | Olfa Terras-Rambourg | 2019-09-03 | TUNISIA | America to Africa Consulting, LLC (A2A) 6715 | 2019-09-03 | America to Africa Consulting, LLC (A2A) | 74 rue d'Assas | 75006 Paris FRANCE | |||
13503 | 13503 | 2019-10-31 | Republic of Fiji | 2018-11-02 | FIJI | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 9th Floor Suvavou House, Victoria Parade | PO Box 2212, Government Buildings Suva | |||
13504 | 13504 | 2019-10-31 | Urenco, Ltd. | 1996-11-08 | GREAT BRITAIN | Urenco, Inc. 5137 | 1996-11-08 | Urenco, Inc. | Buckinghamshire | ||||
13505 | 13505 | 2019-10-31 | Virgo Star, Inc. on behalf of CRRC North America, Inc. | 2019-07-18 | CHINA | Crossroads Strategies LLC 6702 | 2019-07-18 | Crossroads Strategies LLC | One Rockeller Plaza | Suite 2802 | New York | NY | 10020 |
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]) );