FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where Short_Form_Last_Name = "Rosenthal"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 16
- Central Parcel Service, Inc. 3
- Pan-American Coffee Bureau 1
- Squire Patton Boggs, LLP 1
- Kekst & Company 1
- Gadsby & Hannah 1
- Seyfarth, Shaw, Fairweather & Geraldson 1
- Sutherland, Asbill & Brennan 1
- Promotional Concept Group, Inc. 1
- Sutherland, Asbill & Brennan 1
- Berliner, Corcoran & Rowe 1
- Saatchi & Saatchi North America, Inc. 1
- Coudert Brothers 1
- Dyer, Ellis & Joseph, P.C. 1
- Cahill, Gordon & Reindel 1
- Dilenschneider Group 1
- Ogilvy Public Relations 1
Registrant_Name 15
- Central Parcel Service, Inc. 3
- Sutherland, Asbill & Brennan 2
- Berliner, Corcoran & Rowe 1
- Cahill, Gordon & Reindel 1
- Coudert Brothers 1
- Dilenschneider Group 1
- Dyer, Ellis & Joseph, P.C. 1
- Gadsby & Hannah 1
- Kekst & Company 1
- Ogilvy Public Relations 1
- Pan-American Coffee Bureau 1
- Promotional Concept Group, Inc. 1
- Saatchi & Saatchi North America, Inc. 1
- Seyfarth, Shaw, Fairweather & Geraldson 1
- Squire Patton Boggs, LLP 1
City 5
- New York 7
- Washington 6
- Chicago 3
- Boston 1
- Washington, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2685 | 2685 | 1989-01-01 | 1981-11-20 | Rosenthal | Douglas E. | Sutherland, Asbill & Brennan 3307 | 1981-11-20 | Sutherland, Asbill & Brennan | 1275 Pennsylvania Avenue, N.W. | Washington | DC | 20004-2404 | |
3437 | 3437 | 1996-01-08 | 1992-07-30 | Rosenthal | Linda K. | Dyer, Ellis & Joseph, P.C. 4121 | 1988-03-21 | Dyer, Ellis & Joseph, P.C. | 600 New Hampshire Avenue, N.W. | Suite 1000 | Washington | DC | 20037 |
4692 | 4692 | 1985-01-28 | 1974-09-20 | Rosenthal | Abraham | Central Parcel Service, Inc. 483 | 1947-07-31 | Central Parcel Service, Inc. | 220 South State Street | Chicago | IL | 60604 | |
4693 | 4693 | 1985-01-28 | 1974-09-20 | Rosenthal | Ann | Central Parcel Service, Inc. 483 | 1947-07-31 | Central Parcel Service, Inc. | 220 South State Street | Chicago | IL | 60604 | |
6508 | 6508 | 1984-02-10 | 1983-08-10 | Rosenthal | Philip | Promotional Concept Group, Inc. 3383 | 1982-06-16 | Promotional Concept Group, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
7068 | 7068 | 1989-02-16 | 1980-06-11 | Rosenthal | Gerald A. | Gadsby & Hannah 2914 | 1978-06-12 | Gadsby & Hannah | 1 Post Office Square | Boston | MA | 02109 | |
7114 | 7114 | 1995-02-16 | 1983-02-16 | Rosenthal | Donald L. | Seyfarth, Shaw, Fairweather & Geraldson 3122 | 1980-07-18 | Seyfarth, Shaw, Fairweather & Geraldson | 815 Connecticut Avenue, N.W. | Suite 500 | Washington | DC | 20006-4004 |
13276 | 13276 | 1970-04-13 | 1961-10-23 | Rosenthal | Abraham Israel | Central Parcel Service, Inc. 483 | 1947-07-31 | Central Parcel Service, Inc. | 220 South State Street | Chicago | IL | 60604 | |
13316 | 13316 | 1983-04-14 | 1983-03-09 | Rosenthal | Douglas E. | Sutherland, Asbill & Brennan 3450 | 1983-03-09 | Sutherland, Asbill & Brennan | 1666 K Street, N.W. | Washington | DC | 20006 | |
16583 | 16583 | 1979-05-17 | 1975-10-15 | Rosenthal | Leslie J. | Kekst & Company 2618 | 1975-10-15 | Kekst & Company | 450 Park Avenue | New York | NY | 10022 | |
17791 | 17791 | 1995-05-31 | 1993-02-24 | Rosenthal | Richard | 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 |
21221 | 21221 | 1995-06-30 | 1994-06-17 | Rosenthal | Thorn | Cahill, Gordon & Reindel 4920 | 1994-06-17 | Cahill, Gordon & Reindel | 80 Pine Street | New York | NY | 10005 | |
22270 | 22270 | 1997-07-01 | 1997-06-27 | Rosenthal | James Edward | Dilenschneider Group 5188 | 1997-06-27 | Dilenschneider Group | 200 Park Avenue | 26th Floor | New York | NY | 10166 |
30126 | 30126 | 1990-09-20 | 1985-12-27 | Rosenthal | Jay A. | Berliner, Corcoran & Rowe 3512 | 1983-08-22 | Berliner, Corcoran & Rowe | 1101 - 17th Street, N.W. | Suite 1004 | Washington | DC | 200364798 |
33716 | 33716 | 1994-10-27 | 1989-11-03 | Rosenthal | Douglas E. | Coudert Brothers 3743 | 1985-10-02 | Coudert Brothers | 1627 I Street, N. W. | Suite 1200 | Washington, | DC | 20006 |
34705 | 34705 | 2017-10-31 | 2015-11-05 | Rosenthal | Samuel | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
40055 | 40055 | 1977-12-31 | 1946-12-06 | Rosenthal | Jacob | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | 1350 Avenue of the Americas | New York | NY | 10019 | |
42065 | 42065 | 2016-12-31 | 2016-09-15 | Rosenthal | David | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 |
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]) );