FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Short_Form_Last_Name = "Pierson"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3692 | 3692 | 1959-01-14 | 1958-10-09 | Pierson | Lillian Rose | Allied Public Relations, Inc. 1177 | 1958-10-09 | Allied Public Relations, Inc. | 250 Park Avenue | New York | NY | ||
6686 | 6686 | 1996-02-12 | 1982-05-18 | Pierson | W. DeVier | Pierson, Semmes & Bemis 2988 | 1979-01-17 | Pierson, Semmes & Bemis | 1054 - 31st Street, N.W. | Suite 300 | Washington | DC | 20007 |
10194 | 10194 | 1977-03-18 | 1969-08-21 | Pierson | W. DeVier | Pierson, Semmes, Crolius & Finley 2159 | 1969-08-21 | Pierson, Semmes, Crolius & Finley | 1054 - 31st Street, N.W. | Washington | DC | 20007 | |
22665 | 22665 | 1958-07-07 | 1958-01-07 | Pierson | Lillian Rose | Roosevelt, Summers & Hamilton, Inc. 1099 | 1958-01-01 | Roosevelt, Summers & Hamilton, Inc. | 787 Fifth Avenue | New York | NY | ||
25375 | 25375 | 2020-07-31 | 2019-04-09 | Pierson | Rachel | Beacon Policy Advisors LLC 6658 | 2019-04-09 | Beacon Policy Advisors LLC | 1701 Pennsylvania Avenue, NW | Suite 200 | Washington | DC | 20006 |
31277 | 31277 | 2001-09-30 | 1999-09-24 | Pierson | Stuart F. | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
35618 | 35618 | 1983-11-11 | 1979-11-05 | Pierson | Stephanie | McCann-Erickson, Inc. 3060 | 1979-09-16 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
38980 | 38980 | 1970-12-23 | 1970-09-30 | Pierson | James H.S. | Marplan Research, Inc. 2124 | 1969-02-26 | Marplan Research, Inc. | 485 Lexington Avenue | New York | NY | 10017 |
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]) );