FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
39 rows where Short_Form_First_Name = "Susan" and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Short_Form_Termination_Date (date)
Registration_Number 29
- GCI Group, Inc. 4
- Daniel J. Edelman, Inc. 3
- Ruder Finn, Inc. 2
- Quebec Government Office 2
- Saatchi & Saatchi North America, Inc. 2
- McCann Direct, Inc. 2
- Richartz Fliss Clark & Pope, Inc. 2
- Spanish National Tourist Office, New York 1
- JETRO, New York 1
- Sontheimer Hazlett, Ltd. 1
- Peter Rothholz Associates, Inc. 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
- Conant & Company Public Relations, Inc. 1
- Cannon Advertising Associates, Inc. 1
- Government of Ontario, Canada 1
- Tromson Monroe Advertising, Inc. 1
- Singapore Tourism Board 1
- Cayman Islands Department of Tourism 1
- Young & Rubicam, L.P. 1
- Marketshare 1
- Teddy Kollek for Mayor 1
- Young & Rubicam, New York 1
- Lord Group 1
- Teddy Kollek for Mayor 1
- Arnold Worldwide/NY 1
- Mediaedge: CIA, LLC 1
- Ketchum Inc. NY 1
- Ogilvy Group LLC 1
- Group M Worldwide, LLC 1
Registrant_Name 28
- GCI Group, Inc. 4
- Daniel J. Edelman, Inc. 3
- McCann Direct, Inc. 2
- Quebec Government Office 2
- Richartz Fliss Clark & Pope, Inc. 2
- Ruder Finn, Inc. 2
- Saatchi & Saatchi North America, Inc. 2
- Teddy Kollek for Mayor 2
- Arnold Worldwide/NY 1
- Cannon Advertising Associates, Inc. 1
- Cayman Islands Department of Tourism 1
- Conant & Company Public Relations, Inc. 1
- Government of Ontario, Canada 1
- Group M Worldwide, LLC 1
- JETRO, New York 1
- Ketchum Inc. NY 1
- Lord Group 1
- Marketshare 1
- Mediaedge: CIA, LLC 1
- Ogilvy Group LLC 1
- Peter Rothholz Associates, Inc. 1
- Singapore Tourism Board 1
- Sontheimer Hazlett, Ltd. 1
- Spanish National Tourist Office, New York 1
- Tromson Monroe Advertising, Inc. 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
- Young & Rubicam, L.P. 1
- Young & Rubicam, New York 1
State 1
- NY · 39 ✖
City 1
- New York 39
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1656 | 1656 | 2022-08-22 | Schiekofer | Susan | Group M Worldwide, LLC 7160 | 2022-08-22 | Group M Worldwide, LLC | 175 Greenwich Street | New York | NY | 10007 | ||
2031 | 2031 | 2022-10-25 | Szymanski | Susan | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
5107 | 5107 | 1992-01-31 | 1990-08-03 | Eisenstat | Susan | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
5108 | 5108 | 1992-01-31 | 1991-08-06 | Chamberlin | Susan | Young & Rubicam, New York 4554 | 1991-08-06 | Young & Rubicam, New York | 285 Madison Avenue | New York | NY | 100176486 | |
5756 | 5756 | 1988-02-01 | 1987-02-13 | Migliaccio | Susan | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | Saatchi & Saatchi Building | 375 Hudson Street, 10th Floor | New York | NY | 10014-3620 |
8759 | 8759 | 1985-03-01 | 1982-11-24 | Mark | Susan | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
10212 | 10212 | 1985-03-18 | 1978-05-10 | Spiegel | Susan | Cannon Advertising Associates, Inc. 1945 | 1965-12-14 | Cannon Advertising Associates, Inc. | 444 Madison Avenue | Suite 301 | New York | NY | 10022 |
10330 | 10330 | 2004-03-19 | 1999-08-20 | Deacy | Susan | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
10463 | 10463 | 1994-03-21 | 1993-08-30 | Lipton | Susan | Teddy Kollek for Mayor 4828 | 1993-07-09 | Teddy Kollek for Mayor | 635 Madison Avenue | New York | NY | 10022 | |
10869 | 10869 | 1987-03-27 | 1986-02-07 | Rike | Susan | Marketshare 3775 | 1986-02-07 | Marketshare | 41 Madison Avenue | New York | NY | 10010 | |
11146 | 11146 | 1990-03-30 | 1988-08-02 | Lipton | Susan | Teddy Kollek for Mayor 4164 | 1988-08-02 | Teddy Kollek for Mayor | 635 Madison Avenue | New York | NY | 10022 | |
11178 | 11178 | 1996-03-30 | 1995-04-28 | Hirsch | Susan | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
11708 | 11708 | 1995-03-31 | 1992-01-30 | McNamara | Susan | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
15989 | 15989 | 2012-05-09 | 2008-03-20 | Kauffman | Susan | Richartz Fliss Clark & Pope, Inc. 5623 | 2004-05-18 | Richartz Fliss Clark & Pope, Inc. | 305 Madison Avenue | Suite 2145 | New York | NY | 10165 |
15996 | 15996 | 2012-05-09 | 2004-05-18 | McGill | Susan | Richartz Fliss Clark & Pope, Inc. 5623 | 2004-05-18 | Richartz Fliss Clark & Pope, Inc. | 305 Madison Avenue | Suite 2145 | New York | NY | 10165 |
17706 | 17706 | 1987-05-31 | 1986-11-10 | Wagner | Susan | Tromson Monroe Advertising, Inc. 2403 | 1973-01-09 | Tromson Monroe Advertising, Inc. | 450 Park Avenue, South | New York | NY | 10016 | |
17797 | 17797 | 1995-05-31 | 1994-02-24 | Migliaccio | Susan | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | Saatchi & Saatchi Building | 375 Hudson Street, 10th Floor | New York | NY | 10014-3620 |
19724 | 19724 | 2010-06-16 | 2004-12-20 | Lawson | Susan | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
20563 | 20563 | 1996-06-29 | 1996-08-12 | Waldman | Susan | McCann Direct, Inc. 3922 | 1986-12-29 | McCann Direct, Inc. | 750 Third Avenue | New York | NY | 10017 | |
23593 | 23593 | 1964-07-19 | 1963-07-19 | Baumgartner | Susan | Sontheimer Hazlett, Ltd. 1648 | 1963-07-19 | Sontheimer Hazlett, Ltd. | 275 Seventh Avenue | New York | NY | 100016788 | |
26650 | 26650 | 2018-08-14 | 2015-04-13 | Krulic | Susan | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | 589 5th Avenue | Suite 1702 | New York | NY | 10017 |
27221 | 27221 | 2001-08-22 | 1999-08-11 | Radd | Susan | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
28318 | 28318 | 1997-08-31 | 1991-09-19 | Funkhouser | Susan | Lord Group 4556 | 1991-08-14 | Lord Group | 810 Seventh Avenue | New York | NY | 10019 | |
29273 | 29273 | 1988-09-06 | 1988-04-08 | Kaplan | Susan | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
30252 | 30252 | 1965-09-22 | 1964-03-04 | Folkman | Susan | Peter Rothholz Associates, Inc. 1692 | 1964-02-18 | Peter Rothholz Associates, Inc. | 369 Lexington Avenue | New York | NY | 10017 | |
32221 | 32221 | 2008-10-03 | 2007-02-06 | Molinari | Susan | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
32700 | 32700 | 1994-10-12 | 1993-10-25 | Halstead | Susan | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
33306 | 33306 | 1993-10-21 | 1991-01-29 | Mitchell | Susan | McCann Direct, Inc. 3922 | 1986-12-29 | McCann Direct, Inc. | 750 Third Avenue | New York | NY | 10017 | |
33502 | 33502 | 1992-10-23 | 1986-12-02 | Baldwin | Susan | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
33792 | 33792 | 1993-10-28 | 1990-11-13 | Roberts | Susan | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
35732 | 35732 | 2013-11-13 | 2011-01-20 | Belanich | Susan | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36153 | 36153 | 1979-11-21 | 1979-04-12 | Wilsin | Susan | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
38547 | 38547 | 1991-12-17 | 1989-09-07 | Purdy | Susan | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
38662 | 38662 | 2000-12-18 | 1992-10-09 | Sattell | Susan | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
39787 | 39787 | 1965-12-31 | 1965-05-27 | Baumgartner | Susan | Conant & Company Public Relations, Inc. 1896 | 1965-05-27 | Conant & Company Public Relations, Inc. | 10 East 40th Street | New York | NY | ||
39854 | 39854 | 1967-12-31 | 1966-04-15 | Baumgartner | Susan | Spanish National Tourist Office, New York 538 | 1948-09-14 | Spanish National Tourist Office, New York | 665 Fifth Avenue | New York | NY | 10022 | |
40748 | 40748 | 1992-12-31 | 1978-08-06 | Sanders | Susan | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | 7 Dey Street | New York | NY | 10017 | |
41405 | 41405 | 2005-12-31 | 2004-03-25 | Thomas | Susan | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
41475 | 41475 | 2005-12-31 | 2003-12-29 | Chamberlin | Susan | 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]) );