FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Short_Form_Last_Name = "Bernard"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 10
- Quebec Government Office 2
- Jamaica Progressive League, Inc. 1
- Warren Weil Public Relations 1
- Miele & Stone, Inc. 1
- Bradley, Rosen & Kaus Advertising, Inc. 1
- Squire Patton Boggs, LLP 1
- Cable & Wireless North America, Inc. 1
- Cassidy & Associates, Inc. 1
- Cable & Wireless, Inc. 1
- Fleishman-Hillard, Inc. 1
Registrant_Name 10
- Quebec Government Office 2
- Bradley, Rosen & Kaus Advertising, Inc. 1
- Cable & Wireless North America, Inc. 1
- Cable & Wireless, Inc. 1
- Cassidy & Associates, Inc. 1
- Fleishman-Hillard, Inc. 1
- Jamaica Progressive League, Inc. 1
- Miele & Stone, Inc. 1
- Squire Patton Boggs, LLP 1
- Warren Weil Public Relations 1
City 5
- New York 5
- Vienna 2
- Washington 2
- Jamaica 1
- St. Louis 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5685 | 5685 | 1972-02-01 | 1971-04-01 | Bernard | Richard C. , Jr. | Warren Weil Public Relations 1530 | 1962-03-23 | Warren Weil Public Relations | 219 East 44th Street | New York | NY | 10017 | |
6035 | 6035 | 1966-02-03 | 1964-06-16 | Bernard | David S. | Bradley, Rosen & Kaus Advertising, Inc. 1761 | 1964-06-16 | Bradley, Rosen & Kaus Advertising, Inc. | 580 Fifth Avenue | New York | NY | ||
9214 | 9214 | 1964-03-06 | 1963-03-06 | Bernard | Allen | Miele & Stone, Inc. 1604 | 1963-03-06 | Miele & Stone, Inc. | 555 Fifth Avenue | Suite 1104 | New York | NY | |
15218 | 15218 | 2021-04-30 | 2021-01-30 | Bernard | Mikael | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
16960 | 16960 | 1994-05-23 | 1989-03-29 | Bernard | Keith E. | Cable & Wireless North America, Inc. 4231 | 1989-03-29 | Cable & Wireless North America, Inc. | 1919 Gallows Road | Vienna | VA | 22182 | |
21493 | 21493 | 2004-06-30 | 2001-02-02 | Bernard | Anne | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
24237 | 24237 | 2012-07-27 | 2008-04-15 | Bernard | Jean-Stephane | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
34365 | 34365 | 1995-10-31 | 1994-07-11 | Bernard | Keith E. | Cable & Wireless, Inc. 4945 | 1994-07-11 | Cable & Wireless, Inc. | 8219 Leesburg Pike | Vienna | VA | 22182 | |
36792 | 36792 | 1995-11-30 | 1994-09-21 | Bernard | Lynda | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | 700 - 13th Street, N.W. | Suite 400 | Washington | DC | 20005 |
39887 | 39887 | 1970-12-31 | 1965-09-24 | Bernard | Lucille | Jamaica Progressive League, Inc. 296 | 1945-03-12 | Jamaica Progressive League, Inc. | 15905 Hillside Avenue | 2nd Floor | Jamaica | NY | 11432 |
41198 | 41198 | 2000-12-31 | 1999-10-19 | Bernard | Michelle D. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 |
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]) );