FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Short_Form_Last_Name = "Douglas"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Termination_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
239 | 239 | 2006-01-30 | Douglas | Donna Willa-Mae | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 | |
4015 | 4015 | 1963-01-18 | 1952-11-21 | Douglas | John Woolman | Covington & Burling 523 | 1948-04-16 | Covington & Burling | 888 - 16th Street, N.W. | Washington | DC | 20006 | |
11091 | 11091 | 2013-03-29 | 2007-12-31 | Douglas | Tim | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
13644 | 13644 | 1995-04-17 | 1994-04-17 | Douglas | Richard | Guatemala FUNDESA Working Group 5007 | 1995-04-04 | Guatemala FUNDESA Working Group | 1050 Potomac Street, N.W. | Washington | DC | 20007 | |
21061 | 21061 | 1986-06-30 | 1977-07-08 | Douglas | William H. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
27062 | 27062 | 1996-08-20 | 1987-07-08 | Douglas | Richard W. | IPAC, Inc. 4008 | 1987-07-08 | IPAC, Inc. | 2101 Wilson Boulevard | Suite 1000 | Arlington | VA | 22201-3062 |
27684 | 27684 | 1972-08-29 | 1970-08-07 | Douglas | G.A. | Swedish-American Chamber of Commerce, Inc. 13 | 1942-07-06 | Swedish-American Chamber of Commerce, Inc. | 250 Park Avenue | New York | NY | 10017 | |
29175 | 29175 | 2008-09-04 | 2008-06-18 | Douglas | Caitlin | CLS Strategies 5774 | 2006-10-06 | CLS Strategies | 1850 M Street, NW | Suite 900 | Washington | DC | 20036 |
29550 | 29550 | 1943-09-11 | 1943-07-03 | Douglas | Anna | Redfield, Roy A. 200 | 1943-07-03 | Redfield, Roy A. | 919 Paulsen Building | Spokane | WA | 00000 | |
40252 | 40252 | 1983-12-31 | 1979-04-12 | Douglas | Dorrett A. | Jamaica Tourist Board, New York 1445 | 1961-05-03 | Jamaica Tourist Board, New York | 767 Third Avenue | 2nd Floor, Suite 2127 | New York | NY | 10017 |
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]) );