FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where Short_Form_Last_Name = "Mallory"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_Date, Address_1, Address_2, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3602 | 3602 | 2021-01-11 | 2020-04-16 | Mallory | Jeffrey Richard | Afghanistan-U.S. Democratic Peace and Prosperity Council, Inc. 6817 | 2020-04-16 | Afghanistan-U.S. Democratic Peace and Prosperity Council, Inc. | 3436 23rd Street, SE | Washington | DC | 20002 | |
22885 | 22885 | 1968-07-10 | 1960-07-26 | Mallory | John Kenneth , Jr. | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
26415 | 26415 | 2020-08-10 | 2020-08-10 | Mallory | Greg | Boston Consulting Group International, Inc. 6851 | 2020-08-10 | Boston Consulting Group International, Inc. | 200 Pier 4 Boulevard | Boston | MA | 02210 | |
27293 | 27293 | 1951-08-24 | 1949-02-10 | Mallory | John Kenneth , Jr. | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
27543 | 27543 | 2021-08-27 | 2018-07-10 | Mallory | Jack | LGND, LLC 6570 | 2018-07-10 | LGND, LLC | 6701 Democracy Blvd | Suite 300 | Bethesda | MD | 20817 |
40336 | 40336 | 1985-12-31 | 1980-09-30 | Mallory | James C. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
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]) );