FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
29 rows where Registration_Number = 3600 and State = ""
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 28
- Government of Nigeria 2
- ADCOM Group 1
- Aston Martin Lagonda, Ltd. 1
- Center for Democracy in Angola (CEDA) (formerly: UNITA) 1
- Chamber of Philippine Manufacturers', Exporters' & Tourism Association 1
- Comision Ejecutiva Hidroelectrica del Rio Lempa CEL 1
- Eitaro Itoyama 1
- Fiat Ferroviaria 1
- Government of Barbados 1
- Government of Bermuda 1
- Government of Kenya 1
- Government of Peru 1
- Government of Somalia 1
- Government of St. Lucia 1
- Government of Zaire 1
- Government of the Bahamas 1
- Government of the Republic of Togo 1
- Horsham Corporation 1
- Intercultural Association of Korea 1
- Korea Silo Company, Ltd. 1
- Luso American Foundation for International Relations 1
- Magal Security Systems, Ltd. 1
- National Convention for Reconstruction & Development 1
- News Corporation, Ltd. 1
- Nordion International 1
- Union for National Action 1
- Usarin Land Development Corporation 1
- Vittoria Consultants, Ltd. 1
Country/Location_Represented 24
- CANADA 2
- GREAT BRITAIN 2
- KOREA, SOUTH 2
- NIGERIA 2
- PHILIPPINES 2
- ANGOLA 1
- AUSTRALIA 1
- BAHAMAS 1
- BARBADOS 1
- BERMUDA 1
- EL SALVADOR 1
- ISLE OF MAN 1
- ISRAEL 1
- ITALY 1
- JAPAN 1
- KENYA 1
- LEBANON 1
- PERU 1
- PORTUGAL 1
- SAINT LUCIA 1
- SOMALI DEMOCRATIC REPUBLIC 1
- THAILAND 1
- TOGO 1
- ZAIRE 1
State 1
- - · 29 ✖
Registrant_Name 1
City 1
- - 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1287 | 1287 | 1993-01-14 | Horsham Corporation | 1992-05-26 | CANADA | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Ontario | ||||
1289 | 1289 | 1993-01-14 | Nordion International | 1992-05-18 | CANADA | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Ontario | ||||
1290 | 1290 | 1993-01-14 | Usarin Land Development Corporation | 1992-07-14 | THAILAND | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Bangkok | ||||
1723 | 1723 | 1987-01-31 | Korea Silo Company, Ltd. | 1986-11-19 | KOREA, SOUTH | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Inchon | ||||
1814 | 1814 | 1998-01-31 | Center for Democracy in Angola (CEDA) (formerly: UNITA) | 1985-10-16 | ANGOLA | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | |||||
2744 | 2744 | 1986-02-24 | Chamber of Philippine Manufacturers', Exporters' & Tourism Association | 1985-11-23 | PHILIPPINES | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Manila | ||||
2946 | 2946 | 1988-02-28 | ADCOM Group | 1987-08-05 | LEBANON | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Beirut | ||||
3003 | 3003 | 1995-02-28 | National Convention for Reconstruction & Development | 1994-10-04 | GREAT BRITAIN | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | London | ||||
3880 | 3880 | 1995-03-18 | Fiat Ferroviaria | 1994-11-08 | ITALY | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Savigliano | ||||
4505 | 4505 | 1991-03-31 | Government of Kenya | 1989-05-18 | KENYA | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Nairobi | ||||
5948 | 5948 | 1995-04-30 | Magal Security Systems, Ltd. | 1993-05-14 | ISRAEL | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | |||||
6512 | 6512 | 1985-05-13 | Government of Barbados | 1985-05-06 | BARBADOS | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Christ Church | ||||
6940 | 6940 | 1985-05-30 | News Corporation, Ltd. | 1984-06-14 | AUSTRALIA | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Sidney | ||||
7804 | 7804 | 1994-06-14 | Vittoria Consultants, Ltd. | 1993-10-07 | ISLE OF MAN | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Douglas | ||||
8406 | 8406 | 1986-06-30 | Government of Peru | 1985-09-16 | PERU | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Lima | ||||
8879 | 8879 | 1990-07-01 | Government of Somalia | 1988-06-14 | SOMALI DEMOCRATIC REPUBLIC | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | |||||
8961 | 8961 | 1987-07-02 | Intercultural Association of Korea | 1987-04-01 | KOREA, SOUTH | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Seoul | ||||
9244 | 9244 | 1994-07-14 | Government of Nigeria | 1989-12-20 | NIGERIA | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Lagos | ||||
9245 | 9245 | 1994-07-14 | Government of the Republic of Togo | 1993-08-02 | TOGO | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Lome, Togo | ||||
11252 | 11252 | 1986-09-01 | Government of the Bahamas | 1985-04-09 | BAHAMAS | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Nassau | ||||
12363 | 12363 | 1987-10-01 | Luso American Foundation for International Relations | 1987-04-03 | PORTUGAL | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Lisbon | ||||
13247 | 13247 | 1988-10-31 | Aston Martin Lagonda, Ltd. | 1987-07-16 | GREAT BRITAIN | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | |||||
13706 | 13706 | 1986-11-04 | Government of Nigeria | 1985-10-30 | NIGERIA | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | |||||
13846 | 13846 | 1989-11-09 | Union for National Action | 1989-02-07 | PHILIPPINES | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Manila | ||||
14369 | 14369 | 1986-11-30 | Government of Bermuda | 1986-08-20 | BERMUDA | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Hamilton | ||||
14714 | 14714 | 1999-12-01 | Comision Ejecutiva Hidroelectrica del Rio Lempa CEL | 1998-03-20 | EL SALVADOR | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | |||||
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 | ||||
15206 | 15206 | 1985-12-18 | Government of St. Lucia | 1985-05-06 | SAINT LUCIA | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Castries | ||||
16107 | 16107 | 1989-12-31 | Eitaro Itoyama | 1989-08-23 | JAPAN | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Kawangoe City |
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]) );