FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Short_Form_First_Name = "Evelyn"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3747 | 3747 | 1971-01-15 | 1962-11-28 | Fromm | Evelyn | EG&A International, Inc. 1584 | 1962-11-28 | EG&A International, Inc. | 485 Madison Avenue | New York | NY | 10022 | |
7032 | 7032 | 2021-02-15 | 2018-01-01 | Marino | Evelyn | Media Planning International Corporation 6621 | 2018-12-21 | Media Planning International Corporation | c/o Havas Creative Group | 200 Hudson Street | New York | NY | 10013 |
14201 | 14201 | 1993-04-27 | 1991-09-19 | Gonzalez | Evelyn | Lord Group 4556 | 1991-08-14 | Lord Group | 810 Seventh Avenue | New York | NY | 10019 | |
26475 | 26475 | 1966-08-12 | 1966-01-24 | Rose | Evelyn | Bell & Stanton, Inc. 1827 | 1964-12-04 | Bell & Stanton, Inc. | 757 Third Avenue | New York | NY | ||
29428 | 29428 | 1993-09-08 | 1982-11-24 | Brody | Evelyn | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
34560 | 34560 | 2007-10-31 | 2006-06-09 | Walsh | Evelyn | Enterprise Ireland 2518 | 1974-06-08 | Enterprise Ireland | Ireland House | 345 Park Avenue, 17th Floor | New York | NY | 10154-0037 |
34751 | 34751 | 2020-10-31 | 2018-07-09 | Bubb | Evelyn | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
36101 | 36101 | 1981-11-20 | 1978-11-15 | Dumas | Evelyn | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
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]) );