FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
42 rows where Registration_Number = 335
This data as json, CSV (advanced)
State 1
- NY 18
Registration_Number 1
- French National Railroads, New York · 18 ✖
Registrant_Name 1
City 1
- New York 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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]) );