FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Short_Form_First_Name = "Valerie"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 12
- Swiss Overseas Company, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Saatchi & Saatchi North America, Inc. 1
- Fleishman-Hillard, Inc. 1
- IPG DXTRA, Inc 1
- Dilenschneider Group 1
- Levick Strategic Communications 1
- Ogilvy Public Relations Worldwide 1
- BLJ Worldwide LTD 1
- AB&C Philadelphia, LLC 1
- Roth, Susan 1
- Ogilvy Group LLC 1
Registrant_Name 12
- AB&C Philadelphia, LLC 1
- BLJ Worldwide LTD 1
- Dilenschneider Group 1
- Fleishman-Hillard, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- IPG DXTRA, Inc 1
- Levick Strategic Communications 1
- Ogilvy Group LLC 1
- Ogilvy Public Relations Worldwide 1
- Roth, Susan 1
- Saatchi & Saatchi North America, Inc. 1
- Swiss Overseas Company, Inc. 1
City 5
- New York 6
- Washington 3
- Philadelphia 1
- Rockville 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
502 | 502 | 2020-03-04 | Vardaro | Valerie | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
19946 | 19946 | 2014-06-20 | 2013-12-12 | Gentieu | Valerie | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
21778 | 21778 | 2013-06-30 | 2012-06-29 | Vento | Valerie | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
22269 | 22269 | 1997-07-01 | 1997-06-27 | Lucznikowska | Valerie | Dilenschneider Group 5188 | 1997-06-27 | Dilenschneider Group | 200 Park Avenue | 26th Floor | New York | NY | 10166 |
22489 | 22489 | 2010-07-02 | 2008-12-03 | Elston | Valerie | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | 1900 M Street, N.W. | Suite 400 | Washington | DC | 20036 |
26026 | 26026 | 2004-08-05 | 2000-09-01 | Cashour | Valerie | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
27455 | 27455 | 1953-08-26 | 1953-08-26 | Josefsberg | Valerie | Swiss Overseas Company, Inc. 789 | 1953-08-26 | Swiss Overseas Company, Inc. | 249 West 34th Street | New York | NY | ||
27722 | 27722 | 2013-08-29 | 2010-08-03 | Karr | Valerie | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | 1359 Broadway | Suite 1102 | New York | NY | 10018 |
32770 | 32770 | 1988-10-14 | 1984-07-24 | Vanderhoof | Valerie | 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 |
38040 | 38040 | 1993-12-10 | 1992-07-01 | Winslow | Valerie | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
41829 | 41829 | 2012-12-31 | 2010-07-30 | Edmonds | Valerie | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
42010 | 42010 | 2015-12-31 | 2013-11-01 | Holford | Valerie | Roth, Susan 6154 | 2013-02-10 | Roth, Susan | 10401 Grosvenor Place | #1126 | Rockville | MD | 20852 |
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]) );