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 = "Falk"
This data as json, CSV (advanced)
Suggested facets: Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11555 | 11555 | 1987-03-31 | 1983-01-11 | Falk | William J. | Thompson & Mitchell 3436 | 1983-01-11 | Thompson & Mitchell | 1 Mercantile Center | Suite 3400 | St. Louis | MO | 63101 |
14926 | 14926 | 2006-04-30 | 2006-02-21 | Falk | EmiIy A. | Maynard, Cooper and Gale, P.C. 5716 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | 1901 Sixth Avenue North | 2400 AmSouth/Harbert Plaza | Birmingham | AL | 35203 |
15797 | 15797 | 1983-05-06 | 1982-09-02 | Falk | H. William | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | 747 Third Avenue, 23rd Floor | New York | NY | 10017-2803 | |
20733 | 20733 | 1963-06-30 | 1962-02-20 | Falk | Edgar Alan | BBDO International, Inc. 1500 | 1961-12-12 | BBDO International, Inc. | 383 Madison Avenue | New York | NY | ||
21658 | 21658 | 2010-06-30 | 2009-05-08 | Falk | John M. | Vision Americas, LLC 5907 | 2009-02-19 | Vision Americas, LLC | 1150 K Street, NW | Suite 1411 | Washington | DC | 20005 |
34904 | 34904 | 1986-11-01 | 1986-08-01 | Falk | Jacqueline L. | Mark A. Siegel & Associates, Inc. 3865 | 1986-08-01 | Mark A. Siegel & Associates, Inc. | 1030 - 15th Street, N.W. | Suite 408 | Washington | DC | 20005 |
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]) );