FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where City = "New York" and Short_Form_First_Name = "Linda"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Registration_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 14
- Daniel J. Edelman, Inc. 2
- German National Tourist Office 1
- Ruder Finn, Inc. 1
- JETRO, New York 1
- Grenada Board of Tourism 1
- Robert Marston & Associates, Inc. 1
- North American Precis Syndicate 1
- M. Silver Associates, Inc. 1
- Harshe-Rotman & Druck, Inc. 1
- Saatchi & Saatchi North America, Inc. 1
- Lou Hammond & Associates, Inc. 1
- Marston Webb & Associates, Inc. 1
- Young & Rubicam, New York 1
- VisitSweden 1
Registrant_Name 14
- Daniel J. Edelman, Inc. 2
- German National Tourist Office 1
- Grenada Board of Tourism 1
- Harshe-Rotman & Druck, Inc. 1
- JETRO, New York 1
- Lou Hammond & Associates, Inc. 1
- M. Silver Associates, Inc. 1
- Marston Webb & Associates, Inc. 1
- North American Precis Syndicate 1
- Robert Marston & Associates, Inc. 1
- Ruder Finn, Inc. 1
- Saatchi & Saatchi North America, Inc. 1
- VisitSweden 1
- Young & Rubicam, New York 1
State 1
- NY 15
City 1
- New York · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2607 | 2607 | 1982-01-01 | 1981-11-13 | Miller | Linda | Harshe-Rotman & Druck, Inc. 3292 | 1981-11-21 | Harshe-Rotman & Druck, Inc. | 300 East 44th Street | New York | NY | 10017 | |
2669 | 2669 | 1988-01-01 | 1986-10-10 | Daubson | Linda | 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 |
3143 | 3143 | 2022-01-03 | 2017-01-23 | Nuss | Linda | German National Tourist Office 616 | 1950-02-28 | German National Tourist Office | 1350 Broadway | Suite 440 | New York | NY | 10018 |
4053 | 4053 | 1994-01-18 | 1989-01-24 | Shah | Linda | Marston Webb & Associates, Inc. 4209 | 1989-01-24 | Marston Webb & Associates, Inc. | 60 Madison Avenue | Suite 1101 | New York | NY | 10010 |
5484 | 5484 | 2013-01-31 | 2002-12-24 | Ayares | Linda | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | 747 Third Avenue, 23rd Floor | New York | NY | 10017-2803 | |
13055 | 13055 | 2008-04-09 | 2004-02-09 | Ericson | Linda | VisitSweden 4885 | 1994-01-26 | VisitSweden | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
13628 | 13628 | 1985-04-17 | 1977-10-12 | Lipman | Linda | Robert Marston & Associates, Inc. 2834 | 1977-10-12 | Robert Marston & Associates, Inc. | 485 Madison Avenue | New York | NY | 10022 | |
15636 | 15636 | 1994-05-03 | 1991-06-18 | Ogilvie | Linda | Grenada Board of Tourism 2378 | 1972-09-10 | Grenada Board of Tourism | 317 Madison Avenue | Suite 1522 | New York | NY | 10017 |
15972 | 15972 | 1989-05-09 | 1985-04-18 | Hanan | Linda | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | 201 East 42nd Street | New York | NY | 10017 | |
26826 | 26826 | 1988-08-16 | 1980-06-20 | Prosser | Linda | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
31537 | 31537 | 2013-09-30 | 2013-04-25 | Ayares | Linda | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
32697 | 32697 | 1994-10-12 | 1992-06-09 | Carlson | Linda | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
33630 | 33630 | 1993-10-25 | 1991-04-18 | Saltzman | Linda | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
35847 | 35847 | 1987-11-15 | 1987-06-25 | Parseghian | Linda | Lou Hammond & Associates, Inc. 3682 | 1985-05-23 | Lou Hammond & Associates, Inc. | 39 East 51st Street | New York | NY | 10022-5901 | |
38817 | 38817 | 1993-12-20 | 1991-08-06 | Conroy | Linda | Young & Rubicam, New York 4554 | 1991-08-06 | Young & Rubicam, New York | 285 Madison Avenue | New York | NY | 100176486 |
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]) );