FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where City = "New York" and Short_Form_First_Name = "Sandra"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 12
- Ruder Finn, Inc. 1
- Grenada Board of Tourism 1
- Enterprise Ireland 1
- Dancer Fitzgerald Sample, Inc. 1
- Serko & Simon 1
- Saatchi & Saatchi North America, Inc. 1
- Daniel J. Edelman, Inc. 1
- Brown & Powers Associates, Inc. 1
- M. Booth & Associates, Inc. 1
- Quinn & Co. of NY LTD. 1
- Quinn & Co. of NY LTD. 1
- Park Strategies, LLC 1
Registrant_Name 11
State 1
- NY 12
City 1
- New York · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3646 | 3646 | 1978-01-13 | 1977-07-13 | Liss | Sandra | Serko & Simon 2811 | 1977-07-13 | Serko & Simon | 401 Broadway | New York | NY | 10013 | |
4293 | 4293 | 2018-01-22 | 2017-11-09 | Sokolin | Sandra | Park Strategies, LLC 6488 | 2017-11-09 | Park Strategies, LLC | 101 Park Avenue | Suite 2506 | New York | NY | 10178 |
7882 | 7882 | 1977-02-28 | 1974-11-14 | Protain | Sandra | Grenada Board of Tourism 2378 | 1972-09-10 | Grenada Board of Tourism | 317 Madison Avenue | Suite 1522 | New York | NY | 10017 |
14778 | 14778 | 1998-04-30 | 1985-09-03 | Stahl | Sandra | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
17232 | 17232 | 1994-05-27 | 1991-04-16 | Powers | Sandra | Brown & Powers Associates, Inc. 4500 | 1991-04-16 | Brown & Powers Associates, Inc. | 235 East 45th Street | 11th Floor | New York | NY | 10017 |
27329 | 27329 | 1988-08-24 | 1986-02-20 | Diana | Sandra | 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 |
37096 | 37096 | 2017-11-30 | 2017-10-11 | Hurtado | Sandra | Quinn & Co. of NY LTD. 6433 | 2017-05-24 | Quinn & Co. of NY LTD. | 48 W 38th Street, 12th Floor | New York | NY | 10018 | |
37325 | 37325 | 1978-12-01 | 1974-10-09 | Robertson | Sandra | Dancer Fitzgerald Sample, Inc. 2539 | 1974-10-09 | Dancer Fitzgerald Sample, Inc. | 347 Madison Avenue | New York | NY | 10017 | |
38661 | 38661 | 2000-12-18 | 1992-10-09 | Saias | Sandra | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
39409 | 39409 | 1992-12-30 | 1991-08-21 | Silverman | Sandra | M. Booth & Associates, Inc. 4557 | 1991-08-21 | M. Booth & Associates, Inc. | 470 Park Avenue South | New York | NY | 10016 | |
41667 | 41667 | 2009-12-31 | 2009-06-30 | O'Farrell | Sandra | Enterprise Ireland 2518 | 1974-06-08 | Enterprise Ireland | Ireland House | 345 Park Avenue, 17th Floor | New York | NY | 10154-0037 |
42001 | 42001 | 2015-12-31 | 2015-04-21 | Hurtado | Sandra | Quinn & Co. of NY LTD. 6290 | 2015-04-21 | Quinn & Co. of NY LTD. | 48 West 38th Street 12th Floor | New York | NY | 10018 |
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]) );