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 1996-02-28 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 11
- Cervecerias del Baru 1
- Embassy of Morocco 1
- Federal Government of Nigeria 1
- Grenada Tourist Department 1
- Ministerio de Hacienda Republica de Venezuela 1
- Mitsui Planning Company, Ltd. 1
- NEC Corporation 1
- Netherlands Foreign Investment Agency 1
- RSC Energia (formerly: NPO Energia) 1
- Republic of Sierra Leone 1
- Russian Space Agency 1
Registrant_Name 10
Country/Location_Represented 9
- JAPAN 2
- RUSSIA 2
- GRENADA 1
- MOROCCO 1
- NETHERLANDS 1
- NIGERIA 1
- PANAMA 1
- SIERRA LEONE 1
- VENEZUELA 1
City 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3008 | 3008 | 1996-02-28 | Cervecerias del Baru | 1995-12-26 | PANAMA | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | Panama | ||||
3009 | 3009 | 1996-02-28 | Embassy of Morocco | 1995-02-16 | MOROCCO | Hurwitz & Abramson 4995 | 1995-02-16 | Hurwitz & Abramson | Washington | DC | |||
3010 | 3010 | 1996-02-28 | Federal Government of Nigeria | 1993-08-16 | NIGERIA | J.H.S. Group, Inc. 4941 | 1993-08-16 | J.H.S. Group, Inc. | Abuja | ||||
3011 | 3011 | 1996-02-28 | Grenada Tourist Department | 1982-08-27 | GRENADA | Karen Weiner Escalera Associates, Inc. 3405 | 1982-08-27 | Karen Weiner Escalera Associates, Inc. | |||||
3012 | 3012 | 1996-02-28 | Ministerio de Hacienda Republica de Venezuela | 1995-09-26 | VENEZUELA | Seigenthaler, Thomas P. 5053 | 1995-09-26 | Seigenthaler, Thomas P. | Caracas | ||||
3013 | 3013 | 1996-02-28 | Mitsui Planning Company, Ltd. | 1995-10-27 | JAPAN | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Joetsu-City, Niigata | ||||
3014 | 3014 | 1996-02-28 | NEC Corporation | 1987-05-20 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Tokyo | ||||
3015 | 3015 | 1996-02-28 | Netherlands Foreign Investment Agency | 1992-05-01 | NETHERLANDS | Mathews & Clark Communications 4659 | 1992-05-01 | Mathews & Clark Communications | New York | NY | |||
3016 | 3016 | 1996-02-28 | RSC Energia (formerly: NPO Energia) | 1992-02-20 | RUSSIA | Energia U.S.A., Inc. 4621 | 1992-02-20 | Energia U.S.A., Inc. | Moscow | ||||
3017 | 3017 | 1996-02-28 | Republic of Sierra Leone | 1994-12-27 | SIERRA LEONE | PSC International, Ltd. 4559 | 1991-08-28 | PSC International, Ltd. | Freetown | ||||
3018 | 3018 | 1996-02-28 | Russian Space Agency | 1995-04-11 | RUSSIA | Energia U.S.A., Inc. 4621 | 1992-02-20 | Energia U.S.A., Inc. | Moscow |
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]) );