FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
39 rows where Registration_Number = 3586 sorted by Foreign_Principal_Country
This data as json, CSV (advanced)
These facets timed out: Registrant_Name
Foreign_Principal_Name 10
Short_Form_Name 9 ✖
Document_Type 5
Foreign_Principal_Country 3
- - 26
- GREAT BRITAIN 10
- PANAMA 3
Link | rowid | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country ▼ | URL |
---|---|---|---|---|---|---|---|---|---|
46204 | 46204 | 1984-05-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Registration Statement | Available-FARA-Public-Office | |||
46300 | 46300 | 1985-05-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19850501-D0VYEZ01.pdf | |||
46393 | 46393 | 1986-05-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19860501-D0VYNR01.pdf | |||
46569 | 46569 | 1987-05-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19870501-D0VY3T01.pdf | |||
46696 | 46696 | 1988-05-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19880501-D0VYB401.pdf | |||
46846 | 46846 | 1989-05-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19890501-D0VZDL01.pdf | |||
47007 | 47007 | 1990-05-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19900501-D0VY7701.pdf | |||
47290 | 47290 | 1991-05-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19910501-D0WQPO01.pdf | |||
47749 | 47749 | 1992-05-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19920501-D0W15501.pdf | |||
50712 | 50712 | 1984-05-10 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Short-Form | DEBORAH KAY WILLIAMS | Available-FARA-Public-Office | ||
50713 | 50713 | 1984-05-10 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Short-Form | EDWARD R. HAMBERGER | Available-FARA-Public-Office | ||
50714 | 50714 | 1984-05-10 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Short-Form | GREGORY STUART KAUPP | Available-FARA-Public-Office | ||
50715 | 50715 | 1984-05-10 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Short-Form | JAMES W. GLASSEN | Available-FARA-Public-Office | ||
50716 | 50716 | 1984-05-10 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Short-Form | MARTIN G. HAMBERGER | Available-FARA-Public-Office | ||
50717 | 50717 | 1984-05-10 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Short-Form | ROBERT MICHAEL DIAMOND | Available-FARA-Public-Office | ||
50718 | 50718 | 1984-05-10 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Short-Form | ZEL E. LIPSEN | Available-FARA-Public-Office | ||
93327 | 93327 | 1989-09-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Amendment | https://efile.fara.gov/docs/3586-Amendment-19890901-D0VZDC01.pdf | |||
114713 | 114713 | 1984-11-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19841101-D0VYG101.pdf | |||
114820 | 114820 | 1985-11-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19851101-D0VYPE01.pdf | |||
114914 | 114914 | 1986-11-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19861101-D0VYMK01.pdf | |||
115125 | 115125 | 1988-11-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19881101-D0VZBT01.pdf | |||
115259 | 115259 | 1989-11-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19891101-D0VY9001.pdf | |||
115417 | 115417 | 1990-11-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19901101-D0VY5Y01.pdf | |||
115771 | 115771 | 1991-11-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19911101-D0W00001.pdf | |||
116189 | 116189 | 1992-11-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Supplemental Statement | https://efile.fara.gov/docs/3586-Supplemental-Statement-19921101-D0W25J01.pdf | |||
125414 | 125414 | 1984-12-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Short-Form | JAMIE L. WHITTEN | Available-FARA-Public-Office | ||
12696 | 12696 | 1992-02-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Exhibit AB | AEA TECHNOLOGY | GREAT BRITAIN | https://efile.fara.gov/docs/3586-Exhibit-AB-19920201-D0W07R01.pdf | |
59737 | 59737 | 1989-06-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Exhibit AB | ROLLS-ROYCE, INC. | GREAT BRITAIN | https://efile.fara.gov/docs/3586-Exhibit-AB-19890601-D0VYAD01.pdf | |
87151 | 87151 | 1988-08-12 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Exhibit AB | CHELLINGWORTH & SINGER, LTD. | GREAT BRITAIN | https://efile.fara.gov/docs/3586-Exhibit-AB-19880812-D0VYDJ01.pdf | |
87152 | 87152 | 1988-08-12 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Exhibit AB | COLEBRAND, LTD. | GREAT BRITAIN | https://efile.fara.gov/docs/3586-Exhibit-AB-19880812-D0VYEJ01.pdf | |
87153 | 87153 | 1988-08-12 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Exhibit AB | MINISTRY OF DEFENCE, UNITED KINGDOM | GREAT BRITAIN | https://efile.fara.gov/docs/3586-Exhibit-AB-19880812-D0VYDZ01.pdf | |
87154 | 87154 | 1988-08-12 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Exhibit AB | VICKERS SHIPBUILDING & ENGINEERING, LTD. | GREAT BRITAIN | https://efile.fara.gov/docs/3586-Exhibit-AB-19880812-D0VYCZ01.pdf | |
100274 | 100274 | 1987-09-25 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Exhibit AB | CHELLINGWORTH & SINGER, LTD. | GREAT BRITAIN | https://efile.fara.gov/docs/3586-Exhibit-AB-19870925-D0VY5I01.pdf | |
100275 | 100275 | 1987-09-25 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Exhibit AB | MINISTRY OF DEFENCE, UNITED KINGDOM | GREAT BRITAIN | https://efile.fara.gov/docs/3586-Exhibit-AB-19870925-D0VY4Y01.pdf | |
100277 | 100277 | 1987-09-25 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Exhibit AB | VICKERS SHIPBUILDING & ENGINEERING, LTD. | GREAT BRITAIN | https://efile.fara.gov/docs/3586-Exhibit-AB-19870925-D0VYLZ01.pdf | |
100278 | 100278 | 1987-09-25 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Exhibit AB | VOSPER THORNYCROFT (UNITED KINGDOM), LTD. | GREAT BRITAIN | https://efile.fara.gov/docs/3586-Exhibit-AB-19870925-D0VYKR01.pdf | |
46203 | 46203 | 1984-05-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Exhibit AB | SEA SERVICES, LTD. | PANAMA | https://efile.fara.gov/docs/3586-Exhibit-AB-19840501-D0VYHW01.pdf | |
100276 | 100276 | 1987-09-25 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Exhibit AB | REPUBLIC OF PANAMA | PANAMA | https://efile.fara.gov/docs/3586-Exhibit-AB-19870925-D0VYLJ01.pdf | |
125413 | 125413 | 1984-12-01 | LIPSEN, WHITTEN & DIAMOND | Lipsen, Whitten & Diamond 3586 | Exhibit AB | REPUBLIC OF PANAMA | PANAMA | https://efile.fara.gov/docs/3586-Exhibit-AB-19841201-D0VYHG01.pdf |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );