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 = "Steele"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 10
- Steele, Donald Dickinson 2
- Netherlands Chamber of Commerce in the U.S. 1
- Jamaica Tourist Board, New York 1
- Surrey & Morse 1
- Young & Rubicam, L.P. 1
- Jamaica Tourist Board, Los Angeles 1
- Saatchi & Saatchi North America, Inc. 1
- Daniel J. Edelman, Inc. 1
- J&D International Consulting Services, LLC 1
- US FED Group 1
Registrant_Name 10
- Steele, Donald Dickinson 2
- Daniel J. Edelman, Inc. 1
- J&D International Consulting Services, LLC 1
- Jamaica Tourist Board, Los Angeles 1
- Jamaica Tourist Board, New York 1
- Netherlands Chamber of Commerce in the U.S. 1
- Saatchi & Saatchi North America, Inc. 1
- Surrey & Morse 1
- US FED Group 1
- Young & Rubicam, L.P. 1
City 5
- New York 4
- Los Angeles 2
- San Francisco 2
- Washington 2
- Houston 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7752 | 7752 | 1952-02-27 | 1950-08-22 | Steele | Harold Joseph | Netherlands Chamber of Commerce in the U.S. 639 | 1950-08-22 | Netherlands Chamber of Commerce in the U.S. | 350 South Figueroa Street | Suite 901 | Los Angeles | CA | 90017 |
7930 | 7930 | 1987-02-28 | 1987-01-12 | Steele | L. Marika | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
14542 | 14542 | 1984-04-30 | 1984-04-18 | Steele | Michael S. | Surrey & Morse 2649 | 1976-01-05 | Surrey & Morse | 1250 I Street, N.W. | Washington | DC | 20005 | |
17845 | 17845 | 1995-05-31 | 1991-08-23 | Steele | Audrey | 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 |
19917 | 19917 | 1981-06-20 | 1967-07-18 | Steele | Donald D. | Steele, Donald Dickinson 2030 | 1967-06-20 | Steele, Donald Dickinson | 703 Market Street | Suite 1305 | San Francisco | CA | 94103 |
19918 | 19918 | 1981-06-20 | 1967-07-18 | Steele | Evelyn Jane | Steele, Donald Dickinson 2030 | 1967-06-20 | Steele, Donald Dickinson | 703 Market Street | Suite 1305 | San Francisco | CA | 94103 |
25108 | 25108 | 2007-07-31 | 2005-07-01 | Steele | James J. | J&D International Consulting Services, LLC 5692 | 2005-07-01 | J&D International Consulting Services, LLC | 2200 Post Oak Boulevard | Suite 310 | Houston | TX | 77056 |
29368 | 29368 | 2012-09-07 | 2011-10-05 | Steele | Michael S. | US FED Group 6040 | 2011-05-19 | US FED Group | 1375 Fairmont Street, NW | APT 40 | Washington | DC | 20009-6949 |
36502 | 36502 | 1973-11-28 | 1961-05-03 | Steele | Mary Anne | 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 |
37350 | 37350 | 1981-12-01 | 1981-11-18 | Steele | Mary Ann | Jamaica Tourist Board, Los Angeles 3305 | 1981-11-18 | Jamaica Tourist Board, Los Angeles | 8703 La Tijera Boulevard | Suite 208 | Los Angeles | CA | 90010 |
38681 | 38681 | 2000-12-18 | 1996-10-23 | Steele | Allan McCrea | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 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]) );