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 = "William H."
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 15
- Selvage & Lee, Inc. 1
- Communications Counselors, Inc. 1
- Borger Associates 1
- Needham, Harper & Steers Advertising, Inc. 1
- Association Films, Inc. 1
- Shearman & Sterling 1
- Tromson Monroe Advertising, Inc. 1
- Dancer Fitzgerald Sample, Inc. 1
- Manning, Selvage & Lee, Inc. 1
- Burns, Jackson, Miller, Summit & Jacoby 1
- Hill & Knowlton, Inc. 1
- Young & Rubicam, L.P. 1
- Saatchi & Saatchi North America, Inc. 1
- William H. Douglass & Associates 1
- FTI Consulting (SC), Inc. 1
Registrant_Name 15
- Association Films, Inc. 1
- Borger Associates 1
- Burns, Jackson, Miller, Summit & Jacoby 1
- Communications Counselors, Inc. 1
- Dancer Fitzgerald Sample, Inc. 1
- FTI Consulting (SC), Inc. 1
- Hill & Knowlton, Inc. 1
- Manning, Selvage & Lee, Inc. 1
- Needham, Harper & Steers Advertising, Inc. 1
- Saatchi & Saatchi North America, Inc. 1
- Selvage & Lee, Inc. 1
- Shearman & Sterling 1
- Tromson Monroe Advertising, Inc. 1
- William H. Douglass & Associates 1
- Young & Rubicam, L.P. 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2558 | 2558 | 1972-01-01 | 1971-09-20 | Zuspan | William H. | Needham, Harper & Steers Advertising, Inc. 1748 | 1964-06-03 | Needham, Harper & Steers Advertising, Inc. | 909 Third Avenue | New York | NY | 10022 | |
3953 | 3953 | 1973-01-17 | 1966-05-20 | Jeffers | William H. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
9259 | 9259 | 2019-03-06 | 2018-01-29 | Cullo | William H. | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
11100 | 11100 | 1959-03-30 | 1958-10-03 | Borger | William H. | Borger Associates 1174 | 1958-10-03 | Borger Associates | 60 East 42nd Street | New York | NY | ||
11459 | 11459 | 1976-03-31 | 1975-09-12 | Pearsall | William H. | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
14509 | 14509 | 1976-04-30 | 1974-10-09 | Giles | William H. | Dancer Fitzgerald Sample, Inc. 2539 | 1974-10-09 | Dancer Fitzgerald Sample, Inc. | 347 Madison Avenue | New York | NY | 10017 | |
16022 | 16022 | 1992-05-10 | 1991-08-19 | Douglass | William H. | William H. Douglass & Associates 4555 | 1991-08-19 | William H. Douglass & Associates | 500 East 77th Street | New York | NY | 10021 | |
17851 | 17851 | 1995-05-31 | 1986-10-10 | Cochrane | William H. | 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 |
20638 | 20638 | 1951-06-30 | 1950-06-19 | Jack | William H. | Selvage & Lee, Inc. 628 | 1950-06-19 | Selvage & Lee, Inc. | 500 Fifth Avenue | New York | NY | ||
21061 | 21061 | 1986-06-30 | 1977-07-08 | Douglas | William H. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
25914 | 25914 | 1959-08-04 | 1958-03-28 | Bray | William H. | Communications Counselors, Inc. 996 | 1957-02-04 | Communications Counselors, Inc. | 750 Third Avenue | New York | NY | ||
28037 | 28037 | 1981-08-31 | 1973-08-14 | Shumway, Jr. | William H. | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | 347 Madison Avenue | New York | NY | 10017 | |
32200 | 32200 | 1978-10-03 | 1977-10-04 | Greilsheimer | William H. | Burns, Jackson, Miller, Summit & Jacoby 2718 | 1976-08-31 | Burns, Jackson, Miller, Summit & Jacoby | 445 Park Avenue | New York | NY | ||
34264 | 34264 | 1986-10-31 | 1974-09-05 | Freed | William H. | Tromson Monroe Advertising, Inc. 2403 | 1973-01-09 | Tromson Monroe Advertising, Inc. | 450 Park Avenue, South | New York | NY | 10016 | |
34887 | 34887 | 1983-11-01 | 1981-10-06 | Appelman | William H. | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 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]) );