FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where "Short_Form_Termination_Date" is on date 1988-04-15
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13428 | 13428 | 1988-04-15 | 1986-01-06 | Biel | Eric R. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
13429 | 13429 | 1988-04-15 | 1987-03-26 | Baughman | Laura | Mudge, Rose, Guthrie, Alexander & Ferdon 3200 | 1981-02-18 | Mudge, Rose, Guthrie, Alexander & Ferdon | 2 Wall Street | New York | NY | 10005 | |
13430 | 13430 | 1988-04-15 | 1985-04-05 | French | Verrick O. | French & Company 3666 | 1985-04-05 | French & Company | The Willard | 1455 Penn. Ave., N.W. #1260 | Washington | DC | 20004 |
13431 | 13431 | 1988-04-15 | 1986-04-09 | Park | Jin Woo | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
13432 | 13432 | 1988-04-15 | 1985-05-22 | McIntosh | Martha Anne | French & Company 3666 | 1985-04-05 | French & Company | The Willard | 1455 Penn. Ave., N.W. #1260 | Washington | DC | 20004 |
13433 | 13433 | 1988-04-15 | 1982-09-27 | Clark | Agi | N.W. Ayer & Son, Inc. 3411 | 1982-09-27 | N.W. Ayer & Son, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
13434 | 13434 | 1988-04-15 | 1987-11-16 | Ellison | Mark M. | French & Company 3666 | 1985-04-05 | French & Company | The Willard | 1455 Penn. Ave., N.W. #1260 | Washington | DC | 20004 |
13435 | 13435 | 1988-04-15 | 1986-12-02 | Sneed | Richard L. | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 |
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]) );