FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where "Foreign_Principal_Termination_Date" is on date 1999-12-31 and State = "DC" sorted by State
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_1, Foreign_Principal_Registration_Date (date)
Foreign_Principal 8
- Government of Guatemala, Embassy 1
- Government of Iceland, Embassy 1
- Government of Portugal, Embassy 1
- Government of Switzerland, Embassy 1
- Government of the Republic of Bolivia, Bolivian Mission to the OAS 1
- People's Republic of Mozambique, Embassy 1
- Republic of the Fiji Islands 1
- Taipei Economic and Cultural Representative Office in the United States (TECRO) 1
Country/Location_Represented 8
- BOLIVIA 1
- FIJI 1
- GUATEMALA 1
- ICELAND 1
- MOZAMBIQUE 1
- PORTUGAL 1
- SWITZERLAND 1
- TAIWAN 1
Registrant_Name 7
State 1
- DC · 8 ✖
City 1
- - 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16449 | 16449 | 1999-12-31 | People's Republic of Mozambique, Embassy | 1987-10-13 | MOZAMBIQUE | Cameron, Bruce P. 4043 | 1987-09-28 | Cameron, Bruce P. | Washington | DC | |||
16457 | 16457 | 1999-12-31 | Government of Guatemala, Embassy | 1999-07-29 | GUATEMALA | Williams & Connolly 5323 | 1999-07-29 | Williams & Connolly | 220 R Street, N.W. | DC | |||
16458 | 16458 | 1999-12-31 | Government of Iceland, Embassy | 1997-12-18 | ICELAND | Hall, Thomas Forrest 5221 | 1997-12-18 | Hall, Thomas Forrest | Washington | DC | |||
16459 | 16459 | 1999-12-31 | Government of Portugal, Embassy | 1997-02-18 | PORTUGAL | Cameron, Bruce P. 4043 | 1987-09-28 | Cameron, Bruce P. | Washington | DC | |||
16460 | 16460 | 1999-12-31 | Government of Switzerland, Embassy | 1996-12-19 | SWITZERLAND | Barbour Griffith & Rogers 5146 | 1996-12-19 | Barbour Griffith & Rogers | Washington | DC | |||
16461 | 16461 | 1999-12-31 | Government of the Republic of Bolivia, Bolivian Mission to the OAS | 2000-06-22 | BOLIVIA | Manatt, Phelps & Phillips 5171 | 1997-04-11 | Manatt, Phelps & Phillips | 1819 H Street, N.W., Suite 410 | DC | |||
16470 | 16470 | 1999-12-31 | Republic of the Fiji Islands | 1999-05-17 | FIJI | Sandler, Travis & Rosenberg, P.A. 5303 | 1998-12-07 | Sandler, Travis & Rosenberg, P.A. | Washington | DC | |||
16474 | 16474 | 1999-12-31 | Taipei Economic and Cultural Representative Office in the United States (TECRO) | 1999-01-28 | TAIWAN | Lonie, David Morrison 5298 | 1999-01-28 | Lonie, David Morrison | Washington | DC |
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]) );