FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where "Short_Form_Termination_Date" is on date 1962-12-31
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Termination_Date (date)
Registration_Number 12
- George Peabody & Associates, Inc. 11
- Gardner, Morrison & Rogers 3
- Turkish Consulate Office of Culture & Information Attache 2
- Israel Government Tourist Office 2
- Austrian Trade Commission, Los Angeles 2
- Swedish Information Service 1
- Kelly, Nason, Inc. 1
- French National Railroads, New York 1
- Spanish National Tourist Office, New York 1
- Basque Delegation in the U.S.A. 1
- Scandinavian Railways 1
- John Moynahan & Associates 1
Registrant_Name 12
- George Peabody & Associates, Inc. 11
- Gardner, Morrison & Rogers 3
- Austrian Trade Commission, Los Angeles 2
- Israel Government Tourist Office 2
- Turkish Consulate Office of Culture & Information Attache 2
- Basque Delegation in the U.S.A. 1
- French National Railroads, New York 1
- John Moynahan & Associates 1
- Kelly, Nason, Inc. 1
- Scandinavian Railways 1
- Spanish National Tourist Office, New York 1
- Swedish Information Service 1
City 3
- New York 22
- Washington 3
- Los Angeles 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39722 | 39722 | 1962-12-31 | 1957-01-31 | O'Meara | Irene Cecelia | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | 501 Madison Avenue | New York | NY | 10022 | |
39723 | 39723 | 1962-12-31 | 1957-01-31 | Gross | Lenore Elaine Shapp | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | 501 Madison Avenue | New York | NY | 10022 | |
39724 | 39724 | 1962-12-31 | 1957-01-31 | Huber | Joel Cook , Jr. | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | 501 Madison Avenue | New York | NY | 10022 | |
39725 | 39725 | 1962-12-31 | 1957-01-31 | Wiseman | Frances Sylvia | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | 501 Madison Avenue | New York | NY | 10022 | |
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 |
39727 | 39727 | 1962-12-31 | 1945-03-07 | Lundbergh | Holger | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | 825 Third Avenue | New York | NY | 10022 | |
39728 | 39728 | 1962-12-31 | 1961-03-08 | Barovick | Richard Leon | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | 501 Madison Avenue | New York | NY | 10022 | |
39729 | 39729 | 1962-12-31 | 1958-03-18 | Bahn | Chester B. , Jr. | John Moynahan & Associates 1033 | 1957-06-06 | John Moynahan & Associates | 155 East 44th Street | New York | NY | 10017 | |
39730 | 39730 | 1962-12-31 | 1961-03-21 | Atakent | Ihsan | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
39731 | 39731 | 1962-12-31 | 1961-03-21 | Galbo | Vincent J. | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
39732 | 39732 | 1962-12-31 | 1961-03-21 | Ozaktas | Adnan | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
39733 | 39733 | 1962-12-31 | 1961-05-22 | Elkort | Martin Edward | Israel Government Tourist Office 620 | 1950-03-27 | Israel Government Tourist Office | 350 Fifth Avenue | New York | NY | 10118 | |
39734 | 39734 | 1962-12-31 | 1953-05-26 | Ferguson | Milton Carr | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | 501 Madison Avenue | New York | NY | 10022 | |
39735 | 39735 | 1962-12-31 | 1953-05-26 | Glass | William Burton | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | 501 Madison Avenue | New York | NY | 10022 | |
39736 | 39736 | 1962-12-31 | 1953-05-26 | Peabody | Barbara Keating | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | 501 Madison Avenue | New York | NY | 10022 | |
39737 | 39737 | 1962-12-31 | 1953-05-26 | Peabody | George , Jr. | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | 501 Madison Avenue | New York | NY | 10022 | |
39738 | 39738 | 1962-12-31 | 1954-05-27 | Rath | Alfred H. | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
39739 | 39739 | 1962-12-31 | 1961-06-30 | Gardner | Ralphn Webb | Gardner, Morrison & Rogers 1462 | 1961-06-30 | Gardner, Morrison & Rogers | 1126 Woodward Building | Washington | DC | ||
39740 | 39740 | 1962-12-31 | 1961-06-30 | Morrison | Fred Wilson | Gardner, Morrison & Rogers 1462 | 1961-06-30 | Gardner, Morrison & Rogers | 1126 Woodward Building | Washington | DC | ||
39741 | 39741 | 1962-12-31 | 1961-06-30 | Sheriff | Seymour | Gardner, Morrison & Rogers 1462 | 1961-06-30 | Gardner, Morrison & Rogers | 1126 Woodward Building | Washington | DC | ||
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 | |
39743 | 39743 | 1962-12-31 | 1960-08-01 | Aurell | Doris Dawn | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | 501 Madison Avenue | New York | NY | 10022 | |
39744 | 39744 | 1962-12-31 | 1948-09-14 | Coll | Jose Maria | Spanish National Tourist Office, New York 538 | 1948-09-14 | Spanish National Tourist Office, New York | 665 Fifth Avenue | New York | NY | 10022 | |
39745 | 39745 | 1962-12-31 | 1959-09-14 | Forrester | William D. | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | 501 Madison Avenue | New York | NY | 10022 | |
39746 | 39746 | 1962-12-31 | 1961-09-14 | Goldenberg | Bella | Israel Government Tourist Office 620 | 1950-03-27 | Israel Government Tourist Office | 350 Fifth Avenue | New York | NY | 10118 | |
39747 | 39747 | 1962-12-31 | 1953-10-21 | Kriessmann | Dr. Wilhelm L. | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
39748 | 39748 | 1962-12-31 | 1956-12-05 | Onatibia | Juan | Basque Delegation in the U.S.A. 586 | 1949-08-09 | Basque Delegation in the U.S.A. | Madison Square Station | Post Office Box 42 | New York | NY |
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]) );