FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
23 rows where Address_1 = "Geneva"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 23
- African Millers' Association 1
- Agendas International, Inc. 1
- Arent, Fox, Kintner, Plotkin & Kahn 1
- Arter & Hadden, LLP 1
- Bogle & Gates 1
- Cronson, Donald 1
- Crowell & Moring International, LLC 1
- D.C. Association for Retarded Citizens (DCARC) 1
- European Free Trade Association 1
- Fox, James F. 1
- International Marketing Group 1
- JWI, LLC 1
- Jack H. McDonald Company 1
- James F. Fox, Inc. 1
- Kelly, Nason, Inc. 1
- MacCracken, Collins & Whitney 1
- O'Connor & Hannan, L.L.P. 1
- Patrice Tanaka & Company, Inc. 1
- Powell Tate, Inc. 1
- Powell, Goldstein, Frazer & Murphy, L.L.P. 1
- Smith & Harroff, Inc. 1
- TransSwiss Exports, Ltd. 1
- von Raab, William 1
Registrant_Date (date) 23 ✖
- 1942-07-30 1
- 1958-10-16 1
- 1961-03-13 1
- 1963-05-14 1
- 1969-08-27 1
- 1974-10-22 1
- 1976-04-13 1
- 1978-08-10 1
- 1978-10-25 1
- 1979-02-12 1
- 1981-09-10 1
- 1983-05-24 1
- 1983-09-30 1
- 1986-10-21 1
- 1987-04-01 1
- 1987-05-28 1
- 1987-06-29 1
- 1989-04-19 1
- 1991-06-04 1
- 1995-02-06 1
- 1995-06-26 1
- 1996-12-30 1
- 1997-03-11 1
Foreign_Principal 17
- Societe Generale de Surveillance, S.A. 6
- European Free Trade Association 2
- African Business Research Bureau LTD (ABRB) 1
- Association Francois-Xavier Bagnoud 1
- Compagnie Aramayo de Mines en Bolivie 1
- Departement de l'economie publique (Department of Economic Affairs) Republic and Canton of Geneva 1
- European Broadcasting Union 1
- IFACO, S.A. 1
- International Catholic Migration Commission 1
- International Trade Center UNCTAD/GATT 1
- Investors Overseas Services, Ltd. 1
- Lombard, Odier & Cie 1
- Perret & Berthoud, S.A. 1
- Societe Generale de Surveillance (SGS) 1
- Swiss World Airways 1
- United Nations Conference on Trade & Development (UNCTAD) 1
- Valeurs White Weld, S.A. 1
Country/Location_Represented 2
- SWITZERLAND 21
- INTERNATIONAL 2
State 1
- - 23
City 1
- - 23
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
951 | 951 | 1992-01-01 | Societe Generale de Surveillance, S.A. | 1991-06-12 | SWITZERLAND | von Raab, William 4538 | 1991-06-04 | von Raab, William | Geneva | ||||
1697 | 1697 | 1973-01-31 | European Free Trade Association | 1961-03-13 | SWITZERLAND | European Free Trade Association 1434 | 1961-03-13 | European Free Trade Association | Geneva | ||||
3447 | 3447 | 2004-03-04 | African Business Research Bureau LTD (ABRB) | 2002-08-12 | INTERNATIONAL | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | Geneva | ||||
3499 | 3499 | 1979-03-07 | Lombard, Odier & Cie | 1979-02-12 | SWITZERLAND | Fox, James F. 2997 | 1979-02-12 | Fox, James F. | Geneva | ||||
3525 | 3525 | 1993-03-08 | IFACO, S.A. | 1989-04-19 | SWITZERLAND | African Millers' Association 4240 | 1989-04-19 | African Millers' Association | Geneva | ||||
4926 | 4926 | 1990-04-01 | Societe Generale de Surveillance, S.A. | 1987-04-01 | SWITZERLAND | Jack H. McDonald Company 3956 | 1987-04-01 | Jack H. McDonald Company | Geneva | ||||
5167 | 5167 | 1990-04-11 | Societe Generale de Surveillance, S.A. | 1987-04-03 | SWITZERLAND | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Geneva | ||||
6440 | 6440 | 2000-05-10 | Departement de l'economie publique (Department of Economic Affairs) Republic and Canton of Geneva | 1996-07-18 | SWITZERLAND | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | Geneva | ||||
6762 | 6762 | 1977-05-24 | European Free Trade Association | 1976-04-13 | SWITZERLAND | D.C. Association for Retarded Citizens (DCARC) 2683 | 1976-04-13 | D.C. Association for Retarded Citizens (DCARC) | Geneva | ||||
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 | ||||
8164 | 8164 | 1988-06-29 | Societe Generale de Surveillance, S.A. | 1987-06-29 | SWITZERLAND | Smith & Harroff, Inc. 4000 | 1987-06-29 | Smith & Harroff, Inc. | Geneva | ||||
8829 | 8829 | 1967-07-01 | European Broadcasting Union | 1965-12-27 | SWITZERLAND | Arent, Fox, Kintner, Plotkin & Kahn 1628 | 1963-05-14 | Arent, Fox, Kintner, Plotkin & Kahn | Geneva | ||||
9690 | 9690 | 1964-07-31 | Perret & Berthoud, S.A. | 1955-03-31 | SWITZERLAND | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Geneva | ||||
10252 | 10252 | 1979-08-10 | Valeurs White Weld, S.A. | 1978-08-10 | SWITZERLAND | Cronson, Donald 2943 | 1978-08-10 | Cronson, Donald | Geneva | ||||
10838 | 10838 | 1984-08-30 | International Trade Center UNCTAD/GATT | 1978-11-01 | SWITZERLAND | International Marketing Group 2540 | 1974-10-22 | International Marketing Group | Geneva | ||||
11795 | 11795 | 1970-09-24 | Investors Overseas Services, Ltd. | 1969-08-27 | SWITZERLAND | James F. Fox, Inc. 2160 | 1969-08-27 | James F. Fox, Inc. | Geneva | ||||
12098 | 12098 | 1998-09-30 | Swiss World Airways | 1998-11-16 | SWITZERLAND | Patrice Tanaka & Company, Inc. 5162 | 1997-03-11 | Patrice Tanaka & Company, Inc. | Geneva | ||||
14267 | 14267 | 1959-11-27 | Compagnie Aramayo de Mines en Bolivie | 1958-10-16 | SWITZERLAND | MacCracken, Collins & Whitney 1181 | 1958-10-16 | MacCracken, Collins & Whitney | Geneva | ||||
14307 | 14307 | 1990-11-29 | United Nations Conference on Trade & Development (UNCTAD) | 1988-07-26 | INTERNATIONAL | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Geneva | ||||
16023 | 16023 | 1987-12-31 | Societe Generale de Surveillance, S.A. | 1986-10-21 | SWITZERLAND | TransSwiss Exports, Ltd. 3899 | 1986-10-21 | TransSwiss Exports, Ltd. | Geneva | ||||
16078 | 16078 | 1988-12-31 | Societe Generale de Surveillance, S.A. | 1987-04-24 | SWITZERLAND | Bogle & Gates 3474 | 1983-05-24 | Bogle & Gates | Geneva | ||||
16251 | 16251 | 1994-12-31 | Association Francois-Xavier Bagnoud | 1990-10-31 | SWITZERLAND | Agendas International, Inc. 3524 | 1983-09-30 | Agendas International, Inc. | Geneva | ||||
16445 | 16445 | 1998-12-31 | Societe Generale de Surveillance (SGS) | 1997-12-08 | SWITZERLAND | Powell Tate, Inc. 5148 | 1996-12-30 | Powell Tate, Inc. | Geneva |
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]) );