FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where City = "New York" and Short_Form_Termination_Date = "2016-12-31"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Registration_Date, Address_2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42022 | 42022 | 2016-12-31 | 1987-02-17 | Stewart | Ingrid | St. Lucia Tourism Authority 2668 | 1976-03-15 | St. Lucia Tourism Authority | 630 3rd Avenue | Suite 702 | New York | NY | 10017-4504 |
42023 | 42023 | 2016-12-31 | 2010-02-18 | Andersen | Christina | VisitDenmark 634 | 1950-07-25 | VisitDenmark | 655 Third Avenue | 18th Floor, Suite 2010 | New York | NY | 10017 |
42026 | 42026 | 2016-12-31 | 2014-03-10 | Ross | Jessica | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 301 E. 57th Street | New York | NY | 10022 | |
42031 | 42031 | 2016-12-31 | 2008-04-02 | Choynacki | Annette | Belgian National Tourist Office 529 | 1948-06-17 | Belgian National Tourist Office | 300 East 42nd Street | 14th Floor | New York | NY | 10017 |
42032 | 42032 | 2016-12-31 | 2008-04-09 | Saeger | Laura | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
42043 | 42043 | 2016-12-31 | 2017-06-21 | Blank | Spenser | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 | |
42044 | 42044 | 2016-12-31 | 2017-06-21 | Colon | Carol Lyn | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 | |
42045 | 42045 | 2016-12-31 | 2017-06-21 | Fillip | Chris | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 | |
42046 | 42046 | 2016-12-31 | 2017-06-21 | Moeller | James | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 | |
42047 | 42047 | 2016-12-31 | 2017-06-21 | Schwartz | Robert | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 | |
42061 | 42061 | 2016-12-31 | 2016-09-15 | Bundred | Iain | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 | |
42062 | 42062 | 2016-12-31 | 2016-09-15 | King | Benjamin | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 | |
42063 | 42063 | 2016-12-31 | 2016-09-15 | Mullins | Tara | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 | |
42064 | 42064 | 2016-12-31 | 2016-09-15 | Risi | Jennifer | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 | |
42065 | 42065 | 2016-12-31 | 2016-09-15 | Rosenthal | David | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 | |
42066 | 42066 | 2016-12-31 | 2016-09-15 | Stewart | James | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 | |
42067 | 42067 | 2016-12-31 | 1997-09-26 | Charles-St. Jules | Anthea Lorine | St. Lucia Tourism Authority 2668 | 1976-03-15 | St. Lucia Tourism Authority | 630 3rd Avenue | Suite 702 | New York | NY | 10017-4504 |
42069 | 42069 | 2016-12-31 | 2016-10-12 | Ludlum | Nicholas | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 | |
42070 | 42070 | 2016-12-31 | 2016-10-12 | Rios | Michelle Corrigan | Ogilvy Public Relations 6376 | 2016-09-15 | Ogilvy Public Relations | 636 11th Avenue | New York | NY | 10036 | |
42073 | 42073 | 2016-12-31 | 2014-10-28 | Crawford | Robin | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 301 E. 57th Street | New York | NY | 10022 |
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]) );