FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Address_1 = "Kiev"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Foreign_Principal_Termination_Date (date)
Registrant_Name 14
- Aitken Irvin Lewin Berlin Vrooman & Cohn 1
- Amtorg Trading Corporation 1
- Heller & Rosenblatt 1
- Hill and Knowlton Strategies, LLC 1
- IPG DXTRA, Inc 1
- Kleban & Samor, P.C. 1
- Law Office of Stewart & Stewart 1
- MIS United Enterprises, Inc. 1
- P/C Advisors, Inc. 1
- Raftis Associates 1
- Redex Packaging Corporation 1
- Reichert, E. Karl 1
- U.S.A. Expo, Inc. 1
- Williams, Mullen, Christian & Dobbins, P.C. 1
Registrant_Date (date) 13 ✖
- 1993-06-11 2
- 1949-11-07 1
- 1981-11-10 1
- 1986-12-01 1
- 1990-12-07 1
- 1992-04-24 1
- 1992-05-20 1
- 1992-09-21 1
- 1992-10-23 1
- 1993-05-21 1
- 1993-11-26 1
- 1997-08-18 1
- 1998-01-13 1
Foreign_Principal 12
- Government of Ukraine 3
- Fund for Development of Foreign Economic Activity of Ukraine 1
- Government of Ukraine (through the Agency of Humanitarian Technologies) 1
- Government of Ukraine, Office of the President 1
- International Organization Open Economy of Eastern Europe 1
- Office of the President of Ukraine 1
- Office of the President of Ukraine (Through P/C Advisors, Inc.) 1
- Office of the President of Ukraine through P/C Advisors, Inc. 1
- Paton Welding Institute"" 1
- Prime Minister of Ukranian SSR - Vitold P. Fokin 1
- Ukrainian Branch of the World Laboratory (& Ministries) 1
- Ukroboron Service 1
State 1
- - 14
City 1
- - 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1274 | 1274 | 1998-01-13 | Ukroboron Service | 1998-01-13 | UKRAINE | MIS United Enterprises, Inc. 5225 | 1998-01-13 | MIS United Enterprises, Inc. | Kiev | ||||
1449 | 1449 | 1994-01-21 | Office of the President of Ukraine through P/C Advisors, Inc. | 1993-06-11 | UKRAINE | Williams, Mullen, Christian & Dobbins, P.C. 4815 | 1993-06-11 | Williams, Mullen, Christian & Dobbins, P.C. | Kiev | ||||
2487 | 2487 | 1991-02-14 | Prime Minister of Ukranian SSR - Vitold P. Fokin | 1990-12-07 | USSR | U.S.A. Expo, Inc. 4445 | 1990-12-07 | U.S.A. Expo, Inc. | Kiev | ||||
2995 | 2995 | 1994-02-28 | Office of the President of Ukraine (Through P/C Advisors, Inc.) | 1993-06-11 | UKRAINE | Raftis Associates 4816 | 1993-06-11 | Raftis Associates | Kiev | ||||
5752 | 5752 | 1994-04-29 | International Organization Open Economy of Eastern Europe | 1993-10-29 | UKRAINE | Law Office of Stewart & Stewart 4709 | 1992-09-21 | Law Office of Stewart & Stewart | Kiev | ||||
5895 | 5895 | 1992-04-30 | Paton Welding Institute"" | 1990-03-14 | RUSSIA | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | Kiev | ||||
6326 | 6326 | 1993-05-04 | Fund for Development of Foreign Economic Activity of Ukraine | 1992-10-23 | UKRAINE | Reichert, E. Karl 4727 | 1992-10-23 | Reichert, E. Karl | Kiev | ||||
7134 | 7134 | 1992-05-31 | Government of Ukraine | 1992-05-20 | UKRAINE | Redex Packaging Corporation 4670 | 1992-05-20 | Redex Packaging Corporation | Kiev | ||||
7144 | 7144 | 1995-05-31 | Government of Ukraine, Office of the President | 1992-04-27 | UKRAINE | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Kiev | ||||
10607 | 10607 | 1997-08-18 | Government of Ukraine | 1997-08-18 | UKRAINE | Aitken Irvin Lewin Berlin Vrooman & Cohn 5235 | 1997-08-18 | Aitken Irvin Lewin Berlin Vrooman & Cohn | Kiev | ||||
12381 | 12381 | 1996-10-01 | Government of Ukraine | 1994-10-28 | UKRAINE | Heller & Rosenblatt 4870 | 1993-11-26 | Heller & Rosenblatt | Kiev | ||||
14446 | 14446 | 1993-11-30 | Office of the President of Ukraine | 1993-05-21 | UKRAINE | P/C Advisors, Inc. 4806 | 1993-05-21 | P/C Advisors, Inc. | Kiev | ||||
14496 | 14496 | 2001-11-30 | Government of Ukraine (through the Agency of Humanitarian Technologies) | 2001-05-03 | UKRAINE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Kiev | ||||
16242 | 16242 | 1992-12-31 | Ukrainian Branch of the World Laboratory (& Ministries) | 1992-04-24 | UKRAINE | Kleban & Samor, P.C. 4653 | 1992-04-24 | Kleban & Samor, P.C. | Kiev |
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]) );