FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
30 rows where City = "New York" and Short_Form_First_Name = "Frank"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date)
Registration_Number 27
- Australian Information Service 2
- British Information Services 2
- N.W. Ayer & Son, Inc. 2
- American Section of the Jewish Agency for Israel 1
- Chinese Information Service 1
- Centex, Inc. 1
- Communications Counselors, Inc. 1
- DDB Worldwide Communications Group, Inc. 1
- Forbes Research, Inc. 1
- Ruder Finn, Inc. 1
- Sontheimer Hazlett, Ltd. 1
- McCann-Erickson, Inc. 1
- Needham, Harper & Steers Advertising, Inc. 1
- IDA Ireland 1
- Association Films, Inc. 1
- Curacao Tourist Board Through Rendine Travel Associates, Inc 1
- Miles R. Grove, Inc. 1
- FCB New York 1
- National Federation of Coffee Growers of Colombia 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- White & Case, LLP 1
- Whitman & Ransom 1
- Villares Overseas Corporation 1
- Grey Advertising, Inc. 1
- Shandwick North America, Inc. 1
- Strategy XXI Group, Ltd. 1
- Arnold Worldwide/NY 1
Registrant_Name 27
- Australian Information Service 2
- British Information Services 2
- N.W. Ayer & Son, Inc. 2
- American Section of the Jewish Agency for Israel 1
- Arnold Worldwide/NY 1
- Association Films, Inc. 1
- Centex, Inc. 1
- Chinese Information Service 1
- Communications Counselors, Inc. 1
- Curacao Tourist Board Through Rendine Travel Associates, Inc 1
- DDB Worldwide Communications Group, Inc. 1
- FCB New York 1
- Forbes Research, Inc. 1
- Grey Advertising, Inc. 1
- IDA Ireland 1
- McCann-Erickson, Inc. 1
- Miles R. Grove, Inc. 1
- National Federation of Coffee Growers of Colombia 1
- Needham, Harper & Steers Advertising, Inc. 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Ruder Finn, Inc. 1
- Shandwick North America, Inc. 1
- Sontheimer Hazlett, Ltd. 1
- Strategy XXI Group, Ltd. 1
- Villares Overseas Corporation 1
- White & Case, LLP 1
- Whitman & Ransom 1
State 1
- NY 30
City 1
- New York · 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4082 | 4082 | 1965-01-19 | 1964-08-21 | Scheffey | Frank | Sontheimer Hazlett, Ltd. 1648 | 1963-07-19 | Sontheimer Hazlett, Ltd. | 275 Seventh Avenue | New York | NY | 100016788 | |
4417 | 4417 | 1990-01-25 | 1949-03-14 | Beswick | Frank | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
4616 | 4616 | 1981-01-27 | 1978-05-10 | Rendine | Frank | Curacao Tourist Board Through Rendine Travel Associates, Inc 2325 | 1972-03-02 | Curacao Tourist Board Through Rendine Travel Associates, Inc | 685 Fifth Avenue | New York | NY | 10022 | |
4786 | 4786 | 1964-01-30 | 1961-10-06 | Long | Frank | Australian Information Service 418 | 1946-12-31 | Australian Information Service | 636 Fifth Avenue | New York | NY | 10020 | |
5742 | 5742 | 1985-02-01 | 1981-02-11 | Turpin | Frank | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
9845 | 9845 | 2003-03-14 | 2002-06-05 | Fernandez | Frank | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
10077 | 10077 | 2002-03-16 | 1971-10-01 | Yahner | Frank | DDB Worldwide Communications Group, Inc. 1066 | 1957-09-16 | DDB Worldwide Communications Group, Inc. | 437 Madison Avenue | New York | NY | 10022 | |
10114 | 10114 | 1961-03-17 | 1947-07-25 | Mitchell | Frank | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
12872 | 12872 | 1992-04-07 | 1973-03-28 | Gromer | Frank | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
13620 | 13620 | 1984-04-17 | 1981-11-06 | Church | Frank | Whitman & Ransom 3296 | 1981-10-23 | Whitman & Ransom | 522 Fifth Avenue | New York | NY | 10036 | |
20130 | 20130 | 1970-06-24 | 1961-11-20 | Saunders | Frank | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
24515 | 24515 | 1992-07-30 | 1991-06-03 | Devaney | Frank | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
25488 | 25488 | 1972-08-01 | 1972-08-01 | Marciuliano | Frank | Miles R. Grove, Inc. 2363 | 1972-08-01 | Miles R. Grove, Inc. | 128 East 38th Street | New York | NY | 10016 | |
25538 | 25538 | 1985-08-01 | 1982-09-27 | Gentile | Frank | N.W. Ayer & Son, Inc. 3411 | 1982-09-27 | N.W. Ayer & Son, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
25842 | 25842 | 1963-08-03 | 1960-02-26 | Rothman | Frank | Forbes Research, Inc. 1197 | 1959-02-03 | Forbes Research, Inc. | 70 Fifth Avenue | New York | NY | ||
25910 | 25910 | 1959-08-04 | 1957-02-04 | Hefter | Frank | Communications Counselors, Inc. 996 | 1957-02-04 | Communications Counselors, Inc. | 750 Third Avenue | New York | NY | ||
27960 | 27960 | 1977-08-31 | 1967-06-19 | Broadhurst | Frank | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
28014 | 28014 | 1980-08-31 | 1974-06-10 | Fernandez | Frank | National Federation of Coffee Growers of Colombia 2519 | 1974-06-10 | National Federation of Coffee Growers of Colombia | 140 East 57th Street | New York | NY | 10022 | |
28045 | 28045 | 1981-08-31 | 1973-09-06 | Wolf | Frank | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | 347 Madison Avenue | New York | NY | 10017 | |
28382 | 28382 | 2001-08-31 | 2002-02-11 | Clarke | Frank | Strategy XXI Group, Ltd. 5273 | 1998-09-01 | Strategy XXI Group, Ltd. | 515 Madison Avenue | 34th Floor | New York | NY | 10022 |
29324 | 29324 | 1989-09-07 | 1982-09-27 | DeFilippo | Frank | N.W. Ayer & Son, Inc. 3411 | 1982-09-27 | N.W. Ayer & Son, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
29504 | 29504 | 1956-09-10 | 1955-08-05 | Hefter | Frank | Australian Information Service 418 | 1946-12-31 | Australian Information Service | 636 Fifth Avenue | New York | NY | 10020 | |
29733 | 29733 | 1992-09-14 | 1991-09-12 | Sommerfield | Frank | 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 |
30335 | 30335 | 1951-09-24 | 1949-11-03 | Hlina | Frank | Centex, Inc. 598 | 1949-11-03 | Centex, Inc. | 465 Lexington Avenue | New York | NY | ||
32001 | 32001 | 2006-10-01 | 2003-06-03 | Panopoulos | Frank | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
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 | |
32507 | 32507 | 1991-10-09 | 1990-10-09 | Clarke | Frank | Grey Advertising, Inc. 4420 | 1990-10-09 | Grey Advertising, Inc. | 777 Third Avenue | New York | NY | 10017 | |
33604 | 33604 | 1985-10-25 | 1983-09-29 | Delzio | Frank | Villares Overseas Corporation 3523 | 1983-09-29 | Villares Overseas Corporation | 630 Fifth Avenue | Suite 1750 | New York | NY | 10111 |
33879 | 33879 | 1971-10-29 | 1950-05-05 | Stein | Frank | American Section of the Jewish Agency for Israel 208 | 1943-09-14 | American Section of the Jewish Agency for Israel | 515 Park Avenue | New York | NY | 10022 | |
37714 | 37714 | 1958-12-04 | 1946-11-26 | Tao | Frank | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 |
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]) );