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

74 rows where Registration_Number = 1748

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Needham, Harper & Steers Advertising, Inc. · 74 ✖

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
2557 2557 1972-01-01 1971-09-20 Grinere Rose M. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
2558 2558 1972-01-01 1971-09-20 Zuspan William H. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
3768 3768 1975-01-15 1968-08-20 Cornwell Douglas A. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
6646 6646 1971-02-12 1969-10-17 Dochtermann Ludwig Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
6912 6912 1973-02-15 1973-03-02 Waters John P. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
7762 7762 1976-02-27 1974-01-16 McCardle Diane Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
7763 7763 1976-02-27 1971-09-20 Schachter Roslyn Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
7884 7884 1978-02-28 1973-03-02 Nolan Kathleen H. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
8714 8714 1973-03-01 1973-04-20 Wells James Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
8715 8715 1973-03-01 1973-05-01 Zach Robert S. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
9113 9113 1977-03-04 1973-03-02 Loece Annette Mednola Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
9688 9688 1974-03-12 1968-08-20 Reis Robert H. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
10498 10498 1974-03-22 1974-01-16 Gottlieb Mel Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
11402 11402 1967-03-31 1964-06-03 O'Blak Frank , Jr. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
11450 11450 1975-03-31 1974-07-18 Kaufmann Jane Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
12410 12410 1972-04-01 1971-09-20 Aburish Said Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
12866 12866 1969-04-07 1964-06-03 Elliott Sylvia Lillian Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
14494 14494 1973-04-30 1969-10-17 Rohrer Graham Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
14495 14495 1974-04-30 1974-01-16 Kirby Michael E.G. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
15327 15327 1972-05-01 1968-08-20 Vergara Norman Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
15884 15884 1972-05-08 1971-10-05 Durham Guy F. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
16367 16367 1973-05-15 1973-03-02 Librante Paula Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
16542 16542 1968-05-17 1964-06-03 Miller John Arthur Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
17623 17623 1973-05-31 1969-10-17 Timmerman Robert E. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
18408 18408 1972-06-01 1971-09-20 Romano David Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
18409 18409 1972-06-01 1971-09-20 Wehmann Peter F. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
18959 18959 1973-06-06 1973-04-05 Webber Harry Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
19339 19339 1975-06-13 1974-07-18 Wells Thomas W. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
19517 19517 1975-06-15 1971-09-20 Vellanti Edward A. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20002 20002 1973-06-22 1971-09-20 Massee William Jordan Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20778 20778 1966-06-30 1964-06-03 Lawrence Lewis James Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20779 20779 1966-06-30 1964-06-03 Radisch Bernard Buddy Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20872 20872 1973-06-30 1973-04-05 Sutin Suzanne E. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20945 20945 1980-06-30 1974-01-16 Rangell Sydelle Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20946 20946 1980-06-30 1974-01-16 Widholm Robert Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20953 20953 1980-06-30 1979-04-27 Caponnetto Marianne Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20954 20954 1980-06-30 1979-04-27 Gellatly John A. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20955 20955 1980-06-30 1979-04-27 Grasso Barbara F. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20956 20956 1980-06-30 1979-04-27 Lowy Michele Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20957 20957 1980-06-30 1979-04-27 Marino Carmine Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20958 20958 1980-06-30 1979-04-27 Marker Robert S. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20959 20959 1980-06-30 1979-04-27 Plants Duane Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20960 20960 1980-06-30 1979-04-27 Santos Anthony Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20961 20961 1980-06-30 1979-04-27 Thompson Page Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20962 20962 1980-06-30 1975-06-11 Fraser Alan Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20964 20964 1980-06-30 1971-09-20 Kay Allen Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20965 20965 1980-06-30 1971-09-20 Lynch Robert F. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20966 20966 1980-06-30 1971-09-20 Rohrer Graham Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20967 20967 1980-06-30 1969-10-17 O'Hare Patricia Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
22096 22096 1972-07-01 1971-09-20 Herz Stephen Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
22103 22103 1973-07-01 1971-09-20 Harwood Jerome Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
23605 23605 1976-07-19 1971-09-20 Haas Andre Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
27253 27253 1971-08-23 1964-06-03 Murray John Raymond , Jr. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
27254 27254 1971-08-23 1964-06-03 Petrocelli Robert Humbert Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
27255 27255 1971-08-23 1965-06-16 Foley Howard Scott Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
27304 27304 1971-08-24 1964-06-03 Barnett Michael Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
27569 27569 1968-08-28 1964-06-03 Stevens James Stacy Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
30354 30354 1976-09-24 1974-01-16 Jacobs Joseph Jerry Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
30933 30933 1979-09-30 1971-09-20 MacDonald Robert Bruce Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
32498 32498 1974-10-09 1974-01-16 Hubler Jack Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
32499 32499 1974-10-09 1974-07-18 Kirkpatrick Frank Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
33235 33235 1974-10-20 1968-08-20 O'Hare Patricia Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
33236 33236 1974-10-20 1971-09-20 Biederman Barron Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
33237 33237 1974-10-20 1971-09-20 Korey Lois Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
33594 33594 1974-10-25 1974-01-16 Stassi Peter Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
34871 34871 1974-11-01 1974-07-18 Schell Merle Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
36144 36144 1975-11-21 1975-06-11 Cohen Jeffrey Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
37299 37299 1972-12-01 1971-09-20 O'Hare Patricia Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
37599 37599 1974-12-02 1973-04-05 Chamberlain Leslie Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
39315 39315 1977-12-30 1974-01-16 Kraus John R. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
39788 39788 1965-12-31 1965-06-16 Doherty Robert Cunningham Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
39789 39789 1965-12-31 1965-06-16 Grady Lester Charles Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
39858 39858 1967-12-31 1965-06-16 Fehr Richard Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
39989 39989 1975-12-31 1971-09-20 Agins Sherman L. Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022

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])
);