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

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

State

Registration_Number

  • 1748 · 74

City

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
2404 1972-01-01 1971-09-20 Grinere Rose M. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
2405 1972-01-01 1971-09-20 Zuspan William H. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
3558 1975-01-15 1968-08-20 Cornwell Douglas A. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
6366 1971-02-12 1969-10-17 Dochtermann Ludwig 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
6618 1973-02-15 1973-03-02 Waters John P. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
7450 1976-02-27 1974-01-16 McCardle Diane 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
7451 1976-02-27 1971-09-20 Schachter Roslyn 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
7572 1978-02-28 1973-03-02 Nolan Kathleen H. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
8377 1973-03-01 1973-04-20 Wells James 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
8378 1973-03-01 1973-05-01 Zach Robert S. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
8749 1977-03-04 1973-03-02 Loece Annette Mednola 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
9294 1974-03-12 1968-08-20 Reis Robert H. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
10096 1974-03-22 1974-01-16 Gottlieb Mel 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
10990 1967-03-31 1964-06-03 O'Blak Frank , Jr. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
11038 1975-03-31 1974-07-18 Kaufmann Jane 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
11948 1972-04-01 1971-09-20 Aburish Said 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
12386 1969-04-07 1964-06-03 Elliott Sylvia Lillian 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
13968 1973-04-30 1969-10-17 Rohrer Graham 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
13969 1974-04-30 1974-01-16 Kirby Michael E.G. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
14766 1972-05-01 1968-08-20 Vergara Norman 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
15284 1972-05-08 1971-10-05 Durham Guy F. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
15744 1973-05-15 1973-03-02 Librante Paula 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
15915 1968-05-17 1964-06-03 Miller John Arthur 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
16975 1973-05-31 1969-10-17 Timmerman Robert E. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
17719 1972-06-01 1971-09-20 Romano David 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
17720 1972-06-01 1971-09-20 Wehmann Peter F. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
18250 1973-06-06 1973-04-05 Webber Harry 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
18619 1975-06-13 1974-07-18 Wells Thomas W. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
18790 1975-06-15 1971-09-20 Vellanti Edward A. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
19256 1973-06-22 1971-09-20 Massee William Jordan 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20024 1966-06-30 1964-06-03 Lawrence Lewis James 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20025 1966-06-30 1964-06-03 Radisch Bernard Buddy 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20118 1973-06-30 1973-04-05 Sutin Suzanne E. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20191 1980-06-30 1974-01-16 Rangell Sydelle 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20192 1980-06-30 1974-01-16 Widholm Robert 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20199 1980-06-30 1979-04-27 Caponnetto Marianne 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20200 1980-06-30 1979-04-27 Gellatly John A. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20201 1980-06-30 1979-04-27 Grasso Barbara F. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20202 1980-06-30 1979-04-27 Lowy Michele 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20203 1980-06-30 1979-04-27 Marino Carmine 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20204 1980-06-30 1979-04-27 Marker Robert S. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20205 1980-06-30 1979-04-27 Plants Duane 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20206 1980-06-30 1979-04-27 Santos Anthony 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20207 1980-06-30 1979-04-27 Thompson Page 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20208 1980-06-30 1975-06-11 Fraser Alan 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20210 1980-06-30 1971-09-20 Kay Allen 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20211 1980-06-30 1971-09-20 Lynch Robert F. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20212 1980-06-30 1971-09-20 Rohrer Graham 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
20213 1980-06-30 1969-10-17 O'Hare Patricia 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
21290 1972-07-01 1971-09-20 Herz Stephen 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
21297 1973-07-01 1971-09-20 Harwood Jerome 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
22744 1976-07-19 1971-09-20 Haas Andre 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
26271 1971-08-23 1964-06-03 Murray John Raymond , Jr. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
26272 1971-08-23 1964-06-03 Petrocelli Robert Humbert 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
26273 1971-08-23 1965-06-16 Foley Howard Scott 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
26317 1971-08-24 1964-06-03 Barnett Michael 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
26571 1968-08-28 1964-06-03 Stevens James Stacy 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
29293 1976-09-24 1974-01-16 Jacobs Joseph Jerry 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
29866 1979-09-30 1971-09-20 MacDonald Robert Bruce 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
31362 1974-10-09 1974-01-16 Hubler Jack 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
31363 1974-10-09 1974-07-18 Kirkpatrick Frank 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
32074 1974-10-20 1968-08-20 O'Hare Patricia 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
32075 1974-10-20 1971-09-20 Biederman Barron 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
32076 1974-10-20 1971-09-20 Korey Lois 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
32424 1974-10-25 1974-01-16 Stassi Peter 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
33670 1974-11-01 1974-07-18 Schell Merle 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
34895 1975-11-21 1975-06-11 Cohen Jeffrey 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
35997 1972-12-01 1971-09-20 O'Hare Patricia 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
36268 1974-12-02 1973-04-05 Chamberlain Leslie 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
37948 1977-12-30 1974-01-16 Kraus John R. 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
38418 1965-12-31 1965-06-16 Doherty Robert Cunningham 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
38419 1965-12-31 1965-06-16 Grady Lester Charles 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
38488 1967-12-31 1965-06-16 Fehr Richard 1748 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. 909 Third Avenue   New York NY 10022
38619 1975-12-31 1971-09-20 Agins Sherman L. 1748 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])
);