FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where City = "New York" and Short_Form_First_Name = "Robin"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_2, Short_Form_Termination_Date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87 | 87 | 2023-01-09 | Crawford | Robin | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 301 E. 57th Street | New York | NY | 10022 | ||
1660 | 1660 | 2021-08-23 | Mui | Robin | Sing Tao US 6999 | 2021-08-23 | Sing Tao US | Sing Tao Newspapers New York Ltd. | 188 Lafayette Street | New York | NY | 10013 | |
1669 | 1669 | 2022-08-26 | Knight | Robin | Brunswick Group LLC 6826 | 2020-05-20 | Brunswick Group LLC | 245 Park Avenue | 14th Floor | New York | NY | 10167 | |
2097 | 2097 | 2020-11-02 | Kim | Robin | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
7996 | 7996 | 1992-02-28 | 1991-10-21 | Schepper | Robin | Sawyer Miller Group 3777 | 1986-02-12 | Sawyer Miller Group | 14 East 60th Street | New York | NY | 10022 | |
12749 | 12749 | 2014-04-04 | 2011-04-15 | Levy | Robin | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
13090 | 13090 | 1992-04-10 | 1990-01-31 | Anderson | Robin | McCann Direct, Inc. 3922 | 1986-12-29 | McCann Direct, Inc. | 750 Third Avenue | New York | NY | 10017 | |
22002 | 22002 | 2022-06-30 | 2022-06-06 | Crawford | Robin | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 301 E. 57th Street | New York | NY | 10022 | |
22411 | 22411 | 2022-07-01 | 2018-10-31 | Rathmell | Robin | Kobre & Kim LLP 6604 | 2018-10-31 | Kobre & Kim LLP | 800 Third Avenue | New York | NY | 10022 | |
22558 | 22558 | 1974-07-04 | 1974-03-22 | Harris | Robin | H&H 2506 | 1974-03-22 | H&H | 39 East 12th Street | New York | NY | 10003 | |
28095 | 28095 | 1986-08-31 | 1999-03-02 | Chiu | Robin | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
28306 | 28306 | 1997-08-31 | 1993-04-27 | Daily | Robin | Lord Group 4556 | 1991-08-14 | Lord Group | 810 Seventh Avenue | New York | NY | 10019 | |
29019 | 29019 | 1988-09-02 | 1975-02-21 | Chiu | Robin | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
37910 | 37910 | 1978-12-08 | 1978-02-01 | Prestage | Robin | Australian Tourist Commission, New York 2279 | 1971-09-22 | Australian Tourist Commission, New York | 630 Fifth Avenue | Room 467 | New York | NY | 10111 |
41834 | 41834 | 2012-12-31 | 2011-08-18 | Van Puyenbroeck | Robin | Strategy XXI Group, LLC 6058 | 2011-08-18 | Strategy XXI Group, LLC | 515 Madison Avenue | 13th Floor | New York | NY | 10022 |
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]) );