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_First_Name = "Amy"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Registration_Date, Address_1, Address_2, Short_Form_Date (date)
Registration_Number 12
- Daniel J. Edelman, Inc. 5
- GCI Group, Inc. 4
- BerlinRosen Ltd. 2
- Chinese Information Service 1
- Bermuda Tourism Authority 1
- Kastor, Hilton, Chesley, Clifford & Atherton, Inc. 1
- JETRO, New York 1
- Saatchi & Saatchi North America, Inc. 1
- Arnold Worldwide/NY 1
- Finsbury, LLC 1
- RF Binder Partners Inc. 1
- NSW Government US Office Inc. 1
Registrant_Name 12
- Daniel J. Edelman, Inc. 5
- GCI Group, Inc. 4
- BerlinRosen Ltd. 2
- Arnold Worldwide/NY 1
- Bermuda Tourism Authority 1
- Chinese Information Service 1
- Finsbury, LLC 1
- JETRO, New York 1
- Kastor, Hilton, Chesley, Clifford & Atherton, Inc. 1
- NSW Government US Office Inc. 1
- RF Binder Partners Inc. 1
- Saatchi & Saatchi North America, Inc. 1
State 1
- NY 20
City 1
- New York · 20 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
750 | 750 | 2020-04-09 | Binder | Amy | RF Binder Partners Inc. 6814 | 2020-04-09 | RF Binder Partners Inc. | 950 Third Avenue | 7th Floor | New York | NY | 10022 | |
1552 | 1552 | 2023-07-31 | Moynihan | Amy | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 | |
2346 | 2346 | 2021-12-03 | Rowland | Amy | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
5281 | 5281 | 2003-01-31 | 2002-06-05 | Serrano | Amy | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
8829 | 8829 | 2002-03-01 | 2001-08-10 | Jacksic | Amy | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11920 | 11920 | 2004-03-31 | 2003-02-25 | Shields | Amy | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
15094 | 15094 | 2017-04-30 | 2015-06-02 | Schultz | Amy | Finsbury, LLC 6293 | 2015-05-12 | Finsbury, LLC | 3 Columbus Circle, Floor 9 | New York | NY | 10019 | |
19309 | 19309 | 2004-06-12 | 2003-08-08 | Rinaldi | Amy | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
19900 | 19900 | 1963-06-20 | 1961-06-26 | Plager | Amy | Kastor, Hilton, Chesley, Clifford & Atherton, Inc. 1460 | 1961-06-26 | Kastor, Hilton, Chesley, Clifford & Atherton, Inc. | 575 Lexington Avenue | New York | NY | ||
22211 | 22211 | 1991-07-01 | 1989-08-16 | Salzman | Amy | 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 |
30106 | 30106 | 2022-09-19 | 2022-07-22 | Brown | Amy | NSW Government US Office Inc. 7145 | 2022-07-22 | NSW Government US Office Inc. | 150 East 42nd Street 34th Floor | New York | NY | 10017 | |
30571 | 30571 | 2018-09-26 | 2018-05-15 | Chen | Amy | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30576 | 30576 | 2018-09-26 | 2018-07-20 | Lebowitz | Amy | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
31296 | 31296 | 2002-09-30 | 2003-05-27 | Bortz | Amy | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
36976 | 36976 | 2008-11-30 | 2008-01-28 | Sarno | Amy | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
38651 | 38651 | 2000-12-18 | 1995-05-12 | Simpson | Amy | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
38670 | 38670 | 2000-12-18 | 1997-10-17 | Oseland | Amy | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
38682 | 38682 | 2000-12-18 | 1993-10-25 | Bortz | Amy | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
40145 | 40145 | 1980-12-31 | 1973-06-12 | Chien | Amy | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
41178 | 41178 | 2000-12-31 | 1999-02-23 | Palladino | Amy | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
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]) );