FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where Address_1 = "Kinshasa"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 18
- Angola Office 1
- Baker & McKenzie 1
- Beckerman 1
- Black, Kelly, Scruggs & Healey 1
- Cohen & Woods International, Inc. 1
- Duncan, Allen & Talmage 1
- EAW Group, Inc. 1
- El-Assad, Nael 1
- LeBoeuf, Lamb, Leiby & MacRae 1
- Long, KaLeigh 1
- Maheu, Robert A. 1
- Mer Security and Communication Systems Ltd. 1
- Milbank, Tweed, Hadley & McCloy 1
- Parti Lumumbiste Unifie (PALU) 1
- SABENA Belgian World Airlines 1
- Southfive Strategies, LLC 1
- Washington World Group, Ltd. 1
- Weaver International Corporation 1
Registrant_Date (date) 18 ✖
- 1965-01-11 1
- 1969-11-10 1
- 1971-10-04 1
- 1983-07-25 1
- 1984-06-14 1
- 1985-05-08 1
- 1986-12-18 1
- 1986-12-19 1
- 1987-12-04 1
- 1995-03-10 1
- 1995-04-20 1
- 1995-09-19 1
- 1998-10-15 1
- 2008-08-14 1
- 2017-04-28 1
- 2017-05-04 1
- 2019-06-26 1
- 2020-05-08 1
Foreign_Principal 13
- Republic of Zaire 5
- Democratic Republic of the Congo 2
- Angola Government In Exile (G.R.A.E.) 1
- Democratic Republic of the Congo, through Mer Security and Communications Systems Ltd. 1
- Department of Environment Conservation of Nature & Tourism 1
- Government of Zaire 1
- Government of the Democratic Republic of Congo 1
- Government of the Democratic Republic of Congo through Mer Security and Communication Systems Ltd. 1
- Government of the Republic of Zaire 1
- Office of the President of the Republic of Zaire 1
- Parti Lumumbiste Unifie (PALU) 1
- The Government of the Democratic Republic of Congo 1
- Tryphon Kin-Kiey Mulumba 1
Country/Location_Represented 4
State 1
- - 18
City 1
- - 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
693 | 693 | The Government of the Democratic Republic of Congo | 2020-05-08 | CONGO, DEMOCRATIC REPUBLIC OF THE | Baker & McKenzie 6821 | 2020-05-08 | Baker & McKenzie | Kinshasa | |||||
1649 | 1649 | 2001-01-30 | Democratic Republic of the Congo | 1998-11-18 | CONGO, REPUBLIC OF THE | EAW Group, Inc. 5284 | 1998-10-15 | EAW Group, Inc. | Kinshasa | ||||
2932 | 2932 | 1982-02-28 | Republic of Zaire | 1974-02-20 | ZAIRE | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Kinshasa | ||||
4593 | 4593 | 2001-03-31 | Democratic Republic of the Congo | 1999-02-11 | CONGO, REPUBLIC OF THE | Cohen & Woods International, Inc. 5003 | 1995-03-10 | Cohen & Woods International, Inc. | Kinshasa | ||||
5301 | 5301 | 1997-04-15 | Office of the President of the Republic of Zaire | 1996-12-18 | ZAIRE | Washington World Group, Ltd. 5016 | 1995-04-20 | Washington World Group, Ltd. | Kinshasa | ||||
5832 | 5832 | 1987-04-30 | Republic of Zaire | 1987-12-04 | ZAIRE | El-Assad, Nael 4068 | 1987-12-04 | El-Assad, Nael | Kinshasa | ||||
7636 | 7636 | 1986-06-06 | Republic of Zaire | 1986-06-27 | ZAIRE | Duncan, Allen & Talmage 3503 | 1983-07-25 | Duncan, Allen & Talmage | Kinshasa | ||||
9090 | 9090 | 1987-07-08 | Republic of Zaire | 1986-12-19 | ZAIRE | Maheu, Robert A. 3920 | 1986-12-19 | Maheu, Robert A. | Kinshasa | ||||
9920 | 9920 | 2018-07-31 | Democratic Republic of the Congo, through Mer Security and Communications Systems Ltd. | 2017-12-12 | CONGO, REPUBLIC OF THE | Beckerman 5877 | 2008-08-14 | Beckerman | Kinshasa | ||||
9922 | 9922 | 2018-07-31 | Government of the Democratic Republic of Congo through Mer Security and Communication Systems Ltd. | 2017-05-04 | CONGO, REPUBLIC OF THE | Southfive Strategies, LLC 6426 | 2017-05-04 | Southfive Strategies, LLC | Kinshasa | ||||
9961 | 9961 | 1973-08-01 | Angola Government In Exile (G.R.A.E.) | 1971-10-04 | ANGOLA | Angola Office 2282 | 1971-10-04 | Angola Office | Kinshasa | ||||
11465 | 11465 | 1977-09-09 | Republic of Zaire | 1975-12-02 | ZAIRE | LeBoeuf, Lamb, Leiby & MacRae 2169 | 1969-11-10 | LeBoeuf, Lamb, Leiby & MacRae | Kinshasa | ||||
11724 | 11724 | 1995-09-19 | Parti Lumumbiste Unifie (PALU) | 1995-09-19 | ZAIRE | Parti Lumumbiste Unifie (PALU) 5052 | 1995-09-19 | Parti Lumumbiste Unifie (PALU) | Kinshasa | ||||
11995 | 11995 | 1988-09-30 | Government of the Republic of Zaire | 1986-12-18 | ZAIRE | Weaver International Corporation 3916 | 1986-12-18 | Weaver International Corporation | Kinshasa | ||||
14911 | 14911 | 1987-12-09 | Department of Environment Conservation of Nature & Tourism | 1985-05-08 | ZAIRE | SABENA Belgian World Airlines 3679 | 1985-05-08 | SABENA Belgian World Airlines | Kinshasa | ||||
15104 | 15104 | 1990-12-14 | Government of Zaire | 1989-07-13 | ZAIRE | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Kinshasa | ||||
16828 | 16828 | 2018-12-31 | Government of the Democratic Republic of Congo | 2017-04-28 | CONGO, REPUBLIC OF THE | Mer Security and Communication Systems Ltd. 6423 | 2017-04-28 | Mer Security and Communication Systems Ltd. | Kinshasa | ||||
16864 | 16864 | 2019-12-31 | Tryphon Kin-Kiey Mulumba | 2019-06-26 | CONGO, REPUBLIC OF THE | Long, KaLeigh 6695 | 2019-06-26 | Long, KaLeigh | Kinshasa |
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]) );