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 2008-04-30 sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 10
- Embassy of Colombia 1
- Forza Italia 1
- Government of Iceland 1
- Government of Turkey, Embassy 1
- Korea Trade-Investment Promotion Agency 1
- Lebanese Option Gathering 1
- Shanfari Group of Companies 1
- State of Qatar, Ministry of Foreign Affairs 1
- Stolt-Nielsen S.A. 1
- Taipei Economic and Cultural Representative Office 1
Country/Location_Represented 10
- COLOMBIA 1
- GREAT BRITAIN 1
- ICELAND 1
- ITALY 1
- KOREA, SOUTH 1
- LEBANON 1
- OMAN 1
- QATAR 1
- TAIWAN 1
- TURKEY 1
Registrant_Name 9
City 5
- - 4
- Washington 3
- Doha 1
- London 1
- New York 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6037 | 6037 | 2008-04-30 | Embassy of Colombia | 2007-05-03 | COLOMBIA | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 2118 Leroy Place, NW | Washington | DC | 20008 | |
6039 | 6039 | 2008-04-30 | Government of Iceland | 1993-01-15 | ICELAND | Kronmiller, Theodore George 4649 | 1992-04-17 | Kronmiller, Theodore George | Reykjavik | ||||
6041 | 6041 | 2008-04-30 | Korea Trade-Investment Promotion Agency | 2008-04-07 | KOREA, SOUTH | KWR International, Inc. 5119 | 1996-07-02 | KWR International, Inc. | 460 Park Avenue | New York | NY | 10023 | |
6042 | 6042 | 2008-04-30 | Lebanese Option Gathering | 2008-04-15 | LEBANON | Smith & Harroff, Inc. 5862 | 2008-04-15 | Smith & Harroff, Inc. | No Principal Address (See www.intiMAA.org) | ||||
6043 | 6043 | 2008-04-30 | Shanfari Group of Companies | 2004-12-22 | OMAN | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | P.O. Box 783 Muscat Postal Code 113 | ||||
6046 | 6046 | 2008-04-30 | Taipei Economic and Cultural Representative Office | 2008-02-25 | TAIWAN | C&M Capitolink, LLC 5858 | 2008-01-22 | C&M Capitolink, LLC | 4201 Wisconsin Avenue, Nw | Washington | DC | 20016 | |
6038 | 6038 | 2008-04-30 | Forza Italia | 2006-05-03 | ITALY | Ferrigno, Salvatore 5750 | 2006-05-03 | Ferrigno, Salvatore | Via Dell'Umilta, 36 | 00187 Roma | |||
6040 | 6040 | 2008-04-30 | Government of Turkey, Embassy | 2007-10-17 | TURKEY | Liss, Norman 5832 | 2007-10-17 | Liss, Norman | Turkish Embassy | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 |
6045 | 6045 | 2008-04-30 | Stolt-Nielsen S.A. | 2006-08-22 | GREAT BRITAIN | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | Aldwych House | 71 - 91 Aldwych | London | ||
6044 | 6044 | 2008-04-30 | State of Qatar, Ministry of Foreign Affairs | 2011-07-27 | QATAR | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | Mr. Sa'ad M. Al Rumaihi | P.O. Box 4925 | Doha |
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]) );