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 = "Glover"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2250 | 2250 | 2012-11-29 | Glover | Robert C. | Commonwealth of Dominica Maritime Registry, Inc. 5334 | 1999-10-12 | Commonwealth of Dominica Maritime Registry, Inc. | 32 Washington Street | Fairhaven | MA | 02719 | ||
6734 | 6734 | 1991-02-13 | 1977-03-03 | Glover | Rose-Marie | Sontheimer Hazlett, Ltd. 1648 | 1963-07-19 | Sontheimer Hazlett, Ltd. | 275 Seventh Avenue | New York | NY | 100016788 | |
7030 | 7030 | 2020-02-15 | 2019-11-13 | Glover | Kelsey | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | 1299 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20004 |
14432 | 14432 | 1962-04-30 | 1952-12-08 | Glover | Charles Carroll , III | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
21469 | 21469 | 2003-06-30 | 2002-07-25 | Glover | Juleanna | Clark & Weinstock 5457 | 2001-09-10 | Clark & Weinstock | 601 13th Street, N.W. | Suite 410 South | Washington | DC | 20005 |
24284 | 24284 | 1952-07-28 | 1947-03-03 | Glover | Charles Carroll , III | Cox, Oscar S. 341 | 1946-01-28 | Cox, Oscar S. | 1210 - 18th Street, N.W. | Washington | DC | ||
25863 | 25863 | 1984-08-03 | 1984-07-30 | Glover | Michael E. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
29599 | 29599 | 2022-09-11 | 2022-07-11 | Glover | Juleanna | Ridgely Walsh LLC 7137 | 2022-07-11 | Ridgely Walsh LLC | 2146 Wyoming Avenue, NW | Washington | DC | 20008 | |
32290 | 32290 | 2019-10-04 | 2019-05-02 | Glover | Stephanie | Pagefield Global 6675 | 2019-05-02 | Pagefield Global | 5 Chancery Lane | London | |||
35625 | 35625 | 1999-11-11 | 1997-11-28 | Glover | Kelly | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
36957 | 36957 | 2006-11-30 | 2005-08-30 | Glover | Marjorie | Chadbourne & Parke, LLP 5685 | 2005-05-18 | Chadbourne & Parke, LLP | 1200 New Hampshire Avenue, NW | Suite 300 | 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]) );