FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Short_Form_Last_Name = "Rowan"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 10
- Daniel J. Edelman, Inc. 2
- Squire, Sanders & Dempsey, L.L.P. 1
- Wolf Shevack, Inc. 1
- Burson-Marsteller 1
- Public Affairs Analysts, Inc. 1
- Public Affairs Analysts, Inc. 1
- Saatchi & Saatchi North America, Inc. 1
- Hyjek & Fix, Inc. 1
- Sedam & Emerson, a Professional Corporation 1
- Cassidy & Associates, Inc. 1
Registrant_Name 9
City 4
- New York 4
- Washington 4
- Chicago 2
- Fairfax 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3766 | 3766 | 1975-01-15 | 1961-03-28 | Rowan | Russell C. | Wolf Shevack, Inc. 1436 | 1961-03-28 | Wolf Shevack, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
13992 | 13992 | 1988-04-23 | 1987-05-19 | Rowan | Keith P. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
15912 | 15912 | 1978-05-08 | 1978-01-04 | Rowan | David W. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
17677 | 17677 | 1984-05-31 | 1984-02-07 | Rowan | Michael | Public Affairs Analysts, Inc. 3558 | 1984-02-07 | Public Affairs Analysts, Inc. | 342 Madison Avenue | Suite 1512 | New York | NY | 10173 |
17818 | 17818 | 1995-05-31 | 1984-07-24 | Rowan | Mary | 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 |
19411 | 19411 | 1982-06-14 | 1981-05-11 | Rowan | Michael | Public Affairs Analysts, Inc. 2726 | 1976-10-18 | Public Affairs Analysts, Inc. | 1 Dag Hammarskjold Plaza | Suite 1819 | New York | NY | 10017 |
19553 | 19553 | 1988-06-15 | 1987-10-14 | Rowan | Yueh-mei Wu | Sedam & Emerson, a Professional Corporation 4049 | 1987-10-14 | Sedam & Emerson, a Professional Corporation | 4020 University Drive | Suite 320 | Fairfax | VA | 22030 |
22277 | 22277 | 1999-07-01 | 1997-01-02 | Rowan | Nicholaus Clark | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
22278 | 22278 | 1999-07-01 | 1997-02-18 | Rowan | Nicholaus Clark | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
22284 | 22284 | 2000-07-01 | 1996-03-01 | Rowan | James P. , Sr. | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | 700 - 13th Street, N.W. | Suite 400 | Washington | DC | 20005 |
34056 | 34056 | 1986-10-30 | 1985-10-31 | Rowan | Ann M. | Hyjek & Fix, Inc. 3660 | 1985-03-19 | Hyjek & Fix, Inc. | 2100 Pennsylvania Avenue, N.W. | Suite 560 | Washington | DC | 20037 |
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]) );