FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Short_Form_Last_Name = "Patrick"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_2, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6930 | 6930 | 1983-02-15 | 1982-07-28 | Patrick | Peter | Patrick & Associates 3394 | 1982-07-28 | Patrick & Associates | 407 - 11th Street, S.E. | Washington | DC | 2000 | |
9198 | 9198 | 2019-03-05 | 2018-10-01 | Patrick | Susie | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
11764 | 11764 | 1997-03-31 | 1980-03-28 | Patrick | Casimir C. , II | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
15698 | 15698 | 1993-05-04 | 1991-01-31 | Patrick | Mary | Jasculca/Terman & Associates, Inc. 4289 | 1989-09-12 | Jasculca/Terman & Associates, Inc. | 730 North Franklin Street | Suite 150 | Chicago | IL | 60610 |
20318 | 20318 | 2000-06-26 | 2000-04-28 | Patrick | Tiffany C. | Maseng Communications 4660 | 1992-05-05 | Maseng Communications | 11309 Baroque Road | Silver Spring | MD | 20901 | |
20773 | 20773 | 1966-06-30 | 1965-03-19 | Patrick | Robert John , Jr. | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
23210 | 23210 | 1980-07-15 | 1978-12-06 | Patrick | Peter | Patrick & Associates 2984 | 1978-12-06 | Patrick & Associates | 407 - 11th Street, S.C. | Washington | DC | 20003 | |
32042 | 32042 | 2011-10-01 | 2009-02-20 | Patrick | Von Bargen | Quinn Gillespie & Associates, LLC 5753 | 2006-06-01 | Quinn Gillespie & Associates, LLC | 1133 Connecticut Avenue, NW | 5th Floor | Washington | DC | 20036 |
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]) );