FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Short_Form_Last_Name = "Lipsen"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3408 | 3408 | 1990-01-08 | 1982-12-22 | Lipsen | Janice C. | Counselors for Management, Inc. 3431 | 1982-12-22 | Counselors for Management, Inc. | 1000 - 16th Street, N.W. | Suite 603 | Washington | DC | 20036 |
24213 | 24213 | 1993-07-27 | 1992-12-23 | Lipsen | Zel E. | Birch, Horton, Bittner, Inc. 4742 | 1992-12-23 | Birch, Horton, Bittner, Inc. | 1155 Connecticut Avenue, N.W. | Suite 1200 | Washington | DC | 20036 |
24951 | 24951 | 2000-07-31 | 1996-01-19 | Lipsen | Zel E. | Lipsen, Zel E. 5092 | 1996-01-19 | Lipsen, Zel E. | One Massachusetts Avenue, N.W. | Suite 330 | Washington | DC | 20001 |
28266 | 28266 | 1995-08-31 | 1993-07-12 | Lipsen | Zel | Lipsen & Hamberger 4829 | 1993-07-12 | Lipsen & Hamberger | Willard Office Building | 1455 Pennsylvania Ave, NW #225 | Washington | DC | 20004-1008 |
30487 | 30487 | 1979-09-26 | 1977-06-10 | Lipsen | Charles B. | Cramer & Lipsen 2570 | 1975-04-01 | Cramer & Lipsen | 475 L'Enfant Plaza, S.W. | Suite 4100 | Washington | DC | 20024 |
36119 | 36119 | 1992-11-20 | 1984-05-10 | Lipsen | Zel E. | Lipsen, Whitten & Diamond 3586 | 1984-05-10 | Lipsen, Whitten & Diamond | 1725 DeSales Street, N.W. | Suite 800 | Washington | DC | 20036 |
40156 | 40156 | 1980-12-31 | 1977-07-22 | Lipsen | Charles B. | Nicaraguan-American Trade Council 2808 | 1977-07-22 | Nicaraguan-American Trade Council | 475 L'Enfant Plaza, S.W. | Washington | DC | 20024 |
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]) );