FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
31 rows where Registrant_Name = "O'Connor & Hannan, L.L.P." and State = "" sorted by Foreign_Principal_Termination_Date descending
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 >30
- Alfredo Cristiani 1
- Argentine Businessmen Delegation 1
- Argentine Meat Board 1
- Asociacion Nacional de la Empresa Privada de El Salvador 1
- Balfour Beatty, Ltd. 1
- Bombonas Venezolanas, C.A. 1
- CKLW Radio Broadcasting, Ltd. 1
- Camara Nacional de la Industria Pesquera (Canainpes) 1
- Connaught Laboratories, Inc. 1
- Excem, S.A. 1
- Government of Peru 1
- Government of St. Christopher-Nevis 1
- Government of the Netherlands/Antilles 1
- Government of the Phillipines 1
- Hotung Institute 1
- Hules Mexicanos, S.A. 1
- Industrias Negromex, S.A. de C.V. 1
- International Catholic Migration Commission 1
- Jamaican Broadcasting Corporation 1
- Joint Committee of Hong Kong Knitwear Associations 1
- Kawasaki Kisen Kaisha, Ltd. 1
- Mexican Cement Chamber of Commerce 1
- Morgan Grenfell Group, PLC 1
- National Republican Alliance of El Salvador (ARENA) 1
- Ontario Flue-Cured Tobacco Growers' Marketing Board 1
- SmithKline-Beecham Corporation 1
- Societe Franco-Belge de Materiel de Chemins de Fer 1
- Standard Chartered, PLC 1
- Taipei Economic & Cultural Representative Office (TECRO) 1
- United Kingdom Mutual Steam Ship Association (Bermuda), Ltd. 1
- …
Country/Location_Represented 18
- GREAT BRITAIN 5
- MEXICO 4
- CANADA 3
- EL SALVADOR 3
- ARGENTINA 2
- HONG KONG 2
- BERMUDA 1
- FRANCE 1
- JAMAICA 1
- JAPAN 1
- NETHERLANDS ANTILLES 1
- PERU 1
- PHILIPPINES 1
- SPAIN 1
- ST. KITTS AND NEVIS 1
- SWITZERLAND 1
- TAIWAN 1
- VENEZUELA 1
State 1
- - · 31 ✖
Registrant_Name 1
- O'Connor & Hannan, L.L.P. · 31 ✖
City 1
- - 31
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5990 | 5990 | 2001-04-30 | Government of the Netherlands/Antilles | 1987-03-19 | NETHERLANDS ANTILLES | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Fort Amsterdam | ||||
5998 | 5998 | 2001-04-30 | Taipei Economic & Cultural Representative Office (TECRO) | 1987-06-17 | TAIWAN | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | |||||
16279 | 16279 | 1995-12-31 | Ontario Flue-Cured Tobacco Growers' Marketing Board | 1993-11-18 | CANADA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Tillsonburg, Ontario | ||||
16297 | 16297 | 1995-12-31 | Camara Nacional de la Industria Pesquera (Canainpes) | 1994-03-22 | MEXICO | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | |||||
16335 | 16335 | 1995-12-31 | Hotung Institute | 1995-12-01 | HONG KONG | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Hong Kong | ||||
5585 | 5585 | 1995-04-25 | Government of Peru | 1992-09-29 | PERU | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Lima | ||||
5588 | 5588 | 1995-04-25 | Standard Chartered, PLC | 1994-04-01 | GREAT BRITAIN | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | London | ||||
14248 | 14248 | 1994-11-25 | Government of the Phillipines | 1993-07-27 | PHILIPPINES | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Washington, DC | ||||
6783 | 6783 | 1994-05-24 | International Catholic Migration Commission | 1993-11-24 | SWITZERLAND | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Geneva | ||||
4933 | 4933 | 1994-04-01 | Argentine Meat Board | 1978-10-25 | ARGENTINA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Buenos Aires | ||||
14246 | 14246 | 1992-11-25 | Morgan Grenfell Group, PLC | 1988-12-15 | GREAT BRITAIN | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | London | ||||
6715 | 6715 | 1992-05-22 | Argentine Businessmen Delegation | 1991-12-10 | ARGENTINA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Buenos Aires | ||||
8476 | 8476 | 1991-06-30 | Connaught Laboratories, Inc. | 1987-12-09 | CANADA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | |||||
8489 | 8489 | 1991-06-30 | SmithKline-Beecham Corporation | 1989-11-22 | GREAT BRITAIN | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Middlesax | ||||
924 | 924 | 1990-01-01 | Asociacion Nacional de la Empresa Privada de El Salvador | 1987-04-29 | EL SALVADOR | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | San Salvador | ||||
8435 | 8435 | 1989-06-30 | Alfredo Cristiani | 1989-04-27 | EL SALVADOR | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | San Salvador | ||||
5581 | 5581 | 1989-04-25 | Kawasaki Kisen Kaisha, Ltd. | 1986-02-06 | JAPAN | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Tokyo | ||||
4469 | 4469 | 1989-03-31 | National Republican Alliance of El Salvador (ARENA) | 1988-10-25 | EL SALVADOR | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | San Salvador | ||||
16069 | 16069 | 1988-12-31 | Mexican Cement Chamber of Commerce | 1983-11-21 | MEXICO | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | |||||
5578 | 5578 | 1987-04-25 | Hules Mexicanos, S.A. | 1983-11-21 | MEXICO | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | |||||
5579 | 5579 | 1987-04-25 | Industrias Negromex, S.A. de C.V. | 1983-11-21 | MEXICO | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | |||||
10519 | 10519 | 1985-08-15 | Balfour Beatty, Ltd. | 1984-04-27 | GREAT BRITAIN | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Surrey | ||||
10523 | 10523 | 1985-08-15 | Jamaican Broadcasting Corporation | 1983-04-08 | JAMAICA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Kingston | ||||
5823 | 5823 | 1985-04-30 | Joint Committee of Hong Kong Knitwear Associations | 1984-09-07 | HONG KONG | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Kowloon | ||||
11485 | 11485 | 1984-09-10 | CKLW Radio Broadcasting, Ltd. | 1980-08-08 | CANADA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Ontario | ||||
7391 | 7391 | 1984-06-01 | Excem, S.A. | 1983-11-10 | SPAIN | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Madrid | ||||
6554 | 6554 | 1983-05-15 | West of England Shipowners' Mutual Insurance Association, Ltd. | 1981-07-17 | GREAT BRITAIN | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | London | ||||
6555 | 6555 | 1983-05-15 | United Kingdom Mutual Steam Ship Association (Bermuda), Ltd. | 1981-07-07 | BERMUDA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Hamilton | ||||
13969 | 13969 | 1982-11-15 | Bombonas Venezolanas, C.A. | 1980-04-09 | VENEZUELA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Caracas | ||||
6853 | 6853 | 1982-05-26 | Societe Franco-Belge de Materiel de Chemins de Fer | 1978-11-06 | FRANCE | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Paris | ||||
12334 | 12334 | 1981-10-01 | Government of St. Christopher-Nevis | 1981-02-24 | ST. KITTS AND NEVIS | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | St. Kitts |
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]) );