FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Registration_Number = 3780 sorted by Short_Form_Date
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date (date), Registration_Date (date)
Short_Form_Termination_Date (date) 10 ✖
- 1993-03-17 2
- 2001-03-31 2
- 1987-06-30 1
- 1988-03-31 1
- 1989-01-11 1
- 1990-06-30 1
- 1991-04-23 1
- 1997-02-10 1
- 1998-05-04 1
- 1999-05-14 1
State 1
- NY 12
Registration_Number 1
- O'Leary Clarke & Partners, Inc. · 12 ✖
Registrant_Name 1
City 1
- New York 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11578 | 11578 | 1988-03-31 | 1986-02-20 | Lieberman | Marianne | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
11855 | 11855 | 2001-03-31 | 1986-02-20 | O'Leary | Alice | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
14001 | 14001 | 1991-04-23 | 1986-02-20 | Kaprielian | Walter | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
21069 | 21069 | 1987-06-30 | 1986-02-20 | Goren | Carol | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
3571 | 3571 | 1989-01-11 | 1987-02-02 | Ilijic | Mary J. | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
21139 | 21139 | 1990-06-30 | 1988-06-22 | Perrone | Michele | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
10153 | 10153 | 1993-03-17 | 1991-04-25 | Salerno | Barbara A. | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
10154 | 10154 | 1993-03-17 | 1991-04-25 | Smith | Rachel | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
6584 | 6584 | 1997-02-10 | 1996-03-18 | Arnold | Thomas B. | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
15712 | 15712 | 1998-05-04 | 1996-03-18 | Clarke | James | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
11857 | 11857 | 2001-03-31 | 1997-03-14 | Vale | Margaret | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
16335 | 16335 | 1999-05-14 | 1998-07-13 | Eisenoff | Marc | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
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]) );