FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where Short_Form_First_Name = "Andrea" and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 15
- Ogilvy Group LLC 2
- CIT Travel Service, Inc. 1
- Partido Revolucionario Cubano (Autentico) 1
- Partido Reformista Social Cristiano 1
- Quebec Government Office 1
- Barbados Investment & Development Corp. Barbados Tourism 1
- Enterprise Ireland 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Carl Byoir & Associates, Inc. 1
- Young & Rubicam, L.P. 1
- Deutsche Telekom, Inc. 1
- Ogilvy, Adams & Rinehart, Inc. 1
- Rubenstein Public Relations 1
- Ogilvy Group, LLC 1
- Media Planning International Corporation 1
Registrant_Name 15
- Ogilvy Group LLC 2
- Barbados Investment & Development Corp. Barbados Tourism 1
- CIT Travel Service, Inc. 1
- Carl Byoir & Associates, Inc. 1
- Deutsche Telekom, Inc. 1
- Enterprise Ireland 1
- Media Planning International Corporation 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Ogilvy Group, LLC 1
- Ogilvy, Adams & Rinehart, Inc. 1
- Partido Reformista Social Cristiano 1
- Partido Revolucionario Cubano (Autentico) 1
- Quebec Government Office 1
- Rubenstein Public Relations 1
- Young & Rubicam, L.P. 1
State 1
- NY · 16 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
78 | 78 | 2022-01-07 | Romero | Andrea | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
293 | 293 | 2018-02-02 | Townrow | Andrea | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 | |
2750 | 2750 | 1996-01-01 | 1991-09-12 | Axelrod | Andrea | 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 |
2827 | 2827 | 2004-01-01 | 1999-09-15 | Kavanagh | Andrea | Enterprise Ireland 2518 | 1974-06-08 | Enterprise Ireland | Ireland House | 345 Park Avenue, 17th Floor | New York | NY | 10154-0037 |
7365 | 7365 | 1974-02-22 | 1973-10-18 | Heyaime | Andrea | Partido Reformista Social Cristiano 1687 | 1964-02-05 | Partido Reformista Social Cristiano | 3736 10th Avenue | Suite 9A | New York | NY | 10034 |
8974 | 8974 | 1998-03-02 | 1996-04-04 | Strauss | Andrea | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
15230 | 15230 | 2021-04-30 | 2021-04-16 | Wang | Andrea | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | |
18792 | 18792 | 1952-06-04 | 1950-07-05 | Bendi | Andrea | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
20242 | 20242 | 1997-06-25 | 1990-12-28 | Axelrod | Andrea | Ogilvy, Adams & Rinehart, Inc. 4455 | 1990-12-28 | Ogilvy, Adams & Rinehart, Inc. | 708 Third Avenue | 12th Floor | New York | NY | 10017 |
21690 | 21690 | 2011-06-30 | 2011-11-03 | Franklin | Andrea | Barbados Investment & Development Corp. Barbados Tourism 1995 | 1966-11-30 | Barbados Investment & Development Corp. Barbados Tourism | 820 Second Avenue | 5th Floor | New York | NY | 10017 |
27169 | 27169 | 2019-08-21 | 2019-03-29 | Romero | Andrea | Ogilvy Group, LLC 6585 | 2018-08-30 | Ogilvy Group, LLC | 636 11th Avenue | New York | NY | 10036 | |
27303 | 27303 | 1965-08-24 | 1962-02-21 | Veliz | Andrea | Partido Revolucionario Cubano (Autentico) 1474 | 1961-08-24 | Partido Revolucionario Cubano (Autentico) | 90 St. Marks Avenue | Brooklyn | NY | ||
30995 | 30995 | 1986-09-30 | 1985-09-16 | Neukrug | Andrea | Carl Byoir & Associates, Inc. 3170 | 1980-11-24 | Carl Byoir & Associates, Inc. | 380 Madison Avenue | New York | NY | 10017 | |
35539 | 35539 | 1990-11-09 | 1988-11-18 | Demirjian | Andrea | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
38459 | 38459 | 2020-12-15 | 2019-03-08 | Lopez | Andrea | Media Planning International Corporation 6621 | 2018-12-21 | Media Planning International Corporation | c/o Havas Creative Group | 200 Hudson Street | New York | NY | 10013 |
38524 | 38524 | 2015-12-16 | 2015-08-07 | Landau | Andrea | Rubenstein Public Relations 6311 | 2015-08-07 | Rubenstein Public Relations | 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]) );