FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Foreign_Principal_Termination_Date" is on date 2007-01-31
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_2, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 11
- CN Romtehnica S.A. 2
- Corporacion de Promocion de Exportacion e Inversiones (CORPEI) 1
- Embassy of Thailand 1
- Government of the Democratic and Popular Republic of Algeria, Embassy 1
- Korean Culture and Information Service, Embassy, Republic of Korea 1
- Ministry of Commerce of the Government of Pakistan, Embassy 1
- Republic of the Philippines 1
- Rodina Political Party 1
- Serbian National Council of Kosovo and Metohija 1
- Social Democratic Labour Party of Northern Ireland 1
- University of Johannesburg 1
Country/Location_Represented 11
- ROMANIA 2
- ALGERIA 1
- ECUADOR 1
- KOREA, SOUTH 1
- NORTHERN IRELAND 1
- PAKISTAN 1
- PHILIPPINES 1
- RUSSIA 1
- SERBIA 1
- SOUTH AFRICA 1
- THAILAND 1
Registrant_Name 10
City 6
- Washington 4
- - 3
- Bucharest 2
- Auckland Park 1
- Quezon City 1
- Quito 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1862 | 1862 | 2007-01-31 | CN Romtehnica S.A. | 2005-07-21 | ROMANIA | Williams Mullen Strategies, Inc. 5698 | 2005-07-21 | Williams Mullen Strategies, Inc. | 5C Timisoara Boulevard 77311 | 6 Bucharest | Bucharest | ||
1863 | 1863 | 2007-01-31 | CN Romtehnica S.A. | 2005-07-21 | ROMANIA | Williams, Mullen, Clark & Dobbins, P.C. 5699 | 2005-07-21 | Williams, Mullen, Clark & Dobbins, P.C. | 5C Timisoara Boulevard, 77311, 6 | Bucharest | |||
1864 | 1864 | 2007-01-31 | Corporacion de Promocion de Exportacion e Inversiones (CORPEI) | 2006-10-25 | ECUADOR | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | Direccion: Av. Amazonas 4430 y Villalengua, Edificio Amazonas 100, Piso 8 | Quito | |||
1865 | 1865 | 2007-01-31 | Embassy of Thailand | 2006-08-30 | THAILAND | Clark Consulting 5611 | 2004-03-12 | Clark Consulting | 1024 Wisconsin Avenue, NW | Washington | DC | 20007 | |
1866 | 1866 | 2007-01-31 | Government of the Democratic and Popular Republic of Algeria, Embassy | 2006-01-17 | ALGERIA | Carmen Group Incorporated 5727 | 2006-01-17 | Carmen Group Incorporated | 2118 Kalorama Road, NW | Washington | DC | 20008 | |
1867 | 1867 | 2007-01-31 | Korean Culture and Information Service, Embassy, Republic of Korea | 2006-01-25 | KOREA, SOUTH | Pastreich, Emanuel Yi 5728 | 2006-01-25 | Pastreich, Emanuel Yi | 2370 Massachusetts Avenue, NW | Washington | DC | 20008 | |
1868 | 1868 | 2007-01-31 | Ministry of Commerce of the Government of Pakistan, Embassy | 2006-06-01 | PAKISTAN | Quinn Gillespie & Associates, LLC 5753 | 2006-06-01 | Quinn Gillespie & Associates, LLC | 3517 International Court, NW | Washington | DC | 20008 | |
1869 | 1869 | 2007-01-31 | Republic of the Philippines | 2005-08-02 | PHILIPPINES | Venable, LLP 5435 | 2001-05-29 | Venable, LLP | #5 V. Luna Road, Diliman | Quezon City | |||
1870 | 1870 | 2007-01-31 | Rodina Political Party | 2005-09-22 | RUSSIA | Venable, LLP 5435 | 2001-05-29 | Venable, LLP | ul. Vozdvizhenka, 7/6 | 119019 Moscow | |||
1871 | 1871 | 2007-01-31 | Serbian National Council of Kosovo and Metohija | 2006-04-04 | SERBIA | Venable, LLP 5435 | 2001-05-29 | Venable, LLP | c/o Abbot Simeon (Vilovski) Banjska Monastery | 38216 Banjska Kosovo and Metobiia | |||
1872 | 1872 | 2007-01-31 | Social Democratic Labour Party of Northern Ireland | 2006-02-02 | NORTHERN IRELAND | O'Neill, Rosemary D. 5730 | 2006-02-02 | O'Neill, Rosemary D. | 121 Ormeau Road Belfast, BT 71 sh | ||||
1873 | 1873 | 2007-01-31 | University of Johannesburg | 2006-05-03 | SOUTH AFRICA | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | P.O. Box 584 | Auckland Park |
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]) );