FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where City = "New York" and Short_Form_First_Name = "Kristin"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2209 | 2209 | 2021-11-22 | Bender | Kristin | Willkie Farr & Gallagher LLP 7047 | 2021-11-22 | Willkie Farr & Gallagher LLP | 787 Seventh Avenue | New York | NY | 10019 | ||
2901 | 2901 | 2013-01-01 | 2013-01-03 | Hutton | Kristin | Lou Hammond & Associates, Inc. 5935 | 2009-05-15 | Lou Hammond & Associates, Inc. | 900 Third Avenue, Suite 401 | New York | NY | 10022 | |
15146 | 15146 | 2019-04-30 | 2017-03-01 | Eckert | Kristin | Bavarian U.S. Offices for Economic Development, LLC 6015 | 2011-01-07 | Bavarian U.S. Offices for Economic Development, LLC | 80 Pine Street | 24th Floor | New York | NY | 10005 |
15994 | 15994 | 2012-05-09 | 2004-05-18 | Degnan | Kristin | Richartz Fliss Clark & Pope, Inc. 5623 | 2004-05-18 | Richartz Fliss Clark & Pope, Inc. | 305 Madison Avenue | Suite 2145 | New York | NY | 10165 |
17805 | 17805 | 1995-05-31 | 1995-02-24 | Rand | Kristin | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | Saatchi & Saatchi Building | 375 Hudson Street, 10th Floor | New York | NY | 10014-3620 |
21695 | 21695 | 2011-06-30 | 2007-12-31 | Dahle | Kristin | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
31453 | 31453 | 2009-09-30 | 2009-05-07 | Chapdelaine | Kristin | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
39253 | 39253 | 1984-12-28 | 1983-05-20 | Warner | Kristin | N.W. Ayer & Son, Inc. 3411 | 1982-09-27 | N.W. Ayer & Son, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
41419 | 41419 | 2005-12-31 | 2002-06-05 | Volk | Kristin | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 |
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]) );