FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where City = "New York" and Short_Form_First_Name = "John A."
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 17
- John A. Cairns & Company, Inc. 1
- John A. Clements Associates 1
- Jamaica Tourist Board, New York 1
- Needham, Harper & Steers Advertising, Inc. 1
- Chirurg & Cairns, Inc. 1
- Atwater Bradley Company, Inc. 1
- Government of Ontario, Canada 1
- Loeb, Rhoades & Company 1
- Rogers & Wells 1
- White & Case, LLP 1
- Ogilvie, Taylor & Associates, Inc. 1
- Shea & Gould 1
- Ogilvie, Taylor & Associates, Inc. 1
- Saatchi & Saatchi North America, Inc. 1
- Daniel J. Edelman, Inc. 1
- GCI Group, Inc. 1
- Coalition for a Democratic Haiti 1
Registrant_Name 16
- Ogilvie, Taylor & Associates, Inc. 2
- Atwater Bradley Company, Inc. 1
- Chirurg & Cairns, Inc. 1
- Coalition for a Democratic Haiti 1
- Daniel J. Edelman, Inc. 1
- GCI Group, Inc. 1
- Government of Ontario, Canada 1
- Jamaica Tourist Board, New York 1
- John A. Cairns & Company, Inc. 1
- John A. Clements Associates 1
- Loeb, Rhoades & Company 1
- Needham, Harper & Steers Advertising, Inc. 1
- Rogers & Wells 1
- Saatchi & Saatchi North America, Inc. 1
- Shea & Gould 1
- White & Case, LLP 1
State 1
- NY 17
City 1
- New York · 17 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7503 | 7503 | 1975-02-24 | 1974-07-24 | Sommers | John A. | Loeb, Rhoades & Company 2527 | 1974-07-24 | Loeb, Rhoades & Company | 42 Wall Street | New York | NY | 10005 | |
7595 | 7595 | 1979-02-25 | 1975-08-04 | Wells | John A. | Rogers & Wells 2598 | 1975-08-04 | Rogers & Wells | 200 Park Avenue | New York | NY | 10017 | |
7635 | 7635 | 1993-02-25 | 1990-08-03 | McCook | John A. | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
9708 | 9708 | 1985-03-12 | 1980-05-13 | Ogilvie | John A. | Ogilvie, Taylor & Associates, Inc. 3105 | 1980-05-13 | Ogilvie, Taylor & Associates, Inc. | C/O Daniel J. Edelman, Inc. | 1775 Broadway | New York | NY | 10019 |
9906 | 9906 | 1970-03-15 | 1965-09-15 | Bradley | John A. | Atwater Bradley Company, Inc. 1925 | 1965-09-15 | Atwater Bradley Company, Inc. | C/O J.A. Bradley | 525 Park Avenue | New York | NY | 10021 |
17819 | 17819 | 1995-05-31 | 1984-07-24 | Sullivan | John A. | 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 |
19562 | 19562 | 1990-06-15 | 1985-10-09 | Yost | John A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
20493 | 20493 | 1955-06-29 | 1955-02-07 | Clements | John A. | John A. Clements Associates 872 | 1955-02-07 | John A. Clements Associates | 959 Eighth Avenue | New York | NY | ||
20954 | 20954 | 1980-06-30 | 1979-04-27 | Gellatly | John A. | Needham, Harper & Steers Advertising, Inc. 1748 | 1964-06-03 | Needham, Harper & Steers Advertising, Inc. | 909 Third Avenue | New York | NY | 10022 | |
24168 | 24168 | 1979-07-27 | 1978-04-04 | Ogilvie | John A. | Ogilvie, Taylor & Associates, Inc. 2880 | 1978-04-04 | Ogilvie, Taylor & Associates, Inc. | 111 Broadway | New York | NY | 10006 | |
29676 | 29676 | 1989-09-13 | 1987-07-02 | Harras | John A. | Coalition for a Democratic Haiti 4007 | 1987-07-02 | Coalition for a Democratic Haiti | 62 Hicks Street | Apartment #2 | New York | NY | 11201 |
32849 | 32849 | 1979-10-15 | 1978-12-22 | Craig | John A. | Shea & Gould 2986 | 1978-12-22 | Shea & Gould | 330 Madison Avenue | New York | NY | 10017 | |
33446 | 33446 | 1946-10-23 | 1946-04-23 | Cairns | John A. | John A. Cairns & Company, Inc. 354 | 1946-04-23 | John A. Cairns & Company, Inc. | 45 East 17th Street | New York | NY | ||
33788 | 33788 | 1993-10-28 | 1991-11-12 | Smith | John A. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
36210 | 36210 | 1985-11-22 | 1985-03-12 | Ogilvie | John A. | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
36339 | 36339 | 1964-11-25 | 1964-11-25 | Cairns | John A. | Chirurg & Cairns, Inc. 1822 | 1964-11-25 | Chirurg & Cairns, Inc. | 130 East 59th Street | New York | NY | 10022 | |
40064 | 40064 | 1978-12-31 | 1977-02-14 | Alexander | John A. | Jamaica Tourist Board, New York 1445 | 1961-05-03 | Jamaica Tourist Board, New York | 767 Third Avenue | 2nd Floor, Suite 2127 | 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]) );