FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Address_1 = "4 Times Square"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Zip, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21714 | 21714 | 2013-06-30 | 2019-01-19 | Kerlin | Paul | Skadden, Arps, Slate, Meagher & Flom 6617 | 2019-01-18 | Skadden, Arps, Slate, Meagher & Flom | 4 Times Square | New York | NY | 11036 | |
21715 | 21715 | 2013-06-30 | 2019-01-19 | Loucks | Michael Kirk | Skadden, Arps, Slate, Meagher & Flom 6617 | 2019-01-18 | Skadden, Arps, Slate, Meagher & Flom | 4 Times Square | New York | NY | 11036 | |
21716 | 21716 | 2013-06-30 | 2019-01-19 | Malet | Lauren | Skadden, Arps, Slate, Meagher & Flom 6617 | 2019-01-18 | Skadden, Arps, Slate, Meagher & Flom | 4 Times Square | New York | NY | 11036 | |
21717 | 21717 | 2013-06-30 | 2019-01-19 | Margaret E. | Krawiec | Skadden, Arps, Slate, Meagher & Flom 6617 | 2019-01-18 | Skadden, Arps, Slate, Meagher & Flom | 4 Times Square | New York | NY | 11036 | |
21718 | 21718 | 2013-06-30 | 2019-01-19 | Porter | Melissa | Skadden, Arps, Slate, Meagher & Flom 6617 | 2019-01-18 | Skadden, Arps, Slate, Meagher & Flom | 4 Times Square | New York | NY | 11036 | |
21719 | 21719 | 2013-06-30 | 2019-01-19 | Roseen | Kara | Skadden, Arps, Slate, Meagher & Flom 6617 | 2019-01-18 | Skadden, Arps, Slate, Meagher & Flom | 4 Times Square | New York | NY | 11036 | |
21720 | 21720 | 2013-06-30 | 2019-01-19 | Sloan | Clifford | Skadden, Arps, Slate, Meagher & Flom 6617 | 2019-01-18 | Skadden, Arps, Slate, Meagher & Flom | 4 Times Square | New York | NY | 11036 | |
21725 | 21725 | 2013-06-30 | 2019-03-14 | Cowie | Matthew | Skadden, Arps, Slate, Meagher & Flom 6617 | 2019-01-18 | Skadden, Arps, Slate, Meagher & Flom | 4 Times Square | New York | NY | 11036 | |
38530 | 38530 | 2019-12-16 | 2019-08-01 | Krawiec | Margaret E. | Skadden, Arps, Slate, Meagher & Flom LLP 6704 | 2019-08-01 | Skadden, Arps, Slate, Meagher & Flom LLP | 4 Times Square | New York | NY | 10036 | |
38531 | 38531 | 2019-12-16 | 2019-08-01 | Mclntosh | Michael A. | Skadden, Arps, Slate, Meagher & Flom LLP 6704 | 2019-08-01 | Skadden, Arps, Slate, Meagher & Flom LLP | 4 Times Square | New York | NY | 10036 |
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]) );