FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
26 rows where "Short_Form_Termination_Date" is on date 1980-06-30 sorted by Registration_Number
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_1, Zip, Registration_Date (date)
Registration_Number 10
- Needham, Harper & Steers Advertising, Inc. 16
- Quebec Government Office 2
- Arter, Hadden & Hemmendinger 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
- Italian Government Travel Office, Chicago 1
- Government of Ontario, Canada 1
- Colombian Government Trade Bureau 1
- Beef + Lamb New Zealand, Ltd. 1
- Arent Fox Kintner Plotkin & Kahn, PLLC 1
- Mel Anderson Communications, Inc. 1
Registrant_Name 10
- Needham, Harper & Steers Advertising, Inc. 16
- Quebec Government Office 2
- Arent Fox Kintner Plotkin & Kahn, PLLC 1
- Arter, Hadden & Hemmendinger 1
- Beef + Lamb New Zealand, Ltd. 1
- Colombian Government Trade Bureau 1
- Government of Ontario, Canada 1
- Italian Government Travel Office, Chicago 1
- Mel Anderson Communications, Inc. 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
City 5
- New York 21
- Washington 2
- Chicago 1
- Houston 1
- McLean 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20948 | 20948 | 1980-06-30 | 1973-02-07 | Berg | R. Christian | Arter, Hadden & Hemmendinger 1001 | 1957-02-21 | Arter, Hadden & Hemmendinger | 1919 Pennsylvania Avenue, N.W. | Suite 400 | Washington | DC | 20006 |
20969 | 20969 | 1980-06-30 | 1979-11-15 | Miltenberg | Robert Allen | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | 7 Dey Street | New York | NY | 10017 | |
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 | |
20952 | 20952 | 1980-06-30 | 1979-03-29 | Guertin | Andre P. | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
20968 | 20968 | 1980-06-30 | 1978-11-15 | Langevin | Pierre | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
20947 | 20947 | 1980-06-30 | 1980-01-21 | Pala | Gabriele | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
20951 | 20951 | 1980-06-30 | 1975-03-25 | Howe | Allan | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
20949 | 20949 | 1980-06-30 | 1971-03-10 | Crespo | Mario | Colombian Government Trade Bureau 2121 | 1969-01-30 | Colombian Government Trade Bureau | 140 East 57th Street | New York | NY | 10022 | |
20963 | 20963 | 1980-06-30 | 1977-09-07 | Leydon | Barry Nugent | Beef + Lamb New Zealand, Ltd. 2526 | 1974-07-08 | Beef + Lamb New Zealand, Ltd. | 6841 Elm Street | #7401 | McLean | VA | 22106 |
20950 | 20950 | 1980-06-30 | 1980-03-14 | Van Beek | Mariette M. | Arent Fox Kintner Plotkin & Kahn, PLLC 2661 | 1976-02-18 | Arent Fox Kintner Plotkin & Kahn, PLLC | 1050 Connecticut Ave., NW #500 | Washington | DC | 20036-5339 | |
20944 | 20944 | 1980-06-30 | 1980-01-08 | Cox | James O , III | Mel Anderson Communications, Inc. 3080 | 1980-01-08 | Mel Anderson Communications, Inc. | 6901 Corporate Drive | Suite 201 | Houston | TX | 77036 |
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]) );