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

28 rows where Registration_Number = 1240

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_First_Name, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

Registration_Number 1

  • Intourist U.S.A., Inc. · 28 ✖

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
3650 3650 1983-01-13 1979-05-11 Korolkov Evgeniy A. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
4300 4300 1965-01-23 1963-01-23 Vladimirov Vladimir Victorovitch Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
9898 9898 1965-03-15 1962-03-15 Nikiforov Youri Alexandrovich Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
10432 10432 1985-03-21 1982-09-22 Azarov Alexey A. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
10926 10926 1965-03-28 1959-06-23 Spiridonov Valentin Mikhailovich Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
13698 13698 1992-04-18 1989-08-24 Mesiatsev Alexey N. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
17071 17071 1969-05-25 1965-08-17 Tyaglova Kira Mikhailovna Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
20103 20103 1993-06-23 1990-07-20 Erchov Dmitri Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
20365 20365 1980-06-27 1977-11-01 Donskov Nikolai N. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
20510 20510 1980-06-29 1977-11-01 Kirioukhin Valeri M. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
22517 22517 1977-07-03 1975-03-24 Dzhashi Enrico A. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
22525 22525 1987-07-03 1983-05-17 Bagrov Yuri F. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
23764 23764 1968-07-22 1965-07-06 Slavnov Anatoly Ivanovitch Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
23767 23767 1970-07-22 1969-07-22 Mikhailovna Gusarova Valentina Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
25781 25781 1974-08-02 1971-05-17 Bagrov Yuri Fjedorovich Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
26682 26682 1973-08-15 1970-01-13 Uvarov Valleriy Dmitrievich Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
26819 26819 1975-08-16 1971-05-17 Tyaglova Kira Mikhailovna Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
29006 29006 1976-09-02 1975-08-25 Nikolski Mikhail V. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
29264 29264 1978-09-06 1975-08-25 Kryazhev Vitaliy G. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
30187 30187 1977-09-21 1974-05-22 Vladimir Ukhlin Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
33059 33059 1985-10-17 1985-06-28 Kuntsevich Mikhail M. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
33823 33823 1970-10-29 1968-01-09 Lyskin Oleg Iosiphovich Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
35817 35817 1981-11-15 1978-01-30 Tourkine Vicor N. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
37380 37380 1985-12-01 1981-07-27 Desyatnikov Felix A. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
37951 37951 1973-12-09 1969-05-12 Damaskin Igor Anatolievich Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
38162 38162 1984-12-12 1980-08-04 Zima Valery I. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
38975 38975 1959-12-23 1959-06-23 Timerbaeva Nina Petrovna Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
40404 40404 1987-12-31 1974-05-22 Nadezda Koulikova Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 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])
);