FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
111 rows where City = "Bethesda" sorted by Address_2
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32066 | 32066 | 2013-10-01 | 2009-10-30 | Footlik | Jay | 30 Point Strategies, LLC 5884 | 2008-10-06 | 30 Point Strategies, LLC | 7315 Wisconsin Avenue | Suite 425 East | Bethesda | MD | 20814 |
32067 | 32067 | 2013-10-01 | 2008-11-06 | Neusner | Noam | 30 Point Strategies, LLC 5884 | 2008-10-06 | 30 Point Strategies, LLC | 7315 Wisconsin Avenue | Suite 425 East | Bethesda | MD | 20814 |
32068 | 32068 | 2013-10-01 | 2010-12-15 | Silberberg | Joshua | 30 Point Strategies, LLC 5884 | 2008-10-06 | 30 Point Strategies, LLC | 7315 Wisconsin Avenue | Suite 425 East | Bethesda | MD | 20814 |
7707 | 7707 | 1988-02-26 | 1986-07-25 | Roesing | William P. | Campaign Planning, Inc. 3862 | 1986-07-25 | Campaign Planning, Inc. | 4520 East-West Highway | Suite 550 | Bethesda | MD | 20814 |
14870 | 14870 | 2002-04-30 | 2001-04-06 | Moore | John D. | American Worldwide Inc. 5425 | 2001-04-06 | American Worldwide Inc. | 3 Bethesda Metro Center | Suite 600 | Bethesda | MD | 20814-6332 |
6409 | 6409 | 1988-02-08 | 1987-06-16 | Gomez | Francis D. | Public Affairs Resources, Inc. 3994 | 1987-06-16 | Public Affairs Resources, Inc. | 7315 Wisconsin Avenue, N.W. | Suite 800 East | Bethesda | MD | 20814 |
24991 | 24991 | 2001-07-31 | 1997-07-14 | Pordzik | Wolfgang G. | Pordzik, Wolfgang G. 5192 | 1997-07-14 | Pordzik, Wolfgang G. | 4710 Bethesda Avenue | Suite 919 | Bethesda | MD | 20814 |
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]) );