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 = "Sarah"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 15
- Daniel J. Edelman, Inc. 2
- Instituto Argentino de Promocion del Intercambio 1
- Bennett Associates, Inc. 1
- Ruder Finn, Inc. 1
- Hong Kong Trade Development Council, Inc. 1
- Cayman Islands Department of Tourism 1
- IPG DXTRA, Inc 1
- Mediaedge: CIA, LLC 1
- Ketchum Inc. NY 1
- 42West, LLC 1
- HL Group Partners, LLC 1
- Havas Media Group USA LLC 1
- Teneo Strategy LLC 1
- Ogilvy Group LLC 1
- Ruder Finn, Inc. 1
Registrant_Name 14
- Daniel J. Edelman, Inc. 2
- Ruder Finn, Inc. 2
- 42West, LLC 1
- Bennett Associates, Inc. 1
- Cayman Islands Department of Tourism 1
- HL Group Partners, LLC 1
- Havas Media Group USA LLC 1
- Hong Kong Trade Development Council, Inc. 1
- IPG DXTRA, Inc 1
- Instituto Argentino de Promocion del Intercambio 1
- Ketchum Inc. NY 1
- Mediaedge: CIA, LLC 1
- Ogilvy Group LLC 1
- Teneo Strategy LLC 1
State 1
- NY 16
City 1
- New York · 16 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1419 | 1419 | 2022-07-18 | Jordan | Sarah | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
2939 | 2939 | 2016-01-01 | 2006-05-09 | Tyre | Sarah | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
3454 | 3454 | 2008-01-08 | 2007-02-27 | Rosenbaum | Sarah | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
4142 | 4142 | 1953-01-20 | 1947-09-23 | Irizarry | Sarah | Instituto Argentino de Promocion del Intercambio 489 | 1947-09-23 | Instituto Argentino de Promocion del Intercambio | 45 Rockefeller Plaza | Room 557 | New York | NY | |
12976 | 12976 | 2021-04-08 | 2021-03-10 | Simpson | Sarah | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | |
18584 | 18584 | 2017-06-01 | 2017-06-01 | Watson | Sarah | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
19110 | 19110 | 1991-06-09 | 1988-09-02 | Monks | Sarah | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
21724 | 21724 | 2013-06-30 | 2013-03-07 | Rothman | Sarah | 42West, LLC 6156 | 2013-03-07 | 42West, LLC | 220 West 42nd Street | 12th Floor | New York | NY | 10036 |
22750 | 22750 | 1969-07-08 | 1962-08-03 | Lydgate | Sarah | Bennett Associates, Inc. 1140 | 1958-05-08 | Bennett Associates, Inc. | 605 Third Avenue | New York | NY | 10016 | |
31547 | 31547 | 2013-09-30 | 2013-04-25 | Straub | Sarah | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
32690 | 32690 | 1994-10-12 | 1994-04-27 | Yarkoni | Sarah | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
35238 | 35238 | 2010-11-04 | 2013-07-26 | Payne | Sarah | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
37193 | 37193 | 2021-11-30 | 2021-07-30 | Stanley | Sarah | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | |
38675 | 38675 | 2000-12-18 | 1993-10-18 | Slaninka | Sarah | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
41479 | 41479 | 2005-12-31 | 2003-12-29 | Hammel | Sarah | Mediaedge: CIA, LLC 5605 | 2003-12-29 | Mediaedge: CIA, LLC | 825 Seventh Avenue | New York | NY | 10019 | |
41875 | 41875 | 2013-12-31 | 2013-08-07 | Mahaney | Sarah | HL Group Partners, LLC 6178 | 2013-08-07 | HL Group Partners, LLC | 853 Broadway | 18th Floor | New York | NY | 10003 |
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]) );