FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Short_Form_Last_Name = "Gilbert"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5776 | 5776 | 1991-02-01 | 1988-12-09 | Gilbert | Lauren | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
8074 | 8074 | 1997-02-28 | 1988-03-29 | Gilbert | Gerald E. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
12538 | 12538 | 2009-04-01 | 2008-05-06 | Gilbert | Daniel R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
19585 | 19585 | 2002-06-15 | 1998-09-18 | Gilbert | Christian | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
19916 | 19916 | 1981-06-20 | 1981-04-16 | Gilbert | Richard S. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
26463 | 26463 | 2006-08-11 | 2005-09-30 | Gilbert | Meredith | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
27435 | 27435 | 1995-08-25 | 1992-01-30 | Gilbert | Marcel R. | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
35090 | 35090 | 1979-11-02 | 1977-02-28 | Gilbert | Richard S. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
37388 | 37388 | 1986-12-01 | 1986-11-02 | Gilbert | Kathy | N.W. Ayer & Son, Inc. 3411 | 1982-09-27 | N.W. Ayer & Son, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
41019 | 41019 | 1997-12-31 | 1994-04-20 | Gilbert | Sandra A. | Robison International, Inc. 3950 | 1987-03-20 | Robison International, Inc. | One Massachusetts Avenue, N.W. | Suite 880 | Washington | DC | 20001 |
42005 | 42005 | 2015-12-31 | 2015-06-15 | Gilbert | Suzanne | FitzGibbon Media, Inc. 6299 | 2015-06-15 | FitzGibbon Media, Inc. | 2108 Military Road | Arlington | VA | 22207 |
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]) );