FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where "Short_Form_Date" is on date 1992-10-09
This data as json, CSV (advanced)
Suggested facets: Address_2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6470 | 6470 | 1993-02-09 | 1992-10-09 | Kraiem | Ruben | Paul, Weiss, Rifkind, Wharton & Garrison 4539 | 1991-07-09 | Paul, Weiss, Rifkind, Wharton & Garrison | 1285 Avenue of the Americas | New York | NY | 10019-6064 | |
13926 | 13926 | 1997-04-22 | 1992-10-09 | Doane | James K. | Preston, Gates & Ellis, L.L.P. 3567 | 1984-03-22 | Preston, Gates & Ellis, L.L.P. | 5000 Columbia Center | 701 Fifth Avenue | Seattle | WA | 98104-7078 |
16270 | 16270 | 1993-05-13 | 1992-10-09 | Hershman | Edward | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
16271 | 16271 | 1993-05-13 | 1992-10-09 | Mangers | Claire | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
17475 | 17475 | 1995-05-30 | 1992-10-09 | Hollstein | Manfred | Daimler-Chrysler Aerospace of North America, Inc. 4719 | 1992-10-09 | Daimler-Chrysler Aerospace of North America, Inc. | 1401 H Street, N.W. | Suite 700 | Washington | DC | 20005 |
19063 | 19063 | 1993-06-08 | 1992-10-09 | Gray | Douglas | YHDA International 4421 | 1990-10-12 | YHDA International | 28 Junction Square | Concord | MA | 01742 | |
32698 | 32698 | 1994-10-12 | 1992-10-09 | Johnson | Cathleen | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
33633 | 33633 | 1993-10-25 | 1992-10-09 | Fenton | Bronwyn Anne | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
33634 | 33634 | 1993-10-25 | 1992-10-09 | Perez | Maria Isabel | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
38249 | 38249 | 1999-12-13 | 1992-10-09 | Humphrey | Deidre D. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
38659 | 38659 | 2000-12-18 | 1992-10-09 | Levine | Jennifer | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
38660 | 38660 | 2000-12-18 | 1992-10-09 | Rojas | Valentino | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
38661 | 38661 | 2000-12-18 | 1992-10-09 | Saias | Sandra | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
38662 | 38662 | 2000-12-18 | 1992-10-09 | Sattell | Susan | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
38663 | 38663 | 2000-12-18 | 1992-10-09 | Valadez | Norma Jean | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
41246 | 41246 | 2001-12-31 | 1992-10-09 | Gasson | Ellen C. | Rendon Group, Inc. 4449 | 1990-12-17 | Rendon Group, Inc. | 1875 Connecticut Avenue, N.W. | Suite 414 | Washington | DC | 20009 |
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]) );