FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where Foreign_Principal_Termination_Date = "2001-12-31"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 21
- CACTAC - Central American and Caribbean Textile and Apparel Council 1
- Cayman Islands Government 1
- Commercial Office of the Embassy of the People's Republic of China in Washington 1
- Embassy of Korea 1
- Embassy of the Republic of Korea 1
- Government of Haiti 1
- Government of Eritrea, Embassy 1
- Government of Kazakhstan 1
- Invest in Finland Bureau 1
- Korea Telecom 1
- Messier-Dowty International 1
- Mexico City Tourism Authority (Fondo Mixto de Promocion Turistica de la Ciudad de Mexico) 1
- Neuchatel Government Canton of Neuchatel, Switzerland 1
- Nissho-Iwai Corporation 1
- Republic of Benin 1
- Republic of Guyana 1
- Republic of Haiti 1
- Republic of Korea, Embassy 1
- Societe Nationale d'Etude et de Construction de Moteurs d'Aviation 1
- Taipei Economic & Cultural Representative Office in Washington (TECRO) of Republic of China 1
- Taipei Economic and Cultural Representative Office in the United States (TECRO) 1
Registrant_Name 18
- Downen, Robert L. 2
- Meredith Concept Group, Inc. 2
- Squire Patton Boggs, LLP 2
- Bannerman & Associates, Inc. 1
- Development Counsellors International 1
- Fielding, Fred F. 1
- Foley Hoag, LLP 1
- Ganzglass, Martin R. 1
- International Technology and Trade Associates, Inc. (ITTA) 1
- Karen Weiner Escalera Associates, Inc. 1
- Livingston-Solomon Group, L.L.C. 1
- Mayall, Norman V. 1
- McGuireWoods Consulting, LLC 1
- Paul, Weiss, Rifkind, Wharton & Garrison 1
- Powell, Goldstein, Frazer & Murphy, L.L.P. 1
- QORVIS LLC 1
- Richard Lewis Communications, Inc. 1
- Schmeltzer, Aptaker & Shepard, P.C. 1
Country/Location_Represented 15
- KOREA, SOUTH 4
- FRANCE 2
- HAITI 2
- TAIWAN 2
- BENIN 1
- CAYMAN ISLANDS 1
- CHINA 1
- ERITREA 1
- FINLAND 1
- GUYANA 1
- INTERNATIONAL 1
- JAPAN 1
- KAZAKHSTAN 1
- MEXICO 1
- SWITZERLAND 1
City 1
- - 21
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16491 | 16491 | 2001-12-31 | Commercial Office of the Embassy of the People's Republic of China in Washington | 1999-01-06 | CHINA | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | 2133 Wisconsin Avenue, N.W. | DC | |||
16492 | 16492 | 2001-12-31 | Societe Nationale d'Etude et de Construction de Moteurs d'Aviation | 1996-03-20 | FRANCE | Meredith Concept Group, Inc. 5101 | 1996-03-20 | Meredith Concept Group, Inc. | Paris | ||||
16493 | 16493 | 2001-12-31 | CACTAC - Central American and Caribbean Textile and Apparel Council | 2002-04-03 | INTERNATIONAL | Schmeltzer, Aptaker & Shepard, P.C. 5304 | 1999-03-02 | Schmeltzer, Aptaker & Shepard, P.C. | Calle Roma y Liverpool Col. Roma, Edif. AS1 San Salvador C.A. | ||||
16494 | 16494 | 2001-12-31 | Cayman Islands Government | 2001-06-08 | CAYMAN ISLANDS | Fielding, Fred F. 5440 | 2001-06-08 | Fielding, Fred F. | Office of the Financial Secretary Government Administration Building George Town, Grand Cayman | ||||
16495 | 16495 | 2001-12-31 | Embassy of Korea | 2000-02-01 | KOREA, SOUTH | Downen, Robert L. 5291 | 1998-12-04 | Downen, Robert L. | 2450 Massachusetts Avenue N.W. 20008 | DC | |||
16496 | 16496 | 2001-12-31 | Embassy of the Republic of Korea | 2001-09-10 | KOREA, SOUTH | International Technology and Trade Associates, Inc. (ITTA) 5458 | 2001-09-10 | International Technology and Trade Associates, Inc. (ITTA) | 2450 Massachusetts Avenue N.W. 20008 | DC | |||
16497 | 16497 | 2001-12-31 | Government of Haiti | 2001-06-04 | HAITI | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Kurzban Kurzban Weinger & Tetzeli Plaza 2650, Second Floor 2650 S.W. 27th Avenue Miami 33133 | FL | |||
16498 | 16498 | 2001-12-31 | Government of Eritrea, Embassy | 2000-06-19 | ERITREA | Ganzglass, Martin R. 5375 | 2000-06-19 | Ganzglass, Martin R. | 1708 New Hampshire Avenue, N.W. | DC | |||
16499 | 16499 | 2001-12-31 | Government of Kazakhstan | 2001-10-23 | KAZAKHSTAN | Bannerman & Associates, Inc. 3964 | 1987-04-28 | Bannerman & Associates, Inc. | Almaty | ||||
16500 | 16500 | 2001-12-31 | Invest in Finland Bureau | 2001-03-19 | FINLAND | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | Aleksanterinkatu 17, P.O. Box 800 FIN-00101 Helsinki | ||||
16501 | 16501 | 2001-12-31 | Korea Telecom | 1995-03-06 | KOREA, SOUTH | Paul, Weiss, Rifkind, Wharton & Garrison 4539 | 1991-07-09 | Paul, Weiss, Rifkind, Wharton & Garrison | |||||
16502 | 16502 | 2001-12-31 | Messier-Dowty International | 1999-02-16 | FRANCE | Meredith Concept Group, Inc. 5101 | 1996-03-20 | Meredith Concept Group, Inc. | Gloucester | ||||
16503 | 16503 | 2001-12-31 | Mexico City Tourism Authority (Fondo Mixto de Promocion Turistica de la Ciudad de Mexico) | 2001-02-26 | MEXICO | Karen Weiner Escalera Associates, Inc. 5412 | 2001-02-26 | Karen Weiner Escalera Associates, Inc. | Instituto de Promocion Turistica Nuevo Leon 56 Col. Condesa 06140, Mexico, D.F. | ||||
16504 | 16504 | 2001-12-31 | Neuchatel Government Canton of Neuchatel, Switzerland | 1999-03-23 | SWITZERLAND | Mayall, Norman V. 5306 | 1999-03-23 | Mayall, Norman V. | Neuchatel | ||||
16505 | 16505 | 2001-12-31 | Nissho-Iwai Corporation | 1990-12-20 | JAPAN | Richard Lewis Communications, Inc. 4452 | 1990-12-20 | Richard Lewis Communications, Inc. | Tokyo | ||||
16506 | 16506 | 2001-12-31 | Republic of Benin | 1999-07-08 | BENIN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Minister of Finance B.P. 301 Benin, West Africa | ||||
16507 | 16507 | 2001-12-31 | Republic of Guyana | 1993-03-03 | GUYANA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Georgetown | ||||
16508 | 16508 | 2001-12-31 | Republic of Haiti | 2003-06-04 | HAITI | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | Kurzban, Kurzban, Weinger & Tetzeli Plaza 2650, Second Floor 2650 S.W. 27th Avenue Miami 33133 | FL | |||
16509 | 16509 | 2001-12-31 | Republic of Korea, Embassy | 2001-02-05 | KOREA, SOUTH | McGuireWoods Consulting, LLC 5408 | 2001-02-05 | McGuireWoods Consulting, LLC | 2450 Massachusetts Avenue, N.W. 20008 | DC | |||
16510 | 16510 | 2001-12-31 | Taipei Economic & Cultural Representative Office in Washington (TECRO) of Republic of China | 1998-12-04 | TAIWAN | Downen, Robert L. 5291 | 1998-12-04 | Downen, Robert L. | 4201 Wisconsin Avenue, N.W. | DC | |||
16511 | 16511 | 2001-12-31 | Taipei Economic and Cultural Representative Office in the United States (TECRO) | 2000-02-01 | TAIWAN | Livingston-Solomon Group, L.L.C. 5352 | 2000-01-07 | Livingston-Solomon Group, L.L.C. | 4201 Wisconsin Avenue, N.W. 20016 | DC |
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]) );