FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Short_Form_Termination_Date = "2002-05-31"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Termination_Date (date), Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17957 | 17957 | 2002-05-31 | 1992-02-04 | Sutton | Barbara | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | 700 - 13th Street, N.W. | Suite 400 | Washington | DC | 20005 |
17958 | 17958 | 2002-05-31 | 2002-04-08 | Beal | Thomas P. | Zemi Communications, L.L.C. 5491 | 2002-04-08 | Zemi Communications, L.L.C. | 99 Madison Avenue | 2nd Floor | New York | NY | 10016 |
17959 | 17959 | 2002-05-31 | 1999-05-17 | Hipp | Van D., Jr. | American Defense International, Inc. 5311 | 1999-05-17 | American Defense International, Inc. | 1800 K Street, N.W. | Suite 1010 | Washington | DC | 20006 |
17960 | 17960 | 2002-05-31 | 2001-05-29 | Quinn | Thomas H. | Venable, LLP 5435 | 2001-05-29 | Venable, LLP | 575 7th Street, N.W. | Washington | DC | 20004 | |
17961 | 17961 | 2002-05-31 | 2000-06-26 | Tyler-Gordon | Tanya | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
17962 | 17962 | 2002-05-31 | 2000-09-01 | Froehlich | Patrick | Bavarian Office for Trade, Investment, Research and Technology 5381 | 2000-09-01 | Bavarian Office for Trade, Investment, Research and Technology | 555 Hamilton Avenue | Suite 130 | Palo Alto | CA | 94301 |
17963 | 17963 | 2002-05-31 | 2000-11-02 | Bafalis | Louis Skip"" | Alcalde & Fay, Inc. 5394 | 2000-11-02 | Alcalde & Fay, Inc. | 2111 Wilson Boulevard | 8th Floor | Arlington | VA | 22201 |
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]) );