FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where "Short_Form_Date" is on date 1988-11-18
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4562 | 4562 | 1990-01-26 | 1988-11-18 | Cook | Beth E. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
12836 | 12836 | 1990-04-06 | 1988-11-18 | Fultz | Richard Donald | Neill, Mullenholz & Shaw 3962 | 1987-04-16 | Neill, Mullenholz & Shaw | 815 Connecticut Avenue, N.W. | Suite 800 | Washington | DC | 20006 |
14256 | 14256 | 1991-04-28 | 1988-11-18 | Fletcher | Donald M. | Hong Kong Government (Industry Department) 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
14620 | 14620 | 1991-04-30 | 1988-11-18 | Fitts | James | ClarkeGowardFittsMatteson, Inc. 4123 | 1988-04-20 | ClarkeGowardFittsMatteson, Inc. | 535 Boylston Street | Boston | MA | 02116 | |
14621 | 14621 | 1991-04-30 | 1988-11-18 | Goward | Jonathan M. | ClarkeGowardFittsMatteson, Inc. 4123 | 1988-04-20 | ClarkeGowardFittsMatteson, Inc. | 535 Boylston Street | Boston | MA | 02116 | |
21130 | 21130 | 1989-06-30 | 1988-11-18 | O'Brien | Michael E. | ClarkeGowardFittsMatteson, Inc. 4123 | 1988-04-20 | ClarkeGowardFittsMatteson, Inc. | 535 Boylston Street | Boston | MA | 02116 | |
28144 | 28144 | 1989-08-31 | 1988-11-18 | Aldrich | Brian | ClarkeGowardFittsMatteson, Inc. 4123 | 1988-04-20 | ClarkeGowardFittsMatteson, Inc. | 535 Boylston Street | Boston | MA | 02116 | |
33263 | 33263 | 1993-10-20 | 1988-11-18 | Diebold | Julie E. | ClarkeGowardFittsMatteson, Inc. 4123 | 1988-04-20 | ClarkeGowardFittsMatteson, Inc. | 535 Boylston Street | Boston | MA | 02116 | |
33264 | 33264 | 1993-10-20 | 1988-11-18 | Kincannon | Mary | ClarkeGowardFittsMatteson, Inc. 4123 | 1988-04-20 | ClarkeGowardFittsMatteson, Inc. | 535 Boylston Street | Boston | MA | 02116 | |
33265 | 33265 | 1993-10-20 | 1988-11-18 | Matteson | William C. | ClarkeGowardFittsMatteson, Inc. 4123 | 1988-04-20 | ClarkeGowardFittsMatteson, Inc. | 535 Boylston Street | Boston | MA | 02116 | |
35539 | 35539 | 1990-11-09 | 1988-11-18 | Demirjian | Andrea | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
35540 | 35540 | 1990-11-09 | 1988-11-18 | Soubiran-Niedermayer | Virginie | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
35541 | 35541 | 1990-11-09 | 1988-11-18 | Weber | Eric | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
40591 | 40591 | 1989-12-31 | 1988-11-18 | Price | Anthony | ClarkeGowardFittsMatteson, Inc. 4123 | 1988-04-20 | ClarkeGowardFittsMatteson, Inc. | 535 Boylston Street | Boston | MA | 02116 |
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]) );