FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

43 rows where Registration_Number = 817

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date (date)

State 1

Registration_Number 1

  • Pekao Trading Corporation · 43 ✖

Registrant_Name 1

City 1

Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
3034 3034 1961-01-02 1957-03-25 Szafir Nikodem Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
4785 4785 1961-01-30 1958-09-24 Daniec Julius Z. Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
4997 4997 1984-01-31 1980-08-20 Walasek Zygmunt Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
5146 5146 1995-01-31 1990-08-01 Grudzinski Maciej Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
5974 5974 1994-02-02 1990-08-01 Sarzynska Marzena L. Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
16012 16012 1975-05-10 1960-08-01 Trzeciak Andrew K. Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
16729 16729 1964-05-20 1960-08-01 Wieckowski Jan J. Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
17587 17587 1961-05-31 1962-03-19 Janiec Edward J. Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
17682 17682 1984-05-31 1981-10-21 Latopolski Kazimierz Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
18394 18394 1968-06-01 1954-02-23 Talmont Wladyslaw Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
19103 19103 1981-06-09 1974-09-11 Konczal Czeslaw Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
19787 19787 1956-06-18 1956-09-21 Sikora Jan Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
19788 19788 1958-06-18 1954-02-23 Majewski Kazimierz Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
20880 20880 1973-06-30 1967-11-03 Walasek Zygmunt Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
20932 20932 1978-06-30 1968-07-24 Kurmel Edward Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
21240 21240 1996-06-30 1988-02-02 Dachman Andrzej T. Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
21268 21268 1997-06-30 1995-08-01 Szajek Krzysztof Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
21319 21319 1999-06-30 1992-01-30 Nowicka Bozena A. Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
21320 21320 1999-06-30 1996-01-31 Holland-Wajs Anna Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
21321 21321 1999-06-30 1985-02-04 Kurylo Andrew O. Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
21322 21322 1999-06-30 1998-02-04 Karecka Anna D. Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
21323 21323 1999-06-30 1998-02-04 Rakowski Waldemar Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
21324 21324 1999-06-30 1998-02-04 Wegnerowski Jerzy K. Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
21325 21325 1999-06-30 1990-02-05 Kropiwnicki Leszek Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
21336 21336 1999-06-30 1993-07-29 Kwasnik Stanislawa Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
21337 21337 1999-06-30 1993-07-29 Maciorowski Krystyna Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
21338 21338 1999-06-30 1988-08-04 Perkowska Iwona A. Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
22252 22252 1996-07-01 1991-02-01 Krampus Michalina Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
23115 23115 1989-07-14 1984-08-02 Kanton Marian Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
24819 24819 1991-07-31 1989-02-03 Szewczyk Jan Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
24825 24825 1991-07-31 1989-08-02 Blewaska Jeffrey Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
25510 25510 1980-08-01 1975-03-14 Kropiniewicz Tadeusz Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
30263 30263 1988-09-22 1984-08-02 Oppeln-Bronikowski Janusz Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
30423 30423 1970-09-25 1966-03-31 Kropiniewicz Tadeusz Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
30444 30444 1995-09-25 1991-02-01 Sobolewski Wojciech Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
32197 32197 1974-10-03 1971-05-06 Mrowczynski Bogdan Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
32652 32652 1961-10-12 1961-04-26 Kielman Wladyslaw Leopold Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
33746 33746 1983-10-28 1979-01-22 Kirstein Josef Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
38742 38742 1989-12-19 1984-08-02 Pisarski Grzegorz Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
39551 39551 1956-12-31 1954-02-23 Jur Stefan Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
39877 39877 1969-12-31 1958-09-24 Kwiatkowski Jerzy Jastrzebiec Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
40035 40035 1977-12-31 1973-05-21 Tadeusz Rokita Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016
40406 40406 1987-12-31 1978-06-05 Sulinski Chester A. Pekao Trading Corporation 817 1954-02-23 Pekao Trading Corporation Two Park Avenue Suite 400 New York NY 10016

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_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])
);