FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Short_Form_Termination_Date" is on date 1991-03-29
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Last_Name, Short_Form_First_Name
Short_Form_Date (date) 11 ✖
- 1990-05-24 2
- 1989-03-03 1
- 1989-04-10 1
- 1989-09-05 1
- 1989-12-18 1
- 1990-01-09 1
- 1990-07-16 1
- 1990-10-19 1
- 1990-12-11 1
- 1991-03-07 1
- 1991-03-19 1
Registration_Number 6
Registrant_Name 6
City 3
- Washington 7
- St. Louis 3
- New York 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11040 | 11040 | 1991-03-29 | 1990-01-09 | Ferretti | Christopher L. | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
11041 | 11041 | 1991-03-29 | 1989-03-03 | Tagliarino | Scott A. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
11042 | 11042 | 1991-03-29 | 1991-03-07 | Pardo | Francesca | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
11043 | 11043 | 1991-03-29 | 1991-03-19 | Cotton | Lesley | 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 |
11044 | 11044 | 1991-03-29 | 1989-04-10 | Richman | Susan Tisherman | van Kloberg & Associates, Ltd. 3466 | 1983-05-09 | van Kloberg & Associates, Ltd. | 1129 - 20th Street, N.W. | Suite 400 | Washington | DC | 20036 |
11045 | 11045 | 1991-03-29 | 1990-05-24 | Berman | Julie E. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
11046 | 11046 | 1991-03-29 | 1990-05-24 | Graham | Melissa | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
11047 | 11047 | 1991-03-29 | 1990-07-16 | Ducker | Carolyn | Paul, Hastings, Janofsky & Walker 3763 | 1985-12-16 | Paul, Hastings, Janofsky & Walker | 1050 Connecticut Avenue, N.W. | Suite 1200 | Washington | DC | 20036 |
11048 | 11048 | 1991-03-29 | 1989-09-05 | Moriber | Jeffrey | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
11049 | 11049 | 1991-03-29 | 1990-10-19 | Rowland | Carol A. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
11050 | 11050 | 1991-03-29 | 1990-12-11 | Sarris | Thomas Gregory | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
11051 | 11051 | 1991-03-29 | 1989-12-18 | Berman | Julie E. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
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]) );