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

42 rows where City = "New York" and Registration_Number = 335

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • French National Railroads, New York · 42 ✖

City 1

  • New York · 42 ✖
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
6108 6108 1974-02-04 1966-11-21 Defferard Ernest Marcel French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
7280 7280 1962-02-20 1956-12-17 Hagin Jean Doris French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
7492 7492 1956-02-24 1955-07-13 Klein Joseph Louis French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
7866 7866 1971-02-28 1963-10-17 Dubor Claude French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
8654 8654 1967-03-01 1962-01-02 Bucher Jacques J. French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
12376 12376 1961-04-01 1959-02-04 Blumstein Camille Joseph French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
12819 12819 1973-04-06 1963-07-10 Avril Paul Andre French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
13351 13351 1950-04-15 1945-12-03 Verlot Jean-Bernard French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
13504 13504 1954-04-16 1949-01-03 Maillet Francois French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
14544 14544 1984-04-30 1972-08-22 Blumstein Joseph C. French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
16727 16727 1953-05-20 1945-12-03 Montheard Rene French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
18432 18432 1978-06-01 1971-12-21 Norlem Allan French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
18709 18709 1958-06-03 1956-06-25 Guillaume Andre Edouard Georges French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
19131 19131 1952-06-10 1950-07-31 Mattre Philippe Le French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
19507 19507 1970-06-15 1963-10-30 Monzain Andre French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
19948 19948 1946-06-21 1945-12-03 LeJeune Herbert French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
20005 20005 1979-06-22 1977-02-28 Ange Richard French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
20857 20857 1972-06-30 1967-11-14 Maisons Jacques French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
20914 20914 1976-06-30 1973-08-08 Douel Michel French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
20987 20987 1982-06-30 1979-08-31 Ponssot Michel French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
22034 22034 1956-07-01 1955-03-24 Villa Margaret Harriet Hanson French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
25492 25492 1973-08-01 1956-03-07 Meinnier Jacques Jean French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
27035 27035 1954-08-20 1951-07-09 Petit Bernard Jean French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
27416 27416 1986-08-25 1983-03-23 Loubinoux Jean-Pierre French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
29126 29126 1950-09-04 1951-03-12 Coidan Stephen S. French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
30794 30794 1950-09-30 1949-01-03 McHale Thomas Joseph French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
30814 30814 1958-09-30 1952-07-07 Deshayes Pierre French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
30820 30820 1961-09-30 1959-02-04 Tiers Andre Paul Augustin French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
31790 31790 1964-10-01 1949-01-03 Vergos Gerard Andre French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
31791 31791 1964-10-01 1952-01-29 Barthelemy William A. French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
33055 33055 1974-10-17 1974-10-17 Defferard Ernest Marcel French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
35798 35798 1972-11-15 1953-06-30 Bris Pierre Marie Antoine Le French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
37663 37663 1965-12-03 1963-10-30 Librader Charles J. French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
39742 39742 1962-12-31 1951-07-09 Emeric Joseph Charles French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
40459 40459 1988-12-31 1974-02-19 Steinfels Horst French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
40463 40463 1988-12-31 1956-03-07 Berthe Robert French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
40478 40478 1988-12-31 1987-04-23 Frelat Bernard French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
40480 40480 1988-12-31 1975-04-25 Paulin-Westfall Gisele French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
40501 40501 1988-12-31 1956-06-25 Scher Dagobert Michel French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
40505 40505 1988-12-31 1979-07-02 Fiorenza Joseph French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
40519 40519 1988-12-31 1978-08-11 Pawlukowsky George French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   New York NY 10020
40543 40543 1988-12-31 1984-12-28 de Tessieres Alain French National Railroads, New York 335 1945-12-26 French National Railroads, New York 610 Fifth Avenue   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])
);