FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where City = "New York" and Short_Form_First_Name = "Steven"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 13
- Ruder Finn, Inc. 1
- Cayman Islands Department of Tourism 1
- Peter Martin Associates, Inc. 1
- Daniel J. Edelman, Inc. 1
- IPG DXTRA, Inc 1
- Shandwick North America, Inc. 1
- Rubenstein Associates, Inc. 1
- Zemi Communications, L.L.C. 1
- Zemi Communications, L.L.C. 1
- Spring O'Brien & Company, Inc. 1
- White & Case LLP 1
- Gladstone Place Partners LLC 1
- Rubenstein Associates, Inc. 1
Registrant_Name 11
- Rubenstein Associates, Inc. 2
- Zemi Communications, L.L.C. 2
- Cayman Islands Department of Tourism 1
- Daniel J. Edelman, Inc. 1
- Gladstone Place Partners LLC 1
- IPG DXTRA, Inc 1
- Peter Martin Associates, Inc. 1
- Ruder Finn, Inc. 1
- Shandwick North America, Inc. 1
- Spring O'Brien & Company, Inc. 1
- White & Case LLP 1
State 1
- NY 13
City 1
- New York · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
617 | 617 | 2023-03-21 | Rubenstein | Steven | Rubenstein Associates, Inc. 7247 | 2023-03-21 | Rubenstein Associates, Inc. | 825 Eighth Avenue | New York | NY | 10019 | ||
1182 | 1182 | 2022-06-01 | Otillar | Steven | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | 1221 Avenue of the Americas | New York | NY | 10036 | ||
3201 | 3201 | 2008-01-04 | 2008-04-22 | Field | Steven | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
5439 | 5439 | 2010-01-31 | 2008-10-10 | Lai | Steven | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 20 W 22nd Street | Suite 906 | New York | NY | 10010 |
7892 | 7892 | 1981-02-28 | 1980-06-20 | Feld | Steven | Peter Martin Associates, Inc. 2846 | 1977-11-15 | Peter Martin Associates, Inc. | 770 Lexington Avenue | New York | NY | 10021 | |
12507 | 12507 | 1998-04-01 | 1992-07-30 | Rosenbaum | Steven | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
17885 | 17885 | 1997-05-31 | 1997-02-25 | Curtis | Steven | Zemi Communications, L.L.C. 5120 | 1996-07-01 | Zemi Communications, L.L.C. | 99 Madison Avenue | 2nd Floor | New York | NY | 10016-7419 |
17984 | 17984 | 2005-05-31 | 1993-03-12 | Rubenstein | Steven | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | 1345 Avenue of the Americas | 30th Floor | New York | NY | 10105-0109 |
27718 | 27718 | 2008-08-29 | 2004-12-20 | Aiello | Steven | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
30692 | 30692 | 1999-09-28 | 1996-05-03 | Curtis | Steven | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
32643 | 32643 | 2018-10-11 | 2018-09-12 | Lipin | Steven | Gladstone Place Partners LLC 6591 | 2018-09-12 | Gladstone Place Partners LLC | 485 Madison Avenue, 4th Floor | New York | NY | 10022 | |
34481 | 34481 | 2003-10-31 | 2002-04-08 | Meeter | Steven | Zemi Communications, L.L.C. 5491 | 2002-04-08 | Zemi Communications, L.L.C. | 99 Madison Avenue | 2nd Floor | New York | NY | 10016 |
35333 | 35333 | 1991-11-06 | 1991-06-03 | Kravitz | Steven | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
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]) );