FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Short_Form_First_Name = "Joe"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 14
- Mexican Chamber of Commerce, Inc., Chicago 1
- FCB New York 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Peter Martin Associates, Inc. 1
- Bozell & Jacobs, Inc. 1
- Saatchi & Saatchi North America, Inc. 1
- Schmertz Company, Inc. 1
- Rockey Company, Inc. 1
- Russo Marsh & Rogers 1
- Public Strategies, Inc. 1
- Ogilvy Public Relations Worldwide 1
- Foley Federal & International Affairs 1
- MKW Group, LLC 1
- Trippi & Associates 1
Registrant_Name 14
- Bozell & Jacobs, Inc. 1
- FCB New York 1
- Foley Federal & International Affairs 1
- MKW Group, LLC 1
- Mexican Chamber of Commerce, Inc., Chicago 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Ogilvy Public Relations Worldwide 1
- Peter Martin Associates, Inc. 1
- Public Strategies, Inc. 1
- Rockey Company, Inc. 1
- Russo Marsh & Rogers 1
- Saatchi & Saatchi North America, Inc. 1
- Schmertz Company, Inc. 1
- Trippi & Associates 1
City 8
- New York 4
- Washington 4
- Austin 1
- Chicago 1
- Houston 1
- Potomac 1
- Sacramento 1
- Seattle 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3500 | 3500 | 2015-01-09 | Foley | Joe | Foley Federal & International Affairs 6239 | 2014-08-05 | Foley Federal & International Affairs | P.O. Box 61303 | Potomac | MD | 20859 | ||
4345 | 4345 | 1992-01-24 | 1989-02-15 | DiSalvo | Joe | 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 |
4579 | 4579 | 2000-01-26 | 1994-05-10 | Goldstein | Joe | Schmertz Company, Inc. 4161 | 1988-07-26 | Schmertz Company, Inc. | 2919 Ellicott Street, N.W. | Washington | DC | 20008 | |
7888 | 7888 | 1981-02-28 | 1981-01-22 | Abrams | Joe | Peter Martin Associates, Inc. 2846 | 1977-11-15 | Peter Martin Associates, Inc. | 770 Lexington Avenue | New York | NY | 10021 | |
8908 | 8908 | 2017-03-01 | 2015-09-03 | Williams | Joe | MKW Group, LLC 6318 | 2015-09-03 | MKW Group, LLC | 1425 K Street. NW | Suite 350 | Washington | DC | 20005 |
9599 | 9599 | 1948-03-11 | 1946-07-13 | Goldstone | Joe | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
12218 | 12218 | 2018-03-31 | 2018-01-24 | Trippi | Joe | Trippi & Associates 6515 | 2018-01-24 | Trippi & Associates | 1133 15th Street, NW | 8th Floor | Washington | DC | 20005 |
14209 | 14209 | 2000-04-27 | 1989-01-19 | Catena | Joe | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
18005 | 18005 | 2006-05-31 | 2005-05-10 | Wierzbicki | Joe | Russo Marsh & Rogers 5682 | 2005-05-10 | Russo Marsh & Rogers | 770 L Street | # 950 | Sacramento | CA | 95814 |
23214 | 23214 | 1981-07-15 | 1981-07-15 | Slade | Joe | Bozell & Jacobs, Inc. 3259 | 1981-07-15 | Bozell & Jacobs, Inc. | 2 Allen Center | Suite 2000 | Houston | TX | 77002 |
25807 | 25807 | 2005-08-02 | 2005-06-24 | Emery | Joe | Public Strategies, Inc. 5689 | 2005-06-22 | Public Strategies, Inc. | 98 Jacinto Boulevard | Suite 1200 | Austin | TX | 78701 |
35768 | 35768 | 2008-11-14 | 2007-05-07 | Snodgrass | Joe | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
36381 | 36381 | 1998-11-25 | 1997-06-27 | Quintana | Joe | Rockey Company, Inc. 4594 | 1991-11-14 | Rockey Company, Inc. | 2121 Fifth Avenue | Seattle | WA | 98121 | |
40310 | 40310 | 1985-12-31 | 1982-01-12 | Kilgore | Joe | 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 |
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]) );