FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40 rows where "Foreign_Principal_Termination_Date" is on date 1991-12-31
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date (date)
Registrant_Name >30
- Burson-Marsteller 3
- Manchester Trade, Inc. 3
- Doremus, Porter & Novelli 2
- Hori & Bunker, Inc. 2
- Jones Day 2
- Rivkin, Radler, Bayh, Hart & Kremer 2
- Squire Patton Boggs, LLP 2
- Allan L. Forbes, Inc. 1
- Burchinow, Djab Naminow 1
- CHACMA, Inc. 1
- Cliff Madison Government Relations, Inc. 1
- Collier Shannon Scott, PLLC 1
- Edward Aycoth & Company, Inc. 1
- Frankl, Wolfe J. 1
- Graham & James, L.L.P. 1
- Interface Public Affairs 1
- International Public Relations Company, Ltd. 1
- Lord Group 1
- Major, Barbara Ann 1
- Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. 1
- New Zealand Tourist & Publicity Office 1
- Nieburg, Patrick E. 1
- Padilla, Speer, Burdick & Beardsley, Inc. 1
- Reichler & Soble 1
- Ruder Finn, Inc. 1
- Schmertz Company, Inc. 1
- Skadden, Arps, Slate, Meagher & Flom, L.L.P. 1
- Styles, Deborah M. 1
- Weill & Paxton 1
- Windels, Marx, Davies & Ives 1
- …
Registrant_Date (date) >30 ✖
- 1973-10-23 3
- 1988-06-22 3
- 1969-10-09 2
- 1982-12-10 2
- 1987-08-27 2
- 1989-07-17 2
- 1991-05-08 2
- 1961-09-27 1
- 1966-03-14 1
- 1972-03-27 1
- 1977-08-19 1
- 1979-07-23 1
- 1980-12-01 1
- 1981-09-23 1
- 1984-05-09 1
- 1985-06-24 1
- 1985-07-24 1
- 1987-01-07 1
- 1987-04-15 1
- 1987-08-03 1
- 1987-11-19 1
- 1988-07-26 1
- 1989-08-11 1
- 1990-05-23 1
- 1990-06-06 1
- 1990-10-15 1
- 1990-11-14 1
- 1991-01-22 1
- 1991-02-05 1
- 1991-07-29 1
- …
Foreign_Principal >30
- Aerospatiale 1
- Akademie fur Fuhrungskrafte der Deutschen Bundespost 1
- Alto Carbona 1
- Baja Norte Board of Tourism 1
- Banco Central de Nicaragua 1
- Berlin Economic Development Corporation 1
- Chiyoda Chemical, Engineering & Construction Company, Ltd. 1
- Elbow Beach Hotel 1
- Embassy of Norway 1
- Embassy of Russia 1
- Embassy of the Republic of Bulgaria 1
- Federal Republic of Nigeria 1
- Government of Iceland 1
- Government of the Republic of Greece 1
- Government of the Republic of the Marshall Islands 1
- Hachette U.S.A., Inc. 1
- ICN Galenika 1
- Information Department Embassy of the U.S.S.R. 1
- Information Office, Embassy of the Republic of Korea 1
- International Association of Independent Tanker Owners (Intertanko) 1
- Jugopetrol 1
- Korean Foreign Trade Association 1
- Malaysian Palm Oil Promotion Council 1
- Ministry of Fisheries, Government of Mexico 1
- Minpeco, S.A. 1
- Mongolian People's Republic, Ministry of Trade & Industry 1
- New Zealand Government Tourist Office 1
- Novo Industri, A.S. 1
- Overseas Telecommunications Commission 1
- Qantas Airways, Ltd. 1
- …
Country/Location_Represented 29
- MEXICO 4
- AUSTRALIA 2
- FRANCE 2
- GERMANY 2
- GREAT BRITAIN 2
- JAPAN 2
- KOREA, SOUTH 2
- USSR 2
- YUGOSLAVIA 2
- BERMUDA 1
- BULGARIA 1
- DENMARK 1
- GREECE 1
- GUATEMALA 1
- ICELAND 1
- INTERNATIONAL 1
- KUWAIT 1
- MALAYSIA 1
- MARSHALL ISLANDS 1
- MONGOLIA 1
- NAMIBIA 1
- NEW ZEALAND 1
- NICARAGUA 1
- NIGERIA 1
- NORWAY 1
- PERU 1
- RUSSIA 1
- SAUDI ARABIA 1
- SWITZERLAND 1
Address_1 28 ✖
- - 5
- Washington 5
- Houston 2
- London 2
- Sydney 2
- Tokyo 2
- Batajnicki Drumm 1
- Belgrade 1
- Bundespost 1
- Kuala Lumpur 1
- Lagos 1
- Lima 1
- Majuro 1
- Managua 1
- Moscow 1
- New York 1
- Oslo 1
- Piso 1
- Queretaro 1
- Reykjavik 1
- Schaumburg 1
- Seoul 1
- Tijuana 1
- Ulan Bator 1
- Wellington 1
- West Yorkshire 1
- Windhoek 1
- washington 1
City 1
- - 40
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16186 | 16186 | 1991-12-31 | Mongolian People's Republic, Ministry of Trade & Industry | 1991-02-05 | MONGOLIA | Burchinow, Djab Naminow 4468 | 1991-02-05 | Burchinow, Djab Naminow | Ulan Bator | ||||
16187 | 16187 | 1991-12-31 | Aerospatiale | 1991-10-12 | FRANCE | International Public Relations Company, Ltd. 1967 | 1966-03-14 | International Public Relations Company, Ltd. | NY | ||||
16188 | 16188 | 1991-12-31 | Akademie fur Fuhrungskrafte der Deutschen Bundespost | 1987-08-27 | GERMANY | Doremus, Porter & Novelli 4031 | 1987-08-27 | Doremus, Porter & Novelli | Bundespost | ||||
16189 | 16189 | 1991-12-31 | Alto Carbona | 1990-08-16 | MEXICO | Manchester Trade, Inc. 4149 | 1988-06-22 | Manchester Trade, Inc. | Queretaro | ||||
16190 | 16190 | 1991-12-31 | Baja Norte Board of Tourism | 1991-08-14 | MEXICO | Lord Group 4556 | 1991-08-14 | Lord Group | Tijuana | ||||
16191 | 16191 | 1991-12-31 | Banco Central de Nicaragua | 1991-03-08 | NICARAGUA | CHACMA, Inc. 4020 | 1987-08-03 | CHACMA, Inc. | Managua | ||||
16192 | 16192 | 1991-12-31 | Berlin Economic Development Corporation | 1980-12-01 | GERMANY | Frankl, Wolfe J. 3173 | 1980-12-01 | Frankl, Wolfe J. | |||||
16193 | 16193 | 1991-12-31 | Chiyoda Chemical, Engineering & Construction Company, Ltd. | 1989-07-17 | JAPAN | Hori & Bunker, Inc. 4272 | 1989-07-17 | Hori & Bunker, Inc. | Tokyo | ||||
16194 | 16194 | 1991-12-31 | Elbow Beach Hotel | 1986-03-01 | BERMUDA | Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. 3043 | 1979-07-23 | Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. | |||||
16195 | 16195 | 1991-12-31 | Embassy of Norway | 1989-10-02 | NORWAY | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Washington | DC | |||
16196 | 16196 | 1991-12-31 | Embassy of Russia | 1977-08-19 | RUSSIA | Major, Barbara Ann 2824 | 1977-08-19 | Major, Barbara Ann | Washington | DC | |||
16197 | 16197 | 1991-12-31 | Embassy of the Republic of Bulgaria | 1991-01-22 | BULGARIA | Windels, Marx, Davies & Ives 4466 | 1991-01-22 | Windels, Marx, Davies & Ives | Washington | DC | |||
16198 | 16198 | 1991-12-31 | Federal Republic of Nigeria | 1990-11-14 | NIGERIA | Edward Aycoth & Company, Inc. 4436 | 1990-11-14 | Edward Aycoth & Company, Inc. | Lagos | ||||
16199 | 16199 | 1991-12-31 | Government of Iceland | 1986-09-09 | ICELAND | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Reykjavik | ||||
16200 | 16200 | 1991-12-31 | Government of the Republic of Greece | 1991-07-08 | GREECE | Schmertz Company, Inc. 4161 | 1988-07-26 | Schmertz Company, Inc. | Washington | DC | |||
16201 | 16201 | 1991-12-31 | Government of the Republic of the Marshall Islands | 1987-11-16 | MARSHALL ISLANDS | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Majuro | ||||
16202 | 16202 | 1991-12-31 | Hachette U.S.A., Inc. | 1991-04-01 | FRANCE | Jones Day 3427 | 1982-12-10 | Jones Day | New York | NY | |||
16203 | 16203 | 1991-12-31 | ICN Galenika | 1991-05-08 | YUGOSLAVIA | Rivkin, Radler, Bayh, Hart & Kremer 4510 | 1991-05-08 | Rivkin, Radler, Bayh, Hart & Kremer | Batajnicki Drumm | ||||
16204 | 16204 | 1991-12-31 | Information Department Embassy of the U.S.S.R. | 1987-01-07 | USSR | Styles, Deborah M. 3924 | 1987-01-07 | Styles, Deborah M. | washington | DC | |||
16205 | 16205 | 1991-12-31 | Information Office, Embassy of the Republic of Korea | 1990-05-23 | KOREA, SOUTH | Nieburg, Patrick E. 4378 | 1990-05-23 | Nieburg, Patrick E. | Washington | DC | |||
16206 | 16206 | 1991-12-31 | International Association of Independent Tanker Owners (Intertanko) | 1982-11-08 | INTERNATIONAL | Graham & James, L.L.P. 3275 | 1981-09-23 | Graham & James, L.L.P. | Oslo | ||||
16207 | 16207 | 1991-12-31 | Jugopetrol | 1991-10-25 | YUGOSLAVIA | Rivkin, Radler, Bayh, Hart & Kremer 4510 | 1991-05-08 | Rivkin, Radler, Bayh, Hart & Kremer | Belgrade | ||||
16208 | 16208 | 1991-12-31 | Korean Foreign Trade Association | 1988-06-22 | KOREA, SOUTH | Manchester Trade, Inc. 4149 | 1988-06-22 | Manchester Trade, Inc. | Seoul | ||||
16209 | 16209 | 1991-12-31 | Malaysian Palm Oil Promotion Council | 1990-06-06 | MALAYSIA | Allan L. Forbes, Inc. 4380 | 1990-06-06 | Allan L. Forbes, Inc. | Kuala Lumpur | ||||
16210 | 16210 | 1991-12-31 | Ministry of Fisheries, Government of Mexico | 1990-08-30 | MEXICO | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Piso | ||||
16211 | 16211 | 1991-12-31 | Minpeco, S.A. | 1988-01-21 | PERU | Doremus, Porter & Novelli 4031 | 1987-08-27 | Doremus, Porter & Novelli | Lima | ||||
16212 | 16212 | 1991-12-31 | New Zealand Government Tourist Office | 1972-03-27 | NEW ZEALAND | New Zealand Tourist & Publicity Office 2328 | 1972-03-27 | New Zealand Tourist & Publicity Office | Wellington | ||||
16213 | 16213 | 1991-12-31 | Novo Industri, A.S. | 1987-08-10 | DENMARK | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
16214 | 16214 | 1991-12-31 | Overseas Telecommunications Commission | 1987-04-15 | AUSTRALIA | Padilla, Speer, Burdick & Beardsley, Inc. 3959 | 1987-04-15 | Padilla, Speer, Burdick & Beardsley, Inc. | Sydney | ||||
16215 | 16215 | 1991-12-31 | Qantas Airways, Ltd. | 1987-11-19 | AUSTRALIA | Cliff Madison Government Relations, Inc. 4060 | 1987-11-19 | Cliff Madison Government Relations, Inc. | Sydney | ||||
16216 | 16216 | 1991-12-31 | Republic of Guatemala | 1987-02-27 | GUATEMALA | Reichler & Soble 3582 | 1984-05-09 | Reichler & Soble | |||||
16217 | 16217 | 1991-12-31 | Rossing Uranium, Ltd. | 1990-10-15 | NAMIBIA | Interface Public Affairs 4426 | 1990-10-15 | Interface Public Affairs | Windhoek | ||||
16218 | 16218 | 1991-12-31 | Saudi Refining, Inc. | 1988-06-30 | SAUDI ARABIA | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Houston | TX | |||
16219 | 16219 | 1991-12-31 | Sheikha Hussah Sabah al-Salem al-Sabah & Sheikh Nasser Sabah al-Ahmed al-Sabah | 1990-10-19 | KUWAIT | Jones Day 3427 | 1982-12-10 | Jones Day | London | ||||
16220 | 16220 | 1991-12-31 | Sidermex International | 1988-06-22 | MEXICO | Manchester Trade, Inc. 4149 | 1988-06-22 | Manchester Trade, Inc. | Houston | TX | |||
16221 | 16221 | 1991-12-31 | Tungsten Carbide Products | 1989-08-11 | GREAT BRITAIN | Weill & Paxton 4280 | 1989-08-11 | Weill & Paxton | London | ||||
16222 | 16222 | 1991-12-31 | Union of Soviet Socialist Republics | 1991-07-29 | USSR | Skadden, Arps, Slate, Meagher & Flom, L.L.P. 4550 | 1991-07-29 | Skadden, Arps, Slate, Meagher & Flom, L.L.P. | Moscow | ||||
16223 | 16223 | 1991-12-31 | World Vision Travel Company, Ltd. | 1989-09-07 | JAPAN | Hori & Bunker, Inc. 4272 | 1989-07-17 | Hori & Bunker, Inc. | Tokyo | ||||
16224 | 16224 | 1991-12-31 | Yorkshire & Humberside Development Association | 1985-07-24 | GREAT BRITAIN | Yorkshire & Humberside Development Association, California 3706 | 1985-07-24 | Yorkshire & Humberside Development Association, California | West Yorkshire | ||||
16225 | 16225 | 1991-12-31 | Zurich Insurance Company | 1990-03-20 | SWITZERLAND | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | Schaumburg | IL |
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]) );