FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where City = "New York" and Short_Form_First_Name = "Philip"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 17
- Enterprise Ireland 3
- Marathon Strategies, LLC 3
- Daniel J. Edelman, Inc. 2
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- EG&A International, Inc. 1
- McCann-Erickson, Inc. 1
- IDA Ireland 1
- Quebec Government Office 1
- Allen/Van Slyck Group 1
- White & Case, LLP 1
- Robert Marston & Associates, Inc. 1
- Stroock & Stroock & Lavan 1
- Promotional Concept Group, Inc. 1
- McCann Direct, Inc. 1
- BLJ Worldwide LTD 1
- Kobre & Kim LLP 1
- Marathon Strategies LLC 1
Registrant_Name 17
- Enterprise Ireland 3
- Marathon Strategies, LLC 3
- Daniel J. Edelman, Inc. 2
- Allen/Van Slyck Group 1
- BLJ Worldwide LTD 1
- EG&A International, Inc. 1
- IDA Ireland 1
- Kobre & Kim LLP 1
- Marathon Strategies LLC 1
- McCann Direct, Inc. 1
- McCann-Erickson, Inc. 1
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- Promotional Concept Group, Inc. 1
- Quebec Government Office 1
- Robert Marston & Associates, Inc. 1
- Stroock & Stroock & Lavan 1
- White & Case, LLP 1
State 1
- NY 22
City 1
- New York · 22 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6508 | 6508 | 1984-02-10 | 1983-08-10 | Rosenthal | Philip | Promotional Concept Group, Inc. 3383 | 1982-06-16 | Promotional Concept Group, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
9377 | 9377 | 1970-03-07 | 1962-11-28 | Klarnet | Philip | EG&A International, Inc. 1584 | 1962-11-28 | EG&A International, Inc. | 485 Madison Avenue | New York | NY | 10022 | |
9542 | 9542 | 2021-03-09 | 2019-07-30 | Singer | Philip | Marathon Strategies, LLC 6289 | 2015-04-16 | Marathon Strategies, LLC | 38 East 29th Street | New York | NY | 10016 | |
12096 | 12096 | 2011-03-31 | 2008-10-28 | Elwood | Philip | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | 1359 Broadway | Suite 1102 | New York | NY | 10018 |
13037 | 13037 | 1993-04-09 | 1988-05-03 | Corish | Philip | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
13624 | 13624 | 1985-04-17 | 1981-05-13 | Dorf | Philip | Robert Marston & Associates, Inc. 2834 | 1977-10-12 | Robert Marston & Associates, Inc. | 485 Madison Avenue | New York | NY | 10022 | |
14033 | 14033 | 1984-04-24 | 1982-10-21 | Sunshine | Philip | Stroock & Stroock & Lavan 3005 | 1979-03-22 | Stroock & Stroock & Lavan | Seven Hanover Square | New York | NY | 10004 | |
14294 | 14294 | 2010-04-28 | 2010-04-19 | Watson | Philip | Enterprise Ireland 2518 | 1974-06-08 | Enterprise Ireland | Ireland House | 345 Park Avenue, 17th Floor | New York | NY | 10154-0037 |
14301 | 14301 | 2010-04-28 | 2009-06-30 | McHugh | Philip | Enterprise Ireland 2518 | 1974-06-08 | Enterprise Ireland | Ireland House | 345 Park Avenue, 17th Floor | New York | NY | 10154-0037 |
15965 | 15965 | 1974-05-09 | 1963-11-14 | Young | Philip | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
16545 | 16545 | 1971-05-17 | 1970-03-03 | Van Slyck | Philip | Allen/Van Slyck Group 2191 | 1970-03-03 | Allen/Van Slyck Group | 1041 Third Avenue | New York | NY | 10021 | |
24869 | 24869 | 1995-07-31 | 1995-03-31 | McGauran | Philip | Enterprise Ireland 2518 | 1974-06-08 | Enterprise Ireland | Ireland House | 345 Park Avenue, 17th Floor | New York | NY | 10154-0037 |
27365 | 27365 | 2015-08-24 | 2015-04-16 | Walotsky | Philip | Marathon Strategies, LLC 6289 | 2015-04-16 | Marathon Strategies, LLC | 38 East 29th Street | New York | NY | 10016 | |
28621 | 28621 | 2016-08-31 | 2014-08-28 | Duguay | Philip | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
31719 | 31719 | 2021-09-30 | 2021-08-25 | Singer | Philip | Marathon Strategies LLC 7000 | 2021-08-25 | Marathon Strategies LLC | 38 East 29th Street | 4th Floor | New York | NY | 10016 |
32000 | 32000 | 2006-10-01 | 2003-06-03 | Metais | Philip | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32823 | 32823 | 1969-10-15 | 1968-02-02 | Filhaber | Philip | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
34558 | 34558 | 2007-10-31 | 2008-01-30 | Walotsky | Philip | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
34566 | 34566 | 2007-10-31 | 2008-07-25 | Walotsky | Philip | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
34724 | 34724 | 2018-10-31 | 2018-10-31 | Singer | Philip | Kobre & Kim LLP 6604 | 2018-10-31 | Kobre & Kim LLP | 800 Third Avenue | New York | NY | 10022 | |
35372 | 35372 | 1995-11-07 | 1995-07-28 | Moore | Philip | McCann Direct, Inc. 3922 | 1986-12-29 | McCann Direct, Inc. | 750 Third Avenue | New York | NY | 10017 | |
35734 | 35734 | 2018-11-13 | 2015-04-16 | Singer | Philip | Marathon Strategies, LLC 6289 | 2015-04-16 | Marathon Strategies, LLC | 38 East 29th Street | New York | NY | 10016 |
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]) );