FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
24 rows where Short_Form_Last_Name = "Bernstein"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 21
- EMB, Ltd. 2
- McCann-Erickson, Inc. 2
- DLA Piper US LLP 2
- American Section of the Jewish Agency for Israel 1
- Spanish National Tourist Office, New York 1
- Palcor News Agency 1
- Israel Government Tourist Office 1
- Japan Economic Institute of America 1
- Atlanta Products Corporation 1
- Galland, Kharasch, Calkins & Short, P.C. 1
- Hank Meyer Associates, Inc. 1
- Peter Rothholz Associates, Inc. 1
- World Zionist Organization - American Section, Inc. 1
- Aaron D. Cushman & Associates, Inc. 1
- Galland, Kharasch, Morse & Garfinkle, P.C. 1
- Dyer, Ellis & Joseph, P.C. 1
- Pace Advertising 1
- APCO Worldwide, Inc. 1
- Bernstein Law Firm, PLLC 1
- Havas Media Group USA LLC 1
- Cleary Gottlieb Steen & Hamilton LLP 1
Registrant_Name 21
- DLA Piper US LLP 2
- EMB, Ltd. 2
- McCann-Erickson, Inc. 2
- APCO Worldwide, Inc. 1
- Aaron D. Cushman & Associates, Inc. 1
- American Section of the Jewish Agency for Israel 1
- Atlanta Products Corporation 1
- Bernstein Law Firm, PLLC 1
- Cleary Gottlieb Steen & Hamilton LLP 1
- Dyer, Ellis & Joseph, P.C. 1
- Galland, Kharasch, Calkins & Short, P.C. 1
- Galland, Kharasch, Morse & Garfinkle, P.C. 1
- Hank Meyer Associates, Inc. 1
- Havas Media Group USA LLC 1
- Israel Government Tourist Office 1
- Japan Economic Institute of America 1
- Pace Advertising 1
- Palcor News Agency 1
- Peter Rothholz Associates, Inc. 1
- Spanish National Tourist Office, New York 1
- World Zionist Organization - American Section, Inc. 1
City 4
- New York 12
- Washington 10
- Chicago 1
- Miami 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2540 | 2540 | 1967-01-01 | 1966-04-15 | Bernstein | Phyllis | Spanish National Tourist Office, New York 538 | 1948-09-14 | Spanish National Tourist Office, New York | 665 Fifth Avenue | New York | NY | 10022 | |
2835 | 2835 | 2005-01-01 | 2000-09-05 | Bernstein | Matthew C. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
3440 | 3440 | 1996-01-08 | 1995-09-28 | Bernstein | Lara M. | Dyer, Ellis & Joseph, P.C. 4121 | 1988-03-21 | Dyer, Ellis & Joseph, P.C. | 600 New Hampshire Avenue, N.W. | Suite 1000 | Washington | DC | 20037 |
6383 | 6383 | 1983-02-08 | 1973-05-10 | Bernstein | Arthur D. | Galland, Kharasch, Calkins & Short, P.C. 1051 | 1957-07-09 | Galland, Kharasch, Calkins & Short, P.C. | 1054 - 31st Street, N.W. | Washington | DC | 20007 | |
7663 | 7663 | 1960-02-26 | 1958-08-21 | Bernstein | Marcia Musicant | Japan Economic Institute of America 929 | 1956-01-25 | Japan Economic Institute of America | P.O.Box 65780 | Washington | DC | 20035-5780 | |
8190 | 8190 | 2005-02-28 | 1997-10-22 | Bernstein | Caryl S. | Bernstein Law Firm, PLLC 4764 | 1993-02-08 | Bernstein Law Firm, PLLC | 5335 Wisconsin Avenue, NW | Suite 440 | Washington | DC | 20015 |
8419 | 8419 | 2021-02-28 | 2006-12-08 | Bernstein | Matthew | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
9206 | 9206 | 1956-03-06 | 1956-03-06 | Bernstein | Abraham S. | Atlanta Products Corporation 932 | 1956-03-06 | Atlanta Products Corporation | 3-5 Harrison Street | New York | NY | ||
10794 | 10794 | 1984-03-26 | 1983-08-23 | Bernstein | Arthur D. | Galland, Kharasch, Morse & Garfinkle, P.C. 3513 | 1983-08-23 | Galland, Kharasch, Morse & Garfinkle, P.C. | 1054 - 31st Street, N.W. | 2nd Floor | Washington | DC | 20007 |
11350 | 11350 | 1959-03-31 | 1953-04-06 | Bernstein | Joseph Ilan | Israel Government Tourist Office 620 | 1950-03-27 | Israel Government Tourist Office | 350 Fifth Avenue | New York | NY | 10118 | |
13913 | 13913 | 1992-04-22 | 1991-12-13 | Bernstein | James S. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
13973 | 13973 | 1985-04-23 | 1983-12-15 | Bernstein | Todd W. | Hank Meyer Associates, Inc. 1161 | 1958-08-11 | Hank Meyer Associates, Inc. | 2990 Biscayne Boulevard | Miami | FL | 33137 | |
18275 | 18275 | 2023-05-31 | 2022-06-03 | Bernstein | Andrew A. | Cleary Gottlieb Steen & Hamilton LLP 6964 | 2021-05-25 | Cleary Gottlieb Steen & Hamilton LLP | One Liberty Plaza | New York | NY | 10006 | |
18622 | 18622 | 1965-06-02 | 1965-01-04 | Bernstein | Laurel Cutler | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
21090 | 21090 | 1988-06-30 | 1983-04-12 | Bernstein | Louis | World Zionist Organization - American Section, Inc. 2278 | 1971-09-21 | World Zionist Organization - American Section, Inc. | 633 Third Avenue | 21st Floor | New York | NY | 10017 |
23054 | 23054 | 1993-07-13 | 1991-05-03 | Bernstein | Deborah M. | Pace Advertising 4508 | 1991-05-03 | Pace Advertising | 485 Fifth Avenue | New York | NY | 10017 | |
26541 | 26541 | 1996-08-13 | 1995-12-26 | Bernstein | Jennifer P. | Aaron D. Cushman & Associates, Inc. 2572 | 1975-04-07 | Aaron D. Cushman & Associates, Inc. | 35 East Wacker Drive | Suite 850 | Chicago | IL | 60601 |
27953 | 27953 | 1977-08-31 | 1966-06-10 | Bernstein | Laurel Cutler | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
29792 | 29792 | 1962-09-15 | 1959-09-15 | Bernstein | Edith Lewis | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | 1329 - 18th Street, N.W. | Washington | DC | ||
29793 | 29793 | 1962-09-15 | 1959-09-15 | Bernstein | Edward Morris | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | 1329 - 18th Street, N.W. | Washington | DC | ||
32993 | 32993 | 1970-10-16 | 1964-09-24 | Bernstein | Richard Melville | Peter Rothholz Associates, Inc. 1692 | 1964-02-18 | Peter Rothholz Associates, Inc. | 369 Lexington Avenue | New York | NY | 10017 | |
33871 | 33871 | 1971-10-29 | 1949-03-28 | Bernstein | Victor H. | 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 | |
35965 | 35965 | 1949-11-17 | 1949-11-17 | Bernstein | Victor H. | Palcor News Agency 600 | 1949-11-17 | Palcor News Agency | 16 East 66th Street | New York | NY | ||
42210 | 42210 | 2018-12-31 | 2018-12-21 | Bernstein | Diana | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 |
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]) );