FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
29 rows where City = "New York" and Registrant_Name = "Scandinavian Railways"
This data as json, CSV (advanced)
State 1
- NY 29
Registration_Number 1
Registrant_Name 1
- Scandinavian Railways · 29 ✖
City 1
- New York · 29 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2505 | 2505 | 1955-01-01 | 1952-07-23 | Wennberg | Thor Reinhold | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
4669 | 4669 | 1955-01-28 | 1954-02-24 | Petersen | Reinhold | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
20724 | 20724 | 1962-06-30 | 1955-02-16 | Harrysson | John Helmer Bertil | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
20731 | 20731 | 1963-06-30 | 1961-01-23 | Nielsen | Bent Winter | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
25467 | 25467 | 1968-08-01 | 1964-03-04 | Christensen | Poul | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
25471 | 25471 | 1968-08-01 | 1966-10-31 | Hillerstrom | Tord Henry | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
30853 | 30853 | 1965-09-30 | 1963-01-07 | Wiberg | Gunnar Axel | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
32548 | 32548 | 1953-10-10 | 1952-07-23 | Bjerregaard | Erik | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
37945 | 37945 | 1970-12-09 | 1958-01-08 | Rasmussen | Aase | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
37946 | 37946 | 1970-12-09 | 1961-01-23 | Johanson | Brita Johanna | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
37947 | 37947 | 1970-12-09 | 1969-05-13 | Norlem | Allan | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
37948 | 37948 | 1970-12-09 | 1952-07-23 | Bunaes | Bjorn Einar | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
37949 | 37949 | 1970-12-09 | 1955-07-25 | Dahl | Doris | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
37950 | 37950 | 1970-12-09 | 1966-10-31 | Noerlem | Ib Allan | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39554 | 39554 | 1956-12-31 | 1955-06-22 | Bunaes | Bjorn Einar | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39556 | 39556 | 1956-12-31 | 1955-07-25 | Theen | Marta Gulli Ingeborg | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39557 | 39557 | 1956-12-31 | 1955-07-30 | Nilsen | Inger Kirstine | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39566 | 39566 | 1957-12-31 | 1957-01-09 | Hassard | Bjorg Wilhelmine Maren Riis | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39607 | 39607 | 1957-12-31 | 1957-07-26 | Larsen | Inger Lise | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39656 | 39656 | 1958-12-31 | 1955-07-25 | Larsen | Henning Vilhelm | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39657 | 39657 | 1958-12-31 | 1956-07-30 | Brorvik | Bjorn | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39667 | 39667 | 1959-12-31 | 1959-02-06 | Ramm-Ericson | Ubger Nargareta | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39686 | 39686 | 1960-12-31 | 1960-05-11 | Sundstrom | Kerstin Elisabeth | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39688 | 39688 | 1960-12-31 | 1960-07-18 | Forsberg | Anna Birgitta E. Elisabeth | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39689 | 39689 | 1960-12-31 | 1957-07-26 | Jensen | Kaj Aagaard | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39726 | 39726 | 1962-12-31 | 1959-02-06 | Axen | Per Ulrik | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39782 | 39782 | 1964-12-31 | 1963-11-19 | Kristiansen | Ola | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39784 | 39784 | 1965-12-31 | 1959-02-06 | Hansen | Erik Fritjof Johan Fosnes | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
39832 | 39832 | 1966-12-31 | 1965-08-18 | Stokkebryn | Gunnar | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | 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]) );