FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Short_Form_Last_Name = "Mayer"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Date (date)
Registration_Number 12
- Austrian Trade Commission, New York 1
- Communications Counselors, Inc. 1
- Partido Reformista Social Cristiano 1
- Quebec Government Office 1
- Mayer & O'Brien, Inc. 1
- Colombian Government Trade Bureau 1
- Squire Patton Boggs, LLP 1
- Mayer & O'Brien, Inc. 1
- Burson-Marsteller 1
- Hoppel, Mayer & Coleman 1
- 42West, LLC 1
- 42West, LLC 1
Registrant_Name 10
City 4
- New York 6
- Washington 3
- Chicago 2
- Los Angeles 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5695 | 5695 | 1973-02-01 | 1970-12-28 | Mayer | Terry | Colombian Government Trade Bureau 2121 | 1969-01-30 | Colombian Government Trade Bureau | 140 East 57th Street | New York | NY | 10022 | |
5703 | 5703 | 1974-02-01 | 1973-09-12 | Mayer | Howard | Mayer & O'Brien, Inc. 2461 | 1973-09-12 | Mayer & O'Brien, Inc. | 333 North Michigan Avenue | Chicago | IL | 60601 | |
6186 | 6186 | 2002-02-05 | 1972-03-21 | Mayer | Rafael E. Almonte | Partido Reformista Social Cristiano 1687 | 1964-02-05 | Partido Reformista Social Cristiano | 3736 10th Avenue | Suite 9A | New York | NY | 10034 |
13397 | 13397 | 1983-04-15 | 1980-04-01 | Mayer | Dr. Walter H. | Austrian Trade Commission, New York 625 | 1950-05-11 | Austrian Trade Commission, New York | 150 East 52nd Street | 32nd Floor | New York | NY | 10022 |
16888 | 16888 | 1992-05-22 | 1992-04-06 | Mayer | Lisa M. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
23783 | 23783 | 1986-07-22 | 1986-05-08 | Mayer | Dean | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
29309 | 29309 | 1983-09-07 | 1982-09-27 | Mayer | Lambert | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
30813 | 30813 | 1958-09-30 | 1958-04-04 | Mayer | Edward Newton , Jr. | Communications Counselors, Inc. 996 | 1957-02-04 | Communications Counselors, Inc. | 750 Third Avenue | New York | NY | ||
33097 | 33097 | 2019-10-17 | 2019-07-09 | Mayer | Allan | 42West, LLC 6680 | 2019-05-18 | 42West, LLC | 600 Third Avenue | 23rd Floor | New York | NY | 10016 |
38127 | 38127 | 2008-12-11 | 2008-12-11 | Mayer | Allan | 42West, LLC 5899 | 2008-12-11 | 42West, LLC | 11400 W.Olympic Boulevard | Suite 1100 | Los Angeles | CA | 90064 |
38271 | 38271 | 1964-12-14 | 1964-12-14 | Mayer | Howard Gerson | Mayer & O'Brien, Inc. 1831 | 1964-12-14 | Mayer & O'Brien, Inc. | 333 North Michigan Avenue | Room 1500 | Chicago | IL | 60601 |
38549 | 38549 | 1992-12-17 | 1983-05-20 | Mayer | Neal M. | Hoppel, Mayer & Coleman 3470 | 1983-05-20 | Hoppel, Mayer & Coleman | 1000 Connecticut Avenue, N.W. | Suite 410 | Washington | DC | 20036 |
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]) );