FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "New York" and Short_Form_First_Name = "Leslie"
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Zip, Short_Form_Date (date)
Registration_Number 11
- Goerl, Albert 1
- South African Tourism 1
- Needham, Harper & Steers Advertising, Inc. 1
- Barbados Investment & Development Corp. Barbados Tourism 1
- Bell & Stanton, Inc. 1
- Cayman Islands Department of Tourism 1
- Myers Communicounsel, Inc. 1
- Kanan, Corbin, Schupak & Aronow, Inc. 1
- Spring O'Brien & Company, Inc. 1
- BerlinRosen Ltd. 1
- 5W Public Relations, LLC 1
Registrant_Name 11
- 5W Public Relations, LLC 1
- Barbados Investment & Development Corp. Barbados Tourism 1
- Bell & Stanton, Inc. 1
- BerlinRosen Ltd. 1
- Cayman Islands Department of Tourism 1
- Goerl, Albert 1
- Kanan, Corbin, Schupak & Aronow, Inc. 1
- Myers Communicounsel, Inc. 1
- Needham, Harper & Steers Advertising, Inc. 1
- South African Tourism 1
- Spring O'Brien & Company, Inc. 1
State 1
- NY 11
City 1
- New York · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1006 | 1006 | 2022-05-12 | Bishop | Leslie | 5W Public Relations, LLC 7118 | 2022-05-12 | 5W Public Relations, LLC | 3 Park Avenue | 19th Floor | New York | NY | 10016 | |
12753 | 12753 | 1949-04-05 | 1949-02-16 | Geller | Leslie | Goerl, Albert 541 | 1948-10-05 | Goerl, Albert | 396 Second Avenue | New York | NY | ||
16570 | 16570 | 1973-05-17 | 1971-03-29 | Lieber | Leslie | Bell & Stanton, Inc. 2054 | 1967-10-06 | Bell & Stanton, Inc. | 909 Third Avenue | New York | NY | ||
18586 | 18586 | 2018-06-01 | 2018-03-07 | Patterson | Leslie | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
25821 | 25821 | 2018-08-02 | 2012-07-07 | Green | Leslie | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
26610 | 26610 | 1987-08-14 | 1986-05-23 | Greenberg | Leslie | Myers Communicounsel, Inc. 3836 | 1986-05-23 | Myers Communicounsel, Inc. | 11 Penn Plaza | New York | NY | 10001 | |
35714 | 35714 | 1990-11-13 | 1988-04-19 | Aronow | Leslie | Kanan, Corbin, Schupak & Aronow, Inc. 4128 | 1988-04-19 | Kanan, Corbin, Schupak & Aronow, Inc. | 820 Second Avenue | New York | NY | 10017 | |
37100 | 37100 | 2018-11-30 | 2016-01-15 | Gittens | Leslie | Barbados Investment & Development Corp. Barbados Tourism 1995 | 1966-11-30 | Barbados Investment & Development Corp. Barbados Tourism | 820 Second Avenue | 5th Floor | New York | NY | 10017 |
37599 | 37599 | 1974-12-02 | 1973-04-05 | Chamberlain | Leslie | Needham, Harper & Steers Advertising, Inc. 1748 | 1964-06-03 | Needham, Harper & Steers Advertising, Inc. | 909 Third Avenue | New York | NY | 10022 | |
39983 | 39983 | 1975-12-31 | 1974-07-27 | Gould | Leslie | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
41897 | 41897 | 2014-12-31 | 2013-01-28 | Knobloch | Leslie | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 20 W 22nd Street | Suite 906 | New York | NY | 10010 |
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]) );