FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Short_Form_Termination_Date" is on date 2015-11-30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37061 | 37061 | 2015-11-30 | 2015-02-09 | Frank | Laura E. | Ceisler Media & Issue Advocacy, LLC 6266 | 2014-12-19 | Ceisler Media & Issue Advocacy, LLC | 1525 Locust Street, 6th Floor | Philadelphia | PA | 19102 | |
37062 | 37062 | 2015-11-30 | 2015-02-09 | Gibson | William Keegan | Ceisler Media & Issue Advocacy, LLC 6266 | 2014-12-19 | Ceisler Media & Issue Advocacy, LLC | 1525 Locust Street, 6th Floor | Philadelphia | PA | 19102 | |
37063 | 37063 | 2015-11-30 | 2014-04-23 | Shoyer | Andrew W. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
37064 | 37064 | 2015-11-30 | 2015-06-19 | Gutierrez Aliaga | Violeta Maria Isabel | Paz-Soldan, Carlos Mateo 6301 | 2015-06-19 | Paz-Soldan, Carlos Mateo | 411 Windsor Lane | Winchester | VA | 22602 | |
37065 | 37065 | 2015-11-30 | 2015-06-19 | Paz-Soldan | Carlos Mateo | Paz-Soldan, Carlos Mateo 6301 | 2015-06-19 | Paz-Soldan, Carlos Mateo | 411 Windsor Lane | Winchester | VA | 22602 | |
37066 | 37066 | 2015-11-30 | 2013-09-09 | McMahon | Michael E. | Herrick, Feinstein LLP 6185 | 2013-09-09 | Herrick, Feinstein LLP | 2 Park Avenue | New York | NY | 10016 | |
37067 | 37067 | 2015-11-30 | 2013-10-11 | Hart | Daniel Scott | Herrick, Feinstein LLP 6185 | 2013-09-09 | Herrick, Feinstein LLP | 2 Park Avenue | New York | NY | 10016 | |
37068 | 37068 | 2015-11-30 | 2013-10-11 | Karaahmet | Barbaros M. | Herrick, Feinstein LLP 6185 | 2013-09-09 | Herrick, Feinstein LLP | 2 Park Avenue | New York | NY | 10016 | |
37069 | 37069 | 2015-11-30 | 2013-10-11 | Kaye | Lawrence M. | Herrick, Feinstein LLP 6185 | 2013-09-09 | Herrick, Feinstein LLP | 2 Park Avenue | New York | NY | 10016 | |
37070 | 37070 | 2015-11-30 | 2015-10-13 | Hayes | James A. | Herrick, Feinstein LLP 6185 | 2013-09-09 | Herrick, Feinstein LLP | 2 Park Avenue | New York | NY | 10016 | |
37071 | 37071 | 2015-11-30 | 2012-11-28 | Jeon | Misung | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
37072 | 37072 | 2015-11-30 | 2014-12-19 | Ceisler | Lawrence A. | Ceisler Media & Issue Advocacy, LLC 6266 | 2014-12-19 | Ceisler Media & Issue Advocacy, LLC | 1525 Locust Street, 6th Floor | Philadelphia | PA | 19102 |
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]) );