FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
36 rows where Short_Form_First_Name = "Andrea"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 30
- Hill and Knowlton Strategies, LLC 3
- Daniel J. Edelman, Inc. 2
- Invest Northern Ireland 2
- Ogilvy Public Relations Worldwide 2
- Ogilvy Group LLC 2
- CIT Travel Service, Inc. 1
- Partido Revolucionario Cubano (Autentico) 1
- Partido Reformista Social Cristiano 1
- Arnold & Porter Kaye Scholer LLP 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
- Philip Manuel Resource Group, Ltd. 1
- Peter Martin Associates, Inc. 1
- Deutsche Telekom, Inc. 1
- YHDA International 1
- Ogilvy, Adams & Rinehart, Inc. 1
- Boasberg Valentine-Radford, Inc. 1
- Troutman Sanders, LLP 1
- Manning, Selvage & Lee 1
- M+R Strategic Services 1
- Rubenstein Public Relations 1
- Stroud Communications 1
- MMGY Global, LLC 1
- Ogilvy Group, LLC 1
- Media Planning International Corporation 1
- Birdsall, Voss & Associates, Inc. ("BVK") 1
Registrant_Name 30
- Hill and Knowlton Strategies, LLC 3
- Daniel J. Edelman, Inc. 2
- Invest Northern Ireland 2
- Ogilvy Group LLC 2
- Ogilvy Public Relations Worldwide 2
- Arnold & Porter Kaye Scholer LLP 1
- Barbados Investment & Development Corp. Barbados Tourism 1
- Birdsall, Voss & Associates, Inc. ("BVK") 1
- Boasberg Valentine-Radford, Inc. 1
- CIT Travel Service, Inc. 1
- Carl Byoir & Associates, Inc. 1
- Deutsche Telekom, Inc. 1
- Enterprise Ireland 1
- M+R Strategic Services 1
- MMGY Global, LLC 1
- Manning, Selvage & Lee 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
- Peter Martin Associates, Inc. 1
- Philip Manuel Resource Group, Ltd. 1
- Quebec Government Office 1
- Rubenstein Public Relations 1
- Stroud Communications 1
- Troutman Sanders, LLP 1
- YHDA International 1
- Young & Rubicam, L.P. 1
City 10
- New York 15
- Washington 11
- Bannockburn 2
- Chicago 2
- Brooklyn 1
- Concord 1
- Kansas City 1
- Milwaukee 1
- Overland Park 1
- Stamford 1
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 | |
2486 | 2486 | 2007-12-31 | Haughian | Andrea | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 | |
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 |
5874 | 5874 | 2013-02-01 | 2013-03-15 | Shatzman | Andrea | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
6870 | 6870 | 2003-02-14 | 2000-11-16 | Wedderburn | Andrea | Manning, Selvage & Lee 5397 | 2000-11-16 | Manning, Selvage & Lee | 1133 21st Street, N.W. | Suite 300 | Washington | DC | 20036 |
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 |
9979 | 9979 | 1998-03-15 | 1990-09-11 | Strout | Andrea | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
14906 | 14906 | 2003-04-30 | 2002-07-15 | Hutchinson | Andrea | Peter Martin Associates, Inc. 4236 | 1989-04-05 | Peter Martin Associates, Inc. | 800 Summer Street | Suite 521 | Stamford | CT | 06901-1051 |
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 | |
15491 | 15491 | 2013-05-01 | 2012-06-29 | Wuebker | Andrea | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
15608 | 15608 | 2016-05-02 | 2015-06-30 | Barnetche | Andrea | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
17360 | 17360 | 2001-05-29 | 1998-11-30 | Schepke | Andrea | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18043 | 18043 | 2008-05-31 | 2007-06-06 | Frazer | Andrea | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
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 | |
20029 | 20029 | 1988-06-22 | 1986-12-19 | Boggs | Andrea | Philip Manuel Resource Group, Ltd. 3919 | 1986-12-19 | Philip Manuel Resource Group, Ltd. | 1747 Pennsylvania Avenue, N.W. | Suite 701 | Washington | DC | 20006 |
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 |
21253 | 21253 | 1996-06-30 | 1996-11-21 | Kirkbride | Andrea | YHDA International 4421 | 1990-10-12 | YHDA International | 28 Junction Square | Concord | MA | 01742 | |
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 |
24261 | 24261 | 2022-07-27 | 2022-07-27 | Holschuh Argires | Andrea | Birdsall, Voss & Associates, Inc. ("BVK") 7147 | 2022-07-27 | Birdsall, Voss & Associates, Inc. ("BVK") | 250 W. Coventry Court | Milwaukee | WI | 53217 | |
25127 | 25127 | 2008-07-31 | 2008-06-03 | Koppel-Pollack | Andrea | M+R Strategic Services 5829 | 2007-09-19 | M+R Strategic Services | 2120 L Street, NW | Suite 600 | Washington | DC | 20037 |
26079 | 26079 | 1975-08-06 | 1975-01-14 | Lange | Andrea | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
27082 | 27082 | 2004-08-20 | 2004-06-10 | Sarubbi | Andrea | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
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 | ||
27371 | 27371 | 2021-08-24 | 2019-01-14 | Gaggioni | Andrea | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
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 | |
31281 | 31281 | 2001-09-30 | 1999-09-29 | Rimer | Andrea | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
32578 | 32578 | 1991-10-10 | 1991-04-01 | Hodges | Andrea | Boasberg Valentine-Radford, Inc. 4492 | 1991-04-01 | Boasberg Valentine-Radford, Inc. | 4600 Madison Avenue | Kansas City | MO | 64112 | |
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 | |
35927 | 35927 | 2017-11-15 | 2017-09-29 | Stroud | Andrea | Stroud Communications 6471 | 2017-09-29 | Stroud Communications | 4427 WESTOVER PL NW | Washington | DC | 20016 | |
37161 | 37161 | 2020-11-30 | 2020-09-14 | Yu | Andrea | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
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]) );