FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
23 rows where City = "New York" and Short_Form_First_Name = "Alan"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Address_1, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 21
- Hong Kong Trade Development Council, Inc. 2
- White & Case, LLP 2
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- McCann-Marschalk Company, Inc. 1
- Saxton Graphic Associates, Ltd. 1
- McCann-Erickson, Inc. 1
- Needham, Harper & Steers Advertising, Inc. 1
- M.J. Jacobs, Inc. 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Hill & Knowlton, Inc. 1
- Airbus Industrie of North America, Inc. 1
- Tele-Press Associates, Inc. 1
- Bozell, Jacobs, Kenyon & Eckhardt, Public Relations 1
- GCI Group, Inc. 1
- Bozell, Jacobs, Kenyon & Eckhardt, Public Relations 1
- Lord Group 1
- PR Consulting Group, Inc. 1
- Zemi Communications, L.L.C. 1
- Mediaedge: CIA, LLC 1
- PricewaterhouseCoopers, LLP ('PwC LLP") 1
- Visit Mexico USA, LLC 1
Registrant_Name 20
- Bozell, Jacobs, Kenyon & Eckhardt, Public Relations 2
- Hong Kong Trade Development Council, Inc. 2
- White & Case, LLP 2
- Airbus Industrie of North America, Inc. 1
- GCI Group, Inc. 1
- Hill & Knowlton, Inc. 1
- Lord Group 1
- M.J. Jacobs, Inc. 1
- McCann-Erickson, Inc. 1
- McCann-Marschalk Company, Inc. 1
- Mediaedge: CIA, LLC 1
- Needham, Harper & Steers Advertising, Inc. 1
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- PR Consulting Group, Inc. 1
- PricewaterhouseCoopers, LLP ('PwC LLP") 1
- Saxton Graphic Associates, Ltd. 1
- Tele-Press Associates, Inc. 1
- Visit Mexico USA, LLC 1
- Zemi Communications, L.L.C. 1
State 1
- NY 23
City 1
- New York · 23 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1945 | 1945 | 2022-10-12 | Segan | Alan | Visit Mexico USA, LLC 7184 | 2022-10-12 | Visit Mexico USA, LLC | 444 Madison Avenue | Suite 300 | New York | NY | 10022 | |
2754 | 2754 | 1996-01-01 | 1991-09-12 | Sprules | Alan | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 | 1974-08-12 | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. | 309 West 49th Street | Worldwide Plaza | New York | NY | 10019-7399 |
5220 | 5220 | 2000-01-31 | 1996-07-01 | Stoga | Alan | Zemi Communications, L.L.C. 5120 | 1996-07-01 | Zemi Communications, L.L.C. | 99 Madison Avenue | 2nd Floor | New York | NY | 10016-7419 |
7620 | 7620 | 1993-02-25 | 1992-01-24 | Prigge | Alan | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11102 | 11102 | 1962-03-30 | 1961-09-19 | Goff | Alan | McCann-Marschalk Company, Inc. 1477 | 1961-09-19 | McCann-Marschalk Company, Inc. | 1271 Avenue of the Americas | New York | NY | ||
13082 | 13082 | 1989-04-10 | 1987-06-11 | Haber | Alan | Bozell, Jacobs, Kenyon & Eckhardt, Public Relations 3778 | 1986-02-13 | Bozell, Jacobs, Kenyon & Eckhardt, Public Relations | 75 Rockefeller Plaza | 6th Floor | New York | NY | 10219 |
15354 | 15354 | 1981-05-01 | 1979-05-10 | Wong | Alan | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
18442 | 18442 | 1980-06-01 | 1978-06-27 | Lee | Alan | Airbus Industrie of North America, Inc. 2817 | 1977-08-02 | Airbus Industrie of North America, Inc. | 630 Fifth Avenue | New York | NY | 10111 | |
19235 | 19235 | 1987-06-11 | 1987-06-11 | Haber | Alan | Bozell, Jacobs, Kenyon & Eckhardt, Public Relations 3991 | 1987-06-11 | Bozell, Jacobs, Kenyon & Eckhardt, Public Relations | 6 East 43rd Street | New York | NY | 10017 | |
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 | |
23831 | 23831 | 1964-07-23 | 1963-06-07 | Halpern | Alan | Saxton Graphic Associates, Ltd. 1637 | 1963-06-07 | Saxton Graphic Associates, Ltd. | 614 Third Avenue | New York | NY | 10016 | |
24540 | 24540 | 1993-07-30 | 1990-03-21 | Dean | Alan | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
26565 | 26565 | 2011-08-13 | 2011-08-11 | Chu | Alan | PricewaterhouseCoopers, LLP ('PwC LLP") 6053 | 2011-08-11 | PricewaterhouseCoopers, LLP ('PwC LLP") | 300 Madison Avenue | New York | NY | 10017 | |
26971 | 26971 | 1995-08-18 | 1989-09-07 | Wong | Alan | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
27989 | 27989 | 1977-08-31 | 1968-09-20 | Fraser | Alan | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
28316 | 28316 | 1997-08-31 | 1991-09-19 | Beukes | Alan | Lord Group 4556 | 1991-08-14 | Lord Group | 810 Seventh Avenue | New York | NY | 10019 | |
30609 | 30609 | 1993-09-27 | 1992-02-11 | Metrick | Alan | PR Consulting Group, Inc. 4614 | 1992-02-11 | PR Consulting Group, Inc. | 540 Madison Avenue | New York | NY | 10022 | |
32009 | 32009 | 2006-10-01 | 2004-10-13 | Avery | Alan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32055 | 32055 | 2012-10-01 | 2011-10-31 | Gover | Alan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
33335 | 33335 | 1969-10-22 | 1966-09-14 | Richman | Alan | M.J. Jacobs, Inc. 1856 | 1965-02-16 | M.J. Jacobs, Inc. | 551 Fifth Avenue | New York | NY | 10017 | |
33398 | 33398 | 1986-10-22 | 1986-09-19 | Smith | Alan | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
41370 | 41370 | 2004-12-31 | 1977-09-30 | Macnow | Alan | Tele-Press Associates, Inc. 2832 | 1977-09-30 | Tele-Press Associates, Inc. | 321 East 53rd Street | New York | NY | 10022 | |
41483 | 41483 | 2005-12-31 | 2003-12-29 | Schanzer | Alan | Mediaedge: CIA, LLC 5605 | 2003-12-29 | Mediaedge: CIA, LLC | 825 Seventh Avenue | New York | NY | 10019 |
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]) );