List of all foreign principals (active and terminated)

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

67 rows where Registrant_Name = "Koenig, Harry D." sorted by Registrant_Date

View and edit SQL

Suggested facets: Foreign_Principal_Registration_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State

  • - 67

Registrant_Name

  • Koenig, Harry D. · 67

Country/Location_Represented

City

  • - 67
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
5443 1945-04-29 Alexandra Ivanovna Poliakoff 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5444 1945-04-29 Andrew Grycink 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5445 1945-04-29 Basil Katinivic 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5446 1945-04-29 Benjamin Gashinsky 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5447 1945-04-29 Berel Jaffe 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5448 1945-04-29 Chae Hene Goldenberg 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5449 1945-04-29 Chai Drezar Karvorsky 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5450 1945-04-29 Chaika Botwinick 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5451 1945-04-29 Children of Schmeul Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5452 1945-04-29 David Greenberg 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5453 1945-04-29 Deborah Katz 1943-11-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5454 1945-04-29 Dmitri Wakulchyk 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5455 1945-04-29 Dmitry Wasilievich Poliakoff 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5456 1945-04-29 Dorothy Herzog 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5457 1945-04-29 Emily Borgardt 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5458 1945-04-29 Esta Risha Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5459 1945-04-29 Etta (Yanta) Milner 1943-11-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5460 1945-04-29 Fage Kaplan 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5461 1945-04-29 Gittel Ubogy 1943-11-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5462 1945-04-29 Gregor Kashisky 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5463 1945-04-29 Haretina Wakulchyk 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5464 1945-04-29 Herschel Botwinick 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5465 1945-04-29 Itzick Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5466 1945-04-29 Ivan Wasilievich Poliakoff 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5467 1945-04-29 Jacob Greenberg 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5468 1945-04-29 Laber Botwinick 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5469 1945-04-29 Lazar Botwinick 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5470 1945-04-29 Leib Einbender 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5471 1945-04-29 Leve Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5472 1945-04-29 Lily Schwarzwald 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5473 1945-04-29 Luba Katz 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5474 1945-04-29 Machlea Kesselman 1943-11-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5475 1945-04-29 Madeline Strung 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5476 1945-04-29 Malasha Rewchuk 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5477 1945-04-29 Maria Wasilievna Poliakoff 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5478 1945-04-29 Marianna Meskauskis 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5479 1945-04-29 Mary Loz 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5480 1945-04-29 Mary Strung 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5481 1945-04-29 Milia Frankel 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5482 1945-04-29 Minna Gruenfeld 1943-11-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5483 1945-04-29 Mitchell Strung 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5484 1945-04-29 Moisha Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5485 1945-04-29 Nenu Dzanguberkova 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5486 1945-04-29 Next of Kin of Constantine Tarbeyff 1943-11-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5487 1945-04-29 Next of Kin of Harry Pavloos (Harry Thomas Pavlof) 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5488 1945-04-29 Next of Kin of Solomon Wapner (Wapno) 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5489 1945-04-29 Next of Kin of the Estate of Demetri Teplikow (a/k/a Jim Circulowski) 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5490 1945-04-29 Next of Kin of the Estate of Frank Norwillas (Norwellas) 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5491 1945-04-29 Nick Katinivic 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5492 1945-04-29 Olga Kubalova 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5493 1945-04-29 Panteleimon Wakulchyk 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5494 1945-04-29 Pavel Wasilievich Poliakoff 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5495 1945-04-29 Pavlina E. Wolochonovich 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5496 1945-04-29 Peter Wasilievich Poliakoff 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5497 1945-04-29 Phyllis Katinivic 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5498 1945-04-29 Rifke Maler 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5499 1945-04-29 Safetka Tseboeva 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5500 1945-04-29 Shayer Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5501 1945-04-29 Shenka Botwinick 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5502 1945-04-29 Sonya Gloeva 1944-05-01 USSR 151 151 1942-10-29 Koenig, Harry D.          
5503 1945-04-29 Unknown Heirs of Fritz Strung 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          
5504 1945-04-29 Vasili Krotoff 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5505 1945-04-29 Velvill Seidenknop 1944-11-03 USSR 151 151 1942-10-29 Koenig, Harry D.          
5506 1945-04-29 Walter Katinivic 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5507 1945-04-29 Wladimir Terentiev Maximovich 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5508 1945-04-29 Yehuda Greenberg 1942-10-29 USSR 151 151 1942-10-29 Koenig, Harry D.          
5509 1945-04-29 Zinovy Wakulchyk 1945-05-04 USSR 151 151 1942-10-29 Koenig, Harry D.          

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])
);