FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where City = "New York" and Short_Form_First_Name = "Bernard"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 24
- French Chamber of Commerce of the U.S., Inc. 2
- British Information Services 2
- Israel Information Services 2
- Bernard Preyer Company 1
- American Section of the Jewish Agency for Israel 1
- French National Railroads, New York 1
- Bernard Relin Associates 1
- Feltus, Randolph 1
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- New York Bureau of the Telegraph Agency of Russia (TASS) 1
- Mokotoff, Milton M. 1
- DDB Worldwide Communications Group, Inc. 1
- Bernard Relin & Associates, Inc. 1
- Lampert Agency, Inc. 1
- McCann-Erickson, Inc. 1
- IDA Ireland 1
- Management Formation, Inc. 1
- FCB New York 1
- Loeb, Rhoades & Company 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Hicks & Griest, Inc. 1
- Cove, Cooper & Lewis, Inc. 1
- T.J. Ross & Associates, Inc. 1
- Public Affairs Analysts, Inc. 1
Registrant_Name 24
- British Information Services 2
- French Chamber of Commerce of the U.S., Inc. 2
- Israel Information Services 2
- American Section of the Jewish Agency for Israel 1
- Bernard Preyer Company 1
- Bernard Relin & Associates, Inc. 1
- Bernard Relin Associates 1
- Cove, Cooper & Lewis, Inc. 1
- DDB Worldwide Communications Group, Inc. 1
- FCB New York 1
- Feltus, Randolph 1
- French National Railroads, New York 1
- Hicks & Griest, Inc. 1
- IDA Ireland 1
- Lampert Agency, Inc. 1
- Loeb, Rhoades & Company 1
- Management Formation, Inc. 1
- McCann-Erickson, Inc. 1
- Mokotoff, Milton M. 1
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- New York Bureau of the Telegraph Agency of Russia (TASS) 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Public Affairs Analysts, Inc. 1
- T.J. Ross & Associates, Inc. 1
State 1
- NY 27
City 1
- New York · 27 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3477 | 3477 | 1964-01-09 | 1956-06-18 | Rosenberg | Bernard | Israel Information Services 543 | 1948-10-12 | Israel Information Services | 11 East 70th Street | New York | NY | 10021 | |
3508 | 3508 | 1948-01-10 | 1947-06-09 | Freeman | Bernard | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | 1947-06-03 | New York Bureau of the Telegraph Agency of Russia (TASS) | 50 Rockefeller Plaza | New York | NY | 10020 | |
4252 | 4252 | 1982-01-22 | 1980-04-24 | Landou | Bernard | T.J. Ross & Associates, Inc. 3102 | 1980-04-24 | T.J. Ross & Associates, Inc. | 405 Lexington Avenue | New York | NY | 10017 | |
4434 | 4434 | 1990-01-25 | 1947-07-25 | Glemser | Bernard | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
6766 | 6766 | 1945-02-14 | 1943-03-18 | Preyer | Bernard | Bernard Preyer Company 96 | 1942-08-14 | Bernard Preyer Company | 17 John Street | New York | NY | ||
7498 | 7498 | 1975-02-24 | 1974-07-24 | Berger | Bernard | Loeb, Rhoades & Company 2527 | 1974-07-24 | Loeb, Rhoades & Company | 42 Wall Street | New York | NY | 10005 | |
9619 | 9619 | 1971-03-11 | 1964-08-28 | Zamichow | Bernard | Lampert Agency, Inc. 1739 | 1964-05-21 | Lampert Agency, Inc. | 770 Lexington Avenue | New York | NY | 10021 | |
9965 | 9965 | 1993-03-15 | 1991-03-19 | Cummings | Bernard | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 | 1974-08-12 | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. | 309 West 49th Street | Worldwide Plaza | New York | NY | 10019-7399 |
10027 | 10027 | 1963-03-16 | 1957-09-16 | Endelman | Bernard | DDB Worldwide Communications Group, Inc. 1066 | 1957-09-16 | DDB Worldwide Communications Group, Inc. | 437 Madison Avenue | New York | NY | 10022 | |
12711 | 12711 | 1954-04-04 | 1954-02-26 | Lewis | Bernard | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
13910 | 13910 | 1991-04-22 | 1989-05-31 | Cooper | Bernard | Cove, Cooper & Lewis, Inc. 3067 | 1979-11-06 | Cove, Cooper & Lewis, Inc. | 135 East 55th Street | New York | NY | 10022 | |
18321 | 18321 | 1956-06-01 | 1955-12-01 | Slutsky | Bernard | Mokotoff, Milton M. 922 | 1955-12-01 | Mokotoff, Milton M. | 39 Broadway | New York | NY | ||
20339 | 20339 | 1952-06-27 | 1946-05-27 | Relin | Bernard | Bernard Relin Associates 359 | 1946-05-27 | Bernard Relin Associates | 654 Madison Avenue | New York | NY | ||
22683 | 22683 | 1978-07-07 | 1974-11-18 | Lipsky | Bernard | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
22893 | 22893 | 1972-07-10 | 1969-01-30 | Seabrooks | Bernard | Management Formation, Inc. 2120 | 1969-01-30 | Management Formation, Inc. | 477 Madison Avenue | New York | NY | ||
30431 | 30431 | 1987-09-25 | 1960-05-17 | Hamstra | Bernard | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
30733 | 30733 | 1989-09-29 | 1985-03-12 | Shusman | Bernard | Public Affairs Analysts, Inc. 3558 | 1984-02-07 | Public Affairs Analysts, Inc. | 342 Madison Avenue | Suite 1512 | New York | NY | 10173 |
33912 | 33912 | 1971-10-29 | 1947-10-23 | Joseph | Bernard | American Section of the Jewish Agency for Israel 208 | 1943-09-14 | American Section of the Jewish Agency for Israel | 515 Park Avenue | New York | NY | 10022 | |
35612 | 35612 | 1959-11-11 | 1959-05-11 | Relin | Bernard | Bernard Relin & Associates, Inc. 1225 | 1959-05-11 | Bernard Relin & Associates, Inc. | 654 Madison Avenue | New York | NY | ||
36151 | 36151 | 1977-11-21 | 1976-01-28 | Zamichow | Bernard | Hicks & Griest, Inc. 2656 | 1976-01-28 | Hicks & Griest, Inc. | 220 East 42nd Street | New York | NY | 10017 | |
37589 | 37589 | 1966-12-02 | 1966-06-10 | Lubar | Bernard | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
37999 | 37999 | 1948-12-10 | 1948-10-12 | Zamichow | Bernard | Israel Information Services 543 | 1948-10-12 | Israel Information Services | 11 East 70th Street | New York | NY | 10021 | |
39149 | 39149 | 1949-12-27 | 1947-12-04 | LeRoy | Bernard | Feltus, Randolph 381 | 1946-10-16 | Feltus, Randolph | 128 East 56th Street | New York | NY | ||
39841 | 39841 | 1966-12-31 | 1949-09-12 | d'Escayrac | Bernard | French Chamber of Commerce of the U.S., Inc. 167 | 1943-01-01 | French Chamber of Commerce of the U.S., Inc. | 1350 Avenue of the Americas | New York | NY | 10019 | |
39845 | 39845 | 1966-12-31 | 1966-10-06 | Musnik | Bernard | French Chamber of Commerce of the U.S., Inc. 167 | 1943-01-01 | French Chamber of Commerce of the U.S., Inc. | 1350 Avenue of the Americas | New York | NY | 10019 | |
40246 | 40246 | 1983-12-31 | 1977-02-03 | Ussher | Bernard | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
40478 | 40478 | 1988-12-31 | 1987-04-23 | Frelat | Bernard | French National Railroads, New York 335 | 1945-12-26 | French National Railroads, New York | 610 Fifth Avenue | New York | NY | 10020 |
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]) );