home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

16 rows where Registration_Number = 6491

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Foreign_Principal 16

  • All-Ukrainian Industry Association Federation of Employers of the Oil and Gas Industry"" 1
  • Ambassador-at - Large Kitoko Gaea Ngoulou 1
  • Chamber of Commerce and Industry of Serbia 1
  • Civil Movement For a Just Ukraine"(Hromadska Orhanizatsiia Rukh Spravedlyva Ukrayina)" 1
  • Embassy of the Kingdom of Morocco 1
  • Global Axis Partnership 1
  • Kyiv City Organization of Employers of the Oil and Gas Industry 1
  • Libyan United Democratic Party (LUDP) 1
  • Ministry of Foreign Relations and International Cooperation of the Republic of Honduras (through the Embassy of Honduras in the United States) 1
  • PJSC AGRARIAN FUND 1
  • Pavel Valnev 1
  • Primary Trade Union Organization of State Enterprise National Nuclear Energy Generating Company Energoatom"" 1
  • Public Joint-Stock Company National Joint-Stock Company (Naftogaz of Ukraine) 1
  • State Foreign Trade Enterprise SpetsTechnoExport 1
  • The Centre for a European Future 1
  • Ukrinmash 1

Country/Location_Represented 9

  • UKRAINE 8
  • BELGIUM 1
  • BULGARIA 1
  • CHAD 1
  • HONDURAS 1
  • INDONESIA 1
  • LIBYA 1
  • MOROCCO 1
  • SERBIA 1

City 6

  • - 10
  • Washington 2
  • Brussels 1
  • Cairo 1
  • Kyiv 1
  • Park Ridge 1

State 3

  • - 13
  • DC 2
  • IL 1

Registrant_Name 1

  • Yorktown Solutions, LLC 16
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
45 45   All-Ukrainian Industry Association Federation of Employers of the Oil and Gas Industry"" 2020-01-05 UKRAINE Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC          
47 47   Ambassador-at - Large Kitoko Gaea Ngoulou 2022-12-23 CHAD Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC Presidency of the Republic of Chad, PO Box 74 N'Djamen      
108 108   Chamber of Commerce and Industry of Serbia 2019-11-12 SERBIA Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC Resavska 13-15 Belgrade 11000      
195 195   Embassy of the Kingdom of Morocco 2021-11-08 MOROCCO Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC 3508 International drive NW Washington DC 20008
564 564   Primary Trade Union Organization of State Enterprise National Nuclear Energy Generating Company Energoatom"" 2023-04-10 UKRAINE Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC 2 Maidan Nezalezhnosti   Kyiv    
685 685   The Centre for a European Future 2023-03-20 BELGIUM Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC Rue des POISSONNIERS 13   Brussels    
1034 1034 2019-01-01 Public Joint-Stock Company National Joint-Stock Company (Naftogaz of Ukraine) 2017-11-19 UKRAINE Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC B. Khmelnitskogo st., 6, Kyiv, 01001      
1037 1037 2019-01-01 State Foreign Trade Enterprise SpetsTechnoExport 2018-03-31 UKRAINE Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC          
1038 1038 2019-01-01 Ukrinmash 2018-03-21 UKRAINE Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC Ukraine, 04119, Kyiv, 36, Dehtyarivska str.        
1547 1547 2022-01-26 Ministry of Foreign Relations and International Cooperation of the Republic of Honduras (through the Embassy of Honduras in the United States) 2021-11-04 HONDURAS Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC 1220 19th street NW Suite 320 Washington DC 20036
2577 2577 2020-02-15 Global Axis Partnership 2019-05-16 INDONESIA Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC Sudirman Central Business District (SCBD) Lot. 18 Tower A 8th Floor Jl. Jenderal Sudirman Kav. 52-53 Jakarta 12190      
7712 7712 2021-06-09 Pavel Valnev 2020-12-19 BULGARIA Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC 1492 Tyrell Avenue   Park Ridge IL 60068
14599 14599 2022-11-30 Civil Movement For a Just Ukraine"(Hromadska Orhanizatsiia Rukh Spravedlyva Ukrayina)" 2021-08-17 UKRAINE Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC          
14738 14738 2019-12-01 Libyan United Democratic Party (LUDP) 2018-12-26 LIBYA Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC 1 Al Moshier Ahmed Ismail Street   Cairo    
15080 15080 2019-12-13 PJSC AGRARIAN FUND 2019-08-08 UKRAINE Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC 1 Grinchenko Street Kyiv 01001      
16852 16852 2019-12-31 Kyiv City Organization of Employers of the Oil and Gas Industry 2018-03-03 UKRAINE Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC B. Khmelnitskogo st., 6, Kyiv 01601        

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 266.749ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows