FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where City = "New York" and Short_Form_First_Name = "Nancy"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 11
- FCB New York 2
- New York Bureau of the Telegraph Agency of Russia (TASS) 1
- McCann-Erickson, Inc. 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Dominican Tourist Information Center, Inc. 1
- Dorf & Stanton Communications 1
- Agendas International, Inc. 1
- Howard J. Rubenstein Associates, Inc. 1
- G.S. Schwartz & Company, Inc. 1
- Rubenstein Associates, Inc. 1
- Ketchum Inc. NY 1
Registrant_Name 11
- FCB New York 2
- Agendas International, Inc. 1
- Dominican Tourist Information Center, Inc. 1
- Dorf & Stanton Communications 1
- G.S. Schwartz & Company, Inc. 1
- Howard J. Rubenstein Associates, Inc. 1
- Ketchum Inc. NY 1
- McCann-Erickson, Inc. 1
- New York Bureau of the Telegraph Agency of Russia (TASS) 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Rubenstein Associates, Inc. 1
State 1
- NY 12
City 1
- New York · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2943 | 2943 | 2016-01-01 | 2010-05-28 | Martira | Nancy | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
7993 | 7993 | 1992-02-28 | 1990-04-27 | Brenner | Nancy | G.S. Schwartz & Company, Inc. 4370 | 1990-04-27 | G.S. Schwartz & Company, Inc. | One Madison Avenue | New York | NY | 10010 | |
9963 | 9963 | 1993-03-15 | 1992-03-12 | Israel | Nancy | 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 |
13570 | 13570 | 1992-04-16 | 1980-06-24 | Freidman | Nancy | Dominican Tourist Information Center, Inc. 3114 | 1980-06-24 | Dominican Tourist Information Center, Inc. | 485 Madison Avenue | New York | NY | 10022 | |
13634 | 13634 | 1988-04-17 | 1985-05-08 | Strogoff | Nancy | Agendas International, Inc. 3524 | 1983-09-30 | Agendas International, Inc. | 820 Second Avenue | Suite 600 | New York | NY | 10017 |
17982 | 17982 | 2005-05-31 | 1993-03-12 | Haberman | Nancy | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | 1345 Avenue of the Americas | 30th Floor | New York | NY | 10105-0109 |
22302 | 22302 | 2003-07-01 | 2002-10-08 | Anderson | Nancy | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
26920 | 26920 | 1985-08-18 | 1951-08-13 | Bell | Nancy | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | 1947-06-03 | New York Bureau of the Telegraph Agency of Russia (TASS) | 50 Rockefeller Plaza | New York | NY | 10020 | |
27944 | 27944 | 1977-08-31 | 1975-03-28 | Fisher | Nancy | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
32247 | 32247 | 1988-10-04 | 1985-06-18 | Scribner | Nancy | Dorf & Stanton Communications 3471 | 1983-05-17 | Dorf & Stanton Communications | 111 Fifth Avenue | New York | NY | 10033 | |
38439 | 38439 | 2014-12-15 | 1985-09-30 | Beck | Nancy | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
38993 | 38993 | 1986-12-23 | 1985-12-10 | Haberman | Nancy | Howard J. Rubenstein Associates, Inc. 3761 | 1985-12-10 | Howard J. Rubenstein Associates, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 |
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]) );