FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Short_Form_Termination_Date = "1991-02-28" sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7985 | 7985 | 1991-02-28 | 1990-12-03 | Wasserman | Gary | FMR Group, Inc. 4381 | 1990-04-18 | FMR Group, Inc. | 1000 Potomac Street, N.W. | Suite 401 | Washington | DC | 20007 |
7984 | 7984 | 1991-02-28 | 1990-11-07 | Landi | Mike | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
7983 | 7983 | 1991-02-28 | 1990-09-11 | Clemente | Charles C. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
7982 | 7982 | 1991-02-28 | 1990-08-31 | Watlington | B. Gale | Keene, Shirley & Associates, Inc. 3997 | 1987-06-19 | Keene, Shirley & Associates, Inc. | 919 Prince Street | Alexandria | VA | 22314 | |
7981 | 7981 | 1991-02-28 | 1986-08-08 | Scanlon | John P. | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
7980 | 7980 | 1991-02-28 | 1979-07-17 | Lepow | Leslie H. | 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 |
7979 | 7979 | 1991-02-28 | 1988-06-30 | Bergen | John D. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
7978 | 7978 | 1991-02-28 | 1989-06-01 | Minow | Newton N. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
7977 | 7977 | 1991-02-28 | 1986-05-23 | Schechter | William | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7976 | 7976 | 1991-02-28 | 1990-05-07 | Swain | Frank S. | Baker & Daniels 4375 | 1990-05-07 | Baker & Daniels | 300 North Meridian Street | Indianapolis | IN | 46204 | |
7975 | 7975 | 1991-02-28 | 1990-05-07 | Johnson | David Lawther | Baker & Daniels 4375 | 1990-05-07 | Baker & Daniels | 300 North Meridian Street | Indianapolis | IN | 46204 | |
7974 | 7974 | 1991-02-28 | 1990-04-27 | Stern | Ava | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7973 | 7973 | 1991-02-28 | 1990-01-04 | De Lorenzo | Annette | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | 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]) );