List of all short form registrants (active and terminated)

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

153 rows where City = "New York" and Registrant_Name = "New York Bureau of the Telegraph Agency of Russia (TASS)"

View and edit SQL

State

Registration_Number

Registrant_Name

  • New York Bureau of the Telegraph Agency of Russia (TASS) · 54

City

  • New York · 54
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
29154 1948-09-24 1948-04-30 Hedrick Travis K. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29733 1977-09-30 1977-04-21 Borodin Viktor 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29740 1977-09-30 1977-09-12 Bogoluybov Vladimir 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29901 1992-09-30 1988-04-04 Kochetkov Mikhail 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29902 1992-09-30 1988-04-04 Maslov Nikolai 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29903 1992-09-30 1990-04-30 Kolesnichenko Mikhail T. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29904 1992-09-30 1974-05-07 Wicklen Frederick M. , Jr. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29905 1992-09-30 1991-07-08 Lebedev Ivan L. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29910 1992-09-30 1988-09-21 Berezhkov Alexey S. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29911 1992-09-30 1988-09-21 Korolev Alexander 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29912 1992-09-30 1986-10-07 Fediachine Andrei G. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29913 1992-09-30 1992-11-03 Khabotin Sergei 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29914 1992-09-30 1988-11-04 Lunev Stanislav P. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29915 1992-09-30 1989-11-15 Kouznetsov Sergei N. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
30527 1948-10-01 1947-06-09 Folsom Franklin Brewster 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
30535 1955-10-01 1951-06-08 Bolshakov Georgi Nikitovich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
30555 1961-10-01 1947-06-09 Klein Jerome 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
30574 1968-10-01 1963-10-28 Petroussenko Vitaly Vasilievich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
30580 1971-10-01 1969-05-02 Yarochevsky Boris V. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
31408 1989-10-12 1984-11-06 Turkatenko Nikolai D. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
31580 1984-10-15 1980-09-15 Smirnov Vladimir E. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
31689 1953-10-16 1952-01-15 Mardo William Blom 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
31949 1960-10-20 1950-03-10 Beglov Ivan I. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
32291 1949-10-25 1947-06-09 Krafsur Samuel 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
32850 1966-10-31 1961-09-13 Ponomarev Leonid Semenovich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
32853 1966-10-31 1963-09-30 Lubimov Sergei 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
32895 1977-10-31 1972-11-22 Legantsov Vladislav I. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
33506 1964-11-01 1963-03-07 Derevenskov Gennady Georgievich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
33509 1966-11-01 1963-03-07 Shokin Leonid Ivanovich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
33531 1971-11-01 1959-10-01 Danilov Alexander Jakovleyvich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
33537 1971-11-01 1967-10-18 Melikyan Artem Ovanesovich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
33544 1972-11-01 1968-11-27 Chukseev Vitaliy Yakovlevich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
33584 1987-11-01 1987-04-28 Kirilchenko Yuri 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
33810 1992-11-03 1987-02-20 Sitov Andrei K. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
33813 1992-11-03 1992-04-30 Aguryeev Alexei 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
34078 1989-11-08 1989-10-30 Vanichkin Pavel N. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
34227 1986-11-10 1984-11-06 Orlov Vladislav I. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
34653 1969-11-18 1967-08-07 Poroshin Alexander G. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
34659 1988-11-18 1988-09-21 Loshchilin Andrei 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
34770 1967-11-21 1947-06-09 Rodriguez Emilio Delgado 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
34914 1962-11-24 1962-05-28 Turkatenko Nikolai Demyanovich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
35269 1983-11-30 1968-11-04 Pakhomov Nikolai V. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
35793 1949-12-01 1947-06-09 Remizov Timofei Yakovlevich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
35808 1956-12-01 1953-07-08 Lopoukhin Mikhail Mikhailovich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
35814 1959-12-01 1955-01-31 Paramonov Vladimir Borisovitch 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
35852 1968-12-01 1966-06-16 Yadroshnikov Leo Konstantinovich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
35862 1970-12-01 1969-10-17 Zhegalov Leonid N. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
36354 1948-12-06 1948-04-30 Ilyashenko Kuzma Ignatievich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
36765 1990-12-13 1985-08-21 Borisenko Igor E. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
36872 1948-12-15 1947-06-09 Cunningham William 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
37380 1979-12-21 1970-08-20 Voronin Alexei V. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
37814 1958-12-30 1953-07-08 Saveliev Anatoly Serbeevich 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
37824 1970-12-30 1969-08-19 Belyaev Kim I. 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
38529 1976-12-31 1971-11-01 Vashedchenko Vladimir 464 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020

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